Yvonne K.

Key Skills

Software

Other

Top Subject Matter

Excel data cleaning

Power Query transformations

and introductory financial modeling

Top Data Types

Text

Computer Code Programming

Top Task Types

Data Collection

Freelancer Overview

Excel & Data Analysis Instructor (Part-time) — TechSkills Africa. Brings 7+ years of professional experience across complex professional workflows, research, and quality-focused execution. Core strengths include Other. Education includes Bachelor of Science, University of Nairobi (2020). AI-training focus includes data types such as Text and labeling workflows including Data Collection.

Labeling Experience

Data Analyst & Excel Modeling Specialist (Freelance/Consulting)

OtherTextData Collection

Prepared and cleaned large ERP-export datasets using Power Query pipelines, reducing manual data preparation effort by over 70%. Built automated reporting workflows and scheduled outputs by generating Excel reports from structured inputs, enabling decision-ready dashboards for client KPIs. Translated messy business data into organized spreadsheet structures suitable for investor and operational reporting. • Designed Power Query pipelines for ingestion and cleaning of large datasets from ERP exports. • Developed VBA macros and Excel add-in tools automating recurring reporting workflows for multiple clients. • Automated Excel report generation using Python libraries (openpyxl, xlwings) for scheduled or API-driven outputs. • Created interactive executive dashboards with drill-down capability for operational and financial KPIs.

2022 - Present

Excel & Data Analysis Instructor (Part-time) — TechSkills Africa

OtherTextData Collection

Designed and delivered training on Excel, Power Query, and introductory financial modeling using reusable datasets and templates for cohorts of 20–40 learners. The instruction emphasized transforming raw business inputs into clean, structured formats suitable for analysis and reporting. Learners practiced repeatable workflows that functioned as supervised preparation of analysis-ready data and modeling outputs. • Developed course exercises and model templates using consistent, reusable datasets. • Taught Power Query-based ingestion, transformation, and data cleaning concepts. • Supported intermediate to advanced Excel modeling logic and automation practices. • Achieved consistent learner satisfaction ratings of 4.8/5.0 across cohorts.

2021 - 2023

Financial Data Analyst — ABC Capital Partners

OtherTextData Collection

Consolidated and standardized data ingestion workflows across multiple source systems to support FP&A reporting models and investment analysis. Built structured scenarios and sensitivities by translating business and portfolio inputs into consistent decision-ready spreadsheet outputs. Documented assumptions and spreadsheet logic to support auditability and reliable downstream use. • Used Power Query to consolidate data from 8 source systems into a single reporting model. • Maintained monthly close, variance analysis, and annual budgeting spreadsheet processes. • Built sensitivity and scenario models for portfolio performance under varying assumptions. • Documented all logic, assumptions, and methodology for seamless handoffs and audits.

2020 - 2022

Education

Work History