fb-pixel

Location

Poland

Rate

$35  / per hour

Years of experience

16+

About

I am an experienced SSIS Developer with a robust academic background in mathematics and specialized postgraduate training in database systems from AGH University of Science and Technology. My professional journey began in finance as an accountant assistant, where I honed my skills in data management, including account assignment, database updating, and archiving. This foundational experience paved the way for my current focus on SQL Server Integration Services (SSIS), where I leverage my expertise to develop efficient data integration and transformation solutions. With a Master’s degree in Mathematics from Cardinal Stefan Wyszynski University, I possess a deep analytical capability, demonstrated in my master’s thesis on the use of genetic algorithms to solve complex logistical problems such as vehicle routing. This analytical prowess is complemented by my practical skills in ETL processes, data warehousing, and performance tuning, making me adept at managing large datasets and improving data processing workflows. I am passionate about utilizing my skills in database and information systems to contribute to projects that require innovative data solutions and advanced problem-solving capabilities.

Tech Stack

Ssis, Database, JavaScript, Linux, PostgreSQL, Power BI, Python, SQL

Experience

  • Design and Develop SSIS Packages: Create and maintain robust SSIS packages for efficient data extraction, transformation, and loading (ETL) processes, ensuring accurate and reliable data flow across various systems.
  • Database Maintenance and Optimization: Manage SQL Server databases, perform regular maintenance tasks, ensure data accuracy, and optimize performance through effective indexing and query optimization.
  • Data Warehousing: Implement and maintain data warehousing solutions, utilizing star and snowflake schema designs to support complex business intelligence applications and reporting needs.
  • Performance Tuning of ETL Processes: Optimize ETL processes by identifying bottlenecks and implementing solutions to improve data processing speeds and reduce load times.
  • Error Handling and Data Quality Checks: Develop sophisticated error-handling mechanisms within SSIS packages to manage exceptions and maintain high data quality throughout ETL processes.
  • Documentation and Reporting: Create comprehensive documentation for all data integration processes and develop reports using SQL Server Reporting Services (SSRS) to aid in data analysis and decision-making.
  • Collaboration and Team Support: Work collaboratively with other IT professionals, including database administrators, developers, and analysts, to support data-related tasks and contribute to team projects.

Employment history

Business Intelligence Developer- Melita Ltd May 2019- Present

-Drive and manage data integration activities to ensure that data is received, compete, accurate and available for users.
-Perform files transfers, data warehouse imports, and updates using SSIS
-Building ETL processes using SSIS and SQL server stored procedures
-Working on column store data warehouse system Google BigQuery, preparing PowerBI datasets and dashboards based on Google BigQuery
-Creating new data warehouse solutions
-Development of data models for Data Marts
-Document data flows, data dictionaries and findings of the data analysis
-Prepare and execute test case scenarios
-Review release intstructions
-Creating reports
-Working with high volume Microsoft data warehouses and BI technologies: SSIS, SSRS, SSAS and Power BI
-Working with Microsoft SQL server, Oracle MySQL database management systems
-Creating support BI tool using Python (web development)

Digital Solutions Developer- Tupperware Brands May 2018- April 2019

-Using SSIS to migrate databases and old server environment
-Creating ETL flows using SSIS, developing and building SSRS reports and dashboard, SQL queries implementing and modifying including stored procedures, views and functions, designing and developing stored procedures, queries and views necessary to support SSRS reports
-Creating ad-hoc reports, deploying changes in internal web application (HTML)
-Updating and publishing content on the company’s internal website, data conversion and configuration using Microsoft database technology (SQL Server 2014)
-Building test plans and follow through, work on test environment, work on international projects with internal and external suppliers
-Participate in roll-outs of projects and training events

Software Developer (Hemmersbach GmbH&Co.KG January 2017-April 2018

-Maintenance, development and troubleshooting of core company application based on VBA with fronted access
-Development os SSIS packages to load data from various sources, implementation of workflows by parameterization the existing function blocks
-Providing the users with a customized and functioning applications, creating database objects (MS SQL Server 2014) such as tables, views, etc.
-Creating, maintaining, and optimizing stored procedures and functions, working in agile methodology (scrum)
-Maintaining and developing Warehouse application (VBA), backend developing companies applications (MS SQL 2016)

Senior Analyst- Brown Brothers Harriman February 2016-December 2016

-Creating queries and reports in IBM Cognos Query Studio
-Developing queries in IBM Cognos Query Studio for multiple users in AML team
-Preparation of MS Excel and VBA solutions in order to accelerate AML process
-Developing and testing SQL scripts to query and manipulate data, performing SQL queries
-Improving the quality of the reporting solution
-Supporting the management team by creating daily ad hoc reports

Analyst-HSBC Service Delivery January 2015-January 2016

-Preparation of MS Excel and VBA solutions in order to accelerate KYC process (screening, Waterfall approach)
-Preparation of training materials in MS Excel, participation in MI program (documenting SQl database systems)
-Performing SQL queries
-Cooperation with operational managers by creating reports to meet expectations of the business partners

Analyst- The Royal Bank of Scotland plc May 2013- December 2014

-Managing macro tools project improving and accelerate AML process (3 months)
-Identify, understand and plan for macro improvement session
-Participation in session with AML team and cooperation with IT team during project
-Preparing tests and application error reporting
-Performing specific Anti Money Laundering analysis of high risk customers for the UK Retail Division
-Preparation of appropriate transactional analysis of RBS and NatWest customers
-Identify and escalate potential risks to British financial authority (FCA)
-Completion of the Risk Assessment on customers which resulted in decision whether RBSG retain or exit the connection with the customers

Tutor - Private Mathematics Tuition September 2009-April 2013

-Develop customized lesson plans tailored to the individual learning styles and needs of each student to enhance their understanding of mathematical concepts.
-Deliver engaging and effective mathematics instruction on topics ranging from basic arithmetic to advanced calculus, depending on the student’s grade level and learning objectives.
-Conduct assessments to evaluate students’ progress and provide timely feedback to help them understand their strengths and areas for improvement.
-Create and utilize various educational materials such as practice worksheets, instructional videos, and interactive activities to facilitate learning and maintain student interest.
-Coordinate scheduling with students and parents to ensure consistent tutoring sessions while effectively managing time during each session to cover all necessary topics.
-Regularly communicate with parents or guardians about students’ progress, challenges, and achievements, providing recommendations for further improvement outside of tutoring sessions.

Accountant assistant- Biuro Finansowe Anna Mroz January 2006-October 2008

-Allocate financial transactions to appropriate accounts within the company’s accounting system, ensuring accurate tracking of income and expenditures.
-Manage the secure archiving of financial documents and records in compliance with legal and company guidelines to ensure data integrity and availability for audits.
-Regularly update financial databases to reflect transactional changes and adjustments, ensuring that all financial data is current and accurately recorded.
-Maintain the accuracy and reliability of financial data through consistent checks and validations within the accounting system.
-Ensure compliance with financial regulations and standards by properly organizing financial records and following established accounting practices.
-Assist in the preparation of financial reports by providing necessary data and reports from the financial database as requested by senior accountants or management.

Education history

AGH University of Science and Technology January 2016- June 2016 Postgraduate Studies - Database Systems
Cardinal Stefan Wyszynski University October 2006-May 2013 Mathematics, type of degree: Master of Mathematics, master’s
thesis: Genetic Algorithms in Solving Vehicle Routing Problem
Download profile as PDF

We’ve helped 83 clients with IT recruitment and software development.

Read about a few of them below...

DevsData LLC Reviews 5.0 stars 37 reviews
Powered byClutch logo
Powered byClutch logo
See more testimonials
Similar blind CVs/resumes
Poland

Avaloq Developer Resume Sample

Avaloq Consultant with a strong background in SQL, PL/SQL, and Linux
Avaloq Script
Git-icon
Git
Jira
Linux-icon
Linux
Scrum-icon
Scrum
SQL-icon
SQL
Rate $15  /  per hour
Poland

Senior Business Analyst Resume

An experienced Technical Team Lead, Senior Oracle Consultant, and Solution Architect.
SQL-icon
SQL
Bash-icon
Bash
ETL
Java-icon
Java
T-SQL
Rate $20  /  per hour
Poland

Linux System Administrator Resume Sample

Senior Linux/DevOps Infrastructure Engineer with over 20 years of experience
Linux administrator
Linux-icon
Linux
Solaris
SunOS 4
UNIX
Rate $45  /  per hour
Ukraine

Flutterflow Developer Resume

A developer with five years of commercial experience in IT.
Express.js-icon
Express.js
Flutter-icon
Flutter
FlutterFlow
JavaScript-icon
JavaScript
MongoDB-icon
MongoDB
Node.js-icon
Node.js
React-icon
React
Typescript-icon
Typescript
Rate $11  /  per hour
UK

Quantitative Trader Resume

Quant and Trader with a proven track record in the investment banking industry.
Python-icon
Python
C++-icon
C++
PostgreSQL-icon
PostgreSQL
R-icon
R
SQL-icon
SQL
Rate $150  /  per hour
Portugal

Portuguese Developer Resume Sample

Software engineer with over 12 years of commercial experience
C++-icon
C++
AWS-icon
AWS
Bash-icon
Bash
Java-icon
Java
Oracle
Python-icon
Python
Rate $30  /  per hour
Poland

ETL Tester Resume Sample

Experienced Senior ETL Developer skilled in BI, Data Vault, ETL processes, data visualization, and project coordination.
Informatica
Aginity
ETL
SAP
SQL Server
Rate $18  /  per hour
Poland

Programmer Resume Sample

Dedicated Programmer with extensive experience in software development.
Pascal
.NET-icon
.NET
C#-icon
C#
C++-icon
C++
ChatGPT
Git-icon
Git
PostgreSQL-icon
PostgreSQL
Rate $12  /  per hour
Poland

Microsoft PowerBI Developer Consultant Resume Sample

Certified Data Analyst with a Master's degree.
Python-icon
Python
Bash-icon
Bash
ETL
Git-icon
Git
Jira
Jupyter
Linux-icon
Linux
Matplotlib
Numpy-icon
Numpy
Pandas-icon
Pandas
Power BI
Rate $12  /  per hour

I agree to and accept that DevsData LLC will provide better user experience by collecting, analyzing and cataloging information about Internet electronic addresses that I have connected with my devices and about the type of my devices (such as the type and version of software) as well as by making automatic decisions (not involving sensitive data). The agreement applies for the legally binding period, or until either the user or DevsData LLC withdraws from the agreement. Withdrawing from the agreement will result in removing the user's data. Please see our privacy policy.

We use cookies to provide the best experience for you. >More about cookie policyarrow

Book a call with our team

For software development projects, minimum engagement is $15,000.

whatsapp
Prefer email?
Quote mark

Best back-end engineers I've ever worked with...​

“I interviewed about a dozen different firms. DevsData LLC is truly exceptional – their backend developers are some of the best I’ve ever worked with. I’ve worked with a lot of very well-qualified developers, locally in San Francisco, and remotely, so that is not a compliment I offer lightly. I appreciate their depth of knowledge and their ability to get things done quickly. “

Avatar

Nicholas Johnson

CEO OF ORANGE CHARGER LLC;

MENTOR AT YCOMBINATOR

Success

Thank you


We'll get back to you within 1 business day.