Business Context
The customer initially used an excel-based manual reporting system inclusive in their on-premise EBS system. They realized the need for a cloud transformation to promote efficient and detailed reporting in the organization. To achieve this, we implemented:
Oracle ADW (Autonomous Data Warehouse) for a centralized data warehouse
OAC (Oracle Analytics Cloud) for centralized reporting
This project was finished in multiple phases over a course of 10 months.
The Client
Founded in 2006, the Saudi Railway Company (SAR) is the largest state-owned railway operator in the Middle East, providing public transportation services for goods and passengers. It was founded with the aim to construct, operate and manage passenger and freight rail networks that would link KSA’s northern region with both eastern and central regions. SAR provides an integrated transport solution for its passengers and transporting minerals, petroleum, and other petrochemical products across the Kingdom of Saudi Arabia. The organization staffs over 2000 employees and has an annual revenue of about USD 139.32 million.
The Challenges
Wellington’s use of data was fragmented and compartmentalized, creating a suboptimal client and employee data access experience, and failing to accommodate growth. Business units needed a way to speed up development of custom web applications for unique client needs before competitors could beat them to market. The firm needed a solution that would support a more agile, cost effective, and scalable data management approach.
- Absence of centralized reporting platform was the biggest challenge of SAR. The employees used an excel sheet-based ad-hoc reporting procedure to extract important data from the external source system, which was time-consuming and often lacked the level of detail needed to carry out business tasks.
- There were no existing summary reports and defined KPI (Key Performance Indicators) that could help the client continuously identify risks, effectively optimize them, and take risk preventive actions to minimize impact.
- SAR had raised report reconciliation issues on financial and procurement reports. Additionally, the unstructured hierarchy in reporting had a major impact on various in-house reports.
- The nonexistence of Intra Period Financial Information before the closing of books was also an important concern.
- Lastly, the customer had no comprehensive visibility into overall transactions, which would help them improve business processes and operations.
- Absence of centralized reporting platform was the biggest challenge of SAR. The employees used an excel sheet-based ad-hoc reporting procedure to extract important data from the external source system, which was time-consuming and often lacked the level of detail needed to carry out business tasks.
- There were no existing summary reports and defined KPI (Key Performance Indicators) that could help the client continuously identify risks, effectively optimize them, and take risk preventive actions to minimize impact.
- SAR had raised report reconciliation issues on financial and procurement reports. Additionally, the unstructured hierarchy in reporting had a major impact on various in-house reports.
- The nonexistence of Intra Period Financial Information before the closing of books was also an important concern.
- Lastly, the customer had no comprehensive visibility into overall transactions, which would help them improve business processes and operations.
- 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 developed a data strategy with a hybrid cloud approach that made elastic resources available for analysts and developers. Once the strategy was ratified, our team launched a result and goal-oriented proof of concept (PoC) to solidify the business case for implementing AWS Redshift and supplemental cloud technologies to replace the existing Oracle environment. This solution delivery approach was able to explore and address Wellington’s concerns with the technology and build confidence in a combination of products from AWS and open source platforms.
- The Mastek team developed multiple executive dashboards entailing major KPIs for several department heads, including procurement, finance, and HR.
- We ensured that all the transaction-level drill-down reports reached to the last level with all the necessary transactional details.
- Our implementation team identified the decisive values of the detailed application modules as well as the cross-module reports.
- Implemented the complex Oracle EBS Financial Statement Generator Dynamic Reports (Exclusive of Account Mapping File) to enable SAR to record business logic, and process accounting hierarchy updates with the reporting solution. This would eliminate user intervention as well as offer a dynamic reporting experience to their employees.
- We developed Oracle Analytics Cloud reports and dashboards and added them to a standardized repository, so they can be easily deployed as pre-built analytics in the future.
The Solution
Our team developed a data strategy with a hybrid cloud approach that made elastic resources available for analysts and developers. Once the strategy was ratified, our team launched a result and goal-oriented proof of concept (PoC) to solidify the business case for implementing AWS Redshift and supplemental cloud technologies to replace the existing Oracle environment. This solution delivery approach was able to explore and address Wellington’s concerns with the technology and build confidence in a combination of products from AWS and open source platforms.
- The Mastek team developed multiple executive dashboards entailing major KPIs for several department heads, including procurement, finance, and HR.
- We ensured that all the transaction-level drill-down reports reached to the last level with all the necessary transactional details.
- Our implementation team identified the decisive values of the detailed application modules as well as the cross-module reports.
- Implemented the complex Oracle EBS Financial Statement Generator Dynamic Reports (Exclusive of Account Mapping File) to enable SAR to record business logic, and process accounting hierarchy updates with the reporting solution. This would eliminate user intervention as well as offer a dynamic reporting experience to their employees.
- We developed Oracle Analytics Cloud reports and dashboards and added them to a standardized repository, so they can be easily deployed as pre-built analytics in the future.
Play Video
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.
– Jone Does
Client, XYZ Company
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.
– Jone Does
Client, XYZ Company
Client, XYZ Company
Advantages of partnering with us
- USABILITY: Employees now could run ad hoc queries, quickly iterate, and improve existing applications.
- ADMINISTRATION: Wellington’s workload and daily management requirements were greatly simplified.
- SCALABILITY: The environment could now handle massive growth in user data from 5 TB to over 1 PB with little response time degradation.
- PERFORMANCE: Wellington saw a 2x improvement in query response times.
- AFFORDABILITY: Operating costs reduced significantly moving to AWS, and the migration was achieved efficiently, with better results, and over a shorter timeframe – resulting in an overall reduction of 24% in IT spending.
- The Results
The Outcome
With flexible cloud architecture, newly automated processes, and a modernized frontend, Wellington teams adopted a more agile development model. This critical piece of the firm’s digital transformation strategy enabled the development of over 250 new custom applications. Over 600 were optimized for AWS over the course of the project.
- The customer now has access to 80+ reports on Oracle Analytics Cloud on a single click.
- By automating the entire reporting solution, SAR has fully eliminated the manual efforts put in by its employees.
- We implemented a robust, centralized data warehouse, which can also be expanded to future data sources.
- For ad-hoc reporting, we implemented Self-Service Analytics for the business users.
- Implemented payroll and other similar cross-module reports standardized and improved their overall reporting processes.
- Using pre-built ETL solutions helped SAR enhance its system’s performance and scalability.
- The customer now has access to 80+ reports on Oracle Analytics Cloud on a single click.
- By automating the entire reporting solution, SAR has fully eliminated the manual efforts put in by its employees.
- We implemented a robust, centralized data warehouse, which can also be expanded to future data sources.
- For ad-hoc reporting, we implemented Self-Service Analytics for the business users.
- Implemented payroll and other similar cross-module reports standardized and improved their overall reporting processes.
- Using pre-built ETL solutions helped SAR enhance its system’s performance and scalability.
Streamline your business processes with
Why the Customer Chose Mastek
- Mastek vast experience in Analytics and Oracle Cloud.
- Our competitive implementation cost.
- Suitable technical proposal and great customer support that provided technical knowledge and assistance.
- We further provided consultation services to the customer and helped them prepare a long-term road map.
- Good reputation and long-term relationship with the Oracle sales team.
Oracle EPM Cloud Implementation Success Stories
Previous
Next
Decomplex
Customer Success
Decomplex
Customer Success
See how more enterprises rely on us to solve their most complex business problems.
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