Kelechi Ogbogu

• Extracted and integrated data from multiple SQL databases (IBM Db2, MSSQL), reducing reporting preparation time and improving decision-making.
• Built Power BI Dataflows and automated refresh schedules, eliminating manual errors
and ensuring consistent data accuracy.
• Designed efficient data models and dashboards capable of handling large datasets with faster query performance.
• Developed KPIs (production performance, production hours, backlog, lead time) that
enhanced efficiency, reduced overtime costs, and improved on-time delivery.
• Implemented price effect analysis on raw materials, enabling significant cost savings in procurement.
Technologies Used: Power BI, DAX, SQL (IBM Db2), Power Query, Excel.

• Improved academic and enrolment data quality by implementing data cleaning and governance processes.
• Queried data (MSSQL, PostgreSQL) for curriculum planning and resource allocation, accelerating decision-making.

• Analyzed enrolment trends with Power BI dashboards, supporting interventions that improved student retention.
• Partnered with faculty to monitor impact of new teaching strategies, contributing to improved pass rates.
Technologies Used: Power BI, SQL (MySQL, PostgreSQL), Excel, Python.

• Conducted customer data mining and developed actionable insights, boosting marketing campaign effectiveness and sales conversions.
• Built analytical dashboards and KPI scorecards in Power BI and QlikSense, reducing reporting effort and improving delivery reliability.
• Partnered with finance and marketing teams to optimize forecasting and budget planning through data-driven insights.
• Introduced delivery performance KPI framework, significantly improving on-time delivery performance.
Technologies Used: Power BI, Qlik Sense, SQL, Excel.