Bilkis Olanrewaju

Data Analyst @Vividx

GB

Cleaned and transformed large consumer and inventory datasets (3.2 million records) from multiple sources using Excel and Power Query, improving data accuracy and enhancing insights for process optimization.• Developed and managed ETL pipelines to integrate and load complex datasets into MySQL Workbench using LOAD DATA IN FILE, optimizing data import and query execution.• Connected MySQL Workbench to Power BI Desktop using MySQL ODBC, enabling efficient data retrieval, automated data refresh, and seamless integration of large datasets.• Automated repetitive reporting tasks using SQL queries and Excel macros, reducing report preparation time by 30% and freeing resources for advanced analysis.• Created and optimized custom DAX measures in Power BI to perform advanced trend analysis and apply complex business logic, supporting faster and more informed decision-making.• Designed and maintained interactive, storytelling-driven dashboards that integrated data from SQL and Excel, uncovering over $43K in inventory optimization opportunities and boosting dashboard engagement by 40%.

University of Ilorin

Bachelor's degree

Ulster University

Master's degree

ACCA

Accounting and Finance