Location
PolandRate
$37
/ per hour
Years of experience
12+About
As a Business Intelligence developer and data analyst with over 12 years of experience, I have honed my skills in supporting senior management decisions within the financial and IT sectors. My expertise includes writing advanced T-SQL queries, creating complex stored procedures for financial data analytics, and developing ETL processes using SSIS and Talend. Additionally, I excel in creating ad-hoc and subscription-based reports using SSRS and Power BI, managing and developing databases on MS SQL Server, and developing data warehouses and data vault models. With a strong foundation in mathematics and statistics, I have built and implemented credit scoring models and designed business systems, such as electronic credit applications. Throughout my career, I have held various roles, including Senior Data Warehouse Engineer at RCI Banque, Business Intelligence Developer at Liberty Mutual Insurance, and Fullstack SQL Developer at PwC IT Services. I have successfully developed data warehouses, managed databases, and created ETL processes across different platforms, including AWS and Azure DevOps. My greatest accomplishments include restoring SQL Server functionality, migrating data sources, and creating key performance indicator reports from scratch. With advanced certifications in SQL Server, Power BI, and AWS, I am well-equipped to tackle complex data challenges and provide valuable insights to drive business decisions.Tech Stack
Database, AWS, Azure DevOps, CI/CD, Database Management System (DBMS), GIS, Kafka, MS SQL, Power BI, SQL Server, Ssis, SSRS, T-SQLExperience
- Creating and managing data warehouses using T-SQL on MS SQL Server, AWS, and Exasol databases. Developing advanced ETL processes with tools such as SSIS, Talend Open Studio, and Talend Cloud..
- Crafting complex T-SQL queries and stored procedures to support financial data analytics and other business needs.
- Generating ad-hoc and subscription-based reports using SSRS and Power BI, along with KPI reports and other analytical tools.
- Overseeing the development, performance tuning, and administration of databases on MS SQL Server.
- Working closely with stakeholders to understand their needs and convert them into effective technical solutions.
- Designing and documenting various business systems, including electronic credit applications and credit scoring models.
- Managing and developing CRM applications, supporting user requests across different markets, and ensuring data integrity and accessibility.
Employment history
Senior Data Warehouse Engineer, RCI Banque SA
June 2022 - Present
- Developing data warehouse and the underlying data vault model (Data Vault 2.0) using SQL in Exasol database.
- Creating ETL processes with Talend Cloud, Apache Kafka, and Confluent Kafka.
- Utilizing tools such as DBeaver, GitHub, and Gliffy diagrams in a Confluence, Jira, and Scrum environment.
Business Intelligence Developer, Liberty Mutual Insurance
June 2021 - June 2022
- Gathering business requirements and translating them into technical solutions.
- Developing data warehouse using T-SQL on MS SQL Server and AWS.
- Creating ETL processes using SSIS with Visual Studio, CI/CD pipelines, and Azure DevOps.
Fullstack SQL Developer, PwC IT Services
November 2020 - May 2021
- Creating ETL processes using Talend Open Studio for data integration and SSIS with Visual Studio.
- Developing and performance tuning of data warehouse using T-SQL on MS SQL Server.
- Managing tools like CyberArk, Sourcetree, GitLab, Jenkins, and Kubernetes in a Jira environment.
System Administrator – SQL Developer, Elavon
September 2018 - November 2020
- Gathering business requirements and translating them into technical solutions.
- Managing and developing databases on MS SQL Server as a database administrator.
- Creating reports using SSRS with Visual Studio and Power BI.
usiness Intelligence Developer -Database Architect / Programmer, Beqom
September 2017 - August 2018
- Gathering business requirements and translating them into technical solutions.
- Managing databases and creating reports on MS SQL Server using T-SQL and SSRS.
- Supporting requests from top-tier customers and providing solutions.
Data Analyst / Report Developer, Pitney
February 2017 - September 2017
- Gathering business requirements and translating them into technical solutions.
- Creating reports using Power BI and SSRS with Visual Studio on MS SQL Server.
- Working with Salesforce and SAP S/4HANA databases.
Business Intelligence Specialist, Profi Credit
September 2016 - February 2017
- Creating analytical reports and ad-hoc analysis in MS Excel using T-SQL and MySQL.
- Preparing budget plans for sales and marketing departments.
- Using tools like Talend Open Studio for MDM and Toad for MySQL.
Credit Risk Team Leader / Senior Risk Specialist, Cooperative Savings and Credit Union
August 2012 - August 2016
- Gathering business requirements and translating them into technical solutions.
- Building, validating, and monitoring credit scoring/rating (PD) models using STATISTICA.
- Designing, testing, and documenting an electronic credit application.
- Developing reports in MS Excel using VBA and T-SQL on MS SQL Server.
Statistics Developer, Kamsoft
January 2012 - April 2012
- Creating sales reports in the area of pharmacy using Oracle databases.
Education history
Silesian University of Technology in Gliwice
2010 - 2012
Computer Science
Faculty of Applied Mathematics
Faculty of Applied Mathematics
Silesian University of Technology in Gliwice
Master of Science in Mathematics / specialisation: Statistics
Faculty of Applied Mathematics
Faculty of Applied Mathematics