About Client

SSGA used Netezza to run business-critical quantitative workloads for market pricing of funds. With Netezza reaching its end of life, the firm would have to restructure its capital pricing models.

Our company was engaged to build solutions that will provide performance benefits of pricing algorithms and allow for on-demand scalability of data.

Objectives

SSGA used Netezza to run business-critical quantitative workloads for market pricing of funds. ​

With Netezza reaching its end of life, the firm would have to restructure its capital pricing models. ​

Mastek was engaged to build solutions that will provide performance benefits of pricing algorithms and allow for on-demand scalability of data.


Project finished on time, on scope and on budget. Both the ERP and EPM streams are live and operational. Both end users and finance superusers (project team) are using the system in earnest and the associated benefits (of the new ERP) are already visible. A great accomplishment for both teams!

Being a remote implementation brought it own challenges, however your dedication and hard work made the difference.

–Client Project Manager


Project finished on time, on scope and on budget. Both the ERP and EPM streams are live and operational. Both end users and finance superusers (project team) are using the system in earnest and the associated benefits (of the new ERP) are already visible. A great accomplishment for both teams!

Being a remote implementation brought it own challenges, however your dedication and hard work made the difference.

– Client Project Manager

The Situation

A call to upgrade legacy HR systems

The legacy ERP solution from Workday that Viking had been using for its HR-related operations needed to be better aligned with HCM best practices, and made user-friendly for both employees and managers, This was critical to maintain accurate employee data for administrative and payroll efficiency, improve communication and reporting, and provide an open and transparent organisational view.

Further, with Workday solution nearing its expiration, continuity of support needed to be maintained. It was thus imperative that Viking migrated to a new HR system before the license expired.

Earlier, Viking had implemented Oracle Cloud Financials for their Order-to-cash and Procure-to-pay processes, and they were impressed by Oracle Cloud Applications’ ease of use, agility, and reduced operating costs. The organisation was thus keen to leverage the Oracle Cloud system for unifying their business processes.

Challenges

NHS England commissions South Central West (SCW) – as part of the CSU collaborative – to provide the Calculating Quality Reporting Service (CQRS) system to more than 6,000 GP practices across England. The system processes data which supports GP payments of up to £1billion per year.

With its current infrastructure, CQRS has issues with scalability, flexibility, interoperability and maintainability (with some software components soon reaching end of life). Users – including commissioners and GP practices – experience usability issues, which means it is more time-consuming and resource-intensive than necessary to complete their jobs.

The objective for this project was to support the organisation in their strategic planning and decision-making on the future service, through the delivery of an options appraisal at the end of the 10-week project.

  • Migrate Capital Pricing models from Netezza to a Scalable platform to meet SLAs.

  • Optimize core computational algorithms.

  • Migration requires advanced programming skills in R, Python, and Spark.

  • Migrate Capital Pricing models from Netezza to a Scalable platform to meet SLAs.

  • Optimize core computational algorithms.

  • Migration requires advanced programming skills in R, Python, and Spark.

A UK government department has a back-end tidal protection system, built using accurate and reliable data from the UK’s largest network of tidal stations. They need to make this prediction capability available as an API to developers across the UK using a subscription (paid and free) model.

About Client

The client is headquartered in New Zealand and invests in natural disaster research, education, and providing insurance to property owners for the damage caused by natural disasters like earthquakes, landslides, volcanic eruptions, hydrothermal activity, and tsunamis. They are committed to reducing the impact of natural disasters on people and communities.

The Challenge


Mastek’s project team was professional and friendly to interact with. Our teams worked very well together and were able to get to know each other on a bit of a personal level as we worked through open issues. The team was responsive to questions and issues as they arose and worked closely with Oracle to resolve open questions, keeping us updated along the way.

– Melissa Lighthall
Global People Project Director, Digital People Solutions at Arcadis U.S., Inc.

There was no mechanism to interact with enterprise data.  Store associates did not have a way to look up customer profile, purchase history, loyalty points, rewards, coupons, offers, etc.

Business Benefits

Why Mastek?

We started by interviewing and observing 50 people, from front line staff to those responsible for policy and strategy. This was followed up with surveys and data analysis to understand and validate the thoughts and behaviours of several hundred more people.

We identified the main user needs, and focused on where we could deliver most value – helping people undertake the tasks.

A number of prototypes were created and tested in usability studies with end-users; this gave us the insight we needed to keep the interface as optimal as possible, and get the right information in front of users at the right point in their journey.

We carried out a private beta trial after passing the GDS assessment, and used this insight to create further prototypes for testing. 

Throughout the project, we kept people informed and engaged through in-situ change messaging and regular show-and-tells.

  • Proven expertise and deep knowledge in migrating from Netezza to AWS Redshift.
  • Strong experience with performance optimization of pricing algorithms.
  • Proof of Concept to establish the right architecture and environment.

Using their proprietary Glide framework and ADOPT (Advisory, Design, Orchestrate, Prepare, Transition) methodology for the Oracle implementation, Mastek ensured automated and seamless integration without errors and customized roles and access enabled efficient reporting and inquiry access without incurring additional license cost.

Why Mastek?

We started by interviewing and observing 50 people, from front line staff to those responsible for policy and strategy. This was followed up with surveys and data analysis to understand and validate the thoughts and behaviours of several hundred more people.

We identified the main user needs, and focused on where we could deliver most value – helping people undertake the tasks.

A number of prototypes were created and tested in usability studies with end-users; this gave us the insight we needed to keep the interface as optimal as possible, and get the right information in front of users at the right point in their journey.

We carried out a private beta trial after passing the GDS assessment, and used this insight to create further prototypes for testing. 

Throughout the project, we kept people informed and engaged through in-situ change messaging and regular show-and-tells.

  • Proven expertise and deep knowledge in migrating from Netezza to AWS Redshift.
  • Strong experience with performance optimization of pricing algorithms.
  • Proof of Concept to establish the right architecture and environment.

Using their proprietary Glide framework and ADOPT (Advisory, Design, Orchestrate, Prepare, Transition) methodology for the Oracle implementation, Mastek ensured automated and seamless integration without errors and customized roles and access enabled efficient reporting and inquiry access without incurring additional license cost.

Play Video

Mastek’s project team was professional and friendly to interact with. Our teams worked very well together and were able to get to know each other on a bit of a personal level as we worked through open issues. The team was responsive to questions and issues as they arose and worked closely with Oracle to resolve open questions, keeping us updated along the way.

– Melissa Lighthall
Global People Project Director, Digital People Solutions at Arcadis U.S., Inc.

Benefits

  • Plug-and-play integration build for multiple POS such as Micros, Opera and Fosse made it possible to have a simplified cash overview process. It also helped with the analysis of revenue and cost for each service provided.  

  • Established a catalogue-based procurement cycle (Punch Outs).  

  • With the new Oracle ERP Cloud system in place, it was easy and secure to conduct an end-to-end tracking of expense reimbursements. 

  • Oracle ERP Cloud system was customized and automated to generate auto-bank reconciliations; reports on revenue per available room (REVPAR), average daily rate (ADR), flow through which is operating profit % for additional revenue earned compared to budget; and tracking of fixed assets specific to location. 

  • We built a customized interactive dashboard for budget vs actual analysis. They were also able to have a real-time financial statement generation.

  • Plug-and-play integration build for multiple POS such as Micros, Opera and Fosse made it possible to have a simplified cash overview process. It also helped with the analysis of revenue and cost for each service provided.  

  • Established a catalogue-based procurement cycle (Punch Outs).  

  • With the new Oracle ERP Cloud system in place, it was easy and secure to conduct an end-to-end tracking of expense reimbursements. 

  • Oracle ERP Cloud system was customized and automated to generate auto-bank reconciliations; reports on revenue per available room (REVPAR), average daily rate (ADR), flow through which is operating profit % for additional revenue earned compared to budget; and tracking of fixed assets specific to location. 

  • We built a customized interactive dashboard for budget vs actual analysis. They were also able to have a real-time financial statement generation.

What we did

We supplied a multidisciplinary team, including architects, service designers and user researchers.

Through a series of targeted technical and service design workshops, we delved into strategic areas that promised significant potential outcomes, as well as those with relatively smaller impact but more straightforward solutions. Throughout the process, we maintained an ongoing feedback loop with the teams, facilitating adjustments and refinements as needed.

We also conducted in-depth user research with commissioners and GP practice managers, data analysis and an expert infrastructure review to understand and map the ‘as is’ ecosystem, and to identify pain points and opportunities. 

We used this baseline to propose three options that address infrastructure issues, user needs and business needs. Our recommendations included an ideal future state as well as transitional models to enable an informed approach to decision-making by the client. 

Benefits

The client was very pleased with the work, and they are moving ahead with our recommendations for technical system changes. This enables them to make critical and time-sensitive infrastructure changes that will ensure service continuity when parts of their tech stack reach end-of-life.

  • On-demand and scalability of AWS EC2 allowed the business division to evaluate trading risk before the market opened.

  • Affordability – 10% reduction in server and storage costs (~$1.5M/year).

  • Agile Processing – Implemented a re-usable framework and self-service utility.

For the first deployment, in a city that averages 60,000 violations per day with multiple images per violation – Volteo Edge’s solution relays over 100 alerts per day to Verra that would otherwise have been missed. The 14 people who had been tasked with image quality control were reassigned to more productive work. Due to its effectiveness, the solution is set to be expanded to Vera Mobility’s newly acquired business entities and customers as well. 

  • On-demand and scalability of AWS EC2 allowed the business division to evaluate trading risk before the market opened.

  • Affordability – 10% reduction in server and storage costs (~$1.5M/year).

  • Agile Processing – Implemented a re-usable framework and self-service utility.

The solution helped Intel to provide its employees with a more pleasant and productive work environment, from ensuring energy-efficient environmental controls to the avoidance of frustrations associated with parking and cafeteria queues or searching for workspaces, resulting in improved employee retention.

Streamline your business processes with

Oracle EPM Cloud

Oracle EPM Cloud Implementation Success Stories

Decomplex
Customer Success

Decomplex
Customer Success

See how more enterprises rely on us to solve their most complex business problems.
Looking for a trusted partner who will decomplex digital?