PROFESSIONAL SUMMARY:

• Ten + Years of experience in Analysis, Design, Coding, Development, Implementation and performance tuning in IBM InfoSphere Information Server - Data Stage Versions 8.7/8.5/7.x Enterprise Edition and Server Edition as part of various Data warehouse Development and Data Migration projects executed for major clients across globe.
• Ten + Years of experience in Analysis, Design, Coding, Development, Testing and Production support in Enterprise Data Warehouse, Data Migration Application under different environments.
• Extensive experience resolving technical issues using ETL tools like DataStage, Informatica.
• DataStage Technical Lead for the ETL Onsite & Offshore Development teams and provided the recommendations to optimize the data extraction and loading using ETL Datastage jobs.
• Specializes in data analysis, data mapping, data conversion, data integration, business analysis, functional design, Technical design, Metadata Driven approach and different aspects of data/information management.
• Experience in Full Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, implementation and project documentation.
• Extensive experience interacting with cross-functional, global teams and communicating project information to multiple levels in an organization.
• Has ETL Design/Implementation experience with Industries/areas like Retail, Banking, Pharmaceutical and Health care.
• Strong background with ETL Design and coding for Data loading, cleansing, Data Quality, Validation and Integration for enterprise data migration systems.
• Design and Build common re-usable ETL components to define reprocessing of error records, audit processes, Job monitoring and ETL logging processes.
• Expertise in Implementation of SQL queries, PL/SQL packages, stored procedures, functions, triggers using Oracle SQL and query optimizations.
• Expertise in using UNIX shell scripts with Datastage, implementing FTP process using UNIX shell scripts.
• Expertise in defining the ETL Integration architecture, ETL Metadata Driven approaches, development of best of breed ETL environment, defining and implementing ETL Methodology, designing, defining, creating and implementing ETL components, mentoring the ETL team and troubleshooting integration issues.
• Extensive Knowledge on Development, Support and Maintenance of DW and BI projects.
• Expertise in handling Data sources likes Oracle, DB2/UDB and Teradata.
• Experience in developing complex Jobs, Sequences and re-usable jobs/containers.
• Expert knowledge of performance tuning source, mapping, target and sequences.
• Expertise in using tools like Toad, DB2-AQT, VSS and HP-PVCS Dimensions.
• Good analytical skills, a self-motivated learner, and possess excellent communication and interpersonal skills and ability to work in a team as well as individually.
• Experience in Data modeling, Data Warehousing Concepts and ETL Tools.
• Experience in using Information Analyzer for data analysis, Quality stage to maintain data quality, Metadata Work Bench for data lineage, Business lineage and impact analysis.

SKILLS:

ETL Tools: Datastage 8.7/8.5/7.x PX, Quality Stage, profile stage, Information Analyzer, Fast Track, Business Glossary, Metadata Work Bench, Informatica.

Languages: SQL, PL/SQL, UNIX Shell Script, C, C++

Databases: Oracle 8i/9i/10g, IBM DB2, TeraData, SQL Server 2008, MS-Access 2003,2007

Other DW-BI Application Tools: Toad 7.x, DB2-AQT 7.x, Datastage version control tool, HP-PVCS Versioning tool, Micro strategy 8.1.0,Business Objects, Cognos.

Environment: AIX Unix 5.2, Windows 98, XP, 2K,Windows7.

Methodologies: - ERwin Data Modeler, Dimension Modeling, ER Modeling.

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Consultant/Senior Application Developer

Responsibilities:

• Involved in gathering, analyzing the user requirements.
• Used the Data stage stages Copy, Lookup, Transformer, Sort, Column Export, Funnel, Row Generator, Join, Dataset, Aggregator, Change Capture, Peak, Sequential file, Modify, Remove Duplicates, Oracle Enterprise for development and debugging process.
• Extensively worked with Autosys .Jil files for scheduling the Datastage jobs.
• Created Batches and sequences to control set of Datastage Parallel Extender jobs.
• Prepared Unit Test Plans and conducting Peer Reviews for Individual as well as Integrated Components.
• Involved in developing Unix Shell Scripts, TDQ Shell Scripts and TDQ SAS Scripts.
• Design, technical reviews and troubleshooting of many complex jobs and scripts.

Environment: IBM Datastage 8.5 PX, Oracle 10g, IBM AIX 5.0, Unix hummingbird exceed, Autosys, Unix Shell Scripting, SAS Scripting,Clear case, Windows 7.

Confidential, Charlotte, NC

Consultant/Senior Application Developer.

Responsibilities:

• Involved in gathering, analyzing the user requirements.
• Involved in source, target data mapping of the requirements using FastTrack.
• Involved in the Customer Systems Data Integration Platform ( Confidential ) and leverages in the metadata Driven approach for development efforts. The Centralized metadata repository shares metadata across the platform and enables data integration development.
• Imported source and target Metadata Assets (Database tables or Data files) into shared metadata repository.
• Developed technical and business terms in the business glossary.
• Involved in documenting source and target mapping and transformation rules with FastTrack.
• Involved in leverage metadata for data integration code development in Datastage.
• Involved in linking business glossary terms with Metadata assets in FastTrack and metadata workbench.
• Involved in demonstrating data and business lineage reporting through the metadata workbench.
• Involved in migrating common metadata assets (database tables or data files), Fast Track Assets, Business Glossary asset migration from development to SIT to Prod environments.
• Used the Data stage stages Copy, Lookup, Transformer, Sort, Column Export, Funnel, Row Generator, Join, Dataset, Aggregator, Change Capture, Peak, Sequential file, Modify, Remove Duplicates, Oracle Enterprise for development and debugging process.
• Extensively worked with Control-M for scheduling the Datastage jobs.
• Created Batches and sequences to control set of Datastage Parallel Extender jobs.
• Prepared Unit Test Plans and conducting Peer Reviews for Individual as well as Integrated Components.
• Design, technical reviews and troubleshooting of many complex jobs and scripts.

Environment: IBM Datastage 8.7 PX, Fast Track, Business Glossary, Metadata Work Bench, Oracle 10g,Oracle Exadata x3, IBM AIX 5.0, Unix hummingbird exceed, Control-M,SVN subversion, Windows XP.

Confidential, Princeton, NJ

Senior Consultant/Datastage Technical Lead

Responsibilities:

• Involved in gathering, analyzing the user requirements.
• Involved in source, target data mapping of the requirements using FastTrack.
• Performing Administrator functions like creating projects, importing joins to new projects, protecting project, unlocking the jobs.
• Used the Data stage stages Copy, Lookup, Transformer, Sort, Column Export, Funnel, Row Generator, Join, Dataset, Aggregator, Change Capture, Peak, Sequential file, Modify, Remove Duplicates, Oracle Enterprise for development and debugging process.
• Handling all types of Source files viz. Flat files, CSV’s and Extract Metadata from Oracle Database for all scenarios.
• Involved in linking business glossary terms with source and target fields in FastTrack.
• Prepared Unit Test Plans and conducting Peer Reviews for Individual as well as Integrated Components.
• Implemented automatic E-MAIL Generation at the end of master sequences to inform the success/failure status.
• Datastage Technical Lead at Onsite, interacting clients on daily basis and mentored Offshore Development team(s).
• Involved in Project Management, Planning and Version controlling of all documents.
• Development, testing and technical review of the most complex jobs and scripts developed.
• Resolved many complex technical issues related to Data Stage.

Environment: IBM Datastage 8.1/7.5.2 PX, Fast Track, Business Glossary, Oracle 10g,IBM AIX 5.0, HP-PVCS version controlling and Windows XP.

Confidential, Minneapolis

Senior ETL Consultant/Technical Analyst

Responsibilities:

• Involved in analyzing the user requirements.
• Creation of Mapping documents, Low Level Designs and low level job flow using Visio.
• Involved in source, target data mapping of the requirements using FastTrack.
• Involved in linking business glossary terms with source and target fields in FastTrack.
• Design, Build & Test parallel jobs to extract data from SAS files and DB2 data base systems by using of Sequential file stage and DB2/UDB API, Enterprise Stages respectively.
• Extracted data from various source systems like relational database (EPM), flat files(Client supplied files---TMMBR CLAS GRP CODE.txt) for lookups and load data in to the data warehouse.
• Used the Data stage stages Copy, Lookup, Transformer, Sort, Column Export, Funnel, Row Generator, Join, Dataset, Merge, Aggregator, Change Capture, Peak, Sequential file, Modify, Remove Duplicates for development and debugging process.
• Design, Build & Test sequencer jobs to run all the four parallel jobs (Extract, Transform, Load ODS, and Load DB2) in sequence.
• Created Re-usable components using shared containers, Routines and Multiple Instance Jobs using RCP (Runtime column propagation).
• Handling huge volumes of data (up to 2 TB) using DB2 load Utility.
• Extensively worked with Control-M for scheduling the jobs.
• Was part of Production Support Team and resolved many complex issues.

Environment: IBM Datastage 8.5/7.5.2 PX, Fast Track, Business Glossary, Oracle 10g, IBM DB2 8.x, Teradata 13, IBM AIX 5.0, Control-M Scheduler, HP-PVCS version controlling and windows XP.

Confidential, Dublin, Ohio

Senior ETL Software Developer/Consultant

Responsibilities:

• Involved in Project Kick Off and gathered the user requirements.
• Understanding the existing Cardinal’s Source system and data mappings from sources into Warehouse and analyzing the existing system data Process model.
• Involved in the ETL-Data stage coding from open-hub/DB2 to Teradata.
• Performing analysis, coding and testing of various applications on Teradata Database using DATASTAGE.
• Participated in Requirement Analysis and Preparation and approval of Test Plan and Test Case documents.
• Experience in Shell scripting, writing complex ad-hoc queries in SQL.
• Experience in SQL tuning of complex queries.
• Analyzing the data using the Information Analyzer and using quality stage to maintain data consistency throughout the Project.
• Developed Full Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, implementation and Project documentation.
• Extensively Used Parallel Stages like Join, Merge, Lookup, filter, Remove Duplicates, Row Generator, Column Generator and Peek Stages for development and Debugging process.
• Worked with Deployment team in data cleansing before moving it into the production environment & Data Analysis.
• Used QUALITY Stage to investigate data and defining Rule sets to data.
• Using other Data quality stages like Standardize, Match Frequency, Unduplicate and Reference matches.
• Defining Match Specifications to ensure the quality of data.

Environment: IBM Infosphere Information Server- Datastage 8.1, IBM AIX 5.0, windows XP, Oracle 9i, IBM DB2,Teradata, PeopleSoft, IBM Information Analyzer, QUALITY Stage.

ETL Developer/Software Engineer

Confidential, Minneapolis

Responsibilities:

• Involved in setting up application and environment.
• Involved in gathering the user requirements and data mapping of the requirements.
• Involved in designing the schemas based on the user requirement using ERwin.
• Analyzing Mapping Documents and Design Specifications.
• Designed and Developed Datastage Parallel jobs as per Technical Documents.
• Performing export and import of data Stage components, table definitions and routines using Data Stage Manager.
• Designed Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions (SCD).
• Extensively Used Parallel Stages like Copy, Lookup, Transformer, Sort, Column Export, Funnel, Row Generator, Join, Dataset, Merge, Aggregator, Sequential file, Modify, Remove Duplicates, Peak for development and Debugging process.
• Implemented Stock Management by sending automated E-mails to the vendors whenever the number of items of a particular product goes down beyond a given value.
• Tested the jobs through UNIX scripts to load the data into warehouse and used Control-M for Scheduling the ETL Jobs.
• Unit testing, peer reviews & System Testing and updating Project Share point with the risk log, issue log, BRD-change log documents.
• Rectified the ST/SIT defects on Daily basis using Mercury Quality Center Tool.
• Using HP-PVCS Version Control Tool to keep track of multiple versions of DataStage Jobs and promote latest version of jobs from development to QA to UAT and Production.
• Participated in the UAT (Defects Rectified) and Production Support(Using Serana PVCS & WBSD)
• Created the RFC’s, work orders through HPSD, IWR to resolve the tickets/incidents through the DSO.
• Prepared Technical-inspection Summary documents.

Environment: IBM Datastage Parallel Version 7.5.2, IBM AIX 5.0, Oracle 10g, IBM- DB2,Control-M, Mercury Quality Center, HP-Service Desk.

ETL Developer/ Software Engineer

Confidential, NY

Responsibilities:

• Analysis the user requirements.
• Design, Build & Test parallel jobs to extract files from TPS systems in Flat files by using of sequential files.
• Extracted data from various source systems like relational data bases, flat files and load data in to the data warehouse.
• Extensively worked with facts and Dimension tables - architecture to produce source to target mappings based upon business specs.
• Developing solutions for Complex Problems with utmost performance using the Data stage stages like Transformer, Sort, Aggregator, Funnel, Modify, Data set, Look up.
• Handling all types of Source files viz. Flat files, CSV’s and Extract Meta Data from Oracle Database for all scenarios.
• Prepared Unit Test Plans and conducting Peer Reviews for Individual as well as Integrated Components.
• Extensively worked with datasets to handle large volumes of data.
• Created Multiple Instance Jobs for code reusability for generating reports to 5 different Years.
• Wrote UNIX shell scripts for file validation and scheduling Data Stage jobs.
• Used Data Stage Manager to implement import and export of metadata and interfaces.
• Used Partition Methods and Collecting Methods for implementing Parallelism.
• Created Shared Containers and Sequences these can be re-used for different modules.
• Extensive hands in configuring the Version Control Tool viz. VSS.

Environment: Ascential Datastage Enterprise Edition Version 7.5.2/7.5.1. A, IBM AIX 5.0, Oracle 9i, SQL Server 2005, Toad, Microsoft Visio and windows 2000.

Confidential, New York City, NY

SWR Application Developer

Responsibilities:

• Participated in Requirement Analysis and Preparation and approval of Test Plan and Test Case documents.
• Extensively worked with facts and Dimension tables - architecture to produce source to target mappings based upon business specs.
• Designed several jobs using Sequential file, Join, Merge, Lookup, Change Capture, Remove Duplicates, Funnel, Filter, Copy, Peek, Pivot, Aggregator, Modify, and Transformer Stages.
• Extensively worked with datasets to handle large volumes of data.
• Created Multiple Instance Jobs for code reusability for generating reports to 16 different customers.
• Job design, technical reviews and troubleshooting of Data stage Jobs.
• Used Data Stage Manager to implement import and export of metadata and interfaces.
• Created Test Plans for Unit Testing for designed jobs.
• Used Partition Methods and Collecting Methods for implementing Parallelism.

Environment: Ascential Datastage 7.5.1.A, Server/Parallel Version 7.5.2, AIX, Oracle 8i, Toad, and windows 2000.