Pooja Gumpula
Data Analytics & Engineering professional with 3.6 years experience delivering cloud ETL/ELT pipelines and BI reporting for US enterprise clients
Hire this person
Send a job offer directly to this candidate
About
Data Analytics & Engineering professional (3.6 years) delivering cloud ETL/ELT pipelines and BI reporting for US enterprise clients (energy/utilities, healthcare payer) via direct project engagement.
Core strengths: Azure Data Factory, Databricks/PySpark, SQL/T-SQL, Snowflake, Power BI/DAX, Tableau. Independently seeking remote full-time or contract roles — available to start immediately, no relocation or visa required.
Experience
Data Engineer & Analytics Consultant — Direct Client Project Delivery at Tata Consultancy Services (TCS) (2023-09 – Present)
Engaged via Tata Consultancy Services (TCS) as an individually staffed consultant on named US client accounts (not a bench/staffing pool role)
Data Engineer (Project 1: Enterprise Utilities Data & Analytics Platform) at Leading US Energy & Utilities Enterprise (2024-11 – Present)
- Partnered with business stakeholders to map core corporate KPIs into structured cloud warehouse schemas, reducing ad-hoc reporting requests by an estimated 30%
- Built automated ADF batch ingestion pipelines moving data from on-premise systems into ADLS Gen2, cutting manual data-load effort from days to hours
- Engineered a Bronze/Silver/Gold Medallion architecture in Databricks (PySpark, Spark SQL), improving downstream query performance on cleansed energy logs
- Developed SQL semantic models and analytical views enabling self-service reporting for internal business analyst teams
- Maintained data lineage documentation mapping technical transformations to business terminology for governance and audit readiness
Data Engineer & Analytics Consultant (Project 2: Healthcare Payer Insights & Reporting Platform) at Leading US Health Insurance & Payer Corporation (2023-09 – 2024-10)
- Analyzed large-scale insurance enrollment and claims data to identify and resolve reporting bottlenecks affecting cross-functional visibility
- Built Python/SQL ETL pipelines to orchestrate and load historical premium data into AWS Redshift
- Designed production Power BI dashboards with advanced DAX and Time Intelligence functions, used by leadership to track quarterly claim approval trends
- Configured Row-Level Security (RLS) policies to protect sensitive patient data while enabling role-based executive views
- Automated weekly reporting workflows using Apache Airflow, cutting turnaround time from roughly 3 days to under 1 day
Data Engineering & Analytics Intern at Fractal Analytics (2023-01 – 2023-06)
- Supported senior analytics leads in translating business goals into pipeline transformation logic and requirements checklists
- Wrote SQL validation scripts to detect pipeline anomalies, deduplicate records, and profile raw vendor data
- Built Power BI dashboard prototypes to visualize internal operations metrics for leadership review
- Participated in Agile ceremonies using Jira for sprint tracking and Git for version-controlled releases
Data Analytics Job Simulation at Deloitte Australia (2024)
- Completed a Deloitte Australia data analytics program covering data analysis, forensic technology, and client-facing reporting exercises
Education
Bachelor of Technology (B.Tech) in Computer Science and Engineering – Jawaharlal Nehru Technological University, Hyderabad (2023)

