SUMMARY:

• 12+ years of experience in ETL/Data warehouse Testing and Java/.Net based application testing
• Strong in developing SQL’s based on the business requirements
• Expertise in working on Data Migration, Data Mart, Master Data Management projects
• Familiar with JIRA, TM4J, Confluence, HP ALM & QC tools
• Sound knowledge on Healthcare industry (, Claims, Providers etc.…)
• Excellent knowledge in testing the End to End functionality of ETL testing, Business Object Reports and Extracts
• Widespread knowledge in building the Test Strategy & Estimates, Test Case development, Test Execution, Reporting and Regression Testing bed maintenance for ETL testing
• Ample experience in working on Agile & Water Fall methodologies
• Leading a team of 8 members, who are working in ETL testing
• Good knowledge on Software Testing Life Cycle
• Worked as Defect Manager in reporting, prioritizing and managing the software defects
• Defect Prevention anchor and Configuration Controller for a team of 15 members
• Highly flexible and adaptable contributor; adept at multi - tasking, meeting deadlines, and thriving in a fast-paced environment
• Quick Learner and Good team player with solid work ethics and Good Analytical skills

TECHNICAL SKILLS:

Domain Knowledge: Insurance (Life, Health, Mortgage)

Tools: Teradata, Toad, Infosphere Datastage, Change Data Capture (CDC), Business Objects, SSH Tectia, SQL Server & SQL Developer, Mongo DB

Defect Tracking Tool: JIRA, TM4J, Confluence, HP ALM, HP QC 10, HP ALM 11.52, IBM’s CQ, RQM

Database: Oracle 10g & 11g, AS 400, Sybase

Operating System: Windows 10, Windows 7, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Technical Manager

Tool: SQL Server, SSRS, JIRA, TM4J, Confleunce

Database: Oracle 11g

Responsibilities:

• Managing the QA Team and be a point of contact for business team
• Accountable for Requirement gathering from Business Team, study AS-IS system and develop data mapping
• Defining Test Strategy and Expectation for Test Planning for data warehouse-based development projects
• Ensuring all the aspects of ETL process from data acquisition through the various warehouse layers are covered in Test Scenarios
• Implementing and supporting of Data Extract, Transformation and Load (ETL) methods and end-user testing tools
• Understanding and helping in identifying the performance gaps and scalability of test case execution against large data systems
• Making recommendations for standardized data warehouse test tools and automated solutions
• Configuring Data Warehouse Testing tool as per the project’s requirement
• Developing standardize QA template for Test Plan, Test Summary, Test Cases and QA metrics
• Developing testing process and communicate standards and methodologies to participants in the process
• Ensuring test process are followed and test defects are managed appropriately
• Mentoring the test team, track test execution, traceability and test data
• Coordinating the triage process and ensure that all defects are documented and tracked through resolution or acceptance
• Reporting issues/defects to the project team, and follow up in issues for the assigned
• Work on gap analysis and improvement plans for team/project

Confidential, Des Moines, IA

ETL - Test Lead

Tool: SQL Server, Teradata (EDW), Mongo

Database: Oracle 11g, Sybase

Responsibilities:

• Responsible for preparing Test estimates, Test strategy & Test plan document and obtain sign off from the Business Stakeholders
• Maintain RTM and ensure no requirements are missed
• Leading a team of 3 onsite resources, 5 offshore resources
• Review and Fine tune the SQL’s prepared by the team members
• Ensure business/functional scenarios are covered
• Create test data in sources for System & UAT testing with respect to Business Requirements
• Coordinated with multiple vendors to bring the data into DB
• Responsible for ETL Jobs which used to load the data from different source systems to Development & QA Db’s (EDW, Sybase)
• Conduct defect triage meeting with Development, Project, Business team on the defects
• Prepared weekly status reports and reported it to Project team and Business

Confidential, West Sacramento, CA

ETL - Sr. Quality Analyst

Responsibilities:

• Responsible for preparing test estimates & test plan document
• Prepared SQL queries and validated the data in SQL Developer
• Verified ETL transformation logic when data loaded through different layers
• Demonstrate the stories to the clients, at the end of each Sprint and obtaining sign off

Confidential, Pleasanton, CA

ETL - Sr. Quality Analyst

Tool: SQL Developer

Responsibilities:

• Responsible for Non-Prod environments (Dev, QA & UAT) & Prod (Production & Disaster Recovery) environments testing, to ensure the data transition from Oracle 10g to Oracle 11g happened successfully
• SPOC for all the testing activities that happens in different environments
• Responsible for deriving the test strategy, testing efforts (estimates) and approach towards ETL testing
• Involved in designing the framework for automation testing
• As a Test Lead, managing a team of 10 offshore and 2 onsite resources & responsible for allocating the task to the team
• Preparing SQL queries and validating the data in SQL Developer
• Verifying the data in SQL Developer and validating, in different layers like, Target & Stage
• Responsible for presenting the deliverable to the client, with respect to the requirements
• Preparing daily, weekly, monthly status reports and responsible for presenting the projects progress to the client

Confidential, La Palma, CA

ETL - Test Analyst

Tool: Business Objects & Teradata

Responsibilities:

• Responsible for preparing test estimates & test plan document
• Prepared SQL queries and validated the data in Teradata, Toad and AS 400
• Verified ETL transformation logic when data loaded through different layers
• Responsible for verifying the data in BO reports and validating in Teradata, in different layers like Semantic, Core & Stage and source systems (Oracle, DB2)
• Responsible for test execution and defect reporting in HP QC
• Managed a team of 3 onsite resources and coordinated with multiple vendors
• Responsible for ETL Jobs which used to load the data from different source systems to Development & QA Db’s (Teradata)
• Prepared weekly status reports and reported it to Business team

Confidential

Test Analyst

Environment: Web Based Application

Responsibilities:

• Prepared Test Effort Estimation and Test Strategy document
• Handled a team of 6 members and task allocation to the team
• Reviewed the test cases, developed by the team members
• Co-ordinated with development team for system design and defect triage sessions
• Worked as a Configuration Controller for the team

Confidential

Test Engineer

Environment: Web Based Application

Responsibilities:

• Involved in analysing the Requirement, identifying the test scenarios, manage the RTM
• Responsible for preparing test cases and walkthrough with business
• Worked as a single offshore resource and handled the entire module
• SPOC for test execution and defect reporting
• Involved in management level activities such as preparing metrics report, estimation
• Direct reporting to the client, with the daily status and weekly status reporting.
• Defect Prevention anchor for the team

Confidential

Test Engineer

Environment: Web Based Application

Responsibilities:

• Responsible for analysing the requirements and identifying the test Scenarios based on the States and Products
• Preparation of Test plan with respect to Functional, Performance and Automation Testing
• Completed the project as a single resource with zero production defects
• Co-ordinating with different team from different vendors, to get the testing completed
• Bottom line responsibility for the End to End testing

Confidential

Test Engineer

Environment: Web based Application.

Responsibilities:

• Involved in identifying the key functionalities from Manual Test cases for converting into regression suite
• Holding the major responsibilities in Test execution and defect reporting
• Worked as a mentor for new joiners and guided them with the project activities