Database Development
● Microsoft SQL Server 6.5, 7.0, 2000, 2005, 2008, 2012, 2014, SQL Azure
● Microsoft SQL Server Reporting Services
● SQL Server installation, upgrades, security
● Data Modeling, Data Encryption, Security
● WPF, WCF, DTS, ADO, ADO.NET, ODP.NET, Entity Data Model, Linq to SQL, REST, ODATA
● T-SQL, procedures, functions , triggers, views
● .NET integration with Oracle Databases
● Microsoft Access, Access/SQL Integration
● Tortoise SVN, MS SourceSafe, Star Team
● Google Analytics Integration and Tracking
Content Management Systems
● Kentico CMS Intranet
● SharePoint 2010 Foundation, Standard
● SharePoint 2013 Foundation, Enterprise
● WorldLightASP.com CMS
|
Application Development
● Windows Mobile, Windows Phone 8
● Windows Server NT, 2000, 2003, 2008, 2012
● Visual Interdev
● Visual Studio 2003, 2005, 2008, 2010, 2012
● OFFICE 2013, Office Live
● SkyDrive, Google Drive
● MS Source Safe, MS Team Foundation Server, Cloud Based Team Foundation Server (visualstudio.net)
● Internet Information Services IIS (All versions)
● Classic ASP, VB 6.0, VB.NET, C#, COM, ActiveX
● ASP.NET 1.1, 2.0, 3.5, 4.0, 4.5
● ASP Membership, Personalization , Forms Authentication, AJAX Control Toolkit, Silverlight
● HTML, XHTML, CSS, JavaScript, JSON, JQUERY
● YouTube API, JavaScript API, Activate.NET API
● E-Commerce, SSL, Shopping Cart Development
● Facebook API, Twitter API
● PayPal API, Google Checkout API, Authorize.NET API
|
Project Portfolio
Global Construction Services Firm (2011 – 2014)
Portland, Oregon
The Client
A Portland based manufacturer with offices worldwide, this firm is a global industry leader in skyscraper window pane construction and instlation. Their work can be seen in skycrapers all over the world, including the new World Trade Center building. As their Lead developer on multiple projects Developed custom CAD drafting macros to automate producures for CAD drafters. Modified an corporation-wide .NET based timecard intranet used to track project expeditures, PTO and vacation time in offices on 3 continents. Developed custom timecard solutions, AUTODESK macro development, custom human resources software development, server installation, migration, upgrades and support. SharePoint server installation, upgrades and administration, mobile device application development. I also assisted the entire enterprise in a shift to a collaborative SharePoint 2013 environment.
The Technology
AutoCAD VBA, C#, Silverlight, Windows Virtual Machines, IIS, Windows 2003 Server, SQL Server 2012, Trasact SQL, AJAX, ADO.NET Entity Framework, SQL Server Reporting Services (SSRS) ASP.NET 2.0, ASP.NET 3.5, ASP.NET 4.0, HTML, JavaScript, JSON, AJAX, Silverlight, C#, SharePoint 2010, SharePoint 2013, AUTODESK Vault
AMEX Software Development Vendor (2013)
Portland, Oregon
Upgraded and refactored a very large corporate database and Windows Server support several call centers nationally.
Nellie Mae Education Foundation (2013)
Boston, Massachusettes
The Client
The Nellie Mae Education Foundation promotes accessibility, quality, and effectiveness of education, especially for underserved populations, in the six New England states. I developed a custom enterprise Kentico CMS version of the NMEF.org website. Requirements gathering with several departments, interfacing with the Kentico CMS support team, development of custom content types and web parts.
The Technology
SQL Server 2012, Kentico CMS, HTML, Javascript
Party Center Software (2013)
Portland, Oregon
The Client
Party Center Software is an industry leader software solution provider providing Software as a Service (SAAS) event planning and POS software. Provided support and application modifications to this e-commerce order placement website’s Party planning software.
The Technology
SQL Server 2005, ASP.NET 3.5, C#, HTML, JavaScript, FEDEX API,
Classic ASP Web Developer (2011)
http://www.cendix.com/
Portland, OR
The Client
Cendix is the leading provider of Web-to-print solutions that automate on-demand one-to-one marketing campaigns and increase sales both online and offline. Custom classic ASP and SQL Server development on multiple Cendix marketing channel partner websites
The Technology
Classic ASP, SQL Server 2005, Trasact SQL, Visual SourceSafe
SEO Consultant (2010)
http://www.worldlightasp.com
Portland, OR
The Client
WorldLightASP Clients
The goal of the WorldLightASP system is to draw traffic to customer websites through integrated SEO tools. As a result the following users are #1 or top 5 on Google: Martin Welch (# 1 for Classic ASP Portland, #3 for Martin Welch), The Herb Shoppe Apothecary (#1 for Herbs Porltand, OR), Bruteforce HHO, llc (#1 for Bruteforce HHO), Raja Afrika (first 3 pages of Google for Raja Afrika).
The Technology
Windows 2003 Server, WorldLightASP CMS, Google Analytics, Yahoo Webmaster Tools, Bing Webmaster Toolkit
RajaAfrika.com (2010)
http://www.rajaafrika.com
Portland, OR
The Client
Martin Welch is a media aficionado.
I believe that internet media is the next frontier. Ultimately internet media will merge with our investments in large display media (Plasma TVs) and we will get our TV from the internet rather than cable providers. Much like the early days of the internet, early movers in the field of web-based media today will be the moguls of tomorrow.
With this in mind, I created RajaAfrika.com
The Challenge
RajaAfrika.com is currently in version 3. Version 1 used a collection of YouTube videos to display content. Users could watch one video and then after, click another video that they wanted to watch. Nice, but hardly a TV station. Version 2 incorporated AJAX to better streaming and ASP.NET Membership to allow members to create playlists. Version 3 is begining to incorporate advertisements and other personalization features.
The challenge with RajaAfrika.com is to create an engrossing environment that feels like TV and that enables visitors to sit back and enjoy an experience rather than just a video.
The Technology
Windows 2003 Server, IIS, ASP.NET 3.5, VB.NET 3.5, ASP Forms Authentication, ASP Personalization, WorldLightASP Blog, MS SQL Server 2005, DHTML, JavaScript, YouTube JavaScript API, AJAX, JSON
WorldLightASP (2010)
http://www.worldlightasp.com
Portland, OR
The Client
WorldLightASP wanted a “simple website solution.” A general content management application that would enable the majority of people needing a simple website to rapidly create one and apply a royalty free design to create a professional look and feel.
The Challenge
As the principal developer on the WorldLightASP project I had to create a content management system architecture that was both scalable and extensible. The interface needed to be intuitive for non-technical users and still have compelling advanced features for more seasoned users. WorldLightASP also needed to support both sales and designer affiliate programs that could be easily managed from the website as well as e-commerce features such as recurring billing and shopping carts.
The Technology
Authorize.NET E-commerce API, PayPal API, Windows 2003 Server, VB.NET 3.5, ASP.NET 3.5, SQL Server 2008, SQL Server Reporting Services, JavaScript, JSON, AJAX, HTML
Mad Fish SEO (2009)
http://www.madfishseo.com
Portland, OR
The Client
Mad Fish SEO is a local Portland, OR firm specilizing in Search Engine Optimization, Graphic Design and PHP.
The Challenge
Mad Fish SEO had inherited an ASP Storefront 6.0 E-commerce project. They hired me find way to extend their existing e-commerce application. StoreFront 6.0 had very little docuentation and poor support for extending features. I was able to find work arounds to complete each new feature and succeeded in making the website more user friendly.
The Technology
ASP StoreFront 6.0, ASP.NET 1.1, Microsoft SQL Server 2008, HTML, JavaScript, AJAX
FEI (2009)
Portland, OR
The Client
FEI is an international corporation developing tools for nano-tech.
The Challenge
FEI needed to have an custom outlook for developed that would take information from end users in a structured format and generate an email to appropriate recipients.
The Technology
MS Outlook 2007, Visual Basic for Applications (VBA)
City of Seattle: Human Services Division (2009)
Seattle, WA
The Client
HSD is responsible for all human services programs offered by the City of Seattle including youth services programs and elder services.
The Challenge
HSD needed to update features of it budgetary control intranet application originally developed using Classic ASP. A requirement was to create all new features and .NET and to enhance existing Classic ASP/COM components where possible.
I helped to add new .NET features in an environment where Classic ASP and .NET pages were co-existing. It was also necessary to solve the problem of how to share SESSION information between Classic ASP and .NET pages; a problem, for developers, akin to the Y2K bug. I actually blog about it here. I worked as the lead developer to add new features and upgrade features from Classic ASP to .NET in an environment running both servers. New features included budgetary controls and custom reporting.
The Technology
Classic ASP, ASP.NET 2.0, VB 6, COM, SQL Server 2005, AJAX, AJAX Control Toolkit, JavaScript, HTML.
Microsoft Certification Course Content Producer (2008)
Portland, OR
The Client
The client is a Microsoft sub-contractor awarded projects from Microsoft to create content for various Microsoft websites such as Microsoft TechNet and Microsoft Learning.
The Challenge
The client required my expertise as a Microsoft SQL Server developer to evaluate software and create content for Microsoft certification courses for the recently released 2008 version of Microsoft SQL Server.
Development of content for Microsoft Learning and Microsoft TechNet websites required testing evaluation versions of Microsoft 2008 SQL Server on “Longhorn” a.k.a Microsoft 2008 Server using virtual machines and carefully documenting steps of assigned tasks to create accurate course materials for certification courses.
The Technology
Microsoft Virtual Server, Windows Server 2008, SQL Server 2008, PowerPoint, Word, Tortoise SVN
Cultural Awareness Foundation (2008)
http://www.culturalawarenessfoundation.com
Portland, OR
The Client
The Cultural Awareness Foundation is a Portland, OR based 5013c non-profit promoting awareness of and interest in Brazilian arts and culture.
The Challenge
The Cultural Awareness Foundation needed a website, fast and they needed the content of that website to be quickly and easily updatable by non-tech savvy users.
I set CAF up as a user of our WorldLightASP Content Management System. With the WorldLightASP CMS there was nothing to download and nothing to install. We picked out a design and they began uploading their content to the website the same day.
The Technology
WorldLightASP CMS
AllFlame.com (2007)
http://www.allflame.com/
The Client
AllFlame.com is a spin-off of FirePlaceVillage.net.
I helped the staff at AllFlame quickly construct a content management system and e-commerce tool that allowed users to instantaneously update their website with new content and product information, without requiring any coding or HTML knowledge by users.
The Technology
WorldLightASP.com CMS, WorldLightASP E-Commerce, Windows 2003 Server, ASP.NET 2.0, ASP.NET Membership, VB.NET, JavaScript, HTML
FireplaceVillage.net (2007)
http://www.fireplacevillage.net/
The Client
FirePlaceVillage.net is New Hampshire's Largest Retailer of Wood Stoves, Gas Stoves, Fireplaces, Grills and Accessories.
I assisted FirePlaceVillage with rapid positioning of a content management system that enabled employees to immediately post new content straight to the website, without requiring any coding or HTML knowledge on their part.
The Technology
WorldLightASP.com CMS, Windows 2003 Server, ASP.NET 2.0, ASP.NET Membership, VB.NET, SQL Server 2005, JavaScript, HTML
The Client
A pioneer website in its industry, EnhanceScape, in collaboration with HomeDepot, connects Homeowners with landscaping projects to area contractors capable of doing the work. The EnhanceScape Management System provides homeowners with bids from up to 4 different contractors allowing homeowners to choose the contractor that best suits their needs.
The Technology
Classic ASP, ASP.NET 2.0, SQL Server 2000, HTML, JavaScript, AJAX
ReliableRemodeler.com (2006)
http://www.reliableremodeler.com/
The Client
Reliable Remodeler is a rapidly growing company pioneering the field of matching homeowners to home-improvement contractors.
Reliable required assistance adapting their information systems to their rapidly growing business and required a consultant that had an expert understanding of SQL Server and Classic ASP to convert their systems to .NET. I helped them analyze their work flow, database and existing systems and then proposed solutions to help them upgrade their existing systems while concurrently creating new systems for managing customers, affiliates and sales data.
The Technology
Windows 2003 Server, AJAX, Classic ASP, ASP.NET 2.0, SQL Server 2000/2005, JavaScript, HTML
The Client
The Nellie Mae Education Foundation promotes accessibility, quality, and effectiveness of education, especially for underserved populations, in the six New England states.
Nellie Mae wanted a redesign of the website that I developed for them in 2000. The new website needed to support content management, management of the grant information offered by Nellie Mae and different levels of administrative access. I developed a content management and grant information management intranet that supported article publication, article versioning, membership management and full-text searching.
The Technology
Windows 2003 Server, ASP.NET 2.0, VB.NET SQL Server 2000, JavaScript, HTML, Microsoft SourceSafe
Thomson Financial - Course Technology (2005)
http://samcentral.course.com/
The Client
Headquartered in Boston, Massachusetts, Thomson Course Technology was founded in 1989 based on the vision that technology would transform the way people teach and learn.
Course Technology’s flagship product Skills Assessment Manager (SAM), an enterprise class, distributed, student academic and placement testing application had rapidly outgrown its ability to support its user base. The SAM application was in active use by over 400,000 students and educational institutions that needed hot-fixes and could not suffer excessive downtime.I worked as part of a team of developers to track and fix bugs in the SAM application, posted hot-fixes to clients while simultaneously working independently to improve the system’s scalability through normalization of the underlying data-model and re-factoring server-side code into Classic ASP classes. The end result was a dramatic reduction in outages due to server overload and highly reusable code for the SAM application.
The Technology
Windows 2000 Server, Classic ASP (server-side JavaScript), Visual Studio 6, Star Team (bug tracker), JavaScript, HTML, ISAPI, Source Control
The Client
This was an ASP.NET/VB.NET/SQL Server e-commerce web site that enabled a specialty jewelry manufacturer to promote and sell her products to a global audience.
The Technology
ASP.NET, JavaScript, Visual Basic.NET, SQL Server 2000, SSL
Charter One Bank (2003)
The Client
Charter One Bank (later purchased by Citizen's Bank) contracted us to build an intranet survey web application for Midwestern bank to capture employee activities that qualify for federal recognition under the Community Reinvestment Act.
The Technology
Visual Basic.NET, JavaScript, ASP.NET, SQL Server 2000, XML
Liberty Mutual Insurance (2002)
The Client
Liberty Mutual Insurance contracted us to build the WARP Project Management System; an early model intranet based entirely within the MS Outlook 2000 environment. This task management application was implemented as a custom Outlook forms application that ran against a SQL Server database and tracked 150 fields of task and project management information.
The second version of this tool was an ASP port that delivered all of the same rich user interface functionality in a web client that users had come to expect from the Outlook forms application. As the deployment environment mandated zero changes to either the server or client configurations, this functionality had to be delivered through extensive client-side scripting and Dynamic HTML.
The web version also ran queries against an Oracle database to display data from a pre-existing Oracle/Java-based application.
The Technology
Classic ASP, JavaScript, VBScript, Outlook Forms Development Kit, SQL Server 2000, Oracle
City of Boston Empowerment Zone (2002)
The Client
Boston's Empowerment Zone commity hired us to create the EZ Info website; a self-managed online directory of businesses and organizations in Boston’s Empowerment Zone.
The Technology
Visual Basic.NET, ASP.NET, JavaScript, SQL Server 2000
The Client
Finnanced by Fleet Bank (later purchased by Bank Of America), this online community enables residents and organizations in the Roxbury community of Boston to promote their events and read news and discussions via a self-service community information database.
The Technology
ASP Classic, JavaScript, VBScript, ASP.NET, Visual Basic.NET, SQL Server 2000, SMTP
Aftermeeting – Aftermeeting Web Site (2000)
The Client
Online community to enable conference attendees to collaborate online after meetings and other events.
The Technology
Classic ASP, JavaScript, VBScript, SQL Server 2000, Chat, MS Site Server 3.0
The Client
Self-managed web presence for foundation. Client is able to manage data for personnel, grantee organizations and articles and white papers.
The Technology
Windows 2003 Server, ASP.NET 1.1, VB.NET SQL Server 2000, JavaScript, HTML, Microsoft SourceSafe
Boston Parent’s Organizing Council (1999)
http://www.bpon.org
The Client
Self-managed web site for community organization. Client is able to manage data for member organizations, events, documents and announcements.
The Technology
Classic ASP, JavaScript, VBScript, SQL Server 7
NESCAUM - Air Quality Monitoring Web Site (1999)
http://www.nescaum.org
The Client
Web site that used a custom-built application to pull data from a dial-up air quality data monitor and post graphs of air quality on the web.
The Technology
Classic ASP, VBScript, JavaScript, SQL Server 7, Visual Basic 6, Hilgraeve HyperTerminal, Graphics Server 5
The Client
Self-managed web site for venture capital firm. Client was able to manage data for portfolio of companies, current investors and job opportunities.
A separate web module handled event planning for investors and portfolio company executives. Third module produced marketing documents based on current portfolio of companies and current investors in database.
The Technology
Classic ASP, JavaScript, VBScript, SQL Server 7, VBA
Quality of Life Network (1998)
The Client
Built online community for people passionate about local and global quality of life issues. Site included personal profiles, discussions, announcements, internal messaging and live chat.
The Technology
Classic ASP, VBScript, JavaScript, SQL Server 7, Chat
Blackside Productions (1997)
The Client
Blackside Productions, company behind the legendary civil rights documentary "Eyes on the Prize" contracted us to create companion Web Sites to a series of recently released PBS documentaries. We delivered 3 web sites that enabled client to manage data for educational programs, artist biographical text and media and personnel.
The Technology
Classic ASP, VBScript, JavaScript, SQL Server
BlackFacts Online (1996)
http://www.BlackFacts.com
The Client
Before Web 2.0 and with the Assistance of Ken Granderson, MIT Alumn and founder of Inner-City Software, I created this collaborative web application. The BlackFacts website is an online calendar of African American historial events. The website supports membership and has web-based administrative interfaces so that the public can add, review and approve new information on a continung basis. The site continues to draw moew than 10,000 visitors per month.
The Technology
Classic ASP, VBScript, JavaScript, SQL Server