
Mafdy
Power BI & Data Analytics Lead at Thenes Consulting
Barcelona, Spain
Power BI & Data Specialist
Domain experience
Relevant Total Experience: 10 years
Seniority Level: Senior
Sector Experience:
Communication Services Consumer Discretionary Consumer Staples Energy Financials FinTech Health Care Industrials Information Technology Materials Real Estate UtilitiesSkills
Skilled in: Corporate Development, Due Diligence, Legal, Portfolio Services & Add-on M&A, Private Equity & Growth Capital, Sell-side M&A
Languages: Spanish, Arabic, English
Work Experience
Thenes Consulting
Power BI & Data Analytics Lead
●1/4/2024
- Now
Pay.UK
Power BI Consultant
●1/10/2023
- 31/3/2024
- Migrated 90 legacy reports to Power BI saving Pay.UK 40 hours/week. Hands on development support to team of 16 in financial services. Created an interactive compelling suite of Power BI reports & dashboards, transforming disparate data into actionable insights - Lead best practices for delivering end-to-end solutions: data sourcing, data warehousing, data modelling (star schemas), security, data analysis & visualisation. PowerBI, DAX, SQL, API Integration, Python - Expert in SQL, built large volume data warehouse SQL queries & stored procedures to optimize data models, data pipelines & produced performant re-usable golden source data - Implemented Power Automate & Power Apps to automate repetitive manual audit functions & distribute targeted stakeholder reports - Created & conducted comprehensive training & communications program. Virtual & in-person trainings, guides, blogs & awareness campaigns. Tailored my style to suit technical & non-technical stakeholders across the org. 180 of 350 staff attended at least one event - Established a citizen developer network. Developing strong relationships with key stakeholder. Getting buy-in, translating technical requirements into practical solutions & fostering adoption of Power BI - Managed project, created plan for Power BI roll-out & report migration. Managed developers & operational business users through Dev, Test, UAT & Production
Department of Jobs, Skills, Industry and Regions
Power BI Lead
●1/10/2022
- 31/7/2023
- Lead development & coached ~80 developers in end-to-end data solution architecture - Lead BI Team, identified & executed strategic projects (Agile Scrum & PRINCE). Created a program of work to motivate team, leverage strengths & facilitate professional development - Created MI & Operational reporting suite: HR, Financial & KPI Management. Reports used dataflows, high performance star schemas, optimised DAX & intuitive visualizations. I centralised disparate data, improved security and increased discoverability, I increased staff engagement from 50 to ~200 users - Established federated BI architecture model. Created certified master datasets for financial, HR & executive data. Supported BI teams to integrate with and build composite models on-top of these. My work resolved core department challenge: maintaining a single source of truth while allowing specialist areas integrate their own data & reporting - Delivering in multi-stage development environment Jira/DevOps, Source Control, CI/CD - Created automated access control & security provisioning based on org hierarchy using dynamic object/row level security, this reduced security requests from >15 to <2 per week - As primary admin of Power BI Premium Capacity, monitored & maintained BI platform. Re-architected problem dataflows, datasets & ETL processes to reduce capacity load by 35% & reduce refresh times by 60% - Re-implemented data warehouse (Oracle & Azure) redesigning SQL views & SSIS, SSAS, SSRS - Improved data governance framework, establishing comprehensive data & reporting catalogues to ensure traceability, integrity & accuracy. By improving metadata management, I facilitated better data quality, compliance & privacy
Department of Jobs, Skills, Industry and Regions
Manager Insights & Continuous Improvement
●1/1/2022
- 31/10/2022
- Establish & Lead the Department’s Data Analytics, Reporting & Engineering group. A successful initiative that helps data professionals within the department share knowledge, develop reporting, up-skill in data tools and create a more cohesive organization wide data strategy - Lead the data team, identifying strategic goals with directors. Created roadmaps to set priorities for the data team and focus on delivering the most effective solutions that allow team members to leverage their core strengths and contribute effectively to the work - Created reporting integrating directly with Salesforce to track team performance, assist managers with workload allocation and identify resourcing bottlenecks, this allowed team to increase number of cases resolved by 15% - Create a tool for rapid resource deployment to state emergencies, eliminating need to review data across ~10 different spreadsheets, slashing 1 hour process to 5-minutes with new ability to simulate and plan for a range of scenarios directly from the user interface - Created predictive reporting to enable workforce planning based on historical scenario analysis
Windana Drug & Alcohol Recovery Limited
Business Intelligence & Systems Lead
●1/11/2019
- 28/2/2022
- Resolve 30% ($2.4M) funding target under-performance. Transformed culture of distrust in data by designing, developing & maintaining intuitive automated dashboards. These clearly highlighted key trends, patterns & issues. Reports allowed staff to scrutinize detailed data to own & resolve data quality issues - Reduced budget deficit from $1M to $50k at primary site. Created budgetary reporting to track live spending & dynamically forecast. My new solution was actively utilized by all sites - Built dashboard suite: Finance, Payroll, Client Management, Outcomes Measurement & KPIs - Used Power Apps & PowerAutomate to automated processes around mandatory reporting, EOM, EOY, financial services, accounts reconciliation & payroll reconciliation activities. Reduced a 5-day process to 30-minutes - Lead implementation of org wide IT transformation. Implemented a new payroll & HRIS system. Extensive vendor negotiation, project management, change management & training, requirements gathering, process mapping & re-engineering. Facilitated many workshops and resolved competing interests through my well-practiced influencing skills
KINETIC DESIGN ENGINEERING LIMITED
Software Engineer
●1/1/2015
- 31/7/2019
- Full Stack Development bug fixes and enhancements using Delphi, C# & Python. Strong analytical mindset & passion for creating software to solve key business problems - Designed SQL databases & data warehouses (SQL Server, MySQL), created and modified complex queries, views, stored procedures and upgrades to model architecture - Allowed 50% of the annual incoming bugs to be resolved in weeks. Integrated CRM & error tracking system using REST APIs & SQL to provide insights for most prominent bugs - Built SQL reports for customers: customer insights, staff performance (KPIs), profitability of jobs & products, expected vs actual performance - Collaborate & build excellent working relationships with cross-functional teams to understand & document requirements and deliver impactful solutions - Extensively trained with junior staff on code base & robust ways of working (Peer-to-Peer QA) - Supported customers by providing technical support & troubleshooting assistance
Education
Massey University
1/1/2011
- 31/1/2014
Licenses / Certificates
Microsoft
Microsoft Certified: Fabric Analytics Engineer Associate
●1/5/2024
Want to work with Mafdy?
Sign up on the Fintalent platform to get in touch with Mafdy and 2,500+ other M&A freelancers!