AG

Akash Gupta

Analytics Intern · Essilor Luxottica

Dallas, TX

Work Experience

Analytics Intern

Essilor Luxottica

2022 – 2022

Collaborated with cross-functional teams to transition from ad-hoc reporting to automated key performance indicators (KPIs) dashboards using Power BI which increased operational efficiency by 40%. • Preprocessed and cleaned 160K+ rows of customer data using Python (NumPy, Pandas, Matplotlib, Seaborn) and performed exploratory data analysis to check for outliers and data distributions. • Implemented regression (Linear and Logistic) models on customer spending data to identify purchase behavior and patterns. Prepared and presented on target marketing which improved cost efficiency by 27%.

Business Analyst

Farmfuls

2020 – 2021

Created and executed complex SQL queries (joins, window functions, subqueries) in MS SQL Server to analyze customer purchasing behaviors and built Tableau dashboard to provide data-driven insights to key stakeholders. • Performed Exploratory data analysis on sales data using Python to analyze trends and predict sales outcomes, resulting in sales growth of 45% by enhancing sales force quality and transparent pricing. • Implement regression analysis using Python to determine business factors contributing to better customer engagement which resulted in customer retention by 30% in a 12-month period.

Education

Bachelor of Business Administration

Devi Ahilya Vishwavidyalaya

2016 – 2019

Bachelor of Business Administration

Master of Science

The University of Texas at Dallas

2021 – 2023

Master of Science