Enterprise Data Architect

Enterprise Architecture, Enterprise Data Architecture, Data Management, Master Data Management, Systems Engineering, COTS ERP Data Migration, Data Warehousing/Business Intelligence

EXPERIENCE SUMMARY:

Over 20 plus years' experience in Information Technology, 15 years Systems Engineering, 15 years Enterprise Data Architecture and Data Management, 12 years Data Warehousing, 10 years Enterprise Architecture, 7 years System of Systems Engineering, 5 years COTS EPR Data Migration, and 5 years Master Data Management.

Experience includes enterprise strategy, methodology, governance, processes, planning, analysis/ design, development and execution. Experience also includes enterprise/program Federal Enterprise Architecture Framework FEAF /DoD Enterprise Architecture Framework DoDAF alignment, IT portfolio management, and systems engineering and integration. Extensive experience on large DoD/Military Joint Service, Federal Government Agency and cross-functional integration projects as LSI, M I and SETA on both classified and unclassified projects. Strong expertise applying industry best practice methods and sound enterprise architecture, data architecture/ management, and integration techniques across functional domains to include Combat/Operational, HR/personnel, organization, force structure, manpower, finance/budgeting, pay, installation/ facilities, logistics, training, readiness, grants management, law enforcement, security and telecommunications.

• Enterprise Data Architecture and Data Management establishing and utilizing Enterprise Data/Information Architectures and Data Management that are FEAF/DoDAF aligned. Experience includes DoD Net Centric Data Strategy and Service Oriented Architecture SOA based enterprise Information Architectures. Extensive experience utilizing and extending standard information exchange models JC3IEDM/C2IEDM/NIEM . Focus establishing Enterprise Technical Reference Data Layer Architecture including enterprise data modeling, data governance, standards, reuse, strategic data asset management, data quality, data security, metadata management and integration, repository architecture, and data life cycle. Data Modeling includes UML, IDEF1X, and ERDs.
• Systems Engineering includes over 15 years on large Federal and DoD Systems Engineering and Technical Assistance SETA , Lead System Integrator LSI , Management and Integration M I , and systems integration contracts producing and performing DoD 5000 and related milestone deliverables. Experience includes development of program Systems Engineering Master Plan SEMP and Software Development Plan SDP including alignment with Life Cycle milestones and deliverables. Responsible for IMS with EVMS management and reporting to stakeholders during Concept Refinement and System Development and Demonstration SDD phases, development of specifications, coordination and monitoring of supplier activities, and integrated product teams IPTs . Completed Systems Engineering Certificate Program with the Systems and Software Consortium in 2008.
• Enterprise Architecture includes defining and implementing enterprise technical architectures, as well as, alignment and compliance with FEAF/DoDAF/Zachman. Includes modeling of enterprise architectures, using Rational Rose, System Architect and ER/Studio following industry best practice methodologies including Rational's Unified Modeling Language and UML , Systems Analysis/System Design SASD and others. Techniques include using views to manage integration, enterprise/ system assets and infrastructure requirements.
• Master Data Management includes establishment of enterprise governance and processes, technical instantiation, and standard operating procedures. Framework included the technical reference architecture established authoritative ownership, data model management, and an integrated enterprise data dictionary. Technical implementation included replication of enterprise reuse data to distributed Master Data stores that support SOA data services, standard application interfaces for external boundary data, and data warehousing. Led Data working Group to ensure and support compliance.
• Data Warehousing includes architecture, tool/component integration, and life cycle management with strong emphasis on methodology, processes, product interchangeability, and data reuse. Experience includes component architecture, data design and modeling relational and multi-dimensional , ETL, data cleansing, data integration, data mart/ analytics infrastructure and design, and metadata integration.
• COTS EPR Data Migration includes legacy analysis, fit/gap analysis, enterprise data modeling, logical and physical transform mappings, interfaces, data cleansing, data conversion, ERP data loading, interface migration, and metadata integration. Consulting expertise includes migration strategy and planning, software and process infrastructure, and technical execution. Strong focus on sound methodology and practices which are tool, product, and COTS ERP independent that emphasize repeatability, predictability, improveabilty and metrics.

CHRONOLOGICAL WORK EXPERIENCE:

Chief Technology Office CTO , Sr. Data Warehouse Architect

Confidential

Lead Enterprise Data Architect brought in to setup a new data architecture team to establish best practice enterprise data/information architecture, establish processes and governance while implementing and aligning with Department of State directives to improve data quality, data sharing and data access. Also, lead data architecture team to execute and manage data modeling for projects.

• Established Enterprise Data Architecture that included enterprise and system data models and data dictionaries, reusable enterprise domains and common objects, standard terms and abbreviations, and framework for Master Data.
• Developed Data Management Life Cycle DMLC that provided processes and governance integrating data activities across the development life cycle, across projects and technologies e.g. applications/services, interfaces/ data exchanges, databases/ data stores, reporting/ analytics , collecting standardized metadata, and reverse engineering physical and logical models, mapping nonstandard data to standards, and capturing data lineage. DMLC provided model driven development.
• Led organizations investment and implementation of IBM's InfoSphere Suite that enable continuous integration across the data lifecycle with its shared Metadata Repository. The implemented InfoSphere Suite included Data Architect, Business Glossary, FastTrack, Data Stage, Information Analyzer, and Metadata Repository.
• Established Data Quality Improvement framework that included both data naming semantics and data value quality.
• Provided data architecture support to projects that included data requirements, source-to-target mapping for data movement and data standardization linkage, logical and physical data modeling, and data architecture artifacts configuration management. Support provided for agile and standard waterfall projects.

Technical Environment: Oracle RDBMS, Subversion, IBM InfoSphere Suite Data Architect, Business Glossary, FastTrack, DataStage, Information Analyzer , Windows, XSD/XML, SQL, DDL/DML.

Technical Initiative Team

Confidential

Provide Systems Analysis, Systems Architecture and Engineering activities for the Technical Initiation Team on the Advanced Information Technology Services AITS contract supporting the Project Directorate PD Reserve Component Automation System RCAS and Information Management System IMS systems.

• Develop and troubleshoot interfaces from Engineering Change Proposals ECP through design, development, integration and validation testing, acceptance testing support, and all specification materials. Interfaces include external and internal systems and organizations implemented in a wide range of methods including web services, ETL, FTP, and replication to synchronize distributed databases.
• Provide support, development, configuration, and test support for Oracle Data Integrator ODI interfaces with DMDC-DEERS and Tour of Duty.
• Provide analysis supporting the SSN Reduction RCAS Engineering Change Proposal ECP . The analysis involves the replacement of SSN exposure with Electronic Data Interchange-Person Identifier EDIPI within RCAS applications, database and interfaces.
• Develop training materials for the ASO Wallet Management Approach implementation supporting PII Encryption.
• Responsible for development of contract Systems Engineering Master Plan SEMP and Software Development Plan SDP .

Enterprise Architecture Team

Provide Strategy, Planning and Execution of NSF Enterprise Data Architecture practices supporting Agency modernization, migration to Research.gov including compliance with Federal Enterprise Architecture and Framework FEA and FEAF , Grants Management Line of Business GMLoB and Financial Management Line of Business FMLoB . As NSF Enterprise Data Architect on the Enterprise Architecture team providing establishment of the Technical Reference Architecture Data Layer which includes Service Oriented Architecture SOA , project compliance reviews and recommendations.

Specific initiatives include:

• Developed Data Layer segment of the NSF Technical Reference Architecture establishing and implementing guidance, processes and components to include Information Architecture, Enterprise Reporting and Data Warehousing Architecture, Master Data Management Architecture, and SOA Data Services. Including developing the strategic approach white papers, Technical Proposals, and prototypes.
• Established the Component Architecture, governance, methods/processes and component architecture for Enterprises Reporting Data Warehousing and Business Intelligence . This architecture integrated best industry practices from Enterprise Master Data Management MDM , Enterprise Data Warehousing, ETL and Analytics/Business Intelligence.
• Established The MDM Framework included a technical reference architecture established authoritative ownership, data model management, and an integrated enterprise data dictionary. Technical implementation included replication of enterprise reuse data to distributed Master Data stores that support SOA data services, standard application interfaces for external boundary data, and data warehousing.
• Established organizations initial Enterprise Data Warehousing framework which included ETL providing the transformation, integration and loading primarily SAS of authoritative source data into multi-dimensional star schema populating the Data Warehouse. Oracle OBIEE serves as the primary analytics component. Provided Technical Proposal and prototype support for the Dashboard project.
• Established the methods/processes and component architecture for the Data Layer elements of Enterprise Data Services. Providing reference and read-only data includes data sourcing from the Enterprise Master Source Data and standardization and optimization the Data Access Layer for reuse and performance. Provided the Technical Proposal and prototype support for the FAS Service Enablement prototype.
• Currently proposing data replication for Enterprise Master Source Data to establish a near real-time Operational Data Store supporting both Data Warehousing and Data Services.
• Developing NSF Standard Operating Procedures, processes and implementation of standard Enterprise and Project data modeling.

Technical Environment: Oracle RDBMS, Sybase ASE and Replication Server, Embarcadero ER/Studio Data Architect, ERWin, OBIEE, PLSQL, SAS, XSD/XML, SQL, DDL, DML, Sax BASIC scripting.

Additional company level duties include Business Unit proposal and business development support as needed. Supported efforts include NETCENTS II metadata strategy, which include DoD Net Centric Data Strategy NCES, DDMS, and DoD Metadata Registry services , and ITES-2 RIA-JMTC Application Support. Work included development of Enterprise Single Sign-on Trade Study supporting AKO/DKO business development product evaluation.Served as Chief Data Architect for the Lead System Integrator LSI for the U.S. Army Future Combat System FCS Program providing direct management and technical lead of integration activities for the System-of-Systems Engineering and Integration SSEI Data Architecture Team during System Development and Demonstration SDD phase.

The FCS Chief Data Architect CDA responsibilities include:

• Program focus was utilizing DoD directed standard information exchange model JC3IEDM/C2IEDM to support system of systems interfaces.
• Develop processes and metrics to gather and analyze data from internal and external sources to monitor, status, and manage program progress to include schedule, performance, financial, and risk while meeting the overall FCS program objectives and compliance with Department of Defense DoD and U.S. Army directives.
• Responsibilities also included coordinating and leading Integrated Product Team IPTs , providing FCS Program, DoD/Joint, and Army briefings and collaboration, and delivery of DoD 5000 System Development and Demonstration SDD phase SoS and System/Integrated Platform architecture DoDAF complaint products and deliverables.
• Managed data modeling and data integration activities performed by the System-of-Systems Engineering and Integration SSEI Data Architecture Team in the Development and Maintenance of the Brigade Combat Team information Model BCTIM within the funding and schedule constraints of the FCS program.
• Position required US Army combat arms and general US Army domain and operational understanding/ experience, and DoD Net-Centric architecture.
• DoDAF products to included architecture driven OV-7, SoS SV-6, SV-11, traceability to OV-3 IERs and AV-2 Information Architecture dictionary. Related deliverables include engineering thread SV-6s to support IV V and LSI based Interface Requirements Specifications IRS generated from the System of Systems Integrated Architecture.
• Documented the BCT Integrated Logical Data Model OV-7 in conformance with DODAF in a model using UML and CADM conformant tools, and communicate the overall Information Architecture to vested parties.
• Analyzed candidate architectures performed reviews of SoS and Systems architecture products meet with LSI partners and US Army overseeing implementation of the architecture within the FCS design approach, coordinating FCS Integrated Platform architectures to ensure consistency with SoS Architecture/model products.
• Addition responsibilities included: facilitating and coordinating consistent two way flow of architecture impacts/considerations ensuring horizontal integration of SoS and Integrated Platform data artifacts conducting SOS technical requirements and design reviews defining SoS and Integrated Platform integration strategy and detail plans driving alignment with DoD Net Centric Strategy, KPP decomposition, allocation, and traceability to FCS design supporting spiral development and technology planning.
• Socialized, promote and ensure an appropriate level of consistency of approach for FCS Information Architecture processes and products across program.
• Provided analysis and guidance for the identification, selection, and compliance with Army, DoD, and Joint information architectures, data exchange standards, data definitions, reference or standard data models, and data management plans, policies, and strategies. Ensured SoS-to-Integrated Platform Architecture perspective/view disconnects were identified and resolved.
• Provided program IMS and EVMS development and reporting as LSI Chief Data Architect to include coordination of numerous suppliers.

Technical Skills: Project management Systems Engineering Data Architecture EVM, UML IDEF1X Rational Rose System Architect DODAF and DoD/Army standards service oriented architectures SOA spiral software development and object-oriented OO design concepts.

LTS Corporation

Responsibilities include architecture and integration primarily in the areas of interfaces, data architecture, data migration, and software components. Delivery and oversight has also included system design, development of metadata repository, methodology integration, enterprise architecture compliance, data conversion/ migration, and deployment issues. Additional areas of focus have been data modeling, PeopleSoft EPM and existing EDW data warehouse integration, and security/SSAA support. Utilized UML for enterprise architecture/DoDAF models and ERWin for data models.TFARS formerly Total Force Manpower Management Program TFMMP is the first major increment of the Sea Warrior/N1 Migration effort, which is a component of the Navy's Task Force Warrior initiative. The Sea Warrior/N1 Migration project integrates the Navy's business systems into a COTS ERP PeopleSoft environment. TFMMP functionality includes manpower, distribution, position management and budgeting.

Technical Environment: PeopleSoft HCM and EPM , PeopleTools, PeopleCode, ERWin, Saphir PeopleSoft option , Ascential Data Stage, Solaris/Unix, Windows, Sun Servers, Oracle, PL/SQL, SQL, PVCS, Rational Suite Requisite Pro, ClearQuest, Rational Rose , UML, Integration Management Suite, Toad, ASP, JavaScript, and Business Objects.

• Serve as company's Chief Engineer with primary responsibilities of contract technical oversight, consulting support to project leads, technical staff management, and client relations. Provide strategic, planning, methodology and execution level consulting for information management, data administration, data warehousing, systems architecture, systems/ software engineering, data engineering, data management, systems and data integration, and COTS ERP data migration solutions. Responsibilities also include contract project management, technical support for business development, execution oversight, and IT technical support to the CEO and company.
• Provided data architecture, data migration strategy, data management and relational database technical architecture, and data/interface requirements integration. Responsibilities also included methodology management, systems engineering/ architecture and associated DoD 5000 Series Milestone deliverables.
• DIMHRS project integrates the Military Services Army, Navy, Air Force, and Marine personnel and DFAS pay systems into a COTS ERP PeopleSoft web based enterprise architecture. DIMHRS an ACAT1 program has been assessed by the Defense Science Board as DoD's largest software project ever undertaken. The system replaces over eighty 80 legacy systems with several hundred interfaces. All systems requirements captured and maintained in Rational Rose.

Technical Environment: Rational Suite Requisite Pro, ClearQuest, Rational Rose , UML, PeopleSoft, PeopleTools, ERWin, Solaris/Unix, Windows, Sun Servers, Oracle, PL/SQL, SQL, PVCS.

Sr. Data Warehouse Architect

Lead Data Warehouse Architect for System Engineering and Technical Architecture Team supporting the DIMHRS Personnel and Pay Pers/Pay program. Responsible for integration support and DoD 5000 Milestone approval deliverables.

• Developed Data Warehousing, OLAP and data management areas of the Enterprise Architecture Proof of Concept EA POC . Included software component and processes for data acquisition and extraction, data cleansing, ETL, data warehouse, data mart, data delivery, metadata management, and RDBMS services.
• Presented EA POC data warehousing/analytical sections to the Joint Technical Integration Group TIG , which included technical representatives from the Army, Navy, Air Force, Marines, DFAS, and JR IO.
• Developed data warehousing/analytical systems engineering processes and tailoring of Product Line Engineering practices.
• Responsible for data warehousing/analytical task planning for DIMHRS Master Integrated Schedule.
• Conducted software/tool evaluations and trade studies. Defined evaluation process and criteria.
• Provided support in development of Systems Engineering Plan, Management Plan, and numerous program and DoD 5000 documentation deliverables.

Sr. Data Warehousing Architect

Served as Data Warehousing Architect co-lead to develop an enterprise-wide conceptual data warehouse architecture and project plan for development of a proof of concept prototype/pilot. The architecture included integration of the Navy's manpower and personnel systems providing integration, analytical, and knowledge management capabilities.

• Developed conceptual architecture for the enterprise-wide data warehouse and prototype/pilot plan.
• Presented conceptual architecture to the Navy's Technical Integration Group TIG .
• Facilitated data requirements sessions with functional representatives.
• Developed and conducted proof of concept demonstrations.
• Delivered product evaluations for OLAP and ETL tools.
• Utilized ERWin for data modeling.
• Developed proof of concept included standing up ETL, a departmental data warehouse, and data marts.
• Installed and configured Oracle7.3 database and COGNOS Impromptu/ PowerPlay.
• Delivered Data Warehousing/OLAP Strategy and Preliminary Architecture. The project's purpose was to provide increased analytical multi-dimensional and forecasting capabilities for special program requirement procurement tracking, weapon system/foreign weapon system procurement, and strategic marketing intelligence.
• Conducted product/tool evaluations and trade studies and delivered purchase recommendations.
• Delivered hardware/infrastructure requirements.
• Delivered architecture included data acquisition, data warehousing, analytical and decision support, data integration and transformation, and metadata management components.
• Delivered proof of concept architecture and project implementation plan.
• Led US Army CIO ASC/AIC Data Team providing data engineering support for knowledge-based and simulation/ scenario modeling, data integration, decision support/ data analysis, and data quality initiatives throughout the Headquarters Department of Army HQDA . Supported organizations mission to provide technology insertion, research and development, and innovative data strategies and integration solutions to the HQDA, as well as to promote, support, and evolve existing data management and standardization guidance and initiatives.
• Provided data strategy, data architecture, system design, component integration, methodology/ process development and overall project technical management. Heavily utilized data acquisition, ETL, data cleansing, data modeling relational and multidimensional , metadata management, and data mapping while delivering data warehousing, data analysis/OLAP, data quality and data integration solutions.
• Supported functional areas that included force structure management and planning, mobilization, operations, manpower, training, personnel, logistics, installations, and budgeting. Clients included Secretary of the Army, US Army Headquarters Staff, Office of the Deputy Chief of Staff for Operations ODCOPS , Office of the Deputy Chief of Staff for Personnel ODCPER , Office of the Deputy Chief of Staff for Logistics ODCLOG , Defense Financial Accounting Service DFAS , Defense Information Systems Agency DISA , US Army Information Management Center IMCEN , US Army Personnel Command PERSCOM , US Army Forces Command FORCOM , Logistics Support Agency LOGSA , and numerous of other agencies.

Technical Environment: Oracle RDBMS, DB2, Solaris, Unix, SPARC 2000, IBM Mainframes, Windows/NT, SQL FORMS 4.5, SQL PLUS, PL/SQL, SQL, Data Junction, SQL Loader, Oracle CASE, ModelMart, ERWin, BPWin, COGNOS Impromptu/PowerPlay, Business Objects, BRIO.