Categories
Case studies Partners

AWS Select Tier Consulting Partner

AWS Select Tier Consulting Partner

AWS Select Tier Consulting Partner

Unico has been recognised by Amazon Web Services (AWS) as a Select Tier Consulting Partner in the AWS Partner Network (APN).

As an AWS Select Tier trusted partner, our team leverages AWS products, and services to provide cloud solutions and advisory services to our customers. Unico is proud to be recognised for our specialised cloud services and technical proficiency in cloud deployment, and management.   

We are thrilled about advancing to the Select-Tier Consulting Partner level. This will enable us to continue to provide quality AWS cloud solutions to our customers and assist them on their cloud transformation journey.

Ramnik Singh, Partner Manager

Our AWS speciality areas:

If you are interested in finding out more please contact:

Ramnik Singh

Business Development Manager

Categories
Case studies Partners

Oracle MySQL database replication for senior government office

Oracle MySQL database replication for senior government office

How Unico is supporting a senior government office review architecture and configuration in light of some recent operational issues (Oracle MySQL database replication) and their roadmap.


Summary:

  • Updated configuration
  • Provided MOP (method of procedure) to implement and enable the new configuration
  • Supported the senior office with implementation and support.

Oracle MySQL referred us to this piece of work as we are a trusted and long-standing partner. A senior government office engaged Unico to review their architecture and configuration in light of some recent operational issues (Oracle MySQL database replication) and their roadmap.

We conducted interview workshops to clarify initial requirements, reviewed architecture and configuration, revised configuration and articulated implementation steps including a future roadmap.  

Our team delivered an updated configuration, a MOP to implement and enabled the new configuration and supported the office with the implementation and support including technical queries and troubleshooting.

Replication was successfully re-instated and operational across the Oracle MySQL cluster. A high-level technical assessment of future work items including an Oracle MySQL version upgrade, cluster upgrade, and traffic balancing was also considered.

Brent Wijnberg

Business Development Manager

+61 3 9865 9179

Categories
Case studies Partners

Building a Multi-Club database and shared scheduling platform: Racing Victoria

multi-club database for Racing Victoria though Salesforce Marketing Cloud business units

Building a Multi-Club database and shared scheduling platform: Racing Victoria

How Unico engineered a custom marketing cloud business unit database and shared scheduling platform that enabled Racing Victoria to conduct collaborative events and marketing campaigns.


Summary:  

  • Data engineering and platform development 
  • Salesforce Marketing Cloud (SFMC) integration and consulting
  • Data cleaning, reorganisation and subscriber management
  • LIVE shared calendar scheduling

The Victorian racing industry is made up of sixty nine metropolitan and country tracks and five clubs, hosting over 500 race meetings a year. They are regulated by Racing Victoria. 

Each operates independently, hosts race meetings, manage members and run independent marketing and advertising campaigns with siloed customer data sets.

Consequently, clubs would promote events and race meetings to owners and customers over the same period resulting in scheduling clashes. 

Race meeting overlap leads to three distinct challenges for clubs:

1. Attendees are split between race meetings resulting in lost revenue. 

2. Wasted media spend due to prospects receiving marketing communications for multiple racing meetings scheduled on the same weekend. 

3. The best horses are split across race meetings resulting in lower quality horse talent. 

Racing Victoria recognised that a lack of visibility across race schedules and customer databases was a significant barrier to effective collaboration between clubs. They needed a way to unify their customer data and event scheduling without violating data privacy. 

Racing Victoria’s annual All-Star Mile, an interclub fan voted race meeting, presented the perfect opportunity for Racing Victoria and Unico to develop a multi-club database and live shared scheduling module. 

shared calendar scheduling
Club members were being invited to race events scheduled over the same time period.

The solution is powered by Salesforce Marketing Cloud business units and comprises of: 

  • Shared customer database comprising of five linked salesforce marketing cloud business units, one for each club and regulator.  
  • Local and shared data extensions allowing for layered access to shared customer data sets for marketing campaigns – information includes name, email, postcode, and category (owner, trainer, member etc.). 
  • Hierarchical data structure with a single master control over local data sharing permissions. 
  • Subscription management – enabling club members to opt-in and out of specific marketing email communications depending on preferences. 
  • A custom preference centre allowing users to choose which clubs they want to receive email communications from, as well as opt-in to specific campaigns of interest such as dining events or race meetings.  
  • A custom unsubscribe function that ensures unsubscribed contacts are removed from all lists. 
  • A live multi-club shared calendar accessible to all salesforce marketing cloud business units. 
  • Construction and automation of customer journeys for the annual race meeting calendar for Victoria. 

Racing Victoria’s new multi-club database improved club coordination by enabling collaborative events and marketing campaigns. 

The platform has helped Victorian horse racing clubs and tracks work better together, advancing the interest of Australian racing and creating a partnership mindset across the state.  

This solution has a highly accurate database, adheres to high standards of customer privacy and security, and boosted Racing Victoria’s revenue potential through parallel marketing streams. 


Unico have extensive experience using technology to enhance animal welfare outcomes as well as support traceability, regulation and member engagement.

Speak with one of our specialists today to find out more. 

Evan-Harridge

Evan Harridge

Director of Innovation

Categories
Case studies Partners

Modernising a regulatory audit and booking system using process digitisation: Intralot

Modernising a regulatory audit and booking system using process digitisation: Intralot

Utilising process digitisation and platform development to transform legacy regulatory systems.


Summary:  

  • Process digitisation 
  • Web portal for audit tracking
  • UI & UX design

Intralot is a global lottery and sports betting operator that monitors pokie machines in Victoria on behalf of the state government

Monitoring of these machines is crucial to protect gambling integrity and ensure compliance with state regulatory requirements at venues. Audits of machines are conducted regularly to check for compliance breaches and record installation.

Historically, Intralot relied on a manual Microsoft excel based system to record booked audits, machine installations and data entry.  This resulted in:

1. Inefficient and time-consuming manual data entry

2. Vulnerabilities to compliance breaches due to human error

3. Large amounts of unstructured data due to manual processes

4. Difficulty coordinating large teams across different vendors and casinos

Intralot engaged Unico to support the digitalisation of manual processes and develop a new online booking portal to accurately and effectively record audits and installation of machines.

Our solution delivered:

  • Process digitisation, eliminating manual data translation from vendor information into the legacy case management control system (CMCS)
  • Web based portal to track data entry and audits of machines
  • Real time viewing of upcoming deployment activities and reports on historical data
  • Automated management of business rules about deployments
  • Overall improvements in lead times for deployment activities
  • The utilisation of Oracle database, Amazon Web Services servers and JAVA script
  • Solution architecture that enabled historical record keeping of machine installations, maintenance and monitoring incidences

“Our project had very specific quality requirements, strict regulator frameworks and tight deadlines. The technical delivery team execution was excellent, and they very clearly understood the end goal.”

Basu Gowda, Program Manager, Intralot

Digitising these processes has made it easier for Intralot to ensure machine compliance, accurate record keeping and traceability for more effective planning of future audits.

Unico continues to provide support and regular governance to Intralot, ensuring new machine vendors are onboarded seamlessly.


If you are interested in our digital transformation capabilities get in touch below.

Ramnik Singh

Business Development Manager

Categories
Business update Partners

The largest Oracle MySQL NDB Cluster in the Southern Hemisphere

The largest Oracle MySQL NDB Cluster in the Southern Hemisphere

When one of Australia’s largest telecommunications providers needed a new mission-critical platform for provisioning millions of mobile, fixed, and broadband services, they turned to us – Australia’s leading Oracle MySQL technology partner – to develop a solution.

We developed an “always on technology” mobile provisioning and fixed service orchestration solution that deployed the largest Oracle MySQL NDB Cluster in the Southern Hemisphere.

The solution stores millions of services and involves:

  • Taking provisioning orders from multiple CRMs and orchestrating these orders across many network devices to activate fixed and mobile services.
  • Maintaining a comprehensive service inventory of customer network data that is used throughout the provisioning process.
  • Complex service and cross service orchestration when provisioning these services into various network systems.
  • Zero touch provisioning, with self-healing through existing state determination and use of automated retry with no manual intervention.
  • Fully configurable so new services and devices can be added as needed.

Oracle MySQL enabled us to deliver a single centralised database for all service inventory data resulting in significant cost savings. These solutions incorporated the MySQL database and have benefitted extensively from its function, performance, and reliability.

We have been working with Oracle MySQL for over ten years, resulting in numerous highly complex mission critical technology solutions. We have also deployed the Oracle Communications Service Gateway (OCSG) into a leading Australian Telco to provide a ‘Network As A Service’ (NaaS) gateway.

Categories
Insights Partners

The future of the workplace – New ways of working and what it means for businesses and commercial real estate

The future of the workplace – New ways of working and what it means for businesses and commercial real estate

2020 was the year that redefined the way we work and shaped the future of the workplace. The global pandemic resulted in dramatic shifts in how businesses operate, and how people are safely managed across shared spaces. As we near the end of FY21, hope is on the horizon with vaccine rollouts in progress around the world.

However, international peaks in COVID-19 cases, second waves, vaccine supply concerns and the threat of new strains indicate there is a significant degree of unpredictability and health concerns to manage for years to come, and long-term impacts to consider.

Distinct changes in office behaviour and protocol once born out of necessity have given way to more enduring shifts in workplace policy that will outlast COVID-19.

The global pandemic has changed the way we work for good. Companies have not only pivoted to an immediate existential threat; they have reconsidered how they function and operate


Erica Volini , Global Human Capital Leader,  Deloitte

How is the way we work changing?

Initially, most businesses were thrust into remote working scenarios due to safety concerns surrounding a world amid a global health crisis.

Although the pandemic endures, and the public health impact will continue, there is growing evidence to suggest COVID-19 has permanently changed employer and employee expectations around the way we work. Employees are no longer married to the concept of working in the office five days a week. Fundamentally, this is the future of the workplace.

The removal of strict in office attendance requirements and presentism has blown open traditional recruitment that has been restricted to location and inner city talent pools. At Unico, we have seen firsthand that the widespread acceptance of remote working has opened up the job market, allowing us to employ team members in locations where we don’t typically operate.

A 2021 Roy Morgan Research poll found that in Melbourne alone three quarters of city workers are reluctant to go back to work full time. The same poll found more than 30% of respondents would prefer to work mostly from home and 42% would like some regular days in the office. Roy Morgan’s research also found that in January 2021 CBD traffic had reduced by 72% in Melbourne and 66% in Sydney compared to the same time last year.

On a global scale, recent data from Linkedin’s Workforce Confidence Index showed 47% of US professionals believe their companies will allow them to work remotely, at least partially after the coronavirus pandemic subsides. Employees in tech and finance had even greater expectations of flexibility with 73% and 67% of individuals respectively sharing this belief.

As workers have experienced the extra time and flexibility working from home affords, their desire for a ‘flexible working model’ has continued to grow. Documented benefits to working from home include flexibility to juggle life, creating work-life balance, limiting distractions, and home based child care. Exposure to a new way of working has undoubtedly changed the way staff work and employers need to listen.

Employees will demand greater flexibility and organisations will require it


Ashley Williams, Assistant Professor – Harvard Business School

In July 2020 a Gartner survey amongst global business leaders revealed 82% of respondents plan to allow employees to work remotely some of the time. Experimentation with remote working has proven these work models can work effectively in certain scenarios and build more resilient business operations. Companies are beginning to apply a more agile and creative mindset to work policies and realise the employee experience is not necessarily limited to a traditional office environment.

Big tech is leading the charge with giants like Facebook, Microsoft, and Salesforce embracing flexible work models. Salesforce recently declared the “9-to-5 workday dead” and cited the employee experience as being “more than ping-pong tables and snacks”.

In our always-on, always-connected world, it no longer makes sense to expect employees to work an eight-hour shift and do their jobs successfully


Brent Hyder – Head of HR – Salesforce

Salesforce’s Head of HR Brent Hyder emphasised that workers need ‘flexibility to be successful’ which means striking a balance between personal and professional obligations. For many companies embracing this philosophy could mean the difference between losing or retaining their best talent as flexible working fast becomes the norm, not the exception.

One of the most popular models that are being embedded into corporate life is the 3-2-2 model or flex work model. This model allows employees to come into the office one to three days a week with a typical focus on collaborative tasks, customer meetings, and presentations. Research indicates that models such as these offer many benefits to both employees and employers.

Flexible work policies also act as an effective tool for improving employee engagement through empowerment and indicating respect. Those engaged with their jobs miss fewer days of work, have less turnover, and have improved career longevity. Engagement is a proven way business leaders can improve the KPI’s of their employees if they proactively work at it. Years of Gallup research has shown that when employees are engaged their performance improves dramatically, highly engaged workplaces can claim 41% lower absenteeism, 40% fewer quality defects, and 21% higher profitability.

What does that mean for the future of the workplace? How does this affect businesses reassessing their workplace needs and the wider commercial real estate market?

In Australia alone, it is forecast that in 2021 half of all office workers will spend two days at home. Consequently, a fall in net demand for office space of up to 5% will be triggered. Similarly, Gartner found an increase in remote working due to flexible working policies will allow some organisations to support up to 40% more workers in the same amount of space they use today.

These statistics indicate some significant shifts in commercial real estate for businesses which can be separated into two key areas:

1) A surplus of space in existing tenancies will drive down demand for larger office spaces

Due to changes in workplace norms many tenants will reduce their leased space needs as they expire and renewals transpire or slow demand as surplus capacity is absorbed. Businesses may even make the shift to smaller, cheaper premises without necessarily reducing the size of their workforce. To persuade tenants who are not set on changing their lease, property operators and developers will have to provide additional value to convince them to stay. A marketable point of difference for building owners will make leasable spaces more appealing for both new and existing tenants. This could come in the form of IoT-enabled SMART spaces and technology that can enhance the tenant experience and protect staff. Such technology can be offered in the form of tailored tenancy packages.

2) A need to manage a dynamic flow of people in and out of the office

As flexible working becomes increasingly normalised, challenges emerge for businesses seeking to manage staff across multiple sites and environments. A consistent flow of staff in and out of the office will be highly demanding for HR departments and management as well as a strain on company resources. From workforce planning and coordination to asset booking and desk allocation, there is a range of tasks that will be made overly difficult due to flexible working.

Shifts to a hybrid way of working will involve remote and on-site staff having to collaborate together virtually and physically, often simultaneously. Ensuring high quality audio visual facilities exist in offices will be crucial for businesses seeking to maintain the benefits of flexible working without sacrificing productivity or creativity.

Hot-desking once declared dead, will now become essential for many larger businesses looking to support a flexible workplace that allows for a dynamic flow of people. In a world beset by COVID-19 tracking, managing, and protecting staff compliantly is crucial but unnecessarily complex without the right tools.

Technology is the answer to the future of the workplace. Workplace management platforms, software, and the data-gathering potential of IoT offer a highly effective solution for these challenges when combined.

What next?

COVID-19 has led to enduring changes that have changed how we work and how we use our spaces. The new normal is flexible working. It is hot desking. It is creating a safe environment for our team. It is being supportive of employee wellbeing.

Whenever a major external event forces us to change, new opportunities and challenges emerge. Businesses have to grapple with change and technology is the best resource to effectively and efficiently deliver the results needed.

If you are interested in what your future workplace could look like, or how technology can help you prepare for flexible working we are happy to guide you through our technology solutions including JourneyHub.

Head of Innovation

Categories
Insights Media Partners

All-Star Mile voting shows horse racing continues to strengthen female audience

All-Star Mile voting shows horse racing continues to strengthen female audience

Highly secure website and All-Star Mile voting platform with a validation rate of 96.4%


Unico is proud to have supported Racing Victoria deliver their vision for the All-Star Mile for three consecutive years. The All-Star Mile is the world’s richest mile and the only race where the Australian public choose who races on the day.

Racing Victoria and Unico collaborated to create a highly secure website and All-Star Mile voting platform that is auto-scaling, auto-healing with cloud-first design, and the ability to handle high levels of user traffic. Unico is proud to announce for the third year that a Big 4 Advisory firm’s Cyber Security team were unable to penetrate the platform and a validation rate of 96.4% was achieved through SMS verification codes and Salesforce marketing cloud campaigns.  

The All-Star Mile was designed to attract a new and more diverse audience, which was achieved for the second year in a row with over 32% female voters. This could not have been delivered without the teamwork and collaboration between Racing Victoria and Unico – our team more than halved the number of unverified votes from last year worked on tight deadlines and had to adapt to meet regulatory constraints” Racing Victoria GM Customer Strategy & Engagement Marcia Allan.

This year’s All-Star Mile continued to engage fans with 10 wildcard Owner Ambassadors who shared a prize pool of $500,000, with Matt Fory from Shepparton taking home the top $250,000 prize alongside winner Mugatoo.

If you would like to find out more about Unico’s All Star Mile secure website and voting platform, please contact Evan Harridge.


Evan Harridge

Director Innovation

Categories
Case studies Partners

Australia’s first entitlement server eSIM solution for wearable device compatibility: uPair

UPair-1

Australia’s first entitlement server eSIM solution for wearable device compatibility: uPair 

One number, one service. An entitlement server eSIM solution that allows Telco network customers to use the built-in cellular capability of their wearable technology. 


Summary

  • An easy to integrate, low entry cost entitlement server solution ready to implement for all Telcos
  • Compatible with Apple & Samsung devices
  • High availability, low latency and fault-tolerant provisioning system
  • CRM integration and customer entitlement management 
  • Built in multiple edge case scenario capability & ACID compliance
  • Utilised an Oracle MySQL database

Many Telcos don’t have the budget, resources or knowledge to develop an entitlement server solution for their own business.

That means they are missing out on crucial new streams of revenue that can be gained from charging customers for value-added services.

Entitlement server solutions are used to allow users to connect multiple SIM and eSIM enabled devices to one number and service. This connection can be bundled into a subscription package where pairing capability is offered via mobile app.

Our solution uPair gives lower tier Telcos the ability to compete with Tier 1 Telcos by offering their customers wearable tech pairing at a low cost of entry.

Unico partnered with Australia’s largest mobile service provider who needed an application that allowed Australians to use the built in cellular capability of the new ‘Apple watch’ (GPS + Cellular) .

In doing so Unico were the first in Australia to develop an eSIM solution that supported wearable device compatibility.  

uPair eSIM solution developed by Unico

By integrating this entitlement solution our customer could share a single service with a mobile device through sharing accurate subscriber identification information with their network.

Our client was equipped with a telco grade, real-time and high availability entitlement server solution that enabled them to offer value-added services to their customers.


uPair was able to meet the needs of a world-class telecomms provider and deliver a world first in eSIM technology.

– John Rowland, Managing Director, Unico


The project included provisioning and enabling of the eSIM for the Apple Watch to download and update its network whilst allowing paired devices to operate with a ‘shared number’ service. The partnership marked the first time an eSIM technology had been delivered to the Australian consumer market.  

Thanks to uPair thousands of Australians are connected to Australia’s biggest mobile network for phone calls and messages via their wearable devices

If you are interested and want to find out more get in touch below and talk to us today.

Jason Bodsworth

Business Development Manager

Categories
Case studies Partners

Creating a one-to-one customer experience through Salesforce Marketing Cloud: Cargill Australia

Sales-Force-Marketing-Cloud

Creating a one-to-one customer experience through Salesforce Marketing Cloud: Cargill Australia

How Unico helped a global food provider communicate more directly with Australian farmers using Salesforce Marketing Cloud (SFMC).


Customer

  • Cargill Australia

Project

  • Enhance communication with farmers on market conditions using Salesforce Marketing Cloud

Objectives

  • Allow Cargill Australia to send targeted, personalised messages to its contacts 
  • Create elaborate customer journeys and communication campaigns with relevant stakeholders  

Approach

  • Targeted consulting in Cargill Australia’s prioritised areas 

Outcome

  • Tailored customer journeys designed to fit the business requirements for all subscribers 
  • New personalised, direct communications capabilities with subscribers 
  • Managed and authenticated a subscriber list of over 50,000 contacts  

Cargill Australia have a large database of contacts in Salesforce Marketing Cloud who they regularly send emails and text messages regarding crop pricing and market conditions. Without marketing automation enabled through SFMC, they could not create and send personalised emails to key stakeholders and customers at scale. Consequently, Cargill Australia would conduct untargeted email campaigns carrying irrelevant information to broad customer segments. 

During our engagement with Cargill Australia we helped build journeys and campaigns for all existing customers within their database. This included designing interactive email campaigns containing cloud hosted crop surveys that were able to deliver data to Cargill Australia regarding estimated crop sizes and harvest dates. Collated data was able to drive campaigns that contained useful and timely information sent in alignment with crop harvesting and growth cycles. This data could be utilised by farmers to better manage their crop.

Increased efficiency in communications has been beneficial for both Cargill Australia and their contacts as they now have access to important agricultural data when they need it most.


Through the utilisation of crop survey emails, we were also able to authenticate Cargill Australia’s contact database to ensure that all customer data was accurate and clean.

Our partnership with Cargill Australia has boosted their confidence in what they can achieve with Salesforce Marketing Cloud. Unico’s ongoing consultation has empowered their team to utilise SFMC to map out custom journeys and campaigns for their entire contact base.


Evan-Harridge

Evan Harridge

Director of Innovation

Categories
Case studies Partners

Maximising ROI on marketing automation campaigns through data cleansing: Racing Victoria

Maximising ROI on automated marketing campaigns through data cleansing: Racing Victoria

How we helped Racing Victoria regain trust in their customer data by building a custom data cleansing extension to extract and cleanse duplicated Salesforce Marketing Cloud contacts.


Summary

  • Salesforce Marketing Cloud (SFMC) campaigns and data cleansing services
  • Identification and removal of duplicate SFMC contacts 
  • Ensure all MRC’s contacts and leads are listed with 100% accuracy 
  • Reduction of salesforce contract renewal fees    

Metrics

  • Removed 400,000 corrupted / duplicate contacts from database of over 1,000,000 
  • Saved RV $100,000 in costs over a 2-year contract renewal period  

A major part to conducting an effective automated messaging campaign is whether you can trust your data. Campaign results can vary drastically return in investment (ROI) based on how accurate the Salesforce database of contacts is. Racing Victoria (RV) had a database of over 1,000,000 contacts which contained a significant number of duplicates and corrupted data. In a 2-week engagement Unico cleansed their database of any duplicate contacts or outdated contacts that were no longer being targeted by email or SMS content. 

The data was extracted to a data extension where comparative testing was conducted to verify that contacts were classified as duplicates before deletion. Ensuring that a contact database is rid of all non-validated contacts means messaging automation platforms like SFMC charge users based on the true size of their contact list. 


“Contact database authentication was a major focus for Racing Victoria as our number of contacts continued to grow. Unico was able to enable us to have complete trust in our data within just two weeks and provided immediate ROI through this engagement”

– Marcia Allan, GM Customer Strategy & Engagement, Racing Victoria.


Following the data cleansing of Racing Victoria’s contact database, over 400,000 entries were removed resulting in over $100,000 of saved contract renewal costs. This was four times the cost of the Unico engagement, resulting in significant ROI for RV and clear value add.


Evan-Harridge

Evan Harridge

Director of Innovation

X