SUMMARY

• 8 years of experience in IT industry in Testing, Analysis, Design & Implementation of various Data Warehousing/ETL Projects.
• Experience in all phases of ETL testing, including Requirements Specifications Analysis, Performing Unit, Functional, Integration, System, Configuration, Regression, GUI and Acceptance Testing.
• Good Exposure in ETL test management, test Designs, Requirement Analysis, Estimation.
• Experience in creating ETL Test Strategy, Test Plan, Test Metrics, Test Summary Reports, Test Cases, Test Execution Results and Test Summary based on the Business Requirement and Mapping documents.
• Extensively done Data Centric Testing (data testing requiring data to be moved, copied from source to target systems correctly and completely, Checksum comparison, checking quality of data)
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio tools.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in BFSI (Retail Banking and Insurance Sectors) and Energy Domain data warehouse projects.
• Experience in working with large business critical projects with offshore vendors.
• Hands-on experience in AS400 with RPG programming.
• Excellent ability to maintain and develop AS400 applications using RPG Integrated Language Environment, Screen Design Aid, Reports using Report Layout utility and Subfiles.
• Well experienced in supporting data extr Confidential ion, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Good experience in Data Modeling using Star Schema and Snow Flake Schema.
• Experience with various scheduling tools like Autosys and scripts using Unix.
• Good analytical and presentation skills.
• Ability to successfully handle multiple tasks independently as well as effectively in teams.
• Excellent Communication, Client Handling, Interpersonal, problem solving and time management skills.

TECHNICAL SKILLS:

Operating Systems: Windows7, Windows XP, OS/400, UNIX

Databases: DB2,DB2/400, Oracle9i, My Sql Server, Greenplum

Tools: Ab Initio GDE 1.14, 1.15 , Informatica 7.1.1, , Toad, PgAdmin, Microsoft Excel, Microsoft Access, VB Script Macros , HPQC, ISDB, Subfiles, Smart400, Implementer, Autosys, Mainframe

Languages: RPG, RPGLE, CL, CLLE, Cobol, SQL, PostgreSQL

Domain Knowledge: Insurance, Banking (Commercial Loans) and Energy

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles

Role : QA Lead

Confidential main objective to build an interface between the two banks Bank of Tokyo Mitsubishi(BTMU) and Mitsubishi UFJ Financial Group(MUFG) which will provide the required data to BTMU. The Global Zeus project will align and submit Union bank data like credit, trade, deposit and customer data to BTMU on daily basis and will establish an automated data interface between MUFG and BTMU management Information system.

Responsibilities:

• Involved in requirement analysis, design, build and test.
• Lead testing effort of this project by coordinating with developers, business analysts and end users on design specifications.
• Lead and coordinated testing Confidential ivities with offshore team by arranging BRD walkthroughs, reviewing test cases and defects analysis.
• Prepare Test Plan, Test Strategy based on the Business Requirement Document.
• Development of Test Scenarios ,Test Cases and maintain Traceability Matrix
• Analyze & review Informatica mapping, technical implementation of business rules.
• Involved in test data setup Confidential ivities coordinating the creation of test data in Greenplum, DB2, Oracle, SQL Server and files as per the need of the project.
• Designed and developed advanced SQL queries to extr Confidential , manipulate, calculate information to fulfill data and reporting requirements
• Extr Confidential ing data from mainframes using file aid utility to compare with data coming from Greenplum database.
• Used HPQC to create test cases, execute them and log all defects.
• Daily status reporting with test Confidential ivity and metrics report
• Involved in Defect Review meetings with Business Team and Developers.
• Prepare executive summary of test progress and project updates to PMO and senior mgmt.
• Conduct Go/Go-No and Signoff on release with Dev, LOB teams.

Environment: SQL, HPQC 9.0, MS Excel, MS-Office, Oracle, SQL Server, GreenPlum, Unix, Mainframe, Informatica 7.1

Confidential, Jean Martin, New Jersey

Role : Sr QA Analyst

Description:

Confidential is in energy and utilities (E&U) space. The solution is targeted for the alternative energy generators to manage, control and monitor the production and remote devices using various advanced tools and technologies. The solution is committed to serving energy providers with innovative approaches to renewable energy generation – smart, sustainable, reliable and efficient. By combining the power of distributed solar energy solutions with a smart grid communications infrastructure we create a unique product for the utility market. The project would be executed in three phases of development and implementation to realize associated value frames and services within entire value chain.

Responsibilities:

• Analysis of the functional requirements and detailed design specifications.
• Preparation of ETL Test Environment & Test Data set up/configuration
• Documented the validation rules, error handling and Test Strategy.
• Development of Test Scenarios, Test Cases and prepare Traceability Matrix.
• Conducted review sessions for the Test cases with the BA and Developer.
• Checking ETL Transformation logic by using SQL Query.
• Created Test input requirements document.
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing and Regression Testing.
• Validated the data flow from Source to Target tables by verifying the mappings and transformations in ETL Tool.
• Participating in various meetings for Enhancement and Modification Request of applications, following the client requirements
• Using black box testing approach to verify features and functionality of the application
• Detected and reported defects
• Responsible for communicating Defect Status Reports in project meetings with Business Team and Developers.
• Experience testing SCD Type 1, Type 2 & Type 3 tables verified history load and incremental data
• Creating and submitting test results: test Confidential ivity reports and metrics report
• Created and Developed Reports and Graphs using ALM.
• Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
• Prepared the Project Completion Report.

Environment: Informatica 7.1, SQL, HP/Mercury Quality Center 9.0,MS Excel, MS-Office, Oracle9i, Unix, Autosys

Confidential, New York

Role : Sr. QA Analyst

Description:

Confidential program outlines the Operational Data Store for Policy and policy trans Confidential ion for Life, Disability, Retirement Services, Group and Park Avenue Securities requires for Distribution compensation calculations, reports and statements. The Operation Data Store sources data from multiple enterprise trans Confidential ional data stores, cleanse the data received and validates the integrity of the data and transforms into consistent format.

Responsibilities:

• Played Confidential ive role in requirements gathering with the business analysts.
• Using black box testing approach to verify features and functionality of the application
• Analysis of the functional requirements and detailed design specifications
• Preparation of ETL Test Environment & Test Data set up/configuration
• Development and execution of the ETL Test Scenarios and ETL Test Cases to verify the expected results
• Creation of Traceability Matrix to ensure comprehensive test coverage of requirements, identify all test conditions and test data needs
• Document software defects, using a bug tracking system, and report defects to software developers and monitor bug resolution.
• Identifying field and data defects with required information in ETL process in various mappings and one to one mapping.
• Creating and submitting test results : test Confidential ivity reports and metrics report
• Participating in various meetings for Enhancement and Modification Request of applications, following the client requirements
• Inter Confidential ing with developers, business analysts to discuss technical problems and bug reporting
• Giving signoff to UAT team

Environment: SQL, Toad, MS-Office, Oracle 9i, HP/Mercury Quality Center 9.0, Informatica 9.0.1, Unix

Confidential, Capital One, Richmond

Role: QA Analyst

Description:

Confidential is an application which provides debt management services to consumers.The cardholders directly inter Confidential with the credit counseling agencies, which in turn send Confidential proposals to the Vendor and send back messages to the agencies. If the proposal is accepted, the customer receives a letter that states the conditions of acceptance of the proposal, which includes the required monthly fixed payment.

Responsibilities:

• Involved in regular discussions with the business analyst to gather the requirements.
• Documented business requirements, discussed issues to be resolved and translated user input into ETL design documents.
• Developed ETL test cases for business and user requirements to perform System and Integration testing.
• Schedule walk through to ensure that all changes if any, to the service being tested are covered in the test plan. This process includes the updating of test scenarios and the type of data required to properly test those scenarios.
• Gather test data in order to test all scenarios based on the test cases laid out in the test plan.
• Validated Error messages and error logs.
• Checked ETL Transformation Logic according to the business rules.
• Developed separate test cases for ETL process for verifying Inbound feeds from various systems and Outbound feeds to various regulators
• Defects were Tracked, Reviewed, Analyzed and compared using Mercury Quality center.
• Confidential ively participate in team meetings to discuss the progress of testing
• Final Signoff on the Test items on Each Release Basis
• Attended daily defects status meeting with Developers and Management to explain the nature of defects.
• Post Implementation support.
• Coordinating with the offshore and onshore teams.

Environment: SQL, Ab Initio GDE 1.15, Co>operating System 2.15, Oracle 9i, Unix, MS-Office

Confidential , Jean Martin, New Jersey

Role : QA Analyst

Description:

Confidential is in energy and utilities (E&U) space. The solution is targeted for the alternative energy generators to manage, control and monitor the production and remote devices using various advanced tools and technologies. The solution is committed to serving energy providers with innovative approaches to renewable energy generation – smart, sustainable, reliable and efficient. By combining the power of distributed solar energy solutions with a smart grid communications infrastructure we create a unique product for the utility market. The project would be executed in three phases of development and implementation to realize associated value frames and services within entire value chain.

Responsibilities:

• Analysis of the functional requirements and detailed design specifications
• Preparation of Test Environment & Test Data set up/configuration
• Development and execution of the Test Scenarios and Test Cases to verify the expected results
• Using black box testing approach to verify features and functionality of the application
• Detected and reported defects
• Created Test input requirements document for ETL design document.
• Creating and submitting test results: test Confidential ivity reports and metrics report
• Validated the data of ETL reports by writing SQL queries.
• Exclusively worked on ETL test case scenarios and test cases with business functionality for business users.
• Participating in various meetings for Enhancement and Modification Request of applications, following the client requirements
• Inter Confidential ing with developers, business analysts and end users to discuss technical problems and bug reporting

Environment: Informatica 7.1, SQL, HP/Mercury Quality Center 9.0,MS Excel, MS-Office, Oracle9i, Unix, Autosys

Confidential, Illinois

Role : ETL Tester

Description:

The Confidential is a database containing claim information. Its intended use is to allow end users to easily run queries, create reports, and perform analysis on claims data. Confidential contains claim information at the claim, claimant, coverage and payment levels. The main source of data provides the detail claim as well as the paid, reserve, and valuation amounts.

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements
• Prepared ETL test plans for data manipulation tool to test business logic
• Prepared demo reports to test functionality tool by writing creating dummy tables.
• Tested entire application manually by using test plans and demo reports.
• Performed ETL test scenarios by writing SQL scripts with consideration of Business scenarios.
• Experience in creating UNIX scripts for sending mails if any issues.
• Analyzed and helped in modifying the Use Cases and created the Test cases based on them.
• Used Quality center to track, analyze and document defects.
• Reproduced all errors found and provided detail documentation like screen shots
• Attended daily status meetings with Project management on testing update.
• Conducted User Acceptance testing (UAT) to validate the application, to check that the application properly reflects business functions and requirements
• Tracked, Managed and documented problems during UAT.

Environment: SQL, Mercury Quality Centre, Ab Initio GDE 1.15, Co>operating System 2.15, Unix, MS-Office

Confidential, Confidential

Role: Ab Initio Developer

Description:

Confidential, is to prove that multiple databases can be merged in to a single database and it works as per the expectations. It has started with three countries into one single database. This is an Integration project in which we are aiming to merge databases of small countries. Merging the data bases will have a huge imp Confidential on the business as any new technical as well as Functional up gradation will be cost effective for these sites.

Responsibilities:

• As an ETL Designer and Developer, was responsible for inter Confidential ion with client and analysis of the specifications provided by the client.
• Participated in data model (Logical/Physical) discussions with Data Modellers and created both logical and physical data models.
• Developed number of graphs and Transformations to facilitate both regular and one time Loading of Data.
• Extensively used Reformat, Rollup, Lookup, Join, Partition by key, Gather, Merge, Run program, Scan, Input File, Output File, Input Table, Output Table components for creating the graphs.
• Tested the graphs by Unit testing, and Integration testing.
• Ensure adherence to quality procedures and coding standards
• Created wrapper scripts for scheduling jobs
• Used Ab Initio EME (Enterprise Meta>Environment) to promote graphs from Development to UAT and then to the production environment.
• Handled Implementation and Release Confidential ivities.
• Provided 24x7 Production Support for ETL jobs for daily, Monthly schedule.

Environment: Ab Initio GDE 1.13, Co>operating System 2.13, Unix, My SQL, DB2, Oracle, Autosys

Confidential , Confidential

Role : Software Engineer

Description:

Confidential aims at design of software, which supports Bankruptcy proceedings. The design involves maintenance of trans Confidential ions related to accounts, checks, claims, creditors, and debtors, disbursements, ledgers maintenance and payments. The issues concerned in the design of the above f Confidential ors are, such as co-relation of the data in the situations of the disbursements where the debtor will typically wire the total amount to be disbursed and checks will be issued to creditors. From there the check can be stopped, returned, reissued, refunded etc.

Responsibilities:

• Reported to the team lead and involved in Application Design, Coding and testing.
• Analysis of the specifications provided by the client
• Responsible for preparation of unit test plans as per the design of the application.
• Testing - unit testing & integration testing
• Coordinating with offshore team and onsite coordinator

Environment: SEU, RLU, DFU, PDM, SDA, ISDB, Smart400, Implementer, Mercury quality Centre, OS400, RPG, RPGLE, COBOL, CL, DB2400