Uploaded File
add photo
Victor
vrocchio@comcast.net
763-420-7888
S Pasadena, FL 33707
Mainframe Engineer
38 years experience W2
0
Recommendations
Average rating
13
Profile views
Summary

Experience
Database Consultant
Information Technology
Apr 2016 - Apr 2017

For Tradestation:

  • Short term consulting projects involving SQL stored procedures for private investors.
  • Writing programs to analyze stock market trends and direction. Utilized these programs to successfully be consistent in day trading the emini - futures
  • Used Windows and Unix machines. Oracle Databases.
  • Wrote file update programs on the Mainframe.
Oracle SQL UNIX
Remove Skill
Software Engineer
Information Technology
Nov 2014 - Mar 2016
Chandler, AZ

Developed reporting for Mainframe Security applications (Top Secret), using SAS, REXX, COBOL, CICS, DB2, Endeavor, SCLM, CLIST, Perl, MQ Series. Performed day to day maintenance and production support of security applications. Developed new processes to support security administrators.

Cobol CICS Software Engineer IBM Websphere MQ DB2 Perl SAS
Remove Skill
Software Developer
Information Technology
May 2009 - Nov 2014

  • For Tradestation: Short term consulting projects involving SQL stored procedures for private investors.
  • Writing programs to analyze stock market trends and direction. Utilized these programs to successfully be consistent in day trading the emini - futures
  • Used Windows and Unix machines. Oracle Databases.
SQL UNIX Stored Procedure Oracle Windows
Remove Skill
DB2 Developer
Information Technology
Jun 2007 - Apr 2009
  • Converted Tax Reporting Datacom programs to DB2.
  • Wrote interface modules, front ends and modified hundreds of Cobol programs including batch and CICS.
  • Worked with Business and IT users gathering requirements and ensuring changes were correct.
  • Performed on call duties and day to day maintenance of production.
  • Cobol, CICS, DB2, DATACOM, Endeavor, Syncsort, Platinum Tools, Expeditor, VSAM, JCL, NDM, SQL.
DB2 Requirements Gathering CICS Cobol JCL SYNCSORT VSAM XPEDITOR
Remove Skill
Mainframe Developer
Information Technology
Nov 2006 - May 2007

  • Converted mainframe credit card management system from old Metris system to new HSBC standards. This included modifying existing JCL and programs. Also enhanced their systems to accommodate new credit card Clients (AMEX, etc.).
  • Cobol, DB2, CICS, FTP, NDM, Changeman, Expeditor, VSAM, TSO

DB2 CHANGEMAN CICS Cobol JCL VSAM XPEDITOR FTP
Remove Skill
Developer
Information Technology
Mar 2002 - Oct 2006

Environment: CICS, Oracle, COBOLII, Assembler, CPCS, Easytrieve

  • Designed and developed OFAC business requirements and systems for money laundering, fraud and Treasury list compliance. Developed systems to transfer funds between banking entities. Developed systems to support fee charges for money transfers. Supported day to day operations of the MoneyGram business of transferring funds. Helped transition routine support and maintenance to off - shore support. Support and development of monetary CICS online transaction processors. Supported the Investment Department with their day to day management of their extensive stock portfolio. Wrote Web pages and SQL scripts to process and send data to mainframe applications. On - line (CICS, Oracle, COBOLII, CPCS, Easytrieve, Assembler, VSAM, SQL PLUS, TSO, MQ Series) environment. VitalWorks, Inc., Project Manager, Mpls, Jan 02 - Mar 02
  • Analyzed and documented a large Medical Claims system for Clinic Doctors and Dentists. Produced system flow, detail flow and process flow documents. Used NATURAL Data Definition Module (DDM) based on ADABAS. Documented enhancement options with time estimates. Wrote management summary reports and recommendations. (DOS/VSE, Natural/Adabase, CICS, ICCF, VSAM, SAS, COBOL, Telon, Unix, Oracle, TSO)
SQL UNIX Oracle IBM Websphere MQ Project Management
Remove Skill
Developer
Information Technology
Feb 2001 - Aug 2001
  • Designed and developed a new business debit card product and intenerated it into the existing card system. Produced detailed specifications and test scripts.
  • Wrote interfaces to CICS to support the web applications. D
  • eveloped web pages with ASP/VBScript, JavaScript and HTML and used FTP to load data from the mainframe to a Unix Sybase platform.
  • On - line (Data Warehousing, CICS, IMS, DB2, SAS, Assembler, Macro, COBOLII, Easytrieve, FTP, Connect Mailbox, TSO) environment.
HTML UNIX JavaScript DB2 Data Warehousing FTP
Remove Skill
Sr. Programmer/Analyst
Information Technology
Aug 1997 - Feb 2001
  • Performed day - to - day analysis and maintenance programming on Traditional Life Insurance/Annuity systems for this conglomerate.
  • Supported Trad and Vantage systems daily with problem resolution and enhancements. Maintained and enhanced CSP screens.
  • Mentored off shore consulting firm to take over support of the Traditional Life Application.
  • Developed web pages with ASP/VBScript, JavaScript and HTML and used FTP to load data from the mainframe to a Unix Sybase platform. On - line Supported production and solved program defects in an On - line (CICS, IMS, DB2, Assembler, Macro, COBOLII, PacBase, SAS, Easytrieve, Focus, TSO) environment.
HTML UNIX JavaScript SAS Cobol DB2 IMS FTP
Remove Skill
Sr. Lead Programmer/Analyst
Information Technology
Jun 1996 - Aug 1997

  • Installed and custom modified a Mutual Fund Sweep package for commercial bank customers. Tested with users and trained them on the use of the project. Interfaced with the Vendor for successful implementation (Cobol, Assembler, DB2, PacBase)
  • Supported the Account Reconciliation and Payable Through legacy systems in the Treasury Management Department, which included user and programming support. Installed Network Data Mover (NDM) and CONNECT/MAILBOX and PEP+ for electronic transmission of customer files. Used FTP to transfer data from the mainframe to a Unix box loading up to Sybase tables.
UNIX Cobol DB2 FTP
Remove Skill
Account Manager
Information Technology
Jul 1995 - Jun 1996

  • Performed duties to nurture more business and monitor development activities as an account manager. Prepared performance reviews, tracked project progress and managed staffing requirements.
  • Wrote responses for requests for proposals and wrote bids on many projects.
Project Management Staffing Account Management
Remove Skill
Project Lead
Information Technology
Aug 1994 - Jun 1995

  • Performed the majority of research and analysis for this retail chain's existing global order management system in the anticipation of replacing it with newer technology. Many integral functions and business requirements were discovered and documented for this client. IMS DB2 Shop with Microsoft Access was used for reporting the findings.
  • Modified IEF code to develop on line ordering system
No skills were added
Remove Skill
Developer
Information Technology
Feb 1994 - Aug 1994

  • Programmed general Ledger applications using COBOL II and DB2.
  • Constructed general ledger reports for balance sheet, income, and expense trees using PeopleSoft tables. Led other team members through the construction process with technical direction.
  • Wrote Powerbuilder application Query screens accessing Sybase.
No skills were added
Remove Skill
DB2 Consultant
Information Technology
Aug 1993 - Feb 1994
  • Modified IMS DB/DC Transform and Telon programs to use DB2 tables in place of IMS database calls.
  • Constructed unit and system test plans for the successful implementation of their entire inventory warehouse systems.
DB2 Test Planning IMS IMS DBDC
Remove Skill
Project Manager
Information Technology
Jan 1992 - Aug 1993

  • Designed and programmed tools and synchronization programs to convert a large item inventory system from IMS database to DB2. The sync programs allowed all of the existing applications to process transactions normally without actually modifying the code. Performed application tuning for IMS programs. Reviewed all SSA's, IMS calls and restore/recovery procedures for safety and accuracy. Modified PCB masks for better efficiency. Set up new PSB's and PCB's for application programmers.
  • Wrote SQL to replace IMS in application programs. Performed DB2 tuning and evaluation tasks. ForSuperSolutions:
Project Management SQL
Remove Skill
Project Manager
Information Technology
Oct 1991 - Jan 1992
  • Led the project team to the successful completion of a large automated Hospital Claims Pricing system. The system is used to insure that providers are charging reasonable fees for services performed.
  • Data modeling and 4GL techniques were employed with Ingres 6.3. Developed and documented OOA and OOD procedures using Westmount (ISEE - IEW)

Project Management
Remove Skill
Project Lead
Information Technology
May 1989 - Oct 1991
San Diego, CA
  • Developed a Customer Follow up and Tickler File system. This is a date triggered follow up system designed to inform service representatives of upcoming customer service functions. Native IDMS was used as the primary database.
  • Developed a Remote Payment Processing system. This project facilitated the printing of payment receipts at various remote locations. CICS Transient Data concepts were used to initiate the printing of customer receipts at the correct customer service locations. Various online screens were developed for processing the payments with Command Level Cobol and VSAM.
  • Converted the above project to CSP/DB2 as a pilot project. Required to perform all the company coordination for CSP and DB2, as this was the first CSP project for this company.
  • Programmed a large Meter Deposit Management system using CSP/DB2 as a sub system to this utilities Customer Information system. The system used a wide variety of interrelated DB2 tables and functionally complex online CSP screens. Was required to write many CICS to CSP interface modules (CSP/DB2 with CICS and VSAM).
  • Performed all duties as database administrator including design and programmer training.
No skills were added
Remove Skill
Consultant
Information Technology
Aug 1988 - Mar 1989
  • Chart of Accounts conversion from Solar in house accounts to MSA account formats. Wrote modules to convert Cobol source programs to the new account structure of MSA.
  • Also modified their online forecasting system by converting them to the new MSA account format and changed the logic to improve the performance of the system (Cobol, CICS, DLI and VSAM).
No skills were added
Remove Skill
Project Lead
Information Technology
Feb 1987 - Aug 1988
  • Installed a large investment management and accounting package called PRISM from Information Systems of America (ISA). The system was comprised of many online CICS and batch modules utilizing a complex VSAM database structure.
  • Was additionally required to make many User modifications to both the online and batch portions of the package. Prepared all production procedures and scheduling processing.
  • Worked closely with investment accounting Users to design new reporting requirements for this package. Supported the tax department with IRS and State reporting requirements.
  • Supported year end tax reporting. Made many modifications and supported their old investment accounting system while the new one was being phased in (Command Level CICS, VSAM).
No skills were added
Remove Skill
Project Lead
Information Technology
Feb 1985 - Jan 1987

  • Performed the systems analysis, programming, implementation and project leadership to develop an online Customer Information query, update and batch transaction generator as a front end to a large Customer Information Control System (Tres Systems). Worked directly with the User staff and Information Systems personnel to complete this project within schedule and budget. The system was written using Macro Level CICS with BAL and Total files.
  • Designed and programmed an online Summary Billing System to control the combined billing of companies with subsidiaries or affiliates. VSAM files, Journal Control and Command Level CICS with COBOL was utilized.
  • Programmed and implemented a Remote Cash Deposit system utilizing remote bill stub reader machines. Developed Debit/Credit logic to process transactions that were downgraded to CICS from the readers.
  • Converted some of their very old and large Macro Level CICS assembler programs to Command Level CICS Cobol. These were the front - end modules to their entire CICS online system.
System Analysis
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Skills
UNIX
2017
15
Oracle
2017
11
SQL
2017
11
Cobol
2016
9
DB2
2016
6
FTP
2007
6
Project Management
2006
6
SAS
2016
6
IBM Websphere MQ
2016
5
IMS
2001
5
Stored Procedure
2014
5
Windows
2014
5
CICS
2016
4
HTML
2001
4
JavaScript
2001
4
JCL
2009
3
VSAM
2009
3
XPEDITOR
2009
3
Perl
2016
2
Requirements Gathering
2009
2
SYNCSORT
2009
2
System Analysis
1987
2
Account Management
1996
1
CHANGEMAN
2007
1
IMS DBDC
1994
1
Software Engineer
2016
1
Staffing
1996
1
Test Planning
1994
1
Data Warehousing
2001
1