Data Analyst & Database Developer & MS SQL Developer

Zkušený datový analytik se silným zázemím v oblasti vývoje SQL a správy databází. Zkušenosti s analýzou dat, reportingem a automatizací. Znalost různých databázových systémů a nástrojů, jako jsou MSSQL, Oracle a Teradata. Má zkušenosti s analýzou finančních dat a reportingem pro bankovní instituce. Dobré komunikační dovednosti a schopnost řešit problémy. Plynulá znalost angličtiny, slovenštiny a češtiny. Rád se seznamuje s novými technologiemi a jeho vášní je fitness, cyklistika a trávení času s rodinou.

SQL Developer 03/2021 - Present

• Logic, stored procedures, functions, and other database-related tasks.
• Initial experience in C# backend programming for an in-house ERP system.
• Development and maintenance of an ERP system (MS Access based).

Data Analyst 12/2020 - 03/2021

• Data analysis and reporting.

Solution Analyst 02/2019 - Present

• Installation and deployment of SAS Viya platform.
• Customization of UI and features of SAS apps.
• Database development and maintenance.
• ETL processing and T-SQL stored procedures.

SFE & Process Analyst 11/2017 - 01/2019

• Analysis and optimization of SME business processes.
• Cooperative preparation of sales plans for SMEs advisors network.
• Data mart maintenance and data quality enhancement.
• Reporting development and automation.
• Data support to surrounding departments.
• Leadership of a junior analyst.

DWH Analyst 05/2017 - 10/2017

• Solving customer business requirements for data sources.
• ETL processing and data structure modifications.
• Modeling and optimization of data models via CASE tools.

Data Analyst 11/2015 - 04/2017

• Development and maintenance of financial data mart.
• Data support to FP&A team.
• Periodical and ad-hoc financial reporting to the board, stockholders, and other departments.
• Calculating branch network bonuses in cooperation with the business team.

Data Analyst 08/2015 - 10/2015

• Re-creation of algorithms for branch network bonuses distribution.
• Reports automation.

Data Analyst 09/2012 - 07/2015

• Regular and ad-hoc reporting and analysis for Top management.
• Development of reports and KPI indicators.
• Automation of reports using VBA and SAS base.
• Regular bonus reports for the branch network (about 500+ bank advisors).

Risk Data Analyst 12/2008 - 08/2012

• Regular and ad-hoc reporting and analysis for RB Top management, including the Risk Department.
• Calculation of adjusting entries.
• Daily cooperation with other departments such as Workout, Early/Late Collections, and Scoring