Muhammad Touseef Farhan
Financial Accountant Analyst
Dubai
Summary of Career
1. Reporting to the Finance Director and Board.
2. Planning and budgeting Complete Revenue and cost centres with direct P&L impact.
3. Advanced Excel Expert (Reporting, Templates, Pivot, Slicer, dashboards, VB, macros, Power Pivot Data cubes, Query, Modelling, etc.)
4. Hands-on experience with Valuation Techniques NPV IRR Discounted Cash-flows etc.
5. Consolidation of Financial Reporting.
6. Demand Planning for Brands ( According to Sale trends, Confirm orders, Seasons and growth)
7. Divisions/ Segments/ Investors Analysis Via ABC costing using right Cost drivers and Cost centres. Presenting Actual profitability of Segments.
8. Managing Actual vs Budgeted (Variance analysis) Suggesting measures to control variances. (Sales Purchase PNL BS CF CAPEX OPEX etc.)
9. Monthly and Ad hoc Inventory reporting Holding periods inventory aging, ratio analysis
10. losing Monthly, Quarterly, and Annual Accounts. (PNL BS, Indirect cash Flows) and Presenting to Directors
Experience as Planing and Analyst FP&A
EGMA Optical Group
05 February 2019
30 November 2019
Budgeting and forecasting Sales for Analyzing sales data of All divisions and planning visits for
sales staff for more than
550 stores across UAE.
• Analyzing brands mix and product mix.
• Suggesting brand and product focus to sales staff for improving sales.
• Generating/Analyzing account manager wise and brands wise sales & sales returns reports
against targets.
• Analyzing rebates, discounts, growth, bonus plans and incentive schemes with customers to
expand customer base in the market.
• Demand Planning for main Brands (According to Sale trends, Stocks, Confirm orders, Seasons,
growth etc.)
• Working Capital Analysis (Receivables/Payables and Inventory Ratios /Days/ Covers Analysis.)
• Preparation of Profit and Loss, Balance Sheet, Cash Flows, (Comparison in these with Historic
• Data and Budget) and Presenting to Directors.
• Follow-up with sales teams for achieving monthly targets.
• Designing refreshable report templates for Complex analysis.
• Ensuring credit Policies of receivables are being Followed.
• Stock checking with customers and make clearance plans to improve working capital.
• Develop and implement all sales activities in market.
• Records of all market visits, Action Plan, pricing, sales, and activity reports submitted by the
sales team.
• Weekly and monthly meetings with Senior Management regarding performance, new
projects, and Actions where supervision required.
• Data Visualization, PowerPoint presentations and very advanced excel Analytics.
• Automated Visual reports on Tableau and Power BI.
• Analyzing pricing and Products positioning in market
• Reviewing and recommending modifications to business process, systems and procedures.
Experience as Financial Analyst
Trucare Group
01 January 2017
05 February 2019
Budgeting and Forecasting of complete detailed expense wise PnL exceeding AED110 million.
• 200+ active Customers and 120+ Active Brands Categories.
• Monthly VAT Audit, workings and Quarterly Filling return.
• Finalizing the Monthly, Quarterly and Annual Accounts.
• Preparation of Profit and Loss, Balance Sheet, Cash Flows, (Comparison in these with Historic
Data and Budget) and Presenting to Directors.
• Reasons for Variance and Suggesting Measures to control Variances.
• Complete financial Ratio’s Analysis.
• Daily Account manager wise and Brands wise Sales and Sales returns Reports against Targets.
• Follow-up with sales teams for achieving Monthly Targets.
• Gross margin checks and report low margin to management for maintaining budgeted
profitability.
• Calculation of Sales Commissions (incentives) for target achieving teams.
• Daily, Weekly, and Monthly Ad hoc reports to Management.
• Division wise Profitability Analysis.
• Sales Team Wise Profitability reports, Key customer wise Profitability reports. (DPA, CPA).
• Stocks Aging Analysis, Holding costs and Order Level Decisions. (Maintaining OTB’s)
• Stock count Supervision and Analysis on yearly basis.
• Ensure Accounts Correct Entries, Daily Basis Checking. (Monthly Complete Internal Audit).
• Projects Appraisal, Specific Projects Budgeting.
• Working Capital Analysis (Receivables/Payables and Inventory Ratios /Days/ Covers Analysis.)
• Ensuring credit Policies of receivables are being Followed.
• Advanced Excel Trainings to other employees.
• Dealing with External Auditors
• Reviewing and recommending modifications to accounting systems and procedures.
• Implemented and Monitoring New Custom Designer Performance evaluation and Supply chain
• Software.
• Ad hoc reporting to All Directors on timely Basis.
Experience as Assistant Accounts Manager
Al Hijrah Trust
20 March 2014
30 October 2016
Joined as an Accounts officer and got promoted to Assistant Accounts Manager
at Head office.
• Data Entry & Vouching.
• Directly Reporting to CEO and Donner in both Foreign Currency ($) and PKR.
• Successfully implementing FoxPro based new Software for Accounts.
• Member of budgeting committee, Member of Audit Committee.
• Projects Appraisal, Project Budgeting & Variance Analysis.
• Bank dealings & Bank reconciliation.
• Finalizing the Monthly and Annual accounts.
• Receivables and Payables Management.
Experience as Accountant
The NGO World
01 October 2011
20 March 2014
Data Entry & Vouching.
• Directly Reporting to Accounts Manager in both Foreign Currency ($) and PKR.
• Bank dealings & Bank reconciliation.
• Petty cash handling
• Finalizing the Monthly and Annual accounts.
• Assisting Accounts manager in all Accounts Related and Bank dealings.
• Project Accounting
• Receivables and Payables Management
Bachelor 01 August 2011
B.COM from Punjab University LahoreMaster 01 May 2014
CMA Final (1 Paper Remaining)