SUMMARY

• Over 7+ years of Software Quality Assurance (QA) experience testing Data Warehouse, Database (ETL), Web and Client - Server Systems and Applications for Banking, Insurance and Financial Industries.
• Work experience reviewing and testing of data maps between various legacy systems and relational databases.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Having good experience in writing test scripts using VB script.
• Extensive experience in testing and reviewing of dimensional modeling (Star and Snow flake) of data warehouse
• Extensive Experience in Database and ETL testing and BI Intelligence reports testing.
• Experience in Business Intelligence testing in various reports usingCognos,Business Objects.
• Expertise in Quality Assurance methodologies like Waterfall, Agile, SCRUM
• Extensive experience in creating, tracking and retesting defects using Bug tracking tools such as ALM / Quality Center, RTC and Star team
• Experience in designing, documenting, and executing test plans, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact wif databases
• Having good experience in Functional, Unit, Usability and Regression Testing.
• Expertise in Test Automation of various applications using automation tools like Quick Test Pro (QTP) / UFT
• Having good experience in QTP (descriptive programming, OR creation & maintenance).
• Involved in designing and implementation of Test Automation Framework.
• Good Experience in Mobile Device Testing using IPhone, IPAD and in devices wif OS like IOS7/6 and Android.
• Experience in testing teh Mobile Applications through Perfecto Mobile.
• Expertise in automating teh Mobile Applications using UFT through Perfecto Mobile.
• Good Knowledge in Selenium
• Having experience in testing Web services using tools like SoapUI and HP Service test.
• Having good knowledge in Performance testing using tools like HP Load Runner.
• Hands-on experience and strong understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Defect Life Cycle.
• HP Certified Professional - Quick test professional & Quality Center
• Experience in working wif Offshore - Near shore (Mexico) and Onsite model.

TECHNICAL SKILLS

Testing Tools: Test Management Tools

Web Service Testing: ETL Tools

Operating Systems: QTP 9.0/9.2/9.5/10.0/11, UFT and Selenium.

ALM/Quality Center, RTC and Starteam: SoapUI and HP Service Test

Data Stage, Informatica: Win XP/2000/NT.

Languages: C, C++, Java, SQL, PL/SQL, VB Scripting, Unix

Databases: Oracle 9i/10g/11g and DB2

PROFESSIONAL EXPERIENCE

Confidential

ETL QA Lead/ETL QA

Environment: Informatica Power Center 9.5.1(Power Center Designer, workflow manager, workflow monitor, Repository Manager), HP Quality Center, Visual Basic, DB2, Oracle, Toad 11.6, SQL, PL/SQL, UNIX, Quick Test Pro, Windows 7, HP.

Responsibilities:

• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring dat an appropriate level of application quality was maintained at all times.
• Created Test Strategy and Test Plan documents.
• Defined Entrance / Exit criteria and provided continual Risk Assessments to Senior Management.
• Coordinate Testing wif remote teams based in Mexico and India.
• Defined Ambiguities wif teh Business and Functional Requirements. Worked wif Business Analysts to clarify Ambiguities
• Verified traceability of Test Conditions to Test Cases
• Provided Test Estimates for various phases of teh project
• Oversaw all phases of testing
• Verify teh implemented ETL code against teh corresponding mapping document.
• Confirm teh data loads from source files into staging table and staging table to target table.
• Analyze data using SQL, Excel, UNIX and data testing tools.
• Created teh Macros using VB scripting to validate teh data transformation from source to target.
• Identifying field and data defects wif required information in ETL process in various jobs and one to one mapping.
• Tested Complex 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.
• Created teh test environment for Staging area, loading teh Staging area wif data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Validated teh data in teh reports by writing simple to complex SQL queries in teh transactional system
• Tested teh entire data reconciliation process for multiple source and target systems.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained teh data integrity and security using integrity constraints and Data base triggers.
• Involved in teh application tuning of database by identifying teh suitable Indexes.
• Worked on issues wif migration from development to testing.
• Reduced teh time to market by automating teh ETL Scenarios
• Executed and managed test cases and reported bugs in HP ALM Quality Center.
• Performed Verification, Validation, and Transformations on teh Input data (Flat files) before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Data Stage tool
• Validated data in between source and target after running Mappings by teh developer team.
• Hands on work experience working wif offsite team model.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.

Confidential

Automation and ETL QA Lead

Environment: Informatica Power Center 8.6, HP Quality Center, Visual Basic, DB2, Oracle, SQL, PL/SQL, UNIX, Quick Test Pro/UFT, Windows 7.

Responsibilities:

• Developed Test Plans, test scripts and executed teh test scripts for Bank DW Project.
• Reviewed Business Requirement Document (BRD) for accuracy and Completeness.
• Thorough out teh project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared teh Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted wif developers, business& management teams to understand teh OPM project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Testing of ETL jobs dat are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Created integrated summary data from multiple tables to represent teh business perspective of teh top management executives.
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
• Designed and developed macros using VB scripts as part of teh ETL process, automate teh process of loading, pulling and comparing teh Expected and Actual results.
• Participated in designing a sustainable automation framework to develop and maintain teh automated test Scripts.
• Developed automated regression test scripts for all teh identified test scenarios
• Participated in functionality testing and regression testing
• Involved in automation testing using QTP.
• Involved in Function library creation, object repository maintenance and scripts development
• Involved in designing teh scripts wif VB scripting
• Created and executed teh automated test scripts for Regression and End-End tests using ALM/QC and QTP
• Validating teh Archive process to purge teh data dat meet teh defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.

Confidential

Automation and ETL QA Lead

Environment: Datastage 8.1, Quality Center, Visual Basic, MYSQL, DB2, Oracle, SQL, UNIX, Quick Test Pro, Windows 7.

Responsibilities:

• Responsible for testing and reviewing of ETL mapping and transformation specifications based on teh business requirements from various teams and teh business teams.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing teh operations mentioned in teh design steps. Compared teh expected results wif teh actual outcome and recorded teh results.
• Working wif teh Development team for process improvement and release planning
• Analyzed application data using teh SQL to identify teh ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked wif data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of teh DB by writing PL/SQL queries to test teh integrity of teh application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate teh outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only teh additional data added during dat period.
• Wrote complex queries to compare teh counts and data from source to target.
• Formulating teh QA plan for black box testing of teh application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze teh data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Using Vb script to generate teh automated test scripts.
• Creating traceability relationship between requirements in teh same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating teh test plan, procedures and Wrote test cases.

Confidential

ETL QA Tester

Environment: SQL, PL/SQL,Test Cases, Test Scripts, Test Plan, Traceability Matrix, Test Director, IBM DB2, Datastage 8.1, Oracle8i

Responsibilities:

• Involving in formulating teh test plan, procedures and Wrote test cases.
• Maintain, back up and restore teh Informatica ETL repositories for teh QA team.
• Coordinated all QA activities and enhancements.
• As part of QA team was involved in implementation of ETL best practices.
• Involved in all phases of (Unit, Integrated and UAT) testing Informatica mappings.
• Tested data marts; tested teh security levels and granting of appropriate roles.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of teh data marts and feeder systems in teh aggregation effort.
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Functional testing, Regression testing, and Data validation Testing.
• Developed automated Test scripts using QTP to perform Functional and Regression testing.
• Executed and managed test cases and reported bugs in Quality Center.
• Performed Verification, Validation, and Transformations on teh Input data (Text files, XML files) before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Validated data in between source and target after running Mappings by teh Informatica developer team.
• Developed SQL queries to check teh database automatically and checking teh data integrity in accordance wif business standards of teh company.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Responsible to send teh Data Warehouse Quality report to teh QA manger on weekly basis for Caliber data mart.
• Provided weekly status report to teh Project Manager and discuss issues related to quality and deadlines.