Subba Reddy Jonnala

Software Test Lead (QA)

email-id: adkafb@r.postjobfree.com

Mobile no: +1-647-***-****

Experience Summary

ISTQB, HP Certified QTP and ALM Professional with 14+ years of experience in the field of Software Testing. Expertise in Manual testing, ETL Testing (10+ Years), Automation testing and proficient in Software Engineering Process Models and Standards. Expert in ETL Testing, P&C Domain, IBC, GAA reporting & Banking Domain.

Testing Experience (Functional)

• Proficient in Black Box testing like ETL Testing, Functional Testing, Integration Testing, System Testing, Regression Testing, Installation Testing, Usability Testing

• Expert in P&C domain and hands on experience in IBC & GAA reports testing (Auto stat plan premiums reporting, Losses, commercial liability, QASP, FCSA & Schedules 89 & 90)

• Work with business and development teams to understand the requirements and plan accordingly

• Planning, deploying and managing the testing effort for any given project/engagement

• Experienced in efforts estimation, resource allocation and delegate testing activities

• Handled diverse team of Quality Assurance specialists Onshore – Offshore model

• Building up and leading the 20+ Testing Team members to the success of project

• Enhance QA methodology for test, defect management and tools supporting processes

• Review test strategies and test plans and ensure coverage for functional, SIT, performance and aspects are covered and tested

• Supporting and assisting in UAT planning and execution

• Well versed with the End to End testing activities from initiation till closure (test planning to Production deployment)

• Maintain defect triage process and continuous defects review and communicating the same to project team

• Defining the scope of testing within the context of each release/deliverable

• Applying the appropriate test measurements and metrics in the project

• Coach, develop and provide guidance to team members on QA processes and best practices

• Report bugs, create and provide metrics on bugs as they move through the bug cycle

• Present QA status of testing with state-of-the-art dashboards and highlight key blockers and where help is needed to the business/leadership teams

• Review of Scenarios, Test cases and traceability matrix

• Proficient in different software development life cycle models, CMMI level procedures and processes

Testing Experience (ETL)

• Extensive experience in testing and reviewing of dimensional modeling (Star and Snowflake) of data warehouse & managing 20+ member teams

• Work experience reviewing and testing of data maps between various legacy systems and relational databases

• Experience includes testing of applications which use integrated databases using SSIS, Informatica, Teradata, Oracle, SQL Server and DB2

• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications

• Worked in multiple responsibilities such as reviewing of ETL architecture, ETL design, analysis and ETL technical specifications

• Strong hands on experience in ETL Testing on relational databases, flat files, Xml’s using SSIS & Informatica

• Extensive experience on test data planning for multiple releases, data loads on to QA environments using Control-M scheduler tool

• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact with databases

• Solid Back End Testing experience by writing complex SQL Queries Education

Bachelor of Technology in Computer Science and Engineering from Jawaharlal Nehru Technological University Hyderabad

Technical Skills

Insurance Software(s) : Duck Creek (P&C)

Testing Tools : HP-QTP 9.2v, 10v, 11v

Languages : C, C++, Java

Scripting Languages : Shell Script, HTML, VB Script, Java Script ETL Tools : SSIS, Informatica & Ab Initio

RDBMS : Oracle, SQL Server, Teradata

Information Discovery tools : Oracle SQL Developer, Teradata SQL Assistant Toad for DB2, SQL Server Management Studio

Operating Systems : Windows 2003, XP, Windows 8.

Defect tracking tools : Azure Devops, TFS, HP-QC, ALM, JIRA Version Control : Visual Source Safe 6.0

Job Scheduler tool : Control M

Bulk Data Processing : Mainframe

BI Reporting tools : MicroStrategy, Web Focus (Operational & Financial) Certifications

ISTQB -ISEB Foundation Level (British Computer Society Certified Tester)

HP Quick Test Professional v11 ExpertONE Certification (Hewlett Packard Certified)

HP Quality Center v11 ExpertONE Certification (Hewlett Packard Certified) Engagement Overview

COMPANY PERIOD DESIGNATION

CAPGEMINI CANADA Inc 05-FEB-2018 to 09-Feb-2021 Senior Consultant CAPGEMINI INDIA Private Ltd 14-JAN-2016 to 02-Feb-2018 Senior Consultant TATA CONSULTANCY SERVICES 15-Sep-2010 to till date IT Analyst VIRTU TECH SOLUTIONS Aug-2008 to Aug-2010 Software Test Engineer IDIKA SOLUTIONS Feb-2007 to June-2008 Software Test Engineer Project Experience

Project#9 (Jul-17- Feb-21)@ Capgemini Canada Inc.

Project Name : Genesis Program (WAVE application – Duck Creek) Client : Northbridge Financial Corporation, Canada Role : Test Lead

Environnent : Duck Creek application, Azure Devops, Team Foundation Server Putty & SharePoint, SQL Server Management Studio, Control-M, SSIS & WinsQL Testing type : ETL Testing

Project Description:

The underlying objective of this project is to bring Wave (Duck Creek application) data into the new EDW in order to facilitate the analytical needs of the business. The data scope for this project is not specific to any Genesis Wave project and will include data from SB, IRCA, CAP2, CAP3

(non-Fleet), MMF, MME, PSP/WIP etc. As desired by the business, all requested data will be brought through to the EDW Datamart layer and made available for analysis. Additionally, some data elements will also be exposed to the business using the Insight BI Tool (MicroStrategy) & Legacy reporting is also in scope for Operational and Financial reporting (Web Focus). Contribution:

• Analyze Business / Functional requirements by interacting with Business, Development and Project team

• Analyze system (functional and non-functional) requirements and review the functional design specifications

• Involved in Understanding the requirements and preparing the test strategy, test plan Performing functional, System and Regression testing

• Documented Test Results, Traceability Matrix Consolidation and preparation of test summary reports, daily status reports and weekly status reports

• Review the FSD, Data Model & STM’s as per the business requirements

• Ensure the overall quality of the project & Data loads using Control-M on to QA env

• Established “Best Practices” and plan for continuous improvement of processes

• Data Validation between Staging, Integration & Datamart using complex queries as per the source target mappings

• Validations of BI reports (Operational & Financial) in MicroStrategy and Web Focus

• Identified, report bugs with logs and traces appropriate root cause to the problem

• Reporting bugs and Requirement walk through Daily interaction with the client & onshore team about status and execution plan

• Review Test cases at Feature, Module, Regression and Business Process levels

• Expert in multi-tasking on parallel releases & involved in end to end project initiation to PROD deployment

• Successfully delivered around 15+ releases on the above major project in the past 3.8 Years

• Show casing the QA metrics to the PM’s and senior management Project#8 (Jan-16- June-17)@ Capgemini India Pvt Ltd Project Name : Test Data Management

Client : California State Automobile Association, USA Role : Test Lead

Environnent : TDM Central tool, Informatica, Cognos, Oracle, SQL Server, Unix, Citrix, Putty & SharePoint

Test Tools : HP -ALM.

Testing type : ETL Testing

Project Description:

Create a Centralized Test Data Management (TDM) services that can serve entire enterprise to provide a consistent tools, framework, processes and test data for all project needs of the Enterprise Data Warehouse (EDW) and Business Intelligence. Contribution:

• Analyze Business/Functional requirements by interacting with Business and Project team

• Preparation of Test Strategy, Test Plan and Effort estimates

• Extracting the data from different source systems and loading them to the TDM Central environment and validating the Source and TDM central tables data

• Develop test procedures and other quality documentation: test plans, test cases, and status reports for management

• Responsible for Identifying scenarios and creates SQL scripts for identified scenarios validate data transformations

• Running the data loads to the target environments

• Test data design and preparation

• Data mining and reservation for future needs

• accept and clarify testing requirements

• identify and prioritize test conditions addressing product risks and features to be tested

• define specific tests that must be designed for that area

• design test cases and sets of test cases to cover test conditions

• identify necessary test data to support test conditions and test cases

• schedule test executions in order

• execute or delegate exploratory, automated, and regression tests

• analyze actual results against the expected ones

• participate in the technical review process contributing behavioral viewpoint

• Bug metrics and triage

• Validation of Cognos BI Reports

• Involved and coordinated SIT testing with multiple teams

• Support provided to the business users on the UAT testing

• Reviewed the UAT bugs/observations and root cause analysis was prepared and best practices implemented in the next upcoming releases

• Calling out the risks/issues foreseen with the senior management Project#7 (Apr-13- JAN-16)@ TATA Consultancy Services Project Name : ICDW Migration.

Client : JPMorgan Chase, US

Role : Test Lead

Environment : Informatica, Teradata, DB2, Control M, Citrix Unix shell scripting

Test Tools : HP -ALM.

Testing type : ETL Testing

Project Description:

Aim of the project is to replace the existing Data Warehouse EDW (Enterprise Data Warehouse) with ICDW (Integrated Customer Data Warehouse). EDW is JPMC’s main tool for customer data warehouse, being a legacy application, is less flexible in accommodating improvements in the operational Customer Information. JPMC has chosen ICDW (Teradata) to replace majority/whole of EDW functionalities. Implementation of EDW requires that the product needs to be integrated with the JPMC systems that EDW is already interfacing with. This also requires data to be migrated from EDW to ICDW.

Contribution:

Involved in ETL, Automation & Manual testing for the following activities:

• Analyze Business / Functional requirements by interacting with Business, Development and Project team

• Analyze system (functional and non-functional) requirements and review the functional design specifications

• ETL Test Cases Preparation based on the business requirements and Mapping Logic

• Prepare and Review Test cases at Feature, Module, Regression and Business Process levels

• Executing the test cases, Reporting bugs and Requirement walk through Daily interaction with the client & onshore team about status and execution plan

• Testing the result by preparing SQL queries for source and target for each scenario in functional spec

• Data validation using Information Discovery tools, preparation of test execution report

• Involved in Understanding the requirements and preparing the test plan Performing functional, System and Regression testing to make sure application is meeting all the requirements

• Documented Test Results, Traceability Matrix Consolidation and preparation of test summary reports, daily status reports and weekly status reports

• Execution of functional test cases, to the compliance of the functional design documents

• Detect, analyze and report bugs with logs and traces appropriate to the problem, for further analysis by the development team

• Mentoring new members

• Ensure the overall quality of the project

• Plan the necessary skills update for the team to perform the tasks efficiently

• Review the functional documents and Requirement analysis document and raised reviewed comments against it and got it fixed

• Established “Best Practices” and plan for continuous improvement of processes Project#6 (JAN-12-FEB-2013)@ TATA Consultancy Services Project Name : Cabin Crew Tracking.

Client : British Airways, UK

Role : Test Lead

Environment : Informatica, Oracle, SQL/PLSQL, WinCvs, Xfree86, MVS Unix shell programming, Detail Navigator

Test Tools : HP-QTP 10.0, HP-QC 10.0

Testing type : ETL Testing

Project Description:

Aim of the project is to replace the TRACIE with iFlightCrew. TRACIE is BA’s main tool for cabin crew roster maintenance and on-the-day control. Being a legacy application, TRACIE is less flexible in accommodating improvements in the operational management of cabin crew. BA has evaluated a number of Crew Tracking products available in the market and has chosen IBS’ iFlightCrew product to replace majority/whole of TRACIE functionalities. Implementation of iFlightCrew requires that the product needs to be integrated with the BA systems that TRACIE is already interfacing with. This also requires data to be migrated from TRACIE to iFlightCrew. Contribution:

Involved in ETL, Automation & Manual testing for the following activities:

• Analyze Business / Functional requirements by interacting with Business, Development and Project team

• Analyze system (functional and non-functional) requirements and review the functional design specifications

• Preparation of test strategies, test scenarios, test cases & created input test data in Quality Center for various modules

• Data Loading to the downstream systems and validating the tables against the files loaded

• Executed test scripts in QC, Performed Manual Testing on various Modules & Functionalities of the Application as per the Functional and Business specifications documents

• Preparation of test execution report

• Documented Test Results, Traceability Matrix Consolidation and preparation of test summary reports, daily status reports and weekly status reports

• Prepare and Review Test cases at Feature, Module, Regression and Business Process levels

• Execution of functional test cases, to the compliance of the functional design documents

• Detect, analyze and report bugs with logs and traces appropriate to the problem, for further analysis by the development team

• Submitted status report and feedbacks in daily meetings with clients

• Mentoring new members

• Ensure the overall quality of the project

• Plan the necessary skills update for the team to perform the tasks efficiently

• Review the functional documents and Requirement analysis document and raised reviewed comments against it and got it fixed

• Established “Best Practices” and plan for continuous improvement of processes Project#5 (SEP-2010- Dec-2011)@ TATA Consultancy Services Project Name : Cabin Crew Tracking.

Client : British Airways, UK

Role : Test Analyst

Environment : Informatica, Oracle, SQL/PLSQL, WinCvs, Xfree86, MVS Unix shell programming, Detail Navigator

Test Tools : HP-QTP 10.0, HP-QC 10.0

Testing type : ETL Testing

Project Description:

Aim of the project is to replace the TRACIE with iFlightCrew. TRACIE is BA’s main tool for cabin crew roster maintenance and on-the-day control. Being a legacy application, TRACIE is less flexible in accommodating improvements in the operational management of cabin crew. BA has evaluated a number of Crew Tracking products available in the market and has chosen IBS’ iFlightCrew product to replace majority/whole of TRACIE functionalities. Implementation of iFlightCrew requires that the product needs to be integrated with the BA systems that TRACIE is already interfacing with. This also requires data to be migrated from TRACIE to iFlightCrew. Contribution:

Involved in ETL, Automation and Manual testing for the following activities:

• Understanding the application under test

• Understanding the Software Requirements and Specifications

• Involved in preparation of Test Plan

• Identified Test scenarios as per Software Requirements and Specifications

• Prepared Test Cases as per Software Requirements and Specifications

• Preparation of test data for various levels of testing

• Generation of automation test scripts using the testing tool

• Preparation of test scripts for each feature list

• Preparation of Test Log after Execution of Tests

• Preparation of Interim Test Reports

• Test data preparation and execution

• Executed Test scripts and prepared the defect Report

• Logging the defects in Quality Center- HP

• Responsible for various testing activities like Functional, system, Integration, UAT and End to End Testing

• Reported the defect list to the Development Team

• Involved in Daily status meetings with development team along with testing team

• Working closely with Development team and preparing weekly status reports for client reference

Project#4 (Nov-09-Aug-10)@ Virtu Tech Solutions

Project Name : 365MT

Client : 365Marketing Technologies, NZ

Role : Software Test Engineer

Environment : C#, ASP.Net, SQL Server 2005, VTrac Test Tools : QTP 9.2

Testing type : Manual and Automation Testing

Project Description:

Aim of the project is to provide the software services to the different type of customers. The project consists of different type of modules like admin and user. The admin module is further categorized by number of sub modules; those are Auto Dealers, Ad Spot, Dealer Utilities, Dealer Reports, and System Utilities. Like user module is also having different sub modules; those are Customer Quick Entry, Customer Search, Customer Opt Out, Letter Creator, List Builder, Representatives and Reports. The reports are further categorized by Opt out Reports, Monthly Registration, Monthly Campaign, Customer Stats, Dealer Tag Order, Rep. Reports and Bulk Email Report. In this application dealers will create different type of customers as per their purchase of vehicle. Like these we have different type of customers; those are Sales, Service and Potential. We can remind the customers for different type of benefits and promotions by sending regular emails. Contribution:

Involved in manual testing for the following activities:

• Understanding the Software Requirements and Specifications

• Involved in preparation of Test Plan

• Identified Test scenarios as per Software Requirements and Specifications

• Prepared Test Cases as per Software Requirements and Specifications

• Executed Test Cases and Prepared the Bug Report

• Developed Test scripts as per Software Requirements and Specifications

• Executed Test scripts and Prepared the Bug Report

• Logging the bugs in VTrac

• Responsible for various testing activities like Functional, Sanity, Integration and End to End Testing

• Reported the Bug list to the Development Team

• Involved in Daily status meetings with development team along with testing team

• Working closely with Development team and preparing weekly status reports for client reference

• Preparation of test data for various levels of testing Project#3 (Sep-08-Oct-09)@ Virtu Tech Solutions

Project Name : Windfall (Product; HRMS)

Role : Software Test Engineer

Environment : VB.Net, ASP.Net and SQL Server 2005

Test Tools : Manual Testing, VTrac

Testing type : Manual Testing

Project Description:

The Windfall Benefits Communication Software is a comprehensive employee benefits eligibility system. HIPAA security and Privacy Act compliant, the Windfall program was created to communicate, update and enroll all facets of employer sponsored benefits and deduction possibilities for employees in a simple, easy to understand manner. Contribution:

Involved in manual testing for the following activities:

• Understanding the Software Requirements and Specifications

• Identified Test scenarios as per Software Requirements and Specifications

• Prepared Test Cases as per Software Requirements and Specifications

• Executed Test Cases and Prepared the Bug Report

• Logging the bugs in VTrac

• Responsible for various testing activities like Functional, Integration and System testing

• Reported the Bug list to the Development Team

• Involved in Daily status meetings with development team along with testing team

• Working closely with Development team and preparing weekly status reports Project#2 (Oct-07-June-08)@ Idika Solutions

Project Name : Customer Relationship Management

Client : Ceilo, U.S.A

Role : Software Test Engineer

Environment : Java, J2EE, Oracle9i

Test Tools : Manual Testing, IMS

Project Description:

Major purpose of this application is the creation of a web based customer relationship management; the Main functionality is customized to the credit union business. Account creation and management, with any number of Contacts associated with each Account. Activity history (Meetings, Calls, Tasks, Notes with optional file attachments, and Emails) is tracked for Contacts, Accounts, Leads, Opportunities and Cases Tasks may be assigned to users, and automatic email notifications may optionally be sent to advise users of new tasks. Contribution:

Involved in manual testing for the following activities

• Understanding the Software Requirements and Specifications

• Developed Test Cases as per Software Requirements and Specifications

• Executed Test Cases, Prepared the Bug Report, Daily and weekly status reports

• Reported the Bug list to the Development Team

Project#1 (Feb-07 – Sep-07)@ Idika Solutions

Project Name : Travel Desk

Client : Michael Arthur, Australia

Role : Software Test Engineer

Environment : .Net Technologies, SQL Server 2000

Test Tools : Manual Testing, IMS

Project Description:

This Project contains three modules User, Administrator and Company. User The new user will automatically be given a unique User ID #. The User can give his preferences and can update it Company. The Company will automatically be given a unique Company ID #. Each COMPANY ID # will have different permissions (i.e. access to different fields) assigned by the administrator. The Administrator can Add, Delete and Update the Users information, Companies Information.

Contribution:

Involved in manual testing for the following activities

• Understanding the Software Requirements and Specifications

• Developed Test Cases as per Software Requirements and Specifications

• Executed Test Cases and Prepared the Bug Report

• Reported the Bug list to the Development Team

Awards and Accolades

Received Rock Star award for the extra mile of efforts showcased in end to end project delivery in Capgemini

Received Bronze star award for training the FLP resources on the software testing in Capgemini

Received STAR TEAM award for successful implementation of Cabin Crew Tracking Program one of the biggest IT change programs within British Airways.

Received On the Spot TCS Gem award for successfully completing the TIARA assessment

Received Appreciation notes from Assurance delivery owner for my hard work, Commitment and significant contribution on complex project delivery References

Will be shared upon request.

Contact this candidate