Open To Work
James Wambua
Nairobi
Work Preference
Summary
Management Information Systems professional specializing in data analytics and ERP systems. Focused on automating workflows and designing dashboards that streamline financial reporting and improve decision-making. Committed to leveraging technology for enhanced operational efficiency and transparency.
Overview
1
1
Certification
10
10
years of professional experience
Work History
Data Analytics Consultant (Freelance)
Freelancer.com
01.2017 - Current
- Delivered tailored analytics solutions for SMEs and startups, driving data-informed decision-making across diverse industries.
- Applied Python, SQL, Power BI, and R to uncover insights and optimize workflows.
- Built automated dashboards aligning revenue, expenses, and cash flow, enabling granular departmental and branch-level reporting.
- Consulted on ERP optimization projects, streamlining reconciliation automation and enhancing variance monitoring for improved financial visibility.
- Developed case studies demonstrating ROI, strengthening client trust and repeat business.
Business Analyst Assistant
Tenkari Systems
Nairobi
01.2021 - 01.2026
- Designed and deployed Power BI dashboards reducing decision-making time by 40%.
- Implemented workflow automation using Excel, SQL, and Python, saving 20+ hours monthly.
- Conducted requirements analyses and translated business needs into ERP and IT solutions.
- Supported ERP integration projects (Navision Dynamics exposure), mapping transactions from source entry to accounts, enhancing financial accuracy.
- Partnered with finance teams to ensure compliance with IFRS standards and accurate reporting.
- Generated exception reports to strengthen internal controls and assisted MIS leadership in documentation and reporting, improving oversight.
- Developed and maintained front-end websites and contributed to back-end integration for internal systems.
Operations Assistant
Ditco Engineering and Construction Ltd
Nairobi
01.2019 - 01.2020
- Assisted in implementing process improvements that reduced operational bottlenecks by 25%.
- Supported management in resource planning and scheduling to streamline efficiency.
- Coordinated daily operations to enhance workflow across departments.
- Collaborated with finance and sales teams to align operations with business objectives.
- Maintained documentation and reporting for compliance and audit readiness.
Education
Diplomas - Business Administration & Project Management
Alison
Online01-2026
Bachelor of Business - Business Information Technology
Mount Kenya University
Nairobi01-2016
Skills
- Requirements gathering
- Data Analytics: Power BI, Excel (Advanced), SQL, Python, R, Tableau
- Financial reporting
- Navision Dynamics, SAP
- Project management
- Business operations
- Development: HTML, CSS, JavaScript, React, PHP, Nodejs, MySQL
- Soft skills
Certification
- CCNA (Cisco Certified Network Associate) – Expired, renewal in progress
- Google Data Analytics Professional Certificate – In progress
- Microsoft Certified: Power BI Data Analyst Associate – In progress
Languages
English – Professional, Swahili – Professional
Accomplishments
- ERP Integration: Supported mapping of transactions from HMIS to ERP, ensuring revenue completeness and inventory accuracy.
- Automated SME Dashboard: Reduced decision-making time by 40% using Power BI, Excel, and Python.
- Workflow Automation: Saved 20+ hours monthly across departments by automating reporting processes.
- Financial Controls: Enabled automated exception reporting to strengthen internal controls.
- Operations Efficiency: Cut operational bottlenecks by 25% through process redesign and resource planning.
Timeline
Business Analyst Assistant
Tenkari Systems
01.2021 - 01.2026
Operations Assistant
Ditco Engineering and Construction Ltd
01.2019 - 01.2020
Data Analytics Consultant (Freelance)
Freelancer.com
01.2017 - Current
Diplomas - Business Administration & Project Management
Alison
Bachelor of Business - Business Information Technology
Mount Kenya University