SQL Developer Resume Profile

EXPERIENCE:

Confidential

Provide COBOL/IMS/DB2 programming support to the NIH Administrative Database group. The ADB system automates the processes related to the procurement of goods, payroll, property, services and translates these procurement actions into accounting transactions that are processed by the Central Accounting System CAS .
Work as a DB2 and IMS administrator for a large Mainframe environment dealing with payroll, procurement, services, property, and accounting system for NIH to deal with development and maintenance programming.
Analyze requirements and modifies existing COBOL batch and online programs for the ADB and CAS systems.
Provide support to the Central Accounting System and Inventory including reviewing the JCL, parameter file and output message file and monitoring the nightly job that creates accounting transactions and a valid transactiofile for the NIH Business System NBS .
Develop new batch and online programs for the Fellowship Payment System and the Miscellaneous Payments Subsystem using COBOL with IMS and DB2.
Provide System Administrator lead support to the NBS Property Management solution. . Work with the Master and TransactioReconciliatioteam to pinpoint concerns, provided informatioused by the Institutes and Centers ICs ithe data clean-up effort, performed validatioof property and accounting data for conversion, and signed off as the lead NBS/CIT analyst/programmer for Property and Accounting conversioto aOracle based GUI system from Legacy. Configure Sunflower Assets software to be used by NIH as the core property management system. It involves both system setup and general maintenance of the lifecycle asset management process. Received a certificate of excellence for his role iCRP3 and I was also awarded 6.0 Continuing EducatioUnits award for attending and participating iSunflower Systems 3.8 Administration. Provide support icreating and monitor daily jobs using Appworx UC4 Applicatiomanager . Troubleshoot the frontend and backend using Unix/SFTP applications. Change Management and perform the functions as required. Create chains, agents, define path, and ruSQL iFROG applicatiofor Oracle backend.

Monitor nightly batch jobs and make sure they are being processed correctly.

Confidential

Worked with the development team coding new modules and designing specs for the Federal Case Registry System. This tool enabled Child Support Enforcement agencies to collect informatioto locate, establish and enforce functions. Mastered ENDEVOR skills, iadditioto applying basic mainframe with AIX based add osystem. Used MICROFOCUS COBOL with TELOoa day-to-day basis and with this and other related applications.

Confidential

Took part iinstallatioof CICS 4.1 to the motor vehicle system. Reacquired additional CICS/VS command level programming oa mainframe with AIX based add osystem .
Maintained a complex system for billing, electronic transmissions, and registratioprocessing online and batch. Worked with a team of developers isupport of the State's Vehicle Registratioand Titling applications.
Provided productiosupport, and performed new development coding projects ranging. Mastered HOURGLASS 2000 itesting Y2K compliancy. The applicatiowas primarily COBOL-based, running under CICS for TransactioProcessing services and used DB2 for database calls.
Acted as the CEDA/DADS administrator for the MVD-state programmers at Tradeport.
Administered cleanup and security for PANVALET, a library management tool.

Confidential

Responsible for design, development, and testing programs using APS, COBOL II, TSO/ISPF, JCL, EASYTRIEVE and IMS, DB2.
Responsible for the online, CICS portioof the project.
Created inquiry, update/add, and cross-referenced transactions for the project clients.
Performed analysis, corrections, and maintenance of productioprograms for the WisconsiProject.
Created formal documentatioof report functionality and conducted code walkthroughs with system experts and end-users.
Distributed all electronic claims sent for professional and institutional processing. Iaddition, answered help desk calls and evaluated problems sent from all other lines of business. Used ENDEVOR for source storage, module retrieval, compilatioof modules, and program migration.

Confidential

Responsible for the on-going support of critical productiosystems. This included coding and testing applications iresponse to user requests, identifying and correcting system bugs, ensuring that on-line transfers betweestores and multiple vendors nationwide were processed correctly.
Verified that scheduled batch jobs were processed successfully, and provided 24-hour on-call support.
Performed these duties for a variety of applications including inventory, sales and purchasing. Accomplished all maintenance and new development oaIBM 3090 mainframe, utilizing CICS, VSAM, DB2, COBOL II, IS/JCL, APS and TSO/ISPF.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship