Štefan Oravec Email & Phone Number

Prague, The Capital, Czech Republic

Architecting and developing the next big thing or two- JSON Schemas everywhere, extended, compiled- Packaging and CI/CD with npm/Jenkins/Open Shift- Simple Query Language in ANTLR4 and compilers to Oracle SQL, JavaScript, Arango DB Query Language- Tons of utPL/SQL | tSQLt tests- Subsystem for versioning JSON Object Graphs in Oracle Database, Microsft SQL Server- Arango DB and even more graphs- loopback.io/typescript/nodejs- Oracle Database PL/SQL, SQL Parser

Prague, The Capital, Czech Republic

RaiffeisenBANKProSeCo - Migration of clients and their products between Core Banking systems- Design of migration process- Architecture and design of data migration tool

Prague, The Capital, Czech Republic

RaiffeisenBANKDICC- Assessment of DWH and BIMultichannel Project- Team Lead of Core Banking integration team- Designer and developer of Data Migration Tool for migration of customer data into new eBankingDICC Team Member- Performance tunning of DWH transformations- Implementation of PowerDesigner model exploration extension- Preparation of basis for Data Governance- PoC of Quality Monitor - system for monitoring Data Quality in DWH

Prague

Independent Oracle Technology Consultant helping Principal Engineering with - Sourcing Oracle/Java professionals - Oracle technology consultancy - Systems architecture - Performance estimate - Work time estimates - Development of internal systems

Prague, The Capital, Czech Republic

Integration of various systems using Oracle SOA Suite- interface and business process analysis- design of services- development of composite applications and BPEL processes, XSL transformationsEvent Manager- Event-driven rule-based notification and fee engine built using Oracle Advanced Queueing and PL/SQL integrated using Oracle SOA Suite- main work on core layers and deployment scripts

Prague

Independent Oracle Technology Consultant helping Raventia with- Oracle technology consultancy- Performance estimate- Development of Oracle Database based systems

Prague, Czech Republic; Ankara, Turkey

Database for Identification and Registration of Ovine and Caprine Animals for CFCU TurkeyOracle 11gR2 SE, Oracle APEX 4.0, Oracle SQL Developer Data Modeler, MS Visual Studio 2010 - analysis of business processes and requirements for animal event & movement notification processing, reports - Oracle performance forecasting and recommendations for proposed HW configuration - design and implementation of code generation for Table API, enum packages, logging - design and implementation of core notification processing - Oracle 11gR2 SE PL/SQL - design and implementation of reporting subsystem - PL/SQL based reporting ETL - reports implemented using Oracle APEX - design and implementation of data migration from Ovine & Caprine Temporary Application, TURKVET and testing environment

Home, Cafe, Park, Train, Airport

In the past:Winter 2010 - RightPeople: - Online Questionnaire application for HR audit - Implemented in Oracle Application Express & Oracle 10g XESpring 2010 - Bohemians 1905, a.s.: - CRM system - invoices, payments, partners, ... - Implemented in Oracle Application Express & Oracle 10g XESpring 2009 - Deloitte CE Service Centre: - Oracle Warehouse Builder OMB+ scripting - deployment and workflow processes, Optimization of reporting SQL

Walviertel Sparkasse: - Integration Adapter built using Oracle Database Advanced Queueing for eBanking on top of SymbolsCUZK (Czech Office For Surveying, Mapping And Cadastre): - Oracle Technlogy & Team Lead - PL/SQL & SQL development guidelines - Design and development of installation SQL+ scripts - Design and implementation of deployment and CI - Design of PL/SQL Unit Testing framework, Logging API, Exception handling API, CRUD Table API - Technological consultancy during design

Home Credit International: - Datawarehouse for HomeCredit.ru - PowerDesigner methodology, Source to target mappings design, Oracle APEX application for Business Dictionary

Time&Material projects in Telefonica O2 CZ&SK: - SMS Server Refactoring - SOLUS Extract - Prepaid Billing HandlerTime&Material projects in Komercni Banka: - Global Loan Limits for Credit Risk Management System