SUMMARY

• Seasoned technology, Data warehouse Automation, strategy and management expert with over 13 years of extensive experience and dedicated to managing large scale, complex implementations across a multitude of industrial experience not limited to Financial and Banking Services, Insurance, Reinsurance, Healthcare, Telecom,

TECHNICAL SKILLS

Data Warehouse: Automation Testing, ETL and Data Migration

TestingETL: Testing using Abinitio, Informatica Power Center, SSIS, SAP BODS

RDBMS/ Database: Oracle 9i/10g, TOAD 10.2, Teradata 8.1 SQL, MS SQL Server

Functional testing tools: QTP 11.0,HP ALM 11.0

Agile/Scrum methodology: Testing (DW/BI)

Data warehousing: SAP BW/BI, BEX Query Designer, BEx Analyzer, Web reports, Erwin Data modeler

PROFESSIONAL EXPERIENCE

Test Manager

Confidential - NJ

Responsibilities:

• Experience in creating Business Requirements, Functional Specifications, Mapping Documents, Test Plans, Test Scripts, Status Reports, Defect Report, and Test Completion report, Traceability etc.
• Proposed and implemented full table data automation framework by using SQL and stored procedures
• Ability to get integrated with data load script and hence can be scheduled during/after daily data load
• Preparing Test Plan, Test Strategy and Test Estimation for DW/ETL requirements
• Validating the source and Target data, Transformation in BW system After ETL
• Reusable automation framework that can hold one/more projects or can be maintained for individual projects.
• To Create EDW script and run/test multiple times.
• Use as regression test when there is a need.
• Managing multiple project like ABL - Asset based lending, FATCA etc.
• Maintaining a highly detailed plan and obsessively caring about the progress on it
• Responsible for analyzing and realizing business requirement of DW/ETL. It Includes coordinating with business Analyst team on all the requirements and understanding it and report the offshore testing team
• Preparing Test Plan, Test Strategy and Test Estimation for DW/ETL requirements.
• Interacting with the customer and end users to understand clearly about their business needs and expectations.
• Responsible for gathering technical requirements of DW/ETL Interfaces
• Responsible for coordinating with the subsystem owners, technical team and Development team to understand the functionality of subsystem and report to offshore testing team.
• Participating in design and code walkthrough to understand the impact of the new DW/ETL enhancements for upstream to DART and down streams systems.
• Providing Test plan or strategy walkthrough of DW/ETL projects to all project stakeholders.
• Alignment of Test strategy with business objectives of the project constructed.

Associate Consultant (Test Manager)

Confidential

Responsibilities:

• Involved in the creating test data in FSRI application(OLTP)
• Validating the source and Target data, Transformation in BW system After ETL
• Validating Adchoc reports using BEx query designer
• Verifying the SAP BI portal reports includes GUI, data, format and structure of the report
• Involved in extensively with BEx Query Designer, BEx Analyzer for developing reports, analysis, and Web reporting
• Involved in the Migration testing of Legacy system to SAP FSRI system
• Validating the Source and Target data using SQL queries(Toad)
• Involved in the verifying the Data mapping from Legacy to Target
• Review Business requirements, IT Design documents and prepared Test Plans for all assigned project releases
• Creating Test Approach and Test Estimation using STP(Service Test point) method for the SAP BW CRs
• Mentoring, task allocation and monitoring, Staff Management Activities for the team

Confidential

Responsibilities:

• Validating Extraction, Transformation and Loading were performed using Abinitio GDE to build the Data warehouse using business transformation rules.
• Involved in the creation of logical and Physical test specification.
• Involved in creating the ETL Transformation Rules and Mapping Specification documents
• Involved in creating Reporting Requirements documents attending the design related meetings.
• Translation of business requirements to technical test plan and communicating with the on-site client manger.
• Validate and priorities the requirements based on Moscow
• Preparing Test Plan, test estimates, new test metrics and producing it to the audit team for internal audit purpose

Confidential

Responsibilities:

• Validate ETL process to transfer and clean data from various sources to Data warehouse and Data Mart
• Involving in validating of Data modeling basing on the requirements using ERWIN and maintaining of Different versions on data models of all of the Subject Areas
• Data mart testing by writing logical and Physical complex query
• To create the ETL Transformation Rules and Mapping Specification documents.
• Defect management activity using HP quality center
• Recruiting team members and Training the team members
• Preparation of Test plan, Test summary report and status report
• Defining the testing process and procedural document
• Estimation of project work
• Perform activity like coordination with onshore team member and client

Confidential

Responsibilities:

• Automated test script preparation, Test execution, Bug Reporting.
• Involved in peer review of test cases/automation test script.
• Giving training to the New Joiners on automation.
• Perform review on test script in to VM (Version Manager)
• Updating Daily status Report and Weekly Report

Testing Engineer/Senior Test Engineer

Confidential

Responsibilities:

• Involved in the writing, reviewing and execution of testcases
• Involved in Manual testing like Functional, GUI and Regression Testing, Compatibility Testing and Installation Testing
• Reporting Defects in to Bug logging and Tracking Tool Through VPN
• Prepared test Summery Report and uploading reports to clients through FTP
• Involved in the activity of managing defect and review