Big Data Developer & Data Analyst & Data Engineer & Data Manager & Database Developer & MS SQL Developer

Zkušený datový inženýr, který má více než 3 roky zkušeností s prací s daty. Na své současné pozici jsem zodpovědný za implementaci komplexních DB pro reporting ( MS SQL), nasazování kódu, monitorování a úpravy výkonu, také implementaci ETL procesů pro naplňování a údržbu DB pro reporting (SSIS, SSRS). Mezi její dovednosti patří MS SQL, SSIS, návrh rozsáhlých datových modelů (PowerDesigner), cloudové platformy (AWS, GCP). Na své předchozí pozici zastávala pozici datového analytika, kde prováděla návrh a vývoj dashboardů a integračních DB řešení (MS SQL, SSIS) aSharePoint, analýzu procesů, zpracování dat, výpočet klíčových metrik metodami lineární algebry. Zastávala také pozici vedoucí týmu s 10 vývojáři. K jejím hlavním úkolům patřila komunikace se zákazníky, řízení pracovního procesu se subdodavateli a výběr a vyhodnocování technologií, které budou použity pro všechny projekty ve vývoji, prováděla také revizi kódu a kontrolu kvality vývoje. Co se týče jazyků, hovoří bez problémů anglicky, také rusky, má základní znalosti němčiny a domluví se česky.

January 2023 - Present Senior Database Engineer

Responsibilities

• Implementing complex reporting databases using MS SQL, including code deployment, monitoring, and performance tuning
• Developing ETL processes for populating and maintaining reporting databases using SSIS and SSRS
• Collaborating with the DBA team on capacity planning and release implementation
• Skills: MS SQL, SSIS, PowerDesigner, cloud platforms (AWS, GCP)

October 2020 - December 2022 Data Analyst

Responsibilities:

• Designing and developing dashboards and integration solutions using MS SQL, SSIS, and SharePoint
• Performing data analysis, processing, and calculation of key indicators using Python and linear algebra methods
• Collecting use-cases for AI projects, preparing documentation, and presenting findings
• Collaboration with manufacturing teams, including the German team

April 2019 - September 2020 Analyst BI / SQL Developer

Responsibilities:

• Designing and developing enterprise and departmental data warehousing and ETL solutions
• Coordinating activities with data source application owners to ensure integration, data integrity, and quality
• Translating business requirements into ETL designs and mapping specifications
• Collaboration with colleagues at ČSOB in Bratislava

October 2017 - April 2019

Responsibilities:

• Working as a back-end developer with MS SQL for the "IFRS17" project

June 2015 - September 2017 Team Lead Developer

Responsibilities:

• Leading software development projects for global markets, utilizing technologies such as XML/XSLT, MS SQL, and Python
• Uploading data according to a schedule to the Asset Liability Management (ALM) system
• Utilizing JIRA and Git for all stages of development, including analysis, planning, coding, testing, and release preparation

April 2013 - June 2015 Team Lead Developer

Responsibilities:

• Heading a team of 10 developers and overseeing all aspects of banking software projects
• Managing communication with customers and subcontractors
• Conducting code reviews and ensuring quality control

February 2011 - April 2013 Support Engineer

Responsibilities:

• Providing support for the Diasoft FA# system, including addressing issues and creating additional reports
• Configuring the system for multiple bank branches

February 2010 - February 2011 Leading Expert of Support Department

Responsibilities:

• Supporting the Diasoft FA# system and handling tasks related to bank cards, individual deposits, and credits
• Registering bugs and installing patches
• Developing bank reporting and external loadings in the system

April 2007 - February 2010 Engineer Configuration and Supporting

Responsibilities:

• Performing pre-design works, analysis, modeling, and reengineering of business processes
• Implementing systems and providing training to users
• Working with modules of the Diasoft 5NT system, including Diasoft FA#. Bank.Back and Diasoft FA#. Retail.Back

Achievements:

• Successfully completed around 10 projects, including the implementation of the Diasoft FA#. Retail.Back module with data migration