Centralized Database – A Nonprofit Organization

Worldwide Steel Certification Association logo

TITA, a non-profit technical institute and trade association headquartered in Chicago works with those in the  structural steel design as well as construction communities to provide various services related to the civil  engineering industry. Their certification program sets the standard for the industry and is recognized nationally  for its quality in certifying steel and steel structures.

Challenge Challenge - Mountain without Flag

TITA faced issues with their certification program when it came to keeping customer information and their  certifications organized in the system. All of the data was previously recorded as lists in separate spreadsheets. The company needed an organized application to maintain their client list and certifications. TITA saw an opportunity to improve customer service while removing the delays and inconsistencies caused by manually  entering information into spreadsheets.

Their process of certifying clients also had inefficiencies that a software solution would help resolve. Our  client’s customers needed to pay a fee before someone is sent to audit the site to issue a certificate. The invoices for these fees were being calculated and created manually for every customer. Furthermore, in order  to request and schedule an auditor for the job, TITA had to send out email requests to their contracted inspectors until someone responded with an offer.

After the auditor offers to do the job, our client then had to contact the company to be audited in order to get  an approval for the auditing dates. This entire invoice and scheduling process had the potential to improve with automation.

Solution Solution - Mountain with Flag

The solution we created for TITA helped address their organizational issues. All data regarding the company  and their customers is now consistent and secure through automation. The centralized database keeps information connected and automatically logs business activities. This way, TITA is aware of who made what changes in the data (such as when an invoice is generated). It also became easier to pull up necessary  information about customers or company activities with a search feature. Both of these features decreased overall processing time.The scheduling and invoicing processes have also been improved and automated.

Now, requests for audits can be sent out and approved automatically with an audit scheduler feature. This  feature allows both the auditors and auditees to receive emails with hyperlinks. Then, TITA can click the hyperlinks and approve or reject requests instantly. This reduces the processing time from a few hours or days to minutes. Similarly, when invoices are generated, they no longer are calculated manually. The system can  charge the appropriate fees for certification and create the invoice. When it comes time to print the certification, it can be generated and printed directly through the system as well.

We continue the relationship with TITA by providing additional solutions to assist other aspects of their  certification program. The next project is aimed directly at field auditors and will help them manage the process before, during and after the on-site audit.

latest news

01

How to Use ADFS to Implement Single Sign-On for an ASP.NET MVC Application

Without using any complex code logic, I leveraged Microsoft’s Single Sign-On (SSO) on my existing ASP.NET MVC web application.

02

10 Ways to Save Money By Hosting On Microsoft Azure

Many companies move to the Cloud to lower costs and offload the management of their IT infrastructure. Once you create resources in the Cloud, there is still more work to do. By considering the list below, you can ensure you are getting the performance you need while keeping your monthly spend in check.

03

Is AI Making Me Lazy?

Over the course of the last month, I logged the different ways my family used AI-powered devices in my home. Does artificial intelligence mean I can't think for myself? Read what I think in my latest blog – Nate Pave.

Copyright © 2018 alligatortek. All rights reserved.