Project Summaries

Front-End Modernization and Responsive Design Enhancement Betters User Experience 

by

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

by

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

Policy Management System Leads to Better Tracking and Insights

by

A major Canadian university was using an outdated policy management system that wasn’t flexible and couldn’t fit their growing business needs. They wanted to be able to keep track of correspondences within the system. They also wanted the ability to add fields (metadata for the documents that are stored for policies) and take away fields as became necessary. The old system was not user friendly and didn’t allow them to manage the policies as they would have liked. They needed a policy management system.  For example, when an email is sent out containing a document, they want to know who responded and how they responded.   The New Policy Management System … Read more

Automated Endowment Fund Reports Result in Quicker, More Streamlined Reporting 

by

A major Canadian University wanted to automate the process of reporting endowment fund expenditures to faculties. The proceeds of endowment funds are used to support academic scholarships, bursaries, and research projects, and are a major component of large academic institutions and their fundraising efforts. Efficient reporting of these funds, their income, expenditures, and unspent balances allows faculties to support the students, scholars, and projects as intended by the donors, while remaining fiscally responsible and avoiding overspending. The existing highly manual and time-consuming process meant that the fund expenditures and balances were often out of date and funds with infrequent activity could easily be forgotten. Unspent funds were an unfortunate but … Read more

Application Upgrade Resolves Vulnerabilities and Security Issue

by

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 

by

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

by

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

by

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

by

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 

by

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