NILESH SARATKAR

SUMMARY

  • Senior Data Warehouse and Data Quality Analyst with twelve years of life cycle development experience.
  • Expertise in Ascential ETL DataStage 7.5, Erwin Data Modeling, Oracle 9i, PL/SQL, UNIX and Korn shell.
  • Efficient in IBM/Ascential (Integrity/QualityStage) 6.0 (Real Time API), CASS (Postal Certification) 3.12.3.
  • Proficient in Project planning, Requirement analysis, Prototype design, Functional and Technical design.
  • Specialize in Customer Data Integration, Data Cleansing, Data Quality Analysis and Address Certification.
  • Extensive practice with Financial, Pharmaceutical, Telecom, Consulting, Freight and Distribution Systems.

SKILL

  • ASCENTIAL (4 Year):DataStage 7.5, Vality / QualityStage / Integrity Real Time API 6.0 and CASS.
  • ORACLE (6 Years):ORACLE 8i/9i, PL/SQL, SQL*Plus, SQL Loader and Developer 2000.
  • UNIX (5 Years):UNIX (AT&T, SUN, AIX, HP), Korn Shell Script, Autosys and Cron scheduler.
  • IBM (1 Year):DB2 UDB Database 7.0, IBM Web Sphere 5.0.
  • MODELING (2 Year):ErWin 3.5 (Model Mart), Visio 5.0 and SQL Navigator.
  • ANALYSIS (2 Years):Data Quality Analysis, Requirement Analysis and SDLC Documentation.
  • ETL D/W (4 Years):DataStage 7.5, Oracle 8i/9i, PL/SQL and Korn shell script.

EDUCATION

  • Bachelor of Science: Bachelor of Computer Science from University of Nagpur, 1994.
  • DataStage Training: DataStage XE 4.2 from Ascential Software, Boston, MA.

EXPERIENCE

1. AIG Inc. New York, NY (QA Automation Lead)Oct 2004 – Present

American International Group, Inc. (AIG) is the world's leading international insurance and financial services organization, which serves commercial, institutional and individual customers through worldwide property-casualty and life insurance networks of any insurer. The Enterprise Risk Management (ERM) encompasses risk management disciplines of Credit, Market, and Operational Risk Management Technology.

Environment: Data Stage 7.5, QualityStage 7.0, Oracle 9i/10g, PL/SQL, XML, SUN UNIX, Korn Shell scripts, Autosys scheduler, Compuware File-Aid, PVCS and Rational Clear Quest.

Responsibilities:

  • Prepare Automated QA test plans and build test data sets suitable for functional and regression testing.
  • Build prototype for Counterparty matching using QualityStage probabilistic matching and standardization.
  • Identify defectsand track them in Clear Quest and follow-up with the development team for resolution.
  • Prepare lay out for Sarbanes Oxley Compliance/Policy Web site and perform Sarbanes Oxley control testing.
  • Build Backend Automation application for QA Regression and functional testing using korn shell script.
  • Aid Release manager and Infrastructure group in code migration for QA, UAT and Production environment.
  • Define best practices for test cases maintenance and built process to convert test cases from flat files to XML.
  • Analyze DataStage job code in DataStage Designer and Director Logs to debug and identify potential defects.

2. Pfizer Pharmaceutical. New York, NY (Sr. IBM Consultant)Feb 2004 – Jun 2004.

Pfizer Inc discovers, develops, manufactures, and markets leading prescription medicines for humans and animals and many of the world's best-known consumer brands. The Information Architecture (IA) team dedicated to provide drug control for sample fulfillment.

Environment: The IA System architecture consists of DataStage 5.2, Oracle 8i, PL/SQL, SUN UNIX, Korn Shell scripts and Autosys scheduler.

Responsibilities:

  • Prepared project plan and resolve dependency to achieve concurrent task scheduling with limited resources.
  • Designed DataStage jobs to load vendor originated data files and integrated all jobs utilizing Autosys scheduler.
  • Prepared requirement and technical documentation along with strategic solution for the Data Model design.
  • Designed DataStage ETL jobs to send fulfillment request order and receive order status back from various sources.
  • Designed PL/SQL objects to translate historical data and perform DataStage job look-ups for incremental loads.

3. Southwest Bell Corp. St Louis, MO (Data Quality Lead)Jun 2003 – Dec 2003.

Southwest Bell Corporation is one of the world's leading data, voice and Internet services providers. SBC associates currently serving 57 million access lines nationwide. Constituent Management System (CIM) provides Batch and Real Time customer data integration services to enterprise wide systems.

Environment: CIM consists of Integrity / Vality / QualityStage Real Time 6.0 (Java API), DataStage 5.2, SUN UNIX, Web Sphere 5.0 and DB2 UDB 7.0.

Responsibilities:

  • Provided solution with Integrity real time API prototype to perform web enabled fuzzy customer search capability.
  • Designed Super Match procedure to enable fuzzy match on various customer name, address and area search criteria.
  • Designed batch customer matching procedure and set match cutoff weights suitable for customers matching engine.
  • Designed prototype and mentor EJB/Java resources to incorporate Real Time API components for Real Time search.
  • Perform Unit, Regression, Integration and Performance testing for any changes in the matching engine parameters.

4. ING Americas. Hartford, CT (Data Quality Lead)Feb 2003 – Apr 2003.

ING is a world-class leader in providing financial products and services to its customers, including life insurance, annuities, retirement plans, and mutual funds. The Enterprise Information Infrastructure (EII) serves as Operational Data Source and Customer Data Integration solutions for data originated from diversified systems.

Environment: EII architecture consists of Vality Integrity Real Time 6.0, CASS Postal Verification 3.0, HP UNIX 11, DB2 UDB 7.0, and Informatica 6.0.

Responsibilities:

  • Performed data quality analysis and provided solution for customer Name, Address, Area and SSN Standardization.
  • Provided Address data cleansing and enrichment solutions utilizing with Integrity CASS (Postal Certification).
  • Resolved un-handled data and pattern issues with the help of new business rules and user pattern overrides.
  • Consolidated and integrated customer data with the help of Integrity/Vality/QualityStage Matching and Survivorship.
  • Supplemented business community with the Meta data handshake between Data Cleansing and ETL architecture.
  • Resolve dependency and Integrated all Data Integration and ETL components using UNIX Korn Shell scripts.

5. McKinsey & Company. New York, NY (Sr. DW Consultant)May 2002 – Jan 2003.

McKinsey & Company is a provider of management and technology consulting services and solutions, which help global clients, capitalize on their most important business and technology opportunities. The purpose of SAIL Data Warehouse is to provide Consultancy business facts and information from Financial, Know Portal Log, Compensation and Semi Annual Review subject areas.

Environment:The SAIL infrastructure consists of Ascential DataStage 4.2/6.0, Meta Stage, Oracle 8i, PL/SQL, Sun Solaris UNIX, and Erwin 3.5 (Model Mart).

Responsibilities:

  • Developed Data Stage ETL jobs and Batches to support Star Schema type I and type II dimensions loads.
  • Designed Data Stage ETL jobs to calculate engagement facts data for different level of summary grain.
  • Modified ETL logic from Data Stage jobs to the Erwin Data Models, which further utilized by Meta Stage.
  • Utilized XML, Pivot, Aggregator, Folder, Pipe and Stage variables to provide best possible ETL solution.
  • Performed QA regression testing by minus operation between Source / Target for code migration on DataStage 6.0.
  • Designed PL/SQL functions to calculate complex financial facts information from Data Warehouse staging data.

6. Wyeth Pharmaceuticals. Radnor, PA (Data Quality Consultant)Feb 2002 – May 2002.

Wyeth is a research-based, global pharmaceutical company responsible for the discovery and development of some of today's most innovative medicines. Goal of the Integrated Customer View (ICV) is to provide clean consolidated customer data from the various systems. ICV also customized for Real Time and Batch mode of operations. Utilized Vality predefined procedures for standardization and customer matching (Name, Address, Area/Zip Code, and Source Identifier).

Environment: The ICV utilizes Oracle 8i, UNIX Sun Solaris, Vality 3.11 (Integrity / QualityStage) and Informatica 5.1.

Responsibilities:

  • Designed Integrity procedures to standardize and perform user override for unhanded and input patterns.
  • Performed Candidate row selection from source data based up on the blocking fields for all matching blocks.
  • Generated Integrity Exact Location matching and Customer Probabilistic matching with multiple passes.
  • Designed new Rule Sets using Pattern Action language to standardize/parse Phone, Fax and Birth Date.
  • Developed generic shell scripts to invoke Integrity and Informatica components in parallel and sequential operation.
  • Provided DQA report and Proof of Concept during the design phase of ICV architecture to the business community.

7. Gartner Group. Stamford, CT, (Sr. Consultant)Sep 2001 – Dec 2001

Gartner Group the leading business analysis, research and measurement firm actively providing consultancy services at various locations all over the world. Gartner’s Gems and Order Entry Data Warehouse designed to fulfill user’s analytical requirements and integrate engagement information from multiple sources.

Environment:The OE/Gems Data Warehouse consists of Oracle 8i, SUN UNIX (Solaris 8), Ascential DataStage 4.1 ETL jobs and Brio financial and analytical reports for the users.

Responsibilities:

  • Designed and developed DataStage Dimension jobs for the Type-I and Type-II ETL Update strategy.
  • Prepare the job dependency sequences list in the DataStage batch ini file for all fact and dimension jobs.
  • Provided Hierarchical solution for Department data structure to match with the roll up/down mechanism.
  • Design PL/SQL functions to resolve complex business facts metrics transformation at the staging database.
  • Design DataStage fact jobs to convert weekly summarization grain to the monthly grain for further integration.
  • Designed restart and rerun mechanism to load Operational Data Store information using Gartner fiscal calendar.

8. Roche Pharmaceutical. Nutley, NJ, (Consultant)Mar 1999 – Jul 2001

The Roche Group is one of the world’s leading research-based healthcare groups active in the discovery, development and manufacture of pharmaceutical drugs. Core Master provides data cleansing solutions for IMS Prescriber, Hospital, DDD, Discovery and FDB data. CMS also serve as data store for Sales and marketing Territory and competitor Product NDC.

Environment:Core Master System utilized Vality (Integrity) 3.9, Oracle 8i, HP-11 UNIX, PL/SQL and Korn Shell scripts.

Responsibilities:

  • Provided staging solutions for Data Validation and Data Cleansing with the help of PL/SQL, Shell and ETL jobs.
  • Architect Data Models using Erwin for the CMS Prescriber, Hospital, Territory, Sales and Product subject areas.
  • Perform and monitor monthly Prescriber and Hospital Data Cleansing, Validation and Matching with Vality.
  • Troubleshoot Vality failure and coordinated Data Quality/Validation issue with the Vality support group.
  • Maintain Roche and Competitor product hierarchy for further Business Object rollup to higher-level products.
  • Support and assist periodic Sales Force Automation re-organization of sales territory and sales rep alignment.

9. Cendant Corp. Stamford. CT, (Oracle Corp. Sr. Consultant)Dec 1998 – Feb 1999

The Promotion project provides an accurate and reliable data from Data Warehouse. Based on current statistics, it provides information for forecasting and promotions. The customized product designed by Oracle Corp. for Cendant the provider of consumer and business services.

Environment:System architecture consists of Oracle 8 Data Warehouse, PL/SQL packages, HP 10 UNIX scripts and Pro*C and customized ETT tool.

Responsibilities:

  • Design and develop ETT tool modules to perform ETL operation for the warehouse Facts and Dimensions.
  • Design and test PL/SQL ETL procedures for data upload using internal JTSS job tracing and logging system.
  • Design fuzzy email match ETL logic using PL/SQL and UNIX shell script for parallel and faster data upload.
  • Generate design specification from Designer 2000 Repository and perform further user requirements analysis.
  • Build error trapping batch process by integrating all designed ETL components using UNIX Korn shell script.

10. VWR Scientific Products. West Chester, PA, (Team leader)May 1998 – Nov 1998

Evaluated Receipts Settlement (ERS) is the major component of VWR Scientific Product Sales EDI System. The basic purpose of the ERS is to automate printing of vendor invoices and credit notes at distributed locations. The ERS also serves as the Dealer Commissions System for VWR vendors.

Environment: ERS consists of Oracle 7, PL/SQL, SQL*Loader, Forms 4.5, Reports 2.5, UNIX shell scripts and Cron.

Responsibilities:

  • Analysis of the Functional specification to prepare Technical specification for newly designed modules.
  • Design application using Reports 2.5, PL/SQL and UNIX shell scripts to for report distribution system.
  • Extraction and load the Summary Bill and Commissions data for the Data Warehouse application.
  • Automation of the data validation and loading process using shell script, Sql*Loader and cron scheduler.

11. P & O Nedlloyd. East Rutherford, NJ, (Consultant)Sep 1997 - Apr 1998

BDR is a repository for data downloaded from the DRS Core 'Branch' system, which is maintained by one of the leading shipping organizations. The basic purpose of BDR is to maintain various component of system manifest, freight release, booking tracking, vessel and container related information.

Environment:This project consists of Oracle 7, Pro*C, Forms 4.5 and Reports 2.5 application designed on AIX UNIX.

Responsibilities:

  • Design and modify Pro*C reports and Data Extraction application for the Freight system.
  • Develop and integrate data entry Forms 4.5 modules for various components of the system.
  • Test the designed modules in TEST, UAT and Production database for the performance tuning.
  • Job tracing and tracking after invoked by BDR System with the help of scheduler components.

12. Newlook Electronics. Bombay (System Consultant)Dec 1995 - Aug 1997

Integrated system consists of the inventory control, purchase, sales, customer support and accounting system for the sole distributor of refrigerators. Integrated system manages inventory at various warehouse locations, sales dealers, and financial accounting operations. Major components of project are Trial Balance, Ledgers, Payment, Receipts and Customer service system.

Environment: Dealer system consists of Forms 3.5, Reports 2.5, Oracle 7, SCO UNIX, Korn shell, Pro*C, and PL/SQL.

Responsibilities:

  • Generate various reports, screens and Pro*C application for the inventory control system.
  • Design the Forms 3.5 screens and user-exits extension using Pro*C for the accounting system.
  • Managing stored procedures and integrity of the data within the database using PL/SQL.
  • Design process steps to load the application data into data models with the help of SQL*Loader.

13. Shewalkar Consultancy. Nagpur (Programmer Analyst)Aug 1994 - Nov 1995

Customized accounting and Inventory control system was developed for one of the leading construction consultancy. The application keeps track of stock transaction, supplier, account payable, account receivable, general ledger, sales and purchase order processing. System also supported with various type of invoice printing and transaction.

Environment:The system architecture consists of Oracle 7 database, Forms 3.5 and Report 2.5 applications.

Responsibilities:

  • Analysis of the business requirement and prepare scope and requirement documents.
  • Prepare functional documents for the purchase, sales and accounting system components.
  • Design PL/SQL and C Language utility to make financial year-end processing.
  • Develop Pro*C programs to generate balance sheet and trial balance reports.

Page 1 of 4.