Recent Projects:
Open House Portal
| Objective |
Web-based application to display Open Houses including mapping, driving directions, and integration with 3 systems in real-time
| | Details |
-
Public web site to search, map and retrieve directions to open houses of properties for sale
- Private site to allow estate agents to enter and edit open houses
- Communicates in real-time with a national MLS system using .NET Web Services
- Communicates in real-time with various MLS systems through a RETS (Real Estate Transaction Server) using XML
- Integrates with Microsoft MapPoint Server through .NET Web Services to create and display maps with driving directions
| | Technology |
C#, ASP.NET, VB.NET, SQL Server, .NET Web Services, RETS (XML Server), Microsoft MapPoint Server, Virtual Earth Mapping
|
Development of Front Office Management Software
| Objective |
Create commercially viable software to manage the front desk of a real estate office including property inventory, appointment scheduling, message taking and paging, and various reporting and management functions
| | Details |
-
Initial program was developed in Clipper (pre Windows timeframe)
- Program was then rewritten in Visual Basic 6 (pre- .NET technology)
- Current program primarily in .Net (C# & VB.NET)
| | Technology |
Clipper, Visual Basic 6, Access, SQL Server, MySQL, C#, VB.NET
| | Outcome |
This software has become the most widely used software in it’s market with over 1,000 installations in two countries
|
CRM Implementation & Customisation (including order Entry System)
| Objective |
Assist with the Vendor selection process of a new CRM system
Implementation of the new CRM system combining data from 3 separate systems (Access, ACT!, Oracle 9i)
Build and integrate a Order Entry System including real-time credit card processing
| | Details |
-
Required amalgamating three databases from three separate systems and formats into the new CRM system
- Building an order entry system based on .NET technology that integrates with the CRM system and processes credit card transaction in real-time
| | Technology |
ASP.NET, VB.NET, C#, SQL Server, Oracle 9i, Windows 2003 Server, Sun Server, Sun Learning Management System
|
Royalty Billing & Reporting System
| Objective |
Web-based application allowing over 200 remote sites to report sales for the purpose of royalty billing and statistical reporting
| | Details |
- Developed a web-based application including sophisticated JavaScript for royal calculations
- Ported millions of records from a legacy application into the newly developed system
| | Technology |
SQL Server, Active Server Pages, JavaScript
|
Statistical Application
| Objective |
Provide statistical information on property sales
|
| Details |
Statistical program written completely in SQL Stored Procedures
|
| Technology |
SQL Server, Transact-SQL, Crystal Reports
|
Government Job Databank
| Objective |
Create a web site for the Federal Government to allow users to search and display jobs available through the federal manpower system
|
| Details |
-
Required the ability of employers to electronically post jobs on the government job board
- Managed the system for 2 years until government IT department could be sufficiently trained to take over the system
| | Technology |
ASP, IIS, Visual Basic 6, SQL Server, Access
|
CRM System - Development
| Objective |
Web-based application for use by 3,500 members of a national organization
|
| Details |
- System allowed the management of clients including tracking correspondence, mailings, customised searches for each client, and ability to provide each client with a customised web page to view their information and correspondence
|
| Technology |
Active Server Pages, SQL Server
|
eCommerce Website for Pharmacies
| Objective |
Create an eCommerce site for several pharmacies allowing uses to search and order products
|
| Details |
Site was designed for 2 online pharmacies to increase their sale through providing products over the internet
| | Technology |
Active Server pages, SQL Server, Access
|
MLS Listing Service
| Objective |
Create a proof of concept MLS system to support a 2,000 member association involved in selling properties
|
| Details |
-
Developed an ASP.NET private web-based application hosted on IIS with a SQL Server backend
- System included searching, reporting, photo database management, client management, integration to external sources for information such as tax information for a particular property
| | Technology |
ASP.NET, VB.NET, .NET Web Services, SQL Server
|
MLS Technology Strategic Review- Outsourcing
| Objective |
Reviewed the organisation’s strategic IT direction and recommending outsourcing the major IT MLS system
Assisted with the selection and implementation of the new system
|
| Details |
-
Conducted a review with all key stakeholders to determine the best strategic direction for the organisation
- Lead various committees and the Board of Directors through the RFP process for vendor selection and ultimate decision
- Presented decision at the Annual General Meeting
- Worked with new vendor during implementation process
- Created various applications to integrate with the new MLS system
| | Technology |
SQL Server, ASP.NET, VB.NET, Crystal Reports, Windows 2003 Server
|
|