Management of Crypto assets. Please contact me for more information.

Project 1 - CTI (Computer Telephony Integration)

Requirement

Develop, test and prepare release candidate for a CTI (Computer Telephony Integration) add-on product to MYOB’s ERP solution, EXO Business. The EXO CTI product was to provide core functionality such as:

  • “Screen-pops” on inbound calls (EXO interface with customer details automatically appears on screen when handset is lifted)
  • Outbound dialing from within the EXO interface (clicking a button on the customer screen)

Solution

  • Research the Unified Communications (UC) market space with a focus on vendors NEC and Avaya to determine hardware and software required for prototype development
  • Initial indication for vendor hardware and software costs alone were approx. $30,000. After protracted discussions with various channel partners I determined we could in fact develop a "1st party TAPI" based prototype for 10% of the initial figure.
  • Proceeded through development and testing of EXO CTI Agent

Technologies

  • Windows Forms .Net (CLR 4.0 / c#)
  • CTI / TAPI
  • SQL Server

Project 2 - SharePoint 2013

Requirement

  • The business had grown rapidly over the last decade and with that growth a volume of valuable business IP had been created but was often difficult to find. In particular informal “Tip Of The Day” emails distributed to all users contained a vast amount of valuable unstructured technical information that had a short life span due to the ephemeral nature of email.
  • Additionally, the business was looking for superior ways to collect unstructured data and access the most challenging of all data silos: the information in the mind of experienced consultants.

Solution

Adopt an Enterprise 2.0 culture within the organisation couple with a SharePoint implementation offering a "Google grade" experience

  • Implement a live prototype SharePoint farm with a primary focus on Search Centre
  • Designed Search Centre Verticals to cover all possible silos of information:
    • Network shares
    • Legacy mediawiki
    • Subversion
  • Integrate Search with SQL Server based support ticketing system using Business Connectivity Services with the ability to:
    • Search issues and resolutions
    • Expose key EXO CRM attributes as SharePoint managed properties to facilitate Search Alerts
  • Designed and implemented a SharePoint Community, Tip Of The Day:
    • This community quickly replaced the informal emails
    • Staff enjoyed participating in the Community, incentivized by the "reputation points" system and custom badges tailored to the organizational culture
    • Initially connected the Community to Outlook to ease the transition

Technologies

  • SQL Server
  • JavaScript
  • XLST
  • SharePoint 2013
    • Farm design, implementation and management
    • Search Centre design, implementation and management (Result Sources, Query Rules, custom Managed Properties)
    • Business Connectivity Services / Line Of Business (LOB) integration
    • Client side rendering development (JavaScript, XSLT)
    • Service Applications (Secure Store, User Profile Service, Managed Metadata)
    • Term Store Management

Requirement

A well-established Accounting practice had always had high standards around development and maintenance of business IP (policies, procedures, MS Office templates etc.) but was finding it increasingly challenging to manage and locate this valuable content. Additionally, over time multiple copies of some documents had come into existence and in some cases they were not up to date.

Solution

  • Established and convened a project team to meet once a week and review every last document.
  • Implemented a fairly standard OOTB SharePoint Foundation 2010 farm to host reviewed content.
  • As the project team completes a batch of documents they were added to SharePoint and established as the "source of truth" for the latest version.
  • Customised Search Centre results

Technologies

  • SharePoint 2010
  • JavaScript

Formed with an ex-colleague, a business was created for the purpose of developing smart device (iPhone) and Social Media applications.

Whilst we successfully released a product to market it did not enjoy commercial success though its free counterpart was downloaded at least 20,000 times.

Technologies

  • iOS 6.0
  • xCode
  • Objective-C
  • SQL Server

Project 1 - Life company data mart

Requirement

The Life company utilized Excel models that pulled data from the central data warehouse (which was in turn populated from Dimension Data). The data retrieval was taking far too long and impeding the productivity of Market Analysts and Portfolio Managers

Solution

Develop a data mart specific to the needs of the Life company (of the total number of instruments in the data warehouse only about 10% were relevant):

  • Created data mart by scripting T-SQL to replicate a trimmed design of the data warehouse within Life infrastructure
  • Developed ETL packages to populate Life data mart from Challenger data warehouse each night

Technologies

  • SQL Server
  • SSIS

Project 2 - RMBS Deal Analysis

Requirement

The Structured Credit team needed a fast and efficient way to process and summarize trustee reports and market data of RMBS securities.

Solution

  • SQL Server database to hold security data & ETL packages to import trustee reports
  • ASP .Net web interface integrated with Infragistics charting library to present security data in a dashboard style including charts of attributes such as tranche rating, LVR, arrears, ageing and maturity

Technologies

  • SQL Server
  • SSIS
  • ASP .Net (c# / CLR 4.0)
  • Infragistics Web Charts

Project 3 - Market Indices

Requirement

Analysts and Portfolio Managers required a fast and intuitive way to view and extract data from a range of market indices covering asset classes such as fixed interest, structured credit and equities. The frequency of the source data points was very heterogeneous, so the system needed to interpolate missing values seamlessly. Solution

  • SQL Server database to hold market data including CLR stored procedures for interpolation
  • ETL packages to import data from various source
  • Web interface to allow rapid viewing of charts as well as extraction of data in a variety of formats

Technologies

  • SQL Server
  • SSIS
  • ASP .Net (c# / CLR 4.0)
  • Excel 2003 / 2007
  • Dimension Data
  • FT Data

  • Performed enhancement work on existing Australian Equities Portfolio Management System
  • Assisted with review of database design for prototype of Index Fund Portfolio Management system

Technologies

  • Sybase ASE
  • Visual Basic

Project 1 - Unit registry migration

Requirement

Consolidate wholesale and retail Composer databases

  • Develop and test SQL migration scripts

Technologies

  • Sybase ASE

Project 2 - Correspondence (Investor statements)

  • Development, maintenance and performance tuning of stored procedures (some of which were several hundred lines long) to extract data from Composer for client correspondence and statements
  • JetForm development

Technologies

  • Sybase ASE
  • Composer
  • Hi-Port
  • Jetform

Project 3 - Australia Equities

  • Maintenance of Australian Equities Portfolio Attribution system
  • Development of system to import and manage broker supplied quantitative data and consensus

Technologies

  • Visual Basic
  • VBA (2003 / 2007)

Project 4 - Fixed Interest Portfolio Management

  • Maintenance of existing Portfolio Management system
  • Maintenance of Hi-Port data import

Technologies

  • VBA (2003 / 2007)
  • Hi-Port