Priyanka Savant

The Home Depot | Seattle, WA

Senior Data Analyst

April 2022-Present

• Enhanced planning capacity for the International Dynamic Routing (IDR) report, which plays a crucial role in forecasting container needs for the upcoming 32 weeks across all the ports. This helped to compare the forecasts with actual demand, resulting in a 46% overall improvement and accuracy in logistics planning and savings of $2.8M

• Led the technical onboarding and suggested order frequency analysis (based on sales forecast) of 100+ import vendors (equating to inventory of ~$1.2B) to incorporate optimization of containers

• Played a pivotal role in tracking and optimizing the Daily Divert Rate metric with dashboards and reports which improved data visibility, leading to improved accuracy in decision-making which effectively resulted in savings opportunities valued at $2.5M and increased the metric by 22%

• Implemented data-driven strategies and identified potential opt-in to accurately forecast the store demand during the Chinese New Year (CNY) duration, reducing excess inventory at the stores and minimizing OOS by 32% Developed and implemented metrics to monitor and built reports to track the forecasted volume and evenly spread out the volume to avoid any over allocation at the stores for import vendors

• Built end-to-end multiple automated reports using Python which included opportunities for SKUs to be in sync, quantifying manual purchase orders placed which reduced cost incurring manual errors by up to $450k on a monthly run-rate basis

• Provided timely ad-hoc analysis to different cross-functional teams, led weekly task of onboarding new vendors on Import Sync in addition to monitoring of PO validations to ensure systematic placement of orders and increased onboarding import vendors capacity by 28%

• Enhanced overall decision-making for the Inventory Replenishment team by developing a transload allocation audit report using SQL and Python, enabling proactive identification of department and class overage SKUs while facilitating optimized store allocation tactics

• Collaborated with the Product Management & Procurement teams to develop business logic and provide high severity analysis based on the store stocking OUL allocation logic, resulting in an overall reduction in the store overage allocation variance in a specific department by 8% and out-of-stock Stocking Distribution Center (SDC) by 20%

• Utilized Google Big Query and Python to automate the stock distribution center (DC) reports shared on a weekly basis with relevant stakeholders – This resulted in a 4-hour reduction in corresponding manual work on a weekly basis

Rx Connection LLC. | Dallas, TX

Data Analyst

March 2021-Present

 • Engineered a dashboard integrating intricate KPIs sourced from diverse claims processing systems, offering a unified perspective to evaluate client’s performance. Leveraged data consolidation techniques to streamline claims data from various sources, enabling seamless comparison of yearly and monthly growth trends. This strategic initiative yielded a remarkable 30% enhancement in data efficiency, empowering swift and accurate decision-making.
• Partnered closely with Strategic Account Executives to craft and deliver automated weekly reports tailored to meet clients' specific business requirements reducing manual efforts and enhanced data collection process to update the dashboard periodically, reducing human effort by 80%
• Collaborated with Engineering team to analyze customer behavior, engagement, and identified customer drop off points in the benefit flow plan, leading to 12% increase in conversion rates
• Extracted quarterly customer usage reports from the database, conducted in-depth analysis of Pharmacy Benefit Management data
• Transformed the data into visually compelling dashboards highlighting key metrics such as drug utilization rates, formulary compliance, and specialty drug spend. These dynamic visualizations not only provided critical insights into PBM utilization but also informed strategic decisions, ultimately optimizing pharmacy solutions and enhancing the decision-making process
• Implemented strategic interventions based on root cause analysis, resulting in a 10% decrease in claims denials and rejections

Agency Partner Interactive (API), Texas

Data Analyst Intern

August 2020-December 2020

• Extracted and cleaned the data from the cloud-based server and used SQL to write queries involving multiple tables using MySQL Workbench

• Collaborated with a team of 2 to develop the database to provide flexible and efficient access to the information and increased overall efficiency by 25%

• Partnered with the Marketing and the Sales teams to develop custom reports and interactive dashboards to observe trends and provide business strategies using Tableau

• Provided useful insights on spending, budgets, and performance according to requirements from the business user

​