Project Tracking System
Industry: Consulting Services
The construction consulting company specializes in obtaining construction project permits for their clients in the City of Chicago. They manage the day-to-day requirements of navigating Chicago’s Department of Buildings’ policies. They understand that time is money and expedite the approval process to get their clients the building permits they need quickly and accurately.
The company manages many different types of construction projects. Each project type has a different set of tasks that need to be completed. Goldmine Customer Relationship Manager (CRM) was being used by their Project Managers to track projects. As the business grew, Goldmine became inefficient and a customized system was needed to enable their Project Managers to work more effectively.
Project Tracking System
The new system designed by SQL Server Programmers has many advantages. One advantage is the time saved by the Project Managers. When the Project Managers are assigned a new project, they can now select the type of project they are working on and have all of the tasks that need to be done automatically created. Previously, they had to select a project type and add each task manually. This took time and created the possibility of missing a task or entering one in error.
Standardized System of Setting Up Projects
In addition, a standardized process for setting up projects is now in place. Tasks are set up in the system and each project type is assigned tasks in the proper completion order. This provides the Project Managers a standard predefined set of tasks automatically created in the proper order for project completion.
Integration with Goldmine CRM
The system is integrated with the company’s Goldmine CRM, eliminating redundant data. The system automatically integrates clients and their projects from Goldmine. This integration process helps keep the project tracking process streamlined and accurate.
Improved Customer Service
The system also enables the Project Managers the ability to customize client notifications regarding project status. Emails can be sent at any time by a Project Manager or automatically set up to email the client on predefined days of the week. Client emails include itemized information on the status of each task and details the progress of their permit approval process.
Large Manufacturing PlantEvery major project has gone live by the desired target date, and runs problem-free.
- Vice President
Plant MuseumSQL Programmers upgraded our Plant Records database and Plant Production database. The new systems provide access to a scalable, reliable and user-friendly system for any user within our networks.
- Director of Information Systems
A Regional Philanthropy FoundationYou continually translate our business needs into successful projects within budget. Thank you!
- Manager of Information Technology
A Meat DistributorSQL Programmers did an outstanding job translating our needs and wants into a workable program. After the development, we have been very pleased with the support. We are currently working on Phase Two!
- Operations and Process Support
SQL Server Programmers is a database consulting firm specializing in Microsoft technologies. For over twenty years, we have assisted hundreds of companies nationwide. Our staff has extensive experience working in various industries to develop systems that manage business information. We develop desktop database solutions and integrate these solutions with the web to create data-driven websites. Our firm is a Microsoft Certified Partner, and our developers are Microsoft Certified Professionals.