Likhitha Gompa

Results-driven Data Analyst with 5+ years of experience designing scalable data models, building executive-level dashboards, and translating complex datasets into actionable insights. At Amazon, delivered data infrastructure supporting 500+ managers across the UK and EU, contributing to a 4% improvement in on-time delivery across 200,000+ monthly orders. Proficient in Power BI, Tableau, SQL, and Python, with a strong track record of stakeholder engagement and Agile delivery across e-commerce and enterprise environments.

Data Analyst at Amazon (2020-07 – 2023-11)

Created and maintained centralised SQL data models, designed Power BI dashboards for 500+ stakeholders, and improved on-time delivery rates by 4%.

• Created and maintained a centralised SQL data model (star schema) consolidating data from 6 operational systems, improving report consistency and reducing conflicting metrics across teams
• Designed and maintained Power BI dashboards tracking fulfilment centre KPIs, inventory health, and delivery performance, used by 500+ operations and programme managers across the UK and EU
• Delivered governance-compliant Power BI dashboards with row-level security (RLS) for 50+ stakeholders, and presented data-driven insights to Operations Directors and Programme Managers to drive fulfilment and delivery strategy decisions
• Improved on-time delivery rates by 4% across 200,000+ monthly orders by analysing 9 months' data and implementing a data validation process that identified and resolved discrepancies
• Wrote complex T-SQL and Amazon Redshift queries (CTEs, window functions, multi-table joins) to extract, transform, and validate large datasets from multiple source systems
• Monitored and optimised the performance of Tableau dashboards, ensuring smooth data processing and user experience
• Mentored 2 junior analysts on SQL query writing, Power BI data modelling, and DAX best practices as part of Amazon's internal upskilling programme

Data Analyst at Tech Mahindra (2019-05 – 2020-06)

Conducted sales analysis, built interactive Power BI dashboards with 30+ visualisations, and improved data accuracy through validation procedures.

• Conducted in-depth analysis of a 15% sales decline using Power BI, identifying key drivers of variability and presenting actionable insights to stakeholders
• Built interactive Power BI dashboards featuring 30+ visualisations of sales KPIs, profits, and trends across multiple dimensions, leveraging parameters, calculated fields, joins, and filters for robust business analysis
• Transformed raw data into structured, analysis-ready formats through data cleaning and modelling, improving Business Intelligence insights and understanding of customer needs
• Maintained and validated customer and sales data to ensure accuracy and integrity, directly supporting Sales Operations reporting
• Collaborated with process leads on an Agile Scrum project, contributing across all sprint ceremonies from planning through retrospective to deliver iterative improvements

Data Associate at Tech Mahindra (2018-01 – 2019-04)

Managed and transformed large datasets in Excel with 99%+ data accuracy through validation procedures.

• Managed and transformed large datasets in Excel, maintaining high accuracy through rigorous data entry and resolving inconsistencies
• Achieved a 99%+ data accuracy rate by developing and implementing structured data validation procedures

Bachelor of Technology in Mechanical Engineering – Jawaharlal Nehru Technological University, Kakinada (2013-06 – 2017-04)