Assisted a digital marketing company to optimize KPIs and increase...Read More
The client is a multinational pharmaceutical company based in India. The client deals in manufacturing and selling active pharmaceutical ingredients and pharmaceutical formulations in India and the US. Considered as one of the most reputed brands in India, the client has expanded with joint ventures and acquisitions in the last two decades.
The client wanted to migrate their existing Oracle-based (EDW, GDW) and Tableau reports to open-source software and tools. With their new business model, the additional requirement of dashboards, reports, and enhancements around existing dashboards, data volume increased greatly. With online access provided to every sales representative, the user base rose to 9000+. Therefore, instead of investing further into on-premise infra with licenses, the client wanted to move to On-Cloud open source platform expecting to keep TCO in control with rising volume and requirement. Scalability, performance, cost, and improvement of batch job processing were the key factor for the analytics modernization.
Our team analyzed the client’s existing infrastructure, platform, tools, and taken-up tasks and:
Our approach helped the client to
We followed a phased approach for the migration:
With spiraling license fees from Oracle, the potential upside in terms of cost savings was easy to appreciate. This engagement not only provided the client with the evidence of skills and expertise that Aptus Data Labs could provide, it also made it an obvious decision for the client to award Aptus Data Labs the contract for 24/7 Production Support.
Some of the benefits to the client were: