Work Experience

06.2023 – ...

Preparations and starting own business activity

• Front-End Development: developing a responsive website and product catalog for a business client
• Developing skills in PowerBI software
• Acquiring additional capital for business startup purposes through a state grant
• Designing and creating a Salary Calculator for employment contracts
• Designing and creating a Self-Employed Salary Calculator
• Building a Software Supplier Offers Comparator
• Preparing a business plan and analyzing the tax system

Achievements:

• Acquiring the first major business client and establishing a long-term partnership
• Successfully securing a state grant on the first attempt, receiving 88 out of a possible 90 points
• Significantly enhancing PowerBI development skills

TUiR WARTA S.A. , TUnŻ Warta S.A.

01.2022 – 05.2023

Senior Specialist – Training Area Analyst

Tasks:

• Creating and automating BI tools for training processes
• Building BI reports for internal and external use
• Analyzing training effectiveness and its impact on sales
• Optimizing processes with internal client input
• Managing BI reports for the sales managers' motivational program
• Gathering business and functional requirements for CRM
• Supporting CRM implementation for training
• Testing CRM reports using SQL
• Providing SQL training for the team

Achievements:

• Automation of the reporting process of annual manager evaluation
• Automation of the document circulation process between the insurance company and the Polish Financial Supervision Authority (KNF)

UPC POLSKA Sp. z o.o.

04.2016 – 12.2021

Reporting and Analysis Specialist

Tasks:

• Identifying growth opportunities
• Consulting clients to understand data needs
• Analyzing data for trends and patterns
• Creating reports, dashboards, forecasts, and data visualizations for management
• Testing and validating data models and analytics
• Automating regular sales reports with improvement suggestions
• Compiling commission reports for sales units
• Reporting company performance and gaps to the Board of Directors
• Analyzing sales campaign quality
• Collaborating with Finance and Sales on KPI definitions

Achievements:

• 95–97% accuracy in monthly sales and service activations forecasting
• An award for thorough reconstruction and extension of operational sales reports included in Commercial Deck
• An award in thanks for a very good attitude and contribution and commitment to the implementation of tasks in 2017
• Significant improvement in practical PL/SQL skills

LODZIARNIE FIRMOWE Sp. z o. o. Sp. k.

10.2015 – 04.2016

Senior Analyst

Tasks:

• Managing the Reporting and Analysis Team
• Supporting the Sales Department's operational needs
• Automating regular sales report delivery
• Creating inventory control tools for the ice cream parlor network supporting HR
• Negotiating with potential software suppliers
• Preparing commission settlements for the ice cream parlor network

Achievements:

• Contributed to a 40% increase in the number of ice cream parlors within the network through work in the analytics team

RWE POLSKA S.A.

01.2015 – 03.2015

Business Analyst

Tasks:

• Defining requirements and coordinating sales system changes
• Managing the commission system implementation project
• Preparing functional requirements for the commission system for RWE service intermediaries
• Communicating with stakeholders to gather business requirements and create GUI instructions
• Verifying solution compliance with business requirements and creating test scenarios

Achievements:

• Approval of the implementation of a commission system project for companies intermediating in the sale of RWE services

01.2012 – 12.2014

Operational Analyst

Tasks:

• Collecting and analyzing sales data to spot trends and issues
• Proposing changes to boost efficiency and cut costs
• Creating reports and presentations with recommendations and benefits
• Working with departments to implement process changes
• Providing analysis to support decision-making

Achievements:

• Automation of the commission settlement process for companies intermediating in the sale of RWE services

06.2011 – 12.2011

Operational Sales Support Specialist

Tasks:

• Administering the sales system for individual customers and SMEs
• Reporting and analyzing electricity consumption data
• Creating sales support tools and streamlining supplier switches
• Settling commissions for trade partners in RWE services
• Creating sales reports and plans with the purchasing department

Achievements:

• Board Members' Award for the Improvement and Automation of the Process for Handling Departing Customers
• Implementation of Complaint document circulation process application for customer service teams

04.2011 – 05.2011

Sales Portfolio Analyst

Tasks:

• Forecasting future purchases based on contracted volumes
• Creating energy consumption profiles by industry or client
• Analyzing sales prices, purchase prices, revenue, and margins on electricity

Achievements:

• Acquiring knowledge about the electric energy sales industry in Poland and abroad

NETIA S.A.

07.2009 – 01.2011

Sales Support Coordinator

Tasks:

• Reporting and analyzing sales data for individual customers in Poland
• Maintaining and distributing contact databases for sales
• Defining requirements, testing, and implementing sales support systems
• Analyzing sales data and competition
• Conducting training on sales support applications and managing their structure
• Developing and automating reporting processes for individual customers

Achievements:

• Distinction "For the development and automation of reporting processes for the Home Market

10.2008 – 06.2009

Telesales Support Specialist

Tasks:

• Reporting and analyzing data in the telesales channel
• Creating supporting tools for Telesales
• Managing HTML documents in the Knowledge Base (CMS for the Telesales department)

Achievements:

• Distinction for: "Commitment and unconventional solutions to improve work in Telesales"

Skills

BUSINESS ANALYSIS

• Gathering and defining software functional requirements, defining use cases
• Creating business models and data flow diagrams
• Analyzing business processes and identifying areas for optimization
• Developing business reports and data analysis
• Communicating with stakeholders to understand their business requirements, creating GUI instructions
• Verifying the solution's compliance with business requirements, creating test scenarios
• Collaborating with the development team to implement system or system changes
• Identifying and proposing improvements in business processes

DATA ANALYSIS

• Consulting with clients to understand their data requirements and expectations
• Designing and implementing data models
• Analyzing data to find trends and patterns
• Creating reports, dashboards and data visualizations
• Data analysis and understanding business needs to provide best solutions
• Testing and validating data models and analytical solutions
• Deploying data models and analytical solutions in a production environment
• Optimization of data models and analytical algorithms to improve performance

APPLICATION DEVELOPMENT

• Creating web applications using Python and the Dash framework
• Creating websites with CSS
• Creating advanced VBA+MS Access / Excel applications and tools, for example:
• Lead management application for telesales teams
• Complaint document circulation process application for customer service teams
• Employment Contract Salary Calculator
• Software Vendor Offer Comparison Calculator
• MS Excell / Access VBA tools for integration or export hundreds of csv / xlsx / txt data sources

DATABASES

• Oracle
• MS SQL Server
• PostgreSQL
• SQLite
• MySQL

PROGRAMING LANGUGES

• SQL
• PL/SQL
• T-SQL
• PYTHON
• DAX
• VBA
• CSS
• HTML
• C++
• R

TOOLS

• PL/SQL Developer
• MS SQL Server Management Studio
• DBeaver
• MS Power BI
• Power Query
• Power Pivot
• MS Excel
• MS Access
• MS Word
• MS Power Point
• Think-Cell
• Tableau
• R Studio
• MicroStrategy
• Microsoft Azure
• GPT
• Jira
• Confluence

SOFT SKILLS

• Communication skills
• Teamwork and collaboration
• Problem-solving skills
• Adaptability and flexibility
• Creativity and innovation
• Time management
• Emotional intelligence
• Attention to detail
• Resilience and stress management

ADDITIONAL SKILLS

• Driving license (categories A and B)
• Graphic designing in Adobe Photoshop
• Video editing in Adobe Premiere Pro

LANGUAGES

• English - B2 level
• Russian - A1 level

Projects

2024: Acquiring additional capital for business startup purposes

The project involved obtaining a grant to start a first business. The application process required compliance with extensive regulations, attending start-up training sessions, providing a detailed business description, conducting a SWOT analysis, performing a financial evaluation, and demonstrating knowledge of the tax system, market, and competition.

The application was successfully approved on the first attempt, receiving 88 out of a possible 90 points.

2024: Interactive Curriculum Vitae

Designed and created an online version of the CV using HTML and CSS. Enhances the ease of access to information such as work experience and a wide range of projects.

2024: Front-End Developer - Responsive Website and Product Catalog

Implemented a modern, responsive website for a company with four business areas: employment agency, plastic product manufacturing, packaging production, and transportation. Additionally, created an electronic product catalog featuring over 150 items in A3 format. The project included graphic design work and professional product photography for some of the products.

2024: Power BI Car Rental data analysis and budget performance

A Power BI project is underway to analyze car rental data in the U.S. for 2024, with SQL Server used to modify and generate datasets, including data from previous years for comparison. The visualization includes budget performance, revenue, trips, and customer ratings, with ability to compare measures with past years and moths values.

2024: Salary Calculator – Employment Contract

A salary calculator compares employment contract costs with self-employment, including taxes and contributions. It supports custom parameters and multiple entries, aiding decisions for B2B and business setup.

2024: Self-employed Salary Calculator

The self-employed salary calculator compares salary costs between employment and self-employment, forecasts business expenses, and analyzes income tax, VAT, and social security contributions. It allows flexible customization and future wage model forecasting.

2024: Software Supplier Offers Comparator

This calculator was developed to compare software supplier offers based on key indicators like implementation time, cost, experience, and more. It assigns points to suppliers using a proportional interpolation algorithm that factors in defined weights for each indicator, allowing for flexible comparisons of multiple offers based on business priorities.

2023: Implementation of a CRM system for the Training Department

A CRM system for the Training Department at WARTA S.A. was implemented, focusing on a customized reporting module. The user contributed by interpreting business needs, creating functional requirements, preparing SQL report sources, testing the module, and documenting its functionality for end users.

2022: Optimization of Document Workflow Process in the Financial Supervisory Department

An interim solution was developed to optimize the verification process of insurance agents' certifications at WARTA S.A., reducing manual work by automating document handling and report generation. The process involved transforming data from various sources into automated Excel reports, streamlining workflows, improving efficiency, and boosting team motivation.

2022: Management of the Reporting Process for Annual Manager Development Program

This project involved managing the reporting process for WARTA S.A.'s national manager development program, where hundreds of managers earned points for training, evaluations, and exams. Using Excel, Access, and VBA, tools were created to integrate data from multiple sources (CRMs, paper exams, evaluation forms) to generate reports for the board and individual managers, track progress, and handle recalculations due to complaints.

2021: Selection of Supplier and Migration of Reports to Power BI

In a team project at UPC Polska, the user compared Business Intelligence software suppliers based on key indicators like cost and implementation time. They also designed views and procedures using PL SQL Developer to generate source data, collaborated with developers to define the model, and verified the accuracy of reports created by the external supplier using Microsoft Power BI.

2020: Web Application for Data Visualization on Microsoft Azure

This independent project involved designing and deploying an application connected to an Azure SQL database using Python, SQL, and the Dash framework while working for UPC Polska. The application visualized budget execution data for a fictional telecommunications company, with filters allowing detailed analysis, and was successfully migrated to a web application on Azure.

2019: Implementation of Sales and Service Activation Forecasting Model

In this project for UPC Polska, weekly sales and activation forecasts were developed based on historical data, trends, and various factors like budget strategy and promotions. Using PL SQL Developer and Excel+VBA, the forecasts were updated daily with actual sales data, and additional factors like conversion rates and backlog were considered, resulting in improved decision-making support for the company.

2017–1018: Sales Reporting Process Optimization

In this team project at UPC Polska, an ad hoc reporting solution was developed using PL SQL Developer, MS Excel, and ThinkCell before transitioning to Power BI. The role involved creating data models and procedures, designing reports and visualizations, and ensuring data accuracy while integrating data from various sources into a reporting data mart.

2016: Construction of a Warehouse Resource Control and Management Model

A warehouse resource management model was developed for GRYCAN, focusing on optimizing resource allocation for ice cream parlors and cafes. The Excel+VBA-based model used sales forecasts and historical data to manage inventory efficiently, and included reporting tools to support management and warehouse operations.

2016: A browser-based skill game designed using JavaScript, HTML, and CSS

A browser-based skill game was developed using JavaScript, HTML, and CSS, featuring a coastal cannon that shoots at moving enemy ships. The game, which generates graphics and animations entirely with CSS, involves managing shot range, scoring hits, and handling dynamic ship movements, with all code contained in a single file and a timer to add bonus seconds for successful hits.

2014: Commission System Project for Intermediary Sales Companies

As the project manager for RWE Polska S.A., I coordinated the development of a commission system implemented by an external supplier using Oracle Application Express. The project involved analyzing business requirements, creating use cases, defining functional requirements, collaborating with the supplier on system details, and obtaining management approval for the implementation phase.

2013: Implementation of Sales CRM for an Energy Company

For RWE Polska S.A., I played a key role in implementing a Sales CRM system, focusing on defining and interpreting business processes related to energy sales and supplier changes. My responsibilities included defining functional requirements, ensuring system compliance, and collaborating closely with the software supplier to address requirements and clarify processes using MS Access/Excel tools.

2012: Optimization of the TPA Process in Changing Electricity Suppliers

For RWE Polska S.A., I developed an MS Access + VBA application to optimize the TPA process for changing electricity suppliers. This solution streamlined the management of applications, improved process efficiency, and reduced costs by centralizing data, automating status updates, and enabling faster, more reliable reporting.

2011: Optimization of Customer Departure Process

In 2011, I developed an MS Access + VBA application for RWE Polska S.A. to optimize the customer departure process. This solution automated document handling and status tracking, generating response templates for complaints and resignations. It streamlined the process, improving efficiency and reducing costs by centralizing data and automating responses, which led to faster and more accurate reporting.

2011: Implementation of Sales Support System

In the project, I defined processes and interpreted business requirements for a Sales Support System, ensuring that functional system requirements were met. I also verified system compliance and analyzed data sources using SQL to generate accurate sales, service, and quality reports.

2010: Optimization and Automation of Sales Reporting Process for the Individual Customer Segment

In the project, I optimized and automated the sales reporting process for Netia's Individual Customer segment, integrating data from various sources and ensuring consistency across reports. I developed an MS Access database connected to an SQL view for automated data integration, created daily reports and visualizations, and tailored them to different recipients' needs, including external firms and internal managers.

2009: Implementation of an application for managing an SMS database for telesales channel consultants

I designed and implemented an MS Access application for managing SMS contacts for telesales consultants at Netia. The application streamlined contact allocation, interaction tracking, and reporting, improving business decision-making and data management compared to previous Excel-based methods.

CERTIFICATES AND TRAINING

EDUCATION