Muhammad Imran Email & Phone Number

Millbrook, England, United Kingdom

Hemel Hempstead, United Kingdom

Various ( Slough, Uk And Amsterdam, Neatherlands)

Managed monthly EMEA (22 countries) management reporting in COPA and prepare/distribute periodic EMEA dashboards to senior managementDeveloped and automated an effective process of EMEA Financial data integrity between SAP modules and ensure that all issues are adequately identified and driven to closure by working with relative country finance teams and IM teamLed the projects for System and process implementation Act as COPA reporting lead for EMEA countries, focusing on delivering the COPA framework to deliver an enhanced management reporting at Brand/product/customer level for revenues to gross margin and key contact for finance/IM teams to identify finance issues and coordinate with IM to advise/implement solutionsSupervise maintenance of Product, customer, profit centre and cost centre hierarchies to synchronize with global hierarchy to support global weekly/monthly reporting Lead EMEA country teams to ensure budget data is captured into SAP for CCA, PCA and COPA modules for financial analysis and supervise them to resolve issues relating to budget preparation/data load processStreamlined the “Assessment Cycles” process for EMEA countries by ensuring “Cost Centre” costs are 100% allocated to COPA for “Profit Centre” periodic reporting and driving country owners to update cost centre/cost element groups and cycles periodicallyWorked with European teams to implement standardised COPA reporting that includes uniformed Cost Centres, Profit Centers, Customers and Products hierarchies in SAP, a monthly report is circulated to highlight noncompliance areas/countries to ensure control is maintainedManaged rebates and allowances process/models in SAP and interacted with country business partners to implement rebate modelsDevelop training material and provide training/ functional support to financial planning and analysis (FP&A) users on financial reconciliations and month end P&L reporting across the EMEA countries

Slough, United Kingdom

Acting as COPA UK reporting lead, focusing on delivering/implementing the COPA framework to deliver an enhanced management reporting processLiaise with central implementation team and the project management team to ensure finance users requirements are fully captured and in scope of system developmentOrganising and being involved in local requirement gathering, build up phase, integration testing, training, UAT, migration and deployment phasesEmbedded SAP assessment cycle process for UK to ensure cost in all cost centers/elements are fully allocated to profitability segments to provide profitability by SKU in SAP COPA up to EBITDevised reconciliation process for financial/management accounting month end between various systems/modules (SAP FI/COPA/BI) for volume, sales, COGS and all other lines up to GM to threshold of 5KTraining/communicating finance team users to include SAP COPA characteristics in all the posting to provide P&L visibility at granular level i.e lowest level customer and productManaging customer and product hierarchies to ensure they are aligned in all systems with updated hierarchies to provides robust reporting, to support this new process was built to capture correct customer/product attributes by all systemsSupporting finance end users with post go-live activities including month-end closures Built financial model to break down COGS into components providing senior management an in-depth view of cost fluctuations and enabling accurate forecasting and variance analysisBuilt robust model to calculate bottom-up per-litre costs for SKUs for quarterly forecasts and annual budget. The improvised approach helped apply inflation assumptions accurately at desired level(s) resulting in an increase in forecast accuracy of up to 15%Prepare and report customer and product profitability (GM) for monthly commercial meetings

Slough, United Kingdom

Run month end actual data load process, reconcile SAP and Cognos to ensure data integrity in both systems and ensure month reports are delivered to business community timelyBuilt Marketing Dashboard, a one-stop tool for the senior management to analyse impact of promotions, advertisements, potentially slow-moving SKUs etc.Worked with sales and marketing teams to standardised/eliminate duplicate reporting to reduce the pressure on FP&A team and save 12-man hours a monthRan, maintained and improved 24-month rolling forecast process in Planning models & BI platforms.Prepared month-end and forecast management reports for senior management, including Customer and Product Profitability Reports, Rebate Reports, Trend Analysis etcLed fixed costs forecasting model development project which includes analysis, scope, design and implementation and post implementation reviewsWorked with Financial Reporting Manager in building and automating suit of cost centre reports for senior management.Led integration project of Dulux Trade Business (DTB) with Dulux Decorating Centre which includes interfacing different system to get actual data, building month end process, reporting consolidated numbers and designing & development of rolling forecast application in CognosDevised reconciliation process and reviewed anomalies in raw margin data between SAP SD, SAP FI and Cognos Powerplay improving data integrity and reducing monthly mismatch threshold from £80k to £10kReconciled month-end results in SAP CO by profit centre and G/L with Cognos Planning. Ensured accuracy of P&L structure and mapping between SAP, Cognos and HyperionManaging customer and product hierarchies to ensure they are aligned in all systems with updated hierarchies to provides robust reporting, to support this new process was built to capture correct customer/product attributes by all systems

Designed, developed and implemented a suite of Cognos Enterprise planning applications for commercial Finance (CF) teams covering stores, channels and products. Models are used by more than 125 users in the companyAutomated rollover of Sales, Stock & Intakes application on weekly basis to improve inventory control processRedesigned Cost Centres (CC) forecast models covering 150 CC and 3000 employeesRe-engineered all planning models, re-aligning them with the new SAP GL systemResponsible for preparing group budgeting and forecasting processFinalising and Consolidating UK and Ireland Budget/STFResponsible for creating STF/Budget timetable and managing workflow for “STF/Budget Progress” & communicating weekly updates to business communityLiaising with senior management to conduct Post STF/Budget reviews and recommending where planning can be improvedAssist in preparing 5 year plan and ensuring budget is in line with 5 year planBuilt suit of commercial forecast reporting reflecting sales, margin, average retail price and volume performance against actualsProduced training material & conduct training courses for Cognos users to ensure a standard level of user competence within the CF teamManaging period end Flash process for UK & Ireland to ensure accurate reporting and commentary is delivered to senior managementPreparing various commercial and cost centres ad hoc reporting for finance directorMonth end management reporting, preparing presentation slides with KPIs for operational review meetingsOwnership of weekly Net Margin reporting

Analysis of sales, margins & volumes generated by chains, channels and stock typesComplete ownership of all Cognos Enterprise planning Applications, ensuring all models are ready for next round of budget/STF Liaison with business users to discuss system issues & improvements which can be made to systems to facilitate users in future, improve and automate budget and STF processesWorking with Cognos report expert to deliver Commercial and financial reporting in Report Studio including building Framework Manager ModelsSupporting 200 users and ensuring that user issues & queries are resolved in a timely mannerEnsuring Cognos Licenses are well controlled and liaising with IBM to discuss Licenses and system issuesAutomation using macros to drive overnight processes plus development of menu driven front ends for minimal ongoing maintenanceProducing financial forecasts and re-forecasting together with budgets and variance analysis thereof.