## BIO
Programming Languages: Visual Basic, C#, SQL, VBScript, JavaScript, PHP, XML, SOAP, and CSS Technologies: ASP, Pear, ASP.NET, ADO, [login to view URL], IIS, COM, DCOM, and COM+ Tools: Windows NT/2000, SQL Server 7.0/2000, Visual Studio 6.0, Visual [login to view URL], SiteServer Commerce Edition, and Crystal Reports 9.0 Experience: Consultant – Windsor Solutions January 2003 – Present • Enterprise Data Catalog for the Washington State Department of Transportation (WSDOT). o This application will catalog all of the data in the various WSDOT physical databases, matching each gathered meta-data item to a common, enterprise-wide understanding of the information that the data represents. o Shared development and analyst positions to incorporate 4-tier system, including Database Access Layer (DAL), Web Services Access Layer (WSAL), Business Logic Layer (BLL), and finally the Presentation Layer. The application is being developed for web-based execution, utilizing C#.NET, SOAP and XML Web Services, with a SQL Server 2000 database. o Delivered on-time solution to the client in June of 2003 that was rewarded with a maintenance contract for the following year. Subsequent visits with the client have resulted in performance tuning and analysis and planning of the execution of the maintenance contract. • Intranet Application for Windsor Solutions o Developed and converted legacy Access application that was a Time Sheet application to a Web-based, intranet application. Upgraded application to incorporate projects, tasks, automated emails, and Crystal Reports. o Wrote Data Transformation Packages (DTS) to extract and convert data from previous Access and SQL Server databases to a destination database on the same server. o Wrote a client application in C# to interact with a Windows service to send reminder emails on a weekly basis. Componentized the technology for easy reuse. Independent Contractor – Canon U.S.A November 2001 – October 2003 Brightcube Technology Purchased by Canon in November 2001 • Designed and implemented an upgrade package for e-commerce system in .NET technology for Canon technology o All middle-tier objects written in C# to encapsulate business logic, security features, and eliminate direct connections to the database from presentation layer o Used ASP.NET technologies including user and custom controls to modularize common code and eliminate code redundancy o Integrated Cache technology and XML as a data source using ASP.NET to improve performance of e-commerce system. • Designed and developed software package for internal engineers and suppliers to replace existing order processing application. o Client/Server Application written in C# and communicated with remote servers using XML Web Services and SOAP o Multi-Threaded Application increased overall user throughput by 200% o Eliminated redundancy and user-error common with previous technology • Responsible for day-to-day support and administration of development, production, and live SQL Server Databases. o Perform SQL Server Logical and Physical DBA Duties. Included responsibilities include normalization, optimization, and query enhancement. o Recently developed specifications and successfully configured Fail-Over Clustering within a development environment using SQL Server 2000 and Windows 2000 clustering software. • Designed and developed integral technology to support multi-language site for next version of Japanese client, Naniwa. o Used caching technology to store into memory html objects for language features and optimized different technologies to improve performance throughout the site. o Designed and developed several key business logic COM+ components using Visual Basic. o Recently completed multi-lingual reporting engine that included dynamic content and automation techniques to automatically process and update daily statistic information. Brightcube ([login to view URL]) July 1999 – November 2001 Photoloft Technology Purchases by Brightcube in December 2000 Sr. Systems Architect/Database Administrator • Began work in developmental phase of beta ASP.NET and C# o Applications written in C# to familiarize developmental team and management the benefits of .NET technology. • Responsible for day-to-day support and administration of 12 Microsoft SQL Server 7.0 DBMS for the company Internet site and off-site Production centers. o As DBA responsibilities entail database management, fine tuning and performance, high availability design and implementation (Microsoft Cluster Server), replication, and database backup and recovery. o As database designer and data architect tasks are support of the web and systems, logical/physical modeling of current and future databases, writing stored procedures, triggers, installation and upgrades. • Worked as lead developer to remove Microsoft Site Server Commerce Edition from Brightcube’s e-commerce back end. The project included the removal of Site Server along with re-architecting the entire e-commerce site with a restructured Object Oriented Design. o Scripting or presentation layer written in ASP technology to provide dynamic content and instantiate COM objects o Designed, developed and tested business rules COM components using Visual Basic, C++, ADO, and OLEDB o Implemented data access tier on SQL Server 7.0 using TSQL and stored procedures • Wrote custom VB applications using ADO and OLEDB as the data source for order processing application and automatic payment center. o Designed application using VB’s ITC control to use the GET method and grab and save an image, transfer all files to a remote location using FTP, along with enforcing all rules including automatic payment for membership based web site. • Worked throughout software development life cycle with internal and external clients to define and gather technical specifications, assess timeline requirements, and deliver a cost-effective product to the customer. o Communicated and worked with customer to define cost-efficient, quality-based requirements for mission-critical applications and communicated those results back to a team of engineers to deliver an “on-time†and “on-budget†solution. o Communicated remotely with external or client engineers to verify usability, satisfaction, and eliminate any software problems related to design or user-error. Internet Services February 1999 – June 1999 Programmer/Technician • Primarily responsible for designing and developing e-commerce solutions and integrating them into existing web sites. o Designed, developed and tested business rules COM components using Visual Basic, ADO, and OLEDB o Programmed in ASP environment (VBScript) to integrate SQL Server and Microsoft Access databases into pre-existing web sites. o Used SQL language to design stored procedures and write TSQL scripts for various automated processes. • Gave on-demand phone support and technical presentations to clients and consumers to explain and
