EXPERIENCE SUMMARY:

• Around 10+ years of experience in the field of IT with strong experience in various Test Methodologies and Processes having been extensively involved in various User Acceptance Testing, Functional Testing and System Integration Testing for US Healthcare, Retail and HRMS domains. Involved in analyzing requirements, writing and executing test plans, designing test cases and procedures, preparing test data, setting up test environment, creating defect documentation, requirement traceability matrix and test summary reports.
• 6+ years of extensive experience working on Agile process
• Persuading Scrum master certification.
• Experience in leading a team of 8 QA engineers.
• Agile Product Lifecycle Management (PLM) experience.
• Having 6+ years of experience in Healthcare Domain
• Acted as a scrum master for 2.5 years.
• Experience in ETL/Data warehouse backend testing
• Experience in testing mobile apps.
• Exposure to Onsite - Offshore work model involving day to day activity planning, guidance, defect review and coaching
• Good hands on knowledge of SDLC methodologies
• Extensive experience in writing SQL queries to perform DB testing.
• Exhaustive experience Software testing processes - Test Initiation, Test Planning, Test Execution and Test Closure activities
• Expert in testing client/server, mainframes and middle ware (EDI) based business application including development and implementation of test plans, test cases.
• Expertise in EDI transactions used in healthcare industry and good knowledge of HIPPA X12.
• Expertise in Healthcare domain and US benefits.
• Lead various Functional, User Acceptance Testing, System Integration projects involving Data Migration testing, Data Warehouse & ETL testing, Reporting and Business/Data Analytics projects and bringing them to successful closure
• Acquired sound skills in testing methodology - Preparation of Effort Estimation, Test Plan, Test Scope document, Test Scripts, Data guidelines, Run plan, Day-Zero checklist and Test Execution involving End to End Defect Management
• Prepared Quality Management System (QMS) related documents such as Project Performance Report, Team Access Matrix, Customer Property Logs, Review Logs, and Time Sheet.
• Involved in Gap-analysis to bridge the gap between the BRDs and FSDs, Impact Assessment and Risk Analysis
• Developed quality assurance standards, processes, procedures and documentation templates
• Expertise in using Test/Project Management tools like JIRA, Rally and HP Quality Center/ALM
• Effectively projecting the Project/Program tracking to reflect clear Project/Program status to various stakeholders
• Prepared various SOP documents streamlining critical procedures
• End-to-End Defect Management - Logging defects, co-coordinating with the Business and development teams to track them to closure using Test Management tools like HP Quality Centre/ALM and Rally
• Expert in conducting JAD sessions with executive level Business Stakeholders, User Clients (End Users), Technical Teams and Project Directors.
• Proficient in writing SQL queries and understanding SQL Tables, SQL Procedures and Data Schema.
• Experience on working with Oracle Forms and Reports.
• Experience in ETL tools like Informatica.
• Experience in testing web services using soap UI, Rest console and Postman.
• Highly responsible and reliable team leader with strong analytical problem solving skills and initiative in decision making
• Exposure to automation testing - QTP

TECHNICAL SKILLS:

Databases & Tools: Oracle SQL Developer, Oracle Toad

Operating System: Windows 95/98/XP/Windows 7, UNIX

Platforms: Oracle apps, .net, Java, Tibco, Drupal and VB

Tools: Jira, SOAP UI, Quality Center, HP ALM 11, QTP

Web Technologies: HTML, Java script, VB Script, XML

Defect Tracking tool: SharePoint, Quality Center, Rally, Jira, Star team, TFS and Test Director

Test Management Tool: HP Quality Center and Jira

Browser: Mozilla Firefox, Google Chrome and MS Internet Explorer

Domains: Healthcare, Retail and HRMS

Microsoft Tools: Excel, Word and PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Web Application, .net, SQL, Agile Model

Business Analyst/QA Lead

Responsibilities:

• Work with developers, user experience designers, subject matter experts and QA teams to obtain a well-rounded understanding of what is being asked for and ability to deliver it within the constraints.
• Reviews business requirements, use cases, User Acceptance Test (UAT) plans and testing outcomes. Develops and maintains Standard Operating Procedures.
• Analysis of requirements for new project and impact analysis.
• Preparing the project and deployment plan of the activities.
• Preparation of Functional Specification, Technical Specification documents.
• Requirement Gathering.
• Perform Gap analysis in identifying the gaps between requirements and system developed.
• Creation of test scripts, test plans and test execution.
• Involved in UAT testing and addressing UAT issues.
• Mobile app testing.
• Participating in Go live activities and Post production support - addressing user issues/concerns.
• Perform Interface and Integration testing.

Confidential

Environment: Web Application, .net, SQL, Agile Model, EDI

Senior QA Analyst/ PLM Lead

Responsibilities:

• Performed System, Functional, Integration, End to End, Regression testing.
• Performed EDI transactions testing.
• Edited and created test data for EDI and HL7 transactions
• Tested EDI transactions such as 837 and 835
• Involved in analyzing business and technical requirements and developing strategic test plans, test cases and test scripts and responsible for executing the test cases, test scripts
• Worked with Business Analysts to define testing requirements to satisfy the business objectives
• Efficiently managed multiple projects simultaneously under crunched timelines
• Responsibilities include meeting the developers and client groups to determine performance requirements and goals and to determine a test strategy that is based on requirements.          
• Developed Test Plans and Test Cases for System, Integration and Regression Testing from Business Requirements, System Requirements
• SoapUI testing for web services.
• Collaborate with Business, Development Team to ensure effective project execution
• Organize and attend review meetings and walkthroughs to understand the requirement documents and the application.
• Trained team members to implement good testing practices and test methodologies
• Extensively involved in Functional, Regression, User Acceptance, Interface System testing, Data Integrity, Compatibility and End to End Testing 
• Prepared Quality Management System (QMS) related documents such as Project Performance Report, Team Access Matrix, Customer Property Logs, Review Logs, and Time Sheet.
• Prepared Test Data for all the possible scenarios and validated the same across the Source Systems and Data Warehouse
• Extensively used SQL queries on SQL server to validate data
• Validated data flow from Source system to downstream systems
• Involved in Testing Change Requests (CRs) to enhance the existing code and various AD-hoc and Maintenance tickets
• Coordinate with Development team and Business during Execution for defect resolution
• Involved in Root Cause Analysis for the defects found
• Reported the daily Planning and Execution progress
• End-to-End Defect Management using JIRA and TFS
• Interviewed and hired QA Engineers
• Conduct KT sessions on a frequent basis to all team members to facilitate cross module training.

Confidential

Environment: Web Application, Windows based application, .net, Tibco, Vb.net, SQL and Agile Model

Senior QA Analyst/PLM lead

Responsibilities:

• Responsible for QA activities in Scrum team.
• Involved in the complete testing life cycle of a release.
• Involved in requirements gathering, Analysis and Design, Implementation, Testing and Deployment.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Extensively interacted with developers, business& management teams to understand business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA-Test Environment
• Extensively tested several Business Objects Reports - Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.
• Participated in deployment activities

Confidential

Environment: Web Application, .net, Java, SQL and Waterfall Model

Senior QA Engineer

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Extracted data using SQL Assistant and Pass-Thru SQL to Create Data Sets.
• Worked with Agile Methodology.
• Prepared extensive set of validation test cases to verify the data
• Tuned stored procedures/scripts, SQL queries to improve the system performance
• Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code.
• Tested new Data Migration tool used in the mapping of data to new system.
• Data Migration of raw data to excel documents for clients
• Extensively tested Informatica Mappings
• Used Quality Center as central repository to maintain the test scripts and print the status report of the same.
• Studied and understood the Data warehouses, Data Marts sources, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
• Interacted with Business Analysts and Clients to gather the business requirements.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Involved in Extensively during UAT testing of various functionalities along with the implementation team, resolved the issues and problems. Used Test director for bug tracking.
• Analyze defect density from HP Quality Center 9.0, to give heads up for Dev/Architect teams.
• Detailed reporting of results and analysis to PM/Client and all stake holders explaining the impact of the critical tests.
• Analysis of the Change Requests
• Documented and report the test results for the Deployment.
• Perform Regression Smoke test for the new builds before the functional testing using QTP.

Confidential

Environment: Oracle apps, HRMS - OAB, SQL, QC, StarTeam and Waterfall Model

QA Engineer

Responsibilities:

• Testing of new features by creating test specifications, test cases, and working closely with development and business teams.
• Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed data quality analysis using advanced SQL skills.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Extensive SQL querying on Staging, Data warehouse and Data Marts.
• Ensured Error logs and audit tables are generated and populated properly
• Performed UAT and Regression Testing.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tracking and reporting the issues to project team and management during test cycles.
• Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.
• Contribute in the development of knowledge transfer documentation.

Confidential

Environment: Oracle apps, HRMS - OAB, SQL, QC, StarTeam and Waterfall Model

QA Engineer

Responsibilities:

• Analysis of client requirements and preparing test plans.
• Data mining, writing scripts for data mining.
• Fixing and testing the fixes as per the system test plan
• Self/Internal review of work done in the team and onsite interaction.
• Defect preventer of the project.

Confidential

Environment: Web Application, .net, Java, SQL, QC, Jira and Waterfall Model

QA Engineer

Responsibilities:

• Analysis of client requirements and preparing test plans.
• Data mining, writing scripts for data mining.
• Fixing and testing the fixes as per the system test plan
• Self/Internal review of work done in the team and onsite interaction.
• Defect preventer of the project.