BI Analyst & DWH Developer

Kandidát je skúsený špecialista na dátové sklady, ktorý pracuje s databázami viac ako 25 rokov. Na svojej poslednej pozícii robila programové zmeny v databáze, bola zodpovedná za prevádzku databázy Oracle, opravy chýb, vytvárala nové zostavy a exporty a pomáhala pri prechode na DataLak. Počas svojej práce používala najmä: Oracle SQL, PL/SQL, PostgreSQL a PL/pgSQL, Amazon Redshift SQL, ETL, Confluece. Keďže na poslednej pozícii pracovala v zahraničnej spoločnosti, kde denne používala angličtinu, komunikácia v angličtine pre ňu nebola problémom. Kandidátka koordinovala tím v Európe, ktorý zahŕňal 3 databázových špecialistov.

Jun. 2019 - May 2021 - Database Developer - Company A

• Developed databases for applications using Oracle SQL and PL/SQL, PostgreSQL and PL/PGSQL, and Amazon Redshift SQL.
• Created ETL processes for data warehouse and data lake using stored code, SQL, and shell scripting.
• Ensured data quality and consistency.
• Developed data lake reporting datamarts and data exports using Amazon Redshift, SQL, and Unix shell scripting.
• Scheduled export files generation using Airflow.
• Migrated Oracle database stored code to PostgreSQL and Oracle DWH to AWS Datalake.
• Deployed to production and pre-production environments using Liquibase, Jenkins, SQL Developer, and DBeaver.
• Supported Java development and testing teams and onboarded new team members.
• Coordinated and shared knowledge with the European part of the database team and created documentation using Confluence.

Sep. 2018 - Dec. 2018 - DWH Developer - Company B

• Exported data mappings from Power Designer and imported them into ODI for testing.
• Prepared and maintained operational and user documentation.

Feb. 2018 - Apr. 2018 - Database Developer - Company C

• Developed applications using T-SQL.

Sep. 2010 - June 2017 - DWH Developer - Company D

• Gathered user requirements, analyzed them, and prepared technical specifications.
• Designed and developed DWH solutions using Oracle SQL, PL/SQL, and AIX Unix shell scripts.
• Tested and deployed solutions into production environment.
• Improved data quality and performed data migration.
• Administered and maintained Oracle DWH databases, including performance tuning and security management.
• Operated and maintained ETL processes using ODI, configured workflows, and managed access rights.
• Provided technical advisory, prepared documentation, and trained employees.
• Led a team.

May 2008 - Sep. 2009 - Application Design Architect - Company E

• Implemented and provided post-implementation support for the new information system of the Social Insurance Agency in Slovakia (EZU).
• Integrated systems and gathered user requirements.
• Prepared technical documentation.