02.2025 — present
Danone
Market Reporting Specialist
Development of Power BI reports and reporting automation. Requirements gathering, coordination of user testing and implementation of planning tools across markets.
01About me
Kamil Soja
Data Analyst
I’m a data analyst with experience in logistics, FMCG and automotive. I develop Power BI reports focused on solving business problems and analysing their root causes.
I automate processes using Power Automate, VBA and SQL. I also design and build relational databases that provide structured data for Power BI reporting.
Combining technical skills with hands-on supply chain experience allows me to understand business problems from both a technical and an operational perspective. This helps me develop solutions that reflect how planners, logistics teams and operations actually work.
Technologies & skills
Power BI & data modelling
- Power BI
- DAX
- Power Query
- M
- Power Pivot
- Data modelling
Databases & data processing
- SQL
- Azure SQL
- MS Access
- ETL / ELT
- Medallion architecture
Process automation
- Power Automate
- VBA
- Excel
02Career
Professional experience
02.2024 — 02.2025
TAURON Polska Energia
Reporting Specialist
Preparation of financial and KPI reports, including reporting for EU institutions. Coordination with subcontractors and preparation and testing of XML code for new reporting implementations.
12.2021 — 02.2024
CAT LC Polska
Planning Data Analyst
Ownership of tactical planning based on client sales data. Development of a SQL database for data processing, automated distribution of plans to carriers and Power BI reporting on transport and warehousing.
07.2020 — 12.2021
Unilever
Shipment Planner
Transport planning for Germany, the United Kingdom and Ireland. Logistics data analysis, KPI reporting, carrier coordination and participation in user acceptance testing of Oracle Transport System.
2017–2020
Early career in logistics and supply chain (Raben Logistics, XPO Logistics).
03Personal project
Supply Chain Planning & Analytics
A personal portfolio project demonstrating SQL, database design and Power BI skills. Built entirely with synthetic data.
The Azure SQL database translates vehicle production forecasts into component demand, transport plans and inventory projections. The project covers import, quality checks, planning versions and data preparation for Power BI reports.
04Projects
Professional projects
FMCG / SUPPLY PLANNING
2025 — presentDanone
PRODUCT PORTFOLIO PLANNING
Supply Plan
Power BI · Excel · SAP APO
A planning tool providing a standardised, unified view of product portfolios across markets and factories. Designed to replace a dozen or so separate tools used across different markets, it supports the identification of out-of-stock risks and what-if analysis.
Power BI provides the reporting and analysis layer, while Excel enables planners to build what-if scenarios. The solution is fed by SAP APO data extracts.
Responsibilities
Solution development, requirements gathering, coordination of user testing and implementation across markets.
DEMAND SNAPSHOT COMPARISON
GPS vs GPS
Power BI · SAP IBP
A Power BI report for comparing product demand snapshots from SAP IBP. The current snapshot can be compared with historical versions from up to one year earlier to analyse changes in demand.
Responsibilities
Development of Power BI reporting for comparing current and historical product demand.
MASTER DATA GAP AUTOMATION
Masterdata Gaps Automation
Power Automate · Power BI · CSV · Teams
A Power Automate flow connected to a Power BI report where planners review master data gaps for their products. The automation forwards those gaps to the people responsible for each factory.
Responsibilities
Development of a flow that retrieves report data, splits it into CSV files by factory and emails each file to the relevant factory contacts. A Teams notification also informs recipients that the email has been sent.
AUTOMOTIVE / TRANSPORT PLANNING
2021 — 2024CAT LC Polska
TRANSPORT PLANNING & ANALYTICS
Tactical Transport Planning
SQL · Power BI
Medium-term planning based on client sales data. Incoming files were loaded into a SQL database and processed into transport plans, which were then automatically emailed to carriers.
The plan also fed a Power BI report covering carrier capacity, transport costs, warehouse capacity utilisation and supply chain efficiency.
Responsibilities
Ownership of the tactical planning process. SQL database design and development, automation of plan preparation and distribution, and Power BI report development, with the aim of streamlining and shortening the planning process.
Descriptions cover work on professional projects. Company data and internal code are not published.
05Contact