Business Analyst
Pernod Ricard Gulf
Total years of experience :9 years, 2 Months
Assisting the Chief Financial Officer in preparing management reports as well as forecasts. Participating in the preparation of budget and business plans by gathering, processing and analysing information, as well as developing analysis as required whilst further developing reporting / decision-oriented tools and internal control.
Duties & achievements
• I have successfully estimated (B/LE's) and timely delivered monthly reporting on P&L by market by brand and cash
• I have ensured full reporting in PRISMA (PR group reporting tool) to Asia/Holding
• Tracking and understanding volume performance: sell-in vs. sell-out, brand/ channel/ Cust-mix
• I have supported both sales and marketing/Operations in terms of solution oriented tools and upgraded KPI's analysis tools.
• I also frequently coordinated with regional office for reporting requirements
and assisted CFO in ad hoc reports/projects
1st-Key achievement:
I have analyzed and reconciled the existing reporting structure matching the new year Marketing Budget from SFM (Sales force Management tool) usually monitoring by Marketing Managers Vs PRISMA (PR group reporting tool). Achieving therefore consistency and harmonizing Sales, marketing and finance outlook to reflect JD Edwards (Accounting integrated ERP).
2nd Key achievement:
I have successfully predicted, measured, planned, revised and reported Marketing and Sales Budget including Cash flows into PRISMA with respect to (1)-Initial Budget (2)-Revised Budget (3)-Actual Budget (4)-Forecast/ Outlook (5)-Actual reporting.
Nature & Scope: All markets All brands/Regional exposure - Asia Holding
ERP’s Experience: SFM (Marketing /Sales/ Finance), HFM-PRISMA (Reporting) & JD Edwards (Accounting). OBIEE Oracle Business Intelligence with ESS Base.
As a Purchasing and Logistic clerk I was responsible for providing financial and administrative order to ensure efficient and accurate financial and administrative operations. My main areas of responsibilities were invoicing, procurement & logistics.
• I used to maintain files and documentation thoroughly and accurately, in accordance with company policy and accepted accounting practices
• I consistently processed 3 way P.O. matching invoices, up to 100 plus line items
• I have planned and prioritized invoices according to cash discount potential and payment terms.
• I used to process and raise and record cheques.
• I have managed the weekly cheque run.
• I have effectively prepared batches of invoices for data entry.
• I have ensured a proper data entry for invoices for payment.
• I have monitored and processed backup reports after data entry.
• I usually responded to several vendor inquiries on daily, weekly basis.
• I have successfully reconciled vendor statements, investigated and corrected discrepancies using proper reconciliation standards.
Key achievements:
A-Firstly, I was instrumental in ensuring a smooth month end closing, a key partner to almost all departments.
B-Secondly I had an average “AQSR 084”. i.e. Getting a permanent efficient solution to vendor/customer queries on time, the 2nd best Average Query Solving Rate of 84% (14% above the standards).
Nature & Scope: Local Market / All Brands / Country wise.
ERP’s Experience: Citrix Boxi, Micros-Oracle, QuickBooks (Accounting)
Reporting into the Senior Business Performance Manager, I was responsible for effective tracking and recording all aspects of A&P spends and Accounting at regional level, cluster of African regions, ensuring complete accuracy and compliance with Company & local statutory requirements
• Focusing on advertising and Marketing promotions I was giving insightful details of marketing spend, campaigns and brands
• I was instrumental in validation of budget on day to day basis and monitoring in trackers i.e. Achieving “preventive controls” prior to any spend to avoid any budget unauthorized overspent.
• I was reviewing monthly actual spends and future month forecast with Marketing managers and Marketing director to ascertain real spend and perform journal adjustment i.e. “Detective Control” to confirm expenditures
• I have cross checked and ensured marketing account balances in SAP reflects true and fair value (Reallocation, correction, forecast)
Key achievements
1-I have monitored and effectively controlled advertising and Promotional cost over market hub (Cameroon, West Africa, Central Africa).
2-I have broken down overall marketing AOP (Annual Operating Plan) into manageable activities by market, by brand by category to give insightful details about business performance in a timely and accurate manner.
3-I have received several certificates, awards and recommendations in the 6 years spent in Diageo and the most outstanding were Diageo Finance Capability Certificates and the IFQA @ Global level
"International Finance Quality Awards" awarded by Richard Miles Finance Director International in year 2010 & 2011.
Nature & Scope: All markets All brands/Regional exposure - Africa /UK Holding
ERP’s Experience: Citrix, SUN Systems, SAP (FI-CO) ...