SUMMARY:

• 13 years of progressive experience in IT industry with emphasis on Software Testing
• 9+ years of experience as Quality Manager / Senior Test Lead
• Possess CRM and BPM (Salesforce, Siebel & Pega PRPC) and ETL testing experience with Pentaho, Informatica, MS SQL Server
• Possess Federal Government contract experience in National Institutes of Health (NIH) and Centers for Medicare & Medicaid Services (CMS)
• 9+ years of Test Management/Project Management experience
• Expert in HP ALM 11.x, Quality Center including Dashboards and Management modules
• 8+ years as Quality Center / HP ALM Administrator
• JIRA experience for Project Tracking and Test management
• Lead teams with different geographic locations, peak size 30+
• Expertise in Test Estimation Techniques (TCP, UCP) and Quality Tools standardization
• Expert in User Centered Design and analyzing wireframes for business needs
• Expert in Quality Management and Metrics Management
• Expertise in implementing QA process improvements including support of CMM capabilities
• Extensive knowledge in SharePoint for document management
• Strong Client facing skills and experienced in Client / Vendor relationship management
• Thorough knowledge of Software Development Life Cycle and Testing life Cycle
• Hands - on experience in Functional Testing, System Integration Testing, Regression Testing, User Acceptance Testing and Automation testing
• Extensive experience in V&V Model, Waterfall, Agile, Reverse Engineering and Spiral
• Experienced in writing the SQL and DQL queries in SQL Server, Oracle, DB2 and Documentum server
• Experienced in creation and execution of Test Strategy, Test Plan, Test Script and Test Cases for Functional and Automated Testing.
• Prepared Testing Summary Reports, Release Readiness Report, QA Dashboards
• Experienced in QTP and Selenium for regression testing
• Experienced in Web service testing
• Possess excellent domain knowledge in Personal & Commercial Insurance, Financial and Billing Applications
• Experience in managing multiple projects concurrently in onsite / offshore model including implementing efficient and effective Test Strategies, Test Plans, Test cases and Process improvements.
• Strong in Analyzing Functional Requirement Specification (FRS) and System Design Specification (SDS) and convert them in to Test scenarios
• Expertise in analyzing and validating critical business requirements
• Strong communication and Interpersonal skills to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS:

Operating System: Windows XP / 98 / 2k / 7, MS DOS, IBM Mainframes

Programming Languages: C, C++, Visual Basic, Knowledge of Java

Databases & Tools: Oracle (TOAD, SQL Developer), MS SQL SERVER, PL SQL, DB2, Pentaho, Informatica, Aginity Workbench

Scripting Languages: VBScript

Content Management Tool: Documentum 5.3, 6.5

Business Process Management / CRM: PEGA PRPC, Sales Force

Test Management Tools: Test Director 8.0, Quality Center 9.x versions, HP ALM 11.X, 12.x versions, JIRA, TestLinks

Automation Testing Tool: Quick Test Pro 8.x versions

Version Control Tools: Visual SourceSafe, Share Point

Web Service Tools: SOAP UI, Eclipse

SDLC Methodologies: V&V, Waterfall, Agile, Spiral

PROFESSIONAL EXPERIENCE:

Confidential, NIH

Senior Quality Assurance Advisor

Responsibilities:

• Participate in project kick off with NIH representatives and prioritize the testing requests
• Estimate the total size of the project and provide estimates
• Review Change Requests / Business Incidents and assign resources to test
• Managed multiple releases as part of the CRIS / BTRIS program.
• Act as Liaison between BA, Development and the Client team for any testing needs
• Provided UAT Support and training for UAT users in JIRA, HP ALM and SQL
• Estimates review, Resources planning and allocation
• Cognos reports testing using SQL Server and Netezza as back end.
• Identify the training requirements for team and provide the necessary platform for training
• Responsible for testing deliverables in each stages and provide walkthrough as needed to the client
• Train and Mentor the team in QA process, including Best Practices
• Review Data migration strategy document and provide inputs
• Involved in MS-SQL Server tool migration from 2009/2012 to MS-SQL Server 2016
• Hands on test leader during test execution phase and provided leadership thoughts for optimizing the process
• High Level data Analysis, participate Data Migration strategy meetings
• Review Data dictionary and perform analysis
• JIRA Project Administration, created Dashboard reports, Metrics reports and managed user access
• Participate in Design review meetings with Architecture team and provide inputs
• Delivered all the modules on time without any production issues
• Metrics Management for all the releases, and provided necessary metrics for upper management decisions.
• Wrote complex SQL queries to test the ETL transformations
• Involved in Source to Target Testing (Validation Testing), Metadata Testing, Data Completeness Testing, Data Accuracy Testing, Data Transformation Testing, Data Quality Testing.
• Participate in ETL testing the transformation rules for each module using MS-SQL queries
• Perform End to End testing and provide UAT support
• Participate in status meetings and provide status
• Defect meetings with Development, Business users on need basis
• Participate in GO / NO-GO meetings and provide sign off
• Review and Publish status reports and metrics for senior management to track the progress of the project

Test Management Consultant

Responsibilities:

• ETL Test Strategy implementation (Informatica / DB2)
• Involved in ETL testing strategy implementation using ETL testing framework as part of the Master Data Management program.
• Prepare and review Data migration testing strategy document
• Identified Risks and provided mitigation process
• Hands on test leader during test execution phase and provided leadership thoughts for optimizing the process
• High Level data Analysis, participate Data Migration strategy meetings
• ALM Project Administration, created Dashboard reports, Metrics reports and managed user access
• Participate in Design review meetings with Architecture team and provide inputs
• Helped the team with Metrics Management for all the releases, and provided necessary metrics for upper management decisions.
• Managed Source to Target Testing (Validation Testing), Metadata Testing, Data Completeness Testing, Data Accuracy Testing, Data Transformation Testing, Data Quality Testing.
• Participate in ETL testing the transformation rules for each module using SQL queries
• Participate in status meetings and provide status

Lead Testing Consultant

Responsibilities:

• Participate in User stories discussion
• Estimate the Level of effort required for each user story and assign testers
• Lead and mentor a team of 6 testers.
• Mentoring the team members and task allocation
• Make Testing related decisions in the project
• Tool evaluation for testing needs
• Review Data migration strategy document and provide approval
• Analyze the user stories and walkthrough the scenarios with the client team
• Conduct Stand up meetings during testing phase
• High Level data Analysis, participate Data Migration strategy meetings and storyboard meetings
• Review Data dictionary and direct contact with Business, Analysis and Development personnel for any clarifications
• Wrote complex SQL queries to test the ETL transformations
• Performed Source to Target Testing (Validation Testing), Metadata Testing, Data Completeness Testing, Data Accuracy Testing, Data Transformation Testing, Data Quality Testing and GUI Testing
• Participate in ETL testing the transformation rules for each module using SQL queries
• ETL data flow in to Salesforce UI
• Sales Force (Accounts, Contacts, Opportunities) workflow validation using GUI
• Integration testing between Sales Force and other AOL systems for data integrity
• Test the automation process (Java based batch file) to push data from Salesforce to MPS system (includes updating tables, creating tables, updating table data, retrieving data)
• Perform End to End testing and provide UAT support to AOL testing team
• Pre-production and Production testing in AOL systems
• Participate in Production testing and provide Migration Testing Sign off
• Participate in daily stand up meetings and provide status
• Participate in GO / NO-GO meetings and provide sign off

Senior Testing Consultant/Test Management Consultant

Responsibilities:

• HP ALM Project Administrator
• Lead and Mentor a team of 10 onsite and 4 offsite testers.
• Database testing using HOD (DB2) with ISPF
• Micro strategy reports validation testing with DB2
• Write SQL queries to fetch data for testing needs
• Prepare Functional Test Plan, UAT test Plan, Test Summary Report, Release readiness report
• Provide hands on training to team on HP ALM
• Create Dashboards in HP ALM for metrics reporting
• Create and review Requirement Traceability Matrix in HP ALM
• Prepare and review Functional Test Plan and review with the stake holders
• Mentoring the team members and task allocation
• Test cases execution in HP ALM
• Coordinate with Automation testing team for test data needs
• Review and Publish status reports and metrics for senior management to track the progress of the project

QA Lead

Responsibilities:

• Managing the Testing team of 12 members and Coordinating testing resources for end-user testing activities including Test Strategy preparation, Test Plan reviews, Testing Estimate preparation and Publishing Testing schedule for approvals.
• Capture all the Business Flow / Work flow rules and get the sign off from Project Owner, Architect, and Project Manager to create test cases
• Prepare Test data, User list, Reports list for testing the PRPC rule
• Prepared Test Strategy to Test PEGA PRPC Implementation across Confidential and implemented the best practices.
• Co-ordination with Users for training them in PRPC platform
• Documentum to PEGA integration testing using DQL / WebTop
• Defect Management-Responsible to conduct Defect Triage Call to track the defect data and follow-up with the defects through their lifecycle till closure.
• Manage end-to-end Quality Assurance and Validation activities on day-to-day basis across client business areas.
• Quality management - Manage the validation activities for the entire Validation Life Cycle activities.
• Act as a Single point-of-contact for Validation communications, monitoring and resolution for applications supported
• Verification of documents in EMC Web publisher
• Prepare test data for data drop simulation to create tasks in PEGA
• Co-ordination with Business Analysts for review & sign off on the test artifacts
• Facilitate defect triage meetings with Business Analysts and Developers during Test Execution
• Preparation of Production Checkout Test Plan and performing Production Checkout Testing
• Prepare and execute DQLs to validate metadata in documentum
• Coordination with the Business team for requirement walkthroughs, ambiguity clarifications, quality test conditions & test cases deliverables, test execution and Daily / Weekly status reports

Automation Test Analyst

Responsibilities:

• Preparation of Automation Framework (Driver Script)
• Execution of Test Cases
• Preparing and review of Automation scripts (Functions, Libraries)
• Coordination with Client and offshore team
• Preparation and Review of Test Cases & test data
• Preparing Automation test data
• Defect Reporting and Tracking
• Metrics collection and reporting
• Status reporting to the client

Test Analyst / Module Lead

Responsibilities:

• Developed an in-house tool for rate logic validation using Macros in MS-Excel to test the rating requirements
• Requirement Analysis
• Preparation, Review and Execution of Test Cases
• Identify and automate critical test cases
• Defect reporting and tracking
• Preparation of Test Summary Reports and Project Management Metrics
• Key Player in building Application Knowledge Repository