Lead architect for CRM (Customer Relationship Management) VAR specializing in financial services implementations. Responsibilities include upfront requirements gathering, producing hardware/software/integration strategy, and implementing the integration component of CRM rollouts.

Technologies include Microsoft Data Transformation Services (DTS), perl, ASP.NET/C#, Java/JSP, Microsoft Reporting Services, XML+XSLT

Database developer of medical inventory management ASP's hosted analytics application, including design of data model, data aggregation architecture, ETL process and reporting framework.

Technologies include ASP.NET, SQL Server, OLAP Server.

Extended and refactored existing LAMP reporting module to include performance, functionality and usability enhancements. Delivered code review of existing architecture looking for performance improvements, and suggestions for future scale-out strategies.

Lead developer of employee directory application including new feature development, client-specific customizations, maintenance and end-user customer support escalations.

Technologies include Microsoft SQL Server, IIS, FastCGI, Apache, MySQL, mod_perl ('WAMP')

Lead developer for e-commerce website undergoing ASP-to-ASP.NET migration using Commerce Starter Kit.

Worked on branded or skinned version of Quickbase web application using rewriting reverse proxy.

Also lead development of Conservaton Almanac - a reporting website based on above dataset. Content on site was programmatically regenerated from Quickbase source using combination of perl Quickbase API, screen scraping, XSLT, and SVG.

Architectural review and mentoring engagement to validate the design of billion-row clickstream analytics application.

Engagement included code and data model review and well as on-site one-on-one coaching.

Performance tuning, architectural review, and mentoring engagement for client migrating from RDBMS to Microsoft OLAP platform.

Lead architect for visioning and web strategy engagement for Human Resources unit of Fortune 500 financial services firm.  Project involved gathering business and technical requirements for short and long term development plan by interviewing both business groups and technical staff within company.  Responsible for assessing architectural implications of business needs and reconciling those with existing technical infrastructure within company.  Phase 2 of project involves implementation of development roadmap using the Interwoven Teamsite Content Management System.

Initial engagement involved code review and write-up of a plan for achieving fault tolerance using mirrored data centers and SQL Server log shipping.  Also included assessing the suitability of using MSSQL Server OLAP Services as a reporting platform

The project evolved into general purpose Transact-SQL query performance tuning as well as new web application development for an extranet reporting application using ASP/PerlScript. 

Lead architect/developer on application integration project linking NetAge CRM package with Intraspect KM application.  Implemented single-signon using Apache/mod_perl rewriting reverse proxy, and 2-way data synchronization between Oracle and MS SQL Server 2000 systems.

Sole developer of click-stream analytic data warehousing application for high-traffic (50M hits/mo) web site implemented on Microsoft Analysis Services and SQL Server 2000. Application consisted of significant extraction, transform, and load (ETL) processes written in Perl, VBS, and Data Transformation Services (DTS). Wrote object oriented middle tier which transformed MDX queries into XML-based WDDX packets for display by Cold Fusion user interface.

Project was completed to spec and ahead of schedule, with zero critical defects reported by QA department. Responsibilities were then expanded to include re-factoring a targeted email marketing application and general web site/SQL performance tuning. After reviewing web site architecture for scalability issues, recommended and implemented an Edge-Side Include(ESI) caching reverse proxy using an Apache/mod_perl to cache as much of the site's dynamic content as possible.

Engagement included significant knowledge transfer (4+ weeks) consisting of both informal mentoring, professional documentation for all custom software components. In addition, conducted classroom-based training on Microsoft data warehouse technology and methods for company's entire development staff.