Data Warehouse Architect Resume Profile
Mclean, VA
Summary:
Over20 years in IT technical and management experience in Architecture, Policy Development, Business Process Re-engineering, Data Warehousing, Repository, Year 2000 Program Management, and Data and Process Modeling. Support Joint Staff J6 of DODAF V1.5 and 2.0 architectures for JCIDS reviews and developed policy. Experience in Enterprise, Solution, and Data Warehouse Architecture team management and task lead experience in developing and implementing software applications. Strength in creative problem solving, attention to detail to produce quality results, and ability to adapt to support customer's needs.
Data warehouse architect
Professional Experience
Confidential
- Providingarchitecture support, e.g., developed architecture views for JIE Increment 1 ICD and JS Cyberspace Operations Reference Architecture.
- For the JS Cyberspace Operations Reference Architecture, analyzed 17 existing architectures and capability requirements documents, crafting architecture data into a taxonomy and other architecture views for categorizing and analysis of cyberspace and network activities.
- Conduct architecture analysis and develop whitepapers for C4/Cyber Functional Capability Board, e.g., a comparison of the Marine Corps Cyberspace Operations architecture to previously approved cyberspace requirements and Leveraging Mission Area Architecture Information in DoD Processes whitepaper.
- Support Joint Staff J8 in JCIDS Manual revision embedding architecture requirements for all capability development.
- Conducting architecture assessments, as part of the JIE Architecture Working Group, to determine compliance with DoD IEA, DoDAF, FEA, and other applicable requirements and recommendations for appropriate action.
- Providingarchitecture technical support for developing and implementing guidance for the evolving Global Information Grid and JIE, e.g., architecture data requirements, architecture review processes, and DoD Directive and Instruction reviews. Develop and deliver architecture strategies, policy input, and doctrine positions recommendations, based on directed research and analysis. Coordinate with other mission area working groups with architecture and policy assessments.
- Analyzed existing guidance and oversight efforts, identifying a need for cross capability analysis. Outlined resource requirements and planned responsibilities for the Cross capability analysis and coordination activity activities include gap analysis and assessment, redundancy analysis, mission analysis, research support, day-to-day support for capability analysis for the FCBs developing architecture governance and cross-capability guidance.
ENTERPRISE ARCHITECT
Confidential
As AMC SEC support, collaborated with Army CIO/G6 as part of Information Technology Management Reform ITMR WG. Coordinated the development of products Architecture WBS, 3 Architecture work streams of the ITMR Implementation Plan, OV-1s for architecture portion of Information Technology Management Reform.
- Providedsubject matter expertise for Net Ready Key Performance Parameter, DoDAF V2.0, Architecture Federation Strategy, and Architecture policy experience.
ENTERPRISE ARCHITECT
Confidential
- Analyzed Joint Capability Integration Development System JCIDS , Information Support Plan ISP documents, and DoDAF architecture views for Interoperability Supportability or Net Ready Key Performance Parameter certification.
- Developed Joint Staff policy providing DoDAF V2.0, Architecture Federation Strategy, and Architecture policy experience. Authored Net-Ready Architecture Data Assessment Template and content architecture and interoperability for CJCSI 6212.01F, JCIDS Manual, CJCSI 6212 Resource and Net Ready Key Performance Parameter webpages, and DoD 4630 Directive and Instruction rewrite.
PROJECT MANAGER AND TECHNICAL LEAD
Confidential
- Coordinated the development, publication, and release of DoDAF V2.0and V1.5, with collaboration of various Components and COCOM organizations across DoD, including the DoDAF Core Management Group, and the three DoDAF Technical Working Groups Data, Method, and Presentation , in alignment with the FEA Consolidated Reference Models.
- Led DoDAF V2.0 Outreach and Socialization effort and the design and content management of the public DoDAF, DoDAF Journal, and DKO DoDAF websites.
- DevelopedGIG Architecture Federation Strategy, the Architecture Competency Framework, and co-drafted Architecture Federation Directive and Instruction now a draft instruction .
Confidential
Emergency Medical TechniciaN
- As part of Prince William County EMS with NVFDRS, administer first-aid treatment and life-support care to sick or injured persons in pre-hospital setting, assessing the nature and extent of illness or injury to establish and prioritize medical procedures.
Confidential
Enterprise Architect,
- Developed and defined the DoD's Business Mission Area BMA Net-Centric Strategy for data and services for a Service-Oriented Architecture, based on DoD's Net-Centric Data Strategy and OMB's Federal Enterprise Architecture Framework.
- Developed and definedthe BMA Net-Centric framework for Authoritative Data Sources, the BMA Net-Centric Implementation Plan to guide business enterprise service implementation, and the Service-Oriented Architecture SOA extensions for DODAF, and the BMA alignment strategy to the FEA Business Reference Model.
- Coordinated with DoD CIO and defined extensions for the DoD Discovery Metadata Specification.
- Developed and defined the BMA Federated Architecture Strategy and Roadmap.
Enterprise data Architect
- Delivered solution architecturesfor concurrent projects and BCP's Business Complex Programs in compliance and alignment with the Enterprise Information Architecture for integrated and interoperable solutions comprised of COTS, Open Source, and internally developed software.Created specifications based upon system configuration and user requirements and managed associated risks. Created and revised technical data architectures and designs for data warehouse, data marts, meta data strategy, internet and intranet environments based on requirements.
- Evaluated vendors, their data warehousing tools, solutions, and proposalsusing test metrics, measures, and criteria.
Data Warehouse Architect/Development Manager,
- Managed ETL Extract, Transformation, and Load and Hyperion Essbase Online Analytical Process OLAP teams in two locations. Provided operational guidance, mentoring, and employee development guidance.
- Redesigned the Financial Decision Support System of data marts, metadata strategy, and business intelligence systems, deployed interoperable solutions, and migrated data with as little disruption to business services as possible. Revised technical system architecture and maintained data architecture source data models, logical data models, dimensional models .
- Implemented and leveraged several processes ticketing system, requirements management, configuration control, implementation, and migration . Developed and implemented testing processes to reduce risk and ensure integration and interoperability during multiple conversions and updates to Oracle RDMS, ETL processes, and Hyperion Essbase cubes.
- Co-developed the Core Processes Data Architecture strategy for back office systems, which included integration of architectures for several data warehousing initiatives.
Data warehouse architect
- Led data architecture and warehouse requirements team and managed user, management, and marketing expectations. Evaluated vendors, their data warehousing tools, solutions, and proposals. Researched and tested COTS solutions with specialized benchmarks for new infrastructure.
- Worked with various groups development, hardware system engineering Windows and Unix environments , business planning, and marketing to develop, implement, and test toll free call detail data marts for customized reporting enabling additional revenue streams for MCI.
- Managed Risk Assessment QA Applications teams consisting of 18 Project Managers with additional administrative staff. Developed several processes Claimed compliant, Decommission, and Conversion for application to select and follow for Year 2000 preparation.
- Defined the evaluation processes and performed technology evaluations of Year 2000 COTS tools and vendors. Trained junior personnel for Year 2000 tool and vendor evaluations.
- corporate lexicon, and designed architecture plan and user guides for impact analysis.