Post Job Free
Sign in

Financial Analyst Microsoft Office

Location:
Calgary, AB, Canada
Posted:
August 31, 2018

Contact this candidate

Resume:

Saheed Ajani

Canada ************@*****.*** 431-***-****

PROFILE

Competent & strategic treasury, investment, accounting and financial analyst with more than 6 years of experience in financial service, manufacturing, trading, mining & energy (oil & gas, power) sectors. Currently a level 2 candidate in the CFA program as well as a candidate in the CMA program. Demonstrated exceptional teamwork, positive attitude, relationship management as well as facilitation, leadership and presentation skills. Have a disciplined and solution-oriented approach and zest for shaping challenges into concrete achievement

EDUCATION AND PROFESSIONAL QUALIFICATION

Master of Arts in Economics (Degree) Aug 2014 - Oct 2015

University of Manitoba, Canada

Bachelor of Science in Economics (Degree) Nov 2006 - March 2010

Obafemi Awolowo University, Nigeria

Chartered Financial Analyst – CFA Institute

Level 2 Candidate (Level 1- Passed)

Certified Management Accountant - CMA

Candidate

SKILLS & COMPETENCIES

Strong proficiency in the use of Microsoft office tools (Word, Excel, PowerPoint and Visio)

Advanced Excel Skills: Pivot, VLOOKUP, Formulas, Macros, Sorting, Formatting and Filtering

Good user of Oracle (ERP etc.), SAP, SQL, Simply Accounting, & Microsoft Dynamics GP

Frequent user of Bloomberg and Reuters market/financial indicators and analysis

Strong research, valuation, quantitative and analytical skills as well as knowledge of IFRS & GAAP

Financial analyst with broad experience in all aspects of accounting, treasury, investment & finance

Financial and budget reporting; Financial planning & analysis; Financial modelling & forecasting

Business performance reporting; Variance analysis; Budget planning; Cost optimization

Consolidation of entities for group financial reports & Inter-company and account balances reconciliation

Cash & treasury management; Corporate finance & reporting; Regulatory and compliance reporting

Broad knowledge of financial credit products (Trade, Debt, Insurance and Contingent Instruments)

Broad knowledge of financial markets & instruments as well as derivative/hedging instruments

Project/Credit/Risk evaluation, analysis and management; Equity & Debt investment management

Investment and Economic analysis; - Risk analysis, ESG analysis, NPV, IRR, MIRR PBP, DPBP, ROIC

PROFESSIONAL EXPERIENCE

Treasury Analyst – Treasury, Investment and Corporate Finance April 2018 till Date

Motor Coach Industries (MCI), Canada – (TSX: NFI)

MCI is a member of New Flyer Group-NFI and listed on the Toronto Stock Exchange. NFI is a Canadian multinational automotive company specializing in the manufacturing of heavy-duty transit buses, motor coaches and distribution of aftermarket parts. With presence in USA, Canada etc.

Key Responsibilities & Achievements

Manage all banking relationships & transactions (Manage User Access on Various Banking Platforms)

Manage the company’s cash liquidity requirement through daily, weekly & monthly cashflow forecasting; Consolidate regional cash reports and monitor compliance with Finance policies as well treasury procedures

Prepare detailed short and medium-term financial & cashflow forecasts as well as credit obligations

Maintained the accuracy of spot and forward deals for currency & interest rate derivative instruments, including forwards and swaps as well as maintained mark to market model & reporting risk positions

Prepare schedules and related journal entries: - long & short-term debt payments, accruals, interest rate calculation, credit (loan) drawdown, money & capital market investments, derivative & hedging transactions, capital expenditure, insurance premium & claims and treasury-initiated banking transactions

Appraise, analyse, and review the company’s credit (Loans) obligations: - working capital & capital project; Participate in counterparty credit reviews and manage credit/tenor limits in the Oracle ERP System

Participate in Investor Relations activities; Prepare materials for debt & equity investments; Involve in capital management (debt & equity) & capital account reporting as well as prepare all rating agency materials

Prepare and coordinate documents for letters of credit, credit applications & other debt instruments

Analyze bank fees, interest payments and recommend areas for cost savings; Initiate wire payments, ACHs and execute foreign exchange transactions; and invest excess cash in financial instruments

Responsible for ensuring all tax payments are processed in a timely manner, confirm all FX and investment trades with appropriate counterparties & complete reconciliations and backup for all transactions/payments

Prepare monthly reports for each business unit including actual & forecast results, variance analysis & narrative write up, as well as prepared monthly budget performance reports & analysis

Assist in the coordination and execution of financing arrangements and shareholder return programs

Prepare schedules and track all production revenue, leases, receivables, payables as well as manage the master data of assets, revenue, leases, costs and profit centers for all business units

Participate in the development of complex financial models to support financial valuation of business opportunities, potential mergers, acquisitions or divestitures, and assist with other duties as required

Senior Financial Analyst – Financial Reporting & Corporate Planning Nov 2015 – Mar 2018

Stallion Group of Companies, Dubai; UAE

Stallion Group is a diversified multinational company, headquartered in Dubai-UAE, & business interest in Manufacturing, Trading, Mining & Energy (Oil and Power). With business presence in Africa and Asia

Key Responsibilities & Achievements

Prepared the group’s management accounts (P&L, Balance sheet), financial notes, financial ratios, financial models and analysis; monthly trial balance; balance sheet account reconciliations; and contributed to the preparation of quarterly & annual financial statements & disclosures

Prepared monthly management reports for each business unit including actual & forecast results, variance analysis & narrative write up, as well prepared monthly budget performance reports & analysis

Prepared schedules and tracked all production revenue, leases and royalties as well as managed the master data of assets, revenue, leases, costs and pricing & profit centers for the energy business – (Oil & Gas)

Prepared Capital Assets report through the entry of fixed asset additions and disposal as well as calculation of monthly depreciation; Prepared audit work papers & coordinated interim and annual audits

Prepared month end closure report, advised on closing journal entries, reconciliation status, provisions and various account balances such as cash ledger balance, inter-company balance, payables, receivables and other sub account balances; Performed in-depth review and tie-out of the financial reporting package

Prepared & reviewed schedules and related journal entries: - long term debt payments, accruals, interest rate calculation, credit drawdown, short & long-term investments, and treasury-initiated banking transactions

Prepared the group’s financial, regulatory, compliance and performance reports for internal/external users

Participated in Investor Relations activities; Prepared materials for debt & equity investments; Participated in capital raising (debt & equity), capital restructuring & capital account reporting

Managed the group’s financial and currency risks through hedging and insurance instruments as well as managed investment related transactions such as money and capital market instruments

Prepare necessary economic and financial indices (i.e.: Investment Analysis, Economic Analysis, Risk Analysis, ESG Analysis, NPV, IRR, MIRR PBP, DPBP, ROIC etc.) for capital project/investment appraisal

Developed and maintained complex financial models to support financial valuation of business opportunities, potential mergers, acquisitions or divestitures, and to support senior management decision making

Developed revenue assurance & earning models for reviewing top-line revenue items and earning quality

Analyst – Investment, Credit and Treasury Services Jan 2012 – July 2014

Guaranty Trust Bank Plc, Nigeria – (NSE: GTB & LSE: GTB)

GTB is one of the top tier financial institutions in Africa, head-office in Nigeria and listed on both London and Nigeria Stock Exchange (LSE; NSE). GTB is a multinational bank, with business presence in Africa and Europe

Key Responsibilities & Achievements

Prepared financial models, financial analysis & investment analysis for specific debt financed projects e.g. Dangote Refinery & Petrochemical Company($3bn), Seven Energy Group($1bn), Prime Pak($50m)

Prepared monthly business performance reports, loan syndication reports & budget performance review

Analyzed clients’ historical and projected financial statements for project/credit evaluation & assessment, as well as valuation of corporation’s cashflow, debt, equity, derivative hedging & short-term investments

Performed counterparty credit reviews and manage credit/tenor limits as well as collateral in the Credit Risk Management System – CRMS; Performed as required collateral valuation via fair value/present value

Performed capital raising for clients; equity and debt via money and capital markets – commercial papers, banker acceptances, certificate of deposits, bonds, debentures, right issues, private equity funds & ETFs

Prepared simulation & financial models related to debt financing and financial risk management strategies

Banking operations (Currency Trading, SWIFT Funds Transfer, Account Opening, Letter of Credit Issuance, Bills for Collection Processing, Foreign Exchange Operations, Cash & Treasury Management etc.)

Performed business & financial advisory to corporate organizations with annual turnover of $1million and promoted alternative & structured investment product sales, and increasing clients’ penetration

Project/Credit appraisals, assessment and analysis-: working capital financing, capital project financing, international trade financing (LCs, BCs, Form M etc.), bonds and guarantees, loan refinancing and loan restructuring; managed portfolio of about $100 million with zero percent delinquent loans

Managed funds in excess of $100million in diverse range of financial instruments on behalf of clients with weighted average returns of at least 2% above inflation rate: - local and foreign currencies

Clients’ Relationship Management – sales of capital & money market, debt, trade & contingent instruments

Prepared quarterly research on Nigeria’s economic & industrial outlook as well as global market report

Member of the bank’s strategy team that worked with KPMG to design the bank’s African business expansion model – 2012; Actively involved in the bank’s 70% M&A transaction of FINA bank in Kenya; Actively involved in the bank’s tier 1 & 2 capital raising – Corporate Eurobond $500m & Global Depository Receipt Shares

Treasury & Finance Analyst April 2010 – Dec 2011

Stallion Group of Companies - (Multinational & Conglomerate - Manufacturing, Trading, Mining & Energy)

Key Responsibilities & Achievements

Managed all banking relationships & transactions (Managed User Access on Various Banking Platforms etc)

Appraised, analysed, and reviewed the group’s credit (Loans) obligations: - working capital, capital project, international trade, and bonds & guarantees: - local & foreign currencies

Contributed to Investor Relations activities as required, such as financial reports & analysis, corporate governance & operation reports, research report as well as prepared all rating agency materials/documents

Prepared detailed short and medium-term financial & cashflow forecasts as well as credit obligations

Managed the group’s cash liquidity requirement through daily, weekly & monthly cashflow forecasting

Responsible for the management of cash balances and wire transfers; ensured all treasury payments were made, all treasury accounts were adequately funded, and excess cash was appropriately invested

Maintained the accuracy of spot and forward deals for currency & interest rate derivative instruments, including forwards and swaps as well as maintained mark to market model & reporting risk positions

Prepared confirmations and settlements of various treasury transactions – local & foreign currencies

Prepared and coordinated documents for letters of credit issuances, credit applications & debt instruments

Prepared schedules and related journal entries: - long term debt payments, accruals, interest rate calculation, credit drawdown, short & long-term investments, and treasury-initiated banking transactions

Prepared analysis of accounts receivable & payable; Performed reconciliations for accounts receivable & payable, sub-ledger accounts, and intercompany receivable & payable transactions

Prepare necessary economic and financial indices (i.e.: Investment Analysis, Economic Analysis, Risk Analysis, ESG Analysis, NPV, IRR, MIRR PBP, DPBP, ROIC etc.) for capital project/investment appraisal

Assisted in quarterly & annual financial reporting activities; and supported special projects as required

Managed and participated in the implementation of the company’s SWIFT payment system reducing the company’s bank charges by $2 million annually



Contact this candidate