سمير حامد

Identify unbilled revenue and ensure adjustments recorded correctly by overseeing revenue reports. Prepare FTE employees working hour reports of six UK, four Ireland, and three Nordics branches. Analyse monthly direct operating expenses and SGA costs impact on EBITDA to ensure cost effective operations. Participate in decision making process by presenting financial data to senior management team. Create key customer and cluster reports to showcase organisational financial position. Analyse monthly results and prepare reports to show impact of volumes and margins. Analyse customer’s key metrics to prepare reports for gross revenue per kilo, net revenue per kilo, volume per shipment, and net revenue margin for the UKIN Freight Director. Prepare monthly business review packs for air freight business line for the senior leadership team by giving insight into risks and opportunities from current trading relationships and volume deviations. Cultivate strong internal relationships to understand the business operating plan for core and new volume growth and gaps to outturn for the full year.
• Introduced a new process to track unrecognised revenue for the UKIN cluster and gained $213k credit from two china branches.
• Secured three working hours per day and improved month end report efficiency by creating formulae and macros to generate automated reports.
• Created budgeting templates for other finance colleagues and operation teams to update full year figures to baseline to be used for forecasting the 2020 budget.

Formulated KPIs report to gauge productivity and labour efficiency across 2 manufacturing sites. Led weekly management and leadership meetings to present PowerPoint pack on weekly performance of site. Analysed weekly stock variances and provide suggestions on key usage variances vs. standard. Collaborated with project management and developer’s teams to provide support for efficient stock management and reporting. Managed margins with customers and find alternatives without compromising quality and specification by creating a costing matrix. Prepared budget by collaborating with managing directors. Forecasted direct and indirect costs in the budget in order to deliver EBITDA covenant to the bank for 2018. Compared actual weekly actual spending with budget to ensure cost effective operations. Prepared presentations of key management information in the most appropriate manner for finance and non-finance users to understand easily.
• Efficiently utilised labour according to productivity needs to minimise expense by analysing opportunities.
• Improved the efficiency of the finance department by proficiently utilising excel for automated reports.

Prepared P&L reports for the online Boots.com business line and managed the monthend reporting deadlines. Analysis to report actuals compared vs budget and plan down to EBITDA level and variance commentary for senior management meetings. Produced Weekly Retro Forecast reports for all categories by extracting data from SAP BW data warehouse and manipulating it to present in a useful manner. Executed weekly meetings to present review reports on updated forecasts and produce packs for senior managers. Forecasted baseline for year end in order to roll forward for new financial year budget. Collaborated with category managers to gain insight into projects and one-offs for the budgets to analyse large volumes of data for past trends and taking into account seasonality, key holiday periods and sales plans. Created budget review packs for each of the Boots.com categories to identify area of improvement and implement changes. Analysed and reconciled Partnership Marketing Costs Vs Provisions in the accounts by liaising with individuals in the PM department to provide insight.
• Planned, designed, and implemented model for forecasting and business partnering the Online and in store ordering revenue in order to achieve budget targets based on Web conversions and average order values.

Created monthly consolidation reports of multi-site overseas group of companies (UK, Ireland & China) with variance analysis to understand group’s financial health. Prepared budgets and forecasts as well as collaborate with non-finance stakeholders to communicate the ways to manage budgets effectively and efficiently. Prepared weekly KPI reports and ad-hoc analysis on Sales and Margin. Managed cash flow and day-to-day capital of group to ensure organisational requirements are met for business operations. Coordinate with auditors for completion of Year end statutory individual and consolidated accounts by utilising UKGAAP & IFRS principles. Executed meetings with tax advisors to develop tax computations of companies.
• Enabled maximum margins by developing product costing matrix for new customers with a view to offering rebates for future growth of the business and customer base.
• Ensured compliance with organisational policies and procedures by monitoring and managing inventory controls.

Management accounting and forecasting of stations, facilities and other departments with commentary around the key variances. Reviewing and appraising project spends and impacts on the P&L. Preparing performance reports and presentation packs for board meeting. Assisted the Commercial Director in financial decision making by providing key trend analysis and KPI’s to improve business performance. Analysed costs attributed to train cancellations and the impact of these on the P&L with fines from Department of Transport. Reviewing and challenging the weekly revenue forecasts from internal stakeholders and making sure impacts are clearly reflected in the business plans. Investigating passenger delay claims and impacts on the P&L and measuring against KPI’s set on passenger satisfaction. Working with non-finance stakeholders to understand advertising campaigns impact on passenger trends.

Prepared consolidated European forecasts on weekly and monthly basis. Created capex forecast to acquire, upgrade, and maintain physical assets and reviewed actual spend vs forecast on monthly bases for senior finance and non-finance managers. Provided analysis on OPEX Budgeting process by liaising with Senior Managers. Participated in monthly performance meetings with operations on delivery of key KPI’s. Prepared monthly reports for finance and non-finance senior management by analysing critical OPEX overspends. Involved in SOX testing and updating relevant Schedules. Developed variance analysis of OPEX Costs vs Budget. Reviewed month end balance sheet reconciliations with FSSC teams to ensure the accuracy.
• Participated in quarterly and annual audits by liaising with auditors.