Summary
Work History
Education
Skills
Certification
Accomplishments
Passions
Notable Awards
Industry Expertise
Tableau
Programming Languages Tools
Training
Timeline
Generic

CONSTANTINE INGUMBA

Analytics Engineering And Data Analytics Product Manager
Nairobi

Summary

Experienced and results-oriented senior analytics engineer with a proven track record in driving strategic data initiatives and optimizing business performance. Known for spearheading analytic efforts, employing advanced tools to identify patterns and enhance repayment performance. I established data infrastructure, saving costs, improving reporting turnaround times, data visualization developer and adept at transforming data into actionable insights. I played a pivotal role in building data and reporting systems, achieving over 95% up-time. I am adept in SQL, Python, and various BI tools, certified in Oracle Business Intelligence Foundation Suite and SQL. Proven ability in data modeling, problem-solving, and effective communication with non-technical stakeholders. I am passionate about data-driven decision-making, continuously learning new technologies, dedicated to automating processes for increased efficiency, and committed to excellence in the dynamic field of business intelligence.

Work History

Senior Analytics Engineer

D.light
09.2023 - Current
  • Setting the strategic direction for the company's data infrastructure, ensuring it aligns with business objectives and growth plans
  • Oversee the management and optimization of the data warehouse, particularly using Amazon Redshift, to enhance performance and reliability
  • Guiding and mentoring the data analytics engineer and other team members, fostering a collaborative and growth-oriented team culture
  • Design, develop, and maintain robust data pipelines using tools like Airbyte, Redshift, dbt, and Dagster, ensuring efficient and accurate data flow from various source systems
  • Implement data transformations and establish processes to ensure high data quality and integrity throughout the data lifecycle
  • Collaborate effectively with cross-functional teams to understand and meet diverse data requirements across the organization
  • Contribute actively to the continuous improvement and scaling of the company's data infrastructure, staying abreast of industry best practices and emerging technologies
  • Ensure data security, compliance, and governance across the entire data stack, safeguarding sensitive information and adhering to relevant regulations
  • Promote a culture of documentation, emphasizing the importance of documenting work to maintain clear and efficient systems, and actively participate in the creation and maintenance of documentation

Group Senior Business Intelligence Analyst

D.light
08.2022 - 08.2023
  • Utilized analytics tools to identify, analyze, and interpret patterns and trends in complex data sets as a crucial aspect of past operations
  • Worked closely with stakeholders throughout the organization to pinpoint opportunities for leveraging company data to enhance repayment performance
  • Engaged with stakeholders to identify valuable insights from data and presented them in reports and visualizations for the Exco and other relevant decision-makers

Group Business Intelligence Officer

Apollo Group
10.2019 - 08.2022
  • Established the data and reporting infrastructure from the ground up using Oracle BI, ODI, and SQL, providing near real-time insights into products, branches, and business KPIs
  • Utilized OBIEE, Tableau, and SQL to redefine and track the business team's production KPIs, offering recommendations to improve the product mix for enhanced profitability
  • Led a team of 2 analysts and the underwriting team in brainstorming and improving group data quality by 25%
  • Redesigned and modeled the group data warehouse, resulting in an 80% improvement in reporting turnaround times – TATs)
  • Implemented and automated loss ratio reports, encouraging performance-based rating and improving premium collections, thereby enhancing group profitability by about 10%
  • Established a centralised reporting platform for all group companies on OBIEE, reducing group licensing costs by 50%
  • Automated ETL processes using ODI across billions of rows of data, saving approximately 40 hours per month

Data Visualization Developer

Co-operative Bank of Kenya
07.2018 - 10.2019
  • Developed and maintained data transformations for reports and dashboards
  • Collaborated with data engineers and BI developers to build a customer 360 dashboard and branch vision dashboard that facilitated a single view of all customer and branch data
  • I served as the liaison between the business units, technology teams, and support teams on data visualization and demonstrated operational agility in delivering BI solutions
  • Supported and ensured the availability and performance of developed reports and dashboards for both external and internal users
  • Built role based KPI dashboards on OBIEE that enabled 100% data driven business user appraisals

BI Lead and System Administrator

Turnkey Africa LTD
10.2015 - 07.2018
  • Built out the data and reporting infrastructure from the ground up using OWB, OBIEE, and SQL to provide near real-time insights into customer data
  • Streamlined the process of troubleshooting and monitoring LAN/WAN activities, resulting in an improvement in up-time to over 95%
  • Collaborated with other DBAs to tune client databases and assisted developers in optimizing code, leading to improved application speeds of about 30%
  • Implemented regular alerting and monitoring of network and system performance via Nagios, reducing application downtimes by 11%
  • Planned and implemented automated backups and fail-over configurations for internal and client databases
  • Led a BI team consisting of 1 analyst and 1 intern
  • I worked with and managed a vendor team of 3 to build robust firewalls using Sophos and also installed a Dell EMC storage device

Education

Bachelor of Science - Telecommunication and Information Engineering

Jomo Kenyatta University of Agriculture and Technology
05.2011 - 12.2015

Skills

Data Project Management

Certification

Oracle Business Intelligence Foundation Suite11g Certified Implementation Specialist

Accomplishments

  • Led the migration of the data engineering pipeline at D.light from Oracle cloud to AWS saving costs by over 65%.
  • Pioneered branch 360-view reporting at Cooperative Bank, allowing for the view of branch and staff KPIs from the business intelligence suite.
  • Established the entire data analytics stack for the organization independently, starting from scratch, to facilitate data-driven decision-making.
  • Generated recommendations for process improvements based on insights obtained through data analysis.
  • Contributed to the overall enhancement of operational efficiency through proactive data-driven initiatives.
  • Prepared and maintained dashboards for stakeholders, serving as a valuable resource for informed decision-making.

Passions

  • Data-Driven Decision Making
  • Learning New Technologies
  • Automation

Notable Awards

  • IHOPE Award Winner, D.light, 12/2023
  • Most Valued Player, APA Insurance
  • Most Digitally Disruptive/Agile Employee, APA Insurance

Industry Expertise

  • Data Product Management
  • Data Security and Compliance
  • Leadership and Management
  • Insurance
  • PAYGO and Financial Services

Tableau

https://public.tableau.com/profile/constantine.ingumba#!/

https://github.com/constah

Programming Languages Tools

  • Python
  • Oracle Analytics: OAC, OAS, OBIEE, ODI, and OWB
  • Tableau
  • Analytics Engineering: DBT, Airbyte, DLT
  • SQL
  • Machine Learning / AI
  • Databases: Oracle, Postgresql, Redshift, MySQL

Training

  • A-Z: Hands-on PowerBI Training for Data Science
  • A-Z: Hands-on Tableau Training for Data Science
  • Python for Data Science and Machine Learning Bootcamp
  • Oracle Cloud Platform Enterprise Analytics 2021
  • Profiles International East Africa Leadership Training Program
  • Udacity Data Product Manager Nanodegree

Timeline

Senior Analytics Engineer

D.light
09.2023 - Current

Group Senior Business Intelligence Analyst

D.light
08.2022 - 08.2023

Group Business Intelligence Officer

Apollo Group
10.2019 - 08.2022

Data Visualization Developer

Co-operative Bank of Kenya
07.2018 - 10.2019

BI Lead and System Administrator

Turnkey Africa LTD
10.2015 - 07.2018

Bachelor of Science - Telecommunication and Information Engineering

Jomo Kenyatta University of Agriculture and Technology
05.2011 - 12.2015
CONSTANTINE INGUMBAAnalytics Engineering And Data Analytics Product Manager