RSS
Username:
Password:

Menu

Home
Résumé
Personal
Board
Webcam
Links
Members

Powered by Apache Web Server

Powered by Slackware Linux

Valid XHTML5!

Valid CSS!

Matthew W. Froemsdorf


TECHNICAL SKILLS

Database Platforms: NCR Teradata R15.10 and earlier, SQL Server 2000, Oracle 9, MySQL 5.5.
Operating Systems: Windows 8/7/Vista/XP, Solaris, HP-UX, Linux
Development Languages: SQL, UNIX shell scripts (ksh), Pig, Hive, Perl, C, HTML/XHTML/CSS, CGI, PHP
Application Software: MS Office, Visio, ERwin, Teradata SQL Assistant, Teradata ViewPoint, BTEQ, TPT, Protegrity, Sparq, Flume, more.
Other Technical Skills: Data architecture, relational data modeling, physical RDBMS design, RDBMS administration, Linux system administration.

WORK EXPERIENCE

Froemsdorf Consulting, Data Warehousing Consultant

September 2015 - current
Managed, designed, and implemented various projects for customers using the Teradata relational database system.

At W. W. Grainger, Inc., served as technical lead during the development of a new data warehouse subject area prototype.

Teradata Corporation, Partner Integration Labs Engineer

May 2009 - August 2015
Provided technical consultation to Teradata partners in various industries. Created and presented technical training sessions to familiarize partners with Teradata features including indexes (primary / secondary / join / PPI / MLPPI), Teradata Utilities, Viewpoint, DBQL, new database features, and more. Reviewed partner data models in ERwin and assisted in the conversion of logical data models to physical data models. Worked directly with partners at the Teradata Partner Benchmark Center to configure their software for Teradata, capture and analyze benchmark results, and tune partner's SQL and data models for optimized Teradata performance based on benchmark results. Managed technical issues encountered by partners and drove issues to resolution. Supported partners included financial application software, healthcare database applications, ETL utilities, middleware packages, and enterprise operations software.

Froemsdorf Consulting, Data Warehousing Consultant

August 2005 - April 2009
Managed, designed, and implemented various projects for customers using the Teradata relational database system. Most of the independent work involved two long-term contracts.

At Siam Commercial Bank, served as technical lead during the implementation of the Enterprise Data Warehouse system.

August 2007 - present
Served as technical lead for the Database Administration team, including various DBA duties.

At Charles Schwab & Co., Inc., served as technical lead in the migration of various data marts from Oracle to Teradata.

February 2007 - August 2007
Led the migration of the Charles Schwab Asset Management data mart and Fixed Income data mart from Oracle to Teradata. Worked with database administrators to determine indexes, statistics, and partitioning to add to tables in the data warehouse, in order to improve performance for end-users. Used PMON and Explain facility to tune existing Teradata processes to optimize for performance. Created presentations and led training sessions to introduce new users to Teradata. Designed data feeds to load Teradata tables from Oracle tables or from flat files, using Fastload, Multiload, and SQLPlus. Designed physical data mart schema optimized for Teradata. Redesigned Oracle cursor-based stored procedures to Teradata set-based stored procedures. Worked with Business Objects developers to ensure that generated SQL was optimized for Teradata.

August 2005 - January 2007
Led the migration of the Charles Schwab Branch Manager Incentives data mart from Oracle to Teradata. Worked with database administrators to determine indexes, statistics, and partitioning to add to tables in the data warehouse, in order to improve performance for end-users. Used PMON and Explain facility to tune existing Teradata processes to optimize for performance. Designed data feeds to load Teradata from Oracle and vice-versa, using SQLPlus, Fastload/Multiload, FastExport, and SQLLoader. Designed physical data mart schema optimized for Teradata. Redesigned Oracle cursor-based stored procedures to Teradata set-based stored procedures. Developed a Linux-based framework for scheduling and managing development and production environments. Redesigned Microsoft DTS packages to use the new Teradata warehouse.

NCR Corporation, Senior Data Warehousing Consultant

January 2001 - August 2005
Managed, designed, and implemented various projects for customers using the Teradata relational database system.

At Safeway, Inc., implemented the industry's first "Active Data Warehouse" system on Teradata, designing a series of Fastload and BTEQ scripts to read data from an MQ Series message queue and load store transactions to the data warehouse in near real-time. Managed 12 Safeway employees and contractors in the Vendor Cost Analysis project, enabling profitability and margin analysis by UPC/store/date. Designed and programmed the Synchronization component of the Teradata Dual Active Facility, enabling the mirroring of tables across multiple Teradata systems for purposes of load balancing, redundancy, and disaster recovery.

At Albertson's, Inc., designed and implemented the Base Cost application area to enable profitability and margin analysis applications by UPC/store/date on the data warehouse.

At Warner Home Video, designed and implemented an application to recommend an optimized mix of home video titles by format for each store for various retailers based on historical and projected sales in order to maximize future sales.

At GAP Inc., modified the physical design of the Teradata schema supporting the Market Basket Analysis application. Improved report performance by a factor of 100+, causing reports which had required hours of system time for processing to complete in minutes.

Hyperion Solutions Corporation, Product Marketing Manager, Hyperion Essbase Technologies

August 1999 - December 2000
Marketed Hyperion software products within the Hyperion Essbase product family. Researched and documented market requirements for products. Created and executed product launch plans. Performed marketing responsibilities during product rollouts. Assisted on sales calls. Assisted Hyperion partners to enable integration between Essbase and partner tools. Educated Hyperion channel partners on Essbase positioning. Presented on Essbase architecture and functionality to both technical and business audiences.

NCR Corporation, NCR Wal-Mart Global Support Team, Data Warehousing Consultant

January 1999 - July 1999
Managed, designed, and implemented various projects using the Teradata relational database system for Wal-Mart Stores, Inc. Managed, designed, and implemented a project to measure performance of the world's largest database. Designed and performed data modeling and programming for a parts-tracking and events-tracking system for the NCR field support team.

NCR Corporation, NCR Wal-Mart Global Support Team, Data Warehousing Support Services

February 1997 - December 1998
Provided on-site support for the Teradata data warehouse at Wal-Mart Stores, Inc., the world's largest commercial data warehouse. Optimized performance of SQL queries, researched failed load jobs, and assisted in the development of database applications. Created a web-based performance monitoring utility fully integrated with the back-end of the Wal-Mart Retail Link system.

HONORS AND AWARDS

NCR Teradata Certified Master R12, V2R5, V2R3
Hortonworks Data Platform Certified Developer
Keynote speaker at Hyperion "Beyond Business Intelligence" conference, September 2000.
Speaker at NCR Partners User Conference, October 1998.
Graduated as Departmental Valedictorian from University of Arkansas Computer Systems Engineering Department, Summa Cum Laude, and named departmental "Senior of the Year", May 1997.

EDUCATION

University of Arkansas, Fayetteville, AR; September 1994-May 1997. B.S. in Computer Systems Engineering, May 1997. Cumulative GPA 3.94, Engineering GPA 4.0, C.S. Eng. GPA 4.0 on a 4-point scale. Class rank #1 out of 68.

REFERENCES

Available upon request.