Karan Bhatia Email & Phone Number

Auburn Hills, Michigan, United States

Gautam Buddha Nagar, Uttar Pradesh, India

Managed a team of 50 highly skilled workers involved in manufacturing and export of electronic grade chemicals for semiconductor & pharmaceutical industry

Troy, Michigan

• Led a team of 5 analysts which included a mix of Data Analysts, Marketing Analysts & BI Tool Developers to support analytical needs of the clientele of Fiat Chrysler Automobiles of US & Canada, Mitsubishi USA, Honda USA• Managed enterprise BI platform including highly visible KPI metrics of sales, close rates, affiliate & campaign management, digital advertising and dealer performance facilitating the clients to make useful decisions in the Brand, Dealer Website & 3rd Party programs they maintain for online Lead Management System

Dearborn, Michigan

• Responsible for ingestion, standardization, enrichment, mastering and assembly of data products for downstream applications in the manufacturing domain for enterprise data integration to support Ford’s Blueprint for Mobility strategy and the One Ford Plan for profitable growth• Data streams included Customer, Dealer, Vehicle & Manufacturing Assembly Lines• Data Transformations tools used: Alteryx &Hadoop to support the KPI analytical dashboard needs in OlikView

Detroit, Michigan

• Onshore analytics lead for parent company (Mu-Sigma Inc.) managing the engagement between General Motors (HQ- Renaissance Center) and a team of 10 analysts in Bangalore, India• Responsibilities included strategizing with GM's Pricing Director, North America and his team of Segment Managers enabling them with data driven decision making in terms of option bundling, features & package pricing, accessories pricing & inventory management and overall trim pricing fo different segments• Segments included FSUs, FSPUs & Sports division. Key analysis included assessing Customer Behavior, analyzing Cannibalization Effect within & also with the competitors along with working Price Simulation Models• Played a key role in development of a scenario builder tool for the GM Parts & Accessories team residing within GM-CCA Grand Blanc MI which is currently helping them make data driven decisions on pricing the accessories as well as managing the inventory. Limited the potential loss to $4 Million from a possible loss of $18 Million from channel cannibalization risks by applying Discount sensitivity analysis for the existing inventory products• Involved in integrating disparate data sources into one, efficiently map data across key dimensions into an integrated view and create a visualization layer to enable real-time, more effective decisions

Jersey City, New Jersey, Us

• Fraudulent Claims Model: Independently developed a model for Horizon Blue Cross Blue Shield of New Jersey. The scope of the model was to identify the claims of the fraudulent members and identify such claims coming in the future• Hospital Scorecard: Solely responsible for creating an automated version of the Hospital Scorecard for AmeriHealth New Jersey focused on the efficiency of the inpatient and ER departments

Detroit, Michigan, Us

• Performance Management Dashboard: Worked extensively as a single resource for Blue Cross Blue Shield of Michigan in Downtown Detroit area on creating a user interactive dashboard which measures the initial and past performance of every vertical including finance, revenue, claims & HEDIS & STAR Ratings department of this healthcare insurance institution

Manchester, United Kingdom

• Complaint Forecast Model: Worked on an extensive onshore project in Manchester (England) to support British Gas in order to identify key variables which were to be treated as candidates for complaints and hence help the onshore team to improve the current model of complaints forecast• Correlation Calculator: As a part of the above project, a robust complaint correlation variable calculator was created using traditional modelling tools and techniques like SAS, Regression. Identified Data Anomalies and Outliers present in the datasets. Performed trend analysis on various processes and formed correlations between them

Noida Area, India

• Contact and complaint analysis for British Gas - an energy leader based in UK: Analyzed the contact and complaint behavior of customers with respect to different events and check their satisfaction levels by NPS scores (survey data) given• Cost Analytics around consume and pay customer journey using SAS. Studied and analyzed the customers’ contact and complaint trend and provided valuable insights to the clients in terms of cost savings• Customer satisfaction Analysis: Analyzed how the satisfaction of a customer relates to their behavior and organizational events combined and hence to effectively make changes so as to make least changes in customer satisfaction levels• Complaint Propensity Model: Calculated the propensity of a customer to complaint on the basis of his/her attributes and organizational journey and hence be able to predict and take proactive measures to prevent the same. Helped reduce the complaints by 16% in a year• Digital Transition Model: Invited to client location in London (England) for 3 weeks to set up a robust model using customer segmentation of web & app transactions according to customer demographics in order to improve the digital experience & increase digital engagement

Bachelor Of Technology (B.Tech.), Mechanical Engineering

High School, High School