SUMMARY:

• Enterprise Data Mgmt - Data Architecture & Modeling/Data Governance/Data Quality Mgmt/ MDM Enterprise Architecture - Documentum/ATG/ITIL/Erwin/PVCS/Remedy/Performance TuningBusiness Intelligence - Analytics, Data Integration, Process Management/Re-engineering
• Enthusiastic promoter of best practice data management. Tables and columns need unambiguous business names and definitions.
• I gather them, accelerate your data management practice and improve your process maturity.
• Extensive experience in financial services, health care, government, retail consulting.
• Strong background in application and database design, development, testing, and optimization.

TECHNICAL SKILLS:

Development Tools: SQL/MDX, PL/SQL, T/SQL, C, C++, HTML, SGML, COBOL, Unix Scripts, PERL

Databases: Oracle, SQL Server, Teradata, DB2, Informix w/Discoverer Plus OLAP, OBIEE, Microstrategy, Business Objects, Cognos Reporting

Applications: Oracle Commerce, Oracle Hyperion DRM/Planning Plus, MS SSIS/Office/Project/Visio/Access/VBA/Sharepoint/Powershell, Erwin ModelMart & Data Modeler, Sybase PowerDesigner, Embarcadero ER/Studio, Rational Rose/Data Architect/Software Architect/Software Modeler, Oracle SQL Developer, Oracle Designer/Developer, Data Advantage Group Metacenter, SQLProgrammer, DBArtisan, System Architect, Informatica PowerCenter, PowerExchange, DataStage, bulk load and stored procedure development, Oracle 10g,11i, SAP/R3/R4, awk, lex, sccs, rcs, Sable, nmake, curses, mm, nroff/troff/eqn, Trillium,WinRunner, LoadRunner, XRunner, Hyperion DRM/Planning Plus, PegaSystems

Platforms: Linux, UNIX AIX, Microsoft Windows Server 2003/2012 R2 Data Center, z/OS, Z/VM, z/VSE, Z/TPF, Open/VMS

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Enterprise Data Architect/Modeler

Responsibilities:

• Designed, implemented, deployed data integration across 4 sources including Shared Drives, Sharepoint Document Libraries, Pega applications, Active Directory
• Gathered data and data management requirements, designed, implemented Operational Data Store in support of Customer Relationship Management and Care Management ERP releases in Pega System: 1 DB, 3 Schemas, 310 tables, 3700 columns
• Proposed data quality validation rules and issue fixes for the 17 Smart PDF extract types
• Designed and prototyped extract and loading of business form history from 17 Smart PDF files, XLSX and XLSM files: 1800 columns
• Designed, implemented migration of Indiana Branches, Consumers, Caregivers, Staff
• Specified and managed replication of 22 DBs across environments and de-identification of personal health information
• Created data models of 24 existing DBs and architected new enterprise Data Warehouse and System of Record
• Mapped 18,000 source columns to 2,000 target columns for Data Warehouse ETL

Confidential, Woonsocket, RI/Richardson, TX

Technical Leader/Data Architect/Data Modeler

Responsibilities:

• Created business terms and business definitions for Confidential .com OLTP application based on Oracle Commerce (ATG backend, Endecca front end), 2920 tables, 17,500 columns, 58 subject areas.
• Created/review logical/physical Erwin 7.3.x data models for new projects (Minute Clinic, InStore Reminder, FastPass)
• Worked with business on as-is/to-be business process flows
• Mapped MediSpan, RxNorm, Enterprise Drug feeds.
• Created/reviewed conceptual/logical/physical Erwin 7.3.x data models for new SOA-enabled Enterprise Formulary Management System interfacing with 3 Claim Adjudication systems (18,000 columns, 45 subject areas).
• Proposed Data Modeling standards and Data Management policies.

Confidential, Merrimack, NH

Principal Data Architect

Responsibilities:

• Revised data modeling standards.
• Reverse engineered logical/physical data models of schemas of 20 Oracle and SQL Server databases customized or built by Confidential Corporate Technology Group into PowerDesigner using SQL*Navigator.

Confidential, Southboro, MA

Physical Data Architect

Responsibilities:

• Prepared 3-year blueprint for developing IT Service Management as a Service
• Upgraded 8 IT Service Management business processes to ITIL V3 standards which raised average CMM maturity from 2.2 to 3.
• Configuration Management was tracked in 15 systems, hundreds of spreadsheets, thousands of emails.
• Migrated assets and configurable items, business processes, business and IT services from source systems, spreadsheets, emails into centralized CMDB and implemented data management standards which resulted in 75% fewer service desk contacts per user and less management effort.

Confidential, Providence, RI

Manager of Enterprise Data Architect

Responsibilities:

• Prepared 1-year roadmap for implementing Enterprise Product, Customer, Vendor master data
• Order processing software of acquired distribution systems was incompatible and allowed freeform entries. Proposed data standards for 2 data governance groups meeting weekly, implemented first 2 sets of Master Data, designed lookup tables to translate outbound data to standards. Resulted in 7-year extension of contract with largest customer.
• Supermarket chain promotions led to increased demand being unmet. Migrated chain data via EDI 852, from SQL Server 2008/SSRS/SSAS, and from ISAM/VSAM files to create Demand Management data mart in Teradata Retail LDM.

Confidential, Boston, MA

Enterprise Data Architect

Responsibilities:

• Created data models for 4 SQL Server databases.
• Implemented two-tier billing tables and T-SQL stored procedures.
• Centralization of DB platforms led to decommission of a SQL Server DB with 47 downstream systems.
• Did data analysis enabling replacing SQL Server DB with two views.
• Supported 9 projects for 4 lines of business..

Confidential, Boston, MA

Principal data modeler

Responsibilities:

• Budget drafts were tracked in SQL Server tables whose names included the year.
• Planned data migrations to Oracle 11g into tables with year as a column.
• Developed and tested executive dashboard. Reduced effort to draft next budget.
• Two databases needed specifications for stored procedures.
• Wrote T-SQL spec for 2 DBs (9K LOC)

Confidential, Burlington, MA

Data Architect/Data Governance

Responsibilities:

• Neither Confidential and Confidential reports nor Excel extracts met needs to report by and across 3 Lines of Business.
• Extracted requirements from Excel, Confidential, Confidential .
• Delivered 2 SQL Server data warehouses. Created Microstrategy Dashboard.
• Definitions of reporting attributes were missing. Improved metadata from 0% defined to 100% defined (1200 definitions).

Confidential, Canton, MA

Data Architect/Data Governance

Responsibilities:

• BI Department lacked expertise in to-be technologies and data governance. Implemented data governance for international retail sales DW/BI environment migrating from Oracle 10g/PL/SQL/Discoverer Plus to Oracle 11g/OBIEE/Hyperion DRM with Oracle EBS ERP.
• Taught team how to classify data warehouse projects into 4 capability zones depending on data integration, data quality, reuse requirements
• Data models were home-grown. Led data integration using National Retail Foundation ARTS standard. Modeled Item Master for Master Data Management.
• Improved Metadata from 3% to 100% (11,000 terms)

Confidential, Boston, MA

Technical Project Manager

Responsibilities:

• Managed five transition projects to migrate metadata from Brownstone repository at Confidential to Confidential MetaCenter at BoA with Sql Server 2010/SSRS/SSAS.
• Created metamodels of enterprise metadata objects in Rational tools.
• Wrote standards documents on six sigma and agile data management and enterprise metadata management for federated metadata environment for thousands of databases.
• Assisted in migration of data warehouses into IBM Financial Services Data Model.

Confidential, Fairborn, OH

Enterprise Data Architect

Responsibilities:

• Created 5-year road map of data management/data governance improvements. Implemented first 2.5 years.
• Ensured compliance of design to Operational Data Store, core, data mart, presentation, and service view standards for Teradata and Oracle databases
• Corrected mappings of 179 external feeds.
• Led metadata improvements: increased defined business terms from 7% to 70%, valid business terms from 46% to 96%, in 1 year, for data 3,000 tables and 60,000 columns.