Data Analyst Retail Sales

Sahil Yadav

Richardson, TX 469-***-**** **************@*****.*** https://www.linkedin.com/in/sahil-yadav-419a1a156/ EDUCATION

The University of Texas at Dallas Aug 2022-May 2024 Master of Science- - Business Analytics GPA: 3.4/4.0 Relevant Coursework: Predictive Analytics, Database Foundations for Business Analytics, Statistics and Data Analysis, Prescriptive Analytics, Business Analytics with R, Project Management SRM University, India Aug 2016-May 2020

Bachelor of Engineering, Information Technology GPA: 3.6/4.0 Relevant Coursework: Data Structure and Algorithms, Database Management System, Software Engineering, Data Mining TECHNICAL SKILLS

Programming Languages: Python (NumPy, Pandas), R, SQL, SAS, HTML, CSS, UNIX, Shell Scripting BI/ ETL Tools: Tableau, Looker, Power BI, Advanced Excel (VLOOKUP, Pivot Tables), Hadoop Databases: MySQL, MS SQL Server, MongoDB, Oracle SQL, PostgreSQL Statistics: Hypothesis Testing, A/B Testing, T-test, Chi-square, Regression/Random Forest/NNW, Time Series CERTIFICATIONS

Learning Microsoft Project (LinkedIn Learning and Project Management Institute) Introduction to R and Intermediate R (DataCamp)

SQL (Stanford University)

WORK EXPERIENCE

Data Analyst LatentView Analytics India Aug 2020–Jul 2022

• Supervised Marketing Analytics domain for a major Media and Entertainment client handling their US market using tools and technologies like Python, Looker, Power BI, Tableau, and Excel.

• Analyzed the effect of different variables like Release Dates, Weekends, Promo, and Holidays on the sales of products and ascertained which parameters, directly and indirectly, affect sales using machine learning models.

• Acted as a Subject Matter Expert on Looker, providing guidance and support to other teams.

• Enhanced Customer Behaviour Analysis by 30% through Customer Segmentation and accelerated business growth by building detailed reports for generating accurate insights. Intern LatentView Analytics India Jan 2020–Jul 2020

• Oversaw and developed multiple dashboards to visualize product performance and analyze Marketing metrics like SEO, CTR and Channels.

• Collaborated with the team to develop complex features through requirement gathering, planning, solution design, and implementation which led to collecting product insights and measuring product success.

• Cooperated fully with product owners and enterprise architect to understand requirements.

• Developed reports in Tableau for communicating monthly status to the stakeholders and reduced the turnaround time by 20%. ACADEMIC PROJECT EXPERIENCE

US E-Commerce Data Analysis – [MySQL, Tableau, Microsoft Excel]

• Modeled an efficient database for restaurants in the US using efficient Entity-Relationship modeling and normalization techniques to store, retrieve, and update organization data.

• Implemented multiple analytical functions and SQL queries in MySQL to derive insights and perform exploratory data analysis.

• Linked the result sets in Tableau using MySQL connector and created a dashboard to perform explanatory data visualization. Retail Sales Forecasting Project – [SAS, Python]

• Performed data cleaning, feature engineering, and end-to-end data analysis on the Food item dataset in SAS and Python.

• Trained supervised Machine Learning Model after data cleaning and performed price and demand analysis and identified other interesting insights.

• Demonstrated feature correlation with price variation to assist stakeholders to drive key business decisions. Graduation Ceremony Project – [Microsoft Project, Reporting]

• Designed a WBS with Microsoft Project for the ceremony by consulting an active academic SME and learning about the previous ceremonies.

• Collaborated with team members to define the scope and proposal document including all the stakeholders.

• Implemented effective Resource, Cost and Schedule Management strategies to organize a successful university wide promotional event.

Contact this candidate