We provide IT Staff Augmentation Services!

Enterprise Data Architect Resume

2.00/5 (Submit Your Rating)

OBJECTIVE:

  • Experience in software engineering and technology; experience in systems architecture and data architecture, in data warehouse and data migration from legacy systems to modernized systems, in Enterprise Information Management, Business Intelligence and Master Data Management and in portfolio, system and enterprise management.
  • Confidential has provided support and lead activities of engagement for the executive program office, the organization, and technical levels of the program for both commercial and government efforts.
  • He has provided oversight in development and management of the artifacts produced in support of Engineering, Data Management and Decision Support Systems providing an integrated approach to strategic planning and the identification of capabilities, system acquisition, program, and budgeting development.

TECHNICAL SKILLS

  • Oracle
  • Data Quality
  • Data Profiling
  • Data Migration
  • Operational Support
  • Blueprints
  • Data Mapping
  • Data Mining
  • Documentation
  • Data Modeling
  • Data Management
  • Metadata
  • Gap Analysis
  • Business Intelligence
  • Strategic Planning
  • Best Practices
  • Finance
  • Medicaid
  • Medicare
  • Data Visualization
  • Enterprise Architecture
  • Knowledge Management
  • Analytics Platform
  • Content Management System
  • Confidential
  • Data Analytics
  • Data Architecture
  • Data Cleansing
  • Data Governance
  • Data Sources
  • Enterprise Resource Planning
  • ERP
  • ETL
  • Master Data Management
  • MDM
  • Data Archiving
  • Data Conversion
  • Data Transformation
  • Database Modeling
  • Data Models
  • JDBC
  • MS SQL Server
  • SQL Server
  • Oracle 10g
  • PL/SQL
  • SQL
  • Dimensional Data
  • Rational
  • RE - Engineering
  • Requirements Analysis
  • SDLC
  • SEI
  • Systems Architecture
  • UML
  • USE Case
  • .Net
  • Visual Studio
  • B2B Software
  • Software Engineering
  • Magic
  • Python
  • Structured Software
  • Software Development
  • XML
  • Data Validation
  • Data Warehouse
  • Tableau Software
  • Tableau
  • Security
  • Data Structures
  • CMMI
  • Project Planning
  • RUP
  • Decision Support
  • Linux
  • Solaris
  • BI
  • Software Requirements
  • Technical Requirements
  • Governance
  • Staffing
  • Budgeting
  • Inventory
  • Procurement
  • Data Extraction
  • Collection
  • Translate
  • Business Requirements
  • Requirements Gathering
  • Damage Assessment
  • Organization Skills
  • Archiving
  • Quality Analysis
  • Active Confidential
  • MBE
  • Loader
  • Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Architect

Responsibilities:

  • Project supporting the Joint Technical Coordinating Group for Munitions Effectiveness (JTCG/ME) Battle Damage Assessment (BDA) Confidential Army Futures Command, Combat Simulation and Geospatial Analysis.
  • Responsible for the development of data management processes and standards for metadata management, data architecture, data quality and data security.
  • Additional duties include the design and implementation of an enterprise data warehouse which will consolidate classified data from various disparate data sources to support the geospatial analysis of strike data.
  • The data warehouse will be hosted in the Confidential Army Futures Command Unified Data Environment Microsoft Azure cloud.
  • Define the enterprise data architecture and the ETL architecture.
  • Develop DoDAF system models and data flow diagrams using Confidential (v19) to document the to - be environment.
  • Develop software requirements and supporting documents, data quality and data validation rules.
  • Develop data models using ERwin (2020r1).
  • Meet with Army personnel to discuss, ascertain and document project requirements, and to define data strategies.
  • Perform analysis functions to document data quality issues, define data quality and data transformation rules and develop recommendations.
  • Define data modeling and design standards, recommend tools, best practices, and related development for the enterprise data models.
  • Create the data structures, develop ETL, data quality validation and data cleansing procedure code.
  • Develop SSIS packages using Visual Studio for loading image file data and deploy the data warehouse using SQL Server .

Confidential

Chief Information Officer

Responsibilities:

  • Support the Confidential Joint Program Executive Office - Chemical and Biological Defense Joint Program Executive Office - Chief Information Officer's Knowledge Management team at the Confidential facility.
  • Provide expertise in the current principles and practices of data management strategies, data modeling, data analytics and data visualization in the information management space.
  • Provide guidance in organizing information to facilitate support of projects and information architectures, transition planning from legacy to modern systems concentrating on master data management, governance, and data quality and in the development of an enterprise data and analytics platform.
  • Support the Enterprise Architecture Governance and Enterprise Data initiatives, working with the CIO, Army staff and executive program level decision makers, responsible for the development of the enterprise data management strategy document.
  • Lead the identification and inventory of as-is systems and determine authoritative data sources and data flows.
  • Participate in the requirements elicitation process, in discussions and interviews, gather artifacts and documentation and develop the to-be enterprise conceptual, logical, and physical data models (DoDAF DIVs) using CA ERwin (v9.64).
  • Create DoDAF UML/SysML/BPMN models (OV2, OV-5a, b, OV-6c, SV1, SV2, SV4, etc.) using Magic Draw (18.5)
  • Participate in the development of product prototype evaluations; for data analytics and data visualization effort replicate custom-built application JDBC calls in Qlik and Tableau for comparison.
  • Participate proof-of-concept projects - data quality, cleansing and loading efforts using Python and Pandas, SQL Server (2014) and participate in the design of an enterprise data and analytics architecture exploiting services under MilCloud 2.0, and leveraging Microsoft Azure for Government products for managed service resources including cloud analytics, cloud BI, Azure SQL, Azure SQL Data Warehouse-as-a-Service.

Confidential

Enterprise Data Architect/Technical Lead

Responsibilities:

  • Integration, data migration and modernization project at the Pentagon for the Confidential, Foreign Military Sales, with additional work at Confidential Support Activity facility.
  • Define the strategy and roadmap for workflows, applications, BI analytics, enterprise data warehouse and future state reporting architectures to meet agency needs for strategic decision making.
  • Evaluate, develop, and identify specifications, best practices, develop strategy, planning and implementation deliverables and vendor services in support of a tri-service eCommerce ERP finance program.
  • Work with the Government to define the enterprise data management strategy, roadmap, and requirements.
  • Participate in the development of the master data management and data governance plan, and in the development of data migration, data conversion, data cleansing strategies and ETL rules.
  • Develop current and future state models, gap analyses, and transition planning, data mapping source-to-target attributes, document in Confidential the as-is system functions which will be retired through the implementation of the program, evaluate the to-be business and technical requirements and translate into specific solutions; structure, attributes and nomenclature of data elements.
  • Document the data, interfaces, and integration points for CISIL, MISIL, DIFS, DSAMS, and Navy SCIP Portal systems and develop DoDAF models utilizing the Confidential System Architect (v7.5.3) tool.

Confidential

Data Architect/Technical Lead

Responsibilities:

  • Confidential Clinical Standards and Quality, End Stage Renal Disease group, responsible for the design of logical and physical data models supporting as-is and to-be architecture in an Agile development environment.
  • Lead the development of new subject areas and deployment strategies to support a mission-centric legacy system Data Warehouse.
  • Responsible for efforts to sustain legacy system growth, performance ramifications and solutions, re-engineering of 3NF architecture to Star, XML/XSD schemas, development of dimensional models and ETL staging area models using CA ERwin (v7.3.9), the physical models were developed using Oracle 11g (v11.2).
  • Participate in Data Management group meetings, working with the teams to support and enhance the Master Data Management efforts - data quality analysis and assessment, data lineage, target metadata registry, metadata capture and management and conformance requirements development and to promote a shared foundation of common data definitions and to reduce data inconsistency where applicable to the data warehouse and business intelligence design efforts.
  • Additional participation includes SLA adherence documents for hardware and software deployment, NIEM compliance reporting, functional and non-functional requirements gathering and gap analysis between as-is and to-be architecture design requirements.

Confidential

Data Architect/Technical Lead

Responsibilities:

  • Responsible for the development of DoDAF system models, and Dimensional data models for the Data Warehouse effort, for team leadership and for providing operational support. Develop in conjunction with the client the conversion design blueprints used in identifying, extracting and in the movement of data across all data stores.
  • Responsible for leading the data rationalization efforts in mapping of source data - financial, vendor, contract, logistic, procurement and acquisition systemsextracting and moving data into test and development databases, operational data stores and data archiving silos and to continually improve the technical quality and stability of all the data extraction systems.
  • Assess data quality using the Oracle Data Quality and Oracle Data Profiling tools, Oracle Data Warehouse Builder (10.5) to build mappings for ETL layer, as well as develop SQL
  • Loader scripts and PL/SQL procedures and functions for implementation on Sun Solaris under the Linux operating system.
  • Conduct requirements elicitation Confidential groups, analysis and development of functional requirements documents, source to target data mapping and related documents.
  • Research, selection and implementation of data mining and data transformational analysis tools - Oracle Data Miner used in conjunction with other tools to migrate legacy systems data into an Oracle 10g database.
  • Map and extract data from source systems to target data stores, validate data loaded into the data stores, troubleshoot technical issues and support partners through the data cleansing process.

We'd love your feedback!