Making good decisions is essential to the success of any business or organization. CDM Smith came to Tekbees with the challenge of creating a web solution that integrated the Investment Prioritization Model related to water and sewer projects.
Our development enabled the organization of top priority strategic criteria to streamline project execution and maximize results.
In this article, we will describe how the development team created a web solution that transformed the decision making process, turning this case into a success story.
¿Cuál fue la solución para CDM Smith?
The development team relied on the Investment Prioritization Model, which consisted of a comprehensive database hosted in Excel, encompassing a wide variety of projects from companies and public entities.
The goal was to evaluate the projects affiliated with the COMPASS program. In particular, this program aims to finance initiatives to improve the performance of the companies that offer potable water and sanitation services in Colombia.
The evaluation process contemplates specific objectives, such as improving investment or achieving greater coverage in the country. It prioritizes the most relevant criteria to obtain better results.
We needed to improve the functionalities within the model; therefore, we created interactive screens with graphics to display the interaction of the criteria in each project, according to the prioritization that each entity configured from the internally set objectives.
In this way, we transformed a simple Excel table into a platform with multiple views, allowing us to dynamically organize the relevant strategic points for analysis.
Methodologies for good development
During the process, the SCRUM methodology was adopted, allowing better time control for a more timely delivery.
A differential factor in the development process was the use of trending technologies; for instance, JavaScript, which ensured improved support and a contemporary approach to the solution.
How do we guarantee quality for the project?
One of the pillars of this solution was to guarantee the quality of the final product.
To this end, a rigorous version control was implemented, ensuring that the base model remained intact and that all modifications would be recorded in another database for traceability.
Benefits and Results
- Online accessibility eliminated the need to have the file on each computer, facilitating collaborative work and access from anywhere with an Internet connection.
- Version control ensured data protection and allowed users to perform more effective comparative analysis.
- The new frontend improved the user experience, offering a user-friendly and easy-to-manage view, with interactive graphics that allowed a more visual and understandable analysis.
- The ability to manage multiple users facilitated real-time collaboration and improved communication between the teams involved.
Each stage of development significantly boosted CDM Smith’s growth and, at the same time, provided us with valuable experience in creating solutions for future customers looking to improve their decision making in an informed manner.
At Tekbees we don’t stop growing! Learn about our experience and motivate yourself to create the change you’ve always dreamed of for your company.








