Microsoft Power BI
SOLOMON ASOGBA
Data Expert: Automation, Analysis & Reporting
Lagos,LA
Believe, there is no limit
Solomon Asogba
Summary
Senior Data Analyst and System Developer with over 6 years of experience transforming complex data into strategic business assets. My expertise lies in bridging the gap between technical data architecture and business goals.
I don't just analyze data; I build the ecosystems that generate it. I specialize in architecting end-to-end data solutions using Microsoft Fabric and Power BI, while simultaneously deploying low-code business applications using Microsoft Power Apps and automating workflows with Excel VBA and Google Apps Script.
Core Competencies:
- Data Engineering: Microsoft Fabric (Lakehouse/Warehouse), SQL Server, ETL Pipelines.
- Visualization: Power BI, Tableau, Looker Studio.
- Development: Power Apps, VBA, Google Apps Script, Python.
- Prototyping & Collaboration: Figma, Miro, Jira, Agile/Scrum.
Currently helping organizations reduce reporting turnaround times and optimize revenue through rigorous data governance and advanced modeling. Open to connecting with leaders in the tech and energy sectors.
Overview
6
6
years of professional experience
5
5
Certificates
3
3
years of post-secondary education
Work History
Senior Data Analyst
Quantum Z Technologies
11.2024 - Current
- Lead the design and deployment of enterprise data models and interactive dashboards, currently reducing reporting turnaround time by 60%.
- Develop robust ETL pipelines using Power Query to ensure data integrity across disparate data sources.
- Analyse complex datasets to identify revenue trends, directly supporting executive decision-making for a multi-million CAD portfolio.
- Implement data governance frameworks to identify anomalies, ensuring 100% compliance with internal data quality standards.
System Analyst Developer
Asiko Energy Holdings Limited
11.2021 - 10.2024
- Directed cross-functional teams of analysts and developers to deliver data-driven enterprise solutions, resulting in a measurable 50% increase in user productivity.
- Built and deployed custom business applications using Microsoft Power Apps, streamlining internal processes and replacing legacy manual tracking systems.
- Automated complex cross-platform workflows using Google Apps Script and VBA, reducing manual processing effort by 60% and minimizing human error.
- Managed cloud infrastructure deployment and monitoring, successfully maintaining 99.9% system uptime for mission-critical operations.
- Led the full product lifecycle (SDLC) from requirements gathering to post-launch support, implementing rigorous quality control processes.
Data Analyst
Pobek Advisory Limited
07.2019 - 10.2021
- Analysed large, complex datasets to identify patterns and trends, delivering monthly reports that supported client business strategies.
- Performed extensive data cleansing and transformation using Excel, VBA and Power Query, establishing a reliable foundation for downstream analysis.
- Created predictive models to forecast market trends, enabling clients to anticipate changes in demand with 85% accuracy.
Senior Data Analyst
Hydrocarbon Information Services Limited
01.2024 - 12.2024
- Retained as a subject matter expert to oversee critical data projects concurrent with other employment.
- Directed resource allocation and project timelines for major initiatives, ensuring delivery under budget and on schedule.
- Designed advanced dashboard visualization tools that enabled stakeholders to monitor KPIs in real-time, improving strategic agility.
- Audited enterprise-wide data management metrics and implemented a remediation plan that improved data quality scores by 60%.
- Partnered with IT infrastructure teams to optimize database performance, ensuring scalability for growing data volumes.
Business Intelligence (BI) Analyst
Hydrocarbon Information Services Limited
01.2020 - 12.2023
- Conducted deep-dive market analysis on pricing strategies within the Nigerian LPG industry, providing insights that influenced executive pricing decisions.
- Served as the technical lead for a major system migration project, ensuring the seamless transfer of data, while maintaining 100% data integrity.
- Developed and maintained dynamic BI dashboards using Power BI, translating complex market data into actionable visual reports for non-technical stakeholders.
Education
Bachelor of Science - HUMAN KINETICS
10.2014 - 12.2017
Skills
System Architecture
undefinedCertification
Microsoft Certified: Power BI Data Analyst Associate
Software
Mircrosoft Fabric
Advanced Mircosoft Excel
Visual Basic for Applications (VBA)
Mircosoft Power Apps
Microsoft SQL Server
Work Preference
Work Type
Full TimePart TimeContract WorkLocation Preference
RemoteHybridImportant To Me
Career advancementLanguages
English
Bilingual or Proficient (C2)
French
Elementary (A2)
Interests
Technology
Music
Sports
Politics
Timeline
Microsoft Applied Skills: Implement a lakehouse in Microsoft Fabric
01-2025
Microsoft Applied Skills: Implement a data warehouse in Microsoft Fabric
01-2025
Senior Data Analyst - Quantum Z Technologies
11.2024 - Current
Fundamentals of Agile Project Management, Project Management Institute
06-2024
Senior Data Analyst - Hydrocarbon Information Services Limited
01.2024 - 12.2024
Microsoft Certified: Power BI Data Analyst Associate
01-2023
Data Analysis and Visualization with Microsoft Power BI, Udacity
07-2022
System Analyst Developer - Asiko Energy Holdings Limited
11.2021 - 10.2024
Business Intelligence (BI) Analyst - Hydrocarbon Information Services Limited
01.2020 - 12.2023
Data Analyst - Pobek Advisory Limited
07.2019 - 10.2021
University of Lagos - Bachelor of Science, HUMAN KINETICS
10.2014 - 12.2017