Case Studies

Our architects and consultants at MSA Group have mastered the are of problem solving. This has enabled MSA Group (MSA) to consistently deliver measurable business value to our clients since our inception in 2003. The following are some of the unique and robust value-added solution which we have delivered for our clients.

KEYBANK (Key) is a leading fortune 500 financial services company with locations around the US and other parts of the World. Their headquarters is located in Cleveland, OH. KeyBank provides various financial services including Retail Banking, Capital Markets and Industrial Financing.

Client Problem: Key has had a long-standing need for a robust metadata management system(MMS) that is able to present organized meta data at an enterprise level. The number of productionized tables at the time was already over 1.2 million. Each year, Key’s data environment grows by approximately 14%. Most of this growth is due to development teams not having an understanding of what already exists, resulting in significant redundancies. The Strategic Data Architecture Initiatives team at Key was chartered with developing this robust metadata environment and providing a solution for all employees at Key to access the information about the company’s data assets. Critical for this solution was friendly search capabilities to find what was already available in the environment and organize those searches in a logical way that can support the highest level executive to the most granular information that an application developer would need in his development work. The chartered project chose Cognos as the end-user reporting tool with an Oracle backend and Exeros and ab Initio were used in the data migration process. Cognos was used to implement the complex searching and view capabilities.

MSA's Solution: MSA Group architected a solution with robust search capabilities along with a complex user friendly dashboard with tabs and screens to encompass the full variety of metadata forms including business, technical, physical domain and more. Though the project had failed on four(4) different occassions prior to Key engaging MSA, it took MSA a single iterations after the initial design to implement the solution and help Key in rolling it out enterprise-wide. MSA was charged with ensuring the complete success of the project and this entailed working with and guiding Key's data architects, ETL developers, relational and dimensional modeling of the metadata, creating robust Cognos reports and overseeing metadata consolidation for the purposes of this project.

Client's Benefits: MSA provides robust solutions which stand a test of time and Key's MMS is no exception. Here are some of the immediate benefits realized:
 Development cost savings of over 30% and sustained reliability of the solution delivered.
 Reliable processes and resources cutting the expected project duration by 25%.
 Reduction of the time for metadata search and analysis from days to minutes.
 High user adoption of the Metadata Management System due to its ease of use
 Key can leverage our global delivery model for their corporate performance management (CPM) needs.

Our other case studies which might interest you include:
 Advanced Claims Analysis and Management Portal for Travelers (formely St Paul Travellers).
 Healthcare Workforce Automation System (WFA) for CIGNA.
 Advanced Informatics dashboard for the Commercialized Informatics Division of Matria Healthcare
 Robust stepwise metadata modeling solution with SAP and Oracle for BASF.
 Advanced retail logistics and supply chain dashboard for GAP Inc.

For a pdf version of the complete compilation of our case studies, send an email to info@msait.com