Colin Nicholls

32 Heritage Drive, San Rafael, CA 94901
Voice: (415) 451-0142
email: colin at spacefold.com

17 years experience developing database application software and Internet middleware; building websites and e-business applications. Demonstrated strength in application design and technical documentation. Interested in XML technologies and open source development tools.  References available on request.

Work Experience

Nov 2007 - present: Oracle Developer and Business Analyst, EC Wise, San Rafael CA.
Oct 2005 - Nov 2007: Data Integration Consultant, dba Spacefold, for Bally Technologies, NV.
Apr 2003 - Oct 2006: Software Developer, dba Spacefold, for Microsoft Corporation, Redmond, WA.
May 1999 -  Jan 2003:  Solutions Developer, Acxiom Corporation, Little Rock, AR.
mid 1996 - Feb 1999:  Development Manager, Cornerstone Software, New Zealand
Sep 1993 - mid 1996: Senior Software Consultant, Cornerstone Software
Jan 1989 - Sep 1993: Software Developer, Telecom New Zealand

Education

1989 - Bachelor of Engineering (Electrical & Electronic), University of Auckland, New Zealand

Competencies

Skills: Software development; Object-oriented programming; Technical writing and documentation; User interface and API design; Web application and design; Database design and entity relationship modeling; Teamwork and Project management
Technologies: .NET 1.1 & 2.0; Java; Microsoft Visual FoxPro; VBScript/Javascript; XML DOM and SAX parsing, Web Services, SOAP, T-SQL, PL/SQL
Tools: Visual Studio 2005, SQL Server 2005, Apache Tomcat 3.x; Eclipse IDE; Apache Ant build tool; Borland JBuilder; Microsoft Expression Web; InstallShield; Inno Setup
Other Experience: Apache HTTP server (win32); Microsoft Internet Information Server; J2EE, Windows NT/2000 Network configuration; Siebel 7 eBusiness configuration; Jasc PaintShop Pro 7-10; Apache SOAP Toolkit; Cakewalk SONAR 6.0.

Career Highlights

Aggregated Business Data Portal (Nov 2004)

Designed and implemented a web-based portal in .NET 1.1 to show aggregated data from a variety of disparate data sources throughout the business, bringing common data together into a composite view, with expanding and collapsing regions for usability. Ported to .NET 2.0 in 2007.

Visual FoxPro 9.0 Reporting System (Apr 2003) and subsequent service releases (2005,2007)

Designed and implemented new features of Visual FoxPro 9.0, as part of the Visual Studio Data Team at Microsoft. These features include language enhancements as well as Integrated Development Environment (IDE) enhancements.

Sales Business Database Troubleshooting and Upgrade (Feb 2003)

Update and migration of various FoxPro systems. Implementation of web services exposing these systems, and fulfillment of additional data-mining/output requirements, for external browser- and application- based clients.

Web Services Engine (June 2002)

Maintained and exteneded a web service engine that provides a mechanism for query and update of a hosted Oracle prospect and customer database by third-party clients using SOAP transactions, using the Tomcat servlet container and SOAP toolkit components from the Apache Software Foundation, writing the web services and multi-threaded business logic in Java 1.3.1, using JDBC and JSP pages for support and administrative functions. Developed on Win32, deployed on Tru64 Unix.

Acxiom M.V.P Award (May 2002)

Presented by Acxiom’s AbiliTec Software Business unit for mentoring their team on XML messaging API issues.

Siebel-Acxiom Integration Toolkit (November 2001)

Installed Siebel eBusiness application server 7.0.3 and developed and documented a set of worked examples or “Labs” (using Siebel’s own courseware as a model) that walk a prospective Siebel configurator through the process of integrating Acxiom’s Batch CDI and real-time Solvitur4 Knowledge Broker XML service into a customized Siebel application.

MQ-Series/XML-HTTP bridge middleware (July 2001)

Co-developed a Java console application that listened for MQ-Series messages, transformed them using XSLT into Acxiom’s Knowledge Broker XML request format, and posted the results back on to a response message queue. Used Java 1.2, IBM’s MQ-Series Java SDK, and custom Knowledge Broker toolkit code.

XML Messaging Proposal (2001)

Prepared a proposal for how Acxiom could express their current and future products in a consistent XML messaging format. Although not adopted globally across Acxiom, many projects and business units in Acxiom used this document as a starting point for developing their specific XML message schemas.

Acxiom Bravo Project Excellence Award (2000)

Awarded for work on the ADN Software Development Kit.

ADN Toolkit/J (2000-2001)

Designed and maintained a collection of Java packages, API documentation, and examples intended for integration by Acxiom and other third party developers to easily access Acxiom’s online data products.

XML / HTTP seminar (January 2000)

Co-created and taught a training course on XML messaging over HTTPS to a customer who wished to incorporate Acxiom’s real-time data cleansing into their application offering.

Acxiom Data Network (ADN) 1.3 - 1.4 (April 1999)

Implemented version 1.3 and 1.4 of Acxiom’s Data Network, allowing real-time access to Acxiom’s InfoBase data via XML over HTTPS, using West Wind Technologies’ WebConnection and Visual FoxPro.

Acxiom ADN Wizard (February 1999)

Designed an improved user interface for Acxiom’s data cleansing wizard. Implemented the revised wizard using Visual FoxPro, delivering a complete installation program using InstallShield.

Development Team Management (1996-1998)

Held the Development Manager role at Cornerstone Software, New Zealand for 3 years. In addition to being Team Lead on many customer projects, mentored and acted as advocate for the other developers.

Accommodation Booking Engine (client and web) (1996-1998)

Was lead developer on Accommodata's original accommodation reservation application, taking their existing data base application and re-developing it, extending it into an online web-based booking engine. This application appears to have been replaced in August 2003.

Tenancy Database Application (1998)

Designed and developed a client-server application that transparently switched back-end databases on a single code base using Visual FoxPro and SQL Server. Documented thoroughly so that the client who had no previous experience in either platform could continue to develop and maintain the application.
(See http://www.spacefold.com/colin/articles/sql_backend/backend.htm)

Technical Articles (1993 – 1999)

Wrote several programming articles and had them published in technical magazines:

FoxTalk July 1993, Pinnacle Publishing
Inside Visual FoxPro May-Aug 1996, Cobb Group
Fuchs dFPUG Newsletter 1998

(See http://www.spacefold.com/colin/articles/index.html)

Speaker at FoxPro conferences

Given sessions at a number of technical FoxPro programming conferences, in the US, Germany, Australia and New Zealand:

dFPUG Visual FoxPro Konferenz, November 2004, Franfurt, Germany
Advisor/Microsoft FoxPro DevCon, October 2004 Las Vegas, Nevada
Microsoft Visual FoxPro DevCon, June 1999 Palm Springs, California
dFPUG Visual FoxPro Konferenz, November 1998, Frankfurt, Germany
FoxTeach Visual FoxPro Conference, May 5-7 1996, Toronto, Canada
Ashpoint 4th Australasian FoxPro Technical Workshop, 1995 Sydney/Melbourne/Auckland