Juraj Balak

Senior Oracle PL/SQL Analyst / Developer at Well Data Consistency / Master Data Store Project

Analyze bussines requirements of existing customers of ProfitLine/Price, design the solution inline with ProfitLine/Price tool, develop the solution. Analyze, design and develop the new features of ProfitLine/Price, which are offered in the new release of ProfitLine/Price. Development using Oracle PL/SQL, Perl scripting. SQL tuning and performance improvements.

Design and develop forms in ASCII format to be run on ASCII terminals (VT220), PL/SQL packages to support the functionality of the forms to be developed for new production system and common error handling system, debug and trace system, independent language system to be used in user interface (forms) for the production system to be used in various productions in various European countries.

Design and develop the structural, graphical and functional design of the application as well as work flow diagrams, set of PL/SQL packages and functions to provide the database interface from VISI application to the MIDDLEWARE's database using PL/SQL and PRO*C/C++ programming techniques by connecting MS Visual Studio 6.0 and VISI application to Oracle 8i database.

Design and develop various procedures, functions, packages and triggers to meet system’s requirements using Oracle’s PL/SQL language and other Oracle tools including dynamic SQL techniques, various server processes using C language and C compiler on AIX operating system accessing Oracle 7.3 database with usage of embedded (precompiled) SQL techniques, various data load utilities for customer’s data, which needed to be converted from the customer’s previous billing system

design and develop the batch processing system for the daily overnight transfer of the data from the LIVE system to the REPORTING system. The system development involved PL/SQL functions, procedures, packages, snapshots and triggers to capture the daily changes on the LIVE system. Design and develop an error handling and management procedures for unusual, but possible error situations like network problems, power cuts, etc.

For MISER application, design and develop forms, libraries, functions, procedures, packages and triggers using PL/SQL language on both server and client sides to meet requirements to validate the records from the data files and individually (by the operator) to re-validate records, which did not pass through the validation process initially.

To convert the existing code and the report layouts from Oracle ReportWriter 1.1 to Oracle Reports 2.5 providing enhancements required by the customer, the re-development of the report layouts, PL/SQL procedures, functions and triggers.

The project has covered the development and testing of the information system for the Sergeant at Arms office at House of Commons in United Kingdom’s Parliament in London.To develop and perform the test strategy for particular system modules to meet customer’s requirements.

The introduction and quality management courses in Science Systems, understand the quality management manual and procedures required in Science Systems (Industrial) Ltd.

Create a database design (E-R diagram, DB schema), forms and reports to meet customer’s requirements using Oracle Forms 4.5, Reports 2.5) using PL/SQL language,tools for batch report processing to create ASCII output files for various schematic systems defined by the customer using Oracle Forms 4.5, Reports 2.5. design and develop the database interface to storedata from the MicroStation’s drawings to the Oracle7 database using MicroStation’s internal C language based on ANSI C.

The project has covered the development of the applications for the new information and reservation system called Complex Services for Passengers for Slovakian Railways. To develop and test particular modules (forms and reports) to meet customer’s requirements using Informix SQL and 4GL release 4.0 on UNIX platform.

1–4 Semester: Subjects oriented to mathematics, algebra, geometry,management of IS and HR 5–10 Semester: Subjects oriented to Informatics,Software Development. Methodology of creation of IS, CASE, Operation analysis, developing tools for various programming languages, OS and DBs.