Sql Server Data
Resume:
Gregory Michelson
OBJECTIVE: DATA ARCHITECT
Sacramento, CA
**************@*****.***
SUMMARY
Senior Data Architect with an extensive and successful track record in the design, development, organization, and maintenance of data structures and repositories, for many companies and projects. Developed an architectural framework detailing the business and technical aspects of the data and delivery services, with details showing how the components fit together and how the system can be expanded over time. Developed methods for maintaining consistent approaches to Data Modeling in all stages of a project from Requirements to Physical design.
SKILLS
Gathering requirements for key metrics, reports and analytical subjects.
Assisting departments to understand their data/information and the way Information Architecture works to supply these needs.
Developed Conceptual models during the Requirements phase of projects.
Developed Logical and Physical models during the Design Phase of projects.
Ensured the consistency and quality of the data resource.
Build an architecture for ETL.
Responsible for the mapping definitions defining the rules for mapping data from source to the target Data Warehouse.
TECHNICAL EXPERIENCE
Implemented systems using the following:
Model Skills: Entity-Relationship Analysis, Business Data Modeling, Resource Modeling
Model Tools: ERWIN, SILVERRUN, DB ARTISAN (ER Studio), CASEWISE, DEFT
RDBMS: MS SQL SERVER, SYBASE, INFORMIX, INGRES, MySQL
Network DB: IDMS (CULLINET), TOTAL (CINCOMM), SYSTEM 2000 (S2K)
Languages: SQL, XML, SQR, Basic, COBOL; Object View, 4TH Dimension (4D); HTML, ASP
Platforms: IBM (PC-NT and Windows), SUN, HP (Unix), IBM (Mainframe), DEC (Alpha), MACINTOSH (PC)
EXPERIENCE SUMMARY
Data Architect
Elyon Strategies, LLC, Folsom, Ca
Feb 2011 – Dec 2014
Developed an Information Architecture Questionnaire for a State Government Agency
Drafted (and company presented to the Client) a comprehensive Information Architecture Questionnaire, that accurately assessed (it has been used and tested) the complete state of the Business and Technical maturity and opportunities for improvement of a major health care agency.
Questions included ones addressing policy decisions at all levels of the organization. Personnel capabilities, training and deployment methods. Semantic maturity (vocabulary) and the existence of models, documentation, and cross discipline training were included. The existence of data dictionaries, meta-data repositories and their current level of maturity were addressed.
Developed a Data Migration Plan for a State Government Agency.
Wrote a plan to migrate two complex computer based systems to a single, common system. The plan incorporated many checks and balances to ensure the success of the whole effort.
The main features included progressive commitment, extensive test scenarios, gradual commitment and stepping through multiple levels of loading and testing.
Non IT Related / Financial Planner / Financial Analyst
Mar 2009 to Dec 2010
.
Data Architect
Tradescape, Inc., San Jose, Ca
Sep 2008 - Dec 2008
Worked in a MySQL environment, using both Linux and Windows on large servers.
Responsibilities included Data Modeling, DB Design and Deployment.
Designed and developed a comprehensive archiving system, including the stored procedures for updates and deletes. This system used a different process for each of the three main databases - staging, processing and reporting. The online-archive database design was the principle one, but the overall process included an historical-archive database also.
Designed and developed the financial reporting system, using more traditional relational tables, to provide for ongoing reports. Designed and developed the supporting structure (tables) for the process control system, which tracked the overall processing step by step to verify both data integrity and process completeness.
Set up a parallel database system using MS SQL Server 2005, to quickly load one set of large production files and summarize the results.
Data Architect
Cellfire, Inc., San Jose, Ca
Oct 2007 - July 2008
Working in a MySQL environment, designed an improved data model to support production.
Assisted the engineering team to improve the current production database, by improving the indexes and reducing the current database size through a process of archiving older data.
Drafted a plan to produce an improved management reporting Data Warehouse.
Started the design for an extensive upgrade to the Corporate Data Warehouse.
Also started a process to identify business entities and began to put these definitions into a metadata model, thus establishing a business meta data source and usage patterns.
Assisted IT operations with overall database improvements, updating physical models and standardizing database upgrades.
Data Architect
Mayo Clinic, Rochester, MN, via Pragmatek Consulting Group, Inc.
Feb 2007 - Apr 2007
Worked for a small consulting company in Minneapolis MN as a sub-contractor. My assignment as a Data Architect was for an SOA Project at Mayo Clinic in Rochester MN.
Designed and documented a process to utilize the Lab Division's Common Data Model (CDM) as the central part of integrating a number of legacy Lab systems into a new SCC Soft Lab system. This involved the methodology for documenting the old EDI style message (HL7 format), converting it to an XML Schema and producing a new XML Message that the SCC Soft Lab system could then accept as input.
The overall design included a database to maintain the new and old message structures, a standard data element definition and a mapping from the old message nomenclature into the new CDM.
Data Modeler, Data Architecture Team
CAISO, Folsom, CA, via Sapphire Technology, Inc.
Nov 2003 – Dec 2006
One of three Data Modelers on the CAISO MRTU program, working from a conceptual data model that the team had enhanced, developed a Logical Data Model to accurately reflect the requirements identified by Business Analysts while meeting the needs of the Service Oriented Architecture.
Developed a business fact model by facilitating sessions with business experts, and formulated consistent definitions of terms. Used conceptual data modeling and business process modeling skills. The resulting definitions and references between terms were documented using the CaseWise tool set. The terms defined had to meet the legal requirements of the California Energy Tariff.
Contributed to the semantic model, which is a mapping of business terms to logical definitions, and implemented a supporting database to manage this metadata and the mapping to actual database elements. There were over a 1000 terms and definitions in the mapping, and about 1/3 of the terms were related to CIM attributes.
Assisted in developing and implementing a Data Bus (under a Service Oriented Architecture). All major applications publish to and subscribe from the Bus, using XML with supporting XML Schemas. The structure and tools of the Data Bus link the applications asynchronously, decouple systems and standardize communications.
Co-developed a complete conceptual data model for a Market trading and tracking system that encompassed approximately 75% of the business and 90% of the business entities of CAISO. Used this as a basis for the logical data models to support the update and maintenance of the Full Network Model, the Integrated Forward Market, and the Congestion Revenue Rights functions of CAISO.
Drafted a comprehensive manual to explain the structure, use and basic methodology behind data models. This was designed for the business analyst and the knowledgeable business manager.
Data Architect and Data Modeling Consultant – Mar 2001 to Sep 2003
Designed, delivered and installed business transaction and historical-archive databases and supporting governing procedures. Starting from business conceptual models, developed and documented logical and physical data models in support of major business segments. Many projects included the development and delivery of ETL processes for converting existing databases to the new structures. A working database was delivered that included advanced data integrity constraints built in to the structure. Clients included:
Ciena Corporation, Cupertino, Ca
Somerton Student Insurance Services, Rancho Murieta, Ca
Sutter Connect, Rancho Cordova, Ca – part of Sutter Health Group
Senior Systems Architect
Advanced Open Source Solutions (AOSS), Roseville, CA.
Nov 2000 – Mar 2001
Designed and wrote specifications, including the XML DTD, for a comprehensive programming interface to support movement of numerous types of legacy data to an integrated Sybase Database for Call Tracking. Documented the conversion from the current process to the new XML Document Types.
Sybase 11.5 using HP-Unix on large HP Systems.
Instructor
MTI College of Business and Technology, Sacramento, CA.
Mar 2000 – Sep 2001
Part time Instructor for Database Theory and Structured Query Language (SQL) courses, which use the tools and DBMS from MS SQL Server 7.0 as part of the course. The course included an introduction to data modeling.
SQL Server DBA
INTEL, Corp, Folsom, CA.
June 2000 - Nov 2000
Acting DBA in MS SQL Server 7.0 environment (using NT 4.0 Servers). Developed and installed a Maintenance Plan on the Production Servers. Installed Database Replication and ensured its day-to-day operation.
Trained a new-hire in Database Management principles of Operation and Maintenance as well as the use of tools such as Schema Manager and Modeling Tools. Also taught new DBA advanced use of SQL and stored procedures.
Assisted in defining a complex process for upgrading the Production Servers on a Hosted Site (using Intel's IOS - Intel Online Services), which included process to update the Application Code and Static Pages and modifications to data in Static Tables. Assisted in resolving a number of technical issues with the Operation of the Hosted Site (using Intel's IOS).
Wrote and tested the Database Schema Update Plan for the Preview (staging) and Production Servers. Reviewed the Data Models for the Reseller Rebate application and a new Supplier Certification application - suggested and implemented a number of change
Wrote the data conversion specifications and the SQL Stored procedures to convert a set of MS Access tables to MS SQL Server 7.0. Conversion included changing the data encoding schemes from the old to the new database.
MS SQL Server 7.0 on Microsoft NT 4.0 Servers.
Senior Sybase DBA
Hewlett Packard, Roseville, CA.
Aug 1998 – Jun 2000
Responsible for performance testing and Sybase tuning of a large call tracking application (Clarify's Clear Support). Wrote many stored procedures used for database maintenance and as development tools. Also assisted developers in the use of Microsoft Reporting tools which called SQL stored procedures.
As Development DBA, supported 12 Test/Development and 1 Production Server. Responsibilities included planning for disk space growth, updating Sybase and related software to the latest release, trouble-shooting and call support interface to Sybase Technical Support.
Environment: Sybase 11.1 and 11.5, HP UNIX and Microsoft NT.
Responsible for the day to day operation of the production Billing System and its Sybase Server.
Maintained the development and test Sybase servers and consulted with the programming staff on database and SQL problems.
Environment: Sybase 11.0 and 11.1 and Sun (UNIX).
Senior Database Administrator
INTEL, Hillsboro, OR.
Aug 1997 – Jul 1998
Database Administrator for development and production systems. Installed and documented Replication on MS SQL Server. Tested programs and wrote documentation associated with MS SQL Server maintenance and replication (documentation was done using an HTML editor).
Provided data model design reviews and consulting to a broad range of customers from novice to expert in background. Promoted good database design practices to ensure data integrity, optimum performance and increased data sharing.
Developed a Web based (intranet) MS SQL Server Maintenance Application for use by Technical Administration people, which required no knowledge of SQL or MS SQL Server to determine the current status of a production server. Included:
oOverall Server Status
oProactive Problem Warnings for common Server and Database problems
oReplication specific reports and Distribution Database queries
oTrouble shooting reports and correction guides
During the data conversion of the Parts Table from another system, used MS Access to verify and edit the data before loading it to the MS SQL Server 6.5 database.
Created the initial design and data model for a Data Warehouse (SQL Server 7.0 databases) that would later store summary information for all of the Web page activity at INTEL.CO
Environment: Microsoft SQL Server 6.5 and Microsoft NT.
Database Administrator
Diamond Multimedia Systems, San Jose, CA.
Apr 1995 – Jul 1997
Database Administrator for development and production systems. Developed many tools for programmers and routine administrative functions. Wrote a set of tools, using SQL stored procedures, to support production applications and provide access to many aspects of the metadata and server status information. For example, database size and disk usage was monitored and tracked over time to be able to predict growth.
Helped to develop the data conversion process from the legacy systems using MS Access to do data edits and test the new reporting process. The data was then loaded to a data warehouse using MS SQL Server 6.5. Converted the databases on a DEC Alpha machine to SQL Server on NT. Also assisted developers in the use of Crystal Report calls to stored procedures.
Environment: Microsoft SQL Server 6.0 and 6.5, and Microsoft NT
Data Architect and Data Modeling Consultant – Jun 1989 to Apr 1995
Designed, delivered and installed business transaction and historical-archive databases and supporting governing procedures. Starting from business conceptual models, developed and documented logical and physical data models in support of major business segments. For most projects a working database was delivered ready for testing was included, with advanced data integrity constraints built in to the structure. Customers included:
Advanced Cardiovascular Systems (ACS), Santa Clara, Ca
Apple Computer, Cupertino, Ca
DHL Airways, Redwood City, CA
Interop, Inc., Harrisburg Pa, (local site in Mt. View, Ca)
Pacific Gas & Electric Co., San Francisco, Ca
Sun Microsystems, Mt. View, Ca
EDUCATION
University of Minnesota
Bachelor of Science Degree in Mathematics
Data Modeling
advanced training in Data Modeling Techniques
Instructor training on how to teach Data Modeling class
Certified Sybase Data Modeling Instructor and database design tools (DEFT was the tool name)
Facilitation
Personal Development Training - sales and presentation methods
Instructor training on how to conduct meetings and facilitated sessions
Business Modeling and Business Rules development class
Technical Classes
Ingres DBA training
Sybase advanced tuning techniques
How to teach non-technical users, basic SQL skills (a class)
Business Statistics - process improvement (a class)
MS SQL Server class on 2005 new release and ETL services - on line class
Perl, script programming for Unix (self study course)
Contact this candidate