Philip Hinton Email & Phone Number

Auckland, New Zealand

Auckland Museum is putting all its collections online (including the Online Cenotaph).My initial six-month contract was analysing and correcting the non-military data in the museum's two databases. With over 100 years of data to sort through, we concentrated on "quick wins".My second six-month contract focussed on the military records (Cenotaph), cleaning and ingesting WW2 soldiers records. This enhanced 40,000 existing records and added 76,000 new soldiers!The third contract, for 12 months, dealt with 14 data enhancement, cleaning, and standardisation projects.It was with great pleasure at the end of that last contract that I was given the new permanent full-time role of Collections Data Analyst!In the first week of February 2017, I gave a 15 minute presentation to the Collections and Research teams on my new concept "Dataeology" (the information equivalent of archaeology). This was very well received, with comments like "You made data fun!", "Interesting", "Amusing", "I didn't know Excel could be so much fun", "I understood 95% of that!". Following that, I've had many requests for help with Excel projects.In November 2018, I gave a four-hour workshop on "No Programming Required! Data Cleaning for Non-techies" at the National Digital Forum conference in Wellington. We had 19 attendees! Four hours proved to be not long enough, and we had a few technical hitches, but I've had good feedback. I have used the workshop material to create an Intermediate Excel training course at Auckland Museum.As a result of the 2018 workshop, I was invited to Wellington by Te Papa Museum to give two one-day Intermediate Excel workshops to selected staff. Because of the volume of material, I later ran four follow-up Zoom tutorials on Tables, Pivot Tables, and formulas.This job is very important for the overall Collections Online project, is stretching me in good ways, and is a lot of fun!

Field crew job schedule creation and Job Management software management. Field Service Mobility superuser.Computer and job management systems support. Systems and process innovation. Microsoft Excel "subject matter expert": including developing VBA macros for process automation. Technical support and training.Created contract-specific maps and spatial data analyses using ArcMAP for parks maintenance staff and contract managers.Attended four Field Service Mobility conferences (Auckland and Sydney) and gave successful presentations at each location.

Management of City Parks' Street Garden maintenance crew. Street garden landscape design and construction.Created various automated spreadsheets for job costing, vehicle checks and the gardeners' scheduled work, amongst others.

Henderson

Processing water billing accounts, water meter applications, water meter readings, etc.My best success was discovering that our ancient database could record macros (unknown by my colleagues), from which I developed a process for dealing with meter re-reads that saved 35 keystrokes per reading, cut paper printouts by 50%, staple use by 100%, and trips to the printer to one.I also developed a list of the common property management callers so I could surprise them with knowing all their details when they called - they loved it!

Auckland, New Zealand

Updated WCC's garden spatial data and maps using existing data, "as built" diagrams, and personal knowledge from my time at Techscape.Developed the use of geospatially-aligned "as built" diagrams as overlays in the MapInfo program from which to trace correctly sized and located assets on their own layer.

Waitakere City

Management of Techscape's Parks and Street Garden maintenance crews for Waitakere City Council assests. Garden landscape design and construction. "Technical expertise" for yearly Trees for Babies and Community Street Tree Planting events - assisted in selecting planting locations, ordered and delivered trees, demonstrated planting techniques at each event, organised after-event tree maintenance.Computer and software support. Excel spreadsheet development for management and admin staff.I was also one of the company's two Internal Process Auditors.

B. Hort (Tech)(Hons), Horticulture

Activities and Societies: Proofreader for Massey's student newspaper, Chaff. Member of Massey's Toastmasters.Learned how to use.

Bsc., Biology, Botany, Geology, Chemistry

Activities and Societies: Christian FellowshipUndergraduate first year only, year off to re-evaluate study plans, then to Massey.