Summary

Flexible and versatile Business Analyst specializing in developing innovative solutions to organizational problems. Advanced knowledge of R, SQL, Excel VBA software.

Highlights

Advanced Excel modeling Business requirements matrix Statistical Analysis such as Regression

Analysis (Linear, Non linear ,Logistic),Hypothesis Testing ,ANOVA ,Optimization, Correlation, Estimation, Forecasting.

Advanced Predictive Methods, Machine Learning, Data Mining, Objective

Segmentation, Association Rule Mining, Market Basket Analysis.

Time Series Forecasting - Exponential Smoothing, ARIMA Modeling.

Advanced Analytics - Principal Component Analysis, Artificial Neural Network, Support Vector Machine, Random forest, Decision Tree

Campaign Management Analytics, Basel Modeling, Queuing Theory, HR Analytics

Experience

Senior Analyst (December 2014 to till date)

M/s BEACON ADVISORY | ANALYTICS – Gurgaon, HaryanaProjects Undertaken

Continuous Inventory Replenishment System(CRS) ProjectThe goal of the project was to reduce built up inventories at various stages of supply chain (distribution side) for big Indian FMCG Company

Analyzed data and Masters shared for sanity, integrity and completeness. Perform analytics to understand variation and deviation in data so as to completely understand

Business model of our Client. Using tools like Advanced excel, R extracted and integrated data for further level analysis as well

as by using Excel VBA reduced man hours and chances of human error. Using Advanced Excel analyzed the data and shared the findings of analysis to internal

management for further actions.

Sales Force AnalyticsThe goal of the project is to analyze data for a UK based Fortune 100 Company to find meaningful insights and suggest improvement for their sales force effectiveness.

Performed Sanity, integrity and completeness checks on the data and masters shared. Extraction and integration of data to make it ready to perform further level analysis. Using tools like SQL, Advanced Excel and Macros to evaluate performance according to Product

Category, SKU and Outlets for each Distributor. Present outcomes and findings of analytics to internal management for further actions.

Route and Transport Optimization

The goal of the project was to Optimize Transportation and Route for a UK based FMCG Major thereby reducing their overall transportation costs.

Developed clusters for route optimization using tools like Advanced R. Identified transporters and used negotiating skills to arrive at optimum freight charges. Developed highly sophisticated model for optimum utilization of our Goods carrier using Excel

VBA

Process Engineer/Analyst (April 2011 to April 2013)

M/s SIAC SKH INDIA CABS MANUFACTURING PVT. LTD. – Palwal, Haryana

Projects Undertaken

Identified "bottlenecks" and implemented new and improved processes and policies. Tracked, analyzed and interpreted trends in Pre dispatch Inspection data. Developed metrics used to determine inefficiencies and areas for improvement.

AKSHAY RAOH.NO. 1812 SECTOR 8, FARIDABAD HARYANA 121006 Cell: 9999766691, Email ID: akshay_rao87@yahoo.co.in

Documented process flows and developed requirements for functional improvements and enhancements. Conducted activity-based analysis of business processes and made recommendations based on the

findings. Boosted company efficiency and customer satisfaction by streamlining processes deemed inefficient. Identified process boundaries and determined opportunities to automate processes and functions.

Independent Projects

Higgs-Boson Machine Learning Challenge (2 Months)The goal of the Higgs Boson Machine Learning Challenge is to explore the potential of advanced machine learning methods to improve the discovery significance of the experiment. Using simulated data with features characterizing events detected by ATLAS*, your task is to classify events into "tau tau decay of a Higgs boson" versus "background."

Used highly sophisticated tools like python and R to do the analysis.

IRDA Data Analysis to detect doubtful Motor Insurance claims (1 Month)To analyze & identify "doubtful claims" and "clean claims” through cluster analysis from the dataset containing motor insurance claims in India from different insurance providers collected by Insurance Regulatory and Development authority of India (IRDA), an agency of Government of India for Insurance sector supervision and development .The data is masked and shared as a public data.

Used Advance tools like R to identify doubtful claims and clean claims.

EducationPOST GRADUATE DIPLOMA IN BUSINESS ANALYTICS ,2014

NIIT – INDIA

BACHELOR OF ENGINEERING ,2009

MAHARSHI DAYANAND UNIVERSITY – FARIDABAD, HARYANA, INDIA