SELF SERVICE BI
ORGANIZATIONA multinational financial services conglomerates operating in 56 countries specializing in commercial lending and leasing. The company manages millions of dollars every day serving thousands of business units, guaranteeing business unit commitments to their customers, collecting money from Business Units, and paying banks internationally for letters of credit.
CHALLENGEGlobal Business Units had little visibility into the costs associated with the Letters of Credit (LOC) for their projects. The visibility of LOCs across multiple Business Units was nonexistent. This lack of visibility across the organization resulted in localized deals for LOCs that were not in the best interest of the overall company. Similarly, the Business Units could not take advantage of financial institutions around the world to get the best deal terms for the LOC. A reporting solution for an Automated Letter of Credit web application that facilitates the request, review, bid and issuance of Bank Guarantees and Letter of Credits by third party banks was required to service these requests by different Business Units. This reporting solution required complex filtering criteria and the ability to export report data to Excel and zip files depending on user roles. Reports were also required to be available through the BI Dashboard and other delivery channels without compromising the consistency of the information. Additionally, users needed the capability to create new reports in the BI Dashboard that should be available through the Web Application to different users.
Consistency across all reporting channels is critical as multi-million dollar business decisions were made based on the information presented in these reports. It is important to present the macro and micro level information with enterprise data governance to ensure the security of the information. The existing reporting system is a manual adhoc reporting system that involved writing SQL to retrieve data from heterogeneous data sources and merging them together in Excel for additional manipulations. This reporting system was prone to data accuracy and consistency errors. All the data required for effective use of the reports was not available due to data ownership and governance concerns. The data was scattered across multiple Oracle databases and access to the databases was restricted due to data security concerns. Data was distributed as flat files resulting in several import and export routines. The end solution was unreliable and could not scale to meet the 1400 hundred concurrent user requirement.
- Visibility of deals across all Business Units resulting in bundling of deals and multi-million dollar savings globally
- Multi-Million dollar savings due to reliable and consistent data resulting in avoiding bank penalties and compliance penalties.
- Security and data governance enforced across all channels integrating with single signon Consistent look and feel between web application and reporting solution
- Reduced IT costs and involvement due to self-service adhoc reporting capability for end users
- Automated reporting solution helped business users focus on their business instead of spending their valuable time manipulating data in spread-sheets