James Troi

Senior Developer

About

With more than 30 years of experience creating website and database solutions, I have witnessed the incredible growth of the web and evolved alongside it. I am a full-stack developer, possessing the skills and experience to deliver end-to-end web solutions.

I am a detail-oriented individual with a passion for people and information management. My longevity in the web development space stems from an insatiable curiosity and desire to learn. In this ever-evolving field, there's always a new opportunity to broaden my knowledge.

My diverse interests and experience in photography, audio, and video work are assets in web development. Websites today are multimedia endeavours, and my additional skills allow me to see beyond just the text on a screen.

In recent years, I've focused on creating and providing custom content management systems. Yet, I have extensive experience with various CMS solutions and web publishing platforms such as WordPress, Drupal, Shopify, and Squarespace. I easily adapt to new technologies, using whatever tools are available to deliver effective solutions.

I pride myself on my ability to work well with individuals from all backgrounds and across multiple business units. I excel at gathering information from and managing expectations of stakeholders at all stages of a project. I believe in creating simple, intuitive systems that assist rather than confuse the end user.

Experience
2016 – current
Programmable Soda
Senior Developer

At Programmable Soda we create custom content management systems using PHP, Laravel, MySQL, TailwindCSS, Livewire, and AlpineJS.

The creation of our custom CMS means our clients only need see what they require for each section or content type for their site. We also provide methods allowing site administrators to grant their staff permissions-based access to maintain sections of their sites.

Because of the ease of administration, once launched, most of our sites are fully maintained by the clients; many of whom we don't hear from until updates or new features are required.

We work across many sites, however, below are examples where I have personally completed over 90% of the work on the sites:

Inglis

Inglis is Australia's largest thoroughbred auction house. I have worked with them for over 15 years across the build and management of their site and servers hosted with AWS. The site sees large volumes of visitors during auctions and has also had to deal with the occasional attempts by third parties to hack and hinder its operations.

The site consists of two base server instances, the public-facing web server and a secondary private data-crunching server. The "web processor" instance ingests data and where appropriate creates a static file cache for many of the pages which rely on large database queries. This model allows us to reduce processing time and to rapidly scale the public server as increased capacity is required.

Features include:

  • Load Balancer and a Web Application Firewall to mitigate intrusion attempts.
  • Initial data ingestion a third-party API, massaged by the CMS, then maintained directly by the client, while still receiving non-clashing updates from the API.
  • A process taking multipage PDFs, provided via FTP by a third party, extracting the pages individually and processing them as both optimised images and individual optimised PDFs.
  • Ability for sellers to upload images and videos of their horses. A series of functions process the images and videos through content processing pipelines; initially confirming the provided media contain images of "horses", and nothing nefarious; using Amazon's Rekognition. Approved assets are then encoded into multiple formats using AWS MediaConvert for delivery to the site visitor.
    Images and videos which fail the automatic approval process are queued for the client to manually approve or remove before going through the processing pipeline.
  • Days on which the sales are taking place are automatically managed by the content management system with queues and jobs kicking into gear to push and pull data via internal and external APIs to keep results updated and presented to the site's visitors.
  • Website data made available to the Inglis iPad app and to third-party listing sites such as Equineline via a local API.

Feel Good Ink

Feel Good Ink is a digital greeting card company addtionally allowing purchases to include prepaid gift cards and physical gifts, with the added bonus of donating a portion of your purchase to a charity of your choice.

Features include:

  • Custom card creator built on an HTML5 Canvas component using a customised version of fabric.js. Allows creators to add text, images, GIFs, drawings, etc to customise their cards.
  • Event and calendar system in the member's profile allowing members to create reminders and schedule cards for delivery.
  • Automated Email and SMS delivery of cards with tracking to advise the sender when the card is received and opened. Via AWS SES and SNS services.
  • QRCode creation and campaign module allowing Feel Good Ink to create QRCode codes for coffee cups and posters in local cafes. These codes link to the site with referrer codes and charity codes allowing FGI to create campaigns locking visitors to a certain charity and a referral code to gauge the campaign's effectiveness.
  • Integrated creation and management of Virtual Mastercards & Gift Cards using a third-party API.
  • Tax-time reporting for senders as the donation portion of a purchase is tax-deductible.
  • Administration reporting for Feel Good Ink to maintain their obligations to charity and financial partners.

AFL Coaches Association

The AFL Coaches Association manages the interests of senior coaches with regard to their involvement and interaction with the Australian Football League. They also present their own set of annual awards such as AFLCA Player of the Year and AFLCA Coach of the Year.

Features include:

  • A voting system, allowing AFL Senior Coaches and their delegates to login in after each match and cast their votes for the AFL Coaches Player of the Year award.
  • A custom integrated Email and SMS campaign service used to distribute media releases to the public and also to communicate directly with the AFL Coaches. The system operates much like a commercial email platform such as MailChimp, but has the added feature of being able to send to both email and SMS in one campaign.
  • Appearance & Continuous Professional Development (CPD) Registers: coaches record their activities for community outreach, education and furthering their career. This is a points-based account on a rolling calendar in which coaches must maintain a pre-defined level of CPD points.
  • Multiple reports and exports for data as required by the AFL Coaches Association in Excel and CSV formats.
  • All personal information encoded at the database level to ensure even in the unlikely event of a breach the data is securely encrypted using AES-256 and AES-128 encryption.
  • Currently undergoing a rebuild to turn the admin section into a fully-integrated CRM allowing the AFL Coaches Association to record interactions with their members. Will also feature a component for structured courseware tracking progression and completion.

Australian Football

AustralianFootball.com is a passion project started by Adam Cardosi while I was at Slattery Media. Adam came in over 10 years ago with a massive single spreadsheet and I have taken that data and created a data-warehouse which has continued to grow exponentially as Adam scoops up more historical and current data with the help of a community of like-minded individuals.

Australian Football prides itself on being the most complete history of the sport, including National, State, and local codes.

Features include:

  • Extensive queries running on over 2,000,000 rows of data across 50+ tables in a relational MySQL database.
  • A complex matrix of business rules and logic to handle the numerous rule changes throughout the 150+ years of the game while maintaining a consolidated dataset.

St Kilda Ferry

St Kilda Ferry is a commuter and event-based travel service in Melbourne. Members of the public can pre-book online.

Features include:

  • Web-based booking of the ferry service. With dates and times managed by the client. Due to being at the mercy of nature on days they need to cancel trips they are able to do this easily via a simple interface.
  • Uses Shopify APIs to create checkouts and manage seat availability via direct API calls and webhook integration. This allows both the Point of Sale system used on the boat and at physical selling locations to stay up to date with the website inventory.
2008 – 2016
The Slattery Media Group
Senior Developer / Photographer / Videographer
  • Was part of a team creating and maintaining a large number of websites for internal publications and for external clients (see Programmable Soda) using our custom-built content management system based on open-source PHP and MySQL.
  • Created iOS-based iPad applications for some of our titles including an interactive Jackson's Footy which allowed parents and children to read-along and/or interact with elements of the book. This included recording the author, Dwayne Russell's reading of the book and processing the audio into snippets I could manipulate in the app. It also involved taking the beautiful illustrations provided and carving them up while filling in the gaps enabling me to create animated sequences.
  • Created iOS-based iPad picture books for Our Great Game and The Story of the Melbourne Cup
  • Created multiple promotional videos for our titles such as Finding Jack Dyer.
  • Created a series of videos for Love of Language capturing the stories of their ambassadors such as George Donikian, Laura Anderson, Helen Kapalos, and Kosta Barbarouses.
  • Photographed multiple AFL matches and media events.
  • Photographed products and people for internal and external publications including: Author images for The French Kitchen, and the cover of Mike Sheahan's Open Mike, and the Queen Victoria Market's monthly publication MarketLife.
  • Production of podcasts.
  • Left due to redundancy as the company owner wanted to return to focusing on print-based publications. With my partner we took on the clients and created the company Programmable Soda.
2005 – 2008
Burbank Homes
Webmaster
  • As part of the marketing team I was responsible for working with all stakeholders across the company's divisions to plan, design, develop, and maintain the websites.
  • Created a custom PHP and MySQL-based web content management system allowing much of the day-to-day operations to completed by the relevant departments.
  • Maintained a large number of websites for Burbank Homes and the Burbank Group of Companies including: Storage Box, Mt Buffalo Resort, Burbank Homes, National Pacific Finance, National Pacific Properties, Denton Mills, and many building / community development projects.
  • Created and maintained a company intranet including a staff-movement tracker, meeting room booking system, and a web-based shared calendar.
  • Created and maintained the externally hosted web server running Microsoft IIS.
  • Left when an approached to join The Slattery Media Group.
2000 – 2004
Murdoch Magazines
Webmaster
  • Responsible for some of the first large-scale websites for Australian magazine properties including: Better Homes and Gardens, marie claire, Men's Health.
  • Built and maintained all other websites across the company such as our Intranet, Murdoch Books, and individual publication and events marketing sites.
  • Worked closely with the Marketing and Ad Sales departments of each publication to ensure their goals we met.
  • Part of the management team managing Murdoch Media Interactive a team of 13 people, reporting directly to the CEO and CFO.
  • Worked with Telstra to provision and maintain our Microsoft IIS server in a Telstra co-location running Lotus Domino and the Aprix content management system.
  • 2001 Better Homes and Gardens won the inaugural Magazine Publishers' Award for Innovation Online.
  • Created a barcode-based timing system used beach-side as a method to capture times of participants in the Men's Health Ocean Racing Series.
  • Created a fitness tracking website to facilitate the running of the annual Men's Health Fitness Challenge.
  • Left due to redundancy when Seven's Pacific Publications acquired Murdoch Magazines.
1994 – 1999
Optus Communications
Call Center Operator, Cable Modem Trial Assistant, Senior Developer

Initially joined Optus as a Call Centre Operator with the full intention of moving to a web team when Optus began internet operations.

  • Phone-based customer service for OptusTV and Optus Telephone
  • Created a presentation for my call centre team about "The Internet", what it was at that time and what I knew it could become. This presentaion was eventually delivered to the whole call centre and later provided to Optus Senior Management.
  • Became part of the small team involved in operating the Optus Cable Modem Trial in Sydney. Personally created the Intranet we used as a team to service our trial customers including creation of policies and procedures.
  • After the merge of OptusTV operations into Optus Communications, I joined the Business Information Support Group as a Senior Developer. We were responsible for the creation and management of the corporate Intranet ensuring thousands of pages of flat-file HTML content remained current as call centre staff used them as guides to perform their daily tasks.
  • Co-ordinated workshops and focus groups with all levels of the business to review current processes and identify opportunities to improve process flows which were then implemented via the Intranet.
  • Created training resources for new staff and participated in their training.
  • Created the website and backend used by Optus Staff to apply for and manage their shares as part of the Cable & Wireless Optus Share Program.
  • Left after headhunter approached me to join Murdoch Magazines.
Volunteer
2013 – current
Williamstown Camera Club
Committee Member, President, Web Developer
  • Committee duties, organising and co-ordinating events.
  • Creating member surveys and analysing the data.
  • Hosting the online component of our meetings via Zoom.
  • Creation of training presentations.
  • Website creation and maintenance.
2017 – 2019
Marsh Monster Mash
Web Developer, Videographer

Marsh Monster Mash was a community-run event providing a Halloween event to the people of Bacchus Marsh, Victoria. Money raised through the event was donated to a charity selected by the community.

2015 – 2016
Heartfelt
Photographer

Heartfelt is a volunteer organisation of professional photographers from all over Australia dedicated to giving the gift of photographic memories to families that have experienced stillbirths, premature births, or have children with serious and terminal illnesses.

2005 – 2008
Gay & Lesbian Switchboard
Telephone Counsellor
  • Certified counsellor with anonymous phone services supporting Melbourne's LGBTIA+ community. Calls ranged from directory services, referrals to professional services, family support, and on occasion, suicide prevention.
  • During my time here I also built a web-based system for referral management, counselor communication, and rostering. All done as volunteer services. My IT support continued after I left, until they integrated with a national system.
30 Burnett Street,
Sadliers Crossing, Qld, 4305
0414 449 674
james@jamestroi.com
jamestroi.com
Skills
  • HTML
  • PHP
  • Javascript
  • CSS
  • Git
  • Laravel
  • Livewire
  • AlpineJS
  • Relational Databases
  • API Development
  • Information Management
  • UI / UX
  • Photo / Video Editing
Education
HSC
Jamison High School
1986–1991
Hobbies
  • Photography
  • Writing
  • Reading
  • Sewing
  • Woodwork
  • 3D Printing
References
Available on request