Princely KitilyaBusiness & data analyst, Lublin
Lublin --:-- Email me

Princely
Kitilya

I help businesses use the data they already have.

NowJunior business analyst at Sollers, Lublin

Scroll for the story

Where it started

In school, I loved economics and accounting.

Then I started looking at how real businesses actually run.

The gap

Most of them sit on data they never use.

So I moved from economics into business analysis and data science, to close that gap.

First real fix

Month-end close, 30% faster.

As an accounting intern at Basil & Alred in Tanzania, I automated the monthly reports in Excel and rebuilt the dashboards leadership read.

Four more messes,
four answers.

Same habit every time: messy data in, a decision someone can make out.

Is this company healthy?

90%

less time to build a report

Judging a company means working out dozens of ratios from its financial statements. My app does it straight from the Excel files, compares companies side by side and flags warning signs in red. Here, Boryszew carries the most debt of the three.

Practice projectPython · Streamlit

Try the app ↗︎

Where does the money come from?

60%

less time on one-off reports

Patients, treatments and payments lived in separate files, so every question meant matching them by hand. I put them in one database with a live dashboard, so managers can see revenue month by month on their own.

Practice projectSQL · PostgreSQL · Streamlit

Try the dashboard ↗︎

Where do delays cost the most?

€800,200

in delay penalties, across 300,000 flights

Airlines pay penalties for late flights, but a huge flight log doesn't tell you where to look. My Excel dashboard filters delays and penalties by airline and state in one click, and points straight at California.

Practice projectExcel · Power Query

Which EU countries are alike?

4

groups of look-alike countries

Comparing 27 countries on six measures at once is too much for any table. I pulled World Bank data and let an algorithm sort the countries into groups that behave alike, in a chart you can explore.

Practice projectPython · scikit-learn

See the code ↗︎

Now I do this for a living.

Junior business analyst at Sollers, Lublin. Seven months on Guidewire PolicyCenter, the software insurers use to sell and manage policies.

  1. Translate.

    I turn what the insurer needs into clear story cards that developers can build without guessing.

  2. Map.

    I draw the business processes in BPMN with Camunda, so business and tech agree on one picture.

  3. Lead.

    I've run the team's sprints as Scrum Master, keeping a multicultural team moving in the same direction.

Behind the work

Open a spine to read it.

  • Top 2% of my year

    Rector's Scholarship · UMCS Lublin

    Awarded to the top 2% of students in BSc Business Analytics & Data Science, with a 4.94 GPA out of 5.

  • SQL, Python, Power BI

    Plus Excel, R, Jira and Camunda

    The tools behind every project on this page, from the hospital database to the fare model.

  • English & Swahili

    Both native · basic German

    I work comfortably across cultures and in multicultural teams.

  • Software engineering diploma

    BrainStation · Vancouver · 2023–24

    Software engineering and web development, before I moved into business analytics.

  • 8 certificates

    IBM · Google · DataCamp · 2025–26

    Data analysis and visualisation with Python (IBM), data science and regression (Google), SQL and Python (DataCamp).

Does your team have data it isn't using yet?

kitilyaprincely@gmail.com

Princely Kitilya, LublinEvery moving dot on this page is a data point.