John Oloo
Data and Commercial Specialist at Monument Distillers East Africa Limited- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Data Visualization for Data Analysis and Analytics
LinkedIn -
Advanced Microsoft Power BI
LinkedIn -
Supply Chain Analytics Foundations
LinkedIn -
Analyzing and Visualizing Data with Microsoft Power BI
Macquarie University -
Analyzing and Visualizing Data with Microsoft Excel
University of Colorado -
Certified Monitoring and Evaluation Professional
Kenya Institute of Management
Experience
-
Monument Distillers East Africa Limited
-
Kenya
-
Beverage Manufacturing
-
1 - 100 Employee
-
Data and Commercial Specialist
-
jul 2021 - –nu
Kensington Distillers & Vintners, London, is an alcoholic beverage manufacturing and distribution company that produces wines and spirits. It extended its African footprint by entering the East African market as Monument Distillers East Africa Limited, operating a highly efficient supply chain that connects consumers with high quality premium drinks and new emerging brands.The company is at the centre of distributing a range of global brands from leading American spirits company, Sazerac, including Popov Vodka, Southern Comfort, and Paddy’s Irish Whisky. The portfolio also includes international brands Martini, Bacardi, Four Cousins, Montego Rum, Squadron Rum, Bannerman’s Scotch Whisky, and Grace du Roi Fine wine among others.What I do:• Aggregating and analyzing master data sourced from CRM systems, to inform management business reviews• Preparing daily sales reports by combining data from different databases to convey insights on actual sales vs set targets• Analyzing customer mapping data and recommending related insights to the marketing and commercial excellence team• Receiving and collating daily purchase plans to plan for product availability and full supply of orders to clients• Performing a weekly inventory valuation to analyze the quantity and cost of stock in the warehouse and the expected gross profit or loss• Developing accurate dashboards that track key channels of distribution, brand activations and depletions for the identification of appropriate sales mechanisms • Conducting a monthly sensitivity analysis that measures the marketing cost and overall GP to determine ROI and marketing efficiency• Modelling the integrated value chain budget for all SKUs to project the market basket and stock movement• Forecasting monthly sales and establishing revenue targets to estimate how much stock is required in the warehouse• Updating a weekly KPI tracker to provide feedback on process improvement metric required by departmental heads
-
-
-
Hela Clothing
-
Retail Apparel and Fashion
-
1 - 100 Employee
-
Business Analyst
-
jul 2019 - jul 2021
Hela Clothing is an apparel manufacturing company that is engaged in the supply of clothing and accessories to many of the world’s top retailers with a product portfolio that includes Intimate wear, Sportswear, and Kids wear. This includes brands such as Tommy Hilfiger, Calvin Klein, and Michael Kors. The company is heavily involved in design and product development accredited with the highest customer standards, offering innovative apparel solutions for today’s fast changing fashion requirements.What I did:• Conducted periodical analysis of progress data, to ensure that all process improvement initiatives are being tracked and reported on a regular basis • Visualized and monitored production trends of each line section to report on the volume performance of different SKUs based on the revised delivery plan• Processed data requests from the D2D database and ensured quality and integrity of data domains• Monitored down time and planned end date reviews that provided insights to understand the urgent business needs and objectives• Participated in the preparation and analysis of business plans and the annual operating plan (AOP) by driving clear support data to stakeholders through ROI predictions and market share analysis• Tracked payable and receivable accounts to assist in profit and loss reporting and documentation• Developed dashboards and reports that guided business units to track and report on historical and current volume and revenue generated• Coordinated Hub operations in Tanzania and presented ad hoc reports that addressed the required business needs• Proactively consulted with production managers and planning team to ensure data accuracy of monthly targets• Provided insights on key purchase orders, in-stocks, and sales for various SKUs that would impact the overall profitability of the business units• Cleaned large data sets by reviewing reports and performance indicators to locate and correct inconsistencies
-
-
-
ICAP at Columbia University
-
United States
-
Non-profit Organizations
-
700 & Above Employee
-
Data Clerk
-
feb 2018 - jun 2019
• Timely and accurate entry of client’s data into the database• Routine data collection, cleaning, and verification• Conducted qualitative and quantitative research to measure and evaluate impact at the end of various projects• Performed desk research and literature reviews• Quarterly data quality assessments (DQAs) to ensure validity and precision of data• Prepared periodic performance reports regularly • Timely and accurate entry of client’s data into the database• Routine data collection, cleaning, and verification• Conducted qualitative and quantitative research to measure and evaluate impact at the end of various projects• Performed desk research and literature reviews• Quarterly data quality assessments (DQAs) to ensure validity and precision of data• Prepared periodic performance reports regularly
-
-
Education
-
2020 - 2022
Strathmore University
Master of Science - MS, Statistical Science -
2013 - 2017
Maseno University
Bachelor of Science - BS, Mathematical Science, with IT -
2009 - 2012
Nairobi School
Kenya Certificate of Secondary Education
Community
