AA

AHMED AFIFY FAHMY

Available to hire

I’m Ahmed Afify Fahmy, a results-driven Data Analyst and Business Intelligence specialist focused on turning complex financial and operational data into clear, executive-ready insights.

About

I’m Ahmed Afify Fahmy, a results-driven Data Analyst and Business Intelligence specialist focused on turning complex financial and operational data into clear, executive-ready insights. I bridge enterprise ERP data from SAP S/4HANA FI with modern analytics workflows using SQL, PostgreSQL, Power BI, Power Query, Python, and advanced Excel—while keeping reconciliation accuracy extremely high.

In my current work at PepsiCo Egypt, I automate ETL and reporting processes (including cash collection and month-end reconciliations), build KPI dashboards and decomposition models, and improve data quality for reliable decision-making. I also enjoy creating data pipelines and AI-assisted analytics workflows, such as automating remote job analytics and healthcare financial intelligence using star schema modeling and interactive BI visuals.

  • Joined October 2026

Industry experience

  • Consumer Goods
  • Financial Services
  • Manufacturing
  • Healthcare
  • Professional Services
  • Retail

More experts in Minya, Egypt

Projects · 1

Commercial Sales Performance & Returns Impact Intelligence Dashboard | Excel & Power BI

Engineered an executive-level Commercial Analytics Dashboard in Power BI analyzing multi-year transactional sales performance, product profitability, and the financial impact of customer returns. Key Financial & Business Metrics Delivered: • Revenue & Profitability: Evaluated 6.16M EGP in Total Net Sales across 1,566 net units, yielding 964.2K EGP in Net Profit against 5.20M EGP in Net Cost and 487.9K EGP in discounts. • Returns Financial Impact: Isolated return behavior showing 913.5K EGP in lost profit due to returned orders across 1,462 returned units, identifying Laptops and Headsets as the highest returned products and Giza as the top return region. • Regional Performance: Identified Minya (228.6K EGP profit) and Cairo (199.3K EGP profit) as the primary profit drivers, while uncovering margin erosion in regions with elevated discounts and return rates. • Product & Sales Rep Dynamics: Highlighted product margins (Laptops generating 4.3M in sales and 587.3K in profit) alongside individual sales representative contribution (led by Mina Fawzy with 1.86M sales / 302K profit). Tech Stack & Analytics Deliverables: Excel, Power Query (ETL & hygiene), Power BI (Relational Data Modeling, DAX measures for Net/Gross variance, dynamic slicers for Year/Region/Product, and Gauge margin monitoring)

  • Data Analyst

Work experience

Control & Reporting Coordinator • Accounts Receivable · pepsicoNov 2007 – Present · 19 yrs 1 mo

Responsible for managing end-to-end financial operations, transactional accounting, and automated reconciliation across high-volume business operations. Bridge core accounting controls with modern data analytics to eliminate manual errors and deliver real-time operational insights. Key Achievements & Responsibilities: Engineered automated data workflows using Python and Advanced Excel to reconcile high-volume cash collection and accounts receivable (AR/AP) transactions across multiple plants, reducing manual processing time significantly. Designed and deployed interactive Power BI dashboards and executive reports, tracking key financial KPIs, cash flow movements, and operational variances. Leveraged SQL and relational queries to validate transactional integrity, extract ERP data, and ensure 99%+ ledger accuracy during month-end closing. Streamlined audit preparations and discrepancy investigations by standardizing reporting structures and automating variance detection.

Control & Reporting Coordinator (Data Analytics & Automation Focus) · PepsiCo EgyptJan 2007 – Present · 19 yrs 11 mos

Lead financial and operational data analytics and workflow automation initiatives by integrating high-volume SAP S/4HANA FI transactional data into reporting pipelines using Python, SQL, Power BI, Power Query, and advanced Excel. Automated cash collection & reconciliation by extracting ERP reports from SAP S/4HANA FI, updating master workbooks via Python, generating accounting entries, saving 15+ hours weekly and improving reliability. Built cross-department validation and reconciliation models across multi-plant operations sustaining over 99% accuracy and accelerating month-end closing. Developed standardized KPI reporting packages and executive dashboards for working capital and variance insights, and led ongoing data quality/master data governance for sales and distribution datasets.

Control & Reporting Coordinator · PepsiCo EgyptJan 2007 – Present · 19 yrs 11 mos

Spearheaded financial data automation by integrating transactional SAP S/4HANA data into dynamic reporting workflows. Automated cash collection and journal entry processes to reduce recurring manual intervention and speed up monthly closing reconciliations. Designed cross-departmental financial reconciliations with >99% accuracy, reducing discrepancy resolution turnaround times. Standardized operational reporting templates using Power Query and advanced Excel to provide timely insights to senior finance leadership.

Education· 5

Bachelor of commerce · Cairo University2000 – 2004

Comprehensive academic foundation in corporate accounting principles, financial management, auditing standards, and business economics. Developed rigorous quantitative analysis and statistical reasoning skills, which serve as the backbone for modern financial data modeling, variance analysis, and automated reporting systems.

Diploma of Data analyst · Sohag University2025 – 2026

ntensive, hands-on program focused on the end-to-end data analytics lifecycle, business intelligence, and process automation. Core Focus & Applied Skills: Data Extraction & Modeling: Writing analytical SQL queries, joining relational databases, and designing normalized schemas. Business Intelligence & Visualization: Building interactive Power BI dashboards, KPI tracking, and DAX calculations. Data Manipulation & Scripting: Using Python (Pandas) and Advanced Excel (Power Query) for automated data cleaning, validation, and workflow efficiency

Bachelor's Degree in Commerce (Accounting Major) · Egypt (institution not specified)2030 – 2026
Professional Data Analysis Track (40 Training Hours) · Sohag University – TTEU2030 – 2026

Certifications and awards· 7

Professional Diploma in Data Analytics2025 – 2026

Intensive program focused on SQL relational modeling, Power BI dashboard development, automated reporting, and Python (Pandas) data workflows.

Bachelor's degree in commerce / accounting2030 – 2026
Professional Training Course in Data Analysis (40 Training Hours) - Sohag University – TTEU (Advanced Excel, Power BI, SQL, and Python with AI)2030 – 2026
Data Analysis Professional Track (SQL, Python, Power BI, Excel) – Self & Online Training2030 – 2026

Hire AHMED AFIFY FAHMY today

Post a job and invite AHMED, or contact them directly. No hidden commission.

Post a job