Analyst Systems

Summary: I have diverse experience in the areas of COBOL, IDMS DB/DC, ADS/O, DB/2, CICS and mainframe utilities. Worked with clients in various sectors such as Government, Finance, Health Care, Insurance, and Communications.

Applications/Packages/Utilities/Tools

CA-IDMS (ADS/O, ADS/ALIVE, IDD, OLQ), Changeman, CICS, DB2, CLIST, Easytrieve, Access, BMC Tools, Excel, Endevor, ESP, FileAid, HP Quality Center, ISPF, JCL, Librarian, Microfocus COBOL, Monarch, MVS, Oracle, Platinum Tools, QMF, HP Quality Center, ROSCOE, SPUFI, SQL Developer, SQL Server, Teradata, TSO, UNIX, VM/XA, VSAM, Word, XEDIT, Z/OS.

EXPERIENCE

CONFIDENTIAL EMPLOYER

State of California Medi-Cal Project 10/2011 - Present

• Analyzing and making recommendations for impact changes to Programs, JCL, PROCS, SYSINS & Copybooks for the ICD-9 to ICD-10 project due to Federal requirements.

• Examining COBOL, SAS, Easytrieve & DYL280 code as well other mainframe entities including VSAM files.

Genesis Networks Solutions 03/2011 – 08/2011

Senior Subject Matter Expert, Abilene, TX

• Currently providing support for land based billing for AT&T. Tasks include client support and testing batch (back-end) applications for defects before a software upgrade is released. Coordination of testing is between domestic and offshore personnel. Testing and defect tracking is done using HP Quality Center.

• Use ESP for scheduling batch processes. Creating/modifying ESP networks for automation of jobs versus manual triggering of jobs and applications.

• Override JCL when required for ESP triggered jobs and events.

• Create/modify FILEAID executables.

Environment: AT&T Connect, COBOL, DB2, ESP, FileAid, IMS, JCL, HP Quality Center, VSAM, Z/OS,

United Parcel Service Atlanta, GA

Drivers Helper 11/2010 – 02/2011

• Assisted drivers in delivery of packages during the holiday season and other busy delivery times.

Department of Commerce, US Census Bureau, Atlanta, GA

Enumerator 04/2010 – 05/2010

• Interviewed people for the 2010 census.

• Spoke in both English and Spanish in order to receive information pertinent to the questions asked on the 2010 census form.

IT-Resources, East Setauket, NY

Senior Analyst 05/2009 – 07/2009

• Used Microfocus SOA Express, Mainframe Express and Endevor to develop/modify Web Services for

Blue Cross/Blue Shield of South Carolina. Blue Cross is modifying their applications to be web based instead of mainframe CICS based and is using the Microfocus SOA product suite to serve as middleware through Websphere and MQ Series. The Microfocus product acted as a code generator for Mainframe COBOL and Java front end.

Environment: IBM Z/OS, COBOL, CA7, Endevor, CICS, UNIX, Java

Wal-Mart Stores Inc., Bentonville, AR

Programmer/Analyst 03/2008 – 04/2009

• Maintained and supported MARS (Multinational Accounts Receivable System), COOPS and DEALS for US, Canada, Mexico, Great Britain, Argentina, India, Japan, China & Brazil. Also supported Pharmacy Systems if required.

• Developed a Remedy screen to track manual bills for Shared Services. The screen replaced a manual process using Excel which was prone to error and did not provide traceability for the manual bills. The new functionality also generated e-mail reminders to ensure better cash flow for collections or sending out Dunning notices.

Environment: IBM Z/OS, COBOL, DB2, Easytrieve, IMS, SPUFI, TERADATA

Technology Partners, Chesterfield, MO

Edward Jones, Maryland Heights, MO

Consultant 03/2007 – 12/2007

• Corrected and implemented changes to production problem tickets

• Converted programs from CA-IDMS to DAL (Data Abstraction Layer).

Client is in the process of converting from CA-IDMS to DB2.

• Worked on compliance issues for legal and regulatory requirements.

• Developed DB2 programs for the Financial Advisor oversight project.

Environment: IBM Z/OS, COBOL, DB2, IDMS, SPUFI, ORACLE, TUXEDO

Southeastern Data Cooperative, Tucker, GA

Consultant 11/2006 – 02/2007

• Applied changes to Microfocus COBOL code for GIS Stored Procedures.

• Modified scripts when necessary.

• Tested both batch and online web based programs.

• Ran database queries using Oracle SQL Developer.

Environment: HP 3000 & 9000, Microfocus COBOL, HP UX, Oracle

Longhill Enterprises, NY, NY

Centers for Medicare and Medicaid Services, Baltimore, MD

Senior Systems Analyst/Consultant 11/2005 – 05/2006

• Executed, tested, & analyzed batch and on-line programs for the new Medicare Part D system (MARx). The system is written in COBOL & DB2. There is also a Web based User Interface to enroll beneficiaries in as well.

• Tested scenarios are written to correct software design problems or add functionality to the system when required.

Environment: IBM Mainframe, COBOL, DB2, SPUFI, QMF, BMC tools, JCL.

Indecon, Indianapolis, IN

Sallie Mae, Fishers, Indiana

Senior Systems Analyst/Consultant 06/2005 – 10/2005

• Analyzed, designed, developed, tested and modified batch & online systems for Sallie Mae. Provided assessment and recommendations to remedy production abends.

• Business System Design and Technical Systems Design were written for both domestic and offshore work forces in order to comply with IRS guidelines and requirements for the Taxpayer Relief Act (TRA). The changes made are for reporting of Capitalized Interest (1098-E forms) and W9-S (SSN verification) forms for Sallie Mae's student loan clients.

Environment: COBOL, CA-IDMS 15.0, COBOL, DMLO, Endevor, OLQ, Z/OS, JCL, TSO/ISPF and CA-IDMS ADS/O

AGSI, Atlanta, GA

Verisign

Senior Systems Analyst/Consultant 02/2004 – 06/2005

• Analyzed, designed, developed and maintained on-line and batch programs for a third Party wireless billing system for Verisign.

Environment: UNIX (SCO, AIX). Zortech COBOL, TextPad, Borland Starteam, Applix

Global Commerce and Information Systems, Fredericksburg, VA

Sallie Mae, Fishers, Indiana

Senior Systems Analyst/Consultant 11/2003 – 12/2003

• Analyzed and modified CA-IDMS 15.0 maps and dialogs due to expansion of field sizes or replacement of database records for the Reserve, School & Retirement screens.

Environment: CA-IDMS 15.0, ADS/O, IDD, ADSALIVE, COBOL

CSC (formerly DynCorp), Atlanta, GA

Centers for Disease Control and Prevention Financial Management Office 07/1999 – 01/2003

Senior Systems Analyst/Consultant

• Primary responsibility was for analysis, development, review, execution and debugging of the Federal Success system. Duties also included enhancement to existing on-line IDMS-DC and IDMS-DB batch reports.

• Retrofit code to solve problems incurred due to Year 2000.

• Modified budget reports due to Fiscal Year 2000 changes in the codebook (General Ledger).

• Implemented and maintained the Production Control System in production. The Production Control System is used for scheduling of batch jobs as well as allowing the users to print ad-hoc reports. The Production Control System includes security to allow or prevent access to functions depending upon department requirements.

• Developed models in Monarch for Accounting & Budget users. The models are used to create EXCEL spreadsheets and ACCESS databases which the users can use for analysis.

Environment: IBM Mainframe, CA-IDMS 10.2 DB/DC, OS 390, Microsoft SQL Server, COBOL II, Monarch.

S2 Systems, Atlanta, GA

GE Capital - Retail Financial Services, Atlanta, Georgia 09/1998 – 06/1999

Senior Systems Analyst/Consultant

• Analyzed, developed, reviewed and executed test scripts for validation of the CARMS financial system for Year 2000 compliance. The testing involved validation of 13 specific days to secure Federal Deposit Insurance Corporation (FDIC) validation.

Environment: IBM Mainframe, CA-IDMS 10.2 DB/DC, OS 390, Microsoft SQL Server, COBOL II, CA-ADS/ALIVE,

CA-DMLO, Easytrieve and HourGlass for date simulation.

ASAP Staffing, Norcross, GA

Southern Company, Atlanta, Georgia 06/1998 – 09/1998

Senior Systems Analyst/Consultant

• Analyzed, reviewed, and recommended modifications to CA-IDMS 14.0 DB/DC programs and CA-IDMS ADS/O modules for Southern Company’s Millennium project. Date fields were reviewed for Year 2000 compliance and retrofitted to either expand the size of the date where required or windowing logic was implemented to handle the 21st century.

Environment: OS 390, VM/ESA, TSO, XEDIT, REXX

Keane (formerly METRO Information Services)

Norfolk Southern Railroad, Atlanta, Georgia 06/1997 – 06/1998

Senior Systems Analyst/Consultant

• Analyzed, enhanced, tested, debugged and implemented CA-IDMS 10.2 DB/DC programs for the Norfolk Southern Contract Refund system. Enhancements included modifications to augment search and optimize performance efficiency in the online environment.

• Analyzed, coded, tested and debugged CICS/DB2 online screens for the ROAD Control system. Debugging was done using Compuware’s XPEDITER for CICS, as well as SPUFI and QMF.

Environment: OS 390, ROSCOE, TSO, DB2, IDMS DB/DC, CICS, SPUFI, QMF, XPEDITER

Aquent 06/1995 – 06/1997

Metropolitan Life Insurance (Pensions), Atlanta, Georgia

Senior Systems Analyst/Consultant

• Analyzed, enhanced, tested and debugged CA-IDMS 12.0 ADS/O dialogs and CA-IDMS programs for Metropolitan Life’s CTS online Pension system. Analyzed, enhanced, tested, and debugged IDMS 12.0 batch programs for Metropolitan Life’s pension contracts in a VM/XA and MVS Environment

• Also uploaded/downloaded files from an IBM MVS environment to an MS Access database using PKZIP/PKUNZIP for tracking of data integrity for batch loading of pension contract data.

Environment: OS 390, ROSCOE, TSO, IDMS DB/DC, VM/XA

Bank of America, Concord, California

Senior Systems Analyst/Consultant

• Analyzed and documented Bank of America’s internal float system. The system was developed by J.D. Carreker and heavily modified for bank standards. Documentation included written documentation as well as high level dataflow diagrams.

Environment: PC

Pacific Bell Communications, Pleasanton, California

Senior Systems Analyst/Consultant

• Developed user specifications for Toll-Free (800/888), Usage Processing System, Product Services and Fraud systems for initial product rollout in early 1997.

Environment: PC

The Doctors’ Company, Napa, California

Computer Consultant

• Developed, modified and maintained programs in IDMS DB and COBOL II. Created data and validation reports for migration from an IDMS 10.2 environment to a Microsoft SQL Server Environment Tasks included population of primary and foreign keys and data validation/translation. Additional tasks included maintenance of sweep and merge programs in order to develop the required relationships on the relational database.

Environment: OS 390, TSO, IDMS DB/DC, ADS/O

Hexcel Corporation, Pleasanton, California 11/1994 – 05/1995

Programmer Analyst

• Analyzed, designed, programmed, debugged and modified Computer Associates CAS 3.0 General Ledger System using IDMS ADS/O and VS COBOL II. Provided technical and user support for the General Ledger System. Applied vendor supplied fixes (PTF’s), and in-house customization to the General Ledger System. Assured the integrity of subsystem feeds to the General Ledger System.

Environment: OS 390, TSO, IDMS DB/DC, ADS/O

Computer Task Group, San Jose, CA

MCI, San Jose, CA 10/1994 – 11/1994

Computer Consultant

• Analyzed, designed, programmed, debugged and modified MCI customer billing system using IDMS DB COBOL.

Environment: OS 390, TSO, IDMS DB/DC, ADS/O

Krystal Solutions, San Bruno, CA

Amdahl Corporation - Santa Clara, California 06/1994 -09/1994

Computer Consultant

• Analyzed, designed, programmed, debugged and modified Amdahl’s inventory management system using IDMS DB COBOL and IDMS ADS/O.

Environment: OS 390, TSO, IDMS DB/DC, ADS/O

Vision Service Plan, Rancho Cordova, CA

Database Analyst, 08/1993 – 01/1994

• Analyzed, designed, programmed, debugged and modified in-house journal reports to accommodate both release 10.2 and 12.0 formats. The reports are used to monitor mainframe CPU activity, concurrent database activity, disk activity, throughput & waits; and database retrieval and update statistics.

• Removed and modified data manipulation control language (DMCL), schemas, subschemas and segments for both local and central version dictionaries for CA-IDMS releases 10.2 and 12.0.

Environment: OS 390, TSO, IDMS DB/DC, ADS/O

Education:

B.S. Computer Science,

Florida International University, Miami, Florida.

Training

CA-IDMS 12.0 Database Definition.

CA-IDMS 12.0 Implementing and Maintaining a Database

CA-IDMS IDMS DB/DC

CA-IDMS IDD

CA-IDMS CULPRIT

C (U.C. Berkeley Extension)

C++ (U.C. Berkeley Extension)

Contact this candidate