The Strategic Design to Bring Multiple Legacy Data Sources to One Place
Susan G. Komen is the world's largest nonprofit source of funding for the fight against breast cancer and the only organization that addresses breast cancer on multiple fronts such as research, community health, global outreach and public policy initiatives. The organization has invested more than $2.9 billion in groundbreaking research, community health outreach, advocacy and programs in more than 60 countries. Its efforts helped reduce deaths from breast cancer by 40 percent between 1989-2016.
A review of its IT infrastructure identified that Susan G. Komen needed to streamline processes, increase efficiency and reduce cost. Additionally, an unknown number of data silos existed and the organization was not taking advantage of the opportunity to leverage a common operational approach and a common data model.
BTH began with a Discovery Phase using a team that included a Project Manager, Business Analyst, Database Architects, and Solution Architects. The first step was to interview product and platform owners to identify all unique applications deployed. This led to identifying 45 different applications within scope and helped identify data elements unique to each product as well as data elements common across multiple products.
All facets of existing data systems were explored and all data silos identified. From the information collected, BTH developed a comprehensive Data Model/Entity Relationship Diagram (ERD) of a "to-be" system state and high-level Business Requirements. The team proposed specific structures for unique data elements and a common and unified constituent journey aligned with the Komen operational model.
In a second phase, BTH implemented the findings in a Salesforce-based solution and started a unification project to retire the legacy CRM system — implementation plan to migrate from legacy CRM to existing Salesforce instance, installing NPSP, updating campaign hierarchy, preparing for gradual feature migration which Komen implemented over time.
For the first time ever, Komen had a unified data model and a single view of all data records. This gave them a very clear "To-Be" model, allowing Komen to eventually migrate away from legacy systems and toward a unified constituent experience.
BTH builds data strategies that give you a complete view of every supporter.
Start a Conversation →