A small sampling of past projects

Asset management portfolio administration tool

Industry finance
Summary Designed and implemented a complex database, stored procedures, data warehousing, reporting, and analytics in a web-based application that has since been used to administer hundreds of millions of dollars in investments for over a decade.
Types of work Database architecture
Stored procedures
Data warehousing
Web application
Analytics
Automation
Technologies SQL Server
Transact SQL
SQL Server Analysis Services (SSAS, data warehousing)
SQL Server Integration Services (ETL)
HTML
JavaScript
ColdFusion
Key benefits
  • Automates many recordkeeping and reporting tasks that had previously been manual
  • Provides on-demand reporting for asset management clients
  • Analytics supply new insights to asset managers

ETL system port and upgrade

Industry Healthcare/insurance
Summary Led a team replacing a labor-intensive and hard-to-maintain legacy data transformation system with a modern ETL solution and modifying the system to meet an updated set of requirements that required multiple changes. The new system is much easier to maintain and improve and runs automatically rather than needing to be tended through its process.
Types of work Application design
Database development
ETL implementation
Documentation
Technologies Microsoft SQL Server
Transact SQL
Stored procedures
SQL Server Integration Services (SSIS)
C (legacy system)
IBM DB2
C#
Key benefits
  • Meets updated requirements for output content and format
  • Runs automatically; the old system had to be run manually and carefully monitored
  • Better logging, better error handling, automatic notifications of bad source data and other errors
  • Greatly reduced troubleshooting and maintenance time
  • 82% increase in productivity implementing changes and improvements after upgrade

Content-protected publishing and eCommerce site

Industries publishing, photography
Summary Created a site to allow prospects to subscribe to and view online product review information not available anywhere else while providing content protection to protect on-site materials from being copied and shared elsewhere. The site and programming have been in continuous use (with upgrades along the way) for 18 years.
Types of work Web application design and development
Database design and development
Content protection
eCommerce
Online publishing
Technologies MySQL
HTML
JavaScript
Active Server Pages
CSS
Key benefits
  • Self-service subscriptions for customers
  • Novel content protection system allows publishing information that was not available elsewhere with minimal concern about piracy
  • Administration site allows reviewing, approving, locking, and reporting on subscriptions

web site eCommerce and analytics

Industry aquarium monitoring
Summary Developed eCommerce and customer data feed features to enhance existing website, allowing online purchases and up-to-the-minute reporting and analytics for subscribers using data from their purchased devices.
Types of work Web application
eCommerce
Sales and promotion
Analytics
Reporting
Technologies HTML
CSS
TypeScript
JavaScript
MySQL
APIs
Key benefits
  • Enabled online purchases
  • Provided sales and promotional tools on site to engage prospects
  • Gave customers a portal to access their device data in real time

Online writers' group and tools

Industry writing/publishing
Summary Created a proprietary web forum, critique exchange site, writing contest system, moderation system, and related tools. This site launched a large and successful writers' group and was used by thousands of writers over more than 15 years.
Types of work database design and development
stored procedures
web application
automation
document management
Technologies HTML
CSS
Javascript
Active Server Pages
SQL Server
Transact SQL
Key benefits
  • Bespoke forum system made possible types of communication not otherwise available
  • Integration of contests, forum, critique system, moderation, and other aspects of the site allowed for easy and consistent participation and administration
  • Automated processes and integrated systems enabled all-volunteer group to run with minimal time investment