Data Warehouse

Kenneth Hamermesh

**** * ******* *** #*, Lakewood, CO 80227 303-***-**** ******@*.***

Qualifications

As a 25+ year veteran of SQL based development, the objective has always been to always align

organizational goals with technology outcomes. Have been successful in building systems from the

ground up. Have assisted others to make projects successful. Have intervened to make project outcome

successful.

Skills

• SQL development and implementation proficiency.

• Stored Procedure building, query writing, tools usage expertise.

• Rapid Application Development and implementation focused.

• Business acuity.

• Data Analysis and Analytics proficient.

• DBMS usage: SQL Server (most recent), Oracle. Tool Usage: .Net, ftp, etc.

Experience

Klode-TRA-Manheim Nov 2003 to present

Designed and built the SQL back end and UI to enable imaging of all documents and photographs. Blobs

stored in partitioned views across 100+ filegroups, tables and files across multiple databases.

Built the SQL/XML back end to support B2B operations.XML is transmitted via Web Services. The XML is shredded/composed and processed with stored procedures utilizing table driven tag-table/column pairs.

Designed the original operation of a multi-source on-line auction system. The on-line auction system places Internet, Proxy and live bidders on an automated equal footing. Built the SQL back end to enable its operation, using Linked Servers across data centers.

Built a SQL data warehouse to integrate separated operations to a single public and customer facing entity. Built in real time data capabilities to and from the data warehouse. Enabled the data warehouse to act as a transaction processor for the customer, making the silos of data

transparent. Built back end reporting, provided data analytics.

Directed and built the scripts to merge separate business silos and SQL databases into centralized SQL databases.

Credit Management Group Jan 2001 to Oct 2008

Developed the SQL back end database for a credit card marketing and collections business. Stored

procedures used to create result sets for BI reporting and portfolio monitoring.

Created a SQL data warehouse of credit card transactional and performance data. The data warehouse supported the establishment and maintenance of credit decisions and the generation of daily financials.

Built the SQL back end to capture credit bureau data, analyze/score credit bureau and applicant data.

Built an automated ftp process to transmit, receive and process credit bureau data in real time.

United Membership Marketing Group Jan 1994 to Mar 2001

Built out UI and SQL back end to enable the rapid growth of a membership association and credit card

marketer.

Designed and implemented remote systems to tie partner businesses into a core system.

Directed and created a SQL data warehouse to combine customer and credit card

transactional data.

Evolved data warehouse into a “data distribution center” to support operational facets. Directed construction of back end reporting.

Used data analytics to determine/monitor credit policies.

CIO, responsible for an organization of up to 45 technologists.

Ken Hamermesh

2

Benefit Management Systems (BMS) Jan 1991 to Mar 1996

At BMS created (UI, SQL backend, reporting capabilities):

A claims processing systems for the “Colorado Eye Health Network”, a provider of eye care services to over .5M subscribers/dependents.

A doctor-patient outcome analysis system for Porter Adventist Hospitals, evaluating diagnostic/procedure

codes and outcomes.

A “generic” benefit management system to allow companies to self manage subscribers (employees), dependents and associated benefits.

A benefit management system customized for VEBA retirees.

An environmental field audit system used for Space Command, USAF.

Beginning the build out of systems for United Membership Marketing Group.

Education

Bachelor’s Degree U C Berkeley

Ken Hamermesh

Contact this candidate