Associate Consultant
Melbourne, Victoria, Australia
Requirement gathering, data modelling, problem solving, data analysis, visualization & reporting:- Value Chain Analysis - conducted value chain analysis across departments to identify the potential opportunity in sales related activities.- National Sales Insights - conducted Excel analysis on dealer order data to identify dealer fraud behavior.- Demand Allocation - Modelled and solved the demand planning problem using Microsoft Excel Solver, resulting in a 95% increase in work… Show more Requirement gathering, data modelling, problem solving, data analysis, visualization & reporting:- Value Chain Analysis - conducted value chain analysis across departments to identify the potential opportunity in sales related activities.- National Sales Insights - conducted Excel analysis on dealer order data to identify dealer fraud behavior.- Demand Allocation - Modelled and solved the demand planning problem using Microsoft Excel Solver, resulting in a 95% increase in work efficiency.- Order Bank Prediction - conducted monthly order number prediction from the website traffic data using machine learning techniques and external geographic features using Python and Databricks. Show less