BI Architectural Assessment

Founded in the late 1950s with a mission to improve the financial well-being of America’s professional military families, the company today serves clients from all walks of life at all stages of life. As a Registered Investment Adviser firm, the company develops and delivers comprehensive financial plans to assist American families in their efforts to reduce debt, build wealth and pursue their financial goals and dreams.

Impact

RCG provided the company with actionable recommendations and an action plan to achieve:

  • Future Enterprise Architecture Framework
  • Future Framework for Master Data Hub
  • Future Managed Data Environment Framework
  • Future BI/Enterprise Data Warehouse Architecture

Desired Outcome

The company is undertaking new business initiatives to expand its base of Advisors, provide customers a wider array of products, and adapt its business model to a changing financial market. These initiatives will require a greater use and emphasis on customer data for targeted marketing, customer up- and cross-selling, analysis of product and customer profitability, and customer service. These initiatives also require strong support to the company’s Financial Advisors, who require access to customer data, product offerings, and an easy-to-use system for sales and support. 

As a consequence, the company’s executive management has included Customer Relationship Management (CRM) and BrokerDealer  Software as two of the company’s top five objectives. Each of these two initiatives is cross-functional and requires data from many of the company’s application systems. Addressing the technical approaches for supporting these initiatives have fallen to the Enterprise  Architecture group in IT. Enterprise solutions are challenging because they must meet the needs of several departments, gather and integrate data from several disparate application systems, and deliver data that has the highest level of integrity, correctness, and consistency. This is especially true for Customer data, the handling and use of which is technically known as a subset of Master Data Management.

The Enterprise Architecture group engaged RCG to provide an assessment of their architectural direction in support of Customer data and Master Data Management. To fully support the company’s business strategy in the quickest and most cost-effective manner, the Enterprise Architecture approach must be cohesive, align business needs, technical methods, and organizational policies, practices, and procedures, and deliver into an enterprise-wide capability rather than one that is application focused.

Our Solution

RCG met with the company’s CIO during a BI industry conference and discussed the BI Architectural Assessment An RCG Global Services Case Study challenges associated with the current CRM initiative. RCG presented innovative approaches to the CRM challenges and the CIO engaged RCG to perform an assessment of the company’s architect architectural direction in support of  Customer data and Master Data Management. RCG provided an assessment of the company’s architectural direction in support of Customer data and Master Data Management with actionable recommendations. To fully support the company’s business strategy in the quickest and most cost-effective manner, the Enterprise Architecture approach must be cohesive, align business needs, technical methods, and organizational policies, practices, and procedures, and deliver into an enterprise-wide capability rather than one that is application focused.

RCG was able to develop a high-level assessment and action plan after just two days of fact-gathering workshops.

Technology

RCG reviewed enterprise architecture presentations to provide background on the project and form a starting point for the on-site discussions. Two (2) workshop sessions (14 hours) were conducted with eight participants from the company and two (2) RCG BI practitioners. The technologies in place at the client at the time of the assessment were:

  • Microsoft SQL Server
  • IBM AS/400
  • Oracle DBMS
  • Informatica Power Center

Subscribe to get the Latest Updates

Enter your email address below to get the latest news and updates from RCG.