Ian Tubman
Senior Analyst Programmer at Australian Centre for the Prevention of Cervical Cancer- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
SQL (Advanced)
HackerRankNov, 2022- Oct, 2024 -
SQL (Basic) Certificate
HackerRankOct, 2022- Oct, 2024 -
SQL (Intermediate)
HackerRankOct, 2022- Oct, 2024 -
C# (Basic) Certificate
HackerRank
Experience
-
Australian Centre for the Prevention of Cervical Cancer
-
Australia
-
Hospitals and Health Care
-
1 - 100 Employee
-
Senior Analyst Programmer
-
Feb 2023 - Present
-
-
-
Schiavello
-
Australia
-
Leasing Non-residential Real Estate
-
300 - 400 Employee
-
Senior Software Developer
-
Jul 2018 - Oct 2022
Financial, MRP & VB6 maintainer 2020-2022Quality Safety & Environment in M-Files 2019HR in M-Files 2018Delivered solutions for QSE & HR management systems. Supporting business units with legal document control capability via workflows in M-Files.My major tasks included optimisation of SQL database stored procedures and table indexes. For example, I removed all loops in a Bill Of Material expansion procedure, by converting it to a recursive SQL to feed multiple CTE’s containing OVER windowing functions to find quantity and sequence numbers. This yielded better code and faster results in manufacturing and purchasing processes.Delivered solutions for QSE & HR management systems. Supporting business units with legal document control capability via VBA workflows in M-Files.Worked within an Scrum team, extending Financial & MRP systems written in Visual Basic. Managing those with Jira stories, TFS, GIT, TeamCity & Octopus. Later, started work within an Kanban team for conversion of those systems to C# & Blazor. Managing those with DevOps stories, GITHUB & Azure DevOps pipelines. Show less
-
-
Development Manager
-
Jan 2000 - Jun 2018
Wireless Barcode Driver System 2016Web Quotation Management System 2014Web Dispatch Management System 2012Business System (Financial+MRP) DBA 2006Payroll DBA 2004Dispatch Management System DBA 2002Barcode Engineering 2001Financial System DBA 2000Implemented EAN128 barcode input/output to manage products from ordering through to delivery. Interfaced barcode RF serial devices from HID, Motorola, Intermec, Symbol and Zebra. Managed in-house module & database changes for barcoding, bill of materials, emailing, GST, general journaling, invoicing, item master, job costing, ordering, payroll, shop floor control and timesheets capture. Worked closely with business analysts, provided excel data upload macros, modelled database designs and effectively provided guidance to 4 developers.Programmed above systems in ASP.NET, C++, MSTest, SQL, VB.NET, VB6 and Crystal Reports. Show less
-
-
Analyst Programmer
-
Feb 1996 - Dec 1999
Contact Management System 1996Quotation Management System 1998IT support for Sales staff. Installed: printers, networking, databases and NT4 domain controllers. Supported Excel and maintained Quotation applications. Modelled and built, a contacts application with sparse matrices to enrol customers into events and publications.Programmed these systems in MsAccess, SQL 6.5, Crystal Reports, VBA & VB5.
-
-
-
Kind Data (VIC)
-
Melbourne, Australia
-
Computer Consultant / Installer
-
Jan 1992 - Jan 1996
Setup of Windows, Networks, PCs and Applications (various customers) Programmed Access, Visual Basic and Crystal Reports (BP Oil) BP Oil projects include processing oil refinery yield predictions with Microsoft Access. Setup of Windows, Networks, PCs and Applications (various customers) Programmed Access, Visual Basic and Crystal Reports (BP Oil) BP Oil projects include processing oil refinery yield predictions with Microsoft Access.
-
-
Education
-
Victoria University
Bachelor of Applied Science