Overview
From 2016 to 2019 I was contracted to consult and design a business operations system to support the development of the at the time, newly established Quotation Department to align, support, and improve existing corporate quotation systems for a team of 3 estimators and estimator teams located across all locations (Hickory, NC, Raleigh, NC, Charlotte, NC, Columbia, SC, Charleston, SC, & Atlanta, GA).

In 2017, I was hired on board full-time to maintain the systems in which I designed. As of 2021 to my knowledge, these interfaces are being used. In this passage I will briefly touch on my responsibilities in this design project.
Projects
Calendar Design & Administration

Database Design & Administration

Digital Filing & ETL

Sharepoint Design & Administration

Warehouse Interactive Map Design
Responsibilities
User Experience

Establishing Business requirements
Multihoming
Writing proposals for necessary software to create interfaces
Audience Research
User Journeys
Uncovering Network Clusters
Creating User Stories
Network Effects
Network Bridging between Murray Supply's Vendors and Interfaces
Convert physical files, floor maps and specifications to sleek and intuitive digital files via Sharepoint Design.


Quality Assurance, Accessibility, and User Testing

Worked closely with sales, vendors, clients, IT, and stakeholders to ensure interfaces were accessible company wide.

Ensured Interface accessibility for vision impaired.
.
Daily meetings discussing needed requirements for interfaces

Ensuring each step of the database along with the calendar, were descriptive and accounted for all items being requested for quote from estimators.

Scheduled testing with coworkers from multiple departments and various levels of management for databases, calendars, and SharePoint sites I created.

Prioritized test tasks and monitored user which aided in flexibility, efficiency of use, real world use, and detecting errors to ensure QA requirements were met.


Team Management
Delegated daily projects amongst team through project set up, initial project contact, maintaining communication with clients, and project delivery by the deadline on a daily basis (Projects could last anywhere from due same day to 3 months or more based on the need for updates, extensions, or revisions due to bid requirements).

Maintained project calendar and records for up to 3 years as well as record filing

Preparation of training materials and training for new hires from mid-level to management in Charlotte location.
Team
Stakeholder: Brooks Jester

General Manager: Brian Harris

Manager: Terry Parrish

Quotations Admin and Database Architect:
Jeffery Wiafe(Me)

Lead Estimators:
Jason Brown
Jim Yount

Supporting Estimators:
Franky Helms
Background
In September 14, 2015 – MORSCO, a Fort Worth-based distributor of commercial and residential plumbing, heating and cooling equipment (HVAC), and pipe, valves and fittings (PVF), acquired all of the assets of Murray Supply Company (“Murray Supply”), a leading plumbing supply company based in North Carolina. As a result of the expansion, the quotations department was created to facilitate managing quotes from all of Murray Supply's 4 locations which grew to 10 (NC, SC, and GA).
Research


Competitive Research

In the beginning I was provided a few notes about competitors and how their departments were ran. I cannot go into too much detail to avoid exposing trade secrets, however these initial notes and meetings with the stakeholders. Were essential to getting my foundation set for the over all structure of the interfaces I would build to serve all the requirements of these projects.

Another hierarchy I had to understand was the waterfall structure of the industry and how information got to the quote department.

Below is a sketch of a draft of a flow chart I created before creating a final high-fidelity for the department to use during the course of their work:‍
Examples of Some Requirements Assigned:

Audience Research
To play a role so integral to almost all construction projects from set up to delivery, I had to take into account how my designs would impact each department of the company and how it could either help or hurt delivery times and communication with clients, I began by learning about Murray Supply and which part of the process needed the most attention and priority.‍
Ideation & Development
Due to the various skillsets needed per department, my manager and I conducted daily SCRUM meetings until all interfaces were up and running in their entirety.

To detail, this process helped us devise a code that we could use to apply to different types of projects to provide specific KPI to quotes, for stakeholders to make essential business decisions. This led to Reporting such as depicted below:
Thanks to Open Creative Sessions we designed a code system that ultimately served upper management, in addition to appropriate microcopies to use when sending quotes and creating calendar entries.

Managers valued the code system as it would aid in directing sales team members to clients who focus on these types of buildings or compare what types of projects to focus on getting quotes for. We also thought of all cases where anyone who had access to our calendars and databases may have trouble navigating and finding updated quotes due to the serial number difference per quote, and contractors, new architects, and new engineers calling the same project different names or code names per quote request.

This led to another issue revealed during our brainstorm which was naming conventions and hierarchies to keep all these projects organized in an intuitive way that would be inclusive to everyone involved with the project.  

Example:

###### for the Original Quote
###### for the Original Quote update
######-1 For a Rebid
######-1a For a Rebid update


During this session, I also learned that Salesmen work with a vast variety of companies who all have their own management structure they use from Waterfall, Agile to "Mom and Pop", many still have processes that are decades old. This meant that I had to adopt a filing system that kept all the essential details front and center, along with being as accessible as physical copies of the documents they were used to taking on the road with them.

Ultimately implementing Open Creative Sessions to generate ideas led me to narrow down software that would be essential to daily operations:

SharePoint
Google Drive
Localendar
Access
Excel


*It is important to note that I had the range to apply any necessary software however, due to the various skill levels, I understood that these 5 would be sufficient to the company's goals and save them much more money than creating an interface from the ground up.

(This would have cost hours from the IT department along with several lengthy phone calls and meetings daily when my department should be heads-down quoting bids for clients.)



Language developed when sending communication outside of the department:

(Though well known, and largescale, Murray Supply is generally personable, direct, and to the point, we couldn't make the language in our correspondence too technical, or we could risk loosing the bid entirely.)
A major hurdle which came up during the calendar development process was language and color palate.

How would we see a Total of Jobs without cluttering data with other entries?

What color could be used to signify department-specific tasks and employee updates?

Would there be enough range in color choices to signify when a job was complete, in progress, or needed to be started?

Below are my notes and iterations to final version for the calendar:
Notes:
Sketch:
Final Calendar Entry Layout:

Due to the limited color selection on the calendar design system we used, we had to figure out which color would be used per entry and any other potential scenarios or hinderances which would arise during the workday:

Final Calendar Color Palette
Final Calendar Design
During my testing of the calendar, an issue arose which needed the highest priority especially as traffic ramped up for quote requests.

To prioritize as a team, the estimators needed a means of seeing which projects were time-intensive or came with special requests or restrictions. This discovery contributed to a change in the naming structure which allowed the sales team to coordinate with the quote department to avoid sending jobs that had less certainty about if we had a chance to win the bid after estimations were made.

Future reiterations would include an email which would include jobs for the day if the calendar recognized if there were more than 5 jobs asking for 30+ products. I had to pay attention to how I created the language in this auto emailer to avoid salesman putting off this high priority message as they completed their daily responsibilities.

Too technical and my department may be working over night, If I lacked enough information other departments may not take this email as serious and assume we would still take care of the quote request.

(Because this warning feature was customer and project specific details I chose not to include any examples, this was a big help during holidays, and days we were short staffed!)

Final Thoughts
I enjoyed my time at Murray Supply very much and left with a deep adoration for the industry.

I learned how society functions at a depth that most people are not exposed to regularly. I came across many insights about urban development and operational design which I apply to personal and professional life today.

The impact I left is felt through the positive relationships and network I built through strong teamwork and effective communication.

Below are some excerpts from reviews I received from my managers throughout my time at Murray Supply:
Thank you for your time!
Let's Connect!
Don't forget to Download a copy of my resume →
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Download Resume