My main area of expertise would be creating reports, reporting tools, analyses and automated calculations in MS Access and MS Excel.
Although I did spend some time in the Assembly Facility, my experience is mainly on the nuances of the Distribution Center, Transfer pricing and Intercompany transactions.
I did participate in several Internal SOX audits at Dana with full responsibility on the latest two (both rating satisfactory).
I am working for two Business Units at once, effectively doubling all work (ISVAs, AOP/Forecast planning, MOR presentations...etc.)
I have two direct reports whom with we did build up an effective control environment for the Distribution Center in Hungary and manage all the Controlling tasks and deadlines efficiently.
Financial Planning (AOP, Forecasts, Weekly trends...etc.)
Income Statement Variance Analysis of monthly results and plans & presenting results.
Monitoring and controlling Cash-Flow/Working Capital elements.
Presenting and reporting to 2 Business Units (OH & CV), plus the Aftermarket organization.
Managing Transfer prices on 75k+ parts in alignment with Tax department.
Creating and maintaining an effective Control environment and monitoring daily KPIs (Sales, Inventory, Supplier & Customer order book, expenses and legal obligations).
Financial controls & support audit readiness.
Ad-hoc reporting and supporting Management decisions/strategy.
Involved in at least 5 Internal/Deloitte audits - last two were my responsibility and both ended on Satisfactory rating.
Creating daily reports (both financial and operative).
Supporting Month Closing tasks (retrieving data from ERP, calculations, reports, documentation).
Variance analysis on various KPIs.
Support management with data and reports.
Creating and managing proper documentation for audits.
Ad-hoc reports to support the Controller and Local management.
Support of the implementation of the Distribution Center's controlling environment (founded in 2012).
Participating in several audits (Internal/Deloitte & the annual PwC ones) and preparing/submitting requested documentations.
Being responsible for the daily KPI reporting for the Management.
Supporting Controller on ad-hoc request.