Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Pooja Patil

Austin,TX

Summary

Highly competent Data Engineer with background in designing, testing, and maintaining data management systems. Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.

Overview

9
9
years of professional experience

Work History

Data Engineer

Nomi Health
Austin, TX
10.2022 - Current
  • Company Overview: Healthcare Domain
  • Built and optimized end-to-end data pipelines using Snowflake and AWS Lambda.
  • Implemented Datadog-based monitoring and Snowflake Alerts for proactive issue resolution.
  • Led data governance initiatives using Snowflake masking policies.
  • Reduced Snowflake account costs by 10% through compute/cloud/maintenance optimization via cost management framework.
  • Used dbt to implement and manage Medallion Architecture.
  • Integrated and updated patient records via RESTful APIs.
  • Normalized unstructured healthcare JSON data into structured Snowflake tables.
  • Extracted EDI 837 & 835 data to link claims to remittance, tracking full claim lifecycle.
  • Automated orchestration using Airflow, AWS Lambda, and Snowflake Tasks.
  • Maintained databases of known defects and tracked resolutions in bug tracking systems like Jira.
  • Tracked progress on deployments using project management tools such as Jira.
  • Documented application features, bug fixes, changes, requirements and design decisions in Confluence.

Data Analyst

Nomi Health
Austin, TX
03.2021 - 10.2022
  • Automated validation workflows, improving data quality by 25%.
  • Designed complex ETL pipelines integrating internal and state systems (HL7, HIPAA-compliant).
  • Used AWS Secret Manager and Lambda for secure, PII-compliant ETL processing.
  • Created real-time dashboards for COVID-19 site performance and operational decisions.
  • Analyzed claim data to identify trends and recommend process improvements.

BI/ETL Developer Intern

Nomi Health
Austin, TX
03.2021 - 05.2021
  • Created ETL pipelines for COVID-19 testing/vaccine data in Snowflake.
  • Automated HL7 message generation from CSV using AWS Lambda + S3.
  • Created SQL Server Integration Services packages for incremental and full loads of data from various sources.
  • Designed, developed and tested ETL processes to extract, transform and load data from multiple sources.
  • Maintained version control over all code changes within the BI environment including stored procedures, views and functions.
  • Monitored system performance by developing automated scripts to detect potential issues in the data pipelines.

Software Intern

ADSY Infotech
Indiana, USA
01.2021 - 03.2021
  • Built AngularJS front-end apps and deployed using AWS Elastic Beanstalk.
  • Utilized AWS SDKs for automation and back-end integration.

Graduate Assistant – Software Engineering

University of Central Missouri
01.2020 - 05.2020

System Engineer – BI & ERP

Tata Consultancy Services
Mumbai, India
11.2016 - 07.2019
  • Company Overview: Banking Domain
  • Designed ETL solutions using SAP BODS and optimized SQL/PLSQL queries.
  • Led GST integration project for Tata Capital loan management systems.
  • Received multiple recognitions including 'On-the-Spot' and 'Process Champion' awards.

Education

Master of Science - Computer Science

University of Central Missouri
Warrensburg, MO
05.2021

Bachelor of Engineering - Computer Science

Vidyalankar Institute of Technology
Mumbai, India
06.2016

Skills

  • Python
  • SQL
  • PL/SQL
  • Oracle
  • MySQL
  • MS SQL Server
  • Snowflake
  • AWS
  • Power BI
  • DOMO
  • DBT
  • Data governance
  • ETL development
  • Airflow
  • Skyflow
  • GitHub
  • JIRA
  • Datadog
  • PagerDuty
  • Talend
  • VS Code
  • HL7
  • FHIR
  • Confluence
  • Data integration
  • SQL programming
  • Python programming
  • Team building
  • Analytical skills
  • Snowflake Cost Management
  • SQL expertise
  • Query optimization
  • Technology leadership work streams
  • Process automation

Timeline

Data Engineer

Nomi Health
10.2022 - Current

Data Analyst

Nomi Health
03.2021 - 10.2022

BI/ETL Developer Intern

Nomi Health
03.2021 - 05.2021

Software Intern

ADSY Infotech
01.2021 - 03.2021

Graduate Assistant – Software Engineering

University of Central Missouri
01.2020 - 05.2020

System Engineer – BI & ERP

Tata Consultancy Services
11.2016 - 07.2019

Master of Science - Computer Science

University of Central Missouri

Bachelor of Engineering - Computer Science

Vidyalankar Institute of Technology
Pooja Patil