PROFESSIONAL SUMMARY:

• Over 9 years of professional experience in Data Warehouse and Mainframe Projects with domain expertise skills in Insurance, Financial, Healthcare & Retail.
• Working as theSenior QA, experienced in analyzing Business Requirements for creating, reviewing and executing - Test Strategy, Test Plans, Test Scenarios and Test Cases.
• As the Mainframe/ETL Consultant extensively worked with QA team and business partners for building and executing test cases of all dimensions.
• Having 3 years of Experience in Informatica Power Center.
• Conversant with all phases of project Life Cycle including Requirement Analysis, Program Design, Development, Testing, Maintenance and Documentation.
• Having in-depth working experience in SDLC, STLC and Agile methodology and tools like HP Quality Center, Clarity etc.
• Conversant with all various kinds of testings like, white-box testing, black-box testing, unit testing, system testing, regression testing, integration testing, performance testing, UAT etc.
• Performed testing using Microsoft Tools.
• Having experience in testing both batch and online (eg. Webservices) testing.
• Experience in developing stored procedures, online transaction screens using IMS DC, CICS, JavaScript, HTML, and CWS.
• Good working knowledge of batch FTP processing the use of CA-7 and ESP for scheduling.
• Extensive experience in hierarchical database like IMS DB and good experience in relational database like DB2 and writing application programs with exposure to DB2 Utilities.
• Extensive experience in Risk Analysis and Impact Analysis of Project.
• Having Experience of Onshore-offshore model and Client Communications.
• Having experience on SAS and Netezza.
• Proficient Experience on working in Waterfall and Agile model and MDM Methodology.
• Having strong analytical, organizational and problem-solving skills, ability to identify operational deficiencies and design system improvements, good communication skill with individuals at all levels.
• Received Bravo s for my contribution in Confidential &B and in nationwide project.
• IBM DB2 Certified Database associate and application developer Exam 700 and 703 .

TECHNICAL SKILLS:

Operating Systems: OS390, Windows 98, XP

Databases: DB2, IDMS, IMS, Oracle

Development/Product Tools: JCL/Proc, REXX, Netezza

ETL Tool: Informatica Power Center 8.5 and 9

Programming Languages: COBOL, SAS, EASYTRIEVE, JCL, SQL

Tech services skills: QA, Maintenance, Support

Other tools: QTP, HP Quality Center, File-AID, SPUFI, QMF, TOAD,SQL Developer,Change man, CA Scheduler, ESP Scheduler, RDz

Business Verticals: Retail, Finance, Insurance

Methodologies: Waterfall, MDM (Master Data Management)

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ETL Lead

Responsibilities:

• Mainly involved in ETL design & testing.
• Involved in the ONSITE and OFFSHORE Communication for requirements gathering from the Business users.
• Setting the ETL standards for the Regions Data Warehouse
• Helped, guided and mentored dev team in Informatica testing.
• Prepared test-strategy and test-cases for testing team in major projects like Netezza/flat-file conversion.
• Data mapping, ETL Development, metadata management, data migration and reporting solution)
• Ran pilot testing projects using different new tools like DVO.
• Monitoring and tracking the applications as per the schedule run.
• Handling the user queries and tickets for Informatica applications
• Restarting/Reloading of applications run and making sure the process is completed
• Catching up for the applications and need to make sure catch up process is completed
• Analyze functional requirements provided by Business Analysts for the code changes.
• Create workflows based on dependencies in Informatica for the code changes.
• Unit test the data mappings and workflows.
• Validate the data loaded into database.
• As a MDM consultant, I was involved in interaction/co-ordination with multiple teams to help then understand the MDM methodologies.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Provide the status report for all the application monitoring, tracking status .
• Execute the test cases for the code changes.
• Mainly involved in Preparation of Low level Designs (Mapping Documents) by understanding different source systems
• Wrote validations scripts using PL/SQL Stored Procedures before transferring data from temporary table to Interface tables.

Environment: Windows 98, XP, UNIX, ZOS, Netezza, Microsoft SQL Server 2005/2008/2008 R2/2012/, Oracle 10g, DB2, XML, Informatica Power 9.1 Mainframes,HP Quality Center.

Confidential, Philadelphia, PA

ETL Tester

Responsibilities:

• Worked as an SME for MARF and PAS applications, and performing Requirement Analysis, QA and modification of existing modules as required.
• Involved in Round the clock Production support activities for business applications - Base load, Bureau and PAS Producer Admin System etc applications.
• Involved in preparing Technical Design specification based on the functional specifications.
• Was responsible for weekly/monthly review, testing and implementation of all offshore source codes into the production system.
• Experience in integration testing, system testing, and User Acceptance Testing (UAT).
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using DataStage and SSIS.
• As a lead of the Process Improvement team, I am involved in creating and mentoring new in-house tools for simplifying process and saving effort for the team.

Environment: Informatica Power center, COBOL, Microsoft SQL Server 2005/2008/2008 R2/2012/JCL, DB2, SQL, Easytrieve, CICS, VSAM, QTP, HP Quality Center, Netezza, ESP Scheduler

Confidential

ETL Tester

Responsibilities:

• As a senior member of the team, I had been working with POS QA team, wherein I have been working in all kinds of System testing.
• Involved in requirement analysis, test-case preparation and validations.
• Involved in end to end testing and verification of change requests which included extensive client interaction.
• Involved in mentoring new team members for educating the testing and quality assurance policy procedures.
• Experience in integration testing, system testing, and User Acceptance Testing (UAT).
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using DataStage and SSIS.

Environment: COBOL, JCL, HP Quality Center, IBM Clearquest, VSAM

Confidential

Mainframe ETL Tester

Responsibilities:

• Worked in the design, implementation and verification phases of many work-orders of the project with no technical supervision.
• Using SAS for creating customized extraction and reports for customer from various flat files with huge data.
• Tested ETL Mappings and flow of data from Source to Target
• Tested the load process of ETL to make sure the data is populated according to the specified data transformation rules.
• Was among the 3 trainers (for business process and technical) for all new joiners in the project.
• Had done 6 process improvements to save costs and enhance quality of delivery.
• Was involved in requirements gathering, estimation, coordination with team members and negotiation on time team used to work under very critical SLA and stringent timelines

Environment: JCL, COBOL, CICS, DB2, SQL, SAS, Easytrieve

Confidential

Mainframe Tester

Responsibilities:

• Worked in the maintenance and development phase of the project.
• Being part of the most complex ‘Distribution and Procurement’ module, we developed some new modules and modified existing functionality with limited supervision.
• Analysis of programs and Documentation.
• Coding through implementation for requests to add new features to the existing functionality.

Environment: JCL, COBOL, IDMS/ADSO