Data Management

Greg Michelson

Business address: *** Parkshore Drive, Suite 134, Folsom, CA 95630

Contact Office : 916-***-**** Cell: 916-***-****

Email: abpejm@r.postjobfree.com

Introduction:

Greg is a seasoned veteran in IT data management. He worked his way up from database administrator to senior

data modeler while working for many of the premier technical companies in the Bay Area, including Apple Computer

and Stanford University. His management and business analysis skills have served him very well in his more recent

role as a data architect. Greg has extensive experience in the following disciplines:

Enterprise level data modeling

Large scale application logical and physical data modeling

Master Data Management and Data Quality policies and procedures

Development of standards, guidelines and tutorials for data modeling

Business systems analysis covering a complete SDLC

Superior communication both written and verbal with business and IT

Professional Experience

Elyon Enterprise Strategies

Data Architect (2011 to present)

Leading the team on everything from semantic modeling to naming standards is Greg s favorite role. Applying

Zachman Framework (ZF) to organizing the discipline of conceptual design, documentation and client analysis has

greatly helped the team to organize their overall approach and individual efforts. The insight gained by quickly

arriving at a set of primitive constructs, based on the ZF, has moved the team forward towards an integrated model of

the entire semantic and conceptual effort required to be successful on each client engagement.

Independent Consultant

Data Architect (2009)

Greg s recent experience was with a series of internet start-up companies in the Bay Area where he applied the

principles of data management, data modeling, data warehouse design and overall data maintenance practices to

such companies as Cellfire, Inc. and Tradescape, Inc.

Improved the overall design and workings of the production database, while documenting the existing

schema in the data model.

Installed procedures to check the quality of the database and set up an arriving schema and related

procedures to maintain data history and minimize the impact of day-to-day database processing.

Established the target data warehouse model and a plan to verify it and start the ETL work to populate the

required tables and index structures.

Page 1

Larry Baltezore - Resume

Mayo Clinic

Data Architect (2007)

Greg s was tasked with the job of using the newly finished Common Data Model (CDM) for the Lab division of the

Clinic to build a new messaging sub-system for the SCC Soft Lab system that would allow all seven (7) labs to

communicate with it.

Greg converted the CDM to an XLM schema as the foundation for the new messaging system, then mapped

the HL-7 message structure to a set of messages using XML.

His design included a standard data element definition and a database to maintain the mapping from the old

structure to the new massage nomenclature, which in turn was related to the CDM.

The new message structure was validated by a team of business and systems analysts and was

implemented by a five-person team to using the newly designed message structure in IBM web-based tools.

California Independent System Operator (CalSO)

Senior Data Modeler (2003)

As part of the data architecture team, Greg developed logical data models in support of the large rewrite of the

market and related tracking and settlements systems. He established data naming, metadata and data modeling

standards.

His skills as a facilitator were put to the test as he helped to revise the Operating Divisions business fact

model. He produced the second version and published the business dictionary with over 1,000 terms that

had to meet the legal department requirements. Ronald Ross of Business Rule Solutions LLC produced the

first version.

He drafted a comprehensive manual to explain the structure, use and methods of data modeling to the

business analyst community and knowledgeable middle managers.

He and a colleague designed a metadata dictionary and linked many business terms to existing database

structures to prove its usefulness.

Additional Professional Training:

Greg is a trained instructor in Data Modeling. He is certified at a technical college in Sacramento and with

Sybase, Inc.

Greg s training in leading meetings and acting as a facilitator has assisted him in completing many

assignments with senior managers.

Greg has received training in numerous modeling tools including ER/win, ER Studio and Case Wise.

Greg s background includes numerous courses in RDBM s such as MS SQL Server, Sybase and Ingres.

Education:

B.S. in Math with a Teaching Credential, University of Minnesota

Completed two-thirds of the MBA coursework at Northwestern University, Evanston, Illinois

Page 2

Contact this candidate