Location
PolandRate
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 and Cloud, 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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Creating sales reports in the area of pharmacy using Oracle databases.
Education history
Faculty of Applied Mathematics
Faculty of Applied Mathematics