Data Architecture Consultant Resume
OBJECTIVE
To serve as a technical expert, on staff or on a consulting basis, helping to resolve complex issues with significant financial, organizational, and operational business impact, and enhancing organizational efficiencies and effectiveness on critical corporate or government projects.
ACHIEVEMENTS- 20 years of employment rendering technical, engineering, and advisory services in the Defense, manufacturing, and Life Sciences industries, five of those in project leadership and management roles.
- Developed the third normal form relational data model for the EMETF geographic information system for placing fully equipped military units at specified locations for simulation of radio frequency compatibility, vulnerability, and interference.
- Developed the conceptual, logical, and physical data models and implemented the data base for the targeting analysis of the JSTARS Field Operational Test and Experiment of 1994 at Fort Huachuca, AZ.
- Led the creation of relational logical and physical models for the engineering change control and configuration management database for C-17 military transport aircraft.
- Developed a data flow model and the first conceptual data model for the construction of a nuclear attack submarine.
- Developed logical data models representing the content of all standard executive reports from data processing at the Dictaphone corporation
- Developed a logical relational model representing all possible configurations of all possible computers to be used or emulated to recover the business of a client of IBM Business Continuity and Recovery Services at their recovery operations centers.
- Developed structural models and data maps to make engineering change data promptly available on the Daimler Chrysler intranet to the DC service authoring organization.
- Reverse engineered 24 separate repositories of Motorola customer data comprising more than 400 diverse data elements to create a migration plan and data map for conversion to customer master data management using Oracle Financials.
- Developed process maps and object data models and a hierarchical object schema for the to-be engineering to manufacture process for Motorola Consumer Electronics.
- Developed an integrated bill of materials data model for IBM Common Tools for use in the design and sourcing of IBM z series computers.
- Developed legacy data models and an integrated data map for migration of the GM Sitel call center lead management system to Siebel 7 customer relationship management.
- Developed a conceptual data model for the information object (product with offering documents) produced in the IBM PC Co Integrated Product Development process
- Developed the relational logical data model for integration of clinical and genetic patient data at the Fred Hutchinson Cancer Research Center.
- Assisted in enhancing the data model and improving the data base for the Cleveland Clinic Foundation Hospital abdominal aortic aneurysm treatments
- Developed a model for integration of genetic, genealogical, and clinical data for anonymous patients at the Huntsman Cancer Institute.
PROFESSIONAL EXPERIENCE
Confidential, Park Ridge, IL
Staff Executive, February 2009 - April 2009
- Execute management consulting projects delivering revenue enhancements and cost reductions to small businesses
Confidential, Tucson, AZ
Independent management consultant, Nov 2007- present
- Consulted on process and issues for CarbonTech Tucson, LLC, renewable energy fuel manufacturer
Confidential, Tucson, AZ
Vice President, Director; Ritual Chair, Jan 2005 - Dec 2008
- Unpaid volunteer elected position in governance of the synagogue, attending Board Meetings, voting on ways and means and strategy, serving as liaison to various other religious and community organizations, managing all logistics for the presentation of religious services weekly and for holy days, maintenance and construction of religious furnishings, and operation and repair of audio amplification systems.
Confidential, Armonk, NY
Technical Sales Consultant Life Sciences & Healthcare, 2002 - 2005
- Represented IBM data integration (DB2 related) solutions to sales prospects on-site, at trade shows, in presentations, and as augmentation effort on proofs-of-concept and loss-leading implementation projects.
Senior Business Transformation Consultant, 2000 - 2002
- Performed on and managed IBM Global Services internal and external process improvement consulting engagements
Data Architecture Consultant, Contracted to IBM, 1996 - 2000
- Performed process and data modeling and documentation on IBM process improvement consulting engagements.
Confidential, Fort Huachuca, AZ
Chief Scientist, 1993 - 1995
- Senior resource for resolving all scientific, geographic, technology and standards compliance issues arising during support of field and operational testing of US Army intelligence systems at TEXCOM IEWTD.
Confidential, Fort Huachuca, AZ
Senior Systems Engineer, DTSS, 1990 - 1993
- Managed the team preparing to, creating, and operating the US Army CECOM SED TFS Life Cycle Software Engineering Support Center for the Digital Topographic Support System, planning annual tasks, estimating annual budgets, setting up and operating the initial computer system network, hiring resources as tasks and budgets grew, managing the system transition from development to deployment, and managing the operations through release of the first official revision.
Confidential, Fort Huachuca, AZ
Geographic systems analyst, DTSS, 1989
- Team member doing independent verification and validation of Army Intelligence software under development, reviewing software and data base designs and documents for clarity, correctness, and compliance with applicable standards.
Confidential, Fort Huachuca, AZ
Senior analyst, Research & Development, Electromagnetic Environmental Test Facility 1987-88
- Provided engineering support for systems improvements in the simulated testing of radio frequency compatibility, vulnerability, and interference of US Army equipments in battle.
Confidential, Cleveland Heights, OH
Instructional Systems Manager & Systems Management Instructor, August - December 1986
- Managed the computer and taught operating systems concepts and operations
Confidential, Beachwood, OH
Contract technical writer at LaserCAM, January to September, 1985
- Provide document production services, both format and content, for LaserCAM proprietary textile parts manufacturing systems.
- Project Management
- Executive Presentation
- Business Process Reengineering
- Data Modeling
- Technical & Business Writing
- Quantitative/Qualitative Analysis
- Statistical Analysis
- Systems Analysis & Design
- Development Methodologies
- Solution Consulting & Sales
MBA Essentials Certificate (four continuing education units).
Ph.D., Life Sciences, Ecology and Systematics.
MS., Mathematics, Computer Science and Statistics.
MA., Botany.
BS, Agriculture, Forest Science.
Applications Used
Oracle 7.0.12, SQL*DBA, SQL*Forms 3.0, SQL*Plus, Designer/2000; DEC All-in-1; Ami Pro 3.0, ARC/Info 5.0, Century TERM, Century TCP/IP, DB2, dBASE III+, dBASE IV, DrawPerfect 1.1, Erwin 3.5.2, Harvard Graphics 3.0, iGrafx, Lotus 1-2-3, Lotus Notes 4.5.3, Lotus Smart Suite 97, Microsoft Office Word, Powerpoint, Excel; Microsoft Project 4.0, Quickbooks, RNF, Siebel 2000, Siebel Tools 6.01, Visio 4.0, Visio Enterprise 5.0, VisioModeler, IBM WBI Workbench, WordPerfect 5.1
Operating Systems Used
HP-UX 9.0, VAX/VMS 5.3, 5.4, MS-DOS 5.0, 6.1; MS-Windows 3.1, 95, 98, 2000, XP; OS/2 2.1, 3.0; VM/CMS 2; TI-DNOS; HP-CI; CDC NOS 2.1.
Programming Languages Read/Written
Ada, BASIC, C, CCL, COBOL, COMPASS, DCL, Fortran, Pascal, SQL