PROFESSIONAL SUMMARY:

• 6 + years of professional experience in IT with extensive performance Quality Assurance Testing for Front end and Back end Applications.
• Excellent Domain Knowledge in Financial, Retail and Healthcare and Insurance.
• Excellent knowledge in implementation of different Waterfall and Agile QA methodologies /policies, strategies and plans in all stages of SDLC.
• Excellent knowledge in test planning, coordinating, execution and leading the testing process.
• Tested various ETL processes developed using ETL tools like Informatica Power center, SSIS, Ab Initio and DataStage.
• Tested various reports generated by Business Objects, Hyperion, Cognos and OBIEE.
• Proficient in querying various RDBMS like SQL server, Oracle, Netezza, DB2.
• Excellent knowledge of defect management and tracking using Quality Center.
• Adept at backend testing and data validation testing using SQL queries.
• Proficient in Functional, Negative, Regression, System, Integration, User Acceptance (UAT), Security, Usability and compatibility testing during the various phases of the development of the application.
• Experience in performing data validation and preparation of test data in UNIX environment using various UNIX commands and editors.
• 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.
• Experience in selenium IDE and Selenium Web driver.

TECHNICAL EXPERTISE:

Operating Systems: Microsoft Windows, Linux, UNIX

Languages: SQL, Java

RDBMS: SQL server, Oracle, Teradata and DB2

ETL Tools: Informatica Power Center, Ab Initio and Datastage

BI Tools: Business Objects, Hyperion, Cognos and OBIEE

Testing Tools: HP ALM, Rally, Selenium WebDriver

Version Control Tools: Rational Clear Case, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Burbank, OH

QA/ETL/BI TESTER

Responsibilities:

• Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts.
• Sound knowledge and exposure in working with the Oracle, Netezza database and Data stage, Informatica ETL tools.
• Worked in ATLAS for reading/analyzing the requirements for the project.
• Involved in testing the Cognos reports by writing complex SQL queries, tested whether the reports developed in Cognos are as per company standards.
• Worked with business team to test the reports developed in Cognos and ARC developed reports.
• Responsible to translate business requirements into quality assurance test cases.
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases.
• Worked in HP ALM tool as test management tool, DB visualizer tool and Netezza for database, Cognos tool for reports.
• Involved in testing the UI applications.
• Solid understanding of ETL processes: ETL design, ETL testing, and ETL implementation.
• Extensive working knowledge in UNIX operating system .
• Knowledge in Software Development Life Cycle (SDLC) like Waterfall, and Agile .
• Good Experience on Selenium IDE and creating Scripts in selenium web driver by using Java .
• Strong skill in Back end Testing using SQL queries on Oracle and Netezza.
• Proficient in all phases of Test Life Cycle from test planning to defect tracking and managing defect life cycle.
• Strong communication and interpersonal skills to maintain effective work relationships with all levels of personnel .
• Ability to work in a team environment or independently.
• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Prepared all the test scenarios and shared across the team.

Environment: Datastage, Informatica, Oracle, Netezza, HP ALM, Notepad++, Cognos, DB Visualizer, Atlas, SharePoint.

Confidential, Minneapolis, MN

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.
• Involved in end to end testing of the entire process flow starting from the source database to the target DataMart to the reports by considering all possible scenarios.
• Tested procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Tested source data for data completeness, data correctness and data integrity.
• Involved in Unit Testing, integration testing, regression testing and Performance Tuning
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested the XMLs feeds received from another source which is a third party for data consistency.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Prepared test data to cover all the test scenarios.
• Used UNIX scripts to run the Informatica ETL jobs from command line.
• Maintained all the test cases in HP ALM and logged all the defects into the defect module.
• Tested the entire 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.
• Tested the migration of reports from Business objects.
• Tracked defects to closure by coordinating with the dev team.
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.

Environment: Teradata, Oracle, Informatica, SQL, PL/SQL, HP ALM, XML, Oracle 12c, Business Objects, TOAD

Confidential, Durham, NC

QA Analyst

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios.
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the source data for data completeness and data correctness.
• 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 Microstrategy.
• 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 environment for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Co-ordinated with the offshore counterpart for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP ALM 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 Power Center, Oracle 12c, SQL Server, SSMS, UNIX, Putty, MicroStartegy, HP ALM, Toad for Oracle, MS Office, Windows, JIRA

Confidential, Dayton, OH

QA Analyst

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Extracted certain column of data from a number to files.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the Oracle database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Involved in creating both positive and negative test data to cover all business scenarios
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Selenium, Informatica, Oracle, Teradata, Rational Clear Quest, Rational Clear Case, XML Spy, Shell Scripting, SQL Assistant, SQL, PL/SQL, UNIX, Jira, Control M.

Confidential, Deerfield, IL

QA Tester

Responsibilities:

• Reviewed requirements for testability and usability and consulted development staff with regards to system functionality.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Tested the flow of data from front end to backend databases.
• Developed Automation scripts for new enhancements using Selenium WebDriver and Junit.
• Tested the ETL processes that ran to load the reference data into the central repository.
• Develop, maintain and execute manual test cases.
• Performed smoke testing, Functionality testing, Integration testing, and Regression testing.
• Participated in review meetings for creating Test plan and test results summary.
• Analyzing business and functional requirement to design SIT and UAT Test Cases
• Participated to create Test Analysis reports (TAR) and stored them into the HP ALM.
• Updated RTM on daily basis, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Participated in the meetings with business users to present future functionality of the application, gather information from them to know about their need and communicate.

Environment: Selenium, DB2, Datastage, Cognos, UNIX, Windows, Notepad++