Quality Assurance Project Manager
Resume:
STEVEN A. SAUL
***********@*****.***
PROGRAMMER ANALYST
BUSINESS ANALYST
LEGACY SUPPORT & CONVERSION SPECIALIST
PROJECT LEADER
* COBOL / Assembler / SAS
* DB2 / VSAM / CICS
* IMS DB/DC, Toad for DB2
* Technical Documentation / Pseudocoding
* Production Support / Enhancement / Development / Quality Assurance
* JCL, TSO, ISPF, CLIST, Sort, PL/1
* Systems Development Life Cycle
* UNIX, Korn Shell Scripting, Perl
* Endevor, Xpediter, Changeman, FileAid
* Ramis, Mark IV, Total, Environ, SQRibe
* HTML5, CSS3, Javascript, Java
* MS Access, Excel, Word, Project, Visio
* MS SQL Server / Visual Basic
CAREER SUMMARY
* Over 25 years Mainframe experience in developing, enhancing, and supporting Financial (Banking/Credit Card), Securities, Healthcare (Claims, Account Recoveries, Medicare), Manufacturing, Utilities and Insurance, COBOL, Assembler, SAS, DB2, IMS DB/DC and Online and Batch applications.
* Systems Analysis, Business Analyst and Program Analysis expertise in a broad range of applications and industries. Excellent communications with all levels of management and business users. Experienced Leadership and Project Management experience.
* Legacy Conversion and Support experience with Assembler, IMS DB/DC, VSAM, SAS, PL1, SQRibe, Mark IV, RAMIS, TOTAL and ENVIRON/1 to Enterprise COBOL with DB2 and/or IMS DB/DC.
* SAS experience focused on Health, Statistical, Accounts Recoveries, Financial and Quality Assurance and Analysis models. Worked extensively with SAS to provide analysis, statistics, auditing, proofing and support of new development, enhancements and Production Support. Application support/maintenance/enhancement of SAS/DB2 applications.
* Developed and enhanced COBOL and Assembler IMS DB/DC and DB2 Online Transactions as well as Batch Inquiry and Maintenance programs. Added DB2 functionality to Conversational IMS DC Applications. Designed DB2 tables for new and replacement applications. Designed IMS Databases and VSAM Files in support of new and/or existing IMS systems. Designed, developed and implemented enhanced security and Audit Logging and Reporting functions for DB2 and IMS DB/DC Systems.
* Provided Production Support, Maintenance, and Functional and Business Mandated Enhancements as required. Worked closely with senior management and business units to ensure enhancements met specifications within time and budget constraints.
* UNIX, Korn Shell Scripting, and Perl in support of a Legacy Financial Reporting System for Firm-wide Financial Analysts reporting on investments and commissions.
STEVEN A. SAUL
PROFESSIONAL EXPERIENCE
03/12 – 04/13: Health Management Services SAS Support, DB2 Conversion, Technical
Documentation
Skills Used: SAS, DB2, Toad for DB2, COBOL, Assembler, MS Access, Endevor, InfoMan
Industry: Health Claims Recoveries
* Provided maintenance, enhancement and Production Support of a SAS based application for various contracts using SAS Indexed Files as the Legacy based database, followed by upgrade to DB2.
* Support of SAS Indexed Files, conversion to DB2 and pseudocoding of SAS programs for subsequent development to Informatica.
* Worked remotely on assigned Tracks with daily Agile Scrumm Status Meetings. Adhoc enhancements in support of client changes/upgrades in a fast-paced Production environment.
* Provided debugging and enhancements to additional supporting COBOL and Assembler programs, as well as stand-alone MS Access applications.
12/09 – 02/12: Morgan Stanley Smith Barney Legacy Support Specialist
Skills Used: SAS, DB2, SPUFI, QMF, SQRibe, UNIX, Korn and Bash Shell Scripting, Perl, Adobe Distiller
Industry: Brokerage / Financial
* Provided maintenance and Production Support of a legacy mainframe application (SQRibe, DB2, PostScript/PDF), and related Unix / Perl / web-based financial reporting system.
* Application generates over 1600 PostScript reports on a monthly basis for a Firm-wide Financial Analysts reporting on investments and commissions. These reports are uploaded first to an associated Unix/Perl application which provides additional processing (Postscript to PDF), splits the reports by Financial Advisor, Branch, Region, Division and Firm, and then uploads them to an internal website.
* Supported a complex SAS/DB2/VSAM mainframe application providing investment Sales Aggregate and Year-to-date data which is then transmitted to a Unix-based Business Objects application via NDM transmission for inclusion to other reporting Applications.
* Involved in Morgan Stanley and Smith Barney merger and subsequent Conversion to a common application base.
12/11 – Present : Big Apple Pen Club Web Designer / Developer
Skills Used: HTML5, CSS3, Javascript
Industry: Non-Profit (Club)
* Designed, organized and developed a Hobby website. Site is still under development. Approach was to determine function and form, putting up a Home Page with a working drop-down menu. This provided feedback from the club members to organize the site accordingly. Also, as Webmaster, handled all administrative details, including domain registration, selection of hosting provider, creation of email ids for select individuals, and creating a member mailing distribution list.
06/09 – 12/11 : AllWriteNow Web Designer / Developer
Skills Used: HTML, CSS, Javascript
Industry: Retail Sales
* Replaced and enhanced a Retail Sales web site, resulting in a four-fold increase in sales and a ten-fold increase in visitors. Enhancement involved better organization, presentation as well as site navigation.
09/08 – 03/09 : State of Georgia Medicaid Legacy Conversion Specialist
Skills Used: Enterprise Cobol, DB2, SPUFI, CICS, VSAM, TOTAL, Environ, EasyTrieve, Xpediter, SAS, FileAid,
Industry: State Agency / Health, Medicaid
* Participated in the legacy conversion effort of a Health Reporting System for a State Agency to convert COBOL/TOTAL and ENVIRON to Enterprise COBOL with DB2 versions 7 and 8 for batch and online, resulting in multi-million dollar savings, simplifying maintenance and future enhancements.
* Used SAS and DB2/SPUFI as data analysis and verification tools to ensure program accuracy.
* Worked with proprietary conversion tools, Changeman, Xpediter, FileAid and SPUFI to handle the conversion and Quality Assurance testing against a user prepared Baseline.
* Used TestTrack Pro for Project Management reporting.
STEVEN A. SAUL
PROFESSIONAL EXPERIENCE
11/06 – 07/08: Con Edison Legacy Conversion Specialist
Skills Used: Enterprise Cobol, DB2, SPUFI, SAS, IMS DB/DC, VSAM, ISAM, Mark IV, RAMIS, Xpediter, PL/1, VSAM, Assembler, EasyTrieve
Industry: Utilities
* Performed initial Business Analysis of affected and related systems, files and Databases to determine impact and implementation schedules.
* Worked with a team on a legacy conversion effort of Mark IV and Ramis programs to Enterprise Cobol using IMS and DB2 databases. Performed Baseline regression testing, Quality Assurance testing and final Systems Assurance testing leading to Production implementation.
* Used SAS and DB2/SPUFI as data analysis and verification tools to ensure program accuracy.
* System Testing, Quality Assurance and Production implementation of converted IMS application successfully completed.
* Also converted ISAM to VSAM for Assembler based programs.
06/06 – 11/06: Citigroup Quality Assurance
Skills Used: Enterprise Cobol, SAS, DB2, SPUFI, CICS, Mercury Quick Test Pro (QTP), VSAM, Job Scheduler
EasyTrieve, MS Excel, DB2 Stored Procedures, MQ Series
Industry: Financial
* As a Senior Tester, developed Test Plans and Unit Test Cases in support of an ongoing testing effort using test scripts in Quick Test Pro and Robot (client developed software).
* Extensive use of custom-built SAS programs used to perform Quality Assurance testing.
* Provided a Test and Audit function to assist in the sale of almost two-dozen branches and their associated customers to another bank, resulting in $1.1 billion dollars in sales income.
* Performed QA testing of IMS and DB2 applications.
* Audit functions required the development of DB2 queries in SPUFI and SAS, as well as working with existing CICS screens, DB2 Stored Procedures and MQ Series..
07/05 – 05/06: State Farm Insurance Programmer / Business / Systems Analyst
Skills Used: Enterprise Cobol, PL/I, DB2, IMS DC, Xpediter, SPUFI, SQRibe, DB2 Stored Procedures
Industry: Insurance
* Provided enhancement, Production Support, and development in support of the Online and Batch Internal Cash application, which processes all premium payments received for Auto, Health, Fire and Theft insurance policies on a daily basis.
* Performed Business Analysis impact study of requested enhancements and devised Audit Proofing criteria.
* Highly visible project retains policy and payment information in DB2 partitioned tables (V8 and V9) across networked regional offices using DB2 Connect as well as IMS DC v8 and v9.
* Coded and maintained highly complex DB2 queries and updates and DB2 Stored Procedures.
07/04 – 05/05: Depository Trust and Clearance (DTCC) Systems / Business Analyst
Skills Used: Assembler, DB2, SPUFI, CICS, MS Excel, MS Word
Industry: Brokerage
* As the Senior Business Analyst, extracted and documented the Business Rules and functionality of a high-volume legacy Clearance and Settlement transaction system written in Assembler, batch CICS and DB2. Assembler macros were used extensively to dynamically generate data and functional-specific assembler code. As the core application of the business, extracted Business Rules were discussed with senior management and other relevant business users in weekly meetings.
* Analyze various technologies to attain superior processing capabilities for an existing system handling over $3 Trillion dollars in securities settlement daily, with over 1400 transactions per second.
STEVEN A. SAUL
PROFESSIONAL EXPERIENCE
02/03 – 03/04: Cendant Corporation (Car Rental) Systems / Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, DB2, SPUFI, QMF, MS Word, Excel, Visio, Project,
Panvalet, Xpediter, SAS, VSAM
Industry: Car Rental
* Business Analysis of both Avis and Budget processing requirements and product mapping was performed prior to coding to ensure system compatibility.
* Successfully developed a Budget version of the Avis Rental and Reservations System, to allow both Avis (corporate) and Budget (personal) systems to share a single fleet of vehicles.
* Major portion of the online system written in Assembler, IMS DB/DC and DB2 with remainder in Cobol2, IMS DB/DC, DB2 and VSAM.
* Conversion effort also required use of SAS to track Rate and Discount relationship changes.
* Also worked with Orion, an application for smaller, independent rental locations.
06/02 – 02/03: MBNA America Business Analyst, Programmer Analyst
Skills Used: Cobol, Assembler, IMS DB/DC, DB2, SPUFI, QMF, MQ Series, SAS, CICS, SQRibe
Industry: Financial
* Business Analysis requirements work involved investigating and documenting an in-house developed replacement for Experian, a real-time Credit Card Scoring System.
* Wrote new Cobol2 / DB2 / MQ Series programs and modified existing Cobol2/DB2 and Assembler/DB2 programs as enhancements in support of this effort along with enhancements to DB2 Stored Procedures..
* Followed Structured Systems Design and Program Specifications protocol as per client requirements.
* Used SAS to assist in the Program Specifications to track field inter-relationships.
02/02 – 04/02: First Data Merchant Services Programmer Analyst
Skills Used: Program Analysis, Assembler, Cobol2, IMS DB/DC, Panvalet, IBM TEST Facility
Industry: Financial, Credit Card Processing
* Provided enhancement of online Assembler programs to extract and pass Credit Card Track Data and other critical fields for Home Depot (Private Label) credit card processing in an effort to reduce fraud, as well as to provide the capability for cross-country purchasing.
06/01 – 12/01: First Data Merchant Services Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, Panvalet, IBM TEST Facility
Industry: Financial, Credit Card Processing
* Modified existing online Assembler programs to remove built-in test facilities for MasterCard, VISA, American Express and Discover Card approval processing and port them to new external Assembler programs callable by the Production System.
01/00 - 03/01: Empire Blue Cross Blue Shield Systems / Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, DB2, VSAM, SAS, SPUFI, QMF, Project Management,
MS Word, Excel, Project Manager, Endevor, Xpediter, SQRibe
Industry: Health Claims
* As Project Lead, provided support to correct Production problems due to Y2K related errors. Used SAS to analyze and develop a comprehensive solution for archival restoration of deleted IMS Database records.
* Ongoing Business Analysis requirements were needed to produce ad hoc reports written in COBOL2 and SAS.
* Performed a comprehensive analysis of Product Code Rates across various data repositories eliminating duplicates and out-of-date Rates.
* Enhanced several online IMS transactions based on business rules changes. Created test data, masking sensitive data components for Quality Assurance testing.
* Worked on Nexxt Health initiative, an in-house Internet business designed to provide Medical professionals easy access to patient subscriber status and real-time claims resolution.
* Provided software migration support for the Nexxt Health Initiative, including conversion of existing IMS and DB2 databases to VSAM in preparation of new Internet application. Used SAS to facilitate the reporting of data fields and correct data relationships involved in this conversion effort.
STEVEN A. SAUL
PROFESSIONAL EXPERIENCE
02/97 - 12/99: Chase Manhattan Bank Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, DB2, SPUFI, PL/1, CICS, VSAM, Endevor, Xpediter,
MS Word, Excel, Metacobol, Job Scheduler
Industry: Financial
* Project leader and technical expert to convert existing batch Demand Deposit Account (DDA) Posting System from METACOBOL / IMS to COBOL2 / IMS
* Successfully converted multiple applications for Year 2000 compliance.
* Provided subsequent Production Support and applications enhancements.
02/96 - 12/96: Citibank, NA Programmer Analyst
Skills Used: Cobol2, IMS DB/DC, DB2, VSAM, SAS, Endevor, MS Word, Excel, EasyTrieve
Industry: Financial
* As the senior technical consultant, provided analysis and programming support to develop and place into production a central warehouse repository of data across all businesses and subsidiaries to support the Federally mandated CRA/HMDA (Community Reinvestment Act/Home Mortgage Disclosure Act) reporting requirements using SAS.
10/95 - 02/96: American International Group [AIG] Programmer Analyst
Skills Used: Program Analysis, Cobol2, DB2, SPUFI, QMF, SAS, MS Excel, Endevor
Industry: Insurance
* Provided Production Support and enhancements for an existing Policy and Claims DB2 Batch system.
11/94 - 10/95: Con Edison Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, DB2, SPUFI, PL/1, CICS, MS Word, Excel,
Endevor, Xpediter, VSAM, SAS, EasyTrieve
Industry: Utility
* Developed a highly visible DB2 and IMS application involving frequency of electric motor inspections. Provided cross-application data extracts as required.
* Provided Production Support for several Service Support Operation systems, and ad hoc DB2 reports to assist field engineers in controlling city-wide gas, steam and electric services.
07/94 – 03/99: JAR Car Rental Company Programmer Analyst
Skills Used: Paradox, Visual Basic, MS SQL Server
Industry: Car Rental
* Designed, developed and successfully installed a Car Rental System using Paradox, a non-Windows based programming language and database.
* Redesigned and rewrote application in Visual Basic and MS SQL Server in anticipation of business expansion.
05/94 - 11/94: Joseph E. Seagram & Sons Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, DB2, MS Word, Excel, Endevor, Xpediter, SAS
Industry: Retail
* As the Lead Analyst, was responsible for converting an existing Assembler/IMS application to COBOL2/DB2.
07/93 - 12/93: National Westminster Bank Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, DB2, SPUFI, QMF, Endevor, SAS
Industry: Financial
* Provided systems development and production support for a Multi-Branch Acquisition in the Demand Deposit Accounts [DDA] area. Extensively used SAS to provide mapping solutions and reports between the various Banking products used by East River Savings.
STEVEN A. SAUL
PROFESSIONAL EXPERIENCE
10/92 - 07/93: Con Edison Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, DB2, SPUFI, QMF, Xpediter, CICS, Endevor
Industry: Utility
* Modified a complex IMS DC Conversational System to interface to a new DB2 system currently under development.
* Additionally, designed and coded the DB2 Month-end Reporting and Maintenance subsystem.
11/91 - 10/92: United States Trust Company Programmer Analyst
Skills Used: Assembler, Cobol2, IMS DB/DC, Panvalet
Industry: Financial
* Provided maintenance and enhancement support for several Assembler and COBOL IMS Online and Batch systems.
* Handled address correction software to provide accurate address, city, state and zip code information for client database.
* Provided Production Support as needed.
01/86 - 11/91: Federal Reserve Bank of New York Project Manager
Skills Used: Cobol2, Assembler, IMS DB/DC, DB2, Panvalet, VSAM, Project Management
Industry: Financial
* Worked on a major IMS DB/DC systems development effort, designed Databases, wrote majority of program specifications, provided technical support and specified modular components to simplify program development for junior programmers.
* Designed and developed a job submission interface between IMS and the system Internal Reader for data transmittal between systems..
* As a Senior Project Leader, I was responsible for several applications and over a dozen programmers in the maintenance and enhancement of existing IMS DB/DC systems.
* Provided continued Production Support, and Enhancements as per user requests and Ad hoc reports. Scheduled work load based on priority of User Requests and Staff Availability, keeping Users and Senior Management continuously apprised.
10/84 - 12/85: Citibank, NA Programmer Analyst
Skills Used: Cobol2, Assembler, IMS DB/DC, Panvalet, IDMS/ADSO
Industry: Financial
* Developed an Online Inquiry System using IDMS/ADSO in COBOL.
* Assisted in the design and development of an IMS DB/DC system written in PL/1.
05/82 - 10/84: Financial Information Services Agency of NY [FISA] Project Manager
Skills Used: Assembler, Cobol2, IMS DB/DC, Panvalet, VSAM, Project Management
Industry: City Agency
* In my role as an IMS Database Administrator, provided support of various IMS DB/DC systems.
* Became a Deputy Director in the Applications Group, supervising several programmers in support of a number of existing IMS DB/DC systems.
EDUCATION
09/1964 - 06/1968 George Washington High School Liberal Arts Degree New York, NY
09/1968 - 06/1969 Manhattan Community College NY Transferred to CCNY New York, NY
09/1969 - 06/1971 City College of New York 108 Credits - Computer Science Major (No degree) New York, NY
Contact this candidate