Leonardo  DiGiovanni
220 Lily St

San Francisco, CA, 94102

415-522-1800 

QUALIFICATIONS
Applications Project Leader, Senior Programmer Analyst,
Technical Lead. Responsibilities included Systems Analysis and Design,
Application Development, supervising Junior and Senior P/A, directing Training
Courses, Job & Program Troubleshooting. Directed Information Center managing
4th Generation Languages, disk packs, files, and ACF2 security.

SOFTWARE:

 

PC’S: Front-Page,
Access, Word, Excel, Btrieve, Q&E, Procomm Plus, SPF-PC, Focus, Microsoft
SQL.

 

Mid-Range & Client-Server:
UNIX AIX, CRON, Korn-shell, Oracle, SQL (SQLPLUS SQLLOAD), BASIC-4, Business
BASIC, SYBOL, Manugistics 

 

Mainframe: Cobol
II, PL/1, Fortran, Focus, REXX, DYL-280, SQL,PC EXPRESS, ACF-2/Data Security,
PANVALET, DMS, IMS DB/DC, MFS, JCL, TSO, ISPF/Dialog Manager, CLIST, DB2, QMF,
Data-Expert, IMS-Expert, Expediter, IBM Utilities, Syncsort, DF Sort, Q&E,
SQL-Plus, ISAM,VSAM, BTS-II, ENDEVOR. 

 

HARDWARE:

     RS6000 Unix Aix 

     HP9000 Unix 

     IBM 390 and 3090
Series Computers 

     UNIVAC 1100
Series Computers 

     IBM PC's 

     Basic Four
Minicomputers 

 

EMPLOYMENT HISTORY     

     1998-2002 KITZEL
CORPORATION, (consultant) 

     1997-1998
COMPUTER MERCHANTS, (consultant), Boston, MA

     1996-1997
NORTHWEST SOFTWARE, (consultant) Portland, OR,
 97006 

     1996-1996
COMPUTER DYNAMICS, (consultant) Chatsworth, CA


     1993-1996 HOME
SAVINGS OF AMERICA,
Irwindale, CA, 91706


     1991-1993
COMPUTEC INTERNATIONAL, (consultant) Glendale, CA,

     1984-1991 COMPUTER PEOPLE UNL, (consultant) Milwaukee,
 WI

 





EDUCATION

     University
 Of Wisconsin – Milwaukee,  Milwaukee, Wisconsin


     Yourdon
Structured Design and Structured Programming. 

     Oracle's SQL Complex Queries and Procedural Options.

 

EXPERIENCE

 

KITZEL CORP 

Designed and created Web Pages
using Front-Page and Microsoft Access databases on PC servers for Real Estate
Property Management

 

CHARLES SCHWAB & CO / Kitzel Corporation 01/98 to 02/00 

Designed and implemented Production
and Test Environments for User Department for Y2K remediated batch and online
jobs in Cobol, Focus, and REXX. Coded
Syncsort programs for Y2K for date sorting for Brokerage Systems. Instituted
user-friendly ISPF panels for user entry of data of ad-hoc Focus and Cobol jobs. Remediated Focus programs for Y2K, and converted
user submitted clists to daily scheduled jobs. Consulted on
converting fractions to decimals for Stock Market data. 

 

INTEL CORP / Northwest Software 08/96 to 01/98 

Coded & Debugged Focus/DB2 and SQL
programs for manufacturing systems interfacing with Unix
systems using FTP. Created Jobs, Procs, Sort
procedures on MVS system for tracking and reporting on manufactured products. Reviewed
interfacing scripts on Unix subsystem. Assisted Business Analysts in determining and writing Process
Specifications.

 

NESTLE USA
/ Computer Dynamics 02/96 to 08/96 

Back office
support for manufacturing system on HP9000 UNIX system, tracking food products
and shipments. Wrote Korn-shell scripts for automated
job and program execution on UNIX for Manugistics roll-ups (data aggregation).
Created Jobs, Cobol/DB2 programs on MVS system, and
documentation. Maintained on-call production support for both Mainframe
and Unix systems. Assisted in
Disaster Recovery support.

 

HOME SAVING OF AMERICA
6/93 to 02/96 

On RS6000 UNIX system: Back Office
Lead in creating Production Environment for Client-Server Data Warehouse
project in Retail Product Pricing for fixed and variable loan products.
Designed and created directory structures, wrote Cron & Korn-shell scripts
for automated job and program execution on UNIX. Standardized file, job &
task names. Trained in PC Express and wrote PC Express programs for Data
Structure Rollups and data aggregation.

 

On IBM 3090 Mainframe: Organized, implemented
procedures and created file structures on mainframe for Retail Banking and
Lending Systems. Wrote FOCUS with DB2, COBOL II/DB2, and REXX programs to
aggregate data and transfer data (FTP to UNIX or Netview DM to OS2) to Oracle
for lending systems, loading DB2 and ORACLE tables. Designed and implemented
FOCUS databases, initiated Backup and Disaster recovery. Evaluated lending
information for high-risk loans and average turnaround times for loans in the pipeline.
Created Production Implementation with Endevor, file structures with GDG bases
and documentation using Visio.

 

SOUTHERN CALIFORNIA GAS / Computec
10/91 to 04/93 

Designed Logon-ID
and Rules interface system with ACF2 using ISPF Dialog Manager, Clists, and
REXX. Improved efficiency in implementing rules and Logon-Id's.
Diagnosed and resolved ACF2 problems, and JCL in production Jobs. Lead for
junior programmers in writing and debugging DYL-280 programs. 

 

J.I. CASE COMPANY / Computer People 09/89 to 06/91 and 6/87
to 9/87

Managed Information Center for
SAS, FOCUS, and EXECUCOM. Supervised 4 Analysts on
Help-Desk and projects. Aided programmers in designing FOCUS databases
and debugging systems. Installed FOCUS 6.0 and 6.5 and tested SAS 6.06.
Supervised and reviewed FOCUS and SAS training classes, and Crwth student courses.
Diagnosed ACF2 security problems and modified rules, assisted
in rules creation standards. 

 

Approved
Production Control Job installations. Developed standards for ACF2
rules, Info Center
dataset names, and DMS archive. Evaluated/prepared proposals
for purchase and elimination of MVS software products. 

 

Resolved
programmer problems with JCL, Syncsort, IDCAMS, IBM Utilities, and other MVS
system difficulties. Assisted users with Mainframe to PC data transfer
protocols. Diagnosed End User problems with spreadsheet and
word processing programs.

 

Designed systems and databases for
users and reviewed designs by programmer analysts in manufacturing environment.
Assisted users with Accounting, Cost Reduction, and Payroll
projects. 

Assisted in the design and
programming of a purchasing system using COBOL and IMS
 DC with a team of 2 other consultants.
Translated COBOL Database Master layouts into FOCUS
Masters. 

 

Designed a Cash Accounting System
to collect bank deposit transfer data and load into IMS database. Deposits were
then transferred to a concentration bank and database updated. Design included
IMS database with secondary indexes. 

 

System reported sales, reconciled
checking accounts, updated General Ledgers, and produced over a dozen reports.
Company's Commercial Paper and Bonds were also tracked and reported to company
Treasurer when neared maturation.

 

 

WISCONSIN BELL
TELEPHONE / Computer People 08/88 to 09/89 

Analyzed
Wisconsin Bell and Ameritech's toll and local calling usage. Created and
loaded DB2 databases for Midwest Information Warehousing System using COBOL and
IMS. Created FOCUS Masters for interface to DB2 Tables.
Verified information using QMF into DB2 Tables. Assisted users and programmers to write FOCUS programs. 





 

A.C. NIELSEN / Computer People 10/87 to 08/88 

Directed a team
to develop documentation for a store retrieval system in PL/1. Developed documentation from PC to Mainframe datasets.  Developed and programmed various information reports
using COBOL and IMS for reporting consumer statistics to companies. Performed maintenance on COBOL CICS programs. 

 

ALLEN BRADLEY / Computer People 08/87 to 10/87 

Programmed IMS
on-line Account Receivable and Payable systems using COBOL. Designed and
programmed several reports. 

 

WISCONSIN BELL
TELEPHONE / Computer People 03/85 to 02/86 

Installed FORTRAN applications
system, and modified programs to interface with files due to Bell Divestiture.
Programmed data collection system using ISPF DIALOG MANAGER panels
and CLISTS for data-entry operators to enter complicated information. 

 

Assisted in the design and
programmed the NEPC system using FOCUS and FOCUS Sink Machines. Designed FOCUS Databases. Created an FCC Docket
record-keeping and tracing system with the ability to find dockets containing
key words. 

 

FIRST WISCONSIN NAT'L BANK / Computer
People 11/84 to 02/85 

Assisted in the
design and creation of a consolidated customer account statement. Supported DDA checking account systems, restructured programs into
structured code. 

 

     WISCONSIN BELL
TELEPHONE / Cap Gemini America
11/83 to 11/84

Developed a
Circuit Design system in COBOL to calculate costs for Private Line service to
present to the Public Service Commission. Determined
Circuit type and transmission lengths.