SUMMARY:

I have extensive expertise in data modeling and data quality analysis, enterprise architecture products and development, logistics management, and use of a wide range of modeling, CASE, and data quality tools. I have more than 35 years of work experience in information technology, logistics automated systems, data administration, requirements and business process analysis, technical project management, and analyzing data structures from which legacy elements are extracted and logical data models are developed. I am proficient in the use of Computer - Aided Software Engineering (CASE) tools such as ER/Studio, Telelogic System Architect, ERwin, BP Win, IE: Advantage, SQL Server Management Studio and Redgate SQL Compare.

PROFESSIONAL SKILLS:

Data Modeling Logistics automated systems

Data Standardization Logistics management

Data Analysis Software testing/evaluation

IDEF1X Technical writing

IDEF0 Manpower planning/management

Data management Information modeling

COMPUTER EXPERIENCE:

Software: ER/Studio, ERwin/ERX, MySQL, Telelogic System Architect, BPWin, Visio, MS-Access/Word/Excel/ PowerPoint, Adobe Acrobat/PhotoShop, SQL Server Management Studio, Redgate SQL Compare

Environment: s DOS, Informix, MS-Windows 3.x/NT/95/98/2000/XP/2007/2010, UNIX, SQL

DBMS: MS-Access, SQL Server, DB2, Oracle

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Data Modeler

Responsibilities:

• I have been responsible for maintenance and update of a number of legacy system data models, creating new models, generating data definition language for data base update, running insert SQL statements to staging environments, and updating release documentation.
• Major initiatives have included building a new data model to support report generation for the chairman’s dashboard and currently six data models to support report generation for new Additional Preferred Provider Organization (APPO) reports.

Confidential, Reston, VA

Senior Data Modeler

Responsibilities:

• I was part of a team supporting expansion and modernization of the enterprise data warehouse for the Confidential .
• Using agile development principles and Erwin v9.6 modeling tool, I analyzed data from source systems, created logical and physical data models of several domains totaling in excess of 330 tables, generated and implemented data definition language (ddl) in various EDW databases using SQL Server Management Studio.
• Other tasks included establishing and maintaining a comprehensive data dictionary for all of the tables comprising the EDW, naming and defining several hundred key constraints, creating and naming in excess of 1500 indexes.
• I also supported major releases of the EDW by reverse engineering and maintaining the staging and master input databases and generating delta scripts for their implementation in the release environment using the Redgate SQL compare tool.

Confidential, Arlington, VA

Consultant

Responsibilities:

• I was engaged in training in a large variety of topics including sql programming and queries, data analytics, big data, data visualization, data governance, transportation, SAP, and advanced instruction in MS Office products.

Confidential, Herndon, VA

Senior Data Modeler/Analyst

Responsibilities:

• I provided in depth analysis and construction of a logical/physical model for 11 different areas of loan data required for stress test analysis by the Confidential.
• This involved analysis of a variety of source system data, coordination with subject matter experts, development of standardized business names and definitions, construction of a non-relational data model using ERwin v9.2 modeling tool, publishing of a data dictionary, review of the model and dictionary with subject matter experts and generation of data definition language (ddl).

Confidential, McLean, VA

Senior Principal Database Analyst

Responsibilities:

• I was a member of the FDIC Enterprise Information Management (EIM) Data Architect team with responsibility for analysis of requirements, and preparation of new application development, support and preparation of changes to existing applications, update of existing application data models using the ERwin and ER/Studio tools, synchronization of application models with the production databases, maintenance and update of the FDIC Conceptual Data Model, maintenance and update of the Enterprise Data Model, maintenance and update of the model manager libraries, analysis and submission of changes to the Standard Glossary of Terms, coordination with development teams for any new application development or existing application support, preparation of change packages for existing application support and new application development to include update of logical and physical models and data definition language (ddl) generation across multiple database platforms (MSSQL, DB2, and Oracle).
• I supported over 150 existing application databases that were split evenly across DB2, MSSQL and Oracle platforms.
• I personally developed models and generated data definition language on the Oracle platform for at least 6 new applications.
• Other duties included review of all change packages including those from other DAs prior to submission of packages to ElM, submission of all change packages to ElM for review, scheduling recurring Data Management Control Board meetings and coordination with ElM section, publishing DMCB results to all FDIC project managers and other interested parties, managing remedy tickets assigned to the DA group to include assignment to a specific DA and followup to insure ticket is completed in a timely manner, coordination with appropriate DBA for post review implementation of approved change.
• During the last 3 years of this position, I was assigned additional duties as an administrator for ER/Studio.
• This involved the conversion of over 200 models from ErWin and resolution of all the conversion errors/differences, setup and maintenance of the repository in ER/Studio, creation of project folders for non-admin users, movement of models between development and production libraries, archiving of superseded and updated models, and the creation and maintenance of user accounts and assignment of user permissions.

Confidential, Arlington, VA

Data Architect

Responsibilities:

• I was responsible for various projects in support of the Enterprise Information Management Section for the Confidential
• In this capacity, I developed draft enterprise level logical and physical data models for the fourteen FDIC defined families of data.
• This involved analysis of the business functions of FDIC and development of the business objects and their attributes in accordance with FDIC standards for naming and defining.
• I was responsible for the development of logical and physical data models and data definition (ddl) generation using the ERwin modeling tool to support several new initiatives at FDIC including the Background Investigation Database System (BIDS), Automated Loan Examination Review Tool (ALERT), and the Basel II Capital Accord which provides regulatory directions for the reporting of risk based capital by banks.
• Additionally, I prepared and presented Data Management Control Board (DMCB) change packages for enhancements and changes to existing applications.
• This involved coordination with DBA’s and developers to determine the correct requirements for the application changes, preparation of the logical and physical models across DB2, MSSQL and Oracle database platforms in accordance with the Enterprise Architecture, generation of the data definition language (DDL) to create the database, and preparation of the package documentation for presentation to the DMCB review board on a weekly basis.
• I served as the data management section point of contact for all DMCB change packages prepared by DA’s/DBA’s with the responsibility for review of all packages and the presentation of the packages to the DMCB on a weekly basis.

Confidential, Alexandria, VA

Information Engineer/Systems Analyst/Data Modeler

Responsibilities:

• I worked on a project to establish a Program Management Office for the Army as executive agent for Confidential Biometrics.
• In this capacity, I reviewed and participated in the development of requirements documents, developed a draft data management plan, and participated in requirements, standards, and architecture Integrated Product Teams for the project.

Senior Systems Analyst

Confidential

Responsibilities:

• I worked on project for the Confidential Business Transformation Agency to develop and enhance release 3.1 of the Confidential Business Enterprise Architecture (BEA).
• In this capacity, I was responsible for developing Operational View7 (OV7) data models for the Common Supplier Engagement (CSE) business area as well as its relationships to the other business areas and architecture products using the System Architect tool.
• I analyzed the business processes and data requirements for Intragovernmental Transactions and incorporated them into the CSE data models. I developed and recommended over 70 potential enhancements to the CSE business area data models.
• I analyzed 690 OV6a business rules to insure the OV7 data models supported them and that they were aligned with the proper Business Enterprise Priorities (BEP) or Core Business Missions (CBM).
• I researched and analyzed Data Objects and Information Exchanges to insure the correct BEP and CBM alignment.

Senior Information Engineer

Confidential

Responsibilities:

• I interviewed division level supervisors and other subject matter experts to analyze, develop and record business activities, business processes, and organizational charts.
• I worked in support of a project to analyze and standardize from three legacy databases approximately 15,000 data elements and create a data dictionary and repository for the Office of the Chief Financial Officer of the Confidential . In this capacity, I reviewed system data documentation, functional documentation, and interviewed various SMEs to eliminate redundant data elements and create standards to be used across the various HUD financial systems.
• I was involved with the development and testing of the Naval Aviation Production Program Integrated Production Data Repository. In this capacity, I was primarily responsible for resolving exceptions connected with the creation and display of analysis charts, analysis of exception and historical data, and development of an online user guide for the process. Additional responsibilities included initial population of the database, creation and maintenance of system user files, monitoring of customer data input and submission of input data to approval authority.
• I was responsible for the analysis of the business functionality of the Order Fulfillment and Accounting System (OFAS) to determine the data requirements for inclusion in an enterprise level data model. In this capacity, I analyzed system documentation, conducted interviews with SMEs, and visited work sites to capture the functionality of OFAS and determine a comprehensive set of data entities, data attributes, and business rules for inclusion in the Confidential data model.
• I was responsible for analysis and determination of business rules, collection of system functional requirements, preparation of logical data models, mapping of source system functional data elements to newly proposed data elements or existing Confidential standard data elements, creation of new Confidential compliant standard data elements, and preparation of proposal packages for Confidential approval and integration into the Confidential Data Model in accordance with Confidential 8320 standards.
• I analyzed and resolved comments from the functional proponent on the second phase of proposal packages submitted for the Defense Training Standards Working Group. In this capacity, I made corrections as necessary using the ERwin data modeling tool to data models and proposal packages, responded to comments from the functional proponent, and conducted coordination with other functional proponents when data elements used in the Confidential models fell under their stewardship
• I analyzed the data and business practices to determine the requirements for a comprehensive data model to support development of an automated information system for the Military Working Dog Management System. In this capacity I was responsible for collection of system functional requirements, analysis and determination of business rules, preparation of logical and physical data models using the Erwin data modeling tool, mapping of source system functional data elements to newly proposed data elements or existing Confidential standard data elements, creation of new Confidential compliant standard data elements, and preparation of proposal packages for Confidential approval and integration into the Confidential Data Model in accordance with Confidential 8320 standards.
• I analyzed requirements and developed a logical data model of the real estate inventory view in support of an enterprise data warehouse development project for the Department of Housing and Urban Development. In this capacity, I analyzed functional documentation, interviewed SMEs, and prepared logical and physical data models using the Erwin modeling tooland data dictionaries for the real estate inventory view.
• I developed the Materiel and Materiel Item logical data model views and prepared Confidential standards compliant proposal packages for the Defense Training Standards Workgroup (DTSWG). In this capacity, I analyzed documentation, conducted interviews with SMEs, prepared logical and physical data models using the Erwin modeling tool, and mapped source system functional data elements to newly proposed data elements or existing Confidential standard data elements. Additional tasks included preparation of proposal packages for approval and integration into the Confidential Data Model and coordination with functional proponents for submission of the proposal packages.
• I provided contractual support to the Confidential Occupational Measurement Squadron for six separate automated systems dealing with the functional areas of occupational analysis, testing and evaluation. In this capacity, I was responsible for collection of system functional requirements, preparation of logical and physical data models using the ERwin data modeling tool, mapping of source system functional data elements to newly proposed data elements or existing Confidential standard data elements, creation of new Confidential compliant standard data elements, and preparation of proposal packages for Confidential approval and integration into the Confidential Data Model in accordance with Confidential 8320 standards.

Confidential, Arlington, VA

Principal Research Scientist

Responsibilities:

• I provided contractual support to the Confidential for worldwide implementation of the Single Stock Fund concept.
• In this capacity, my primary responsibilities were development of an implementation plan and assisting in preparation of a training/marketing plan and cost benefit analysis.
• I worked closely with numerous government staff elements to analyze various factors impacting on cost and implementation and researched technical documentation to gather information about automated logistics and financial system processes in order to provide the most efficient and least costly plan for Single Stock Fund implementation.