8108 Surreywood Dr

Richmond, VA 23235

804 402-3101

Objective

Data Modeler and Database Developer

Experience

2003–2005              Coleman & Coleman Software Richmond, VA

Application and Database Consultant

§        Built www.cheapmowerparts.com website for Tri State Air Cooled Engines in Johnson City, TN 37601.

§        Built www.dscr-secoe.com/secoe/project/gethomepage.do for the Defense Supply Center in Richmond.

§        Managed contract developers as needed, built the servers, designed the architecture, installed and configured the software. Developed the databases, developed the framework and java classes as needed.

§        Contract DBA support for database recover and tuning.

§        Built www.associatesupport.com web site. used graphis designers and technical writers for content.

1999–2003              Capital One Financial            Richmond, VA

Data Modeling and Database Administration Consultant

§        Built data model and development, test, UAT databases for $12 million recruiting and selection system. The GT8 system automated the delivery and collection of Bio data, test and interview results, and automated the scoring of candidates to allow a one day recruiting process for call center and non-exempt personnel.

§        Designed model and database for HR information factory and data mart. The key component of this model and database is the ability to integrate data from disparate systems. A concept called the Rosetta Stone, managed to create a master id for each person, and data from each system mapped to a master id allowed integration of HR data. In most cases we were able to prevent duplicate master ids from being created, except in cases where name only prevented an exact match. These were manually matched by data stewards to facilitate loading.

§        Designed and built 10 other small application schemas and databases in the HR space. These applications included: a skills database for associates to enter proficiency and experience factors for various job related skills, a data verification database, two reporting databases using oracle snapshots, a content based security application for the data mart, a master domain controller for cross referencing lookup table data between source systems, training database, special integration testing database, worked on many batch interfaces using PL/SQL and unix shell scripting.

1998–1999              Oracle Corporation               Richmond, VA

Principal Consultant

§        Production DBA for 50GB databases on HP V and N series. The main databases were refreshed from mainframe data nightly, and local applications enhancements to the data, and access to the inventory data for the Defense Logistics Agency, Dept of Defense agency.

§        System Administrator for Oracle Application Server, created and maintained the applications for the server as created by the app developers, and did the production turnovers for each application for both new and modified apps.

§        Developed standards for development turnover and application architecture for Oracle based applications. Worked with the operations and development management to begin a process for automated turnovers using standard directories and methodologies. Fully automated turnovers became the norm, and downtime due to manual turnovers became minimal.

1997-1999              Circuit City Stores/ Divx         Richmond, VA

Database Design and Development

§        Financial Systems, Customer Information System Modeler. Modeled and implemented all changes to the development and test databases and prepared turnovers for the delivery of changes into the production databases.

§        System Administration for Solaris reporting solution – Actuate. A member of the selection team for choosing an object based reporting tool which would function with the Informix database. Expected report size was tremendous, and web delivery was required. Managed the environment and developed turnover procedures for the developers to use in delivery of reports to the system administrators for turnover. Handled all upgrades to the software and maintenance on the unix servers.

1986–1997              Bank of VA, SIGNET, EDS.    Richmond, VA

Lead Programmer Analyst

§        Oracle Database Developer Credit Risk Management. Worked with an implementation team of 7 people to model commercial loan portfolio risk calculations. Models were built using Powerbuilder, SAS, and PL/SQL. SAS turned out to be the most effective across the portfolio. Much of the ETL was written in PL/SQL after staging with SQL*Loader.

§        Powerbuilder, SAS, and PL/SQL toolset. Worked with all 3.

§        Technical Lead for Visa and Mastercard merchant accounting, managed a team of 5 programmers for development and support. Mandated regulatory changes as well as operational improvements were my direct responsibility. My team provided on call support as needed.

§        Retail DDA, Time Deposits, IRA application team. Worked as the lead developer on several large regulatory changes including Regulation C for money laundering. Converted the DDA system from a series of hard coded values to a flexible system of parameters, making new product development less dependent on programming to improve the development cycle.

1981–1996              C. F. Sauer Company           Richmond, VA

Programming Manager

§        Managed a staff of 5 programmer analysts with direct responsibility for design, development, and implementation for all projects in Data Processing.

§        Built an accounts payable system for the distribution of cooperative advertising.

§        Built line scheduling algorithm for production to minimize backorders.

§        Managed implantation of Lawson Systems General Ledger system.

Education

BS Information Systems, Virginia Commonwealth University

Interests

Church, Baseball, Scouting, Soccer.