Sri Harsha Gorantla

Data professional with 3+ years of experience across the data lifecycle: designing relational data models, building automated ETL/ELT pipelines, and delivering clean, production-ready datasets and reporting in SQL and Python. Cloud data engineering experience spans a production AWS pipeline (S3, Lambda, Glue, Redshift) built to bring sales, inventory and customer data into a single warehouse, and a self-built, end-to-end AWS project (S3, Glue/PySpark, Redshift, Airflow) with a star-schema warehouse and idempotent, repeatable loading, fully documented with an architecture decision record, data dictionary and operational runbook. Experienced in partnering directly with operations, founders and marketing stakeholders to translate business questions into structured, reliable data products, and in automating manual workflows to improve turnaround time and data reliability.

Currently studying for the AWS Certified Data Engineer – Associate certification.

Data Analyst, Customer Operations - Teleperformance Ltd - United Kingdom

(2024-09 - 2026-05)

• Automated the weekly data extraction and report generation process using Python, reducing turnaround time by 30%.
• Resolved dataset inconsistencies across multiple call-log sources that were causing figures to differ between reporting tools, improving data reliability by 25% across the operations team.
• Own and maintain 8 live KPI dashboards in Power BI used by supervisors to manage daily operations, covering call handling time, booking success rates, cancellation volumes and agent performance.
• Investigated repeat-contact patterns across 500k+ booking and interaction records, identifying cancellation and rescheduling behaviours driving avoidable callbacks; recommendations contributed to a 10–15% reduction in repeat contacts.
• Ran root cause analysis on the top recurring complaint categories; findings were incorporated directly into team training materials and SOPs used by team leaders on an ongoing basis.

Data Engineer - Nurogen Healthcare Ltd - London

(2023-06 - 2024-08)

• Built the entire analytics function from scratch for a pharmaceutical excipient startup with no existing reporting infrastructure, working directly with the founders to establish what needed to be tracked and why.
• Designed and operated an AWS-based ETL pipeline (S3, Lambda, AWS Glue, Amazon Redshift) to bring sales, inventory, customer, product and web analytics data into a single warehouse: organised S3 into raw, processed and archive layers; used Lambda to validate incoming files and trigger the corresponding Glue job; used Glue to deduplicate, standardise and join the data before loading fact and dimension tables into Redshift for Power BI reporting.
• Structured and analysed approximately 25,000 historical sales, inventory and customer records, creating the data foundation the business needed before any meaningful reporting was possible.
• Integrated Google Analytics with internal sales data to map the full customer journey, identifying specific drop-off points in the purchase funnel that informed website changes.
• Delivered 7 Power BI dashboards used daily by founders and management for business reviews, covering sales trends, inventory movement, customer engagement and website performance.
• Ran customer segmentation analysis on the early customer base, grouping buyers by purchasing behaviour, used by the marketing team to run targeted campaigns during the product rollout phase.

Project Controller | Academic Research Internship - University of East London

(2022-10 - 2023-05)

• Built a regression-based cost estimation model on 500+ historical construction projects, achieving under 10% mean absolute error, more accurate than the manual approach previously used.
• Quantified for the first time that location and material specification were the strongest cost drivers; presented findings to an industry panel alongside an academic examiner.

MSc - Civil Engineering - University of East London (2021-09 - 2023-06)

BTech - Civil Engineering - Lovely Professional University (2016-08 - 2020-09)