Extensive mainframe experience using COBOL, PL/1, SQL, DB2 Stored Procedures, JCL under MVS and/or OS/390 operating system. Solid demonstrated experience in System Maintenance and Full Project Life Cycle (Systems Analysis & Design, Program Specifications, Development, Testing, and Implementation). Strong leadership qualities with excellent communication skills.
COBOL, SQL, Stored Procedures, PL/1
MVS, OS/390, z/OS
JCL, RUMBA, TSO, ISPF, RDZ/Xpediter, File Manager, SPUFI, Autoflow, MS Office Outlook, Lotus Notes, SharePoint
Projects worked on while in Statefarm account:
AGT-ID to ASSOC-ID Conversion (December 2014 to present)
Remove from MPD Host applications any use and reference to an Agent's SSN/TIN due to its sensitivity being a Non-Public Information (NPI) data.
Canada Migration Program (CMP) Day 1 (August 2014 to December 2014)
Separate Canadian customers from U.S. customers in preparation for State Farm transition to Desjardin of Canada business.
SFOP/AIMS Migration to Associate Register (April 2013 to August 2014)
Changed all MPD Host applications to retrieve agent information from Associate Register (AR) database instead of from SFOP and AIMS.
Accelerated Client 2.0 Project (December 2011 to October 2012)
Migrated 27 regional Client Register (CR) databases into one central Master Party Detail (MPD) data store in HAPlex.
Migrate FDW Publish Process to MPD (March 2011 to May 2012)
Move the source of Client-to-FDW Publish process from regional Client Register to Enterprise MPD database.
FDW Impacts of Enterprise Matching (January 2010 to April 2011)
Enhancement of FDW's (Federated Data Warehouse) Client Integration System to accommodate process changes introduced by Enterprise Client Matching.
Enterprise Client Matching Project (October 2009 to September 2010)
Migration of regional Client Matching application to Enterprise level so the same client from Illinois region and from Missouri Region can be identified as one and the same customer.
Migrate Client Register to WCC (January 2008 to September 2009)
Developed a brand new tool that will validate the accuracy of the data in WCC after the migration from Client Register database.
Financial Vendor Data Store (May 2006 to December 2007)
Enhancement of the application that maintains the financial information of all Statefarm Vendors
Vendor DBVal Project (January 2005 to June 2006)
Created new batch application that performs a monthly Database Validation between Statefarm's Client Register and three of its vendors (Bank, Mutual Funds, and Humana)
Regional Client Matching Project (August 2004 to March 2006)
Enhanced both batch and on-line processes that determine if a newly created customer in the regional Client Register is already an existing client in the database.
Auto MLD Discount Project (September 2003 to August 2004)
Introduced a batch application that provides Auto Affiliate client details of customers having policies other than Auto.
COBOL, Communication, Conversion, Data Validation, Debugging, Documentation, IBM Mainframe, DB2, MVS, IMS, IMS DB, IMS DC, Insurance, Inventory, ISPF, ITIL, JCL, Leadership, Lotus Notes, Migration, MS Office, office, Outlook, SharePoint, OS/390, PL/1, Project development, QA, Requirement, RUMBA, SPUFI, SQL, System design, System documentation, Systems Analyst, Technical support, Technical assistance, TSO, Validation, Xpediter
Companies Worked For:
Job Titles Held: