Tomasz Bartłomiejczak

Plant and NEE Logistics Controller
Poznań, wielkopolskie

Umiejętności

Lotus Notes SAP SQL MS Office (Word, PowerPoint, Excel) VBA for Excel Hyperion Exact Globe

Języki

angielski
biegły

Doświadczenie zawodowe

O-I Produkcja Polska S.A.
Plant and NEE Logistics Controller
• prepare plant budgets, calculate activity prices, upload Bill of Materials and routings, upload future prices for raw materials etc, calculate new standard costs
• provide input to monthly forecast for the plant based on latest production plan
• prepare capex budget proposals for plant investments; Providing financial support to help the Plant engineer and Plant Manager analysis of the profitability of individual products and sales price calculations,
• review and reconcile inventory count,
• SOX control: prepare, review and execute all necessary internal control according to control framework adapted by the entity/plant,
• prepare logistics budget and forecast,
• support logistics teams in the decision making process and increase their financial awareness in order to achieve better fcst accuracy.
O-I Produkcja Polska S.A.
Plant controller
• prepare plant budgets, calculate activity prices, upload Bill of Materials and routings, upload future prices for raw materials etc, calculate new standard costs,
• provide input to monthly forecast for the plant,
• prepare capex budget proposals for plant investments; Providing financial support to help the Plant engineer and Plant Manager analysis of the profitability of individual products and sales price calculations,
• review and reconcile inventory count,
• SOX control: prepare, review and execute all necessary internal control according to control framework adapted by the entity/plant
Logo
Controlling Specialist
Audio SAT (Grupa Sivantos)
• active participation in the budgeting process (analysis of sales and costs in relation to the objectives in the budget),
• responsibility for the preparation of monthly sales reports and the cost to the needs of the Sivantos Group,
• analysis of the profitability of individual products and sales price calculations,
• work on the optimization of business processes using tools SQL and VBA for Excel,
• reporting and analysis of sales and marketing.
Sivantos Sp. z o.o.
Assistant Financial Controller
• responsibility for the preparation of monthly sales reports and the cost to the needs of the Sivantos Group,
• analysis of the profitability of individual products and sales price calculations,
• reporting and analysis of sales and marketing.
Logo
Finance specialist
City of Poznań-Poznań City Hall
• performance budget analytic,
• develop and present to accept collective plans: budget, Long Term Financial Forecast, a schedule of current expenditure and investment,
• agreeing on the content of contracts and agreements,
• preparation of documents related to the award of public.

Szkolenia i kursy

Visualization of financial data
Microsoft Excel - Automate reporting and data analysis using VBA
Public Procurement Law
Accounting units of local government

Edukacja

Logo
Finance and Accounting, studia podyplomowe
Uniwersytet Ekonomiczny w Poznaniu
Logo
Obtaining and Accounting For Finance From European Union Founds, studia podyplomowe
Wyższa Szkoła Bankowa w Poznaniu
Logo
Master of Administration, magisterskie
Uniwersytet im. Adama Mickiewicza w Poznaniu

Specjalizacje

Finanse/Ekonomia
Kontroling

Zainteresowania

Sport - soccer, squash, jogging
History and politics
Automation of reports in Excel using SQL and VBA
Data Visualization

Inne

Driving license. B

Grupy

Uniwersytet im. Adama Mickiewicza w Poznaniu
Uniwersytet im. Adama Mickiewicza w Poznaniu
Uniwersytet im. Adama Mickiewicza w Poznaniu to jedna z najlepszych uczelni w Polsce. W uznanych rankingach polskich szkół wyższych UAM sytuuje się w ścisłej czołówce najlepszych uczelni
Excel
Excel
dla wszystkich użytkowników programu MS Excel oraz programujących w VBA.
SQL Server
SQL Server
SQL Server oraz wszystko, co jest w bezpośredni sposób z nim związane.