Contact: Tony D’Errico
Email: tonyderrico@hotmail.com
Phone: 613-415-1844
TONY D'ERRICO
Management (Intensive Day Program) Certificate, Concordia University, 2000
Diploma of Collegiate Studies in Computer Science, Champlain Regional College, 1976
TECHNICAL SKILLS
Languages Cobol/ANSI/-2/-370, COBOL IMS DB/DC, Natural, DB2,
Cognos (Impromptu), Transact SQL / SQL
Mainframes IBM, AMDAHL, Unisys
Midrange Digital VAX, Sun Solaris
Operating Systems VS2, MVS, VM/XA, VSE/SP, MVS/XA JES III, OS-JCL and Utilities,
VM/CMS, CICS, VAX, VMS, DCL, Unix
Software FILEAID, CICS Cobol programming, CLISTS, Panvalet, ACF2, TSO/ISPF,
EASYTRIEVE, WordPerfect, Microsoft Word, DB2I, SPUFI, QMF,
XPEDITER, CA-7/CA-11 Job Schedulers, Endevor, SDSF, FTP, Syncsort,
CA-Optimizer, Construct, VSAM, MQSeries
Data Bases DB2, I.M.S. DB/DC with DLI, ADABAS, SQL Server 7, Cognos
Methodologies Structured Systems Analysis and Design by MCAUTO/IST (STRADIS),
Data Modeling, Prototyping.
From February 2011 to September 2011 as Consultant (Senior Systems Analyst) for Broward College in Ft Lauderdale, Florida.
Environment : Sun Solaris Unix, Linux, Natural/Adabas/Construct, VI Editor, Microfocus Cobol. FTP TCP/IP, Beyond Compare
Responsible for the conversion of the commencement book programs used at graduation ceremony from MicroFocus Cobol to Natural language code thus saving the College from paying $100,000/yr licensing fees for Cobol compiler.
From February 2009 to August 2010 as Consultant (Senior Systems Analyst) for Florida State College at Jacksonville in Jacksonville, Florida
Environment : Sun Solaris, Unix, Linux, Natural/Adabas/Construct, VI Editor, NetCobol, Microfocus Cobol
Worked on FSCJ Student Information System. Created batch jobs for downloading Comma Delimited files as required by users to upload onto spreadsheets. Files contain Exit exam data, Student demographics, Student scores etc.
Designed and created a new Adabas table with appropriate Superdescriptors to allow for Add/Update/Purge/Browse of College Courses. Planned and controlled the implementation phase.
Converted 15 Microfocus Cobol programs to NetCobol, linked and ran in the newly created NetCobol environment.
From March 2007 to September 2008 as a Consultant (Senior Systems Analyst) for American Family Insurance, Madison, Wisconsin
Environment : Mainframe, MVS, JCL & Utilities, Syncsort, TSO, ISPF, Endevor,
Natural/Adabas, CA7 Scheduling
Design and implement various Sales Agent Promotional Campaigns. The Campaigns track agent policy sales volumes attained and create incentive payouts depending on level of sales achieved. I met with Marketing, wrote Solution Proposals and I did the actual development. Coordinated user testing. I used data modeling and structured analysis techniques on this project.
Provide on-call support 24/7.
From August 2006 to March 2007 as Senior Consultant for Keane Canada assigned to primary client Morgan Stanley, Toronto, Ontario
Environment: Mainframe, MVS, OS-JCL & Utilities, Syncsort, TSO/SPF, MQSeries, OnDemand, TCP/IP, Natural/Adabas
Merged individual retail and institutional operations into a Single Broker Dealer System where I was heavily involved in data mapping and design of the newly created SBD application.
Developed and coded new processes necessary for Regulatory Reporting.
Conducted Structured Walkthroughs.
From Feb’04 to March’05 as Consultant (Senior Systems Analyst) with City of Montreal, Montreal, Quebec
Environment: Mainframe, MVS, OS-JCL & Utilities, Syncsort, CICS, TSO/SPF, MQSeries,
Endevor, Natural/Adabas, TCP/IP
Working on the Traffic Violations System for the Municipal Court that automates all activities in processing of traffic violations.
Responsible for building a bridge between the World Wide Web and this mainframe application that allows traffic tickets to be paid via the internet, using MQSeries, Natural and Servers.
Work on major enhancements to the Municipal Court Management application.
From Feb’02 to Jun’03 as Consultant (Senior Systems Analyst) with Government of Canada
(Foreign Affairs and International Trade)
Environment: VAX VMS, Cognos (Impromptu), Transact-SQL, Natural/Adabas, SQL-Server-7
Served as Prime Support for the Export Permit Control system written in Natural on a VAX VMS computer. The developed system monitors quotas and issues permits for import and export of commodities.
Role of Analyst/developer for conversion to a WEB based application using SQL and Impromptu.
From May’01 to Oct’01 as Consultant with OneBeacon Insurance, Foxboro, Massachusetts
Environment Mainframe, VSAM, MVS, OS-JCL & Utilities, Syncsort, TSO/ISPF, Predict, Natural/Adabas, CICS, Endevor
Developed new registrant screens to comply with New York Department of Motor Vehicles requirements.
Worked on changes to the Inquiry System in CARS to show newly added database fields.
Responsible for coordinating the Company Name Change for both CARS and CAMS with a total of 713 modules being modified.
From Jan’01 to Apr’01 as Consultant (Senior Systems Analyst) with CVS/pharmacy (4300 stores), Woonsocket, Rhode Island
Project: CVS.com Website integration project
Environment Mainframe, MVS, OS-JCL & Utilities, COBOL, VSAM, Syncsort, TCP/IP, EasyTrieve, TSO/ISPF, FILEAID, FTP
Responsible for management of the virtual store inventory and modified current systems and processes for web integration besides development of web interfaces.
Performed analysis of Transaction Log processing and introduced employee/customer discount cards.
From Aug’00 to Nov’00 as Consultant (Assessment) with Commonwealth of Massachusetts (Department of Medical Assistance), Boston, Massachusetts
Project: Medicaid Management Information System
Environment Mainframe, MVS, OS-JCL & Utilities, COBOL and Command Level CICS, Syncsort, TSO
Performed assessment of Claims History Application and produced a Review and Recommendations document that complied with the Massachusetts Information Technology Center standards and procedures. The recommendations were accepted.
From Mar’00 to Jun’00 as Consultant (Process Reengineering) with The Standard Life Insurance Company, Montreal, Quebec
Environment Excel, Mainframe, MVS, OS-JCL & Utilities, Cobol VSAM, Syncsort, TSO/SPF, Data Modeling, STRADIS, Process Flows
Involved with the reengineering of the Investment Administration area back office functions and prepared documentation on the process flow.
Identified inefficiencies and defined the impact of proposed solutions on processes pertaining to portfolio management of Mutual Funds and recommended the best solutions
Interacted with users for review of the proposed future process flows and produced the Report Strategy Document that categorizes over 100 reports.
From Mar’99 to Jun’99 as Consultant (Mainframe) with The Bradford Exchange, Chicago. Ill
Project: E-Commerce Order Processing
Environment Mainframe, MVS, OS-JCL & Utilities, CICS, TSO/SPF, Natural/Adabas, TCP/IP
Scope: The E-Orders project was initiated to enable customers to buy Bradford products through the Internet. The Bradford Exchange is a seller of exclusive collectible items through selected magazines and publications around the world.
Worked on enhancement of the existing back-end systems to accommodate e-orders from the Internet web site.
Developed interfaces between the mainframe and web site including an interface that provided information on product inventory levels to the web server besides another interface that tracked order status on the web site.
From Feb’98 to Dec’98 as Senior Systems Analyst with Bank of Nova Scotia, Montreal, QC
Project: National Trust Integration Project.
Responsible for preparing the High Level Interfaces Strategy document that identified and defined all sub-systems used by the newly acquired Company.
Highlighted cost effective strategies for integrating existing computer applications into the Bank of Nova Scotia environment.
Identified the platforms of each sub-system and determined the requirements for different functionality that would be required at BNS, ensuring zero duplication of services.
Project: Shareholders Communication
Produced Preliminary Analysis document detailing the total automation of the issuance of mailing materials to the shareholders.
Project: Retail External Mutual Funds
Produced Preliminary Analysis document detailing the impact of the acquisition of National
Trust clients on management of Mutual Funds.
Proposed alternate solutions for handling the increased volumes and detailed the efforts required.
Project: Electronic Funds Transfer
Environment: Mainframe, MVS, OS-JCL & Utilities, Syncsort, TSO/SPF, Data Modeling, STRADIS, COBOL and Command Level CICS, IDMS
Produced Preliminary Analysis document that presented a visualization of the operation of EFT between Trust Application and the outside world.
Studied and analyzed enhancements to the current Trust Asset System and prepared Functional Specifications for programmers.
From Dec’96 to Dec’97 as Consultant (Production Support) with Bell Sygma, Dorval, Quebec
Environment Mainframe, MVS, OS-JCL & Utilities, I.M.S. DB/DC with DLI, Cobol, VSAM, Syncsort, TSO/ISPF, FILEAID, DB2 ,SPUFI, QMF, Endevor, CA-7, CA-11 Job Schedulers.
Provided production support for the new Customer Billing System.
Interacted with users and operations teams for tracking job execution and prepared activity schedules for migration to production environment, backups and modification of programs.
Produced statistics on production runs and data.
From Dec’92 to Dec’96 as Consultant (Senior Analyst-Programmer) with City of Montreal, Montreal, Quebec
Project: Automated Budget System
Scope: The Budget system allowed users to plan for expenses and receipts.
Involved with development of the new automated Budget system. Worked from functional specifications to create detail specifications and programs.
Responsible for the installation of Natural Connection across user departments, enabling them to download data from the Budget system to local workstations.
Established permanent procedures for proper functioning of Natural Connection and worked on implementation and testing of each module.
Project: Traffic Violations System
Environment Mainframe, MVS, OS-JCL & Utilities, Syncsort, TSO/SPF, Endevor, TCP/IP, Predict, Natural/Adabas, Natural Connection.
Scope: The developed system automated all activities for processing of traffic violations.
Worked on new enhancements to the Traffic Violations system for the Municipal Court.
Responsible for introducing Bar Codes onto legal documents.
Used the Construct tool to generate standardized natural code.
From Jan’92 to Dec’92 as Consultant (Production Support) with Caisse de Dépôt et Placement du Québec, Montreal, Québec
Responsible for analysis, programming and support of system components of the Stock Portfolio Management system using Mainframe, MVS, OS-JCL & Utilities, TSO/SPF, Predict, Natural/Adabas
From May’91 to Nov’91 as Consultant with Beaver Asphalt Co. Ltd., Montreal, Quebec
Interacted with client teams and evaluated the IT requirements of the company for development of a project plan, detailing the information system requirements.
Studied and analyzed the Payroll, Job Costing, General Ledger, Accounts Payables/Receivables, Inventory, Maintenance of Equipment as well as Real Estate operations in major construction companies.
Recommended a solution that was implemented by the client. This pertained to a UNIX environment running on an IBM RISC 6000 system with packaged programs.
ADDITIONAL EXPERIENCE
From Nov’88 to May’91 as Consultant (Senior Systems Analyst) with Bell Helicopter Textron, St. Janvier, Quebec
Project: Material Requirements Planning and Acquisition/Customer Order Processing System
Environment: Mainframe, MVS, OS-JCL & Utilities, I.M.S. DB/DC with DLI, DB2, Cobol, VSAM, Syncsort, TSO/ISPF, FILEAID, MFS, XPEDITER, EasyTrieve, ACF2, Panvalet, CLISTS, CA-7, CA-11 Schedulers, BTS, CA-Optimizer, MFS, SDSF, Endevor.
Responsible for system analysis, coding, installation and user support in production environment.
Implemented improvements in front-end validations on data entry screens and wrote database checker programs to identify and fix bad data accumulated in the system.
Responsible for supporting users in Material Requirements Planning, Purchasing and Accounting. Installed the newly introduced government taxes namely GST and PST.
Did the conversion of Check Reconciliation from a manual operation to an automated system.
From Jul’88 to Nov’88 as Marketing Consultant with Peat Marwick, Montreal, Quebec
Involved with launch and marketing of the new brand of Computer Aided Systems Engineering tools (CASE). VAX, VMS, Silverrun, Oracle, SQL.
Provided post sales support and served as hotline coordination, scheduling technical support staff
From Jun’87 to Jun’88 as Senior Systems Analyst with Spar Aerospace, St Anne de Bellevue, Quebec
Converted Spar's Weekly Time Reporting System from Fortran batch to MIMS MITROL database. Converted a batch Fortran system to an on-line interactive application.
Involved with system study, analysis, design and preparation of specifications. Wrote testing scripts for all possible scenarios.
Provided guidance and support to two programmer/analysts.
From Jan’86 to May’87 as Computer Consultant with Bekhor Securities Ltd., Montreal,QC QC
Assisted in the installation of a mini computer from Convergent Technologies to provide real-time price data and implemented a software package that allowed IBM-PC users to obtain data on Stocks, Commodities and Options via modems in Micro Vax environment.
From Apr’81 to Dec’85 as Senior Analyst/Programmer with Trans Quebec & Maritimes Pipelines, Montreal, Quebec
Environment Mainframe, MVS, OS-JCL & Utilities, CICS, Natural/Adabas, Cobol, VSAM, Syncsort, TSO/ISPF, FILEAID, EasyTrieve, ACF2, Panvalet, CLISTS, SDSF, CLISTS, Prototyping.
Responsible for the Design, Development and Installation phases for Land Rights, Gas Control, Public Hearings, Library and Personnel Systems.
Served as the EasyTrieve Coordinator for the company and monitored the performance of ADABAS/NATURAL databases.
From Jul’80 to Oct’80 as IMS Programmer with Canadian Utilities, Edmonton, Alberta
Converted Financial Information Systems from C.U. gas companies to other operations in the Corporation using MVS, OS-JCL & Utilities, TSO/SPF, Cobol, I.M.S DL/I, ACF2 and BTS.
From Apr’80 to Jun’80 as CICS Cobol Programmer with Alberta Government Telephones, Edmonton, Alberta
Wrote Online inquiry programs for the Accounts Payable System using Cobol and CICS.
From Jun’79 to Dec’79 as CICS Cobol Programmer with Royal Bank of Canada, Montreal, QC
Worked on debugging old and new Cobol programs in Mainframe, MVS, OS-JCL & Utilities.
From Jan’79 to Jun’79 as Senior Programmer with Canadian National Railways, Montreal,QC
Writing report programs for Marketing using Cobol, MVS, OS-JCL & Utilities, TSO/SPF, Cobol
From Jan’76 to Jan’79 as Mainframe Analyst/Programmer with Pratt & Whitney Aircraft of Canada, Longueuil, Quebec
Responsible for Illustrated Parts Catalog application for engine parts. Cobol, ISAM files. TSO/SPF.
Support on Price File for all spare parts. Cobol I.M.S. batch.
Support on Product Structure application. Cobol I.M.S. DB/DC using DL/I.
Systems Analyst and Lead Programmer on Service Center Inventory Control System. Produced both Conceptual and Detail Design documents. Cobol I.M.S. DB/DC using DL/I.
D’Errico
& Associates, Inc. Resume of Tony D’Errico Page