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.

Data Integration, Data Warehouse and Business Intelligence Analytics Solution for a Leading Financial Company

  • The client is a worldwide financial group with offices in more than 11 countries including 26 domestic offices in USA and $ 15B in average assets. The client had challenges in reconciliation of data from more than 25 source systems to their General Ledger. Working with the client's team, Expedien designed and implemented a data integration & analytics solution that resulted in increased productivity and better ROI.

  • Key Challenges

    The client has nearly 25 source systems. Integrating data from all these heterogeneous sources poses the primary challenge, followed by reconciling the integrated data with the bank’s ledger data. Other challenges include back tracing the information value chain to identify and rectify anomalies in the reconciliation output and implementing the complex business logic during transformation without impacting performance.

    Implementation Highlights

    • Data from nearly 25 source systems is integrated and transformed as per business logic and fed into downstream applications which process the data and provide business users access to performance reports.
    • At every stage before feeding the downstream application, data quality and data reconciliation is done with the ledger data. Any data quality issue is tracked properly through a mechanism that will allow the team to track and correct the cause.
    • Through proper data quality checks implemented for the project, some of the data mapping issues that were unnoticed before were identified, which helped other business users who were not part of this implementation.
    • Meeting the deadlines without any compromise in quality of the deliverables.

    Benefits

    • Increased revenue. Finely detailed Department, Product and Customer level performance reporting now allows the business to concentrate on the critical segments by providing appropriate incentives to its personnel as appreciation, as well as to take corrective actions if needed.
    • Increased productivity thanks to a very accurate Fund Transfer pricing calculation that utilizes a direct feed from Bloomberg rates at the lowest level of product information, which helps measure performance against objectives at an earlier stage.
    • Return on investment since the new data marts can be utilized for Allocation and Activity based costing with very minimal enhancement.
    • Streamlined implementation that replaces the multiple manual processes of generating spredasheets based on rate calculations for very limited accounts.

    Expedien Differentiation

    Expedien has deep expertise with the financial vertical and with implementing scalable Enterprise Business Intelligence solutions. Expedien guided the client in improving its data usage by implementing mechanisms to record, track and correct the data quality issues. The Expedien team, with its data analysis and data modeling skills,ensured that the project was on track with quick response time for any gap in source system analysis or any logical or physical modeling issues.

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.