Developer Life Insurance
Resume:
Robert Saunders
Hartford, Ct *****
********.*******@*****.***
SENIOR IT ANALYST- ETL / MAINFRAME / BUSINESS INTELLIGENCE
KEYSTRENGTHS
MAINFRAME - Insurance Applications Commercial and Personal Lines, Banking, Financial, Retail
Cobol, DB2, SQL, FOCUS, CICS, VSAM, IMS DB/DC, ADABAS, Natural, OS/JCL, EASYTRIEVE, FileAid, Endevor, Panvalet, Changeman, Documerge, Focus, TCP/IP, FTP, EDI, TSO, CA-7, Control-M, QA Testing, REXX, Clist, Xpediter, Intertest, CEDF, XML, MS Office, Sharepoint, Microsoft Access, Excel
DATABASES – DB2, ORACLE, SQL SERVER, TERADATA, IMS DB/DC, ADABAS
ETL - Informatica PowerCenter - version 8.6 version 9.1
DataStage - version 8.1
Webfocus
Autosys
XML
Unix Shell Scripts
BUSINESS INTELLIGENCE
Oracle Hyperion Interactive Reporting - version 8.5, 9.3, EPM 11.1 Oracle OBIEE
Oracle Essbase
Oracle Hyperion Financial Data Quality Management (FDM)
Oracle Hyperion Profitability and Cost Management (HPCM)
Oracle Hyperion Smartview
Oracle Hyperion SQR
JavaScript - Dashboards for all Oracle Hyperion reporting
SQL Queries for Oracle Hyperion Reporting
SSIS/SSRS - SQL Server Reporting Services 2008 (SSRS)
HP Quality Center
Professional Experience
DXC TECHNOLOGY (FORMERLY COMPUTER SCIENCE CORPORATION) Norwich, Ct 08/2015-present
Sr Developer/Analyst – Mainframe - Cobol, DB2, IMS DB/DC, JAVA,OS/JCL
Application Developer assigned to maintain and develop various applications for General Dynamics and Electric Boat related to construction of nuclear submarines. Adhered to SDLC methodologies, all changes subject to source code and test case peer reviews. Created and ran complex SQL queries using DB2 Query, SPUFI and QMF for testing, adhoc reporting, and production issues. Added MQSERIES steps to existing jobstreams to create message queues containing input transactions to new IMS DB/DC programs. Created new reports using EASYTRIEVE obtaining information from Orders and Parts IMS database segments and DB2 tables. Used Xpediter/IMS to invoke interactive session in IMS/DC environment. Provided production support for nightly batch jobs. Used CA-7 to set up and monitor jobs on scheduler. Converted Cobol programs to Cobol3. Made enhancements to Electronic Desktop front-end applications modifying Java code. TSO/ISPF, COBOL, PANVALET, FILEAID, DB2, IMS DB/DC, EASYTRIEVE, MQSERIES, SYNCSORT, INFORMATICA, JAVA
HARTFORD FINANCIAL SERVICES Hartford, Ct
Sr Informatica Analyst - Informatica, DataStage, Webfocus, Mainframe 07/2014 -11/2014
Created Business specifications for new Informatica PowerCenter (version 9.1) jobs and workflows for HR (Human Resources), EFR (Enterprise Financial Reporting), and Peoplesoft applications. Created new reports and made changes to existing reports using Webfocus Developer Studio and DataStage. Modified existing SQL and wrote complex SQL queries using TOAD to resolve production issues and generate new code for Informatica workflows. Monitored all production jobs on a daily basis using Autosys/Unix. Generated FOCUS and Cobol/DB2, extract files on mainframe and XML files that were imported to Informatica Source Analyzer. Tracked and assigned incidents to other team members including offshore team using Remedy and PPM (Project and Portfolio Management Center). Used Citrix to access following apps: WS FTP PRO, TOAD 12.10 G, Webfocus Developer Studio 7, Ascential Datastage 75, 10g SQL Plus, Ultra Edit32
CIGNA CORPORATION Bloomfield, Ct 09/2011 - 04/2013
Sr Application Development Specialist – Hyperion, OBIEE, Essbase, Smartview, ETL, Informatica, Mainframe
Oracle Hyperion Business Intelligence, SQR Developer – Created Datel Model and Business Specifications using Sharepoint for new reports generated for new Healthcare application. Specified Business Rules needed for new scripts created for Hyperion FDM. Created new reports using OBIEE, Hyperion Interactive Reporting 9.3, EPM 11.1, SQR, and JavaScript. Responsible for converting five different applications from Hyperion 9.3 to Hyperion EPM 11.1 in test, staging, and production environments using Oracle Essbase and Oracle Hyperion Profitability and Cost Management (HPCM). Created Informatica PowerCenter (version 9.1) extracts including COBOL/DB2 and FOCUS files generated on mainframe to load to Oracle Hyperion Financial Data Quality Management (FDM) and Oracle Essbase cubes. Compared Informatica extracts back to source files and modified Informatica code where necessary. Verified data on Essbase using Smartview and compared results to initial source files and Informatica extracts.. Databases accessed for Hyperion reporting, Oracle, DB2, Teradata, SQL Server. Used HP Quality Center 10.0 to input test cases and record all defects. SSIS used to extract, transform and load packages to data warehouse. SQL Server Reporting Services 2008 (SSRS) used for Safer application to create business specifications, design, develop, test, and deploy reports. Unix shell scripts and XML used to trigger batch SQR jobs set up on Tivoli Workload Scheduler (TWS) and converted to ESP on mainframe. Paticipated in Macroscope pilot. Set up jobs in Hyperion EPM 11.1 Test Environment for user testing and coordinated production release by application after obtaining user sign-off.
BANK OF AMERICA Windsor, Ct (Remote position) 03/2011- 08/2011
Sr Mainframe Developer/Analyst – Cobol, DB2, VSAM, XPEDITER, EasyTrieve, Focus, Endevor
Assigned to work on CAPS (Comprehensive Analysis and Profitability System) Northwest Transformation Project. Created Business Specifications to added new banks for two new states to support fully analyzed accounts for the Commercial, Small Business, Real Estate, and Premier/Private Banking business client segments. Responsibilities include analysis, coding changes, unit testing, batch cycle JCL and proc modifications to CAPS application. Online screen changes using CICS, Intertest. Created new reports for users using Easytrieve and Focus Report Writer. Cobol, XPEDITER, DB2, CICS, INTERTEST, VSAM, Easytrieve, Focus, CA-7, OS/JCL.
UNITED STATES DEPARTMENT OF AGRICULTURE St Louis, Mo 06/2008 -08/2010
Oracle Hyperion Business Intelligence Developer/Business Analyst Webfocus, ETL, Mainframe
Part of Data Warehouse/Oracle Business Intelligence Team, Analyzed critical business needs and created business requirements, specifications, and new data model for new reports for Rural Development applications including Single Family Housing Direct (Hyperion Interactive Reporting) and Rural Utilities Loan Servicing Systems (Webfocus). Worked on conversion upgrades to Hyperion Version 9.3 and Hyperion EPM 11.1. Supported mainframe applications and set up Informatica PowerCenter (version 8.6), created Cobol/DB2 extracts as part of conversion to EPM 11.1. Created Informatica extracts including XML and COBOL/DB2, Easytrieve and FOCUS files generated on mainframe to load to Oracle Hyperion Financial Data Quality Management (FDM) and Oracle Essbase cubes. Compared Informatica extracts back to source files and modified Informatica code where necessary. Verified data on Essbase using Smartview and compared results to initial source files and Informatica extracts. Monitored Informatica workflows using Autosys, Unix shell scripting. JavaScript used for object-based scripting language. Databases accessed for Hyperion and Webfocus reporting, Oracle, DB2, Teradata, SQL Server. Set up jobs and schedules to create reports in two Hyperion instances for test, and one for production environment. Trained other users and developers the new features of each Hyperion version. Monitored over 150 Hyperion production jobs on a daily basis using and reran jobs to create reports when necessary.
FIDELITY INVESTMENTS, Boston MA 08/2005-05/2008
Senior Mainframe Technical Lead
Retirement Systems - Development project for Required Minimum Distribution Mailings - Cobol, DB2, QMF, CICS, Easytrieve Plus. Formatted letter sent to account holders who were 70 years of age stating IRS requirements for Required Minimum Distribution amounts for current year. Ran DB2 Load/Unload Utilities for testing prior to production release.
Multi-Company Project - Project Leader and Developer –Worked wih QA to create test plan and modify hundreds of existing QA scripts using REXX - Created test plan and clists to automate running test scripts for modifications to online CICS screens for all of Fidelity applications to add fields related to multi-company. Added multi-company field to a number of Cobol, Focus, CICS (CEDF, Intertest), DB2 (including stored procedures) programs and copybooks. Modified SQL statements and code for hundreds of programs for various applications within Brokerage including Order Entry, Mutual Funds, and Fundserv. Set up and executed jobs to load branch specific data to new FSAT region set up for multi-company. Used ClearQuest to monitor all issues and assign to developers. Testing included all phases of Software Development Life Cycle.
CITIZENS BANK Cranston RI 11/2004 - 8/2005
Senior Mainframe Programmer Analyst and Developer
Completed analysis, coding, and testing for tasks related to Citizen’s Bank acquisition of Charter One Bank. New code written in Cobol, CICS, and EasytrievePlus. Used Xpediter extensively in order to resolve all batch issues related to data conversion. Intertest and CEDF used to monitor online screen display. Created JCL and procs for new production jobstreams using Endevor. Completed analysis and testing for all performance issues related to large data conversion files. Provided on-call support for numerous batch cycles in various test regions prior to production release, and provided on-call production support as each phase of project was implemented.
FIDELITY INVESTMENTS, Boston MA 9/1999 – 11/2004
Senior Mainframe Programmer Analyst and Developer
Developed and supported jobs to provide the WebPlaid Contact and Potfolio Management system with daily downloads of data from the mainframe. As a member of the Conversions team, converted data for multiple correspondents onto the Fidelity platform, both batch and online. Conversion modules written in Cobol, DB2 (with complex SQL and stored procedures), and CICS. Easytrieve and QMF used to generate various adhoc reports as requested by user. Created Account Link Files and Reports, Created ID’s and PINS for investors and brokers using Microsoft Access. Created New User Setup Files and Reports using Microsoft Access. Created file extract and Electronic Data Interchange (EDI) transmission jobs for many different correspondents, including File Transfer Protocol (FTP), Network Data Mover (NDM), and Remote Job Entry (RJE) transmissions. Set up jobs on scheduler using Control-M. Provided on-call production support for hundreds of different file extract and EDI transmission jobs.
COMMERCIAL UNION – (ONE BEACON) Foxboro MA 09/1997 – 09/1999
Mainframe – Documerge Business Analyst and Developer
Programming Consultant assigned to work on Group Disability and Workmen’s Compensation enhancement and development projects. Completed creation of business specifications and programming for Group Disability system using Microfocus Cobol. Responsibilities included network rate distribution, network distribution to support system upgrades, and technical assistance to branch offices and agents. Completed major enhancements for Year 2000 compatibility. Assisted in setting up network servers for new branches as a result of merger between General Accident and Commercial Union.
THE NEW ENGLAND LIFE INSURANCE COMPANY Boston MA 03/1997– 09/1997
Mainframe Programmer Analyst and Developer
Programming Consultant assigned to work on mainframe project development. Completed analysis of and enhancements to exisiting IMS DB/DC, DB2 Life Insurance system in order to produce daytime policy output instead of generating policies during the nightly batch cycle only. Modified existing Documerge Variable Data Reformatter (VDR) module and JCL to run DocuMerge job stream. Responsibilities included analysis, programming development, and testing of all Documerge forms generated for Life Insurance policies. Developed JCL and procs to run new system. Determined where new jobs should be set up on the scheduler using CA-7. Worked closely with users to verify output.
COMMMERCE INSURANCE COMPANY Webster, MA 10/1996 – 03/1997
Mainframe, Client Server Programmer Analyst and Developer
Programming consultant assigned to work on Conversion and Interface of existing AS400 system to DB2 Client Server.
Created system design and detail design documents for various functions capturing data from new Policy Management Systems Corporation. Coordinated efforts with PMSC representatives and users to map existing AS400 data to new DB2 tables containing PMSC data. Set up jobs to create and load new DB2 tables. Performed analysis, programming and testing of new Cobol/DB2 programs to collect PMSC data for Claims 1099, Profit Sharing, and Budget Reporting systems.
THE NEW ENGLAND LIFE INSURANCE COMPANY Boston MA 01/1996 – 10/1996
Mainframe Programmer Analyst and Developer
Programming consultant assigned to various projects on the PC and mainframe for LifeInsurance applications. Completed the analysis, programming and testing for enhancements to existing IMS/DC system to call DB2 common access routine to obtain Agent Licensing Information. Documented procedures and modifications needed to existing File Transfer Utility in order to send forms created on the PC using DocuMerge PrintCommander to the mainframe. Developed CLISTS and created panels with various options to submit jobs to load large volumes of Documerge forms that were uploaded from the PC and stored in Panvalet libraries to the Electronic Document Library. Set up jobs on scheduler using CA-7.
ALLMERICA FINANCIAL Worcester, MA 04/1995 – 01/1996
Mainframe Programmer Analyst and Developer
Programming consultant assigned to work on DB2 development projects for Activity Based Costing System for Accounts Payable. Completed analysis, programming, and testing of DB2/COBOL programs for new History/Volume Adjustment process. Set up queries, procs, and forms using QMF. Created JCL to run DB2 programs and QMF procs. Created CLISTS to submit procs and jobs in batch mode. Completed analysis, programming, and testing of new DB2/COBOL2 programs to automate process to create records to be added to General Ledger for Peoplesoft. Created reports using Syncsort summarizing dollar amounts multiple ways by product code, activity code, book type, etc. Set up monthly jobs to create production files and reports for the users.
ChubbLifeAmerica Concord, NH (Apr 1995 – Jan 1996)
Mainframe Programmer Analyst and Developer
Programming consultant assigned to various projects for ChubbHealth medical insurance applications. Set up queries, procs and forms for QMF reports to show annualized premiums for agents by line of business.Cobol/DB2 enhancements to create new I.D. cards with a ‘No Prescription’ option. Completed enhancements to online CICS programs to generate correct run date control record for month-end processing. Created new reports using COBOL2/VSAM to show all policies,employees, and dependents with specific coverage, such as HMO or POS.
COMMERCIAL UNION Foxboro MA 04/1994 – 12/1994
Mainframe Programmer Analyst and Developer
Programming consultant assigned to various projects for Commercial Workmen’s Compensation system. Completed major enhancements to existing system to automate anniversary rating. Added new fields to NATURAL screens and ADABAS segments. Microfocus Cobol, Animator, PROXMVS, SPF/PC
ChubbLifeAmerica Concord, NH 09/1993 – 04/1994
Mainframe Programmer Analyst and Developer
Programming consultant assigned to various projects for ChubbHealth medical insurance applications. Cobol2/DB2 enhancements to Agents Commissions system to add processing for a new company. Tested embedded SQL through Spufi. Set up queries, procs, and forms to generate QMF reports to display all void checks for agents and their total commissions. COBOL2/VSAM development - Analysis, programming and testing of programs to create extract files for all employees and dependents with Medicaid eligibility.
COMMERCIAL UNION Foxboro MA 01/1993 – 09/1993
Mainframe - Documerge Programmer Analyst and Developer
Programming consultant assigned to Business Owners Policy Systems development project. Responsibilities included the formatting of all output documents attached to a policy using DocuMerge. Created tag list and numbered all variable data fields on output documents. Completed analysis, programming, and testing of the Variable Data Reformatter (VDR). Designed and set up jcl to create Rulebase. Loaded forms to Electronic Document Library. Set up test and production JCL to run DocuMerge job stream.
HARTFORD INSURANCE GROUP Hartford, CT 01/1992 – 01/1993
Mainframe Programmer Analyst and Developer
Programming consultant assigned to Personal Lines area to work on various Auto and Homeowners projects. Enhancements to Auto system to generate new I.D. cards and modifications to declarations page. Generated new forms to be attached to policy. Verified output with users. Created new Homeowners reports for year-end processing using Easytrieve Plus and Focus. Completed analysis, programming, and testing of Homeowners rate changes for multiple states. Verified output with users. Cobol, DB2, Focus, Easytrieve
COMMERCIAL UNION Foxboro MA 10/1990 – 12/1991
Mainframe Programmer Analyst and Developer
Programming consultant assigned to Commercial Mass Auto development project. Responsibilities included analysis, coding, and testing of conversion program to convert existing ISI policies to new system format. Completed programming and testing of new declaration page module created using Documerge. Created tag list and numbered all variable data fields on declaration page. Worked closely with users to verify format and placement of hard-coded data and all variable data tags on declaration page. Coded all rating modules using Cobol, ADABAS. Input and manually rated test policies using rate pages. Verified all test results with users.
NATIONAL GRANGE MUTUAL INSURANCE CO Keene, NH 10/1986 – 10/1990
Mainframe Programmer Analyst and Developer
Maintenance projects for Personal Auto, Assigned Risk, and Homeowners. Tasks included CICS map generation, online and batch edits, report modifications, coding and testing of rate changes, and modifications for outside company processing. Project Leader for development of new Dwelling Fire system. Created detailed task plans. Programming responsibilities included creation of online screens using CICS. Completed analysis, programming and testing of rating modules and declaration page module. Created JCL jobstream for nightly batch cycle, and worked closely with scheduling to set up job on scheduler. Documented on-call procedures in the event of system abends.
HARTFORD INSURANCE GROUP Hartford, CT 10/1981 –10/1986
Mainframe Programmer Analyst and Developer
Claims Division – Batch Claims Reporting system - enhancements to various jobs, procs, and reports. OS/JCL, COBOL,FOCUS,EASYTRIEVE
Commercial Lines Division
General Liability - IMS DB/DC maintenance and new development, BTS to monitor online transactions
Worker’s Comp – IMS DB/DC database conversion project. Rewrote rating modules to reflect new segments on database.
Life Division – IMS DB/DC development. Wrote detailed modular specs, coded new programs and conducted structured walkthroughs. Testing included all phases of Software Development Life Cycle. Analysis and development of new reports using FOCUS.
EDUCATION
UNIVERSITY OF DELAWARE - Newark, Delaware 1976-1980
Bachelors Science Degree - Agriculture (excl 1978)
Distinctions - Dean’s List, Varsity Baseball
COLORADO STATE UNIVERSITY - Fort Collins, Colorado 1978
Horticultural Business (junior yr only)
COMPUTER PROCESSING INSTITUTE - East Hartford, Connecticut 1980-1981
Programming Curriculum, COBOL, OS/JCL, ASSEMBLER, RPG
NEW HAMPSHIRE TECHNICAL COLLEGE – Concord, New Hampshire 1994
Introduction to C and C++ Programming
WESTFIELD STATE UNIVERSITY - Westfield, Massachusettes (Online Courses) 2010-2011
Introduction to Java Programming
Introduction to PHP Programming and MYSQL
Contact this candidate