David K

Data Analyst with 8+ years of experience delivering reporting solutions, operational analytics and business intelligence across e-commerce, digital health and higher-education environments. Experienced translating business requirements into scalable reporting solutions that support executive decision-making, improve operational visibility and strengthen data quality across multiple business systems. Strong background in SQL, Python, PostgreSQL, Power BI and ETL processes, with extensive experience analysing operational data, validating business information and transforming complex datasets into trusted management reports and interactive dashboards.

Proven ability to collaborate with business stakeholders, engineering teams and senior management to define reporting requirements, develop KPI frameworks, investigate complex data issues and improve organisational decision-making. Recognised for bridging business and technical teams and delivering consistent, decision-ready information that supports organisational performance.

Data Operations & Business Intelligence Analyst - Regulusweb - Nairobi, Kenya

(2021-01 - 2025-08)

E-commerce platforms for Hotpoint Appliances Kenya, Text Book Centre, Nairobi Sports House

• Partnered directly with business owners, management teams and software engineers to understand reporting requirements and translate business needs into scalable analytics solutions.
• Designed and maintained executive Power BI dashboards providing visibility into sales performance, revenue, customer behaviour, inventory levels, conversion rates, order trends and operational KPIs.
• Developed operational dashboards monitoring response times, production incidents, API failures and service performance, enabling technical teams to identify recurring issues and improve platform reliability.
• Sourced and reconciled data from multiple systems — PostgreSQL application databases, structured application logs, Excel-based business inputs and monitoring platforms such as Sentry — to build a single, trusted reporting layer.
• Designed star-schema data models in PostgreSQL, structuring fact and dimension tables with defined keys and relationships to support consistent, reusable KPI calculations across Power BI dashboards.
• Built SQL-based reporting solutions against PostgreSQL databases to analyse business transactions, investigate operational incidents and validate data accuracy across enterprise applications.
• Developed automated Python ETL pipelines that extracted operational information from application logs, transformed timestamps into East Africa Time, standardised data formats and loaded validated datasets into PostgreSQL for reporting.
• Reduced manual reporting effort by approximately five hours each week through automation of operational log extraction and dashboard refresh processes.
• Designed regional data pipelines consolidating sales information from Kenya, Uganda and Rwanda, enabling Power BI dashboards to refresh automatically every six hours and provide near real-time commercial insights.
• Worked closely with business stakeholders to define KPI calculations, reporting structures and dashboard layouts that supported executive decision-making.
• Performed root cause analysis on production incidents using SQL, application logs and operational data, improving incident diagnosis and supporting faster issue resolution.
• Supported software releases through User Acceptance Testing, validating business functionality, reporting accuracy and data consistency before production deployment.
• Produced executive operational reports summarising platform performance, recurring incidents, business trends and service delivery metrics for senior management.

Technical Operations & Product Quality Analyst - ONA Data

(2018-01 - 2020-12)

International agricultural and digital health data exchange initiatives

• Collaborated with product managers, software engineers and international technical teams to translate business requirements into comprehensive testing and validation activities.
• Designed and executed functional, integration and User Acceptance Test cases supporting enterprise software releases.
• Performed extensive REST API testing across OpenAPI-compliant platforms supporting agricultural and healthcare data exchange.
• Sourced data from REST APIs and PostgreSQL databases across partner agricultural and health information systems, reconciling records across sources to validate consistency before analysis.
• Validated large operational datasets using SQL and PostgreSQL, ensuring consistency, completeness and accuracy before production deployments.
• Supported interoperability between enterprise platforms including DHIS2, OpenMRS, CommCare and other health information systems through API validation and integration testing.
• Investigated complex production issues through database analysis, API diagnostics and application testing, identifying root causes and recommending corrective actions.
• Documented business rules, validation procedures, technical findings and quality improvements to support knowledge sharing and continuous improvement.
• Analysed operational data and customer feedback to identify recurring product issues and recommend improvements that enhanced platform reliability and user experience.

IT Systems Specialist & Technical Trainer - Strathmore Business School

(2012-01 - 2017-12)

• Produced operational and management reports supporting budgeting, procurement, infrastructure planning and technology investment decisions.
• Managed institutional IT asset data, improving visibility into technology resources and supporting informed procurement planning.
• Collected and analysed operational data to identify service trends, recurring technical issues and opportunities for operational improvement.
• Developed reporting templates that improved consistency and quality of departmental reporting.
• Designed and delivered technical training programmes that increased adoption of enterprise applications and reduced recurring support requests.
• Investigated technical incidents, documented recurring problems and recommended process improvements that strengthened service delivery.
• Worked closely with departmental leadership to align technology services with operational requirements, supporting more than 400 staff and students.

Bachelor of Business Information Technology - Business Information Technology - Strathmore University