Nilesh Saratkar
Background
Mr. Nilesh is a
senior-level information technology professional with over five
years of complete system development cycle experience. He also
possesses an extensive data warehouse application analysis,
development, integration, testing, and production support
experience. He has worked extensively in ORACLE 7.0 and 8.0
Database, PL/SQL, Developer 2000, Pro*C, Systems prototyping in C
language and UNIX shell scripts. Mr. Nilesh recently has
contributor for Systemlog entry scheme, restart process design,
Data extraction and upload from Data Warehouse with Fuzzy match
logic. Mr. Nilesh also has design and development experience of
Sales, Purchase, Inventory, Account, Freight, Pharmacuiticals and
Distribution system.
TECHNICAL SKILLS
RDBMS
· ORACLE UNIX Server 7.0,8.0.
· Personnel ORACLE 7.2.
GUI
· Developer 2000.
· Borland C++ 4.5.
OPERATING SYSTEM
· AT&T, SCO and AIX UNIX.
· Windows NT, 95, 3.x.
TOOLS
· SCCS, sdb & dbx Debuger.
· PL/SQL, SQL Loader.
· Pro *C, C++.
HARDWARE
· IBM Compatibles.
EDUCATION
· B.S. Computer Technology.
WORK EXPERIENCE
1. Roche Pharmaceuticals.
NJ, Consultant. Mar 98 - Till Date.
The Roche Group is one of the world’s leading
research-based healthcare groups active in the discovery,
development and manufacture of pharmaceuticals and diagnostic
systems. As a team member of Core Master System Group, provide
data warehouse design and production support solutions for
Organization, Customer, Employee and Product data models. This
clinical application provides information to business groups and
consist of Oracle Database and various UNIX tools.
Responsibilities :
*Design data warehouse application to feed data by business rules
from various sources.
*Provide solution to restart failed process from point of failure
to save processing time.
*Manage data migration interfaces between Data warehouse and
various target systems.
*Data analysis solution for various production critical
situations and data validation.
*Test and Turnover the warehouse application into production
along with documentation.
2. Cendant Corp. CT, Senior
Consultant ( Oracle Corp. ) Dec 98 - Feb 99
The Promotion project provides the accurate and reliable data
from data warehouse with most flexibility. Based on current
statistics it provides information for future forecasting and
promotions. This is the customized product designed for Cendant
Corporation the world's premier marketer and provider of consumer
and business services for Real Estate, Travel, Alliance Marketing
and High Growth products. The major component of the project is
Oracle 8 Warehouse, PL/SQL scripts, UNIX scripts and extraction
tools.
Responsibilities :
*Designed and developed ETT
(extract, transport and transformations) modules for warehouse..
*Analysis of syslog entries for message routing in Unix shell
scripts.
*Designed PL/SQL procedures for data upload using JTSS tracing
and log system.
*Designed fuzzy match logic UNIX shell script for faster data
extraction.
*Analysis of user requirement and design specification generated
by Designer 2000.
3. VWR Scientific
Products. PA, Team leader May 98 - Nov 98
Evaluated Receipts Settlement (ERS) is the major component of VWR
Scientific Product Sales System, where the payment to a vendor
for goods is triggered by the receipt of those goods rather than
a invoice sent by the vendor. Along with ERS Summary billing and
Commissions is also being designed. System consists of Forms 4.5,
Reports 2.5, SQL/PLUS, SQL*Loader, Import and Export embedded
with UNIX shell scripts cron scheduler. The basic purpose of the
ERS is to automate creation of vendor invoices and credit notes.
Responsibilities :
*Analysis of Functional
specification to prepare Technical specification for every
module.
*Designed application using Reports 2.5, PL/SQL and UNIX shell
scripts.
*Designed Oracle test database schema, generate test data using
SQL *Loader and MS Excel.
*Extraction of summary bill and commissions from dimensional Data
Warehouse.
*Implementation of all project components in Production
environment.
*Atomization of Data loading process using shell script and SQL*
Loader.
4. P & O
Nedlloyd. NJ, Consultant Sep 97 - Apr 98
BDR is a repository for data downloaded from the DRS Core
'Branch' system. Which maintained by one of the leading shipping
organization. The basic purpose of BDR is to maintain various
component of system manifest, freight release, booking tracking,
vessel and container related information. The repository provides
the raw data necessary to develop reports, interfaces, file
extracts and input to ancillary systems.
Responsibilities :
*Designed and modified Pro *C
reports and Extract application for BDR System.
*Developed and integrate data entry modules for various component
of system.
*Designed UNIX scripts for job scheduling and data modification.
*Testing module in systest, usertrial and production database for
performance.
*Job tracing after invoked by BDR System with the help of
scheduler components.
5. Newlook Electronics.
System Consultant Dec 95 - Aug 97
Integrated system consisting
of inventory, purchase, sales, customer support and accounting
system for a sole distributor of refrigerator. Project takes care
of inventory at various warehouses, dealers, sales and financial
accounting tasks. Major components of project are Trial Balance,
Ledgers, Payment, Receipts and Customer service system.
Responsibilities :
*Designed various reports, screens and Pro *C application for
inventory system.
*Generation of user-exit using Pro *C for financial accounting
system.
*Managing stored procedures and integrity of data within the
database using PL/SQL.
*Modification and porting of data with the help of SQL *LOADER.
*Modification of corrupt data file during porting using PL/SQL, C
and UNIX utilities.
Contact Information
Sign My Guestbook View My Guestbook
This site is recently updated by Nilesh Saratkar.