AREAS OF EXPERTISE :

Solid understanding and experience in the the design and establishment of practical Information Architectures, Master Data Management MDM , Enterprise Data Models, BI infrastructure corporate data warehouse model , 'to-be' data models OLTP and Analytical applications, Establishing corporate-wide metadata mapping standards and guidelines Identifying and uncoupling business process logic from data in existing complex distributed transactions management of multiple data integration projects establishing integration standards via SOA 's canonical model to conform to EA governance procedures Mentoring and teaching seminars on EIA Gartner EA, NIEM's XML Schema , UML and component based modeling- working knowledge

WHITE PAPERS:

• When SOA runs into MDM, you are on the right track
• How reliable is the data in your data warehouse
• The advantages of having a multi-dimensional database in data
• warehousing solutions.
• Data Governance a rewarding corporate effort
• From Business Processes to Service Oriented Architecture
• Published by Oracle.com- expert advice, IT-online local TV channel, VISIBLE
• Corp BIEC.co and VLDB Forums

PROFESSIONAL EXPERIENCE:

Business Information Engineering Corporation BIEC Principal, Consultant on BIEC contracts:

Project Manager / Sr. EIA VL Contract

Application middleware app Data warehouse staging EDM extension middleware app designed a highly adaptive enterprise data model Responsible for overseeing technical solutions alternatives and final implementation in a parallel proto-type platform to find and automatically correct the data integrity problems of existing databases or any data source increased data quality and consistency across online database systems by developing and adhering to a subset based EA framework developed by my company Developed dynamic online Master Data links within the source systems virtual MDM repository using proprietary Agile software development framework EIA courses technical material for teaching seminars and practical 'how to' guides on Enterprise Information Architecture and business use of SOA based MDM platforms customizing for pharmaceutical companies as vendor solution package

Federal Contract IBM, Sr. Enterprise Architect design and strategy in setting the foundation for data governance under EIA framework .Data requirements and analysis defining Customer Care architectural standards, redesign of existing CRM Data Definitions and data models. Delivered customized and integrated CRM data models.

Confidential

Business Intelligence BI Federal Contract NetStar- Project lead -Analysis of existing data sources and data marts to improve BI functionalities Promoting DMBOK practices as the technical lead on Tri-Health Care System's data mart design and MDM staging 'to-be' proposal teaching and providing design guidelines on various data warehousing efforts such as inclusion of organizational business requirements into ERD to maintain application independence Provided plans to fit within EIA framework which shifts to a vertical approach to LOB data integration.

Confidential

Sr. EIA Architect and Project Manager-Responsible for enterprise-wide data governance, MDM design and overseeing massive data cleansing efforts Led a team of 12 DBAs and engineers involved in coding and extensive re-modeling including detailed

manual checks of data volumes set formal procedures for SME interactions and corporate-wide access of business data through UML notations and diagrams.

Project Manager

Confidential

• Hired and managed a team of 14 data architects and BAs to work on the
• development of Winstar's enterprise-wide data and process 'to be' models defined and documented the requirements of candidate models EDI,MDM of today delivered specification and design of the 2000 entity corporate ER Diagram successful modification of organizational Order,CS,provision,billing logical data and process models leading to significant improvements in data quality. Seminar instructor on modeling and normalization The development tasks were as follows parallel db setup and meetings with various corporate staff and documentation of the enterprise model-and DDL in Designer2K For the first time corporate data definitions were mapped and made shareable across all development platforms Oracle 9g, SQL server, excel,flat files . Selected the vendor and tools for my 3 projects.

Confidential

Mentor/Data Architect / Walter Reed Army Medical

Developed requirements analysis documentation and questionnaires by evaluation of existing reports, SME interviews and recent I/O patterns point of contact for the preliminary 'to-be' data model of national breast cancer database to physicians and staff Defined data dictionary and assigned tasks to the database development teams

Confidential

• Sr. EIA consultant to the MIS department on the establishment
• of the Enterprise Architecture framework Analysis of applications,
• data models, backup and recovery plans, platforms and tools Oracle DBA
• responsible for performance and tuning of an SMP load
• balancing HP-ux Unix OS running 3 Oracle instances high volume
• distributed transactions replicated via Oracle multi-master symmetric replication method. System later purchased by Wells Fargo Bank.

Confidential

Sr. Data warehouse Consultant

Financial data warehouse architect- defined project and guidelines

Confidential

examination of existing legacy and processes and databases 3000 entities to determine content and granularity level required to accommodate the diverse and complex financial rules and requirements across secure external user views designed the first loan administration dimensional data model STAR schema central to other subject areas used ER-WIN data mart component to serve as the central meta BI data repository defined the staging area setup and the mapping structures

Confidential

• Project Manager- Full life cycle development of the enterprise-wide data model and EDM repository similar to MDM of today Defining, setting and
• documenting specific standards and procedures for information strategy and integrated planning of the organizational valuable business data
• Consolidating the existing disparate business area databases and other data sources into a detailed conceptual model by resolving previous data anomalies and lack of logical independence developed a three tier client server architecture to be implemented by my development DBA team The
• information architecture supported a distributed transaction processing environment multiple ORACLE RDBMS nodes with a single business rules validation layer.

Confidential

In charge of design of DOE data warehouse system Analysis and understanding of clients' analytical/BI and application systems issues and shaping of decision making systems Performance and tuning, specializing in VLDB Provided project time and cost estimation- detailed planning and direction Completed 2 advanced Oracle DBA, 2 data warehouse OLAP tools , Parallel Query operation, Server optimizer methods and Enterprise

Manager courses.

Confidential

• Data Architect/DBA specifying the physical organization, table layouts and tuning parameters to optimize the performance of distributed database systems C/S architecture -multiple Informix 7.1 engines on Windows NT
• 3.51 servers Implemented data replication for query load balancing and remote site backup for an automated secure entry system Developed standards on the maintenance and update of the highly integrated data processing environment Implemented online Informix DBA query tool.

Confidential

• Project manager responsible for the US order billing applications and
• database system defined the external user views, logical and physical
• level specifications and implementation of RDBMS
• Resolved requirements conflicts and performed data modeling to
• precisely represent the structures and entity relationships of the
• organizational model Installed and configured the database server
• Informix Online 7.1 engine on SPARC running SunOS 2.4
• Developed application interface routines ESQL/C 7.1 and shell
• scripts and coordinated the code development on the front end
• Studied the reporting needs of the billing department to implement a
• subject matter data mart to address the main decision support BI
• requirements and to define the meta data repository for future expanded
• data warehouse efforts Supervision and training of development team.

Confidential

• Conducted training seminars 3 weeks to software developers and
• DBAs on the architecture and administration of relational database
• management systems, focusing on Informix Online 6.0 and 7. 1
• database servers.

Confidential

• Architect- providing services on the design and development of
• database management systems in client/server environments Database
• administrator responsible for installation, performance study,
• trouble shooting and monitoring of multiple database servers Informix- Online
• 7.1 0 on Unix HP-UX 1 0.01 Created stored procedures to control access and
• improve query performance Built EIS a data mart architectural framework

Confidential

• DBA- installation and optimization of the Informix Online servers
• and I-Star client/server connectivity software's on Solaris 2.3 systems
• Incorporated true distributed database environment into the design
• API routines employing dynamic SQL allowing, for joining and
• updating information in several remote on-line database servers
• simultaneously Performing requirements analysis, logical and physical
• data modeling, E-R diagramming and implementation of the Oregon
• State Chemical Stockpile Emergency Preparedness Program automated
• system To serve as a shell for the future development. Created comprehensive remote site replication procedures ensuring
• accurate and efficient data replication controlled by the network process.