Archives: Project Cases

This is Custom Post Type for Project Cases shown in Portfolio

Greater Houston Partnership’s Transformation with Salesforce Marketing Cloud

Posted on July 30, 2024

Challenges

Despite being a longtime Salesforce customer, Greater Houston Partnership (GHP) faced significant challenges in fully leveraging the platform due to their reliance on Constant Contact, which wasn’t integrated with Salesforce. This lack of integration resulted in time-consuming manual exporting and importing of data between the two systems. Additionally, the old system lacked design flexibility and opportunities for customized branding in email templates. Overcoming these issues required ensuring a seamless integration between Salesforce Marketing Cloud and Sales Cloud, addressing the diverse communication needs of various audience segments, designing effective automated journeys for member onboarding and engagement, managing a large volume of personalized content, and providing adequate training and resources to the team.

Key Features

Targeted Communication
Personalized Newsletters
Social Media Advertising
Automated Journeys

Solution

Catalyst implemented Salesforce Marketing Cloud for GHP, integrating it seamlessly with their existing Sales Cloud environment to enhance their marketing and communication efforts. The solution included Email Studio for  personalized email communications, Web Studio for managing over ten types of targeted newsletters, Advertising Studio for creating targeted social media advertisements, and Journey Builder for automating member onboarding and prospect engagement journeys. This comprehensive implementation enabled GHP to send highly targeted communications, manage opt-ins effectively, expand their reach through social media, and automate personalized journeys, significantly improving their ability to engage with diverse audience segment and drive economic development in the Greater Houston area.

Benefits

The implementation of Salesforce Marketing Cloud brought significant benefits to GHP. It enhanced their ability to send highly targeted and personalized communications, fostering stronger engagement with current members, event sponsors, local businesses, and prospective members. The platform’s capabilities allowed GHP to manage over ten different types of newsletters effectively, ensuring content was aligned with recipients’ interests. Additionally, targeted social media advertising expanded their reach, attracting new businesses and members. The automation of member onboarding and prospect engagement journey streamlined communication processes, saving time and effort while maintaining consistency and relevance. Overall, the implementation significantly bolstered GHP’s marketing and communication strategies, promoting economic development and strengthening business connections within the Greater Houston area.

The Air, the Sea, and the Cloud

Posted on November 19, 2020

Seattle Skyline with Mt. Rainer

Overseeing Seattle’s seaport and Seattle-Tacoma International Airport (SEA-TAC), the Port of Seattle is a government agency that sits at the intersection of travel and commerce. Described as “one of the Pacific Northwest’s leading economic engines,” the Port of Seattle has historically received over 30,000 inquiries, concerns, suggestions, compliments, and complaints that have informed Port policies, capital improvement projects, community engagement endeavors, and recreational offerings like cruises.

The Port is on a mission to solidify its place as an international powerhouse in the realms of transit, commerce, and customer satisfaction, and it relies on correspondence from locals and visitors and travelers (hereafter, “constituents”) to do so.

However, staff’s ability to collect this outreach and act upon it accordingly had become increasingly limited by outdated and disparate technology.

Ready to tackle this challenge, enter the Catalyst team of Salesforce CRM and Marketing Specialists.

Setting the Stage: The Who’s, the Why’s, and the What’s

This project encompassed approximately 50 users within – and the business processes across – three domains within the Port of Seattle that manage operations for both the maritime and aviation factions: Commission Services (CS), Airport Customer Experience (ACE), and External Relations (ER).

  • CS supports the decision-making body of the Port, which is the five elected Port of Seattle Commissioners, in managing outreach, policy, and budgeting.
  • ER acts as the communication and public relations wing of the Port, overseeing newsletter distribution, email campaigns, and in-person and virtual events.
  • ACE works to improve the traveler experience for those flying to and from Seattle-Tacoma International Airport. In years’ past, there have been, on average, 50 million flyers annually.

Catalyst began our descent onto – and set sail with – the Port of Seattle in September 2019.

The legacy state of the Port’s technical ecosystem was deeply uncentralized, using seven legacy platforms concurrently. It was time-consuming for staff to tab between these different platforms throughout the day. These applications did not communicate with each other, compromising data integrity and undermining the ability to complete duplicate checks on information. Having these different systems also made it hard to standardize information for public-facing FAQs, as well as internal reference.

Salesforce was also a part of this array of platforms but had not been maintained or updated in a way that enabled the Port to take full advantage of the platform for several years.

The Port knew change was necessary.

The Catalyst team implemented a Salesforce solution that now acts as a centralized hub for the three domains to manage correspondence from constituents and fellow Port staff. Let’s now take a closer look at how CS, ACE, and ER are using Salesforce, particularly the Service Cloud, Einstein artificial intelligence, Marketing Cloud, and Social Studio products. For added convenience, our team integrated Salesforce with Microsoft Azure Active Directory, enabling staff to access Salesforce with their Microsoft Outlook credentials, eliminating the need to remember yet another unique log-in. We also integrated Tableau with Salesforce for more advanced reporting.

A Closer Look at Commission Services (CS)

CS is leveraging Salesforce Service Cloud to manage constituents’ e-mail correspondence with the five elected Port Commissioners. Salesforce has centralized constituent correspondence and contact information on the backend, enabling staff to provide more timely responses that can consider a constituent’s entire history of outreach to the Commissioners for added context.

Using one of the branded email templates coming out of Service Cloud, CS is equipped to handle a variety of categories of constituent outreach for each Commissioner. Similarly, they can also assign “tags” to certain cases of particularly high priority or those related to a timely concern.

For example, let’s say the Seattle area is impacted by wildfire, and 700 constituents submit concerns about safe travel, water quality, and trade implications as a result. In the legacy system, CS staff had to manually sift through Outlook and individually collect the 700+ constituents’ contact information to respond. Now, with Salesforce, CS can choose to label each of these concerns with a “wildfire” tag and then send an email en masse directly from the Service Cloud user interface with updates, restrictions, and safety tips to the constituents who submitted a case assigned a wildfire tag.

In turn, Salesforce has optimized CS staff time and productivity without compromising the quality of information concerned constituents can receive.

CS is also using Tableau for its reporting to identify patterns in the locations for which complaints are submitted. For example, Tableau can illuminate if there’s an uptick in complaints concentrated around Pier 66 and flag for staff if it’s a site of high concern and priority.

A Closer Look at Airport Customer Experience (ACE) at Seattle-Tacoma International Airport

First and foremost, the Catalyst team updated ACE’s instance of Service Cloud, running on the outdated Salesforce Classic interface, into the more intuitive Salesforce Lightning offering more robust functionality.

On the public-facing side, constituents can now contact ACE with questions, complaints, concerns, compliments, and comments about their experience at SEA-TAC through social media, live agent web chat, email, voicemail, text (SMS/MMS), and web form.

Regardless of the channel of intake, all correspondence routes to the Salesforce Service Cloud backend as a “case.” To minimize the need to tab between platforms, ACE service agents can respond to all correspondence directly within the Service Cloud user interface,

As is the case for CS, ACE benefits from the 360-degree view of the constituent Salesforce provides. The backend houses a constituent’s entire history of outreach on their contact record.

Since go-live, across all channels of case intake for ACE, there has been a 16.24% decrease in time for case resolution for SEA-TAC travelers compared to the same time period pre-go-live in 2019.

ACE and Artificial Intelligence

Let’s revisit that concept of tagging we first discussed with CS.

From “This security line is taking forever,” to, “Nobody at this gate is wearing a mask,” there’s several categories of outreach that travelers passing through SEA-TAC can submit to ACE that warrant follow-up.

ACE alone has historically received upwards of 12,000 cases a year, so it would be time-consuming to manually vet, triage, and assign each case a category upon entering Service Cloud. This is all the more true as this number of cases is expected to rise with the new channels of intake introduced through our implementation.

Assessing the volume of cases by category is an insightful report for leadership to identify areas causing concern. To be mindful of team time and capacity without compromising the importance of categorization, the Catalyst team implemented Einstein, Salesforce’s artificial intelligence product, to train the system to categorize by way of machine learning.

Let’s call out a few things on this contact record. We can see the constituent’s email in the “Correspondence” component, as well as Knowledge Articles that may help the customer service agent address this inquiry. We also can see Einstein case categorization at play in assigning this as a “TSA Precheck” case. Also note the entire case submission history of our contact Rosa is included for additional contact about who this constituent is and what matters to her.

We trained this system to assign the correct permutation of category and sub-category using 135,000+ legacy cases. In total, there is now a standardized set of 30 categories and 100+ sub-categories.

ACE and Case Deflection

We’ve discussed what happens when a case enters Service Cloud, but also important to note are the mechanisms in place to deflect case creation and offer self-service.

Our web designers built a mobile-responsive web form, hosted on SEA-TAC’s website, through which constituents can submit inquiries, complaints, and concerns. However, the intent of this web form is to deflect cases.

For example, let’s say a traveler at SEA-TAC is trying to learn more about rideshare guidelines to coordinate a ride after their flight. This web form first appears as a “Frequently Asked Questions” search bar. Upon typing in the phrase “ride pickup” in the search, the constituent will be presented with a drop-down list with relevant articles based on the keywords inputted.

The constituent has the option to upvote articles as helpful. If they select, “No, these articles weren’t helpful,” they are presented with the true web form to submit additional details. These details will be routed into Service Cloud as a case for follow-up.

Since launch, 88% of interactions with the web form did not result in case creation, which speaks to the efficacy of the Knowledge Articles presented prior to the actual web form.


The web form first appears as an FAQ search bar but will present additional fields to submit a case if the constituent can’t fine the information they need.

A screenshot of the automated messages sent by Mobile Studio – MobileConnect upon opting in. An example of a SMS message sent would be, “Construction in Concourse D begins October 22. Arrive early to navigate detours.”

ACE and Social

Social media is a tremendous tool for customer service, and ACE is tapping into the power of Salesforce Social Studio and Social Studio Automate to support its social media management needs.

We added 26 automation rules that run across the Port’s 6 social accounts for the Seaport and SEA-TAC. Now, incoming social mentions and tags are now automatically labeled with a “New” status to support an organized post cleaning and routing process on the Social Studio front end; this status indicates to ACE staff that the post has not been addressed for service yet. Post labels, like “question about COVID-19” or “complaint about restrooms,” are also assigned to inbound content based on keywords so staff can immediately know exactly what types of matters at hand need attention.

For broader social listening capabilities, we updated and re-configured social listening “Topic Profiles” to allow the Port to see discussions about Sea-Tac airport, as well as complaints and praises for topics such as Port of Seattle cruise lines, commercial fishing in Seattle, and the Port of Seattle brand as a whole.

Social media posts in which SEA-TAC is directly tagged, as well as those identified through social listening, can be sent to Service Cloud and created as a case for service agent attention.

ACE and Mobile

The airport regularly sends SEA Text Alerts notifying travelers of happenings within the airport. In the legacy system, the SMS messages used to be delivered within 1-2 hours of pressing send, but that’s not particularly helpful during time-sensitive travel.

With Salesforce Mobile Studio MobileConnect, these SMS alerts are now delivered in real-time, immediately upon being fired off from Marketing Cloud. That way, travelers are immediately in-the-know of what’s happening in SEA-TAC, from construction updates to airport concession discounts.

Here’s one of the nearly 40 branded email templates we built for the Port to share maritime and aviation news.

A Closer Look at External Relations

ER uses Marketing Cloud to manage opt-ins for, and the creation and distribution of, 31 categories of email newsletters. Similarly, our team migrated over 100,000 subscribers from legacy communications systems into Marketing Cloud.

Synchronization between Marketing Cloud and Service Cloud has been essential. By integrating Marketing Cloud and Service Cloud, our team selected data from Service Cloud into Marketing Cloud to be filtered and segmented for various marketing campaigns and Port communications.

Likewise, in terms of event management, the Port regularly hosts events at and around SEA-TAC and the seaport itself, and our team leveraged Marketing Cloud to support the Port in reconciling invitees, RSVPs, and attendees for Port-led events. Salesforce CloudPages, available in the Web Studio module in Marketing Cloud, are used to build landing pages where external users can RSVP to various Port events. Through Marketing Cloud’s Journey Builder automation tool, the Port can initiate an invitation email allowing users to RSVP to the event, sending them into a “journey” where they will receive reminders, follow-ups, event details, and post-event communications, all personalized to each individual contact based on their behavioral triggers. RSVP and attendance data are stored in both Service Cloud and Marketing Cloud.

Training and Moving Forward

At this time, well over 80 hours of training on Service Cloud and Marketing Cloud have been supplied to the Port of Seattle end users through real-time and recorded sessions. Our teams are currently undertaking Phase 2 of work for Service Cloud and Marketing Cloud.

Digital Transformation that ‘Steels’ the Show

Posted on September 17, 2020

construction crane from the base looking up

The American Institute of Steel Construction (AISC) confers certifications to American and international architectural and construction firms, validating that these agencies are authorized to use structural steel in their development of buildings, bridges, and other structures. Garnering these certifications boost firms’ credibility, enabling them to acquire new business.

Catalyst implemented a Salesforce case management and staff-facing portal to support the American Institute of Steel Construction (AISC) in keeping all data related to certifications – from firms’ initial application to audits validating they qualify for certification – centralized in one place. We also integrated the case management backend into the AISC’s website so data regarding certified firms is readily accessible to the public.

The Certification Process

The certification process begins as the interested firm submits an application and application fee to AISC. Upon receiving the application and payment, the AISC then sends an auditor to meet the applicant on-site at their office to go through a certification checklist. The auditor takes their findings back to AISC and makes a determination that will inform the “decision package” to be mailed to the applicant.

If deemed eligible, the firm will receive a certification, while those deemed ineligible will receive a breakdown of problem spots to rectify to improve their chances of certification in the future.

AISC holds the awesome responsibility of ensuring the firms it certifies construct with caution and integrity. For this reason, it typically takes between 5-6 months from the moment of submission to certification, and the firms are audited once a year for certificate renewal.

The Technology Behind the Certifications

Pain Points in the Legacy System

Catalyst began working with AISC as they planned to sunset their legacy software used to house data about certified firms. The software was outdated and did not encompass the full breadth of the certification process listed above. The legacy system only managed the status of application payments and audits; it did not create or maintain auditors’ schedules, nor did it receive the firms’ applications. As a result, AISC turned to Google Sheets, Google Forms, the Microsoft Office Suite, emails, and physical Post-It Notes to supplement the legacy system, minimizing the possibilities for internal collaboration and leaving data strewn about in disparate platforms.

New Workflows, as Facilitated by Salesforce

AISC Web form new

This web form for applicants sits on the AISC website and is fueled by Salesforce’s web-to-case functionality. All submissions will be routed into Service Cloud.

Throughout seven weeks, we worked with over 30 AISC team members, conducting interviews and facilitating discovery sessions to identify gaps in legacy processes and how Salesforce could close them. The Catalyst team implemented Salesforce Service Cloud and Community Cloud to replace the functionality of the legacy platforms, along with an on-brand and mobile responsive web form that sits on their website to accept firms’ applications and funnel them into Service Cloud. We also installed the Nintex Drawloop document generation tool so AISC could generate certifications and confirmation of payment receipts directly from Service Cloud.

The web form on AISC’s website is dynamic, enabling interested firms to apply for the Fabricator, Erector, or International certifications based on the interests they specify:

  • Erectors more broadly install, repair, and maintain steel buildings and structures.
  • Fabricators bend, cut, and mold steel to create beams and columns during builds.
  • International certifications verify the firms meet the standards needed to build with steel abroad.

This web form routes submissions into Service Cloud, creating a record on the Service Cloud backend for each interested firm.

Salesforce products do not currently manage the actual application fee process, but each applicant’s record on Service Cloud does list a unique payment number. AISC staff manually change the payment status to “Received” and use the Drawloop doc-gen tool to email the applicant a PDF’ed confirmation of receipt directly from Service Cloud.

AISC-application-record

After an application is submitted using the web form, it’s details populate in a Service Cloud record and inform AISC’s follow-up email to the interested firm.

AISC-audit-portal

The Auditor Portal is accessible exclusively to AISC’s auditors and enables them to check what appointments they have scheduled, submit their audit findings (to be synced into the pertinent Service Cloud record), and review past audit reports.

AISC staff also use Service Cloud to manage auditor appointments and schedule their on-site visits. When on-site, auditors use a private portal built on Community Cloud called the “Auditor Portal,” through which auditors can submit their findings.

All data inputted on this Portal syncs to the applicant’s record in Service Cloud, enabling AISC staff to make a final determination about the firm’s eligibility using one platform: Service Cloud. To further reinforce Service Cloud as the new, sole source of truth, Catalyst also migrated data for existing contacts, certified firms, and over 15,000 audit records from the legacy systems into the backend.

If deemed eligible, the firm will receive a certification in the mail generated from Drawloop and housed on their Service Cloud record, as well as information about completing yearly audits to maintain their certification. If deemed ineligible, they will be mailed information about repeating the audit and a breakdown of problem spots as recorded on the Auditor Portal.

AISC-account-history

The Auditor Portal is accessible exclusively to AISC’s auditors and enables them to check what appointments they have scheduled, submit their audit findings (to be synced into the pertinent Service Cloud record), and review past audit reports.

The Catalyst team also integrated Service Cloud with the AISC’s website for its Find A Certified Company feature, which allows the public to search for firms within a certain zip code who are certified as at least a Fabricator, Erector, or International Builder. If the firm is listed as an active, eligible certified firm on Service Cloud, it will appear as a search result on this map.

AISC-certification
AISC-certified-companies

All results pulled back from this search are active certified firms, per the Service Cloud backend.

What Comes Next

The Catalyst team has just commenced Phase 2 with the AISC. We are building a firm-facing Portal through which certified firms can log in, find information specific to their firm’s profile, such as what they are certified in and when each certificate needs renewal, and access exclusive resources the AISC publishes just for members.

Digital Media in Chicago’s #EmergencyResponse Plan

Posted on July 31, 2020

Since 2017, Catalyst has supported the City of Chicago in developing, launching, maintaining, and enhancing a non-emergency 311 solution powered by Salesforce.

This 311 solution – called CHI311 – encompasses a constituent relationship management (CRM) backend built on Salesforce Service Cloud, a public-facing web-based Community Portal built on Salesforce Community Cloud, the City’s first-ever public-facing custom mobile app, and Salesforce Marketing Cloud through which City communications personnel can send email campaigns and manage City social media accounts.

In response to the COVID-19 pandemic, Chicagoans looked to CHI311 for timely and reputable information about the virus, preventative health recommendations, City shelter-in-place updates, and most recently, re-opening guidelines.

In this period of uncertainty, CHI311 has equipped City staff and constituents with the tools to navigate the pandemic safely.

In sum, COVID-19 related service requests were added to the Community Portal and mobile app, along with up-to-date articles regarding public and preventative health and Chicago-specific safety guidelines. Marketing Cloud was then used to create and send City-branded emails about available housing grants and community letters from Mayor Lori Lightfoot, as well as to track constituent conversations about the City’s response to the pandemic via social listening.

Quickly Accessing COVID-19 Related Services and Information

As the pandemic first began to sweep the City, the City’s 311 call center experienced a 35% increase in constituent outreach directly related to Coronavirus inquiries.

Identifying patterns in these calls and requests, the Catalyst team stood up a “COVID-19 Assistance” category on the public-facing side of CHI311 in under two days. This new category of type codes was created to meet the constituent needs that were repeatedly asked for in the call center and in the expedited timeframe that emergencies mandate. Please refer to the screenshot to see the COVID-19 type codes added to CHI311 to date.

As time is of the essence in emergencies, we note the following turnaround times for various COVID-19 service requests:

              • The City has collaborated with organizations like the Salvation Army to respond to and close emergency food requests in 2.5 days.
              • General COVID-19 inquiries submitted through CHI311 are answered within 24 hours, with a staff member at the Chicago Department of Public Health reaching out to the constituent directly.
              • Senior well-being checks requested have been completed in one day.

7,000 COVID-19 requests were received by Chicago’s non-emergency 311 within the first three weeks of the City’s shelter-in-place.

These calls were deflected from 911, easing pressure on emergency responders and enabling them to focus on pressing matters during one of the most unprecedented public health events in modern history. Similarly, because constituent self-service has always been at the crux of CHI311, a COVID-19 emergency banner resides at the top of the CHI311 mobile app and Community Portal, ushering constituents to the City’s COVID-19 microsite where they can find the latest information from their City leaders.

Communication is Key: Marketing Cloud and the City of Chicago’s COVID-19 Response

Among the channels the City of Chicago used to communicate its COVID-19 response plan were email and social media, as facilitated by Salesforce Marketing Cloud and Catalyst’s Marketing Cloud Subject Matter Experts.

The Chicago Department of Housing
To ease financial strain provoked by the pandemic, the City’s Department of Housing (DOH) established a grant program through which Chicagoans could apply for assistance to pay for their housing.

Over 83,000 residents applied for these grants, and Marketing Cloud’s Email Studio module was leveraged to send applicants information about the grant program itself on City-branded email templates. Information moves fast in a pandemic, and the Catalyst team helped the City craft and send the emails at a moment’s notice. Applicants approved for the grant were also notified with an email sent from Marketing Cloud.

Personalization always matters in public sector communications. Constituents want to feel recognized by local government, and this is all the truer amid crisis. The City of Chicago flexed this personalization muscle with the DOH grant recipients. Personalization strings, driven by AMPScript (Marketing Cloud’s proprietary scripting language for advanced personalization in emails), were placed in email templates sent to grantees to allow for varying combinations of the following to appear in one email:

  • The recipient’s name
  • A survey link specific to that grantee
  • DOH contacts specific to their housing case

AMPScript made it possible to send one email that rendered over 250 variations based on the data being pulled from the Marketing Cloud contact list to fill in these unique data points. Rather than send hundreds of separate emails, DOH could send just one email without compromising the personalization the recipient needed and deserved.

From the Office of Mayor Lori Lightfoot

The Mayor’s Office also leveraged Email Studio to send newsletters from Mayor Lightfoot to subscribers, including:

  • An explanatory email in March when the pandemic first began to escalate discussing shelter-in-place guidelines
  • A voting-oriented email leading up to Election Day to recruit election judges
  • A community update to check-in with folks and bolster morale in Summer 2020 as the City slowly began to re-open

Within Salesforce’s Marketing Cloud suite of products is Social Studio, a social media management and social listening tool. The Catalyst team set up a series of social listening tools called Topic Profiles regarding COVID-19 to track constituent conversation, questions, and concerns around topics such as the virus itself, outdoor dining, and Chicago’s reopening plan.

Insights from these Topic Profiles were shared with Mayor Lightfoot to inform her communications plan, talking points shared in press briefings, and content published on the City’s website, social media and CHI311’s public-facing elements. The City also tapped into Social Studio’s scoring algorithm, called “Sentiment Analysis,” to determine the tone with which Chicagoans talked about COVID-19 related topics, paying particular attention to topics with overwhelmingly negative sentiment to inform where Mayor Lightfoot and the Communications Team needed to quell feelings of concern and fear.

Managing Unemployment and Crisis in the State of South Carolina

Posted on July 30, 2020

Millions of Americans are out of work amid the COVID-19 pandemic. In response to job losses throughout South Carolina, the State’s Department of Employment and Workforce (DEW) sought a case management solution to manage unemployment inquiries about claims and benefits asked via email.

The Problem

Previously, DEW managed inquiries strictly through a Microsoft Outlook inbox, to which twelve employees had access. As the COVID-19 pandemic intensified, this inbox received over 1,000 inquiries a day, and many unfortunately went unaddressed as the inbox could not support the volume of responses. In this legacy inbox, the only way for the employees to confirm if an inquiry was addressed was through the read receipt or if they contacted their team manually via Microsoft’s internal instant messaging chat.

As more South Carolinians were out of work, DEW knew change was necessary to support its constituents.

The Solution

In response, Catalyst launched a Salesforce case management solution to support DEW staff with centralizing constituent unemployment inquiries and claims. With Salesforce serving as the source of truth for email inquiries, DEW staff can now effectively respond to all constituent concerns in a timely fashion. Among these outreach categories are: Appeals Inquiry, Checking Claim Status, Collections, Employer Inquiry, Issue on Claim, Overpayment Issue, and Reporting of Fraud.

Success with Salesforce Service Cloud

The email-to-case management solution for DEW is built on Salesforce Service Cloud, and our team created a forwarding rule from this inbox that automatically routes correspondence into Salesforce and creates a case. To ensure the case indeed lands in a customer support agent’s hands, the Salesforce system is configured with a “round robin.” That is, it will automatically assign cases to agents, ensuring they are evenly distributed so no one resource is inundated with cases.

There are a series of checks the case undergoes upon its receipt in Service Cloud, as facilitated by case escalation and automated notifications to confirm it receives the most timely and satisfactory attention.

The case undergoes a manual QA “spot-check” by its assigned agent to ensure the newly-created record warrants a response and is not a spam message.

If the case passes the QA check and is marked as warranting follow-up from its assigned agent, the Salesforce solution will automatically send a “confirmation of receipt” email to the constituent so they can rest assured knowing their concerns are heard. (Left screenshot)

The agent assigns either a “high” or “urgent” priority level depending on the request or inquiry.

If assigned “urgent,” the case’s status must be set from “new” to “in progress” within one hour of being assigned this status. Otherwise, a series of notifications are sent to internal stakeholders to ensure these matters get taken care of immediately to prevent service level agreement (SLA) breach.

Finally, upon resolving the problem, the agent can send a resolution email to the constituent and leverage one of the DEW-branded email templates our team built for them. (Right screenshot.)

With Salesforce serving as the source-of-truth, the team at DEW can pull reports and dashboards more quickly than before. Using the legacy inbox, all data was pulled manually and housed in a series of Excel spreadsheets. Salesforce now allows for the intuitive creation of reports and dashboards on all data within the system, and DEW administrators can even schedule these metrics to send every morning to stakeholders’ inboxes for an assessment of personnel performance, the types of cases coming in, and how long it takes for staff to resolve them.

Getting Off the Ground Quickly

Supporting those who have been laid off is a critical part of any holistic emergency response. We’ve been able to expedite our project delivery for DEW by leveraging the architecture of the Salesforce emergency case management solution we built for accelerateSC, the COVID-19 response plan spearheaded by South Carolina Governor Henry McMaster, through which constituents can submit COVID-19 related inquiries and requests for emergency support.

In all, we deployed the Agency’s solution in two weeks and leveraged an additional two weeks for ongoing enhancements post go-live.

Impact and Results

Cases are currently being closed in under two business days, providing resolution to constituents’ unemployment inquiries more quickly than in the legacy system.

Illinois Tollway

Posted on June 21, 2019

The Problem

Established in 1953, the Illinois Tollway system is composed of four major toll roads that stretch across 286 miles of Illinois. On a daily basis the Tollway handles millions of transactions, totaling close to a billion or more annual transactions. They serve over four million customers bringing in over $1 billion in annual revenue. Currently, electronic toll revenue is the core of the business system comprising 85 percent of the Tollway’s revenue. This number will continue to grow exponentially as the Tollway continues to implement all-electronic roads and interchanges.

In the spring of 2014, the Illinois Tollway realized a replacement for its customer service and violation processing system was necessary for this continued, successful growth. The 2005 system no longer supported their goals of reducing operational costs, improving customer service cycle times, and embracing improved customer service policies such as shorter violation notice cycles and dynamic management of fines and settlements. To scale their business both vertically and horizontally, the Tollway received a “best of breed” enterprise back office solution developed by SAP and Accenture called the Accenture Tolling Solution (ATS). With their new solution ready, it was clear that to ensure proper implementation the Tollway needed a solution integrator with technical and business experience implementing and running enterprise-level business applications like the ATS. Without proper implementation, the Tollway’s ability to collect electronic tolls would be jeopardized, leaving their core business and operations at risk.

Our Solution

The Tollway awarded Jacobs Engineering Group (Jacobs) the System Integrator Services contract in conjunction with Catalyst. Together Catalyst and Jacobs provided the Tollway with technical and business experience implementing and running enterprise-level business applications like the ATS to provide oversight and to monitor the post go-live System processing, operational characteristics, user experience, and performance. At the onset of the project, Catalyst placed multiple senior-level consultants and management staff at the Tollway to first learn the ins and outs of its business and establish a strong foundation. Once the team was comfortable with the Tollway’s business operations, they applied their experience in risk management to ensure proper identification, mediation, mitigation, and escalation was applied to any and all issues that arose within the project. Project documentation and meetings implemented by Catalyst on a weekly basis ensured all teams were frequently updated on the status of all project work streams. Catalyst’s flexible customer engagement style established a strong foundation of trust and allowed for the team to easily collaborate with the Tollway to achieve critical project milestones.

During the design, build, and testing phases of the project, Catalyst utilized its most senior infrastructure and application technical resources to provide ample guidance. The team utilized its knowledge of PCI compliance to ensure all network setup and implementation was completed properly and to the highest industry standard. Specifically, Catalyst provided guidance and assessment on the configuration of the VmWare ESX Host and Citrix XenApp. On many occasions the team provided key research, feedback, and knowledge of past experience as it related to database, server virtualization, operational configurations, and maintenance considerations. Specifically, the team provided guidance and assessment on the configuration and implementation of SAP Netweaver, Oracle Golden Gate and 11g/12C, and ATS NetApp and Cisco UCS. Often times this feedback was crucial to the success and continuance of the project. 

In providing proper communication, resource utilization, transparency, and collaboration, Catalyst proved to the Tollway it is a trustworthy and long-term partner. Through this engagement, the Tollway and Accenture have both looked to utilize Catalyst in future endeavors. The ATS went live August 2016.

“Catalyst is a wonderful partner for any organization going through significant technological evolution. Their team represents a deep and diverse set of skills and experiences that ensures we always have someone to rely upon for guidance, even when the questions and challenges we have are esoteric and complex. We are grateful for the input and leadership of our Catalyst partners every step of the way”

– Shana Whitehead, Chief of Business of Systems at the Tollway

Chicago Department of Aviation FlyChicago

Posted on June 21, 2019

The Problem

In August of 2011, the Chicago Department of Aviation (CDA) sought support related to IT Application Development and Maintenance as well as IT Networking and Infrastructure. The previous consultant had left the project abruptly, requiring the CDA to issue a Task Order Request (TOR) to find a new company to assume support immediately. Many applications and tasks were included in the TOR, but the largest and most pertinent aspect of the TOR concerned Flychicago.com, the CDA’s public-facing website for O’Hare and Midway International Airports.

The City of Chicago is one of the few metropolitan cities in the United States that has not one, but two airports: O’Hare and Midway International Airports. Both airports are managed by the City of Chicago through the Chicago Department of Aviation (CDA). Together O’Hare and Midway generate more than $45 billion in annual economic activity and create 540,000 jobs for the region, making it an integral part of the City of Chicago. On a daily basis thousands of users access Flychicago seeking important information regarding Chicago’s airport system. With such high traffic, Flychicago is one of the main platforms used by the CDA to communicate with its customers regarding real-time flight delays, traffic alerts, parking rates and availability, recent news, and much more. As such, it was imperative Catalyst assume control and support of the website immediately.

Our Solution

Catalyst developers got to work and began acclimating to the CDA’s environment by learning its main business processes, acquainting themselves with CDA staff, assessing all existing applications, and familiarizing themselves with Sharepoint, the Content Management System (CMS) used to manage Flychicago. In just six weeks the team had assumed full control of Flychicago and began making improvements toward a refined user experience with newly developed applications as well as the development of an updated mobile site. In June of 2014, the CDA requested an overhaul of Flychicago’s content. Catalystcombed through each page within Flychicago and updated the content to include accurate, current information, search engine optimization (SEO) for increased public access, and a consistent voice across all pages.

In November of 2014, the Catalyst team updated the existing mobile site. New pages were added to aid the CDA’s communication with mobile passengers, a new design was implemented for improved user experience, and Google Analytics was set to track all mobile traffic. As a result of the new mobile site’s success, as well as a global increase in mobile use, the CDA contracted Catalyst in January of 2016 to develop a fully responsive, fully redesigned Flychicago. Prior to the redesign the CDA maintained two separate sites, desktop and mobile, making content management difficult and cumbersome. By implementing industry standards and developing a fully responsive website, Catalyst improved maintenance efficiency and overall end user experience. Additionally, the team developed new in-airport maps for both airports integrated with Google Maps utilizing Blue Dot technology. The new maps improve passenger wayfinding within the airports and allow the CDA to promote its many concessions directly to passengers, increasing overall revenue. The new site launched in March of 2017. 

Impact & Results

The 2014 content overhaul increased inbound traffic on the desktop version of Flychicago by 50% or 15,000 hits in one year.

The 2014 redevelopment and redesign of Flychicago’s mobile site increased mobile traffic by 633% or 306,144 hits in one year.

On average, Flychicago receives 10,000 visitors a day.

Chicago Department of Aviation PCI

Posted on April 18, 2019

The Problem

In 2015, the Chicago Department of Aviation (CDA), the entity responsible for the management of Chicago’s Airport System, sought to automate the payment process for Midway International Airport’s Daily Parking Lot. By 2014 the CDA had already automated the payment processes for the parking garages and lots within O’Hare International Airport and was ready to follow suit with Midway. By implementing automatic payment systems for all of the parking garages and lots within Chicago’s Airport System, the CDA would lower overall labor costs, modernize the airports, and ensure ease of travel for its passengers.

Since 2006, the Payment Card Industry Security Standards Council (PCI SSC) has set requirements and security standards for organizations that handle credit card payments from major card schemes. These standards, known as the Payment Card Industry Data Security Standard (PCI DSS), must be met by every organization that accepts, transmits or stores any cardholder data, regardless of size or number of transactions. Furthermore, annual audits are performed on an organization’s payment systems to ensure they are continually adhering to the PCI DSS. In November of 2015, the environment that Midway’s automated payment system was being built on was found to be non-compliant, and the project was put on hold. To help get the system’s environment PCI compliant so the project could continue, the CDA reached out to Catalyst for assistance.

Our Solution

Catalyst’s infrastructure lead performed an assessment on the environment and located all of the areas that were not in line with the PCI DSS. Through the assessment, Catalyst found that the third-party vendor implementing the system had installed the payment application, authentication services, logging services, and antivirus software onto one system. For the environment to be PCI compliant, these applications and services systems must be separate from one another. To fix the issue, Catalyst worked with the vendor to virtualize the environment and implemented multiple virtual machines (VMs) to ensure each function resided on a separate server.

With the VMs in place, Catalyst worked with the City of Chicago Department of Innovation and Technology (DoIT) to perform vulnerability scans on each of the systems and found many security issues preventing PCI compliance. To help the vendor patch the system, Catalyst provided a detailed report on each issue along with recommendations on how to fix them in order to get the system PCI compliant. The Catalyst team worked alongside the vendor to implement the recommendations and in March of 2016 the automated payment system for Midway’s parking garages and lots was PCI compliant. As a result of Catalyst’s success with Midway’s system, the CDA requested the team run an assessment on O’Hare’s environment prior to the 2016 PCI audit. Through the assessment, Catalyst discovered many issues within the environment: the system was missing a centrally-managed anti-virus system as well as a separate logging and file integration system. Furthermore, the virtual private network (VPN) being utilized by the vendor to access the environment was not using multi-factor authentication. All three of these factors were in direct violation of the PCI DSS and caused O’Hare’s environment to be non-compliant.

To ensure the CDA passed the audit in December, the team implemented new servers for the two systems. A combination of radius server and duo security was set up to ensure multi-factor VPN authentication to the CDA’s PCI environment. Once the environment was ready, the Catalyst team drafted documentation and procedures to ensure the vendor was able to maintain compliance. As a result of Catalyst’s efforts, to date O’Hare’s PCI environment is fully compliant and passed the PCI audit. The team continues to work with the CDA and its vendors to ensure both environments maintain their PCI compliance.

Impact & Results

In 2016, O’Hare’s parking garages and lots combined completed 3.7 million transactions for an average of 308,000 per month.

On average, Chicago’s Airport System experiences approximately 10 million passengers per month.

Chicago Department of Finance IVR/OFPC

Posted on April 18, 2019

The Problem

In 2012, the City of Chicago Department of Finance Utility Billing and Customer Service (DoF), in conjunction with the Department of Innovation and Technology (DoIT) issued a TOR for a re-write of their Online Full Payment Certificate Application. The City of Chicago requires a Full Payment Certificate (FPC) for all real estate transactions. An FPC confirms that the seller of a property has paid their utility bill in full, and its issuance formally moves the seller out of the property utility account and moves the buyer in.

 

The DoF and DoIT sought to modernize their existing, outdated platform while also making utility data available to title companies and city processors through a web-based platform with incorporated analytics. The outdated application components did not account for future compatibility with multiple browsers, mobile devices, and tablets, and it was not developed using the basic core JEE services compatible with future Java Runtime Environment (JRE) versions. The legacy environment had major flaws and an obsolete technology stack.

Our Solution

Catalyst engineers got to work learning the ins and outs of the real estate transaction and utility billing process, partnering with team leaders to develop an application that not only fit the DoF’s needs, but had the scalability to ensure longevity. The team used Java best practices and application development standards to ensure that the application could be successfully deployed to the City’s WebLogic JEE environment and seamlessly integrate with other City systems.

In addition to developing a responsive bootstrap-based application, Catalyst developed three web services in order to interface with the City’s Banner database and eCheckout application. These integrations facilitated a smooth completion of each FPC application. The completed application utilizes approval paths between title companies, DoF processors, and Water Department

Field Reviewers, and includes the ability to attach supporting documentation to each application, which sped up the application process and removed manual process triggers between the departments. The completed OFPC application was the first application to reside in the City of Chicago’s new Exadata environment, an environment set up to streamline the use of big data in order to better serve the City’s constituents.

Impact & Results

The OFPC application increased the amount of applications completed online from 15% to 87%. The average number of days to process an application reduced from approximately 10  to .93

Approximately 550 field reviews are completed each month through a previously nonexistent field review portal