PROFESSIONAL SUMMARY

• 5+ years of IT experience in Software Development Life cycle (SDLC and STLC) which includes Requirement gathering, analysis, design, build, testing and deploying application.
• Expertise in testing Data Warehouse ETL and Reporting tools wif extensive knowledge in ETL and OLAP/OLTP processes.
• Extensive Experience in testing End to End Data Warehousing/ Business Intelligence solutions for Healthcare, Retail, Financial domains.
• Expertise in testing wif relational data bases such as Oracle, Teradata and SQL server, DB2 and Netezza.
• Strong experience in ETL Testing using Informatica and BI Testing using MSTR, Cognos and Cognos TM1.
• Good exposure to Testing, Debugging, Implementation, Documentation and Production support.
• Well versed in GUI application testing, Database testing, smoke testing, system testing and Front - end testing.
• Experience in testing the Historical and Incremental data.
• Expert in using the Agile/Scrum and Waterfall testing lifecycle Methodologies
• Expert in analyzing the root cause of the failed test case and provide the related data samples to the developers.
• Experienced in developing and Executing Test Scenarios, and Test Cases/Script.
• Expert in reviewing/reporting, tracking, & maintaining Defects wif high level of detail, accuracy and informative recreation steps using TFS, ALM/Quality Center, Bugzilla, JIRA, and RALLY.
• Hands on experience in Report building (Crosstab, List) using Report Studio and Analysis Studio.
• Excellent Communication and interpersonal skills wif clear understanding of business processes and ability to work as part of team or individually.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Sr. Test Engineer

Responsibilities:

• Involved in BA walkthroughs and ETL Specification Document.
• Worked wif the Dev team to gather information for some ambiguous requirements.
• Tested cognos reports (Graph, table, and chart) wif the data.
• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Preparation of test scenario’s and test cases based on requirement.
• Wrote complex SQL scripts for individual tables by following the transformation rules in S2T documents, which includes writing identity rule and for all the other columns of the table.
• Used EXCEPT statement to find difference in records between source table and target tables.
• Regression testing of the extract files and tables.
• Analysis of the mismatched records and further proceeded wif either raising a defect using ALM and check whether the ambiguity still exists or not.
• Follow up wif existing defects and new defects in TFS
• Worked wif UAT defects, enhancement defects, production defects.
• Developed reports by using Application Life Cycle Management metrics for daily status reports.
• Status update on daily basis to the upper management by providing the daily metrics based on the defects opened, closed or retested and on the number of the test cases executed.
• Responsible for executing the System Test Cases and reporting defects Application Life Cycle Management
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during the Defect Management meetings.

Confidential

Sr. Test Engineer

Responsibilities:

• Tested various reusable ETL Transformations, which facilitate Daily, Weekly & Monthly Loading of Data.
• Reviewed the Business Requirement Document to understand the process and write Test Cases.
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases.
• Used Agile testing methodology for achieving deadlines in UAT.
• Executed and managed test cases and reported bugs in Quality Center 9.2.
• Performed Verification, Validation, and Transformations on the 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 the Informatica developer team.
• Experience working wif onsite team and coordinate my own efforts wif team members in the on- site team.

Confidential

Sr. Test Engineer

Roles and Responsibilities:

• Tested stored procedures & views in Toad using SQL/PLSQL.
• Worked wif Data Completeness, Data Transformation, Data Quality and Integration Testing for different line of feeds
• Worked wif SCD1, SCD2 testing while dimension data validations.
• Prepared test cases for data validations between Data Mart to data cubes.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked wif developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Worked wif UNIX scripts in executing and validating logs for the issues.
• Involved in KT sessions for new joiners to ramp up them.
• Validated all the jobs and successfully system tested the jobs
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing.
• Preparing and supporting the QA and UAT test environments.

Confidential

Test Engineer

Role and Responsibilities:

• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports
• Performed back-end testing on the Oracle database by writing SQL queries.
• Collected, analyzed and reported testing metrics, executed SQL queries
• Built and maintained effective QA test lab environments
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Used Query Studio to test ad hoc reports
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations
• Participated in various meetings and discussed Enhancement Request issues
• Conducted Regression testing after the bugs have been fixed by the development team
• Generated reports from Test Director.
• Responsible for source control, versioning, and configuration management of test scripts, test results, defects
• Developed Test Strategy, Test plan, Test cases, and Test scripts
• Created test plan and executed test cases using Rational Test Manger
• Conducted Functionality, Security, and End to End testing
• Reported bugs using Test Director and generated the defect reports for review
• Defect reporting and tracking was also done using Test Director.
• Maintained the test traceability matrix
• Performed Regression Testing on weekly builds.
• Monitored the workflow transformations in Informatica work flow monitor

Confidential

Test Engineer

Responsibilities:

• Analyzing the business requirements by going through the project documents
• Attending the KT session for the requirements clarifications
• Preparing the RTM based on BRD document
• Preparing and reviewing test cases based on given requirement specification, Mapping documents
• Prepared different types of test cases like Layout, Count, Scenario and Mapping.
• Preparing the SQL script to verify and validating data between source and target through Teradata SQL Assistant