SUMMARY

• Having Around 8 Years in the field of Software Quality Assurance in Data Warehouse/ETL Testing, Database Testing, Manual Testing and Functional Testing.
• Experience in Software QA and Testing Methodologies, verification, and validations in all phases of the SDLC.
• Experience in Software Development Life cycle like debugging, testing, maintenance, and designing.
• Expertise in ETL testing using Informatica Power Center with proper understanding of Data Analysis, Data Modeling, Data Warehouse/Data Mart Design, Data Conversion, OLAP data Validation, and Verification.
• Well experienced in managing defects and creating requests through documenting tools like HP ALM/Quality Center/Test Director and JIRA.
• Good Expertise in creating complex SQL scripts for Data Validation, for complex business rules based on ETL mapping documents.
• Expertise in creating Test plan documents and Test strategy documents.
• Experienced in DW projects ETL testing against DW testing with Informatica tools.
• Expertise in designing the test scenarios and scripting the test cases to test the application.
• Strong experience with ETL systems and having expertise with tools Informatica and Data stage.
• Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Good experience in writing SQL to data validation in migration as part of backend testing.
• Experience in preparing System Test Cases for S2T - Source to Target Transformation Rules
• Excellent experience in working with Quality Centre/HP ALM.
• Prepared Defect Analysis Report and Test Recommendation reports.
• Well-versed in Defect Tracking and Bug Reporting using JIRA & QC.
• Involved in writing and reviewing the test cases, execution, and validation with peers.
• Actively involved in Scrum Meetings, Sprint Planning, Retrospection & Review with the Clients and Developers.

TECHNICAL SKILLS

Software Testing Tools: Control M, Dialogue, HP ALM, HP QC 10.0, HP QTP V 10.0, Informatica - ETL jobs

Operating System: Windows - NT, Windows - 9X, XP, 20XX, Win7

Languages: C, C++, VB, VBA

Database: Oracle 9i, 11g, SQL Server

Bug Tracking Tools: JIRA, Remedy

Tools: Used: HP-QC9.2,10,11 and HP-QTP V10.0 (HP-Certified), Snowflake, Teradata Client, WinScp

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

DWH Test Analyst/ETL Tester

Responsibilities:

• EDIM (Enterprise Data Incident Management) was designed to help control and communicate data incidents( DIs) enterprise-wide, providing a centralized platform to monitor, manage and mitigate incidents. eDIM serves as AUB enterprise-wide standard tool to support tool for data incident remediation. DQC (Data Quality Control) pulls the information from eDIM on a daily basis and is planning to work capability to associate it with feed or asset.
• Worked closely with software developer/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle
• Developed Test strategy, test plan/design, execute test cases and defect management for the ETL systems
• Participating in SCRUM meetings with the Development and Product Management team.
• Validating the migration of Data from source to target system and ensure whether all transformations took place according to the mapping document and ETL Process is working as expected.
• Validate the Data between Data Warehouse and reports.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Snowflake Schema) and maintenance.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment for testing the business rules imposed on data movement.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that design meets requirements and function according to technical and functional specifications.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements.
• Involved in recording change requests on the Change Request Form (Remedy) Participated in meetings.
• Preparing test cases for data verification Compared SQL results with application results by writing SQL queries.
• Participating in SCRUM meetings with the Development and Product Management team.

Environment: HP ALM, SQL Developer, Informatica, QTest, JIRA, Autosys, Linux Server | Testing: System Testing, Win SCP

Confidential, Los Angeles, CA

DWH Test Analyst/ETL QA Test Engineer

Responsibilities:

• The Bank introduced a new Advance Notice solution leveraging the existing core banking platform to address the upcoming regulatory changes. The proposal will be to create a newAdvanced Notice Account (ANA)product which gives customers the ability to deposit funds for specific pricing, and where the funds can be withdrawn after a specified period (proposed to be 35, 60, 90 and 180 days) and priced at a different rate, depending on the Notice Period.The business will need to track, measure, and report on the usage of the new ANA product. ANA program will agree with each business group for the day to day reporting for ANA.
• Truncating values and ensuring correct data aggregations Evaluated and documented business requirements and technical specifications for Mobile App.
• Performing QA Smoke, Acceptance, Regression, Function, UI, Usability and Compatibility Testing.
• Writing Requirement Tractability Matrix (RTM) detailed Test Plan and Test scenarios.
• Participated in defect triage meetings, provide accurate report of test progress to the management team and follow up with development team on defects
• Involved in running the ETL loads in development server and developed the strategies for analyzing the data for ETL Team
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Updated the status of the testing to the QA team and SDLC team and accomplished tasked for the assigned work to the Project Management team regularly.
• Strong Backend ETL testing experience and worked in a fast-paced Agile methodology
• Involved in stand up, sprint planning, sprint demo and retro meetings for Agile methodology
• Strong usage of HP Quality center management tool for a centralized control over entire project
• Identified testing scope, risks, assumptions used to design, build and prioritize test cases and provide inputs on high level estimate for testing effort
• System coordinating with stakeholders for systems specification Analyzed user/business requirements and functional specifications documents.

Environment: HP ALM, SQL Developer, Informatica Power center, Agile, MS Office, SQL server

Confidential, New York, NY

DWH Test Analyst

Responsibilities:

• Simple Life is a CommInsure Direct Life initiative that is aimed at revolutionizing Direct Life Insurance in Australia through its simplicity of design and speed of purchase. The project will enable the business to launch a new bundle of Life Insurance benefits within a simple and transparent design by:
• Developing a simple way to communicate our propositions with customers to remove the mystique and complexity created by the insurance industry.
• Generated test cases based on the requirement document and involved in DB testing.
• Performed functional, performance and regression testing
• Involved in creating test plans, testcases, execution, peer reviews & defect reports to the project leads.
• Worked with Data management teams to run the jobs for data refresh
• Attended the Pre-UAT meetings to discuss the requirements and analyze the scope of testing.
• Providing a simple application process through online and mobile apps - the quickest in the market and minimal paper.
• Allowing customers to choose pre-set bundles of cover or choose levels of cover to suit themselves.
• Worked as QA engineer and involved in Functional Testing, Regression Testing, System Testing, Defect Triage, and Status Reports.
• Performing various functions prior to conducting tests such as data analysis and mapping.
• Conducting Quality Assurance tests for ETL process.
• Preparing test cases for data verification Compared SQL results with application results by writing SQL queries.

Environment: HP ALM, SQL Developer, Teradata Client, Informatica Power center, Agile | Testing: System Testing

Confidential, Dallas, TX

DWH Test Analyst

Responsibilities:

• GDW is only loading Personal Overdraft data from CommSee. CommSee is sending the data of the Branch Personal Overdraft application. PCE is a new Data Source for GDW which will include data of Temporary Personal Overdraft offered by ATM. PCE data is required to be loaded into GDW Integrated Model which will be able to link with CommSee and CTS data. Business Users will access Personal Overdraft data.
• Outlined how the source extract data file feeds will be managed. Including file validation, file naming convention, data validation and other service level requirements.
• Extensively worked in Functional, Integration, Regression and UAT activities
• Created Test Scripts based on the test plan document and made sure the test scripts satisfy the test requirements.
• Validated the data flow from Source to Target tables by verifying the mappings and transformations in ETL Tool, Informatica.
• Created and Executed SQL queries against the database to verify the backend data.
• Prepared detailed Test Scenarios and Test Cases in HP Quality Center.
• Worked closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle
• Developed Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems
• Developed and executed detailed ETL related functional, performance, integration and regression test cases, and documentation
• Analyzed and understood the ETL workflows developed

Environment: HP ALM, SQL Developer, Teradata Client | Testing: System Testing, Win SCP

Confidential, Houston, TX

DWH Test Analyst/ ETL Tester

Responsibilities:

• project has come in scope to build a target system to capture the Amex- Clients and their merchant level information. There are 3 different streams are capturing the Merchant level data. Amex wants to be located in one place to see the Merchant Transaction level. So they have built a platform to load the Merchant level data from 3 different sources using the Group Reference data as one more source.
• To provide a complete list of extract files produced from the source system to target and their structure including format and metadata
• To define any standard header/trailer records
• To outline how the source extract data file feeds will be managed. Including file validation, file naming convention, data validation, and other service level requirements.
• Involved in generating the Test data for test cases
• Used QC for bug tracking, reporting, and analysis.

Environment: HP ALM, SQL Developer, Teradata

Confidential

QA Analyst

Responsibilities:

• The E-Shopping System application enables vendors to set up online shops, customers to browse online, and a system administrator to approve and reject requests for new products and maintain lists of product categories. Also on the agenda is designing an online shopping site to manage the items in the shop and also help customers purchase them online without having to visit the shop physically. medical and healthcare contained.
• Designed Test Conditions by analyzing the given requirements from functional and business perspectives
• Worked with development, and business team to ensure the feasibility of design and clarify requirements.
• Performed manual testing as per the required functionality and GUI of the application
• Preparing the Traceability matrix to confirm all the requirements are covered in testing
• Involved in writing queries for back-end testing to verify the data update and validate them.

Environment: Remedy, SQL Server, CSV, HP Quality Center