Jakub Kozioł

Business Intelligence Leader at Aptiv | AA RPA & Tableau Developer
Brzesko, małopolskie

Umiejętności

Alteryx Business Objects Creativity Skills Human Resources Microsoft Excel Microsoft Office Prezi SAP HR SQL Tableau VBA Microsoft PowerPoint leadership skills Internal Communication Remedy Visionary Thinking

Języki

polski
ojczysty
angielski
biegły
niderlandzki
podstawowy
niemiecki
podstawowy

Doświadczenie zawodowe

Logo
People Analytics Manager
Relativity
UBS Kraków
Authorized Officer | HR Reporting Team Leader & SME
UBS
Dual-hatted role:
1. Leading global HR Reporting Team (up to 13 data analysts)
2. Client facing role as a SME – in particular for Asset Management, Global Wealth Management, Corporate Center divisions and Americas and EMEA regions
Tools: Tableau, Alteryx, BO, Excel, VBA, OTBI, Fusion (HRi), BrassRing, Automatic Anywhere and LMS

● Leading creation and implementation of the first HR robot in UBS– PackMan in AA, that took over entire process from over 22 EEs – 24/5 service
● Continuous improvements and optimization of the reports and the processes which lead to cost saving – 2 FTE (50k CHF)
● Coordinating migration of reports from PL to the newly created BSC in India
● CSR Excel Trainer: > Career Turn; > Krakow Business Starter
UBS Kraków
Associate Director Group Internal Audit Reporting Manager
Ubs
Aptiv
Business Intelligence Leader
Dual-hatted role:
1. Leading SCM Analytics team (up to 2 data analysts)
> building the vision & mission and implementation of these
2. Client facing role - leading data visualization through Tableau
Tools: Tableau, Alteryx & Excel
UBS Kraków
Authorized Officer | Workforce Analytics Lead
UBS
Dual-hatted role:
1. Leading global analytics team (up to 3 data analysts)
2. Client facing role as an analyst for Corporate Center division
Tools: Tableau, Alteryx, BO, Excel, VBA, OTBI, Fusion (HRi), BrassRing, Automatic Anywhere and LMS

● Leading for the 2nd year in a row implementation of the first HR robot in UBS – 2Pack in AA, that took over entire process from over 22 EEs – 24/5 service
● Continuous improvements and optimization of the reports and the processes which led to cost saving – 1,5 FTE (38k CHF)
UBS Kraków
Authorized Officer | HR Reporting Specialist & Deputy Team Leader & SME
UBS
1. HR Reporting Specialist – Deputy HR Reporting Team Leader (up to 5 data analysts)
2. Client facing role as a SME – in particular for Cross Divisional team (Talent, Recruitment, Learning)
Tools: BO, Excel, VBA, OTBI, Fusion (HRi), BrassRing and LMS

● Continuous improvements and optimization of the reports and the processes which led to cost saving – 1,5 FTE (38k CHF)
● Leading Global Core Cycle Upload & Download process – 24/5 support to entire UBS (US, EMEA, APAC), setting up the entire process, coordinating team up to 20 data analysts
Cisco Systems Poland Sp. z o.o.
Payroll Analyst - Data Lead (Data Analyst)
> Data collection, load & validation of all payroll related items for 4 countries: DE, IT, PT & ES;
> In control of all required inputs in SAP HR for payroll processing;
Actions: HRMS to SAP HR via G2 interface, ESPP, Recurring & Non-Recurring Payments, Car Allowances & Lease Plan, Referral Awards, Meal Vouchers, PLI Bonuses, Commissions, OnCalls, Salaries;

Beyond projects:
● Optimization of the processes leading to speeding up the processes by 1/5;
● Together with Payroll Manger ensuring correctness of the paid salaries;
Lundbeck Business Service Center
HR Specialist
> Preparing standard & complex HR reports to the Management in HQ Denmark;
> Creating KPI reports & analysis of HR teams;
> Solely responsible for sustaining OM structure in SAP;
> Processing PA, OM & C&B (Payroll) actions in SAP;
> LMA Superuser;
> Vocal point of contact for HQ Denmark;

Beyond projects:
● Complete rebuild of the OM structure for entire organization;
● Delivering Excel & OM trainings for HR team;
● Delivering Data submission for Towers Watson;
Philip Morris Polska Distribution Sp z o.o.
HR Specialist Organizational Management (HR Associate)
> Sustaining global OM structure in SAP for over 80k EEs (complex reorganizations);
> Delivering standard & complex HR report;

Beyond projects:
● Testing HR/IS solutions;
● Auditing OM structure;
Philip Morris Polska Distribution Sp z o.o.
HR Customer Representative (HR Associate) & Intern
Internship for the first 3 months;
> Vocal point of contact for PMI HQ in Switzerland;
> Resolving EEs’ queries via phone, e-mails, Lync;
> Delivering standard & complex HR report;
> Preparing official PMI letters (salary adj., promotions, demotions, upgrades etc);

Beyond projects:
● Collaborating closely with Senior Management Team while supporting Global Announcements process;
● Coordinating Work Permit process for Swiss EEs;
POLDIM S.A.
Finance Department Practice
● providing standard FIN reports;
● inputting financial data into SAP FIN system;
Logo
Entrepreneur
Own Business
> Creating business from Idea to startup, received huge donation for the idea;
> Managing business independently (managing 2 EEs, ensuring financial liquidity);
> Creating and implementing whole marketing strategy;
Logo
OFE Advisor
Aviva Sp. z o.o.
Responsibilities:

● Acquiring new customers, presenting the offer to them and resolving their queries;
● Selling Aviva OFE products by signing contracts with customers;
● Building & maintaining professional relationships with customers;

Beyond projects;

✔ This was my additional task, as I was studying;

Szkolenia i kursy

Nesse - Treningi Interpersonalne
Feb 2020 - Fundamentals of Being Manager

Aptiv
Oct 2019 - Lean Leadership Training

Udemy
May 2018 - Tableau Expert: Top Visualization Techniques in Tableau 10; License: UC-41L9MGVL
April 2018 - Tableau 10 Advanced Training: Master Tableau in Data Science; Lic.: UC-0I3BHZUP
March 2018 - Tableau 10 A-Z: Hands-On Tableau Training for Data Science; License: UC-ODFBIFCT
March 2018 - Learn Tableau Desktop for Accurate Business Analysis; License: UC-YL4HM9UM
March 2018 - Master Microsoft Excel Macros and Excel VBA; License: UC-V0KGJXYI

Coursera - University of California, Davis
March 2018 - Fundamentals of Visualization with Tableau, License: WDAG8UZCNLCM


UBS - Heuresis certified Management Trainers and Consultants Ltd., Krakow
January 2017 - Train the trainer
May 2016 - Introduction to Project Management

StrefaKursow.pl
December 2015 Microsoft Excel – VBA Programming; License: omfzt1b5ne8ogwcskcso0kg8sookwsw

Lynda.com
November 2015
- Coaching and Developing Employees; License: CB856B
- Excel 2013: Macros in Depth; License: 4F545A
- Executive Decision Making; License: C28166
- Human Resources Fundamentals; License: C5FC6D
- Leadership Fundamentals; License: E8FCA3
- Managing Teams; License: A82FAA
- Managing for Results; License: 933E32
- New Manager Fundamentals; License: B59570
- Operations Management Fundamentals; License: D13556
- Teamwork Fundamentals; License: 7303C8

Lundbeck
April 2015 - Learning Management System Super User Training

PMI
May 2014 - Personnel Administration & Organizational Management Certifications
July 2014 - HR eAnalytics
July 2013 - SAP HR

Comarch
June 2013 - MS Excel 2010 – Advanced; License: CER_130618_2551500MIC_140308AJ_11
May 2013 - MS Excel 2010 – Elementary; License: CER_130423_2551500MIC_140308AJ_09

UBS
May 2013 - MS Excel 2007 & Lean

Coursera
June 2013 - Case Western Reserve University - Inspiring Leadership through Emotional Intelligence; License: PF29QL2VWH

January 2013 - Stanford University - A Crash Course on Creativity

December 2012 - University of Michigan - Model Thinking

May 2012 - Stanford University - Game Theory

Edukacja

Logo
Managerial Studies, studia podyplomowe
Tischner European University
Logo
Human Resources Management, studia podyplomowe
Tischner European University
Logo
Applied Linguistics, magisterskie
Tischner European University
Logo
Modern computer graphics (hobby), studia podyplomowe
University of Science and Technology
Logo
English Philology, licencjackie
Maria Curie-Skłodowska University

Specjalizacje

Human Resources/Zasoby ludzkie
Kadry i płace
Human Resources/Zasoby ludzkie
HR Business Partnering
Human Resources/Zasoby ludzkie
Wynagrodzenia i benefity
Human Resources/Zasoby ludzkie
Zarządzanie HR
IT - Rozwój oprogramowania
Analiza biznesowa

Zainteresowania

Exploring world, Getting lost in a good book, Playing piano, Spending time with family, Biking and Bike trail, Learning, cooking.

Grupy

Akademia Górniczo-Hutnicza im. Stanisława Staszica w Krakowie
Akademia Górniczo-Hutnicza im. Stanisława Staszica w Krakowie
Akademia Górniczo-Hutnicza to jedna z najlepszych i najbardziej renomowanych polskich uczelni, od lat zajmująca czołowe miejsca w rankingach szkół wyższych. Przoduje w dziedzinie nowocze
Wyższa Szkoła Europejska im. ks. Józefa Tischnera
Wyższa Szkoła Europejska im. ks. Józefa Tischnera
Wyższa Szkoła Europejska im. ks. Józefa Tischnera
EXCEL w praktyce
EXCEL w praktyce
Pytania, wskazówki, odpowiedzi, komentarze, usprawnienie pracy w EXCELu. Cel: wzajemna pomoc, wymiana doświadczeń, propozycje usprawnień pracy
Human Resources
Human Resources
Zasoby Ludzkie, Praca, Kariera, Szkolenia, Polityka Personalna, Rekrutacja