SUMMARY:

• 9 years of extensive experience in Quality Assurance testing of SQL, Data, ETL and Business Intelligence processes, Web Based and Client/Server applications.
• Excellent knowledge in implementation of different QA methodologies/policies, strategies and plans in all stages of SDLC.
• Excellent knowledge in test planning, coordinating, execution and leading the testing process.
• Experience performing all types of testing like smoke, system, integration, regression, and User acceptance retesting.
• Extensive experience performing Root cause analysis on defects and conducting review meetings on defects for open defects.
• Excellent knowledge of defect management and tracking using Quality Center, JIRA and Mission Control
• Tested various ETL processes developed using ETL tools like Informatica Powercenter, Ab Initio and Datastage.
• Tested various reports generated by Business Objects, Hyperion and Cognos.
• Proficient in querying various databases like Oracle, Teradata, DB2, SQL server, MySQL, MongoDB, Hadoop and Flat files. Excellent knowledge of defect management and tracking using Quality Center.
• Adept at backend testing and data validation testing using SQL queries
• Experience in performing data validation and preparation of test da in UNIX environment using various UNIX commands and editors.
• Excellent Domain Knowledge in financial, insurance, Healthcare medical technology and Hands on experience in Waterfall, Agile and adaptive delivery methodologies.
• Coordinated testing efforts and effectively managed Off - Shore teams.
• Self-conscientious starter, strong team skills and ability to lead a team toward achieving organizational objectives

TECHNICAL SKILLS

Testing Tools: HP ALM/Quality Center, Test Director, JIRA, Mission Control

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Linux.

Languages: SQL, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008, Teradata, Sybase, DB2

ETL Tools: Informatica PowerCenter 8.x/9, Ab Initio, SSIS and Datastage

BI Tools: Business Objects XIR2/XIR3, Cognos, Microstrategy, SSRS and Hyperion

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Sr. QA Tester

Responsibilities:

• Review functional and design specifications to ensure full understanding of individual deliverables.
• Identify test requirements from specifications, map test case requirements and design test coverage plan.
• Develop, document and maintain functional test cases and other test artifacts like the test data, and data validation.
• Defects were tracked and prioritized using HP ALM/Quality Center and analyzed the variation between expected results and actual results.
• Developed complex SQL queries to verify the data loaded into the target tables. Validate the test data using MS access, TOAD, UNIX & MS Excel.
• Tested ETL mappings and worked in source to staging area to validate the Basel II multiple source system data with SQL queries.
• Involved in backend Data warehouse ETL testing with SQL, check the data integrity and referential integrity.
• Coordinated between offshore and onsite team and managed the entire project for testing needs.
• Debugged the SQL-Statements and stored procedures for various business scenarios. Performed extensive data validations against Data Warehouse.
• Logged and tracked defects on a release basis using HP ALM/Quality Center.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Performed transformation and data quality for various data feeds coming from different source systems.
• Tested reports developed by Business Objects Universes for both ad hoc and canned reporting
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Created test cases and tested Business Objects reports using HP Quality Center/ALM.
• Created complex SQL queries for data validation to verify the ETL mapping rules.
• Analyzed the Requirement Traceability Matrix, daily test status reports, weekly defects report, and risk analysis, including regular communications with the business team.
• Tested several reports developed in Business Objects.

Environment: ETL Informatica PowerCenter, ALM/HP Quality Center 11.0, SQL, PL/SQL, XML, XSLT, Oracle 10g, Unix, Toad for Oracle, MS Office 2007, QTP, Windows XP

Confidential, Minneapolis, MN

QA Tester

Responsibilities:

• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM
• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Tested Informatica mappings, and the data from different sources whether it was formatted, Cleansed, summarized, aggregated, transformed and loaded into target database
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level. Prepared sample test data by inserting data into staging tables.
• Prepared all the test scenarios and shared across the team. Involved in testing all the reports that were generated through Business Objects.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend Datamart through SQL and also using excel for data comparison.
• Was involved in running the Informatica jobs from UNIX box for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP Quality Center for all the team members to review.
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Environment: Informatica PowerCenter 9, Oracle, Unix, Business Objects, HP Quality Center, QTP, Toad for Oracle, MS Office, Windows XP

Confidential, Charlotte, NC

QA Tester

Responsibilities:

• Wrote SQL scripts to perform database testing and to verify data integrity.
• Reported debuging using Infromatica and tracked defects using Quality Center.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Strong ability in developing advanced and complex SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, Tested the Universe s Structure to ensure that tables are properly uploaded, Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation
• Tested the data load process using the Infromatica ETL tool for various data loading scenarios including Batch Load, Sequential Loads, Incremental Loads & Direct Dumps
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Defects found tracked and managed in Quality Center and disposition in defect scrub meetings
• Worked with Data Conversion projects for testing data quality after migration.
• Used SQL Loader for data retrieval and querying. Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Tested ad hoc and canned reports for Business objects. Validate the business functionality using UAT Testing
• Involved in extensive DATA validation using SQL queries and back-end testing. Validated business reporting requirements with internal and external customers.
• Used SQL server and Oracle database as source and destination data warehouse.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Validated the reports to make sure all the data is populated as per requirements.

Environment: Informatica Power Center, Business Objects XIR3, SQl, PL/SQl, SQL Server 2008, QTP, Quality Center 11.0, Oracle 10g, UAT, UNIX and TOAD.

Confidential, Monterey Park, CA

QA Analyst

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested all the compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tracked defects to closure by coordinating with the dev team. Tested source data for data completeness, data correctness and data integrity.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Prepared test data to cover all the test scenarios. Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.

Environment: SQL, PL/SQL, HP Quality Center 10.0, XML, Oracle 10g Informatica 8.6, Business Objects XIR3, TOAD for Oracle