cbs logo

Project Name

Domestic and International TV Distribution

Overview

PDG redesigned CBS’s existing PDS rights management system and implemented a custom title availability reporting system utilizing a custom version of PDGC’s CCAE software suite. Licensing modules were redesigned to support new contract paradigms and rights including complex license carveouts, and non-linear catch-up rights in numerous forms.

Tech Stacks

C# | Microsoft .NET 4.5 | Angular 6 | Microsoft SQL Server

cbs logo

Project Name

B2B Asset & Content Management

Overview

PDG developed a Digital Asset Management and Content Management system for three different business divisions to offer a common storefront for ViacomCBS distribution customers to browse digital content and access marketing/promotional materials. PDG owned and managed the design, development, implementation, and QA of all new and upgraded application components. This includes creating APIs to migrate legacy assets to OTMM (OpenText Media Management), building a modern Security Authorization module, and building a web interface with modernized UI/UX.

Tech Stacks

ASP.NET Core | Angular 10 | Microsoft SQL Server | Salesforce/PARDOT

sony pictures logo

Project Name

Revenue Pipeline Management (RPM)

Overview

PDG supported the analysis and requirements gathering processes along with owned the technical design, development, and worldwide rollout of this custom system. RPM integrates existing sales & distribution systems with a custom data warehouse and forecasting application in order to increase television sales by providing more information about product availability. The distribution system handles all licensing, customer, fee, and shipping information for 300,000+ titles and thousands of concurrent deals. RPM is used by hundreds of sales planners and finance users worldwide.

Tech Stacks

Java EE | Spring | Angular 7 | DevExtreme | Active MQ | Oracle DB | Microsoft SQL Server | Microsoft SSAS

21st century fox

Project Name

Film & Television Distribution

Overview

To provide near real-time contract validation and availability reporting, PDG installed its cloud-based CCAE application suite to augment Fox’s contract management system and manage its multi-billion-dollar distribution business. Additionally, enterprise messaging services were built out to connect product, rights, release, and scheduling metadata throughout the organization.

Tech Stacks

PDGC CCAE v3.0 – Java | Spring | Angular 6 | Kafka | PostgreSQL | AWS EC2 | Splunk

nbs universal logo

Project Name

TV Production Data Warehouse

Overview

For this project, PDG managed the data warehouse and report development while also providing functional and technical design. This included managing and making key design decisions for the development of the ETL process, data model, reports, and automated Excel applications. PDG also designed and managed the development of web and mobile-based Microstrategy production budget executive dashboards. The data warehouse provides consolidated cost and budget data from SAP and three external production accounting systems (Entertainment Partners, Cast and Crew, and Ease Accounting). This allows for the automation of numerous finance processes including the production recap (budget and forecast) consolidation and reporting process for over 100 users across all TV productions providing visibility to up-to-date forecasts through reports and executive dashboards.

Tech Stacks

SAP | Teradata | Informatica | Microstrategy | Cast & Crew | Ease Accounting | Excel

nbs universal logo

Project Name

SAP ERP Business Planning

Overview

PDG helped implement the automation and standardization of the FP&A processes for the Television Distribution group at NBCUniversal with the goal being to transition all their planning models in Excel into a comprehensive BPC Solution to speed up processes.

Tech Stacks

SAP BPC | SAP HANA | ABAP

stx logo grey

Project Name

SAP BPC support

Overview

PDG provided application support for the implementation of SAP S4 Hana and BPC to fulfill STX’s financial accounting, forecasting, and consolidations needs. STX uses BPC to perform film, television, digital, and home entertainment P&L forecasting on both a cash and accrual basis.

Tech Stacks

SAP BPC 10.1 | SAP AO | S4 Hana

att direct tv logo

Project Name

DIRECTV Advanced Business Planning

Overview

PDG built a Business Intelligence tool that provides high-value dashboards to ATT Advertising business stakeholders as well as Tech Ops. It allows users to drill down and slice and dice across huge volumes of historical ad performance and customer behavior events. In addition to creating an actionable, centralized data lake for all things ad-related, its main value resides in providing predictive algorithms that leverage big data and Spark distributed computing, which allows users to visualize the predicted performance of upcoming advertising campaigns.

Tech Stacks

Spark | Scala | Spring | AWS Glue | Amazon QuickSight | Amazon EMR | Amazon S3 | Redis | AWS CloudFormation

att direct tv logo

Project Name

AT&T TV Program Scheduling

Overview

PDG fully migrated the DIRECTV TV / VOD Guide metadata pipeline to the cloud. This included movie poster images, celebrity headshot, aggregated guide schedules & celebrity biographies over a satellite using Kafka, Couchbase, GoLang, & Kubernetes.

Tech Stacks

GoLang | Kubernetes | Amazon S3 | Couchbase NoSQL Database | Java | Kafka

ADVERTISING
BROADCASTING AND CABLE
CONSUMER PRODUCTS
MANUFACTURING
MEDIA & ENTERTAINMENT
MUSIC
OTT (OVER-THE-TOP)
SATELLITE TELEVISION
TELECOM