Data Project

DAVID J SCHKLOVEN

**** ***** ****** • BALTIMORE, MD 21209

PHONE 410-***-**** E-MAIL **********@*******.***

S UMMARY

Data Architect / Database Designer with more than 25 years of information systems experience and more than 17

years of data architect experience. Track record of taking on and solving the most-challenging database problems in

government and business settings. Worked at the Enterprise, program and project levels.

Proven track record of delivering high-quality, mission-critical databases on time and budget and rapidly identifying

data conversion problems on modernization projects.

Superior communication skills. Works well with technical and non-technical team members at all levels. Effective

mentor to junior staff. Articulate in print and in person. Briefed the IRS Commissioner and program executives on the

project database design, data issues and technical opportunities

A REAS OF EXPERTISE

Data Architecture

SQL

Metadata Management

Data Standards Planning

Data Governance Principles

Full Life Cycle Support

Data Model Management

Data Requirements Analysis

Data Recovery Strategy Planning

Data Dictionary Management

Enterprise Information Management

Conceptual to Physical Data Modeling

Data Conversion Planning

Data Archiving

Performance Based Tuning

Data Warehouse Design

Data Stewardship Principles

Data Quality Principles

T ECHNICAL SKILLS

Databases: IBM DB2, Microsoft SQL Server, Microsoft Access and Oracle. Database design and tuning, system

architect, system design, relational modeling and data warehousing

Operating Systems: TSO/CICS, Windows and Unix

Tools/Programming: IBM Rational Data Architect, Rational Rose, Rational ClearCase, Rational ClearQuest, IBM -

Telelogic System Architect, AllFusion ERwin Data Modeler, Microsoft Visio and Oracle Developer 2000, Microsoft

Office suite, SQL and Microsoft Visual Basic for Applications

P ROFESSIONAL EXPERIENCE

Senior Data Architect Alltech International, Inc.

Subcontracted to Computer Sciences Corporation on project for the IRS 2000 - 2009

**********@*******.*** 410-***-**** Page 2

David J Schkloven

Enterprise Data Architecture –

Briefed executives on enterprise level issues and opportunities

Briefed IRS Commissioner on enterprise level operational database design

Authored and updated versions of the Enterprise Data Architecture and the supporting Enterprise Logical

Data Model

Wrote the Enterprise Level Data Conversion Plans, Data Archiving and Data Recovery Strategies

Developed a strategy for storing and utilizing unstructured data, a concept of active archiving for the

database and a concept of performance based database tuning

Authored IRS Enterprise Data Standards later promoted to Treasury-wide Enterprise Standards

Project Data Architecture –

Extracted data requirements from existing system, system documentation and IT and user interviews

Developed database design during the business system design and development phases of the project

and created supporting logical and physical data models

Assisted the conversion effort during the implementation of schema changes, identified data conversion

problems, provided review of the conversion efforts, provided strategies for enhancing performance

and participated in performance tuning design sessions, supported testing efforts on multiple releases

Documented the new database structure in the data dictionary and authored position papers on various

topics dealing with financial transactions and memo transactions

Program Data Architecture –

Created and modified the conceptual, logical and physical data models for multiple phases of associated

projects and the enterprise level conceptual and logical data models for the entire program including

the conceptual data model used for the Request for Proposal (RFP)

Captured data and application requirements during the initial phases of the project effort

Conducted briefings to executives, managers and developers on program design and individual project

requirements

Data Architecture

Authored reports defining modifications to database to facilitate performance tracking and reporting and

developed database views to improve the performance of the MIS system

Wrote extraction programs from existing database, file transfer programs between systems and the data

evaluation and insertion programs for transaction tracking and reporting

Developed reports, evaluated and modified requirements and specifications and evaluated the database

model to reduce redundancy and improve the efficiency of the system database

Developed and implemented templates used to create supporting reports

Data Architect Global Computer Staffing, Inc.

Subcontracted to ACS Government Services Inc. on project for the US Dept. of Ed. 1998 - 2000

Conducted analysis, developed database and implemented modifications to the primary and supporting

databases on DB2, Oracle and Access platforms

Participated in analysis, development and testing of COBOL code for the project

Authored reports defining modifications to database for performance tracking and reporting

Developed database views to improve the performance of the MIS system

Developed and implemented an automated template for the production of the Run Book System

**********@*******.*** 410-***-**** Page 3

David J Schkloven

Consultant Automation Consultants, Inc.

Consultant to various clients 1997 - 1998

PHH Fleet Leasing

Data Architect / Lead Requirements Analyst

Participated on a system design project

Evaluated current data model design to facilitate information sharing

Lead analyst during the information gathering, requirement analysis and process definition phases of the

project evaluated current data gathering and customer set-up processes for unrelated systems to evaluate

and design common processes to facilitate information sharing and common reporting requirements

Credit Risk Management Associates

Data Architect / Analyst

Participated on a Year 2000 analysis and code modification project.

Participated in the analysis, modification and testing of existing COBOL code for specific clients

Performed analysis and modified existing code using File-aid and Endeavor along with standard TSO

utilities

Designed and developed the Y2K process documentation database using Access 97 used to store client

data and program inventory and results of the analysis, modification and testing process as well as the

project management documentation

Designed and developed reports for inter-team, supervisory and client needs

Developed, modified and managed the client’s project scope as a management team member

Documented issues and their impact on the project using word processing documents and spreadsheets.

Lockheed Martin

Data Architect

Participated in object design sessions, process model review sessions and data design sessions

Used Powersoft Data Architect development tool to record Data Model requirements and to define and

generate database schema, both logical and physical targeting the Oracle DBMS

Supported the project team by providing data modeling, consultation services and database technical

expertise

Data Architect / System Engineer Loganbritton

Consultant to Zurich Personal Insurance 1995 - 1997

Engaged on a development effort to rewrite an insurance policy writing system

Facilitated development of business data model, identification of system components for development,

development of data model review methodology and review schedule

Facilitated object design sessions, model review sessions and database design sessions

Employed ERWin as a working tool during data requirements analysis and IEF OS/2 and Windows

development tool (version 5.3.1) to record Data model requirements in the central encyclopedia

Provided consultation and expertise for data and process modeling and IEF technical support

Graphically designed an interactive Data Manipulation Language (DML) engine using Dynamic SQL

Designed an inferred logic based engine for data capture during an interactive interview

Used word processing and Lotus Notes to document issues of a business or technical nature and to

document the impact of those issues on the project

Assisted in the project management for the development and maintenance of DB2 database development

schedule

Established the methodology for information gathering and evaluation, developed methods to capture

business events and business information life cycle data

**********@*******.*** 410-***-**** Page 4

David J Schkloven

Data Architect Software Resources International, Inc.

Consultant to the IRS 1992 - 1994

Provided development coordination services during two modifications and three contract extensions

Established model management procedures and change control procedures promoting the sharing of

objects for the project

Authored model review and reconciliation reports for development models at the client site

Data Architect / System Engineer Mindbank, Inc.

Consultant to the Interamerican Development Bank 1991 - 1992

Participated and led Joint Application Development (JAD)/ Joint Requirements Planning (JRP) sessions, and

provided expertise during the modeling of both data and activities to eliminate redundancy and improve

system efficiency

Used Business Process Re engineering (BPR) techniques to identified changes to workflow to improve the

productivity of the workforce and to make functional changes to enhance overall business performance

Took part in the identification, definition, and redefinition of user processing requirements necessary for the

proper selection of an integrated systems package purchase

Consultant DTC, Inc.

Subcontracted to various clients 1990 - 1991

County of Milwaukee

System Engineer / Lead Requirements Analyst

Participated in the systems design, technical design, and code generation for portions of a Business System

Implementation (BSI) phase of the Criminal/Civil Justice Information System (C/CJIS) project

Developed logic used to capture information during intake screening and initial housing assignment of

inmates

Developed decision tree based logic to evaluate the inmate and to recommend a housing assignment based

on table based data and algorithms

Designed and generated the screen layout for each on line procedure

Modeled and built a basic table based inference engine to conduct. record and evaluate interview of

inmates.

Participated in the collection and evaluation of user data and processing requirements

Led JAD/JRP sessions, modeled both data and activities during the analysis phase of the project

Naval Aviation Depot Operation Center

System Engineer / Analyst

Participated in Depot Improvement project for Facility, Maintenance Services and Aircraft Scheduling

Management and Depot Accounting and Cost Analysis Systems

Led JAD/JRP sessions, modeled both data and activities during the analysis phase of the project

United States Marine Corps

Data Modeler

Participated in the development of the Enterprise Models used to document potential study areas for the

analysis of Nuclear, Biological, and Chemical warfare scenarios

Led JAD/JRP sessions, modeled both data and activities during the analysis phase of the project

Employee National Security Agency

Employed as a Special Research Analyst, Data Analyst, and Process and Data Modeler 1983 - 1990

Data Analyst / Modeler

Responsible for a analysis project defined in an earlier strategic planning effort; prepared schedule and

staffing requirements, defined the necessary subtasks and coordinated meetings with senior management

**********@*******.*** 410-***-**** Page 5

David J Schkloven

Modified and tailored the methodology used to conform to the specific needs of NSA/CSS, and adapted the

data model to reflect the unique nature of the associated data stores

Conducted and controlled data gathering sessions with senior and middle management

Produced data and process models and defined natural business systems and data stores using case tool

Briefed executives on enterprise level issues and opportunities

Special Research Analyst

Responsible for the analysis and reporting of various issues, findings and opportunities that were presented

for analysis in the various departments and projects in which I was involved

E DUCATION AND PROFESSIONAL DEVELOPMENT

The University of Baltimore Baltimore, MD

Historical Research, B.A.

James Martin and Associates: Information Strategy Planning and Business Area Analysis.

Texas Instruments: Information Strategy Planning and Business Area Analysis, Advanced Data Modeling,

Business Systems Implementation. Business Area Analysis II, Business System Design, Technical Design,

Construction.

Other: Structured Data Analysis, Structured Process Analysis, and Data Modeling, Visual Basic for Applications,

Database Tuning Concepts

A FFILIATIONS

The Association of Information Technology Professionals – Baltimore Chapter

C LEARANCES

TS-SCI – expired, 1995

Treasury MBI – active

Contact this candidate