Data Architect Resume
Memphis, TN
QUALIFICATIONS:
Application DBA, Applications Programmer, Data Architect, Data Branch Manager, Data Warehouse Designer, Enterprise MDM initiative, Enterprise Information Management, Enterprise Systems/Data Architect, Public and Private Sectors INSTRUCTOR:( Intro to Enterprise Frameworks (DAMA, Zachman, TOGAF), Intro to Business Process Modeling, Intro to BPM Notation, Intro to Structured Systems Design and Analysis (De Marco), Intro to Data Analysis and Design Concep ts, and Principles. Applied Data Analysis, Applied Data Mapping, Intro to Data Transformations, Intro to UML), Project Manager, Quality Assurance/ & Testing, Structured Systems Analyst,
37+ years experience with Database Technologies (Cassandra, DB2, Data Movement Tools (Ab Initio), Data Modeling Tools (AIIFusion, CA Erwin Workgrp Edition, PostgreSQL, PowerDesigner, Embarcadero, Visio), Business Intelligence Tools (Business Objects, SAS), Ne twork Infrastructure, Design and Security, Data Modeling Fundamentals and Concepts 1st 6 th NF Relational, Anchor, and Dimensional (STAR and Snowflake), Inmon & Kimball Methods
CURRENT POSITION: DataArchitect, CIO and Manager with DataUSA of Memphis, Memphis,TN from April2013 to Present:
Overseeing day to day operations of firm:
- Sales
- Consulting
- En t erprise MDM initiative
- Enterprise Information Ma n ageme n t
- Enterprise Data Architect deve l oping Multi level Marketing for Home Fash i on Industry startup
- Data Modeli n g Concepts 1st 3 rd NF
- Dimensiona l (STAR and Snowflake) Schema
- DAMA, DODAF, TOGAF, and Zachman Frameworks
- Inmon & Kimball Methodologies
WORK HISTORY:
Enterprise Information/Data Architect,
Confidential
Technical Author
Confidential, performed as one of three highly regarded Technical Analysts and Authors supporting the design of the Department of Navy s future Integrated Personnel and Pay Systems (IPPS/N). Each of the three gentlemen was selected as a World Class level expert assigned to cover specific Subject Areas. Confidential was selected to author volumes covering Scalability, Capacity, and Performance, as well as, the extremely dynamic area of Governance and Roles. The analysis and design was performed in order that each gentleman could author the initial volumes foundational for all future technical direction regarding DON Personnel and Pay capabilities for Manpower, Personnel, Training and Education (MPTE) Performance and Governance Strategies.
Enterprise Information/Data Architect,
Confidential
Enterprise Information/Data Architect Consultation
Provides DAMA Framework compliant Data Management Services and Data Architecture deve l opment and consultation in support of the Authoritative Data Warehouse (ADW) project.Provides support in the daily data management activities as follows: Data Governance planning, oversight and control over management and use of data assets Data Architecture Management as an integral part of the enterprise architecture Data Development analysis, design, building, testing, deployment and maintenance Database Operations Management support for structured physical data assets Data Security Management ensuring privacy, confidentiality and appropriate access Reference & Master Data Management managing Golden versions and replicas Data Warehousing & Business Intelligence Management enabling access to decision support data for reporting and analysis Document & Content Management storing, protecting, indexing and enabling access to data found in unstructured sources (electronic files and physical records) Meta Data Management integrating, controlling and delivering meta data Data Quality Management defining, monitoring and improving quality of data assets. Designs highly complex Relational, Dimensional, and Data Vault IT data structures for Conceptual, Logical, and Physical data models.Ensures systems operate at peak performance Troubleshoots software issues and makes recommendations for upgrades Develops instructions for integration projects.
Enterprise Information/Data Architect,
Confidential
TASK MANAGER
Provides DAMA Framework compliant Data Management Services and Data Architecture deve l opment in support of Enterprise Information Management (E l M) Concept of Operations (CONOPS), Manpower, Personnel, Training and Education ( MPTE) Data Management Strategy, a n d the Authoritative Data Warehouse (ADW) project. Prov i des support in the daily data management activities as follows: Data Governance planning, oversight and control over management and use of data assets Data Architecture Management as an integral part of the enterprise architecture Data Development a n a lysis, design, building, testing, deployme n t and maintena n ce Database Operations Management support for structured physical data assets Data Security Management ensuring privacy, confidentia lity and appropriate access Reference & Master Data Management managing Golden versions and replicas Data Warehousing & Business Intelligence Management enabling access t o decision support data for reporting and analysis Document & Content Management storing, protecting, i ndexing and e n ab l ing access to data found in unstructured sources (electronic files and physical records) Meta Data Management integrating, controlling and delivering meta data Data Quality Management defining, monitoring and improving quality of da t a assets. Participates in complex IT projects. Ensures systems operate at peak performance Troubleshoots software issues and makes recommendations for upgrades Develops i n structions for integration projects.
Consultant Lead Designer Project Leader with MG Devices Accounting Systems, Los Angeles, CA
Provided consulting services to Retail Sales, A ccounting and D ata P rocessing Se rvices B ureau whose primary client was Atlantic Richfield Oil Company Retail Sales. Performed as Project Lead, Database System Designer, Software S ystem Analyst, and Designer. Developed distributed product tracking and pricing system . Data Modeling Concepts 1st 3 rd NF Tools Utilized: AT& T 3BV, UNIX, C, INFORMIX, and SQL. 04/87 04/89 Atlantic Richfield Oil Company (AM/PM Mini Market) Los Angeles, CA Consultant Lead Designer Project Leader Personal Consultant to Mr. Robert Fidler, Vice President, ARCO Retail Sales Non Petroleum Products Conducted Feasibility Study Distributed Product Tracking and Pricing Re engineered Product Tracking and Pricing process based upon Bill Smith ' s four point plan (Six Sigma): Global competitiveness Participative management Quality improvements Training and Education Center Business Process Models
Enterprise Data Architect with Merchant & Traders Buffalo, NY
Developed Predictive Analysis and Business Intelligence Enterprise Data Model for A l ternative Banking Enterprise MDM initiative Enterprise Information Management Design and deve l opment of BPM Design a n d deve l op Conceptual, Logic a l, and Physic a l Data Architecture Data Modeling Concepts 1st 3 rd NF Dimensio n al (STAR and Snowflake) Schema DAMA and Zachman Frameworks Inmon & Kimba ll Methodo l ogies Personally respo n sible for all data related products and deliverables
Data Architect, CIO, and Manager with Data USA of Memphis, Memphis, TN
Overseeing day to day operations of firm:
Sales Consulting En t erprise MDM initiative Enterprise Information Ma n ageme n t Enterprise Data Architect deve l oping Multi level Marketing for Home Fash i on Industry startup Data Modeli n g Concepts 1st 3 rd NF Dimensiona l (STAR and Snowflake) Schema DAMA, DODAF, TOGAF, and Zachman Frameworks Inmon & Kimball Methodologies
Consultant,Memphis, TN
Confidential
Analyzed and designed DATA WAREHOUSE for the consolidation of multip l e company corporate Sales & Marketing information. Each company employed independent Enterprise Models . Database was implemented in Oracle incorporating STAR SCHEMAS with source data originating from DB2, IDMS, ORACLE, and VSAM data structures . Data Modeling Concepts 1st 3 rd NF Dimensional (STAR and Snowfl ake) Schema Inmon & Kimball Methodologies Designed and developed data migration software. Designed and coded automated Messaging/Interface processes. Distributed processing via MQSeries. Reporting developed in Seagate Crystal and employed CRYSTAL ENTERPRISE. Analyzed, designed, and created empl oyed CRYSTAL ENTERPRISE reporting system for Sales & Marketing from enterprise DB2 and ORACLE databases with automated scheduling via Seagate Infose rver Calendars. Report distribution via Seagate Infoserver, Cognos Web Components, and DAZZLE. Project Lead, analyzed, maintained and coded modifications to legacy CICS IDMS Sales & Marketing Reporting system. Project Lead, analyzed, designed, and developed Active Server/ ADO/Oracle WEBSITE for the analysis of CUSTOMER COMPLAINT TRACKING system data. The reporting was de ve loped in Seagate Crystal. Project Lead, analyzed, designed, and created SQL views / queries for SEAGATE CRYSTAL reporting system for Sales & Marketing and COMPLAINT TRACKING systems Oracle databases.Implemented report distribution via Seagate lnfoserver.
Project Lead, analyzed, designed database and system processing, to include legacy system interfaces for new COMPLAINT TRACKING system. The system was imp l emented in DELPHI using an ORACLE database. Additionally, the system interfaced to DB2 legacy systems. Implemented under CITRIX SERVER a nd included a mobile application, which initially employed ORACLE REPLICATION. Designed custom Replication capability which dynamically generated replication process based upon deltas of Enterprise Database Catalog vice local Systems Catalog wh ich resulted in 200%. Performance increase. System tracked activity re garding customer complaints and compensations. Setup scheduling and report distribution via Seagate Infoser ver. BI Reporting developed in Enterprise Crystal Repository. Project Lead, designed Oracle database for Validation and Reference Data (VRD) to extend Enterprise Data Model (DB2) to server based environment. The reporting was developed in Seagate Crystal.
Analyzed, designed, and coded SAPIENS based Customer Order Entry system (PPRO) with DB2 database. Project Lead, anal y zed , and designed database and system processing to include legacy system interfaces and coded a new CICS/DB2 Manufacturing Distribution system (Common Order). The system included both batch (CICS asynchronous with interval control) and online (TELON) components. Distributed processing and messaging was accomplished using native MQSeries. Analyzed, designed, and coded modifications to the distribution sub system of CICS/IDMS/IMS Printing Paper Order Entry (PPOE) system. Tools Utilized: VISUAL INTERDEV, ASP, COM, VISUAL BASIC, VB SCR IPT, JAVA SCRIPT, DELPHI, COBOLII, VSCOBOL, SAFESOURCE, P ANV ALET, SPUFI, QMF, CICS, DB2, ORACLE, PARADOX, IDMS, IMS, VSAM, Platinum, Erwin, Endeavor, MQSeries, SAP IEN S, TELON, Seagate Infoserver, Cognos Web Components, and DAZZLE.
Consultant with,Greenville, SC, Confidential
- Analyzed, designed, and coded a CICS/DB2 Cooperative Advertising Claims system.
- Accomplished data modeling and process modeling. Designed and coded on line reporting . Performed structured analysis and design.
- Data Modeling Concepts 1st 3 rd NF
- Tools Utilized : SPUFI, QMF, CICS, DB/2 and BMC CATALOG MANAGER.
ACCESS METHODS:
DBAM, ISAM, and VSAM.
TOOL SETS
ADS/ A, ALLFUSION (ERWIN), BPWin, Business Objects Enterprise, COOLBiz, Erwin Workgrp Edition, Systems Architect, ProVision, Sybase Power Designer, Visio.
DATABASE SYSTEMS:
DB2, DB2/UDB, CASSANDRA, IDMS , IMS, INFOBASE, INFORMIX, MAC OS X, MS/ACCESS,, MS/ SQL SERVER, MS/ SQL SERVER SCRIPT, ORACLE, PARADOX, PostgreSQL, SYBASE, S2000, and TERADATA, TOTAL.
HARDWARE:
AT& T 3BV , IBM 3090,370,4300, AS400, IBM iSeries, eSeries & AS/400, and INTEL based Servers/PC.
LANGUAGES:
ADS/0, C, COBOLII, COBOU370, DDL, DELPHI, DML, FORTRA N, JAVA, JAVA SCRIPT, OS/JCL, PLSQL, MICROFOCUS COBOL, SQL, T SQL, VISUAL BASIC, VB SCRIPT, and VS/COBOL.
METHODOLOGIES:
BPEL, BPMN, DMBOK, IDEFO, IDEFIX, SDM70, STRUCTURED SYSTEM ANALYSIS & DESIGN, DAMA, DODAF, TOGAF, YOURDON, UML, and ZACHMAN.
OPERATING SYSTEMS:
AS400 OS, LINIX, M VS, MVS /XA, PC/DOS, REDHAT, UNIX, and Windows OS.
SOFTWARE:
ACTIVE SERVER PAGES, APPC, ASC SQL VIEWPOINT, ASC WEB INTERFACE, BMC CATALOG MANAGER, CICS, CRYSTAL ENTERPRISE, CRYSTAL REPORTS, DADMS, DART, DAT AST AGE, ENDECA FED ERA TED SEARCH ENGINE, LU6.2, MSIVISUAL, INTERDEV, MQSERIES, PRISM, PLATINUM, QMF, SAPIENS, SEAGATE ENTERPRISE, SEAGATE INFOSERVER, SNA , SPUFI, S2000, and TELON .