The Client
Established in 2005, MedChoice is a Philippines-based pharmaceutical manufacturing company, providing best-in-class, affordable medicines in the country. Their expertise lies in the field of Endocrinology, Psychiatry, Neurology, and Ob-Gynecology. They are bringing together the finest talent and veterans of the pharmacy field to provide the best in the healthcare industry.
One of their biggest concerns was their current financial process which had a lot of gaps. Since MedChoice was planning to go public, the company wanted to modernize its system.
MedChoice wanted to partner with someone who has a proven and tested approach to implementing Oracle EPM Cloud solutions. Therefore, with the Mastek team as an Oracle implementation partner, they were able to streamline their financial system using Oracle EPM Cloud.
The Challenges
Our team needed to create a centralized financial system to overcome the existing challenges that MedChoice Pharma was facing. Some of them are:
- The existing spreadsheet files did not support financial processes such as audit trail, security, reporting, and integration.
- Tracking the versions on the excel sheets was a seemingly impossible task during consolidation.
- Preparation of ratio analysis, balance sheet, profit and loss, and cash flow had its own set of challenges.
To overcome the above challenges, the Mastek team completed the deployment in just 16 weeks, remotely, using the ADOPT approach. We continually resolved all support-related issues throughout the life cycle of the project.
The Challenges
Our team needed to create a centralized financial system to overcome the existing challenges that MedChoice Pharma was facing.
- The existing spreadsheet files did not support financial processes such as audit trail, security, reporting, and integration.
- Tracking the versions on the excel sheets was a seemingly impossible task during consolidation.
- Preparation of ratio analysis, balance sheet, profit and loss, and cash flow had its own set of challenges.
To overcome the above challenges, the Mastek team completed the deployment in just 16 weeks, remotely, using the ADOPT approach. We continually resolved all support-related issues throughout the life cycle of the project.
The Challenges
Our team needed to create a centralized financial system to overcome the existing challenges that MedChoice Pharma was facing. Some of them are:
- Optimise performance and improve process efficiency
- Unify data and generate a single source of truth to upgrade reporting and overall visibility
- Create a seamless authentication experience and add a security layer while accessing cloud applications
- Ensure the ability to navigate future challenges with flexibility, scalability and agility
- Optimise performance and improve process efficiency
- Unify data and generate a single source of truth to upgrade reporting and overall visibility
- Create a seamless authentication experience and add a security layer while accessing cloud applications
- Ensure the ability to navigate future challenges with flexibility, scalability and agility
The Solution
- Our team helped automate the complete financial process using Oracle Financial Consolidation and Close Cloud Service (Oracle FCCS), a sub-module of Oracle EPM.
- A custom report dashboard was created by the team in order to get consolidated reports.
- Migrate 20 on-prem applications, 23 Essbase Cubes, 4000+ reports and 28 integration touchpoints to the cloud
- Migrate 100 GB of data from legacy systems to Oracle Cloud
- Gain a bird-eye’s view of operations by incorporating dashboards
- Drive better insights from data, improved reporting, top-notch data security, governance and compliance
The Solution
- Our team helped automate the complete financial process using Oracle Financial Consolidation and Close Cloud Service (Oracle FCCS), a sub-module of Oracle EPM.
- A custom report dashboard was created by the team in order to get consolidated reports.
- Migrate 20 on-prem applications, 23 Essbase Cubes, 4000+ reports and 28 integration touchpoints to the cloud
- Migrate 100 GB of data from legacy systems to Oracle Cloud
- Gain a bird-eye’s view of operations by incorporating dashboards
- Drive better insights from data, improved reporting, top-notch data security, governance and compliance
These Solutions Included
- Creating a unified front-end that makes data workflows highly customizable and accessible for application development.
- Rewriting queries and processes that were defined in Oracle to AWS-friendly SQL.
- Building a secure, continuous data sync between legacy systems and the cloud.
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum.
Client, XYZ Company
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec odio. Praesent libero. Sed cursus ante dapibus diam. Sed nisi. Nulla quis sem at nibh elementum imperdiet. Duis sagittis ipsum.
Client, XYZ Company
Benefits
Improved Quality and reliability of services.
Improved customer satisfaction & confidence.
Average monthly critical system issues reduced by 60%.
Reduced staffing and systems management time.
Average monthly performance issues reduced by 90%.
The Outcome
Putnam’s migration was completed in just 60 days. With many Python based, self-service utilities set up; the data architecture team was able to support an acceleration in customer analytics processes and go-to-market plans.
- Increased productivity and reduced manual efforts after eliminating the need of maintaining different spreadsheets.
- Centralized unified financial system enabled easy workflow of the processes, specifically pertaining to audit trail and reporting.
- Tracking of versions while consolidation.
- Upon deploying the new system, the pharmaceutical manufacturing client who earlier could only manage yearly consolidation of reports, was now able to consolidate monthly reports.
- Increased productivity and reduced manual efforts after eliminating the need of maintaining different spreadsheets.
- Centralized unified financial system enabled easy workflow of the processes, specifically pertaining to audit trail and reporting.
- Tracking of versions while consolidation.
- Upon deploying the new system, the pharmaceutical manufacturing client who earlier could only manage yearly consolidation of reports, was now able to consolidate monthly reports.
Streamline your business processes with
Oracle EPM Cloud
Step into the next generation of business process planning with the power of automation. Leverage flexibility, sociability, and predictive planning to mitigate compliance challenges and outperform volatile market conditions.
Oracle EPM Cloud Implementation Success Stories
Decomplex
Customer Success
Decomplex
Customer Success
Leading automation for the Ministry of Justice
Driving improvement in patient care with data insights
Flexible IT systems for VISA verification
One of the largest county Councils of Greater London saved £4.5m annually