We provide IT Staff Augmentation Services!

Access/sql Programmer Resume

2.00/5 (Submit Your Rating)

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

Confidential

access/SQL programmer

Responsibilities:

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

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
Confidential,Lancaster, PA

Senior Analyst Siemen Medical

Responsibilities:

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

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.
Confidential,New York, NY

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
Confidential,Florham Park, NJ 

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
Confidential, Lancaster, PA

Senior Analyst

Responsibilities:

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

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.
Confidential, New York, NY

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
Confidential, Florham Park, NJ

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

We'd love your feedback!