SUMMARY

• 10+ years of IT experience which includes in Requirement Gathering, Analysis, Design, Development, Testing and Deployment in implementing Data warehouse, Data Integration and Data Migration projects of varying complexity.
• 10 years of ETL experience in IBM Datastage 11.x/9.x/8.x of Enterprise and Server editions.
• Good experience in IBM Quality Stage for Data cleansing, Standardization and Address verification.
• Good experience in providing ETL Technical Design solution and involved in Design reviews as an ETL Architect.
• Good experience on overall Hadoop Eco - system (HDFS, Hive, Sqoop, Flume, Pig)
• Involved in providing ETL technical assessment and framework for Datastage reusable jobs.
• Involved in developing proof of concept (PoC) studies to evaluate the technical feasibility of new solutions, to envision the future state of the system.
• Good experience in gathering and analyzing the functional requirements and frame it to technical requirements.
• Involved in participating JAD sessions with different application teams for Data integration projects.
• Good experience in various relational databases like Oracle, DB2, MS SQL Server and MPP databases like Oracle Exadata, Teradata as Source and Target systems.
• Good experience in ETL extraction of data from flat files, complex flat files, CSV files and XML files into Data repository.
• Work Experience includes Requirement Analysis, Design, Development, Testing, Quality Assurance and Implementation.
• Good understanding of Dimensional Data Modeling techniques using Erwin.
• Good hands-on knowledge of IBM Infosphere Information analyzer for Data profiling.
• Experience in using IBM Infosphere Metadata Workbench for impact analysis of Datastage jobs.
• Expertise in Performance tuning, debugging and troubleshooting of Datastage jobs.
• Experience in real-time integration stages like Hierarchy, XML stages in Datastage.
• Good experience of Datastage SFDC stage for the integrating Salesforce cloud system data.
• Good experience in UNIX shell scripting, SQL.
• Experience in using Oracle Golden gate for implementing CDC solution.
• Effective team player with good interpersonal and problem solving skills.

TECHNICAL SKILLS

ETL Tools: Datastage 11.x/9.x/8.x, Talend, Informatica

Hadoop Stack: Hive, Pig, Sqoop, Flume

Quality Tools: Quality stage 11.5, Information Analyzer, AVI

Reporting Tools: Cognos, Tableau

Data Modelling: Erwin

Databases: Oracle, DB2, MS SQL Server, Oracle Exadata

Languages: C, Python, COBOL, SQL, PL/SQL

ERP: PeopleSoft

Cloud Systems: Workday, Salesforce

Database Tools: TOAD, DB2 Query Analyzer, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, San Francisco CA

ETL Architect/ETL Technical Lead

Responsibilities:

• Worked with the MMS Business team for gathering requirements for Data Integration for MDM In-bound and Out-bound Downstream processes (SFDC and EDW)
• Worked as an ETL Architect/ETL Technical Lead and provided the ETL framework Solution for the Delta process, Hierarchy Build and XML generation.
• Prepared the Technical Specification document for the ETL job development.
• Worked on ETL Development, Code review and Coordinating the development activities with offshore team.
• Implemented reusable ETL job framework using Datastage for the Delta extraction from different Sources.
• Implemented the Hierarchy Build for the MDM and worked on the hierarchy stage for generating the XMLs.
• Worked on the development of Downstream feeds from MDM to SFDC, Data Lake Hive tables and EDW systems.
• Supporting and Coordinating with QA team for the SIT testing
• Support to Business team for UAT testing.
• Preparation of implementation plan, back out plan and Control plan.
• Support for production deployment activities, implementation.

Environment: UNIX AIX, Oracle 12c, SQL Server: IBM Infosphere Datastage 11.5, IBM Qualitystage 11.5, AVI, Hive, IBM Maestro

Confidential, Pleasanton CA

ETL Technical Lead

Responsibilities:

• Worked with the functional team for gathering and understanding the requirements for the Management responsibility reports of FDW.
• Impact analysis to the existing ETL jobs as part of the FDW enhancements.
• Prepared the Solution Design Document and Technical specification document as part of FDW Enhancements for the ETL jobs.
• Providing the effort estimates for the Development and Unit testing.
• Worked on the overall SLA improvement of FDW to improve the performance.
• Worked on the performance improvement of ETL Datastage jobs and performance tuning to the SQLs used in Oracle.
• Coordinating with the offshore team for the Development activities.
• Code review and Performance tuning of Datastage jobs and SQL’s for optimization.
• Supporting and Coordinating with QA team for the SIT testing and UAT.
• Performance testing for the enhancements and SLA improvement of ETL jobs.
• Preparation of implementation plan, back out plan and Control plan.
• Support for production deployment activities, implementation for the Enhancements.

Environment: UNIX AIX, Oracle 11g, PeopleSoft FSCM IBM Infosphere Data stage 9.1.2 Server and Parallel Jobs, IBM Tivoli, IBM Cognos

Confidential, Pleasanton CA

ETL Technical Lead

Responsibilities:

• Worked with Olink FSCM team for requirement gathering.
• Did the impact analysis to find the impacted ETL jobs for Datastage and Informatica.
• Prepared the Technical specification document which gives the low level design for the development changes of ETL jobs.
• Effort estimation for the Development and Unit testing.
• Provided the ETL framework for re-usable ETL jobs using metadata driven approach (RCP) for the Parallel Jobs.
• Coordinating with the offshore team for the Development activities.
• Code review and Performance tuning of Datastage jobs and SQL’s for optimization.
• Supporting and Coordinating with QA team for the SIT testing and UAT.
• Working closely with the application Dev teams to get the requirements for history data load strategy.
• Performance testing for the re-building of large volume tables and full-load jobs.
• Preparation of implementation plan, backout plan and Control plan.
• Support for production deployment activities, implementation and warranty support after post-production.

Environment: UNIX AIX, Oracle 11g, DB2, Teradata IBM Infosphere Data stage 9.1 Server and Parallel Jobs, Informatica, IBM Cognos

Confidential, Los Angeles CA

Sr. ETL Developer

Responsibilities:

• Worked with various Source system and MDX system analysts for gathering and understanding the requirements.
• Preparation of Requirements ACD document which covers the high level design and Design ACD which covers the low level design.
• Used agile methodology for this project implementation which is divided into multiple releases.
• Effort estimation for the Design and Development.
• Providing the ETL framework for re-usable interfaces using metadata driven approach (RCP) including all the control checks (Date Check, Size Check, Record count check, Duplicate check) and metadata validation check.
• Involved in Design of ETL ABC tables in MDX for capturing the Control stats which will be used for EDMP control checks as per the Bank standard.
• Coordinating the offshore team for the Development activities.
• Code review and Performance tuning of Datastage jobs for optimization.
• Performing the Code Integration testing.
• Supporting and Coordinating with QA team for the SIT testing and UAT.
• SLA and scheduling discussions with the Source and Target systems/applications.
• Working closely with the application Dev teams to get the requirements for Day0 and Day1 load strategy.
• Performance testing based on the Volumes expected for Day0 and Day1 production runs.
• Preparation of Deployment plan, contingency plan and Control plan.
• Support for production deployment activities, implementation and warranty support after post-production.

Environment: LINUX, Oracle Exadata, Oracle 11g, MS SQL Server, Sales Force

Confidential, Los Angeles CA

Sr. ETL Developer

Responsibilities:

• BRD review meetings with different application teams to understand the requirements and the dependency of upstream and downstream applications.
• JAD sessions with the CRM application SA teams for the preparation of High level Design.
• Providing the estimates for the Design and Development efforts.
• Design discussions with CRM application DEV teams for the preparation Low level design.
• Preparation of equivalent Technical Design steps in the LLD for the Development.
• Providing the ETL Design framework for the Job development.
• Coordinating the offshore team for the Development activities.
• Code review and Performance tuning of Datastage jobs for optimization.
• Performing the Code Integration testing.
• Supporting and Coordinating with QA team for the SIT testing and UAT.
• SLA and scheduling discussions with the upstream and downstream applications.
• Working on Performance testing based on the Volumes expected for Day0 and Day1 production runs.
• Preparation of Detail task list for the deployment and Control plan.
• Support for production deployment activities and implementation.

Environment: LINUX, Oracle 11g, MS SQL Server, iSeries DB2, Sales Force

Confidential, Houston TX

ETL Lead Developer

Responsibilities:

• BRD analysis and review meeting with the Business team to understand the requirements.
• Preparation of Functional Specification Design (FSD) based on the Confidential and Requirements.
• Preparation of equivalent Technical Design Documents (TDD) for Setup and Transaction Data conversions.
• Leading and driving the ETL team technically and functionally for the Development.
• Providing level of estimations (LOE) for the ETL Development.
• Automation of ETL process and framework to handle the data conversion for multiple countries based on the global template.
• Performance tuning of existing Data stage jobs for the optimization.
• Conducting Peer reviews and Unit Testing.
• Support for SIT (System Integration Testing), UAT (User acceptance Testing) and production implementation.

Environment: AIX UNIX, Oracle 11g, PeopleSoft EPM, Workday

Confidential, Houston TX

ETL Lead Developer

Responsibilities:

• Participate in the BRD review meetings with the Business Analysts and understanding the requirements.
• Analyzing the Business requirements from the Client and preparing of Functional Specification Design (FSD).
• Preparation of equivalent Technical Design Documents (TDD).
• Leading and driving the team technically and functionally for the ETL Development.
• Providing level of estimations (LOE) for the ETL Development projects, enhancements and Service requests.
• Performance tuning of existing Data stage jobs for the optimization.
• Conducting Peer reviews and Unit Testing.
• Support for SIT (System Integration Testing), UAT (User acceptance Testing) and production implementation.

Environment: AIX UNIX, Oracle 11g, PeopleSoft EPM

Confidential

ETL Lead Developer

Responsibilities:

• Gathering the Business requirements for enhancements.
• Analyzing the Business requirements and Preparation of Functional Specification Documents.
• Preparation of equivalent Technical Specification Documents for the enhancements.
• Effort estimation for the Development and Testing.
• Performance tuning of existing Data stage jobs for the optimization.
• Conducting Peer reviews and Unit Testing.
• Support for SIT (System Integration Testing), UAT (User acceptance Testing) and production implementation.

Confidential

ETL Lead Developer

Responsibilities:

• Analysis of High level system architecture and Design.
• Preparation of Technical Specification Document and Mapping sheets for different modules and interfaces.
• Effort Estimation for the Development.
• Developing Data stage jobs for the migration of different modules.
• Used DB2 and SQL server Databases as Source and Target systems.
• Developing different reusable routines.
• Peer reviews for Design and Development.
• Unit testing of DS jobs and Sequences.
• Support for System Testing.

Confidential

ETL Lead Developer

Responsibilities:

• Business Requirement Analysis.
• Analyzing the business mapping rules and implementing the equivalent low level design using Visio.
• Prepared Functional specifications.
• Investigated data issues using the Investigate function in Quality Stage, standardize data using business rule sets and Match data using unduplicated functions of Quality Stage.
• Developed Data stage parallel jobs using different types of stages.
• Used Runtime column propagation for loading data into tables and unloading data into datasets.
• Running, monitoring of the jobs using Data Stage Director for checking logs and fixing issues.
• Developed and implemented Job sequences to integrate the data stage jobs.
• Prepared Unit Test Plan for unit testing of DS jobs.
• Prepared System level test cases and did system testing.
• Support for User acceptance testing (UAT).

Confidential

ETL Developer

Responsibilities:

• Developed and implemented various server jobs to perform ETL based solution for data migration into SAP, data extracted from legacy systems and People soft.
• Standardization of data using business rules and Match data using induplicate functions of Quality Stage.
• Built user defined DS routines to validate data and for some specific tasks.
• Developed jobs for the conversion of data in-line with SAP format.
• Developed Batches, sequences to integrate the data stage jobs.
• Prepared Unit test cases and System test cases and done the testing for SAP.
• Used ISMW interface for loading the data into SAP tables
• Used ABAP and BAPI plug-in stages for extraction and loading the data into SAP tables.
• Used different SAP transactions to validate the data in SAP.