Marek Spisak

Design and development of system for Work Order Automation for service centers of Sky Italia.
System was based on MS SQL Server and front-end written in C# using Microsoft Visual Studio.
For project reporting purposes were used SQL Server Reporting Services.

Implementation of Euro support into Italian Management Information System for Automotive Dealers used by distributors of Mercedes Benz, Smart, Chrysler, Mitsubishi, Opel, Chevrolet, Peugeot, MAN, Subaru, Škoda/Seat, Suzuki, Volkswagen, Audi, MAN and others.
Implementation of new features and improvements during application life cycle.

Development of system for accounting of payments for domestic refuse for city of Rychvald.
System was written in Borland Delphi and relayed on Borland Database Engine.

Development of Information system for viands producent.
A complete design and development from Database Layer to GUI.
System is responsible for collecting orders, calculation of ingredients consumption for production, handling of Bill of Materials, invoices, management of warehouse for products and ingredients.
After primary delivery a continuous support and eventual improvements are implemented.
First release of system was written in Visual Basic and based on MS Access. Later was rewritten in Client-Server manner, based on Firebird database and completely written in C++ using Borland C++ Builder.

Development of the system for massive medical prescriptions.
The goal of the system was to pick papery prescriptions, digitalize with hi-speed scanners, optical recognition of medicines and other information available on the prescription, checking of correctness of all information and in the final phase calculation of pharmacies revenue and generation of reports for health insurance companies and ministry of health.
The original solution were implemented in companies processing 350 000 – 750 000 prescriptions per month.
After the final implementation there was continuous support and enhancements of the system.
System is based on Firebird database backed and written in Borland C++ Builder. System integrates medicine database provided by external companies specialized for maintaining of such databases.

Analyse, design and implementation of information system for lawyers. System was covering the whole lawyer process cyrcle and backoffice needs.
It was written in Borland Delphi on Borland Database Engine

Analyse, design and implementation of accountment software for the accounting company and tax consultant.
Application written in Borland Delphi, database Interbase.

Information system for automobile dealers and service (process management, back office), used by numerous number of dealers of many marks – eg. Mercedes, Smart, MAN, VW, etc.
Development of a new system for automotive dealers based on the SQL Server back-end and front end development in Microsoft .NET using C#.
System was build using custom framework in front of .NET. For reporting purposes SQL Server Reporting Services were used.
Analyze, application and database design, implementation and Czech team leadership.