SUMMARY

• Over 8 years of diverse experience in Quality Assurance including ETL, Manual and Automation testing with expertise in requirements gathering, analysis, planning.
• Extensive knowledge in ETL testing, Manual Testing and Test Automation using Tools like Ab Initio, Informatica, UFT, QTP, HP Application Life Cycle (ALM), HP Quality Center.
• Experience in testing Web - based, Client-Server and Data Warehouse applications on different environments.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration
• Experience in Data Warehouse applications testing using Informatica, SSIS, Shell Scripting, PL/SQL, Informatica, Data Stage and Ab Initio on multiple platforms.
• Well versed in all stages of the Software Development Life Cycle.
• Experience in creating ETL test data for all ETL mapping rules to test the functionality of the Ab Initio and Informatica graphs.
• Strong knowledge of Metadata and Star Schema/Snowflake Schema.
• Extensive experience in Test Planning, developing Test cases using requirements and design documents, Test Execution, Defect Management, Requirement Mapping with Test Cases while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Experience in Automation Test Scripts using Keyword Driven Framework in QTP.
• Extensively worked in System, Functional, End-End, Black Box Testing, Integration, and Data Driven Testing.
• Involved in User Acceptance Testing (UAT).
• Expertise in SQL and PL/SQL scripting to validate data integrity of the backend data.
• Extensive working knowledge in Windows and UNIX platforms.
• Experience in Mortgage, Banking, and Healthcare applications testing.
• Experience in UNIX commands and Shell Scripting.
• Good communication skills, committed, quick learning capability, result oriented, smart working with a quest and zeal to learn new technologies.

TECHNICAL SKILLS

Testing Tools: Quick Test Pro 11.0, Load Runner, SOAPUI, Selenium IDE

ETL Tools: Ab Initio, Informatica Power Center,AUTOSYS, Unix Shell Scripting

Operating Systems: Windows 95/98/2000/XP/NT, Unix

Test Management Tools: HP ALM, HP Quality Center

Defect Tracking Tool: Rational Clear Quest, JIRA

Languages: C, C++, Java, J2EE, VB.Net, ASP.Net, SQL, PL/SQL, Visual Basic 6.0, ASP

Database: Oracle 8i/9i, TOAD, MS SQL Server 2000,DB2, MS-Access

Scripting: Java Script, VB Script, HTML and XML

Tools: /Packages: Visual Source Safe, MS Office

Application Server: Apache Server, Web Sphere V5.0/V6.0.x

Protocols: HTTP/HTML

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr.ETL/SQL Back-end Test Specialist

Responsibilities:

• Worked closely with the business/project team in creating the detailed Test Plan, Test Cases with respect to the scope and priority of test effort based on design requirements.
• Used Quality Center for test management as part of the project.
• Involved in testing the mappings and transformations to test the data quality and data integrity at various stages during data movement.
• Involved in writing complex SQL Queries to check data loading from Source to Target tables.
• Performed data validation testing writing SQL scripts.
• Generated Rating agency reports using the ETL data and validated the same.
• Analyzed Source Systems, Staging area, fact and Dimension Tables in Target Data Warehouse.
• Involved in testing the interfacing of the web application with the legacy COBOL/CICS Mainframe programs.
• Performed Black box, Functional, and Integration Testing on Web Based Applications.
• Involved with development teams to build true End to End Performance testing environment for all releases.
• Coordinated the Testing efforts during Integration, System and User Acceptance Testing phases.
• Performed extensive Database Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application.
• Worked on QTP/UFT for Regression, Integration, and system Testing.
• Involved in ETL process testing using Ab Initio ETL tool.
• Tested ETL process of data extraction using Ab Initio, executed Ab Initio graphs and created data files.
• Validated data files produced result of Ab Initio graphs and data transformation case studies involved.
• Managed the test process and execution using Quality Center, generated reports for test coverage analysis.
• Actively participated in meetings to resolve the defects in efficient and timely manner.
• Analyzed the test results and graphs by generating different reports in Quality Center reflecting the stability of the application with the QA, Development and Business team.

Environment: UFT 11.0, QTP, HP ALM, Ab Initio, DB2, MS SQL Server, J2EE, Mainframe, VB, Windows XP/2000 Adv, UNIX and MS office.

Confidential, Providence, RI

Sr. ETL QA SQL Test Analyst /Data Centric Tester

Responsibilities:

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
• Configured the QA Environment for Manual Testing as well as Automation through autosys.
• Tested the data and data integrity among various sources and targets
• Designed, developed stored procedures using PL/SQL and tuned SQL queries for better performance.
• Used debugger to test the data flow between source and target and to fix the invalid mappings.
• Used Informatica Power Center 8.6.1and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Designed and created the Microsoft Visio diagram which represents the workflow and execution process of all the process in the reinsurance world.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Written complex SQL queries for validating the data stored in different database tables.
• Helped the team in analyzing the data to be able to identify the data quality issues
• Worked as a consultant in delivering quality data centric solutions for various business domains
• As a Test Lead involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans and Execution Plans.
• Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Build a customer data centric data warehouse to analyze transactions across finance, marketing, risk collections and consumer relations for the credit card division.
• Clean customer data warehouse successfully implemented on Oracle target, the data warehouse is growing in its analytical richness.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Implemented Iterative and IncrementalAgile - ScrumMethodology for rapidly changing or highly emergent requirements and following parallel development and testing.
• Monitored the data move process through Data Extract to Flat file through Informatica Execution flows and Loading data to Data mart through NZLOAD utility.
• Tested database for Data Validation, Data Verification using NZ SQL.
• Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams.
• Tested several business reports including Score Cards, KPI's, Summarized, Master-Detailed and Drill Down reports developed by Microstregy
• Supporting presales activity for Data centric warehouse testing projects.
• Tested/Created/maintained Micro Strategy metadata for the projects and performed user administration.
• Totals, Drilling options, prompts, metric calculations, drill maps and security filters using Micro strategy.
• Used PMCMD command to start, stop and ping server from UNIX.
• Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing.
• Also manually tested the application for each system build, for both negative and positive testing.
• Involved in automation of test cases using QTP.
• Did functional testing using QTP
• Good experience in communicating with offshore team
• Communication with the client for weekly status report
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Generated tractability Matrices to ensure that all the requirements are covered by the test cases.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing.
• Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Involved in FTP process to transfer the files from one server to other.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Utilized Test Director/Quality Center for Tracking and Reporting Defects, which are assigned to developers.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Participated in Daily and weekly status meeting with team members and coordinated with teams (Development, Business, and QA) for the progress of the work done in application.

Environment: Informatica power center 9.1.0 1, Micro Strategy 8.0.2 SQL, PL/SQL, SQL Server 2005/2008, Unix Shell Scripting, Micro focus COBOL, TOAD 9.2, Java,MVS, VSAM Files, Oracle 9.2 and 10G, Teradata V2R6, HP Quality Center 10, QTP 10, Autosys, MQ Series, Microsoft Visio, Web Focus report

Confidential, DE

ETL Tester

Responsibilities:

• Reviewed Business Requirements Documents and the Technical Specifications.
• Developed Test Cases, Test Scripts from the data mapping documents, functional specification documents and mapped the test cases with requirements for generating Requirement Traceability Matrix (RTM).
• Performed Functional, Integration, Regression and System (End-End), and Back-End Integration Testing with back end Oracle Database using SQL Queries.
• Modified and created SQL Queries and stored procedures for quality assurance and analysis.
• Analyzed application data using SQL to identify ETL processes.
• Worked with Data Analysts to implement Informatica Mappings and Workflows.
• Worked Extensively with SSIS to import, export and transform the data between Used T-SQL for Querying the SQL Server2000 database for data validation and data conditioning
• Extensively used Informatica Workflow Manager to run workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow variables and Session parameters to extract the additional data added during that period.
• Analyzed and tested ETL Informatica Mappings with source data, staging and target data.
• Automated and scheduled Informatica Jobs using AUTOSYS and UNIX Shell Scripting.
• Worked closely with the Developers and System Engineering Teams in the review and modification of the product and its specifications.
• Involved in generating Test plans and Test specifications.
• Involved in ETL process for a Data Warehouse from their legacy systems using Informatica Power Center.
• Extensively worked on ETL tool Informatica - Mapping Designer, Workflow Manager, and Workflow Monitor.
• Worked on QTP for Regression, Integration, and system Testing.
• Developed, Enhanced, and Maintained automated testing scripts with QTP.
• Used Parameterization for testing with a specific set of data.
• Enhanced scripts by adding checkpoints.
• Reported the Bugs using HP Quality Center and closely worked with developers to nail down the technical problems.

Environment: Quick Test Pro 11.0, HP Quality Center 11.0, Informatica, AUTOSYS, MS SQL Server 2005/2008.SSIS,SSRS,SSAS, ASP.Net, XML, TOAD, Windows 7.

Confidential, MN

QA Analyst

Responsibilities:

• Reviewed Business Requirements Documents and the Technical Specifications.
• Written Test Strategy and Test Plans corresponding to business rules and other operating conditions.
• Involved in ETL process testing using Informatica ETL tool.
• Documented Test Cases in HP Quality Center.
• Wrote SQL queries and Database Checkpoints to verify data quality and calculations, reviews.
• Involved in developing the automated test scripts using Record and Playback function in QTP.
• Prepared the Test Data for the Data Driven Approach in QTP.
• Managed objects in Object Repository, parameterized tests in Global and Local Data Tables.
• Updated Automation Scripts with respect to the latest product releases.
• Conducted verification of the documents, plans, requirements and specifications.
• Reviewed Test Scripts to ensure Quality Standards.
• Performed Boundary values testing and Validation testing.
• Worked with SSIS system variable, passing variables between packages
• Conducted the application compatibility tests with different Operating Systems.
• Implemented Defect Tracking using HP Quality Center and coordinated with developers and SQA team.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data Transformation, data quality, integration testing, UAT & regression testing
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Involved in Security testing for different LDAP roles.
• Generated Weekly Reports, Defect Reports and Customized Summary Reports.

Environment: Quick Test Pro (QTP) 10.0, HP Quality Center 10.0, Informatica, SQL server SSIS (2005), SQL server SSRS (2005), SQL Server 2000/2005, JAVA, JavaScript, DB2, HTML, XML, SQL, Oracle, Web Sphere V5.0/V6.0, Windows XP/NT and UNIX.

Confidential

QA Tester

Responsibilities:

• Verified layout of data files and control file entries as per business requirement.
• Validated the base table (Star schemas- Fact and Dimension) by writing complicated SQL statements and reports.
• Developed backend programming in Oracle using PL/SQL and SQL.
• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive, Negative testing, Post Production testing and End to end Testing of ETL code and reports.
• Tested daily, monthly and quarterly loads end to end.
• Experience in writing complicated SQL statements.
• Wrote extensive SQL and PL/SQL Scripts for creating stored procedures in Oracle.
• Created new Oracle Stored Procedures and modified the existing ones.
• Designed, Developed and tested PL/SQL Programs to prepare and clean Data for data migration and also to retrieve data from the database to compare against the input sets
• Did functional testing using Quick Test Pro.
• Designed forms and reports using Developer 2000 according to the client requirements. Triggers, procedures and functions are developed in this reports using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Wrote and ran Unix Scripts for batch jobs.
• Involved in validating the ETL mappings from various systems(CRM,OLTP) to transaction history/reporting database
• Interacted with Solutions analysts, system staff, ETL developers and the data load staff.

Environment: Informatica 6.2/5.1, Toad, SQL, Test Director, Shell Scripting, QTP, Sun Solaris 5.8, PL/SQL, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts