John M.

John Mwendwa Musembi is a Data & BI Analyst with 3 years of experience in financial analysis, operational reporting, business intelligence, and data analytics. He leveraged Python, SQL, Excel, Power BI, and data visualization to clean, structure, analyze, and present data for business and operational decision-making. As a Finance Analyst at FMC in Kenya, John focused on financial analysis, budgeting, forecasting, reconciliation, and reporting. He improved monthly budget forecast accuracy by 8% through variance analysis, reconciled over 200 financial records monthly, and streamlined reporting processes, reducing preparation time by 20%. His work translated financial data into actionable variance insights to support strategic budget decisions. Previously, as a Data Analyst Intern, John worked with program teams to define KPIs and improve data-driven targeting. He cleaned and validated over 10,000 rows of data, improving reporting and dashboard accuracy by 25%, and developed interactive Power BI dashboards for real-time KPI tracking. He streamlined reporting workflows, saving approximately 15 hours per month. John also completed a remote Data Analyst Associate Internship with a previous company in Dubai, where he produced dashboards and Excel reports, standardized datasets, and collaborated with a five-person remote team. His work contributed to improved operational efficiency and reduced reporting errors. Technically, John's toolkit included Python, Pandas, NumPy, scikit-learn, SQL, BigQuery, Excel, Power Query, and VBA. He worked with Power BI, Tableau, Looker, automated reporting, ETL, AWS, dbt, Git/GitHub, and data visualization libraries including Matplotlib, Plotly, and Seaborn. His analytical capabilities encompassed KPI modeling, forecasting, regression, classification, and clustering, supported by knowledge of ERP integration and data governance. He also possessed emerging technology skills in Artificial Intelligence and prompt engineering.

• •3 years of experience in data analytics, business intelligence, financial analysis, and operational reporting.
• •Improved monthly budget forecast accuracy by 8% through financial variance analysis.
• •Reconciled 200+ financial records monthly as a Finance Analyst.
• •Reduced financial reporting preparation time by 20% through process improvements.
• •Delivered variance analysis and insights supporting strategic budget decisions.
• •Defined KPIs with program teams, contributing to a 25% improvement in targeting efficiency.
• •Cleaned and validated 10,000+ rows of data, contributing to a 25% improvement in reporting and dashboard accuracy.
• •Built interactive Power BI dashboards for real-time KPI tracking.
• •Streamlined reporting workflows, saving approximately 15 hours per month.
• •Standardized data and reduced reporting errors by 30%.
• •Collaborated remotely with a five-person international team, completing projects ahead of deadlines.