Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Accomplishments
Timeline
Generic

Chandralekha Putta

Hyderabad

Summary

As a dedicated and experienced Quality Assurance Lead with over 6 years of expertise, I specialize in enhancing efficiencies and identifying issues within data streams and Business Intelligence applications. My strong communication skills enable me to effectively articulate project needs, while my proficiency in SQL scripting allows me to seamlessly receive and monitor data from diverse sources. My talent for synthesizing quantitative information and engaging with both colleagues and clients makes me a valuable asset to any team.

Overview

1
1
Certification

Work History

Project Title: Facets Modernization- Surrounds Remediation

CareFirst
  • As part of facets Modernization work current database which is residing in Oracle on premise is migrated to Azure Cloud SQL server
  • All Informatica ETL workflows shall recreated to be able to connect with Azure cloud SQL server to process migrated data in G6 platform
  • Existing ETL process will remain running processing Legacy data this will be decommissioned upon complete migration to G6
  • To Remediate the workflow to be able to connect Azure Cloud Source queries, Lookup queries, Targets and Stored procedures will be remediated to be able to connect Cloud database
  • Tools and Technologies: Microsoft SQL Server, Informatica PowerCenter, SQL developer, JIRA, WinSCP, FACETS UI

Project Title: Pharmacy Re-imagine- Experience Cube Claims Integration

Blue shield of California
  • The project involves integration of RX Claims data from Abarca Snowflake share into Experience Cube from ADLS to Raw/Business Vault Layers
  • Testing involves Data Quality check rules to be implemented across the data flow- Ingestion, Data vault and Extracts
  • DBT Cloud Automation is used to validate basic data quality checks between source and target in Raw/Business vault layers
  • Tools and Technologies: Microsoft Azure Synapse Analytics, Snowflake, MS SQL Server, DBT Cloud, JIRA, Confluence

Project Title: Service Requests-Data Enhancements

Blue shield of California
  • The project involves testing the service requests and incidents assigned based on monthly release
  • The main objective is to ensure that the data is correctly flowing from different datasets to the stating layer based on the transformation logic or business logic and from the stating layer ensure that the data is flowing into the extracts and finally into Data Mart's
  • Tools and Technologies: Netezza, JIRA, DBeaver

Project Title: Guiding Care Utilization Management Enhancements

Commonwealth Care Alliance
  • This includes advocating for affordable, high-quality, and cost- effective healthcare policies that lead to healthcare equity for individuals who need it most
  • A Consent Engine portal was developed and where QA performs testing various end to end validations from UI to API to DB
  • Used postman for API testing and Selenium for UI layer testing
  • Salesforce for authenticator generation
  • Tools and Technologies: MS SQL Server, JIRA, Postman

Education

B.Tech - Computer Science and Engineering

G.Pulla Reddy Engineering college
Kurnool
04.2017

Skills

  • Data warehouse testing
  • ETL testing
  • Automation
  • Python
  • SQL
  • Informatica PowerCenter
  • Putty
  • Postman
  • Selenium
  • Microsoft Azure
  • HP ALM
  • JIRA
  • Confluence
  • SQL Server
  • Snowflake

Certification

  • Infosys certified Global Agile Developer
  • Infosys certified TDM professional
  • Infosys certified SQL Professional
  • IBM Training completion certificate on Essentials of Big Data using IBM Infosphere Big Insight under IBM career education program
  • Infosys certified Cloud data Professional
  • Infosys awarded with Tech Domain Maestro award for contribution in Facets Modernization project
  • Team awarded with best team to deliver a critical project in Rise awards
  • Top rating as Outstanding for fiscal year 23-24 for handling a critical project with 20 engineers size team as a lead

Personal Information

  • Date of Birth: 04/17/96
  • Nationality: Indian

Accomplishments

  • Received Tech Domain Maestro award for contribution in Facets Modernization project; team was awarded best team in Rise awards.
  • Top rating as Outstanding for fiscal year 23-24 for leading a critical project with a team of 20 engineer
  • Infosys certified Global Agile Developer; Infosys certified TDM professional; Infosys certified SQL Professional.
  • IBM Training completion certificate on Essentials of Big Data using IBM Infosphere Big Insight under IBM career education program.
  • Infosys certified Cloud data Professional.

Timeline

Project Title: Facets Modernization- Surrounds Remediation

CareFirst

Project Title: Pharmacy Re-imagine- Experience Cube Claims Integration

Blue shield of California

Project Title: Service Requests-Data Enhancements

Blue shield of California

Project Title: Guiding Care Utilization Management Enhancements

Commonwealth Care Alliance

B.Tech - Computer Science and Engineering

G.Pulla Reddy Engineering college
Chandralekha Putta