We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

3.00/5 (Submit Your Rating)

SUMMARY:

  • 8 of professional experience as a Mainframe Analyst
  • Extensive application, data manipulation and testing tools experience.
  • Strong business area knowledge of life products and business processes with the discipline to perform and document business level analysis to complement IT expertise. Excellent communication skills, effective in team and independent environments.
  • Ability to work independently and efficiently to meet deadlines, responsible, team player, willing to teach and to learn.
  • Expert level data conversion experience including lead analyst, design and development roles on multiple Conversion Engines.

TECHNICAL SKILLS Languages: COBOL/COBOL II, SQL, MFS, MVS/JCL, CICS, EZTRIEVE, Data Stage, C, C , SyncSort and Java Database: DB, DB2, Oracle, Access, IDMS, IMS DB, MQ and VSAM. OS: Widows, XP, Vista, UNIX, and TSO. Hardware: IBM z/OS, Environment: Mainframe, Web, Endeavor, EDI, Sun, Control-M and QMF

WORK EXPERIENCE:

Confidential

  • Creating, testing, updating and maintaining application.
  • JCL, DB2, SQL, COBOL, EDI
  • QA Created functional test plans and test cases, performed functional testing and data validation
  • Mainframe Programmer on investment system, clearing house conversion.
  • Managed defects and reported
  • Creating and maintaining database using my SQL

Environment: MF z/OS, COBOL, CICS, JCL, DB2, EDI

Confidential

  • Responsible for analyzing and maintaining client side debt collection system in leading credit card Company of IsraCard MasterCard
  • Maintaining and enhancing the Financial Systems ONLINE BATCH using: COBOL, MVS/JCL, DB2, IMS,
  • DB, VSAM, SQL, MQSeries, CICS. QA Tested and debugged programs using: XPEDITER and FILE AID, SPUFI, RACF, C. Working with Endevor to control the source versions and monitoring with Control-M
  • Interface with end-users to define enhancements for the existing system.
  • Provided 24 hour support in case of malfunctions
  • Developed logic program for a new applications as well as program that analyzes and modifies logic in existing applications using IMB mainframe.
  • Coded, tested, debugged, documented, implemented, check printing and maintained software applications
  • Ensured that system improvements are successfully implemented
  • Continuously provided training and sharing knowledge.
  • Worked closely with clients to establish problem specifications and system designs.
  • Performed regression and system-level testing to verify software quality and function before it was released.
  • Developed the next generation integration platform for internal applications.
  • Environment: MF z/OS, COBOL, CICS, JCL, MVS, ISPF, DB2, VSAM, IMS, SPUFI, Endevor, FILE AID, XPEDITER, RACF, Control-M, MQSeries.

Confidential

  • Generating reports and creating files using QMF
  • Maintenance of the marketing system and product development
  • Error handling, support and enhancements to the existing system.
  • Development using IBM, DB2, IMS, COBOL, JCL, CICS and DATA STAGE.
  • Consultant The Life Annuity Group Maintenance and development on RPS Repetitive Payment System CSC/Vantage Annuity System. Software tools included COBOL, VSAM, CICS, DB2, SQL, and ENDEVOR.
  • Consultant Corporate IT Developed Access database to assist in Earnings system migration using DB2, SQL, QMF, SPUFI, TSO/ISPF, ENDEVOR, MICROSOFT WORD, MICROSOFT EXCEL, MICROSOFT ACCESS, VSAM, FILE-AID, Control-M
  • Conducted tutorials on DB2 relational database, SQL-Server/Structured Query Language.
  • Provided training classes in the fundamentals of Web Programming Development.
  • Supplied training in Internet surfing, email, word processing, Windows/NT and spreadsheet applications.
  • Focused training sessions in Java programming language and VB.Net
  • Hands On experience in developing applications using COBOL, CICS, VSAM, DL/1 and DB2 on IBM
  • Mainframe operating system.
  • Environment: MF z/OS, COBOL, CICS, JCL, MVS, ISPF, DB2, VSAM, QMF, ENDEVOR, FILE AID, XPEDITER, RACF, Control-M, MQSeries, DATA STAGE.

Confidential

  • Developed and maintained programs for Department of Credit Applications, analyzed and programmed collateral and third party guarantees system
  • Analysis of existing collateral system and a new CICS collateral system developments
  • Planning and performing tests on Quality Center
  • Handled coding requests from end-users, Support of queries and debugging
  • Coding of CICS screens and programs, development using COBOL, JCL, DB2 and CICS.
  • Monitored nightly batch schedules which included checking all condition codes daily to ensure that all jobs were executed.
  • Developed detailed technical documentation for solutions implemented in resolving production issues.
  • Examined DB2 tables to create SQL queries for immediate fixes.

Environment: MF z/OS, COBOL, CICS, JCL, MVS, ISPF, DB2, VSAM, SPUFI, ENDEVOR, FILE AID, XPEDITER, RACF, Control-M, MQSeries.

Confidential

  • Software User Administrator, Worked with Oracle DB and Sybase. Worked with Solaris systems, HP, AIX UNIX and Windows environments.
  • Ensured support of daily batch jobs/scheduler as well as troubleshooting problems during the testing phase and migration from IDMS to the DB2 database.
  • Supported team members with problem resolution.
  • Monitored, patched, and troubleshot enterprise class applications.
  • Recommended improvements and resolved issues related to enterprise class applications
  • Perform hands-on design and development for application enterprise class application that included code reviews and unit testing.
  • Implemented an integrated computerized patient medical record and services system that offered immediate and cost-effective on-line worldwide access, storage, and retrieval.
  • Extracted data from DB2 to ensure accuracy to view tables
  • Created testing on DB2 tables using File-aid
  • Environment: Oracle, Sybase, Solaris, DB2, UNIX, Windows, Test Director and Microsoft Office.

We'd love your feedback!