Michael Mwangi Email & Phone Number

Nairobi County, Kenya

Nairobi County, Kenya

 Collaborated with Analytics Engineers to build data pipelines in DBT for a robust fraud detection model, ensuring clean data structures and KPI extraction. Made informed technology choices, integrating DBT, SharePoint, and Looker to enhance analytical capabilities. Developed and implemented data models, data mining and statistical analysis algorithms to support business decision-making. Utilized Looker, a prominent business intelligence platform, to create dynamic Delta Dashboards showcasing comparative insights on the performance of two cash forecasting models through robust data visualization techniques. Utilized SQL, Python, R, and other programming languages to extract, clean and manipulate large data sets Built and maintained data pipelines and data integrations with various systems and tools Created and maintained detailed documentation of data flows, processes and definitions Conducted statistical analysis, forecasting and modeling to support business decisions Created and maintained reporting and dashboards to visualize data insights Collaborated with cross-functional teams to understand data needs and deliver data solutions Managed master data, including creation, updates, deletion, commissioning, and decommissioning of data sets in SQL Server. Provided technical expertise in data storage structures, mining, and cleansing. Interpreted analysis to communicate effectively to a broad audience with different business interests and skill sets.

Nairobi, Kenya

 Lead analytics for the sales function of the business. Querying data from various internal and external databases using SQL, testing and Quality Analysis of SQL codes to ensure high-quality analysis. Building models, analysis, and transformations on internal data using Excel, SQL and R. Designing user-friendly, clear, and impactful presentations of analytic findings. Working together with the business to enable data-driven decision making on the most important business questions.

Chania Avenue

 Data analysis. Analyse multiple warranty data using Excel, SQL and Power BI to determine materials to be purchased for repairs and warranty support. Created a material planning model on excel to track material consumption. This led to an increase in repair material availability from 70% to above 90% for the first 2 quarters of 2020. Budget management and variance reporting. Created Power BI dashboards that track actual warranty spend vs the budget and reporting on the cause of any variances.

Chania Avenue

 Asset tagging, allocation, demand forecasting and maintenance on the fixed asset register; Fixed asset physical count and updating findings on the fixed asset register; Providing detailed reports from SAGE to enable smooth data upload to Microsoft Dynamics AX; Microsoft Dynamics AX training, support and troubleshooting to assist immigration from SAGE; Managing day to day supplier interactions, including facilitating meetings with internal customers and ensuring all supplier requests and queries are addressed quickly and accurately; Performance of due diligence on new suppliers and updating any new suppliers on the supplier muster roll and creating new suppliers on Microsoft Dynamics AX; Training of new employees from the different procurement offices in Kenya, Uganda and Tanzania on the procurement procedures; Managing asset returns and warranty claims. Issuing of purchase orders using SAGE and Microsoft Dynamics AX.

Chania Avenue

 Formulation and maintenance of a supplier muster roll; Conducting of a supplier due diligence on new and existing suppliers; Verification of documents received such as tax compliance and PIN certificates using KRA itax; Ensuring supplier compliance through visits; Negotiating for better prices and credit terms; Spotted errors and suggested ways to improve efficiency and spending; Agreeing on supplier delivery time frames and methods; Receipt and confirmations of items received; Attending of monthly and end-year stock takes at the company warehouse on behalf of finance and procurement department; Asset tagging and updating on the fixed asset register; Assisted in formulating a channel between M-Kopa customers and third party service centres for all items sold by M-kopa to them such as phones; Issuing of purchase orders using SAGE.

Master Of Science, Data Science And Analytics

This program has been designed for students who have completed a degree in either Statistics, IT, Commerce, Economics, or Finance.

Data Science, Data Science

Supervised Learning, Pandas, NumPy, Python, SQL, Tableau, Supervised Learning, Advanced Regression, Decision Trees, Neural Networks, R.

Bachelor Of Commerce, Accounting And Finance

Activities and Societies: Rotaract Club Badminton team AIESECFinancial Analysis, Economics, Statistics, Accounting, Business Mathematics.

Cpa Section 6, Accounting

Financial Analysis, Financial Reporting, Taxation, Economics.

O Levels