SUMMARY:

• 38+ years IT experience, with 25+ years as an independent IT / Business consultant.
• Healthcare, Telecommunications, Manufacturing, Retail, Mail Order, Wholesale distribution, Petroleum, Utilities, State Government Labor & Industries, Super Marketing, Mail Order, Construction Data, DoD Contractor (Army, Air Force, Joint Forces Command, National Geospatial Intelligence Agency)
• Developed and maintained Enterprise and project - level Data Models. IDEF1x modeling experience.
• Developed comprehensive Enterprise Data Architecture framework, incorporating MDM principles and practices based on data asset management Key Result Areas (KRA).
• CSOM modeling using IgniteXML ICS.
• Assisted in developing and maintaining a Universal Business Glossary comprising Business Capabilities, abstract Services & Operations, Business Objects/Terms, and mappings to legacy IT implementations.
• Conducted gap assessments of current Data Architecture environments, identifying goals and objectives; critical success factors (CSF) relative to the goals and objectives; as well as organization, process, roles, and data deficiencies; and corresponding improvement opportunities relative to business and data architecture goals and objectives.
• Facilitated JAD sessions using Agile methodology with business communities in developing As-Is and To-Be activity models and business rules. Performed gap analysis in identifying process-oriented and IT/Data-oriented deficiencies, and developed prioritized improvement opportunities.
• Developed an analytic process to identify problem space and corresponding decision questions, analytic tasks to identify the data and data structures necessary to feed decision-making, and identify the disparate legacy data sources.
• DBA responsible for IDMS/R & MODEL 204 DBMS Development and Production Environments. Designed logical and physical databases for Oracle, SQLServer DBMS platforms.
• Developed Data Base Administration Guide including policies, procedures, deliverables, roles, SDLC, etc.
• Lead solution/system architect responsible for developing data Masking & data sub-setting evaluation criteria, evaluation of Data Masking & Sub-setting vendor products through product demonstrations, selecting a single vendor for conducting an on-site Proof-of-Concept (POC) pilot, process modeling, defining services and role, resource requirements, implementation roadmaps, impact analysis, etc.
• Data Migration - Participated in data migration effort for FICO and also Oracle Financial Loan and Lease implementation - analyzed source and target databases/file structures and, facilitated JAD data mapping exercises.
• Worked closely with Agile Scrum Masters in meeting Sprint requirements and deadlines.
• Developed instruction guide/handbook for activity-based, business rule-driven, data-centered SDLC. Evaluated various client’s SDLC's in determining changes needed to in corporate enterprise data-driven concepts, principles and practices in developing and maintaining an enterprise-level data model and metadata repository and databases.
• Project Manager responsible for G/L, F/A, A/P, and Payroll, POS systems, and CICS maintenance.

TECHNICAL SUMMARY:

Data Modeling Methods & Semantics: Entity-Relationship (E/R) Data Modeling aka OLTP, utilizing E.F Codd data normalization rules, Dimensional Data Modeling (Data Warehousing) logical and physical Database design, OWL, RDF, IDEF1x, XMLSpy. Own a licensed copy of ERWIN Data Modeler.

Process Modeling Methods: Process Modeling (IDEF0) BPMN, etc.

Architecture Tools: ERWIN, BPWIN, Ignite ICS, Casewise Corporate Modeler, Metastorm Provision, Enterprise Elements, Data Designer, ADW/IEF, PM Workbench, MS Project, Rational Data Architect (RDA), Rational Software Architect (RSA), Rational ClearCase, TIBCO Business Studio, Enterprise Architect.

SDLC: Agile, Waterfall, Rapid Prototyping Data-Driven Methodology, Spectrum, Macroscope.

DBMS/File Management: ORACLE physical design, MS Access, IDMS/R, MODEL204, VSAM

Vendor Software Packages: Ignite, Cullinet MRP II, Arthur Anderson Inventory Control and Operations Management Systems (ICOMS), Informatics G/L, Data Design F/A, Argonaut AP/PR, POS Systems, IBM Optim Discovery & Designer, Oracle Financial Services Loan/Lease (OFSLL)

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Data Architect/Data Modeler

Responsibilities:

• Assisted in developing and maintaining a Universal Business Glossary (semantic model) comprising Business Capabilities, abstract and real Services & Operations, Business Objects/Terms, as well as mappings between them.
• Also mapped the Universal Business Glossary Objects and Terms to legacy IT implementations, in order to identify proliferation across the application portfolio.
• Facilitated data mapping effort to support data migration to Vendor products
• Performed data migration tool evaluation.
• Provided for architects and Systems Analysts in using Universal Business Glossary application.
• CSOM modeling using Ignite Service Design Platform.
• Developed and proposed Data Model naming conventions, Business Rule conventions and methods
• Worked with Agile Scrum Masters in meeting Sprint requirements and deadlines

Confidential, San Francisco, CA

Data Architect/Data Modeler

Responsibilities:

• Developed Data Architecture project plan including tasks, deliverables, and timelines for creation and implementation and ongoing sustainment of an enterprise MDM data model and physical database integrated physical database.
• Introduced data modeling standards and conventions that were adopted by WSI Enterprise Architecture.
• Developed Logical and Physical data models using ERwin for data conversion from Oracle RMS and other source systems to downstream target systems for Retail, Mail-Order, and Order Management Systems.
• Analyzed Business Requirements Document (BRD) and Functional Design documents (FDs) for Product, Pricing, Shipping, Ship Restrictions, and existing Oracle RMS database structures.
• Derived business rules from BRD and FDs for validation with business community SMEs and Business Analysts (BA).
• Worked with TIBCO MDM Architects in developing TIBCO MDM Repositories, and an enterprise Canonical Data Model.
• Worked with Agile Scrum Masters in meeting Sprint requirements and deadlines

Confidential, Durham, NC

Data Architect

Responsibilities:

• Analyzed databases from the following perspectives: business rules, application database navigation patterns, database volumes and transaction frequencies. Evaluated ETL performance of member eligibility reporting databases.
• Lead Systems Architect in data privacy (data masking), data discovery, and sub-setting initiative for Confidential North Carolina.
• Defined vendor evaluation criteria, evaluated vendor products and selected one for a Proof-of-Concept (POC) based on product demonstrations and analysis.
• Conducted on-site POC and Pilot for IBM OPTIM product suite for data discovery, sub-setting & masking.
• Developed a Data Privacy and Sub-Setting Services portfolio for Confidential .
• Developed comprehensive activity model. Performed Critical Success Factor (CSF) analysis in determining impacts and solutions in the following business areas: roles & resources, organization, policy & governance, process, IT infrastructure capacity,, and IT operations, and Application Development Lifecycle.
• Developed senior management PowerPoint presentations.
• Developed Prototyping, Pre-Service Consumption Preparation and Steady-State Service Proposal, Statements of Work (SOW) and implementation roadmaps. for Info sphere Discovery & OPTIM Sub-setting & Masking
• Co-Team lead in Service Virtualization, Configuration Management, and Test Data Management initiatives for Confidential .
• Worked closely with Agile Scrum Masters in meeting Sprint requirements and deadlines

Confidential, Rosslyn, VA

Data Architect

Responsibilities:

• Supported various Confidential Agency proposals and bids.
• Requested to be available for Confidential /CIO re-compete which was finally ed but was then postponed by the Confidential .
• Participated in reviewing BeInformed, a business rule-driven, dynamic application development too, and also received .
• Assisted in developing the Soldier-as-a-System (SaaS) architecture, including an assessment of current SaaS artifacts, and development of a System-of-Systems (SoSE) engineering-based process tailored to the PEO G-7 organization and functions.
• Tasked with briefly supporting Command & Control On-the-Move (C2-OTM) architecture development.

Confidential, Rosslyn, VA

Enterprise Data Architect

Responsibilities:

• Worked on architecture federation strategy to interface and integrate disparate architecture artifacts and data structures.
• Developed integrated analytic data structure (logical & physical) to satisfy dynamic decision-making needs.
• Supporting roles in the Army’s Enterprise Architecture (AEA) strategy, assisted in developing the Army’s Methodology for Enterprise Transformation (MET), and Enterprise Architecture process.
• Supporting the Secretary of the Air Force CIO (SAF/XC) Architecture Integration Project (AIP), in assessing current development strategy, and ensuring alignment with a capability-based/service-driven approach, and ensuring alignment with stakeholder business drivers and needs for timely, on-demand, decision-making. Developed an enterprise-level analytic data structure supporting stakeholder decision-making needs.
• Supported OASD/NII’s DoDAF 2.0 Data Technical Working Group’s Meta-model DM2 development.

Confidential, Crystal City, VA

Enterprise Data Architect

Responsibilities:

• Assisted with DARS mappings between FEA RMs and Confidential EA Models.
• Supported the Federated Joint Architecture Working Group effort as a sub-contractor to Lockheed Martin Information Technology Division (LMIT).
• Assisted with Portfolio Management Analytic Reporting, based on Confidential 8115.Developeddecision questions, analytic tasks and required analytic data sets, developer’s guide, and mappings to DoDAF Products/Views.
• Assisted with JCIDS Overlay development, based on CJCSI 3170 developing decision questions, analytic tasks and required analytic data sets, overlay developer’s guide, mappings to DoDAF Products, business rules, lexicon.

Confidential, Chantilly, VA

Enterprise/Data Architect

Responsibilities:

• Responsible for authoring & compilation from various authors, editing, configuration management, and distribution of draft and final release of the Confidential Process Guide.
• Short-term contract to assist Confidential Corporation prepare strategic information plan for development of a geospatial intelligence data model for the Japanese Defense Agency (JDA).
• Visited Japan with Confidential representatives to present the plan to a private sector consortium including (Matsushita/Hitachi) in Tokyo.

Confidential, Atlanta, GA

Enterprise Data Architect

Responsibilities:

• Independent consultant with Confidential to develop project-level and enterprise-level E/R Conceptual & Logical Canonical (CDM) data model and Business Rules. Validated Data model against functional specifications, use cases, business rules, and data access objects.
• Developed physical ORACLE integrated relational database, working across multiple organizations with a Technology Infrastructure and Application Architecture team
• Visited Confidential facilities in Scotland and France to assess Confidential enterprise architecture capabilities and gaps, participated in process modeling effort, and development of the enterprise-wide data model.
• Assisted developers with requirements analysis, functional specifications, and facilitated JAD sessions with business and IT participants.

Confidential, Ponca City, OK

Enterprise Data Architect

Responsibilities:

• Contracted with Oil industry client in developing an enterprise Canonical (CDM) data model, business rules.
• Developed physical ORACLE database, working with Corporate Data Architect in established Information Asset Management objectives, functions, policies, standards, procedures, roles, deliverables, and enabling technologies, data modeling methods, etc.
• Assisted developers with requirements analysis and functional specifications.
• Validated Data model against functional specifications, use cases, business rules.

Confidential, Atlanta, GA

Enterprise Data Architect

Responsibilities:

• Assisted in Object Oriented (OO) modeling, and aligning E/R and O/O models.
• Developed integrated physical Database design.
• Mapped Models to business rules, Use Cases, and User Interfaces to legacy data structures.
• Trained Client employees in Activity Modeling and Data Modeling methods.

Confidential, Seattle, WA

Enterprise Data Architect

Responsibilities:

• Independent consultant and then hired as Corporate Data Architect with Health Care Service Provider, responsible for consolidating and refined existing E/R Logical and Physical Data Models.
• Developed Dimension Data Modeling and physical database design, and development of enterprise-wide data architecture, policy, methodology, and modeling procedures
• Worked with Users and I.S. Application teams in developing Process models and Data Models, business rules, and User requirements.
• Developed business process models, business rules, E/R models, physical data base design for Eligibility and Subrogation.
• Developed and implemented 3-schema database and application for inventory control and configuration management & release of all Y2K-related hardware & application components.
• Independent consultant with Confidential and Shipping Industry client, working closely with business community and IT in developing process models, business rules, data models and databases.
• Developed detailed program specifications for off-shore coding of applications
• Identified process and data deficiencies, improvement opportunities, and user requirements, through Critical Success Factor (CSF) Analysis.
• Lead Analyst for Confidential 's Compensation System, including Eligibility processes, business rules, and requirements.
• Developed Process & Logical & Physical Data Models, facilitated JAD sessions with Users and IT.
• Developed Data-driven Development Methodology Phases, Activities, Tasks, deliverables, roles & responsibilities, and review process.
• Independent consultant with State Government Agency. Coordinated conversion & migration of Labor & Industries mainframe Production and Test Applications, JCL/Procs, libraries, etc., to new Test and Production environments on new mainframes.
• Worked with Application Project teams scheduling and performing migration between different hardware and operating environments, and performed Quality Assurance.
• Founded a light manufacturing and distribution company for a line of sporting goods products.
• Developed multiple product lines, pricing structure, out-sourced manufacturing and assembly, marketed products through various distribution channels including international sporting goods conventions.
• Implemented windows-based pc/MRP /Inventory /Accounting package, including the following integrated modules: Inventory, Bill of Materials, Purchasing, Sales, Address, Accounting (GL, A/P,A/R), Stock Room, Receiving, Work Orders, and Invoicing.
• Set up a dealer network, assembled, packaged and shipped product.