Title:Keith Krieger

abpyhj@r.postjobfree.com

Document

Source below

NAME: B. Klamm, Steven

ADDRESS: *** ***** ***** **. #***

ADDRESS

2:

CITY: Petaluma

STATE: CA

ZIP: 94952

CANDIDATE ID: 2250300

US CITIZENSHIP: US

Citizen

EDUCATION:

EXPERIENCE: 10

WILL RELOCATE: Yes - CA

JOB WANTED: Any

RATE NEEDED:

TELEPHONE: 707-***-****

EMAIL: abpyhj@r.postjobfree.com

HOMEPAGE:

COMMENTS:

HOTTEST SKILLS: SQL,Unix shell scripts

REVISION: 05-OCT-01

YOE: 10

RESUME:

DATA ARCHITECT/ANALYST

SUMMARY OF QUALIFICATIONS

Seven years as a data architect/analyst; proven ability to develop, modify and support

relational database programs, improving business productivity and controls.

Track record of achievement through effective teamwork, with excellent communication and

writing skills.

Quick learner with strong technical aptitude. Highly motivated to learn new skills and

programs.

Systems knowledge: Windows 2000, NT, 98, 95, Unix, Mac OS, and Linux.

Programming/scripting languages: SQL (Sybase, MS, Oracle), Visual Basic, HTML, XML, Unix

shell scripts, and Perl.

PROFESSIONAL EXPERIENCE

2001

-2001Senior Data Analyst, LifeMasters, So. San Francisco, CA

Extracted, transformed, and loaded (ETL), medical, pharmacy, and laboratory claims to

determine potential participants for LifeMasters' programs. Analyzed data to forecast

potential savings for new and established customers. Developed detailed, validated, and

customized reports for internal and external use. Recommended appropriate system changes

to update and enhance the current data ETL, and reporting processes.

2000

-2001 Data Warehouse/BusinessObjects Manager, BarterTrust, San Francisco, CA

Created a decision support database system, which consolidated remote legacy databases

and facilitated comprehensive Corporate-wide reporting. System included data conversion

from Paradox databases (native scripting), transmission of data files (ftp), loading data

into Oracle database (SQL Loader), with control and scheduling by NT and Perl scripting.

Reports were developed in BusinessObjects and distributed using WebIntelligence, a

browser based interface.

Designed transaction database using ErWin and Embarcadero Studio modeling tools. Worked

with engineering team to create logical db model based on UML domain model designed with

Rational Rose. Generated physical Oracle database from logical model.

Developed data conversion processes using DataJunction and Perl to support business

requirements of marketing department.

1999

-2000Financial Analyst, DresdnerRCM, San Francisco, CA

Developed Activity-Based Profitability application with Visual Basic. Application

connected to Sybase database and utilized Business Objects as the reporting front end.

Began design of data warehouse to consolidate disparate data sources such as investment

and financial department's MS SQLSERVER database. Began development of Web based

interfaces to data warehouse utilizing ASP and XML.

1998

-99Data Analyst, NextCard, INC., San Francisco, CA

Designed methods of data analysis for end users in Financial, Marketing, and Executive

departments utilizing MSSQL, Excel, Access, and Business Objects.

Implemented Business Objects as the integrated view of disparate data sources within

MSSQL, Excel, Access and text files; creating a comprehensive, accurate, and productive

knowledge base for the entire company.

Administered all aspects of Business Objects system, including installation and

configuration of clients, server and Web application server; designing Universes (object

oriented data sources); training users; maintaining individualized security options.

Delivered Ad Hoc SQL reports, supporting the requester's business requirements.

Developed file transfer procedures to remote mainframe site using ConnectDirect, FTP and

encryption techniques that allowed for secure transfer of sensitive customer data vital to

business initiatives.

Mentored junior database staff in SQL fundamentals and advanced query writing, increasing

their contribution to the company and advancing their career potential.

1998

-98Data Analyst, Anteon, Corp., Concord, CA

Developed database programs in Access and Visual Basic to track hazardous materials for

environmental department of U.S. Navy.

1993

-98Data Analyst, SYBASE, INC., Emeryville, CA

Developed relational database programs in SQL, Perl, PowerBuilder and HTML, improving key

business functions.

Worked closely with employees at all levels, identifying issues and driving solutions to

meet complex, evolving needs.

Created reports which improved order fulfillment, inventory management, tracking of

purchasing history, and other buying/planning tasks.

Supported Project Managers in multiple departments by developing customized reports that

provided specific cost factor data.

Improved relationships with vendors by designing reports that increased timeliness of

payments.

Effectively utilized database tools to translate SQL data into other applications,

including Excel

spreadsheets, aiding in financial decision-making.

Created work procedures and instructions, contributing to team effort which achieved and

retained ISO certification.

Served as technical representative on company-wide rollout team: tested, installed,

introduced and trained staff on new financial program.

Provided hands-on support, including installation and configuration, to PC, Macintosh and

Unix users throughout company.

1992

-93Research Consultant, KLAMM RESEARCH SERVICES, Berkeley, CA

Accessed Dialog and Lexis/Nexis, developing customized reports for business clients.

1989

-92Electronics Technician, UNISYS CORPORATION, Santa Margarita, CA

Performed testing and troubleshooting to component level of mainframe computer boards.

Operated and maintained computer controlled test systems.

EDUCATION & TRAINING

BA

in Technology and Culture, John F. Kennedy University (graduation pending, 12/2001)

Java Introduction, Learnix, 1997

C Programming, Learning Tree, 1996

Contact this candidate