AFTA Drupal Development Case Study

AFTA Drupal Development Case Study

Drupal Development

About the Americans for the Arts

The Americans for the Arts (AFTA) is the nation's leading nonprofit organization for advancing the arts and arts education. Their mission is to build recognition and support for the extraordinary and dynamic value of the arts and to lead, serve, and advance the diverse networks of organizations and individuals who cultivate the arts in America.

Executive Summary

AFTA was leveraging NetForum as their Association Management System, and was looking for a technology partner to help them integrate their Drupal front-end website with NetForum. AFTA was looking to implement an Art Services Directory functionality on their Drupal website that allowed end users to quickly find all types of arts organizations throughout the United States, based on different search criteria, including geolocation. Pumex was also requested to implement several other enhancements to their Drupal platform, which included UI/UX changes, implementation of a Donations/payments functionality (using Salsa API) and integrating different datasets with their NetForum AMS.

Pumex worked with AFTA stakeholders to understand their specific requirements for their front-end website and was able to successfully implement the requested functionality on their Drupal website utilizing integrations with different services, including NetForum xWeb API, Google’s Geolocation API and Salsa’s Donation API.

large

AFTA was looking enhance their Drupal website experience by implementing an interactive search functionality within the Arts Services Directory, wherein users could search for organizations not just by the traditional search fields, but also by zooming in on a specific location on a map. AFTA had previously tried implementing this functionality with a different vendor without success. Once Pumex successfully completed this project, AFTA was looking to implement a new donations module by leveraging SalsaCRM’s donation module within the Drupal website, and then integrating the payment information with the NetForum AMS database.

large large
large

Considering that AFTA’s membership data resided in their AMS system, NetForum, Pumex had to build custom integrations within Drupal to push/pull data via the NetForum xWeb API. Pumex build an additional organization interface on the Drupal front-end through which organizations could subscribe to be displayed in the Arts Services Directory search results and assign roles for individuals who had access for the organizations directory listing. Pumex was also able to successfully implement Google’s Geolocation API to display the directory listings on a map interface, allowing for users to zoom in/out, display pins with the organizations information and contact the organization from within the map. Pumex also successfully implemented the SalsaCRM’s donation module with the Drupal website, also creating an admin module on the Drupal backend where AFTA staff could approve a donation prior to pushing the data into the NetForum database.

Current and Future Results

All UI/UX, Arts Services Directory and SalsaCRM donations integration projects were completed on time, in budget, and to client quality expectations.

Pumex is currently working with AFTA to determine enhancements and changes required on their Drupal website when AFTA upgrades their AMS system from NetForum to Nimble.

Future Plans

Pumex is continuing to work with AFTA from a CTO/CIO consultation perspective to help them take their technology to the next level. Pumex is also working with AFTA to cleanse and migrate all their data from NetForum AMS to Nimble CRM utilizing Pumex’s proprietary Unity Data Sync platform.

AFTA Cloud Migration & Network Refresh

AFTA Cloud Migration & Network Refresh

Cloud Migration & Network Refresh

About the Americans for the Arts

The Americans for the Arts (AFTA) is the nation's leading nonprofit organization for advancing the arts and arts education. Their mission is to build recognition and support for the extraordinary and dynamic value of the arts and to lead, serve, and advance the diverse networks of organizations and individuals who cultivate the arts in America.

Executive Summary

AFTA engaged Pumex to provide a cloud-based solution to support a large remote work environment due to the pandemic. Pumex also provided AFTA with a refresh of their organization’s network infrastructure in their DC and NYC offices.

AFTA was able to push additional efforts into their yearly roadmap due to Pumex completing these projects significantly under budget.

large

IAI was using legacy, custom software that ran critical internal business processes in a disconnected environment. Applications included their IWITS, IWATS, and WCP platforms. They relied on manual export/import processes, lived in silos, lacked functionality to properly record information, and were complex and costly to manage. It was determined that all applications would need to be re-built, due to inequities in code and database schema.

large large
large

Pumex implemented an agile SDLC with two-week sprints. This approach followed a System Design Document that detailed system architecture, DB design, application design, security and controls. We leveraged DevOps processes including CI/CD, test automation, and Git to manage code tracking and merge. Our solution contained a database schema redesign, consolidating four separate databases, rewriting the code base with industry best practices, redesigning the UI/UX for improved user efficiencies, implementing OWASP and Cybersecurity best practices, automating workflows, and migrating to a Gold Source Database.

Immediate Results

Uninterrupted work

Pumex implement this portal as a user-friendly dashboard that enables IAI to gain efficiencies and save costs by significantly reducing the time needed to support members.

Improved Features and Functionality

Pumex integrated and improved the applications, modernized the platform/environment through code reengineering and re-development, and implemented new code

In the Cloud

Pumex implemented a cloud-based solution in Microsoft Azure along with its IaaS and PaaS solutions.

Future Plans & Projected Results

Pumex recommended a phased roll out of the consolidated legacy systems to allow decommissioning over time while the systems continued to run in parallel through the development process. This will ensure an easier organizational onboarding and help to relieve training burdens by reducing productivity issues and employee downtime.

RAPS Website Development

Regulatory Affairs Professionals Society

Website Development

About the Regulatory Affairs Professionals Society

The Regulatory Affairs Professionals Society (RAPS) is the largest global organization for those involved in the regulation of healthcare and related products, which include medical devices, pharmaceuticals, biologics, and nutrition products. RAPS helped establish the regulatory profession and continues to actively support the professional and lead the profession as a neutral, non-lobbying nonprofit organization.

Executive Summary

Pumex was tasked with taking on a highly visible web development project for RAPS on the Kentico CMS platform. The project touched highly trafficked areas of their website, the Home Page, and their Regulatory News page. Due to previous vendor cost overruns and failure to meet project timelines, RAPS technology was under significant pressure to produce the desired results. Pumex was also able to help quickly mitigate a DDoS cyber-attack on their website which recently took place.

Pumex helped rescue RAPS from a previous vendor’s that was not delivering on quality or promises. Our work with RAPS highlights our attention to on-time product delivery within budget and minimizing risks through project management.

large

RAPS was facing challenges with the development and design of its public-facing website. Their previous web development provider was unable to deliver a quality website due to late product delivery, budget overruns, and delayed project management/communication of risk. This was particularly unsatisfactory since RAPS’ web presence acts as their primary form of communication with their members, dissemination of relevant and useful industry information, center for e-commerce, and portal to their LMS. RAPS was also faced with a sophisticated DDoS cyber-attack originating from a foreign entity. This attack involved multiple IP addresses, a friendly bot disguise, and complex countermeasures.

large large
large

Our experience in Agile Development and success in creating repeatable success processes with Project Management, Communication, Risk Management, and Delivery assisted us in delivering their enhanced website. We were also able to redesign the RAPS homepage and create an improved “Regulatory Focus” news page using the Kentico CMS. Both projects were delivered on time, within the allocated funding, and above quality expectations. When RAPS informed Pumex of the cyber-attack, our IT team was immediately available to start troubleshooting and worked to quickly mitigate the attack by the following morning with Imperva.

Current and Future Results

Updated website

Using rich media content, Pumex enhanced the RAPS website using their preferred .NET CMS, Kentico, with an MS-SQL backend.

Data driven enhancements

Pumex leveraged data driven metrics based on information gathered about how RAPS site users navigated the website to make informed decisions about site enhancements which further drove user engagement.

Secure website

Pumex was able to resolve the RAPS website’s DDoS cyber-attack in less than 24hrs, restoring full security to the website within that time.

Future Goals

Pumex is RAPS vendor of choice for all web development, cloud infrastructure management, and cybersecurity requirements. Pumex is proud to continue supporting the overly complex RAPS website with many custom web parts and their ongoing infrastructure support needs.