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