SUMMARY

• Around 7 years of experience in Quality Assurance/Software Testing and manual testing of Client/server, Mainframe and Web based applications
• Experienced in Writing System Test Plans, Test Cases, Test Scripts, Documentation and Setting up Test lab Environment
• Extensive experience in varied aspects of the Software Development Life Cycle
• Experienced in Data analysis, validation, modeling, loading and testing
• Experienced in testing ETL data from multiple data sources into data warehouse
• Conversant with all phases of Project Life Cycle including Requirement gathering, Analysis, Design, Development, Implementation, Testing and Quality procedures.
• Created test scripts, test conditions and performed Functional, Integration, System, and End - to-End testing of the applications
• Expertise in the entire QA Life Cycle Process, which includes design and development of Testing Methodology, Test Strategy, Test Scenarios and Test Cases
• Good knowledge of Agile methodology and scrum process
• Experience in Backend testing of SQL Queries using Oracle, SQL Server, and DB2
• Experience working on large volume of data using Teradata SQL
• Experience in developing ETL mappings using Informatica Power Center and generating reports using Query studio in Cognos
• Experienced in writing SQL queries, scripts and PL/SQL to run data integrity tests
• Experience in using HP Quality Center for bug tracking and defect reporting
• Exposure in automation testing techniques and tools
• Experience with schedulers like Cronjob, control-M etc.,
• Experience in Bug Tracking System and technically sound in knowledge.
• Clear understanding of business procedures and ability to work as an individual and as part of team
• Strong analytical and communication skills with capable of working efficiently under stress and tight deadlines

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/NT/7 and UNIX

Defect Tracking Tools: JIRA, Quality Center

Databases: Oracle11i/10g/9i, SQL Server,DB2,Teradata

ETL Tools: Informatica9.1,Datastage8.0.1/8.5,Cognos 8.x

Programming Languages: Shell, SQL, PL/SQL

Scheduling Tools: Crontab, Control-M

Test Strategies: System,Functional, Inegration, Regression, Black Box, UAT, Performance Testing

Software Methodologies: Agile, Waterfall, V-model

PROFESSIONAL EXPERIENCE

Confidential, Dayton

Sr. ETL tester

Responsibilities:

• Involved in complete lifecycle of the project including requirements, design, testing and production maintenance of the project
• Involved in design and technical specifications for the ETL process of the project
• Prepared test cases by understanding the business requirements, data mapping documents and technical specifications
• Performed functional, integration, regression and end-to-end testing
• Tested reports and ETL mappings from source to target
• Prepared and executed test cases for mappings developed through the Informatica tool in QA environment
• Worked with Oracle database and wrote complex SQL queries and PL/SQL programs to compare and validate backend data
• Interacted with developers and product owners to get requirement details and clear open defects
• Executed test cases in different QA environments by enhancing the test cases using data scenarios and data driven approach
• Participated in designing automation test plans and writing test cases
• Worked with Cognos report generation tool for creating different reports like list, crosstab and Repeater.
• Involved in developing SQL queries, DML and DDL scripts for automation testing
• Used HP quality center for tracking and reporting defects
• Provided test data for UAT and involved in feature functionality testing
• Prepared weekly productivity reports and submitted test metrics to the management

Environment: Oracle10g, SQL, PL/SQL, Quality Center10, Informatica Power Center, Cognos, SQL Developer, UNIX

Confidential, IL

ETL Tester

Responsibilities:

• Involved in complete lifecycle of the project including requirements, design, testing and production maintenance of the project
• Created test cases based on functional requirements and involved in executing test cases
• Performed functional, integration, regression and end-to-end testing
• Prepares test cases for ETL to compare source and target database systems
• Involved in creating test strategy
• Checked data flow through the front and backend and used SQL queries to extract the data from database
• Worked with Oracle database and wrote complex SQL queries and PL/SQL programs to compare and validate backend data
• Tested different detail, summery reports and on demand reports generated using Cognos.
• Interacted with developers and product owners to get requirement details and clear open defects
• Worked on production environment to resolved several data issues
• Executed test cases in different QA environments by enhancing the test cases using data scenarios and data driven approach
• Participated in designing automation test plans and writing test cases
• Involved in developing SQL queries, DML and DDL scripts for automation testing
• Use Jira for test cases and defect tracking and reporting

Environment: Informatica Power Center9.1, Oracle10g, Cognos, SQL, PL/SQL, Jira, Toad, Shell script, UNIX

Confidential

QA Analyst

Responsibilities:

• Involved in full testing lifecycle from analyzing business requirements for multiple projects
• Developed test scripts using UseCase and requirement documents
• Created and executed test cases for functional requirements and mapping documents
• Updated test cases periodically for any changes in the requirements
• Analyzed the source to staging and stage to warehouse documents to come up with test cases for tables data validation
• Worked with source to target minus queries for data validation
• Worked on Informatica workflows and mappings using power center workflow manager, workflow monitor and designer
• Created, optimized, reviewed and executed Teradata SQL test queries to validate transformation rules used in source to target mappings and verify the data in target
• Written complex SQL queries using joins, sub queries to verify the data loads on target system
• Involved in extensive data validation on database using SQL scripts
• Used Teradata utilities to load test data into target tables
• Wrote several Teradata SQL queries using Teradata SQL assistant
• Used Cognos for report generation and tested different derails, summary reports and on demand reports
• Ran UNIX batch scripts in order to validate the data quality
• Performed all stages of testing including functional, regression, end-to-end and performance testing
• Executed test cases and evaluated test results with the expected results
• Tracked and reported all defects through Quality Center
• Generated defect reports for daily defect status meeting
• Interacted with business users for coordinating user acceptance testing
• Analyzed, documented and maintained test results and test logs
• Prepared test summary reports and test metrics

Environment: Informatica Power Center8.1, Cognos8.x, Oracle10g, SQL, Pl/SQL, Teradata SQLDeveloper, Teradata SQL assistant, Test Director, Quality Center, Shell, control-M

Confidential

QA Analyst

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Involved in preparing test data required for all phases of testing
• Prepared and executed system test cases to test the functionality of individual modules
• Performed system testing, regression testing and end to end testing
• Interacted with senior peers or subject matter experts to better understand the application and perform functional and data validation
• Prepared defect analysis report and root cause analysis report for identified defects
• Performed backend data validation stored in backend database using SQL
• Reported the Bugs/Defects using Quality Center 10 defect management tool.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Exported Manual Test Cases from MS Excel template directly to QC and executed the Test Cases in Test Director with Pass/Fail/Blocked status.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participated in test readiness review meetings

Environment: Quality Center 10, Oracle, SQL, Toad, MS Excel, UNIX