PAT F. RICCARDELLI
Norwalk, CT 06851
Home: 203-***-****
*************@*********.***
BUSINESS APPLICATIONS:
. Asset Management (AMS)
. Automated Customer Account Transfer System (ACATS)
. Asset/Mortgage Backed Securities
. Capacity Planning
. Corporate Actions
. Dividend and Interest Payments
. FEDWIRE
. Transfer Agency
. Material Requirements Planning
. Point-of-Sale (POS)
. Securities Movement and Control
. Checking and Credit Card Processing
TECHNICAL SKILLS:
. All IBM operating systems (z/OS most recently)
. COBOL (all levels)
. Assembler (all levels)
. CICS
. DB2/SQL/UDB
. IMS
. VSAM
. MQ Series
. JCL
. REXX
. TSO/ISPF/Dialog Manager
. Endevor/Librarian/ChangeMan
. CA7 Scheduling
. Network Data Mover (NDM)
. Expeditor/Intertest
. Easytrieve, Syncsort (DFSORT), IDCAMS
. All IBM Utilities
. DBArtisan
PROFESSIONAL HIGHLIGHTS
CMM Consulting Services, Inc. - Consultant
1980 - Present
Barclays Wealth (12/2009-present)
. Responsible for support and development of their Financial Resource
Account (FRA) application. This handles all bill paying, checking and
debit card processing for their clients. The application is a COBAL
DB2 application with a CICS online.
. Worked on migration of DB2 databases from the mainframe to a UDB
environment. The applications accessing the databases still run on the
mainframe. Analysis of all DB2 programs was required to determine if
the connection to UDB should be explicit or implicit and if SQL
statements in the programs needed to be modified as well.
. Responsible for restructuring of Data Classification system to
support both Statement Printing and Wealth Management Reporting
applications. This involves major scheduling and program changes to
support the additional processing requirements brought about by the
acquisition of Lehman by Barclays.
United Bank of Switzerland (08/2008-12/2008)
. Worked on converting legacy Book of Record for Margins application
from Assembler to COBOL. Application consisted of 200-300 Assembler
programs. My responsibility was to document what the function of each
was and determine if it was a candidate to be converted to COBOL. This
was followed by writing detailed specifications, coding, and testing
of each.
Bank of America (2007-2008)
Charles Schwab (2001-2007)
. Implemented and supported ACATS system to handle account transfers
in and out of the bank. The system interfaced with a front-end
distributed application using MQ Series. The messages used a XML
format to communicate the processing flow between the GUI front-end
and the mainframe. The transmissions were handled via NDM. The
application was written in both COBOL and Assembler utilizing IMS, DB2
and VSAM file structures. My primary function was to work with the
user area to develop the mainframe applications.
. Designed and coded a process for sending email with attachments
from the mainframe. The code was written in both COBOL and Assembler
utilizing SMTP, MIME and HTML to format the actual email. It was
extremely useful for creating .CSV files in either the batch or online
and sending them directly to the user to be loaded into Excel.
. Worked on IMS based Asset Management System (AMS). This encompassed
Dividend and Interest Payments (DNI), Asset/Mortgage Backed Security
(ABS/MBS), Security Movement and Control (SMAC), and Corporate Action
processing. The online component was both IMS and CICS. The online and
batch applications were written in COBOL and Assembler utilizing DB2,
IMS and VSAM file structures. My responsibilities were both as a lead
and developer.
. Worked on a CICS based FEDWIRE system to handle wire processing with
the Federal Reserve Bank. Headed a development team to implement real-
time account balance lookup at the vendor's site. I designed a cross-
region communication process written in Assembler to communicate
across CICS regions so that we could interface directly with the
vendor product (Metavante).
. Worked on a CICS based application to send and receive trading
instructions. This application consisted solely of background
transactions that ran at specific intervals to process the flow of MQ
messages between DTCC and my client. The transactions would go against
DB2 tables to build the outgoing messages and conversely write the
incoming messages to DB2 tables. Because this application ran without
user intervention I also wrote a CICS exit routine to handle ABEND
processing in the region. Its purpose was to send email alerts to the
systems support and user areas notifying them of any problems.
. Designed and coded an MQ interface that was used by the application
developers to send and receive MQ messages. This allowed developers
that had little if any MQ experience to utilize its capabilities.
Chase (1995-2001)
. Headed development team to design and implement a Global Transfer
Agency System (GTAS). The system handled all record keeping,
redemption, maturity, call and payment processing for Corporate and
Municipal Bonds. The online component of the system was CICS based
using DB2, IMS, and VSAM file structures. The code was written in both
COBOL and Assembler.
. Wrote several CICS background transactions to support an IBM 4GL
product call CSP. These transactions handled all temp storage activity
needed for the applications. The transactions were triggered at
specific intervals to monitor the temp storage queues and delete
queues no longer used by the applications.
. Wrote CICS exit routines for pre and post DLI calls. This was needed
for their Y2K conversion to handle key manipulation in both the IMS
SSAS and the segments returned. These were unsigned packed Julian
dates. The exits removed the burden of converting them to valid packed
fields from the applications.
. Worked with DBA group writing IMS sparsing routines and BMC exits for
unloading and reloading databases as well as handling other IMS
related functions in support of the GTAS application
United States Trust Company of New York (1982-1995)
. Worked on CICS based Corporate Transfer Agency System (CTAS). The
system handled all record keeping and payment processing for the banks
retail products (Mutual Funds, CEFS, UITS, etc.). The online component
of the system was CICS based using DB2, IMS, and VSAM file structures.
The code was written in both COBOL and Assembler.
. Wrote CICS background transactions to support a 24/7 region. The
transactions automated the end of a day processing, initiation of
overnight batch, rolling dates to next day, and start of day
processing.
. Developed an automated job scheduling system to support the batch
processing for CTAS. The system was written in Assembler. It had full
back-out and re-start capabilities built in.
Walden Books (1980-1982)
. Worked with IBM team to install and modify IBM 3680 Point-of-Sale
system (POS) at client's site. The software was written in Assembler
with its own macro language. Also developed back-end reports to
support the clients reporting requirements. The back-end was written
in both COBOL and Assembler using VSAM file structures.
National CSS - Technical Manager
1975 - 1980
Managed development team for 4GL Database Query product called FINAL
(Financial Analysis). The product allowed users to construct their own
databases and perform various queries against the data. The software
was written in Assembler and used its own DB structures.
Clairol, Inc. - Project Manager
1972 - 1975
Developed CICS based Order Processing system to track orders from
inception to final shipment. System handled back-ordering and re-
ordering of products, generation of packing lists and manifests. The
applications were written in both COBOL and Assembler utilizing VSAM
file structures.
. Installed and modified IBM Material Requirements planning (MRP) and
Capacity Planning packages. The packages were written in Assembler and
PL/I.