Bojan Bjelić

Tag: Database design

  • The Blue Minds Company

    Senior Technology Advisor

    The Blue Minds Company, Vienna, Austria

    October 2021 – present

    Continuing to support The Blue Minds Company in the role of Senior Technology Advisor.

    Industry: Energy, Investments

    Responsibilities and applied knowledge: Technology analysis, Technical due diligence, Technology Coordination

    Chief Technology Officer

    The Blue Minds Company, Vienna, Austria

    October 2019 – October 2021

    As the CTO, I was responsible for the technology side of implementing and driving forward the The Blue Minds Company vision in the areas of energy innovation, company building, and consulting.

    I oversaw the strategic planning and development of IT by analysing technological innovations in collaboration with the company’s network of solution partners.

    • Successfully planned and managed the implementation of an AI enabled, fully transparent energy tariff switching engine that based on smart-metre data TariffHero, FFG/Eureka project
    • Analysed from customer and product perspective and then implemented and launched a new customer oriented platform for Energy Hero
    • Numerous technical due diligence interviews and analyses
    • Supported the company on many other fronts

    Industry: Energy, Investments

    Responsibilities and applied knowledge: Technology analysis, Technical due diligence, System integration, Scalability, Cloud, Development process governance, Company process implementation, Provisioning, Hiring

  • Jailer is a tool for database subsetting and relational data browsing

    Database Subsetting and Relational Data Browsing Tool.
    https://github.com/Wisser/Jailer
    137 forks.
    3,109 stars.
    5 open issues.

    Recent commits:

    screenshot.png
  • Serbian Dental Journal

    Serbian Dental Journal

    Document processing system, for more details please have a look on the [permalink href=”127″]Serbian Archives of Medicine[/permalink] project page.

  • Matchpoint

    Matchpoint

    During 2007 and 2008 I worked on a document analysis tool called “Matchpoint”.

    The idea is to parse the document by identifying content blocks and then find certain keywords within the context. The document is tagged based on the found information.

    I did the software architecture first, creating the concepts, entities and relations,and identifying crucial parts of the system.

    The heart of the system is the parsing engine that identifies segments of document, for example education, experience, and so on. All the permutations of the segments are used, and the one that matches the most segments is selected for further analysis. Each of the recognized segments is then searched for the keywords. Each keyword has appropriate tags assigned, and this way the document is in the end tagged.

    Since the algorithm has to analyze documents in different languages, using semantic algorithms seemed a bit too complicated, so I went with regular expressions.

    The documents can be emailed or uploaded by FTP to the web server, where is a Windows service monitoring configured folder. A .NET console application is then run to convert document to plain text using IFilters, and then to run the analysis, and upload the data to the Microsoft SQL Server database in the end.

    Users can use a web application built on ASP.NET Web Forms to search and view indexed documents.

  • Rimako

    Rimako

    During year 2008, I helped the furniture industry company “Rimako” improve it’s web presence.

    At the start I created the information architecture, and identified key SEO techniques to be applied.

    A lot of work by my and my wife Ana went into the design and page structure and elements.

    Web site and CMS were implemented using the excellent CodeIgniter framework for PHP, with MySQL database as the back end.

    The pages are formatted in XHTML, styled with CSS and enhanced with JavaScript to accommodate older browsers (i.e. IE6).

    Please visit www.rimako.co.rs to have a more detailed look.


  • DBN

    DBN

    DBN is an online publishing platform primarily oriented on the Austrian audience.

    Its specific newspaper-like layout turned out to be very successful, as the site has a lot of unique hits. It took a lot of fine tuning to achieve good performance.

    The name “Du bist Nachrichten” (You are news) implies that the users influence the content by voting, thus promoting the most interesting articles.

    If you are interested to see this in action – have a look here, hope you like it.

  • Serbian Archives of Medicine

    Serbian Archives of Medicine

    During 2006 and 2007 I was working on the web publishing platform for “Serbian Archives of Medicine” Journal of the Serbian Medical Society.

    The requirement was to create a system that would accept the submitted articles, routing them through the complex system of administration, reviews, revisions, edits, and so on until they reach the publication.

    On the other hand, there was a need to put the existing printed editions online as well.

    I have presented to the revision board my analysis of the entities and processes, shown some ideas how to handle them in the system, they loved it, and I was hired to do the job.

    After several iterations of architecture revisions, I have designed the database in Access (hosting limitation) which was later migrated to Microsoft SQL Server.

    The web application was implemented in ASP.NET 1.1 WebForms, as it was the platform available for hosting at the time, using C# and NUnit for testing.

    The design was aimed for clean overview and quick loading times, implemented in XHTML (as far as ASP.NET 1.1 WebForms allow), CSS, and enhanced a bit with JavaScript.

    The document management system was a real challenge, since the client had a complex process, but in close cooperation it was implemented successfully.

    The system was later a bit tailored and deployed to [permalink href=”247″]Serbian Dental Journal[/permalink] web site.

    Please have a look at the front end of the site for more details here srpskiarhiv.sld.org.rs.