Supply Chain Analyst - Data Science & BI

VARSHINI VATNALA

Supply Chain Analyst

New York, NY +1-929-***-**** **********@*****.*** linkedin.com/in/varshini-vatnala PROFESSIONAL SUMMARY

Supply chain analyst with three years across logistics operations and distribution analytics at DHL and UPS, backed by a master’s in data science from the University at Buffalo. Works daily in SQL, Python, Power BI, Tableau, Advanced Excel, SAP MM, Oracle SCM, and WMS and TMS platforms on shipment performance tracking, inventory reconciliation, demand forecasting, carrier SLA reporting, and KPI dashboard development. Owns reporting workflows end to end, from raw warehouse and transportation data through the weekly numbers operations leadership reviews, and is Lean Six Sigma trained in replacing manual reporting cycles with automated ones.

CORE SKILLS

Supply Chain and Logistics: Supply Chain Analytics, Inventory Management, Inventory Optimization, Demand Forecasting, Demand Planning, Logistics Management, Transportation Management, Warehouse Operations, Procurement, Vendor Management, Order Fulfillment, Shipment Tracking, Cost Optimization, SLA Management, Carrier Performance Analytics and Reporting: Data Analysis, KPI Reporting, Dashboard Development, Forecasting Models, Root Cause Analysis, Predictive Analytics, Data Visualization, Reporting Automation, Business Intelligence, Inventory Analysis, Logistics Reporting ERP and Supply Chain Systems: SAP MM, Oracle SCM, ERP Systems, WMS, TMS, Purchase Order Management, Inventory Reconciliation, Master Data Maintenance

Data and BI Tools: SQL, Python, Power BI, Tableau, Advanced Excel, Power Query, DAX, Excel Macros, Pivot Tables, VLOOKUP, XLOOKUP, SQL Server, MySQL, ETL Processes, Reporting Pipelines Process and Collaboration: Lean Six Sigma, Continuous Improvement, SOP Development, Process Standardization, Workflow Optimization, Process Mapping, Inventory Control, Stakeholder Management, Cross-Functional Collaboration, Operational Planning, Vendor Coordination

PROFESSIONAL EXPERIENCE

Supply Chain Analyst UPS, New York, USA Aug 2025 – Present

• Lead transportation and logistics analytics for regional distribution operations, maintaining the SQL and Power BI reporting layer leadership uses to track on-time delivery, route efficiency, and carrier utilization.

• Rebuilt the KPI reporting stack in Power BI and Power Query, folding warehouse throughput, inventory movement, and transportation cost into a single scheduled refresh and cutting manual reporting effort by roughly 35%.

• Own the weekly shipment exception review with logistics leadership, tracing recurring transportation bottlenecks through SQL operational reporting; delayed deliveries on the tracked lanes are down 18% since the review began.

• Established a carrier scorecard in Tableau covering SLA adherence, tender acceptance, and cost per shipment, now the reference point for vendor management in quarterly business reviews.

• Model inventory allocation and supply forecasting in Python against historical shipment data, and work with procurement, inventory, and warehouse teams on the ERP and WMS data quality those models depend on.

• Drove a Lean Six Sigma improvement across procurement coordination and warehouse workflow, mapping current state with operations leads and standardizing the handoffs that were causing repeat processing delays.

• Mentor two junior analysts on SQL query patterns and dashboard standards, reviewing their output before it reaches operations and distribution stakeholders.

Supply Chain Analyst DHL, India May 2022 – Aug 2024

• Assisted the regional logistics team with daily shipment tracking and exception reporting, pulling movement data from WMS and TMS platforms into Advanced Excel trackers reviewed by fulfillment supervisors.

• Supported monthly inventory reconciliation across distribution hubs, comparing SAP MM stock records against physical counts and flagging variances for warehouse leads to clear.

• Compiled weekly performance reports on on-time delivery, dock-to-stock time, and carrier utilization, consolidating source systems with Pivot Tables, VLOOKUP, and XLOOKUP.

• Collaborated with procurement coordinators on purchase order follow-up and vendor communication, keeping PO status current in Oracle SCM and escalating aging orders before they hit replenishment schedules.

• Took over the reporting workflow in the second year, writing SQL against shipment and warehouse tables and rebuilding the output in Power BI and Tableau so distribution managers had daily visibility rather than month-end summaries.

• Automated report consolidation with Power Query, Excel macros, and scheduled SQL extracts, removing close to a third of the manual preparation time from the weekly cycle.

• Analyzed two years of shipment and consumption history for demand planning, using root cause analysis on repeat exceptions to tighten replenishment on slow-moving SKUs and lift inventory record accuracy by 19% at the pilot hubs. EDUCATION

Master of Science, Engineering Science (Data Science) University at Buffalo, Buffalo, NY Aug 2024 – Dec 2025

Contact this candidate