{"id":108064,"date":"2023-03-31T12:28:23","date_gmt":"2023-03-31T09:28:23","guid":{"rendered":"https:\/\/innowise.com\/?post_type=case&p=108064"},"modified":"2026-03-17T04:53:03","modified_gmt":"2026-03-17T08:53:03","slug":"financial-data-management","status":"publish","type":"case","link":"https:\/\/innowise.com\/es\/case\/financial-data-management\/","title":{"rendered":"Gesti\u00f3n de datos financieros: mayor comodidad y flexibilidad para el usuario"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Excel-like tool to collect and calculate royalty streams from biopharmaceutical products<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n
\n API<\/a>\n <\/div>\n \n
\n ERP<\/a>\n <\/div>\n \n
\n Golang<\/a>\n <\/div>\n \n
\n Healthcare<\/a>\n <\/div>\n \n
\n Investment<\/a>\n <\/div>\n \n
\n Pharma<\/a>\n <\/div>\n \n
\n React<\/a>\n <\/div>\n \n
\n UI\/UX design<\/a>\n <\/div>\n \n
\n Web<\/a>\n <\/div>\n \n
\n Web development<\/a>\n <\/div>\n <\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Innowise has developed a convenient system for storing, calculating and editing royalty streams on a quarterly basis.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Challenge<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

At the client\u2019s company, each contract represents a royalty stream in an Excel spreadsheet, with net license fees calculated quarterly based on reported sales and royalty rates. Despite being quick and accurate, Excel oftentimes requires much manual work and suffers from slow load times, problems with collaborative work, and the risk of inadvertently deleting essential data. Despite the availability of off-the-shelf financial management solutions<\/a><\/strong><\/span>, our customer sought a bespoke ERP-like product that would prioritize user-friendliness and swift response times.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\"financial\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Solution<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Though the back-end was all on the customer's side, our project team was tasked with ensuring hassle-free API integrations and intuitive UI designs. <\/p>

\nIn essence, the platform's core function is to calculate the revenue generated from a signed agreement, represented as a royalty stream. As contract terms may change over time, an agreement may need to be split into multiple royalty streams with the same name. Each royalty stream is assigned to a manager who oversees one or more drugs, drug groups, or medical equipment. All data and calculations are stored in MS SQL Server databases, extracted from Excel spreadsheets.<\/p>

\nOur main objective was to enhance the application by providing comprehensive interfaces for calculating and monitoring royalty accruals, actual revenue, and cash receipts on a quarterly basis.<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\"financial\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

USER AUTHORIZATION<\/p>

Once a user runs the web application from the desktop, they see a splash screen with the logo and authentication option. When users log into the Windows Server, they go through the sign-in procedure using LDAP authentication (request-response protocol). Upon granting access to a customer (after entering login and password), the access token is created. To ensure security, sessions are set to stop after several hours of inactivity, with the customer receiving a warning a few minutes in advance. At this point, they will be redirected to the splash screen, where they will need to re-enter their login and password information.<\/span><\/p>

LOYALTY STREAMS<\/p>

When a user selects a royalty entity, they are directed to a user interface where they can access relevant values and calculations specific to the selected agreement.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\"financial\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Previously, marketer reports<\/span> were obtained manually from corporate sources to retrieve data on drug sales every quarter. However, the new system automatically retrieves this data, allowing users to observe the result of a cash flow calculation on a quarterly basis. The number of periods (years and quarters) that can be viewed on the screen depends on the resolution.<\/p>

The system has four user roles – admin (manages access and gives permissions), system admin (system technical owner), editor (enters data and does calculations), and viewer (oversees information and downloads reports without editing powers).<\/p>

Upon logging in, users can select a royalty entity, view information, edit values, add comments, copy and paste data, search for information using built-in filters, and forecast projected values for future periods. The drug sales data are categorized by region, providing critical information about the stream, including the market location, start and end date, ID, and active or expired status.<\/p>

The system is compatible with major browsers such as Google Chrome, Microsoft Edge, Firefox, and Safari.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Technologies<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n \n
\n
\n Front-end<\/a>\n <\/div>\n
\n <\/div>\n
\n React<\/a>\n <\/div>\n <\/div>\n
\n
\n Back-end<\/a>\n <\/div>\n
\n <\/div>\n
\n Golang<\/a>\n <\/div>\n <\/div>\n
\n
\n Database<\/a>\n <\/div>\n
\n <\/div>\n
\n MS SQL Server\n <\/div>\n <\/div>\n
\n
\n VCS\n <\/div>\n
\n <\/div>\n
\n GitHub\n <\/div>\n <\/div>\n
\n
\n DevOps<\/a>\n <\/div>\n
\n <\/div>\n
\n Ansible, GitHub Actions, Nginx, Docker, Docker Compose, Ubuntu\n <\/div>\n <\/div>\n<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Process<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

The client initiated a comprehensive onboarding process to ensure a clear understanding of their domain, knowledge transfer, and team readiness for the development phase. Innowise dedicated two weeks to this process, holding kick-off meetings, discussing the project management approach, elaborating the statement of work, communication strategy, reporting, onboarding sessions, and daily calls.<\/p>

Once the onboarding stage was completed, our business analyst clarified the project requirements in detail. Based on these requirements and the customer’s prototype sketches, a UI\/UX designer developed the prototypes. Our React developer advised on the suitable tech stack and suggested technical details such as library investigation. The PM created project tasks in Jira, and the client\u2019s PO verified them.<\/p>

Following the onboarding stage, Innowise provided the following artifacts:<\/p>