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.
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.
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.
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.
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 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.
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 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.
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.
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.
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.
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.
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?
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.
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.
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.
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.
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.
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.
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).
Enhance communication with farmers on market conditions using Salesforce Marketing Cloud
Allow Cargill Australia to send targeted, personalised messages to its contacts
Create elaborate customer journeys and communication campaigns with relevant stakeholders
Targeted consulting in Cargill Australia’s prioritised areas
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.
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
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.