Ahmed Fathi

Duties & Responsibilities • Work closely with Integration Team to automate periodic / ad-hoc reports. • Work closely with multiple departments to full filled their business needs by • providing required data set to take appropriate management decisions which. • enable them to increase their profit, customer base, monitor customer behavior. • and to trace any suspicious activity. Supported departments are as below: • Collaborated with cross-functional teams to develop and implement data governance frameworks, ensuring • data quality and integrity across various departments. • Worked with the metadata management team to enhance data traceability and ensure compliance with internal • and external regulations. • Automated 85% of manual reporting processes, reducing data processing time by 30%.

Duties & Responsibilities • Developed Power BI models and wrote complex DAX functions. • Designed Power BI architecture and administered gateways. • Automated data refresh using PowerShell scripts. • Created diverse reports and conducted user presentations. • Utilized SQL Server, SAP BW, Oracle for data extraction. • Participated in project planning and optimized SQL performance. • Maintained Power Pivot models with stored procedures. • Designed and extracted data for visualization tools. • Implemented tabular queries and SSRS Jobs Performance reports. • Leveraged Tableau for data blending and SSRS for datasets.

• Working with end users to collecting the business requirements and creating the • Business Requirements Document. • Designing high-level architecture and its documentation. • Designing Integration Solution. • Designing dashboard design documents. • Designing and implementing data models. • Performing ETL job with using of SQL programming skills and SSIS • Creating Cubes with Microsoft SSAS. • Creating BI Reports with SSRS and dashboards with Power-BI.