PROFESSIONAL SUMMARY:

• Over 7 years of demonstrated experience as ETL TESTER
• Highly proficient in handling huge volumes of data in various sectors of business such as banking, insurance, supply - chain management system and pharmaceutical industry
• Experienced inIntegration, Load Testing, UA Testing,Black Box, Functional, Regression, System Testing, andGUItesting.
• Clear understanding of various stages of Software Development Life Cycle (SDLC)-Requirements analysis, design, development and documentation.
• Hands on experience in testing oracle procedures, functions and triggers.
• Experienced in testing ETL mappings.
• Expertise in testing Client - Server and Data Warehouse Applications
• Expertise in writing Test Scripts to validate to/from the application to the backend databases by writing and executing SQL queries in RDBMS such as Oracle, MS SQL Server, Toad using PL/SQL and using Unix shell script to automate ETL process
• Expertise in writing automated test scripts for data validation.
• Extensive experience in all phases of AGILE and Waterfall SDLC
• Expertise in MS office applications: Excel, Word, PowerPoint, Access
• Experience in gathering business requirements, building detailed test cases executing test scripts and defect tracking.
• Thorough in testing strategy and in preparing RTM (Requirement Traceability Matrix), test cases and test summary report.
• Self-motivated and result-oriented with ardent focus on delivering quality applications
• Excellent ability to document and report new processes, while striving for constant improvements

TECHNICAL SKILLS:

Databases: Oracle, DB2, Sybase,Toad

Defect Tracking Tool: Quality Center(QC)/ALM, Microsoft Team Foundation Server(TFS)

Languages: C,C#, SQL, PL/SQL, XML

Scripting Languages: Shell, Java Script, and VB Script

Web Servers: IIS

Testing Tools: QTP/UFT, SoapUI Pro

Operating Systems: Windows 95/98/2000/XP/NT, UNIX, Linux

Tools: SQL Developer, MSTR, share point, INFORMATICA, load runner

PROFESSIONAL EXPERIENCE:

Confidential, Irving, Texas

Sr. ETL/BI Tester

Responsibilities:

• This position allowed me to work on multiple projects which gave more insight in the leading the team and prioritizing the testing time lines
• Tested data extraction from various sources like DB2, UDB, Flat files using physical data object and loaded into the ORACLE database for warehouse testing
• Performed data consistency check by testing the datatypes converted using SOURCE QUALIFIER TRANSFORMATION and by using PROFILING
• Designed mapping document and performed SQL queries to test cleansing performed by EXPRESSION TRANSFORMATION in power center data mapping
• In SCRUM process, tested feature by feature, verified Table structures, Procedures,
• Active participation in Sprint Planning, Review and Retrospective Meeting
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, ODS, SQL Server, etc into the Staging table and then to the target database Oracle.
• Performed package validation and file validation.
• Used SQL for Querying the Oracle database for data validation and data conditioning
• Creating test cases from Release Notes, executing test cases, analyzing and interpreting results and reporting software defects in QC/ALM and triage open issues
• Supported scheduling of jobs during off-peak hours to have the data available in multiple test environments.
• Involved in Regression testing, Functional testing, Integration, system and UAT testing and Adhoc testing.
• Responsible for preparing RTM (Requirement Traceability Matrix).

Environment: Oracle 11g, DB2, ALM, informatica, BI tool-Microstrategy

Confidential, Savannah, GA

Sr. ETL Tester

Responsibilities:

• Analyzed and Performed Gap Analysis based on requirements documents.
• Performed end-end testing by checking JOINER TRANSFORMATIONS in WORKFLOW using SQL joins
• Testing ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Developed Complex mappings from varied transformation logics like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Union, Update Strategy and more.
• Tested Informatica folders, global sources, global targets, global ODBC connections, global FTP connections workflows, data profiling and manage metadata.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Used Quality Centre to track, review, analyze, assign and compare defects. Coordinating with Developers for Defect analysis.
• Consumed releases and performed application shakeouts.
• In-depth testing to track the bugs using Oracle stored procedures
• Identified root causes, analyzed and provided solutions to critical, medium and low issues in a reasonable timeframe.
• Responsible for daily Scrum meetings to discuss updates showing the progress of the testing effort and open issues, and update the Sprint Backlog on daily base
• Hands on experience in PL/SQL.

Environment: QTP 11, ALM 11, HP LoadRunner 11.0, ORACLE, informatica

Confidential, Brentwood, TN

Sr. ETL Tester

Responsibilities:

• Tested data migration from DB ACCESS to ORACLE
• Performed reconciliation test(count) to identify data loss risk during data migration process
• Performed processability test to identify inconsistency between application and migrated data
• Responsible for preparing Test Cases, Test Summary Reports, Testing and Status Reports.
• Proficient in using HP Mercury Quality Center (QC/ALM) tool for defect tracking.
• Developed, executed and maintained manual and automated functional using UFT/QTP tests and reported(maintained) the results in HP Quality Center.
• Ensured accuracy and consistency of data in ORACLE db by performing referential integrity checks (checking CONSTRAINTS- not null, unique, default, check, index etc)
• Responsible for executing the test cases, upon successful completion, responsible to promote/migrate the application
• Worked in all phases of SDLC and Agile/Scrum software development
• Hands on experience in coding according to testing framework
• Performed parameterization to ensure real time load conditions through Load Runner.
• Involved in design, development and implementation on a multitude of manual and automation tests for functional, UAT and regression tests.
• Identified the mutation problem in database trigger
• Created release cycles, release scope and milestones using ALM
• Created test plans and uploaded test plans using QC/ALM

Environment: - ORACLE, QC, Load Runner

Confidential

ETL Tester/BI Tester

Responsibilities:

• Actively involved in resource management while providing estimation for testing efforts in agile methodology
• Performed load and performance testing using JMETER
• Provided defect management through CLEAR QUEST, thereby streamlining the process of identifying the defects, documenting the changes and tracking the status updates
• Involved in creating test cases and test planning based on project specification and business requirements using IBM Rational Functional Tester
• Developed SQL queries to verify the business functionality by comparing various data points using TOAD and access to LDAP directories
• Managed report process to include test results, summary and end-of-testing graphs for management review
• Tested the web services using SOAP/ UI
• Partly worked on WINDOWS API using windows SHELL SCRIPT
• Coordinated daily status updates through defect review meetings for various test execution cycles and communicated results with stake holders
• Tested Analytical Data Mart (ADM) using Stored Procedures.
• Participated in implementing sign test exit criteria checklist for production deployment and performed the post production validation before a formal signoff.
• Mentored junior team members on the client specific tools, scrum meatings and on test documentation.
• Involved in extensive DATA validation using SQL queries and back-end testing

Environment: - TOAD, IBM Rational functional tester, clear quest, SOAP UI, QA, JMeter

Confidential

ETL Tester/ BI Tester

Responsibilities:

• Identified the test requirements based on application business requirements and blueprints.
• Comparing and Analyzing the Expected with Actual results in DB through QTP parameterization.
• Performed testing and maintained documentation on different types of DB Testing
• Involved in analyzing the applications and development of test cases
• Applications are tested manually and by automation and maintained using QC 9.2
• Analyzed and reviewed the software requirements, functional specifications and design documents.
• Created and uploaded defects in QC and managed bug life cycle
• Implemented error handling methodology in creating automated tests using QTP/UFT
• Proficient in QA processes, test strategies and experience in creating documents like Test plan, Test procedures and requirement elicitation
• Checked synchronization between UFT and AUT using inbuilt synchronization points.
• Wrote SQL queries and stored procedures to validate data using SQL server 2005
• Created test scripts, executed test scripts, Documented errors and implemented their resolutions using QC 9.2
• Used DESCRIPTIVE PROGRAMMING and automation object model for testing profiles.

Environment: -, SQL SERVER, SOAP UI, QC 9.2