Experience

About Expedien

Expedien's Data Strategy Services Unlock the Business Value in Your Data

  • We focus exclusively on Business Intelligence(BI), Big Data(BD) Analytics and Enterprise Data Management (EDM) services.
  • Our Business Value(BV) methodologies BV-EDM™, BV-BI™ and BV-BD™ methodologies align your data strategy with your business goals.
  • Our approach is business centric, tool agnostic and business process oriented.

SAP Rapid Marts Solution for One of the Largest Manufacturing Companies in the World

  • The client is a global diversified technology and manufacturing leader of aerospace products and services; control technologies for buildings, homes and industry; automotive products; power generation systems; specialty chemicals; fibers; plastics and advanced materials. The client implemented a data warehouse solution using multiple SAP Rapid Marts. Poor performance, lack of scalability and integration, and lack of availability of updated data in their data warehouse were some of the client's key challenges. Expedien executed extensive performance tuning of all SAP Rapid Marts and developed a scalable global data warehouse platform that met the client's current and upcoming reporting needs.

  • Key Challenges

    • Major SAP RapidMart performance issues; long and slow running RapidMart ETL jobs with execution times of more than 28 hours. Data in various marts couldn’t be updated daily because of such a long execution time.
    • Same data from SAP was extracted multiple times leading to multiple hits on the SAP system, and hence poor OLTP performance.
    • Low scalability, compartmentalized solution and inability to do cross functional analysis.
    • Poor ROI; Solution not able to meet global reporting requirements.
    • SAP Quality Management & Engineering RapidMarts were not available.
    • Complex reporting out of SAP and no 360 degree view and slice/dice capability.

    Implementation Highlights

    • Implementation & Integration of various SAP RapidMarts.
    • Performance tuning of SAP extract jobs, execution time reduced to 20% (~5 hours) of earlier time.
    • Development of a long term, scalable Data Warehousing platform utilizing SAP RapidMarts.
    • Porting of SAP RapidMarts to new platform to meet current & future reporting needs.
    • Design and development of SAP Quality Management and Engineering RapidMarts.

    Benefits

    • Availability of up to date information to executives and management for better decision making.
    • Availability of updated daily information in Data Warehouse, Business Intelligence system in a timely manner.
    • Improved SAP performance as extracted programs hit the system only in a small window in night.
    • Quick reporting solution along with capability to drill down to granular level data.
    • Manual & long running SAP reports to automated Business Objects Webi and Crystal reports.

    Expedien Differentiation

    Proven methodology & framework to develop, deploy, integrate and consolidate SAP BusinessObjects RapidMarts along with expertise in SAP modules & manufacturing business process.

Our Assurance

Reduce costs, enable new business capabilities and drive continuous process improvements.

  • We believe that for us to succeed in meeting your goals, we must be a strategic business partner providing strategic advice and relying on analytical objectivity and deep domain expertise around a set of value-add consulting services.
  • As a trusted advisor, we bring significant impact to your businesses as a partner in transformational initiatives.
  • As expert implementers, we proactively deliver the benefits of innovation, bringing you the best talent for your needs regardless of where they or you are located.
The Expedien Difference

It's in our DNA. Placing our clients first is embedded in the Expedien culture. By investing in our people and resources, we bring new ideas and innovation to help you succeed in a changing business environment.