Prateek sharma etl_datastage_exp3.9yrs_resume

• Associate Consultant pursuing Executive MBA with 3+ years of experience in Healthcare ,Banking domain & software development, implementation in the areas of Data warehousing using IBM web sphere Data stage 8.1 tool and IBM Info Sphere Data stage 8.7,ETL Architecture, enhancement, maintenance, Production support, Data Modeling, Data profiling, Reporting including Business requirement, system requirement gathering.

1. Prateek Sharma
Email ID: [email protected]
[email protected]
Contact: [phone]
[phone]
Summary
Associate Consultant pursuing Executive MBA with 3+ years of experience in Healthcare ,Banking domain & software
development, implementation in the areas of Data warehousing using IBM web sphere Data stage 8.1 tool and IBM Info
Sphere Data stage 8.7,ETL Architecture, enhancement, maintenance, Production support, Data Modeling, Data profiling,
Reporting including Business requirement, system requirement gathering.
Presently associated with Capgemini , Pune as Associate Consultant.
Previously associated with SYNTEL LIMITED, Pune as Software Engineer.
Lead projects from initialization phase from capturing business requirements to final phases of testing.
Served as mentor and reviewer to junior Specialists in all areas of data warehousing and ETL.
Experienced in End user training, documentation, and Audit record maintenance and application/product demos.
Ability to quickly adapt to changing priorities, requests, and environments.
Responsible for documenting user requirements and translated requirements into system solutions.
Develop processes for cleansing, transforming, extracting, integrating and loading data with use of DATASTAGE 8.1/8.7.
Handy knowledge on IBM Db2 and Netezza Database.
Knowledge on Mainframe and UNIX.
Responsible of handling Equip management & Quality process for GMAR.
Responsible for Creating and maintaining TAR’s for Quality maintenance.
Dedicated to maintain high quality standards.
Work Experience:
Company Name From Month/Year To Month/Year
Syntel Ltd.
Nov’11 June’14
Capgemini India Pvt Ltd. Sept’14 Till Date
Technical Skills
Operating System Windows-XP/7/Server 2008, Unix
ETL Tools IBM Web Sphere Data stage 8.0, 8.7 and 9.1
Databases Db2, Netezza, Oracle 10g/11g, Teradata
Modelling Tools Microsoft Visio
Other Tools Mainframe, ETL Control-M Scheduling tool
Qualifications & Certifications
Degree/Certification SpecializationMonth/YearUniversity/Institution
IBM Certified INFOSPHERE DATASTAGE v.9.1
ETL Tool Aug’2015 IBM
IBM Certified INFOSPHERE DATASTAGE v.8.5.
ETL Tool Feb’2012 IBM
IBM Certified INFOSPHERE Quality Stage v.8.5.
ETL Tool Feb’2014 IBM
Bachelor of Technology Computer Science & EnggJuly’2011 Amity University
Achievements
IBM Data stage Certified.
IBM Quality Stage Certified
Syntel’s Agile Overview Level-1 Certificate.
Syntel’s Outstanding Award.
Syntel’s Acknowledge (Extra Mile) Award.
Data stage Certificate from Syntel Ltd.

2. Prateek Sharma
Email ID: [email protected]
[email protected]
Contact: [phone]
[phone]
Career Profile
Syntel Ltd.
Project Profile 1
Project Netezza Migration
Client Amex
Role Developer
Duration 6 months
Team Size 4
Environment ETL Data stage 8.0, Db2 , Netezza
The objective of this project is to migrated GMAR project from Db2 to Netezza. This project is expected to provide the various
business benefits like it provide environment, capacity and scalability required to expand GMAR to future business needs and avoid
contentions with current Db2 production environment. It also improves performance with Netezza Databases for GMAR to help meet
the business expectations of availability.
Key responsibilities were
Identify functionality difference between Db2 and Netezza.
Code to migrate from existing database changes to newly created one.
Used the NZ connector stage for developing the Updating tables.
Creation of Test Plan for Performance Testing and Incorporating Review Comments.
Creation of Performance Test Cases and Performance Test cases Review.
Update Design Documents and Create Unit Test Cases.
Code to migrate from existing database changes to newly created one.
Project Profile 2
Project OMS Phase II
Client Amex(American Express)
Role Developer
Duration 11 months
Team Size 4
Environment ETL Datastage 8.7, Db2 , Netezza, Unix
This project extracted Online Merchant Service data from GMAR Upstream on weekly and monthly basis and process this data for
cleansing, transforming, extracting and loading data to GMAR DATAWAREHOUSE and DATA MART Tables. Fully new jobs based
on Generic Utility concepts have been designed within the project. It was a complete restructure of the existing process. Creating a
generic framework & new Balance & Control process which is used for other projects as well.
Key responsibilities were
Mass communication between different teams / vendors assured smooth implementation.
Inclusion of new transformation rules to derive the nonexistent data in GMAR DATAWAREHOUSE and DATAMART.
Creation of generic utility framework.
Inclusion of new business rules if any.
Developing of Adhoc / One time jobs to address the issue.
Deployment of code in Development, QA, Production Environments.
End to End ownership from Analysis, Build, Code, UAT and Implementation.

3. Prateek Sharma
Email ID: [email protected]
[email protected]
Contact: [phone]
[phone]
Code on new environment of data stage V 8.7 using Netezza.
Have used HASH File concept for metadata definitions for the RCP enable jobs .
Capturing the SIT & UAT test results and validated the data.
Creating the CMR’s for migrating the code to production.
Follow up with concern groups to get the approvals for the CMR’s.
Project Profile 3
Project RAW DATA
Client Amex
Role Developer
Duration 6 months
Team Size 4
Environment ETL Datastage 8.7, Db2 , Netezza, Unix
RAW DATA to be sourced from STARS team and stored in our database.
The primary purpose from this scope to introduced RAW data into our environment. Created completely new database table to store
RAW data.
Captured Enrollment-Un-enrollment information at merchant level.
.
Key responsibilities were
Understanding existing business model and customer requirements.
Create the Analysis and Design Documents.
Analyzing the specifications and functional documents of project requirement.
Created the source – target mapping documents.
Design ETL job’s using Data Stage as per business requirement.
Used most of the Stages in Data stage, such as the Transformer Stage, lookup stage, joiner stage, Remove duplicate,
Sort stage, Modify stage, funnel stage, Netezza Connector stage, Aggregator Stage, Sequential Stage, Shared
Containers etc…
Have used HASH File concept for metadata definitions for the RCP enable jobs.
Involved in optimizing / tuning to increase the performance
Created and Configured Sequencers to send email on failure.
Project Profile 4
Project ALIF (Active Location in Force)
Client Amex
Role Developer
Duration 5 months
Team Size 4
Environment ETL Datastage 8.7, Db2 , Netezza, Unix
This project derives ALIF attributes and accommodates them in already existing GMAR database structures in DATA MART Tables.
Key responsibilities were
Prepared & validating the unit test results.
Capturing the SIT & UAT test results and validated the data.
Fixing of code and data related bugs in the existing application.

4. Prateek Sharma
Email ID: [email protected]
[email protected]
Contact: [phone]
[phone]
Creating the CMR’s for migrating the code to production.
Follow up with concern groups to get the approvals for the CMR’s.
Project Profile 5
Project
Merchant Site (Call Volume)
Client Amex
Role Developer
Duration 6 months
Team Size 4
Environment ETL Datastage 8.7, Db2 , Netezza, Unix
This project to be sourced from three different streams (SEMIS, GENSIS & Merchant Force) and stored in our database.
We are going have the Calling details for all three markets.The Calling details are like Servicing and technical for the entire
merchant who already exists in GMAR as well as new merchant.
Key responsibilities were
Lead projects from initialization phase from capturing business requirements to final phases of testing.
Inclusion of new transformation rules to derive the nonexistent data in GMAR DATAWAREHOUSE and DATAMART.
Inclusion of new business rules if any.
Developing of Adhoc / One time jobs to address the issue.
Deployment of code in Development, QA, Production Environments.
End to End ownership from Analysis, Build, Code, UAT and Implementation.
Code on new environment of data stage V 8.7 using Netezza.
Capgemini India Pvt Ltd.
Project Profile 6
Project Risk-MI
Client HSBC
Role Developer/Support
Duration 6 months
Team Size 4
Environment ETL Datastage 9.1, Db2 , Unix
Risk MI was built to provide HSBC North America Holdings (HNAH) with an automated platform to acquire, integrate, analyze and
report risk management intelligence across all business units and lines of business across the holding company. RiskMI receive
feeds from various systems on a periodic basis and load them into RiskMI DataMart. RiskMI process Basel, Credit Risk and Finance
data and this data is finally used by Business for analysis and reporting purpose his project process financial data. Credit risk, Basel,
GL, MTG, Cards & Payment are the main module on which we have to look.
Key responsibilities were
Understanding existing business model and customer requirements.
Create the Analysis and Design Documents.
Analyzing the specifications and functional documents of project requirement.
Created the source – target mapping documents.
Analysis and querying of business logics
Team lead
Generating and testing workflows using Datastage.
ETL Testing.
Data validation and testing using Data stage.
Bug fixing.

5. Prateek Sharma
Email ID: [email protected]
[email protected]
Contact: [phone]
[phone]
Client Interaction.
Assurance of defect adherence and quality of the project.
Migrated whole project from DS 8.1 to DS 9.1.
NDM of files from UNIX to Mainframe and running JCLs in Mainframes.
Configured SSH setup between new servers.
Analyze and fix the defects if any.
Performance tuning of DS Jobs.
Providing the training to the freshers
Transition of interfaces to the support team.
Personal Details
Date of Birth: 14th August 1989
Languages: Hindi, English & German
Nationality: Indian
Passport Number: J7984237
Marital Status: Married