Manager Data

PATRICK J. HAGAN

Phone: 917-***-****

********@*****.***

www.linkedin.com/in/patrick-hagan-31a09834

SUMMARY

Information Technology professional performing large system administration, programming, performance tuning at major Financial Institutions including Prudential, Bank of New York, and Federal Reserve. Including conversion of timesharing system to internal IT department, Chase/Chemical merger, wrote Y2K Best Practices how-to book, and system upgrades. Projects utilized excellent communication skills to solve problems to complete projects on time and within budget. Motto: “Difficult gets done right away, while the impossible just takes longer”.

SKILLS

Operating Systems: UNIX, Novell, Windows, Solaris, LINUX, MVS/ESA, VM/CMS, Z/OS, VSE, VTAM, SNA

Databases: DB2, UDB, SQL, ORACLE, SYBASE, VSAM, MYSQL

Languages: JAVA, VisualAge for Java, Eclipse, WebSphere, J2EE, Servlets, Swing, EJB, JSP, SOAP, WSDL, UDDI, MQSeries, XML, CORBA, UML, COBOL/390, CICS/ESA, CICS TS, BASIC, Visual Basic, Assembler, BAL, PowerBuilder, Crystal Reports, Smalltalk, DYL280, Easytrieve, Micro Focus COBOL, Object Oriented COBOL, C, C++, Xellerate (provisioning), FORTRAN,PL/1

Utilities: TMON, OMEGAMON, Intertest, Xpediter, File-Aid, Abend-Aid, HourGlass, IDCAMS, ENDEVOR, Lotus Notes, Office, Excel, PANVALET, MSHP, SMP/E, RACF, ICSF, Changeman, Platinum, BMC Catalog Manager, ESM, AEF, MAX, TCM, FPS, REXX, ANT, AXIS

Platform Per Scholas June 2018 - September 2018

Consultant - Training

12 week training program in Data Engineering

•Trained and reviewed the basics of Big Data and Hadoop technologies through hands-on classroom activities, case studies, and group projects. Learned how to extract, scrub, and manipulate real-time and warehouse data using SQL & Java.

•Supplemented with materials from Udemy, Packt Publishing, and Safari to get a more in-depth exposure to Hadoop, Spark, SQL, and Java as they relate to Big Data.

Infosys November 2017 - April 2018

Consultant

Primarily working on DevOps research, but also providing expertise on Accelerate projects.

•Provided guidance on Accelerate projects on PGP, Weka, ML, NLP, PCA, SVM, Linear Regression, Skype on Swift.

•Evaluating various DevOps technologies under AWS, Azure, and IBM Cloud (IBM Rational Test Workbench, IBM Urban Code, OpenShift, Ansible, Docker, Kubernetes, Jenkins, Puppet)

•Getting certified in Red Hat Linux, OpenShift, Ansible, and JBoss

•Reviewing Infosys materials on Citizen Data Science and Machine Learning Specializations

Ivy Data Science July 2017 - October 2017

Consultant - Training

Training in Artificial Intelligence and Blockchain

• Training and review of Machine Learning, AI, Deep Learning, NLP, and Computer Vision using Python, TensorFlow, and PyTorch to preform advance AI techniques like CNN, RNN, LSTM, and GAN.

•Prepared for potential NLP clients, but it fell thru.

Convergex (now Cowen) August 2006 – July 2017

Technical Expert/Engineer/AVP for Back Office Systems

Technical Solution Architecture expert on team of eight creating and maintaining all the Back Office Systems for Convergex Trade Operations. Six members of the team were Jewish, so I provided support, when the rest of the team was unavailable. Our clients were Mutual Funds and Hedge Funds who we traded for and provided the back office services for those trades.

Created and maintained over 18 MQSeries, then Socket, and finally Web Service programs (client and server) to connect Mainframe to Windows. This included: Account files, Trade files, Margin files, and home grown Security System.

Provided technical guidance on converting Back Office Systems to AWS

Increased the maximum straight thru trade online processing from 20,000 trades to 200,000 using performance techniques.

As the closest thing our team had to a systems programmer: I verified z/OS, CICS, and MQ, IAM, SOAP, WS, XML, IBM Debug maintenance and upgrades, recompiled COBOL programs to 31 bit, redefined and setup more efficient VSAM Delete/Define procedures for all VSAM files.

For Compliance, I did Name and Address lookups, AML lookups, FINRA requests, SEC requests, CUSIP adds, unarchive trades, Chart of Accounts. CICS maintenance, MQ upgrade to V7, MQ maintenance, CICS SOS problem, SYNCSORT upgrade, TOP Secret upgrade, Web DML maintenance.

To support the Convergex mainframe systems from an application and technical perspective so all trades properly updated the Master files and reported to our Clearing customers.

Created over 200 SQL Server tables based on COBOL copybooks for potential mainframe migration. Also, created preliminary C++ programs for all the COBOL programs.

Responsible for coordinating SSL renewals every year.

Investigated and experimented with new technologies using Machine Learning Mastery, PyImageGurus, UDEMY, PackT Publishing, UDACITY, MOOCs, and other resources. These technologies included: Machine Learning, Data Science, R, Spark, Hadoop, Self-Driving Cars, Computer Vision, Deep Learning, NLP, and Artificial Intelligence.

Created various processes to monitor, investigated, and fix performance issues.

State of Pennsylvania Dept. of Revenue May 2005 – December 2005

Sr. System Programmer

Expert Programming resource supporting MVS system, handle MVS debugging and performance problems, and create SOA\ESB Web Services for mainframe programs.

MVS System Programmer resource for MVS, DB2, CICS, MQ, IMS, USS, WebSphere, SAS, EASYTRIEVE. CICS, DB2, WLM, RMF performance tuning. Investigated RACF and ICSF.

Without source code solved years of outstanding errors (ASRA, AKEA, TICA, 0F0C, SOS) due to INSTALL/1 CICS generation software using combination of LE dumps, System Dumps, Transaction dumps, and IPCS. Includes documentation.

Using PM4CICS on HFS, FEPI, XML, COBOL, and CICS created SOA\ESB with XML WSDL Web Services, MQ, USS to access mainframe resources including 3rd party Vendor software, Stored Procedures, and IMS subprograms. Access by MRO. Started Workflow design for SOA\ESB. Trained other team members.

First Data Bank (Pharmaceutical) October 2004 – March 2005

Senior Programmer/Analyst

Analyzed complex PL/1 state health plan pharmaceutical formulary and pricing applications to create specifications to convert them to Oracle SQL Stored Procedures.

Wrote specifications and corresponding SQL systems for state health plan systems for children, women, adults, and elders

Provided advisory services on application design to help an outsourcing firm keep the long term contract.

Insurance Service Organization December 2003 – March 2004

Senior Consultant

MVS expert analyzed CICS TS Gateway programs to strip out business logic to create Estimated Loss Cost system with JSP/Servlet presentation layer. Performed unit, system, regression, acceptance testing using XPEDITER to run test scripts and File-Aid to check files. Provided technical leadership to other team members.

Converted and tested with TSO, XPEDITER, CEDF, File-Aid, and DB2 (SQL), COBOL, CICS, DB2, VSAM programs LINKing to JCICS JSP/Servlets/Web Services from WebSphere (tested on Solaris and moved to MVS USS Linux).

Created dynamic FCT, PCT, PPT entries with CICS System Programmer Interface for MRO/ISC environment.

Solved Java/SOAP/WebSphere mainframe deployment and performance problems on USS using Linux. Provided expert advice on WebSphere and J2EE.

The Bank of New York February 2001 – April 2002

Technical Specialist

Provided high-level application programming and performance tuning for 256-partition large MVS DB2 (SQL) database and Data Warehouse with supporting VSAM files to calculate current and historical OLAP analysis of financial products for client’s portfolio.

Test data created using Windows NT, EXCEL, FileAid, and ETL utilities.

Designed, created, (unit, system, regression, performance) tested complex online CICS and batch JCL COBOL/DB2/VSAM Stored Procedures for Strategic Global Accounting for multi-currency, foreign exchange, pricing AFP reports such as P&L, Trial Balance, Mortgage Backed Securities, Asset Backed Securities, and Fixed Income from very large DB2/VSAM database using virtual, nested table, sophisticated SQL. Provided expertise in setup of MQSeries.

Documented current system and served as liaison for system requests. Setup ETL and FTP to move data from main database to client OLAP Data Warehouses.

Created COBOL, CICS, DB2, VSAM Stored Procedure application to access external files using EXCI and combine them with the current database to create a combined database of financial products and pricing data.

Prudential Securities Inc. August 1999 – February 2000

Senior Consultant

Single resource performed final Y2K remediation and testing of Prudential‘s MVS COBOL batch JCL and online DB2 (SQL), CICS, VSAM, MQSERIES systems. Setup test environment for unit, system, and QA testing using TSO utilities and File-Aid

Successfully setup separate MVS JCL, DB2, and CICS to do unit, system, acceptance, and regression tests to certify Compliance systems using COBOL, CICS, VSAM, MQSeries, ETL, and XML to properly handle Y2K.

Discovered and documented business rules for systems from the current COBOL/VSAM programs for future projects. Used Changeman QA for version control. Report on compliance with Y2K standards.

Wrote COBOL, CICS, VSAM system to access Prudential customer data by using alternate key. Debugged under XPEDITER.

Chemical Bank (now JP Morgan Chase) August 1995 - February 1999

Consultant

As part of matrix team converted MVS, COBOL, CICS, VSAM systems to common platform to allow Chemical Bank to easily merge systems with other financial institutions. Internal Project Leader and Technical resource.

Created common MVS, COBOL, CICS, VSAM platform to convert data to the common merger platform to feed and receive Check data to commercial banks and various Check Clearinghouses in SWIFT (MT103, MT202, and etc. messages), ACH, and other standard Check formats.

Designed and wrote COBOL input exit for Float Processing System which used the ESM, AEF, MAX, TCM, and FPS packages. Made sure the new system could produce the same data and fraud detection as old float system using extensive unit, system, regression, performance testing. Debugged under XPEDITER. Helped maintain Lotus Notes defect tracking database.

Helped create common MVS, COBOL, CICS, VSAM platform for Rainbow Sheet Systems for Check Processing using CEDF, INTERTEST, XPEDITER, and FileAid

Combined MVS VSAM Chase Manhattan and Chemical Bank Cash Disbursement Systems on-time and within budget while tuning system so it could handle multiple banks and pre-edit incoming transmissions. Helped set up CA7 scheduler to run jobs with proper dependencies

Converted DOS/VSE Cash Disbursement System to current MVS COBOL/CICS/VSAM technology so Chase Manhattan could eliminate the old DOS/VSE operating system. Created COBOL LU6.2 system to send VSAM accounting data to Chase General Ledger system. Also, created NDM procedures to send data from one system to another.

Setup environment to do all Y2K testing using HourGlass date simulation software to certify CDS software. Included white/black box unit, system, regression testing.

Setup ENDEVOR moves from QA to Production.

Maintain and tune CICS using OMEGAMON, INTERTEST, CEDF, and Abend-Aid.

Used CICS System Programmer Interface to check critical files using CICS system commands. Updated SIT, DCT, FCT, PCT, PPT CICS tables using CEDA and Macros for MRO/ISC environment.

Chase Manhattan Bank July 1994 – August 1995

Senior Programmer/Analyst

Enhanced and maintained ETL interfaces to MVS COBOL, CICS, VSAM, DB2, Fortran Credit Card systems based on business needs. Heavy unit, system, regression, QA testing, Abend-Aid debugging of new transactions, credit score, and fraud detection software.

Maintain Chase BankCard Services software using COBOL, CICS, DB2, REXX, FTP on MVS and MicroFocus and Sybase on OS/2 PCs. Used PANVALET for QA

Added, updated, converted credit card profile DB2 database and software for fraud detection and customer accounting based on problem analysis and specifications.

Analyzed and created interface to MVS Chase BankCard system for ATM Payments.

Evaluated, tested, and loaded outside vendor transactions using online CICS and batch JCL procedures using ETL software, File-Aid, INTERTEST.

Abraham’s Brothers Retail Stores, Inc. July 1990 – June 1993

Sr. System Programmer

System Expert responsible for all VSE, COBOL, CICS, VSAM programming, testing (unit, system, acceptance, regression), performance tuning, and documentation to track Abraham’s sales

Performed Help Desk function for UNIX workstations by maintaining Retail system software in Basic and C. Uploaded and downloaded remote workstation data to/from VSE and Sybase SQL Server Stored Procedures using ETL software.

Responsible for all technical and application support running Retail applications using MSHP, CICS, COBOL, ICCF, TMON, Assembler (BAL), and communication software to support over 100 stores in the Mid-West.

Maintained Order, Unit Control, General Ledger, Expense, and Accounts Payable application systems on MVS using CICS (SIT, TCT, PLT, DCT, FCT, PCT, PPT, and home grown scheduler), COBOL, VSAM, TSO and on the Sybase SQL Server using Transact-SQL and ISQL.

Created Data Warehouse Operating Report system that tied together PC data from all the other systems for OLAP analysis of stores based on sales, markdowns, purchases, and inventory turnover.

Cut Abraham's Brothers operating costs by converting to outsourcing firm's hardware running latest version of the MVS, COBOL, CICS, VSAM, TSO.

Federal Reserve Bank of New York November 1984 – July 1990

Senior Systems Analyst

Analyzed problems, created applications, systems enhancements, testing scripts (unit, system, acceptance, regression), and documentation to send and receive Check Processing (DDA) data to other financial institutions and Check Clearinghouses efficiently using MVS, VSE, COBOL, CICS, VSAM, TSO. Internal Project Leader.

Created jobs to feed Check data to commercial banks in SWIFT (MT100, MT202, etc. messages), ACH, other standard Check formats. Also, set up FTP, RJE and NJE jobs to send data internally.

Supported Check Processing Assembler (BAL) and COBOL software that produced "Kills", master lists, and cash letters. Developed CICS screens for the Check Processing system. Converted Rainbow, TICA, and MBB systems from Four Phase system to CICS. Enhancements for fraud detection.

Designed new service code scheme to expand service codes categories.

Modified Microfilm system to improve efficiency, provide better indexes, and more accurate reports for Check Adjustment.

MSHP to install to Target and Distribution libraries to convert four locations to latest VSE operating system. Hardware I/O configuration. Installed IBM system as a channel extender using VTAM/SNA. Installed CICS's Performance Tool and various APARs, PTFs, PUTs, and ZAPs. Expanded disk layouts. Setup disk sharing with Coupling Facility to share data sets between Production and Backup/Test systems. Helped setup TSO/ISPF standards. Ran EREP, CICS, GTF, SMF, RMF, and other diagnostics/performance tools as needed.

Provided applications and systems programming support for Check Processing using MSHP, COBOL, CICS, ICCF, MRO/ISC, and Easytrieve. Updated SIT, TCT, DCT, FCT, PCT, PPT tables.

Moved NY hardware to NJ and performed hardware/software conversion.

National Railway Publication Company 1980 – 1984

Senior Programmer/Analyst

Saved $250,000 per year by converting from external timesharing publishing system and System/36 subscription system to brand new VSE, COBOL, CICS, VSAM IT department using specialized FORTRAN publishing software. This included setting up hardware I/O configuration, IML/IPL procedures, CICS procedures including SIT, TCT, FCT, DCT, PCT, PPT tables, and CICS Assembler macros.

Metropolitan Life Insurance and other Insurance companies 1978 – 1980

Programmer/Analyst

Full software life cycle development of MVS, VM, CMS, VSE, COBOL, VSAM, JCL Profile Development Relative Value System for Medicare for calculating reasonable costs for medical procedures. Conversions from Honeywell system to IBM and from card systems to CICS systems.

Around the Block/NYPC October 1995 – Present

Sr. Software Specialist

On matrix team created UML specifications including database models for e-commerce web-sites using Design Patterns, OOD, and OOP at Around the Block (Red Hat Linux) and NYPC (Windows NT) using Java, Servlets, JSP, XML, J2EE, EJB, LDAP, MYSQL (SQL), Tomcat, OpenEJB, JBOSS, iPlanet, Eclipse, WebSphere.

Designed, installed, administered Windows NT, Suse Linux, Red Hat Linux, SCO UNIX, and SOLARIS systems in J2EE environment based on best practices

LDAP application for event and membership management originally file based AWT, now JSP/Servlet/MYSQL, being converted to J2EE/EJB

JSP/Servlet/MYSQL survey application of possible courses and potential students originally in Swing application. Converting to Java/EJB/XML Web Service

Benchmarking EJB applications on OpenEJB, JBOSS, WebSphere, and WebLogic. Included MQSeries testing Phone System written in C on SCO UNIX and Solaris.

Full SDLC JSP/Servlet/J2EE/XML systems to track/debug access to cookies, parameters, properties, and publish Directory of Theaters, Grants, Prizes

Administrator and Technical training in Thor Technologies provisioning product Xellerate to perform initial analysis of Lehman Brothers RACF/CICS to Xellerate/Oblix project

Research, analyze, and create banking XML DTDs and Schemas for DOM and SAX access using JSP, Servlet, J2EE, EJB, and Web Services system using Eclipse, WebSphere, Visual Basic, Crystal Reports, C++ and OOP techniques. Calculate financial, portfolio, and quantitative analysis formulas for Equities, Fixed Income, American options, European options, Mortgage Backed Securities, Asset Backed Securities, Interest Rate Swaps, etc. based on work of Weygandt, Fabozzi, Wilmott, Neftci, Hull, Cerny, Joshia, and PRMIA.

Working on Professional Risk Manager's Handbook, UDB, WebSphere certifications

In preparation for IBM Try-Buy position supporting ECM using DB2 Content Manager on Z/OS, Windows, and UNIX investigated setup and performance materials on Z/OS, USS, MQSeries, WebSphere V6, and DB2 Content Manager

Mentoring other team members on Java, Servlets, J2EE, LDAP, XML, VisualAge for Java, WebSphere, Eclipse, Design Patterns, Best Practices

Solved performance problem for GEICO with their WebSphere Java/CICS/DB2 two billion row system.

Provided mainframe performance expertise in solving another Insurance company's problem with IBM's new dynamic pricing scheme.

EDUCATION

•Fordham University, College of Business Administration, BS, majors in Quantitative Analysis (Computer Science) and Accounting with minor in Finance

•Pace University: Intensive 11 week Certificate in UNIX/C/C++/JAVA

•Thor Technologies: Administrator and Technical Training in Xellerate v.7.1

•EAI Consulting: 6 month Java Developer program covering C++/Java/Oracle/Solaris

•The American Institute: Update of IBM's Hardware and Software Products,

•American Data Group: VTAM for Practitioners

•On-Line Software: CICS Internals

•Novax: Intensive Introduction to PowerBuilder, Advanced PowerBuilder, Sybase

•New York University: Structured Programming, Systems Analysis, Database Management Concepts, Implementing Data Base Technology, CICS Internals, IMS, Assembler, Intensive Local Area Network Administration, Intensive C Programming, Visual Basic, OOA and OOP with Smalltalk, Intensive Java

•NYPC SIGs: C++/JAVA, Advanced Java, Linux, and XML/Web Services

•Helping to teach JAVA and J2EE/EJBs in a study group using Java, J2EE, EJB, TOMCAT Creating model programs for Socket, RMI, CORBA, Servlets, JMS, DOM, SAX, J2EE, EJB

•Object Developers Group XML SIG

•Network and Systems Professionals Association (NaSPA)

•New York JAVA SIG

•Technical resource for Barry Burd's J2EE JBOSS book

•Corrected various IBM Redbooks and Manuals

•Professional Risk Manager's International Association (PRMIA)

•Co-wrote how-to book “Year 2000: Best Practices for Y2K Millennium Computing”

•Ran four Virus Conferences and six Y2K Conferences and gave speech at Securities Industry Association on testing and conversion techniques

•Over 2,000 resources on various new technology courses including Machine Learning Mastery, UDEMY, UDACITY, Coursera, edX, etc.

•Red Hat certifications in Enterprise Linux, OpenShift, Ansible, and JBoss

•Ivy Data Science Artificial Intelligence and Machine Learning

•Platform Per Scholas Data Engineering program

Contact this candidate