|
|
|
DATABASE CONSULTING SERVICES |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Career Summary - Education - Hardware - Software - Other
Accomplishments - Career Details
Academic Education Professional Education Highlights
2006 - : DATABASE CONSULTING SERVICES - Independent Consultant/IBM Gold Consultant 2/06
– 04/08: PeopleSoft Performance Consultant/DBA For 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 Performance tuning of
DB2 V8 for z/OS upgrade Tested Performance
features of DB2 9 for z/OS on PeopleSoft databases for IBM. Wrote White
paper. Tested Performance
features of DB2 V8 on PeopleSoft databases for IBM. Wrote White paper.
Presented Webinar. Wrote 600 page e-Book “Monitoring, Optimization, Configuration and Architecture eBook for PeopleSoft Enterprise Applications on the Mainframe. Conducted 30 hours of
Webinars 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. Contact us at: |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
925-575-0232 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Copyright
© Database Consulting Services |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
PeopleSoft DB2 UDB DBA and Performance Tuning Specialists. Upgrades, Installs , Administration, Audits |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
