Resume Ravi Malhotra Data Analyst

Resume Ravi Malhotra Data Analyst
DATA INSIGHTS ANALYST

Currently working at Dyson my work scope range from Business Intelligent (BI) to Artifical Intelligence (AI) and currently involved in industry 4.0 projects like 1. Manufacturing Systems [MES & MOM] data analytics — Project Lead 2. Operations and Supply Chain Systems [ERP & SCM] data analytics 3. Smart/Connected Products [IOT] data analytics 4. Customer Perception [Call center, web & social text data analytics]

Honors and Awards
2016 Google Online Marketing Challenge – AdWords Business Semi-Finalist
July 2016
Google Global Marketing
ISO 9001:2008 Internal Auditor
September 2014
Hindustan Pumps & Electrical Engineering Pvt Ltd
Lord of the bytes Event 4th prize
March 2008
Indian Institute of Technology, Roorkee, India
Globalization & Consumer Protection paper presentation
January 2010
Kalasalingam University
Experience
Data Insights Analyst
(May 2017 – Present)
Dyson Technology Centre, Singapore
  • Successfully implemented text analytics engine to categorise customer comments from call centre conversation, web and social media
  • Successfully implemented assembly line monitoring dashboard which helps in answering stakeholder’s questions like: What happened (Descriptive) and Why happened (Diagnostic)
  • Successfully derived products usage pattern from connected devices around the globe
  • Developing a predictive model to predict machine failure
  • Formulating data strategy and departmental balance score card for performance monitoring
Revenue Analytics Intern
(August 2016 – March 2017)
InterContinental Hotels Group, Singapore
  • Developed a model to understand the impact of Macro-Economic variables on rooms revenue using Time Series & Regression Techniques (R, Tableau, Excel)
  • Developed interactive dashboards in Tableau for competitor analysis & performance KPI’s
  • Deployed ETL scripts for data preparation
CRM Administrator
(January – December 2015)
Hindustan Pumps & Electrical Engineering Pvt Ltd., India
  • Derived insights from CMR data & participated in identifying marketing mix
  • Published Trend Analysis, Field Failure Analysis, SWOT & Pareto Analysis reports
  • Visualized geographical sales trend using Click2Maps API
  • Published Sales performance & KPI Dashboards
  • Published Dashboards to SharePoint & used excel for advanced data modelling
  • Liaised with external consultant & marketing team for market research projects
ERP Administrator
(May 2012 – Dec 2014)
Hindustan Pumps & Electrical Engineering Pvt Ltd., India
  • Successfully implemented Purchase, Quality control, Inventory & Production planning modules
  • Requirement elicitation from business & end users for new ERP (EasyERP v2) implementation
  • Documented work flow for new ERP system
  • Deployed and managed old ERP system using VMWare hypervisor
  • Liaison with ERP vendor
  • Report generation & validation
System Administrator
(July 2011 – April 2012)
Hindustan Pumps & Electrical Engineering Pvt Ltd., India
  • Successfully implemented Green IT solution & reduced operational cost by 40%
  • Managed IT infrastructure and provided IT Training
  • Configured and managed servers over VMware hypervisor
  • Analysed and encouraged IT Transformation and implemented IT Policy
Freelance
(June 2010 – September 2012)
Satya Info Tech
  • From Customer requirement elicitation to designing and development of websites over different platforms. Completed 12 website projects

Sample Projects:

  1. http://www.qmssigma.com
  2. http://drarungandhi.com
  3. http://hppsmadhuban.ravimalhotra.com
Certifications
Microsoft Office Specialist – Word 2013
Microsoft Office Specialist – Excel 2013
Microsoft Action Pack Design & Developer
(January 2012 – January 2013)
CompTIA Project Management
CompTIA A+ ce
(February 2015 – February 2018)
Education
MTech – Enterprise Business Analytics
(2016 – Present)
National University of Singapore (Singapore)
BTech – Computer Science
(2007 – 2011)
Maharishi Markandeshwar University (India)
Skills
Data Analysis and Statistics
Related Projects: • STR & Reviewer Pro Data Analysis – Excel PH Stats & H-CAT, Tableau, SPSS Statistics, R, SQLPerformed data analysis to compare top 5 hotels in Singapore on various factors using Clustering, Factor Analysis & Non-Parametric test.
Predictive Analytics and Machine Learning
Related Projects:• Campaign Targeting & Response Modeling for ROI Enhancement – R, Modeler, Excel, Tableau, SQLBuilt and evaluated a Response Model for new customer acquisition, customer up-selling and maximizing ROI. Used Decision Tree, logistics regression & Neural Network.• Biker’s Demand Prediction (Kaggle) – R, Excel, SPSSApplied machine learning techniques to build a forecasting model for generating the bike demand for the next day. Generated a profit increment of 27% from that of Naive Model.
Text Analytics
Related Projects:• Construction Workers Accident Data Analysis (Text Mining) –- Python (NLTK)Performed data scraping, categorization & various NLP techniques to address various business questions and created a text classification ensemble model to classify accident incidents.
Digital Marketing
Related projects:• Google Online Marketing Challenge (GOMC-2016 Semi Finalist) – Google Keyword Planner, Google Analytics, SEO, GTMSuccessfully designed an online digital campaign for a client by increasing its online reach by 37% & increased conversion rate by 78%.