Vrushti Shah

240-***-**** ad22t7@r.postjobfree.com linkedin.com/in/vrushti

WORK EXPERIENCE

University of Maryland College Park, MD

Data Analyst Aug 2023 - Present

● Developed Tableau dashboards converting complex data into user-friendly visualizations that empowered Student Affairs department to improve decision making efficiency by 35%.

● Formulated department specific KPIs within UMD for 15 departments using intricate SQL queries and data integration tools. Accenture Mumbai, India

Data Engineering Associate Jun 2021 - Jul 2023

● Worked extensively with Google as a client, contributing to the development and maintenance of the Google’s Consumer Hardware Data Warehouse. Successfully completed the following projects:

● Logistics Cost Calculator

● Designed a Logistics Cost Calculator utilizing Python, BigQuery and ETL integration, enabling real-time logistics and warehouse cost calculations based on over 15 parameters.

● Delivered a Looker dashboard, resulting in a 30% increase in decision-making efficiency for the client's logistics operations.

● Inventory Aging Dashboard

● Crafted an advanced Tableau dashboard employing Heatmap Matrix, Pareto Analysis, and Sankey Diagram to visualize inventory aging dynamics across 55 warehouses and 12,000 unique SKUs.

● Implemented a real-time inventory monitoring system and optimized resource allocation based on data insights, leading to a 37% decrease in aged inventory and 25% increase in annual cost savings.

● Automation of Weekly Code Release

● Pioneered the automation of weekly code release using an AppScript-based solution in Google Sheets, reducing release time by 2 hours. Led cross-functional collaboration, boosting team productivity.

● Optimizing Data Architecture

● Analyzed BigQuery table performance, identified bottlenecks, and implemented performance tuning, resulting in a 20% improvement in data retrieval speed.

TECHNICAL SKILLS

SQL, Google BigQuery GCP, Python, R, Tableau, Looker, Power BI, ETL, Hadoop, Tensorflow, Scikit-learn, Sklearn, Numpy, Pandas, MS Office Suite, Google Suite, Optimization Modeling, Hypothesis Testing, Statistical Modeling, Solver, Risk, Precision Tree EDUCATION

University of Maryland, Robert H. Smith School of Business College Park, MD, USA Master of Science in Business Analytics, GPA – 4.00 Aug 2023 - Dec 2024

● Course work: Data Processing & Analytics in Python, DBMS, Data Models & Decisions, Decision Analytics, Big Data & Cloud Computing, Data Mining & Predictive Analytics, Data Visualization & Web Analytics, Operations Analytics L.D. College of Engineering Ahmedabad, India

Bachelor of Engineering, Electronics & Communication, GPA - 3.63 Aug 2017 - May 2021 PROJECTS

Refugee Population in the United States:

● Analyzed the data, containing 10 years of data on over 1.5 million refugees. Created predictive model using Python to forecast refugee population dynamics based on country of origin and socio-economic factors (including age, gender, education level, and employment status).

Crop Price Prediction System:

● Implemented a crop price prediction system using Random Forest Regressor, achieving a mean average error (MAE) of 8.37% and R-squared as 0.99 on historical data. Conducted Feature selection using LASSO regression which identified 4 key variables impacting prices.

LEADERSHIP AND VOLUNTEER EXPERIENCE

Vox Populi Club (Socio-cultural), President Jun 2019 - Jun 2020

● Led a team of 20 individuals for a year and organized 4 key events including a Social Outreach Program and Volunteer program during COVID-19 pandemic.

Contact this candidate