Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Alistair Sim | Elance
 
176985602337900
Last Sign-in: Dec 17, 2014

Alistair Sim

Software and Database Expert
   South Africa
Gordon'S Bay
  |  2:22 am Local Time

Verified Freelancer

Alistair Sim's identity has been verified.  Learn More

Overview

Minimum Hourly Rate $27

With 15 years experience in the IT sector, gained from SME to Multi-National Enterprise level, I can offer Corporate quality at SME pricing.
I have gained experience in development, analysis and management, across a variety of business sectors, making me the ideal one stop shop.
My experience is backed by a Business degree in Information Sciences.
I am a full-time freelancer, so thus have no conflict of interest with a day job.

Read More »
Nov 8, 2014|Other IT & Programming|$400|Completed
|
5.0
Jul 24, 2014|Business Intelligence|$1,000|Completed
|
5.0
Jul 8, 2014|Database Development|$142|Completed
|
5.0
Jul 8, 2014|Scripts & Utilities|$450|Completed
|
5.0

View All »

Portfolio

During my time with C3 Applecart, I maintained and added functionality to...
Designed logo for company, using elements of their trade. Redesigned the site , using...
http://www.hh-steel.co.za
Website for a guest house in the Karoo, South Africa. Done in php, using AJAX
A Joomla catalog website for a local clothing manufacturer.
http://www.redemptionphysiquewear.co.za
A range of micro websites for entrepreneurs in the emerging markets of South Africa....
http://www.qualitypainters.co.za
Created and managed databases in MSSQL Server for FrontPage HEAT Data. These reports...
http://www.mixtelematics.com
I used VBA6 and WinSCP scripting to create a program that continuously pulls 3rd party...
I created a web site for Libstar. The picture group on the right hand side is an AJAX...
Redesigned a global corporate's SIM card management system, which manages in excess of...

Skills (10)

Tested
Microsoft Excel 2007 Test
My Score
avg
Access
My Score
avg
SSRS
English Spelling Test (UK Version)
My Score
avg
Passed

Service Description

Software Development
I have over 10 years experience coding VBA and use that for any Microsoft Office Driven development, including automation of business functionality and implementing database interaction.

Report (and Dashboard) Writing
I was a Manager - Data Analyst at a global mobile telemetry provider. I write management and operational reports, based on CRM data, to aid co-workers and managers.
These reports were based on Frontrange HEAT and Salesforce.
SQL Server Reporting Services was my tool of choice here.

Systems integration
I have experience using both SOAP, as well as RESTFull Web Services to integrate systems between my clients and their service providers.
I use php for systems integration to either interact with, or create API's. These integrations invariably rely heavily on database interaction, where I use mainly MS SQL Server and MySQL

Functional Specifications
While working as a Project Manager, I had to also fulfil the role of Business Analyst. I found that our projects were going over budget, as they were not specified and planned sufficiently.
I excel in extracting business requirements and documenting them. Documentation is important, but should also not be excessive, as this cuts into the budget too.
It is an art doing documentation that is clear, but also not costly.


Read More »

Employment

MiX Telematics
Manager: Data Analyst
2012 - 2014
Management Information Reporting. Dashboards and detailed reports (SSRS and Visual Studio) Salesforce Champion Frontrange HEAT Administration. Software Development Development and...
One Digital Media
National Hardware Support Manager
2010 - 2011
3rd Line Linux Support - for Linux based bespoke software on more complex software issues and hardware compatibility Operational Management - Managing the Hardware Service Department (HSD) in...
Public Display Technologies
Technical Team Lead
2009 - 2009
Supervisory function for Maintenance and Support Department. 3rd line support were for the following platforms: Linux (Fedora and ubuntu) Moodle dZine IDS (digital advertising and...
Think Open Software
Project Manager
2007 - 2008
Managing Open Source projects done in php (Zend)and Drupal
Computer Colour Concepts
Senior Web Developer
2007 - 2007
Web development and maintenance in Lasso Database development and Maintenance in Filemaker and MySQL
Mindset Network
Datacast Specialit
2005 - 2007
Systems analysis Specialist function (Satellite based data delivery) Project management (Remote system and interface updates) Version control and content management
Hottentots Holland Steel
IT Manager
2003 - 2005
Desktop Support Network Administration Web Development Web Administration
Sainsbury's Supermarkets PTY LTD
IT Contractor
2001 - 2002
VBA development Business Change Facilitation Lecturing
Unischool
IT Lecturer
1999 - 2000
Lecturing Computer literacy and MS Office to adult audiences

Education

University Of Pretoria
Bachelors of Commerce (Informatics)
1997 - 2000
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

SQL Server
VBA
MySQL
PHP
SFDC
integration
Web Services
JSON
Reporting Services
slim php
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
primalfusion
Type
Individual
Member Since
January 2009
Elance URL
Verifications
0
Groups
Alistair Sim | Elance

Alistair Sim