Data Architect Resume
SUMMARY:
- Results - driven professional offering a progressive, twenty plus year career in information technology.
- Data Architect with over 20 years of experience. Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
- Extensive hands on experience using Oracle, Sybase, IBM DB2 MarkLogic, MongoDB and Neo4J.
- Management and implementation of conceptual, logical & physical data models, data flow diagrams, Confidential schemas, data structures and data standards in support of a robust data management infrastructure.
- Solid experience translating business requirements into conceptual, logical, and physical data models.
- Implement best practices and methodologies in data analysis, design and modeling.
- Vast experience with UML modeling for architecture, canonical modeling & XML modeling.
- Management and development of an enterprise tailored taxonomy.
- Categorized internal and external data collections and ensure users find the information they need with speed and precision.
- Experience on Metadata definition, implementation and maintenance.
- Design standards for using normalized data structures, de-normalized structures, and dimensional structures. Defines common design patterns for modeling various types of relationships.
- Remarkable experience of data architecting activities
- Provide guidance and work leadership to less-experienced staff members.
- Excellent teamwork skills, good oral, written communication and presentation skills.
- Sound knowledge of data modeling tools such as; Erwin, ER/Studio, PowerDesigner and Visio
- Profound knowledge of best practices for data architectures
- Seasoned in data integration, data profiling and data cleansing methods & tools
- A wide knowledge of various architecture frameworks
- An extensive experience of database design and development
- A sound knowledge of Service Oriented Architecture (SOA) with experience applying Enterprise Integration Patterns (EIPs) to support integration solutions via an Enterprise Service bus ( Confidential ) using Oracle Service Bus ( Confidential ) and Red Hat JBoss Fuse.
- Expert level experience on canonical Industry models such as: Confidential, ACORD, OpenTravel and Confidential using MagicDraw a modeling tool for Canonical Modeling & Data as a Service Models (DAAS) using Model as a Service ( Confidential ) as a platform for data design.
- Wide knowledge & experience in Business Process Architect with expertise in various BPM tools and mastery of BPMN 2.0 and Use Cases techniques to depict As-Is Models & To-Be process models.
PROFESSIONAL EXPERIENCE:
Confidential
Data ArchitectResponsibilities:
- Developed a Proof of Concept of architecting three models of Provider Information for evaluation of the best approach to capture all the provider characteristics and data provider lifecycle events for various Confidential applications. These model were depicted one in a relational format and two NoSQL databases such as MongoDB & Redshift for suitability to meet various purposes.
- Implemented Data Naming Standards and data description standards according to ISO 11179 to metadata artifacts to enhance collaboration and communication among various data formats.
- Development of a data repository to store & support development of data artifacts to support various models.
- Applied Information Lifecycle Management (ILM) best practices to data identified in the Provider domain for classification, archiving & socializing via a repository to manage data storage and its usage lifecycle.
- Implemented Informatica Cloud; Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer strategy.
- Developed Informatica mappings and tuning of mappings for better performance for data Migration roadmaps.
Confidential
Data Architect, Washington, DC
Responsibilities:
- Responsible for the process models to operationalize the Data Management Competency Center ( Confidential ) for Confidential .
- Promoted Data Naming Conventions based on the Confidential Mortgage Canonical Model to become the de facto language to use when describing objects that participated in data exchange internally & externally to Confidential .
- Developed Use Cases, Object Models and sequence diagrams to depict some of the design of the application that would reflect Confidential base artifacts & elements to guide the daily operations of a true data management practice; applied MagicDraw to create the class diagrams and other UML artifacts.
- Refactored Exiting Data Architecture to reflect a Confidential canonical language for inter and intra messages to support Service Oriented Architectures (SOA) projects.
Confidential
Lead Canonical Strategist & Service Architect, Florham Park, New Jersey
Responsibilities:
- Strategized and developed a plan to identify major core data components for the Pharmacy Benefit Management for Confidential .
- Identified these major core components (Vocabulary Building) for main domain of various line of business at Confidential .
- Developed an approach to name Schema Elements & Complex Types Naming Conventions based on ISO 11179 data naming standards using Magic Draw to depict these artifacts creating Class diagrams of main business entities of Confidential Pharmacy Benefit Management (PBM) domain.
- Developed a Namespace Naming Standard for all the Domains and core components for data in motion for all major domains of the Enterprise Service Layer ( Confidential ) for accelerate service reuse.
- Developed All Core Components targeting XML and JSON data structures for APIs.
- Modeled canonical data & services to describe the data types and enumerations to classify and control language values that govern Healthcare Industry.
- Defined and created various data dictionaries (Semantics) with full definitions according to ISO 11179 standards for data definitions.
- All Services were created using IgniteXML to create XSDs and WSDLs.
- Developed a Reference Data model to describe taxonomies used by various domains at Confidential .
- Prototyped RESTful web services using REST modeling features of Rational Software Architect tool.
Confidential
Solutions Architect, Mclean, Virginia
Responsibilities:
- Architected a Canonical Data Model Mapping & Domain Data Type validation application providing a loosely coupled web service data mapper of Confidential Core Component/Elements using UML artifacts as a language to describe the architecture using Magic Draw.
- The application utilized Domain Value Maps from Oracle Service Bus ( Confidential ) to support Mapping of heterogeneous domain values as part of services to deploy Common Securitization Platform ( Confidential ) initiative that aims to integrate Confidential and the Common Securitization Solution ( Confidential ) application.
- Responsible for creating a Common Service Contract Template to design services.
- Responsible for implementation of a SOA Governance process for services design via a SOA Governance Policy/Process and Enforcement of a business process, this was designed in collaboration with Accenture Contractors.
Confidential
Solutions Architect, Baltimore, MD
Responsibilities:
- Architect solutions designed and developed Canonical Service models using the Centers for Medicare and Medicaid Services ( Confidential ) Information Exchange Model ( Confidential ) a collection of domain models using Magic Draw a UML Modeling tool.
- Apply the National Information Exchange Model ( Confidential ) standards to models created in house to support the development of (IEPD) Information Exchange Package Documentation
- Enforce data Governance on the elements in the data dictionaries created in support of the canonical models using ( Confidential NDR) Confidential Naming and Design Rules (NDR) 1.3 standards.
- Develop ( Confidential ) Information Exchange Package Documentation for (HIX) Health Insurance Exchanges for the following Domains: Marketplace, Federal Data Hub, HIOS, and MIDAS using the internal canonical models created to support (HIX) Health Information Exchanges.
- Architect & develop UML Class diagrams/to create IEPD using MagicDraw using a Confidential -UML plugin for the following services: Account Transfer, APTC, Verify Lawful Presence, Verify SSN, Annual Household Income, Verify Non ESI Minimum Essential Coverage (MEC), Verify ESI MEC, Remote Identity Proofing.
- Developed (MPD) Confidential -conformant exchange packages, correctly utilizing existing Confidential domains (especially Confidential Core) and including subset, extension, constraint, and exchange schemas.
- Created Confidential using XMLSpy and ConTesA for Confidential rules checking.
- Developed data models for persistence objects to support Data Warehouse and OLTP applications using ER/Studio Data Architect 10.0.0.
Confidential
Oracle BPM 11G Architect, Washington, DC
Responsibilities:
- Developed business process tasks, workflow tasks and control checks for various Business Process maps.
- Designed model of business processes and created automation technical designs.
- Analyzed processes with team members and automated designed business processes.
- Conducted detailed research and analysis of business requirements and suggested optimal solutions.
- Created architecture framework as per processes and standards.
- Formulated technical designs and functional designs for system integration.
- Evaluated service performance and modified SLA patterns to resolve operational issues.
- Reported SOA metrics and optimized automated business processes.
- Created Use Case Models to describe the main functions of the application for State Department Posts around the world using Rational Software architect.
- Developed data models using ER/Studio Data Architect 9.6 and created metadata to document core components/elements that participated in all business process and to provide Key Performance Indicators (KPI) as well as to create dimensional models for Analytics.
- Development of execution logic for all business process to automate processes based on business rule development and data integration points via (Service Identification).
- Conducted meeting with senior level stakeholders to depict as-is and later identified and also eliminated task that added no value and created task that added value in the to-be process models to describe the future application(s).
- Conducted meeting to also extract the Business Objects that a participate in end every tasks form the process models.
- Created Data Models for implementation from the Business Objects identified in the business process diagrams.
- Created User interfaces for each and every task from the use cases derived from the tasks out of the process models maps.
- Created Power point presentations to present the findings, status and direction of the application(s).
Confidential
Master Data management /Migration Architect, Arlington, Virginia
Responsibilities:
- Data architect for IPPS-A program to develop and integrate a unified personnel records and a payroll system to be utilized by the Confidential Active Component, Army Reserve, and National Guard. The system is designed to maintain all current personnel data and its retirees for 24 months. Information was designed to be retrievable through a Web Portal.
- Developed a process to identify the data sources, profile these sources for data quality issues engage the Data Owners/Stewards to correct the data issues and developed a data movement strategy to populate the PeopleSoft “Party” data model based on PeopleSoft functional business rules.
- Architected the application to integrate data from existing legacy personnel apps to the new integrated data via PeopleSoft Integration Broker.
- Worked on DataStage, Mapping Designs and Transformation. Developed mappings and also tuned data mappings for better performance.
- Tools applied were InfoSphere Master Data Management, InfoSphere Business Glossary, InfoSphere Metadata Workbench, InfoSphere Information Services Director & InfoSphere FastTrack.
Confidential
CRM Architect, Washington, DC
Responsibilities:
- As an Enterprise Architect assisted the Confidential leadership formulates and executes a Customer Relationship Management (CRM) strategy as part of "Customer Service Modernization Program ( Confidential ), requiring federal government departments to streamline service delivery and improve customer service capabilities to constituents.
- Supported a business case development with best practice CRM architecture to help setup the Confidential 's) Customer Service Program Office ( Confidential ) as per Confidential 's) Deputy Secretary's customer service transformation vision.
- Developed Business Architecture, Data Architecture and Technical Architecture in Troux to create a blueprint for Customer Relationship Management (CRM) application as a basis for procuring a Cloud based SAAS architecture.
- Developed a Knowledgebase Prototype of Confidential ’s information material in a Content Management System fashion using a Columnar Data store to house various information materials Confidential maintains in its website as HTML and PDF files and utilized Solr an open source search engine to query the materials to satisfy stakeholders Confidential related questions.
- Developed Data Architecture using ERwin 8.1 to depict initial conceptual data models and logical models for the design phase of the project based on the Canonical Party Data Model used by Seibel & Salesforce CRM applications.
Confidential, Washington, DC
SOA/Data Architect
Responsibilities:
- Designed and matured the Integrated Operating Environment (IOE) external interface and services layers of the SOA architecture including reconciliation against IOE requirements and use cases; modeling solution in UML and partitioning components; and documenting system specifications at a conceptual and logical level using Rational Software Architect (RSA).
- Developed an Electronic Records Management (ERM) architecture for paper form applications submitted.
- Developed a Service Oriented Architecture utilizing IBM’s SOMA methodology.
- Realized the services via modeling services contracts (WSDL/ Confidential ) UML models and data mapping in support of the Service Contracts using UML Service Profile for SOA (UML2XSD)and the Confidential standard for Person Centric Query Systems (PCQS) messages using Confidential adopted by Confidential .
Confidential, Washington, DC
SOA/Enterprise Architect
Responsibilities:
- Architected business services using a Service Oriented Architecture (SOA) for a stepwise migration to the Confidential (Next Generation Air Transportation System) for the FAA.
- The services architected required specialized expertise in Enterprise Integration Patterns (EAI) design, Enterprise Architecture and Data Architecture using ERwin 7.0.
- As a Lead Enterprise Architect provided FUSE Confidential technical expertise during the project lifecycle, evaluating design capabilities and COTS products compatibility on the following key FAA modernization efforts; Traffic Flow Management - Modernization (TFM-M) and En Route Automation Modernization (ERAM).
- Conducted and provided system requirement analysis and design artifacts such as WSDL and Confidential for business services creation.
Confidential
Sr. Data Strategist & Architect, Washington, DC
Responsibilities:
- Development of various Data Management initiatives at the VA; which consisted of Data Architecture, Data Master Data Management and Meta-Data Management, Data Governance and Data Stewardship Programs. For an Enterprise Data Management Roadmap.
- Planned & developed an Enterprise Information Integration (EII) data service design to provide information that resides in various data sources in a SOA environment.
- Developed a Business Process for an MDM project using Siperian MDM
- Developed a Canonical Model for Veteran/Soldier using Party Pattern data model using ER/Studio.
- Promoted a Meta-Data Program initiative for the roadmap.
Confidential
Data & Business Process Architect, Washington, DC
Responsibilities:
- Participated in the Data Architecture side of the Enrollment process also developed as Business Process map for the emerging Service Oriented Architecture (SOA) and the Data Architecture models using ERwin a data modeling tool to describe the OLTP & OLAP entities to support application and Analytics for Confidential a BlueCross Blue Shield company
- Developed Business Process and Data Flows diagrams to identify sources of data that participates in the orchestration of the following process; HIPAA 834 Benefit Enrollment, 820 Premium Payment & 837 Encounters transactions using MetaStorm BPM.
- Identified sourcing of data elements that are required to create all system interfaces (Data Services) in the enrollment process at Confidential and documented in ERwin Model Manager to create a data dictionary for all entities/elements.
Confidential
Data & Application Architect, Washington, DC
Responsibilities:
- Architecture, designed As-Is & To-Be Process Models utilizing BPMN notation to depict various business process models for various Business area using Appian BPM
- Lead, designed a canonical model to aggregate data from eight different legacy systems to provide a single view of “Donor” to the business process developed.
- Modeled and deployed Confidential class diagrams using Rational Software Architect to describe the request/reply Services Scenarios of the To- Be Business Process.
- Designed an Orchestrated business process model out the To-Be architecture (BPMN) to run the environment designed in (BPEL).
- Architecture, designed class diagrams to transform into Confidential and WSDL code based on OMG model driven architecture approach via Rational Software Architect and HyperModel using UML Profile for Confidential .
- Architected various Master Data Management architecture(s) to provide single views of various common business objects using ER/Studio to provide data to the operational applications and business intelligence applications.