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

cemco metal

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 logo

Project Name

Mulesoft Migration

Overview

PDGC is providing project management and integration expertise to define the overall project roadmap and manage a team of developers through the assessment of hundreds of microservices supporting critical sales and service functions of ATT.com to identify performance and design improvement opportunities. The objective is to enhance the overall customer experience and increase sales by improving performance, reliability, and time to deliver new features. An additional output of the assessment is to provide a Mulesoft onboarding/migration strategy for the microservice-based APIs to support API discoverability and reusability across the enterprise.

Tech Stacks

Java | Spring | Node.js | Kafka | Cassandra NoSQL Database | Redis | Mulesoft

att direct tv logo

Project Name

DIRECTV Advanced Advertising

Overview

PDGC designed and oversaw a complete re-architecture of the DIRECTV satellite advertising platform, which more than doubled the number of ads that could be targeted to customers and brought down the amount of required lead time to play out a targeted ad from 24 hours to under 4 hours. This re-architecture enabled DIRECTV to enter the advertising interconnect managed by Comcast/NCC which doubled DIRECTV's yearly advertising revenue. PDGC also designed and developed two critical applications in the advertising platform and built out real-time alerting and reporting dashboards used by the 24/7 advertising operations teams. PDGC continues to lead incremental architectural changes for the satellite platform and is also assisting in architecting the next-generation advertising platform for streaming services such as DIRECTV NOW.

Tech Stacks

Java | Angular | Oracle SQL | Microsoft SQL Server | Microsoft IIS | SOAP | REST | Kafka | Hadoop | Splunk

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

Project Name

Farm IP

Overview

PDGC is building a platform to track the movements of grains (soybeans) on farms to ensure crops are segregated between individual farms. This includes developing a complete website to enable user and farm setup along with building and deploying prototypes of Bluetooth LE / LoRa GPS tracking devices.

Tech Stacks

Spring | React | MySQL | AWS IoT (MQTT) | RAK WisBlock (embedded BLE platform)

B2B
BUSINESS PROCESS OPTIMIZATION
DIGITAL TRANSFORMATION
RIGHTS MANAGEMENT
UI/UX DESIGN
STREAMING MEDIA
INTEGRATION
UI/UX DESIGN
STREAMING MEDIA
INTEGRATION
UI/UX DESIGN
STREAMING MEDIA
INTEGRATION