|
Career Details
2006
- Present: DATABASE CONSULTING SERVICES - Independent Consultant/ IBM Gold Consultant/ IBM
Information Champion
7/08 - present: DB2 Performance Consultant
Engaged by CPT Global Limited for several
Fortune 100 customers to undertake MIPS reduction projects.
§
Identify expensive SQL statements using various software tools (Strobe, Freezeframe, Expetune, Apptune,
Detector etc).
§
Review
DB2 Subsystem Environment. Perform Health Checks.
§
Review
program code for inefficiencies
§
Present
and implement solutions.
Engaged
by HMNA for Mid-West Supermarket chain to identify and tune expensive SQL using EZ-DB2.
§
Reduced
Production DB2 CPU usage by 30% over 3 month period, resulting in a
reduction of assigned MSU’s and considerable
cost savings.
Engaged
by IBM Canada to support upgrade and new product install to HCM9, and DB2
9 for large government customer
2/06 - present: PeopleSoft Performance Consultant/DBA
For
various PeopleSoft Customers:
§
Supported upgrades of PeopleSoft
HCM 8.3 to 8.90
§
Performance Audits of PeopleSoft
Environments on DB2 for z/OS and DB2 for LUW
§
Architecture reviews
§
Performance tuning of a wide
variety of PeopleSoft processes.
§
Tested features of DB2 for z/OS V8
on PeopleSoft databases for IBM. Wrote White paper. Presented Webinar.
§
Tested features of DB2 9 for z/OS
on PeopleSoft databases for IBM. Wrote White paper. (Webinar presentation
pending)
§
Wrote 600 page e-Book
‘Monitoring, Optimization, Configuration and Architecture eBook for
PeopleSoft Enterprise Applications on the Mainframe.
§
Developed, marketed and conducted a
30 hour Webinar based on the book.
List
of clients appear on http://db-consulting.com/references.htm
2003-2006:
PeopleSoft/Oracle
§ Benchmarked the following
PeopleSoft products:
o HR Help Desk 8.8 on DB2 for LUW
o CRM 8.9 for Communications on DB2
for LUW
o Financials 8.9 “Day in the Life” on
Oracle 10g
o Payroll 8.9 on DB2 z/OS V8
§ This involved installing all
required software, implementing the PeopleSoft products, using the appropriate
operating system, DBMS, and PeopleSoft monitors to identify and debug
performance problems, and delivering an optimized product to customers
1989
- 2003: DATABASE CONSULTING SERVICES - Independent Consultant/IBM Gold Consultant
6/95
– 3/03: PeopleSoft Performance Consultant
For PeopleSoft customers:
§
Troubleshooted
performance problems, conducted performance audits, developed, marketed and
taught a 3-day Performance Monitoring and Tuning Class for PeopleSoft on DB2
§
List of clients appear
on http://db-consulting.com/references.htm
For PeopleSoft:
Benchmarked the following
PeopleSoft products:
§
Accounts Receivable 8
on DB2 for OS/390
§
Time & Labor 8 SP1
on DB2 for OS/390
§
Payroll 8 SP1 on DB2
for OS/390
§
HRMS 8 SP1 online on
DB2 for OS/390
§
Order Management 7.5
online on DB2 for OS/390
§
Accounts Payable 7.5
on DB2 for OS/390
§
Accounts Receivable
7.5 on DB2 for OS/390
§
Purchasing 7.5 on DB2
for OS/390
§
Billing 7.5 on DB2 for
OS/390
§
Benefits
Administration 7.5 on DB2 for OS/390
§
Financials 7
Application Server Sizing on DB2 for OS/390
§
Financials 7 Online
TCP vs SNA on DB2/OS390
§
Financials 7 Online on
DB2 for OS/390
§
HRMS 7 Online on DB2
for OS/390
§
Financials 6 Online on
Informix.
§
General Ledger 6 on
DB2/OS390
§
HRMS 6 Online on
Informix.
§
Payroll 5 on DB2/MVS
and DB2/UNIX 2.1.1.
§
HRMS 5 Online on
DB2/MVS and Informix
9/94
- 5/95: IBM (for GAP Stores) - DB2/MVS and DB2/2 DBA
§
Designed databases for
an inventory control system to support direct-to-store shipments for Gap
Stores. Environment was VISUALGEN, DB2/MVS, DB2/2, CICS, CICS/OS2 and DDCS/2.
§
Set up and supported
development database environment for the project on DB2/2 & implemented
on DB2/MVS
10/92 - 6/94: PACIFIC BELL - DB2/MVS DBA
§
Designed 100+ tables
for a Data Warehouse Marketing system. Largest table consisted of 1.1 billion
rows storing Usage and Revenue information. Used Bachman DBA tool for design
and documentation. Used DDF for distributed DB2/MVS access. Analyzed,
reviewed and tuned all processes accessing the database
7/92 - 9/92: MERVYNS - DB2/MVS DBA
§
Designed databases for
a Clearance Tracking system.
4/92: WELLS FARGO BANK - DB2/MVS Performance
Specialist
§
Undertook a performance
review for a Returned Checks system. Implemented improvements to the database
design, load process and SQL coding.
9/90 - 7/92: ACS (for CENTEX TELEMANAGEMENT) -
DB2/MVS DBA
§
Converted databases
for a telephone billing system from VSAM to DB2/MVS
§
Retrofitted several
programs with DB2/MVS checkpoint/restart logic.
4/91 - 7/91: PACIFIC BELL - DB2/MVS DBA
§
Converted databases
for a journalizing application from Honeywell IDS to DB2/MVS.
2/90 - 8/90: SAFEWAY - DB2/MVS DBA
§
Converted a VSAM based
promotion and allowances system to DB2/MVS for Safeway Stores.
2/90: RALEYS - SQL/DS DBA
§
Performed database
design and performance review for an Item Movement system.
4/89 - 1/90: LUCKY STORES - DB2/MVS DBA
§
Benchmarked a check
authorization system comparing the CPU utilization of DB2/MVS, VSAM and
IMS/DB.
§
Implemented automated
DB2/MVS Utility Generation system.
7/89 - 12/89: USS-POSCO - DB2/MVS and IMS/DBA
§
Wrote automated
utility generation system using Dialogue Manager/COBOL/REXX and CLISTs
1987
- 1989: COMPUTER TASK GROUP - Consultant DB2/MVS DBA
§
Designed databases for
a DB2/MVS/CICS/CSP Statement of Account system for SAIF Corp.
§
Designed databases for
DB2/MVS/CICS/COBOL performance benchmark application for a Canadian oil
company on behalf of IBM, Canada.
§
Supported a
DB2/MVS/QMF pilot application for Glendale Federal Bank
§
Installed DB2/MVS and
QMF, established the DB2/MVS environment (standards, procedures, security
etc) for USS-POSCO and SAIF
§
Developed disaster
recovery procedures, and recommended system performance enhancements for
Kroger
§
Supported
implementation of a customer order system for AT&T
1980
- 1987: LUCKY STORES - IMS & DB2/MVS DBA and Manager
§
Managed up to 15
people in the Database Group, including the Design, Technical Support,Data
Administration and Development Center functions.
§
Led a project to build
a Corporate Data Model using "BSP" and "SISP"
methodologies. Developed 5 and 10 year software technology plans.
§
Performed DBA tasks
(design, support, troubleshooting) in an IMS DB/DC,PL/1 and COBOL
environment. Supported the implementation of DBRC, Datavantage, SHRINK,
Database and Block Level Data Sharing. Developed and conducted numerous
advanced IMS and DBRC classes
§
Set up the DB2/MVS
environment. Established standards and procedures for DB2/MVS, including naming
conventions, security, backup and recovery, programming guidelines etc. The
environment included DB2/MVS, CICS, IMS/DC, TSO, QMF, DBEDIT, DXT, DB2PM and
CSP.
1975
- 1980: ALTERGO LTD - Programmer/Analyst
§
Worked for clients including
IBM, Rowntree-Macintosh, British Leyland, Aramco, Lucas, Fodens and Lucky
Stores on a variety of applications. All programming was done in PL/1, COBOL
IMS DB/DC. Also taught PL/1 and IMS classes.
1971
- 1975: IBM - Programmer/Analyst
§ Programming and analysis of
financial and inventory control systems using 1401 Autocoder and PL/1.
| 
