Becky Nelson

Cell:949-***-****

Email: acsnld@r.postjobfree.com

PROFESSIONAL SUMMARY:

Detail-oriented, responsible IT professional with over 20 years of experience in database, analysis and application support throughout complete SDLC. Experience includes business/systems analysis, test plan/case definition, programming, testing, documentation, implementation and production support. Experienced in batch and online database systems on multiple platforms, interface analysis and testing. Strong database, analytical skills. Responsible, flexible team member.

Analyzed legacy systems and developed specifications.

Gathered user/client requirements, coded new development and enhancements.

Provided Entire SDLC Support of applications.

Conversion experience on complex system applications.

Provided product support, mainframe and web/distributed testing.

Provided high-level and technical documentation for knowledge transfer.

TECHNICAL SUMMARY:

DATABASES: LANGUAGES:

DB2

IDMS (DDL and DDDL)

DL/1

Oracle 8i

COBOL, COBOL II

ADS/O

EASYTRIEVE PLUS

ASSEMBLER

OPERATING SYSTEMS:

Z/OS

OS/MVS

OS/MVSE

VM/CMS

IMS

DOS/VSE

UTILITIES/ACCESS SOFTWARE:

CICS

ADSA, ADSC, IDD, MAPC, AMU, DMLO, DBOL, Debugger

VSAM, QSAM

JCL, SDSF, IOF

TSO/ISPF

SharePoint

REMEDY, SAR, AMIPRO

ABENDAID

FILEAID

Xpediter, Spufi

BMS

Changeman

ENDEVOR (ENDEAVOR)

FTP, FTS

QMF

WORD, EXCEL

VISIO, Gane-Sarson

POWERPOINT

CA-7

Mercury Test Director, HPQC, ALM, Attachmate

APPLICATIONS:

CASH, ACOUNTS RECEIVABLE, ACCOUNTING

GOVERNMENT

PAYROLL

PRICING

DISTRIBUTION

MANUFACTURING

INSURANCE

CUSTOMER

SALES ORDER

ENGINEERING

INVENTORY

TRANSPORTATION, SHIPPING

TELEPHONY

PHARMACEUTICAL DISTRIBUTION

STUDENT LOAN GUARANTOR SYSTEM

EXPERIENCE:

BAST LLC, subcontract to MCORP, Sacramento, CA.

Programmer/Analyst

EDD, Sacramento, CA 02/14 – Present

Employment Development Department of the State of California. Processes claims, payments for unemployment and disability insurance.

Conducted analysis on CCR (Continued Claims Renewal) system OP (Overpayment) and Payment subsystems to resolve implementation defects.

Researched, created VISIO overview of system/interface flow.

Modified, tested, implemented program logic for IDMS, DB2 applications.

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.

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

BAST LLC, subcontract to MCORP, Sacramento, CA.

Systems Analyst

BOE, Sacramento, CA 07/13 – 02/14

Board of Equalization of the State of California. Processes usage taxes, regulates licensing.

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.

Utilized Unisys Mainframe, TSO/ISPF, CICS, Syncsort, VSAM, MS Word, Excel, BizTalk Server.

BAST LLC, subcontract to MCORP, Sacramento, CA.

Programmer/Analyst

EDD, Sacramento, CA 10/09 – 07/13

Employment Development Department of the State of California. Processes claims, payments for unemployment and disability insurance.

Conducted and documented analysis necessary for high volume database IDMS to DB2 Conversion.

Modified, tested batch and online IDMS, DB2 applications.

Performed analysis and coded program modifications for IDMS logical record (LRF) replacement within programs.

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 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.

Added program logic, performed online, batch and Client-Server SOAP unit testing for DIA (Deloitte project).

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, HPU, MS Word, Excel, Outlook, SharePoint, Attachmate, SOAP, Spufi, .NET Server, Softbase.

C&T Consulting, Austin, TX.

BSA/Programmer/Analyst

Texas Guaranteed Student Loans, Round Rock, TX 3/08 – 10/09

Non-profit student loan guarantor processes data from lenders, claims, serves role of financial central disbursing agent, interfaces with JDEdwards applications.

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).

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.

Login Consulting, El Segundo, Ca.

Unified Western Grocers, Commerce, CA 7/06 – 03/08

Data Specialist

Grocery wholesaler

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.

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

Woodward and Associates, Portland, OR. 02/01 – 06/06

Business Analyst

Environmental Consulting Company (No longer in business)

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).

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

PCL Consulting, Anaheim, CA. 10/97 – 02/01

Bergen Brunswig

Programmer/Analyst

Fortune 200 Pharmaceutical Corporation (Now Amerisource-Bergen located in Pennsylvania)

Designed, coded, documented and implemented COBOL IDMS and DB2 programs for Customer system.

Converted programs from IDMS 12.0, ADS/O to DB2.

New development and legacy modifications for Y2K.

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.

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

JBAI, Pasadena, CA. 7/97 – 10/97

Farmers Insurance, Los Angeles, CA.

Programmer/Analyst

Insurance Company

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.

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

DPRC, Newport Beach, CA: 7/96 – 7/97

Credentials, Orange, CA

Programmer/Analyst

Credit Report Marketing Company (No longer in business)

Gathered, defined business and application requirements for conversion to AS400.

Wrote COBOL data extraction programs.

Analyzed legacy system programs, data and JCL.

Constructed test cases, tested new system AS400 applications for data accuracy and functionality.

Used IBM mainframe, JCL, TSO/ISPF, COBOL II, VSAM, SDSF, SAR, AMIPRO, AS400, Visio.

DPRC, Newport Beach, CA. 11/95 -7/96

Bergen Brunswig, Orange, CA

Programmer/Analyst

Fortune 200 Pharmaceutical Distribution Corporation (Now Amerisource-Bergen located in Pennsylvania)

Designed, coded, modified and implemented programs, JCL and ADSO dialogs for Accounts Receivable, and Cash systems.

Interfaced with users and major customer of fortune 200 distribution company to define application modifications.

Gathered requirements, defined specifications.

Developed and modified programs and files for EDI invoice period end processing.

Modified applications for COBOLII conversion on financial systems support team.

Utilized IBM Mainframe, COBOL, DB2, JCL, TSO/ISPF, VSAM, IDMS V10, ADS/O, DBOL, IDD, OLM, ADSA, ADSG, VPS, FTS.

International Programming & Systems 7/95 – 11/95

Advanced Cardiovascular Systems, Temecula, CA

Programmer/Analyst

Manufacturer of artificial heart components (Now Abbott)

Complex analysis involved defining/gathering user requirements, design, maintenance for legacy IDMS CAS system.

Areas of responsibility included Accounts Payable, Inventory and distribution.

Wrote data extract programs, interfaced with enterprise team for COBOL IDMS to SAP conversion.

Downloaded extracts to server.

Provided product support.

Used COBOL, IDMS V10, CAS, ADS/O, ADSA, ADSG, IDD, OLQ, OLM, Crystal Reports, REMEDY, JCL, TSO/ISPF, VPS, SAR, Windows, Microsoft Word. IBM mainframe, server.

Prodata, Portland, Or. 8/94 – 7/95

Consolidated Freightways, Portland, OR. Programmer/Data Analyst

International transportation/freight Company (now dismantled). I worked on the Emery Worldwide Freight system.

Functioned as team lead for data modeling/mapping team.

Liaison between technical staff and management.

Participated in JAD sessions.

Data modeling for IDMS/DB2 conversion.

Designed, wrote programs for data analysis and extraction in IDMS-DB2 conversion.

Wrote cross-reference programs accessing IDMS internal nested structures.

Assisted development of proof of concept model for enterprise system data warehousing, defined DB2 tables.

Utilized IBM mainframe, COBOL, DB2, IDMS V10, DDL, DDDL, JCL, OLQ, DBOL, TSO/ISPF, EASYTRIEVE PLUS and Syncsort.

Prodata, Portland, Or. 3/91 – 8/94 Adult and Family Services, State of Oregon, Salem, OR.

Programmer/Analyst

Welfare and Jobs system in Oregon state government

Designed, wrote, tested and implemented new programs, data fixes and modifications for government Jobs Automated System (JAS).

Recovered client counts that generated additional federal program funding.

Performed systems analysis, met with users to gather/define requirements.

wrote high level specifications and detail design specifications.

Rewrote ACF108 sampling for reporting to federal government, monitored mitron transmissions of ACF108.

Utilized IBM mainframe, COBOL, CICS, VSAM, SPUFI, Fileaid, TSO/ISPF, EASYTRIEVE PLUS, VSAM, IDCAMS, DYL280, QSAM, FTS, DYL280, Xpediter, Intertest, Syncsort.

Pacific Telecom Incorporated, Vancouver, WA. 3/89 – 3/91

Senior Programmer/Data Analyst

Telephone Service Company. I worked on CAMS and Alascom systems

Performed complex data impact analysis for frequent data migrations from AMS software vendor.

Data analysis, Integration of new data from vendor (AMS).

Met with AMS software vendors to define requirements for modifications and new applications.

Designed, coded, tested, implemented applications for CAMS table-driven system and ALASCOM telephony system.

Developed and modified IDMS database I/O call Macros.

Implemented data element and record changes in IDD.

Liaison between team and DBA staff for ALASCOM system.

Utilized IBM mainframe, COBOL, COBOLII, IBM PC, TSO/ISPF, Wordperfect 5.0, IDMS V10, ADSO, AMU, OLM, ADSG, IDD, ENDEVOR, CA-7, LRF.

Cascade Corporation, Troutdale, OR. 3/86 – 3/89

Programmer/Analyst

Manufacturer of heavy equipment attachments

Converted programs from DL1 to IDMS (all business systems in small shop environment converted).

Designed screens, dialogs, programs, coded, tested and implemented shipping, sales order, engineering, components of inventory, manufacturing, payroll, accounting, bill of material, customer systems.

Trained new employees in IDMS, ADSO.

Conducted user acceptance testing.

Wrote CICS/DL1/IDMS bridge program for customer/data conversion.

Utilized IDMS 10.0, ADSO, LRF, IDD, ADSA, ADSG, COBOL, VSAM, JCL, DEBUGGER, ASSEMBLER, CICS, Logical Record Facility (LRF), DL/1. Systems converted include CUSTOMER, SALES ORDER, SHIPPING, MANUFACTURING, ENGINEERING, INVENTORY, PAYROLL. IBM Mainframe DOS, VM/CMS.

Impell Pacific, Portland, OR. 1/85 – 3/86

Programmer

Software house (no longer in business)

Coded and enhanced COBOL CICS programs, ADSO dialogs.

Developed BMS maps, JCL.

Converted PL1 copybooks to BMS.

IBM mainframe, JCL, TSO/ISPF, SDSF, CICS, COBOL, IDMS, ADS/O, IDD, Panvalet, Librarian

Portland Wire and Iron, Portland, OR. 7/84 – 11/84

Junior Programmer

Manufacturer of heavy equipment (Caterpillar) cabs (No longer in business)

Developed and tested programs using RPGII, COBOL, DL/1, CICS, VSAM, ASSEMBLER.

Modified CICS tables.

Created BMS maps, JCL.

Applied program, JCL modifications for COPICS DL/1 conversion.

Utilized CEMT, CSMT, IMS, IBM mainframe environment.

EDUCATION:

Bachelor of Arts, UCLA, Westwood, CA. 2008

Constructed data simulations

Used LOGONET simulation software

Constructed and modified C++ applications

LTU Irvine, CA. 2001

Independently obtained training in ORACLE 8i, PL/SQL, Developer 2000, Oracle Reports, Visual Basic

Completed Oracle developer and DBA tracks.

Visual Basic 6.0

Associate of Arts, Mt. Hood Community College, Gresham, OR. 1993

Business IT Certificate, Computer Career Institute, Portland, OR. 1984

Contact this candidate