Jean Agren Email & Phone Number

Greater Philadelphia

Greater Philadelphia Area

Consultant at Vanguard • Created and enhanced DB2 Stored Procedures to support web applications for Retail Investments including Client Services, Holdings, and Accounts.• Analyzed and documented Stored Procedures for transitioning data from DB2 to DynamoDB.• Wrote ad-hoc queries using SQL to extract data from DB2 tables. • Wrote EASYTRIEVE DB2 programs to create files and reports.• Deployed code using Endevor through various test regions into Production. • Enhanced the performance of sql statements using Apptune. • Participated in daily Scrum meetings. Created and maintained stories on the JIRA board.

Greater Philadelphia Area

• Migrated billing data from a mainframe platform at IBC to a new platform at Highmark.• Assisted with supporting Payment and Billing applications using .Net technology. • Designed and coded structured batch COBOL DB2 programs, including programs with VSAM files and embedded SQL statements. Debugged programs as needed. • Created and executed JCL. Created procs containing symbolics for overrides. • Was involved in all steps of the SDLC. Worked with the Business Clients to gather requirements. Wrote Functional Specifications and Detailed Design documents. Documented processes.• Participated in all aspects of testing, including Unit, Functional, and UAT. Created and executed Test Scripts using Test Director.• Elevated code through various test regions into Production using Endevor. • Maintained CICS programs to support the online Billing applications.• Provided Production Support.

Greater Philadelphia Area

Senior Systems Analyst Consultant at Independence Blue Cross • Supported several Billing applications.• Enhanced a Legacy Billing system to display both the prior and current premium benefit coverage and rates.• Created COBOL programs to delete over 9 million rows of old balanced invoice and payment data from several DB2 tables, which enhanced the performance of the billing cycle.

Greater Philadelphia Area

Lead Programmer/Analyst Consultant at Exelon • Supported the PeopleSoft HR and Benefit applications and interfaces.• Was Team Lead for the technical components of the Open Enrollment Benefits processing. Wrote and customized COBOL programs and SQRs. These programs created benefits packages, confirmation statements, feeds to and from a service center, and feeds and reports to various benefit vendors.• Converted COBOL programs and SQRs from a MVS/DB2 environment to a UNIX/Oracle environment. Created Korn Shell scripts to run these programs.• Modified and tested programs for PeopleSoft upgrades.• Modified and created interface programs against PeopleSoft HR and Benefits data.• Mapped HR and Benefits data from a legacy HRMS system into PeopleSoft tables.• Mapped Health and Safety data from a legacy Occupational Injury and Illness system into DataPipe tables.• Supported the legacy HRMS and Occupational Injury and Illness systems. Monitored the Help Desk, and participated in Disaster Recovery Testing.• Completed PeopleTools I, PeopleTools II, PeopleCode, SQL/SQR for PeopleSoft, and Process Scheduler.

Greater Philadelphia Area

Senior Programmer/Analyst• Responsible for the development, coding, analysis, and testing of several Billing systems.• Utilized Express Delivery to mechanize the distribution of hundreds of reports.• Produced files and reports for multiple users.• Participated on various Quality Committees. Programmer/Analyst• Developed, maintained, and tested COBOL programs for Payroll.• Designed and implemented data entry screens for inputting various payroll data such as savings bonds, 401K, etc.• Completed a 3 month Programmer Basic Training Course.