Skip to main content
Get in touch
BLOG

A walkthrough of Annexa’s winning Hackathon 4Good entry (SuiteWorld 2024)

A walkthrough of Annexa’s winning Hackathon 4Good entry (SuiteWorld 2024)
Published on 24th September 2024

For NetSuite developers and system architects, few events are as eagerly anticipated as the annual SuiteWorld Hackathon 4Good. This competition draws together some of the brightest minds in the NetSuite universe to develop new and innovative solutions for not-for-profit organisations.

This year, Annexa took part for the first time and stood out by clinching the top prize with a solution that promises to drive greater impact in bird conservation efforts.

Below, we provide a detailed technical rundown of the winning solution and how it is designed to revolutionise conservation work for the American Bird Conservancy. You can also read NetSuite’s rundown of the event here.

The challenge and the team

The Team: Raygun

Annexa’s Director, Jarred Spriggs, and Bart Wadley, Annexa Solution Architect, joined forces with two fellow Aussie NetSuite professionals – Tim Pilgrim at SuiteFunction and Shannon Barratt, Head of ICT at Abco Products – to take on this challenge.

The customer

American Bird Conservancy (ABC) is dedicated to conserving wild birds and their habitats throughout the Americas. With an emphasis on achieving results and working in partnership, ABC takes on the greatest problems facing birds today, innovating and building on rapid advancements in science to prevent bird extinctions, reverse bird population declines, reduce threats to all birds, and build the bird conservation movement.

They are currently implementing a large-scale vision to conserve the next 10 million acres of bird habitat, which they’re calling the 10 million Acre Challenge.

The brief

Create a project priority list for American Bird Conservancy to optimize impact based on bird risk levels, bird population density, and associated conservation costs. Each team must produce:

  • A working mathematical model in Oracle Cloud Infrastructure (OCI) which calculates a priority score for each of ABC’s projects
  • A report within NetSuite for ABC to see the list of projects by priority with relevant details

Crafting a winning solution

The competition began on August 19, 2024, giving teams a few weeks to prepare and build a strong foundation prior to SuiteWorld in Las Vegas.

From the outset, the Annexa team understood the importance of integrating technical excellence with customer-centric design. The solution had to do more than just make sense of data – it needed to provide actionable, accessible insights that could guide ABC’s conservation efforts.

Data integration and modelling

On August 26, each team was given the full dataset, which included:

  • Species data: Included ACAD regional and global data on species population decline, breeding seasons, and their status (e.g., critically endangered).
  • ABC data: Included a species risk index, cost data for habitat creation (e.g., tree planting), current conservation projects, and associated activities.

This allowed the team to get to work and be ready at SuiteWorld with:

  • A working model in OCI which calculates a priority score for each of ABC’s projects
  • An idea of how to create the project priority report within NetSuite

Refining through feedback and collaboration

On the first day of SuiteWorld, each Hackathon team had the opportunity to engage with the customer and machine learning experts to refine their solutions. These feedback sessions gave further access to insights that could help enhance the model’s accuracy and user interface. During this time, Annexa worked directly with the customer to validate their findings and ensure their solution addressed the prototype’s key objectives – scalability, accuracy, ease of use, and the elimination of bottlenecks.

From there, Jarred Spriggs continued to lead the technical development. This involved carefully considering how data processed within OCI would interact with NetSuite to create seamless interactions between these technical elements and the customer-facing components within NetSuite.

Meanwhile, Bart Wadley concentrated on the NetSuite interface, ensuring it was user-friendly and aligned with the customer’s needs. The team’s rapid iteration process allowed them to refine their predictive models and user interactions, creating a seamless solution that met the customer’s requirements.

Annexa then refined their relational data model to connect various data points, including grants, sub-awards, projects, activities, and species impact. This created a comprehensive scoring system by linking data elements like species impact, habitat conditions, and financial metrics.

A flexible and usable solution for ABC

This detailed, reporting solution aimed to provide the American Bird Conservancy with actionable insights, helping them prioritise projects in a more strategic and impactful way.

By evaluating factors such as bird population data, habitat conditions, and financial metrics, the prototype was designed to effectively rank and prioritise conservation projects. Importantly, this approach would enable the tracking of birds and habitats, but also link these elements to conservation activities and available grants.

Prototype highlights

  • Customisable scoring: The model allowed the customer to adjust the weighting of each metric to tailor the scoring according to their priorities.
  • Data Automation: The solution automated data extraction from NetSuite into the Oracle Cloud Infrastructure (OCI) model, enabling real-time adjustments and insights.
  • NetSuite reporting: The solution was integrated into NetSuite to provide a comprehensive reporting dashboard with insights into specific details like habitat, species impacted, and financial metrics.
  • User-friendly interface: The solution was designed to allow users to easily filter and segment information, and view projects in different contexts.
  • Real-time insights: The scoring model was updated back into NetSuite, enabling conservationists to make informed, real-time decisions.
  • Data unification: Unifying siloed data from various departments within ABC, the solution provided a cohesive system for project ranking and resource allocation.
  • Scalability and future initiatives: The solution could be further complemented with NetSuite Analytics, Planning and Budgeting, and automation from OCI.

The presentation and winning moment

On day two of SuiteWorld, each team presented their solutions to a panel of judges, which included experts from Oracle NetSuite and representatives from the American Bird Conservancy.

The team’s presentation demonstrated how their AI/ML-powered solution delivered accurate forecasts while enhancing the user experience within NetSuite. They emphasised the solution’s user-friendly design, precision in predicting project impact, and scalability.

The participation experience

Jarred Spriggs, a key participant in the Annexa team, shared his perspective on the experience:

“This being my fifth NetSuite SuiteWorld Conference, I’ve always wanted to give back and contribute to not-for-profits using my technical skills and knowledge. I saw this as a great opportunity to help and make a meaningful contribution through the Hackathon 4Good. I wasn’t quite prepared for just how detailed the challenge would be, especially as it pushed us beyond our core skill set – building mathematical models outside of NetSuite in OCI. It was a real challenge, but it was also great to get the mind working on something so complex.”

Reflecting on the team’s success in winning the Hackathon 4Good, Jarred added:

“We really listened to the customer on the day, and we asked the right questions – What’s important to you? How do you rank your projects? How do you allocate funds? How do you know if the species is important to protect or not? So, we really drilled down into how they do their job day-to-day to then make the model and the application do that for them.

Then we took our entry in a direction that really prioritised usability for the customer. It wasn’t just about creating a mathematical model for ranking, it was about providing real insights through their NetSuite dashboard. This has helped them to rank projects, drill down into specific details, and sort and segment the information to support their financial and operational decisions.”

The impact and beyond

The Hackathon 4Good highlighted how not-for-profits can harness their data within the NetSuite ecosystem to drive meaningful change. For ABC, they are already set on engaging the team to deploy their winning solution. It also serves as a compelling example of how NetSuite’s extensible cloud ERP platform, with embedded AI and ML, can be a powerful force for good.

Ready for a NetSuite partner who can help propel your mission?

If you’re a not-for-profit considering NetSuite, Annexa can help amplify your impact. We design and develop powerful NetSuite solutions that enable you to respond swiftly to changing financial conditions, measure program impact, and adjust strategies to maximise effectiveness.

Contact Annexa today.

Learn more:

 

Stay updated with Annexa