Gbena Wale

A. Responsibilities:

• Data Architecture and Integration: Led data validation and migration processes for Organon, integrating SAP ERP data with SAP Hana to improve data management and operational efficiency.
• Project Management and Strategic Planning: Led the migration from PureConnect to PureCloud for iA, optimizing cross-functional team coordination and aligning with digital transformation objectives.
• Product Ownership and Dashboard Development: acted as product owner for Desjardins, overseeing the development and implementation of a data quality monitoring dashboard to improve data governance.

B. Technical Environment/Methodologies:

• Technologies: Power BI, Snowflake, JIRA, Azure Data Factory, SQL Server, Azure DevOps, Azure Function, Azure Blob Storage, DAX, Power BI Services.

C. Projects Involved:

a. Organon (Pharmaceutical ): Orchestrating the migration of data warehousing operations to SAP Hana to enhance data capabilities and support advanced analytics, significantly improving Organon's market competitiveness.

b. Industrial Alliance (Insurance): Managing a critical transition to a cloud-based contact center solution, improving operational scalability and supporting iA's digital transformation initiatives.

c. Desjardins (Financial services ): Designing and implemented a data quality monitoring tool and, as product owner, played a critical role in improving data quality governance across business units.

A. Responsibilities:

• Data Maturity Assessment:Assessed data maturity and refined financial data models using the CMM model for Euroclear, ensuring alignment with reporting standards.
• Automation and Process Efficiency:Implemented Power Automate solutions at NN Insurance to streamline reporting and improve task automation.
• Financial data analytics:Enhanced Euroclear's financial data models and metrics to meet advanced reporting requirements.

B. Technical /Methodology:

• Technologies: SQL Server 2019, SSIS, SSAS, SQL, Master Data, DAX, Power BI Reporting Server, Cognos, Visual Studio, Power Automate Desktop, Power BI, Forms, Python, Azure Function, Azure Blob Storage, SQL Polybase, Azure DevOps, Azure Synapse.

C. Projects Involved:

a· Euroclear (Bonds, equities and mutual funds industry): Streamlining financial functions and improved data flow, optimized data maturity assessment.

b· NN Insurance (insurance industry):Increasing operational efficiency through automated reporting proof of concept using Microsoft technologies.

A. Responsibilities:

• Data Warehousing and ETL Development:Streamlined cloud-based BI solutions using Azure Synapse for Egssis to improve data query performance.
• BI audit and optimization:Overhauled L'Oréal's existing BI, identifying and fixing inefficiencies to streamline data processes.
• Technical design and standardization:Harmonized technical specifications and data structures at Charleroi Airport for consistent BI solutions.

B. Technical/Methodology:

• Technologies: Azure DevOps, Azure Synapse, Power BI, Azure Function, Azure Blob Storage, SSIS, SSAS, SSRS, Master Data, Excel Macro.

C. Projects Involved:

a· Egssis (Petroleum Industry):Validated Azure Synapse in a POC culminating in a robust cloud-based BI solution, enhancing Egssis' market position through improved data analytics.

b· L'Oréal (Cosmetics):Conducted a thorough audit and redesign of system architectures to optimize data extraction and warehouse scalability, improving reporting capabilities.

c· Charleroi Airport (Aviation Industry):Provided critical BI consulting to enhance data integration and analysis capabilities to support operational and customer data analysis.

A. Responsibilities:

• ETL and Data Integration:Orchestrated ETL processes using SSIS in Visual Studio, consolidating data into SQL Server 2016/2017.
• Data Warehouse Development:Applied Kimball methodology for real-time BI, dimension modeling, and historization with SCD Type 2.
• Data Analysis and Visualization:Enhanced SSAS analytical processing and created dynamic Power BI visualizations for various reporting needs.

B. Technical /Methodologies:

• Technologies: SQL Server 2016/2017, SSIS, SSAS, SQL, Master Data, DAX, Power BI, Windows, GitKraken, Visual Studio.

C. Projects Involved:

a.VKB Group/GWK (Agrofood Industry): Spearheading the VKB-DAP BI project, significantly enhancing decision-making and competitive positioning through advanced data analytics.

A. Responsibilities:

• Data Integration and Automation:Automated data collection and integration using SSIS and SQL, enhancing server performance monitoring at SASOL.
• Data Warehouse and SSAS Cube Development:Enhanced data warehouses and SSAS cubes for advanced data analysis using SQL Server 2016.
• Reporting and Cost Reduction Analysis:Developed Power BI reports to effectively reduce software license costs through meticulous tracking and optimization.

B. Technical /Methodologies:

• Technologies: Server 2016/2017, SSIS, SSAS, SQL, DAX, Power BI, Visual Studio, Windows, Excel, Word, Outlook, Project.

C. Projects Involved:

a· South African Coal (Oil and Gas Industry): Executing a BI system overhaul across 2,000 servers that cut software license costs by R80 million (40%) at SASOL.

A. Responsibilities:

• Data-Driven Transformation: Spearheaded the transformation of Respublica Student Living into a data-driven organization by implementing cutting-edge business intelligence technologies.
• ETL and Data Integration:Executed ETL tasks using Microsoft SSIS to collect data from various APIs, ensuring accurate and timely data availability for strategic use.
• Data Warehousing and Reporting:Developed a unified data warehouse using Kimball methodology and SQL Server, creating KPIs and dynamic reports for operational efficiency and strategic decision-making.

B. Technical /Methodologies:

• Technologies: SQL Server 2014/2016, SSIS, SSAS, SSRS, SQL, DAX, Power BI, Excel (including VBA macros and pivot tables), Word, Outlook, Kimball methodology.

C. Projects Involved:

a. Respublica Student Living (Accommodation and Retail Industry): Developing an integrated property management system focusing on customer data, billing, and analytics, markedly improving operational effectiveness and strategic decision-making.