PROFESSIONAL SUMMARY:

• Over 6 Years of experience in Quality Assurance in Information Technology, involving analysis and Functional testing.
• Extensive experience in ETL/Data warehouse backend testing and Business Intelligence reports testing.
• Strong knowledge of Software Development Life Cycle (SDLC - Requirement Analysis, Design, Testing, Implementation, Support)
• As a QA Analyst - Worked on the healthcare and Airlines industry verticals.
• Knowledge in creating Test plans, Test Cases, Test Scenarios and Test strategies, Defect management to ensure Quality Assurance and to test all the business requirements.
• Experience in preparing test reports from Quality Center and prepared daily test status reports to communicate the status with the team.
• Experience in using tools: Quality Center and JIRA.
• Extensive ETL testing experience using Ab Initio (Query-IT, Control Center) and Informatica.
• Excellent knowledge of Database Systems - Oracle 12c, DB2 and SQL Server.
• Extensive experience in developing SQL scripts to validate the database tables and reports data for backend testing.
• Excellent knowledge of UNIX commands to validate the data from flat files for various test scenarios.
• Proficient in troubleshooting data issues using SQL and Ab Initio Query-IT.
• Experience in Business Intelligence testing in various reports using Cognos, Business Objects and Tableau.
• Excellent knowledge in Ms-Office (Word, Excel, PowerPoint), MS Visio.
• A very good team player with excellent communication (Verbal and technical), Presentation and Reporting skills.

TECHNICAL SKILLS:

Testing Tools: HP Quality Center 9.0/11.0(ALM), JIRA

Databases: DB2 11.1/10.5, Oracle 12c/11g, SQL Server

Utility Tools: TOAD, SQL Developer and SQL Assistant

ETL Tool: Ab Initio (Co>Op 4.0.3/3.5.3/3.2.7/3.1.7 ), Informatica 9.5.1

Reporting Tools: Cognos and Business Objects

Operating Systems: UNIX, Linux, IBM-AIX, Windows 10

Job Scheduler: Control-M, Ab Initio Control Center, Autosys

Language: SQL, PL/SQL

WORK EXPERIENCE:

Confidential (Dallas, TX)

ETL Tester

Responsibilities:

• Developed Test Plans, test scripts and executed the test scripts for the DW Project.
• Throughout the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different databases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed EL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business & management teams to understand the project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Defects Identified in the testing environment are communicated to the developers using the Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested several complex graphs, mappings and reusable transformations for daily data loads.
• Creating test cases for the jobs as per mappings and design documents
• Monitoring and using job details using Control Center in Development/QA
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data and wrote scripts to load test data to the databases.
• Scheduling and automating jobs with help of development and operations team to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL Dev/SA team and business analyst for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA Test Environment
• Extensively tested several Cognos Reports and Dashboards to validate the reports, the data and cosmetics of the report.

Confidential (Charlotte, NC)

QA Analyst

Responsibilities:

• Worked closely with business users to gather requirements, define project specifications, develop implementation and test plans for the projects & enhancements.
• Designed, created and tested reports to meet business requirements.
• Documented business workflows textually as well as in diagrams according to requirements for the stakeholder review
• Produced the visual models for the application to create use cases, state charts, sequence diagrams and activity diagrams.
• Created quarterly reports for each department in respect of their adherence to standard operating procedures and audit manuals
• Worked with EL group for understating mappings for dimensions and facts.
• Documented and maintained RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan.
• Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Maintained documentation related to difficulties, complexities and anomalies that may arise during the EL process.
• Ability to analyze the root cause of a problem and demonstrate good sense when handing the problem over to development.