Francisco Javier Ramos

A race results website that deals with hundreds of thousands of records and still performs exceptionally fast.

I worked closely with the stakeholders on the requirements, and based on this, I achieved a balance between data consistency and performance.

The performance increase was achieved by calculating race results and rankings ahead of time instead of re-calculating them at run-time. I used object-oriented programming to create objects that held the rankings rules for different types of races, and once the results were processed, I stored them in the database in batches by using table types and stored procedures.

I built a quotation system desktop program by analyzing an Excel spreadsheet where the client had most of his business rules and extracting those requirements into a more modular system.

This resulted in a WinForms application hosted on Azure Blob Storage, where frequent updates could be published. The desktop application was written in C#, using the .NET framework, and communicated with a SQL database hosted in Azure.

Additionally, a customer portal was created to allow them to manage and see their quotes. This was created using ASP.NET MVC and deployed to an Azure App Service.

Finally, a third-party integration was done where quotes would be sent to a SugarCRM instance in Azure, an Azure web job, and an Azure queue was created and configured to process quotes periodically and send them to a public API in SugarCRM.

An application that allowed users to make corrections to their timesheets and make adjustments to their wage information. This application used the standard MVC architecture with a SQL back end. On the front end, it used Vue to manage data binding and validation.

This project was successful because it managed to combine the features of a standard web application with those of a SPA to allow for easier maintenance. Every page was its self-contained SPA, using Ajax and client-side routing for speedy response times.