Développeur MS BI

Data modeling for Manufacturing, Procurement, Finance, Supply Chain department self service reports in Power BI and SSAS.

• Created pipelines through SQL databases and views
• Created semantic models for self serving Power BI reports
• Created templates for reports
• Created reports for senior stakeholders

• Worked with Power BI as the primary tool, creating, enhancing, and simplifying data models for flagship reporting products. Daily use of DAX and M language, along with SQL, DAX Studio, and Tabular Editor.
• Developed a Power Automate solution for one-click download of underlying data from the client side.
• Implemented Power Automate within Power BI to create an Automated QA report.
• Consolidated data from multiple sources and created a data model from scratch for a new flagship product, Multi-Channel, offered by the company.

Front Row Group partners with leading brands to accelerate their e-commerce growth by activating the strength of our capabilities to measure and analyze, explore and invent, and see and solve problems.

• Working with Power BI as a main tool, creating, improving, and simplifying data models for the flagship reporting products. DAX and M language used daily, as well as SQL, DAX Studio, Tabular Editor

• Created the Power Automate solution for a one-click download of underlying data from the client side.

• Worked with Power Automate within Power BI to create an Automated QA report which simplified the QA process when deploying changes to production. It decreased the effort of QA for change release for about 20 minutes per release.

• Introduced improvements in the models through calculation groups for easier Time Intelligence queries

• Consolidating data from multiple data sources and creating a data model from scratch for a new flagship product, Multi-Channel offered by the company

• Initiated the establishment of the Data Academy.
• Developed a customized dashboard in QlikView for a project involving over 100 FTEs, resulting in a 20-hour reduction in manual production labor per month.

• Achieved a 30% reduction in time and effort through the implementation of VBA automation.
• Managed a headcount report, introducing data enhancements for improved visibility to the business.
• Reduced loading time by 20% through a combination of SQL, Alteryx, and Tableau improvements.
• Automated financial reports incorporating budgeting, actuals, and forecasting data.

Dimension Data is a leading African-born technology provider operating in the Middle East and Africa, offering a portfolio of services including systems integration, managed services infrastructure, cloud solutions, business applications, customer experience, and intelligent security solutions.

• Part of a cross-functional BI team in a Managed Service Center

• Managed and improved existing portfolio of operational dashboards with a centralized overview dashboard for all of the KPIs/SLAs with Power BI

• Created financial report to be used by senior stakeholders and country leaders in Europe

• Created and Managed a monthly infographic for a forum of country leadership in Europe

• Coordination and mentoring of colleagues to take over existing projects

• Created the standardized portfolio with an automated data pipeline of Operational reports, billing, invoices, and financials as a Client Dedicated Analyst

• Created a standardized, automated client report to be used for monthly updates by European clients.