SUMMARY

• Performed multiple consulting roles during my career including Sr Mainframe Developer/Production/ Support, Business System Analyst/Mainframe Tester for application development, Maintenance, testing & Production support.
• Extensive background in the full software development life cycle (SDLC), high level and low level design and application integration. Possess in-depth noledge in mainframe technologies.
• Expertise in design & development of programs using COBOL, CICS, VSAM, IMS/DB, DB2, JCL, TSO/ISPF, SPUFI, IBM utilities, Panvalet,, File-Aid, and having noledge of JAVA.

TECHNICAL COMPETENCIES

Software: ACCESS, SQL Server, Visual Basic, VisualtStudio 2005 -, Net & C#, COBOL, ENDEVOR, PARADOX, JCL & UTILITIES, IMS, TSO SPF, HTML, DHTML, XML VSAM, CPCS, FOCUS, SyncSort, File Manager, Mainframe Data Storage, Visio, and FileAid.

PROFESSIONAL EXPERIENCE

access/SQL programmer

Responsibilities:

• Maintain Access SQL queries for company dat manages Relocation for 9 Moving companies throughout US.

SENIOR PROGRAMMER 

Responsibilities:

• Mainframe COBOL/DB2, CICS Trade and Finance Software for Banks in Europe and Asia -utilizing DB2
• Stored Procedures. Front End Java, Backend Cobol CICS DB2.
• Resolved production issues
• Received individual problems from bank in France.
• First duplicated problem. Then fixed code or DB2 stored procedure dat caused error or abend.
• Retested for multiple situations to insure problem solved. Sent changes wif instruction to
• install at bank’s computer installation.
• Performance fine tuning on SQL queries.
• Interaction wif client and business for specifications clarification.
• Maintained SQL databases for Credit Card customers and Employees commissions

Senior Analyst Siemen Medical

Responsibilities:

• Mainframe enhancement to modify all programs (COBOL/DB2, Easytriev) to increase size of patient account via home based office

Senior Analyst Customer Sales and Support 

Responsibilities:

• PC Access Module to read Gmail database of E-mails and calculate average price for all parts listed on such e-mails
• Contacted and received customer orders via the telephone and then contacted suppliers based on availability on e-mails listed above to full fill such orders. No supply on hand.

Senior System Analyst

Responsibilities:

• PC ACCESS & MAINFRAME HEALTHCARE SYSTEM -- Developed and updated systems dat continuously support new user requirements in both Access and Cobol/Focus Mainframe systems utilizingRe wrote entire Cobol reporting module in Microsoft Access so users could run there own reports and queries in order to calculate insurance rates.
• PC ACCESS HEALTHCARE RATING ENGINE DATABASE – extracted exposure data for AIG actuaries
• Designed and implemented Hospital Database for Accounts via input of Excel sent from 6 Intl. regions
• Redesigned Reinsurance project detailing the top 25 reinsurers. Distributed to the heads of the Controllers COBOL/DB2, Focus, SPUFI and FileAid. DB2 database contained over 200 million records

System Software Consultant 

Responsibilities:

• PC LAN AUDIT SYSTEM - Developed system dat monitors all production changes by administrative personnel. Included 3 tier, test, migration and production. Included screen for promotion of source code.
• PC Business Systems Analyst (P&C Insurance) to join our team in New York, NY. PORTLOG / SEALOG SYSTEM - Developed PC Access 8.0 standalone system to be placed onall Exxon and chartered vessels. System sends seagoing and at-port data to Exxon LAN via Excel Spreadsheets
• INTEGRATED SUPPLY INFORMATION SYSTEM (ISIS) - Designed, coded, installed and maintained ISIS, a transaction-based “workflow” system dat processes a cargo of crude oil from acquisition (entry of a purchase contract) to delivery (scheduling transportation), including recording actual dates and volumes, invoicing, payment and accounting.
• “Sleeper system” dat performs background processing on user-entered data to speed up user Workstations.
• Remote transaction data entry system which is installed at affiliates in Rome, London and Singapore.
• Table-driven password security system to allow individual users access

Confidential

access/SQL programmer

Responsibilities:

• Maintain Access SQL queries for company dat manages Relocation for 9 Moving companies throughout US.
• sENIOR programmer – surecomp – kfar sava iSRAEL 6/11 – 8/16
• Mainframe COBOL/DB2/CICS - Trade and Finance Software for Banks in Europe and Asia -
• utilizing DB2 Stored Procedures. Front End Java, Backend COBOL/CICS/DB2.
• Resolved production issues. Received individual problems from bank in France.
• First duplicated problem. Then fixed code or DB2 stored procedure dat caused error or abend.
• Retested for multiple situations to insure problem solved. Sent changes wif instruction to
• install at bank’s computer installation.
• Performance tuning on SQL queries.
• Interaction wif client and business for specifications clarification.
• Hasc Credit Card Jerusalem IsraeL
• Maintained SQL databases for Credit Card customers and Employees commissions

Senior Analyst

Responsibilities:

• Mainframe enhancement to modify all programs (COBOL/DB2, Easytriev) to increase size of patient account via home based office

Senior Analyst

Responsibilities:

• PC Access Module to read Gmail database of E-mails and calculate average price for all parts listed on such e-mails
• Contacted and received customer orders via the telephone and then contacted suppliers based on availability on e-mails listed above to full fill such orders. No supply on hand.

Senior System Analyst

Responsibilities:

• PC ACCESS & MAINFRAME HEALTHCARE SYSTEM -- Developed and updated systems dat continuously support new user requirements in both Access and Cobol/Focus Mainframe systems utilizingRe wrote entire COBOL reporting module in Microsoft Access so users could run there own reports and queries in order to calculate insurance rates.
• PC ACCESS HEALTHCARE RATING ENGINE DATABASE – extracted exposure data for AIG actuaries
• Designed and implemented Hospital Database for Accounts via input of Excel sent from 6 Intl. regions
• Redesigned Reinsurance project detailing the top 25 reinsurers. Distributed to the heads of the Controllers COBOL/DB2, Focus, SPUFI and FileAid. DB2 database contained over 200 million records

System Software Consultant

Responsibilities:

• PC LAN AUDIT SYSTEM - Developed system dat monitors all production changes by administrative personnel. Included 3 tier, test, migration and production. Included screen for promotion of source code.
• PC Business Systems Analyst (P&C Insurance) to join our team in New York, NY. PORTLOG / SEALOG SYSTEM - Developed PC Access 8.0 standalone system to be placed onall Exxon and chartered vessels. System sends seagoing and at-port data to Exxon LAN via Excel Spreadsheets
• INTEGRATED SUPPLY INFORMATION SYSTEM (ISIS) - Designed, coded, installed and maintained ISIS, a transaction-based “workflow” system dat processes a cargo of crude oil from acquisition (entry of a purchase contract) to delivery (scheduling transportation), including recording actual dates and volumes, invoicing, payment and accounting.
• “Sleeper system” dat performs background processing on user-entered data to speed up user Workstations.
• Remote transaction data entry system which is installed at affiliates in Rome, London and Singapore.
• Table-driven password security system to allow individual users access