Unified Database Integration for Reitzel Insulation

Reitzel Insulation seeks to streamline its office operations by consolidating multiple databases into a single, secure, and user-friendly desktop application. The current framework of the app is in place, but the integration of disparate databases remains a challenge. The goal of this project is to enhance data accessibility and security while simplifying the user interface for office staff. By centralizing data, the company aims to improve efficiency, reduce redundancy, and ensure data consistency across departments. The project will involve analyzing existing databases, designing a unified data structure, and implementing the integration within the existing app framework. This initiative will provide learners with an opportunity to apply their knowledge of database management, software development, and user interface design in a real-world setting. - Analyze and understand the current database structures. - Design a unified data model that accommodates all existing data. - Implement the integration of databases into the existing app framework. - Ensure the security and accessibility of the consolidated database. - Test the application for usability and functionality.

Digitize our Office Workflow with Computer Science skills

Reitzel Insulation is able to offer a virtual internship opportunity to as many computer science students or teams that are needed to complete the project. About the project After 40 years of business in Waterloo, Ontario, we would like to transfer our admin processes from paper to digital. Our goal is to be more organized and efficient online with a system that is very easy to use. (Our managers currently favour physical over digital ways) The admin process includes: scheduling quotes, turning the successful quotes into work orders, scheduling insulation jobs, giving employees the work orders to do the job, pictures are taken on site, adjusting the work order after the job is complete, uploading pictures to the server/google photos, invoicing using Quickbooks and any customer communication (emails) needed along the way. (more details of current workflow in attachment) We've looked at many platforms for this role and the closest fit we have found is Jobber EXCEPT if we ever cancel with them, we have to export our files individually and we would rather keep our information in house if possible. As well, as JobPro EXCEPT the monthly fee exceeds our budget. Feel free to look to these platforms for inspiration. The primary focus for the student will be: (see Riipen Proposal pitch deck attachment for more details) We are really looking to you for some guidance on our best route. We think that a web app or portal on our website will be needed to take care of our in-office needs. We also think a mobile app would be beneficial for our employees to view their daily schedule, quotes (for sales reps), work orders (for installers) and submit photos from the job site. We are open to splitting this project into 2 (start with the web app for this project) but we thought it was important to explain our overall vision so that the platform will work properly together as a whole. Website/Software Development - Conducting a needs analysis to determine which platform is most suitable for our website or web app; creating a design proposal including mock-ups; building a fully-functioning website for our organization. Application Development - Creating a fully-functioning mobile application. Our goal at the end of this experience is: To have an internal system that is easy to use and efficient for our office managers. Website/Software Development - For the student(s) to complete a fully functioning website. Application Development - For the student(s) to create a fully functioning application. We will plan to communicate with our virtual intern using these communication tools: Email Student's primary contact : (Brittany, Media Assistant) brittany@reitzel.ca ( I can help with very basic design needs/mockups/ideas if needed) Secondary contact: (Geoff, Assistant General Manager) geoff@reitzel.ca (Knows the office needs)