Akash Gupta
Analytics Intern · Essilor Luxottica
Dallas, TXWork Experience
Analytics Intern
Essilor Luxottica2022 – 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
Farmfuls2020 – 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 Vishwavidyalaya2016 – 2019
Bachelor of Business Administration
Master of Science
The University of Texas at Dallas2021 – 2023
Master of Science