OVERVIEW:

I am an ETL lead/developer with more than nine years’ experience in analysis, design, development, testing, deployment and support in Business Intelligence (Datastage - ETL). I can provide leadership, direction, support and mentoring to deliver successful Business Intelligence (Datastage-ETL) solutions. I have first-hand experience in collaborating with Data Warehouse Architects, Business Analysts and Database Administrators to define and implement ETL solutions by using ETL tools like Datastage and Informatica. I have been involved in all phases of SDLC Project development. I have good working experience of Waterfall and Agile SDLC methodologies. I can work on multi-member inter-departmental teams as well as on individual assignments. I am a result oriented, confident, quick learner, self-motivated, well organized, flexible person with dedication to successful project completion and company goals achievement.

PROFESSINAL SUMMARY:

• Over nine years’ working experience in design, development and Implementation of relational database and data warehousing applications using IBM DataStage (v8.1, 8.5, 8.7, 9.1, 11.3 and Ascential DataStage v7.5) and Informatica (v9.x).
• Complete understanding of Software Development Lifecycle and core area of experience in validating end-to-end business scenarios of B2B (Business to Business) applications, Enterprise Applications developed expertise in Datastage.
• Have good working knowledge of project implementations in Agile and Waterfall Methodology. Participated in daily scrum call, sprint planning, product backlog refinement(PBR), sprint review and sprint retrospective meetings.
• Have good understanding of Capital Market, Banking, Telecom, Asset Management and HealthCare domain.
• Worked as onshore ETL Tech Lead performing activities like coordination of Onsite-Offshore team, participating in requirement gathering sessions with Line of Business, Estimating Level of Efforts, coordination with Database Management and Release Management team, providing projects status to upper management etc.
• Good exposure to entire Software Life Cycle Phases (Feasibility, System studies, Design, Coding, Testing, Implementation and Maintenance).
• Solid skills in designing and implementing data warehouses and data marts using components like Data Warehouse Bus, Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Worked as data modeler for ETL solutions and coordinated with cross functional team like Solution Architecture, Business Analyst, System Testing, Performance Tuning and Operations team to ensure the timely and successful delivery of projects.
• Created design documentation (Technical Specification/ETL Mapping) as per business requirements by understanding Line of Business requirement.
• Experienced in developing UNIX shell scripts for file validations, to run the batch processing and summarized report of data load.
• Strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks.
• Excellent communication skills. Proactive, independent, self-managing and teamwork spirits.
• Developed complex Datastage ETL jobs.

TECHNICAL SKILLS:

ETL TOOLS:: IBM DataStage 11.3/9.1/8.7/8.5/7.5, Informatica Powercenter 9.x

DATABASE: Db2 UDB, Db2 z/OS, SQL Server, Oracle 8i/9i/10g/11g/12c, Sybase, Sybase IQ, Taradata

LANGUAGE:: T-SQL, PL-SQL, UNIX Shell Script

OTHER TOOLS/UTILITIES: EAGLE 12x, Control M, Microsoft VISIO, Erwin, HP Quality Center, Toad, AQT, TWS, Cron, Rapid SQL, SAS Data Minor

PLATFORM:: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential

ETL Tech Lead

• Attended the daily requirement session with Business to understand and document requirement.
• Prepared the functional specification and ETL mapping document based on gathered detail and explain it to offshore development team.
• Working as single point of contacts for all assigned projects performing activities like coordination, estimation, project status updates to upper management, root cause analysis, deployment support etc.
• Reviewed and signed off the code developed by offshore team, provide necessary feedback to improve the quality of product.
• Participated in daily handshake call with Client and offshore team.
• Developed complex parallel jobs using various stages like Join, Merge, Lookup, remove duplicates, Filter, Sort, Sequential file, FTP, Dataset, Column export, XML, ODBC Connector, Column import, CDC, Modify, Aggregator, XML and Database connector stages Etc.
• Created ETL Automation Frameworks to simplify the solutions which also contributed to reduce the delivery time line and budget.
• Created standard common processes like parameter set, shared container, standard frameworks which can be used across the project.
• Partnered with Admin team to configure Datastage and Database Development, System and Production environments
• Lead the daily defect review meeting from development side and provided clarifications/comments to testing team or business partners.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Actively participated in production planning, deployment and verification activities. Analyze the data after first run to make sure data quality and integrity.
• Working closely with the offshore team to ensure that the project is delivered on time on budget.
• Closely working with the ETL/DB Admin team to ensure that all Database/ETL solutions are as per industry and enterprise standards.

Confidential, Chicago, IL

Senior Datastage Developer

• Participated in daily scrum call, sprint planning, product backlog refinement(PBR), sprint review and sprint retrospective meetings.
• Worked within the team to make appropriate, effective decisions related to project responsibilities and to initiate and follow-up on assigned tasks without supervision.
• Design ETL solution by understanding the requirement from business partner. Created logical and physical data models with the help of Data/Application architecture.
• Created detailed design and ETL mapping documents for solutions designed.
• Developed ETL jobs by using IBM Datastage 11.3 to load the DataMart in batch processing. Performed thorough testing on developed components.
• Developed job sequencer with proper job dependencies, job control stages, triggers, and used notification activity to send email alerts.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Wrote Shell Scripts to check for the existence of files and to check for the actual rows as against the expected rows and implemented the script Before-After Job Subroutines
• Participated in discussion with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues in weekly status meetings.
• Prepared control M job schedules.
• Managed production deployments of ETL code and Database objects.
• Actively participated in test case preparations and executions.
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
• Extensively used stages like XML input, FTP, Modify, Difference, Oracle enterprise, Change Capture, sort, merge, join, lookup, aggregator, pivot, surrogate key generator, funnel, filter etc.
• Closely worked with ETL/DB Admin team to ensure that all Database/ETL objects are as per organization standard.
• Actively participated in production planning, deployment and verification activities. Analyze the data after first run to make sure data quality and integrity.
• Developed Store Procedures, Functions to supplement Datastage jobs to produce correct output.

Confidential, Cincinnati, OH

Datastage ETL Tech Lead

• Partner with data and business analysts to refine the business requirements that must be met for building and maintaining data warehouses/marts built on Db2/Oracle.
• Interaction with the business users and other stakeholders to better understand the requirements and design the E2E ETL solution.
• Designed logical and physical data models using best practice industry and organization data principles.
• Working as single point of contacts for all assigned projects performing activities like coordination, estimation, project status updates to upper management, root cause analysis, deployment support etc.
• Prepared technical design/ETL mapping document for ETL solution and explain it to offshore development team.
• Reviewed and signed off code developed by junior developers.
• Participated in daily handshake call with offshore team.
• Developed complex parallel jobs using various stages like Join, Merge, Lookup, remove duplicates, Filter, Sort, Sequential file, FTP, Dataset, Column export, Column import, CDC, Modify, Aggregator, XML and Database connector stages.
• Created standard common processes like parameter set, shared container which can be used across the project.
• Prepared UAT and Production migration plan.
• Lead the daily defect review meeting from development side and provided clarifications/comments to testing team or business partners.
• Addressing User issues, end to end analysis of production problems and provided resolutions for the same.
• Working closely with the offshore team to ensure that the project is delivered on time on budget.
• Closely working with the ETL/DB Admin team to ensure that all Database/ETL objects are correctly migrated for the Production deployment.

Confidential

Senior Datastage Developer

• Involved in gathering requirements, performing source system analysis and development of Datastage ETL jobs to migrate data from the source to the target Data Warehouse.
• Created Datastage jobs to extract data from OLTP to OLAP systems.
• Assisted in the creation of an enterprise operational data store and analytical data warehouse.
• Implemented full lifecycle management to capture and deploy various DataStage ETL metadata including jobs/ mapping and other data integration artifacts (such as schedulers, scripts, etc.,) across environments including the establishment of standards, guidelines and best practices.
• Worked within the team to make appropriate, effective decisions related to project responsibilities and to initiate and follow-up on assigned tasks without supervision.
• Used DataStage stages like Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Funnel, Row Generator, Remove Duplicates, Copy, FTP, Modify etc. stages in ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers, and used notification activity to send email alerts.
• Created Log Tables containing data having discrepancies to analyze and reprocess.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Wrote Shell Scripts to check for the existence of files and to check for the actual rows as against the expected rows and implemented the script Before-After Job Subroutines
• Managed production deployments of ETL code and Database objects.

Confidential

Datastage/Informatica Developer

• Served as ETL Developer contributor in the design and implementation for the client-server multi-tier solution.
• Designed, created and tuned ETL jobs/mapping to support normalized and dimensional models.
• Designed ETL jobs/mappings dealing with different data sources (SQL Server, Oracle, Db2, Sybase, Flat Files, and Excels etc) and loaded the data into target data sources by performing transformations using Datastage and Informatica ETL tools.
• Helped design and implement ETL processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Collect and link metadata from diverse sources, including relational databases Oracle, XML and flat files.
• Involved in Unit Testing, System Testing and UAT Worked with the users in data validations.
• Developed job sequencer with proper job dependencies, job control stages, triggers, and used notification activity to send email alerts.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Developed Control jobs and worked with Scheduler team to schedule the Datastage jobs to be run according to the Business requirements.
• Extensively worked on Error handling, Error validation/cleansing of data and performed lookups for faster access of data.
• Provided support and guidance by creating Release, Deployment & Operation guide documents.
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, Joiner, Rank, Expression, Lookup, Aggregate, Update Strategy and others.
• Design and develop Informatica mappings and workflows; Removed Bottlenecks to improve the performance of mappings and workflows