Bath Fitter (February 2019 - October 2019)
Application Developer
MobileForce API
This API is used by a company called MobileForce, who created an application for us to be able to provide bath tub installers with iPads and perform tasks such as pulling up appointments, save measurement details, create/update service tickets, get customer data, and get contract data. The MobileForce API was written in C# asp.NET, and is a RESTful API. This made all of the creating, updating, deleting, and getting that the application has to do possible. This used a combination of T-SQL stored procedures, views, and linq queries to get the data, update the data, and insert data into our database in real time.
Shiftboard API
The Shiftboard API is used to update, create, and delete events from Shiftboard, after they have been inserted, modified, or deleted from our system. The database used a trigger, which inserted into a temporary table, with the information of which API call to use, and which ID to create/modify/delete. This was written in C#, is a RESTful API, uses Linq, and is triggered using a stored procedure and a SQL job. This API was to ensure that data was only entered once, which reduced the chances of error and saved the time of the coordinators entering the data.
My Home Renovator API
MHR is a company that works in Sam's Clubs across the US. They try to sell bathroom/kitchen/door & window remodeling to people who are interested, and give potential customers our company information. This API sends the leads that are generated from MHR, so that they have up-to-date information on the leads that they have sent to us, and to ensure that we pay them a cut, if a sale is made. The API was written in C#, is a RESTful API, uses Linq, and is triggered via a SQL job that runs and sends leads every day at the same time.
Project Map It API
Project Map It is a service that allows our sales force to go out to different houses and showcase installs that have been done within the same neighborhood and/or a location that is close to the potential customer. This API sends data about previous jobs, including the name, address, city, state, and ZIP code of customers who have had his/her bathroom redone by Bath Fitter. The API is written in C#, uses a combination of a SQL view and a Linq query, and sends updated jobs every four hours throughout the day. It is triggered via a SQL job.
Twilio API
Twilio is a service that allows for direct SMS/MMS messaging to an individual, after a phone number is purchased through them. The purpose of this API is to text customers who have an appointment every morning at 8:00AM. The API is triggered via a SQL job, and it is passed a unique ID that identifies which appointment to send information about. From there, the text message is formatted so that both the date and the time of the day is sent the day before the customer's appointment. The API also handles the customer's response to the text message as well. If the customer responds with a reply of confirmation (Okay, Sure, Yes, etc.), then the appointment is confirmed in our system. If the customer responds with something other than yes, that response and the details of the customer and the appointment are sent to our Call Center, so that the customer can be contacted. The Twilio API is written in C#, and utilizes Entity Framework and Linq.
White Pages Pro API
White Pages Pro is a service that checks a phone number, analyzes it, and returns scores that state whether or not the number has a chance of being a number that is spam. This API was utilized to check the phone numbers that Bath Fitter has used to call customers. The higher the score, the higher the chance that it is spam, which increases the likelihood of the number being flagged by a robocall service on a phone, which blocks the number. After the number is returned, the values are stored in the Microsoft SQL database. If a high spam score occurred, then the phone number is swapped out for a different one with a lower score. The API was written in C# and also includes a GUI for checking individual phone numbers (using MVC). The API also utilizes Entity Framework and Linq.
Bath Saver CRM
The Bath Saver CRM is a custom-made application for performing various tasks such as scheduling installations, services, and calls as well as processing sales, cancellations, and more. The Bath Saver CRM does a lot of other tasks as well, as it is central in our day-to-day operations at Bath Fitter. While I have not built the application from scratch, I have added additional functionality to the application, according to IT service tickets that we receive. This application is written in VB.NET, with a Microsoft SQL database for storing the data. Working on this application helped me to pick up VB.NET quickly.
