Martin Davies CV - IT Trainer
- 1. CV Martin Davies Address: 15/19 Irving Ave Prahran, VIC 3181 Mobile: 0413 338290 E-mail:martin.william.davies@gmail.com MARTIN DAVIES MICROSOFT OFFICE TRAINER EXCEL ACCESS WORD POWERPOINT VBA OUTLOOK AS A TRAINER MY JOBIS TO PROVIDELEARNERSWITH: Relevance Enjoyment Confidence Empowerment
- 2. Career Summary: Specialty is MS Excel, Word, PowerPoint, Outlook, Access, VBA development and training. Experienced with corporate and private clients in group/classroom and individual tutoring. 16 years’ work experience in both industry and training; strong in database design and development; proficient in software design and programming with different computer languages, tools and environments; work effectively both in a team and individually. Academic Qualification: Jul 1999 - Diploma in Information Technology (Software Development), Swinburne University Aug 2004 - Certificate IV in Workplace Training & Assessment TRAINING Note that training is done on a contract basis as are software development assignments. I am currently focused on training as my career. 2016 COURT SERVICES VICTORIA Aug 2015 – Feb 2016 (5 months) County Court Windows 8/Office 2013 Project to rollout new computers with Windows 8.1.1, Microsoft Office 2013 and Lotus Notes upgrade to V8.5.3. Deployment training for 2,700 users. Includes training of champion users, Magistrates, Judges & general staff across 63 sites. 2015 NEW HORIZONS Apr 2015 – Jul 2016 (3 months) Client Barwon Water - Windows 8/Office 2013 rollout on MS Surface Pro 4. Deployment training for 200 users from management to field staff. Also general MS Office training – Excel, Word, Outlook, VBA (below all contract until Mar 2015) 2012-2015 DYNAMIC WEB TRAINING 2012-2015 WIZARD CORPORATE TRAINING 2012-2015 ODYSSEY TRAINING 2012-2015 SAXON’S LEARNING -IT TRAINING 2011-2012 PD TRAINING 2010-2015 KEYBOARD CONCEPTS COMPUTER TRAINING Standard and customised delivery of the following, in classroomand onsite settings. MS Excel/VBA MS Office – Word, PowerPoint, Outlook MS Access
- 3. 2009-2012 NEIGHBOURHOOD HOUSES (PRAHRAN & BOX HILL) Beginner and general computer courses Mature learners Updating older learners to the current PC landscape 2000–2008 SWINBURNE UNIVERSITY - SESSIONAL Diploma and CertificateI and II I.T. courses Software and databasedevelopment
- 4. DEVELOPMENT Feb 2016 – Apr 2016 SKILLTECH (GAS, POWER, WATER METER READING & MANAGEMENT) Maintain multipleMS Access databases duringplanning& development of new national online system. Improvement of software performance and functionality as partof business efficiency and prototyping for national model. Access/VBA/Excel. ODBC connection to SQL Server, creatingViews and Stored Procedures. Oct- 2011 - Dec 2015 JEMENA (GAS & POWER INFRASTRUCTURE) part-time contract role Improve and amend data processingfromprevious development at Jemena in 2011/2 to manage new data sources. Collation of largedata volumes and aggregate for electricity usageanalysis and planning by engineering staff. Oracle/TOAD/Access/VBA. Outputs in Excel format. Jun 2012 KEYBOARD CONCEPTS Use VBA to enhance an Access databasestoringpatient records to allowSMS functionality via Skype to confirmappointments. Onsitework with client Jan- Feb 2012 REVOLUTION RACEGEAR Update an old Access databaseto 2010 Extend functionality to improve analysisand reporting functions Improve databaseschema & data integrity rules to improve quality of data captured. Apr-Jun 2011 PENINSULA HEALTH – MEDICAL ASSOCIATION MEMBERSHIP DATABASE. Design & develop Access 2010 databaseto manage member details Email functionality. Interfaces with Outlook with VBA to contact members. Ongoing ad-hoc enhancements, e.g. storingmember photos, new reports Jul 2010 – Mar 2011 HAYS IT CONSULTING - SOFTWARE DEVELOPER Short term assignments - Access / Excel / VBA solutions –corporateclients: ROYAL VICTORIAN EYE AND EAR HOSPITAL ‘Emergency Dept. Daily Performance Report’ Automated the collection of data collated daily to monitor patient activity in the Emergency Department. Worked with an existingExcel fileto link to liveSQL Server data sources. PENINSULA HEALTH ‘KPI Quarterly Report’ Created a new Excel Spreadsheet (2010 version) Appropriate macros,conditional formatting etc. for executive level reporting. Updated and enhanced an older 2003 version for compatibility. DEPT. OF JUSTICE (CONSUMER AFFAIRS DIVISION) 'Events Calendar' database. upgrade existingAccess system to develop new data capture and reportingfunctionality Update interface. Worked closely with the clienton-site.
- 5. AMES(ADULT MIGRANT EDUCATION SERVICE) 'Human Resources Scorecard' automate time consumingprocesses involved in the quarterly production of the HR Scorecard by developing a system allowingdata extraction from in-houseHR software to Excel Importing data into Access for calculations/filtering/querying Linking back to Excel to allowPivotTables,Graphs etc. to be created and finally linked to an MS Word file(the Scorecard) Minimal data entry/calculation/formattingnowrequired of users,with great time savings. Worked closely with the clienton-site. Main technologies: MS Access, Excel, Word, VBA, SQL. Dec 2009 –May 2010 SOFTWARE TESTER REDGUM TECHNOLOGIES Ensure software under development meets agreed clientspecifications. Develop Test Cases,document testing results, record issues for resolution. Test User Interfaces Technology web based IssueManagement system – 'Jira' Testing of browser based software developed in VB.net. 2005 – 2009 MONASH UNI/DEFENCE SCIENCE TECHNOLOGY ORGANISATION (DSTO) Projects: Ordnance Management and Forecasting Tool Access databaseallowinghigh level Naval staff to create resourceand costingscenarios around Fleet management and ordnanceusage. Inventory component allowing monitoringof ordnancestocks. Logistics Cost of Ownership project Improve data capturequality by redesigningan interfaceto maintenance software. Manage and record data movements in and out of the defence environment. Various data sources exported from Defence systems to Excel, manipulated,then stored in Access Graphical Cost Analysis Tool (web based) Develop a database(MS Access) and Interface (VB.net web forms) for graphical analysis of multi-tiered costingdata over multiplemilitary platforms. Data imported from multiplesources and formats into Excel, manipulated then stored in Access. 2005 –2008 MULTIMEDIA PROGRAMMER (PART-TIME) Design and develop an interactiveliteracy programaimed at dyslexic / illiterateadults and children. technology - Macromedia Authorware, Windows Speech recognition functionality
- 6. 2001 – 2005 SOFTWARE ENGINEER, BOEING MS Access Databases Design & develop databaseprototype for Defence maintenance recording. Convert above to a VB.NET webforms interfacewith SQL Server database. Purchasingand receivinggoods system, relevant management reporting. Ongoing maintenanceof Boeing’s employee timesheet and task management database. Visual Basic Develop programto interrogate databaseand email notification to relevant employee when jobs become due. Develop programs for backup of critical data. Interfacingto various Access databases. Technologies Vb.net, ASP.net, Access,Excel, VBA, SQL.
- 7. Technical Skill Summary: Skill Level Years Access Advanced 15 Excel Advanced 15 VBA Advanced 14 VB6 Advanced 4 VB.net Intermediate 1 ASP.net Intermediate 1 Macromedia/Adobe Authorware Advanced 15 SQL Advanced 13 Database Design & Development Advanced 13 Software Testing & Documentation Intermediate 1 User Documentation Advanced 13 ODBC Advanced 11 Oracle/TOAD Intermediate 2