SUMMARY:

• Thirty years of experience in data and process modeling, design and implementation of enterprise information systems and relational databases, SQL programming, data migration, and corporate information management for Confidential and commercial customers.
• My professional software career spans more than thirty years; twenty of which have focused on relational data engineering, in which I am expert.
• My experience includes data standardization, corporate information management, logical and physical data modeling, database performance tuning, data migration (ETL), and complex data transformation using SQL.
• I am accustomed to performing in lead roles and am experienced with architectural analysis, program and project planning, technical oversight, team leadership, and mentoring of more junior software developers. I authored the software development life cycle (SDLC) document used by the information technology staff at the Department of Justice Office of Community - Oriented Policing Services ( Confidential ).
• I bring insight into enterprise information management and data driven software solutions.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Associate Architect

Responsibilities:

• Developed relational data to drive the Confidential Solicitation Management System (SMS), a data driven software application used to render on line applications for federal grants filled out by agencies nation wide seeking federal assistance to develop and support community oriented policing practices. Complex SQL queries are required to develop these data. I supported three annual solicitation cycles and five separate grant programs.
• Developed an extensible framework for extraction of grant application data from SMS and applied this framework to perform data extractions in support of grant proposal evaluation workflow, migration of data to related grant management applications, and DOJ Office of the Inspector General audits.
• Collaborated with the technical team lead to develop an SDLC aimed at providing technical guidance to developers, maintenance of coding standards, maintenance of repository integrity, alignment of software components with the Confidential Information Architecture, and alignment of implemented functionality with validated business requirements.
• Collaborated with the enterprise architect on design of a framework for implementation of workflow applications featuring a standard approach to .net and SQL Server coding of UI and data storage for complex data sets.
• Led developer teams in creation of a prototype for grant proposal evaluation using the workflow framework as well as development of SMS releases in 2016 and 2017

Confidential, Gaithersburg, MD

Responsibilities:

• Compiled library of SQL query patterns based on web research and implemented sample code in T-SQL under SQL Server 2012
• Developed a mapping meta-data store to support to ETL, backend to display layer data element mapping, and export generation.

Confidential, Fort Meade, MD

Sr. Database Developer

Responsibilities:

• Reverse engineered a relational data model from a complex SQL Server Database using metadata services
• Performed functional gap analysis and adapted the SQL Server database for the Corporate Management Information System (CMIS) application migrated from the Defense Systems Information Agency ( Confidential ) to Confidential based on Confidential ’s functional requirements
• Performed analysis of Confidential ’s manpower and human resources legacy data sources and developed a process to migrate Confidential data from these legacy sources to the adapted CMIS database
• Developed data migration to populate CMIS from Confidential legacy sources implemented using SSIS
• Developed a process to populate and update Confidential CMIS from the Defense Civilian Personnel Data System (DCPDS)

Confidential, Chantilly, VA

Sr. Database Engineer

Responsibilities:

• Developed schema elements in a SQL Server 2005 database to store ad hoc query definitions and forecast specifications
• Implemented T-SQL procedures to return variable width result sets for ad hoc queries against a meta-data driven schema by building SQL dynamically
• Implemented T-SQL procedures to parse query expression elements from an XML document and generate query result sets in XML
• Implemented T-SQL procedures to generate forecasts from historical data based on user specified parameters for historical data element selection and projection model

Confidential, Rockville, MD

Database Architect

Responsibilities:

• Architect for large scale systems including:
• Confidential Recreational Boating Accident Reporting Database (BARD) which was delivered in 2003 and featured schematic support for jurisdiction specific data elements and form design while protecting the integrity of data relevant to the Coast Guard
• Georgia Vital Event Information System ( Confidential ) which was delivered in 2007 and required compliance with Centers for Disease Control data standards while importing data from sources compliant with other standards
• Served as senior database planner and developer for Microsoft technology projects
• Performed data flow analysis, maintenance and enhancement of SQL Server 2005 databases with MS Access front ends, and SQL Server administration/monitoring for the Maryland Transportation Authority. Developed reports in SSRS as needed.
• Designed, implemented and maintained the US Coast Guard’s Boating Accident Reporting Database (BARD) in SQL Server 2000 as a data driven web accessible system. Performed migration of legacy data into this system. Enhanced the system through several major upgrades with production data in place.
• Reverse engineered a COTS SQL Server 2000 database containing transaction data related to services for the homeless for the state of Maine and developed views and procedures to extract data into cubes for a decision support system
• Designed and implemented the Vital Event Information System database ( Confidential ) in SQL Server 2005 for the state of Georgia as a data driven web accessible system including migration of legacy data. Migrated legacy data into Confidential using SSIS.
• Performed requirements analysis and designed a meta-data driven schema to store, query, and report on plant variety characteristics for the Plant Variety Protection Office of the USDA
• Designed and implemented a SQL Server 2005 database to store and analyze food sample pesticide screening results from laboratories across the country for the USDA Agricultural Marketing Service and performed data migration analysis
• Designed and implemented the Disqualified Recipient System (DRS) in SQL Server 2000 for the USDA Food and Nutrition Service and performed data migration
• T-SQL query optimization using Query Analyzer, SQL Profiler, and indexing

Confidential, Kensington, MD

Database Developer

Responsibilities:

• Developed a meta-data driven data model for the Infolinx customizable records management system which could be implemented in SQL Server 7, Oracle 7, or Microsoft Access
• Performed records management requirements analysis for a major mortgage loan servicer and developed a customized Oracle 7 Infolinx database to meet the requirements
• Planned and conducted migration of legacy records management data from various platforms including Clipper, Oracle, and Microsoft Access into implementations of Infolinx

Confidential, Aspen Hill, MD

Software Developer

Responsibilities:

• Developed PL/SQL stored procedures under the Oracle Web Application Server to provide navigable displays of data integrated from several military intelligence databases and selected based on user supplied search criteria for the Office of Naval Intelligence (ONI)
• Developed for ONI a data model for military equipment Characteristics and Performance (C&P) data with standardized data elements to accommodate C&P data held by other military intelligence agencies
• Developed Computer Aided Software Engineering (CASE) tools to reverse engineer legacy code and display its design graphically, to identify candidate code elements for partitioning into callable subroutines, and to store template execution patterns for common operations like binary search, computation of average, etc.
• Performed Nuclear Safety Cross Check Analysis for the US Air Force and systems testing of two real time embedded software systems for the US Navy
• Developed Fortran programs to place component geometry in a 2D design plane represented by a network oriented database
• Integrated computer aided design and drafting ( Confidential ) applications with external databases to ensure consistency of drawings with externally tracked nomenclature and component summary reports
• Migrated a mainframe based Confidential nomenclature tracking system to DBASE III