Experience

The Wests Group Australia
• Australia
• Hospitality
• 1 - 100 Employee
• Data Analyst

  • Sep 2021 - Present


CSA

• Pakistan
• Government Administration

• Software Developer

  • Aug 2020 - Aug 2021

  Salesforce development, including apex triggers, visual force pages, conga merge documents. Development c# .net rest api integration application between salesforce and auspost.

• Consulting Engineer - Data and Analytics

  • Oct 2019 - Aug 2020

  Migration of sql server databases from on premise to Aws rds instances at Uni of Newcastle. Global admin for powerbi tenant migration and uplift of powerbi workspaces to powerbi premium capacity.


Currently Seeking Opportunities
• United States
• Graphic Design
• 700 & Above Employee
• .

  • Aug 2019 - Oct 2019


City of Newcastle, Australia

• Australia
• Government Administration
• 300 - 400 Employee

• ERP Administrator

  • Oct 2016 - Aug 2019

  OneCouncil: Technology One product system administration of CES, ECR, P&R and ECM suites.Management of security regime within TechnologyOne OneCouncil to ensure that security is applied consistently across all suites. Deployment of software upgrade packages. Monitoring and investigation of performance issues within solution and liaising with vendor to implement improvements.In conjunction with business representatives, making configuration changes to OneCouncil application, enabling adjustment of business processes to meet operational requirements whilst keeping within defined governance framework.Specification, documentation and implementation of PPM (performance project management) solution developed by vendor within OneCouncil and ensuring security regime conforms to corporate policy.Analysis and documentation of integration points to and from OneCouncil application with view to ensuring smooth transition when migrated to Cloud.Developed and deployed alerts to inform users of data quality issues that existed within system. Creation of ETLs to enable automation of system processes.Automated the production of Building Professional Board (BPB) reporting requirements. Level 2&3 support for problems encountered with OneCouncil systemHAZMAT: Developed Application that enabled HAZMAT services to generate Hazardous Material reports from external reporting tool. Show less

• System and Data Architect

  • Sep 2013 - Oct 2016

  ERP Implementation: Primarily responsible for Data migration of Data from existing council systems into Technology One OneCouncil corporate application. This is an ERP system with modules for Property and Rating, HR/Payroll, Works and Assets, Finance, Document management and CRM. Developed and implemented profile and role-based security model for users of system. Development of reports using SQL Server Reporting Services (SSRS) to display information relevant to users and managers.Development of data migration tools to aid rapid data migration including tools for managing and monitoring security and environment deployments of OneCouncil modules.Level 3 support for problems encountered with OneCouncil system Show less

• Systems Analyst

  • Dec 2006 - Aug 2013

  MySafety, MyHR: Development and implementation of WHS management and reporting solution to enable Council to meet its requirements to maintain its self-insurance status. This solution had web front end that integrated with CHRIS HR/Payroll system. Included scheduled reporting to applicable managers using automated process contained within SSRS.CHRIS21: System Administration and data integration with other systems. Implemented and developed applications to utilize web services provided by Frontier software as part of CHRIS21.TAMS: Analysis, design and build of software to enable information capture of Tree and other asset information. This is an integrated mapping application utilizing SQL replication to ensure data synchronization is maintained. Development of SSRS reports for use by management to manage their tree stock (currently 100K+ trees recorded and maintained in system). Also does work order creation and managementAMS: Development of upgrade of TAMS system for collecting asset information for any user definable asset class.• Extensive database design and analysis experience including environment migration tools.• ELT monthly financial report development.• Multiple environment setup and deployment.• Authority Upgrade Data conversion• Data specification, tender, application analysis and development• Development of SQL Server Reporting Services reports• Development of disaster recovery collection application in MapBasic• Administration of Project Tracking application (ASP/SQL app)• MapInfo/Map Basic integration and development • Analysis of customer and Business needs for information and systems Show less



Logan City Council

• Australia
• Government Administration
• 700 & Above Employee

• Systems Analyst

  • Aug 2005 - Nov 2006

  • Extract Transform & Load (ET&L) Lattice HR/payroll to Finance One • Claims Management System Access upgrade to Access Data Project • SQL Report (Analysis Services) development • ET&L KFlow comments to PDF and import to OpenDOCS utilizing DTS package creation to convert documents to records • Development of Outlook appointment form for use throughout council. • Enhancement to Council Meeting minute process • Implementation and Administration of Masterview (Web interface to Corporate property details) • Development of Asset Leasing application Show less



Flight Centre

• Australia
• Travel Arrangements
• 100 - 200 Employee

• Analyst Programmer

  • Nov 2003 - Aug 2005

  • Development and Support of Oasis Ticketing application (VB6 application)• Lead programmer in Oasis application development project• Extensive development of SQL 2000 scripts for database and data changes• Analysis and design of financial ticketing data processes• Data analysis and reporting for business• First, second and third level support for users of production application.

• Contractor

  • Apr 2003 - Oct 2003

  Support and development of ADP Ticketing applications (MS Access front end SQL Server 2000 backend)



Suncorp Group

• Australia
• Financial Services
• 700 & Above Employee

• Data Conversion Access Developer

  • Sep 2002 - Apr 2003

  • VBA development utilising full MS Office integration functionality • Development of Data Conversion Reconciliation models in Access 97 • Reconcile upgrades of PeopleSoft v7.5 to v8.4 • Reconciliation models for Ledger, Budget, ADB, Summary, AM and AP • Development of Access 97 form flow procedures • Automate connection to Oracle Tables via ODBC • Development of on the fly SQL creation procedures • VBA development utilising full MS Office integration functionality • Development of Data Conversion Reconciliation models in Access 97 • Reconcile upgrades of PeopleSoft v7.5 to v8.4 • Reconciliation models for Ledger, Budget, ADB, Summary, AM and AP • Development of Access 97 form flow procedures • Automate connection to Oracle Tables via ODBC • Development of on the fly SQL creation procedures



South Sydney Council

• Accounting Systems Manager

  • Aug 1999 - Jul 2002

  • System Administration of Oracle and CHRIS systems • ASP development• Intranet specification, development, modification and support• Application development, interfacing to Corporate databases• Data conversion Manager for new Corporate software solution• Coordinated implementation of CHRIS HR/payroll system• Overseeing development of Web interface to corporate databases• Development of database solutions for simplifying daily work practices• Developed reports using Access interfacing to Oracle databases• Development of visual basic applications for use by staff• Train staff in the use of the corporate financial system. Show less

• Systems Development Engineer

  • Jan 1997 - Jul 1999

  • Writing specifications for provision of technical software for Council.• Evaluation of replacement software for Councils corporate computer system.• Departmental Computer Support and Training for 300 users.• PC software upgrades and support, including Windows 95 and MS Office 97 • PC and peripheral hardware installation and support• Train staff in the use of Microsoft Office Software.• NT Workstation installations and troubleshooting. • Development of financial reports using the corporate database (MUNIC).• Provide information for quarterly and EOY financial statements. • Integration of user databases with corporate database.• Database development using MS Access 97 and Visual Basic 5. • Internet and LAN strategy policy development.• Integrating Database and GIS systems. Show less

• Assistant Assets Manager

  • Jan 1994 - Dec 1996

  • Coordination of GPS Asset Data capture Project• Collection of all Infrastructure Assets data and creation of databases.• Link textual databases with Geographic Information System (GIS), (GDMS).• Export of GDMS layers into MapInfo.• Writing Geographic Programming Language programs (GPL) to extract textual data from corporate databases to display within GIS environment.• Development of applications, Visual Basic and GPL, to import GPS data into GIS system and engineering software.• Integration of databases with Councils financial systems.• Creation of Databases, Access and PACE, for use by Council staff.• Tender preparation and evaluation for GPS systems. Show less

• Engineer Systems Development

  • 1990 - 1994

  • Database Development using PACE• GPL Development.• Implementation of GIS within Council.