Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Bryan Hogan | Elance
Last Sign-in: May 21, 2014

Bryan Hogan

SQL Server/MS Access/MS Excel Analyst/Developer
   Czech Republic
  |   Prague, Prague
  |  1:24 am Local Time


Minimum Hourly Rate $50

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 jobs instead of constantly 'fire-fighting' their...

Read More »


Job Title: Pump Inspections Database Company: Alco Pumps (Australia) Role:...
Job Title: Mobile Phone Pricing Plans Database Company: Optus (Australia) Duration: 1...
Job Title: Doctor's Registration Database Company: Post-Graduate Medical Education and...

Skills (8)

MS SQL Server 2000 Test
My Score
MS SQL Server 2005 Test
My Score
SQL Skills Test (Hands-on programming skills)
My Score

Service Description

My speciality is developing database solutions using MS SQL Server or MS Access that are integrated with Office products such as MS Excel, MS Word and MS Outlook to provide a complete solution. Workflow management, document management, data analysis, all of these are 'parts of the picture' which are included in final solutions.

I also like to think outside of the box. My most recent major project was for Optus, one of the major telecommunications companies in Australia and SE Asia. They needed a database and workflow for creating pricing plans for mobile phone service providers. This market is highly volatile, and therefore new facets are continually being added to plans. Overnight, a feature such as accessing Facebook from your smart phone can become a must have for customers. In a standard normalised database, requirements such as adding new fields can add to changes to tables, stored procedures and views even a simple change such as one new field, when put through a change management process, could take a week or more to implement. Instead, I suggested a design where the pricing plan is stored as an XML document in the database. That way, a new field indeed, an entire new section can be added to the XML document without a single change to the database structure. By validating the XML against an XML schema, business rules can still be strictly enforced so that data integrity can be verified. By using the XML capabilities of SQL Server the data can still be viewed...

Read More »


JCN Systems Pty Ltd (Australia)
Freelance Programmer
2011 - Present
JCN Systems, is an IT Consultancy/Solutions provider based in Sydney/Bowral NSW Australia. I have provided solutions for several of JCN's clients, including...
Optus Telecommunications (Australia)
Database Analyst/Programmer
2009 - 2010
Software Skills used: SQL Server 2005 with XML, Excel 2007, Excel/XML Schema integration using XSD, XML, ADO. I developed an application for the marketing team to create tariffs for clients using...
Australian Government, Regional Development
2009 - 2009
Software Skills used: SQL Server 2005/2008, Access/Word/Excel 2007, Word/Excel/XML Schema integration using XSD, XML, ADO/DAO, Team Foundation. Worked in a team of four to assist in the development...
Thinkronicity Pty Ltd (Australia)
2008 - 2009
Software Skills used: XML/XSLT/VB.Net. As part of a project delivering reports for the New Zealand Transport Agency I developed documentation, test cases, test scripts and XSLT transformation scripts.
Westpac Bank (Australia)
2002 - 2009
Software Skills used: Access 97/XP, Excel XP, MS Chart, Adobe Acrobat PDF, VB.NET. This project commenced initially in April of 2002. Acting as an Analyst Programmer for Thinkronicity Pty Ltd...
Post-Graduate Medical Education and Training Board
2006 - 2008
Software Skills used: SQL Server 2000/2005, Access, Excel, Word, Outlook, (all 2003), XML, ActiveX controls, SSIS, Outlook Redemption, Postcode Lookup software, SourceSafe, testing in Office 2007....
Outdoor Media Association (Ireland)
2004 - 2008
Software Skills used: Access 2000/XP, Access Snapshot Reports, Excel Pivot Tables. The OMA provides reports to its member companies in relation to revenue generated from advertising. A distributed...
Electricity Supply Board (Ireland)
2003 - 2005
Software Skills used: Access 97/2000/XP, Excel 97/XP, Oracle PL/SQL, Word XP, Outlook XP, XML 3.0. During this time I actually worked both full-time and part-time during 3 different periods. Jan...
Abbey College (Ireland)
2003 - 2005
Software Skills used: Access XP, Word XP, Excel XP, ActiveX Controls. Abbey College provided courses to Irish and foreign students, particularly in the teaching of English to foreign students. This...
Various IT Roles
1990 - 2001
Software Skills used: Access 2.0/97, MS SQL Server 7.0, Excel 3.0-97, Word 6.0/97, Outlook 97, ODBC, Siebel. I completed a number of IT assignments for companies including: - AXA Investment...
Various Roles
1980 - 1989
During this time I worked in various roles including: - 1982 - 1989 / Teacher / SA Education Dept & Inner London Education Authority - 1980 - 1982 / Office Manager / Adelaide College of the Arts...


South Australian College of Advanced Education
Bachelor of Education - Early Childhood Education
- 1982
SA School of Music and Audio Education
Certificate of Sound Engineering
- 1982
Adelaide College of the Arts and Education
Diploma of Teaching - Early Childhood Education
- 1979
Overview  |  Job History  |  Portfolio  |  Resume/C.V.


SQL Server
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
Per Client
Member Since
September 2011
Elance URL
Bryan Hogan | Elance

Bryan Hogan