Summary
Overview
Work History
Skills
Websites
Formal Qualifications
References
Training
Timeline
Generic

Armela Magsalin

Sydney,NSW

Summary

I have over 20 years of experience in the IT industry covering Enterprise Solutions and Technology Architectures, IT Strategy and Roadmaps, Stakeholder Management, Consulting, to developing and delivering complex mission critical business solutions. I am a solutions specialist with a passion for delivering excellence to all business stakeholders, believes in building great relationships and is a loyal and trusted employee to the business in realizing their vision and strategy. I specialize in designing technology solutions, as well as developing, maintaining and implementing customized software in Tolling, Banking and Finance environments. Over the years, I have worked in various senior technical roles within IT Companies, Banking, Insurance firms in Singapore, Malaysia and Philippines. In Sydney Australia, I work in full loyalty as a Lead Analyst, Developer and Support for the Electronic Tolling and Collection Back office System of Roads and Maritime Service. I have a great deal of experience working with clients, managers, business leaders, product vendors and outsourced companies mainly gathering and documenting requirements as part of systems analysis and solutions design. My most recent engagement at Q-free is the delivery of Sydney Harbour Bridge and Sydney Harbour Tunnel project. An electronic toll collection in a multi-lane free flow arrangement such that vehicles are tolled without the need to modify the flow of traffic at the identified toll points.

Applications design/development: Immense background in analysis, design, development, customization, implementation and testing of software applications and products.

Database design/development: Years of experience in technical and analytical skills with clear understanding of design goals of entity-relationship modelling. Years of knowledge in designing database solutions, performance tuning and building using stored procedures, views, triggers, functions etc.

Data warehouse: Worked on data warehouse development lifecycle, from gathering requirements to testing, implementation, and support. Designed and built operational data stores (ODS) and decision support system (DSS) databases in Sybase, PostgreSQL, MS SQL Server and Oracle. Management: Strong leadership with experience of mentoring developers and advising technical groups on best practices. Demonstrated leadership skills (technical team leadership, business stakeholder engagements and application solutions presentations)

Personality: Team player, versatile, collaborative, with strong communication and interpersonal skills.

Industry Experience: Primarily in Electronic Tolling Business, IT Solution, Banking, Insurance, Shipping and Transport and Manufacturing companies.

Overview

24
24
years of professional experience

Work History

Software Engineer, Lead Developer, Maintenance and Support for Operations

Q-Free Australia Pty Ltd
Sydney, Australia
02.2008 - 03.2024
  • Lead System Analyst and Developer
  • Responsible for the 'end-to-end' solution of RMS Electronic Tolling and Collection System, working very closely with the enterprise business analysts, various data custodians and business stakeholders (analytics & reporting teams) in understanding requirements, building & presenting prototypes and getting agreement on solutions designed
  • One of the core team of System Engineers for Sydney Harbour Bridge and Tunnel Tolling System and Sydney Airport System
  • Responsible for the projects and change management, resources allocation, release and deployment management
  • Responsible for project cost estimates and preparation of project milestones and risks management
  • Responsible for Database Design, Setup and configuration, Optimization and performance enhancement
  • Technical lead on the design and delivery of solution for various business intelligence reporting, kpi monitoring, Invoices and Statements.
  • Support lead for RMS Electronic Tolling and Collection System Maintenance service

Projects:

Roads and Maritime Service - Electronic Tolling and Collection Back office System (ETCS).

Over 200 ETCS variations and projects delivered. The last project accomplished is the NSW Toll Relief Program

Applications and component such as :

  • CRM – Customer Relation Management System
  • TCA – Tag Contract Application
  • CUPS – Casual User Pass System
  • VRS – Video Retrieval System
  • MH – Mailing House System
  • PH – PrintHouse System
  • Tag Stock Loader Application
  • Online Electronic Tolling System (Integration to RMS ETCS)
  • MOU Trips Request and Processing
  • GANDALF Rental and Fleet Accounts
  • Payment Gateway for Credit Card and Direct Debit

The Harbour Crossing Tolling Project (HCTP)

To provide TfNSW electronic toll collection for southbound users of the Sydney Harbour Bridge (SHB) and Sydney Harbour Tunnel (SHT). An electronic toll collection provided in a multi-lane free flow arrangement. Vehicles are identified through their carriage of On-Board Equipment (“tags”) designed for Australian toll roads, or through images captured by tolling cameras.

Task as Software Engineers for the following key project requirements:

  • Vehicle Detection and Classification
  • Tolling Tag Detection
  • Image Capture and Automated Number Plate Recognition
  • Correlation of vehicle, tag and image data records
  • Action List Processing, to enable communication with the tag of the tag or accounts status
  • Independent Audit Systems
  • Tolling Domain Management (maintenance, monitoring, configuration, logging, and management of the RSS)
  • Reporting
  • Asset Management

The Sydney Airport System -This is comprised of three separate Central System instances:

• GTAS (Ground Transport Access System) which is responsible for access and fee charging of Taxis

• THA (Taxi Holding Area) which allows Sydney Airport operational staff to monitor and control the access control equipment at the Taxi Holding Area which feeds the domestic terminals. This will be merged into the GTAS Central System during the upgrade.

• BLFS (Bus and Limo Fee System) which is responsible for access and fee charging of areas that are not taxi ranks, including dedicated Bus and Limo sites and Priority Pick-up

Task as Software Engineers for the following key project requirements:

  • SACL Data Warehouse – for all information collected and generated
  • Alarms Publisher – system alerts using e-mail and SMS
  • ROAM Backoffice – trip consolidations and billing, transactions blacklist, whitelist and greenlisted tags. Invoicing and Rejections files
  • Web Browser – web management interface for normal operations
  • Reports and System Monitoring

Senior Software Engineer

Solutions Details Pte Ltd
Singapore, Singapore
10.2006 - 11.2007
  • Responsible for Development, enhancement and maintenance of the company's Integrated Business Management Solutions - The Konverge ERP System. Responsible for Systems Analysis & Design, Database Design and Optimization, project estimation and preparation of project milestones and risks management, project release and deployment management.

Software Engineer

IFCA MSC BERHAD
Malaysia, Malaysia
05.2005 - 10.2006
  • Hired as a Software Engineer, with the task of developing and maintaining the IFCA Suite of Construction and Engineering Solutions - A comprehensive & fully Integrated Business Software
  • My responsibility was for customer customization, maintenance, data migration, enhancement and operational support of integrated business solutions for contract, project, materials, plant and machinery and financial system.

Software Developer

Philippine Savings Bank
Philippines, Philippines
01.2005 - 05.2005
  • The company's principal activity is operating as thrift bank offering a range of products on deposits and loans and services that cater mainly to consumer and retail customers. Hired as an IT Consultant, with the task of developing and maintaining the Integrated Loan System application of one this prestigious bank in Philippines

Software Developer

PetPlan Insurance
Philippines, Philippines
05.2004 - 01.2005
  • PetPlans has been one of the pioneer and leading Pre Need Plans provider in Philippines. Hired as an IT Consultant, with the task of developing and re-engineering most of the company's newly approved project plans using Oracle Developer 6i for the front end and Oracle 9i Enterprise Edition as the RDBMS

System Development Team Lead

Account Management Company Incorporated
Philippines, Philippines
05.2000 - 01.2004
  • Responsible for the companies leading client's system maintenance contract, and Software Application Development projects like payroll system, accounting system, billing and collection system, purchasing and inventory management system, insurance system, accounts payable system, case monitoring management system, legal case management system and transport and shipping financial system.

Skills

Programming languages: Sybase PowerBuilder, Python, SQL, PHP, Bash/Shell/Perl/PowerShell script, HTML/CSS, JavaScript, Oracle Developer, Oracle Develop 8i, Oracle Personal, Oracle Forms, Report, Query, Schema, Procedure, PL SQL and Graphics Builder, Oracle Designer

Databases and DB Tools: PostgreSQL, SQL Server 2005/2000, Sybase ASE (150/125), Oracle 10g, MS Access, MySQL, Sybase SQL Anywhere (ASA), SAP ASE, Oracle 80, 8i & 9i, SQL 60 - 65 Server, Watcom SQL Server, InfluxDb, Microsoft SQL Server, MySQL, RabbitMQ, SQLite

Development environments: PGAdmin, Aqua Data Studio, Visual Studio, Visual Studio Code, Sybase Interactive SQL ,IPython / Jupyter, WSL for Windows 10, Oracle VM Virtual box, DBArtisan, Microsoft Visio, Toad, SQL developer, Visual Studio, Atom, Eclipse, NetBeans, Notepad, Vim

Frameworks, Libraries: Apache Beam, Django, Flask, jQuery, Nodejs, Pandas, Protobuf

Collaboration and monitoring: Confluence, Grafana, Jira, Github, Gitlab, Code repository, Tortoise SVN, Nagios, ServiceNow, Splunk

Build, test, config, deploy tools: Docker, Zephyr, Putty, Winscp, Puppet, Maven, Nexus, Jenkins, Postman

Documentation: OpenAPI, PowerDesigner, Swagger technical specification and documentation, Balsamiq tools

Webserver, Monitoring and logging: Nginx, Webserver, NetXMS, Ryslog

Formal Qualifications

  • Bachelor of Science in Computer Engineering (Year 1999)
  • Bachelor of Science in Business Office Administration (Year 1994)

References

  • Lance Brand, Tolling Management Team and GM, Solutions, George St. Parramatta NSW 2151, +61 417 024 459
  • Sonia Magpily, Manager of System Management, Systems and Assets - Tolling Group, George St. Parramatta NSW 2151, +61 459 848 133
  • Arthur Xirocostas, DBA, Principal Consultant, +61 412 590 928

Training

  • Fundamentals of Java Programming
  • Complete Java Masterclass
  • PHP for Beginners - Become a PHP Master
  • The Complete PHP MySQL Professional Course with 5 Projects
  • Artificial Intelligence A-Z: Learn How to Build an AI
  • Sybase Database and Performance Tuning
  • Mastering Transact SQL Programming: Advanced T-SQL Tips & Techniques
  • System and Database Administration: Adaptive Server Enterprise 15.0
  • Oracle Developer Forms and Reports
  • Getting started / UNIX System User
  • Visual Basic

Timeline

Software Engineer, Lead Developer, Maintenance and Support for Operations

Q-Free Australia Pty Ltd
02.2008 - 03.2024

Senior Software Engineer

Solutions Details Pte Ltd
10.2006 - 11.2007

Software Engineer

IFCA MSC BERHAD
05.2005 - 10.2006

Software Developer

Philippine Savings Bank
01.2005 - 05.2005

Software Developer

PetPlan Insurance
05.2004 - 01.2005

System Development Team Lead

Account Management Company Incorporated
05.2000 - 01.2004
Armela Magsalin