Peter Dubbelaar Email & Phone Number

Melbourne, Victoria, Au

Technical Environment:ArcGIS, SQL Server, Python, SQL Server Management Studio, Oracle, Jenkins, Confluence, BitBucketResponsibilities:• Consulting to the business on the new GIS infrastructure• Interpret business requirements and implement technical solutions, including:- Migration scripts to automate transition from Oracle and site SDE instances- Integration with third party systems through python scripting for nightly batch processes• Upgrade ArcGIS Suite, including:- Installation of ArcGIS Server and Portal- Creating system tools in ArcCatalog to simplify processes- Developed a Data Management tool and Presentation Layer synchronisation to ensure consistency of data across environments (Dev, Test, Prod)- Designed and developed Staging and Archiving (including row level archiving) strategies for datasets• Provide recommendations to the business to improve current processes with the Enterprise GIS System• Execute compliance and security checks on Servers and Databases.• Support and development for Web mapping applications• Provide support to GIS user community and team members including:- ESRI Software suite (ArcGIS, ArcSDE, ArcGIS Server)- Python- Database Support- Troubleshooting issuesAchievements:• Migrated all GIS data from Oracle and site SDE instances into a centralized SQL Server SDE with minimal outage to users• Designed and Implemented a Data Management system to control changes to production data and maintain history for compliance• Planned rollout of Data Management system to all GIS units with BHP Globally

Paris, France, Fr

Technical Environment:ArcGIS, ArcFM, Oracle, Toad for Oracle, PythonResponsibilities:• Consulting to the business on the new GIS infrastructure• Interpret business requirements and implement technical solutions, including:- Migration scripts to automate transition from the legacy system, in an efficient, accurate and repeatable process- Business logic for custom ArcFM Auto Updaters- Distributed client / server engine for processing bulk data- Integration with third party systems through python scripting for nightly batch processes• Provide recommendations to the business to improve current processes with the Enterprise GIS System• Provide support to GIS user community and team members including:- ESRI Software suite (ArcGIS, ArcSDE, ArcGIS Server)- ArcObjects and Python- Database Support- Troubleshooting issuesAchievements:• Automated many ETL tasks to improve efficiency and reliability • Developed new systems in ArcGIS to deliver data to the business in shorter timeframes

Perth, Western Australia, Au

Technical Environment:Geocortex, ArcGIS, ArcFM, Oracle, Toad, PythonResponsibilities:• Consulting to the business on the new Geocortex infrastructure• Customise Geocortex workflows to meet business needs• Troubleshoot limitations with the installation within a clustered environment• Provide GIS, Python and SQL Guidance, Training and Support to team members• Provide recommendations to the business to improve current processes with the Enterprise GIS System• Established processes and procedures to update Geocortex Sites, in an efficient, accurate and repeatable process• Led third party company to achieve required business outcomes• Interpreted business requirements and implemented to technical solutionAchievements:• Successfully implemented the new spatial web mapping application

San Ramon, Ca, Us

Technical Environment:ArcSDE, ArcGIS Server, ArcGIS, Python, Oracle, Toad, SQL Server, Team Foundation Server, FME, Shell Scripting, BMC Remedy, DocumentumResponsibilities:• Consulting to the business on new ArcSDE infrastructure• Upgrade and enhance the spatial data repository - Installing of ArcSDE 10.0 - Setting up custom Oracle System procedures to ensure consistency when creating users - Creating system tools in ArcCatalog to simplify processes - Developed a Data Loading / Backfill tool and Presentation Layer synchronisation to ensure consistency of data across environments (Dev, Test, UAT, Prod) - Automated the publishing of ArcGIS Server Services - Administering Corporate Datasets within ArcSDE and Oracle, through python and PL/SQL - Designed and developed Staging and Archiving strategies for datasets• Integrate with third party systems through python scripting and oracle database links - Custom nightly batch processes - Automatic notifications of script execution• Execute compliance and security checks on Servers and Databases.• Implement change request on Production environments during outage windows• Provide support to GIS user community and other integrated communities including: - ESRI Software suite (ArcGIS, ArcSDE, ArcGIS Server) - Database Support (Oracle, SQL Server, and Microsoft Access)• Maintain and document Oracle views, snapshots, database links, user profiles and roles • Backup support for Geocortex, including:• Support other GIS Project teams and Asset development GIS groups where related to Extract Transform Load (ETL) process• Provide support for ArcGIS/Windows server scheduled data management tasks • Troubleshooting and Enhancing Integration between various systemsAchievements:• Successfully upgraded and enhanced spatial data repository• Automated many ETL tasks to improve efficiency and reliability • Developed new systems in ArcGIS to deliver data to the business in shorter timeframes

Perth, Western Australia, Au

Technical Environment:ArcGIS, Python, Oracle, Toad, Visual Studio, FME, FME Server, CognosResponsibilities:• Consulting to the business on new ArcGIS and FME infrastructure• Provide GIS, Python and SQL Guidance, Training and Support to team members• Development of PL/SQL and Python scripts for use within ArcGIS• Development of ArcObjects applications to automate bulk data corrections• Administering Corporate Datasets within ArcSDE and Oracle• Troubleshooting and Enhancing Integration between various systems• GIS Reporting using ArcGIS and FME• Manage and maintain FME Server environment, including scheduling and security• Provide supporting data for Internal and Government Reports− Create and maintain Cognos Reports − Extract data from corporate data warehouse using SQL• Project Management− Liaising with Project Team and Business Leaders− Coordinating project outcomes− Sourcing of information for project− Investigating new concepts− Solution Design• Projects involved in:− Data Validation for New GIS System− Network Capacity Mapping Tool− Installation Date of Wood PolesAchievements: • Received Bright Spark award for Working Together • Completion of Installation Date of Wood Poles project• Completed advanced Cognos training• Developed new systems in ArcGIS and FME to deliver data to the business in shorter timeframes • Determined process improvements in ArcGIS and FME which were rolled out to the team

Technical Environment:C#, VB.Net, ASP.Net, VB6, SQL Server, PHP, MySQLResponsibilities:• Development of .Net Applications− Developed a system for track and trace of stock items utilised by Domestic and Export Dealers in .Net Framework− Developed a program in .Net Framework for integration between time and attendance systems and Human Resources Information System− Developed an internal website for stock management in ASP.Net Framework • Support SQL Server Databases inclusive of: − Development of custom Store Procedures, Triggers− Ad-hoc requests for data extraction− Management of Backups and ensuring reliability and integrity− Linking to external data, via Linked Servers• Implementing MYOB EXO Business Accounting and Warehouse Systems• Customer needs analysis, troubleshooting, and technical support• Customising Systems for the Australian business unit inclusive of:− Writing stored procedures to extract data for Stock, Finance and Management Reports− Reporting using SQL Server− Created triggers to enhance MYOB data integrity using SQL Server− Custom scripts for ASX and Backups of Data • Data Importing • Web development inclusive of:− Developed the web application and interfaces to manage and view the site in PHP− Wrote stored procedures to manage the structure of the company website• System Integration inclusive of:− MYOB EXO Business to existing in-house custom applications − MYOB EXO Business to Web Ninja Web store− MYOB EXO Business to The RIC Group Mobile Devices • Troubleshooting and ad-hoc development on requestAchievements: • Achieved results in a green fields environment.• Introduced a new concept to a supplier firm (Web Ninja) for integration with MYOB EXO Business. It was later accepted and used in their product.• Developed a program in VB.Net for integration between time and attendance systems and Human Resource Information System.

Technical Environment:C#, ASP.Net, SQL SeverResponsibilities:• Developed web portal to manage company payment systems electronically• Provided Guidance, Training and Support to team membersAchievements:• Website developed to specification, on time and within budget.

Brisbane, Qld, Au

Technical Environment:C#, ASP.Net, SQL Sever, Python, ArcGIS Desktop, ArcGIS Server, ArcGIS Image Server, ArcSDE, ArcObjects, ArcFM, FMEResponsibilities:• Work within pre-existing requirements to ensure client’s needs were met• Installation of ESRI’s existing application on client systems, including:− ArcGIS Desktop− ArcGIS Server− ArcGIS Image Server− ArcSDE• Configuration of ArcGIS Server and ArcGIS Image Server• Determined what applications support was required for the client• Customised components of the ArcGIS using Python and C# for updating of clients data• Configuration and Customisation ArcFM System – Fluid transfer software• Use of FME including:− Converting Data between formats (DGN to ESRI, MapInfo to ESRI, CSV to ESRI)− Extracting feature types from datasets for specific analysis− Creating custom applications incorporating FME API to automate processesAchievements:• Recognised by the leadership team as having the ability to solve complex problems in short timeframes.• Developed a Python Script to automate client data updates that was 30% faster and reduced costs by 40%.• Completed ESRI’s ArcGIS Image Server course

Technical Environment:C#, VB6, SQL Server, ArcGIS, ArcObjects, MapObjects, eCognition, Z/I Imaging, FMEResponsibilities:• Successful completion of projects at all stages of the Development Lifecycle:− Automatically updating data for the Australian Navy Meteorology and Oceanography (METOC) section − Property classification for Insurance Evaluation− Industrial Monitoring of Slab yards and Hot Coils for Steel Manufacturer• Meeting with clients - Determine clients requirements, resource allocation and agree project time lines• Managing two teams totaling 15 Staff across Programming and GIS this included:− Mentoring− Coaching− Performance management− Allocation of caseload• Use of FME including:− Converting Data between formats (DGN to ESRI, MapInfo to ESRI, CSV to ESRI)− Extracting feature types from datasets for specific analysis− Creating custom applications incorporating FME API to automate processes• Digital imagery processing of large amounts of data quickly for further processing by other departments• IT Support including installation and monitoring of servers, managing blocked emails in spam filters, handing general IT issuesAchievements:• Promoted to a leadership role within 6 months.• Managed major projects that were delivered successfully, to deadline and to specifications.• Improved efficiency of a process for a major insurance client that enabled the retention of the client.

Bachelor Of Computer Science With Distinction, Major In Distributed Systems And Software Development

Diploma In Geographic Information Systems

Education record