OUR PROJECTS​​

In recent years, MM Guide has been involved in several projects that required a certain level of discretion and are still under NDA today. The examples on this page are genuine transpositions of the most common operations that we are asked to perform by our customers and they present an accurate overview of our best practices and way of working.

Web Application

One of GeoStruct’s clients’ core businesses is constructing fiber-optic networks. The construction of these networks is based on an internal data process. The original data process was stored, edited, and reported in a Microsoft Excel spreadsheet. As part of their ongoing improvement cycle, MM Guide’s task was to create a web application based on the data flow of this Microsoft Excel spreadsheet.
The entire data process requires several manual actions in a Microsoft Excel Environment and automating these actions under these circumstances is difficult. Also, a multi-user environment was deemed necessary, alongside other desired features. Building a custom web application was the best solution.
MM Guide extracted the data model used in the Excel spreadsheet and translated this to an SQL-ready data model. A web view was created to add, edit, and delete this data model. MM Guide ensured that the business logic was implemented in accordance with the directives of the client. The users were provided with the features needed to manage both the data flow and data process.
The project was accomplished quickly, generating a substantial increase in business value. The users are now in control of the data flow and the data process, and they have already found numerous ways to improve and further automate the system.
.NET Core, Entity Framework, Azure SQL, Azure functions, Angular, CI/CD

Datawarehousing

One of our customers is a multinational with an ambition to shorten the processing time for management reports. For example, the January report was delivered on the 16th day of the following month at the earliest. The business objective was to deliver the report within 3 days after the end of the month.
More than 20 source systems provided terabytes of data that needed to be processed in a database. In the happy flow, processing could take up to 3 days per data stream. This resulted in the users being able to strategically manage two weeks later at the soonest.

MM Guide’s data warehouse solution has reduced processing time from 16 days to 3 days. Also, a team maintains the data warehouse and provides support to the users under an SLA.

The initial project was realized with a team of 5 people and took 6 months to complete.

An Azure Data Factory, Azure Data Bricks, and Analysis Services were chosen for this cloud solution.

.NET migration 

One of our customers is a company operating in the large SME segment. The new guidelines stated required that the database and application had to run on different servers. MM Guide was asked to assist them in the migration of their software to the new environment.
The original system consisted of MS SQL and ASP.NET 1.1 technology and was expected to run on the same server. We rewrote the software to accommodate the change to a separate database server and application server.

A dedicated MM Guide team provided:

  • The analysis of the old VB.NET code and its functionality
  • The design of a new architecture, data model, and front-end
  • The development, testing and, hand-over of the software
  • An SLA under which support is provided to the users

The new system is up-to-date, scalable, maintainable, secure and has been migrated without loss of functionality. Of course, the delivery was on time and on budget.

We used a MS SQL database, a .NET Core API using Entity Framework Core to talk to the database. On the client side of the application we used Angular.

BI in the SME segment

One of our customers is a company in the small SME segment. The company is data-rich and has a data ambition, but the organization itself does not have the knowledge to fulfill this ambition.

The company collects, produces, and purchases data and stores it in various Excel files which they misuse as a database. The company is growing and has now reached the point where this solution is no longer scalable, secure, and efficient.

 

The users make daily operational decisions based on analyses from these Excel files. This means that the reports have to be rebuilt daily. Their wish is to automate and visualize the reports, which saves them time to focus on the core business of the company.

MM Guide created a visual web interface where the data can be read into a data warehouse. The data is automatically processed periodically (daily) and displayed as KPI’s in a dashboard. The users only need to log in to the dashboard to be able to base their decisions on these new insights.
This solution saves the company at least an hour every day of building Excel reports, which means the investment will be recouped in 2 years. In addition, decision-rich users get their data neatly arranged and visualized, so they can spend their time more efficiently.
For this cloud solution we opted for an Azure SQL database, a .NET application and an Azure PowerBi dashboard.
World-amico

.Pro – Geo Based Intelligence

One of our customers (DEME) is an international civil engineering company that aims to build a sustainable future by doing its projects with the environment in mind. MM Guide assisted DEME in creating a web application that automates sustainable dredging planning.
Our client’s goal is planning dredging operations that maintain the morphology of the canals and rivers based on a set of requirements. The company however experienced inefficiency in its planning due to the implementation of conventional methods, which led to a non-sustainable scenario.

MM Guide established a data platform that combines and analyzes all kinds of longitude and latitude data sets in a web application. The software complies with these three main features: data uploading, data analyzing, data visualization.

The solution helps the company to plan and better allocate resources for future dredging activities. Thorough planning leads to a conscious use of energy which translates to sustainable production, perfectly in line with the client’s desires.
PostgreSQL, PostGIS, GeoServer, .NET Core, Angular, Azure

legacy projects

Data migration

The hiring department of a financial institute was looking to shift from their current external workforce software to a new industry leading external workforce software platform.

We were in charge of the data migration from one system to the other. In order to upload the data into the new system, the old data had to be mapped to the new data model. Also, we had to make sure all data was traceable from the old state to the new state for regression testing purposes.
We created several tools and applications to handle the data migration. We also created tools to ensure we had a full audit trial once the data was migrated. As an added challenge the system could not go down during business hours, which gave only gave us from Friday evening until Sunday night, 54 hours, to carry out the whole operation.
As a result of rigorous preparation, extensive testing and teamwork we successfully migrated all data to the new system and had a smooth start the next business day.
We used Microsoft SQL Server for our databases, many of the tools developed were .NET applications, but we did not shy away from using Excel and Access for small tools and proof of concepts.
Admin-amico 500

Providing management information

During the time of this project (over 15 years ago) the Rabobank Netherlands consisted of approximately 200 local banks, these banks had multiple offices. Of these 200 banks, 60 of them had access to ORS of which 12 banks made daily use of the tool.

 

To cut down cost, multiple local banks had one LAC (Local Administrative Center). LAC was responsible for management of the financial services and the financial reporting of the local bank and its offices.

To handle the financial reporting the LAC wanted to develop a tool to support the creation of reports. The data in the reports would be used on different levels of management to make sure the SLAs (Service Level Agreement) were met.

We built an Access forms application to support the LAC in their work process flow. The application stored data and created a multitude of reports on that data. ORS allowed for multiple roles and was built to be a multi-user tool, something that was not common in those days.

The tool allowed the LAC to provide data to managers which they could use to steer day to day operations in a nearly real time way. This made it possible to adhere to the various SLAs that were pre-arranged.
Microsoft Access, Microsoft Excel, VBA
Privacy Preferences
When you visit our website, it may store information through your browser from specific services, usually in form of cookies. Here you can change your privacy preferences. Please note that blocking some types of cookies may impact your experience on our website and the services we offer.