Data Engineer

Stephen M. (Monte) Richardson

****************@*****.***

Home 518-***-****

Cell 518-***-****

. Personal Details

*** *. **** ******

Salem, NY 12865

. Work Experience

Dollar General

February 22, 2010 - present

Develop WebFocus reports for Store Operations dashboard using

Developer Studio tools including the report Painter. Reports

access 1010 Data source from a WebFocus Dashboard.

Develop small Maintain applications.

ABC Financial

November 16, 2009 - February 5, 2010

Develop WebFocus Reports for CRS Reporting application using

Developer Studio. Test reports for valid data and for compliance

with requirements; do production support and associated bug fixing

as required.

City of Philadelphia -

December 2008 - May 2009

Conversion of WebFocus Applications from AIX to windows - primary

effort in conversion of Focus databases from Focus in AIX to Focus

on Windows. The conversion process included the extract of data

for each path in a database in text format, the transfer of the

text files using an FTP tool from the AIX environment to an

appropriate directory structure on a windows server, the load of

the transferred data into corresponding databases on the windows

server using the WebFocus Modify language.

The design of the extract and load processes used a template for

the extract and a separate template for the load

Independent Consultant

Knights of Columbus

Developer - July 2007 - November 2008

Team Lead of group of 5 consultants developing reports for Knights

of Columbus Implementation September, 2007 - June 2008

Report Developer. The data extraction component of these reports

was complex - data base was not well designed for reporting

purposes so that most reports required a number of joins - in some

instances between tables containing transactional data. These

extracts needed to be coded in SQL for performance reasons. Nearly

all reports were executed under ReportCaster with distribution to a

library.

City of Philadelphia -

June 5, 2007 - July 2007

Development of maintain application for City of Philadelphia -

Development of several maintain applications for the Department of

Health Services.

Senior Consultant

September 25, 1995 - June 1, 2007

Information Builders, Inc in San Jose, CA

Consultant satisfying the needs of clients of Information Builders,

Inc (IBI) through the development of WebFocus reporting

applications. My general technical experience with IBI is

summarized below.

1. Design of reporting databases - my primary experience in

database design was for a reporting database running in SQL Server

in the windows environment. The database design was "star schema"

with between 6 and 10 fact tables and between 30 and 50 dimension

tables.

2. Development of ETL (extract, transform, and load) procedures to

load reporting database from source data on a scheduled basis using

Information Builder's Data Migrator tool.

3. Development of reporting environment including reports and user

interface for execution of reports using IBI's tools for creating

reports and developing user interface - use of java script and HTML

for front ends on reports.

4. Development of complex reports - complexity was sometimes

introduced by the challenges of extracting data from multiple

tables using joins or other techniques of merging data. For other

reports, the complexity was introduced by a format not easily

generated by the report writer. Experience with drill down and use

of CSS for styling of reports. Experience with IBI's Financial

Reporting Language.

4. Development of online maintenance applications using IBI's

Maintain language

5. Distribution of reports using IBI's ReportCaster product.

6. Training in WebFocus Architecture and Security

7. Project management - Information Builders methodology

8. Use of IWAY - for creating metadata, setup of adapters for MS

SQL, testing procedures, debugging execution problems by examining

configuration settings

9. Developed and taught Dashboard class for West Coast consultants.

10. Additional Skills: Experience with Developers' Studio and MRE

since their initial release 12-13 years ago.

The implementation of web based financial reporting for The

Department of Health Services at the State of California allowed

the elimination of the distribution of most paper reports and

provided access to current data as of the prior day's end of

business. The availability of the data online, in hardcopy, and

via excel led to a change in the culture of the Accounting

Department - time previously devoted to the acquisition of data

could now be committed to analysis.

Clients included State of California ( Department of Health

Services, Department of Conservation), US Navy - Strategic Weapons

Facility Pacific, Transamerica, Vision Service Plan, Blue Shield of

California, Chevron Chemicals, The Gap, Freightliner, Levi Strauss

& Co, and Packard Bell.

Specific skills used include MVS, VM, UNIX, DOS, Windows, REXX,

JCL, Microsoft Office, HTML, Java Script, MS SQL, Oracle, Data

Modelling,

Specific WebFocus Skills:

WebFocus Table language - have worked with this language since 1983

and possess extensive experience in laying out data for a reporting

format and in extracting data for reporting and other purposes.

I've had training in Advanced Reporting techniques with Information

Builders and in the internals of the report writer.

WebFocus Modify Language - used for loading Focus data bases and

other data sources. Extensive experience in the use of this

procedural language and training in its internals. Have worked

with this language since 1983.

WebFocus Dialogue Manager - scripting language used by WebFocus as

a "glue" to put applications together. Have worked with this

language since 1983. Have experience in the use of this language

to tie components of an application together and to generate

portions of code - sorts, verb objects, filters - for reporting

language.

WebFocus Maintain - Have developed applications using Maintain

Language - WebFocus language for maintenance of data with gui

interface

WebFocus Report Painter - significant experience in use of Report

Paointer to develop and style reports

Exposure to and some experience with Resource Layout tool for

laying out compound reports with multiple report and graph

components

WebFocus Style sheets - significant experience in use of Style

sheets to control styling of WebFocus reports including experience

in the positioning of report components for HTML and PDF format.

Experience in the use of SQL passthru - the coding of SQL to be

passed directly to a relational database when the WebFocus flavor

of SQL generated is not sufficient for performance or other reasons

Experience in the configuration of adapters and settings from the

WebFocus reporting server console.

Significant experience in the use of ReportCaster - the Information

Builders product developed for the automated distribution of

reports to e-mail and other sources.

Training and Experience in the use of DataMigrator - Information

Builder's ETL product. Have designed dimensional data warehouses

for MS SQL Server and developed ETL procedures in DataMigrator to

populate the tables.

Experience in the use of MRE - Informational Builder's Managed

Reporting environment that supports the creation of ad hoc reports

for end users.

Systems Engineer

Electronic Data Systems in Santa Clara, California

April 1992 to June 1995

Hitachi Data Systems Account, Santa Clara Account

Supervised a group of professionals responsible for desktop and end

user applications; directed the implementation of applications that

significantly reduced the workload in Lease Administration and

Traffic areas

At Hitachi Data Systems. Member of a Team responsible for

implementation of Oracle Receivables for Hitachi Data Systems

worldwide.

Systems Engineer

Electronic Data Systems in Houston, Texas

September 1990 to March 1992

Enron Account, Houston, Texas

Technical Lead of Group Supporting Enron Gas Marketing (EGM).

Directed enhancement of reporting capabilities and overall

efficiency of EGM's system for managing its nomination and trading

business.

Project Leader

Tenneco, Inc in Houston, Texas

January 1988 to August 1990

As an employee of the Information Systems group, supervised

contract professionals responsible for maintenance of spot market

allocation and control system; directed the streamlining of the

daily purchase allocation program to reduce runtime by 60%.

Systems Coordinator, Gas Purchase Administration

Tenneco, Inc in Houston, Texas

January 1986 to December 1988

Supervised group responsible for reporting gas purchase and gas

contracts information, departmental systems development, and

database support activities. Developed system application for

market out pricing, replacing manual pricing of 5,000 purchase

points.

Analyst, Gas Purchase Administration

Tenneco, Inc in Houston, Texas

January 1984 to December 1985

Developed database and management reports that enabled Tenneco Gas

Pipeline Group to control gas costs and make more informed

decisions on purchasing gas; wrote refund system that allowed

company to comply with federal refund orders; developed purchased

gas cost studies used to support gas cost adjustment filings with

the Federal Energy Regulatory Commission

Analyst, Rate Department

Tenneco, Inc in Houston, Texas

October 1979 to December 1983

Monitored and analyzed Depreciation, rate of return, cost

allocation, rate design, deferred tax and other issues in the

natural gas industry; developed computer model to automate

depreciation rate studies.

Rate Analyst

Texas Eastern Transmission in Houston, Texas

July 1977 to September 1979

Support company's rate and regulatory filings to Federal Energy

Regulatory Commission

Proofreader

Texas State Legislature in Austin, Texas

December 1976 to June 1977

Proofread bills, committee reports, resolutions for Texas

legislature.

Substitute teacher

Austin School District in Austin, Texas

September 1975 - November 1976

Secondary School Teacher (Math)

Indian Springs School in Helena, Alabama

September 1972 to May 1975

Taught Algebra I and Calculus at preparatory school.

. Education History

Lamar University in Beaumont, Texas

June 1966 to May 1970, BS Mathematics

University of Illinois in Champaign-Urbana, Illinois

September 1970 to May 1972, MA Mathematics

Contact this candidate