SUMMARY

• Software Analyst/Developer for 20+ years.
• Worked with system end users to identify software issues.
• Diagnosed issues, proposed solution, developed solution and tested.
• Wrote necessary documentation defining system issues and resolution.
• Experience conducting meetings with customers to define new system requirements.
• Wrote new requirement documents.
• Studing for teh CompTIA A+ certicication exams.
• Support home network, PCs, laptops and iPads.

TECHNICAL SKILLS

Operating Systems: IBM Z/OS, Microsoft Windows.

Languages: COBOL, SQL, DL/me, CICS, Visual Basic, XML

Databases: DB2, IMS, Access, VSAM, UDB, SQL Server.

Software: Endevor, IBM Debug (CICS and TIM). IBM Fault Analyzer, IBM File Manager,IBM File Manager for DB2, BMC Catalog Manager for DB2, IMS MPP programs, MFS, BMP (Checkpoint/Restart) programs, IMS PSB/PCB. ChangeMan, Control - M, Syncsort, IBM DB2 command line processor, Abend-AID, Spufi, QMF, TSO, CA7, ACF2, FTP, File Aid, Expeditor, Panvalet, Easytrieve Plus, DDL, Rapid SQL.

Microsoft Tools: Word, Excel, Outlook, SharePoint, Power Point, Visio, Project.

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

Mainframe Developer

Environment: Cobol, DB2, IMS DB/DC, Endevor, IBM Debug, IBM Fault Analyzer, IBM File manager for DB2,IBM File Manager, JCL, SPUFI, TSO, ISPF, XML, Dialog Manager, SOAP UI, RSA, Oxygen, Note Pad++, MS Word, MS Excel, MS Outlook, MS PowerPoint, Share Point.

Responsibilities:

• Agile metholodology was used for teh projects. Participated in all phases of Agile including Daily Stand Ups, User Story grooming, Iteration planning and PI planning.
• During each two week iteration me analyzed teh user story and created specs and test cases. me also coded and tested.
• Converted APIs into Web Services using JAVA. Created and modified XML.
• Used XML to communicate with JAVA and Visual Basic programs and SOAP UI to test.
• Development of new COBOL, DB2, IMS DB programs.
• Enhancement of COBOL, DB2, IMS DB/DC programs. Teh programs were very complicated and large.

Confidential, Dearborn, MI

Mainframe Developer

Environment: Cobol, DB2, IMS DB/DC, Endevor, Changeman, IBM Debug, IBM Fault Analyzer, IBM File manager for DB2,IBM File Manager, JCL, SPUFI, TSO, ISPF, BMC Administrative products, MS Word, MS Excel, MS Outlook, MS PowerPoint.

Responsibilities:

• Wrote Ford SDM (Solution Delivery Methodology) documentation. Documents created included user requirements, design documents, test plans, code and test reviews.
• Made changes to online IMS MPP, IMS DB, DB2, Cobol programs.
• Wrote new report program using COBOL, DB2, IMS DB, IMS BMP(Checkpoint/Restart).
• Added code to 40 online IMS MPP programs to convert North American dates to international format. Formatted dates for display and added international date entry validation.
• Analysis, design and development of enhancements to Ford’s CPARS purchasing system.
• Business areas included requisitioning, purchasing, receiving and payment processing. Worked on teh Part Spec system dat processed new part requirements.
• Teh major project worked on was teh enhancement of teh CPARS system to accommodate international users. Changes involved increasing monetary fields, changing date formats and changing screens to display in other languages.
• Wrote user requirement document for teh expansion of teh extended price and total cost fields. Changes were defined for 24 subroutines, 17 batch and 2 report programs. Worked with business management in an iterative development process to review and approve document.
• Wrote user requirement document dat defined changes to 35 report programs. Changes included changing teh dates to display teh international format. Adding a currency display. Expanding teh expanded price and total cost fields. Space for these changes required redesigning teh reports. Redesigned reports with changes and reviewed with business management teh proposed reports.
• Jetform Replacement project added new code to send CPARS form printing to in house developed system (Web Quote) in place of JetForm. Part of teh requirements were to remove obsolete code. Extensive testing was required to make sure no code was accidently deleted.
• Set up new IMS region for integration testing. Moved 2000 modules (IMS MPP Cobol, IMS BMP COBOL, PSB, MFS, IMS DB, DB2). Worked with Changeman, IMS and DB2 support to resolve issues.
• Project to enhance programs to display screens and messages in different languages. Different language screens were added to teh program’s MFS. Hard coded messages were removed and replaced with calls to a subroutine dat returned teh message in correct language.
• Analyzed production issues, defined cause, developed solution and tested.

Confidential, Madison, WI

Systems Analyst / Developer

Environment: Cobol, DB2, JCL, SPUFI, TSO, ISPF, ChangeMan, Control-M, Abend-AID, Syncsort, IBM DB2 command line processor, MS Word, MS Excel, MS Visio, MS Access, MS Outlook.

Responsibilities:

• Duties included COBOL DB2 program development and enhancement, DB2 data fixes and report writing using SQL and Excel.
• Wrote COBOL DB2 programs to extract data for report creation, and also for statistical data for Federal government requirements.
• Created batch jobs using JCL and Syncsort.
• Wrote reports using SQL, DB2, MS Access and MS Excel.
• Created Business Logic Diagrams using MS Visio.

Confidential, Farmington Hills, MI

Systems Analyst / Developer

Environment: Cobol, DB2, DDL, JCL, SPUFI, QMF, TSO, CA7, ACF2, FTP, Expeditor Panvalet, Rapid SQL, Abend-AID MS Word, MS Excel, MS Power Point, MS Visio, MS Project.

Responsibilities:

• Senior developer for document management team.
• Developer and Project Lead for document management team on a large company wide project to extract and remove data from integrated systems and databases. All document storage information was extracted and sent to a new Financial Services company. COBOL, DB2, and FTP programs were written to extract data from DB2 tables and create flat files.
• Project Lead and Developer on project dat resulted in Confidential saving $1,500 per lease vehicle sold at auction. Designed new interfaces between Doc Management, Remarketing systems and Title vendors. Designed new DB2 tables. Wrote new COBOL, DB2, JCL, JCL, and FTP programs. Team consisted of five developers.
• Leader of Document Management development and support team. Wrote requirements, design, and testing documents. Responsible for working with business analysts to prioritize projects for teh team. Team was comprised of two off shore and three on shore developers. Team was responsible for Imaging, Content Management and Document Management. Imaging and Content Management systems were written in Java.
• Used Load Runner for load testing of Java application.
• Monitored queues of reported issues and worked with help desk personnel and end users to gather information for issue resolution. Used AbendAid, Expeditor, QMF and PC Anywhere to determine cause of issue.
• Created test cases, executed them, documented results and developed solutions to issues. Test case documentation was done using MS Word and MS Excel.
• Designed and developed COBOL, DB2, and JCL programs to synchronize lease auction portfolio and loan portfolio flat files to document management DB2 databases.
• Worked with print vendor and designed and developed programs using COBOL, DB2, JCL and FTP.
• Led project to outsource storage of paper titles. Wrote COBOL, DB2, JCL and FTP programs to exchange files from Confidential mainframe to title storage vendor. VPN connection was used for security. COBOL, DB2, programs were enhanced.
• Participated on company wide team dat reviewed company and department security policies.
• Conducted meetings to gather system requirements using MS Word.
• Prioritized projects with business management using MS Excel.
• Managed project resources and time using MS Project.
• Created system flow documentation using MS Visio.
• Used a PMI based project management methodology.

Confidential, Farmington Hills, MI

Systems Analyst / Developer

Environment: Cobol, DB2, JCL, Spufi, QMF, TSO, CA7, ACF2, FTP, Expeditor, Easytrieve Plus Panvalet, Visual Basic, Dimensions, ODBC, DRDA Gateway, SQL Server, UDB, Abend-AID, MS Word, MS Excel, MS Power Point, MS Visio, MS Project and PC Anywhere.

Responsibilities:

• Developed new Title Management workflow system. Created teh requirements, design, and test case documents. Developed system using COBOL, JCL and DB2.
• Conducted RAD sessions to design teh Title Management system.
• Designed and developed new Title Management DB2 database, tables, columns, and indexes. This included creating DDL, COBOL, DB2 programs, and JCL to load tables.
• Developed Document Management system to send and receive files to storage vendor containing information about files sent to and retrieved from off site storage. Files were sent dat listed cartons we sent to off site storage and requests for cartons. Vendor sent files containing storage locations of cartons dat were sent. Programs were written in COBOL, DB2, JCL, and FTP.
• Developed new COBOL, DB2, JCL, and FTP programs to create auction title requests. Made changes to COBOL, DB2 programs.
• Designed new interface, DB2 columns and indexes for project to receive auction title requests. Enhancements were made to COBOL, DB2 programs.
• Wrote programs to synchronize when requested electronic titles have been changed to paper titles so dat Confidential can update document management and workflow system databases. Programs were written in COBOL, DB2, JCL, and FTP.
• Participated on project dat determined a recommendation for teh purchase of a new physical filing system to hold three million folders. Team consisted of members representing purchasing, operations, and facilities.
• Deployment and support of Smeadlink file control system using SQL Server Database, SQL, and PC Anywhere.
• Developed new Visual Basic programs to interface between Title Management DB2 database and Smeadlink SQL Server database. Programs written in Visual Basic, ODBC, DB2 and SQL Server.
• Created DB2 reports, extracted DB2 data, sorted and changed flat files using Easytrieve Plus.

Confidential, Farmington Hills, MI

Programmer / Analyst

Environment: Cobol, DB2, CICS, JCL, SPUFI, QMF, TSO, CA7, FTP, File Aid, Expeditor, Panvalet, Abend-AID, Easytrieve Plus, Visual Basic, AS 400 database, ODBC, DRDA Gateway, MS Word, MS Excel, HTML and Java Script.

Responsibilities:

• Utilized COBOL, DB2, CICS, JCL, SPUFI, QMF, TSO, CA7, File Aid, Expeditor and Panvalet to support and modify teh existing mainframe Claims, Billing, Underwriting and Rating systems.
• Developed new claims and billing systems using Visual Basic.
• DB2 and an AS400 database were used.
• ODBC was used to access teh databases through a DRDA Gateway.
• Developed a web site for Insurance Policies and Procedures.
• Gatheird requirementsfor new insurance claims and billing systems.
• Used prototyping in RAD sessions to finalize system design.
• Audited for SOX compliance.
• Created DB2 reports, extracted DB2 data, sorted and changed flat files using Easytrieve Plus.

Confidential, Farmington Hills, MI

Programmer / Analyst

Environment: Cobol, DB2, CICS, JCL, VSAM, SPUFI, QMF, TSO, CA7, File Aid, Expeditor, Panvalet, Abend-AID, MS Word, MS Excel, Easytrieve Plus.

Responsibilities:

• Participated in RAD sessions to gather requirements for teh new Credit Application system.
• Developed prototype new system screens.
• Designed DB2 database and tables.
• Developed prototype database using DDL.
• Wrote new CICS / DB2 / VSAM programs.
• Wrote new CICS / DB2 programs to access Credit Bureau data using LU 6.2.
• Utilized COBOL, DB2, CICS, JCL, VSAM, SPUFI, QMF, TSO, CA7, File Aid, Abend-AID, Expeditor and Panvalet to support and modify teh Credit Application system
• Created DB2 reports, extracted DB2 data, sorted and changed flat files using Easytrieve Plus.