SUMMARY:

• Experienced Senior DataStage developer with a demonstrated history of working in the financial services and retail industry with Master's Degree focused in Computers Science.
• Over 8 + years of experience in System Analysis, Design and Development in the fields of data Warehousing, Data Integration, Data Migration and developing Client server application using IBM DataStage (8.x/9.x/11.x), Oracle, DB2 UDB and Shell scripts.
• Hands on experience in loading and maintaining large Data Warehouses and DataMart using IBM DataStage ETL processes with emphasis on ETL Life Cycle Development including requirement analysis, design, development, testing and implementation.
• 4+ years of strong working experience in Agile environment using Jira software tool for planning and creating the stories and tasks by sprint/Iteration wise.
• Very good experience in improving the performance of parallel jobs by the extensive use of Parallelism and Partitioning techniques available in ETL DataStage.
• Extensively used DataStage Client components like Data Stage Designer, Director, Manager and Administrator in Data Warehouse development. Worked with Data Migration, Data Conversion in diverged environment like DB2 UDB, Oracle and complex files.
• Having very good exposure to Scheduling tools Control - M, Autosys and IBM Tivoli Work Load schedulers.
• Involved in Performance Tuning and troubleshooting of ETL.
• Strong experience in working with complex SQL queries and Unix Shell scripting.
• Extensive experience interacting with Business Analysts, Data Modelers, DBA team, Testing Team, MDM Team, Cross-Functional, global teams and communicating project information to multiple levels in an organization.
• Technical expertise in ETL, Oracle, DB2 and having good exposure to Unix shell scripting, Control - M, Autosys scheduling and IBM Tiwoli scheduler & Reporting tools.
• Excellent analytical and logical programming skills with a good understanding at the concep

SKILLS:

Data Conversion

Data Migration database

Database Modeling

Data Model db2

Oracle

SQL

SQL Queries

Stored Procedures

UDB

Data Integration

Data Warehouses

Datamart

Datasets

Datastage

ETL

Master Data Management

MDM

Application Development

Coding

Enterprise Application

Reporting Tools

Requirement Analysis

Scripting

Shell Scripting

Shell Scripts

JIRA

Test Plan

UAT

Clarify

Life Cycle

Requirement Gathering

SDLC

System Analysis

Technical Design

Data Warehouse

Data Warehousing

AML

Linux unix

Unix Shell

Tivoli

PCM

Documentation

Documenting

Translating

Performance Testing

Performance Tuning

User Acceptance

Acceptance Testing

Credit Card

Credit Cards

Business Intelligence

Financial Services

Cash Management

Forecasting

DUE Diligence

Metrics

Consumer Products

Retail

User Acceptance Testing

Organizational Skills

Governance

Remediation

Business Requirements

Mentoring

Level Design

Brand Marketing

Retail Marketing

Detail-Oriented

Excellent communication skills

Very Organized

Highly Organized

Retail Industry

Scheduling

EXPERIENCE:

Confidential

Senior DataStage Developer

Responsibilities:

• Worked with the business partners in gathering the business needs and converted them as the requirements for the project.
• Worked with Business Intelligence team to understand the reporting needs for their analysis.
• Worked with DBA team, BARB (business analytics and Review Board) team and Info Security Governance team to create the Data Model for all the metrics we gathered as part of our requirements.
• Prepared the Data Model and Technical Design approach Document for the project.
• Participate in requirement gathering and documenting the business requirements by conducting workshops/meetings with various business users.
• Involved in preparing sprint planning (Agile methodology) for each implementation task.
• Developed parallel jobs using IBM Infosphere DataStage 11.5 version with extensive usage of various stages like Join, Lookup, Transformer, Aggregator, Sort and Datasets.
• Developed the parallel jobs effectively using the best partitioning techniques and full use of parallelism concept.
• Created extensive SQL queries for data extraction to test the data against the various databases like Netezza, ORACLE and DB2.
• Implemented the production run cycles for daily, weekly and monthly using the Control - M Scheduler.
• Involved in preparing the design flow for the DataStage objects to pull the data from various upstream applications and do the required transformations and load the data into various downstream applications.
• Collaborate with Business Analysts to clarify application requirements.
• Identify the technical cause and potential impact of errors and implement coding or configuration changes.
• Create/Update documentation for the application as and when code changes are applied.
• Participating in pre and post implementation support activities.
• Involved in Performance Tuning of long running existing process as part of on call team for permanent fixes.
• Conducted weekly status meeting with the Business/Executive team for providing the currents status of the project.
• Training & mentoring the team as and when required.

Confidential

Senior DataStage Developer

Responsibilities:

• Collaborate with Business Analysts to clarify application requirements.
• Involved in translating business requirements/functional design into High level design documents.
• Involved in the Analysis, Design and Testing of the solution/system/application.
• Developed parallel jobs using IBM Infosphere DataStage 11.5 version with extensive usage of various stages like Join, Lookup, Transformer, Aggregator, Sort and Datasets.
• Developed the parallel jobs effectively using the best partitioning techniques and full use of parallelism concept.
• Created extensive SQL queries for data extraction to test the data against the various databases like ORACLE and DB2. Implemented the production run cycles for daily, weekly and monthly using the Control-M job Scheduler. Follow procedures and standards set by the project.
• Perform structured application code reviews and walkthroughs.
• Prepare test plan and test data for assigned work, perform unit/program test and apply fixes as needed. Identify the technical cause and potential impact of errors and implement coding or configuration changes.
• Create/Update documentation for the application as code changes are applied.
• Participating in pre and post implementation support activities.
• Conducted weekly status meeting with the Business/Executive team.
• Coordinating with Business for User Acceptance Testing (UAT) and Status meetings.
• Training & mentoring new team members as and when required.

Confidential

Senior DataStage Developer

Responsibilities:

• Store MOV data elements in central repository, including retention of final verified MOV.
• Create consistent account opening processes, including the use of acceptable 3rd party verification sources and any reliance upon existing MOV data.
• Enhance defect reporting for missing / invalid MOV data elements.
• Develop consistent remediation process for MOV defects.
• Mitigate risk of fines for noncompliance of AML regulations.
• Standardize the MOV processes across all Consumer products and channels.
• Worked with the business partners in gathering the business needs and converted them as the requirements for the project.
• Involved in the Analysis, Design and Testing of the solution/system/application. Developed parallel jobs using IBM Infosphere DataStage 9.1 version with extensive usage of various stages like Join, Lookup, Transformer, Aggregator, Sort and Datasets.
• Developed the parallel jobs effectively using the best partitioning techniques and full use of parallelism concept.
• Created extensive SQL queries for data extraction to test the data against the various databases like ORACLE and DB2.
• Implemented complex SQL queries, PL/SQL Stored Procedures, to load data into Data Warehouse/Data Marts.
• Implemented the production run cycles for daily, weekly and monthly using the IBM Tiwoli Work Load Scheduler.
• Collaborate with Business Analysts to clarify application requirements. Follow procedures and standards set by the project.
• Prepare test plan and test data for assigned work, perform unit/program test and apply fixes as needed.
• Identify the technical cause and potential impact of errors and implement coding changes.
• Create/Update documentation for the application as code changes are applied.
• Participating in pre and post implementation support activities. Training & mentoring new comers as and when required.

Confidential

Senior DataStage Developer

Responsibilities:

• Requirement Analysis.
• Preparation of High Level and Low - Level Design document.
• Developed parallel jobs using IBM Infosphere DataStage 8.7 version with extensive usage of various stages like Join, Lookup, Transformer, Aggregator, Sort and Datasets.
• Developed the parallel jobs effectively using the best partitioning techniques and full use of parallelism concept.
• Created extensive SQL queries for data extraction to test the data against the various databases like Netezza, ORACLE and DB2. Created complex SQL queries, PL/SQL Stored Procedures to load data into Data Warehouse/Data Marts.
• Implemented the production run cycles for daily, weekly and monthly using the Autosys job scheduler.
• Construction of the software components in BACARDI environment.
• Performance testing and verification. Support User Acceptance testing.
• Production Implementation. Post implementation support.
• Update the project status to clients through weekly status calls.