Test Lead Life Cycle
Resume:
Kalyani Dosapati- Technical Test Lead : ***********@*****.***
Charlotte-North Carolina, USA +1-704-***-****
Professional Summary:
Over 12+ years of work experience in IT as a Technical Test Lead in Agile ETL Testing using Informatica, IDMC, ICEDQ, Manual Testing, Automation Testing using Python, TOSCA, TestNG, RAFT & DVO, Functional, Data Migration Testing,Python Scripts Data Testing,API & and Rest-assured for Restful Web Services/Rest API Testing using Postman, Report Testing using Cognos, Data Base Testing, Regression & Integration Testing.
Experience in working with various domains such as Banking, Insurance, Marketing solutions and Transportation domain.
Experience in all phases of Software Testing Life Cycle (SDLC), Software Testing Life Cycle (STLC), Bug life Cycle and Test Management.
Extensively worked on Agile Scrum methodology and actively participated in Sprint/Scrum meetings.
Expertise in Managerial Activities like Project Effort Estimation, Project Metrics, Resource Management.
Involved in Team leading activities and managed the team and the project to meet the project deliverables and help them to resolve the issues.
Proficient in different phases of testing like Test Planning, Requirement Analysis, Test case Design, Test Execution, Defect reporting and Tracking.
Efficient in writing Test plan, Test Strategy and Test closure Reports.
Expertise in writing Test cases, detailed Test Scripts and execution of test cases in ETL testing using IDMC and Informatica.
Expertise in writing automated test cases and execution of test cases through TOSCA, TestNG, Selenium, Informatica Data Validation Option (DVO) tool & RAFT tool.
Familiarity with CI/CD pipelines and integration of automated tests.
Involved extensively in the Functional testing, Integration testing and Regression testing, User Acceptance Testing and End to End (E2E) Testing.
Expertise in Data warehousing testing concepts and understanding Informatica ETL workflows and Mappings.
Expertise in running Informatica Autosys jobs using IDMC,Informatica Power Center and monitor using Informatica Work flow Monitor, WorkLoad Control Center, Allink Transact
Expertise in understanding Informatica mappings to validate and test the ETL logic defined in mapping document.
Expertise in designing and developing Test Strategy, Test Plan, Test Scenarios, Test Cases and generating Defect Reports & Test Closure documents and validation of the Cognos reports using IBM Cognos Business Intelligence.
Experience in API Testing using Postman and comparing with the related Stored Procedure.
Experience in Creating and Executing Test cases to validate data generated by Python scripts.
Experience in writing and executing complex queries using Oracle 11g, SQL Server Management Studio, SQL Server 2005, Toad, Oracle SQL Developer and validating the SQL complex queries and PL/SQL stored procedures.
Expertise in STLC models like Agile, SCRUM, Waterfall-Methodology
Possess Good understanding of Requirements and Mapping document for ETL Testing.
Knowledge on Azure Devops for Defect Management.
Expertise in bug and defect tracking using tools like HP Quality Center, ALM, qTest and JIRA, Azure Devops, Asana.
Expertise in creating Requirement Traceability Metrics.
Strong interpersonal communication and collaboration skills to achieve project goals and motivate the team members.
Received appreciations from Clients/Managers/Leads for the projects worked.
Educational Summary:
Master of Computer Applications (MCA) in the year 2010 from Osmania University.
B.Sc (MPC) in the year 2007 from Kakatiya University.
Employment Summary:
Organization
Designation
Duration
Next Gen Technologies Llc
SDET
Nov 2024 to Till date
Infosys Technologies Ltd
Technical Test Lead
Nov 2016 to June 23
HCL Technologies ltd
Senior Test Engineer
Jan 2015 to Sep 2016
Cognizant Technology Solutions
Programmer Analyst
Feb 2011 to Dec 2014
Technical Summary:
Testing Tools: Informatica Power center 10.2.0, Informatica Workload Control Center, ICEDQ, IICS, IDMC, Allink Transact, Ultra Edit, RAFT, DVO, Postman, TOSCA Commander, TestNG, Jenkins, Git, Unix,Azure Databricks,Snowflake
Technology: Data Warehousing, Informatica, Cognos
Reporting Tool: IBM Cognos Business Intelligence
Web Services: Postman
Testing Types: ETL, Integration, E2E, System, Regression, Automation, User Interface, test driven testing and Database Testing, Data Migration Testing, and Rest-assured for Restful Web Services/Rest API Testing
Bug Tracking Tool: HP Quality Center 11.0,ALM, JIRA, qTest, Azure Devops, Asana
Programming languages: SQL, PL/SQL, HTML, XML, Java, Selenium
Scripting languages: Python
Database& Tools: Oracle 11g, SQL Server Management Studio, SQL Server 2005, Toad, Oracle SQL Developer,
MS-Suite: MS- Word, MS- Excel, MS- PowerPoint, MS- Outlook
Doc Version Control: Microsoft Share Point
Operating Systems: MS Windows XP/7/8/10, Windows, Linux
Professional Experience:
Next Gen Technologies Llc Nov 2024 to Till date
SDET
Description:
Designed to consolidate client supplied and self-reported data and 3rd party appended data which is used to support sales analytical system. Also there are set of process to validate and report the data.
Participates in Agile meetings with Peers/Clients to understand the functional and non-functional requirements for the engagement, understands scope of work to be performed. Interacting with Business Analysts to get clarifications on requirements.
Interacting with Infra team and Software Configuration Management (SCM) teams for Agile test requirements updates.
Preparation of Test plan, Test Strategy, Test Readiness Review, Test completion reports in Agile methodologies.
Well experienced in developing the test cases where requirements change frequently or loosely defined.
Expertise in ETL Validations using IDMC and Informatica from Source to Staging and Destination tables as per ETL Mapping document and Writing Complex queries for ETL & DB testing validations.
Designed and created Manual and Automated Test Cases using Python, Test Plans and implemented execution and conducted Functional Testing, Regression Testing.
Well experienced in validating the API and REST Web services using Post Man, comparing with database stored procedures and Using test scripts in POSTMAN.
Experience in Creating and Executing Test cases to validate data generated by Python scripts.
Involved in leading activities and managed the team and the project to meet the project deliverables.
Expertise in Data warehousing testing concepts and understanding Informatica ETL workflows and Mappings.
Running the Informatica ETL jobs to generate the target extract for validation.
Expertise in complex query writing and complex data validations.
Well experienced in validating the API using Post Man and comparing with database stored procedures.
Designed and created Manual and Automated Test Cases, Test Plans and implemented execution using Python tool and conducted Automation, Functional Testing and Regression Testing.
Reviews the detailed schedule for a work packet and provide inputs to overall project schedule to ensure on time delivery of the project.
Reviews all the risks and mitigations identified, develops action plan for all the risks identified in the test plan, seeks support from test manager for mitigation of the risks involved to complete test plan design.
Assured and tested both XML and JSON formats.
Review test scripts periodically to ensure robustness and coverage to commence test execution.
Reviews the complete execution, develops, and tracks action plan for any risks and their mitigation during test execution to identify defects in the application.
Validates go live activities such as production verification to ensure that the application runs in the production environment without any issues.
Preparation and reviews the closure report and submits to respective stakeholders, overall status and seeks sign-off for projects to support closure.
Participate in estimation, Project Metrics, staffing analysis and solutioning to provide inputs for preparing solution delivery of the proposal.
Participate in Agile daily standup meetings to raise Issues/Concerns, discuss resolutions and providing status.
Environment:
TOAD, Informatica Power center 10.2.0, ICEDQ, IICS, IDMC, SQL Server Management Studio, Agile(Scrum), Oracle 11g, Postman, HP Quality Center 11.0, ALM, JIRA, qTest,MS- Excel, Ultra Edit, Eclipse, Unix, Python, PyCharm
Client: Bank of America Nov 19 – June 23
Technical Test Lead
Description: Banker Assist project provides an integrated set of tools and processes for deal management and reporting to assist in client planning, contact management, revenue opportunities and dashboard at banker and organization level.
Involved in various meetings with Product Owners, Business Analysts and Developers.
Expertise in analyzing the Business Requirements and Developed the detail Test Plan and the Test Strategy, Test Readiness Review, Test completion reports in agile methodologies.
Experience in Agile-Scrum and Waterfall methodologies.
Expertise in ETL Validations using IDMC and Informatica from Source to Staging and Destination tables as per ETL Mapping document and Writing Complex queries for ETL & DB testing validations.
Designed and created Test Plan, Manual and Automated Test Cases using Python and implemented execution and conducted Functional Testing, Regression Testing.
Involved in leading activities and managed the team and the project to meet the project deliverables.
Expertise in Data warehousing testing concepts and understanding Informatica ETL workflows and Mappings.
Running the Informatica Autosys jobs to generate the target extracts and Tables for validation.
Expertise in ETL Validations from Source to Staging and Destination tables as per ETL Mapping document and Writing Complex SQL and PL/SQL queries for ETL & DB testing validations.
Expertise in understanding and validating Oracle PL/SQL stored procedures.
Well experienced in validating the Assist API and Rest-assured for Restful Web Services/Rest API Testing using Post Man, comparing with database stored procedures and Using test scripts in POSTMAN for testing Assist API.
Involved in developing Test scenarios and Test cases & Test scripts using acceptance criteria.
Experience in writing SQL queries to TRUNCATE, UPDATE and DELETE data for DB testing.
Experience to identify and run different kinds of ALM test suites like Full load, Incremental load, Smoke, Health Check and Regression.
Experience in Creating and Executing Test cases to validate data generated by Python scripts.
Developed automated tests for test automation using Python and potentially execute test automation tool s & ICEDQ.
Developed test framework in Selenium for UI Regression test automation and potentially execute unit test automation (Tosca, TestNG).
Familiarity with CI/CD pipelines and integration of automated tests with GIT, Jenkins and Azure Devops.
Reviews the detailed Schedule and all the Risks and Mitigations identified, develops Action plan for all the risks identified in the test plan, seeks support from test manager for mitigation of the risks involved to complete Test plan design.
Reviews Test scripts and complete Execution, develops, and tracks action plan for any Risks and their Mitigation during test execution to Identify Defects in the application.
Expertise in grouping of Test Suites, Test Cases and Test Methods for Regression and Functional Testing using ALM.
Responsible for providing Risk Assessments, test Plans, test cases, and Executing and creating test results within an AGILE software development SCRUM environment.
Involved in developing Traceability Matrix and mapping the Test Cases with the Requirements and Test Metrics.
Performed System Testing in Testing Environment, End to End Regression in SIT environment and User Acceptance Testing in Pre-PROD environment.
Reported bugs using ALM, HP Quality Center, qTest and JIRA, Azure Devops, Asana.
Performed End to End Testing and documenting the Test Results in MS Excel and Evaluation Reports.
Assured and tested both XML and JSON formats.
Involved in Sprint Refinement and Design, Sprint Planning and Retrospective meetings.
Participate in estimation, Project Metrics, staffing analysis and solutioning to provide inputs for preparing solution delivery of the proposal.
Participate in Agile daily stand up meetings to raise Issues/Concerns, discuss resolutions and providing status.
Environment:
Informatica Power center 10.2.0, ICEDQ, IICS, IDMC, CA Workload Control Center, TOSCA Commander, TestNG, TOAD, SQL Server Management Studio, Agile(Scrum), Oracle 11g,Python,PyCharm,Postman,HP Quality Center 11.0, ALM, JIRA, qTest,MS- Excel, Ultra Edit, Eclipse, Selenium Web Driver 3.4.0, Git, Jenkins, Unix, Python, PyCharm, Snowflake
Client: Wells Fargo Dec 2016 – Oct 2019
Technical Test Lead
Description:
Designed to consolidate self-reported, client supplied, and 3rd party appended data which is used to support enhanced sales and performance. Also there are set of process to validate and report the data.
Participates in Agile meetings with Peers/Clients to understand the functional and non-functional requirements for the engagement, understands scope of work to be performed. Interacting with Business Analysts to get clarifications on requirements.
Interacting with Infra team and Software Configuration Management (SCM) teams for Agile test requirements updates.
Preparation of Test plan, Test Strategy, Test Readiness Review, Test completion reports in Agile methodologies.
Well experienced in developing the test cases where requirements change frequently or loosely defined.
Well experienced in validating the API and REST Web services using Post Man, comparing with database stored procedures and Using test scripts in POSTMAN.
Expertise in ETL Validations from Source to Staging and Destination tables as per ETL Mapping document and Writing Complex SQL queries for ETL & DB testing validations.
Experience in Creating and Executing Test cases to validate data generated by Python scripts.
Involved in leading activities and managed the team and the project to meet the project deliverables.
Running the Informatica ETL jobs to generate the target extract for validation.
Expertise in complex query writing and complex data validations.
Well experienced in validating the API using Post Man and comparing with database stored procedures.
Designed and created Manual and Automated Test Cases, Test Plans and implemented execution using RAFT & DVO tool and conducted Automation, Functional Testing and Regression Testing.
Reviews the detailed schedule for a work packet and provide inputs to overall project schedule to ensure on time delivery of the project.
Reviews all the risks and mitigations identified, develops action plan for all the risks identified in the test plan, seeks support from test manager for mitigation of the risks involved to complete test plan design.
Assured and tested both XML and JSON formats.
Review test scripts periodically to ensure robustness and coverage to commence test execution.
Reviews the complete execution, develops, and tracks action plan for any risks and their mitigation during test execution to identify defects in the application.
Validates go live activities such as production verification to ensure that the application runs in the production environment without any issues.
Preparation and reviews the closure report and submits to respective stakeholders, overall status and seeks sign-off for projects to support closure.
Participate in estimation, Project Metrics, staffing analysis and solutioning to provide inputs for preparing solution delivery of the proposal.
Participate in Agile daily standup meetings to raise Issues/Concerns, discuss resolutions and providing status.
Environment:
Informatica Power center 10.2.0, CA Workload Control Center, TOAD, SQL Server Management Studio, Agile(Scrum), Oracle 11g,Python,Postman,HP Quality Center 11.0, ALM, JIRA, qTest,MS- Excel, Ultra Edit, Git, Jenkins, Unix, Python
Client: Harte Hanks Jan 15 to Sep 16
Sr. QA Tester
Project Description:
Transact is a direct marketing database which offers an integrated view of our client’s customers and/or prospects. Harte-Hanks receive the responses via input feeds from the vendors and will apply the business rules for segmenting and determining fulfillments for the responders.
Understanding the Agile business requirements by participating in meetings with Onsite Peers/Clients to understand the functional and non-functional requirements.
Involved in interacting with Infra team and Software Configuration Management teams for Agile test requirements updates.
Expertise in the preparation of Test plan, Test Strategy, Test Readiness Review, Test completion reports.
Develop and/or executes ETL test cases/test plans based on the requirements. Used Informatica Workload Control Center to run and test the ETL mappings.
Involved in leading activities and managed the team and the project to meet the project deliverables.
Designed and created Manual and Automated Test Cases, Test Plans and implemented execution using TOSCA and conducted Automation Testing and Regression Testing.
Well experienced in complex query writing and complex data validations and Validating the change requests (CR’s) and Coordinate with the team for new CR’s testing.
Expertise in ETL Validations as per ETL Mapping document and writing Complex SQL queries for ETL & DB testing validations.
Involved in different types of testing like Full load, Incremental load, System and Regression Testing and Worked in incorporating the new business changes in stored procedures.
Well experienced in validating the API and REST Web services using Post Man, comparing with database stored procedures and Using test scripts in POSTMAN.
Validating individual IBM Cognos Reports and its data.Performed application testing (IE, Chrome, Firefox browsers).
Reviews the detailed Schedule for a work packet and provide inputs to overall project schedule to ensure on Time delivery of the project. Involved in developing Traceability Matrix.
Participate in software defect review meetings and maintains software using defect tracking tool JIRA . Prepares defect metrics reports and analyzes defect metrics for trends and progress.
Participate in Agile daily stand up meetings to raise Issues/Concerns, discuss resolutions and providing status.
Environment:
Informatica Power center, CA Workload Control Center, TOSCA Commander, TOAD,JIRA, PL/SQL Developer, SQL Server 2005, Postman,Agile(Scrum), Oracle 10g,Postman,IBM Cognos Business Intelligence, MS- Excel.
Client: The Hartford Feb 11 to Dec 14
QA ETL Tester
Project Description:
Web Analytic Data Mart (WADM) data related to auto quotes/ issues will need to be sent to the vendor, Adobe Insight. This data will ultimately be used to join with the online web data that will also be stored in Adobe Insight for analytical reporting.
Involved in Agile daily stand up meetings with Clients to understand the scope of work to be performed. Interacting with Business Analysts to get clarifications on requirements.
Monitoring entire QA process and preparing effective Test Scenarios and Test cases and Test scripts. Involved in leading activities and managed the team to meet the project deliverables.
Responsible for identifying test cases for Smoke Test, Functional and Regression Test.
Running the Informatica Autosys jobs to generate the target data for validation.
Involve in daily scrum meetings with the team to discuss about build progress, challenges and development and QA concerns to make sure that the deadlines are met.
Developing and executing Test Plans, Test Cases, Test Scripts, Defect Status Report, Requirement Traceability Matrix, and Test Summary Metrics.
Expertise in ETL Validations from Source to Staging and Destination tables as per ETL Mapping document.
Involved in Full load, Incremental load, System, Smoke, Health Check and Regression Testing.
Responsible for both ETL Testing and Database Testing.
Involved in API Testing to test the web services using Postman.
Wrote and executed SQL queries to check ETL & DB validations.Database testing, Integration testing, functionality and Regression testing were performed.
Executed test suites on Sprints and reporting and keep tracking of bugs on HP Quality Center.
Interacting with team members to ensure smooth progress of project work; ensuring adherence to quality norms throughout the implementation process
Environment:
Informatica Power Center 8.6.1, Work Load Control Center, Ultra Edit, HP Quality Center 10.0, Toad, Agile(Scrum),MS- Excel, Postman
Contact this candidate