Navigate Up
Case Studies

Case studies typically examine the interplay of all variables in order to provide as complete an understanding of an event or situation as possible. This type of comprehensive understanding is arrived at through a process known as thick description, which involves an in-depth description of the entity being evaluated, the circumstances under which it is used, the characteristics of the people involved in it, and the nature of the community in which it is located.

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
  • Leading Global Designer & Retailer Utilizes Business Intelligence to Increase Market Share
    • +Client

      Leading Global Designer & Retailer

    • +Overview

      This client is a leading global designer, marketer and wholesaler of over 35 brands with product expertise in apparel, footwear, jeans wear, jewelry and handbags.  With a reputation for innovation, excellence in product quality and value, and operational execution, this client markets directly to consumers through branded specialty retail and outlet stores, through concessions at upscale department stores and through its e-commerce sites. 

    • +Business need

      Client utilizes seven Business Intelligence platforms in order to report critical data throughout the organization.  Each system reports on different elements of the operational business including logistics and sales; none of which were fully deployed across the organization.  Due to the disparate data sources, resulting reporting was inaccurate and inconsistent.  In addition, the inaccurate data dictionary yielded multiple formulas for the same measure. 

      The labor costs to support seven (7) platforms requiring distinct skill sets was significant and the licensing fees for each application, platform, and data source were costly.

    • +Solution

      In order to realize several strategic initiatives to enhance profitability GalaxE recommended a Platform Consolidation solution.  To ensure the final end state system met the business needs to the client, GalaxE applied it’s IV&V  process and  methodology to:
      • Quickly identify functional and non-functional requirements
      • Inventory all reports and recipients by platform
      • Establish data governance and a process to maintain a consistent data dictionary
      • Establish the costs associated with maintaining each platform
      • Publish a targeted end state that satisfied all requirements
      • Create a road map and execution plan to reduce and consolidate platforms thereby reducing the costs associated with supplying the reporting to the business.

    • +Business Benefits-ROI

      The implemented solution consolidated all seven systems down to two over a period of 18 months.  The consolidated data mart provided more accurate reports which effected inventory, sales and logistics and provided significant savings over time. 
      • Maintenance and support costs were lowered by 50%
      • 70% lower licensing costs
      • Decreased turnaround by 10% time for new report development due to the consolidation and updated data dictionary

  • Increase Customer Satisfaction for Global Premium Accessories Manufacturer
    • +Client

      Premier Global Designer and Manufacturer of Luxury Accessories

    • +Overview

      This client is a global leader in premium handbags and accessories with product offerings including fine accessories for women and men. Their distribution strategy is multi-channel and includes over 500 stores in North America, over 400 directly-operated locations in Asia, and 20 in Europe. In addition, they operate e-commerce websites in the United States, Canada, Japan, and China with informational websites in over 20 other countries. Beyond the company’s direct retail businesses, this client has built a strong presence globally through boutiques located within select department stores and specialty retailer locations in North America, and through distributor-operated shops in Asia, Latin America, the Middle East, Australia, and Europe.    Their success is predicated on maintaining the highest standards for materials and workmanship worldwide.

    • +Business need

      Client uses a stand-alone Product Change Request (PCR) system to process client requests.  The existing system and corresponding process is time consuming, error prone and costly to execute.  In addition, the system has major business functionality gaps:
      • Ability to plan production cycles for specialty sales programs
      • Workflow was inefficient leading to process delays and mistakes
      • Lacked access and functionality across multiple user groups slow and costly “workarounds”
      The existing PCR system is not only complex but difficult to modify and enhance which is leading to costly support and maintenance over time.   Compounding issues, the client maintained very limited documentation or existing user knowledge of the current application which made migration of the application to an updated system very challenging.

    • +Solution

      In order to document existing usage and desired needs, GalaxE applied its IV&V and Application Migration methodology to migrate the PCR application to a new .NET platform.  This process accomplished the following objectives:
      • Quickly identified functional and non-functional requirements through tools and automation
      • Established targeted “End” state
      • Established road map and execution plan for the migration
      • Execute migration factory model to move application from old to new platform

    • +Business Benefits-ROI

      The client was able to realize several business benefits through the new PCR system:
      • Reduced manual efforts to create and review  product change requests by 50%
      • Increased approval turnaround times by a factor of 100 by implementing a “Multiple PCR Editing” editing feature
      • Decreased processing time by 20% by enhancing search capabilities
      • Enabled parallel processes which enabled P& L , Sourcing & BU to view the status of a PCR
      • Improved approval times by 55% by implementing an Email alert system
      • The new application enabled a collaborative workflow between different groups
      • Increased overall sales by allowing the client to plan production for Not-for-sale (NFS) product or Gift-with-purchase (GWP) product

  • Process Improvements for America's Leading Healthcare Provider
    • +Client

      America's Leading Healthcare Proivider with 5+ Million Members

    • +Overview

      One of America’s Leading Healthcare Provider serves more than 4.4 million members, and a network including 158 hospitals and nearly 30,000 doctors.    They administer Medicare plans for more than 270,000 customers and process more than 84 million claims annually.  With over 7,000 employees they design, sell and manage health plan benefits for individuals, families and businesses.

    • +Business need

      In order to cut operating costs and remain competitive, this client seeks solutions to improve processes providing overall better services to their customers and cut operating costs over time.  GalaxE identified four potential areas where processes and systems could be improved:
      • Member Management: This Service performs maintenance to Member.  It receives requests from the Consumer through several service operations like Create, update, reinstate and terminate member to satisfy the business functionality.
      • Membership Info Management: This service returns membership eligibility information. The Service orchestrates calls to a number of subordinate services, has a single operation and shall be directly exposed to a consumer Application and is critical for the end user experience and access to the member portal.
      • Claims: The Claims Composite Service provides summary claims from several different sources including LOCAL, NASCO, BCN, IKA, Vision LDS, Dental ODS and Medco. Additionally, the service also provides EIDs and Provider information for all Claims.
      • Process failover Management:  This functionality is needed to address the issues related to the downtime of the source systems for various reasons. This Service is built to achieve maximum reusability from the business process functionality perspective

    • +Solution

      GalaxE recommended and implemented several improvements including the following:
      • Built a highly reliable Composite Service enabling members and prospective members to access eligibility and claims data by leveraging the offline/local data store with key data elements to retrieve data from when the source systems are down.
      • Implement parallel processes for various source systems with complex process flows and fail over architecture to ensure high reliability and acceptable response times.
      • Incorporated smart architecture to enable bypassing certain source system and retrieve the data from the ODS/LDS to meet the SLA.
      • Implemented integrated testing suites with each version to help distinguish issues with the data vs source systems vs the service.

    • +Business Benefits-ROI

      GalaxE was able to identify and document a plan that would ultimately save the business over $20M annually.

  • Global Non-Profit Uses Advanced Reporting Solution
    • +Client

      One of the Top 3 Largest Private Foundations in the United States

    • +Overview

      Established in 1936, this client is an independent, global organization with a legacy of commitment to innovative leaders on the frontlines of social change. They have the second largest private foundation in the United States, with an endowment of over $10 billion.

    • +Business need

      This Global Non-Profit Organization needs a solution to increase reporting features which include the review of financial data and compliance validation.  Each year the finance department is required to review yearly grants and disbursements to ensure compliance.  They were not used to reporting tools such as SSRS, but very familiar with Excel.

    • +Solution

      GalaxE implemented a solution including MOLAP – SSAS which loaded 70 years of historical financial data summarized in a cube.  The new solutions includes the following features:
      • Ability export from cube to Excel for easy sharing across the organization
      • Ability to drill down into information as required, for validation
      • Derived directly from the data warehouse

    • +Business Benefits-ROI

      • More accurate information, coming from one source (EDW)
      • Improved communication and information sharing across the entire organization
      • Ability to quickly review 70 years of summarized financial information
      • Efficiencies achieved have improved the monthly and yearly close process, eliminating a week of work during the financial close process

  • Large PBM Client Seeks Production Support Improvements
    • +Client

      Fortune 50 PBM Company with an Annual Revenue of $93+ Billion

    • +Overview

      This Client Fortune 100 company is the largest pharmacy benefit management organization in the United States, with 2012 revenues of 93.8 billion.  They manage prescription benefits for tens of millions of Americans on behalf of thousands of clients, including health plans and plan sponsors. Employers, unions and government organizations throughout the nation rely on their services. With a team of more than 30,000 employees they are committed to their members achieving better clinical outcomes and dedicated to delivering better financial outcomes for plan sponsors.

    • +Business need

      With over 30,000 employees nationwide, this client is currently looking for a solution to improve production support for their system.  They are currently struggling with three major issues:
      Problem 1 :  Appeals database does not adequately accommodate various
      regulatory mandates to be addressed in a stipulated timeframe.
      Problem 2 : Manual entry of data by administrative staff, using information from
      hard-copy print outs of case reports from CDP
      Problem 3: Client wanted to move the Database from SQL Server 2000 to 2005.

    • +Solution

      GalaxE proposed the following solutions for this client engagement:
      Solution 1: Developed a flexible, table-based method satisfying the various required time constraints allowing the process to become fully compliant.
      Solution 2: Implementing solution with eliminated manual data entry of reports by providing a Data Transfer utility.
      Solution 3: Upgraded client by migrating applications and the DTS jobs to SQL 2005 and SSIS packages

    • +Business Benefits-ROI

      The combination of the overall solution provided improved production support process which saves this client both time and money.  In addition, our solution allowed the client to meet certain regulatory mandates.  This flexible solution allows for future upgrades and minimized the opportunity for error by implementing an automated solution which eliminated the need for manual entry.

  • Pega Engagement for Fortune 50 PBM Client
    • +Client

      Fortune 50 PBM Company with an Annual Revenue of $93+ Billion

    • +Overview

      This Client Fortune 100 company is the 24th-largest in the United States and is the largest pharmacy benefit management organization in the United States, with 2012 revenues of 93.8 billion.  They manage prescription benefits for tens of millions of Americans on behalf of thousands of clients, including health plans and plan sponsors. Employers, unions and government organizations throughout the nation rely on their services. With a team of more than 30,000 employees they are committed to their members achieving better clinical outcomes and dedicated to delivering better financial outcomes for plan sponsors

    • +Business need

      As one of the country's largest pharmacy benefit managers (PBMs), this client provides plan sponsors and participants access to a network of approximately 65,000 pharmacies including more than 7,200 stores.   Moving forward, this client is seeking solutions which will improve internal processes and improve the customer experience.  They have identified several ways to accomplish this goal including:
      • Improve Data Maintenance:  Improve functionality of add, update and modifying features and reduce redundancy mitigating data entry errors and increase the quality of data.
      • Data Consolidation: Consolidate repository across the enterprise reducing redundancy, mitigating data entry errors and increase the quality of data.
      • Retention Rates:  Improve user experience and retention rate of prescriber calls.
      • Improve Search Function:  Improve system so users across enterprise can search to get current, reliable, accurate, relevant and efficient data
      • Data Capture:  Capture prescriber preferences like bundle preferences, channel preferences, hours of operation, Specialty, Contact details in order to make each experience more customer and personal.

    • +Solution

      In order to efficiently implement the required solutions, GalaxE performed the following services:
      • Documented key gaps between specialty requirements and existing platform functionality including areas where no changes are required, areas where small changes or proposed compromises are possible and areas where significant enhancements are required.
      • Overall business systems strategy and roadmap was created to consolidate platforms to meet future growth and budget constraints.
      • Documented the recommended technologically solutions/ changes required to accommodate Specialty and Mail needs within the same solution.

    • +Business Benefits-ROI

      GalaxE was able to identify and document a plan that would ultimately save the business over $20M annually
      Long term benefits:
      • Improved user experience and retention rate of prescriber calls resulting in a reduction in annual IT costs and increased market share
      • Improved quality of service resulting overall higher client satisfaction

  • Fortune 50 PBM Client Undertakes SharePoint Migration & Upgrade
    • +Client

      Fortune 50 PBM Company with an Annual Revenue of $93+ Billion

    • +Overview

      This Client Fortune 100 company is the largest pharmacy benefit management organization in the United States, with 2012 revenues of 93.8 billion.  They manage prescription benefits for tens of millions of Americans on behalf of thousands of clients, including health plans and plan sponsors. Employers, unions and government organizations throughout the nation rely on their services. With a team of more than 30,000 employees they are committed to their members achieving better clinical outcomes and dedicated to delivering better financial outcomes for plan sponsors.

    • +Business need

      Currently this client is using SharePoint MOSS 2007 for collaboration across various departments; however, they have a mandate to migrate their SharePoint portals to SharePoint 2010.  Migration needs to support the following two scenarios based on the needs of the Site owner.
      • Scenario1 : Content migration ‘AS IS’
      • Scenario2:  Selective content migration

      At present Microsoft supports Scenario 1 alone and in addition, Microsoft does not support scenario 2 -  migrating selected top level sites, child sites, list contents from MOSS 2007 to SharePoint 2010. 

    • +Solution

      Our client engagement team provided an innovative and entirely new solution to accomplish this client’s goal.  Because Microsoft did not support either Scenario 1 or 2, it was necessary to develop a tool which resulted in the successful migration of only the desired contents from SharePoint 2007 to SharePoint 2010.  The new tool, named GSMA (GalaxE SharePoint Migration Accelerator), supports the migration of selected contents at the level of site collection, site or list.  In addition, the team developed a data validation tool (GSMV) to validate the migrated contents.  

    • +Business Benefits-ROI

      • Increased performance
      • Reduced maintenance and infrastructure cost
      • Increased search relevant results
      • Site  Collection Cleanup
      • Retire  Site Collections / Sites as needed

  • PBM Corporation Utilizes Automation for Quality Assurance
    • +Client

      One of the top 5 PBM Corporations in the US with an Annual Renenue of $10+ Billion

    • +Overview

      Client is a $4 Billion healthcare information services company with over 1,200 full-time employees worldwide.  With more than 1 billion prescriptions filled or managed annually, they offer a broad range of pharmacy tools, technology and expertise in the healthcare industry, combining PBM software applications, Application Service Provider (ASP) processing services, and professional services designed for many of the largest organizations in the pharmaceutical supply chain. These organizations include:
      • Pharmacy Benefit Managers
      • Managed Care Organizations
      • Self-insured Employer Groups
      • Retail Pharmacy Chains
      • State and Federal Government Entities

    • +Business need

      The business exports millions of records monthly to their customers’ external systems containing important data related to Explanation Of Benefits (EOB), Transition Benefits (TB) and Pharmacy Drug Event (PDE) information.  A large number of manual QA checks of this data were being performed, which impacted the ability to scale with proper accuracy and quality control.
      Business Metrics
      • The manual QA process was requiring 5-10 person days per month with little impact on the data quality.
      • 150 plus faulty EOB transactions were being sent to customers per month impacting customer satisfaction. This is also occurring for TB and PDE transactions as well.
      • Each faulty EOB would result in an estimated 3 calls to the call center by the customer resulting in a combined 80+ hours of call center time per month assuming 150 faulty EOBs
      Business Impact
      • 5-10 person days per month essentially wasted because it did not ultimately address quality issues.
      • 75+ hours per month in call center cost to the organization.

    • +Solution

      The solution developed by GalaxE provides for automated QA process of all (millions) records based on EOB, TB and PDE data files. A comprehensive rules engine is in place to allow for configurable validation checks of the records in addition to automated alerts in the event of record failure, reducing the need for any manual QA effort previously in place. Allows for automated and comprehensive QA of all input files for a variety of record statuses and conditions. The QA process is able to catch 100% of all errors for resolution prior to being sent to the customer.  Flexible architecture allows for configuration of validation checks to easily handle future requirements. The platform is scalable to any number of EOB, TB or PDE transactions and the data checks can be customized as requirements change.

      Allows issues to be identified before the EOB reaches print, the client, or the member.
      The solution provides customizable reports and dashboards to make it easy for different parts of the organization to monitor quality issues as they may arise.

    • +Business Benefits-ROI

      • Reduction in internal cycle time for inputting and validating EOB files before being sent to print by 25%.
      • Reduction in effort required for manual internal QA, and more importantly manual correction of issues discovered downstream estimated to cost the business the equivalent of 3 FTEs per year, 1 data analysts and 2 CSRs
      • 100% reduction in EOB direct mail errors.
      • Aside from the cost savings and increased quality, it gave the business the confidence they were not creating a poor customer experience.