2021 - today: Risk, reinsurance, pension and health solutions

Customer: on request
Role: Senior SQL Developer - working on insurance solutions for UK market

Tasks:
Finance and insurance industry. Working on applications for the one of the biggest professional services firms that provides a wide range of risk, reinsurance, retirement, and health solutions.

• Evaluation and enhancing the performance of a legacy solution, analyzing and optimizing code, queries, and database structures to improve overall system efficiency and responsiveness.
  
• Preparing unit tests for existing stored procedures and functions, ensuring the accuracy and reliability of database logic and functionality
• Refactoring the database, restructuring and optimizing database schema, tables, and relationships to improve data organization, performance and maintainability.
• Gathering information and requirements for a new functionality, collaborating with stakeholders to understand business needs and define functional requirements for the development process.
• Designing and implementing a new architecture for an existing solution, reevaluating system design and components to address scalability, flexibility and performance requirements.
• Creating new database solutions for new clients based on their input files, including the creation of tables, indexes, primary and foreign keys, stored procedures, functions, and views.
• Maintaining databases to ensure optimal functionality and reliability.
• Development of self-generating T-SQL Stored Procedures, Functions and Scripts.
• Achievements (optional):
  • Cut the time it takes to complete existing stored procedures from 90 minutes to less than two minutes.
  • Prepared a custom view for the reporting system to display only necessary data while omitting sensitive information.
  • Resolved deadlock issues to maintain database integrity and performance.
  • Achieved over 90% code coverage by writing unit tests for the existing solution using the T-SQLT framework.

Skills:
MS SQL 2019, T-SQL, T-SQLT, GIT

---

2017 - 2021: various project

Customer: Software House
Role: BI Developer

Projects:
2 years: Leading European financial services group. Offering a wide range of services to corporate and institutional clients. System for collecting information on all transactions related to suspected money laundering, generating XML files to be sent to the financial institution. The system selects suspicious transactions twice a week.

• Analyzing data from various sources.
  
• Designing and preparing the Data Mart model, considering business needs, and reporting requirements, ensuring efficient storage and access to data.
• implementing the BI solution, including designing system architecture, configuring BI tools, and deploying analytical solutions.
• Creating SSIS package to extract, transform and load (ETL) data from different sources.
• Preparing system to reporting AML (Anti-Money Laundering) transactions.
• Improving existing solutions influencing on work on key processes.

Skills:
MS SQL 2016, SSIS
----------------------------------------------------------------------------------------------------
1,5+ year: Maintenance of existing DWH and improvement of existing solutions. Global leader in in-store communication and merchandising solutions for food and non-food retailers, serving 44 markets across Europe, South America, the Middle East, and Asia.

• Modifying SSIS package to extract, transform and load (ETL) data from different sources.
  
• Optimizing queries for performance, analyzing and fine-tuning SQL queries to enhance database performance and improve overall system efficiency.
• Scheduling and monitoring work processes.
• Creating and modifying stored procedures, views, constraints, and SQL scripts, to support database operations and meet business requirements.
• Performing unit tests to validate the functionality and integrity of database objects and SQL script.
• Maintaining, monitoring and developing data warehouse and SSAS.
• Preparing mapping file concatenating different systems.
• Loading data from ERP systems.
• Preparing QlikView reports for business stakeholders, leveraging data visualization tools to create insightful and actionable reports for informed decision-making.

Skills:
MS SQL 2012, SSIS, SSAS, QlikView

---

2015 - 2017: various projects

Customer: industry/type
Role: BI & DW Developer/ Biztalk Developer

Projects:
1 year: Swedish recruitment agency. Creating a reporting system from scratch based on Tableau and Matillion ETL.

• Creating Matillion ETL orchestrations to extract, load, and transform (ELT) data from different sources, ensuring efficient data integration and processing.
  
• Scheduling and monitoring work processes.
• Performing unit tests to validate the functionality and integrity of ETL processes, ensuring data accuracy and reliability.
• Introducing solutions to improve performance, identifying areas for optimization and implementing enhancements.
• Preparing Tableau reports for business stakeholders, leveraging data visualization tools to create insightful and actionable reports for informed decisionaking.
• Working with key people in the company to collect requirements.

Skills:
Matillion ETL, Redshift, Tableau
----------------------------------------------------------------------------------------------------
1+ year: Manufacturer of paints for interior and exterior painting. Development of the existing DWH, and the creation of a system for collecting information from paint mixing machines around the world. Collection of information on which colors were used, in what quantities. Based on this data, a sales forecasting system was developed.

• Creating SSIS packages to extract, transform, and load (ETL) data from different sources, ensuring seamless integration and efficient data processing.
  
• Optimizing queries and the database for performance, analyzing and fine-tuning SQL queries and database structures.
• Loading data from tinting machines, handling a high volume of files (over 5000 per day), ensuring accurate and timely extraction, transformation, and loading of data.
• Scheduling and monitoring work processes.
• Creating stored procedures, views, triggers, constrains and SQL scripts.
• Updating and managing Excel and Power BI reports to ensure accuracy and relevance of data for stakeholders.

Skills:
MS SQL 2008 R2, SSIS, Power BI
----------------------------------------------------------------------------------------------------
~1 year: A global leader in wine and spirits.

• Providing support and daily maintenance for the existing BizTalk Server (BTS) 2010 solution for an IT company.
  
• Scheduling and monitoring work processes, overseeing the execution of scheduled tasks and workflows.
• Developing and testing mappings used for the integration solution, ensuring data mapping and transformation processes are accurate and meet business requirements.
• Designing and implementing a BizTalk Server 2010-based Enterprise Application Integration (EAI) solution, facilitating seamless integration and communication between disparate systems and applications within the organization.

Skills:
Microsoft BizTalk Server

---

2013 - 2015 (~1,5 year): Development of DWH for provider of property and casualty insurance products and services

Customer: IT Consulting
Role: BI Developer

Tasks:
Development of DWH for provider of property and casualty insurance products and services in the North American Market.

• Creating SSIS packages to extract, transform, and load (ETL) data from different sources, ensuring seamless integration and efficient data processing.
  
• Working with a ready-made solution.
• Scheduling and monitoring work processes.
• Creating stored procedures, views, constraints, and SQL scripts to support database operations and meet business requirements.
• Performing unit tests to validate the functionality and integrity of database objects and SQL scripts.
• Maintaining technical documentation, documenting system architecture, data models, and implementation details.

Skills:
MS SQL 2008 R2, SSIS