Bor Cornelius
Nairobi
Summary
With over 6 years of experience in Business Intelligence and data solutions, I specialize in designing and delivering end-to-end analytics systems on Azure and AWS. My work focuses on transforming raw data into structured, insight-driven reporting through well-designed data models and dashboards.
I have built and supported underlying data pipelines and cloud-based data infrastructures using Azure Data Factory (ADF), Synapse Analytics, Azure Data Lake Storage (ADLS), and Databricks, alongside AWS services such as S3, Glue, RDS, and Redshift—ensuring data is reliable, accessible, and analytics-ready.
I work closely with business stakeholders to translate requirements into practical data solutions, combining strong analytical thinking with technical execution to drive data-informed decision-making.
Overview
6
6
years of professional experience
Work History
BI Developer| Data Engineer
Mitchell Cotts Group
Nairobi
01.2024 - Current
- Built and orchestrated data pipelines using Azure Data Factory (ADF) to ingest data from multiple sources into Azure Data Lake Storage (ADLS).
- Developed transformation workflows using Synapse Spark and Databricks to process large datasets into optimized formats (Parquet).
- Implemented layered data architecture (Bronze, Silver, Gold) to support scalable analytics and data engineering best practices.
- Created external tables and optimized query performance to enhance data accessibility with Azure Synapse Serverless SQL pools.
- Developed structured, high-quality data models to enable downstream analytics and reporting.
- Designed and implemented an Azure-based data platform to centralize operational and financial data for the organization.
- Developed interactive dashboards for data visualization and reporting.
- Collaborated with stakeholders to gather business requirements and objectives.
- Trained team members on BI tools and best practices for data analysis.
- Supported cross-functional teams with ad-hoc reporting and analytical needs.
- Documented requirements through functional specifications and technical design documents.
BI Developer
M-Gas
Nairobi
04.2023 - 01.2024
- BI Development: Design, develop, and deploy BI analysis and dashboards using industry-leading Power BI and AWS Quicksight.
- Data Modelling: Work with data engineering teams to ensure that data sources are reliable, and that data is structured for analysis.
- Collaborated with Senior Manager Data Analytics and Insights to assess company-wide data needs and deliver targeted BI solutions.
- Communicated findings and insights to technical and non-technical stakeholders, facilitating data-driven decision-making.
- Documentation: Maintain and update documentation for BI processes, tools, and dashboards, ensuring that other team members can understand and follow the developed solutions.
- Conducted user training sessions to improve proficiency in BI tools and maximize user engagement.
- Security and Compliance: Ensure that BI solutions adhere to the company's data privacy and protection policies
Business Data Analyst
M-Gas
Nairobi
05.2021 - 04.2023
- Analyzed the impact of marketing initiatives on customer behavior, enabling better tracking and ROI assessment.
- Implemented fraud detection analytics, saving the company from potential losses.
- Automated field operations, enhancing accountability and providing data for operational analytics.
- Analyzed service delivery gaps, improving operational efficiency and customer satisfaction by reducing service outages due to battery issues.
- Diagnosed root causes of returned devices and developed SOPs, reducing return cases and enhancing product quality.
- Conducted device network failure diagnostics to ensure customer satisfaction and reduce downtime.
- Worked with the logistics team to enhance fleet performance and safety, including driver rating and feedback.
Business Systems Analyst
M-Gas
Nairobi
10.2020 - 04.2021
- Analyzed processes and recommended improvements, increasing customer engagement by optimizing time management.
- Managed bug resolution, delivering timely support to field and office personnel, improving overall service reliability.
- Developed escalation matrix for customer issues, prioritizing tasks to improve response times.
- Improved device reliability and diagnostics, enhancing the customer experience.
System Support Analyst
M-Gas
Nairobi
11.2019 - 10.2020
- Diagnosed and resolved system issues, enhancing operational efficiency across departments.
- Provided technical support for software applications and systems used by MGas.
- Collaborated with teams to implement new software tools and enhancements effectively.
- Conducted smart meter diagnostic analysis to pinpoint experienced faults.
- Guided operational teams in identifying service-required customers by analysing sales and smart meter data.
Education
Bachelor's degree - Electrical and Electronics Engineering
The Technical University of Kenya
Nairobi,KenyaSkills
- Multi-Cloud Engineering: Azure & AWS data platform design and implementation
- ETL/ELT Development: Scalable pipeline orchestration using Azure Data Factory
- Data Lake & Analytics Architecture: Synapse Analytics and modern data platform design
- Big Data Processing: PySpark for distributed data transformation
- Data Governance & Security: Implementation of data controls, validation, and access policies
- Business Intelligence: Power BI for semantic modeling and insight delivery
- Agile Delivery: Jira-based workflow management and iterative development
Accomplishments
KEY PROJECTS
Enterprise Cloud Data Platform (Azure)
a. Built an end-to-end data platform using ADF, ADLS, Synapse, and Spark to centralize operational and financial data.
b. Implemented Bronze → Silver → Gold architecture for structured, analytics-ready datasets.
c. Delivered curated data models supporting Power BI reporting.
AWS Analytics Pipeline
a. Designed data workflows using S3, Glue, and Athena for ingestion, transformation, and querying.
b. Built curated datasets for reporting in QuickSight.
c. Improved data accessibility and reduced manual data preparation through pipeline automation.
Operational Reporting & Analytics
a. Developed Power BI dashboards and semantic models to track key business metrics.
b. Automated reporting workflows, improving the efficiency and consistency of insights delivery.
Data Quality & Governance
a. Implemented validation checks within pipelines to ensure data accuracy and reliability.
b. Established data structuring standards to improve usability and maintainability.
Enterprise Cloud Data Platform (Azure)
a. Built an end-to-end data platform using ADF, ADLS, Synapse, and Spark to centralize operational and financial data.
b. Implemented Bronze → Silver → Gold architecture for structured, analytics-ready datasets.
c. Delivered curated data models supporting Power BI reporting.
AWS Analytics Pipeline
a. Designed data workflows using S3, Glue, and Athena for ingestion, transformation, and querying.
b. Built curated datasets for reporting in QuickSight.
c. Improved data accessibility and reduced manual data preparation through pipeline automation.
Operational Reporting & Analytics
a. Developed Power BI dashboards and semantic models to track key business metrics.
b. Automated reporting workflows, improving the efficiency and consistency of insights delivery.
Data Quality & Governance
a. Implemented validation checks within pipelines to ensure data accuracy and reliability.
b. Established data structuring standards to improve usability and maintainability.
Timeline
BI Developer| Data Engineer
Mitchell Cotts Group
01.2024 - Current
BI Developer
M-Gas
04.2023 - 01.2024
Business Data Analyst
M-Gas
05.2021 - 04.2023
Business Systems Analyst
M-Gas
10.2020 - 04.2021
System Support Analyst
M-Gas
11.2019 - 10.2020
Bachelor's degree - Electrical and Electronics Engineering
The Technical University of Kenya