cbs logo

Project Name

Domestic and International TV Distribution

Overview

PDGC 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

sony pictures logo

Project Name

Revenue Pipeline Management (RPM)

Overview

PDGC 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, PDGC 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

Project Name

TV Production Data Warehouse

Overview

For this project, PDGC 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. PDGC 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

Project Name

SAP ERP Business Planning

Overview

PDGC 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

PDGC 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

jafra

Project Name

SAP Digital Transformation

Overview

PDGC provided SAP solution architecture, project management, and business intelligence experts for a full top to bottom digital and technology transformation project to implement best-of-breed 21st-century technologies in order to bring them into the digital age. Using a full SAP stack starting with their e-commerce website & mobile apps through to outbound logistics and everything in between.  Jafra is changing the way its customers do business.

Tech Stacks

SAP Hybris | Vistex | SAP ECC | SAP EWM | SAP TM | SAP CRM | SAP PI | MS SQL Server / BI | Java | Spring Framework | IOS | Android

cemco

Project Name

SteelPro ERP

Overview

PDGC helped to program manage and provide advisory services for the implementation of Cemco's industry-specific ERP, assisting with stabilizing the system from both a performance and utility perspective. PDGC also organized the implementation and roll-out of the system to the various manufacturing plants nationwide.

Tech Stacks

SteelPro | Microsoft .NET | Microsoft SQL Server | Microsoft BI Stack | Angular | AWS

cemco

Project Name

Microsoft Business Intelligence

Overview

The PDGC team successfully built and demoed a POC within 2 months resulting in the implementation of a BI solution that improves the performance and functionality of CEMCO's reporting capabilities involving over 70 reports.

Tech Stacks

Microsoft SQL Server | SSIS | SSAS | Power BI

att direct tv logo

Project Name

DIRECTV Advanced Business Planning

Overview

PDGC 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

Big Data / Business Intelligence
Business Planning
Cloud Platforms
CRM
Database Architecture
ERP
IoT / Embedded Systems
Machine Learning
Application Development