Abdo Alswaf

Data Analyst with 3+ years of experience delivering business intelligence, HR analytics, workforce planning, and process automation solutions across HR, Finance, Operations, and CX. Proficient in Power BI, SQL, Python, SSIS, Power Automate, and SAP SuccessFactors, with a proven ability to transform complex data into executive dashboards and actionable insights. Achieved measurable business impact by reducing manpower costs by 6% (SAR 24M), lowering employee turnover by 12.5%, reducing financial closing time by 50%, and decreasing order cancellations by 15%.

Experienced in automating reporting processes, optimizing data workflows, and partnering with cross-functional stakeholders to support strategic decision-making and improve business performance.

HR Data Analyst at ARASCO (2025-06 – Present)

• HR Master Data & Turnover Analytics Dashboard: Developed a centralized HR analytics solution to monitor headcount, organizational changes, Saudization, workforce movements, and turnover metrics. Automated employee change tracking, improving HR data accuracy and workforce visibility, contributing to a 12.5% reduction in employee turnover.
• HR Weekly Flash Dashboard: Developed and automated an executive dashboard using Power BI, SQL, and Power Automate to monitor weekly headcount changes, employee movements, promotions, resignations, and salary updates. Reduced manual reporting effort, improved reporting accuracy, and enhanced stakeholder visibility through automated report distribution.
• HR Manpower Cost, Payroll & Compensation Analytics: Built enterprise workforce cost analytics covering payroll, salaries, allowances, benefits, compensation, and employee-related expenses across multiple legal entities. Supported payroll validation, budgeting, and workforce planning, contributing to a 6% reduction in manpower costs versus budget (SAR 24M savings).
• Performance Analytics Dashboard: Developed Performance Analytics dashboards in partnership with the Organization Development (OD) team to monitor employee performance and support talent management. Contributed to a 23% increase in Strong performers, 94% increase in Excellent performers, and 450% increase in Outstanding performers between 2024 and 2025.
• Annual Leave Balance Analytics: Developed Annual Leave Balance Analytics to monitor leave balances and vacation liabilities, supporting workforce planning and financial reporting. Enabled proactive leave management, resulting in a 19% year-over-year reduction in outstanding annual leave balances.
• Job Offer Evaluation (JOE) & Recruitment Analytics: Developed the Job Offer Evaluation (JOE) analytics solution and automated recruitment workflows to support data-driven hiring decisions. Reduced recruitment cycle time by 40% through workflow automation and process optimization.
• SQL Optimization & HR Reporting Automation: Optimized SQL queries and automated HR reporting processes to improve data quality, dashboard performance, and report refresh efficiency. Reduced dataset refresh time from 1 hour to 6 minutes while significantly minimizing manual refresh activities.

Process Analyst at Innovative Foods International (2024-01 – 2025-06)

• 360 Dashboard (CEO Dashboard): Developed an executive-level Power BI dashboard (CEO 360) integrating KPIs across Finance, HR, Operations, and Customer Experience. Achieved a 15% reduction in cancelled orders through data-driven decision-making. Automated monthly reporting using Power Automate and Python, minimizing manual processes. Aligned dashboard with departmental goals through collaboration with cross-functional teams.
• Financial Monthly End Closing Dashboard: Designed and implemented a Power BI solution to monitor submission timelines across departments. Achieved 98% on-time submission rate and reduced monthly closing time by 50%. Automated data extraction from NetSuite using Power Automate.
• Procure-to-Pay (P2P) Cycle Dashboard: Created a Power BI dashboard to visualize the P2P lifecycle, identifying bottlenecks and delays. Automated end-to-end data flow using Python and Power Automate. Improved procurement efficiency and compliance.
• Store Visibility Automation & Analytics Dashboard: Designed and delivered an end-to-end Store Visibility automation solution covering 165 branches. Built a Power Apps application used by 200+ users to submit and track hide/unhide requests. Implemented a multi-level approval workflow with SLA control and automated notifications. Fully automated the Unhide process with 100% accuracy, processing 700+ requests monthly.

Developed

Power BI dashboards that enabled a 30% reduction in branch hide time.

Freelance Data Analyst at Upwork (2023-05 – 2024-01)

• Completed 10+ client projects in data scraping and analysis.
• Utilized Python, SQL, and Excel to gather and clean datasets.
• Built insightful reports to support business decisions.
• Maintained 100% client satisfaction with consistent 5-star ratings.

Bachelor's degree in computer science – October 6 University (O6U) (2022-10)