Data Engineer

Zkušený softwarový vývojář s více než 20 lety praxe v oblasti různých operačních systémů a softwarové architektury. Znalosti v oblasti databázových systémů, vývoje, programování, testování a nasazování. Ovládá širokou škálu programovacích jazyků a technologií. Úspěšně dokončil projekty pro různé klienty.

Oracle specialist (2021 - 2022)

• Worked for a retail banking sector client on the DIH integration platform.
• Developed DDL and DML scripts for DIH using Oracle PL/SQL, FileLoader, GoldenGate and KAFKA.
• Prepared data for metadata-generated DDL and DML scripts based on analyst requirements.
• Consolidated metadata generator outputs, tested scripts for functionality and performance, versioned changes and prepared them for testing and deployment.

DB Programmer (2019 - 2020)

• Worked for a financial services sector client on a digitalisation project for a data warehouse.
• Developed DDL and DML SQL scripts for DWH according to analyst requirements.
• Copied and adapted scripts for 16 instances of the data warehouse.
• Tested scripts for functionality and performance, versioned changes and prepared them for testing and deployment using Teradata and GIT.

DB Programmer (2017 - 2019)

• Worked for a financial services sector client on a digitalisation project.
• Developed PL/SQL packages and scripts for digitalisation using Oracle PL/SQL.
• Performed debugging and testing as part of a team.

DB and ETL Programmer (2017)

• Worked for a consumer finance sector client on a DWH project.
• Developed PL/SQL and CloverETL solutions using Oracle PL/SQL and CloverETL.
• Performed debugging and testing as part of a team.

DB Programmer (2016)

• Worked for a telecommunications sector client on a systems migration project.
• Developed PL/SQL packages and scripts for migration using Oracle PL/SQL.
• Performed debugging and testing as part of a team.

DB and ETL Programmer (2014 - 2015)

• Worked for an insurance sector client on data warehouse operations and development.
• Monitored DWH operations and resolved production issues.
• Performed business and technical analysis of new DWH functionality.
• Developed new functionality and changes to existing functionality, including data models, ETL scripts, debugging, testing and production deployment using Infomatica PowerCenter, Oracle PL/SQL, Oracle Reports and SAS.

ETL Programmer (2013)

• Worked for a telecommunications sector client on systems integration.
• Developed and modified ETL scripts or parts of scripts using Infomatica PowerCenter and Java.
• Performed debugging and testing as part of a team.

APEX Programmer (2013)

• Worked for a software sector client on user interface modifications for Octopos.
• Made system changes according to requirements, including debugging and testing.
• Used Oracle PL/SQL, Oracle APEX, JavaScript, JQuery, HTML and CSS.

DB Programmer (2012)

• Worked for a consumer finance sector client on DWH development and deployment.
• Developed and changed systems or parts of systems according to requirements, including debugging and testing.
• Built optimised database transformation scripts and DDL/DML scripts for data and metadata changes, transformations and processing flow control using Oracle PL/SQL.

Programmer (2012)

• Worked for a cosmetics sector client on intranet application modifications.
• Analysed the existing application and implemented customer-requested changes.
• Performed programming, debugging and testing using PHP, HTML, JavaScript and MSSQL.

ETL Programmer (2011)

• Worked for a retail banking sector client on DWH processing control changes.
• Created and modified transformations for processing control according to requirements.
• Performed debugging and testing using Pentaho.

DB Programmer, ETL Programmer (2009 - 2011)

• Worked for a retail banking sector client on DWH development and deployment.
• Developed and changed systems or parts of systems as part of a team.
• Built optimised database transformation scripts and DDL/DML scripts for data and metadata changes, transformations and processing flow control for Informatica.
• Created system scripts for data object handling and scripts for generating objects for Informatica, and updated documentation using Oracle PL/SQL, Informatica, VBScript, Jscript and PowerDesigner.

DB Programmer (2008)

• Worked for a telecommunications sector client on migration of operational systems.
• Developed and debugged parts of systems as required, as part of a team.
• Created DDL and DML scripts for the migration process, adjusted processing flow control and built PL/SQL packages using Oracle PL/SQL and Informatica.

DB Programmer (2008)

• Worked for a retail banking sector client on various data warehouse subsystems.
• Developed and debugged parts of the DWH system according to requirements, as part of a team.
• Built optimised database transformation scripts and DDL/DML scripts for data and metadata changes, transformations and processing flow control using Teradata, Oracle PL/SQL and Informatica.

DB Programmer (2007)

• Worked for an insurance sector client on a non-life insurance system.
• Investigated code defects, fixed bugs and performed debugging as part of a team.
• Retrieved objects from the repository, resolved reported issues, saved updated objects back to the repository and handed them over for testing using Oracle PL/SQL and Oracle Forms.

DB Programmer (2007)

• Worked for a consumer finance sector client on a loyalty card programme.
• Developed and debugged the database part of the application, including table generation, SQL commands and PL/SQL procedures for business logic.
• Produced the relevant documentation as part of a team using ORACLE PL/SQL, EnterpriseArchitect, Java and .NET.

Programmer (2006 - 2007)

• Worked for a software sector client on a thin client for WorkFlow and CRM.
• Developed and debugged the application and presentation layers above the database system as part of a team.
• Built PHP, CSS, JavaScript, XHTML and Smarty code on a company framework, migrated to the development server and performed debugging using Delphi and EnterpriseArchitect.

Programmer (2005 - 2006)

• Worked for a software sector client on a thin client for bank system administration.
• Developed and debugged the application and presentation layers of an internet application above the database core as part of a team.
• Built PHP, CSS, JavaScript, XHTML and Smarty code on a company framework, migrated to the development server and performed debugging.
• Created PL/SQL packages for the application layer and debugged them using Oracle PL/SQL and EnterpriseArchitect.

Programmer (2004 - 2006)

• Worked for a software sector client on a thin client for access to a bank system.
• Developed and debugged the application and presentation layers of an internet banking application as part of a team.
• Built PHP, CSS, JavaScript, XHTML and Smarty code on a company framework, migrated to the development server and performed debugging.
• Created PL/SQL packages for the application layer and contributed to development of the company framework using Oracle PL/SQL and EnterpriseArchitect.

Consultant, analyst, programmer (2003 - 2004)

• Worked for an insurance sector client on a high-volume document printing system.
• Communicated with the customer, analysed requirements and developed or modified relevant parts of the solution.
• Delivered implementation, training and team-based support.
• Developed user plugins in Delphi, templates for typesetting and control scripts for the print process using Delphi, MS SQLServer2000, JScript, VBScript, PPScript and TeX.

Programmer (2001 - 2002)

• Worked for an e-commerce sector client on a modular internet trading system.
• Developed and debugged parts of the system as part of a team.
• Programmed business logic modules using VisualBasic6, ASP, MS Access2000, MS SQLServer2000 and XML.

Analyst, programmer (1997 - 2001)

• Worked for a health insurance sector client on a MIS for senior and middle management.
• Designed and developed an OLAP database and transformed data from primary systems.
• Designed and developed the presentation layer, documentation, demonstrations and training.
• Used Gentia, Progress4GL, MS Access and VisualBasic6.

Architect, analyst, programmer (2008 - 2010)

• Worked for an education services sector client on an internal information system.
• Designed, developed and implemented the database, application and presentation layers.
• Deployed the system to hosting and provided operational support using PHP, XHTML, JavaScript, CSS, PostgreSQL and Apache.

Analyst, programmer (2010 - 2011)

• Worked for a retail sector client on an e-commerce implementation based on an open source system.
• Took over and adapted open source code, developed additional modules and deployed the solution to hosting.
• Provided operational support using PHP, XHTML, CSS, JavaScript, MySQL and Apache.

Architect, analyst, programmer (1997)

• Worked for a marketing sector client on a system for tracking performance and calculating commissions for a multi-level marketing system.
• Designed, programmed and implemented all parts of the system.
• Used VisualBasic5 and MS Access97.