May 2022 – Aug 2025 · 3 yrs 3 mos · Chicago, Illinois, United States · Remote

• Project: Forecast of sales and volume of each client account across six business divisions
• Achieved <10% MAPE (Mean Absolute Percentage Error) by automating sales & volume forecasting of 10000+ accounts across six business units using ARIMA (Autoregressive Integrated Moving Average) for a 12-month horizon
• Project: Driver Application Ranking to identify 5-star drivers among applicant pools
• Reduced lead time spent in the driver hiring process by 30% ranking applications that are more likely to stick with the company for the long term using a ‘Random Forest’ algorithm on non-discriminatory attributes of the applications
• Project: Financial Data Analysis of non-contracted Vendors
• Saved over $8 million annually by flagging the different vendors that charged more than the industry standard across 13 types of transport-related expenses in daily operations

Jun 2019 – Jul 2021 · 2 yrs 1 mo · Noida Area, India

• Project: Most valuable stores for Consumer Produced Goods Beverage Company
• Valuable Store Segmentation: Reduced 15% marketing & supply-chain cost by predicting and categorizing over 10000+ store sales potential for a Consumer Produced Goods Beverage Company across multiple geographies using quantile regression
• Project: Churn Identification for accreditation providing organization
• Churn Customer Identification: Customers that are not likely to renew the subscription in future using Support Vector Machines algorithm resulting in 60% increase in subscription renewal out of 12000+ customers
• Project: Automated Classification of Support Calls for Industrial Company
• Support Call Routing: Automated classification and routing of customer support calls at call centers to their respective department using ‘Support Vector Machines’ algorithm resulting in 50% decrease in query-resolution time and 40% increase in customer engagement
• Project: Greenhouse gases emissions calculation and tracking
• Automobile CO2 Emission Tracking Dashboard: Spearheaded a team of two analysts to develop dynamic dashboard for MNC catering their entire fleet running over 200 countries through reports like CO2 emission, total ownership, maintenance cost etc. leading to revenue saving over $700000

Jun 2018 – Jun 2019 · 1 yr · Noida Area, India

• Project: HealthCare Survey Data Analysis for Pharma Company
• Identification of key influencing parameter: Identified key influencing variable out of over 270+ variables whether a person will take medication or not using Random Forest technique
• Project: Creation of Tableau Dashboard for Digital Ads Spend
• Digital Activity Dashboard: Created executive summary level tableau dashboard from scratch highlighting month on month trends like impressions, Click-through Rate, etc. across all digital promotional channels for pharma products

Jul 2016 – May 2018 · 1 yr 10 mos · Gurgaon, India · On-site

• Project: US-based Pharma Company (Life Science Marketing Analytics)
• Supply Chain Analysis: Predicted Returns forecast for all brands based on demand at the patient level, inventory in supply chain and delay in dispatch enabling Client to have a better view of probable future revenue reversals using statistical methods
• Business Reports: Created numerous daily business reports useful for giving business insights to increase the effectiveness of their sales team
• Call Planning: Computed quarterly plan for sales team on a quarterly basis to optimize marketing cost for targeting physicians
• Received honorarium for imparting R training to new Associate at BU level
• Project: Migration of Data from SAS/SQL to Big-Data
• Lead the planning and execution of moving SAS/SQL written queries to Hive (Big-Data), developing from scratch HQL queries for complex operation like deciling, transpose, etc.
• Full ownership of setting up the overall system taking into account all technical requirements, access restrictions and possible failures scenario.
• Trained the team of 20 peoples in Big-Data covering Map-Reduce, Hadoop-Hive environment, hardware, system configuration, HQL coding, etc.

Jul 2014 – Jul 2016 · 2 yrs · Indore Area, India · On-site

• Project: Jumbune (Product Development)
• Designed and created from scratch, generic Json Data Validation module (first of its kind) for Json data stored in HDFS (Hadoop Distributed File System)
• Formulated and implemented alert mechanism, Hadoop Queue Capacity indicator in Jumbune for Hadoop Administrator

Aug 2011 – Jun 2012 · 10 mos · Kawardha Area, India

• Prepared and executed monthly and annual Bauxite production plan, daily production report
• Devised efficient truck dispatch system and achieved record quarterly production