Lead Data Analyst/Engineer
Resume:
Sachin Puppala
Graduate Data Analyst
Avenel, New Jersey, United States
*******************@*****.***
SUMMARY
Databricks certified Data Engineering and Business Analysis professional with 12+ years of experience designing and implementing scalable data solutions across Retail and Healthcare domains. Strong expertise in advanced SQL, data modeling, data warehousing, and ETL pipeline development in large-scale distributed environments. WORK EXPERIENCE
October 2014-Current
Graduate Data Analyst
International Scholars Office – OSU
Columbus, Ohio, United States
Coordinating with admissions office in providing appropriate services and support to international students. Mentored junior analysts and engineers on DBT development standards, SQL optimization, and data modeling practices. Enabled self-service analytics by building curated semantic and reporting layers through DBT transformations. Generating daily and monthly excel reports and performing data entries. Creating Statistical graphs using reporting tools. Analyzing data trends and patterns of student’s academic and demographic information. Integration/Mapping of current student information system with Banner system. Performing updates and changes for maintaining official websites using Drupal and Joomla.
July 2023-February 2026
Lead Data Analyst/Engineer
United Health Group
Jersey City, New Jersey, United States
Partnered with business and technology stakeholders to analyze data sources, relationships, and data lineage across enterprise data platforms, supporting Master Data Management (MDM) initiatives for consistent and unified data definitions. Translated business requirements (BRD’s)into detailed user stories and technical specifications in Agile environments using Rally/Jira, incorporating MDM standards for data consistency and governance. December 2021-May 2023
Sr. Looker Analyst
Etsy
New York, New York, United States
• *Global Digital E-commerce – Trust & Safety
• *- Performed business analysis across multiple domains, such as LRE (Legal, Response and Enforcement), Marketplace Safety, and Marketplace Standards, ensuring a seamless digital experience
• *- Built advanced analytical datasets using complex joins, nested CTEs, and window functions in Big Query and MySQL
• *- Performed data validation, transformation, and reconciliation to ensure accuracy and consistency of healthcare datasets.
• *- Integrated DBT with cloud platforms such as Snowflake, Google BigQuery, and Amazon Redshift for scalable ELT processing.
• *- Utilized Google Cloud Platform (GCP) extensively to query and analyze data for the Trust and Safety department.
• *- Ensured data accuracy by performing thorough validation and identifying potential error sources within the data.
• *- Designed a tracking system to assess the Financial GMS Impact (pre/post takedowns) along with other key metrics such as Precision rates, Enforcement Accuracy, Impact on Seller tiers using Big Query and Looker for entire Trust and Safety which saved 8 hours of redundant work per week
• *- Performed Data Analysis using data visualizations to effectively communicate insights and trends to stakeholders.
• *- Scheduled and shared dashboards with relevant teams, enabling easy access to critical information using Looker and utilized LookML for data modeling and analysis
• *- Developed 50+ bots/controls for identifying the violative listings across various areas such as Drug paraphernalia, Noxious plants, prescription drugs, mature content, religious content, political boundaries, NHM items, Brand counterfeit controls around all the branded items such as Rolex, Adidas, Nike etc. that do not meet guidelines and perform action using Big Query and My SQL and automated the process.
• *- Developed Dashboards related to QBR, Controls Impact, ERP using Looker tool to surface relevant data trends
• *- Performed headcount analysis for EOP agents by assessing the volume of listings to be reviewed to ensure we are not over/under staffed.
• *- Saved $23 million costs by improving precision of controls that flag violative listings using text-based analytics
• *- Received multiple guiding principle awards for digging deeper and collaboration
• *- Liaised with Engineering, Operations team to setup agent annotations for driving controls precision and worked with Citron Escalation team that occurred in Feb 23
• *- Successfully optimized query runtime from 4 hours to 30 mins by implementing performance tuning techniques
• *- Utilized Google Vision’s Image Recognition feature to accurately detect logos and labels within images adding value to the digital experience
• *- Built new KPI’s for our India content Moderation post our India launch and a framework to look at control’s precision at terms level
March 2016-December 2021
Sr Manager – Data Analytics Engineer
EXL
New York, New York, United States
• *Project 1: Horizon BCBS (State of California)- Readmission Modeling
• *- Developed modeling data set by integrating key data sources e.g., Claims, Provider files, Pharmacy, Plan Enrollment, Members using Python, ensuring master data standardization and consistency across core entities
• *- Utilized PySpark to query large datasets and extract valuable information for reporting and decision-making.
• *- Improved commercial healthcare data assets, including creation of master data within Integrated Workplace Management Systems (IWMS), enhancing data quality, reliability, and integrity for enterprise-wide reporting and operational efficiency.
• *- Performed ETL and initial data exploratory analysis using Tableau BI reporting tool
• *- Performing Data Extraction, Data cleaning, Data manipulation and Data consolidation
• *- Determining the risk factors predicting readmission for the given (Medicaid) population
• *- Identification of high-risk segments by creating decision trees using CART
• *- Saved 1.5 million financial costs by reducing the readmission rate by 1.5% SKILLS
SQL (Structured Query Language) Data Modeling Data Warehousing Database Extract Transform and Load (ETL) Python Programming/Scripting Language Microsoft Windows Azure Looker MySQL Cloud Computing Tableau Apache Atlassian JIRA Oracle ERP Drupal Joomla Selenium Analysis Skills eCommerce Sales Communication Skills GCP (Good Clinical Practices) Reconciliation Performance Tuning/Optimization Metrics ERP (Enterprise Resource Planning) Data Sets Data Quality Data Analysis Trend Analysis Business Analysis Data Visualization Reporting Dashboards Performance Metrics Prescription Drugs Healthcare Legal Query Analysis Systems Analysis Financial Analysis Financial Systems Team Player Safety Standards Query Optimization Software Engineering Oracle Oracle Forms SAP Acceptance Testing Information Technology & Information Systems Business Processes Customer Relations Cost Control Supply Chain Management Testing Reporting Skills Oracle Reports Production Costing Microsoft Project Health Insurance Healthcare Providers Algorithms Scorecarding Hospital Pricing User Documentation Scripting (Scripting Languages) Schedule Development Calendar Management Comparative Analysis Nursing Agile Programming Methodologies Requirements Management Master Data Management (MDM) Multiplatform/Cross-Platform Demographics Mentoring Create Graphs Database Report Tools Economics Statistical Reports Medicare Statistical Analysis System (SAS) Software Development Lifecycle (SDLC) Data Mapping Business Intelligence Data Collection Test Plan/Schedule Programming Methodologies ICD-10 Documentation Medical Treatment Data Cleaning Content Management Systems (CMS) Medical Coding Microsoft Transact-SQL (T-SQL) Vlookups Pattern Analysis Current Procedural Terminology (CPT) Risk Pharmacy Medicaid System Integration (SI) Artificial Intelligence (AI) Data Science Machine Learning Desktop PC Retail CERTIFICATIONS
Databricks Certified Data Engineer Professional
Generative AI Fundamentals (Databricks)
Advanced SAS and Base SAS certified
Advanced SQL for Query Tuning and Optimization
Python for Data Science and Machine Learning
Tableau Desktop Certified Associate and Specialist course HONORS & AWARDS
Saved 8 hours of redundant work per week
Saved $23 million costs by improving precision of controls that flag violative listings using text-based analytics Saved 1.5 million financial costs by reducing the readmission rate by 1.5% LANGUAGES
English - Intermediate
Contact this candidate