• Perform ETL for extracting market, operational, and financial data from multiple sources, transforming and modeling it using Excel, resulting in structured datasets ready for analysis in the feasibility study.
• Clean raw data by fixing nulls, inconsistencies, datatype mismatches, outliers, and duplicates, improving data accuracy by 100% and ensuring reliable decision-making.
• Build automated financial models and dashboards covering KPIs such as project ROI, profitability, cost breakdowns, and revenue forecasts, providing stakeholders with real-time and scenario-based insights.
• Analyze market trends, cost structures, and profitability under various assumptions using Break-Even and Sensitivity Analysis, enabling risk-aware investment planning.
• Develop projected Income Statements, Balance Sheets, and Cash Flow Statements to visualize the project’s financial performance over time.
• Deliver actionable insights and recommendations through professional presentations and data visualizations, improving communication and aligning stakeholders on key decisions.
• Collaborate with a multidisciplinary team to integrate technical, operational, and financial findings into a comprehensive feasibility study that guided a high-value investment decision.

• Designed and developed 16+ interactive dashboards for the 2022 annual budget, covering multiple departments and functions, each containing up to 4 detailed report pages tailored to specific stakeholder needs.
• Performed ETL to extract large-scale public sector data from multiple governmental sources, transforming and modeling it in Excel & Power BI for high-performance analytics.
• Cleaned massive datasets by resolving nulls, inconsistencies, datatype mismatches, outliers, and duplicates, ensuring 100% accuracy for decision-making.
• Built comprehensive budget analysis models for:
  • The full General Budget
  • Human Resources allocations
  • Budgeted activities & projects
  • Operational services & contracts
  • IT services contracts
  • Committee costs & expert authority expenses
  • Reserves & estimated costs
  • Expense management & contract tracking for expert staff
• Delivered interactive reports and visualizations to senior management, enabling faster and more informed decisions for public sector financial planning.
• Developed automated KPI tracking for spending efficiency, budget utilization, and departmental performance.

• Performed ETL to extract operational, HR, and sales data from multiple sources, applying transformation and modeling in Excel & Power Query to create a dynamic, auto-updating dashboard.
• Designed and implemented an interactive Guest Service Dashboard covering KPIs such as Check-in Error, Boarding Error, OTP, Idle Time, OOG Revenue, and manpower utilization.
• Automated data refresh and visualization to provide real-time insights for operational decision-making.
• Integrated multiple data streams to monitor flights, sales, contracts, HR metrics, and operational delays, improving reporting efficiency and accuracy.

• Developed a dynamic HR Dashboard covering the full year of 2022, allowing management to filter and view KPIs by month for detailed workforce analysis.
• Performed ETL processes to extract HR data from multiple dynamic sources, clean it (removing nulls, inconsistencies, datatype mismatches, duplicates), and transform it into a structured, analysis-ready format.
• Delivered interactive KPIs including headcount, Saudization %, average salary, years of service, gender distribution, turnover rate, retention trends, training statistics, and part-time/full-time breakdown.
• Automated calculations and visualizations for workforce demographics such as age distribution, tenure, and department-specific metrics (e.g., Legal Advisor, HR Specialist, Marketing, IT, Sales).
• Designed advanced filters and drill-down features to enable real-time decision-making for HR managers.
• Ensured data accuracy and consistency across monthly reports, improving reporting efficiency by 100% compared to manual tracking.
• Presented actionable workforce insights to stakeholders, supporting strategic HR planning and Saudization compliance goals.

• Designed and developed a comprehensive database for Quran memorization circles.
• Built a no-code application using AppSheet for streamlined data management.
• Created an interactive dashboard in Looker Studio, visualizing key performance metrics.
• Automated report generation and data analysis, enhancing decision-making efficiency.

🚀 Tools Used: Looker Studio, AppSheet, Google Sheets, SQL (Database Design).

🔗 View the interactive dashboard and report here
📱 To view a version of the application, click here

• Developed a dynamic Collections Performance Dashboard to monitor collectors’ achievement against monthly targets, covering KPIs across multiple timeframes (over 6 months, within 6 months, and total outstanding).
• Performed ETL processes to extract financial and customer payment data from multiple sources, clean it (removing nulls, inconsistencies, datatype mismatches, duplicates), and transform it into an analysis-ready dataset.
• Delivered interactive KPIs including: total outstanding balance, overdue amounts (>6 months), discounts, net receivables, customer count, zero-paid customers, payment commitments, actual collections, shortfall amounts, and % achievement.
• Automated calculations for real-time tracking of collection efficiency, allowing management to identify underperforming collectors and prioritize high-risk accounts.
• Designed advanced filters and drill-down features enabling the management team to view performance by collector, region, time period, and customer segment.
• Improved reporting efficiency by over 80% compared to manual tracking, ensuring data accuracy and consistency in monthly performance reviews.
• Provided actionable insights to senior management, contributing to higher collection rates, reduced overdue receivables, and improved financial health of the company.

• Developed an advanced interactive Projects & Events Management Dashboard to track and manage organizational activities in real time.
• Consolidated and monitored multiple operational areas including:
  • Meetings scheduling and follow-up
  • Tasks & responsibilities management (M.N)
  • Weekly agency coordination reports
  • Inter-agency coordination
  • Annual agenda planning
  • Royal decrees & protocol transactions
  • Events & official ceremonies
  • Support unit project tracking
  • Memberships in councils & committees
• Integrated data from various departments, ensuring all updates were dynamic and synchronized.
• Delivered insights to senior management for improved project delivery, coordination efficiency, and decision-making.

• Designed and developed an interactive HR Operations Dashboard for the Entry & Exit Office within the Qunfudhah Health Affairs Directorate, enabling real-time tracking of staff attendance, entry/exit times, shift schedules, and leave requests.
• Performed ETL processes to extract HR and attendance data from multiple internal systems, clean it (removing nulls, duplicates, and inconsistencies), and prepare it for analysis.
• Delivered automated electronic reports including: daily attendance, absence summaries, shift allocations, and leave statistics, significantly reducing manual workload.
• Built a digital shift management and attendance monitoring system that replaced manual paper-based tracking, improving efficiency and accuracy.
• Developed real-time KPIs to monitor punctuality, leave patterns, shift compliance, and overall workforce availability.
• Provided actionable HR insights to management, supporting effective workforce planning and operational decision-making.