Hello! My name is Michał.

I'm Data Analyst and in my spare time - Swift Developer.

I have been coding in Swift since May 2022 and completed the iOS Developer Career Path course taught by Codecademy in December 2022. I also learned to code in SQL. Before that, I also tried Python, JavaScript and Matlab. I work as a Junior Merchandise Planner at Pepco. What does it mean to be a planner? I am a Data Anylst who also creates forecasts and predictions. In addition to planning, I also prepare useful tools in Excel (and hopefully soon in Power BI) for other planners.

With my current position, I have fallen in love with data analysis. I am currently learning how to best use Excel and Power BI.

In the future I will became the leader.

Check my certificates

Recent Work

Excel-based data analysis tools

Purpose: Better forecasting & work automation

Sorry for lack of screenshots!
  • Demand Linecard - connected to the Data Warehouse and extracted data from the product management program. Helps in forecasting the stock and preparing proposed changes on orders in the format for suppliers. In addition, it counts the budget and indicates contact persons.
  • Planner Linecard - same as above but only with Data Warehouse connection and sales plans from Product Planners.
  • ROS range - counts 4 diffrent Rates of Sale based on historical data. You can choose a reference point. Data is presented in form required for other report and you can calculate ROS for all your products at once.
  • Season Planner - tool for Demand Planners. It counts how many pieces per week we should order for each of warehouse based on actual stock and forecasted sales. Quantity is being round to full packages / pallets / cars.
  • Forward Cover Report - in cooperation with other Junior Analyst. Deals with data presentation, formula for calculations and tests the outcomes. Uses Power Pivot, Queries & Data Warehouse.

That is all for January - May. To be contiued... :)

ToDo App

Reminders always with you

Status: Finished Apr 2023
  • Accessibility,
  • Asynchronous methods,
  • Creating reusable views with view configurations,
  • EventKit,
  • UIKit.
GitHub repo

SocialCademy

Online social media app

Status: Finished Feb 2023
  • Cloud authenticator,
  • Cloud storage,
  • SwiftUI,
  • MVVM.
GitHub repo

CookCademy

App for cooking recipes

Status: Finished Oct 2022
  • SwiftUI,
  • MVVM,
  • Editing & adding recipes,
  • Changing colors of layout.
GitHub repo

CodeHistory

Quiz app

Status: Finished Aug 2022
  • First big project,
  • SwiftUI,
  • MVVM,
  • App checks if the user chosen correct answer and changes the colors based on (in)correct answers.
GitHub repo

Smaller Projects

Smaller projects to learn new things

Status: Open list
  • RandomUsers - connected to API, which generates random users names and profile images. #JSON #XCTest
  • GridCallendar - using grid to show calendar
  • ToolbarProject - using toolbar
GitHub repo
GitHub repo
GitHub repo

And of course this website!

If you like these projects or want to give me some feedback

contact me

Work history

May 2023

Fell in love with Data Analysis

At the Infoshare, I realized that I love data analysis and in this direction I would like to shape my career path.

April 2023

Promotion to Junior Merchandise Planner

I was promoted for meritorious service to the company to further develop my potential in analyzing and creating plans, but most importantly, to be able to continue developing tools to work better and faster.

Jan 2023

First success on a new position in Pepco!

I've modified Excel program for Demand Planners which is use to manage orders and covers. It became fully interactive, changes are automatically added, budget is counted and you can edit more than one product per file. It reduces working time by 3-4 times.

25.12.2022 Finished iOS Developer course

From zero to hero!

The course had everything needed to start proffesional job. I learn how to build fully-featured, interactive applications where users can browse, create, save, and upload content.

16.12.2022

New position in Pepco - Demand Planner

  • Planning sales and purchases of subordinate products (in all markets)
  • Monitoring the implementation of sales and purchase plans
  • Preparing analyses and reports

October 2022

  • Finished Learn Intermediate SQL for Marketers and Product Managers course
  • Finished Analyze Data with SQL course

August 2022

  • Finished Learn SQL course
  • Finished Learn the Command Line course

May 2022

Started iOS Developer Career Path course.

Feb 2022

Begin of Pepco journey as Buyer's Assistant.

  • I've created and manage one new product category
  • Contact with supplier (domestic and foreign)
  • Cooperation with other departments
  • Analysis of sales

Dec 2021

Tried my strenght as a Jr. Sales Representative. Turned out not to be my way of career.

October 2021

I started master's degree in Business Psychology, beacuse in the future I'd like to be a good team leader or manager in your company.

July 2019 - entering the medical industry

Started first job as a Audiologist & Salesman. I wanted to help people with hearing disabilities.

The job turn out to be a psychologist, salesman, IT support for other branches & marketer.

June 2019

Graduated with bachelor's degree in Acoustics - Hearing Healthcare and Noise Control from the Faculty of Physics at Adam Mickiewicz University in Poznan.

May 2016

Graudated from high school with a specialization in mathematics-physics with a score of 100% in basic math and 80% in extended math (matura exam). Extended physics with a score of 68%.

Attended study circle in IT.

Intrested?

Download resume Download resume