Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Profile >
Portfolio
Bryan Hogan

Pump Inspections Database

by Bryan Hogan, last login 386 days ago

Description
Job Title: Pump Inspections Database
Company: Alco Pumps (Australia)
Role: Analyst/Programmer
Difficulty: Simple
Duration: 4 weeks
Software Skills used: Access 2007, Excel 2007, Excel/XML Schema integration using XSD, XML, ADO, Outlook 2007

Alco Pumps are a client of JCN Systems who use a number of inspectors to inspect pumps on various sites and complete risk assessments of the sites. The results of these inspections are then provided to the clients who own the sites. Prior to my involvement the inspection forms were sent to the inspectors as PDF forms which were filled in by hand and then returned for manual re-keying into a database with a single table. I re-designed this database to provide a normalised structure that allowed for the storage of multiple inspections instead of the most recent inspection only. I developed Excel forms using security, data validation, VBA programming and XML mapping so that each inspector receives a form listing their sites for inspection. The forms are then filled in, validated and re-submitted to Alco as XML so that the data can be imported directly into the database for the production of reports. The processes of creating inspection schedules, creating the forms for each inspector, emailing the forms and importing the returned inspections were fully automated.
Tags
Access Excel XML
176985602337900
Last Item
CZ
Bryan Hogan

Bryan Hogan

Microsoft SQL Server Programming, Microsoft Access...
Prague, Prague
New on Elance
50/hr
rate
About Bryan Hogan
Many office workers and managers spend their days on repetitive tasks, trying to make sense of their workload and attempting to glean some information about their business from seemingly meaningless data. This is usually due to a lack of software systems, or poorly developed ones. With over 20 years of experience, my goal is to provide integrated systems that automate manual repetitive tasks and make sense of complicated data. This frees up people so that they can apply intelligence to their job...
More Samples
Bryan Hogan | Elance

Bryan Hogan