 |
 |
 |
 |
 |
 |
 |
|
|
·
American
Family |
·
Eli
Lilly and Company |
·
Principal
Capital Management |
|
·
Century
Companies |
·
H&R
Block |
·
Principal
Financial Group |
|
·
CUNA
Credit Union |
·
Health
Care Associates |
·
Simply
Soup Company |
|
·
CUNA
Mutual Group |
·
Incentive
Innovations |
·
State
of |
|
·
Eckland
Consultants |
·
Mariners
Cove |
·
Stratagem |
|
·
Enterprise
Group Ltd |
·
Mutual
of |
·
ThedaCare |
|
Roles |
Project
Manager, Systems Analyst, Business Analyst, Data Architect (Data Modeler)
Database Administrator (DBA), Data Warehouse Architect, Developer, HIPAA SME |
|
Techniques |
Project
Management Professional (PMP) Certified, PMI Project Management Methodology
(PMM), Rational Unified Process (RUP), Object Oriented Software Engineering,
Functional Requirement Analysis, Technical Writing, Business Process
Analysis, Design and Reengineering, experienced in IE, IDEF1X and Chen
notation, Technical Architecture, Dimensional Modeling, Meta Data
Architecture, ETL |
|
Analysis/Modeling Tools |
Rational
Rose, Microsoft Office (Project, PowerPoint,
Visio), Project Workbench, Lotus SmartSuite, WordPerfect, Lotus cc:Mail,
MicroSystems CaLANdar, Patton & Patton Flowchart, |
|
Databases |
IBM
DB2, Microsoft SQL Server, Microsoft Access, Microsoft FoxPro, Borland dBase,
Borland Paradox, Cincom TOTAL, VSAM |
|
Development Tools (PC) |
Data
Junction, Microsoft Analysis/OLAP Services, OLAP@Work, Microsoft Access
(VBA), |
|
Development Tools (Mainframe) |
Cool:Gen
(Composer/IEF), SAS, Cobol, Cobol/DB2, Cobol/Total, CICS, VSAM, JCL,
Easytrieve, INFOPAC, NCR Tran-Pro |
Certifications
·
Institute for Computing Professionals (ICCP) –
Certified Computing Professional (CCP)
·
Project Management Institute (PMI) - Project
Management Professional (PMP)
·
Access
2000 Microsoft
Office User Specialist (MOUS) Certified
Education
Carroll College,
Masters of Science Degree,
Software Engineering Major. Major
subject areas included: Relational Database Design, Object-Relational Mapping,
Advanced Java, .Net and J2EE Programming, Software
Engineering, IT and Project Management and Networking.
Carroll College,
Bachelor of Science Degree,
Computer Science Major, Business Minor. Graduated Cum Laude. Major subject
areas included: Software Design and Development, Data Structures, Data Base
Design, Pascal, Fortran, Artificial Intelligence, Robotics, Management
Administration & Theory.
Waukesha County
Technical College,
Associate of Applied Science Degree,
Business Data Processing Major. Graduated with honors. Major subject areas
included: COBOL, Assembler, RPG II, dBase II and Systems Design and
Development. In addition to the
coursework, successfully completed a special project as the Project Lead, Lead
Designer and co-Developer. We developed
a database application (using dBase II) that tracked and reported information
about a local trucking company.
Memberships and Associations
·
Data
Management Association (DAMA) www.dama.org
·
Project
Management Institute (PMI) – www.PMI.org
Consulting Experience
Rehm Technology Consultant 1996
to Present
Rehm
Technology (www.rehmtech.com)
As a consultant for Rehm Technology, provide real solutions
to real business problems. Performed
various roles (project manager, business analyst, data architect, DBA, senior
data warehouse architect, meta data specialist, systems analyst, developer) in
the following projects:
State of
·
Responsible
for transition of health insurance systems towards HIPAA compliance.
·
Responsible
for the management, design, development and implementation of the Full File
Compare (FFC) Project. Data quality
improved to being the source of record and thousands of dollars were recovered
in the prevention of fraudulent claims.
·
Responsible
for the management, design, development and implementation of the Pharmacy
Benefit Manager (PBM) automated process. This process carved out the pharmacy
benefits from all of the health plans and was placed into one entity which
provides large volume savings to state employees and taxpayers.
·
Responsible
for the management, design, development and implementation of the Wisconsin
Public Employers (WPE) Project that added health insurance program options and
improved the health insurance premium reporting & accounting process.
·
Currently
managing and designing the conversion of the manual eligibility process to an
automated electronic process estimated to save millions of dollars due to
elimination of paper trail and in elimination of multiple data entry.
·
Currently
designing and implementing a long range health insurance vision that
incorporates the HIPAA initiative as well as providing immediate EDI, data
quality and process improvement solutions.
Paul Hauck PhD Ltd DUI Services,
Designed, developed and currently supporting an application to track patient visit and payment activity for multiple psychologists.
Simply Soup Company, Madison WI USA 05/2002 to present
Designed, developed and currently support a recipe and ingredient inventory cost management application that controls ingredient costs and increases profit margins.
Eckland Consultants,
·
Designed,
developed and currently support databases, operational applications and the
data warehouse for the architectural, engineering and environmental due
diligence business function.
·
Completely
redesigned the existing business systems and replaced with a custom solution
that met their end-to-end business needs.
Eckland Consultants now run their business on Rehm Technology software.
CUNA Mutual Group,
Performed an assessment of the
current operational data storage facility, the data load, cleansing,
transformations, summarization and Hyperion Essbase load processes.
Mutual of
·
Designed
and implemented an operational data store and meta data repository to support the
individual insurance division to provide ease of use and analysis.
·
Provided
the client with a methodology and repeatable process for modeling and
populating data tables for use by the end user community. The platform is easy
to use and has created many opportunities to implement streamlined business
processes and solutions.
·
Technologies
included SAS, Cayenne Groundworks, COBOL2, JCL, Visual Basic, IBM DB2/MVS and
Microsoft Access.
American Family Insurance,
Analyzed, designed and developed
Cool:Gen (Composer/IEF) code and DB2/MVS to enhance the existing Cash
Management application.
Enterprise Group Ltd
(www.egltd.com)
As a subcontractor, played many roles that helped shape the
strategic direction of the company. This
included the development of the company infrastructure and providing expertise
in project leadership & management, methodologies, engagement services and
account management. Played various roles (project manager, senior data
warehouse architect, data architect, DBA, meta data specialist, systems
analyst) in the following projects:
Eli Lilly & Co.
Managed and architected the design,
development and implementation of a global clinical trials data warehouse,
using Oracle DBMS and Business Objects.
ThedaCare,
Performed assessment of a health
care enterprise data warehouse implementation.
Delivered assessment results and high-level design options. Provided a meta data repository and
application for the HMO line of business.
H&R Block,
Managed the design, development and
implementation of a tax services data mart.
Principal Capital Management,
Performed assessment of current
data warehouse implementation. This
included business discovery, requirements gathering and desired state road map.
Principal Financial Group,
Designed and implemented a
financial data warehouse & meta data repository that supplies a unique
source of global integrated financial information that is easy to use and
analyze.
Stratagem
(www.stratagemnet.com)
As a subcontractor, provided data
warehouse and operational solutions to Stratagem clients. Played various roles (project
manager, data architect, senior data warehouse architect, DBA, meta data
specialist, systems analyst, developer) in the following projects:
CUNA Mutual Group,
Designed and developed the data
model and VB code to support an international policy administration
application.
CUNA Mutual Group,
Designed and implemented a data
warehouse and meta data repository to support the claims business function to
provide ease of use and analysis.
Technologies included Cool:Gen (Composer/IEF), COBOL2, SAS, JCL, VB, IBM
DB2/MVS and Microsoft Access.
Century Companies of
Designed and implemented a data
warehouse and meta data repository to support the securities business function
to provide ease of use and analysis. Technologies included Cool:Gen
(Composer/IEF), COBOL2, SAS, JCL, VB, IBM DB2/MVS and Microsoft Access.
Business Experience
CUNA Mutual Group,
Project
Manager, Data/Meta Data Architect, DBA, Technical Architect 03/1995 to 10/1996
Responsible for the design,
development, support and maintenance of an Enterprise Data Warehouse and meta
data repository. Performed all aspects of development in order to support the
business function. Technologies included Cool:Gen (Composer/IEF) toolset, COBOL2,
SAS, JCL, Visual Basic, IBM DB2/MVS, Microsoft Access and Cognos Impromptu and
Powerplay.
Project Manager, Data
Architect, DBA, Systems Analyst, Developer 06/1994 to 03/1995
Designed & developed a Marketing Data Mart that made
data readily accessible to the remote staff that needed it. This project
initiated the Enterprise Data Warehouse above.
Technologies included Microsoft Access, Visual Basic, SAS & IBM
DB2/2. Earned a Corporate Award.
Project
Manager, Data Architect, Systems Analyst 05/1994 to 04/1995
Quickly and effectively identified,
and resolved technical issues between physical sites on a large and complex
enterprise-wide Field Compensation project. Earned a Corporate Award.
Systems
Analyst, DBA, Developer 01/1994
to 05/1994
Designed and developed Client/Server applications using VB,
MS Access and IBM DB2/MVS on the IBM ES/9000 mainframe. DB2 tables were
accessed through IBM's DB2 Client Application Enabler, the DB2/2 ODBC driver
and the DDCS/2 gateway. Earned a Corporate Award.
Project
Manager, Systems Analyst, DBA, Developer 05/1993 to
01/1994
Managed, designed and co-developed
a CICS/DB2 Financial Institution Tracking system, developed in Cool:Gen
(Composer/IEF). Earned a Corporate
Award.
Project
Manager, Systems Analyst 01/1992 to 05/1993
On a large-scale implementation of
a GL software package, analyzed the international companies' computer systems
& business procedures. This resulted in financial restructured systems and
procedures that produced consistent reporting. Earned a Corporate Award.
Presenter 03/1992 to
03/1992
Selected by Senior Management to present,
and presented Cool:Gen (Composer/IEF) toolset and applications to a group of
Madison Area Technical College (MATC) instructors.
Project
Manager, Systems Analyst, Data Architect, DBA, Developer 01/1991 to 01/1992
Designed and developed a policy data Decision Support
System, which provided accessibility and ease of use. Worked with IBM’s IAA (Insurance Application
Architecture) data model and customized physical database as per company’s
needs and requirements. Technologies included: Cool:Gen (Composer/IEF), CICS
and IBM DB2.
Senior
Programmer/Analyst 12/1989 to 01/1991
Managed & developed Corporate P&C LAN-based applications using Clipper and dBase.
Programmer/Analyst 08/1988 to
12/1989
Designed, developed & implemented a large-scale LAN-based Accounts Receivable system (Clipper/dBase) reducing our client's manual labor by 50%.
OSI,
Programmer 01/1988 to 08/1988
Redesigned and developed Financial Report COBOL and JCL programs, which relieved a memory utilization bottleneck that reduced mainframe processing time by 50%.
Senior Computer Operator 08/1985 to 12/1987
While also attending college full-time, trained, directed and assigned work to junior computer operators. Created and submitted JCL for programming staff.
Marine
Bank,
Computer
Operator 09/1983 to 08/1985
Processed incoming checks through computerized financial sorting
and recording equipment, while attending college full-time.
Professional Training & Seminars
|
Year |
Training |
Instructor |
|
2002 - 2005 |
Completed Masters degree in Software Engineering |
|
|
2002 |
Wisconsin |
State of |
|
2002 |
Object and Data Modeling: Coming of Age |
Terry Moriarty - Inastrol |
|
2002 |
Project Management Professional Preparation |
PMI |
|
2001 |
Creativity Camp |
SkillPath |
|
2001 |
Data Warehouse Tools |
Pieter Mimno |
|
2001 |
Microsoft Analysis Services Boot camp |
Aspirity |
|
2000 |
Directing, Controlling and Managing Projects Conference |
SkillPath |
|
2000 |
Enterprise Integration & Web Development for
eBusiness |
Advisor DevCon |
|
2000 |
OLAP Workshop |
OLAP Train |
|
1999 |
Data Warehouse Project Management |
|
|
1999 |
SQL Server Users Conference |
PASS |
|
1999 |
Data Warehouse Tool Comparison |
Pieter Mimno |
|
1999 |
Data Warehouse World |
DCI |
|
1998 |
Data Warehouse World |
DCI |
|
1997 |
Developer Conference on Access, VB and SQL |
Advisor DevCon |
|
1996 |
Data Warehouse World |
DCI |
|
1995 |
Nuts and Bolts of Client/Server |
Richard Finklestein |
|
1995 |
AAM 132 – Automation in Insurance |
AICPCU – IIA |
|
1995 |
AAM 131 – Essentials of Automation |
AICPCU – IIA |
|
1994 |
Effective GUI Design |
Corporate Computing Inc. |
|
1994 |
RAD for Developers |
Corporate Computing Inc. |
|
1993 |
EDP Project Management |
John Palmer |
|
1993 |
Conducting Effective Meetings |
David Peck |
|
1992 |
Business Statistics |
UW-Madison |
|
1992 |
Applying Project Workbench |
ABT Corporation |
|
1991 |
Consulting Skills for the IS Professional |
Ouellete & Associates |
|
1991 |
Information Engineering Facility (IEF) |
|
|
1991 |
DB2 Programming and Design |
Automated Design Enterprises |
|
1991 |
ReEngineering the I/S Architecture |
Larry DeBoever |
|
1990 |
CASE: A Strategic Assessment |
|