We provide IT Staff Augmentation Services!

Sql Developer Resume

New Jersy, NJ

Objective: With a great academic record and over 6 years of Analysis, Design, Development, Testing, Support experience in two top companies, I hope to be a valuable addition to your organization.

Professional Summary:

  • Worked extensively on IBM System/390 and IBM z/OS in the functional domain of Banking & Finance and Telecommunication.
  • Proficient in using JCL, CA-7, EZtrieve for invoking COBOL programs.
  • Extensive experience using IDMS, DB2, IMS, VSAM for interacting with data from the Database.
  • Experience in REXX for creating TSO online screens.
  • Experience in using Endevor, Changeman, XMODS for component Release.
  • Extensive experience of firing SQL queries inorder to fetch data from the Oracle Database using MS Access.
  • Experience in using SPUFI, QMF, Stored Procedure for fetching data from DB2 database.
  • Extensive use of MQ Websphere, XML, SFTP, FTP protocols for message and file transfer.
  • Extensive experience in COBOL programming.
  • Extensive experience in using CICS, ADSO products for interacting with online applications.
  • Extensive experience in using XPEDiter, File AID, Abend AID tools for debugging programs.
  • Experience in using STROBE and Code Coverage tools for performance measurements.
  • Experience in using QTP, Screen Scraping Macros using Visual Basic Script for automated testing.
  • Extensive experience in maintaining programs using TSO.
  • Extensive experience in a Team lead position handling a team of (1 to 4) members.
  • Extensive experience in all phases of SDLC ie Agile Methodology and Waterfall Model.
  • Extensive experience in using Function Points (FP) for Project estimations.
  • Experience in using UML concepts during Design phase.
  • Extensive experience in using Mercury Client and Bridgecase tools for viewing program bugs and Production Support incidents.

Technical Skills:

  • Programming related experience:
    • Language Used: COBOL, REXX, EZtrieve
  • Databases:
    • DB2, IDMS, MS SQL Server, IMS,VSAM.
  • Others:
    • Trained in C, C++, HTML, Assembly language on 8085 and 8086 microprocessors, MATLAB, JAVA, UNIX, PL/SQL, SQL, Oracle, VISUAL BASIC.

Work Experience (Summary):

  • Confidential, (15 September 2010 to Present)
  • Current Location – New York, New York, USA

    • The project involves Analysis, Design, Development, Testing, Production Support of Banking & Finance Systems of Deutsche Bank in its various branches like Americas, Europe and Asia and in the functional domain of Payments, Funds Transfer, STP, SWIFT, Loans & Deposits, Limits, Facilities, GLS, Money Market, Capital Market, Foreign Exchange, Balance Transfer.
    • Obtaining the Requirement by having discussions with customers.
    • Preparation and Review of High Level Design and Low Level Design of the requirement.
    • Preparation and Review of Unit Test Plans. Performing Unit Testing for various programs.
    • Providing Bug fixes for many programs.
    • Development and Review of Programs written in COBOL.
    • Providing ASG Level 3 Production Support for High priority issues and escalations reported on Mercury Client and Bridgecase tools. On call Production level support for Client End Users.
    • Using JCL, CA-7, EZtrieve for invoking COBOL programs.
    • Using IDMS, DB2, IMS, VSAM for interacting with data from the Database.
    • Using REXX for creating TSO online screens.
    • Using Endevor, Changeman, XMODS for component Release.
    • Firing SQL queries inorder to fetch data from the Oracle Database using MS Access.
    • Using MQ Websphere, XML, SFTP, FTP protocols for message and file transfer.
    • Using CICS, ADSO products for interacting with online applications.
    • Using XPEDiter, File AID, Abend AID tools for debugging programs.
    • Using SPUFI, QMF, Stored Procedure for fetching data from DB2 database.
    • Using STROBE and Code Coverage tools for performance measurements.
    • Using QTP, Screen Scraping Macros using Visual Basic Script for automated testing.
    • Maintaining programs using TSO.
    • Providing Technical and Domain Level Training to Team members.
    • Providing Estimation in terms of Function Point (FP) for the development and fixes.
    • Using UML concepts in Design phases.
    • Leading a Team of (1 to 3) members.
    • Experience in working in all phases of SDLC ie Agile Methodology and Waterfall Model.
    • Hardware used is IBM z/OS and IBM z/OS. The Operating system is MVS.
  • Confidential, (20 October 2006 to 9 September 2010)
  • Locations – Milton Keynes, England, United Kingdom & Mumbai, India
    • The project involves Analysis, Design, Development, Testing, Support of Telecommunication Systems of British Telecom for Retail and Wholesale customers in United Kingdom in the functional domains of Order Handling, Network Service, Billing, Repairs of Broadband, Landline, Wireless products.
    • Obtaining the Requirement by having discussions with customers.
    • Preparation and Review of High Level Design and Low Level Design of the requirement.
    • Preparation and Review of Unit Test Plans. Performing Unit Testing for various programs.
    • Providing Bug fixes for many programs.
    • Development and Review of Programs written in COBOL.
    • Providing ASG Level 3 Production Support for High priority issues and escalations reported on Mercury Client and Bridgecase tools. On call Production level support for Client End Users.
    • Using JCL, CA-7, EZtrieve for invoking COBOL programs.
    • Using IDMS, DB2, IMS, VSAM for interacting with data from the Database.
    • Using REXX for creating TSO online screens.
    • Using SPUFI, QMF, Stored Procedure for fetching data from DB2 database.
    • Using Endevor, Changeman, XMODS for component Release.
    • Firing SQL queries inorder to fetch data from the Oracle Database using MS Access.
    • Using MQ Websphere, XML, SFTP, FTP protocols for message and file transfer.
    • Using CICS, ADSO products for interacting with online applications.
    • Using XPEDiter, File AID, Abend AID tools for debugging programs.
    • Using STROBE and Code Coverage tools for performance measurements.
    • Using QTP, Screen Scraping Macros using Visual Basic Script for automated testing.
    • Maintaining programs using TSO.
    • Providing Technical and Domain Level Training to Team members.
    • Providing Estimation in terms of Function Point (FP) for the development and fixes.
    • Using UML concepts in Design phases.
    • Leading a Team of (1 to 4) members.
    • Experience in working in all phases of SDLC ie Agile Methodology and Waterfall Model.
    • Hardware used is IBM System/390 and IBM z/OS. The Operating system is MVS.

Educational Qualification:

    • Masters in Software
    • Bachelor of Engineering in Electronics

Hire Now