Hi, I am Mustafa ASLAN

Financial Reporting & Business Intelligence Solutions

ABOUT

A small introduction about myself

Muhammet Mustafa ASLAN

Power BI & SAP Solutions

I am currently working as the Finance and Business Intelligence Manager of Arrow Star Group. The group provides Shipping, Chartering, Technical Management, Trading and Ship Bunkering Services.

Although, I have a background in Finance and Business Administration, I am very passionate in coding and developing. I have also had the experience of the implementation of an ERP System (SAP) as a Key User & an a Project Manager in my past carrier.

I have dealt with a large amount of available data which gave me a great opportunity to develop my skills in designing databases, coding and creating business solutions. I have a strong interest in improving systems that have influenced my career path over the past years.

My key skills are Group Accounting, Financial Reporting, SAP (FI, Co, SD, BW-BO), Microsoft Excel and Visual Basic, Power BI (M Query, DAX)

view my work

Microsoft Excel & Visual Basic

Blogger & Teacher

Microsoft Power BI / DAX / M Query

Blogger & Teacher

SAP

FI, AA, CO, SD

show skills

ABOUT ANYTHING

FUN FACTS

  • 0
    YEARS EXPRIENCE IN FINANCE
  • 0
    ANNUAL AUDIT REPORTS
  • 0
    SAP RPOJECTS (COMPANIES)
  • 0
    Tutorials & Courses

WORK EXPERIENCE

RESUME

2019 - Current

Freelance

Financial Reporting & Business Intelligence Solutions - Remote

Professional Freelancer, Self-Employed

I help my clients to build/develop a strong, reliable and most importantly last user upgradable & updatable solutions. I will be eager to diagnose what kind of solutions I would be developing for your business and free to work on the blue-print stage.

2016 - 2019

Palmali Group

Palmali Group of Companies - Istanbul / Malta

Reporting & BI Solutions manager

Managing the accounts team to deliver data sets for various reporting requirements and for specific deadlines that occur throughout the year. Designing the workflow standards and deadlines for the department ultimately, allows me to produce the following reports

Quarterly Group Consolidation & Financial Statements including over 140 companies for 3 Group Holding Levels

  • Elimination of SAP and Non-SAP Inter-Companies (BS elimination and PL Elimination)
  • Intercompany Matrix Preparation
  • General Ledger based consolidated TB’s
Annual Group Financial Model (Projection & Valuation)

Business Intelligence Reports (KPI’s & Ad Hoc Reports for presentation to third-parties such as banks or clients)

Group Direct Cash Flow

Group Asset & Obligation Reports including LTV Tests and Loan Profiles

There are also certain processes I have to enter/operate myself due to the technicality of the ERP system or nature of the specific work.

Maintaining and running SAP Asset Module
  • Amortization of the Vessels and Dry-docking
  • Vessel Acquisitions or CAPEX Process and Dry-docking capitalizations
  • Vessel or Scrap Valuations,
Calculations of the Periodic Measurements and Accrual Postings

Inter-company reconciliations

Loan Transactions

Quarterly ROB Calculations

Vessel Insurance Pro-rata postings

Process of Inter-Company Recharges

Year-End Postings such as Red Balances, Intercompany GL transfers, FX or Swap Valuations

Inter-Company recharges Consistency Tests

ERP systems Utilization Test

Non-SAP Inter-Company Reconciliations

Maintenance of the ERP System (SAP)

  • Process of Creating new Companies,
  • Maintaining Group Hierarchy and Trading Partner Information,
  • Creating Asset Master Data for the Modules FI/AA/CO/SD,
    • New Fiscal Year Customizations such as Intervals, Number ranges, Balance Carry Forwards etc.
  • Validations for SAP FI Accounting Postings,
  • Maintenance of SAP Custom Tables
  • Maintenance of Chart of Accounts,
  • Maintenance of the treasury related tables such as bank accounts, Country Controls, Swift Codes etc.

2011 - 2016

Palmali Group

Palmali Group of Companies - Istanbul / Malta

Chief of Finance Department

  • Leading quarterly preparation and consolidation of the Financial Statements of the Palmali Group of Companies (136 Subsidiaries) and managing the year-end process according to IFRSs
  • Coordinating the external auditors in their annual (year-end) audit on the financial statements of Palmali Group of Companies
  • Preparation of Palmali Group quarterly management report
  • Preparation of group obligation reports; such as Group Loan Profiles, Short Term - Long Term Obligations, LTV & VTL Tests, Calculation of Interest accruals and managing the whole accounting flows
  • Periodic measurement preparation based on voyage information (Profitability Analysis / COPA - SAP)
  • Creating and checking group inter-company balance matrix (AR-PA), Preparation of group Revenue / Expense Elimination
  • Managing monthly inter-company billing cycle which will be eliminated for the group consolidation
  • Managing group asset accounting flow (Capital Expenditures, Dry-Docking, Scrap Calculation, Vessel Revaluation, Amortization) and following up prepaid expenses for relevant assets
  • Group Insurance accounting according to group assets status and the insurance period
  • Leading and controlling of fleet cash account process
  • Preparation of logistics materials inventory information such as group vessel's remaining on board calculation
  • Compiling daily, weekly and monthly reports on the Company’s KPI’s for various areas of business & cost centers
  • Maintenance of reports and dashboards to meet the specific needs of the varying departments and teams to all levels of leadership
  • Extracting data from multiple data sources for reporting and analysis purposes

2013-2014

Palmali Group

Palmali Group of Companies - Malta

SAP Project Manager

  • Keeping up to date with current business model and processes of the company and ensuring a high quality/accurate/standard of work and service throughout, Maintenance of group hierarchy and the chart of accounts and SAP implementations.
    • Defining business scenarios and R/3 transactions to be realized in the system
    • Preparation of business process procedures and the business blueprint
    • Unit Testing & Documentation and conducting end user training
    • Guiding ABAP team for program developments
  • Preparation of project plan, organization of the project team
    • Evaluating and deciding on functional issues
    • Configuring and customizing the system
    • Training and supporting project members and users

2005 - 2011

Palmali Group

Palmali Group of Companies - Istanbul

Senior Accountant

  • Preparation of quarterly financial statements of the group companies
  • Coordinating the external auditors in their annual audit on the financial statements of Palmali Shipping SA
  • Preparation of Palmali Group quarterly management reports
  • Calculation of the Periodic Measurement based on voyage information
  • Managing monthly inter-company billing cycle which will be eliminated for the group consolidation
  • Group Insurance accounting according to group assets status and the insurance period
  • Leading and controlling of fleet cash account process
  • Extracting data from multiple sources for reporting and analysis purposes
  • Preparation of performance reports
  • Preparation of daily debt list
  • Entering the daily accounting postings according to IFRS

2004-2005

work

Palmali Gemicilik ve Acentelik AS

ACCOUNTANT

  • Entering the daily accounting postings according to TFRS
  • Issuing Revenue invoices
  • Reconciliation of receivable and payable accounts
  • Ad hoc budget reports for the local operations
  • Preparation of the export templates for the accounting software
  • Administration of the process of new company incorporations for the local entities

2005-2010

Student

Anatolian University

Student

"B", Business Administration

2012

Palmali Group

Honorary Employee

SENIOR ACCOUNTANT

  • Honorary Employee - For achieved successes in job accomplishment and conscientious effort in 2012.
  • Download resume

    Skills

    Courses

    SAY ABOUT ME

    TESTIMONIALS

    GET IN TOUCH

    CONTACTS

    Contact Info

    • Ta' Xbiex, Malta