Mainframe Application Analyst/Developer

Rina Brodsky

* *******, ****** ** *****, 949-***-****

********@*****.***

I have over 20 years of industry experience covering all aspects of software engineering working in various capacities for insurance and financial institutions: application development, quality assurance and control, data analysis and production support.

Technical Skills

OS: TSO/ISPF, HP-UNIX, WINDOWS 95/98/NT/2000/XP, AS-400

Databases: DB2, ORACLE 8, IMS, MS Access, SYBASE.

Languages: JCL, SQL, PL/SQL, COBOLII, CICS, CL, Excel, DDL, DYL-

280, FOCUS, SAS, VB6, MQ Series, EZTrive.

Tools: HUON, Mercury Test Tools, FTP, File-AID, QMF, VISIO2000, MS

PowerPoint, Abend-AID, XPEDITER, CA-7, Repository, Strobe,

Supper Tool, Quiz, Orion, Endevor, ChangeMan, Erwin.

Experience

AAA (Costa Mesa, CA) June 2010 - December 2011

Contractor

Working for the Development Center - Enterprise Policy Management team; developed, tested and implemented Roll on/Roll off Amendment process, PAC-09-03C project.

Provide computational analysis and developed online/batch subroutines, copybooks and Validation Rule for PAC-10-07G California Auto Product; the Signatory Endorsement document print trigger, HLDI validation VIN number.

Analyzed and developed conversion of batch programs to load data from PRIME Data Base to AIP.

Designed, built and maintained Insurance statistical and Billing/Accounting reports; Concerto Renewal Retention Report, daily ACSC Employee Benefits Register...

Cleaned up the Change Man packages for production release.

Run production SPUFI by request.

Experian (Costa Mesa, CA) 2006 – 2009

Project Analyst

Developed scripts for Client Services department to automate scheduling and verification of various ETL jobs for financial institutions and third party vendors. The verification process was intended to validate elaborate client requests for security and encryption of personal private user information. Used JCL, SQL and EZTrieve to trigger ETL to retrieve data stored on Mainframe/DB2, used SAS to generate a testing set of data and to validate private information encryption.

Created test plans and defined test cases for functional and system integration testing.

Built reports for institutional clients using Orion for SQL query generation and custom formatting.

Worked with business partners to develop schedules, project metrics, and status reports.

Countrywide – Balboa Insurance Group (Irvine, California) 2004 – 2006

QA Analyst Sr.

Tested Insurance tracking applications in a mainframe environment.

Developed system test plans, test scripts, documents and built test environments for Auto Insurance rate change application.

Conducted and analyzed integration system tests for Wells Fargo clients with insurance needs.

Generated defects and issues reports using Mercury Test tools.

Built statistical and test reports using SQL, DYL-280, QMF.

AAA (Costa Mesa, CA) 2004

System Analyst

Developed the Compensation Incentive System for California PRO PAY changes; PHENX IBM project using COBOL II, DB2, JCL.

Supported all stages of above system development life cycle.

Defined test cases, test scripts for Unit/System acceptance.

ConAgra Foods (Irvine, California) 2002 – 2003

Consultant

Conversion of VSAM files to DB2 on Mainframe platform. Integration of DB2 and Oracle databases for Logistic Distribution system using SQL, COBOL II, JCL, FTP, and SAP.

Developed batch programs to load DB2 tables with forecasting data.

Documented the process and procedures.

Ceridian (Fountain Valley, California) 2000 – 2001

Software Engineer

Analyzed, designed, ongoing support and maintained of W-2 application using Kshell scripts, ORACLE stored procedures, Microsoft COBOL.

Designed and implemented Annual statistic reports for employees’ W-2 using Kshell scriptS, SQL Plus reports, Supper Tool, Quiz.

Bergen Brunswig Corporation (Orange, California) 1998 – 2000

Programmer/Analyst III

Data modeling, analysis and compilation of project specifications; designed, implemented and provided production support of Inventory Reconciliation Account Pay Matching (IRAPM) application using IBM390, DB2, CICS, COBOLII.

Developed consistency testing utility for legacy VSAM AP application and its DB2 successor.

Designed and implemented batch programs (matching GL and IRAPM Invoice extract file, table loading, and financial reports).

Worked on several bridges between GEAC and IRAPM system.

AAA (Costa Mesa, CA) 1995 - 1998

Senior Programmer/Analyst

Analyzed, designed, developed and tested of the Rate Change project for the Insurance system.

Developed system design including function specifications, designed specifications; implemented and tested data conversion from PC to DB2 (Mainframe).

Education

BS in Mechanical Engineering.

Vocational Courses:

ORACLE 8i (Oracle Center in Costa Mesa, CA).

UNIX (HP Center in Orange, CA).

Power Builder and SYBASE (CompuFlex in Woodland Hills, CA).

COBOL, DB2, IMS, CICS (CLC Los Angeles, CA).

Contact this candidate