Tag: SQL

  • Pole Energy

    The Pole Energy online shop project was truly interesting and creative, but on the other hand a big challenge as well.

    The goal was to create a secure, modern, multilingual online shopping application. It has taken about a year, from the initial idea until the full version, during 2009 and 2010, with the first release at the beginning of 2010.

    At the beginning of the project I have created the application architecture, entities, relations, and use cases. As we did agree to loosely follow Agile development process, the architecture was redesigned several times during the project.

    During the implementation, I have lead a crew of experienced developers in the effort to achieve high quality and performance.

    We have decided to go with the Microsoft stack, using ASP.NET MVC enhanced with jQuery to create the user interface, using Entity Framework, LINQ, and C# for the middle tier DAL (Data Access Layer), and Microsoft SQL Server as the back end.

    The project is successfully running on the cloud platform at www.poleenergy.ch

  • 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.


  • Car trading B2B

    Car trading B2B

    During 2oo8 I worked on the vehicle auctioning platform for a Swiss company.

    Frequent discussions with my close associate Saša Klačar, who did the requirements collection and communication with the client, resulted in well documented software architecture.

    After defining the system entities and relations, I managed a team of experienced developers went on to implement the system using ASP.NET Web Forms for the front-end, .NET, C# and SubSonic for the middle tier and Microsoft SQL Server as the back-end.

    I have also designed the database, scripted SubSonic, implemented a part of DAL, and created a Windows service for XML data imports from an external source.

    Following the loose Agile process, we have first released a user interface mock-up, which triggered several system redesigns and resulted in better specification in the following releases.

    The better part of the project was done, but it was at a point stopped by the client, even as they were very satisfied with our results, but it was caused by the company’s internal problems.

  • 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.

  • ISB

    In the summer of 2007 I was working closely with “ISB” to produce this website presenting a portfolio real estates.

    At first I created the information architecture, and suggested the features that would distinguish clients website.

    Database format was imposed by the client’s desktop application, but was a bit augmented with fields needed for web usage.

    Standing out are the features to create a custom list of real estates, as well as detailed search.

    The  web site is available (though a bit redesigned) at www.isbdoo.com.

  • GTECH (formerly Finsoft)

    GTECH (formerly Finsoft)

    Finsoft is an international company producing large scale software systems. Main line products are dealing with sports betting specific demands, real-time transactions and information management.

    During my engagement, the company was acquired by the GTECH Corporation.

    I worked as a senior analyst programmer on web-oriented products – sports betting, affiliate programs, real-time data usage, payment services integration.

    For more details about the company, have a look at Finsoft and GTECH portfolios.

  • 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.