Network Server Assessment
Our client wanted to determine active vs. dormant databases, their overall performance and utilization, and any consolidation/decommissioning opportunities. Our analysts reviewed the entire environment using network listeners for a high-level preliminary analysis before diving into details of each database instance.
Modernizing Data Management
Client’s AS400 system didn’t regulate data consistency or provide a user-friendly experience. In working closely with the executive team an end-to-end data solution was agreed upon; Microsoft stack on the backend with Qlik Sense empowering users on the frontend.
Improving Help Desk Reporting Metrics
Utilizing the client’s Excel data, a dashboard was created to manage and visualize help desk activities. The Excel data was imported into Tableau and our team implemented numerous best practice data metrics, dimensions, and aggregate key performance indicators.
Service Desk Dashboards & Reporting
Y&L provided client real-time PowerBI Dashboards that automatically ingested, transformed, and provided visualization for operational metrics. The dashboards included drill-down into incidents, service requests, change requests, star performers, and trends.
Predictive Revenue Model
The client wanted to predict, week-over-week, where revenue would be 10-weeks out. Our analysts determined the delta between revenue and guided revenue. If the delta was above the set threshold, our automated business rules identified the product line causing the impact down to the regional level so immediate action could be taken.
Addressing a Negative Closing Ratio
Client wanted to determine their pricing sweet-spot on their core product lines along with insight around their quoting lifecycle: won vs. lost quotes. The objective was to create an end-to-end solution prototype consisting of database integration with front-end delivery.
Balancing The Workload
The speed at which a customer’s claim is processed has a direct impact on customer satisfaction and retention. A slow processing cycle can often be due to heavy manual processes and inherent inefficiencies that can have a very direct effect on operational costs.
Salvaging The Salvage Process
“Salvage” is the insurer’s way to literally salvage what they can from an otherwise catastrophic loss. Most insurers outsource the entire salvage life cycle from towing to auctions to specialist vendors.
Preventing Fraud: Claims Processing
The commoditization of Insurance and the high degree of regulation has made the insurance industry a target for fraudsters.
There are numerous soft and hard fraud attempts against insurers.
QA Testing
Harland Clarke was integrating a third party product into its social media page, as well as an ATG application.