Summary
Overview
Work History
Education
Skills
Timeline
Generic

Bhargavi Peta

Florida,USA

Summary

Data Engineer with 6 years of experience maintaining, auditing, and optimizing relational databases and data pipelines in enterprise environments. Strong expertise in SQL (PostgreSQL, SQL Server, Oracle), data quality validation, reconciliation, and traceable audit processes. Proven ability to analyze, document, and remediate data issues, partner with business users to define requirements, and translate business logic into repeatable data solutions. Advanced Excel user (Pivot Tables, XLOOKUP/VLOOKUP, Power Query) with experience supporting asset-heavy, operational, and financial datasets.

Overview

7
7
years of professional experience

Work History

Data Engineer /Data Analyst

Palm beach County
West Palm Beach, FL
04.2024 - Current
  • Designed and developed a modular dbt framework to orchestrate ETL transformations across staging, intermediate, and mart layers in Snowflake..
  • Write and optimize complex SQL queries (multi-table joins, aggregations, validation rules) across Snowflake and PostgreSQL-compatible environments.
  • Designed and implemented repeatable data audit frameworks using SQL and Excel, documenting discrepancies, root causes, remediation steps, and outcomes.
  • Built Excel-based audit and reconciliation tools using Pivot Tables, XLOOKUP/VLOOKUP, filters, and Power Query to validate source-to-target data accuracy.
  • Performed data reconciliation and variance analysis between staging, ODS, and data warehouse layers to ensure consistency and integrity.
  • Automated validation, scheduling, and job monitoring using PowerShell, reducing manual effort by 40%.
  • Partnered with business users to gather requirements, clarify ambiguous requests, and translate business logic into data definitions and SQL rules.
  • Created and maintained technical documentation: table definitions, column mappings, audit logs, and change histories.
  • Supported process improvements around data governance, access controls, and controlled updates.
  • Built dashboards in Tableau and Power BI to track audit results, KPIs, and operational trends.
  • Worked within an Agile/Scrum environment, contributing to sprint planning, backlog refinement, and delivery reviews.

Data Engineer /Data Analyst

Molina Health Care
TX
06.2022 - 03.2024
  • Implemented ETL frameworks in Azure Data Factory and Databricks to support healthcare claims and member data ingestion.
  • Participated in data migration initiatives from legacy Oracle and flat-file systems into SQL Server-based reconciliation environments.
  • Maintained and audited SQL Server and PostgreSQL-based datasets supporting healthcare claims, finance, and operational reporting.
  • Developed and optimized SQL validation queries to identify data integrity issues, duplicate records, and reconciliation gaps.
  • Conducted data profiling and quality checks, documenting findings and corrective actions for traceability and compliance.
  • Migrated data from Oracle and flat-file systems into relational reconciliation environments with validation controls.
  • Built Excel-based validation tools using Pivot Tables and lookups to verify record counts, balances, and transformations.
  • Applied statistical techniques to validate trends, outliers, and anomalies in large datasets.
  • Collaborated with analysts and business users to define data requirements, acceptance criteria, and reporting logic.

Data Engineer

Cognizant
India
01.2019 - 12.2021
  • Developed ETL mappings and modular dbt models to extract data from staging, perform business-logic transformations, and load curated datasets into Operational Data Store (ODS) and Snowflake Data Warehouse for analytics and dashboards.
  • Built ETL jobs using DataStage and SQL for extracting, transforming, and loading high- volume transactional data.
  • Developed dbt source freshness checks and data-quality monitoring dashboards, alerting the data team when anomalies were detected.
  • Optimized Snowflake performance through clustering, query-plan analysis, warehouse auto-scaling, and materialization strategies in dbt (incremental, table, view, ephemeral).
  • Validated migration outputs with PowerShell comparison scripts that perform row-count and checksum matching between source and target.

Education

Master of Science - Computer science

Bradley University
Illinois

Skills

    Relational Databases & SQL:PostgreSQL, SQL Server, Oracle

    Excel & Data VerificationPivot Tables, XLOOKUP/VLOOKUP, Filters, Data Validation, Power Query

    Programming Languages:Python, SQL, Scala, MATLAB

    ETL Tools: IBM DataStage, Informatica, Azure Data Factory

    Cloud Technologies:AWS, Docker, Azure

Timeline

Data Engineer /Data Analyst

Palm beach County
04.2024 - Current

Data Engineer /Data Analyst

Molina Health Care
06.2022 - 03.2024

Data Engineer

Cognizant
01.2019 - 12.2021

Master of Science - Computer science

Bradley University