SUMMARY:

• 12 years of experience in Data Integration Implementation for Enterprise Data Warehouse, Master Data Management and Hadoop Data Lake.
• Experience in ingesting Mainframe VSAM files into Hadoop Data Lake using DataStage 11.5.
• Hands on experience in Talend Data Integration tool.
• Hands on experience in designing and creating Near Real Time Jobs using MQ connectors in DataStage 9.1.
• Extensive experience in building and maintaining Data Warehouses systems using IBM Datastage v11.5/v9.1/v8.5/v8.1.x/v7.5 (Administrator, Director, Manager, Designer).
• Extensively worked on building DataStage jobs to process, merge the data using various stages like Transformer, Modify, Funnel, Join, Merge, Look - up, Pivot, Aggregator etc.
• Experience in creating DDL scripts for Operational Data Store and ETL Source to Target mapping documents.
• Experienced in troubleshooting DataStage jobs, enhancement of jobs and addressing production issues like Performance tuning and Enhancement
• Extensively worked on Oracle 9i, Teradata 7, IBM DB2 Z/OS 9.7 and IBM UDB 8.0.
• Experience in designing Job Batches and Job Sequences for scheduling Server and Parallel jobs using DataStage Director, UNIX scripts.
• Worked on defining dependency and scheduling DataStage jobs using enterprise-scheduling tools such as Control-M, ESP and TWS.
• Expertise in writing DB2 SQL’s and UNIX shell scripts.
• Experience in Designing, developing and implementation of various ETL frameworks with source integrations, Staging, Homogenization, Error and Audit process
• Driven two Hadoop, six Master Data Management implementation, four Data warehousing and two Compliance projects and multiple Profitability projects for leading banks in United States of America & Canada.

TECHNOLOGY STACK:

IBM DataStage Enterprise Edition 8.1, 8.5, 8.7 and 9.1, IBM BigInsights Hadoop platform i.e., Ambari, HDFS and Hive, Talend Data Integration 6.x

Erwin for Data Modelling

Microsoft Visio for creating DFDs (Data Flow Diagram)

M and ESP (Schedulers)

HP Service Manager and BMC Remedy for Change Management

IBM Infosphere Master Data Management.

IBM DB2 v9.7.

IBM Rational ClearCase & Clear Quest.

UNIX and LINUX Shell Scripting.

IBM DataSatge and Quality Stage

WORK EXPERIENCE:

Confidential, Cincinnati

Responsibilities:

• Project planning, Status reporting, Team management, Work allocation, Analysis, Design, Coding, Debugging Unit testing and system testing.
• Working in a highly paced dynamic environment focusing multiple projects and manage strategic and complex projects, enhancement of client facing applications, and on boarding new projects.
• Involved in the end-to-end SDLC, from gathering and analyzing requirements, creating use cases, working with clients to answer developer clarifications, conducting user acceptance testing, deployment, and post deployment defect tracking.
• Involved project proposals, planning, estimation, proof of concept (POC), resource loading, providing technical guidance, supporting team and monitoring of project tasks.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Work in a collaboration onshore - offshore mode with multiple teams to satisfy the customer needs.
• Data analysis, design, development, implementation and design and code reviews for Extraction, Transformation and Loading ETL.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models and strategy.
• Handling Project Management activities and support very closely to make project delivery success.
• Project planning, Status reporting, Team management, Work allocation, Analysis, Design, Coding, Debugging Unit testing and system testing
• Conduct review sessions and finalize the execution strategy with project stakeholders
• Review the performance technique and best practices

Tools: IBM InfoSphere Information Server DataStage 11.5, UNIX, Microsoft Windows, IBM DB2, UNIX shell scripting, SQL, Tivoli scheduler, Textpad editor and Putty

Confidential

Responsibilities:

• Understanding the VSAM file structures, building/adjusting the Cobol Copybook based on the dataset.
• Designing and developing very complex ETL jobs to read VSAM files using Copybook via DataStage Complex Flat File stage.
• Ingesting raw data into IBM BigInsights Hadoop ecosystems.

Tools: IBM InfoSphere Information Server DataStage 11.5, UNIX, Microsoft Windows, IBM DB2, UNIX shell scripting, SQL, Tivoli scheduler, Textpad editor and Putty

Confidential

Responsibilities:

• Exhibiting the roles of Technical Lead and ETL solution designer on the integration project.
• Managing a team of 20+ developers and senior developers at offshore.
• Responsible for the delivery of all ETL artifacts from the design to the delivery phase.
• Work with the onsite stakeholders to ensure the business requirements are met for specific data integration projects.
• Design, develop and support extraction and integration processes (ETL)
• Perform data analysis and propose and ensure transformation covers all data possibilities including managing data anomalies
• Implement processes to ensure data quality in the database systems
• Performance tuning, optimization and scalability to ensure efficiency in the data warehouse
• Troubleshooting and assisting in resolving errors and performance issues
• Support and coordinate QA and UAT testing

Tools: IBM InfoSphere Information Server DataStage 9.1, UNIX, Microsoft Windows, IBM DB2, UNIX shell scripting, SQL, Tivoli scheduler, Textpad editor and Putty

Confidential

Responsibilities:

• Exhibiting the roles of Technical Lead and ETL solution designer on the integration project.
• Managing a team of 20+ developers and senior developers at offshore.
• Responsible for the delivery of all ETL artifacts from the design to the delivery phase.
• Work with the onsite stakeholders to ensure the business requirements are met for specific data integration projects.
• Design, develop and support extraction and integration processes (ETL)
• Perform data analysis and propose and ensure transformation covers all data possibilities including managing data anomalies
• Implement processes to ensure data quality in the database systems
• Performance tuning, optimization and scalability to ensure efficiency in the data warehouse
• Troubleshooting and assisting in resolving errors and performance issues
• Support and coordinate QA and UAT testing

Tools: IBM InfoSphere Information Server DataStage 9.1, UNIX, Microsoft Windows, IBM DB2, UNIX shell scripting, SQL, Tivoli scheduler, Textpad editor and Putty

Confidential

Responsibilities:

• Responsible for providing technical guidelines to the off-shore team, designing and developing the medium to complex DataStage interfaces and coordinating with development team.
• Managing a team of 6 developers and senior developers at offshore.
• Responsible for the delivery of all ETL artifacts from the design to the delivery phase.
• Work with the onsite stakeholders to ensure the business requirements are met for specific data integration projects.
• Design, develop and support extraction and integration processes (ETL)
• Perform data analysis and propose and ensure transformation covers all data possibilities including managing data anomalies
• Implement processes to ensure data quality in the database systems
• Performance tuning, optimization and scalability to ensure efficiency
• Troubleshooting and assisting in resolving errors and performance issues
• Support and coordinate QA and UAT testing

Tools: IBM InfoSphere Information Server DataStage 8.7, UNIX, Microsoft Windows, IBM DB2, UNIX shell scripting, SQL, ESP scheduler, Textpad editor and Putty, IBM Clear Case, IBM Clear Quest, HP Quality Manager, Remedy and Incident Management.

Confidential

Technical Lead and ETL solution designer

Responsibilities:

• Responsible for providing end to end technical solutions to on all ETL DataStage components.
• Designing and developing the complex DataStage interfaces and coordinating with development team.
• Designed ETL components for online synchronization of OCIF and MDM using DataStage MQ connector.
• Involved on developing Quality Stage jobs to standardize Name, Address and Telephone numbers.
• Responsible for the delivery of all ETL artifacts from the design to the delivery phase.
• Work with the onsite stakeholders to ensure the business requirements are met for specific data integration projects.
• Design, develop and support extraction and integration processes (ETL)
• Perform data analysis and propose and ensure transformation covers all data possibilities including managing data anomalies
• Implement processes to ensure data quality in the database systems
• Performance tuning, optimization and scalability to ensure efficiency
• Troubleshooting and assisting in resolving errors and performance issues
• Support and coordinate QA and UAT testing

Tools: IBM InfoSphere Information Server DataStage 8.5, Quality Stage, Message Queue, LINUX, Microsoft Windows, IBM DB2, UNIX shell scripting, SQL, ESP scheduler, Textpad editor and Putty, IBM Clear Case, IBM Clear Quest, HP Quality Manager, Remedy and Incident Management.

Confidential

Senior DataStage Developer and Designer

Responsibilities:

• Designing and developing the medium to complex DataStage interfaces and coordinating with development team.
• Managing a team of 3 developers and senior developers at offshore.
• Worked with the onsite stakeholders to ensure the business requirements are met for specific data integration projects.
• Implement processes to ensure data quality in the database systems
• Performance tuning, optimization and scalability to ensure efficiency
• Troubleshooting and assisting in resolving errors and performance issues
• Support and coordinate QA and UAT testing

Tools: IBM InfoSphere Information Server DataStage 8.5, UNIX, Microsoft Windows, IBM DB2, UNIX shell scripting, SQL, ESP scheduler, Textpad editor and Putty, IBM Clear Case, IBM Clear Quest, HP Quality Manager, Remedy and Incident Management.

Confidential

Responsibilities:

• Responsible for providing application support by monitoring the EDW batch and sending out status report periodically.
• EDW batch optimization, performance tuning and incident/ticket resolution in a timely manner.
• Troubleshooting and assisting in resolving errors and performance issues
• Support and coordinate with onsite team on a daily basis

Tools: IBM InfoSphere Information Server DataStage 8.5, UNIX, Microsoft Windows, Teradata, UNIX shell scripting, SQL, Control-M scheduler, Microstrategy reporting tool, Textpad editor and Putty, HP Quality Manager, Remedy and Incident Management.