SUMMARY

Analytical Senior Software Developer with diverse industry experience including: state social services, third party prescription processing, agriculture industry, government accounting, federal banking, and investment banking. Experienced with all phases of software development life cycle. Effectively analyzes, designs and implements software to satisfy user specifications.

TECHNICAL SKILLS

• Languages: COBOL, CICS, JCL, ROSCOE, SQL, IMS DC, SAS, Natural, Easytrieve,
• C , Visual Basic, VBA
• Platforms: IBM Mainframe, Unix
• Databases: IBM DB2, ADABase, IMS DB, VSAM
• Tools: IBM utilities, IDCAMS, File-Aid, Abend-Aid, Expediter, SyncSort
• Additional: Endeavor, TSO, ISPF, Dialog Manager, Connect Direct, FTP, NDM

PROFESSIONAL EXPERIENCE

Confidential

Senior Analyst/Programmer

• Analyzed change requests for the Automated Eligibility system and provided estimates for effort to completion. Developed design documents for system changes. Developed and implemented system changes.
• Wrote test procedures for testing new web based eligibility system.
• Developed 5 COBOL DB2 programs to replace Natural DB2 programs.
• Created or modified CICS and batch Natural programs that read/update ADABase files to meet user requirements.
• Modified or created new JCL, in ROSCOE executable library, as needed for system changes.

Confidential

Senior Software Developer

• Analyzed user requests to determine which data base, DB2 or ADABase, should be accessed.
• Determined which platform, mainframe or Unix would be the most expedient to pull the data from.
• Used CICS maps and CICS programs to trace the origin of the needed data elements, if not provided by the requestor.
• Created and tested SQL and/or COBOL program to extract and format data.
• Utilized SQL and/or Natural program to validate test results, then sent process to Quality Control for approval.
• Implemented new or changed JCL and COBOL programs using Endeavor.
• Performed peer reviews of other team members' test results to ensure compliance with HIPAA regulations.
• Trained 6 team members how to use the sort/join function of SyncSort, reducing development time on most requested processed by 30 .
• Designed and developed a void and stale check reporting system that pulled data from 2 different financial systems from 7 years back and balanced over 3 Million of void and stale checks to the exact penny.

Confidential

Software Developer

• Modified existing or created new SQL, COBOL programs, and JCL to provide reports as requested by the user.
• Used an in-house GUI to set up recurring reports on Unix platform.

Confidential

Problem Management Analyst

Analyzed recurring abends to determine what corrections were needed and generated Problem tickets and Change Requests to initiate corrective actions.

Incident Control Auditor

• Audited incident tickets to ensure compliance with Sarbanes-Oxley Act of 2002.
• Created audit report on EXCEL spread sheet utilizing pivot tables and distributed to Production Control managers.

Confidential

Analyst/Programmer

Help Desk Reporting System

Performed detailed analysis on the monthly reporting process. Developed work instructions to CMM level 4 specifications using Microsoft Word and Excel. Implemented the work instructions and trained the Help Desk reporting team.

Pharmaceutical System

Developed macros for MS EXCEL spread sheets using VBA.

Project Manager of mainframe system de-install

• Met with client CFO to determine requirements for data retention, coordinated tasks of other programmers, and provided status reports to management and client CFO.
• Researched OS JCL, COBOL programs and copybooks for files and data fields that needed to be retained for historical purposes.
• Extracted historical data using File-Aid, File-Aid IMS, SQL and SAS. Coordinated effort with DBA group to copy the data to DVD or SQL Server database.
• Created PC SAS record layouts for customer and verified that customer could access the historical data.

Patronage payment system

Analyzed annual changes needed, modified COBOL programs and OS JCL, developed test plans, system tested the changes, implemented changes, and coordinated annual year-end processing.

Equity management system

• Provided user support in the form of answering technical questions and resolving system errors.
• Modified OS JCL, COBOL IMS DB/DC programs as necessary. Created new COBOL II IMS DB/DC programs to extract data and create reports for users.

Confidential

Applications Analyst

Government accounting system development project SABRS

Wrote specifications for batch and online processes, created test data and test plans, executed the test plans using Natural programming language and ADAbase. Documented the results on the process to ensure compliance with the specifications.

Confidential

Analyst

Report Library management project

• Met with Report Library manager to determine requirements, designed a solution, and wrote program specifications. Supervised programmer that developed the SAS programs.
• Created test plans, coordinated system testing, developed user operation instructions, and implemented the system.

Bank Statistics Reporting system

• Installed new releases of the vendor supplied reporting system, created and executed test plans, and trained users on changes to system.
• Made changes to OS JCL, COBOL IMS DB/DC programs as requested by users. Developed, tested and implemented Disaster Recovery plan for the Bank Statistics Reporting system. Participated in testing the plan every six months.
• Member of team that identified inefficiencies in the Bank Statistics Reporting department.
• Presented findings and suggestions for improvement to bank vice-president and entire statistics department.

Human Resources system

Updated DB2 system tables to add users, add plans, and grant user access to plans and tables.

Confidential

Senior Programmer/Analyst

New vendor supplied Stock Transfer system

Worked on the installation team for the new vendor supplied Stock Transfer system and then provided user support for that COBOL CICS VSAM system. Installed a new release of vendor supplied Report Writer system and provided user support for the system.