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
 
176985602337900
Last Sign-in: May 21, 2014

Bryan Hogan

SQL Server/MS Access/MS Excel Analyst/Developer
   Czech Republic
  |   Prague, Prague
  |  7:32 pm Local Time

Overview

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 »

Portfolio

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)

Tested
Microsoft SQL Server Programming
MS SQL Server 2000 Test
My Score
avg
MS SQL Server 2005 Test
My Score
avg
Microsoft Access Administration
Microsoft Excel
XML
Microsoft Word
Microsoft Outlook
Microsoft Visual Studio
SQL Programming
SQL Skills Test (Hands-on programming skills)
My Score
avg
Passed

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...

Read More »

Employment

JCN Systems Pty Ltd (Australia)
Freelance Programmer
2011 - Present
JCN Systems, http://www.starcare.net.au/index.html 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
Analyst/Programmer
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)
Analyst/Programmer
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)
Analyst/Programmer
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
Analyst/Programmer
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)
Analyst/Programmer
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)
Analyst/Programmer
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)
Analyst/Programmer
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
Analyst/Programmer
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
Various
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...

Education

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

Keywords

SQL Server
Access
Excel
VBA
XML
My Snapshot
IT & Programming
2
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
bryan_hogan
Type
Individual
Member Since
September 2011
Elance URL
Verifications
0
Bryan Hogan | Elance

Bryan Hogan