Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Vaibhav Chauhan

Vaibhav Chauhan

Data Analyst Intern

BMW of North America, LLC

Greater New York City Area, us

I’m a recent graduate from Stevens Institute of Technology with a Master's degree in Information Systems having specialized in Business Intelligence and Analytics. I’ve a Bachelor’s of Engineering in Electronics and Telecommunication from University of Mumbai, India. My primary interests include gathering large amounts of da...

Message
MENU ☰

BMW of North America, LLC

Data Analyst Intern

 Generated ad-hoc reports using SQL, ORAPROD & Parts Data Warehouse to analyze profit margins
for 11 parts distribution centers in North America
 Conducted Statistical analysis of the Repair Order report and created an interactive dashboard to
present the findings in to Senior Managers in Tableau
 Presented findings of the monthly dealer KPI reports generated using SAP for continuous
improvement to the higher level executives
 Performed monthly retailer parts inventory management impact analysis for retail incentive
programs
 Conducted monthly meeting with the dealers across North America to discuss their KPI’s for tiered
returns
 Transformed a process for generating a quarterly transportation report from COGNOS to SQL
 Generated and drafted the steps for SRD Parts Inventory monthly report
 Drafted RFI proposals for warehouse and transportation bids valued at over 6 million in annual
fees
 Conducted warehouse Client Company meetings and acted as a liaison in their transition into the
DMDC warehouse
 Developed COGNOS KPI reporting requirements for management based on parts sales
assortments
 Performed a parts assortment impact analysis for inventory stocking in 6 parts distribution centers
based on consumption, geography, and environment
 Developed and presented monthly management DMDC project status updates to C-level
executives aiding their decision making