Dashboard

Modernizing an investment bank’s research management practice

 

Client challenge

In reaction to the Mifid II regulation, the client was seeking to increase the efficiency of the research team’s activities and design new revenue models to meet strategic goals through the use of web-analytics.  Research Analysts needed to gain readership insights through:

  • Improved engagement measurements
  • Coordination with sales to identify new opportunities

Due to regulatory changes, the organization needed to shift how it managed the research function’s revenue and costs of unbundled services

 

How we helped
  • We tagged the research website to capture tracking details using open source tools and in-house data capture to gain readership insights
  • We redesigned the website dashboard reports used by the Analysts to highlight critical usage patterns revealed by newly captured web-tracking data
  • We improved and streamlined the dashboard reports used by Sales and Management to highlight upsell opportunities more efficiently

 

Fulcrum improved website visitor tracking and built more actionable reporting aligned with goal setting and decision making.
Cash transaction compliance for a leading banking institution

 

Client challenge

In reaction to regulatory requirements to retain and classify payment records, the client needed help creating a cash transaction classification system for regulatory reporting and compliance, looking specifically to solve for following challenges:

  • Migrating away from using Excel that applied the classification rules with a manual process.
  • Implementing scripts to allow for processing a greater amount of data
  • Needing to improve operational scalability rather than rules being created small chunks at a time
  • Improving repeatability, decreasing processing time, and reducing error

 

How we helped

We developed a text mining and reporting engine in R that efficiently runs against the client’s full data warehouse

  • We automated code in R to be applied against the data warehouse for fast and accurate classification
  • We built a front-end UI to allow business users to create and modify rules to refine business logic and improve resulting classification rate
  • We created reporting on summary statistics and classification rate, including the impact of the addition of new rules
  • We created a next generation text mining process to prioritize the new candidate classification rules

 

Fulcrum created a scalable and sustainable solution to comply with regulations, which provided significant time-savings from manual labor, increased accuracy of classification, and introduced a mechanism to easily create and integrate new rules.

Price setting tool for a leading insurance company

 

Client challenge

The client was seeking to transform a labor-intensive pricing process to a seamless, sustainable and transparent operation. Key challenges included:

  • Lack of standardization in reporting across types of policy (e.g., auto, GL, etc.) which made it difficult to analyze account-level performance at a glance
  • Manual data pulling, and copying/pasting during the data preparation created high human-error risk
  • Difficulty tracking changes and updates to quotes

 

How we helped
  • We mapped out user stories to better understand various user needs and experiences
  • We developed a platform-flexible front-end pricing tool that accounted for user needs (e.g., metrics, reports, etc.) utilizing real-time data ingestion
  • We developed automated scripts for consistent data pulls and to reduce labor hours
  • We built a job management framework to provide pricing governance and monitoring

 

Fulcrum’s development of a reliable and sustainable process resulted in an 80% reduction of manual labor hours, increased pricing transparency, and yielded faster quote turnaround.