RICHARD ROHAIL LINKEDIN.COM/IN/RICHARDROHAIL/ Cell: 647-***-****

**** **** *****, ***********, ** L5V 2W7 add1ru@r.postjobfree.com

Executive Profile

To work for a company, where my professional learning and experience could be useful to set high standards of accurate, meaningful & timely reporting with detail analysis, to achieve business targets efficiently. To utilizing my ERP & Adv. Excel modeling skills for more efficiency & accuracy. In a challenging & growth-oriented environment. Key Transferable Strengths

- Month End Closing, Analysis & Reporting - P&L, Dashboards, MBR, Flash Report, Scorecards & KPI

- Budgeting, Planning & LE Analysis - XLOOKUP, DAX, Power Pivot & Power Query in Excel

- COGS, GM% & OH Variance Analysis - Standard Costing, Project Costing & Pricing

- Trade Marketing & Sales - Dynamics 365BC, SAP(FICO), JDE, BI, Hyperion & SQL

- Payable / Receivable & Bank / LC - General Entries, Reconciliations, Audit, Schedules

- Adv. Excel, Automation & Standardization - Excel Data Modeling and Data Mining skills

- Good Communication & Team Player - Not giving up, Result Oriented & Strong Coordination Academic Qualifications

• CMA Certified Management Accountant, USA (expected completion, Jan 2021)

• MBA major Finance (Master’s in Business Administration)

• B.Com (Bachelor’s in Commerce)

• Many other Skills Development Courses

Professional Experience

Gorrie Marketing Service, Mississauga Jan 2016 – to date GMS is a global retail activation company, bringing brands to life through inspiring environments and experiences for over 135 years, has activated ideas into displays, stores, events, and experiences. Gorrie is a manufacturing and assembly of different projects for Microsoft, LG, Honda, Logitech, Best Buy, Facebook, Under Armor, Nike, Revlon in Canada, USA, Europe & Australia with $16M - $18M annual revenue https://www.gorrie.com/ Senior Financial Analyst (Finance)

• Reporting directly with Finance Controller & Managing Director to analyze and manage Business Activities

• Played a key role in migrating 60% of the data from Visual ERP to Microsoft Dynamics 365 Business Central

• Independently performed a month-end activity and reviewing & analysis of P&L Financials for Management

• Reconciling major Balance Sheet and P&L Accounts of monthly bases and preparing General Journals

• Monthly Accruals, Pre-paid, Rebates, Depreciation working and Bank & Sub Ledgers reconciliations

• Weekly preparing the Open Sales Order Report to analyze the monthly BTG with Sales & Project Team

• Project costing and pricing with Sales Team to share the new project cost with customers

• Analyze the profitability of each Project upon completion as per the Plan

• Generating & analyzing different reports for Management Plant, Project and Sales Team

• To support Budgeting process and building Internal controls & procedures

• Generating commercial invoices for Canadian, US, European & Australian customers & their aging follow-up

• Creating ODBC Excel reports from the System Data base files of Visual ERP

• Custodian of accuracy of BOM’s and their creation as required

• Creating new users, customer, vendors and different parameters in ERP Dynamics / Visual

• Played key role in standardizing, streamlining and simplifying financial models and templates utilizing Advance Excel skills including Power Pivot, Power Query, XLOOKUP, DAX, XMATCH, Macros & Consolidation etc. RICHARD ROHAIL LINKEDIN.COM/IN/RICHARDROHAIL/ Cell: 647-***-**** 1303 Weir Chase, Mississauga, ON L5V 2W7 add1ru@r.postjobfree.com

Reckitt Benckiser Group Plc. UK Jan 2008 to Mar 2014 RB is a UK based multinational consumer goods company, it is a producer of health, hygiene and home products in more than 150 countries for over 100 years. In 2018 their global Revenue was GBP 12.6B RB’s major brands are Dettol, Disprin, Strepsils, Veet, Airborne, Gaviscon, Mead Johnson, Air Wick, Calgon, Clearasil, Cillit Bang, Durex, Lysol, Mycil, Mortein, Cherry Blossom and Vanish https://www.rb.com/ Financial Analyst (Finance – Dubai & Pakistan) Apr11-Mar14

• Generating & reviewing MBR Report using BI within target dates (Flash Report & Dashboard)

• Preparation & analysis of key business Scorecards with high level comments for variances vs Budget

• Interacted with cost center managers for explanation and Contingency Plans as next steps against Targets

• Monitored & develop key KPIs for Management to monitor trends and performances

• Assisted in smooth month end closing, ensuring timely posting of all invoices, journal entries and other process

• Assisted in yearly Budget exercise, developed budget templates, assumptions and back up files, analyzed trends, assisted in LE quarterly update

• Supported Sales & Marketing Department with various monthly reports and regularly providing financial numbers for their day to day business matters

• Member of a team to Migrating data from JD Edwards to SAP

• Support respective SOX compliance initiatives within assigned cost centers

• Process improvement, standardization and automation of files using Advanced Excel Modeling Trade Marketing Analyst (Sales- Pakistan) Nov09 – Mar11

• Analyzing & suggesting the Trade discounts to get the Primary Sales Targets

• Analyzed and reported performance metrics for 200 Distributors on monthly bases

• Looking after “Go To Market (GTM)” operations – Project to increase RB direct coverage

• Member of monthly S&OP (Sales & operating Planning) Team to analyze DR (Demand Review)

• Doing financial analysis of all the Distributors

• Monitored competitor brands and suggested up-gradations in order to keep the company products in the league, while keeping an eye on the budgets

Costing Analyst (Supply Chain – Pakistan) Jan08 – Oct09

• Monthly submission of monthly Financials to region and corporate head office (UK) using JDE

• Validate & analysis the COGS part of Month-end Reporting & KPI’s

• Commented and analyzed Gross Margin for fluctuations for around 70 SKU’s (around 1200 c’SKU)

• Review & analysis of PPV, manufacturing yields, production order variance & labor variance

• Assisted in annual Standard Cost update in BOM i.e. material, labor & overhead in all cost roll-ups

• Key role in preparation of the Annual Budgets (OPEX) as well as different Project Budgeting

• Finance lead for Squeeze & NPD’s (cost optimization to improve GM%) & evaluating product Pricing

• Worked in a cross functional team project for Gross Margin improvement

• Involved in various projects which fall under the RB global transformation project

• Prepare & review monthly Slow Moving & Back Order Inventory along with excess / obsolete inventory reports

• Improved processes & automated files by using advance MS Excel modeling skills

• Key role in monthly closing activities in JDE and entertain all Adhoc requests RICHARD ROHAIL LINKEDIN.COM/IN/RICHARDROHAIL/ Cell: 647-***-**** 1303 Weir Chase, Mississauga, ON L5V 2W7 add1ru@r.postjobfree.com

The

Hiring Manager

Dear Sir/Madam,

Subject: Sr, Financial Analyst

With reference to your job posting, I am excited to apply for the position of Sr. Financial Analyst, please find my resume attached for your consideration.

I have done Bachelor in Commerce and Masters in Business Administration. I am pursuing my CMA (USA) which will be completed in Jan 2021. I have worked in the reputable companies like Reckitt Benckiser Plc and Gorrie Marketing Services (still serving). I earned excellent experience in Month End Reporting & Analysis, Standard Costing, Project Costing, Pricing and Budgeting & Planning, Reconciliations & Gen Entries, Diff Reports and analysis. I am also proficient in MS Dynamics 365 Business Central, SAP, JDE, Visual and SQL I have created excellent and powerful data modelling & automation by using my advanced MS Excel skills including Power Pivots, Power Query, DAX, XLOOKUP, XMATCH, Macros, Consolidation, Edit Linking, Goal Seek and Scenario Manager functions which enables me to do process improvement by increasing efficiency and accuracy in reports.

I am a good team player, proactive and result oriented, always ready to learn with the approach to be an asset to the company. I have excellent communication skills and like to accept challenges and solve issues. I believe my experience, education and skills makes me a solid candidate for the job and an interview call will further give me chance to prove myself as how can I be beneficial to your organization and which skill sets I have to offer.

Looking forward for your response,

Best regards,

Richard Rohail

Contact this candidate