Joseph Magdy

• 1- Budgeting ,Forecasting and Scenario Analysis
  • Lead the annual budgeting process across all countries within the group.
  • Operational Budgeting - Sales Value & Volume, COGS, Marketing, OPEX, GP, Net Profit.
  • Financial Budgeting - Balance Sheet, Cash flow Budget.
  • Capital Budgeting- Capex and Project.
  • Develop and maintain multi-year forecast models, including scenario and sensitivity analysis.
  • Creating scenarios analysis - Best-case, base-case and worst-case.
  • Scenario Planning Forecasting to creating financial models, Projection.
  • Consolidate and validate financial submissions from regional teams and ensure alignment with group strategy.
  • Standardize budgeting processes and reporting formats across all group entities.
  2- Financial Planning & Analysis FP&A (Performance Evaluation - Management reporting )
  • Monitor actual performance vs. budget and provide detailed variance analysis.
  • Deliver periodic financial reports and dashboards to the executive team using Hyperion SYS.
  • Provide recommendations based on financial performance to support business decisions.
  • Product profitability analysis which product lines have the highest profit margin or contribute the most to net profit.
  3- Systems Leadership & Automation
  • Lead the successful implementation and optimization of Hyperion Financial Planning & Budgeting tools.
  • Ensure proper integration of ERP data into Hyperion SYS for Financial planning and reporting.
  4- Business Partner
  • Collaborate with cross-functional teams to understand operational drivers, assess business performance, and translate them into actionable financial plans.
  • Facilitate financial reviews with key stakeholders, ensuring alignment between operational goals and financial targets.
  • Support the CEO with data-driven recommendations, financial modeling, and ad-hoc analysis evaluate resource allocation, and growth opportunities.
  5- Process Improvement & Leadership
  • Mentor and guide FP&A professionals to build a high-performance .

Internal Audit and Financial Control

• Audited Accounts Payable, Accounts Receivable, Costing, Inventory, Treasury, Expenditures, and Fixed Assets to ensure accuracy in the Trial Balance and General Ledger within Microsoft Dynamics GP (ERP).
• Reviewed controlling accounts (e.g., accruals) and all items related to the Balance Sheet and Income Statement on a monthly basis.
• Maintained a master schedule of journal entries and verified postings for accuracy and compliance with proper account codes.
• Conducted variance analysis between budgeted and actual costs to evaluate entity performance on margin and profitability.
• Oversaw account reconciliations, financial reporting, and audit documentation to support decision-making and compliance.
• Led audit planning, risk assessments, and supervision of workpapers, ensuring adherence to audit standards and timelines.
• Developed and implemented financial regulations, administrative rules, and accounting charts to strengthen internal controls.
• Established and managed the Internal Audit function within the Finance Department, including policies, procedures, and audit frameworks.
• Managed fixed assets lifecycle within GP, from creation and valuation to inventory monitoring.
• Coordinated with external auditors and monitored audit quality, taking corrective actions when needed.
• Produced variance and financial performance reports, ensuring management objectives were achieved and reliable information was delivered.
• Evaluated and tested systems and internal controls to ensure compliance with policies, procedures, and contracts.
• Monitored audit assignments against approved timetables and budgets, ensuring efficiency and accuracy.

Accounts Payable and Fixed Assets Control

• Reviewed and reconciled controlling accounts and Accounts Payable transactions within Microsoft Dynamics GP (ERP), ensuring accuracy in the Trial Balance and General Ledger.
• Performed variance analysis between budgeted and actual costs to evaluate organizational performance.
• Recorded and maintained fixed asset acquisitions in GP, ensuring compliance with accounting standards.
• Conducted physical inventory counts of fixed assets to strengthen internal control and safeguard company resources.
• Managed the fixed asset register, including monthly depreciation, adjustments, disposals, and write-offs.
• Implemented a barcode tagging system for all fixed assets to enhance tracking, accountability, and reporting.

• Developed and presented a comprehensive feasibility study for warehouse expansion, evaluating rack system solutions, outsourcing vs. rental options, financing structures, and investment alternatives, with clear recommendations supported by cash flow analysis.
• Conducted an administrative building feasibility study, including ROI assessment and cost–benefit analysis of purchase versus rental scenarios, enabling data-driven decision-making.
• Designed and implemented a Warehouse Management System (WMS) with barcode integration, seamlessly aligned with Microsoft Dynamics Great Plains to improve inventory accuracy and operational efficiency.

Warehouse manager at State National Day Celebrations Organization Committee SNDCOC

• Established and standardized Operating Procedures (SOPs) for all warehouse operations, ensuring efficiency and compliance.
• Directed inventory management processes, including stock audits, slow-moving items analysis, and optimization of stock levels.
• Led team development initiatives, including performance appraisals and capability building for warehouse staff.
• Managed and monitored the warehousing budget, conducting variance analysis and preparing regular financial reports.
• Implemented an advanced Warehouse Management System (WMS) with barcode technology, enhancing accuracy, traceability, and productivity.
• Ensured strict adherence to health, safety, and security standards across all warehouse facilities.
• Developed and monitored cost-efficiency programs, improving warehouse performance and revenue contribution.
• Oversaw the full procurement cycle, including RFQs, POs, and supplier selection.
• Conducted detailed quotation analysis, ensuring the best balance of cost, quality, and delivery terms.
• Built and maintained a comprehensive procurement database, including supplier contracts and planning schedules.
• Negotiated with suppliers to secure cost savings, quality assurance, and long-term value partnerships.

Purchasing and Accounts Payable Store and Inventory Management

• Performed detailed Accounts Payable analysis within Microsoft Dynamics Great Plains ERP to ensure accuracy and compliance.
• Prepared and reconciled payables trial balances to support financial reporting.
• Posted journal entries and maintained accuracy in the General Ledger.
• Executed and monitored AP payments through Microsoft Dynamics (Great Plains).
• Prepared and submitted withholding tax reports in line with statutory requirements.
• Managed inventory control processes, ensuring optimal stock levels and accuracy across stores.
• Generated and analyzed monthly and annual inventory turnover reports to track efficiency.
• Conducted variance analysis and implemented corrective measures to minimize discrepancies.
• Supported cost optimization by improving inventory utilization and storage practices.

• Executed purchase order and receiving transactions within Microsoft Dynamics Great Plains ERP, ensuring accuracy and compliance with procurement policies.
• Managed landed cost calculations, including all related expenses, to determine the true cost of purchased items.
• Processed accounts payable payments (cash and check) in alignment with company financial procedures.
• Handled item and site maintenance to ensure accurate ERP master data management.
• Recorded and reconciled item transaction entries (including adjustments) to maintain data integrity.
• Conducted monthly stocktaking activities, reconciling discrepancies and preparing adjustment entries for accurate inventory records.
• Supported efficiency and control in purchasing, payables, and inventory processes across all stores.

Accounts Receivable Microsoft Dynamics Great Plains ERP

• Prepared and maintained cash flow budgets, receivable reports, and bank transfer schedules to support liquidity management.
• Processed AR invoices, credit memos, and customer receipts, ensuring compliance with contracts, POs, and finance policies.
• Executed sales and receivable transactions in ERP, including invoice posting, sales document applications, and adjustments.
• Monitored collections and customer aging, initiating follow-ups to reduce overdue balances and improve DSO.
• Generated monthly sales and receivables reports for management review, highlighting trends and variances.
• Oversaw customer payment collection, allocation, and reconciliation, ensuring accurate posting and resolution of discrepancies.
• Managed the full cycle of accounts receivable operations, safeguarding accuracy, timeliness, and compliance with accounting standards.

• Processed AR invoices, credit memos, and customer receipts in line with company policies and contracts.
• Monitored collections, outstanding debts, and conducted aging analysis to ensure timely recovery and improve cash flow.
• Supported month-end closing activities, including reconciliations and periodic stocktaking to validate records and ensure accuracy.