Profile picture

Dan McCreary : Curriculum Vitae

Resume

An enterprise metadata strategy architect with a strong track record of leading large software development projects that leverage centralized metadata structures.  Dan has a combination of technology, leadership, training and mentoring skills. Recent Project Experience
  • Designed and created metadata registry for Thrivent Financial.  Managed business terms, synonym sets, data elements, code-tables, taxonomies, product hierarchies, wantlists, schemas, services, business rules, requirements, portlets and tasks.  Created architecture for the creation of business intelligence dashboards, reports and operational scorecards.
  • Created metadata registry for the Minnesota Department of Revenue.  This metadata registry was used for as the basis for communication with 87 counties as well as auto-generation of XForms applications.   See http://proptax.mdor.state.mn.us/mdr for further details on the project.
  • Used MULE open source Enterprise Service Bus ESB to exchange over 2 million XML taxation documents with 87 counties.
  • Designed  and implemented Service Oriented Architecture (SOA) for DOR Property Taxation division using REST and eXist native XML web server.
  • Taught classes on XML Schema, XForms, XSLT and XQuery for the Minnesota Department of Revenue.
  • Created OLAP cubes of property tax data using Microsoft SQL Server 2005.
  • Integrated XForms applications with eXist open source database, Microsoft SQL Server 2005 XML and DB2 version 9.1 PureXML.
  • Created enterprise-wide metadata registry for Minnesota Department of Education including population of metadata registry with over 400 data elements.  This metadata registry is still being used for all enterprise data warehouse projects.
  • Created and delivered metadata registry training materials including topics of business semantics, semantic web, declarative programming, data stewardship, data element definitions, data element representations, business constraints, taxonomies to a wide variety of non-technical users. Seehttp://www.danmccreary.com/training for sample classes.
  • Intimately familiar with internal metadata registry data structures as outlined in ISO/IEC metadata registry standard 11179 including data element concepts, classification schemes and representation terms.
  • Served as domain expert for ISO/IEC 11179 L8 metadata registry technical committee.
  • Created and delivered instructions on large complex metadata registries including Global Justice XML Data Model (GJXDM) and National Information Exchange Model (NIEM).
  • Published metadata in a wide variety of formats for viewable and machine-readable formats including HTML, Microsoft Excel, OWL/RDF, XMI, CWM, Hibernate OR-mapping, SQL, FreeMind and MindManager visualization.
  • Created and defined trust-building processes needed for enterprise-wide adoption of metadata registry.  Familiar with stakeholder analysis, data stewardship and adoption of metadata registries by development staff.
  • Developed systems with data warehouse structures using dimensional analysis, star schemas and the publishing of cubes to non-technical users.
  • Created Service Oriented Architecture (SOA) standards for Minnesota Department of Public Safety, CriMNet division.
  • Taught management-level classes on Enterprise Message Bus (ESB) including reliable and secure messaging concepts.  Include extensive analysis of ROI of PKI infrastructure for encryption, authentication and digital signatures.
  • Taught programmers, project managers and business analysts concepts of Enterprise Service Bus using Java Messaging Service (JMS).
  • Taught extensive classes on XML, XML Schema, and XML transforms internally and externally.
  • Taught departmental-wide classes on Altova products including Enterprise XMLSpyTM, MapForceTM.
  • Used Altova SemanticWorksTM and Stanford's Medical Informatics Protégé  ontology development tools to validate and refine OWL datasets extracted from metadata registry.
  • Performed evaluation of Cognos Framework ManagerTM and integration with Cognos ReportNetTM and Cognos PowerPlayTM.
  • Created web-interfaces to OLAP structures using Cognos PowerPlayTM.
  • Built reusable XSLT 2.0 transform library for managing metadata structures.
  • Used SAXON 8 libraries for implementing parameterized XSLT transforms.
  • Created Apache Ant build scripts for managing metadata publishing on public internet and private intranet web sites..
  • Taught classes on using Apache Ant for managing metadata publishing tasks both on public internet and private intranet web sites.
  • Created cubes from relational database structures using Microsoft Analysis Server.
  • Created library of Oracle metadata extraction tools using SQL scripts.
  • Familiar with many standard ER data modeling tools such as ERWINTM.
  • Created and taught data modeling and object modeling classes for over 20 years.
  • Author of over 200 wikibook articles on XForms, Ant, XQuery and XSLT.  See http://en.wikibooks.org/wiki/XForms