PROFESSIONAL SUMMARY:

• Over 9 years of IT experience (1.9 yrs in USA) in Analysis, Design, Development and Implementation and Testing of software applications in data warehousing and Client/Server applications in the business domain of Retail, Banking, Pharma and Insurance services.
• It includes around 8+ years’ experience on Data Warehousing Tool Confidential - Confidential DataStage 8.1, 8.5 and 9.1. One Year of ETL testing on Business Objects Data Integration ETL tool.
• Proficient in all phases of software development lifecycle, coherent with Performance Tuning, Unit Testing, System Testing, User Acceptance Testing.
• Experience in leading teams, Handled multiple roles - Project Lead, Senior Release engineer, Senior Developer, Support Engineer and Technical coordinator.
• Experience in leading the team of 9 and ensuring the delivery happens on time with the best quality and least defects.
• Enthusiastic about new advancements in Data Warehousing field and constantly strive to keep myself updated by implementing POTs.
• Experience in working in Dimensional Data modeling, Star Schema modeling, Snowflake modeling, Fact tables, Dimension tables, OLAP, Query Intensive database designs, Performance tuning.
• Have excellent knowledge of DataStage (ETL) and Oracle and Sound knowledge of database/code performance tuning and UNIX and testing all kinds of ETL coding.
• Designed, tested and migrated DataStage jobs from Development System to Test System and then to Production System for Operational Data Store and Data Warehouse.
• Created master sequence in DataStage to run jobs /exception handling/ email notification etc which basically controlled the number of job runs in the server, success/failure reports etc.
• Involved in providing production support to various Data warehouse projects and Extensive experience in ETL source to target mapping.
• Experience in designing Job Batches and Job Sequences for scheduling server and parallel jobs using DataStage Director, UNIX scripts.
• Involved in creation of ETL development standards, version control procedures, code migration standards as a member of Technical oversight committee advocating best practices with emphasis on adherence to standards.
• Excellent technical writing skills with hands on experience developing Functional Specifications, Business Requirements, Test Plan, Test Cases, Test Status Reports
• Experience in using testing tools and Job scheduling tools.
• Skilled in planning, coordination, and execution of applications and a Proficient in writing technical documents, presentations and presentation skills.

TECHNICAL SKILLS:

Data Warehousing Tools: Confidential Confidential DataStage 9.1 8.5, 8.0.1, 7.5., BODI, QlikView 12.0

RDBMS: Oracle 11g, SQL Server, DB2, Teradata, SQL plus

DBMS Tools: TOAD, Oracle SQL Developer, Teradata SQL assistant, DB2-QMF for windows.

Other Tools: Putty, HPALM / HPQC, AnthillPro, Microsoft Project.

Versioning Tools: VSS, Power, Team forge, Tortoise SVN

Scheduling Tools: Mainframe - CA7.

Operating System: Windows, UNIX

Business Domains: Retail, Healthcare, Banking, Insurance & Pharma

Domain s: HIPPA (Health Insurance Portability and Accountability Act)

PROFESSIONAL EXPERIENCE:

Confidential

Environment: UNIX

Skill/Tools: Confidential DataStage 9.1b, Oracle 11g, SQL plus, UNIX, HPQC, Mainframe QlikView 12.0, Microsoft Project.

ETL Program Lead

Responsibilities:

• Responsible for leading a project team of 10, in delivering application to customer in the Insurance sector.
• Responsible for analyzing requirements and reviewing estimates
• Reviewing L0, L1 and L2 estimates for the projects.
• Preparing Timelines and Mitigation Plan for the assigned tasks to team.
• Participating in requirement Walkthrough meetings with team and Client.
• Reviewing ambiguities for Business Requirement & Functional Requirement docs and log into QC.
• Reviewing in Test Plan preparation.
• Reviewing the MTP (Master Test Document).
• Participating MTP Peer walk through and Business walk through meetings.
• Reviewing test Scenarios and test cases based on the requirements.
• Participating in Test Scenario and Test case Walkthrough meetings with Business Team.
• Tracking defects encountered during testing.
• Reviewing defects in QC and classifying them based on the severity.
• Participating defect triage meetings and participating in team reviews.
• Attending relevant programs.
• Responsible for team.
• Reviewing status reports, sign off documents.
• Leading UAT support and signoff reports to the end of the project.
• Delivered for all the apps with above 95% DRE (Defect Removal Efficiency) into UAT and PROD
• Responsible for effective communication between the team and the customer/business.
• Providing day to day directions to team and updating project status to the customer.
• Followed agile development process and completed testing within the scheduled release date.
• Participating in Triage meetings with client regularly to discuss about defects and prioritize them.
• Scheduling & chairing bi - weekly scrum calls, focusing on targets & s.
• Ensuring daily and weekly status updates to client in time.

Confidential

Environment: UNIX

Skill/Tools: Confidential DataStage 9.1, Oracle 11g, Teradata SQL Assistant, DB2 (QMF for Workstation), UNIX, Anthill Pro, Power, Team forge. Tortoise SVN, HPALM Mainframe - CA7

Senior Data Specialist/Team Lead/ Production Support lead

Responsibilities:

• Participating in technical and functional discussions with design leads and other technology team members to discuss on new functionality or design changes.
• Attending DIT /PERFORMANCE/ SIT/ UAT status meetings with Confidential management and design leads and providing the status for all works assigned.
• Being a senior DataStage resource at onsite in the project, I am responsible to take care of all
• DataStage issues during DIT, PERFORMANCE, SIT and UAT environments and also resolving critical showstoppers in time in order to continue batch flow.
• Working with offshore team and delivering all deliverables in time with good quality and providing all functional/technical clarifications to offshore team required to complete the works assigned.
• Attending offshore and onshore status meetings along with offshore/onsite Managers.
• Providing analysis and root cause analysis for the jobs failed in batch flow.
• Implementing all new changes due to changes in other dependent project data scenarios and functionality.
• Analyzing defects found in QA testing and providing solution or analysis on requirements.
• Responsible for check-in latest code in POWER and AnthilPro, SVN Tortoise and building the package for deploying the code to development environment and unit testing.
• Responsible for submitting trackers in Team forge to migrate the latest code to test environments like DIT, PERF, SIT and UAT
• Responsible for reviewing code changes, HPQC/HPALM defects analysis and updating, reviewing offshore team’s work/code before sending to design lead review or migration to test environments.
• Involved in analyzing performance of DataStage codes and providing best performance improvement solutions and attending meeting with performance team.
• Lead a team of 6 members during the ETL design and construction phase.
• Co-ordinate with Business users to understand the business needs, metric and reports in Retail Industry.
• Worked extensively on Production support as well.
• Best practices and coding standards were applied during construction phases
• Implemented Slowly Changing Dimensions.

Confidential

Environment: UNIX

Skill/Tools: Confidential DataStage 8.5, 9.1, Oracle, SQL Server & UNIX, Anthill Pro, Power, and Team forge.

Team Lead / Senior Release Engineer

Responsibilities:

• Responsible for leading a project team in delivering solution to customer in the Retail sector.
• My focus is Deploying the code, Providing support for testing team, Loading test data to
• Creating and running several diagnostics jobs for environmental health checkups.
• Executing scripts for data population and validation.
• Developed solutions on code leveling among several QA projects and PROD projects.
• Created Play-book which includes all the architectural design of the project and processes of Release Management.
• Providing solutions on the fly for SIT, UAT batch defects.
• Deliver new and complex high quality solutions to clients in response to varying business requirements
• Handling the planned production releases, creation of change request’s, attending meeting with clients for approvals on the releases .
• Responsible to bring up new environments for batch execution
• Responsible for configuring items and involved in leading the team to own the changes till production.
• Responsible for effective communication between the project team and the customer.
• Provide day to day direction to the project team and regular project status to the customer.
• Confidential customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.

Environment: creations for test environments, Handling of Production releases Extensively used DataStage 8.5, 9.1 (ETL) tool in order to accomplish optimized Confidential for Walmart.

Confidential

Environment: UNIX

Skill/Tools: Confidential DataStage 8.5, 9.1,Oracle, SQL Server & UNIX, Anthill Pro, Power, Team forge.

ETL Specialist/Team Lead/ Production Support

Responsibilities:

• Interacted with the Client’s Business analyst and Technical architect during the design and development phase.
• Converting the design into well-structured and high quality DataStage jobs.
• Performance tuning activities.
• Updating Technical design documents.
• Analyzing and fixing DIT, SIT and UAT defects.
• Best practices and coding standards were applied during construction phases
• Peer Review of test cases and execute the test cases.
• Providing Test support, If need arises
• Delivered the code with high quality to the Client

Confidential Nutrition

Environment: UNIX

Skill/Tools: Confidential DataStage 8.5, Oracle, SQL Server & UNIX

ETL Specialist

Responsibilities:

• Leading elective enhancement team.
• Converting the design into well-structured and high quality DataStage jobs.
• Responsible Enhancements effort estimation.
• Performance tuning activities.
• Analyzing and fixing DIT, SIT and UAT defects.
• Updating HLD and Technical design documents.
• Creation of TDS (low level design) document
• Preparing the Unit Test Cases
• Timely execution, analyzing and reporting of any ad-hoc requests for generating reconciliation reports which are critical in determining migration Confidential decision.
• Best practices and coding standards were applied during construction phases
• Peer Review of test cases and execute the test cases.
• Delivered the code with high quality to the Client

Confidential

Environment: UNIX

Skill/Tools: Confidential DataStage 8.5, Oracle, SQL Server & UNIX

ETL Specialist

Responsibilities:

• Converting the design into well-structured and high quality DataStage jobs.
• Performance tuning activities.
• Timely execution, analyzing and reporting of any ad-hoc requests for generating reconciliation reports which are critical in determining migration Confidential decision.
• Worked extensively on UNIX for handling the Operation Reconciliation engine.
• Catered to any run-time issues which directly impacted the Production dry runs and Critical Business Testing Cycles.
• Updating Technical design documents.
• Analyzing and fixing DIT, SIT and UAT defects.
• Best practices and coding standards were applied during construction phases
• Peer Review of test cases and execute the test cases.
• Performing unit testing, integration testing by using - Negative testing
• Delivered the code with high quality to the Client

Confidential

Environment: UNIX

Skill/Tools: Oracle 9i, BODI, UNIX

ETL Developer and ETL Tester

Responsibilities:

• Involved in Analysis, Design and Development of this project.
• Involved in development of BODI jobs
• Unit Testing.
• Defect Fixing
• Involved in ETL testing activities.