Mahmoud Tawfik

Performed in-depth HR and cost analytics for Saudi Arabia Railways, integrating employee master data with salary, allowance, VAT, and contract information to assess workforce cost structure and efficiency.
Designed executive-level Power BI dashboards visualizing headcount, workforce distribution, and total employment cost across business units, departments, and locations, supporting data-driven HR and financial decisions.
Delivered insights on workforce composition, contractor distribution, and cost allocation, enabling leadership to monitor cost drivers and optimize workforce planning.

Developed and maintained an Excel-based analytics system for 12 school branches, consolidating daily ad campaigns from 5 digital platforms (Google, Meta, TikTok, Snapchat, X).
Designed Master Pivot Tables and interactive dashboards to track key KPIs: Total Cost, Clicks, Registrations, CPM, CPC, CPA, CTR, and Conversion Rate.
Automated data aggregation, enabling daily reporting without manual repetition for multiple schools.
Provided actionable insights on cost efficiency per platform, conversion performance, and trends, supporting strategic decision-making for marketing budget optimization.
Ensured accurate date handling, dynamic updates, and integration of registration data across all branches.

Managed sales, operations, and financial datasets to support both business and financial decision-making.
Supported management in business and financial decision-making by delivering integrated analytical reports combining operational, commercial, and cost insights.
Developed forecasting models for sales channels (offline vs. online/commercial), providing management with forward-looking insights for planning.

Collected, cleaned, and structured 10,000+ PO records, improving data accuracy by 95% and reducing reporting time by 40%.
Built relational models linking POs with suppliers and projects, enabling 100% traceability of spending across categories.
Conducted procurement spend analysis, identifying top suppliers and cost drivers, leading to a 12% reduction in excess spending.
Developed budget vs. actual expenditure dashboards in Power BI, increasing financial visibility by 60% for management.
Delivered actionable insights on supplier performance and project costs, supporting decisions that improved procurement efficiency by 18%.
Provided financial and business impact assessments that guided procurement planning and cost-reduction strategies.

Managed sales, operations, and financial datasets to support both business and financial decision-making., Supported management in business and financial decision-making by delivering integrated analytical reports combining operational, commercial, and cost insights., Developed forecasting models for sales channels (offline vs. online/commercial), providing management with forward-looking insights for planning.

Collected, cleaned, and structured 10,000+ PO records, improving data accuracy by 95% and reducing reporting time by 40%., Built relational models linking POs with suppliers and projects, enabling 100% traceability of spending across categories., Conducted procurement spend analysis, identifying top suppliers and cost drivers, leading to a 12% reduction in excess spending., Developed budget vs. actual expenditure dashboards in Power BI, increasing financial visibility by 60% for management., Delivered actionable insights on supplier performance and project costs, supporting decisions that improved procurement efficiency by 18%., Provided financial and business impact assessments that guided procurement planning and cost-reduction strategies.

Analyzed operational performance data across 16+ international branches, identifying underperforming regions resulting in 18% improvement in resource allocation efficiency.
Conducted comprehensive efficiency audits for 70+ departmental units, delivering data-driven recommendations that increased overall operational performance by 23%.
Collaborated with stakeholders to transform complex findings into actionable executive reports, enabling strategic decision-making based on quantifiable metrics.

Analyzed operational performance data across 16+ international branches, identifying underperforming regions resulting in 18% improvement in resource allocation efficiency., Conducted comprehensive efficiency audits for 70+ departmental units, delivering data-driven recommendations that increased overall operational performance by 23%., Collaborated with stakeholders to transform complex findings into actionable executive reports, enabling strategic decision-making based on quantifiable metrics.

Designed and implemented a custom Excel-based electronic accounting system with an integrated analytics dashboard, reducing financial reporting time by 65%.
Performed in-depth financial analysis across departmental accounts, improving budget tracking accuracy by 32% and enhancing forecast reliability.
Automated key reporting processes using Python and Excel macros, eliminating 12 hours of manual work weekly.

Designed and implemented a custom Excel-based electronic accounting system with an integrated analytics dashboard, reducing financial reporting time by 65%., Performed in-depth financial analysis across departmental accounts, improving budget tracking accuracy by 32% and enhancing forecast reliability., Automated key reporting processes using Python and Excel macros, eliminating 12 hours of manual work weekly.

Conducted 6-month retrospective analysis of 5,000+ patient records using SQL and Python, identifying critical patterns in injury types and frequency.
Developed interactive Power BI dashboards visualizing key healthcare metrics, enabling administrators to identify service improvement opportunities that increased patient satisfaction by 17%.
Generated comprehensive analytical reports that informed public health initiatives, improving hospital preparedness and resource allocation.

Conducted 6-month retrospective analysis of 5,000+ patient records using SQL and Python, identifying critical patterns in injury types and frequency., Developed interactive Power BI dashboards visualizing key healthcare metrics, enabling administrators to identify service improvement opportunities that increased patient satisfaction by 17%., Generated comprehensive analytical reports that informed public health initiatives, improving hospital preparedness and resource allocation.

Developed and maintained an Excel-based analytics system for 12 school branches, consolidating daily ad campaigns from 5 digital platforms (Google, Meta, TikTok, Snapchat, X)., Designed Master Pivot Tables and interactive dashboards to track key KPIs: Total Cost, Clicks, Registrations, CPM, CPC, CPA, CTR, and Conversion Rate., Automated data aggregation, enabling daily reporting without manual repetition for multiple schools., Provided actionable insights on cost efficiency per platform, conversion performance, and trends, supporting strategic decision-making for marketing budget optimization., Ensured accurate date handling, dynamic updates, and integration of registration data across all branches.

Performed in-depth HR and cost analytics for Saudi Arabia Railways, integrating employee master data with salary, allowance, VAT, and contract information to assess workforce cost structure and efficiency., Designed executive-level Power BI dashboards visualizing headcount, workforce distribution, and total employment cost across business units, departments, and locations, supporting data-driven HR and financial decisions., Delivered insights on workforce composition, contractor distribution, and cost allocation, enabling leadership to monitor cost drivers and optimize workforce planning.