MS SQL Developer & Oracle Developer

Seniorní vývojář SQL a Oracle s více než 20 lety zkušeností. Má zkušenosti s různými operačními systémy včetně Windows, HP-UX, OS2, DOS, Novell NetWare a RSX-11. Je také zběhlý v navrhování architektury softwarových řešení pro desktopové a vícevrstvé aplikace a umí programovat v různých jazycích, okrajově se zajímá např. o Javu. Během své dlouholeté praxe získal zkušenosti v oblasti databázových systémů, vývoje, programování, testování a nasazování. Kromě toho má také dovednosti v oblasti návrhu a instalace HW systémů v různých konfiguracích, jako jsou mainframe, terminálové sítě a sítě klient-server. Na nedávném projektu v bankovnictví vyvinul na základě návrhu analytika řešení, které bylo následně nasazeno. Seznámil se také s modelováním relačních databází a jeden z jeho předchozích projektů, který byl určen pro jazykovou školu, byl postaven na databázi PostgreSQL. Pracoval převážně v malých týmech, naposledy v agilním prostředí. Ačkoli nikdy nebyl ve vedoucí pozici, měl několikrát příležitost předávat zkušenosti méně zkušeným začínajícím kolegům. Nedělá mu problém číst, psát a dokumentovat v angličtině, ale má potíže s ústní komunikací.

Oracle Specialist (2021 - 2022)

• Preparation of data for metadata generation of DDL and DML scripts for DIH as specified by analysts
• Consolidation of metadata generator outputs
• Testing individual scripts for functionality and performance
• Verification, completion of deployment conditions, handover for testing and deployment
• Working as part of a team

DB Programmer (2019 - 2020)

• Development of DDL and DML scripts for DWH according to specifications, debugging
• Working in a team
• Writing DML and DDL SQL scripts according to analysts' specifications
• Copying and editing scripts for 16 data warehouse instances
• Testing individual scripts for functionality and performance
• Verification, completion of deployment conditions, handover for testing and deployment

DB Programmer (2017 - 2019)

• Development of PL/SQL packages and scripts for digitalization according to specifications, debugging, testing
• Working in a team

DB and ETL programmer (2017)

• PL/SQL and CloverETL development according to specifications, debugging, testing
• Working in a team

DB programmer (2016)

• Development of PL/SQL packages and scripts for custom migration, debugging, testing
• Working in a team

DB and ETL programmer (2014 - 2015)

• Supervision of data warehouse operations - troubleshooting operational issues
• Business analysis and technical analysis of new DWH functionalities
• Development of new and changes to existing functionalities, creation of data model, ETL scripts or their parts, debugging, testing, deployment
• Working in a team

ETL programmer (2013)

• Development and modification of ETL scripts or their parts, according to specifications, debugging, testing
• Working in a team

APEX programmer (2013)

• User interface modifications
• Modifications to the system according to the specifications, debugging, testing

DB programmer (2012)

• Development and deployment of the bank's data warehouse systems
• Development and modification of systems or parts of systems, according to specifications, debugging, testing
• Working in a team
• Development of optimized database transformation scripts, DDL and DML scripts for data and metadata editing in the data warehouse, transformations and processing flow control

Programmer (2012)

• Modifications to the intranet application
• Making changes to the application according to customer requirements, analysis of the existing application, programming, debugging, testing

ETL programmer (2011)

• Modification and addition to the processing control of the bank's data warehouse system
• Creating and modifying transformations for processing control as specified, debugging, testing

Analyst, programmer (2010 - 2011)

• Implementation of el. Business on the basis of an open source system
• Configuration, deployment of the graphic part, linking the store to suppliers and other cooperating systems
• Adoption and modification of open source code, development of additional modules, deployment to hosting, operational support

DB programmer, ETL programmer (2009 - 2011)

• Development and deployment of the bank's data warehouse systems
• Development and changes of systems or their parts, according to specifications, debugging, testing
• Working in a team
• Development of optimized database transformation scripts, DDL and DML scripts for data and metadata modification in the data warehouse, transformations and processing flow control for Informatica, creation of system scripts for data object handling, creation of object generation scripts for Informatica
• Editing and adding documentation

Architect, analyst, programmer (2008 - 2010)

• Internal information system for a language agency - records of students, lecturers, attendance, performance, course planning, cooperation with accounting and banking system
• Design, development, implementation of database, application and presentation layers
• Deployment on hosting, support of operation

DB programmer (2008)

• Migration of operational systems
• Development and debugging of parts of systems according to specifications
• Working in a team
• Creating DDL and DML scripts for migration process, modifying processing flow control, creating PL/SQL packages, debugging, modifying documentation

DB Programmer (2008)

• Different subsystems of the bank's data warehouse
• Development and debugging of part of the data warehouse system according to the specification
• Working in a team
• Development of optimized database transformation scripts, DDL and DML scripts for data and metadata editing in the data warehouse, transformations and processing flow control for Informatica

DB Programmer (2007)

• User interface and database fixes
• Finding bugs in code, fixing them, debugging
• Working in a team
• Acquiring objects from the repository, finding reported bugs, fixing bugs in objects and debugging them, saving modified objects to the repository, submitting objects for testing

DB programmer (2007)

• Application development for card program
• Development and debugging of the database part of the application, generating tables, SQL statements and PL/SQL procedures for the business logic of the application
• Creating the corresponding part of the documentation
• Working in a team

Programmer (2006 - 2007)

• Thin client for WorkFlow and CRM
• Development and debugging of the application and presentation layer on top of the database system
• Working as part of a team
• Creating PHP, CSS, JavaScript, XHTML, Smarty code over the company framework, migrating to the development server, debugging

Programmer (2005 - 2006)

• Thin client for banking system administration
• Development and debugging of the application and presentation layer of a web-based management application on top of a database core banking application
• Working as part of a team
• Creating PHP, CSS, JavaScript, XHTML, Smarty code over the company framework, migration to development server, debugging
• Creating PL/SQL packages for the application layer, debugging

Programmer (2004 - 2006)

• Thin client for accessing the banking system
• Development and debugging of the application and presentation layer of the banking system web application
• Working in a team
• Creating PHP, CSS, JavaScript, XHTML, Smarty code on top of the company's framework, migration to the development server, debugging
• Creating PL/SQL packages for the application layer, debugging
• Development of the corporate framework

Consultant, analyst, programmer (2003 - 2004)

• System for high-volume document printing
• Customer communication, requirements analysis, development or modification of relevant parts, implementation, training
• Work in a team
• Development of user plugins in Delphi, development and modification of rate templates, development and modification of print process control scripts

Programmer (2001 - 2002)

• Building block system for internet trading
• Development and debugging of parts of the internet trading system
• Working in a team
• Programming the trading logic modules of the system

Analyst, Programmer (1997 - 2001)

• MIS for senior and middle management of a health insurance company
• OLAP database design and development, data transformation from primary systems, presentation layer design and development, documentation, demonstration, training

Architect, analyst, programmer (1997)

• Performance recording and commission calculation system for multi-level marketing system
• Design, programming, implementation of all parts of the system