Summary
Overview
Work History
Education
Skills
Timeline
Generic
Piotr Niemira

Piotr Niemira

Warsaw

Summary

Dynamic data analyst with strong skills in Python, SQL, and performance optimization. Proven track record in streamlining ETL processes and enhancing system flexibility through automation.

Overview

4
4
years of professional experience

Work History

Consultant - Data Analyst

Deloitte
Warsaw, Poland
07.2023 - Current
  • Engineering & ETL Development: Designed and implemented high-performance ETL processes and PL/SQL packages processing millions of records daily within relational database environments (Oracle), ensuring data integrity for the IFRS 9 platform.
  • Python Migration Initiative: Taken part in a project to refactor and migrate business logic from legacy PL/SQL to Python, utilizing Object-Oriented Programming (OOP) paradigms and Pandas/NumPy libraries to enhance system flexibility.
  • Performance Optimization: Optimized complex database views and stored procedures, significantly reducing query execution time through Execution Plan analysis and advanced indexing strategies.
  • CI/CD & DevOps: Managed code repositories (Git/Bitbucket) and deployment processes using Change Console. Oversaw CI/CD pipelines and automated testing workflows in Bamboo.
  • Code Quality Assurance: Served as a Code Reviewer, ensuring high code quality, adherence to software development standards, and compliance with architectural requirements.
  • GenAI Implementation: Developed a knowledge repository for GitHub Copilot based on RAG (Retrieval-Augmented Generation) techniques, mapping business logic to technical context to streamline code generation from natural language inputs.

Analyst

Deloitte
Warsaw, Poland
07.2022 - 06.2023
  • Automated Testing & QA: Created and maintained automated test scripts and SQL test datasets to verify the accuracy of data transformations and the computational logic of the Finevare system.
  • Data Analysis & Triage: Leveraged advanced SQL queries to analyze large data volumes for Root Cause Analysis (RCA) of production errors and to support complex reporting processes.
  • Technical Specification: Translated complex business requirements from the banking sector into detailed functional and technical specifications for development teams.
  • Client Collaboration: Facilitated technical workshops and maintained comprehensive project documentation (Confluence), ensuring alignment between business expectations and technical capabilities.

Education

Master of Science - Big Data Analytics

Warsaw School of Economics
Warsaw
12-2025

Bachelor of Science - Quantitative Methods in Economics

Warsaw School of Economics
Warsaw
07-2023

Skills

  • Programming Languages:
    Python:     Object-Oriented Programming (OOP), Pandas, NumPy, Scikit-learn, TensorFlow, Keras (Data Science & ML stacks)
    SQL & PL/SQL: Advanced DML/DDL, Stored Procedures, Packages, Triggers, Query Optimization & Tuning, Materialized Views
    R: Tidyverse, ggplot2, Shiny, dplyr, caret (Statistical Analysis & Visualization)
    Julia: DataFramesjl, Plotsjl, StatsPlotsjl, GLMjl, Statistics
  • Generative AI & LLMs:
    Prompt Engineering, RAG (Retrieval-Augmented Generation) architecture, Context Mapping, GitHub Copilot optimization
  • Data Engineering & DevOps:
    Tools:     Git, Bitbucket, Bamboo (CI/CD), Change Console, Jira, Confluence
    Databases: Oracle RDBMS, ETL Processes, Data Warehousing concepts
    Cloud & Big Data (Familiar with): AWS (S3, EC2), PySpark, Databricks
  • Other: MS Excel (Advanced), Agile/Scrum Methodologies, Technical Documentation

Timeline

Consultant - Data Analyst

Deloitte
07.2023 - Current

Analyst

Deloitte
07.2022 - 06.2023

Master of Science - Big Data Analytics

Warsaw School of Economics

Bachelor of Science - Quantitative Methods in Economics

Warsaw School of Economics
Piotr Niemira