JOSEPH LOUREIRO

adc19g@r.postjobfree.com

QUALIFICATIONS

•Results-driven professional offering a progressive, twenty plus year career in information technology

•Data Architect with over 20 years of experience, able to deliver datamanagement vision,

goals, priorities, design principles, and operating policies in support of the business goals of the organization

•Experience using Oracle, Sybase, IBM DB2 MarkLogic, MongoDB and Neo4J & DB2

databases

•Enterprise data management & implementation; applying conceptual, logical, physical data models, XSD schemas, data flow diagrams, Metadata & data standards to support a robust data management infrastructure using Erwin & ER/Studio toolsets

•Solid experience translating business requirements into conceptual, logical, and physical

data models

•Vast experience with UML modeling for architecture, canonical modeling & XML modeling using MagicDraw & Sparks EA to name a few

•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 & maintenance

•Remarkable experience of data architecting best practices

•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, Power Designer and Visio

•Seasoned in data integration, data profiling and data cleansing methods & tools

•A wide knowledge of various architecture frameworks such as DODAF, TOGAF, Zachman & 4+1 Architectural View

•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 (ESB) using Oracle Service Bus (OSB) and Red Hat JBoss Fuse

•Expert level experience on canonical Industry models such as: NIEM, AIXM, ACORD,

OpenTravel and MISMO using MagicDraw a modeling tool for Canonical Modeling & Data as a Service Models (DAAS) using Model as a Service (MAAS) 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

US Courts

October 2018 – Present

•Responsible for Data Architecture/Modeling consulting services to the Data Governance Program under US Courts Judiciary Data & Analytics Office (JDAO), contributed & collaborated in a partnership with the Judicial Data Analytics Office (JDAO) a Client of the Data Governance Office delivering the following products; a Subject Area Model for five Program Areas, an Enterprise Data Model constituting of a Conceptual and Logical Data Models used ERWIN as standard data modeling tool for the department

•Produced a glossary of the terms out of the data models delivered

•The following domains were depicted; Warrant, District Court trial, Bankruptcy, Bankruptcy trials & Magistrate Judgeships to name a few

•I also introduced a Data Naming standard based on ISO 11179

Food & Drug Administration

October 2017 – September 2018

•Responsible for creating naming standards for XML/Json Schema Elements & Complex Types Naming Conventions based on ISO 11179 data naming standards

•Responsible for Modeling canonical data domains & services to describe the data types

and enumerations to classify & create control language (Vocabulary) that govern the Food & Drug domains

•Responsible for the creation of the following Office of Regulatory Agency domains; Firm

(Organization), Inspection, Assignment, Product, Import, Sampling, LIMS & Recall

•Developed Informational models using UML for the above domains utilizing Sparks Enterprise Architect; also developed service UML models from these domains based on the service defined from Integration requirements in JSON & XML formats

•Developed the Transformations of these UML services model to UML XSD model using UML

Profile to XSD based on a model driven environment

•Responsible for the generation of XML code from the UML XSD model to create the final artifacts that would be part of the integration scenarios

•Developed Data Mapping & data dictionaries for all the data sources that participated in

the Integration Scenarios in Excel

HHS CMS Health and Human Services Center for Medicare Services

May 2016 - September 2017

•Developed a Proof of Concept of architecting three models of provider master data information for evaluation of the best approach to capture all the provider characteristics and data provider lifecycle events for various CMS applications; these models were depicted one in a relational format and two NoSQL databases such as MongoDB & Redshift for suitability to meet various requirements

•Implemented Data Naming Standards and data description standards according to ISO

11179 to metadata artifacts to enhance collaboration and communication among various data formats

•Applied reference Healthcare data models, reference terminologies like (LOINC, CPT,

SNOMED, ICD-10), and data interchange standards such as HL7, FHIM & FHIR

•Applied Information Lifecycle Management (ILM) best practices to data identified in the Provider/ Prescriptions domain for classification, archiving & socializing using repository to manage data storage and its usage lifecycle

•Responsible for ensuring, integrating and building optimized ‘big data’ data pipelines for

accuracy loading into a data warehouse, NoSQL database or Hadoop data lake repository applying data preparation methods

•Responsible for prepare source to target mapping documents

Ginnie Mae

Data Architect for a Data Management project March 2015 - April 2016

Washington, DC

•Responsible for the process models to operationalize the Data Management Competency Center (DMCC) for Ginnie Mae

•Promoted Data Naming Conventions based on the MISMO Mortgage Canonical Model to

become the de facto language to use when describing objects that participated in data exchange internally & externally to Ginnie Mae

•Developed Use Cases, Object Models and sequence diagrams to depict some of the design of the application that would reflect MISMO 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 MISMO canonical language for inter and

intra messages to support Service Oriented Architectures (SOA) projects

CVS Health

October 2014 - February 2016

Lead Canonical Strategist & Service Architect Florham Park, NJ

•Strategized and developed a plan to identify major core data components for the

Pharmacy Benefit Management for CVS

•Identified these major core components (Vocabulary Building) for main domain of various line of business at CVS

•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 CVS 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 (ESB) 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 for JSON and XML data structures

•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, JSON and WSDLs

•Developed a Reference Data model to describe taxonomies used by various domains at CVS

•Prototyped RESTful web services using REST modeling features of Rational Software

Architect tool

Freddie Mac

February 2014 - September 2014 Solutions Architect

Mclean, VA

•Architected a Canonical Data Model Mapping & Domain Data Type validation application providing a loosely coupled web service data mapper of MISMO 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 (OSB) to support

Mapping of heterogeneous domain values as part of services to deploy Common Securitization Platform (CSP) initiative that aims to integrate Freddie Mac and the Common Securitization Solution (CSP) 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

HHS CMS Health and Human Services Center for Medicare Services

January 2013 - January 2014 Solutions Architect

Baltimore, MD

•Architect solutions designed and developed Canonical Service models using the Centers for Medicare and Medicaid Services (CMS) Information Exchange Model (CIEM) a collection of domain models using Magic Draw a UML Modeling tool

•Apply the National Information Exchange Model (NIEM) 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 (NIEM NDR) NIEM Naming and Design Rules (NDR) 1.3 standards

•Develop (IEPDs) 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 NIEM-

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) NIEM-conformant exchange packages, correctly utilizing existing NIEM

domains (especially NIEM Core) and including subset, extension, constraint, and exchange schemas

•Created XPATHs using XMLSpy and ConTesA for NIEM rules checking

•Developed data models for persistence objects to support Data Warehouse and OLTP applications using ER/Studio Data Architect 10.0.0

Department of State

July 2012 - December 2012 Oracle BPM 11G Architect Washington, DC

•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 and participate in 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

US Army, IPPS-A Project

January 2012 - July 2012

Master Data Management/Migration Architect Arlington, VA

•Data architect for IPPS-A program to develop and integrate a unified personnel records

and a payroll system to be utilized by the US Army 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

Department of Labor

June 2011 - December 2011 CRM Architect

Washington, DC

•As an Enterprise Architect assisted the Department of Labor (DOL) leadership formulates and executes a Customer Relationship Management (CRM) strategy as part of "Customer Service Modernization Program (CSMP), 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 Department of Labor (DOL's) Customer Service Program Office (CSPO) as per Department of Labor (DOL'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 DOL’s information material in a Content

Management System fashion using a Columnar Data store to house various information materials DOL maintains in its website as HTML and PDF files and utilized Solar an open source search engine to query the materials to satisfy stakeholders DOL related questions

•Developed Data Architecture using ERwin 8.1 for initial conceptual and logical models for

the design phase of the project based on the Canonical Party Data Model used by Seibel & Salesforce CRM applications

Department of Homeland Security DHS-USCIS

April 2010 - June 2011 Washington, DC SOA/Data Architect

•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/XSD) UML models and data mapping in support of the Service Contracts using UML Service Profile for SOA (UML2XSD) and the NIEM standard for Person Centric Query Systems (PCQS) messages using IEPDs adopted by DHS USCIS

Federal Aviation Administration January 2009 – March 2010 Washington, DC

SOA/Enterprise Architect

•Liaison to Senior Service-Oriented Architect on Federal Aviation Administration (FAA) SWIM project reporting to the FAA SWIM Technical Lead for SOA Governance and Enterprise Information Management (EIM) using SOA technology based on FUSE tool (Apache Open Source) including CXF Java Framework, Camel, and ActiveMQ

•Accomplished 100% of delivery goals and time tables for all assigned work products

•Technical leader for SWIM Governance team for delivery of all necessary work products for implementation of large-scale SOA

•Developed business case for the SOA COE, by delivering white papers, and presentations to

SWIM technical leaders for feedback and approval. Approved business case allowed staffing and scheduling for the SOA COE to be included in the SWIM project plan

•Defined and implemented the SOA Center of Excellence (COE) and services registry and

repository

•Co-led the creation and review of all SWIM Governance policies and standards

•Developed EIM plan for SOA-based information exchanges (Services) with other Federal customers leveraging NIEM models and AIXM Industry Models

•As a Lead Enterprise Architect provided FUSE ESB 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 EnRoute Automation Modernization (ERAM)

•Conducted and provided system requirement analysis and design artifacts such as WSDL and

XSD for business services creation

Veteran Affairs

January 2008 - December 2008 Sr. Data Strategist & Architect Washington, DC

•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

CareFirst, BlueCross BlueShield February 2007 - December 2007 Data & Business Process Architect Washington, DC

•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 CareFirst 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 CareFirst and documented in ERwin Model Manager to create a data dictionary for all entities/elements

American Red Cross January 2006 - January 2007 Data & Application Architect Washington, DC

•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 XSD 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 XSD and WSDL code based on

OMG model driven architecture approach via Rational Software Architect and HyperModel using UML Profile for XSD

•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

Fidelity National Finance

January 2005 - December 2005

XML Data Architect/Workflow Architect Jacksonville, FL

•Performed enterprise wide architecture and design for Enterprise Architecture

Integration (EAI) and Process integration solutions

•Created BPM models Using AquaLogic BPM to orchestrate the enterprise architecture that will deploy the code such as WSDLs and XSD code

•Participated in a requirements solicitation, requirements authoring, and system design

using RequisitePro, ClearCase, ClearQuest & Rational Software Architect

•The services developed via UML models that depicted the messages and generating xml schemas from the models (UML2XSD) profile

•Defined data formats and SOAP interfaces using XML Schema and WSDL using XMLspy

GEICO

Chevy Chase, MD

June 2004 - December 2004 Senior Data Architect

•Data Modeler using ERwin a data-modeling tool

Royal Caribbean Cruise Lines, Ltd. Miami, FL

June 2003 - May 2004

Senior Application/Data Architect

•Data Modeler using ER/Studio a data-modeling tool

Walt Disney Worlds

Orlando FL

June 2002 - June 2003

Senior Data/Application Architect

•Data Modeler using ERwin a data-modeling tool

DYNEGY

Houston, TX

March 2001 - June 2003 Senior Application Architect

•Data/Workflow/Modeler using ERwin a data-modeling tool and TIBCO InConcert a

workflow management tool

Vistakon

Jacksonville, FL

December 2000 - February 2001 Senior Data Architect

•Data Modeler using ER/Studio a data-modeling tool

Bellsouth

Atlanta, GA

June 2000 - November 2000 Senior Data Architect

•Data Modeler using ER/Studio a data-modeling tool

Database Technologies, Inc.

Miami, FL

August 1999 - June 2000 Senior Data Architect

•Data Modeler using ERwin a data-modeling tool

CSX

Jacksonville, FL

February 1999 - August 1999 Senior Data Architect

•Data Modeler using ER/Studio a data-modeling tool

Veterans Administration

Tampa, FL

September 1998 - February 1999 Senior Data Architect

•Data Modeler using ER/Studio a data-modeling tool

Merrill Lynch Credit Corp

New York, NY

March 1998 - September 1998

•Requirements Gathering Specialist/Senior Data Architect

US Clearing Corp/Quick & Reilly, Inc.

New York, NY

September 1997 to February 1998 Senior Data Administrator

•Data Modeler using ER/Studio a data-modeling tool

Bankers Trust

New York, NY

March 1997 - August 1997

Senior Business Analyst/Senior Data Modeler

•Data Modeler using ER/Studio a data-modeling tool

NBC

New York, NY

August 1996 - January 1997

•Requirements Specialist/Use Case Specialist

Ameritech

•Data Modeler using ER/Studio a data-modeling tool

Merrill Lynch

New York, NY

June 1995 - February 1996

•Senior Business Analyst

Philip Morris USA

New York NY

January 1,994 - May 1995

Senior Business Analyst/Modeler & Senior Functional Analyst

•A Use Cases and Object Modeler using OMT and Jacobson Use Cases

American International Group

New York, NY

May 1993 - December 1993 Data Architect/Business Analyst

•Data Modeler using ERwin a data-modeling tool

PROFESSIONAL DEVELOPMENT

Computer System Analysis degree, New York University, NY.

IgniteXML training from DigitalML in Organizer an OO repository and ICS for Canonical Service Modeling development

FuseESB training from FuseSource.

Fuse Message Broker (ActiveMQ) training from FuseSource. Fuse Mediation Router training from FuseSource.

Oracle BPM Suite 11g training from Oracle University.

Oracle SOA Suite 11g training from Oracle University. Data Governance training from Dataversity

Oracle Database training (various courses) from Oracle University. MarkLogic Fundamentals from MarkLogic University

Data Modeling with MongoDB from MongoDB University Introduction to Apache Cassandra from DataStax Academy Big Data Architecture Workshop from Cloudera University MetaStorm BPM tool Training from MetaStorm

TIBCO InConcert, TIBCO BPM & TIBCO Business Studio Modeler training from TIBCO Popkin Software System Architect training now called IBM Rational System Architect (UNICOM System Architect)

Contact this candidate