Application Development
The Office of the Inspector General (OIG) needed an application for referral assignments and investigations tracking that would work for both the Claims Investigations and Field Investigations units.
QA Testing
Harland Clarke was integrating a third party product into its social media page, as well as an ATG application. The main challenge of the project was the new product’s simultaneous interaction with multiple third-party applications and systems.
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.
Sample Case Study
The Office of the Inspector General (OIG) needed an application for referral assignments and investigations tracking that would work for both the Claims Investigations and Field Investigations units.
Customer Sentiment Analysis
Retail client wanted to analyze customer comments using text analytics. Customer calls into the Service Center are captured and saved in a raw text format. Y&L analysts extracted Service Center data and derived sentiment utilizing latent Dirichlet allocation, text pooling, and clustering algorithms in R.
BI Report and Dashboard Development
Y&L’s data analysts designed, developed, and delivered over 14 C-level reports and 5 dashboards; analyzing areas such as accounting, traffic management, and operations. The team added design elements which helped improve data interpretation.
Environment Assessment & Analytic Proof-of-Concept
Plagued by disparate data sources, hand-scripted query data integrations, and segregated platforms for reporting and dashboards, our client envisioned a consolidated data environment with a unified reporting and dashboard platform, plus the ability to perform predictive analysis.
SQL Query and Performance Tuning
“Y&L analysts were brought in to eliminate data integration failures. An in-depth analysis of system logs was conducted, the server and network infrastructure was reviewed and validated, the integration process and code was reviewed, and data tables were analyzed for improvement. “
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.
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.