Ján Majláth - Projects I have attended
Project 18
| Company | Quin.Online, s.r.o (my own company) |
| Customers | Individual customers, who want to use render farm service |
| Duration | From 2022 |
| Description | I have created render farm service for 3D software Blender |
| My tasks | To design and to implement render farm. Choose technology and software to use to make whole process (to customer) as easy as possible. To install and to configure components (OS, web server, DB server, PHP module, SSL certificates, etc.) To implement software to control render farm processes (every single frame have to be rendered exactly once, sw have to deal with HW failures and user errors). To implement Blender addon. To implement web page. |
| Programming languages | Python, PHP, HTML, jQuery, CSS, stored procedures – MariaDB, Linux shell scripts |
| Applications | Blender |
| Web server | Apache2 |
| Database | MariaDB / MySQL |
| OS | Debian (Linux) |
| Team size | 1 |
| My position | architect, designer, programmer, tester |
| URL | www.viribusfarm.com |
Project 17
| Company | Kedros |
| Customers | Czech electric utility company |
| Duration | 6 months |
| Description | We delivered product „Data collection center for electricity meter readings“. |
| My tasks | Design and implement SQL queries for reports – according to user requirements. |
| Programming languages | SQL |
| Applications | PL/SQL Developer, Jira, Confluence, Enterprise manager |
| Database | Oracle (12c) |
| Team size | 4 |
| My position | designer, programmer |
Project 16
| Company | Kedros / Skytoll |
| Customers | Road and Motorway Directorate of the Czech Republic |
| Duration | from 2019 |
| Description | To build DWH from scratch. To analyze source systems. To process big amount of data. |
| My tasks | To implement data processing from source systems to stage layer (stage layer contains whole history of data). Goal was to implement a system that is as autonomous as possible. |
| Programming languages | SQL, PL/SQL |
| Applications | PL/SQL Developer, Jira, Confluence, M$ Office |
| Database | Oracle (12c) |
| Team size | 3 - 10 |
| My position | analyst, designer, programmer, operations programmer |
Project 15
| Company | Kedros |
| Customers | Slovak electric utility company |
| Duration | from 2015 |
| Description | Electric utility company needs data collection center application. Data is collected every day and there is hard time limit to process it. Application is quite complex - database on backend, java application as frontend, several interfaces (in and out) to communicate with another institutions and applications. There is separate modul called Balance to predict electricity consumption. |
| My tasks | To design and implement requirements into database. Analyze and improve performance. Analyze and fix non-standart situation in production. To prepare release scripts. |
| Programming languages | SQL, PL/SQL |
| Applications | PL/SQL Developer, Jira, SVN, M$ Office, Zabbix, EA |
| Database | Oracle (12c) |
| Team size | 10 – 20 |
| My position | analyst, designer, programmer, operations programmer |
Project 14
| Company | FirstData |
| Customers | Banks |
| Duration | 4 years |
| Description | FirstData provided virtual POS terminals to customers. Product was called IPG (Internet Payment Gateway). |
| My tasks | To design and implement database changes according to requirements. To prepare release scripts. Operation was not interrupted (during releasing) so preparation had to be very precise. |
| Programming languages | SQL, PL/SQL, Unix Shell, Win .bat files |
| Applications | SQL*Plus, TOAD, PL/SQL Developer, GIT, Jira, Confluence, Gerrit, M$ Office |
| Database | Oracle |
| Team size | 8 – 15 |
| My position | designer, programmer, operations programmer |
Project 13
| Company | FirstData |
| Customers | Banks |
| Duration | 2 years |
| Description | FirstData provided services to banks - issuing a cards, authorization, reports, risk monitoring, etc. |
| My tasks | Data processing on backend - import data (from text files), data processing (transformation and reconciliation), generate reports and exports - via Unix shell scripts and database stored procedures. |
| Programming languages | SQL, PL/SQL, Unix Shell |
| Applications | PL/SQL Developer, Subversion, M$ Office |
| Database | Oracle |
| Team size | 1 – 10 |
| My position | analyst, designer, programmer, operations programmer |
Project 12
| Company | IBM Slovakia |
| Customers | Slovak Telecom |
| Duration | 6 months |
| Description | Euro conversion of DWH. |
| My tasks | To analyze data processing (ETL), to design and to implement conversion of historic data. |
| Programming languages | SQL, PL/SQL |
| Applications | Informatica Power Center, PL/SQL Developer, Subversion, M$ Office |
| Database | Oracle |
| Team size | 10 |
| My position | programmer |
Project 11
| Company | IBM Slovakia |
| Customers | Slovak Telecom |
| Duration | 4 months |
| Description | Maintenance and operation of DWH. |
| My tasks | To analyze data processing current and desired state, to design and to implement solution. To create test scenarios. |
| Programming languages | SQL, PL/SQL |
| Applications | Informatica Power Center, PL/SQL Developer, Subversion, M$ Office |
| Database | Oracle |
| Team size | 10 |
| My position | programmer |
Project 10
| Company | IBM Slovakia |
| Customers | Slovak Telecom |
| Duration | 1 month |
| Description | Unstructured archiving. Data had to be stored during defined period. |
| My tasks | To implement script to archive, to create test scenarios. |
| Programming languages | Unix shell scripts |
| Applications | Tivoli storage manager, cygwin |
| Team size | 5 |
| My position | programmer |
Project 9
| Company | IBM Slovakia |
| Customers | Slovak Telecom |
| Duration | 19 months |
| Description | Building a DWH for Slovak Telecom. DWH had to provide data for several areas of services. |
| My tasks | To analyze, to design and to implement solution according to requirements - my areas: revenue assurance and trouble ticket management. |
| Programming languages | SQL, PL/SQL |
| Applications | Informatica Power Center, TOAD, PL/SQL Developer, M$ Office, Subversion |
| Database | Oracle |
| Team size | 50 |
| My position | analyst (partly), designer, programmer |
Project 8
| Company | Allianz |
| Customers | Internal departments |
| Duration | 43 months |
| Description | We built our proprietary IT system - for life and invest insurance - maintenance data about contracts, accounting, reporting, claims settlement. |
| My tasks | To analyze, to design and to implement solution according to requirements. Operation of investment processing. To solve nonstandard situations. To create and generate reports. |
| Programming languages | SQL, PL/SQL, Form Builder, Oracle Designer, Report Builder |
| Applications | TOAD, Visual Sorce Safe, M$ Office, Lotus Notes |
| Database | Oracle |
| Team size | 3 – 8 |
| My position | analyst (partly), designer, programmer, operations programmer |
Project 7
| Company | AssetSoft |
| Customers | Tax office |
| Duration | 8 months |
| Description | We built DWH for Tax Office. |
| My tasks | To implement data processing according to analyse - ETL processes. |
| Programming languages | SQL, stored procedures - Informix |
| Applications | Informatica Power Center |
| Database | Informix |
| Team size | 12 |
| My position | programmer |
Project 6
| Company | AssetSoft |
| Customers | Slovak insurance company |
| Duration | 3 months |
| Description | To implement changes to the application for the processing of insurance claims. |
| My tasks | To implement changes according to analyse. To make changes into database objects structures. |
| Programming languages | C++, SQL, PL/SQL |
| Database | Oracle, M$ Access |
| Team size | 4 |
| My position | programmer, database administrator |
Project 5
| Company | AssetSoft |
| Customers | Slovak insurance company |
| Duration | 4 months |
| Description | To implement changes to DWH according to customer requests. |
| My tasks | To implement changes to DWH according to analyse. |
| Programming languages | SQL, PL/SQL, Form Builder |
| Database | Oracle |
| Team size | 3 |
| My position | programmer |
Project 4
| Company | Slovak Telecom |
| Customers | Internal departments |
| Duration | 15 months |
| Description | Maintenance of DWH. |
| My tasks | Administration of Oracle OLAP database, to implement monitor applications (for daily processing), report creating. |
| Programming languages | SQL, PL/SQL, C, C++, Unix Shell scripts |
| Database | Oracle |
| Team size | 10 |
| My position | programmer, operations programmer, db administrator |
Project 3
| Company | Apis |
| Duration | 1 month |
| Description | Software for truck scales |
| My tasks | To implement software to measure weight of trucks, and to synchronise with PC. |
| Programming languages | C++ |
| Team size | 3 |
| My position | programmer |
Project 2
| Company | Apis |
| Customers | Bank |
| Duration | 8 month |
| Description | To prepare existing software to year 2000 - Signature specimens application. |
| My tasks | To analyze existing code and to implement changes (2 digit year to 4 digit year). |
| Programming languages | C++ |
| Database | CodeBase |
| Team size | 2 |
| My position | programmer |
Project 1
| Company | University |
| Duration | 2 years |
| Description | Research for the master's thesis |
| My tasks | Development of a software package for simulating the learning process of a Kohonen neural network and testing its properties. The package included programs for: training the network, testing a robot arm in 2D and 3D space (with the arm "controlled" by the trained network), and generating suitable samples for network training. |
| Programming languages | C++ |
| Team size | 1 |
| My position | programmer and user |