At the end of October 2012. we started with the production of Business Intelligence (BI) project for the Statistics department of CBBiH. This was the end of the first phase, where Poslovna Inteligencija implemented a solution for GFS. (Government Finance Statistics) I was a member of the project team from the side of CBBiH with a role to support this project at all. After the first phase was finalized, I stayed on the project in the role of principal engineer for support and maintenance of the implemented GFS solution.

My project roles were:

  1. Consulting about choosing the right platform/technology for the project, (for the scope of business processes connected with the statistics department)
  2. Solution testing, the configuration of the MS SQL Server 2012, IIS 7.5, etc.
  3. Deployment of the solution/changes to the test and production environment; (solution done by Poslovna Inteligencija, web application, dtx packages, cube, etc.)

My roles for project support were:

  1. DBA of MS SQL Server 2012
  2. Administration of IIS
  3. The responsible person for changes and implementation of new functionalities in the scope of the project infrastructure; (ASP.NET MVC C#, SQL Server Analyses Services, SQL Server Integration Services)

Using generic application for Banking System, as a leader Oracle developer, I was responsible for maintenance and adding new modules and functionalities. The generic application is very flexible, (made in Oracle Forms 6i) gives the possibility to create a new module without a single line of PLSQL code. Of course, it’s possible to use PLSQL and Oracle Reports for some specific solutions. (e.g. calculation which is not included in the generic model, reports which are not standard generic model reports, etc.)

Generic model supports:

  • Domains, (description of default parameters)
    • Inheritance, (for the situations where we need additional parameters description)
  • Contracts, (with a defined set of input parameters)
  • Procedures, (with defined input parameters, subprocedures, bookkeeping procedures as a part of subprocedures, etc.)
  • Parameter Tables; (possibility to define set of dynamic parameters and its values)

Application can produce HTML code (HTML web site automatically generated by database package, which produces more than 5000 HTML pages) as description of all entered values in generic application, so its very easy to find how contracts are defined, or how procedures are defined with all its description, or how booking procedures looks like, (bookkeeping schemes, with view on details on each accounting entry records related pairs) etc.

This is a generic application, developed in Oracle Forms/Reports, with the main purpose to help the company to easily manage inventory during the year. (annual or monthly) The form of application is generic so that the end user (with administrator privileges) can prepare lists, which are then filled by the employee responsible for inventory. After all, lists are filled, there is a possibility to compare them automatically with current inventory states.

The application is connected to the general ledger, with the possibility to check the current balance of accounts.

Developed in Visual Studio 2003, this web application was a central application for help desk management in ASA Group, Sarajevo. Through the time, this application evolved and with a couple of new functionalities, it started to be used in Central bank of B&H  from the year 2010. as an application for:

  • Incident management,
  • Help desk management,
  • Project management;

The application has its custom forms of authentication, where roles on different modules are done by placing users into different groups. (with the possibility to restrict users to read, write, or both)

Implementation of automatic fax sender application, using Oracle Forms/Reports and GFI fax maker. This system send fax documents automatically, archave sent documents, logs activities connected with fax sending, HW and SW.

The main part of this system is Oracle form, who reads the meta data from database about fax documents ready for sending, then creates fax documents using Oracle reports (reports server) and sends this documents to the default printer. (NetPrintQueue2Fax) The system has 5 distributed fax server, where all source code changes are done by SVN software.

http://www.gfi.com

BH Information Society Development – Legislation Database Project was requested by the BiH Council of Ministers and UNDP Bosnia and Herzegovina.

The overall objective of the project was to provide open access to relevant BiH laws and legal information through a web portal. The project purpose was to:

  • establish a comprehensive database of all relevant BiH legislation at State, Entity and District Brcko level;
  • create codes for laws according to EU standards and develop a categorization index of laws; and
  • allow official gazette to gain revenues from subscription services for an advanced part of the web portal and database.

I was the part of the project team of company COMP-2000, who was a contractor on this project, and my responsibilities were to:

  • design and create a relational database in MySQL DB,
  • create PHP internet application with further functionality: flexible application which was able to accept numbers of prepared design templates, search engine for all entered document according to categorisation and relation between documents, web authentication with cookie, subscription between different servers on internet, (in our case min 2 server, on for FBiH and the other for RS)
  • installation of the application on apache web server under linux OS;

http://www.legislativa.ba

Posted in PHP.

This was one of the biggest projects where I took a role

I was part of the team of Slovenian company Aster doo, (merged with S&T during the end of 2001.) who signed the Contract for Supplying and Implementation of the New Accounting and Banking Information System with Central Bank of Bosnia and Herzegovina. Project team considered 5-6 Oracle developers, which successfully implemented this project until the end of Q2 2003. After implementation, the local branch office of S&T Group S&T BA doo was responsible for project maintenance, which was my lead role in the company.

Main responsibilities:

  • Development of functionality or modules on the system given by the project manager, (Oracle Forms/Reports, PLSQL, Perl)
  • As an only local person in the team, I was appointed to be a deputy of project manager, (local coordination of the project)
  • From time to time, I did administration on the OS True64 and Oracle DB 9i;

Main project modules were:

  • Accounting, (general ledger)
  • Banking, (generic application, where is possible to implement new module without a single PLSQL code line)
  • Domestic payments,
  • Foreign  payments,
  • Asset management,
  • Salaries management,

Duration on the project: 16 months.

This is the first site I developed as a part of my hobby. This site started at the beginning of the year 2000.

Using experience I gained on seebiz.net project, I migrated bhsearch.com from Perl and flat text files as the basis for data storing to PHP4 and MySQL. In general, this site is very similar considering the functionality as seebiz.net, and additionally, I developed a couple of new functionality such as exchange rates data gathering, graphical interface about exchange rates changes through the time, …

Web graphical interface of the site is also prepared by myself.

http://www.bhsearch.com

As a part of the project team for development of the first professional business web site in Bosnia, we developed our own framework for dynamic web site and content management. (managed by sayber.net as a contractor) We used PHP4 and MySQL as a development platform. Our team had 3 developers and one web designer. Site was developed in  about 3 months.

Main functionalities we developed was: forms authentication with cookies, user management, content management with messaging and approval principles implemented, main site with lot of different widgets controlled by config file, reporting system, graphs, etc.

http://www.seebiz.net

ps. this web page has quietly evolved in terms of functionality and graphic design until date

Posted in PHP.