Mehmood Mohsin Ansari, Sr. Consultant – Anaplan (FP&A)

Mehmood Mohsin Ansari

Sr. Consultant – Anaplan (FP&A)

Joannou & Paraskevaides (Overseas) Limited

البلد
المملكة العربية السعودية
التعليم
ماجستير, CIMA
الخبرة
11 years, 3 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :11 years, 3 أشهر

Sr. Consultant – Anaplan (FP&A) في Joannou & Paraskevaides (Overseas) Limited
  • المملكة العربية السعودية - الرياض
  • أكتوبر 2015 إلى يونيو 2019

Reporting To: Financial Controller
Job Tasks & Responsibilities
 Successfully implemented Anaplan, worked closely with Financial Controller as subject matter expert in financial & performance
management systems. It enhanced easier assessment of J&P footprints regionally giving a broader perspective to top management,
making resource planning processes and financial management effective & efficient.
 Ensure availability and consolidation of periodical management reports, including reports on project overheads, B2B contributions
and allocations (i.e. Head Office & Branch Overhead, Site on Cost, Labour, Inter Project Trfs, and General Funding etc).
 Track general ledger accounts and FMS bank elements identifying reporting gaps between treasury & accounts, ensuring accurate
cash flow and liquidity position per bank account.
 Prepare Cash flows to completion of projects and forecasting liquidity. Forecasting project revenue & expense based on s-curve
provided by project managers.
 Identify cost efficiencies by proactive management of vendors, materials and labour.
 Integrate all systems and processes of project valuations, cash flow and liquidity management, including loan management, payment
management, budgeting and planning ensuring end to end value tracking.
 Prepared Anaplan modules, dashboards, lists, actions (import process) and reducing sparsity by effectively using guidance from
Anaplan’s best practices.
 Maintain strict management of system access, privileges, version control and overall system integrity.
 Responsible for the monthly data reconciliation/upload to Anaplan to ensure data accuracy and consistency.
 Models prepared in Anaplan:
 Cash flow (Forecasting Labor/Material/Admin/Operating Expense etc.) Model  Cash Liquidity (Payment Strategies/Aging - Vendor,
Project, Bank, Client/Working Capital/ Valuations (Project Report/Feasibility/S-Curve) Model Investment) Model
 Bank Liquidity (Loans/Repayments etc.) Model  Compensation & Benefit Model
 Cashiers (Petty Cash) Model  IFRS Financial Consolidation (Currency Translation) Model

Sr. Financial Analyst / Modeler في Ma’aden Aluminium Company
  • المملكة العربية السعودية - الجبيل
  • يوليو 2012 إلى ديسمبر 2013

Reporting To: Director Treasury / Finance
Job Tasks & Responsibilities
 Participated in the preparation of various periodic reports, company’s annual budget and assisted in the preparation of the annual business plan
 Prepared a variety of executive reports for management information & control purposes. Also prepared flash reports for prompt review of management
 Reviewed/analysed actual operating costs report vs. plan and provided explanations for variances
 Prepared/analysed periodical cash position, and was actively involved in Murabaha investments
 Responsible for managing the risk of investments as per company policy
 Developed liquidity requirement sheet focusing on cash utilization from project
 Estimated/analysed the working capital requirements
 Analysed the inventory quantity for comparison and investigates any differences
 Analysed various accounts as directed, monitoring the accuracy and advises adjustment in reporting
 Defined/implemented the company’s funding strategy including debt structuring
 Prepared strategic guidelines for transformation of treasury department
 Was responsible for on-going implementation of Oracle Hyperion Financial Management 11 in treasury department
 Prepared financial model for smelter plant, rolling mill and mine & refinery
 Prepared cash flow & loan management model covering Wakala, Procurement, Commercial SIDF & PIF facilities both USD & SAR.
 Also analysed Common Term Agreement (CTA) & financial agreements of the facilities.

Officer- Financial Support في Abu Dhabi Education Council
  • الإمارات العربية المتحدة - أبو ظبي
  • فبراير 2012 إلى يوليو 2012

Reporting To: Head Licensing Department - Line Supervisor(GM)
Job Tasks & Responsibilities
 Critically analysing the financial models for ‘new schools applications’ & ‘fee increase models for existing schools’.
 Preparing analytical & group comparison reports for new schools, villa extension schools, and curriculum & grade extension schools for technical & assessment committee meetings.
 Checking compliance & authentication of financial statements, supporting documents & financial templates.
 Establishing & updating benchmarks & key performance indicators.

Senior Consultant - Corporate Finance في Sajjad Haider & Associates (Management Consultants)
  • الإمارات العربية المتحدة - دبي
  • فبراير 2009 إلى يناير 2012

Reporting To: Chief Executive Officer
Job Tasks & Responsibilities
 Business Advisory: New Set up, Merger, Acquisition, Divestiture, Joint Venture, Strategic Alliance (Financial Feasibility Study,
Financial Modelling, Financial Planning & Budgeting, Business Valuation, Business Strategy, Due Diligence, Information
Memorandum, Market Research).
Projects Completed
 Emirates Dome - Mixed Used Residential Project (Proposed Project)-A project of Gary Goddard (http://www.legacyentertainment.com/)
Proposed project is world largest Indoor Climate Control Dome.
- Prepared component wise and integrated financial model of the project.
- Prepared business strategy report & market research report.
 Lotus Ocean City - Mixed Used Residential Project (Proposed Project)-A project of Sky Noor Ltd. (http://skynoor.com/LotusOverview.html)
World largest planned City (i.e. 6.1 km2); the site is located in Sri Lanka.
- Prepared component wise and integrated financial model of the project.
- Prepared business strategy report & market research report.
 Enfinity Middle East Limited (http://www.enfinity-me.ae/)
- A solar energy based financial model with extensive mathematical calculations, Scope of the work includes validating the
mathematical accuracy of a financial model.
 Samar Euro Beverages
- Worked partially on the financial model, conducted business valuation & prepared financing plan of the project financial
model.
- Partially involved in the preparation of the information memorandum & business strategy report of the project.
 E-Marine (Etisalat) Sub Marine Cable Project: Competitor Analysis for regional expansion
 RTA Bus Route: Feasibility Report
 UAE School: Information Memorandum & Business Valuation
 Cooling Tower Manufacturing / Importing UAE: Concept Paper & Market Research Report
 Ice Cream Franchise Business UAE: Concept Paper & Market Research Report

Senior Financial Analyst في Motiwala Securities (Pvt.) Limited
  • باكستان - كراتشي
  • نوفمبر 2007 إلى يناير 2009

Reporting To: Chief Executive Officer
Job Tasks & Responsibilities
 Preparing financial models, research papers & reports on Fertilizer, Cement, Oil & Gas Exploration & Marketing sector.
 Liaison with trading team & facilitating them for investor's queries.
 Liaison with SECP auditors & facilitating them in the audit of research department, ensuring compliance to rules & regulations.

Financial Analyst في National Fullerton Asset Management Ltd. (NAFA) - http://www.nafafunds.com
  • باكستان - كراتشي
  • يونيو 2006 إلى سبتمبر 2007

Reporting To: CEO, Investment Committee and Head of Equity & Research.
Job Tasks & Responsibilities
 Responsible for in-depth analysis of conglomerate companies & relative sector, identifying revenue & cost drivers, analysing financial
statements, Ratios, preparing financial models & recommending potential stocks for investment.
 Responsible for analysis of mutual fund industry (Equity Funds, Balanced Funds & Cash Funds).
 Liaison with SECP auditors & facilitating them in the audit of research department.

الخلفية التعليمية

ماجستير, CIMA
  • في Chartered Institute of Management Accountants (UK)
  • ديسمبر 2015

CIMA (Strategic level -Student)

دبلوم, Diploma in IAS / IFRS
  • في Institute of Cost and Management Accountants of Pakistan (ICMA Pakistan)
  • ديسمبر 2014

Diploma in IAS / IFRS

دبلوم, Cost Accountant
  • في Institute of Cost & Management Accountants of Pakistan
  • ديسمبر 2013

Student ACMA “STAGE – 4”.

ماجستير, Finance
  • في SZABIST
  • ديسمبر 2003

Specialties & Skills

Financial Modeling
Corporate Finance
Budgeting
Business Planning
Feasibility Studies
Anaplan
MS-Excel
MS Office
Reuters 3000Xtra

اللغات

الانجليزية
متمرّس
الأوردو
متمرّس

التدريب و الشهادات

IFRS / IAS DIPLOMA (الشهادة)
تاريخ الدورة:
June 2015
Certified Anaplan Model Builder (الشهادة)
تاريخ الدورة:
April 2016
Financial Modeling (تدريب)
معهد التدريب:
“Computer Infinity"— (ICMAP 12 credit hours)
تاريخ الدورة:
August 2008
Treasury Management (تدريب)
معهد التدريب:
“Niche Pakistan”
تاريخ الدورة:
August 2008
Security Analysis (تدريب)
معهد التدريب:
“Institute of Business Administration”
تاريخ الدورة:
January 2006