Posts by Imaginet Resources Corp
Modernizing Food Science with AI-Powered Search & Chat
A leading institute specializing in food science consulting wanted their content to be accessible as part of a Retrieval-Augmented Generation (RAG) application designed to support scientific research and innovation. This institute creates a variety of journal publications and their own food science-related content (like journals, courses, and newsletters). The primary goal of the application was to assist food scientists in the development of new food products by enabling AI-Powered intelligent Search and interaction with their extensive library of scientific content. Our Approach We focused on data engineering and AI integration, leveraging the Microsoft Azure ecosystem to build a scalable and intelligent solution. The Impact The solution transformed how food scientists … Read more
Delivering a Scalable MVP for Complex Billing Workflows
A leading retail logistics provider approached Improving Winnipeg with the request to develop a scalable MVP and a foundation for a new billing application. Our client has numerous well-established Canadian retail relationships and transportation partnerships. They have been on the market for more than half a century, and are consistently evolving as an organization to meet modern and future client needs. Our client already had a billing automation that accepted invoices from its partners and billed clients at flat rates. Due to lack of flexibility and a lack of a user-friendly interface, there were many errors and inaccuracies, which led to substantial customer service efforts and client dissatisfaction. Our client … Read more
Front-End Modernization and Responsive Design Enhancement Betters User Experience
An internet-based reservation portal was using an outdated website that was no longer in line with corporate standards or current business practices. The company also wanted to change its reservation process to reduce the number of interactions customers needed to complete an order. They were in need of a front-end modernization. To help the client, we started a review of the current website and the user workflows by engaging with our UX team to perform analysis and redesign. After iterating on the design with the client, we implemented the redesign of both the look and feel of the site as well as the ordering process. The redesign included designs for desktop, … Read more
Automated Data Parsing Saves Time & Better Allocates Resources
A provider of real estate advisory services contacted Imaginet because they were loading large amounts of data into their databases using a batch process as opposed to automated data parsing. The data being loaded was used for making critical business decisions. All the data being loaded required validation and much of it required transformation as it came from disparate sources, each using their own document standards. The process that loaded the data was very manual, taking a lot of effort from multiple people. Automated Data Parsing Setup We created a process where a user could upload the excel file and have it processed automatically. When the file was loaded it … Read more
Application Upgrade Resolves Vulnerabilities and Security Issue
After a software audit at an occupational health and testing company revealed several technical issues and security vulnerabilities within the customer’s core line of business applications, Imaginet was engaged to help identify the solution and lead the effort to resolve it. Due to the issues with the applications, we determined an application upgrade was needed. The existing application was built as a .NET core 2.1 web app running on .NET Framework 4.8, with an Angular front-end client. While .NET Framework 4.8 is still supported, .NET Core 2.1 is not. The customer needed a solution that could be implemented in a matter of months, so rewriting the application from the ground … Read more
New Application Development Projects Enhance Resource Management
A telecommunications organization contacted Imaginet for assistance on 2 new application development projects. The first was a portfolio tracker, and the second was an office furniture ordering application. Portfolio Tracker The portfolio tracker we built for our client tracks and manages the various budgets they have across different departments. Our client has several districts and district managers, and they needed a way to track budgets across these districts and departments. Another aspect of the portfolio tracker is managing tech deployments within the organization. For example, if a boardroom needs a new projector (or other tech) they’ll go through a process to request the needed technology. Our tool allows for the … Read more
Data Collection Upgrade Reduces Technical Debt & Modernizes Data Reports
A well-known consumer packaged goods (CPG) company specializing in pet food asked Imaginet to perform maintenance on their existing data collection processes. We work in a staff augmentation role for this client and do ongoing work for them. Their data departments are divided into different business areas (we will refer to them as teams). On this project, we were working with two of their teams. Both teams required general maintenance and updates to their data collection tools – essentially a data collection upgrade. Team 1: Their primary focus is collecting and processing data about pet foods and products (nutritional claims they make, calories, ingredients, product history, etc.). This process to … Read more
Power BI Data Model Builds Better and More Accurate Reports
A major Canadian University had contacted Imaginet because they needed reports built on top of an existing data warehouse. This is a long-term client of Imaginet’s, and we had previously built a data warehouse for another department within the organization. Much of the work for this project was about defining the semantic data model on top of the data warehouse and then building the reports on it. Before they had a data warehouse, they had multiple applications that were reporting data separately. Since the implementation of the data warehouse, the client wanted to use Power BI as a standard enterprise reporting portal. Our Solution We started with creating views in … Read more
Databricks Migration Saves Money and Improves Data Accessibility
A provider of real estate advisory services contacted Imaginet for support on a system we had built for them a few years ago (mostly built using Azure SQL). They have multiple databases that have monthly costs associated with them. Our client was looking for a cheaper solution as the monthly costs were quite significant. They also had an existing capacity agreement with Databricks, so our goal was to conduct a Databricks migration with our clients databases. What We Did We started from scratch and built all the coordinates and objects for our client’s architecture. We used metadata to create their tables and developed a custom autoloader to transfer files to … Read more
Microsoft Purview Records Management Improves Business Record Storage
A major Canadian university contacted Imaginet because they desired a solution for managing their business records in SharePoint. Their Access and Privacy office is tasked with records management for the university and is currently managing their business records primarily in file shares. They are approaching 100 TB of business records that needed specific classifications – an extremely large volume. We determined Microsoft Purview Records Management would be an appropriate solution for our client. Managing records in file shares presents usability and administration problems. A typical problem with file shares is that business records are often duplicated. Additionally, custom permissions on nested folder structures create tickets for internal IT teams, which … Read more