Summary
Overview
Work History
Education
Skills
Disclaimer
Timeline
Generic
Sravya Putta

Sravya Putta

Hyderabad

Summary

PROFESSIONAL SUMMARY

  • ETL (Extract, Transform, Load) and QA tester with 6.03 years of IT experience in ETL technologies like Informatica power center.
  • Have hands on experience in Informatica, Jira, Oracle SQL, HP ALM, MS SQL, Automation testing used by IntelliJ and Mainframes (IBM I Access Client Solution).
  • Good knowledge in phases of Testing life cycle which includes Requirement Analysis, Test planning, Design, Execution and documentation.
  • Worked on PDF comparator tool by using IntelliJ.
  • Having knowledge on ETL Externalization tool.
  • Participated in BAU (Business As Usual) tickets creation.
  • Having knowledge on data validation activities, regression testing, retesting and agile methods.
  • Having knowledge on preparing test cases, executing the test cases and documenting the test results.
  • Involved in all phases of the project lifecycle.
  • Good Experience in writing Oracle queries for fetching data.
  • Knowledge on Data validation and count validations.
  • Possess excellent verbal and written communication, organizational and administrative skills for project management.
  • Having knowledge on Vertex AI prompt for preparing SQL scripts.

Overview

6
6
years of professional experience
3
3
Languages

Work History

Quality Engineer

Tata Consultancy Service
12.2024 - Current

Project Name : Definity

Project Summary:

Definity financial corporation is a prominent Canadian company specializing in property and casuality insurance. Established in 2021 following the demutualization of economical insurance, Definity serves as parent company to several well-known insurance brands in Canada including Economical insurance, sonnet insurance, Family insurance and Petline insurance.

Roles and Responsibilities:

  • Understanding of business requirements from the initial phase and worked on Test approach documents.
  • Involved in claims BAU(Business As Usual) production tickets we are having to enhancement of the existing tables.
  • Having knowledge on preparing test cases, executing the test cases and documenting the test results.
  • Participated in Preparation of Test plan and Test strategy documents.
  • Execute the test cases and raise defects in JIRA.
  • Validated the test scenarios manually which are schema validation , Null validation, duplicate validation, data validation and count validation.
  • Participated on daily status reports and call.

Quality Engineer

Tata Consultancy Services
09.2023 - 12.2024

Project Name : AXA

Project Summary:

Handled various ETL migration projects for entities such as HK, TH, ID, SG, PH and MY. The data from various legacy applications was being migrated to cloud and upgraded windows and Oracle servers for which we handled ETL Testing.

Roles and Responsibilities:

  • Understanding of business requirements from the initial phase and worked on Test approach documents.
  • Involved in various phases of the project lifecycle.
  • Having knowledge on preparing test cases, executing the test cases and documenting the test results.
  • Participated in Preparation of Test plan and Test strategy documents
  • Execute the test cases and raise defects in JIRA.
  • Validated the test cases by using externalization tool for data validation and count validation.
  • Participated in PDF file Comparison like PDF vs XML.
  • Created BAU production support tickets and done the actual testing for those tickets.
  • Executed the test scripts (in several layers data) Participated on daily status reports and call.

Program Analyst

Cognizant Technology Solutions, CTS
09.2021 - 01.2023

Project Summary Roles and Responsibilities:

Project Name: Manulife

Manulife is a leading international financial services group which operates primarily as John Hancock in the United States and Manulife elsewhere. They provide financial advice, insurance, as well as wealth and asset management solutions for individuals, groups and institutions.

Manulife - Valuation system transformation program (“VST”) aims to provide a more reliable single data source and robust core reporting, that ensures timely, value-added insights to support business management decisions through more efficient integrated group-wide systems. The new IFRS17 solution replaces the existing IFRS4 standard, and it enhances the disclosure and presentation of insurance accounting, exposes the underlying actuarial calculations and risk management tools to investors.

  • Understanding of business requirements from the initial phase and worked on Test approach documents, check whether the tables are mapped properly in DB.
  • Preparation of test plan, test strategy and test closure documents.
  • Executed the test scripts (Annex1, Annex2, Annex 3A and 3B layers), worked closely with the Dev and BA team.
  • Execute test cases and run in ALM (Application Lifecycle Management.
  • Preparation of test results per day, end of test result Documents and sharing with the concerned team.
  • Participated in daily status reports and calls.

Program Assistant

Cognizant Technologies
06.2020 - 08.2021

Project Summary Roles and Responsibilities:

Project Name: Chubb

Chubb project is defined by its extensive product and service offering, broad distribution capabilities, direct-to-consumer platform partnerships, exceptional financial strength and local operations globally. The company serves multinational corporations, midsize and small businesses with property and casualty insurance and risk engineering services; affluent and high net worth individuals with substantial assets to protect; individuals purchasing life, personal accidents, supplemental health, homeowners, automobile and specialty personal insurance coverage; companies and affinity groups providing or offering accident and health insurance programs and life insurance to their employees or members; and insurers managing exposures with reinsurance coverage.

  • Having knowledge on preparing test cases, executing the test cases and documenting the test results.
  • Preparation of Test plan and Test strategy documents.
  • Execute the test cases and raise defects in JIRA and Track it.
  • Executed the test scripts (Staging to CDM layer, Staging to Curated layer, Report layer).
  • Participated on daily status reports and calls


Program Analyst Trainee

Cognizant Technologies Solutions
08.2019 - 06.2020

Project Summary Roles and Responsibilities:

Project Name: MetLife Insurance Company

Guide wire insurance Suite™ provides an end-to-end set of applications that support insurance operations like underwriting, policy administration, billing, and client’s management. The insurance Suite applications are a set of common platform modules that cover the property and casualty insurance life cycle and typically replace legacy systems development internally by insurance carriers. Metlife Guidewire implementation deals with new GW V9 products customizations for three personal lines of business (Auto, Home and Umbrella) rolled out to multiple states in the U.S.

  • Analyzing and understanding the ETL mapping documents and writing SQL queries based on r equirements given in high level document.
  • Preparation of Test Scenarios, Test Cases based on the given requirements.
  • Performed System testing and Regression testing.
  • Involved in Package validation using functional and non-functional test scenarios.
  • Defect tracking in Rally board.

Education

BTech - Information Technology

Bhoj Reddy College of Engineering For Women
Hyderabad
08.2018

Intermediate -

Sri Chaithanya Junior College
Hyderabad
06.2014

SSC -

Sri Saraswathi Vidya Mandir
Gadwal
06.2012

Skills

IDE & Tools: Informatica Power center

Database Languages: Oracle, SQL, GCP(Google Cloud Platform)

Operating System: Windows

Disclaimer

I declare that the details above are correct and true to the best of my knowledge. 

Sravya Putta. 

Timeline

Quality Engineer

Tata Consultancy Service
12.2024 - Current

Quality Engineer

Tata Consultancy Services
09.2023 - 12.2024

Program Analyst

Cognizant Technology Solutions, CTS
09.2021 - 01.2023

Program Assistant

Cognizant Technologies
06.2020 - 08.2021

Program Analyst Trainee

Cognizant Technologies Solutions
08.2019 - 06.2020

BTech - Information Technology

Bhoj Reddy College of Engineering For Women

Intermediate -

Sri Chaithanya Junior College

SSC -

Sri Saraswathi Vidya Mandir
Sravya Putta