ARMELA MAGSALIN

Database Management and Optimization:

• Extensive experience in handling large-scale operational data systems, particularly in the Tolling and Transport Industry.
• Expertise in database design, migration, maintenance, optimization, and performance tuning across various platforms including PostgreSQL, SQL Server, SAP ASE, Oracle, and others.
• Strong understanding of entity-relationship modelling and proficient in utilizing stored procedures, views, triggers, functions, and audit mechanisms.

Business Intelligence Reporting and Data Analysis:

• Experience in creating REST APIs for data retrieval and optimization of database queries and procedures.
• Skilled in transforming and modelling data, analyzing data trends, and presenting insights through reports and visualizations.
• Experience in monitoring system operations, KPIs, customer care, and service enhancements using tools like Grafana and Power BI.

Application Design and Development:

• Skilled in the end-to-end software development lifecycle, including requirements gathering, architecture decision-making, planning, design, development, testing, release, and maintenance.
• Proficient in various programming languages and frameworks such as Shell scripting, Python, SQL, Sybase PowerBuilder, PHP, and web development tools like Django, Flask, Swagger, etc.
• Demonstrated experience in system analysis and design, business requirements impact analysis, feasibility analysis, proposing solutions, functional design documentations, trainings and manuals to stakeholders.

Industry Experience and Collaboration:

• Over 15 years of experience in NSW Tolling and Transport Industry, contributing to the development and maintenance of complex back-office systems. Extensive years of experience in Finance, Banking, Insurance, Payroll and Manufacturing sectors.
• Proven ability to effectively communicate and collaborate with technical and non-technical stakeholders across different domains.
• Experience working in Agile project teams, providing mentoring capability, and working productively with minimal supervision.

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

• Lance Brand, Senior Solutions Manager, Q-Free Australia, Level 7 107 Mount St., North Sydney, NSW, 2060, +61 417 024 459
• Sonia Magpily, Senior Service Manager, Transport NSW Roads and Maritime Services, 12 Darcy Street, Parramatta, NSW, 2150, +61 459 848 133
• Arthur Xirocostas, DBA, Principal Consultant, +61 412 590 928

• Microsoft Power BI
• Python and Django Framework
• Fundamentals of Java Programming
• The Complete PHP MySQL Professional Course
• Sybase Database and Performance Tuning
• Mastering Transact SQL, Advanced T-SQL Tips & Techniques
• Programming: Advanced T-SQL Tips & Techniques Administration, Unix
• Secure SDLC Training
• Security Awareness Training
• PHP for Beginners to Master
• Adaptive Server Enterprise 15.0
• Oracle Developer Forms and Reports