Youssef Hassan

Transformed 50+ dashboard to SSAS migrating all M queries to SQL to implement an SSAS model. Built a full tabular model star schema and managed partitioning to make daily scheduled refrshes according to business needs. Responsible for investigating existing dashboards on power BI and the queries made on them and their complexity in order to make migration to SSAS. Responsible for developing Power BI dashboards according to the business needs

Building two models to unify data and extract golden records using Informatica MDM. Established data connections and scanned different resources types through MOF and applied data domains in addition business glossaries using Informatica EDC. Integrated EDC with IDQ.

Created 5 financial dashboard using Power BI & SAC related to all the banks the company deals with visualising each bank accounts receivables and cash flow. Developed another live financial dashboard using SAP BO which shows everyday net income coming from each bank.

Created a power BI dashboard that summarizes all daily transactions and provides these data to monthly and yearly revenues. Manged the project’s data warehouse ensuring process chains are running regularly.

Created daily reports on the driver side and rider side to show everyday ROI and CPI to help the market place team generate daily campaigns. Contributed to creating 15+ campaigns related to DiDi promotions Developed 20+ tableau and excel reports for stakeholders in Egypt & China to discuss bi-weekly ROI results and enhance our campaigns. Contributed in DiDi’s main 3 projects launched in July 2022 through providing the required analytics and dashboards for stakeholders. Contributed in creating a new fraud detection analytical system to detect frauds made by the drivers which assisted in increasing the ROI in the following months.