SUMMARY:

• Quality Assurance Testing Consultant with over 8 years of industry experience. Experienced in Testing and Quality Assurance of various systems including Insurance Claims Adjudication Systems, Duck Creek Applications, Web - Applications, ETL and Datawarehouse applications, Mainframes and Database applications.
• Over 2.5 years of Experience in Leading QA teams in Offshore-Onshore Model of Project Execution at different client locations.
• Close to 1.5 years of Experience in QA Automation using TAC on Duck Creek Application System.
• Strong experience in performing GUI, Functional, System Integration, End-to-End, Regression, Black box, White box, Smoke, UAT testing.
• Expert in creating Test Plans and Strategies to ensure comprehensive test coverage.
• Proficient in all phases of Quality Assurance Testing Cycle from Test planning to Defect tracking and managing Defect life cycle using HP Quality Center, JIRA, Test Manager.
• Experience in creation of various Matrices for Requirement Traceability, Defect Tracking, Defect Density and Variance.
• Delivery Experience encompassing both Waterfall and Agile methodologies.
• Expertise in Test execution of applications built using COBOL, JCL, DB2, IMS, SQL.
• Efficiently handled role of Defect coordinator between onsite and offshore teams.
• Experience in domains of Health Insurance, Banking, Brokerage, Retail, Property and Casualty Insurance, Commercial Auto Insurance.
• Certified by Confidential Technologies in Banking 100, Banking 200, Insurance 101 and Unified Competency Framework 1.1(Mainframes).
• Proficient in documenting Root Cause Analysis for production defects that were missed in QA and UAT.
• Ability to interact with business stakeholders and work to meet their testing objectives as well as Conducting weekly status meetings with project management, BAs and Developers.

TECHNICAL EXPERTISE:

Testing Tools: Microsoft Test Manager, TFS, HP Quality Center, ALMDuck Creek, Data Tester:

Automation Tools: TAC

Bug Tracking Tools: JIRA, Excel

Operating Systems: Windows, Z/OS (IBM Mainframe), MVS, TSO, ISPF, Unix

Languages: SQL, COBOL, JCL.

File Management Tools: VSAM, File-aid

Debugging Tools: IBM DEBUGGER

Scheduler: CONTROL M

Mainframe Tools and utilities: IBM utilities, SORT, Platinum Utility(DB2),Rumba, File-aid, Beta Mainframe

Database: DB2, IMS, Teradata, Oracle

EXPERIENCE DETAILS:

Confidential

Application Testing and QA Consultant

Responsibilities:

• Querying Production EDW database to identify all the database objects along with their DDLs that needed to be setup in PS2.
• Creation of all EDW Jobs in PS2 by analyzing all the EDW jobs in Pstage
• Performing database validations to ensure that all objects have been created properly.
• Executing dry runs for each CTRL-M job to ensure that the jobs have been setup appropriately.
• Analyzing Job Flows to understand the reason of Job failure and taking necessary corrective action to address failure.
• Performing data and functional validations using SQL to validate ETL loads were accurate.
• Documentation of root cause analysis of job failures and debugging issues.
• Coordinating with source systems to ensure files were received and sanity testing the source files.
• Creating various project level tracking reports for reporting testing statuses.

Confidential

Application Testing and QA Consultant

Responsibilities:

• Perform data validations in Café database to validate accuracy of data.
• Creation of Café Trend automated report using SQL and excel macros to perform data quality checks.
• Validating applications in Production pertaining to member portals, healthcare provider portals, internal package software’s, services like jcaps, edifecs, message queues, jms, web services.
• Performing Root Cause Analysis of Production Incidents, troubleshoot and resolve issues.
• Support Production upgrades for applications and performing application validations.
• Review the Change Request before implementation in Production.
• Manage the Issues raised from users and assign the work items to the team.
• Discuss with the business team to clarify the requirements to get clarity on certain business functionalities.
• Participate in the Production deployment meetings.
• Analyzing Job Flows to understand the reason of Job failure and taking necessary corrective action to address failure.

Confidential

Quality Assurance Lead

Responsibilities:

• Analysis of the Requirements provided by the Client in form of Specification documents and translate them into well-defined Test Strategies.
• Understanding business requirements and creating Test plans/cases to cover all business scenarios.
• Creating Test Plans for Functional Testing, End-End Testing, Integration Testing and Regression Testing.
• Performing Smoke Testing and Functional Testing on the Developed Code and providing QA Sign off.
• Reporting Issues, Tracking Statuses and Seeking Clarifications through JIRA.
• Performing all activities of STLC from End to End - Test planning, Test Case designing and Test Execution.
• Mentoring Team members and reviewing Test Plans and Results from Offshore to ensure Quality of Deliverable.
• Maintaining Issue Log and tracking defects for Requirements as well as Re-testing defects.
• Coordinating Requirements Walk Through sessions with Business Analysts and Offshore.
• Debugging the duck creek manuscripts to identify the exact cause of defect and sharing with development team.
• Reporting Status on progress of Test Execution to Stakeholders.

Confidential

Quality Assurance Lead

Responsibilities:

• Analysis of the Requirements provided by the Client in form of Specification documents.
• Understanding business requirements and creating Test plans/cases
• Performing all activities from End to End - Test planning, test case designing and test execution.
• Performing Rating Testing as per defined Rates & Rules and using complex excel macros.
• Performing Smoke Testing and Functional Testing on the Developed Code and providing QA Sign off.
• Mentoring Team members and reviewing Test Plans and Results from Offshore.
• Responsible for tracking defects and reporting them to development team
• Debugging the duck creek manuscripts to identify the exact cause of defect and sharing with development team.
• Ensuring quality of the deliverables provided to the client from Offshore
• Status Reporting to Onsite for day-to-day activities
• Creating and Maintaining RTM, Velocity Chart, Defect Density and Variance for each Sprint.
• Using JIRA for Issue Tracking, Reporting, Sprint Activities and Clarifications on daily basis.

Confidential

Quality Assurance Lead

Responsibilities:

• Meet with stakeholders to understand the requirements and perform system analysis.
• Attend project kick off meeting and business case walk through meetings.
• Prepare understanding documents and get it reviewed by stakeholders.
• Creating Test Plans for Functional Testing, End -End Testing, Integration Testing and Regression Testing.
• Gather business and functional requirements from business case documents and functional specification documents.
• Coordinate knowledge sharing sessions with offshore testing teams.
• Review High Level testing estimates and test results and getting it signed off from stakeholders.
• Single point of Contact at client location for the Stock Loan for Confidential delivery team.
• Review various COBOL modules and flow diagrams of existing data structures to understand the existing data linkage and create test cases.
• Preparation of status report on daily basis to report the progress of the project and report in Status calls.
• Handling Offshore onshore coordination and handover meetings on a daily basis

Confidential

Onsite Lead

Responsibilities:

• Meet with stakeholders to understand the requirements and perform system analysis.
• Coordinate knowledge sharing sessions and gather requirements. Prepare understanding documents and get it reviewed by stakeholders.
• Attend project kick off meeting and coordinate test case walk through meetings.
• Gather business and functional requirements from business case documents and functional specification documents.
• Review High Level and Low Level design documents and get it signed off from stakeholders.
• Review various COBOL programs for SVI
• Preparation of status report on daily basis to report the progress of all the projects and resource allocation/utilization in Status calls.
• Involved in testing the code performance during the migration process.
• Worked with clients on establishing migration process with IT.
• Actively involved in standby production support during implementations.
• Coordinating testing with QA/UAT Team
• Handling Offshore onshore coordination and handover meetings on a daily basis
• Preparation of status report on daily basis to report the progress of the project.

Confidential

Software Developer

Responsibilities:

• Analyzed the existing system to come up with technical solutions.
• Played a key role in suggesting and implementing process improvements.
• Suggested and implemented Job documentation process for all the ongoing jobs, to have both document in shared drive and Mainframe system for systematic execution of jobs.
• Ensured the proper documentation (like high/low level design, test plan, test scripts, project overview document, etc.) is created for all SDLC phases for the projects.
• Performed the Code walkthrough and Unit test scripts review and also ensured that review is done for all the deliverables.
• Creation of Reusable Code sets for the application and documenting the Run guide for same.
• Identified and communicated project issues / risks to higher management.
• Developed and documented high level conceptual data process designs for review by data analysts for writing codes and test plans.
• Documented the results of unit testing prior to hand off code to the Quality Assurance department.
• Participated in UAT with business users and addressed all user questions.
• Conducted trainings and best practices sessions periodically for new team members
• Ensured that the development abides by Governance guidelines and the Development standards of Nationwide
• Coordinated with the onshore development team members.

Confidential

Software Tester

Responsibilities:

• Analysis of client provided design documents to develop Test Strategies.
• Developed new Test Plans based on FRD and BRD documents.
• Modify and enhance the existing test scripts as per the requirements and the given Technical design document within the given time lines.
• Preparation of Test cases and carrying out UAT Testing, System Integration and Regression Testing and documenting the test results by following Quality procedures in HP QC
• Building the knowledge repository document with the solutions for each and every batch ABEND for future reference or for the test runs.
• Regular meetings with Business Analysts and calls with clients to discuss the work progress and issues.
• Conducting Code walkthrough/review via meeting with developers before commencement of QA phase.
• Successful implementations of multiple Change Requests for the application without a single defect.
• Single point of Contact for any testing related activity.

Confidential

Software Tester

Responsibilities:

• Analysis of the specifications provided by the School Authorities
• Tested the entire employee repository.
• Testing - QA and UAT including performance testing of the Web application.
• Responsible for overseeing the Quality procedures related to the project.
• Checking whether all the functionalities were covered during testing.
• Ensured Proper coordination amongst Team members.
• Participated in knowledge transfer sessions from SMEs
• Coordinated sessions for Understanding business requirements.
• Had the responsibility for Estimation of testing effort of various modules.
• Instrumental in testing the assigned module and Screen flows.
• Was responsible for tracking defects and reviewing with developers
• Collecting information from individual staff/teachers and making data entries for sample testing.