Aditya Sahu Email & Phone Number

London Area, United Kingdom

London, England, United Kingdom

London, United Kingdom

London, United Kingdom

Client: Virgin Media Location- LondonRoles /Tools | Onshore Analytics Manager || Hadoop: Hive ,R programming, Netezza, and SASManaging a team of 6 at offshore as their onshore partner.Briefing and debriefing on multiple statistical models and campaign analysis reports.Working across multiple teams including Acquisition, Customer base , churn model and TV contents Campaign Modeling and model validation.TV Content usage and channel segmentation.Creation of modelling database using multiple data source, JSON using Hive, Netezza and external data.

Bengaluru Area, India

ADVANCED ANALYTICS TEAM : NIELSENRoles /Tools | Custom Modeler/ Sr .Business Analyst || SAS , Excel, SQL-MS Duration | March 2013 – Present • Build Univariate/Multivariate forecasting models for Equivalent volumes and Dollars.• Building Multiple regression based forecasting models using SAS.• Preparing Propensity models for retailers for specific categories and Brands.• Working on developing various SAS code for automating model results, mostly adhoc request from clients.• Aligning the categories and division as per the hierarchy.• Brand forecasting using Regression and issue based study.• Building a relevant business story out of every model and selling it in a presentable form.• Understanding the business sense based the drivers and their relation with the category and the divisions and build business sense out of every forecast.• SUPERVALU INC. - Advanced Analytics TeamRoles /Tools | Custom Modeler/ Sr .Business Analyst || SAS EM 7.1 , SAS EG 4.3, SAS RPM , Excel, SQL- Teradata Duration | January 2012 – March 2013 Primary Task:Building regression Models on Direct campaign, Building category and department level propensity models, RPM based Models, Private Label Models and maintaining the ADS,• Building Adhoc models from the scratch, right from ADS Building till model validating and model presentation to client. • Presentation of Working models and finalized models and Validation for reoccurring models and checking the model consistency over a period of time.• Validating models based on SE, Sales/HH, SWAP analysis, GAIN chart.• Factorial Model Designs and implementation of combined model effect calculation.• Overall a Business consultant for all analytics strategy making and new initiatives.

Bangalore

HUL Analytic CellProject is mainly focussed on analytically improvise the HUL Customer development team and help them in taking key business decisions.Some of the sub-projects are listed below Redline: Predicting the products which are near out of stock at outletsWidth pack : Selling the best possible product for an outlet according to that area basketPromoting Least popular products: Increasing Width packs for the least popular productsDeveloped the T SQl codes for an optimised model, which is used monthly/adhoc depending on the requirement. Practical experience on Market Basket analysis and its modelling. Score Card Modelling experience using SQl/SAS and R to some extent. Creation of variable across multiple dimensions for Scorecard modelling. Transformation of Variables and running Market basket models (Association Models). Building optimised code for a better validation of the output. Solving adhoc analysis report request for the client. Made On Shelf Availability Analysis and generated the OSA reports. Redline analysis for each region across India. Developed many custom analytical reports using SQl and Excel for a better picture of the market status. Worked on product launch decision programs. Designed and developed the entire suggested order process for HUL. Worked on different strategies for pushing Seasonality Products across India.AIG HR Analytics In the absence of an ETL tool, I performed ETL operations using SQL to achieve BULK load and a Look-Up for an Analytical Data Mart. I had done UI creation in COGNOS 8.3 Report studio and extensive Java scripting to achieve UI Requirements. Creation of KPI dashboards on COGNOS much to the client's satisfaction without prior experience was a moment of learning and achievement for me. Created few adhoc reports using Query studio, . It was an exhaustive analytics project that provided me a blend of - clarity and knowledge of SQL with the right understanding of the domain.

Master Of Science - Ms, Data Analytics, Distinction

Bachelor Of Technology (B.Tech.), Electronic And Instrumentation

12Th

10Th

Good at communicating ideas and process implementations to team members