Sales Sql Server

Stephen Clark Jr.

*** ******* ****

Saint Louis, MO 63132

612-***-****

SUMMARY:

. WebFOCUS Senior Consultant with over 20 years of extensive industry

experience

. 7 years WebFOCUS Development experience - latest Release 7.6.2

. 20 years of Mainframe FOCUS Development Experience (Ranked in 95th

percentile on Cap Gemini FOCUS assessment test)

. 10 years of Visual Basic (VBA, VBScript and VB6)

. Database experience including: DB2, Oracle and Access, FOCUS, IMS and

VSAM

. Programming Experience: COBOL, JavaScript and FORTRAN, Crystal and C

Operating Systems: TSO, VM/CMS, Windows/DOS limited UNIX

. Good testing skills.

. Good communication and interpersonal skills.

EDUCATION:

BS, Computer Science, 1986

University of Missouri, St. Louis, MO

WORK EXPERIENCE:

February 2012 to September 2012

Neteffects, St. Louis, MO

Consultant Federal Reserve Bank

. Developed two versions of the MTS Combined Statement Excel Workbook, a

version for Windows and another for UNIX. The Unix version was

created using WebFOCUS 7.7 compound layout feature to load 18 reports

and 4 graphs into and excel workbook by reading CSV data stored in

Oracle CLOBs. The Windows version was created by streaming Oracle

BLOBs in an Excel Macro.

. Modified MTS Webfocus Reports and Graphs to save output in CSV format.

. Completed computer based Java course.

. Wrote utilities for processing Documentation.

January 2011 to September 2011

TechPRO, Minneapolis, MN

Consultant Target

. Developed Financial reports for Transportation Department using

WebFOCUS 7.6 in MRE Unix and TSO.

. Moved data between UNIX and Windows and TSO and Windows with FTP

scripts.

. Created mapping of FMS to DTM fields and developed SQL extraction

procedures for SRT project.

. Provided resolutions to technical problems arising from upgrades to

FOCUS in focexecs and JCL.

. Used VISIO for Flowcharting

. Built DataMarts for faster retrieval and to resolve Oracle timeouts.

. Wrote Excel Macro to automatically convert and transport an Excel

spreadsheet to WebFOCUS/Unix environment with master need for

reporting.

. Converted FMS Aging Access database to DTM and replaced manual ETL

with self-launching WebFOCUS extraction and loading for both MRE and

Reportcaster.

May 2010 to September 2010

Corporate Contract Services, Edina, MN

Consultant ECOLAB

. Update Report Caster reports to allow for Smart Dates.

. Revise Report Caster start-up profile to be used with Report Caster

pre/post processing option.

. Modify styling in reports to accommodate increased field lengths.

. Provide technical assistance to end-users.

. Develop focexecs to traverse Department tree structured database.

. (Taking Skillbuilder .NET classes currently XML Programming and

WebFOCUS Newsletter)

Dec 2009 - Jan 2010

BRC Distributors, St. Louis, MO

. Conversion of Access 2.0 Inventory and Purchasing system to Access

2007

Oct 2007 to Sep 2008

Fujitsu Consulting, San Jose, CA

Consultant NEC

. DSS PeopleSoft to LDW SAP WebFOCUS report conversion project.

. Phase I - Build Project Management Infrastructure

. Create a MS Access database to gather track and analyze requirements.

. Load fields used in SQL for PeopleSoft reports into MS Access

database.

. Work with DBAs to cross-reference PeopleSoft fields used in old

reports to equivalent SAP fields.

. Phase II - Develop WebFOCUS 7.62 financial dashboard reports.

. Used Developer Studio to create WebFOCUS prototypes to replace

PeopleSoft NVision Excel spreadsheets

. Created FOCUS MASTER FILE and MODIFY procedure to load a Chart of

Account hierarchy into FOCUS database for FML reporting.

. OLAP enable FML and regular reports and add FOCUS styling.

. Incorporate drill down, TOC and Excel Templates to WebFOCUS reporting

capabilities.

. WebFOCUS Templates provided the for real time updates to FOCUS Chart

of Account Database from Excel split Total Company summary reports

into separate department level spread sheets. (WebFOCUS templates were

implemented with VBA macros)

Apr 2000 to Jun 2007

Application Engineer Wells Fargo, Minneapolis, MN

. Developed a Feasibility report to show how the features in WebFOCUS

could enhance a VM/CMS FOCUS Accounts Payable system by providing

quick easy access to invoices data and images.

. Converted a VM/CMS FOCUS Accounts Payable system to a self-service

WebFOCUS 5.4 application called eService

. Created system design and developed a FOCUS 5.4 self-service

application e-Service (using Developer Studio) which incorporated HTML

launch pages (using FrontPage) validated with JavaScript, styled FOCUS

REPORTs with drill-down features, and MODIFY FOCEXECs for FOCUS

database maintenance

. Migrated eService FOCUS Database to SQL Server 2000

. Designed, coded and tested the SQL Server 2000 DTS packages of

eService.

. Collaborated on and participated in the implementation of WebFOCUS

Trusted Windows Authentication

. Made IIS configurations changes based on evaluation of IIS performance

counters.

. Monitored SQL Server performance and made tuning changes to SQL server

configuration

. Extracted eService user information from Outlook' GAL using VB/CDO

programs

. Created an ASP function to encrypt/decrypt eService URL's.

. eService was loaded with data extracted from UNIX People Soft,

downloaded with Direct Connect to windows, cleaned with VBScript and

loaded with SQL Server 2000 DTS packages scheduled daily as windows

tasks.

. Wrote a VB/CDO program to send text messages with the return code of

any abnormally ending eService Windows load task to on-call rotation

support staff

. Used Report Caster to schedule and send System Status Reports to

eService support via email.

. Installed Developer Studio and Report Caster 7.1

. Moved Report Caster 4.5 configuration files to 7.1

. Designed coded and tested the presentation layer of eService utilizing

JavaScript, ASP, and WebFOCUS.

. Developed back-up and purge utilities and log reports using VBScript.

. Designed an Access database for loading the relationship of any

eService object using parent/child table structure to allow sitemap or

org chart like display of documentation

. Wrote VBScript programs that parsed the eService directories for

called by/called called/from information in ASP, HTML, and focexecs to

be automatically pre-load eService Access documentation database.

Report/Table or View information was also loaded.

. Wrote a VB Forms to allow developers to add detail documentation on

objects each object

. Objects included in the documentation included: Connect Direct, DTS,

VBScript, ASP, HTML JavaScript, focexecs, masters, access file and SQL

Server 2000 Tables and Views.

. Wrote Word Macros to read eService Access documentation database and

write program documentation.

. Actively participated in meetings and demo presentations

. Adjusted SQL Server and IIS configuration settings based of feedback

from performance monitoring utilities.

. Provided technical support and guidance in CMS/FOCUS to Crystal

Reports 9 conversion

. Researched the impact of upgrading eService from WebFOCUS 4.5 to 7.6

. Provided technical support and project management for the Home Equity

Loan Participation VM/FOCUS application

. This project mainly included developing ad-hoc reports to address

exceptions in monthly data and reporting findings to management. It

also included making code changes based on changes in business

requirements or errors found during data analysis.

. As a Windows Macro developer, wrote VBA MS Office automation programs

for Access and Excel which included OLE interfaces, such as Outlook

Contacts for Time Tracking application, calls to Windows System

Information Functions and Windows API. Most Access database use

Forms, queries, reports macros and modules. Attachmate Extra Basic for

screen scraping data in old mainframe legacy applications that

required daily input in to excel spread sheets.

. In a R&D effort, attended Conferences, viewed Webcasts, and took CBT

courses.

Mar 1999 to Nov 1999

Maxim Group, St Louis. MO

Senior Consultant Laclede Gas

. Setup training classes for clients on usage of FOCUS programs JCL and

CLISTs that were developed during contract

. Translated VSAM and IMS copybooks to FOCUS master file descriptions

. Created and application that allowed allow all DB2 views in a catalog

to be translated into FOCUS Master Files in a background job.

. A Data Dictionary in FOCUS format was developed to describe usage of

Walker DB2 fields and to cross reference field to FOCUS programs.

. Income and balance sheet reports were written with data from Walker

DB2 system, using FOCUS FRL.

Jan'99 to Mar'99

Manpower Technical

Senior Consultant assigned to Minneapolis Post Office

. Inspected COBOL programs for Y2K code compliance

. Developed Word macros that automatically scan COBOL programs for Y2K

fields and highlights them

. Used Word Basic to convert COBOL programs (text files) to word

documents

. Analyzed JCL and copybooks to determine if the code correctly

addressed Y2K Post Office conventions

Dec'98 to Jan'99

Data Management Consultants Inc., St. Louis, MO

Senior Consultant Maritz

. Converted PC/FOCUS reporting system to FOCUS for Windows 6.4 to

incorporate new style sheet and GUI features of FOCUS for Windows

Mar'97 to Dec'98

McDonnell Douglas Technical Services, St. Louis, MO

Consultant

. Provided technical support for the Tax Forecasting System, property

Tax system and Tax Equalization System for the Corporate Tax

Department

. This support included documenting any changes to data or code,

performing month-end and year-end processing and creating interfaces

to TFS system (MVS FOCUS application) using EDA ODBC connector

. These interfaces incorporated features such as Word mail-merge and

Excel Forms, ODBC queries to Access and FOCUS using Excel Macros..

. Created Crystal reports to access G/L data stored in PeopleSoft.

Oct'96 to Apr'97

Intecon, Omaha, NE

Senior Consultant Union Pacific

. Converted a PC/FOCUS application with EDA link to MVS FOCUS 7.0

. The new system also incorporated Extra for Windows Hotspots, Extra

Basic, and PROCOM for Windows Scripts.

. Wrote utility programs to identify Focexecs requiring year 2000

changes

. Modified FOCUS programs to address year 2000 issues

Jun'96 to Oct'96

Cap Gemini America, St. Louis, MO

Senior Consultant Ralcorp

. Supported the CIA reporting system that used (COBOL/SPF/FOCUS/DB2)

. Support consisted mainly of analysis of customer, product, and sales

data, COBOL2 programs, SPF (panels, skeletons), FOCUS (masters, access

files, focexecs), JCL and CLISTs were also maintained.

. Provided Overall FOCUS support for Ralcorp operations which included

technical evaluations for FOCUS candidates, Help Desk support,

database administration and troubleshooting problems related to the

components of CIS which included FOCUS, DB2, IMS, DataCom, JCL and

PC/FOCUS

Apr'95 to May'95

SAYLOG, Houston, TX

Consultant Union Pacific

. Developed an implementation plan for the Integral/In FOCUS product,

which included test suites and procedures to assist in the

installation of new releases of InFOCUS, FOCUS and MSO

. Corrected existing problems in the Applicant Tracking MFD and modified

existing focexecs to allow successful operation of TableTalk and TED

. Added a Batch interface to InFOCUS for production reporting

. Created new reports which incorporated the Match facility to merge

data from several InFOCUS databases

. Installed the FOCUS FD translator and used it to create new MFDs.

Oct'94 to Feb'95

The Shurn Group, St. Louis, MO

Consultant Southwestern Bell

. Converted FIDS Management System form UNIX FOCUS to TSO FOCUS.

. This project involved modification of UNIX FOCUS Dialog Manager, Table

and Modify programs with embedded REXX, XEDIT, COBOL subroutines and

Script to TSO FOCUS programs with REXX/CLIST, SPF Panels and macros,

and COBOL 2 subroutines.

Mar'94 to Oct'94

The Shurn Group, St. Louis, MO

Technical Analyst Post Office

. Utilized FRL, Table, Dialog Manager, Match Modify and User written

Subroutines in various FOCUS applications.

. Converted Mark-IV programs to FOCUS and Lotus macros to Excel

. Wrote Pro-C programs that used dynamic embedded SQL to access Oracle

Tables

. Participated in the evaluation of XCOM, IBI EDA/SQL, and Oracle

Transparent Gateway as client server data migration alternatives

. Mark IV programs were translated to FOCUS programs.

Dec'90 to Feb'94

The Trane Company, St. Louis, MO

Systems Specialist II

. Designed, coded and implemented a batch FOCUS reporting system for a

DB2 manufacturing distribution system.

. This project required writing JCL, FOCUS MFDs and focexecs which

incorporated Dialog Manager, Match, Join and Table facilities.

. Created a Screen Scraper to capture data from an IMS legacy

application and save text files using EXTRA Basic macros

. Used the FOCUS VB Toolkit in Visual Basic application to load dBase

and FOCUS Files

. Provided assistance to users installing IBM PC software and

peripherals which included installation of Attachmate 3270 emulation

software for field clients

. Debugged software

. Acted as backup LAN administrator

Sep'89 to Dec'90

Citicorp Mortgage, St. Louis, MO

Programmer/Analyst, Treasury Systems

. Coded, tested and documented a multi-user system running under both

TSO and MSO.

. Wrote JCL utility programs to operate a sink machine, generate reports

and rebuild FOCUS databases.

. Created a Data Dictionary to serve as a development aid during the

specification phase and as a feed to ad-hoc reporting

. Prepared systems requirements and installation packages for a

simultaneous usage environment

. Interfaced with users to resolve problems encountered during program

development.

Jan'89 to Sep'89

Federal Reserve Bank, Audit, St. Louis, MO

EDP Auditor

. Developed and Alternative Selection plan for Credit Discount which

summarized programming language options based on current software

availability and future procurements.

. Prepared a Cost/Benefit analysis regarding the total vs. partial

rewrite of the Credit Discount System

. Wrote Project schedule, specifications and code in FOCUS, QMF and

IMS/FOCUS

. Converted Easytreive Plus/Panaudit (sampling, aging, compare) programs

to FOCUS

. Converted a mainframe based project management system to PC/FOCUS

. Wrote specifications for FOCUS system enhancements which included,

Business Needs, Alternative Selection and Feasibility reports

. Served as technical liaison to financial auditors

Nov'86 to Dec'88

Federal Reserve Bank, Data Systems, St. Louis, MO

Programmer/Analyst

. Analyzed, designed, programmed and implemented menu-driven cash

ordering and purchasing systems using FOCUS, ISPF Dialogue Management

Services and COBOL for online and batch environments.

. Wrote JCL procedures utilizing IBM utility programs to backup and

archive data, as well as, retrieval BMPs

. Wrote Logon CLISTs

. Served on Quality Assurance team to ensure adherence to Bank software

development standards, procedures and audit requirements

Student Programmer, Sales & Market Analysis - January 1982 to September

1985

Anheuser Busch, INC. St. Louis, Missouri

Designed an integrated FORTRAN and FOCUS system which extracted sales data

in card image format and compressed it for transmission over NJE Lines,

updated FOCUS databases (ETL) generated CA-Telagraf code and produced sales

forecasting reports. Designed and implemented a dot-matrix print driver for

production of connected-point time series. Converted a card based Sales

and Forecasting FORTRAN programs running on an IBM 1130 to and integrated

CRT, sense-switch based stored procedure application. Migrated IBM 1130

Sales and Forecasting FORTRAN programs to a MVS 360 online TSO application

Migrated online MVS/TSO FORTRAN Sales and Forecasting Applications to IBM

PC XT. Added 8080 Macro assembler subroutines to display connected-point

time series, Used Macro 8080 assembler subroutines to allow visual trend

line adjustments on time series using arrow keys

[pic]

Contact this candidate