Olu Ekundayo

Developed and maintained scalable data models incorporating SQL, Python, and Tabular Editor ensuring data accuracy, consistency, and alignment with governance frameworks. Facilitated training and knowledge transfer sessions empowering both technical and non-technical users with self-service analytics tools, thereby enhancing data fluency across the department. Automated data transformation and reporting workflows employing Python, Power Automate, and SQL, minimizing manual effort and improving turnaround times by up to 30%. Formulated and implemented data strategy aimed at enhancing data-driven decision making and increasing data adoption. Engineered low-code applications utilizing Microsoft Power Apps, SharePoint, and Microsoft Dataverse objects. Crafted operational process approval workflows leveraging Power Automate, Power Apps, Outlook, and Teams. Facilitated 12+ cross functional workshops to capture requirements and translate in data objectives and user stories Built automated ETL processes utilizing SQL and Python with Azure Data Factory to transfer data from critical business software to Microsoft Fabric for integrated reporting and analysis.

Led the data migration effort for the ERP deployment integrating Concerto CAFM, by extracting data from the legacy Wren system, performing data profiling and cleansing using advanced SQL queries, mapping datasets to Concerto Master Data templates, and executing data loads into Concerto through the Data Migration Toolkit to ensure data integrity and seamless transition Collaborated with stakeholders to define data requirements, ensuring data accuracy and completeness across related modules. Generated custom HSE reports within Concerto and configured user access rights for effective report distribution for Concerto PPM and Surveys and conditions modules. Validated migrated datasets during UAT phases to guarantee ERP deployment success and compliance with data retention policies. Analyzed, cleansed, and transformed complex Excel-based source data into standardized, migration-ready datasets aligned with Concerto data model requirements.

Developed and managed data artefacts, including Data Flows, Models, and Lineage, to ensure enterprise-wide data governance and compliance with GDPR and PCI-DSS regulations. Collaborated with cross-functional teams to optimize data architecture, achieving a 20% increase in data accessibility. Implemented Data Quality frameworks, minimizing data errors by 15% and enhancing reporting precision. Designed and implemented the process for daily extraction and transformation of SAP HANA data into structured CSV datasets, data cleansing using Python and SQL queries and creating complex Power BI dashboards from the resultant dataset. Managed the creation and user access control on the reporting datasets and on Microsoft Azure and AWS. Created and maintained intricate Tableau dashboards to visualize key metrics and support executive decision-making. Designed and optimized advanced SQL queries to resolve complex data wrangling tasks, successfully transforming raw data into structured formats. Created data gateway and API for migrating Safety Culture ERP Data to Microsoft Fabric