IT Consultant and Solutions Architect
Greater Seattle Area
IT Consultant and Solutions Architect
Greater Seattle Area
I'm an IT consultant with fourteen years of professional experience. In the past I've sold hardware, software and software solutions; managed projects, products and teams of developers; designed applications, database warehouses, and distributed ETL architectures; and have written production code in C#, Transact SQL and VB.
Currently, I'm not taking on new clients since I'm on a long-term contract.
Marketing analytics, regression analysis, business intelligence, data mining, enterprise software development methodology, .NET, SQL Server, Transact SQL (T-SQL) development, OLAP, ETL, reporting, web development, XML, SOAP, web services.
(Information Technology and Services industry)
1999 — Present (9 years)
My primary line of business consists of IT Consulting and information system design. However, I also work on projects in social networking, home and garden automation, and software developer productivity.
(Non-Profit; 5001-10,000 employees; Research industry)
May 2006 — August 2006 (4 months)
Wrote code and advised research trial office developers with the general goals of improving system reliability and usability. The results included:
A 900% improvement in patient data throughput;
A centralized and instrumented data import/export (ETL) process;
New development processes that reduced system downtime.
(Public Company; 10,001 or more employees; MSFT; Computer Software industry)
January 2006 — February 2006 (2 months)
This was a contract development project that I received through Redmond Technology Partners. It involved developing a set of C# (.NET 2.0) components that translates search engine query results into an XML format, and then optionally transforms the results into HTML and e-mails them to a distribution list.
(Non-Profit; Banking industry)
August 2005 — October 2005 (3 months)
My work here consisted of implementing a web service interface to a loan application processing system. The system accepted loan applications and returned responses in a proprietary XML format. The interface handled communication and document translation between this system and an industry standard car loan application system. This was implemented using Windows Server 2003, .NET 1.1 and SQL Server 2000. I received the work as an agency contract through Redmond Technology Partners.
(Privately Held; Information Technology and Services industry)
June 2005 — July 2005 (2 months)
I worked with Mike Wills and Amos Chong to discover and analyze the technical requirements for a license reporting application for Microsoft.com (MSCOM).
The functional requirements of the system stated that the system must be reusable, both on the front end (it must be able to integrate into any Microsoft.com property) and the back end (it must allow each property to serve up a different type of licensing report.)
To satisfy these requirements we designed a series of ASP.NET custom controls on the front end, and a "site configuration" database on the back end so that report imports could be customized for each property without changing the import code itself. Secure Web services (SOAP + HTTPS or WS-Security) enabled communication between components and integrated systems.
(Public Company; 10,001 or more employees; SBUX; Food & Beverages industry)
July 2003 — August 2004 (1 year 2 months)
After Starbucks acquired Seattle Coffee Company, I continued to provide comprehensive IT services to SCC, but systems integration was the main activity. Projects included:
* Transforming and loading SBC financial data into Starbucks' systems.
* Integrating SBC and Torrefazione Italia ecommerce sites into Amazon.com
* Integrating Paymentech credit card services into SBC ecommerce sites.
(Public Company; 1001-5000 employees; Food & Beverages industry)
February 2001 — July 2003 (2 years 6 months)
I provided software development, business intelligence and IT consulting services to SCC. Projects included:
• Developing (with Larry Hubbell) a P&L reporting tool. This OLAP-based tool allows users to quickly perform complex multi-dimensional (org unit, time and statement) analysis of P&L data, and supported Excel exports;
• Mentoring SCC developers on Win32, Visual Basic, and T-SQL programming techniques;
• Adapting Cinnabon's restaurant back office system to work for SCC. This involved:
o changing the user interface and business logic to conform to SBC and TI business practices;
o converting the site data feeds from a modem polling model to an FTP based push model. Doing this saved thousands of dollars in long distance and software licensing fees and reduced the IT support load;
o Creating an automated site management system (site maintenance + ETL). This was administered via a dashboard that gave the administrator a single page view of system status.
(Public Company; 201-500 employees; Food & Beverages industry)
February 2000 — January 2001 (1 year)
I provided software development and business intelligence and software development process consulting services to Cinnabon. Projects included:
• Supporting existing back office ETL processes;
• Integrating Cinnabon payroll and accounting processes into AFCs payroll (Peoplesoft) and accounting systems (Lawson) with Richard Ellison and Larry Hubbell;
• Performance tuning an existing data warehouse ETL process from Lawson Financials. The optimizations cut 4.4 hours from a 4.5 hour process;
• Mentoring Cinnabon developers in Visual Basic and MS Office technologies.
(Privately Held; 11-50 employees; Information Technology and Services industry)
April 1999 — January 2000 (10 months)
I mentored this consulting team in software development processes. I interviewed new programmers, project managers, testers and business analysts; created a quality assurance team that performed ad hoc, scripted and automated testing; established new source code control guidelines; and mentored business analysts in requirements gathering techniques.
(Privately Held; 1-10 employees; Computer Software industry)
April 1998 — July 1998 (4 months)
I managed and participated in the development of an event-scheduling web application for Microsoft's Executive Briefing Center (EBC). Other projects included the "VB Live" code sample web site for the Microsoft Visual Basic team and a search engine for a local publishing company.
(Public Company; 10,001 or more employees; MSFT; Computer Software industry)
August 1996 — March 1998 (1 year 8 months)
As a member of the Rapid Application Development Business Unit (RADBU) of Visual Studio, I managed a team of software developers and testers responsible for testing Visual Studio RAD tools. Responsibilities included:
• Working with the visual studio localization team to streamline software internationalization;
• Managing a four person team of testers and test automation developers;
• Creating processes for ad-hoc and automated testing of these components so that the testing could be easily delegated to members of my team;
• Creating code samples for online distribution;
• Testing the Traditional Chinese and French builds of Visual Basic 5.
• Testing code-generation tools and other software development tools released with Visual Basic 5.
(Public Company; Information Technology and Services industry)
1994 — 1996 (2 years)
machine learning, automation, cooking, indoor gardening, golf.