Power BI
Ilayda Avunduk
Area Business Controller
Istanbul
Summary
Forward-thinking Financial Controller excited to bring 5-year background new organization. Expert in setting financial targets and devising strategies to improve internal controls, standards and processes. Successful in advising business executives on financial strategies driving short-term and long-term growth.
Overview
6
6
years of professional experience
9
9
years of post-secondary education
1
1
Certification
2
2
Languages
Work History
Business Controller
Maersk - Hybrid
Istanbul
08.2022 - Current
Have been Star awarded in 4th Month of my experience in Maersk for transforming all KPI follow up and GP Review’s to Power BI for 5 Country and Products
- Optimize Finance and Customer Experience KPIs, ensure backlogs are effectively kept low and in control
- Ensure monthly risk assessment and control performances are 100% in compliance
- Proactive review and action to mitigate key and critical risk area
- Actively support E2E Control compliance and process improvements through close cooperation with Customer Experience, Area Finance, Global Service
- Ensure job costing controls are followed
- Minimize and control the manual accruals, improving its accuracy
- Local ICB&ICP anchor resolving open and aged items in line with the timelines - Finance Governance on new or adjusted customer / system / supplier / project implementations
- Business partner to Management to identify and drive resolution of revenue/costs leakages
Senior Financial Controller
Moore Global
Istanbul
03.2022 - 08.2022
- Working directly with Moore.llc’s chairman “Sanzar Kakar”
- Managed daily financial functions in collaboration with accounting and payroll personnel.
- Working together with PR team and calculating Project costs especially for companies in U.S.A and Turkey.
- Responsible of the cost accounting of Sanzar Kakar’s personal assets and cash movements in 4 different countries.
German Audit Team Leader
PwC
Istanbul
07.2020 - 03.2022
- Responsible of the planning part of Audit, Tax and Advisory projects of PwC Germany
- Leading Turkish Financial Reporting Standards process and being the function as a bridge between client and Associate
- Responsible of the Power BI & Alteryx projects for the clients of Tax Germany
- Responsible of the review processes and planning operative duties
- Leading and organizing a group of including 5-7 processors
- Lead of the HGB(German Commercial Code) and IFRS training processes
German Audit Reviewer
PwC
Istanbul
05.2019 - 07.2020
German Audit Consultant
PwC
Istanbul
09.2018 - 05.2019
IFRS16 Project Intern
PwC
Istanbul
07.2018 - 09.2018
Long Term Factory Controlling Project Student
B/S/H
Çerkezköy
11.2017 - 07.2018
- QPR Data entries and analyses
- Daily checking and confirming purchase orders
- Monthly ratio calculations for material
- Supporting month end closing reports, especially overhead reports and headcount reports
- Supporting Plan-Actual Deviation explanations
- Supporting seasonality periods
- Supporting annual budget periods
- Supporting EVA calculations for new product projects
Summer Intern
DenizBank
Istanbul
06.2017 - 08.2017
- Supporting and tracking SME credit structures
- Daily checking and rating the interest rate on deposit
Education
Bachelor’s Degree - Business Administration, German Language
Marmara University
Istanbul, Turkey 05.2013 - 05.2018
High School Diploma -
Süleyman Nazif Anadolu High School
Istanbul, Turkey 05.2009 - 05.2013
Skills
Team Lead
Budget, Planning and Analyzing
IASB – IFRS knowledgeSAP – MM&FI ModuleKPI Follow Up
Local GAAP Knownledge
P&L Analyse
Accomplishments
Maersk
- Star awarded(given only to one person in each team if there is a big impact to the company) in 4th month of my experience for automatizing all KPI's(ICP,ICB, Suppliers Work Flow, Unbilled Sales Orders) and Job Costing reports(which we could identify missing revenue/costs, revenue leakages and loss making customers and shipments, automatized material code check to prevent leakages between products) for 5 countries.
- By weekly and daily KPI dashboards BCO can identify the backlogs/route causes of the stableness and push the regarding teams, as an example due to wrong amount an ICB amount has been identified by the first day and the related team has been pushed to clean the backlog on the same day.
- Reduced the amount/percentage of past period impact (percentage difference = 33%)
- Accrual process and the importance is clearly transferred to FINOPS and made them to calculate the accrual lines for each month. With this awareness pushed CX to calculate all risks such as canceled invoices.
PwC
- Was the first consultant of the new team who learned each activity and taught to the new joiners.
- Supervised team of 7 staff members
- Gained new Clients by introducing Power BI Dashboards and trained 7 staff to provide Dashboards to Clients from Germany, Austria and Switzerland.
Software
Microsoft Excel
Alteryx
PowerPoint
Certification
Local CPA Intern
Timeline
Business Controller
Maersk - Hybrid
08.2022 - Current
Senior Financial Controller
Moore Global
03.2022 - 08.2022
German Audit Team Leader
PwC
07.2020 - 03.2022
Local CPA Intern
01-2020
German Audit Reviewer
PwC
05.2019 - 07.2020
German Audit Consultant
PwC
09.2018 - 05.2019
IFRS16 Project Intern
PwC
07.2018 - 09.2018
Long Term Factory Controlling Project Student
B/S/H
11.2017 - 07.2018
Summer Intern
DenizBank
06.2017 - 08.2017
Bachelor’s Degree - Business Administration, German Language
Marmara University
05.2013 - 05.2018
High School Diploma -
Süleyman Nazif Anadolu High School
05.2009 - 05.2013