Team Lead/Database Architect/Developer, Etera
Full lifecycle database developer: Database Architect and Database team lead working with two other DB developers. Designed, built, populated and performance tuned the Etera.com database. Also was 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:
Gathering requirements from many people both at Lante and Etera
Designing the database for the Etera.com web site. The data model has 97 tables
Writing conversion scripts to convert data from legacy DB to new Etera.com DB
Communicating closely with the Object and User-Interface teams as well as all pertinent business experts
Writing triggers and stored procedures relying heavily on MS SQL Server Transact SQL
Data Modeler/Developer, TechnoGym via Palazzo DeMix
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. 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.
Sr. Software Architect
Full life cycle developer. Designed and built the user interface and database for ManagedEnterprise an ERP (Enterprise Resource Planning) application for HMO's. It is a web based healthcare transaction processing and information system integrating communications between healthcare providers, health plans, and ancillary groups that transact business with each other, significantly reducing claim and payment processing time, and lowering healthcare administrative costs. ManagedEnterprise goal is to eliminate the administrative cost of provider and health plans by a standardized, all-insurer, Internet-enabled connectivity system to handle claims submission, referrals and authorizations, eligibility verification, formulary compliance, and rapid electronic payments. ManagedEnterprise 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.
Data Modeler, NVST.COM
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.
Data Modeler, Milliman & Robertson
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. Generated a SQL Server 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.
Data Modeler, Seattle Seahawks
Programmer/Analyst/Modeler, GCSI, Inc.
Programmer/Analyst/Modeler, SAFECO, Inc.
Project Manager/Data Modeler, Flex Plan Services, Inc.
College Instructor, Shoreline Community College
Analyst/Data Modeler, Cohesion
Senior Programmer/Analyst, Pacific Interactive
Senior Programmer/Analyst, Community Sector Services
Senior Programmer/Analyst, Boeing Corporation
Senior Programmer/Analyst, Laser Direct Inc.
Senior Programmer/Analyst, IMC, Inc.
Sr. Programmer/Analyst, Department of the Treasury; Internal Revenue Service
Jr. Programmer/Analyst, The White House; The Executive Office of The President
Key words and phrases related to this expert's capabilities include:
BI Developer, Business Analyst, Business Intelligence, Business Intelligence Analyst, Business Intelligence Manager, Data Analyst, Data Architect, Data Designer, Data Engineer, Data Modeler, Data Modeling, Data Modeler, Data Specialist, Database Administrator, Database Analyst, Database Architect, Database Design, Database Designer, Database Developer, Database Engineer, Database Engineering, Database Modeler, Database Specialist, DBA, ETL Developer, Expert, Information Analyst, Information Architect, Information Designer, Information Engineer, Information Modeler, Information Specialist, Professional, Relational, Relational Database Design, Software Engineer, Software Engineer, Software Engineering, SQL Developer, Sr. Business Analyst, T-SQL Programmer, Web Developer, Web Development
