Project Data
Resume:
CARLTON DANIELS
Gahanna, Ohio 43220
Over eighteen years experience in the development of business application systems with
exposure to all phases of the system development lifecycle. Over 10 years IT experience from a
system architecture perspective with proven experience in data modeling [ER (9 years) and
multidimensional (6 years) – Kimball], database design and deployment, data quality and
applications development. Seeking a project to utilize my background in Data Modeling ( Erwin)
and systems development following standard industry practices.
PROFESSIONAL EXPERIENCE
Collabera, Inc 06/2010 -
Present
Data Architect Consultant
Client: JPMorgan Chase
* Performing requirements gathering and analysis, design and development of applications for
the IPA Service Repricing project.
* Responsible for managing data model changes, designing source-to-target data migration, and
developing application programs to execute the data load process.
* Tools utilized include Oracle 10g, Toad, Toad Data modeler, PL/SQL (packages and
procedures), SQL*Loader.
Salient Information Technologies 09/2005 – 10/2009
Senior/Lead Consultant (Business Analyst / Data Modeler / Data Architect)
Client: World Bank
• Performed Requirements and Business Process Analysis. Served as Lead Designer and
Data Modeler (Erwin 7.0) for the Investment Datamart (Equities, Loans, Derivatives, and
Swaps). Major contributor in the formulation of system architecture to deliver the data mart to
IFC. Lead designer for the project as I advised both business and technical team members
as to what was required to achieve a successful project. Set the stage for Master Data
Management by instituting conformed dimensions. Provided guidance to ETL developers as
well as developed ETL programs utilizing Oracle PL/SQL. Also provided guidance to
Cognos report developers in order to create a corporate dashboard reporting mechanism.
Commended for delivering project in a short amount of time.
• Working with departmental SMEs throughout company and other business analysts as liaison
for the corporate ODS database providing integration consultation to various project teams;
provided documentation of project requirements for “sign off” approval. Coordinated project
efforts through all project phases, requirements through implementation and on-going
maintenance. Designed and developed stored procedures for various projects;
Client: Freddie Mac
• Responsibilities as Lead Data Modeler / Data Analyst: 1). Capturing and representing
business requirements in the form of logical data model, 2.) Communicating design approach
and providing impact assessment for all modeling activities to the client and vendor project
teams via design review sessions; 3). Translation of physical design to DBA staff; 4).
Coordination of deployment activities.
• Added exceptional value to a client’s project team by conducting business process analysis,
system requirements analysis and logical/physical design of the data model for the ISR3
Entitlements database which is a repository for user entitlement provisioning, recertification
and remediation workflows across technology platforms for the entire corporation.
Responsible for setting the direction for the data architecture requirements.
Trilogy Technical Services 02/2005 – 09/2005
Data Architect / Project Lead
Client: AOL
• Performed lead role as Data Warehouse designer: Fielding business and technical questions;
Mentoring technical staff (6 persons); Communicating the overall architectural design to the
team (System Architecture, Data Model, ETL design); Reported to the Director of Software
Contracts; Developed project plan (MS Project) and reported to Director of Software
Development to confirm project priorities, team resources and timelines.
• Responsible for the design and development of the ACC2 Reporting Data Mart for America
Online, Inc. This required the analysis of the reporting needs of business analysts to
construct the logical multidimensional Star Schema to track the effectiveness and
performance levels of collections activities of AOL and its collections vendors. Identified
requirements for factless, as well as aggregate tables utilizing Erwin 4.1 as the modeling tool.
Performed source-to-target analysis which was utilized by ETL developers and
documentation analysts. In addition, provided assistance to OLTP project teams.
CLMS, LLC
Data Analyst/Modeler 08/2004 – 02/2005
Client: SRA contract for the DOD
• Assumed responsibility for the database design and maintenance of the Central Issue
Facilities data model, which is part of the Information Systems Management automation
project for the U.S. Army. Duties included: 1) Analysis of system process change requests
and submission of scope document for confirmation of request interpretation including
proposed solution, 2) Data model modification utilizing Oracle Designer (6i) and
generation of DDL to implement model solution, 3) Submission of recommendations for
application development, 4) Detailed documentation of model changes, 5) Coordination of
model change implementation with DBA (logical modeling and physical design
implementation, and 6) Developed PL/SQL procedures for data cleansing/migration and
performed code review for the migration team.
• Contributions to the project include: 1) Evaluated cleansing rules developed to convert data
from legacy systems to the modernized database schema. Identified issues of
standardization of data for quality assurance and discrepancies between cleansing rules and
migration code. 2) Assisted with data model change requests for the TRANSPROC model
when needed, 3) Researched issues regarding Oracle tools for the database administration
team.
• These efforts allowed the Central Issue Facilities project progress with greater clarity and
ahead of schedule. Project manager and team lead have expressed confidence in these
efforts and acknowledge the clarity of focus that has resulted. In addition, documentation
submitted to the user community has prompted significant feedback in resolving issues of
standardization across facilities. Efforts employed on this project have served as a Model for
the TRANSPROC migration effort.
Custom Technology Integration
Senior Programmer Analyst / Data Modeler 08/2002 – 06/2004
• Performed as Lead Technical consultant: Database design utilizing Oracle Designer;
application programming utilizing Oracle forms and Pl/Sql to develop stored procedures and
triggers. Created logical and physical data models for projects serving private businesses
in manufacturing as well as State Government: Inventory Shipping & Tracking system;
Contract Legislation Review (CLR) system. Developed Oracle Forms applications for the
CLR system and performed basic DBA duties by creating and managing databases,
tablespaces, indexes, user accounts, roles and granting privileges.
Trilegiant Loyalty Solutions
Senior Programmer Analyst 10/2001 – 08/2002
• Performed development projects across various business units of the company. This included
analysis and system requirements definition, database design (logical and physical),
development and deployment of business applications to facilitate integration of new clients
and support of existing clients. Performed data quality analysis with respect to the integration
of vendor data. Software utilized included: Designer/2000; Oracle Developer 6i; SQL
Navigator, PL/SQL for stored procedure and trigger development.
OraSys, LLC / Envera, LLC. (Subsidiary of Ethyl Corp.) 09/2000 – 08/2001
Lead Contract Consultant – Developer Data Warehouse Data / Modeler
• Performed contract duties as Lead Developer: Responsible for the oversight of all
development relating to the warehouse: project staffing and scheduling (MS Project),
analysis, design, and development of the database schema and ETL procedures. Served as
the data modeler for the multidimensional database and also provided relational
design assistance for the production system database utilizing Oracle Designer. Other
software utilized: Oracle 9i RDBMS, Toad and SQL, PL/SQL, Oracle Sales Analyzer.
Metro Information Services / State Corporation Commission 07/2000 – 09/2000
Contract Consultant / Sr. Programmer Analyst / Data Modeler
• Performed analysis and development to convert historical employee records for retrieval by
Oracle’s Human Resource Management System. This included analyzing PL/SQL APIs and
writing procedures that would invoke them in the proper sequence passing the appropriate
parameters.
US Army, Fort Lee 03/2000 – 06/2000
• Database designer for the logistics supply center at Fort Lee using Designer/2000. Also
provided technical assistance regarding application development.
Modis, Inc. 12/1995 – 03/2000
Virginia Department of Vital Records and Health Statistics
Consultant / Sr. Programmer Analyst / Data Modeler
• Sr. Programmer / Analyst, Database Administrator for the OVRHS Data Mart project.
Responsibilities were to create the dimensional data model, ETL procedures to migrate
health statistics data from IBM ISAM files to an Oracle8i database. Participated in the
evaluation of decision support software (SAS, SPSS, Microstrategy): installation, review of
functionality, licensing requirements, product support and costs. Implemented MicroStrategy
decision support software to provide analysis and reporting capability for the Health Statistics
team. Also performed application development, data modeling, database creation,
monitoring and maintenance in support of the data mart and data entry functions; Software
utilized: Installation of Oracle 8i on Windows NT, Designer /2000, Oracle Forms 4.5 and 6i,
PL/SQL, SQL*PLUS, SQL*LOADER, UNIX.
University Of Richmond
• Programmer/Analyst for the Alumni Development conversion project. Development of
PL/SQL programs for data migration from legacy systems to an Oracle database. Gathered
the requirements from business end-users as well as IT staff; Created the database schema
to support the migration; administered user security to support data QA efforts; Software
includes: SQR, SQL*PLUS, PL/SQL, SQL*LOADER, Oracle Forms 4.5, UNIX, Microsoft
Project.
Philip Morris
• Programmer/Analyst serving as a support person for the Manugistics Inventory
management system. Responsible for monitoring daily production processes to ensure
timely and accurate inventory order fulfillment. Provided technical support for Customer
Service. Performed development and maintenance of the Vendor Management
Replenishment System. Integrating new VMR partners utilizing SQL*Plus, PL/SQL, UNIX and
ORACLE FORMS 4.5 and Business Objects. Also responsible for coordinating proper vendor
data feeds for integration with system process and databases.
Quantum Resources, Inc. / Capital One 03/1994 – 12/1995
Contract Programmer / Data Modeler
• Responsible for the design, development and maintenance of the Strategy Fulfillment
modules. Provided Oracle systems problem identification, analysis and resolution for
Tangent data capture processes and database procedures; technical support for business
analysts, and key users. Coordinated special project development and implementation.
Designed database tables, developed, and implemented the Access Check Credit Limit
Increase System utilizing PL/SQL.
Dynamic Resources, Inc. / Halliburton NUS
Programmer Analyst 01/1992 – 12/1993
• Participated in the development of the ALARA and RAC modules of the Radiological
Management System Utilizing SQL*FORMS 3.0 and SQL*REPORTWRITER 1.1.
United States Coast Guard
• Served as a Consultant on the Personnel Management Decision system development team
using PRO*C, SQL*FORMS 3.0, SQL*REPORTWRITER 1.1, and ORACLE CASE (early
version of Oracle’s Designer tool.
(Additional experience that predates above provided upon request)
Dental Benefit Providers
Programmer Analyst 03/1988
– 09/1990
• Participated in the Claims Processing system development project to capture, process and
manage dental claims with respect to patients, providers, benefit plans, premium receipts and
payments for dental claims.
• Performed systems analysis following the Price Waterhouse Top Down system development
methodology; data requirements analysis to produce a logical data model later translated
into physical design; Application development using Oracle Forms and Pro*Cobol; Supported
all phases of system testing and delivery.
EDUCATION
Undergraduate: Northwestern University, 1984
Technical School: Computer Learning Center, 1987
TECHNICAL SKILLS
Hardware: HP3000, HP9000, IBM 4341, IBM 3090, DG 20,000, DEC/VAX, ALTOS,
Sequent
Operating Systems: MVS, AOS/VS, HP UNIX, Windows 2000, Windows NT
Software: Oracle (8i, 9i, 10g), Oracle Designer 6i, SQL, PL/SQL, Oracle Forms 6i,
TOAD, SQL Loader, PRO*COBOL, Microsoft Project, Visual Basic 6.0,
Business Objects, MicroStrategy, Erwin 4.1 ClearCase, ClearQuest
Contact this candidate