DzonintWeb Developer - Software Engineer - IT Technician
Portfolio
About
I'm a full-stack developer who recently graduated from one of Belgrade's IT oriented colleges with experience in both startup and corporate environments where my contributions are impacting thousands of users.
eveNT Belgrade is a web portal for inhabitants and visitors of Belgrade dedicated to bringing up to date information about the latest cultural events from various categories.
The site has custom CMS for admins. They can perform CRUD operations on events and users.
(do note that the site is not running optimally due to limitations from free hosting service)
This was a college related project where we chose a website as a reference for our database. I chose Dotabuff, an online match analyzer for Dota 2.
The first part of project required creating a database and filling it with some data. I wrote the complete script inside text editor and created a PHP script which would take the data from OpenDota API (the same one used in DotaNT project) and create suitable SQL DML commands.
Unfortunately, the project required of database to have all normal forms fullfilled (by all I mean the first three). Denormalization was not allowed, thus I had to modify some of the original database script. Forcing a new "Matches_Account_Item" table drastically increased query time (given that each of 10 players can have up to 9 items per match and that there are ~400 matches inside the database, you can see how many potential records are there to be generated instead of simply holding items inside the "Matches_Account" table).
The second part of the project consisted of making several different queries of a different type.
The third and final part consisted of creating various database objects for the database - views, procedures, functions, triggers and scripts which would generate some of the errors like repeatable read and deadlock.
Fairly simple database. On top of the main form, there is a combo box which lists all donors, and upon selecting one of them their information is shown, along with the list of their donations in the grid view below.
To prevent potential accidents, all of the data shown on main form is locked, neither gridview nor user info can be edited from it.
User has an option of adding a donation or donor, which opens up a new form. Before new donation is entered in database, user must select from one of the existing donors to who the donation will be assigned to.
There are 3 reports in database. First one compiles a list of donors, listing their name, address, contact and e-mail. Second one lists all of the currently selected donor's donations. It contains the date of donation, amount and description, along with the number of times donor has donated and the total amount of books he donated. The third and last report makes a list out of all donations, and groups them by the month and year of donation. It contains description, donor name, date of donation and the amount.
The query is for data which needs to be pulled after user selects a donor from combo box.
NotesNT is a simple online note storage created for REST project assignment - it works by sending AJAX requests from pages while behaving according to the incoming responses.
The assignment was given to me by one of the Belgrade's IT companies and it asked of me to implement HTML/JS frontend and REST backend using any programming language or framework.
Nova Tehnika is a ADO.NET based CRUD application which was done as an college assignment. It consisted of creating a conceptual database model, translating it to relational database model, denormalization of it and implementation of CRUD via connected and disconnected architecture using System.Data.SqlClient namespace.