PDG’s database architecture services offer organizations the ability to streamline the collection, accessibility, organization, and safeguarding of data within their digital corporate ecosystems. Well-managed data enables crucial analysis that can be used to create solutions and catalyze executive decision making. PDG supports its clients by implementing and maintaining database management systems focused on clean, accessible information.
DBMS Technology Solutions From PDG
Behind every successful application is a well-structured, organized database, and our goal on every project is helping our clients build or maintain this. We approach each client engagement by learning about the business, becoming data subject matter experts, and developing an understanding of how their database should be configured for maximum success.
Cloud Database Architecture
We have created powerful solutions using our cloud based CCAE software suite, including custom rights and availability reporting systems that have been designed to support new contract models and rights data. Cloud database architecture works to optimize data and improve the security and flexibility of its storage.
Cloud Database Architecture
We have created powerful solutions using our cloud based CCAE software suite, including custom rights and availability reporting systems that have been designed to support new contract models and rights data. Cloud database architecture works to optimize data and improve the security and flexibility of its storage.
B2B Marketing Database Development
We have developed digital asset management and content management systems that allow stakeholders to access massive amounts of data with ease. Our approach to storage optimization and data normalization helps clients and their customers achieve seamless front-end experiences.
B2B Marketing Database Development
We have developed digital asset management and content management systems that allow stakeholders to access massive amounts of data with ease. Our approach to storage optimization and data normalization helps clients and their customers achieve seamless front-end experiences.
Additional Technologies
- Microsoft SQL Server
- SQL Server Replication
- Microsoft SSAS
- Microsoft SSIS
- Hibernate
- PostgreSQL
- Oracle Database
Additional Technologies
- Microsoft SQL Server
- SQL Server Replication
- Microsoft SSAS
- Microsoft SSIS
- Hibernate
- PostgreSQL
- Oracle Database
Why Choose PDG Consulting as your Database Architecture Technologies?
We are eager to help assist your business become more organized with a refined database system that fits your needs. Reach out to us to learn more about how we use different technologies to accomplish these goals. Contact us today for a free quote!
Project Name
Data Consolidation and Visualization
Overview
PDG was tasked with digitalizing and consolidating data from dozens of source systems across the company into a centralized Enterprise Data Warehouse, including the creation of a robust data visualization and analytics front-end through Qlik Sense. PDG provides service at every level — from requirements gathering, data consolidation gap-fit analysis, and custom web solutions for business user data maintenance — to data modeling and ETL, Visualization development in Qlik Sense, and user onboarding and adoption training.
Tech Stacks
MS SQL Server | Angular | Qlik Sense | SSIS | S3
Project Name
Enterprise Production Incentive Cockpit
Overview
PDG owned and project managed the development of the EPIC enterprise portal used to track Theatrical and Television production tax credits, both domestically and internationally. By integrating the business processes of Production Planning, Theatrical & Television Finance, Treasury, and Tax, EPIC has streamlined and optimized the way WB, HBO, and Turner manage production credits, creating increased visibility and control of the credit process.
Tech Stacks
SAP | Web UI | Enterprise Data Warehouse | .net
Project Name
Sales Analytics and Data Insights
Overview
PDG helped Sony's Distribution Sales Analytics and Data Insights team democratize advanced analytics by creating alternative reporting tools to support sales, sales planning, sales strategy, and marketing areas. PDG designed and developed the analytical reporting database, created the BI data pipelines from source to end user, and supported the development of various business data models and KPI's that are socialized through various reporting tools and dashboards. By developing key metrics and normalizing data across territories and markets, the data is more easily accessible — empowering each group supported with shared insights and analyses.
Tech Stacks
Teradata | Alteryx | Tableau
Project Name
Apple TV+ Studio Systems - Deal Tracker
Overview
PDG drives the development, implementation and design of a new Deal Tracking system which is the technological heartbeat of the Apple TV+ production process. It services users from finance, legal, creative and business affairs departments — acting as the connective tissue between many of these groups. The application manages the deal making, negotiating, and closing processes required for any studio to produce content. PDG leverages its M+E industry expertise to provide timely and comprehensive solutions to Apple TV+ stakeholders.
Tech Stacks
NodeJS | VueJS | Elastic Search | Oracle RDBMS | Kubernetes | AWS EKS | Kafka | Cypress
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 PDG’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
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
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
Project Name
Music Rights Management
Overview
PDG designed and developed the enterprise web application, site flow, and customer-facing storefront for the Magic music rights management system. Magic tracks all publisher and master rights that a studio owns for original scores for its films and television shows. Cue management for features and television episodes allows potential 3rd party licensees to easily find music heard in a production and ensures producers have a comprehensive view of all music used in any production – including licensed songs and/or scores. The core engine also drives an external licensing platform where outside filmmakers can license the original music written for the project.
Tech Stacks
Java | Spring | Oracle | Hibernate | JPA | jQuery
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
PDG CCAE v3.0 – Java | Spring | Angular 6 | Kafka | PostgreSQL | AWS EC2 | Splunk
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
Project Name
Digital Transformation Project
Overview
PDG has owned the entirety of Sesac’s Digital Transformation project from requirements gathering, UX design, application design, development, testing facilitation, and deployment. The project includes updating the Licensee, Affiliate, and public website experience to best-of-breed technologies and UX design. A full-stack implementation - everything from UX to backend, royalty management, song catalog management, payment processing, authentication, and ETL has been re-designed to provide a better user experience on a new tech stack at a lower run cost.
Tech Stacks
Angular | AWS | Glue | Postgres | Cognito | Braintree | Docker | Salesforce | Oracle EBS | Docusign
Project Name
SAP Digital Transformation
Overview
PDG 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 Sprint | IOS | Android
Project Name
SteelPro
Overview
PDG 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. PDG also organized the implementation and roll-out of the system to the various manufacturing plants nationwide.
Tech Stacks
.NET | SQL | MS BI stack | Angular | AWS
Project Name
Microsoft Business Intelligence
Overview
The PDG 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