EXPERIENCE SUMMARY:

• 12 years of experience in manual, automation and ETL testing of various applications for financial and health care industries.
• Extensively involved in analysis of functional specifications, business requirements and preparation of test plans, test scenarios, test cases and test scripts.
• Very strong in backend testing using SQL queries and utilities like AQT, SQL Loader.
• Extensive experience in ETL/ Data warehouse backend testing and Business Intelligence (BI) reports testing of Tableau reports and Micro strategy reports.
• Good knowledge and experience with Shell programming on UNIX.
• Proven ability to manage and lead in a team environment.
• Worked in both Waterfall and AGILE methodologies.
• Experience in Agile and Scrum environments
• Strong experience with testing large scale data migrations.
• Worked in onshore/offshore model.
• Scheduled and executed UNIX jobs that perform ETL operations.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL Processes where in the organizations were using Abinitio and Informatica tools.
• Automation testing with different tools like QTP, Empirix Hammer, Level Four Bridge Test

SKILL:

Testing Tools: Mercury/HP QTP, Empirix Hammer, Level Four Bridge Test

Bug Reporting: HP Quality Center/ Test Director / JIRA/ ALM/RTC

UNIX Shell script:, VB Script, Java Script

Programming Languages: COBOL, SQL, PL/SQL, C, C++ and Java

GUI Applications: Visual Basic 6.0

Oracle 9i:, SQL Server 2000, MS Access 2000

Microsoft Excel:, Microsoft Word, and PowerPoint

Record Keeping System: OMNI

WORK EXPERIENCE:

Confidential

Lead QA Analyst

Environment: SQL Server, Omni, Soap UI, API

Responsibilities:

• Worked on an effort to sunset an application and migrate data to a warehouse.
• Worked with the Automation team to troubleshoot the issue when the scripts fail.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems.
• Prepared Test Plan and Test strategy for each release.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica Power center tool.
• Participated in daily stand - up, sprint planning, sprint demo, retrospective, grooming calls.
• Worked with Project Manager, Scrum Master, and Developers to come up with QA testing timelines for each release.
• Worked with BA’s, UX developers in order to get the answers rose by offshore team and maintained Ambiguity Tracker to keep track for each release.
• Coordinated defect triage calls on a weekly basis.
• Supported the UAT team during their testing.
• Worked on production issues and production validation during the release.
• Worked with onshore, offshore team members, reviewed their test outline, test cases and test results.
• Worked with TDM (Test Data Management) team for the data requests.
• Worked with OMNI to do posts and mini posts for the test data set-up.
• Participated in Sprint demo calls to demo the delivered functionality of the completed sprint.
• Participated in the retrospective calls.
• Tested the services using Soap UI application.
• Performed browser testing and mobile testing using Sauce labs and Mobile labs.

Confidential

QA Analyst

Environment: Java, Micro strategy, PL/SQL, Abinitio, Oracle, JSP, JavaScript, UNIX

Responsibilities:

• Participated in functional requirement and code reviews with BAs and developers.
• Represented testing team for ensuring test coverage and mapping of requirements to test scripts.
• Participated in test data analysis and creation of test data for multiple components.
• Defined tests to be added to a regression/automation suite.
• Created SQL stored procedures to minimize test data creation effort.
• Ensured test environment reflects requirements for test execution.
• Executed functional, integration and end to end test scenarios and test cases.
• Created Shell scripts to schedule/run ETL tasks on UNIX using Vi editor.
• Scheduled and executed Unix Jobs that perform ETL operations.
• Verified the log files using Unix Shell Commands like grep, find, to troubleshoot any job failures.
• Tested the BI Reports using SQL’s to validate data on the reports.
• Validated the ETL data load by running SQL queries against Oracle database.
• Executed ETL procedures in Informatica to validate ETL processes.
• Reviewed test results, applied analytical skills to identify when issues need to be escalated and identified associated risk and/or impact.
• Updated/added PL/SQL script in the Patient Creator tool to handle changes for each release.
• Wrote and reproduced accurate software problem reports including steps to reproduce the defect
• Prepared overall test status reports with results of test case execution.
• Updated the score card for every sprint to send the metrics to management.
• Analyzed customer reported bugs in issue tracking system to ensure quality goal is accomplished.
• Coordinated with developers, Business Analysts and other testers by distributing the work and supported them by providing subject matter expertise.
• Worked on production issues, prod events and prod validation for the releases.

Confidential

Automation Tester

Responsibilities:

• Developed Automation test scripts in Mercury QTP for some Mortgage web applications like Visual Mortgage, Mortgage Network, and Military Banking.
• Involved in pilot project for IVR testing using Empirix Hammer tool.
• Involved in pilot project for ATM testing using Level Four Bridge test tool.
• Worked with support team to get the Tivoli updates installed on Virtual ATM machine.
• Used Quality Center (QC) to log the defects found during script execution.
• Managed daily Defect meetings.
• Provided Test result reports to management.
• Achieved test script automation goal for each release.
• Updated Traceability Matrix.

Confidential

Software Developer

Environment: Java, JUnit, Eclipse, SQL Server, Microsoft Content Management Tool

Responsibilities:

• Designed and developed a human resources application to manage employee information and employee skills information.
• Prepared the high-level class diagram.
• Developed the application.
• Component tested using Junit plug-in in Eclipse.
• Prepared the test scripts for QA purposes.
• Performed Unit testing.

Confidential

Role: Software Developer

Environment: VB, ORACLE, Crystal Reports

Responsibilities:

• Designed and developed an application to issue Loans and recovery process for Co-operative Credit Society, Confidential using Visual Basic as front end and Oracle as back end.
• Gathered requirements from customers.
• Designed Database schema.
• Wrote and executed clear concise Test Plans, Test Codes, Test Cases, Test Scripts and Defect Reports.
• Carried out test activities as required, testing cases beyond the pre-existing situations.
• Provided assistance and directions to team members.
• Reviewed and improved Test plans to ensure effective checking.

5