Client Profile

Leading media company serving Hispanic America -Univision, TeleFutura, cable nets, 62 TV & 69 radio stations & interactive media Univision is a Spanish-language television network in the United States. It has the largest audience of Spanish-language television viewers in the world according to Nielsen ratings. In recent years the network has reached parity with the U.S.'s five major English-language television networks, and is often a strong fifth, outranking The CW, with some fourth-place weekly placing’s, and as of 2012, even first place rankings for individual programs over all five English networks due to the network's consistent schedule of new telenovelas all 52 weeks of the year. Univision is headquartered in New York, and has its major studios, production facilities, and operations in Doral, Florida. Univision is available on cable and satellite in most of the country, with local stations in over 50 markets with large Hispanic and Latino populations.

Identified Issues

• Lack of data visibility between various systems within the organization
• Salesforce CRM unable to obtain core business data for dashboards
• Incompatibility of information across various data sources

Engineered Solution

• Developed and deployed 45 orchestrations to address the business functions
• An ETL solution was built involving TERADATA, Oracle & Salesforce endpoints
• Data transformations were performed to match endpoint compatibility

Results

• Salesforce CRM had full visibility of business data which was also used as a BI
• Bi-directional and seamless integration between discrete systems
• All business requirements were achieved as planned and on schedule