SUMMARY:

• I have extensive expertise in data modeling and data quality analysis, 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 have several years of domain knowledge in the areas of mortgage and banking, health insurance and logistics management.
• 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 IDEF1X
• Data Standardization IDEF0
• Technical writing Manpower planning/management
• Data management Logistics management
• Software testing/evaluation Logistics automated systems
• Information modeling

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Data Modeler/Analyst

Responsibilities:

• I was 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 more than ten 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.4 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:

• While awaiting assignment of an open role, I was engaged in 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 Confidential 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 Confidential 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 Confidential 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 Confidential defined families of data.
• This involved analysis of the business functions of Confidential and development of the business objects and their attributes in accordance with Confidential 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 Confidential 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 . 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.
• 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 ( Confidential ) business area as well as its relationships to the other business areas and architecture products using the System Architect tool and Confidential Architecture Framework (DoDAF).
• I analyzed the business processes and data requirements for Intragovernmental Transactions and incorporated them into the Confidential data models.
• I developed and recommended over 70 potential enhancements to the Confidential 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.
• I worked on a project to develop enterprise architecture for the Military Sealift Command. In this capacity, I interviewed division level supervisors and other subject matter experts to analyze, develop and record business activities, business processes, and organizational charts.

Database Analyst

Confidential

Responsibilities:

• 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.