SUMMARY:

• Over 10+ years of Software Quality Assurance experience in testing Data Warehouse, Web, and Client - Server Applications for Banking, Insurance, and Health care Industries.
• Strong knowledge in Data Warehouse concepts, Dimension Tables, Fact Tables, Snowflake and Star Schema, OLAP Cubes, ETL and BI process.
• Strong in testing ETL programs in written in various tools like Informatica, SAS DI.
• Writing SQL queries for full data validation between source & target at all stages of the data flow.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading. Strong back-end data validation.
• Strong knowledge of software development lifecycle (SDLC) process and methodologies including Test strategy, Test plan, Test case creation, Test execution, and Defect tracking.
• Project management, version control, and release management of multiple products.
• Strong in STLC process and Test management tools HP ALM/QC, Rational Clear Quest.
• Demonstrated excellence in creating Test Strategy, Test Plans and Test cases.
• Proficient in Agile and Waterfall methodology, Black Box Testing, System Testing, Integration & Regression Testing.
• Expertise in Bug Reports using Defect Tracking Tools like Test Director/Quality Center, Rational Clear Quest & SOAP Scope.
• Ability to prioritize tasks well and work on multiple test projects at the same time.
• Team player with good communication and leadership skills and also a self-motivated individual with analytical and problem solving skills.

TECHNICAL SKILLS:

HP Quality Center: ALM / Quick Test Pro SOAP Scope Green Hat: INFORMATICA Power Center, SAS DI/EG, ETL, OLAP. SQL, PL/SQL, Toad, STAT, Oracle, SQL Sever, DB2, Data warehouse, UNIX Shell Script, ETL, Crystal Reports, XML, Tableau, JavaScript,CSS,HTML, Webservices, SAS Base.Hadoop, HDFS, Hive, Spark, Scala, Spark SQL

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis

ETL QA

Responsibilities:

• Involved in requirements gathering and created Test Plans and Test Cases for ETL jobs.
• Tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Extensively used Informatica to load data from Flat Files to Teradata.
• Wrote UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Reviewed Informatica mappings and test cases, tested OLAP cube data against OLTP data.
• Written Test Cases for ETL to compare Source and Target database systems.
• Tested Congnos reports and verified their data in the backend Data marts.
• Wrote, updated and implemented test plans and procedures
• Wrote complex SQL queries to verify backend application data. Used Toad.
• Executed Test Cases in using Mercury Quality Center and logged defects in Rational Clear Quest.
• Participated in daily defect meetings to discussing and analyzing status of existing defects.

Environment: Informatica Powercenter 9.1, Cognos, SQL,PL/SQL,XML, Teradata, Oracle,Unix, QTP, QC/ALM, Rational Clear Quest, TOAD, Tableau.

Confidential, CT

ETL/BI QA

Responsibilities:

• Attended Requirements meetings and Created Test Cases based on Functional Specification documentation and covered all Regression, Validation and back End test cases.
• Tested SAS DI ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Validated the data in the reports by writing SQL queries in the transactional system.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Reviewed the ETL mappings to ensure the transformation rules are applied correctly.
• Executed Test Cases in using HP ALM and logged defects.
• Attended Defect calls and assigned logged defects to the associated Dev member.
• Tested Multiple Projects simultaneously based on the requirement.
• Coordinated with Project Managers, Developers and Business Analysts to prioritize the bugs.
• Good knowledge in Software Test Life Cycle and Testing Methodologies.

Environment: Informatica, SAS DI/EG, Congnos, QTP, ALM, Rational Clear Quest, SQL, Oracle 9i, SQL, Unix

Confidential, San Antonio, TX

Data QA Analyst

Responsibilities:

• Analyzed the user requirements and specifications and developed test cases.
• Involved in QA Life Cycle, which includes developing and execution of the entire QA Process.
• Conducted interviews and brainstorming sessions with Business analysts and related employees to create Test Cases/Scenarios.
• Involved in documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.
• Created Test Plans and Tests in Quality Center.
• Developed test scenarios, test cases, test scripts and gathered test data.
• Performed extensive manual testing.
• Responsible for Functional, Integration, Regression, Security and performance testing of Customer Information Management, Service Plan and Billing modules of the application.
• Developed and executed Test Cases using Quality Center using Test Lab.
• Identifying problems, prioritizing them and communicated the bugs to the developers using QC.
• Conducted performance testing of data driven Web sites, using HP Load Runner.
• Introduced checkpoints, parameterized scripts and developed data driven QTP scripts.
• Control the flow of the test by creating synchronization points and parameterization.
• Defect reporting and bug tracking using Quality Center.
• Coordinated meetings with QA Lead, Project Managers, Developers and Business Analysts to prioritize the bugs.
• Created Proof of Concept Automation scripts using Quick TestPro.
• SQL servers trace analysis to find query optimization opportunities and deadlock errors.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Certified Product on various DB Patches / DB Releases and operating system combinations
• Good knowledge in Software Test Life Cycle and Testing Methodologies.

Environment: QTP, Quality Center, Rational Clear Quest, Rational Clear Case, SOAP Scope, Test Directory, SQL, Oracle, Mainframes, Windows XP and VB Scripting.

Confidential, Arkansas

ETL Tester/QA

Responsibilities:

• Involved in creation of Test plan and Test cases from the Business Requirements.
• Validated the data flow from Source to Target tables by verifying the mappings and transformations in Informatica ETL Tool.
• Tested ETLs which are created using Informatica.
• Tested Daily, Monthly and Aggregate data reports as per business requirements to check data displayed in report matched with expected application data.
• Written SQL queries to validate data against the Reports and compare data with core application tables.
• Tested the daily Interfaces that gets the data from Data warehouse to eSAWS application.
• Created and Executed SQL queries against the database to verify the backend data.
• Prepared detailed Test Scenarios and Test Cases in HP Quality Center
• Interacted with developers in resolving the defects found in the application during testing.
• Working closely with team members to ensure status and schedules are communicated

Environment: Informatica, PeopleSoft EPM, SQL Server, Oracle QTP, Rational Clear Case, SQL, Oracle 9i, LINUX, Load Runner

Confidential, NYC

QA Analyst

Responsibilities:

• Prepared Test plans and various Test Cases.
• Involved in Developing Test Plans for User Acceptance Testing from the Business requirements documents and Technical Specifications
• Involved in defining Test objectives for the applications and performed Manual Testing.
• Involved in cross browser testing using Netscape Navigator and Internet Explorer.
• Involved in developing Integration Test Plans, System Test Plans and Performance Test Plans for the applications.
• Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing, stress testing and load testing the system
• Responsible for preparing User Manuals.
• Used Black Box Testing for working throughout Agile methodology development & test environment.
• Conducted Regression Testing of the web-based application by using Win Runner
• Developed Test Plans and Test Case design using Test Director.
• Updated, maintained, and promoted Test Scripts (UNIX shell script) for Configuration Management and version control.
• Analyzed defects status using Test Director and interacted with developers to fix defects/bugs of the application
• Developed SQL scripts on Oracle database for backend testing and performed the test

Environment: Win runner, Test Directory, Java, Oracle, Microsoft Office, Windows XP, UNIX, and SQL, PeopleSoft CRM/ EPM