
Suzanne M. Clifford
- SQL Developer
- West Lafayette, IN
- Member Since Jun 14, 2023
Summary:
Senior Analyst and Developer with over twenty years’ experience in all phases of the system development life cycle. Seeking challenging position utilizing mainframe skills and offering exposure to newer technologies. Quickly becomes productive with new systems and technologies and communicates well with non-technical clients.
Technical Skills:
Languages: COBOL II, COBOL, Micro Focus COBOL, CICS, JCL, SQL,
Easytrieve, SAS, DMLO, OLQ, HTML, XML, PHP, JavaScript, CSS, PL1
Databases: DB2, IDMS, DBMS, Sybase, Oracle.
Operating Systems: MVS, z/OS, VMS, UNIX, AIX, DOS, Windows
Hardware: IBM Mainframes, DEC/VAX, Sun Workstations
Tools: TSO/ISPF, File-Aid, Intertest, Xpediter, SDSF, vi editor,
MS Access, Abend-Aid, Xpediter, Endevor, ChangeMan, NDM, CA7
MS Excel, Oracle Discoverer, QMF, SPUFI, Visio, Enterprise Architect (EA).
File Structures: VSAM, ISAM.
Professional Experience:
L.L. Bean through Sunbelt Consulting, Freeport, ME ~ 01/17 – Present
· Created design specifications for new and modified interfaces as part of a Workday implementation. Wrote SQL queries to extract data from legacy system Lawson to load into Workday.
Technology Used: SQL, DB2, Oracle, Excel, Unix
Lincoln Financial through TekSystems, Fort Wayne, IN ~ 10/16 – 12/16
· Worked with DBA to analyze and implement performance enhancements to two long running jobs that were causing nightly processing to exceed the batch window. Reduced run time for one job from 70 minutes to 22 minutes, and another job from 42 minutes to 4 minutes. Participated in knowledge transfer on techniques used to reduce run-time.
Technology Used: Micro Focus COBOL, Windows batch scripting, DB2, SQL
Pentagon Federal Credit Union (PenFed) through Cognizant and Net2Source, Reston, VA ~ 05/16 – 09/16
· Developed and modified code to add Cycle Data and Restraints information from an acquired credit union to PenFed's Hogan System. Worked with the ETL team to redesign and simplify process for future mergers to utilize Talend and a relational database.
Technology Used: COBOL, Easytrieve, Hogan Systems, JCL
Verizon through Bartech Group, Boston, MA ~ 10/15 – 03/16
· Created and modified batch programs and DB2 stored procedures written in COBOL and PL1 as part of a project to enhance on-demand reporting for enterprise customers.
Technology Used: COBOL, PL1, DB2, SQL, JCL, Endevor,
L.L. Bean through Starpoint Solutions, Freeport, ME ~ 01/14 – 10/15
· Worked with accountants to refine sales tax collection and reporting in over 14 states. Analyzed and identified issues with current processing and worked with business team, other internal IT teams, and Software vendors to implement solutions.
· Provided production support for Finance team.
Technology Used: COBOL, DB2, SQL, JCL, SPUFI, Endevor, UNIX, BI Query
HSBC through Protech Software Solutions, Buffalo, NY ~ 05/13 – 12/13
· Modified and enhanced calculations for Basel III risk reporting to US and European Regulators. Created detailed designs from requirements, made code changes to COBOL and SAS programs, and worked with financial analysts to thoroughly system test. High-profile project went in on-time and without issues.
Technology Used: COBOL, DB2, SAS, JCL, SPUFI, Endevor
Lincoln Financial through Starpoint Solutions, Fort Wayne, Indiana ~ 06/12 – 03/13
· Designed, coded and tested job streams to create custom data feeds to third party vendors.
Technology Used: COBOL, CICS, JCL, VSAM, Endevor, Xpeditor, Visio, CA7
CNO through Beacon Hill Staffing Group, Carmel, Indiana ~ 02/12 – 05/12
· Investigated and documented 35 year old legacy system to help determine if system should be replaced.
· Modified batch and online programs to user specifications.
Technology Used: COBOL, CICS, JCL, VSAM, Endevor, Xpeditor
Bank of New York / Mellon through Starpoint Solutions, Wilmington, Delaware ~ 03/11 – 10/11
· Coded necessary changes to transfer application to run on BNY's mainframe and use BNY's preferred technologies due to the sale of PNC's Global Investment Services to BNY.
· Coordinated testing of data feeds with external and internal clients.
Technology Used: COBOL, JCL, VSAM, Endevor, NDM, Rightfax, Synctool
Indianapolis Power and Light, an AES company, though TEKsystems, Indianapolis, Indiana ~ 03/10 – 01/11
· Created batch programs to process and format queued work orders to send as SOAP XML messages via web-services to CGI's CAD system for scheduling.
· Created DB2 Stored Procedures to receive SOAP transactions from web-services.
· Created and modified CICS programs to display data from new DB2 tables.
Technology Used: COBOL, DB2, SQL, CICS, XML, Oracle.
Health Plan of San Mateo County though HP Technologies, South San Francisco, California ~ 03/09 - 02/10
· Created and tested programs to load DB2 database tables with data from legacy AMISYS system.
· Designed, coded and unit tested extract programs to integrate legacy HPSM applications with new installation of HEALTHsuite from RAM technologies
Technology Used: AIX, Micro Focus COBOL, DB2, SQL
EDS, an HP company, West Lafayette, Indiana ~ 09/08 ~ 01/09
· Worked with the Georgia Department of Community Health, Managed Care team to determine requirements and create technical designs for new installation of EDS's interChange system.
Technology Used: UNIX, C, SQL, Oracle
Chicago Mercantile Exchange through Starpoint Solutions, Chicago, Illinois - 9/07 - 08/08
· Designed and coded enhancements to the regulatory system to integrate trade information from the Chicago Board of Trade.
· String and regression tested modifications to the Virtual Detection System.
Technology Used: IBM Mainframe, MVS/TSO, COBOL II, DB2, SQL, Xpediter, SPUFI, ChangeMan.
Kentucky Farm Bureau through UBICS, Louisville, Kentucky ~ 6/07 - 8/07
· Coded and tested programs to integrate legacy database with the new Claims Center application.
· Integration tested new Claims Center application to ensure data integrity kept for all lines of business.
Technology Used: IBM Mainframe, MVS/TSO, COBOL II, DB2, CICS, SQL, SCLM, Xpediter.
JP Morgan/Chase through GCI, Lowell, Massachusetts ~ 9/06 - 04/07
· Modified system to receive financial data from legacy Bank One DDA via MQSeries and batch files.
· Created system design specifications from functional requirements.
· Provided technical support to junior team members and QA analysts.
Technology Used: IBM Mainframe, MVS/TSO, COBOL II, DB2, CICS, SQL, Endevor, Xpediter.
Farm Bureau Insurance through TEKsystems, Indianapolis, Indiana ~ 10/05 - 9/06
· Worked with client to create an accurate and efficient replacement to their nightly transaction process.
· Used Enterprise Architect to perform UML modeling of new system.
· Created detailed designs for less experienced programmers and monitored their progress.
· Designed, developed, and system tested new batch COBOL programs and DB2 stored procedures.
· Developed Access database to track changes to reference data for conversion to CSC’s Exceed system.
Technology Used: IBM Mainframe, ROSCOE, MVS/TSO, COBOL II, DB2, CICS, SQL, SPUFI, Microsoft Access, EA, Abend-Aid, Xpediter, Endevor.
Purdue University through TEKsystems, West Lafayette, Indiana ~ 1/04 - 4/04
· Replaced an interface to integrate the Personnel and Student systems.
· Worked independently with client to determine requirements, develop software, perform QA testing, and monitor production implementation to ensure product delivered matched specifications.
Technology Used: IBM Mainframe, ROSCOE, JCL, COBOL, COBOL II.
Anthem Blue Cross, Blue Shield through Trasys, Indianapolis, Indiana ~ 1/03 - 7/03
· Created and modified programs for HIPAA system designed to exchange privacy information with multiple systems on multiple platforms using DB2 stored procedures and XML input.
· Created and executed QA Test of system.
· Trained Employees on system before handover.
Technology Used: IBM Mainframe, MVS/TSO, JCL, COBOL II, DB2, SQL, Endevor, Abend-Aid.
Regence Blue Cross, Blue Shield through Tech RP, Portland, OR ~ 4/02 - 8/02
· Designed, coded and tested programs to calculate payments to providers.
· Balanced Explanation of Benefits produced by Trizetto’s Facets system with Payments.
· Integration tested interfaces between Facets and other Regence systems.
Technology Used: Unix, Sybase, IBM Mainframe, DB2, Micro Focus COBOL, SQL, MVS/TSO, JCL, Endevor.
Kaiser Permanente through COMSYS, Portland, Oregon ~ 8/01 - 4/02
· Designed, coded and tested COBOL, IDMS programs to extract data from Kaiser's legacy membership system to convert to new COBOL II, DB2 system.
· Designed and created Microsoft Access database to track data relationships during the conversion.
Technology Used: IBM Mainframe, MVS/TSO, JCL, COBOL II, IDMS, DB2, SQL, QMF, Endevor.
Walt Disney World through RCG, Inc., Orlando, Florida ~ 10/00 - 6/01
· Designed, coded, and tested enhancements to Disney's Merchandise, Logistics, and Inventory System.
· Updated Disney's EDI system to reduce manual faxing of purchase orders.
Technology Used: IBM Mainframe, MVS/TSO, JCL, COBOL II, DB2, SQL, CICS, Xpediter, ChangeMan.
First Data Corporation through Empowercom Inc., Denver, Colorado ~ 5/99 - 6/00
· Modified First Data's Electronic Federal Tax Payment System to allow integration of payments from another Federal Tax Agent in the event of a Year 2000 failure. System utilized a multi-tier architecture.
· Analyzed acceptable methods to handle payments.
· Developed Requirements, Design and Test documents.
· Modified and tuned DB2 programs, loads and unloads with input of DBA.
Technology Used: IBM Mainframe, MVS/TSO, JCL, COBOL II, CICS, DB2, SQL, N-tier, ChangeMan.
US West through Productive Data Commercial Solutions Inc., Englewood, Colorado ~ 4/98 - 4/99
· Developed and taught a class for non-technical clients on the Oracle database reporting tool, Discoverer.
· Developed Ad-hoc reports and data extracts from an inventory control system and sent to clients in either Microsoft Excel or Microsoft Access.
· Identified and made necessary Y2K modifications to EDI system.
Technology Used: IBM Mainframe, MVS/TSO, JCL, COBOL II, Easytrieve, VSAM, Oracle Discoverer.
Jeppesen through Productive Data Commercial Solutions Inc., Englewood, Colorado ~ 7/97 - 4/98
· Maintained an order processing and revision control system for a large provider of flight materials.
· Modified EDI programs.
Technology Used: IBM Mainframe, MVS/TSO, JCL, COBOL II, IDMS, Endevor.
US West through Blackstone Consulting, Denver, Colorado ~ 11/96 - 7/97
· Maintained a human resources benefits system for US West.
· Coded and tested batch and on-line programs in COBOL.
· Created reports and extract files using SAS.
Technology Used: IBM Mainframe, MVS/TSO, JCL, COBOL II, SAS, VSAM, Endevor, Abend-Aid, Xpediter.
State of California Insurance Fund through Raymond James Consulting, Denver, Colorado ~ 1/96 - 11/96
· Coded and tested batch programs to convert COBOL I, VSAM based legacy system to COBOL II and DB2.
Technology Used: IBM Mainframe, MVS/TSO, JCL, COBOL II, DB2, SQL, Endevor, Abend-Aid, Xpediter.
Programmer Analyst for American Management Systems, now CGI, Golden, Colorado ~ 11/91 - 12/95
· Managed a team providing onsite support in Madrid, Spain for the implementation of a large cellular phone billing and message processing system on a DEC/VAX, IBM PC Platform using IDMS and Sybase databases. Responsibilities included user training, user support, acceptance testing, as well as fixes and modifications to COBOL and C++ code. System utilized a multiple-tier architecture.
· Analyzed methods to improve performance while adding functionality to a mobile network billing and customer management system. This work was done onsite in Düsseldorf, Germany for a large German mobile phone company.
· Determined user requirements for a software tracking system to be used by project management. Designed and coded screens and reports on an IBM PC platform using Clipper 5.0.
· Coded and unit tested Micro Focus COBOL programs on an open system using Sybase and DB2 databases on UNIX and IBM/MVS platforms.
Technology Used: IBM Mainframe, MVS/TSO, VAX/VMS, JCL, COBOL II, DB2, SQL, Sybase, IDMS, UNIX, C++
Personal Project:
Creator and Co-Founder of MyMoneyPicture.com, April 2012 - Present
Education:
University of Colorado at Denver, School of Business: Denver, Colorado
Graduate Studies in Information Systems. 8/91 ~ 8/92
Indiana University, School of Business: Bloomington, Indiana
Bachelor of Science in Marketing. 8/81 ~ 5/85