Thomas Harvey Kregel Career
Mayo Foundation - Data Architect (14 years)
· Designed Department of Laboratory Medicine Data Warehouse and Marts
· Developed Web Services for the Plummer Project as Mayo transitioned to Epic.
· Also, in Plummer developed Epic interfaces and assisted in data conversion for this project.
· In Enterprise Data Trust, designed databases for data warehouse on IBM DB2 Server platform
. Cancer Center Data Mart
. Clinical Notes Data Mart
. Quality Infection Analytics Data Mart
. Supply Chain (2.5-year Agile project) Data Warehouse and Data Mart
MoneyGram / Intuitive Software Development - Data Architect (April 2007– Dec 2007)
· Designed model and develop several systems at MoneyGram
· Designed databases for existing applications on both Oracle and SQL Server platforms Integration Team for newly purchased Oracle Financials Applications to MoneyGram business needs
GMAC-RFC Shared Services / Intuitive Software Development - Data Architect (13 Months)
Designed and helped to develop several systems:
· Replace several existing systems for tracking BCG Business Group customer projects and loans to them. Customers were real estate development projects
· Designed Lending Compliance System to evaluate mortgages evaluating conformance to Federal, State and Local usury regulations
· Designed database for Tracking projects under several BCG financial products
· Designed unified Contact Management system to be used by the above plus other databases
· Developed ETL for local data warehouse
· Coordinated schema modification with DBA team
· Developed stored procedures for Contact Management system
· Developed stored procedures for SQL Server Compliance System
· Developed Source to Target Mapping for Compliance data warehouse reporting system
Children’s Hospital / Intuitive Software Development - Data Architect (8 Week Project)
· Designed and prototyped a Data Mart to track patient flow through Emergency Room and Surgery Units using Oracle 9i and ERWin.
Wells Fargo / Intuitive Software Development - Data Architect (13 Months)
. Architectural Lead on a corporate system integration team at Wells Fargo's Trust Division.
· Worked with Wells Fargo team to create and maintain a data warehouse of 2000 retirement plans covering 4 million participants. Initially we imported 100 plans as the result of a corporate merger. In Phase 2 we standardized existing Retirement Plans and imported them to the Oracle 9i / Linux System.
· Tools used: Embarcadero ER Studio, Oracle Stored Procedures, Oracle Data Loader, Oracle Enterprise Manager, Embarcadero DB Artisan
· Conducted requirements analysis, designed the Oracle tables, indexes and constraints, analyzed and implemented the reference data, documented the Source to Target mapping, documented the Metadata and tuned the Stored Procedures.
Wells Fargo's Enterprise Data Warehousing Unit / Intuitive Software Development - Data Architect (12 Months)
· Worked on a warehousing team at Wells Fargo's Enterprise Data Warehousing Unit
· Worked with Wells Fargo employees and consultants to create and maintain multiple data warehouses and data marts for central corporate system
· Tools used were Datastage ETL, UNIX, DB2 Scripting and CSV Repositories
Wells Fargo / Bluestem Systems - Data Architect (12 Months)
· Produced an Enterprise Scrub System. This system combined various Wells Fargo internal sources with state 'Do not call' sources to produce a single scrub system that mailing or calling lists could be submitted to before using them to solicit new business.
· Tools involved were Perl, Syncsort, UNIX, and the Redbrick database.
Fair Issac - Data Architect (2.5 years)
· Designed the MS SQL Server database for MyFICO.com, the first public facing credit reporting system in the world. This is a very successful project which integrates MS Commerce Server, MS Content Management Server, and Fair, Isaac's own credit analysis systems
· Designed and maintained Oracle data warehouses for Smith & Hawken, Aetna Insurance, AAA Mid-Atlantic Insurance
· Maintained DB2 UDB data models for American Family Insurance and Principle Financial Group
Cargill / Intuitive Software Development - Technical Architect (9 Months)
Rejoined the Cargill Lynx project as Technical Architect. The various roles over the eight months included:
· Designed and led Futures Positions Data Warehouse and Marts
· Led the sub-team in development of ETL stored procedures.
· Performance tuning the ETL. This reduced their nightly and monthly batch cycles from 40 hours down to 16.
· Research and repair of Lynx project production and development bugs
· Mentor to less experienced members of team including on-boarding and best practice seminars.
3M / Intuitive Software Development - Technical Architect (7 Months)
The various roles over the 6 months in Healthcare Products included:
· Sybase DBA
· Developed and documented coding standards for all data access via stored procedures and shell scripts
· Trained permanent staff for maintenance and support
· Data modeler on batch pricing interface
· Performance tuning
· Development of UNIX CRON jobs, supporting shell scripts and Sybase stored procedures
· Brought results in on time and well under budget
Cargill / Intuitive Software Development - Technical Architect (5 years)
Rejoined the Cargill Lynx project as Technical Architect.
· Represented DBA team as Technical Architect on Futures & Positions sub-team
· Developed and documented coding standards for all data access via stored procedures and triggers
· Trained over 200 stored procedure / trigger developers in Lynx coding standards
· Promoted to Senior data modeler on project, trained new employee modeler at departure
· Conducted seminars for developers regarding performance enhancement in data access
· Assisted with offsite benchmark tests
· Advisor to entire team on performance enhancement
· Conducted code walk-throughs on all data access code changes to ensure performance and reduce logical errors
· Assisted Application Support Team during final rollout
Eagle Foods / SHL Systemhouse - Senior Systems Engineer (5 Months)
Worked on project as a data modeler / designer / developer / team lead. The production system was a warehousing / ordering / inventory / distribution system for a large food store chain on an Oracle 7 DB environment on Sun UNIX replicating to 93 Microsoft SQL Server/NT servers at each individual store.
· Designed and built user interfaces using Oracle Forms (Developer 2000)
· Designed and developed data models (Designer 2000)
· Designed and built interfaces between central Oracle D and remote MS SQL Server/NT platforms using Oracle PLSQL and Oracle Pro-C
· Led a team of 5 developers in implementation of design
· The production system is a warehousing / ordering / inventory / distribution system for a large food store chain on an Oracle 7 DB environment on Sun UNIX replicating to 93 Microsoft SQL Server/NT servers at each individual store.
Carlson Companies / SHL Systemhouse - Senior Systems Engineer (2 Months)
Worked on the Carlson Eagle project as a data modeler. During the 5 weeks on this project developed data models using the LBMS case tools system. The production system was an Oracle 7 DB environment on a UNIX platform.
Cargill / SHL Systemhouse - Senior Systems Engineer (3 years)
Worked on the Cargill LYNX project as a data modeler / DBA.
Over the 2.9 years on this project:
· Developed data models that had to be integrated into a system of over 900 tables
· Worked closely with object designers to interface relational tables with Smalltalk objects
· Insured relational data integrity by building an auto-generation tool to maintain the 3000 required triggers
· Designed and developed Sybase open server applications in C
· Wrote and tested over 1000 Sybase Transact SQL stored procedures and specialized triggers
· Acted as DBA to as many as 20 data servers simultaneously
· Performance tuned numerous stored procedures and triggers
· Managed the release to System Test, Office Test, and Production of over 8000 database objects
· CASE tool to Sybase interface designer/ developer in UNIX environment
· Production system was a Sybase System 10 DB environment on a 150+ node distributed database system which employs asynchronous replication via Sybase Replication Server.
Healthcare Compare Corporation / SHL Systemhouse - Systems Analyst (5 Months)
Developed an accounts receivable system at Healthcare Compare Corporation in Chicago Illinois. Assisted the client in developing the data model for an interface between an EDS billing system and an Ingres relational database system.
· Designed and developed data access and entry screens in the MS Windows environment
· Designed and developed an Embedded SQL/C set of programs for converting the EDS data and entering the Ingres System
· Trained Healthcare Compare employees in C and Embedded SQL enabling them to maintain the code he had written
Hartford Steam Boiler Reliability Technology / Intuitive Software Development - Programmer Analyst (15 Months)
· Developed applications in Ingres in a VAX and UNIX environments
· Developed reports in Embedded SQL/C
· The application was a turnkey Fleet Management System for customers with large fleets of motor vehicles and related equipment. Typical customer was a large city government or corporation. System tracked all aspects of maintenance, fuel/oil consumption, repair scheduling, depreciation and disposition, parts inventory, fuel inventory, and bar coding.
3M / Intuitive Software Development - Programmer Analyst (5 months)
Developed applications in Ingres in VAX and UNIX environments at 3M Corporation. He also developed reports in Embedded SQL/C and Embedded SQL/FORTRAN. The application was a document tracking system. Further details are confidential.
Seagate Technologies / Cap Gemini Inc. - Programmer Analyst (13 Months)
Developed applications in Ingres at Seagate Technologies. He also developed reports in Ingres Report Writer and consulted variously on performance tuning. The applications were related to marketing analysis for sales of disk drives.
Digital Information Systems Corporation / Intuitive Software Development - Programmer Analyst (12 months)
· Developed applications in Ingres in VMS and UNIX environments at Digital Information Systems Corporation
· Developed reports in Embedded SQL/C
· Assisted in performance tuning
· Application was a turnkey manufacturing system including Shipping, Receiving, Inventory, General Ledger, Accounts Payable, Accounts Receivable, Order Entry, Bill of Lading, Bill of Materials, and Shop Floor Management. Typical clients were large manufacturing corporations such as Kaiser Aluminum.
Minnesota Pollution Control Agency - Pollution Control Specialist (3 years)
Designed, developed and tested three systems for the Tanks and Spills section:
· Underground storage tank registration system
· Leaking underground storage tank remediation system
· Emergency spills hot line reporting system
In each Ingres project
· Designed the system tables
· Designed and developed the applications
· Designed and developed the reports
· Managed the process of conversion from the previous flat file system with a team of two data entry clerks
Midwest Financial Management - Computer Systems Director (12 Months)
Small financial planning firm designed and developed a database system tracking client’s insurance, investment, tax, and personal information. He designed the tables, built and tested the applications, and managed a team of two clerks in entering the data.
Exxon Production Research Corporation - Geophysicist (5 years)
Some IBM / FORTRAN , but mostly data quality QA in global geophysical field work.