Summary
Overview
Work History
Education
Skills
Accomplishments
Designation
Timeline
Generic

Sahitya Mangalampalli

Leander,TX

Summary

Data expert specializing in data migration and ETL processes with a proven track record at Tata Consultancy Services. Skilled in optimizing Snowflake solutions, enhancing performance, and streamlining operations. Expert in the insurance domain, root cause analysis, and project planning, with a focus on retiring/migrating legacy systems and developing data pipelines. Strong consultant skills in client management, issue resolution, root cause analysis, product management, and team leadership, managing teams across shores.

Overview

13
13
years of professional experience

Work History

Assistant Consultant, Lead

USAA - Tata Consultancy Services
Austin, US
06.2022 - Current
  • Executed migration of over 500 legacy components to Snowflake cloud-based solution.
  • Designed and developed ETL/ELT pipelines to facilitate data migration and modernization.
  • Designing data strategies for increasing performance on legacy systems, optimizing a legacy application with 12 jobs into 1 flow reducing the runtime and resource utilization which is one example for Snowflake, improving efficiency and reducing costs.
  • Engineered modernized data ingestion flows utilizing Informatica and DBT for transformation.
  • Orchestrated data flow design, performing impact and root cause analysis on legacy systems.
  • Managed defect tracking while gathering requirements and executing end-to-end validations.
  • Led international teams in migration planning, overseeing agile ceremonies and capacity planning.
  • Converted business needs into IT requirements as product subject matter expert.

Data Acquisition Analyst and ETL Developer

USAA - Tata Consultancy Services
San Antonio, US
01.2018 - 06.2022
  • Analyzed P&C policy transactional data flow from source to data warehouse and reporting.
  • Designed architecture validating over 100 P&C policy features to enhance data quality.
  • Built Tableau dashboards tracking transaction counts for Policy P&C and IOT features.
  • Developed ETL pipelines implementing over 80 features using Informatica across Netezza and DB2.
  • Provided production support for Policy P&C applications, resolving multiple data defects.
  • Optimized SQL queries to reduce slowness in ETL execution.
  • Created new data flows to improve ETL execution efficiency on production runs.

Data Acquisition Analyst

USAA - Tata Consultancy Services
San Antonio, US
10.2015 - 12.2017
  • Impact analysis and root cause analysis for multiple defects in the test and production environments.
  • Developed test strategies to streamline workflows across system integration and release stages.
  • Fostered collaboration among team members by leading regular scrum meetings.
  • Production support activities for 3 applications with 1000+ jobs, supporting the oncall activities, leadership connects, handling MI calls and providing root cause analysis.
  • Delivered data warehouse solutions through collaboration with customers and technical leads.
  • Proactively addressed issues in Informatica and SQL development tasks.
  • Resolved operational problems efficiently while supervising production cycles.
  • Drafted comprehensive design documentation, guiding discussions on necessary code changes.

Developer, Team Member

USAA - Tata Consultancy Services
Chennai, India
01.2014 - 10.2015
  • Analyzed requirements and created corresponding code solutions.
  • Streamlined defect and configuration processes using Rational Team Concert.
  • Maintained the Kanban dashboard by tracking daily tasks.
  • Conducted system analysis to identify efficiency improvements.
  • Produced data tailored to specific team requirements.
  • Streamlined repetitive data processes through the development of automation scripts.
  • Preparation of low-level design documents, unit testing, and validation documents.
  • Facilitated generation of required data to validate functionalities effectively.

Developer

Statefarm through Tata Consultancy Services
Chennai, India
08.2012 - 12.2013
  • Preparation of Analysis and Design Documents
  • Preparation of process flows
  • (AS-IS & TO-BE)
  • Preparation of business documents - UI Specifications, Use Cases
  • Analysis for flow requirements
  • Coordination with on-site team to understand the requirements
  • Code walk through, debugging and error fixing
  • Preparation of J Unit Test cases
  • Creation of tasks based on the business requirements and track them to completion
  • Project Life Quote & Purchase is a new web based application which will be developed from the scratch and will be accessible to Customers, Agents and Customer Care network

Trainee

Tata Consultancy Services
Chennai, India
03.2012 - 06.2012
  • Gained expertise in technical work, analytical methods, and soft skills.
  • Project Employee Management System (EMS) worked on the project in all the phases of study, analysis, design, development, testing and deployment.

Education

B. Tech - Information Technology

Jawaharlal Nehru Technological University
Kakinada, INDIA
01.2011

Skills

  • UNIX
  • SQL
  • Python
  • DBT
  • Snowflake
  • Informatica PowerCenter 107
  • Data migration
  • Data modeling
  • ETL/ELT processes
  • Root cause analysis
  • Product management
  • Team leadership
  • Performance tuning
  • Quality assurance
  • GitLab
  • Netezza DB
  • Tableau
  • Data ingestion

Accomplishments

  • Implemented SQL-based cost optimization techniques, resulting in a significant reduction in ETL process time and delivering faster, more efficient data access to business users.
  • Recognized for expertise in Property and Casualty Insurance, serving as a Subject Matter Expert (SME) with deep knowledge of data flow and business processes, earning accolades for domain proficiency.
  • Managed and mentored a team of 18 onshore and offshore ETL developers and data QA professionals, guiding them in ETL processes and Property and Casualty domain expertise. Oversaw the maintenance of production data, ensured timely resolution of production issues, and drove new development initiatives aligned with business goals.
  • Championed Agile methodologies, tracked KPIs, and facilitated seamless collaboration with business users, stakeholders, data stewards, and leadership to meet project objectives and exceed expectations.

Designation

Assistant Consultant

Timeline

Assistant Consultant, Lead

USAA - Tata Consultancy Services
06.2022 - Current

Data Acquisition Analyst and ETL Developer

USAA - Tata Consultancy Services
01.2018 - 06.2022

Data Acquisition Analyst

USAA - Tata Consultancy Services
10.2015 - 12.2017

Developer, Team Member

USAA - Tata Consultancy Services
01.2014 - 10.2015

Developer

Statefarm through Tata Consultancy Services
08.2012 - 12.2013

Trainee

Tata Consultancy Services
03.2012 - 06.2012

B. Tech - Information Technology

Jawaharlal Nehru Technological University

Similar Profiles

CREATE PROFILE
Sahitya Mangalampalli