Ralph E. Bertrum
15 Fishing Trail
Stamford, Connecticut 06903
Phone: I have homes and offices in New York, Connecticut, and Nevada.
Office Phone……………….………203-355-0559
Cell Phone...................................203-667-6453
Please contact me by e-mail.
E-MAIL: RalphEBertrum@aol.com
Website: www.cpsigroup.com
Mr. Bertrum is a Very Senior Business Management Consultant.
Providing OS/390, MVS, VSE, VM, CICS, and DASD Performance Tuning, Optimization and Efficiency of large scale Systems, Applications, and Data Centers resulting in Major Cost Reductions, Increased Productivity and Improved Services to end customers.
Mr. Bertrum is a VSAM and VSAM BASED, I/O Sub-system EXPERT Specialist, which includes KSDS, RRDS, ESDS, AIX, IMS, and DB2 Linear files. He has developed VSAM analysis Tools, which have established Standards for VSAM Processing. He comes to a Client Site with his own proprietary software and Improves CICS On-line Response Time, Batch run times, Transaction Throughput, CPU efficiency, MVS Performance, and saves DASD Storage.
Mr. Bertrum believes in a pro-active approach to Capacity and Performance Tuning.
He doesn't Measure or Monitor Performance, he improves Performance. He doesn't Plan Capacity, he reduces the need for increased Capacity. He has built his own Proprietary VSAM ANALYSIS Software and Expert DataBase to provide Major Efficiency, Optimization, Performance and DASD Storage Improvements.
Benefits to Clients include Improved Processing, Faster On-line Response Time, Greater System Availability, Fewer ABENDS, Improved Service Level Agreements, more timely project completion, and Hardware (CPU and DASD) Upgrade delays.
He is an expert in IBM, EMC, Storage Tek, Iceberg, RAID, and Hatachi DASD Storage Performance and Optimization.
He has performed services for over 600 major data centers.
He has worked for data centers using in excess of 20,000 MIPS and 50 Tera bytes of DASD Storage.
LATEST SOFTWARE HAS DRAMATIC RESULTS:
Mr. Bertrum's NEW Software, TURBO BATCH JCL ANALYZER has been used for five clients. VSAM files were identified with problems and fixed.
One client reduced the I/O on one file from 8,223,122 per day to 1,372,444 per day.
The second client had a job runtime drop from 3.5 hours to 51 minutes. This shifted the whole workload and dropped the total average MIPS being charged for by the Out Sourcing Company and reduced the monthly bill.
The third client reduced a Job run time from 4 hours to 21 minutes. This got the job back within the SERVICE LEVEL AGREEMENT.
The fourth client was submitting 12 batch jobs 8 times a day to run against CICS online files. Each time the jobs were run, CPU spiked to 100% for the entire machine. This would last until the jobs finished. Usually about 20 minutes, 8 times a day. The TURBO BATCH JCL ANALYZER identified the problem. The jobs now run in 3 and a half minutes and the spiking is gone.
The fifth client had JOBS waiting in the QUEUE for hours. The Software found the problem and pushed back the start time by 3 - 4 hours.
Mr. Bertrum is the inventor, designer, and developer of:
TURBO CATALOG ANALYZER - Identifies VSAM Catalog Errors
TURBO VSAM ANALYZER - Efficiency Optimization of VSAM
TURBO CICS ANALYZER - FCT and Shut down STATS analysis
TURBO CICS ANALYZER - Look-a-side Hit analysis
TURBO CICS Region Contention Analyzer
TURBO DB2 Contention Analyzer
TURBO BATCH JCL ANALYZER - Checks and improves 150 PARMS
TURBO JESLOG ANALYZER - Finds Possible Improvements
TURBO CONTROL CARD LIBRARY ANALYZER - Finds Improvements
TURBO PROC LIBRARY ANALYZER - Finds Improvements
TURBO DASD STORAGE ANALYZER – Saves DASD space
THE KINDS OF THINGS TURBO VSAM ANALYZER DISCOVERS:
TURBO discovers VSAM files where hardware upgrades have been made without the appropriate adjustments to file parameters.
TURBO finds VSAM parameters in use, which have not been used in modern data centers for the past 15 to 20 years.
TURBO finds VSAM parameters, which waste DASD, clog cache controllers, and cause massive unnecessary I/O's and EXCPS.
TURBO finds VSAM files with unnecessary and/or incorrect FREESPACE settings resulting in wasted DASD, unnecessary EXCPS and I/Os, and excessive application housekeeping CPU overhead.
TURBO finds VSAM files, which have grown over time, without the necessary adjustments to space allocation, FREESPACE settings, and index control interval sizes.
TURBO finds and identifies VSAM Catalog errors.
TURBO identifies VSAM files with broken Catalog entries.
TURBO finds and identifies VSAM files with incorrect data control interval sizes.
TURBO finds VSAM files using the spanned parameter, which should not, and files not using it which should.
TURBO finds VSAM files, which have been defined with typos resulting in incorrect settings.
TURBO finds VSAM files, which have not been reorganized in quite a number of years.
TURBO finds improvements to User Catalogs.
TURBO finds improvements to VSAM based System Files such as: CICS, TSO, SMS, DB2 DCAWORK, USER CATALOGS, etc.
TURBO finds VSAM files with excessive numbers of extents.
TURBO finds VSAM files, which have no or incorrect numbers of buffers resulting in slow processing speeds.
TURBO finds On Line VSAM files, which waste space in CICS LSR Buffer Pools.
TURBO finds VSAM files defined in TRACKS, which should be defined in CYLINDERS and vice versa.
TURBO discovers VSAM files with excessive CI and CA splitting, which can be greatly improved.
TURBO can identify file naming convention problems.
TURBO finds completely empty or over allocated VSAM files.
TURBO finds VSAM files with excessive I/O contention with other files.
The Batch JCL analyzer identifies incorrect Region Sizes, Blocksizes, buffersizes, old space parameters, alternate utilities, improvable sort control cards, and greatly speeds throughput.
MR. BERTRUM PROVIDES AN ABSOLUTELY FREE ANALYSIS FOR ANY CLIENT.
His broad range of experience includes:
· MVS Performance measurement and tuning.
· Performance, Optimization and Efficiency Audits.
· Software Developer of Performance, Optimization and Efficiency Tools. ( TURBO ).
· 15 Years of Technical Sales Support for a Major Software Vendor and his own products.
· Online Response Time Audits.
· Overnight Batch Runtime Audits.
· DASD Optimization Audits.
· Capacity planning and design.
· MVS Systems Programmer.
· DOS/VSE Systems Programmer.
· VM Systems Programmer.
· CICS Systems Programmer.
· EDOS Systems Programmer.
· Technical Installation Manager for Major Software Vendor supporting 2,500 clients.
· Development and Implementation of systems in a wide variety of application areas.
· In-depth, Hands-on experience in Hardware, Software, and Function-Specific packages.
· Over ten year’s actuarial systems and applications experience.
HARDWARE:
IBM 303X, 308X, 309X, CMOS, ES9000, 4321, 4341, 4381, 360-XXX, 370-XXX, Magnuson M/80, 3380 DASD, 3390 DASD, EMC DASD, ICEBERG DASD, RAID DASD, NAS 80XX, 90XX, AMDAHL, WANG VS/100, IBM PC/XT, PC/AT, IBM 1401, 402, 407, 602A, 088, HP-3000, TRS 80-II, IBM SYS34, SYS 36, SYS 38, Data General S360, Honeywell 62xx, DEC PDP 11/23, PDP 11/70, PEGASUS TURBO XT-8.
SOFTWARE:
MVS/ESA, OS/390, COBOL-II, COBOL 68, COBOL 74, RPG, RPG-II, RPG-III, BAL, RMF(Resource Monitoring Facility), SMF(System Monitoring Facility), MXG, MICS, ENDEVOR, ASSEMBLER, BATCH LSR, BOOLE & BABBAGE, CICS LSR, DATA IN VIRTUAL, TMON, OMEGAMON, IDMS, ADSO, OS/VS1, OS/VS2, OS/MVS, OS/MVS/XA, OS/MVS/SP, TSO, ISPF, TSO/ISPF, PANVALET, DOS, DB2, DMS, EMERALD, FAST ACCESS, FASTSW, FASTVSAM, DOS/VS, DOS/VSE, DOS/VSE/SP, VM, CICS COMMAND LEVEL, CICS MACRO LEVEL, IMS/DB/DC, HARDWARE COMPRESSION, HSM, HYPER-BATCH, IMS/DB/CICS, RACF, ACF2, ADABAS NATURAL, LIBRARIAN, CMS/EXEC, CMS/EXEC2, OS and DOS, HYPER-BUFF, HYPER-CACHE, VI/O PLUS, JCL and UTILITIES, RSX, MICRO RSX, TRS-DOS, MS-DOS, TOPS-10, TOPS-20, DPL, EDOS, ECON, $IAM, ICEGENER, ICF CATALOGS, INFOPAC, INFOPAK, NDM, EDOS/VS, EDOS/VSX, PMS, CMS/XEDIT, ICCF, ETSS, PDMS, ROSCOE, OWL, RSTS/E, PWS, SAM'S COMPRESS, SHRINK, SMS, SOFTWORKS PSP, EASYTRIEVE, AUTOCODER, IDMS/R, OS/MFT, IMS/DL1, BMS, JES2, JES3, HASP, VSAM, IDCAMS, ISAM, STROBE, ULTIMIZER, VIO PLUS, VLF, VSAM ANALYZER, GSAM, QSAM, HIDAM, DYNAM-T, DYNAM-D, TAPS, CA-SORT, CA-EARL, SYNCSORT, DF-SORT, EXTRACTO, DBASE-II, DBASE-III PLUS, MULTIPLAN, HARVARD PROJECT MANAGER, PFS, Microsoft WORD, Microsoft EXCEL, Windows 3.XX, Windows 95, Windows 98, Windows 2000, Windows NT.
PACKAGES:
GEAC: Formerly Dun and Bradstreet:
Management Sciences
Payroll, Personnel, Benefits, Labor Relations, Time and Attendance, Labor Distribution,
General Ledger Interface, GENERAL LEDGER, ACCOUNTS PAYABLE, Accounts Receivable, Fixed Assets, P/C Front End, and INFORMATION EXPERT REPORT WRITER ( IE ) and MANAGEMENT REPORT WRITER ( MRW ).
McCormack and Dodge ( M&D ) ( M Series ):
MILLENNIUM, GENERAL LEDGER, ACCOUNTS PAYABLE, FIXED ASSETS, Human Resources, Payroll, Personnel, Benefits, Purchase Order, ACCOUNTS RECEIVABLE, Auditor Report Writer, Query Print, Management Report Writer, MRW, SDT, MULTI-MILL, and PC LINK.
INFORMATION SCIENCES - InSci - Payroll, HR, Human Resources, Pension
Administration ( PAS ), Personnel, Benefits, GRS Exec, General Retrieval System.
SYSTEMATICS - All mainframe applications.
ALLTEL - All mainframe applications.
Integral Systems Incorporated ( ISI ) - Payroll, Personnel, Benefits, Applicant Tracking,
PC Front end, and ASAP Report Writer.
Condata - Payroll, Personnel, and SWIFT Report Writer.
Insurance Systems of America - ISA - General Ledger, Accounting, Budget, and Cost
( ABC ), V5, Policy Management System ( PMS ), EXTRACTO Report Writer, and
OSCARS.
Seibles Bruce - Policy Management System ( PMS ).
Informatics - TAPS, and General Ledger.
The Wyatt Company - COBRA Administration System, COBRA Compliance system.
Automatic Data Processing - ( ADP ) - Payroll and Personnel.
Control Data Corporation - COADS General Ledger and Accounts Payable Systems.
Baxter Health Care - PCS - Patient Care System. All Baxter Mainframe Packages.
Data Design Associates - ( DDA ) - Accounts Payable System.
On Line Software International - Accounts Receivable, Accounts Payable and General
Ledger.
Hogan Banking Systems - All Mainframe Applications including Umbrella.
Tesseract - Payroll and Personnel applications.
Computer Associates ( CA ) all Mainframe Products.
Gentran - All Applications.
Supertracks - All Systems.
American Software, American Management Systems, PEGA Software, Florida Software,
And SAS.
EMPLOYMENT HISTORY:
Critical Path Software Incorporated.
Principal and Founder, 1986 to Present:
Clients include:
AegonUSA - Louisville, KY and Nashville, TN - Full data center performance audit.
Aetna Insurance Company - Hartford, CT - Omni LPAR Application audit.
American International Group ( AIG ) - New York City, NY and New Jersey.
International GEAC General Ledger - Performance tuning.
LMS back end audit and CPU reduction tuning.
Bell Atlantic - New Jersey - Performance tuning of a GEAC General Ledger System.
Banco Lambarda - Lambardia, Italy - Full data center efficiency audit.
Chase Manhattan Bank - New York City, NY:
GIS LPAR performance audit.
Auto Finance System - CPU and run time reduction tuning.
VISA card Cost reduction tuning equaling $ 535,000.00 per month in savings.
GEAC General Ledger tuning on merger with Chemical Bank cutting costs and
overnight runtime in half.
Chase Manhattan Bank of Texas - Arlington, and Houston, TX.
Performance tuning and run time savings on their PEGA system.
Chemical Bank and Manufactures Hanover Bank MERGER - New York City, NY.
Second largest bank merger in United States History. Performance tuning of combined
GEAC General Ledger resulting in 70% run time reduction and 50% in CPU
consumption.
Citi-Group - New York City, NY.
Performance tuning GEAC International General Ledger and Accounts Payable.
Dun & Bradstreet ( McCormack and Dodge ).
Performance tuning of Domestic General Ledger for 24 banks. GEAC.
Mortgage Loan system - Saint Louis, MO. - CICS response time audit and tuning
and overnight runtime resulting in major savings.
Student Loan system conversion tuning from IDMS to AMS ten engine system, largest
in the world to date. Reducing conversion time on an IBM ES9000 10 CPU machine from
7 days to 1 and a half days allowing the conversion to be completed and go into
production in a timely manner.
Citi-Group - Delaware, Maryland - Performance and efficiency Audit of entire Data Center.
Citi-Group - Singapore - Asia Pacific Technologies Data Center. Performance,
Optimization, DASD, and Efficiency Audit.
Citi-Group - Singapore - Credit Card processing Data Center. CICS Performance,
Optimization, and Efficiency Audit for Alltel Systematics Systems.
Citi-Group - Sydney, Australia - Australia Credit Card Processing Data Center. Full Data
Center Optimization and Tuning. CICS, DASD, CASHE, RAID, Alltel/Systematics Custom Systems etc.
Columbia Health Care HCA - Nashville, TN - Full Data Center Performance Audit.
Darden Restraints Corporation - Orlando, Florida - Full Data Center DASD, CICS,
Performance, Optimization, Tuning, and Efficiency Audit.
Depository Trust Corporation (DTC) - New York City, NY - Full MVS, DASD and CICS
Performance Audit.
First Data Resources Corporation (FDR) - Omaha, Nebraska - Full Data center Optimization
Audit.
First Union Bank - Charlotte, NC - Full Performance Audit of all 3 Data Centers.
Fleet Bank - Albany, New York - Full Efficiency Audit of entire Data Center.
General Electric Business Services - Fort Myers, Florida - DASD and runtime
Performance Tuning of one of the Largest Accounts Payable Systems in the World
saving $ 200,000.00 per year in DASD costs and speeding overnight runtimes by
3 hours per night.
General Electric Data Center - Louisville, KY and Cincinnati, Ohio - Full Performance Audit
of one LPAR.
Humana Health Care - Louisville, KY - Optimization Tuning of entire Data Center saving
CPU, CICS, DASD and overnight runtime.
Kemper Insurance - Chicago, IL - Performance tuning of OMNI system LPAR.
Kraft Foods Corporation - New York City, NY - Full Performance Optimization Audit.
Kraft Foods Corporation - Chicago, IL - Full Data Center Optimization Audit.
Merrill Lynch - New York City, NY - International General Ledger Performance Tuning.
Full Efficiency Audits on 2 Full Data Centers.
Metropolitan Life Insurance Company - New York City, NY - Full Efficiency Audit of one
LPAR.
NYNEX Telephone Company - New York City, NY - Optimization Audits for 3 full Data
Centers.
Oppenheimer Funds - Denver, Colorado - Full Performance, Optimization, and Efficiency
Audit of Data Center.
Sabre Airline Reservation System - Tulsa, OK - Full Data Center Performance,
Optimization and Efficiency Audit.
Salomon Smith Barney - New York City, NY - Full Performance, Optimization, and
Efficiency Audit for 2 Data Centers.
Texas Utilities - Mesquite, Texas - Full Data Center Performance Audit.
United Parcel Service - New Jersey - Full Performance Audit for 8 LPARS.
And several hundred other data centers and applications.
From 1959 thru 1986 Mr. Bertrum held many positions:
Professional and Business Experience:
For one of the top five largest companies in the world, provided performance improvements to one of the largest Accounts Payable systems in the world, resulting in a 3 to 4 hour per night shorter batch window and a DASD savings of $ 200,000.00 per year.
For a very large bank, provided a performance optimization of their VISA card application
resulting in a charge back savings of $535,000.00 per month.
For a very large Health Care Provider, identified major performance improvements for the
entire data center, resulting in faster CICS response times and faster overnight batch.
For a very large bank, identified performance improvements for an Auto Finance application, which resulted in a 39% run time improvement in overnight batch, while at the same time, there was a 150% increase in daily transaction volume.
For the largest bank in the United States, provided performance optimization services
for data centers located in New York, New Jersey, Australia and Singapore.
This performance optimization involved banking systems such as Mortgage Banking,
HOGAN, Loan-Processing, Tesseract, Systematics, Credit Reporting, and ATM on-line
Systems, with emphasis on DBS systems. As a result of this effort, all systems experienced a doubling of transaction volume while CPU consumption remained unchanged or was lowered.
Provided performance optimization services to the second largest bank merger in United States history. As a result of this effort, the MSA general ledger system, running 2,500,000 detail transactions per day reduced processing costs by half, while adding significant savings in CPU, EXCP's and clock run-time. Over night batch before tuning took 16 to 18 hours. After implementation of performance improvements it was reduced to 4 to 5 hours per night. The optimized systems reduced processing costs by over $100,000 per month.
Provided performance Audit and tuning for the largest M&D Multi-Mill system in the world
(over 1,300 files). On-Line Response Time per transaction was improved by 15%,
while volume increased by 40%. The project provided the client $50,000 savings per month.
For a major paper company, managed the installation and maintenance of an M&D Millennium applications and InSci version 10.0, converting from in-house legacy systems.
Conducted tuning of the above systems, which resulted in a 100% performance improvement.
Conducted a capacity and performance Audit for a very large New York hospital.
The architectural design included M&D's Millennium general ledger, accounts payable,
purchase order, human resources and fixed assets systems.
Identified several thousand performance efficiencies.
For a large record company, provided performance tuning services for their M&D Millennium, accounts payable and purchase order systems.
Assisted in the implementation of an M&D human resources system for a large sporting goods retailer. Provided performance tuning services for the entire Millennium system.
For a paper company, fine-tuned the performance of the existing M&D Millennium general ledger, accounts payable, purchase order, accounts receivable and fixed assets systems.
For a major holding company, managed and audited the conversion of two hundred banks
and insurance companies from Control Data COADS General Ledger to MSA General Ledger.
Installed the M&D human resource system for a local hospital.
For a publishing company, installed and managed the conversion on an IBM mainframe to the M&D Millennium general ledger and fixed assets system.
Designed and implemented a payroll and labor distribution system for a maintenance and food Corporation. Evaluated architecture alternatives and system requirements. Designed a front-end Union rate processing system to handle pay rates, union deductions and union entitlements for six hundred local union agreements, paying $1.5 billion payroll to 80,000 employees weekly. The technical environment combined two existing payroll systems (one of which was interfaced to Millennium), with transmissions from eighty sites.
For a large pet food company, planned and led the disengagement of a human resource system through a divestiture, and designed and managed the development of the new system. This included performing complete data and system analyses. Creating a new coding structure, conversions, test, parallel plans, and security systems, while managing separate corporate project teams concurrently. Staffing and training a new payroll department, training management and staff, creating a new users manual, purging corrupted data, and coordinating interfaces to outside services. The new payroll system was then performance tuned improving performance by 50%. This was done on time and within budget.
For a major telephone company, performance tuned MSA general Ledger, information expert, and accounts payable systems.
For a major publishing company, provided a performance tuning audit for an in-house developed IMS production control system.
Publications:
Bertrum, R., "Structured System Audit Methodology" 1986
Bertrum, R., "The Functional Audit Methodology," 1985
Presentations:
"Millennium Performance Tuning," Speaker,
M&D Tri-State Users Group, May 1988
"M&D Fixed Assets under Millennium Performance Tuning," Speaker,
M&D Tri-State Users Group, May 1988
"Millennium Performance Tuning," Speaker,
M&D Northeast Users Group, April 1989
"Turbo Tuning Your Data Center," Speaker,
Computer Measurement Group (CMG) Reno, Nevada, December 1999
Associations:
Member, Data Processing Management Association (DPMA)
Member, Independent Computer Consultants Association (ICCA)
Member, Human Resources Information Management Society (HRIMS)
Member, Human Resource Systems Professionals (HRSP)
Education:
B.B.A., Accounting, University of Connecticut, 1968
System and User Classes:
IBM CICS Command and CICS Macro Level courses.
Honeywell and NCR programming classes.
Dun & Bradstreet, Price Waterhouse, Yourdin Associates, Authur Anderson,
and General Electric Management courses.
InSci, MSA, M&D, ISI, ConData, and EDOS, user and system classes.
References: Will be provided upon request.