Service Providers

Since 1997, Spud Software has developed custom software solutions and/or implemented PACManager for a variety of businesses and organizations.  The following are just some of the examples of how we helped clients reach their goals.

1-800-Concrete

Business Needs
1-800-CONCRETE came to Spud for help with their online systems, with a need to provide their customers with online tools and a public facing web management platform. 1-800-CONCRETE provides customers with a single spot for sourcing concrete. Their system also provides concrete businesses with a lead generation source, and the ability to offer a branded 800 number to multiple companies.

Solution
Spud implemented an online system that provided 1-800-CONCRETE newer technology that allows for their team to easily handle their public facing web management system and tools for their customers to generate real-time quotes.


ACDelco International Multi-Language Parts Catalogs

Partnering with MSX International (ACDelco’s engineering services supplier), Spud Software developed ACDelco’s first electronic composition system to automate the generation of multi-language and region specific International Parts Catalogs.  The project was awarded to Spud Software due to our unique solution for parsing raw parts data from ACDelco’s engineering database and composing in the horizontally aligned format used by retail automotive parts catalogs.


ACDelco Internet Parts System Video

Company Information
ACDelco needed a web based, instructional video to educate users at their retail outlets on the key features and functionality of their new Internet Parts system.

Business Needs
They had not completed any system documentation and they needed the instructional video within one month in order to meet the launch date.

Solution
Spud Software leveraged its automotive parts expertise on staff to review the system, develop the script for the audio and graphic portions of the video, develop the narrative and the graphics, and complete the video integration within a month.


Albion Tire Company

Business Needs
Albion Tire City came to Spud to implement business management software. Software that could manage sales, quotes, inventory, reporting, and more.

Solution
Spud implemented business management software for Albion Tire City that connected all of their locations for real time inventory management, allowing each location to quickly identify what items were available at each location. Providing a way for the sales team to still make a sale to the customer and coordinate the install of the product based on when it could be transferred from the other location. Albion Tire City was able to streamline their customer quote time while implementing an electronic process. The system also provided specific reporting to management to make accurate business decisions.


Almar Orchards, LLC

Business Needs
Almar Orchards came to Spud Software to help with a content management system to streamline their online presence, and to implement an eCommerce platform that allows consumers to order items shipped directly to their door, or for pickup at the orchard.

Solution
Spud created a web based management platform that allows the team at Almar Orchards the ability to manage their web presence, product inventory, orders, and payment processing. The system has provided Almar Orchards a way to expand their business and customer base.


America’s Premiere Realty

Business Needs
America’s Premiere Realty came to Spud looking for a software solution to manage their employees and realty transactions. The solution also needed to provide reporting tools allowing Leadership to have real time information.

Solution
To meet the company’s needs, Spud Software developed Realty Tracker, a custom software solution that tracks and reports on the company’s realty transactions, leads, sales, and advertising. It also serves as an employee management system, allowing administrators to create and maintain employee records and associate those with real estate transactions. Custom reporting tools include yearly production reports, realty transaction reports, and yearly production reports for either all or individual realtors.

As the company’s business grew, so did their software needs. Spud Software continued expanding their management system to track business in multiple states.

On top of this, we have developed a custom website that integrates with their home listing and quoting software to allow buyers to search for homes and request mortgage and financing quotes.


Archadeck Outdoor Living

Company Information
Specializes in the custom, award winning designs and construction of outdoor living spaces, decks, patios & hardscapes, sunrooms, porches, shade structures, outdoor kitchens, and fire features.

Business Needs
Streamline on-site sales visit process, reduce the amount of product catalogs physical copies needed for a sales visit, and to send a follow-up email to clients as shortly after a sales visit as possible containing images of products that the potential customer showed interest in during an on-site sales visit. In order to stay competitive, the client wanted to show potential customers that they were dealing with a company that used modern technology and to offer customers a better overall shopping experience.  

Solution
We created an iPad (iOS) only app for presenting products offered by Archadeck/Outdoor Living Brands, such as sun rooms, shades, screened rooms, pergolas, outdoor kitchens, hardscapes (stone walkways), gazebos, decks and accessories.  The app was two very large photo galleries of product images and material choices.
Users added images to the app via iTunes.  Users had access to the “Media” section of the app and were able to add new albums to the galleries, as well as add the desired images to those albums.  They could easily swap out existing information with updates from the corporate office.
The app acted like a CRM for managing potential clients.  It also helped the sales people, as they no longer needed to carry multiple product catalogs with them on their sales calls.

Technical Details
Enterprise iOS app. Mini-CRM. Integrated sales follow-up PDF builder. Email functionality.


Beaumont Health

Business Needs
Beaumont Health came to Spud Software to build a custom workflow application to support hiring approvals and tracking. The workflow application required the integration of existing internal, and external applications.

Solution
Spud implemented a custom workflow application for Beaumont that streamlined approval processes for hiring. The system integrated with PeopleSoft, HCM, and tied into an existing Oracle database to leverage existing data. The system was launched to be responsive and user friendly across various device types and sizes.


Big Brothers Big Sisters of Flint

Business Needs
Big Brothers Big Sisters of Flint and Genesee came to Spud Software to help with a content management system to streamline their online web presence.

Solution
Spud created a web based management platform that allows the team at Big Brothers Big Sisters of Flint and Genesee the ability to manage their web presence, event calendar, event registrations, donations, and payment processing. The system has provided Big Brothers Big Sisters of Flint and Genesee a way to streamline their organization and their online web presence.


Blue Water Importers

Company Information
Blue Water Importers started over 20 years ago when owner, Jack Dempsey, began purchasing vehicles in Canada for sale in the US. As time went on, Blue Water took over the transport of the vehicles, the work of conforming them to DOT requirements, and titling. Today, Blue Water specializes in the conformity and transport of vehicles for other dealers. With a team of just under twenty people, they process approximately 1,000 vehicles a month and counting. As demand has spread, Blue Water, currently located in Burton, MI, is pursuing plans to open additional locations in several other States in the Midwest and Northeast regions.

Business Needs
Blue Water Importers came to us needing a system that did vehicle tracking, document generation, barcode creation and scanning, email automation, document archival, reporting, invoicing, shipping management, and business process communication.

The Blue Water business processes fall into the main areas of Order setup, Importation, Vehicle Check-In, Title Processing, Recall Repair/Documentation, Instrument Panel Modification, DOT Conformity, Outbound Processing, and Invoicing. Each of these processes requires labor-intensive activities including customer interaction, contact management, VIN verification, vehicle data entry, legal vehicle classification, customs duty calculation, document creation, emailing, document archival, barcode label printing, barcode reading, document cross-referencing, vendor selection, creating shipping labels, taking and printing pictures, instrument panel tracking, odometer reading verification, discussions with book keeper, report creation, invoice creation, bill of lading creation, and bond tracking. Although Blue Water specializes in the above activities and performs them with skill and expediency, the volume of vehicles they can handle is restricted by the time it takes to perform and organize these business activities.

Solution
We were able to identify each type of entity that Blue Water interacts with, as well as their government requirements and job functions, and then detail each business process with the manager of those activities. Not only does this include identifying how daily operations are performed, but also pinpointing the desired result of each activity, employee opinion on the process, pain-points, and bottlenecks involved. All of the processes and decision points were identified in a “vehicle life cycle” flowchart which was modified to streamline the existing process, force adherence to preferred business processes, and incorporate value-add business activities Blue Water wanted to incorporate into their business process. We then looked for places to automate the system. Any time a process showed to be consistent, we had an instant opportunity to do this, and when decisions were made the same way on a regular basis, we had strong potential to automate here as well. After creating the road map of what Blue Water wanted, we began work on a web application that supported all of those activities.

Technical Details
The new system utilized security to allow both clients and employees’ access to their respective site functions. In order to give employees more time in the field we built the system to automatically assign bonds to vehicles and alert the importation manager if any special attention was needed to the bond or shipment of the vehicle, generate and send documentation emails to the custom brokers, and send manifests to the drivers. Using Optical Character Recognition (OCR), a local application was created to scan specific email accounts as well as network folders. This application pulls any new documents, scans them with OCR, and presents them to the appropriate team for verification. The team at Spud Software also created a way to build invoices automatically as vehicles undergo various activities. This process gave employees the capability to select a group of vehicles that are complete, send the invoice data to Quick Books through an API, and do so in such a way that invoices are automatically generated for each customer containing all vehicles and associated itemized charges. Another API was implemented to automatically print FedEx labels for title shipment. Another concern Blue Water had was keeping their employees on the move, so we built a mobile app that gave them the ability to work in the field. Personnel now has the ability to photograph vehicles, enter additional vehicle data, and print barcode labels from a mobile printer. Furthermore, the mobile app has the ability to take photos for DOT Conformity and automatically uploads them to the web server and stores them with the appropriate VIN. These photos are later printed along with all other DOT Conformity documentation that has been collected or generated for each vehicle.


Boral

Business Needs
The Boral team at their Metamora plant reached out to Spud Software to help streamline their reporting capabilities and to implement database integrations.

Solution
Spud worked closely with the plant manager and with Boral corporate IT to implement multiple solutions. The solutions helped to streamline executive reporting, and consolidation of data from multiple ERP and SAP solutions into a standardized data warehouse for reporting.


Brand Labs

Company Information
Brand Labs creates custom Volusion solutions for manufacturers, wholesalers, and retailers. They pride themselves on the development of unique eCommerce sites that meet their clients’ very specific needs — even when those needs extend beyond the world of eCommerce. For example, they can integrate Volusion with third party applications, even your own proprietary ones, allowing you to use Volusion as a hub for your entire business. As a matter of fact, they’ve become so good at what they do that they’ve become Volusion’s Enterprise Solution Partner, helping them to meet the needs of their larger retailers.

Business Needs
Brand Labs was in need of talented developers. To meet their customer deadlines, Spud Software stepped in to assist with their projects. Spud software was able to work with the Brand Labs team, so much so that Spud Software worked as an extension of their team. Spud’s team attended meetings, used their software version control, and collaborated with their developers to meet customer expectations

Solution
Spud Software provided support in the following ways:

  • Existed as part of their team
  • Used their software version control
  • Collaborated with their lead developers

Brown Star Products

Business Needs
The e-commerce site was very user-friendly for the company itself, but very convoluted for their end users.

Solution
Spud Software took over the existing e-commerce site, redesigned it and updated the content to make it searchable for end users. We were able to help them manage not only the look of the site, but also how their content interacted with the search within the system itself.


C&L Ward Mobile App

Company Information
C & L Ward is Michigan’s top provider of home improvement products and services and largest dealer of Andersen® windows and patio doors. Founded in 1972, C & L Ward is a family-owned and operated corporation that is strongly committed to complete customer satisfaction.

Business Needs
C&L Ward was looking to arm their field staff with comprehensive sales related information organized in a way that helped drive consistent, effective presentations to customers.

Solution
Spud Software developed a mobile app that puts the key information at their fingertips, including presentation sequencing and key content about their products, installation methods, testimonials and more.


ChoiceTel

Business Needs
ChoiceTel collaborated with Spud about updating their existing custom software. Their existing custom software used older technologies, and had areas for improvement and efficiencies.

Solution
Spud worked closely with the ChoiceTel team to understand business processes and created a prototype of an enhanced version of the business management software via interactive wireframes. Incorporating dashboard level reporting and streamlined management tools to make handling client tickets and assets more streamlined.


Cost Less Pet Treats

Business Needs
Cost Less Pet Treats came to Spud for system integration with their existing eCommerce application for selling their pet products.

Solution
Spud worked closely with the Cost Less Pet Treats team along with a 3rd party partner that was integrating their MLM system to drive traffic to the Cost Less Pet Treats online store. This provided a members only benefit, along with the ability to pass back rewards information.


D.E. McNabb

Business Needs
D.E. McNabb came to Spud looking to improve upon their software systems to manage their business. Their existing software system was outdated and no longer supported. The outdated software also required older versions of operating software limiting the updates needed to support the software and their PCs. The application needs to run their sales pipeline for retail customers and their show & expo customers. The application would control all aspects of their processes from quoting to shipping the product.

Solution
Spud rebuilt the application from a DOS and FoxPro version to a cloud based web application that will allow access from anywhere. The application has a CRM built in allowing the sales team to create and monitor their customers with quote and sales tracking. The application is being built to be dynamic between their departments for retail, show and warehouse. The application will also be integrated with their Microsoft Dynamics accounting software with reporting built in.


Diplomat Pharmacy


Emil Rummel Agency, Inc.

Business Needs
The Emil Rummel Agency came to Spud looking to implement an automated solution for interacting with their customers.

Solution
Spud created an automated solution utilizing Microsoft Azure cloud infrastructure. The solution monitored and captured dynamic information and provided auto responses to customers. This increased the response to customers from hours or days to minutes. The solution took advantage of integration APIs with Office 365 and Azure Function apps.


EuroBlooms, LLC

Business Needs
EuroBlooms came to Spud Software to help with a content management system to streamline their online presence, and to implement an eCommerce platform that allows consumers to order items shipped directly to their door. EuroBlooms is also a wholesale supplier to big box retail stores also.

Solution
Spud created a web-based management platform that allows the team at EuroBlooms the ability to manage their web presence, product inventory, orders, and payment processing. The system has provided Euro Blooms a way to expand their business and customer base.


Event Link

Business Needs
Event Link approached Spud to develop multiple solutions to optimize event management and bring brand awareness to the events run by the Event Link staff for their clients.

Solution
Spud built an iOS application for EventLink to enhance the photo booths to help with social media marketing for the events. The booth consisted of cameras, green screens, and cloud connected iPads. When a guest wanted to take a picture at the booth, the picture would auto save to a cloud environment and be available on the iPad for review by the guest. The guest was able to utilize the iPad app to upload their picture to a social media destination of their choosing.

Spud also created a comprehensive event registration platform utilized for Porsche and Audi training conventions. Each training convention had a set amount of available seats. The required people to be scheduled into waves. The website allowed for Porsche dealership personnel to register for an event and manage their registrations.

The Event Link staff utilized the web based administrative tool to manage and check in registrants to the events. Event was able to manage existing events, utilize the content management system to setup new events. The administrative system also provided capabilities to send automated email blasts directly to the participants. Spud provided full end user support, including email and direct phone support. This support ran Monday through Friday from 8am-8pm.


EZ Homes

Business Needs
EZ Homes came to Spud to capitalize on an opportunity to modernize this industry by bringing the buying and selling of pre-owned manufactured homes online.

Solution
Phase 1 – Spud created an online platform that enables home owners to easily share details about their home they wish to sell. Once the seller clicks ‘Submit’, that lead is immediately assigned to an EZ Homes agent who receives an email with the home details and the seller contact information. If EZ Homes purchases the home, then the listing is broadcasted via email to a catalog of brokers, agents, and mobile home park owners who may wish to purchase the home. It is also listed on their website for the general public to browse as well.

The EZ Homes website tracks the sales process at every step, and should it stall for any reason, automated reminders are sent via email to the sellers and buyers to help keep the process moving.

Phase 2 – Previously, EZ Homes was only in the business of buying and selling actual homes. If EZ Homes received a lead in a state where they do not do business, the lead was ignored. They have now expanded, however, into the business of selling leads (and not just homes) to their catalog of nationwide brokers. And brokers are able to customize the types of leads they wish to purchase.

Likewise, EZ Homes is now able to purchase leads from other brokers as well. If a broker in their network obtains a lead for a home they are unable to purchase themselves, they may sell that lead to EZ Homes. EZ Homes may then either purchase the home outright, or turn around and sell that lead to other brokers in their network.

The online software Spud created for EZ Homes manages every aspect:

  • Handling incoming leads
  • Determining if EZ Homes wants to buy the home, or to sell the lead
  • Finding the brokers who’s criteria matches the lead, and automatically selling it to them
  • Making sure the lead is not a duplicate
  • Handling all financials, including secure credit card processing & any questions that may arise about the validity of a lead
  • Communicating to all parties (the seller, the broker, the buyer, and EZ Homes) via email alerts and email campaigns

Flint Fresh Mobile Market

Company Information
Flint Fresh is a non-profit market whose mission is to bring sustainable access to healthy food to the Flint community by increasing their access, affordability, and personal responsibility, while also helping local farmers and growers.

Business Needs
As a non-profit working to bring awareness of healthy and accessible local food to the Flint community, the Flint Fresh team needed a mobile application that would help drive consumer awareness and usage. The app needed to send out notifications, promotions, and rewards to consumers, as well as allow them to complete an assortment of objectives in order to earn rewards and/or discounts to be used at their next visit to the Flint Fresh Mobile Market.

Solution
Spud developed a web application that controls the content of a mobile app that was developed with the goal of driving consumers to the Mobile Market through the mean of notifications, promotions, and rewards. The web application allows the Flint Fresh team to create campaigns for the mobile app. Campaigns allow the consumer to complete the objective and earn a predetermined reward to spend at the Mobile Market. The Campaign objectives consisted of taking a survey or watching educational videos to earn a reward that was created by the Flint Fresh team in the web application. The Flint Fresh team can upload a video to the web application and associate the video to be viewable on the app, part of a campaign or archive it for a later time. The surveys are uploaded in CSV format by the Flint Fresh team that will be sent out on a campaign in a question wizard on the app. The web application has the option to download the results of the surveys that have been submitted and the campaigns that have been completed to track trends.

Driven by consumer notifications, promotions, and rewards, the web application allows the Flint Fresh team to create campaigns for the mobile app. The consumers are able to complete objectives in order to earn predetermined rewards to spend at the Mobile Market, and these objectives consist of things such as taking surveys or watching educational videos. The Flint Fresh team has the ability to upload videos to the web app and associate the video to be viewable on either the app, part of the campaign, or they can archive it for a later time. Surveys can be uploaded in CSV format to be sent out on a campaign in a question wizard through the app, downloaded to show the results of surveys and completed campaigns in order to track trends.

The Flint Fresh Mobile Market team now has the tool needed to help bring awareness to their program through the access of a mobile app.

  • Ability to reach out to the consumer audience without tracking the individual consumers
  • Ability to create and track campaign rewards
  • Ability to track trends in consumer activity, trends from surveys, campaigns completion, trends in coupon rewards

Flint Gastroenterology

Business Needs
As a longtime client, Flint Gastro had a fully functional program that was originally developed many years earlier by Spud Software. After many years of successful use, the system was in need of an update to stay current with modern technology standards.

Solution
Spud created an enhanced version of the software system, allowing the Flint Gastro medical practice to manage their patients and day-to-day operations. It tracks appointments, provided reporting, and allowed the user to schedule next appointment reminders. The system was developer with the latest standards allowing the team at Flint Gastro the ability to use more devices and browsers to access the system.


GM Tax Staff Nafta Tariff System

Company Information
The NAFTA program for importing parts represented an opportunity for GM to save millions in tariff costs annually as well as an opportunity to get preferential treatment for its trucks at border crossings. The challenge: It required full compliance with the U.S. Customs Harmonized Tariff Classification reporting requirements.

Solution
Partnering with MSX International and GM’s Customs Brokers, Spud Software designed and developed GM’s Electronic Classification Reporting Database (ECRD). Our ECRD solution included tools that allowed their engineers to quickly identify and record the key specifications of a part, associate the part’s attributes with the corresponding rate listed in the US Customs tariff schedule, and create the necessary documentation to meet NAFTA compliance requirements.


Good Sleep LLC (Michigan Lung and Critical Care Specialists)

Company Information
Michigan Lung is committed to providing comprehensive, compassionate and patient-focused care for all of their patients and their families. Michigan Lung and Critical Care Specialists’ physicians, nurse practitioners, sleep technologists, and respiratory therapists continue to educate themselves in order to provide the most up-to-date treatment options and their efficient, friendly and professional staff works hard to make every patient’s visit to Michigan Lung and Critical Care Specialists as hassle-free as possible.

Business Needs
Method for collecting sleep apnea patient data in an out-of-lab setting and the ability to review collected data efficiently and effectively.

If you are waking up tired in the morning, perhaps you could be one of the 18 million Americans who suffer from sleep apnea. Obstructive sleep apnea is blockage of the airway during sleep, which can have serious life-shortening consequences such as high blood pressure, heart disease, and stroke.

In an attempt to make things easier for the growing number of people who have suspected sleep apnea, two board- certified sleep physicians with a pulmonary/critical care/sleep disorders medical practice in Grand Blanc, Michigan have been researching and developing a method of testing for sleep apnea using a smart phone. Dr. Mark Rittenger and Dr. Gregory Streff, of Michigan Lung and Critical Care Specialists, have teamed with Spud Software to create an app designed to use with a smart phone and simplify the testing process. Nocturnal Polysomnography, or sleep study, is usually done in a sleep lab, with the patient hooked up to wires, and monitored during sleep by a sleep technologist. Many patients are unable or unwilling to have an in-lab study, or their insurance company may only cover a home sleep test. This new medical application will allow patients to do the testing outside of the lab, with the data being recorded via an Android device and the data is then uploaded and sent to the physician for interpretation.

Solution
Spud Software was able to create a two-fold solution, first creating an app that the patients themselves could use, and then creating an administrative website that the staff at Michigan Lung and Critical Care Specialists could use to view results. After logging into the app, signing the HIPPA waiver, and doing a pre-sleep survey, the patient would hook up leads and wires that capture different readings such as the bodies’ electrical signals and oxygen levels. When the patient woke after the study, the patient would have another interaction with the app to take a post-sleep survey and then the information would be sent to the administrative site for reporting.
Doctors and sleep technicians had the ability to view the patient’s data in order to decide if they were suffering from sleep apnea. This was especially useful to patients that were homebound and truckers that are constantly on the road, but are required by the industry to take the test yearly for insurance purposes.

With the In-Home Sleep Study Software, Spud Software developed a proprietary out-of-lab sleep study software app that will enable patients to take a “lab quality” sleep study in the comfort of their own homes. Sleep apnea is a very serious condition that can lead to bigger problems such as high blood pressure, heart disease, and stroke. If we can increase the amount of people willing to take the tests by simplifying the procedure, then we have hit our goal.

Simplifying the Procedure – Patients receive a case-protected Android phone with the app pre-installed and instructions for use.
Helping the Uninsured – The app can help the uninsured or those whose insurance won’t cover sleep tests
Automated Results – The data is automatically recorded onto the phone and then sent to the physician.
Home Comfort – The app allows patients to have a sleep study from the comfort of their own home.

Technical Details
Android app designed to support a custom-made circuit board and wiring harness for collection of patient data. CMS website for managing patient profiles, staging and scoring recorded sleep data, and doctor’s report generation.


GPB Benefit Solutions

Business Needs
GPB Benefit Solutions came to Spud looking to create a Benefits tracking software solution for the labor industry. They had a high level concept and a need for design specification document for the software platform.

Solution
Spud worked very closely with the GPB Benefits Team to capture and document all aspects and details of the software solution consisting of wireframes, flow diagrams, and business logic documentation. This provided a complete overview of the software needs and helped identify any gaps prior to a software build out.


Grand Blanc Community Schools

Business Needs
Grand Blanc Community Schools came to Spud looking to streamline an existing custom application. The existing application was very intensive on server resources, took a significant amount of time to process data, and did not provide alerting and notifications of failures.

Solution
Spud worked closely with the Grand Blanc Community Schools IT group and established an automated Data Processing Application for consuming GISD data and generating multiple output files to support the many 3rd party vendors used by Grand Blanc Community Schools. The application provides automated notifications of failures and streamlines the IT processes for managing the data integrations moving forward.


Grand Blanc Parks and recreation

Company Information
In a cooperative effort in 1970, the city of Grand Blanc, charter Township of Grand Blanc and the Grand Blanc Community Schools formed the Grand Blanc Parks and Recreation Commission. The Commission operated as a part-time department until 1975, when it became a full-time operation.

The Parks and Recreation Commission is responsible for operating and maintaining Creasey Bicentennial Recreational Complex and the newly renovated Grand Blanc Senior Activity Center. In winter months, when weather permits, they maintains the ice rink at Physician’s Park and the sledding hill at Creasey Bicentennial Park. Currently, the Grand Blanc Parks and Recreation Commission employs six full time staff, and depending on the time of year, an additional 50 – 125 seasonal and part-time employees.

Solution
A website was created that allowed Grand Blanc Parks & Rec to enter new programs that were being offered into the system so that users could sign up and pay for them. Users were able to create an account, register for classes or events, and pay for them all in one place. Once this was done an alert was sent out to the staff. The site also had functionality in place to limit the registration so that if only 25 classes were available, a 26th person could not join. It integrated with Stripe so that people could actually pay for the classes there. It sent out confirmation emails and alerted the Grand Blanc Parks & Rec staff that you had a registration. It basically just allowed them to manage their entire Parks & Rec program system right through their website.


Grant Mccarthy

Business Needs
A member of their staff was using a custom developed Microsoft Access based application to calculate net operating loss tax values based on provided company information. Grant McCarthy was looking to expand this application into a software as a service system in a web-based platform, but previous attempts to migrate the application to the web had failed.

Solution
We created an app for the corporate tax website that allows large companies to go in on a state by state basis, look back and determine what their net losses would be, and refile previous year tax rebates on net operating losses that may have expired or were not used correctly. The app also allows the user to look forward and view what their net operating loss is as they import their data, and when the best time would be to claim those taxes. This was redeveloped as a fully web-based application, allowing it to be taken to market as a software-as-a-service tool. What he will be able to do is, his team can still manage an individual’s tax records, import their data and run it, but the end reports that people need to actually do the refile are things that the end-users of the different corporations would be able to run themselves. It is targeted towards large to very large corporations operating on a national scale.


Green Peak Innovations

Business Needs
Green Peak Innovations came to Spud looking to expand their brand across a mobile presence on Android and iOS, creating an app that would connect customers to their brand and provide a digital communication solution.

Solution
Spud worked extensively with the Green Peak Innovations team and their 3rd party providers to generate an integrated mobile app on the Android and iOS platforms. The mobile app connects Green Peak Innovations’ customers to their online menu of products, retail locations, loyalty benefits, and promotional communications.


Helping Hand Home Health Care

Company Information
Helping Hand Home Healthcare is a family owned business established in 1973 and has grown to become one of Michigan’s largest home care providers. They have achieved both ACHC and CHAP accreditation because they are dedicated to providing the highest quality of health services.
They believe that all of their clients are entitled to live with dignity and that it is their job to ensure that they are able to do so in an environment of utmost health and respect. Helping Hand Home Healthcare maintains a family oriented approach designed to meet the needs of the client and family, together as a unit.

Business Needs
Reporting system to track data from their current system to track internal data and customer data. Specialized reports were needed to track certain data, the allocation based on criteria and movement of critical data. Helping Hand’s needs of reporting on critical data will help manage and scope out future business needs, expenses, moves and forecast business plans based on the reports.

Their current business software did not have the ability to produce the report Helping Hands is looking for. They reached out to us to build the custom reports off of their current database. The reports are specifically based on certain criteria and user input within their current software.

Solution
Create enterprise reports to support Helping Hand see the movement of data and forecast based on the reporting data. We built a report option using SQL Server Reporting Services to allow them to pull the report needed in real time. The report was completely custom built to their specifications.

Technical Details
We used SSRS to run reports against their preexisting database from their current software.


Ideal Machinery, Inc.

Company Information
Ideal Machinery, Inc. has spent over 20 years building a company with a reputation for understanding the fast-paced climate of the industry. They make it a point to ship products quickly and from their beginning in machinery sales, to their current status as one of the world’s largest dealers of machinery and parts, they have done everything they can to satisfy their customers – and that has made Ideal Machinery, Inc. a force to be reckoned with in this industry.

Business Needs
Ideal machinery needed support for an existing database and API system in order to manage data
synchronization between two different online sales portals which share a common inventory.

Ideal Machinery has a website and database with an attached API, with the full system in PHP. Along with the website, Ideal Machinery also has an eBay site where they sell their products. The custom made API allows
the company to synchronize changes to the products automatically across both the website and eBay. For example, if the description were to be updated for a product, this change would automatically update in both
locations, synchronizing their inventory across platforms.

Solution
Spud Software provides support to maintain and update the WordPress site, e-Store, API for data synchronization, and related services.

Technical Details

  • WordPress site with a large amount of custom coding and plug-in management.
  • Online e-store for hardware sales and support.
  • Business eBay profile for hardware sales.
  • Custom API for inventory levels and data synchronization between WordPress e-Store and Business eBay profile

Jetpack Marketing LLC – Code

Spud Software recently worked with Jetpack Marketing, LLC in the development of CODE: a novel, mobile-based application to assist dealerships with the presentation, comparison, test drive, proposal and delivery phases of auto sales.

Utilizing a custom content management system, CODE consists of a specially-crafted database of extensive vehicle information (including competitive comparisons) and the mobile app that works in the challenging environment of dealership lots—which often do not have reliable internet access.

Another key is that all of this content is managed by Jetpack Marketing from their own cloud-based dashboard, also developed by Spud, which then distributes the data to iOS devices around the country.


Lake Management – Business management system

Business Needs
Lake management companies are required to provide detailed reports about their lake treatment activity to the Department of Environmental Quality (DEQ).

Solution
Spud Software developed an end to end business system, inclusive of the ability to auto generate customized reports that meet each state’s DEQ requirements.


Michigan Institute of Urology (MIU)

Company Information
As one of the oldest and largest sub-specialty Urology practices in the State of Michigan, Michigan Institute of Urology (MIU) is dedicated to providing patients the most up to date, state of the art urologic care. Their specialists have been recruited from the most sophisticated university centers in the United States and are available at all 22 office locations. MIU’s administrative staff follows strict guidelines to insure the most cost effective medical care is provided. Michigan Institute of Urology, P.C., is comprised of 46 General and Fellowship Trained Urologists with a complement of compassionate, caring Nurse Practitioners, Registered Nurses, Medical Assistants and Ancillary Personnel.

Business Needs
To provide a proof-of-concept demo app for use at trade-shows.

MIU was in search of a method for tracking patients within medical facilities that could supplement existing system. Partnering with Industry Scope, MIU had a vision of a product which could be resold to other medical facilities for managing patient billing codes using a lite-weight mobile app which could also be used to notify on-premises care providers of an emergent situation with a patient at a given facility.

Solution
Spud created an iOS app and website which were to be primarily used for managing patient rounds in medical facilities. The purpose was to give visiting doctors an order of operations when they showed up at a given facility of who they needed to see in what sequence. Administrators could do push communications that went out across all the users of the app. That way, if a patient was going into an emergent situation the user could push a notification to the doctor saying “If you’re within this active patient care group at the facility you are assigned to at this time, you need to get to room ### stat”. The backend website managed the content of the application, allowing the user to add other users, patients and their data, as well as hospitals, their floor and their room information.

We built a prototype system that MIU could then take to trade shows and demonstrations. The demo provided flexibility and on-the-fly customizations such as allowing users to do drag-and-drop reordering of patients and allowed them to enter patient notes and apply billing codes to patient records. This software prototyping was built so that MIU could take the demo to trade shows. The demo also allowed the user to enter notes that stayed until the demo was complete.

Technical Details

  • iOS app for managing patients, patient rounds, and billing codes.
  • Administrative CMS website for adding new patients, adding in medical care facility information, system user administration, billing codes management, and End of Day report generation.

NAPA Database Conversion

Business Needs
Spud Software was contracted by RL Fisher (NAPA’s training management company) to convert 16 major data bases to 2012 standards.

Solution
Spud Software’s team of programmers performed the upgrade and also replaced several outdated data feeds and reporting routines with a comprehensive data exchange application.


North American Bancard Mobile App

Solution
Spud Software was contracted to develop mobile apps for processing anywhere, anytime payments via smart phones and tablets. The app supports the sellers real time transactions for both their B2B and B2C business.


Primacy Systems Pvt. Ltd.

Business Needs
When the client came to us, their current website was having functionality issues. When a user accessed the site and tried to update their subscription, it would process the payment but it would not activate the subscription. Due to this error, the company had to process credit back to all of the subscribers that ran into the issue and manually update their subscription. Their site was down for three days at one point while they were trying to correct the problem.

They also were unable to sell physical products or event tickets online, had minimal security to the site, and the site was not interactive for the user.

Solution
We were able to step in and fix the payment issue in their site in under two hours. After that, we created a new site for them which gave strengthened security, allowed them to sell products and event tickets online, and added more interactive pieces like audio and videos for the users to view after log in. We developed the audio player as a site-wide application that allows users to play audio files that will continue playing while the user navigates through the site. For instance, if you were listening to the audio and decided you enjoyed the speaker, you could continue listening while you went to the purchase page to buy more audio from their series. We integrated UPS Vertex and Global One Pay and credit custom credit card payments which allows the system to do all of the subscription billing and even manage automatic retries.


R.L. Fisher & Company, inc.

Business Needs
Their old system was running three separate databases running 3 different versions of Microsoft SQL in-house, one of which was being expired by Microsoft.

Solution
Spud Software consolidated all of their databases into a single SQL 2012 server offsite, moved and tested the multitude of websites that they ran, improved their security, and redid all of their backend management processes to move them away from out of date DTS packages and into a processes that could be remotely managed.


SendJim

Business Needs
SendJim wanted to simplify customer follow-up with a software solution that automates their client’s responses to customers.

Joshua Latimer, founder of SendJim, originally approached an off-shore company to build the software in order to save on costs. With multiple undesired results, he then approached Spud Software and we were able to assist with the project requirements, implement, and roll-out the completed software with both reasonable pricing and timing. Spud Software excelled and provided more than just the step-by-step coding instructions you see from an off-shore company. SendJim needed a business automation tool for regular people. It was hand built for small business professionals as a way to increase their customer loyalty, follow up, and customer engagement. Their belief is “You don’t have time to follow up with every single prospect or client, but “Jim” does.”

Company Information
Joshua Latimer has a passion for helping small businesses recognize their potential through customer relations. He works with his clients to help them understand the importance of properly following up and engaging their biggest asset, their current customers, and to show them a clear path to more money and referrals simply by loving their clients better.

Solution
Spud Software continually works with SendJim to add more and more useful features to their software application. Here are the phases that have been completed so far:

Phase #1: Street Bidder
Sending Postcards and Emails on the move.
During this phase Spud Software built out both a web application and mobile apps for Android and iOS. It allowed a simple way for users to reach out to potential customers and also follow-up with current and potential customers by sending emails and postcards. To send a potential customer a quote, the user can take a picture of the house from the street, enter the address and pricing details in to the app, and with the click of a button send the customer a fully customized postcard.

Here is a feature list:

  1. Photo editor for modifying pictures before sending mailings
  2. You can “search” for previously captured customer information so you don’t have to type it in again
  3. Added a “Find Me” button that auto locates you and saves time from typing in the street, city, state and zip codes.
  4. Brand new and completely redesigned “Quick Send” feature.
  5. Send emails in addition to postcards
  6. You can set your postcards and emails to send immediately or at any future date
  7. You can send multiple different mailings at once with a sequence all by pushing one button
  8. You can buy credits inside the mobile app

Phase #2: Sending Gifts, Letters, and Greeting Cards

During this phase, we improved upon the software to include additional mailing types. For example, you can send brownies, gift cards, and popcorn to your customers. Or you can send them a custom letter or high quality greeting card.

Phase #3: Radius Bomb, Neighbor Mailing, and Integration Options

This has been the ultimate improvement! During this release Spud updated the software to do the following:
1. Radius Bomb: Using a satellite view map, draw a shape around any house or group of houses to automatically send them a mailing. We build a comprehensive address database that includes every mail-able address in the United States along with their location data. This has caused a lot of excitement among small business who can now target neighborhoods with mailings without sending out salespeople on foot.
2. Neighbor Mailing (Five-Around): Typically, a small business will walk to the nearest neighbors of a recent customer once the job is complete. Starting with this release the system can automatically send a custom mailing to the clients nearest neighbors! It can include a picture of the work done from the customer and testimonial.
3. Integration Options: API available to use with your favorite CRM. Within your CRM users can now send a Send Jim Mailing once a job is complete without having to log into the SendJim application separately. Users can also import their customer list from the CRM into SendJim with the click of a button.

Technical Details
Web application built using a .NET MVC Framework and SQL Server Database. The Android and iOS mobile apps are built in their respective native languages.


Spartan Properties

Business Need:
Spartan Properties came to Spud with an existing process for managing their mobile home inventory that was entirely Excel based. All details were added into an Excel spreadsheet that was shared across the network. The sheet was slow, difficult to use and did not contain all of the information that administrators needed which often forced office staff to search through paper records for details. The system also did not provide an accurate indication of what state each home was in and what might need to be done on a specific home.

This system was impacting the growth of the business. The overhead of trying to work with the Excel based system was keeping the administrative staff extremely busy. This prevented Spartan from pursuing growth opportunities to expand the business into new areas or increase how many homes they can process simultaneously.

Solution:
Spud Software produced a web based administrative solution for Spartan that allowed them to maintain all of their home details in a single repository. The system captured all of the details about each aspect of the home, allowing administrative staff to avoid searching through paper records for common questions. The system also features an event driven system that accurately represents how homes are processed and can handle things happening out of the normal expected order. The system is available off site and on mobile devices allowing users to access information without reaching out to administrative staff.

This solution has increased the total workload the existing staff is able to handle. This will allow Spartan Properties to increase the number of homes they process and expand the areas they operate in. Additionally the solution has increased their data integrity and level of knowledge transfer. With all information in a single repository, they are no longer constrained to looking through paper records for details about homes.

Technical Information:

  • ASP.NET 4.6 MVC Web Application
  • SQL Server 2016 Database using Entity Framework Code First
  • Microsoft Identity based authentication
  • HTML 5 with AngularJS

Stat EMS Geo-Locating App

Company Information
Current and future investments and enhancements that include government and private partnerships and a new breed of transportation logistics services will further strengthen our reliability and quality control. Health Care Reform will present new and unforeseen challenges but STAT considers these challenges as an opportunity to promote and grow its service in the Region.
Advances in their logistical and technological capabilities and continued focus on servicing skilled nursing facilities, hospital systems, and other predominant health care areas will attract new clientele and promote job growth in the State of Michigan.
Meanwhile, their professional relationships in the medical community at the local, State, and Federal level and the UAW Region 1D will continue to open up new and unforeseen opportunities.

Solution
We created a geo-locating app that allowed the user to see where calls generally came from and place ambulances near that location so that they could be the first to respond.


Student Adventures

Business Needs:
Mobile app for iOS and Android for students to use on fields trips along with an administrative website for managing the content within the app on a per field trip basis

Company Information:
Student Adventures is a Michigan family-owned business working with educators to provide extraordinary educational travel experiences for students. Student Adventures’ travel experts have been working with student groups for over a decade creating quality tours to every major US destination. Unlike many tour providers, Student Adventures’ philosophy is to keep overhead low and pass the savings along to your trip participants. In a challenging economy Student Adventures believes that affordable prices are just as important as quality service.

General Problem Description:
Student Adventures was looking for a cost-effective way to provide the students on their field trips with a mobile app which could function as a self-guided tour narrator, provide itinerary and scheduling information, and a provide method of contacting students who are on a trip in an emergency situation.

Solution:
Based off of the Tell Ask Sell app created by Spud Software, Student Adventures had an app created that allows students on field trips to see what they would be doing on a given day during the field trip and provide crucial information about points of interest in the field trip location. Via an administrative portal, parents to see what’s going on with a trip, and bus drivers and tour guides can communicate.

Technical Details:

  • iOS and Android public-facing apps available for download from App Store and Google Play respectively.
  • CMS administrative website for managing app contents.

Tell Ask Sell Marketing Communications Tool

Business Needs
Spud Software partnered with local business and marketing experts to develop a robust, easy-to-use communication tool that allows users to create and launch multiple communication campaigns across a variety of media formats. Using our Agile Approach, Spud Software worked with the client to design, develop, and launch this customized marketing tool.

Solution
Tell Ask Sell eliminates the fragmented tools needed to reach people by combining email, direct mail, sms, social (twitter® and facebook®), custom-branded Android® and Apple® apps and rich mobile surveys into an easy-to-use, highly customizable web-based suite. Today the Tell Ask Sell cloud-based software gives subscribers single-point control over their outreach campaigns. They can engage in meaningful dialogues with their audience, whether they’re consumers, employees, students, patients, whomever. And since the subscriber has multiple broadcast paths to precisely communicate, and the audience selects their path preference and lifestyle interests, Tell Ask Sell ensures a relevant, mutually desired exchange.


The Hundred Club

Business Needs
The Hundred Club of Genesee, Shiawassee, and Lapeer counties came to Spud Software for help with their online systems, with a need to consolidate their membership management and electronic communications platforms.

Solution
Spud implemented an online system that provided The Hundred Club newer technology that allows for their team to easily handle their membership management, billing, invoicing, email campaigns and much more.


The Pink Fund

Company Information
The Pink Fund helps women diagnosed with breast cancer who are unable to work or get access to financial aid. The last thing anyone battling cancer should have to worry about is money; sadly, that is the reality for thousands of people.
General Problem DescriptionThe Pink Fund already had a website, but they came to Spud in need of a web application that would accomplish two key goals:

  1. Make the application process, which includes the up-loading of multiple documents, a more stream-lined, user-friendly experience for their clients.
  2. Make the entire process efficient for everyone from the client, to the dedicated Pink Fund staff, who sift through a huge number of documents to get clients processed.

Solution
Spud Software provided The Pink Fund with a custom-built solution that was tailored to their needs and allowed for the management of applications and all necessary documentation. The solution allowed applicants to complete and submit application data and documents across multiple devices- PCs, Tablets, and Phones. The Pink Fund reviews the submitted information and can request additional details from the applicant or move the application along for review and approval, creating an electronic and streamlined process for everyone.


The State Bank

Business Needs
The company had an old system for internal applications and filling out pre-credit screenings and the old PHP application would not work with their upgraded server.

Solution
We went into the application and updated it to remove the outdated portions that were no longer supported by the newer version of PHP. In addition, we also added error trapping and other controls to make the flow of the program work better and be more stable.


The Wonka Truck

General Problem Description:
Wonka has been delighting kids for decades. When Spud Software was approached with the opportunity to join in on an effort to develop a mobile play station for Wonka, we quickly agreed. What resulted was fun on wheels for area children and a great marketing tool for Wonka candies.

Solution:

  • The Wonka truck would drive up and open a side door.
  • Inside the truck was a 52” screen that allowed children to engage in games and win candy.

Toyota Vehicle Delivery Mobile App

Toyota was seeking to improve their customer’s satisfaction with the vehicle delivery process. The primary issues were the length of time it took to review the vehicles features with the customer and the inability of the customers to retain the knowledge.

Spud Software provided Toyota with a mobile app solution with the following key elements:

  • A library of content for all key vehicle features (Images, video, and text descriptions).
  • The time it takes to review each feature’s content is also clearly displayed.
  • The sales person then has the ability to custom select sets of features that each particular customer wants to review (with a known length of time).
  • The features selected for each set are then sequenced in a clockwise manner to be reviewed in one trip around the vehicle.
  • After the delivery review is complete, the customer is e-mailed a link where they can download the app so that they have easy access to their vehicle info at any time.
  • The app is supported by a back end content manager that allows Toyota to update the content independently at any time.

Viopoint – Powershell Reports

Company Information
For more than 9 years, VioPoint has been helping organizations effectively manage the challenges of protecting critical business data. They understand the value of delivering results and each of their core offerings (testing, compliance, vulnerability management, and monitoring) are focused on this simple goal. VioPoint’s experience transcends a broad range of clients that include leading industry segments.
Organizations work with VioPoint because they want to accelerate security program performance and establish a foundation for continued success. If you are struggling to quantify results and faced with the all too common challenge of selling silence, VioPoint can help.

Business Needs
VioPoint and their clients needed security solutions to handle multiple points of security standards. Their preexisting applications were in need of being updated, and new processes needed to be built to handle growth and customer needs. VioPoint needed reports that complied with client standards based and/or government regulation, reduced the number of vulnerabilities in their systems, and could be used to create a baseline to compare data. They also needed a PowerShell utility use cases to produce data based on specific criteria, which would then be updated and create a graphic representation of the report for the user. Different solutions were needed based on security vulnerabilities and scanning times.

VioPoint relied on PowerShell and Qualys to run their operations, as well as the operations of their clients. The existing PowerShell utility tools were in need of updates and a way to process new data. When VioPoint came to us, updates were needed that involved creating new reports and visual graphics in Excel so that user could quickly understand and process the data.

Solution
Spud Software utilized existing PowerSHell utilities and enhanced them to fit the needs of VioPoint’s clients. We expanded the functionality of the PowerShell Cmdlets to handle new use cases and adjusted existing use cases, and the utilities download data from both Qualys and Kenna. With the data from Qualys and Kenna, the utility would generate a report in either a CSV or Excel format. If CSV, it would list all of the data with column headers that the client had requested for that use case. The Excel format files would have multiple sheets, one for data similar to the CSV, and a second for visual charts. Charts varied from line graphs to stacked bar/column charts.

Technical Details
The utilities would call out to APIs for Qualys and Kenna through PowerShell commands using a web request and would then process the data to produce a CSV/Excel report. The Excel reports would contain charting of the data to show trends and the current status of the companies’ assets.


Viopoint – Qualys Data Warehouse

Company Information
For more than 9 years, VioPoint has been helping organizations effectively manage the challenges of protecting critical business data. They understand the value of delivering results and each of their core offerings (testing, compliance, vulnerability management, and monitoring) are focused on this simple goal. VioPoint’s experience transcends a broad range of clients that include leading industry segments.
Organizations work with VioPoint because they want to accelerate security program performance and establish a foundation for continued success. If you are struggling to quantify results and faced with the all too common challenge of selling silence, VioPoint can help.

Business Needs
VioPoint and their clients needed security solutions to handle multiple points of security standards. Their preexisting applications were in need of being updated, and new processes needed to be built to handle growth and customer needs. VioPoint needed reports that complied with required client standards based on government regulation, reduced the number of vulnerabilities in their systems, and could be used to create a baseline to compare data. They also needed PowerShell utility use cases to produce data based on specific criteria, which would then be updated and create a graphic representation of the report for the user. Different solutions were needed based on security vulnerabilities and scanning times.

VioPoint had a client needed to resolve multiple issues at once. They wanted to be able to feed their internal dashboard for live reporting of current data, while at the same time have a backup of their cloud Qualys/Kenna data.

Solution
Spud Software created a Windows service and a front end application (WPF app) that communicates via a Web API service. We built the functionality to pull data from Qualys and Kenna, and the Kenna data imported and merged with the Qualys data. The front end application sets up all of the settings for the applications, and communicates via a web service which has a self-hosted Web API service within it. The Windows service also has a self-hosted SignalR service. The user can manually start the process to download data through the SignalR service, whose communication channel was carefully designed for UX and responsiveness. The project included a SQL scripts, created to handle 11 different use cases that VioPoint’s clients needed. The scripts were given to VioPoint’s clients dashboard team in order to put it into their internal dashboard.

Technical Details
The front end application is a Windows Presentation Foundation (WPF)application which communicated with the windows service in one of two ways, Web API or SignalR. Web API was used in order to create, read, update, or delete functions and windows service settings. SignalR was used to run a function outside of its scheduled runtime.

The Windows service handled the running of the functions, while Qualys functions would download all current data from the Qualys cloud and import the information into a temp table in the database. The data would then be prepared for the merge and merged into the rest of the data. Kenna functions would download all current Kenna data and store it in a temp table before merging the data into the correct Qualys Asset record. The Purge Data function cleaned out all of the data in the data warehouse based on company policies.


Visible Builder – Social media Management Mobile APp

Company Information
On March 27th, 2013, Dennis Schaefer attended JLC Live, a national trader show for residential construction professionals. After speaking with other builders at the conference, Schaefer noted some frustration among his colleagues with the recent rise of Social Media Marketing. Large-sized construction and home improvement companies were taking advantage of social networks like Facebook, Porch.com and Houzz to advertise their work. Meanwhile, small business owners said they lacked the resources to reap the benefits of social media marketing.

Being a licensed builder in the state of Michigan for more than 34 years, Schaefer understood their concern. Following the conference, Schaefer took out his binder and began jotting down some ideas for VisibleBuilder.com.
A year later, Schaefer shared his idea with our Spud developers and Visible Builder soon became a web-based program, capable of maintaining various social media profiles and handling daily posts for professionals in the construction industry.
“The initial reaction has been even better than expected…Everyone loves the concept and the program’s simplicity.”

Solution
Spud Software worked with Visible Builder to develop an app that ties into their Social Media Management platform (also developed by Spud) that allows users to submit account updates via their mobile devices. These updates create online reviews on the most popular and Google searched sites and include the ability to upload images. The system also took and tracked payment and would discontinue user access if payment was overdue.

Technical Details

  1. Reputation Monitoring – Research on what’s being said about a client’s company online.
  2. Testimonial Harvesting – Builders will also be asked to submit email addresses, which are used for testimonial harvesting. Visible Builder contacts the client’s best customers to obtain testimonials, then posts to their various social networks.
  3. Local Search Assistance – Updating any outdated profile information on local search directories.
  • The ability to take a picture or select from the phone’s gallery.
  • Tracking and displaying the number of monthly updates a user has remaining.
  • A simple, easy-to-use interface to make the process less intimidating for users.