Project Portfolio

2012: LISCR Sr. Database Architect/Developer

Designed an enterprise wide corporate database including all data used by the company in six large disparate departmental databases. Used ERWin Data Modeler, SQL Server and T-SQL. LISCR is the second largest ship registry in the world having almost 400 employees.

2011: ATSC Sr. Database Architect/Developer

Designed and implemented the migration of data from the Department of Commerce’s ‘Export Control Automated Support System’ (ECASS) database into ATSC’s USXPORTS database.

2010: NetCracker Technology Sr. Database Architect/Developer

Supported data migration and data integration of NetCracker products for the Army National Guard's Enterprise Service Desk in Washington, DC and for Shaw Communications in Calgary, Alberta. I developed using Oragle 10g PL/SQL, MS SQL Server 2005, Java and JavaScript. I designed and developed a Java and JavaScript web-enabled Oracle 10g database system to track NetCrackers’ compliance to over one thousand individual DOD (STIG's) Security Technical Implementation Guidelines.
2009: Segue Technologies Sr. Database Architect

Designed and developed several disparate database systems. This involved requirements gathering and analysis, data modeling with ER\Studio, writing about 10,000 lines of T-SQL stored procedures, functions and triggers.

2008: Boeing Sr. Software & DB Architect

Design and develop a 'Versant' object oriented database that tracks all data concerning all electrical and software components on all Boeing aircraft. My efforts involved TCL, Python, Web services, SQL Server 2005, Visual Studio 2005, C#, VBScript and JavaScript.
2008: Piraeus Sr. Software & DB Architect

Designed and developed web-based, BI dashboard applications and data warehouses. This included database performance tuning. Developed using XML, Web services, SQL Server 2005, Visual Studio 2005, C#, VBScript, JavaScript, Dundas Chart and Silverlight.

2007: RealTech Sr. Database Architect

Designed, built and performance tuned an OLAP and OLTP database system from scratch.  I designed this database system (NDB) specifically to quickly and easily import, store and retrieve very disparate MLS (Multiple Listing Service) real estate data sources. MLS data sources do not adhere to any standards of structure or content. They are as different from one another as snowflakes.  My system quickly and easily incorporated new MLS's and quickly searched across all imported MLS's from one unified database.  I used ERStudio, SQL Server 2005, Transact SQL, SSIS and DTS.

The OLTP database I designed has fifty-one tables and replaced a legacy system containing sixty-nine disparate databases, some of which had over four hundred tables.
2006: CCH Sr. Programmer / DB Analyst

Designed and built two different wizards that imported state, city and local tax rate data into two different ERP systems: Navision and Sage ACCPAC. I also re-designed and built two different tax rate databases. This involved data modeling (ERWin), forward engineering the data model into SQL Server 2005 database, performance tuning, writing ETL, and C#.
2005: N-Link Sr. Programmer Analyst
Designed, developed, tested and debugged a distinct segment of STM (Statement of Work Management System) for the United States Department of Health and Human Services.  I used C# and Transact SQL. STM is slated to replace several disparate legacy systems that have never shared data with each other and have outlived their usefulness. The entire STM application is written in object oriented C# with a SQL Server 2000 back-end. I reverse engineered several legacy systems using ERWin 4.1. I also, designed and implemented an ETL (Extract Transform and Load) plan to extract data from several different legacy databases then transform, scrub, merge and load this data into the new STM database structure.
01-04: Western Wireless Sr. Programmer Analyst
Designed and built seven major web-based, enterprise wide applications where no such application previously existed. I implemented all of them using Visual Basic .NET, ASP.Net, Erwin, C# , Transact SQL and SQL Server 2000. I was solely responsible for the implementation of every aspect of the software development lifecycle for each of these applications including: initial requirements analysis, user interface design, database design, database performance tuning, testing and implementation. I also used Rational Rose Data Modeler to design several databases..

UCL

Unapplied Cash Log

CSI

Cell Site Inventory

FLT

Franchise License Tracker

DMS

Document Management System

AMS

Application Management System

CHURN

Churn Reporting Tool

LMS

Lease Management Reporting Tool
2002: City University College Professor
Taught Intermediate Visual Basic v6.0 (CS322) to 19 students for spring quarter.
2001: Complete Business Solutions Inc. Sr. Data Architect
Functioned as the dimensional data warehouse architect for an Oracle data warehouse at the Washington State Department of Health Drinking Water information Technology Project.
2000: Sound Health Solutions Sr. Data Modeler/ Prog. Analyst.
Full lifecycle database developer: Functioned as user interface designer, programmer, requirements analyst and lead data modeler. I conducted many in-depth requirements gathering and analysis interviews with business experts including medical doctors, exercise physiologists, registered dieticians and psychotherapists. I assisted in composing functional, technical, design, and user interface specifications documents.

I created a data model having over 75 tables and 273 attributes and its corresponding data dictionary using ERwin v3.5.2. I forward engineered that data model to a SQL Server v7.0 database and performance tuned the database. I wrote stored procedures as were requested by other UI developers. Designed and built an administrative UI to the database allowing internal administrators to create, read, update and/or delete records. The UI consisted of 74 different VB v6 forms.
2000: Etera Team Lead/ Sr. Data Modeler
Full lifecycle database developer: Database Architect and Database team lead working with two other DB developers. I designed, built, populated and performance tuned the Etera.com database. Also solely responsible for data conversion effort as well as writing triggers that updated the legacy DB from the new Etera.com DB and vice versa. These activities involved:
 bullet.gif (663 bytes) Gathering requirements from many people both at Lante and Etera
 bullet.gif (663 bytes) Designing the database for the Etera.com web site. The data model has 97 tables
 bullet.gif (663 bytes) Writing conversion scripts to convert data from legacy DB to new Etera.com DB
 bullet.gif (663 bytes) Communicating closely with the developers and business experts.
 bullet.gif (663 bytes) Writing triggers and stored procedures relying heavily on MS SQL Server Transact SQL.
99-02: The Bramante Group, LLC Sr. Software Architect
Designed and built a database system ManagedEnterprise for use by HMO's. It is a healthcare transaction processing and information system integrating communications between healthcare providers, health plans, and ancillary groups, significantly reducing claim and payment processing time, and lowering the administrative cost of provider and health plans. ManagedEnterprise is a standardized, all-insurer, Internet-enabled connectivity system to handle claims submission, referrals and authorizations, eligibility verification, formulary compliance, and rapid electronic payments. It is HL7 compliant enabling interoperability between disparate electronic Patient Administration Systems (PAS), Electronic Practice Management (EPM) systems, Laboratory Information Systems (LIS), Dietary, Pharmacy and Billing systems as well as Electronic Medical Record (EMR) and Electronic Health Record (EHR) systems.
1999: TechnoGym via Palazzo DeMix Sr. Data Modeler/ Prog.  Analyst
Full lifecycle database developer: Lead data modeler and web user interface designer for TechnoGym's "template / turn-key" E-commerce web site. This template site is for gym-clubs that purchase TechnoGym's equipment. The database contains over 60 tables and 150 relationships. The web user interface contains over 60 different web pages. I used ERWIN v3.5.2, Microsoft Front Page v3, and Microsoft SQL Server v7.0. The E-commerce web site and underlying database can be adapted for use by any of these gym-clubs in order to create their own fully customizable E-commerce web site by filling out and submitting the proper administrative web pages.

This allows gyms to create their own data driven websites that include: membership sales, pro-shop sales, class schedules, reservations, promotions, and home page text and graphics. The web pages that a club's administrators would use manage: reporting (over 15 different reports), web site look and feel, text, graphics, memberships and pro-shop store items. These data driven website also handles the translation of all static web page text into any number of different languages e.g. French, German, Italian, Spanish, and English as well as security groups and membership therein.
1999: NVST.COM (via Interra Group Inc.) Sr. Data Modeler
Full lifecycle database developer: Lead data modeler for NVST.COM's flagship website which is an 'E-Broker' between entrepreneurs and investors. The site also has 'template' E-Commerce web sites available for any entrepreneur or investor, which subscribes to the site. Interviewed NVST.COM's staff and performed rigorous, in-depth requirement analysis. Created a data model with 72 entities, and 650+ attributes using ERWIN v3.5.2 Implemented the physical SQL Server 7.0 database based on the model, and populated 25+ tables.
1999: Milliman & Robertson Sr. Data Modeler/ Prog. Analyst
Full lifecycle database developer: Lead data modeler and developer for Milliman & Robertson's 'MedGuide' database product. The MedGuide database stores Milliman & Robertson's managed healthcare guidelines. These guidelines previously existed only in seven volumes of hard copy as well as in several thousand HTML files. The data model I designed (using ERWin 3.5.2) has 72 entities and stores four of the seven volumes of Milliman & Robertson's managed healthcare guidelines. I generated a SQLServer 7.0 database from the ERWin data model; then wrote VB 6.0 conversion routines which read several thousand HTML files and wrote specific data to the appropriate tables and fields in the database.
1998: Seattle Seahawks Sr. Data Modeler
Lead data modeler for the Seattle Seahawks "C.D.A." database development effort. The data model I completed for the Seahawks contained 69 tables, and 82 relationships. I interviewed Seahawks staff and performed rigorous, in-depth requirement analysis. I reverse engineered and normalized the current physical Informix legacy database. I expanded the model to accommodate data categories for the entire NFL such as coaches, pro and college players, player and game statistics, plays and formations, video library cataloging, scouting, training, ticketing and many more. I fully documented every entity and attribute in the model as to its purpose and its source (if there was one) in the current physical Informix legacy database. I used ERWin v3.5 for creating the data model.
1998: GCSI, Inc. Sr. Data Modeler/ Prog. Analyst
Full lifecycle database developer: I was solely responsible for every aspect of the development life cycle. Developed the "Configurator" which each of 50 salespeople have been using 40hrs/week since it was rolled out in May 1998. The "Configurator" enables users to quote custom PC configurations on-line while speaking with their client. Users are able to add any number of PC configurations, as well as third party items, to their quotes. The "Configurator" enabled users to create, read, update, delete, search, FAX, print, and e-mail quotes. Due to severe time constraints, I created the "Configurator" using MSAccess97 as a front-end and SQLServer v6.5 as the back-end. I used ERWin v3.5 for creating the data model.
97-98: SAFECO, Inc. Sr. Data Modeler/ Prog. Analyst
Full lifecycle database developer: Analyzed business system requirements. Created a data model with over 80 entities, and 760 attributes using ERWin v3.0. Implemented the physical SQL Server 6.5 database based on the model. Wrote approximately 50 SQL Server 6.5 stored procedures. Wrote several COM objects in VB5 each of which reads a hierarchically structured text file (downloaded from a mainframe), programmatically normalize it; then write the output records to multiple normalized SQL Server database tables. The purpose of the overall application is to allow SAFECOs' commercial insureds to file and edit their insurance claims online via the internet as well as view reporting data.
1997: Flex Plan Services, Inc. Project Manager/Sr. Data Modeler
Full lifecycle database developer: Managed product development for Flex Plan Services flagship product "Flex98" which will be a user configure-able human resources benefits administration intranet application accommodating on-line employee benefits enrollment. I completed the project schedule, database model, and application architecture model. The data model was done using ERWin/ERX 2.6 and contained over 45 tables. The architecture involves 3 tiered development using a VB5 ActiveX Doc 1st tier, a VB5 2nd tier, and a SQLServer 3rd tier.
1997: Shoreline Community College College Instructor
Adjunct faculty member teaching "Database Concepts" and Data Modeling to 30 students for spring quarter.
1997: Cohesion Analyst/Data Modeler
Full lifecycle database developer: Over the course of this period I developed several different database applications on several different contracts. These contracts required direct requirements analysis sessions with the user group and subsequent data modeling and development.
96-97: Pacific Interactive Senior Programmer/Analyst
Developed a 3 tiered internet application consisting of a VB/ActiveX/HTML 1st tier; a VB/RDO/OLE Server 2nd tier, and a SQLServer 6.5 3rd tier. I developed the 1st and 2nd tiers for a 3rd tier consisting of over 70 SQLServer tables.
1996: Community Sector Services Senior Programmer/Analyst
Wrote over six thousand lines of Visual Basic test scripts to test CSS's flagship product "PsychAccess" before first public release.
1996: Boeing Corporation Senior Programmer/Analyst
Developed a database application with which to track airplane design flaws and other problems discovered during the construction of airplanes.
1996: Laser Direct Inc. Senior Programmer/Analyst
Full lifecycle database developer: Developed a report generator which included an interface, a data model combining over 20 ORACLE and ISAM tables, about 90 queries, MDB attachment to ORACLE and ISAM tables, and the programmatic assembly of SQL for ad-hoc querying.
94-96 IMC, Inc. Senior Programmer/Analyst
11/1/94 - 6/12/96     Sr. Programmer/Analyst for the     Department of the Treasury; Internal Revenue Service
Statement of Work Expert System (SOWES) -- Re-engineered/implemented an expert system to generate a statement of work based on user input. I was the defacto lead developer on this team.

6/6/94 - 10/28/94     Jr. Programmer/Analyst                   the White House; The Executive Office of The President; (OMB)
U.S. Budget Modernization Effort -- Wrote the federal budget software for the analysis and compilation of federal budget data. I used Visual Basic v3.0 and the Gupta SQL API, in a team environment, to develop two applications accessing IBM DB2 tables on an IBM 3090 Mainframe via a Gupta gateway server. I was involved in every aspect of the development life cycle.

2/15/94 - 6/6/94      System Administrator/Programmer   Agency for International Development (AID)
Developed several mission critical applications, using dBaseIV, that access and analysis global health information at CIHI for decision-makers in AID and AID-recipient countries.