Data Warehousing Resume Profile
ENTERPRISE DATA ARCHITECT
I offer exceptional experience at creating and running an organization's information strategy, data architecture, and data management functions. More than 15 years' experience establishing and leading master data, data governance, information strategy, and enterprise data architecture programs for companies of all sizes over 20 years' experience in information technology as a whole. Proven results motivating and coordinating separate business functions t achieve integrated objectives. Known for consistent business focus, pragmatic principle-based designs, exceptional communication skills, and distilling complicated problems t their actionable critical path. Key skills include:
Information Strategy | Data Architecture |
Data Governance | Master Data Management MDM |
Data Quality | Leveraging Metadata |
Data Modeling | Software Evaluation |
Data Warehousing Business Intelligence | Big Data |
PROFESSIONAL EXPERIENCE
- Data Management Simplified Confidential
- Data Management Simplified is the 13th book I have written. It teaches all the skills needed by a professional Architect or Data Manager t manage their company's data effectively and efficiently. Includes underlying principles, sample frameworks and toolkits, and necessary roles and processes. Due in bookstores Winter 2014.
- Confidential Enterprise Data Architect
- Founded the Enterprise Data Architecture function. Academic organizations tend t be free-spirited and resistant t centralized governance. This one is als Los Angeles' largest private employer, with over 10,000 staff members. A university is like a manufacturer whose raw materials, tooling, and finished goods are all people: over a quarter million people each year, comprising hundreds of different roles and responsibilities, from over 70 independent sources. USC had n authoritative source of truth, n clear data ownership, n documented reusable data architecture, and n data-management function. There were massive redundancies and inefficiencies. T improve the situation, in this agile consulting role I:
Designed and put int production the Enterprise Data Model
- for dozens of data objects in the domains of Person, Application, and Enrollment
- Facilitated workshops identifying business's key operational and strategic information concepts
- Developed conceptual, logical, and physical enterprise data models approved by partners
- Harmonized existing business vocabularies and taxonomies when available crafted new vocabularies when not
- Contributed t key projects s they built systems providing and using authoritative shared data
Designed, evangelized, and drove construction of Enterprise Data Architecture
- Automates data collection, cross-source matching, standardization t enterprise business vocabulary, quality assessment, enrichment, and distribution via batch and messaging technology
- Founded on pragmatic, repeatable design principles
Designed and established Master Data Management functions
- Developed data governance framework, roles, processes, and artifacts
- Identified Business Data Owners
- Defined data quality metrics, processes, and infrastructure
- Evangelized business benefits of consistent, ongoing data governance
- Confidential Enterprise Data Architect
- Created and led Enterprise Data Architecture organization. Defined and designed all master data objects, reference data architecture, enterprise data backbone for production distribution, and company-wide governance method for data management. At project level, modeled data and interfaces for dozens of applications, ensuring maximum leverage of corporate master data. Managed up t four data architects directly and dozens of other roles via matrix management.
Eliminated annual 2.24MM in data-reconciliation labor by replacing hundreds of redundant department data sources of truth with 70 single-source global master data objects, comprising over 1,500 controlled data elements, distributed t over 500 consumers.
Saved 955K in development costs by designing, driving creation of, and ensuring adoption of global data backbone including integrated hub, message bus, and data virtualization. Built it using n capital budget.
Cut an annual 160K 30 from data governance cost by establishing company-standard scope, roles, processes, and IT point of contact.
Reduced by 45 the time needed t assess software products' architectural compliance, and improved assessment repeatability, by creating standardized template and process.
Reduced project delivery times and freed up time of overburdened architecture staff by making best-practices policies, standards, and design patterns accessible as decision trees, frameworks, and guidance documents. Project teams could then make architecturally aligned decisions without needing an architect present.
Eliminated regulatory compliance risk around controlling access t systems and data by automating collection of metadata needed by access-control tools.
Designed and oversaw construction of big data warehouse containing millions of clinical study lab results.
Maximized Data Architecture organization's business impact by creating, evangelizing, and executing an annual Data Strategy based on company and department goals, vetted by IT and business leaders, and approved by C-level executives.
Designed automated data-quality assessment system t alert Business Data Owners and consumers t data that fails t satisfy business rules they have defined.
Devised metadata-management system
- enabling one consistent set of business and technical definitions t be leveraged by downstream applications and reports.
- Confidential Director of Data Architecture
Accountable for all database designs and information integration for this data-centric site. Managed group of four Data Architects.
Lowered operational costs by designing central database for automobile data, which enabled automated generation of extensive Web site.
Saved company 250K
- by designing new data-syndication application t use existing hardware during off hours, instead of buying new dedicated hardware.
- Confidential Senior Data Architect DBA
Accountable for all database designs, data flow design, and database management. Mentored junior DBAs and managed a team of developers.
- Supported product development by designing and implementing data models for e-commerce and electronic distribution of digital content with digital rights management DRM .
- Minimized time needed for developers t comprehend new systems by producing easy-to-understand documentation of data flows between application modules.
- Confidential Oracle Programming Manager
Business delivery manager
- charged with ensuring this consulting company's clients received the value they expected. Worked with California Institute of Technology CalTech executives defining new business requirements. Designed custom Oracle Financials modules t meet requirements. Managed developer team and brought designs t production.
- Confidential Senior Data Architect DBA
Accountable for all database designs and information integration. Designed streaming data going t proprietary set-top-box STB , non-relational arrays inside STB, and back-end integrations of head-end components. Modeled data for Digital Rights Management DRM , e-commerce, and on-screen program guide. Application was rolled out t 250,000 customers.