CASE STUDIES

Information Management PERFORMANCE PORTFOLIO

Client: Southwest Research Institute COMPANYPROFILE: Southwest Research Institute (SwRI), headquartered in San Antonio, Texas, is one of the oldest and largest independent, nonprofit, applied research and development (R&D) organizations in the United States. PROJECT DESCRIPTION: SQL Query and Performance Tuning ENVIRONMENT: SQL Server, SQL Server Integration Services, Proprietary front-end (UI) SUMMARY: SwRI was engaged in […]

November 8, 2018

Information Management PERFORMANCE PORTFOLIO

Client: Rackspace, Inc. COMPANYPROFILE: Rackspace, Inc. is a managed cloud computing company headquartered in San Antonio, Texas. PROJECT DESCRIPTION: Implement Master Data Management (MDM), Data Quality, and Data Governance across multiple applications ENVIRONMENT: Oracle, Informatica, Informatica Data Quality, Salesforce, Proprietary Applications SUMMARY: The Y&L Information Management practice was selected by Rackspace to manage a large-scale […]

Information Management PERFORMANCE PORTFOLIO

Client: Trinity Church COMPANYPROFILE: Trinity Church is a diverse church in the San Antonio area. PROJECT DESCRIPTION: Improve Marketing Campaign Effectiveness. ENVIRONMENT: MS Access SUMMARY: Trinity Church needed to identify their target demographic for the acquisition of new students and the retention of old ones. Their goal was to put together a proper marketing campaign. […]

Information Management Performance Portfolio

CLIENT: CINTRA PROJECT DESCRIPTION: OBIEE Environment Assessment ENVIRONMENT: OBIEE, Oracle Data Integrator SUMMARY: Prior to beginning the OBIEE report development, Y&L was asked to assess the current reporting environment. The client had concerns on how a previous vendor had modeled new attributes and metrics, adding over 250 objects to the repository in a matter of […]

Cost Savings: Address Cleansing

INDUSTRYBACKGROUND Despite the desire to go paperless, Federal, State and regulatory requirements often mandate mailing paper correspondence in certain industries. The P&C Insurance industry is one such industry. Unlike the validation of phone numbers or email addresses, physical address validation is a protracted process, making it difficult to ascertain correctness. BUSINESS PROBLEM Apart from regulatory […]

October 29, 2018

Cleaning The Risk Pool

INDUSTRYBACKGROUND Just like mortgages, credit cards, and other type of financial transactions, that require underwriting; Credit Scores are a key determining factor within the auto insurance underwriting process as to whether a prospective customer is an acceptable risk. The Credit Score has a significant impact on determining the premium charged to an individual. People with […]

Primavera-Unifier Expansion Assessment at a City Municipality

When it comes to large city municipalities, some departments can be heavy users of project management software while other departments may have limited use or understanding. One major issue is if a novice department wants to begin to more fully utilize the software, the more experienced department may be concerned their projects may become negatively […]

October 26, 2018

TEA’s TSDS “Early Childhood” Data System

For over two decades, the State of Texas has been collecting data to support reporting and policy efforts at both the state and federal level. Statewide systems store and manage data, however, these systems were not developed to support the increasing demand for timely, consolidated and actionable data. Focusing on federal compliance reporting requirements, the […]

HHSC Fraud Monitoring and Prevention

This project was aimed at making large scale database and service changes to create a system that allows fraud monitoring and prevention. The scope also included large scale data transformations to create elaborate reports for interagency and intra-agency consumption. During the course of development, Sistema also conducted extensive batch changes, including coordination with outside agencies. […]

Transformation to an eGovernment Solution

Sistema Technologies performed a full-scale IT Assessment which included the development of an IT roadmap for converting the client’s environment into a state-of-the-art eGovernment agency. The IT roadmap involved building an automated web-based workflow solution that digitized all forms and workflow routing processes, was driven by a robust workflow engine and was in alignment with […]

SAP Implementation

A premier refining, marketing and logistics, company in the western United States with approximately $37 billion in annual revenues was looking to further automate their finance and accounting systems. To help our client improve cash flow, increase efficiencies of accounts receivable and accounts payable, Y&L implemented the SAP FSCM module. During this process we migrated […]

Can you Dig It?

When a pipeline inspection results in anomalies there is a need to perform a dig (Pipeline In-Line Inspection – ILI) along with a visual inspection which may result in further testing or repair. Working with our client, a leading pipeline storage, and distribution company for crude oil, refined products and specialty liquids, Y&L assisted in […]