AbdElrahman Faheem

Deliver centralized BI, analytics, and data engineering solutions using Python and SQL as part of the Annual Procurement Planning (APP) team supporting supply chain, planning, budgeting, and stock control across multiple Wadi Degla Holding companies, •Wadi Degla Clubs , Wadi Degla Developments , Cairo Tower, The District Vill , National Yachts Company , Peak Marine , Egypro , EgyproFME, Egy Const •Work closely with management and C-level executives to understand business needs and translate them into executive Power BI dashboards and infographics that support data-driven decision-making. •Design and build Power BI solutions by creating low-fidelity and high-fidelity dashboards and dynamic infographic layouts, and deliver storytelling reports using advanced DAX to clearly communicate business insights. •Support planning and yearly budgeting by analyzing historical demand, consumption, and pricing data, including price forecasting for budget preparation. •Perform stock control and inventory aging analysis using Python to improve operational visibility and decision-making. •Build automated Python and SQL reporting pipelines to generate daily reports, analysis, and insights with minimal manual effort. •Prepare executive presentations, communicate insights to leadership, and lead knowledge transfer and technical enablement sessions to promote best practices in BI development, automation, and analytics. Technologies: Python , SAP , Power BI, SQL, DAX, Excel

Developed Java-based APIs on the Data Warehouse (DWH) to enable real-time data access and improve reporting accuracy. Automated daily and weekly sales reporting using Python, enhancing speed, reliability, and insight delivery. Built web-scraping solutions to extract live Amazon pricing data for competitive market analysis. Implemented Git and GitHub version control for Power BI dashboards, ensuring smoother collaboration and version tracking. Created a Customer Service Portal using Java Spring APIs for instant inventory lookups across stores. Performed inventory and sales performance analysis to identify trends and optimize retail operations. Streamlined product transfer operations across 26 retail, warehouse, and e-commerce channels through automated Excel and SQL reports.

Developed Python-based API integrations and scraping tools to collect real-time pricing and inventory data. Analyzed supplier performance, lead time, and pricing using SQL and Power BI dashboards. Built ranking and classification systems to improve supplier selection and sourcing efficiency. Delivered insights on inventory aging, pricing trends, and stock optimization strategies.

Analyzed employee performance data to support operational improvements and team productivity. Conducted sales data analysis for multiple e-commerce platforms serving Elbatt’s clients in Saudi Arabia, delivering insights that helped optimize online sales strategies. Built and automated custom reports using Google Sheets, replacing manual processes and streamlining operations for faster, more accurate data tracking. Visualized key metrics with Excel and Power BI, enhancing reporting for both internal teams and clients. Key Tools: Excel, Power BI, Google Sheets, Data Automation