We provide IT Staff Augmentation Services!

Senior Programmer Analyst Resume

Sacramento, CA

PROFESSIONAL SUMMARY:

  • Detail - oriented, responsible IT professional with over 20 years of experience in IDMS, DB2, analysis, and application support throughout complete SDLC.
  • Experience includes business/systems analysis, programming, test plan/case definition, testing, documentation, implementation, and production support.
  • Experienced in batch and online database systems on multiple platforms, interface analysis and testing. Advanced IDMS skills, responsible, flexible team member.
  • Analyzed legacy systems and developed conversion specifications.
  • Provided analysis, coded and modified IDMS, DB2, COBOL programs.
  • Gathered user/client requirements, coded new development and enhancements.
  • Provided Entire SDLC Support of applications.
  • Conversion and analysis experience on complex system applications.
  • Provided product support, mainframe and web/distributed testing.
  • Provided business, functional and technical specifications and documentation.

TECHNICAL SKILLS:

  • IDMS
  • DL/1
  • DB2
  • Oracle 8i
  • COBOL, COBOL II
  • ADS/O
  • EASYTRIEVE PLUS
  • ASSEMBLER
  • Z/OS
  • OS/MVS
  • OS/MVSE
  • VM/CMS
  • IMS
  • DOS/VSE
  • CICS
  • ADSA, ADSC, IDD, MAPC, AMU, DMLO, DBOL, Debugger
  • VSAM
  • JCL, SDSF, IOF
  • TSO/ISPF
  • SharePoint
  • REMEDY, SAR, AMIPRO
  • ABENDAID
  • FILEAID, File Manager
  • Xpediter, DEBUG
  • BMS
  • ChangeMan
  • ENDEVOR (ENDEAVOR)
  • FTP, FTS
  • QMF, Spufi
  • WORD, EXCEL
  • VISIO, Gane-Sarson
  • POWERPOINT
  • CA-7
  • Mercury Test Director, HPQC, ALM, Attachmate
  • GOVERNMENT Employment History, Claims, Payments
  • PAYROLL, CASH, ACOUNTS RECEIVABLE, ACCOUNTING
  • PRICING, DISTRIBUTION
  • INSURANCE, STUDENT LOAN GUARANTOR SYSTEM
  • CUSTOMER, SALES ORDER
  • ENGINEERING
  • INVENTORY
  • TELEPHONY
  • PHARMACEUTICAL DISTRIBUTION

EXPERIENCE:

Confidential, Sacramento, CA

Senior Programmer Analyst

Responsibilities:

  • Provided systems and data analysis for transactions in Payroll Input Processing (PIP) system in Employment History (EH).
  • Developed mass update programs for California State University (CSU) retirement data, Affordable Care Act (ACA) status code.
  • Modified and developed programs for Other Post Employment Benefits (OPEB) project in EH.
  • Provided product/UAT support.
  • Provided consultation to management regarding future IDMS to DB2 conversion.

Environment: Utilized IBM Mainframe, COBOL, IDMS, ADS/O, TSO/ISPF, CICS, Syncsort, VSAM, FileAid, File Manager, IBM DEBUG, MS Word, Excel, SharePoint, Advantage.

Confidentia, Sacramento, CA

Systems Analyst

Responsibilities:

  • Provided systems and data analysis of revenue system component for Regional Railroad Accident Preparedness and Immediate Response (RRAPIR) fee project.
  • Provided analysis and system test support for Mobile Telephony Services (MTS) through three project phases.
  • Analyzed system requirements for Cigarette Licensing Fee (CLF) project.
  • Provided product support, mainframe and web/mid-tier system test scenarios, data analysis.
  • Provided VSAM, FileAid and TSO support.

Environment: Utilized IBM Mainframe, TSO/ISPF, CICS, Syncsort, VSAM, FileAid, MS Word, Excel, SharePoint, .Net Server.

Confidential, Sacramento, CA

Consultant Programmer/Analyst

Responsibilities:

  • Conducted analysis on CCR (Continued Claims Renewal) insurance claims system Overpayment (OP) and Payment subsystems, resolved implementation defects.
  • Researched, created VISIO overview of system/interface flow.
  • Modified, tested, implemented program logic for IDMS-based DB2 applications and DB2 applications using native DB2.
  • Responsible for analysis, logic and package integration for CCR and Treasury Offset Project (TOP).
  • Provided VSAM impact analysis, wrote backup and restore JCL for impacted VSAM files.
  • Provided support for Re-Employment Assessment (REA) project implementation.

Environment: Utilized IBM mainframe, TSO/ISPF, COBOL II, CICS, Syncsort, VSAM, FTP, Z/OS JCL, IOF, SAR, DB2, SQL, IDMS V16, IBM Utilities (IDCAMS, IEBGENR, IEFBR14), ATERAS software, Changeman, Smart/RESTART, FileAid, Xpediter, HPQC, ALM, MS Word, Excel, VISIO, Outlook, SharePoint, Attachmate, Spufi, TestBase/Softbase, XML, .Net Server.

Confidential, Sacramento, CA

Systems Analyst

Responsibilities:

  • Provided analysis and system test support for new ALR (Automated License Renewal) system.
  • Scribed, co-led, and participated in JAD sessions, documented issues and requirements.
  • Coordinated with SME (Subject Matter Expert) to provide data for system testing staff, Created, modified JCL.
  • Identified and documented application and interface defects.

Environment: Utilized IBM Mainframe, TSO/ISPF, CICS, Syncsort, VSAM, MS Word, Excel, .Net Server.

Confidential, Sacramento, CA

Consultant Programmer/Analyst

Responsibilities:

  • Conducted and documented analysis necessary for high volume database IDMS to DB2 Conversion.
  • Modified, tested batch and online IDMS, DB2 applications.
  • Responsible for initial analysis, coding and implementation for Smart/RESTART print/restart utility conversion involving 38 programs, 256 PROCs, requiring 38 control cards.
  • Lead 7 people coding and unit testing ARIES to Smart/RESTART JCL conversion, instructed programming staff in usage of Smart/RESTART.
  • Created cross-reference matrix of SCDB components converted for Smart/RESTART, provided extensive documentation for turnover.
  • Tested entire Child Support subsystem for Weekly Benefit Amount (WBA) expansion project, identified additional necessary modifications.
  • Coded SQL queries, high performance unloads/loads for data, JCL and modifications for Re-Employment Assessment (REA) project.
  • Added program logic, performed online, batch and Client-Server SOAP unit testing for DIA (Deloitte project).

Environment: Utilized IBM mainframe, TSO/ISPF, COBOL II, CICS, ASSEMBLER, Syncsort, VSAM, FTP, Z/OS JCL, IOF, SAR, DB2, IDMS V16, DMLO, IDD, OLQ, VISIO, CA Detector, IBM Utilities (IDCAMS, IEBGENR, IEFBR14), Changeman, FileAid, Xpediter, HPQC, MS Word, Excel, Outlook, SharePoint, Attachmate, SOAP, Spufi, Easytrieve Plus, .NET Server, ATERAS software, Softbase.

Confidential, Austin, TX

BSA/Programmer/Analyst

Responsibilities:

  • Researched and documented current Lender Manifest (LM) student loan guarantor system.
  • Created dataflow, process flow diagrams of Lender Manifest (LM) subsystem and application documentation for jobs, programs in LM.
  • Gathered requirements, coded new IDMS programs, JCL, and enhancements for B2B Electronic Signature capability.
  • Wrote, tested mainframe to client-server reporting application that, through FTP to Client-Server, simulates real-time processing.
  • Modified, tested Real Time CICS response applications.
  • Wrote high-level functional and physical design, detail specifications, Created walkthrough packet deliverables.
  • Facilitated user training, acceptance testing (UAT).

Environment: Utilized IBM mainframe/utilities, TSO/ISPF, COBOL, CICS, Syncsort, VSAM, FTP, Z/OS JCL, SDSF, DB2, IDMS V16, DMLO, ADS/O IDD, OLQ, VISIO, Gane-Sarson, IBM Utilities (IDCAMS), FileAid, Xpediter, Mercury Test Director, MS Word, Outlook, SharePoint, Attachmate, Tranrunner.

Confidential, El Segundo, Ca

Data Specialist

Responsibilities:

  • Gathered business requirements for distribution system proof of concept.
  • Wrote and modified COBOL extract programs to create files for customer information proof of concept.
  • Modified IDMS programs, ADS/O dialogs.
  • Created interface files for AS400.
  • Mapped data, created data history documentation.

Environment: Utilized IBM, Z/OS, TSO/ISPF, VSAM, COBOL, IDMS V14, IDD, Excel.

Confidential, Portland, OR.

Business Analyst

Environment: al Consulting Company (No longer in business)

Responsibilities:

  • Gathered project requirements for environmental consulting business.
  • Designed, coded, tested applications for customer, billing systems.
  • Developed reports for consulting projects.
  • Customer liaison for client projects with James River Corporation (Washington), Vanport Manufacturing (Oregon).

Environment: Utilized COBOL, VSAM, CICS, Oracle 8i, PL/SQL, Microsoft Word, PowerPoint, EasyTrieve Plus.

Confidential, Anaheim, CA

Programmer/Analyst

Responsibilities:

  • Designed, coded, documented and implemented COBOL IDMS and DB2 programs for Customer system.
  • Converted programs from IDMS 12.0, ADS/O to DB2.
  • Provided new development and legacy modifications for Y2K.
  • Provided complex systems analysis. Met with users, defined and documented business application conversion.
  • Applied major modifications to existing IDMS, ADS/O, DB2, COBOLII systems including Accounts Receivable and Cash.
  • Successfully navigated complex QA system.

Environment: Utilized IBM mainframe, DB2, JCL, COBOL, VSAM, CICS, FTP, IDMS V12, IDD, ADS/O, MAPC, DBOL, ADSA, QMF, SQL, DEBUGGER, MS WORD, EXCEL.

Confidential, Pasadena, CA

Programmer/Analyst

Responsibilities:

  • Defined and documented business and application requirements for DB2 conversion project.
  • Designed and created stored database calls/procedures.
  • Modified, tested COBOL programs with generated code (COGEN) to DB2 for DB2 conversion project.

Environment: Used IBM mainframe, JCL, TSO/ISPF, COGEN, COBOL, DB2.

Hire Now