systems analyst / mainframe developer

Irina Elizar

Systems Analyst /Developer

West Bloomfield, MI 48323

Email: dh7hlm@r.postjobfree.com

Phone: 248-***-****

PROFESSIONAL SUMMARY

Senior Systems Analyst /Developer with 20+ years in mainframe system development (SDLC) including requirements elicitation, data/work flow analysis, functional and technical specifications, test cases and test plans, coding, testing through user acceptance testing and signoff, change management, implementation and production support. Experienced working with end users and stakeholders, documenting process changes and managing change requests. Proven technical, analytical and problem solving skills successfully leveraged on many conversions, upgrades, reverse engineering and legacy modernization projects.

QUALIFICATIONS

Functional Skills: Requirements Elicitation, Data/Work Flows, Functional and Technical Specifications, Data Modeling/Analysis, Database design, Test Cases and Test Plans, Regression/System/UAT testing, Traceability.

Technical Skills: MS Word, MS Excel, MS Visio, MS Access, MS Outlook, Lotus Notes, Novell LAN, MS Windows.

COBOL, DB2/SQL, CICS/BMS, IMS DB, Easytrieve, JCL, File-Aid, DB2 Utilities, DB2 Stored Procedures, QMF, SPUFI, VSAM, QSAM, Total DB, TSO/ISPF, Endevor, Changeman, Panvalet, Xpediter, Intertest, FTP, CA7, IBM MVS Z/OS.

WORK EXPERIENCE

GDI Infotech, Ann Arbor, MI – Systems Analyst / Developer - 01/2011-01/012

Assignment: Comerica Bank, Auburn Hills, MI

Created process flow diagrams and developed test plans for two major conversion projects (Visio, Word).

Created requirements traceability matrix and verified system results for HR conversion project (Excel).

Designed implementation run sheets to monitor and schedule support for 102 new production jobs (Excel).

Created and converted test files to CSV format for upload into new vendor system (COBOL, DB2/SQL, File-Aid).

Conducted file transfers to MS Access database to facilitate results validation in system testing (FTP, Access).

Created job processes for daily production loads into new Securities database (DB2 Utilities, JCL).

NMRF LLC, Detroit, MI – Business Analyst - 02/2009-10/2010

Performed research and feasibility analysis for mortgage origination startup (Excel, Word, Outlook).

Collected market data and prepared statistical reports for management review.

COMPUWARE CORPORATION, Detroit, MI - Systems Designer / Developer - 07/1991-11/2008

Assignment: Bridgestone/Firestone, Cleveland, OH - 01/2008-08/2008

Analyzed and made recommendations to fix process discrepancies between applications (COBOL, Excel).

Documented user requirements, wrote technical specifications, created test plans (CFNA Paintball project).

Implemented and tested changes to batch and online programs across multiple applications (COBOL, IMS DB).

Developed traceability matrix and validated requirements, conducted system and user acceptance tests.

Assignment: Handleman Company, Troy, MI - 06/2007-01/2008

Created test plans and test data, managed user acceptance testing and coordinated the signoff process.

Conducted code reviews, supervised system and interface testing, wrote project progress reports.

Assignment: Comerica Bank, Auburn Hills, MI - 09/2002-06/2007

Performed high-level requirements and data analysis for conversion to Oracle Financial System (OFSA).

Designed and created DB2 database tables for Trust, Risk Rating and Connectivity systems (Excel).

Coordinated and ran ETL processes for large Data Warehouse to support integration testing (DB2 Utilities).

Implemented Connectivity project interfaces for Decision Support (DSS) application (COBOL, DB2/SQL, JCL).

Created test cases and test plans, created test data and conducted system and integration testing (File-Aid).

Coordinated, tested and implemented year end Corporate Budget Planning management reports.

Assignment: Bank One, Troy, MI - 10/1996-09/2002

Researched (reverse-engineering), documented and restructured the Daily Unavailable Charges application.

Facilitated meetings with users and interface groups to elicit, document and verify change requirements.

Analyzed and documented system functions and the impact of change requests for business users.

Estimated work efforts for Y2K implementation, implemented Y2K changes for Customer Analysis system.

Assignment: Blue Cross Blue Shield of Michigan, Southfield, MI - 06/1995-10/1996

Developed online and batch programs for Turn-Around Document Router (TAD) application (COBOL, CICS).

Documented requirements, wrote technical specifications for batch and online programs (Word, Visio).

Documented test cases and created test plans for system and integration testing (Word, Excel).

Analyzed and resolved production incidents within Claims Processing application (COBOL, DB2/SQL, CICS, JCL).

Assignment: Dow Chemical, Midland, MI - 07/1991-06/1995

Implemented CICS APPC(LU6.2) pipeline protocol to improve communications between remote systems.

Tested and documented system functions for future technical support and end users.

MERCANTILE STORES COMPANY, New York, NY – Systems Analyst / Team Lead - 07/1988-07/1990

Performed data analysis/mapping and designed DB2 tables for a major conversion project.

Facilitated interviews with business users to refine and validate requirements.

Wrote technical specifications, coded and tested menu-driven application (COBOL, DB2/SQL, CICS).

Conducted code reviews, developed test cases and test plans, created traceability matrix for system testing.

Run queries against DB2 database to verify system test results (QMF, SPUFI).

Coordinated and supervised testing, reported defects and tracked defect resolution.

BUDD COMPANY, Bloomfield Hills, MI – Programmer Analyst - 01/1985 -07/1988

Developed online and batch programs for Sales and Marketing system (COBOL, CICS/BMS, JCL).

Implemented electronic transmission system (EDI) of bills of lading and shipping notifications (CICS).

Facilitated interviews with end users and documented requirements for system enhancements.

Managed change requests and incident resolution with interface teams and users.

Documented process flows and support procedures for in-house support personnel.

Provided support and training for application end users.

SYMCON CONSULTING, Detroit, MI – Programmer - 01/1983 -12/1984

Assignment: Michigan Employment Security Commission (MESC), Detroit, MI

Designed, coded and tested programs for new unemployment benefits system (COBOL, CICS, VSAM, JCL).

Created test cases and test plans, executed system testing of menu-driven online application.

Designed and implemented management statistics reports (COBOL, VSAM).

EDUCATION

Business Administration Degree Program – Walsh College, Troy, MI

Associate of Applied Science - Oakland Community College, Farmington Hills, MI

Contact this candidate