Who is Puneet Bhatia?

Hello! I am Puneet,a graduate student in Business Analytics at the University of Cincinnati.

Academic Background

• B.TECH in Mechanical and Automotive Engineering, Delhi Technological University, Delhi, India
• M.S. Business Analyics, University of Cincinnati, Cincinnati, OH, United States

Professional Background

I started my professional career as a Data Analyst with Tata Motors, in Pune, India. My duties involved demand forecasting and inventory planning at the dealership level and strategic channel management. After working in Tata Motors for 6 months, I decided to shift to a more quantitative and analytical role, so I joined the management consulting firm ZS Associates as a Business Operations Associate. At ZS I

• Led the development, requirement gathering, client interactions and ad-hoc analysis of Sales Incentive Compensation Plans and Awards of a Fortune 100 Pharmaceutical Client in North America region for multiple Business Units
• Designed a SQL based system to run Oncology Business Unit Contests (extra incentive component based on complex Business rules) which was leveraged to reduce operational time by 60%
• Developed sales goals of various drugs for North American territories using regression analysis, statistical simulations and data manipulation using SQL
• Developed an interactive Tableau Dashboard which segregated data on various parameters and showcased Incentive Compensation Health Check Insights using statistical measures and presented the insights in client meetings

Experience in R

I have used R at my workplace, primarily for Data Visualization using the ggplot2 package and base R functions.

Experience with Other Analytic Software

I have extensively worked on SQL, Tableau and Advanced Excel at ZS. Through my curriculum at UC and through online courses I have also built basic expertise in the following tools :

• Python
• SAS
• Excel Solver
• FICO Xpress