The client was introducing new products and extending methods of sale to include third-parties. As a result, it was necessary to extract data from several transaction systems, transform and cleanse the data and provide it to a specialized database supporting sales compensation calculations and reporting.
Prodigy was initially hired to carry out solution design and project management of the ETL processes. Subsequently we were engaged to develop .Net applications to automate the ETL processes. Information was extracted from four different operational systems and transformed and loaded into an off-the-shelf application – Callidus.
In addition to development Prodigy also carried out functional and technical design, project and QA planning and documentation to support release and implementation.
The ETL project was completed on time and budget. Prodigy was also able to quickly and successfully adapt the developed modules to changing requirements and new data elements. The system is currently in production. The project involved between 2 and 7 staff for a period of 6 months.
This client was migrating their current Pega workflow system to a new version. The migration needed to proceed with minimal disruption. At the same time, additional and improved functionality was required including provision for US currency.
Prodigy assisted the client team in migrating current Pega Applications from Pega v5.3 to Pega v6.2. This required analysis, planning, modification and testing to ensure that features on Pega v5.3 were compatible with the features and functionality of Pega 6.2. Complexities included handling work, data and rule separation for multiple applications running on a single instance. Our roles included that of Pega subject matter/technical expert, lead architect and technical configuration.
Prodigy assisted in the successful migration of 30 million work/data instances and introduced new workflows to handle US currency. In addition, the team trained in-house staff in the operation and maintenance of the Pega system.
The client manages, collects and distributes music royalties to publishers and song writers. They undertook a comprehensive multi-year rewrite and expansion of its entire set of systems including musical works matching (DAP), royalty collection and payment (RMS), external interfaces and their member website. Prodigy is the prime contractor for the Data Exchange Router (DER) sub-project that moves data between DAP, RMS and the Web as well as outgoing data for external organizations.
Prodigy provided team leads, business analysts and developers to create standardized work flows that synchronize data between internal systems in near-real time, as well as exchanging data in electronic data interchange (EDI), XML, CSV formats with other international societies’ systems and standard bodies like SUISA and CISAC. Key issues that arose were changing requirements within the target systems (in parallel development with data flows) and the existence of major differences and gaps in data structure and use between the target systems requiring the incorporation of business rules into the integration flows.
A custom Azure Message Bus orchestration engine was created, with hundreds of flows (written in C#) that manage data flows between internal and external systems. Data flows were structured using a standard design pattern and reusable components to support change and easy maintenance.
Prodigy also provided a team lead and developers to extend the multiple interactions we had previously written. Using Swagger some 15 separate API interactions were developed to support the micro-services architecture of the new website. Complete sets of system documentation were provided to assist in use and maintenance of the APIs by SOCAN staff.
Prodigy developed the user requirements, functional specification as well as the application and the many data flows over a 4 year period (including 2 years of production use) and continues to provide advanced support to the SOCAN application team that has taken over the system.
The client operates a large number of operational and transactional systems. As a result it has been difficult for them to easily develop accurate and consistent reporting applications. The recent purchase of the complete suite of Oracle products provided an opportunity to centralize the information flow to their reporting products.
Prodigy was engaged to assist with the detailed solution design and project management of the implementation of the new approach. Solution design included technical /systems analysis, design and specification based on discussions with users and subject matter experts as well as technical documentation on other systems. Project management required interfacing with multiple (over twenty) other teams who were responsible for the feeds into the new centralized system.
The initial version of the application was completed and implemented. Work is continuing on phased implementation of additional and expanded data feeds.
