Sutherland Nele

• Design and Develop Software Solutions for the Bank of South Pacific and its major clients and partners.

Projects:

• BSP Kundupei Client: Upgraded the Kundupei .Net Framework Application for the Bank of South Pacific that is used by over 5000 customers for the bank to handle ABA file vetting and processing and also include other logging and enterprise features.
• BSPPay Flexcube (Oracle UBS) Integration: Integral member of the team involved in the development of the Internet Payment Gateway for the Bank of South Pacific. Integrated the BSPPay system with the new Flexcube Core Banking System that was rolled out by BSP in 2023.
• BSPPay Admin Web Portal: Designed, developed and implemented the admin web portal using React and Spring Boot for the Internet Payment Gateway based on analyzed requirements and understanding of industry technical standards. The backend is running on Java Spring Boot RESTful API Microservices using Keycloak for Authentication and Authorization and MariaDB Relational Database. The frontend admin web app were developed using React and runs as a docker container on a separate port.
• BSPPay Air Niugini Sabre E-Commerce Website Integration: Integrated BSPPay with Sabre E-Commerce platform that the Air Niugini uses. The Sabre website sends a SOAP AUTH request which is then converted to JSON and processed using a microservices architecture design.
• PNG E-Receipting System: Designed, developed and implemented the e-receipting system for the Papua New Guinea department of Finance based on analyzed requirements and understanding of industry technical standards. The backend is running on Java Spring Boot RESTful API Microservices using KeyCloak for Authentication and Authorization and Mariadb Relational Database. The frontend admin web app were developed using ReactJs as runs as a docker container on a separate port.

• Designed and Developed Software Applications.

Projects:

• HGDC Costman System: Designed and Developed the HGDC PNG Costman system which enhances cost management at Hides Gas Development Company's Operations division by replacing spreadsheets with a sophisticated system that accurately tracks and centralizes internal, external, and inter-division costs. It boosts productivity and ensures reliable reporting by managing RFQs, quotes, invoices, and internal expenses like payroll and accommodations. Tailored for specific user roles, its detailed user interface includes login screens, dashboards, and administrative tools, streamlining operations effectively. The system is based on a Microservices Architecture with React as the Frontend and Spring Boot RESTful APIs as the backend. It also integrates with Keycloak IAM and has MariaDB as it's database.
• PNG Case Management Information System: Designed and Developed the Papua New Guinea Case Management System. The source code is on github under GPL 3.0 at https://github.com/sutherlandnele/png-case-management-information-system. This is a sophisticated application built using Java Spring Boot for the backend and React for the frontend. This system is designed as a microservices architecture to handle different facets of case management efficiently.
• Lclpngltd E-Commerce Wordpress Website: Designed, Developed and Hosting the E-Commerce Wordpress 6 Website for Lean Consulting PNG Limited. The website is integrated with Kina Bank's Internet Payment Gateway to accept online Card payments. Website address is at https://www.lclpngltd.com.
• Woocommerce Wordpress Website Plugin for BSPPay: Designed and Developed a Wordpress Extension for BSPPay that integrates with the BSPPay payment option for BSP Bank.
• NAC Wordpress Website: Designed, Developed and Hosting the Wordpress 6 Website for the Papua New Guinea National Airports Corporation. Website address is at https://www.nac.com.pg.
• Cloudcode USSD Gateway: Designed and developed the Cloudcode's USSD Gateway. The USSD Gateway, powered by JAIN SLEE, delivers a robust platform for telecom applications, integrating SMPP for SMS and Sigtran for IP signaling, crucial for USSD management. It connects with MNOs in Papua New Guinea, like Telikom and Digicel, supporting services such as mobile banking. Its scalable architecture minimizes latency for reliable USSD sessions. JAIN SLEE's dynamic logic and effective messaging enhance network performance.
• Cloudcode SMS Gateway: Designed and developed the Cloudcode's SMS Gateway. The Cloudcode SMS Gateway leverages JAIN SLEE for robust event-driven processing and SMPP for efficient messaging. It acts as an intermediary, facilitating smooth SMS transmission between applications and various mobile network operators (MNOs) in Papua New Guinea, including Telikom, Digicel, Vodafone, and Bemobile. Its high-throughput, scalable, non-blocking architecture ensures real-time SMS delivery. Dedicated SMPP bindings maintain connections with MNOs, meeting specific protocols and requirements to enhance message reliability and delivery speed.
• PNG Fleet Management System: Designed and developed the PNG Power Fleet Management system currently being used to manage all the PNG Power's Fleet site-wide. This is an ASP.Net Core application and based on the Microsoft ASP.Net suit of tools and frameworks and also includes a layered approach to programming from building the SQL Server database entities, C# classes (Models, Views, ViewModels and Business Logic), IOC Dependency Injection (AutoFac), AutoMapper and other cool front-end UI frameworks like JQuery and
  Tweeter Bootstrap.
• PNG Power Regulalatory Management Information System: Designed and developed the PNG Power Regulatory Services Information Management System to manage installations, investigations, inspections, appliances, inspectors and electrician information in all centers within PNG. This is an ASP.Net WebForms application and based on the Microsoft ASP.Net suit of tools and frameworks and also includes a layered approach to programming from building the SQL Server database entities, C# classes (Models, Views, ViewModels and Business Logic), IOC Dependency
  Injection (Unity), AutoMapper and other cool front-end UI frameworks like JQuery and Tweeter Bootstrap. The source code is on github under GPL 3.0 at https://github.com/sutherlandnele/png-fleet-management-information-system.
• CIC HRM: Designed and Developed the Human Capital Management Information System for the Papua New Guinea Coffee Industry Corporation Limited. This was a World Bank funded project. In the backend, system is developed Using Oracle 18c XE Database running on Tomcat 9.0 Application Server, Oracle Restful Data Services (ORDS) and Oracle Application Express 19.2 on-premise environment. It also has all the other cool front-end technologies and frameworks to give it a modem UI including jquery,
  boostrap, less, css3, etc. The system is running on Linux Centos 7 64-bit
• ICCC Joomla Website: Papua New Guinea Independent Consumer & Competition Commission (ICCC) Corporate Website. The website is very dynamic in nature, has in-built document management features and online forms workflow processing.
• ICCC Cosumer Good Price Monitor Web App: This is a tool written in PHP, CodeIgnitor, Keens UI and MariaDB that one can use to monitor the prices of consumer goods that are sold in a region or country. The app can also integrate with a Joomla Website and use Joomla's Authentication and Authorization mechanisms to access the web app.
• Cloudcode Vleebo: Developed flagship product called Vleebo (An Online Fleet Management System) using ASP.Net Core, React Native, React and Mariadb Database server. The API microservices and the frontend web apps are hosted as docker containers within Plesk Ubuntu 20.04 server on AWS.

• Providing support to OTML core systems, which include:

- Ellipse/SAP ERP System

- Alesco Human Resource Management Information System

- Oracle Discoverer 10g

- Office 365 and SharePoint

- OTML Web Applications

- OTML SQL Server 2000/2005/2008 Database Applications

- OTML Oracle Database 9i/10g/11g Applications

- Oracle 6i/10g Forms & Reports Applications

- Cardax Door Access System

Projects:

• OTML Restructure OTML Payment PL/SQL Package: Developed a custom Oracle PL/SQL package to update the Concept Alesco HR system to bulk terminate, pay and hire OTML employees during the 2013 retrenchment exercise in OTML.
• OTML Contractor Man Hours Web App: Designed and developed a secure C# ASP.Net MS SQL Server database application using the .Net Entity Framework and Telerik UI Visual Studio 2010/2012 plugins. The application is used by the business to register hours for OTML contractor's labor and machine hire before the Finance department does payment. The information in this system is also used by the Safety department to produce man hours reports for the Mineral Resource Authority (MRA)
• OTML People Tracking Web App: Designed and developed a secure C# ASP.Net MVC MS SQL Server database application using the .Net Entity Framework, Kendo UI, SignalR and Cardax SDK. The application is integrated with the Cardax Door Access system and provides realtime/live data via SignalR as employees and contractors badge in and and out of cardax doors at the mine site. This system is used by the Safety Department at the Mine site to track employee movements in and around the mine area.

• Provided Oracle Database and Application consultancy services to clients in Papua New Guinea including the PNG Department of Education and PNG Power Limited.

Projects:

• PNG FODE Student Enrollment Management Information System: Designed and developed the Student Enrollment Management Information for the Papua New Guinea Flexible Open Distance Education (FODE) using Oracle Application Express 4.1 hosted on Apache Web Server. I migrated from the existing Oracle Forms & Oracle Reports System that was currently being used. The whole solution consisted of Oracle Database 11g Enterprise Edition Database, Application Express 4.1 and Apache Web Server for serving the http web pages.

• Employed by Telikom to lead a team of graduate programmers in order to fulfill its need to develop new software solutions for the business. I was primarily involved in developing in-house systems using Microsoft and Oracle technologies such as Visual Studio 2010, MOSS 2007, SQL Server 2008, Oracle 10g, Oracle Application Server 10g and Oracle Application Express 3.2

Projects:

• Time Management System: Designed and Developed an ASP.Net Application using C# and Infragistics UI controls that integrated with the Cardax Door Access system. The system was used by the Human Resource department to control and manage employee time and attendance.

• Experience in Designing and Managing an Oracle Database 9i, Oracle 10g & Oracle 11g
• Worked with Oracle Real Application Cluster (RAC) Architecture at Hardware and Software level
• Experience in writing software design specification documentation for new software (Datec Software Development Team)
• Briefly worked with GIS tools and Oracle Spatial including Oracle Application Server 10g (10.1.3) MapViewer, MapInfo 8.5 and Google Earth Pro.

Projects:

• Civilian Firearms Licensing System: Involved in the development of the Civilian Firearms Licensing System for the Royal Papua New Guinea Constabulary using Oracle Application Express 3. This system is used to manage the licensing of firearms in Papua New Guinea. I integrated Oracle Application Express with the DataCard ID printer by using DataCard printer SDKs.

I was automatically selected into Oktedi Mining Limited's Graduate Development Program to work as a cadet in the Information Services department right after I graduated because of the agreement that was in place during that time between the Papua New Guinea University of Technology's Computer Science Department and Oktedi Mining
Limited for the top Computer Science graduate.

During my training term, I was mostly attached with the Applications Support team and performed the following duties:

• Worked with MS SQL Server 2000/2005 Database and Data warehousing and Decision Support Systems (DSS) and familiar with MS SQL Server Database Administration Tasks
• Installing and managing MS SharePoint 2007 Server and integration with Active Directory.
• Experience with Programming with T-SQL/PL-SQL – Writing Stored Procedures, Functions, Triggers, Packages, Scheduling Jobs on database server, working with database tables and views.
• Experience in Supporting (Debugging) and Developing Distributed Database Applications developed in VCSharp.Net/VB.Net (Corporate Reports ASP.Net with VB.Net, MS Reporting Services, MS SQL Server 2000/2005 Database Back-End)
• Did a lot of support work through work orders in OTML to Maintain/Modify Existing Programs (Safety System, Ellipse, Corporate Reports – Modified User Interface, Created New Reports, Modified Existing Reports,Correcting Errors in the System).
• Administered OTML Company Web Intranet and developed web pages using HTML, Javascript and C#.
• Provided Support Work for Ellipse (OTML's core Enterprise Resource Planning (ERP) system)
• Provided Training on new or existing System to OTML system users