BI Analyst & DWH Developer

The candidate is an experienced Data Warehouse Specialist who has been working with databases for over 25 years. In her last position, she made database programming changes, was responsible for Oracle database operations, bug fixes, created new reports and exports, and assisted with migration to DataLak. During her work she mainly used: Oracle SQL, PL/SQL, PostgreSQL and PL/pgSQL, Amazon Redshift SQL, ETL, Confluece. Since in her last position she worked in a foreign company, where she used English on a daily basis, communication in English was not a problem for her. The candidate coordinated a team in Europe, which included 3 database specialists.

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.