BI Analyst & DWH Developer

Kandidát je zkušený specialista na datové sklady, který pracuje s databázemi více než 25 let. Na své poslední pozici prováděla programové změny v databázi, byla zodpovědná za provoz databáze Oracle, opravy chyb, vytvářela nové sestavy a exporty a pomáhala s migrací na DataLak. Při své práci používala především: Oracle SQL, PL/SQL, PostgreSQL a PL/pgSQL, Amazon Redshift SQL, ETL, Confluece. Vzhledem k tomu, že na své poslední pozici pracovala v zahraniční společnosti, kde denně používala angličtinu, komunikace v angličtině pro ni nebyla problém. Kandidátka koordinovala tým v Evropě, který zahrnoval 3 databázové specialisty.

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.