Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Dieter T. | Elance
 
176985602337900
Last Sign-in: Nov 30, 2015

Dieter T.

Well experienced analyst developer
   Australia
  |   Wellington Point, Queensland
  |  8:10 am Local Time

Overview

Minimum Hourly Rate $55

Substantial experience in Excel automation, Access Development with SQL backend. Designed and programmed several cost management and reporting tools using a combination of these systems in the Construction industry over the last 3 years.

I also have experience in the telecoms, retail and manufacturing industries, having filled a number of roles including Business Analyst, Cost/Project Controller and Project Manager.

I believe in a structured approach lending itself to an Agile development approach where functionality can be displayed or...

Read More »

Skills (5)

Tested
Access
My Score
avg
Passed
Microsoft Excel VBA
VBA
My Score
avg
Passed
Excel
My Score
avg

Service Description

Development in Excel

Past projects include work labour time allocation system that delivered the project's daily workforce reports by work package, covering worker classifications by skill (e.g carpenter, electrician) and work type (permanent works or indirect works). This was the feeder system for blue collar payroll handling at peak more than 1000 personnel.

Combined system with Access as front end, SQL as database and Excel for reporting:
Designed and programmed the system to record all details of personnel, equipment usage on a daily/hourly basis, act as procurement feeder system. Contained further features of budget management, daily reporting and HSE reporting.
A number of automated excel reporting tools were built to facilitate daily reporting with limited user interaction, cost reporting (budget vs actual, S curves).

A Plant Management component allowed the recording of inspections, services, defects, defect resolution, odometer information and reporting to provide an overview and detail of the performance of this function.

A corporate plant management module allowed for the management of registrations, certificate management, service and Odo data, equipment information and standard / project specific charge out rates. The module enabled tracking of allocation to projects / personnel and the generation of charge-out billing.

Read More »

Education

Heriot-Watt University
Masters in Business Administration
2000 - 2004
University of South Africa
Bachelor of Commerce
1991 - 1996
University of the Orange Free State
Post Graduate Diploma in Financial Planning
1989 - 1990
University of Pretoria
Bachelor of Engineering (Chemical)
1986 - 1989
Overview  |  Job History  |  Resume/C.V.

Keywords

construction
project control
cost control
plant management
HSE reporting
Excel
VBA
SQL
My Snapshot
All Categories
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
DThierry
Type
Individual
Member Since
March 2015
Elance URL
Verifications
0
Groups
Dieter T. | Elance

Dieter T.