EXPERIENCE 6/2002 - 9-2002 High tech medical products Company Minneapolis, MN
Business Data Architecture Consultant
+Interviewed 25 managers
+Logical Modeling for product outcomes registry
+Logical Modeling for remote programming product
+Metadata architecture EII Enterprise Information Integration
+21CFR Part 11 electronic record and signature standards
+Hipaa Privacy
+HL7 Standards
+XML Industry-standard models
+ECM proudcts Documentum, Dante

7/2001 - 2/2002 Blue Cross of Minnesota, Eagan, MN
Hipaa Consultant
+Overall adjudication process/ data architecture
+Derived clearinghouse requirements, Rational, RUP, use case, sequence diagrams
+Transactions: 837 claims, 835 remittance, 270/271 eligibility
276/277 claim status, 278 referral/authorization, unique identifiers
+Privacy, Security


2/2001 - 5/2001 Western Lake Superior Sanitory District Duluth, MN
Data Warehouse Consultant
+Needs analysis for data warehouse, web-based report/query development
+Full Ralph Kimball lifecycle methodology
+Enterprise Models
+ERD modeling, dimensional modeling, Visio
+Statistical Analysis tool evaluation
+Technical alternatives
+Development estimates

9/2000 - 2/2001 United Health Group Minnepolis, MN
Senior IT Consultant
+Designed web-based real estate census application system, reporting data warehouse
+Full Ralph Kimball lifecycle methodology
+ERD Modeling, dimensional modeling, Visio
+ETL design, data warehouse, data mart design
+Interfaced PeopleSoft Financials, existing COGNOS

8/1999 - 8/2000 Allianz Insurance Company, Minneapolis, MN
Data Warehouse Consultant
+Full Ralph Kimball lifecycle methodology
+Enterprise Models Erwin, BPwin, modelmart
+ERD modeling, dimensional modeling
+Technical alternatives
+Development, ETL
+Implementation using WebFocus

3/1999 - 6/1999 Best Buy, Minneapolis, MN
Data Warehouse Consultant
+Design of customer data warehouse
+Enterprise Models System Architect
+ERD modeling, dimensional modeling
+Consolidating OLTP data into ODS, ETL

1/1999 - 3/1999 GE Capital Services, Minneapolis, MN
Project Lead, Business Analyst
+Web-based reporting for 3000 worldwide customers
+Multiple currencies, languages
+ERD modeling Visio

1/1998 - 8/1998 Fair Issac (Dynamark) Saint Paul, MN
Data Warehouse Project Manager
+Full Lifecycle large direct marketing database 95M credit cards
+ERD, dimensional models S-Designer, ETL
+25GB Redbrick data warehouse/ datamarts

2/1996 - 10/1997 Star Tribune Minneapolis, MN
Project Manager
+Replace legacy circulation systems
+Case Tools KnowledgeWare IEW, ADW
+Managed 35 leads/ developers
+S-Designer
+Strategic Planning, organizational development
+Package search/ evaluation
+VRU system integration, GIS, demographic databases, telemarketing system

6/1974 - 2/1996 23 other projects, including project manager for 13 projects total,
several OLTP development projects

EMPLOYERS
Honeywell Inc, Minneapolis
Tecsi Software, Paris, France
Cytrol Inc, Minneapolis
Ernst & Young, Minneapolis
Independent since 1990

EDUCATION 5/1974 University of Minnesota US-MN-Minneapolis
Bachelor's Degree Math
Master's Degree Computer Science


SKILLS Skill Name Skill Level Last Used Experience
IT/ Consulting Expert Currently used 20 years
Project Management Expert currently used 20 years
Business Analysis Expert currently used 20 years
Architect/ OLTP Expert Currently used 12 years
Databases Currently used 20 years
Data Modeling Currently used 15 years
Data Warehousing/ DataMarts Expert Currently used 5 years