Data Analyst Business

SHUBHAM CHAUDHARY

*** * **** ** ******* Illinois 60616

(312) 752- 7461 ****************.***@*****.*** GitHub

EDUCATION

Master of Science in Business Analytics December 2022

University of Illinois Chicago GPA: 3.69

Key Courses: Machine Learning, Big Data Analytics, Marketing Analytics

Bachelor of Technology in Electronics and Communication Engineering May 2020

SRM Institute of Science and Technology, Chennai, India GPA: 3.2

TECHNICAL SKILLS AND CERTIFICATIONS

Data Visualization: Tableau, Qlik Sense, Power BI, and Qlik View

Programming Languages: R, SQL, Python

Big Data: Spark, Hadoop, Pig, MapReduce and PySpark

Database: Microsoft SQL Server 2014, Oracle SQL developer, RDBMS, Informatica MDM, MySQL

Analytical Tools: MS Excel, R Studio, Google Sheets

Machine Learning: NumPy, Pandas, Matplotlib, XGBoost, NaiveBayers, caret, dplyr and randomForest

Tableau Certified Desktop Specialist and Qlik Sense Business Analyst Certification

EXPERIENCE

Snap On Crystal Lake, Illinois

Data Analyst Intern June 2023 - present

•Created 10 Tableau dashboards to track individual productivity from production, inventory and receiving departments

•Analyzed data from 10+ SQL databases to write complex queries using joins, sub queries and window functions that help in tracking KPIs like Receiving efficiency per day, Inventory turnover, Cash to Cash Cycle time and Order fill rates.

•Using predictive analytics created dashboards that help in calculating overall efficiency across departments, reducing overhead costs in labor planning and finding opportunity for improvements in various receiving processes

•Presented insights to senior leadership and gained appreciation from them for pointing out bottlenecks with their solutions

HelloFresh Aurora, Illinois

Operational Planning Analyst Feb 2023 – May 2023

•Collaborated with different departments (inventory, kitchen, and production) to collect data and identify operational needs

•Developed dashboards in Google sheets to reduce the amount of meal discards by 50% from different fulfillment centers

•Performed ad hoc data analysis for product teams to explain different data collection points and forecasting methods

•Reduced technical errors by 30% in planning tools by improving the troubleshooting process and removing recurrent errors

MediaOcean LLC Chicago, Illinois

Business Operations Intern June 2022 – Dec 2022

•Collaborated with functional teams (Finance, Sales, and Operations) to collect relevant data and identify business needs

•Designed a data architecture to create 6 Power BI dashboards by aggregating more than 30+ flat files and developed dashboards that track YoY revenue growth, client health and media spend through different social media platforms for over 200 users to strategize their marketing towards consumers

•Designed an operational database aggregating financial, revenue and operations data in the Snowflake environment to reduce data aggregation from 2 hours to 2 mins for data accessibility in one place

•Performed ETL using staging tables to clean 1 million+ records to reduce data cleansing activity from 1 hour to 5 minutes

Cognizant Technology Solutions Chennai, India

Programmer Analyst July 2020 – July 2021

•Developed 10 Tableau dashboards for annual sales review by 20+ business analysts by aggregating 30+ SQL databases containing information about customer demographics, product descriptions and sales channels

•Developed SQL queries for reducing time for MDM data loads & displaying data in CRM tools from 1 hour to 10 minutes

•Improved customer satisfaction scores (CSAT) from 8 to 10 by managing aggressive SLAs, prioritizing, and closing high-priority tickets within 5 days.

•Performed data cleaning for quarterly review by removing 100+ products performing poorly in APAC regions to enhance 30+ Tableau dashboards by performing site administration to reduce failed data extracts refresh, which led to dashboard breakages and managing users

Contact this candidate