SUMMARY

• 11 years of experience in Software Quality & Testing arena, used various methodologies and automated tools.
• Expertise in Functional testing, ETL Testing, Regression testing and Automation.
• Has extensive experience in Testing Web based, client - server, Data Warehousing solutions, ETL and Business Intelligence solutions.
• Strong experience in ETL testing, Data Conversion Testing and Automation.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Good knowledge of ISO & SEI-CMM.
• Expertise in Banking & Finance domains.
• Has good experience on Agile and Waterfall processes.
• Experience with Mentoring, coordinating and Leadership roles in creation and execution of QA and Testing.
• Successfully handled & delivered various projects in onsite/offshore model.
• Working closely with Delivery & Program Managers as liaison between offshore & onshore team members & ensuring end-to-end delivery of quality products to client within defined SLA.
• Hands on experience in handling multiple Testing projects in different environments at Project & Program Level and ensuring quality of the deliverables as per schedule, managing scope, issues, risks and changes.
• Proficient in Automation Framework creation and development of Test Libraries, Shared Object Repositories and reporting libraries.
• Very good understanding of Data Warehousing concepts, Data Analysis.
• Expertise in writing complexSQL queries for back-end testing.
• Excellent interpersonal, communication, documentation and presentation skills.
• Have experience in Bulk loading data from Flat files into Oracle using SQL Loader.
• Experience in testing several complex reports generated by Cognos, Focal Point including dashboards, summary reports, master details, drill down and score cards.

TECHNICAL SKILLS

ETL Tools: Ab Initio, Informatica

QA Methodologies: Agile, Iterative, Waterfall and Spiral Methodology

Functional Testing Tools: QTP, UFT

Test Management Tools: QC, ALM

Operating Systems: Windows XP, UNIX

Databases: Oracle, SQL Server, and MS-Access

Languages: SQL, PL/SQL, UNIX Shell Scripts, VB Script, Java, XML

PROFESSIONAL EXPERIENCE

Confidential

QA Lead

Responsibilities:

• Analyzing the Business requirements and Rules by working with Business analysts and Product Owners.
• Preparation of Test Plan and Test Strategy for both Manual and ETL testing.
• Preparation of Test Cases using User Story and Use Case documents.
• Responsible for Work Allocation and Review Test Execution Results reported by QA Engineers.
• Analyzing the Test Result from QTP Scripts for Various Loan Products.
• Designed Summary Reports, Traceability Reports using Reports from Quality Center.
• Developed Reusable Functions using Keyword Driven Framework in QTP.
• Successfully implemented Mercury Quality Center for Requirement Management, Test Design and Defect Logging with Test Cases.
• Test Execution, Defect logging, Requirement Mapping with Test cases.
• Track Bugs through tracking system - Quality Center.
• Tested Web Application for both Positive and Negative Testing in order to cover all possible scenarios viz. Standard, Pricing and Optional offered to vehicles.
• Determining the Entry and Exit Criteria for different phases in testing cycle of the system.
• Generated Weekly Reports, Defect Reports, Test Summary, Requirement Traceability Reports, Test Statistics and Customized Summary Reports.
• Participated in meetings with Business Analysts and Developers & Conducted Knowledge Sharing Sessions and Training to Team Members.
• Involved in Manual Test Case Preparation and Test Case Execution.
• Tested several complex reports generated by Ventyx Focal Point tool including Dashboards, Summary Reports, Master Detailed,Drill down.
• Attending and Conducting External Walkthrough and Peer Review meetings for Test Plan, Test Scenarios and Test Cases.
• Extending and maintaining the automation regression test suite.
• Preparing and Executing the Automated scripts/Excel Macros to compare the source destination files in ETL testing.

Environment: CHORDIANT, TIBCO, ACTION

Confidential

QA Lead

Responsibilities:

• Developed Conversion Test Strategy for end to end data conversion from Maestro to Symphony.
• Automated end to end process of data conversion testing.
• Developed two automation scripts to validate data at Phase I and Phase II of Data Conversion.
• Strong experience in data migrator package testing and reviewing config files of data migrator package.
• Developed 4000 queries at Maestro and Chordiant level.
• Followed the Symphony business application diagram to develop the queries for conversion testing.
• Extracted complete branches data (50,000 records per branch) for Increment testing.
• Extensive experience in executing ETL jobs and analysis for rejects.
• Worked with Solutions, mapping teams to understand the business requirements.
• Tested the data conversion / Migration transformation logic from source system to destination system.
• Interacted with Developers, Project Manager and Client for business process.
• Automated to extract the Maestro branch data through PUTTY.
• Created and Tested Request and response files, Verified with the logs and database.
• Automation script developed to read XML file values and compare with Staging and Chordiant database values.
• Executed UNIX Batch jobs (Shell scripts) and verified the file feeds and extracts.
• Performed Backend testing with SQL queries, Verified front end data / File data matching with the back end data.
• Created Test data according to the requirement.
• Experience in documenting using Microsoft Visio package.
• Performed Joint / Integration and end to end testing.
• Built test cases in Quality Center.
• Executed Quality center reports and uploaded those reports to share point.

Environment: CHORDIANT, TIBCO, ACTION

Confidential

Quality Analyst

Responsibilities:

• Developed business components using Business Process Testing (BPT)
• Executed automation business components in 7 rounds of Gen 1B Increment Execution.
• Validated 6 languages of Gen1B application using Business Components.
• Developed business components for Cognos Reports.
• Performed user interface and functionality testing.
• Written Test Cases based on software requirement specifications and created Test Data.
• Created XML files with test data according to the requirement.
• Performed Batch testing with Quality Center.
• Involved in release management to solve issues and new development requests.
• Involved in all testing stages of waterfall methodology.
• Developed automated test scripts from manual test cases for regression testing based on the requirement documents using Quick Test Pro.
• Created various Scripts for the Application using QTP.
• Executed automation test scripts and identified defects.
• Prepared the Requirements Traceability Matrix (RTM) and managed requirements.
• Good understanding of the entire Software Development Life Cycle (SDLC) with emphasis on the testing phase.
• Performed back end testing to test whether the data loaded into the database.

Environment: CHORDIANT, TIBCO, ACTION

Confidential

Quality Analyst

Responsibilities:

• Prepared Manual test scripts based on requirements.
• Identifying the End to End scenario’s for automation.
• Prepared automated Test Scripts using VBScript.
• Test scripts review.
• Test Activities included Sanity, Functional and Regression Testing.
• Allocating work to team members and consolidation of the same.
• Reviewed all team members’ automation scripts and provided peer reviewer comments.
• Communicating with Client on functional clarifications of project.
• Business scenario preparation based on the Functional Specification document.
• Logging the defects in Test Director.
• Attended requirements and design meetings, review and analysis of requirements and design documentation.

Environment: SIEBEL7.5.3 on Windows XP.