Access/sql Programmer Resume
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
Confidentialaccess/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