CASE STUDIES

Maintenance

Based upon Y&L Consulting’s performance on a successful FSCM migration and other SAP projects, Tesoro Corporation awarded us with an annual maintenance contract for implementing enhancements, change requests, and bug fixes. Y&L Consulting was responsible for providing maintenance support to Tesoro’s SAP systems. The support included fixing known defects, making code changes, and testing any […]

October 26, 2018

Preventing Fraud: Claims Processing

INDUSTRYBACKGROUND 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. Some of the most common fraud examples are, filing claims for fictitious accidents, multiple small claim requests and the impersonation of a claimant in order […]

October 25, 2018

Salvaging The Salvage Process

INDUSTRYBACKGROUND “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. As it is not a customer-facing transaction, salvage processing often gets very little attention. And while it does not really bring in any […]

Balancing The Workload

INDUSTRYBACKGROUND 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. Apart from these internal challenges, a lag in claims processing also […]

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. Our analysts loaded a Teradata database and, using Tableau, began to compare operational performance against KPIs […]

October 24, 2018

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. This solution was […]

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. Dashboards were built to be mobile-friendly and a landing page with helpful tips and feedback loops was implemented. To maximize efficiency, the Q&A functionality within […]

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. The dashboard was able to drill-down from a top-level view to a specific resource. Tickets by team […]

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. A SQL Server Database environment was implemented to ingest AS400 data. With the correct architecture, rules, […]

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. The following attributes were defined for output and visualization in Tableau: versions, configurations, software available […]

Report Migration

Client had an immoveable deadline to retire their legacy data warehouse and migrate 15,000 existing Cognos reports to a new Oracle data warehouse. Combining usage reports and interviewing report users reduced reports to 2,000. Decomposing reports down to their root elements was conducted, and a matrix of all base elements was produced. Elements were further […]

MDM, Data Quality, and Data Governance Implementation

“Due to rapid growth, our client’s product and customer data was not easily shared between systems, resulting in duplicate and inconsistent naming conventions. Y&L analyzed data sources across various systems and created a single data model. A source-to-target mapping document showed the migration from source systems to master tables. ” “Embedded within the integrations were […]