Apoorv Shrawat
Naperville,IL
Summary
Data analysis professional prepared to deliver impactful insights and drive business decisions. Adept in data visualization, statistical analysis, and database management, with strong focus on teamwork and adaptability. Known for reliability, analytical thinking, and results-driven approach. Skilled in Power BI, SQL, Excel, Python ensuring robust data solutions and strategic recommendations.
Overview
6
6
years of professional experience
Work History
Data Analyst- Transformation Enablement
CDW
Vernon Hills, IL
12.2025 - Current
- Worked across various teams to set correct timeclock data in Workday which was impacting hundreds of users as the time was not showing correctly post workday migration.
- Worked on Return pro to match what Return Pro has vs what we show on our end (SSMS). Understood and streamlined the architecture of return pro and built in house reports for Executives using Power BI, Showcase and SSMS.
- Responsible for warehouse migration across 10 teams from Legacy EDW to cloud with Continuous UAT and EDAS team integration leveraging copilot in SSMS 21.
- Built entire Returns Dashboard including Return pro, Compliance and ROI measures ensuring accuracy of metrics by meeting and discussing it with stakeholders.
- Migrated the entire Operations Doc used by Executives and VPs to report out numbers to Cloud ensuring data integrity and accuracy including Shipping, Returns, Stocking, Receiving and B&H.
Supply Chain Data Analyst
CDW
10.2019 - 12.2025
- Designed, developed, and deployed enterprise-level Power BI dashboards for Transportation Services Management (TSM), establishing a unified reporting hub for Claims, Outbound Shipments, and Shipment Tracking.
- Built and maintained advanced Customer Experience and ICAN data models, eliminating redundant manual tasks and increasing reporting efficiency across the Supply Chain Strategy organization.
- Served as the primary SME for supply chain analytics, ensuring rapid, accurate triage and resolution of stakeholder-submitted ServiceNow incidents.
- Led the transition from Legacy EDW to Cloud DB, conducting full end-to-end UAT, validating data integrity, and providing final sign-off after collaborating with Data Science & Engineering teams.
- Leveraged Copilot AI to accelerate issue diagnosis, uncover analytical insights, and enhance BI delivery speed, significantly improving overall turnaround time for business partners.
Education
Master of Data Center Operations and Management -
Illinois Institute of Technology
Chicago05-2018
Skills
- SQL
- PowerBI
- AS400-IBMi
- Showcase
- Dax
Timeline
Data Analyst- Transformation Enablement
CDW
12.2025 - Current
Supply Chain Data Analyst
CDW
10.2019 - 12.2025
Master of Data Center Operations and Management -
Illinois Institute of Technology