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

nbs universal logo

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 logo

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

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