We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

Charlotte, NC

SUMMARY:

Senior Programmer/Analyst skilled in a variety of operating system platforms and computer languages capable of translating complex technical material into concrete and understandable objectives to key business owners and project stakeholders in a cross - platform and cross-functional environment.

TECHNICAL SKILLS:

Operating-Systems/Environments: IBM VM/SP, DOS/VSE/SP, OS/400, CICS/ICCF, CMS, MUSIC/SP, MVS/XA, MVS/ESA, OS/390, Z/OS 390, AS/400 V5R1, iSeries V5R2, iSeries QSHELL, Z/OS Unix Shell, DEC TOPS/10.

Databases: dBase IV, Oracle 9I, Oracle 11g, iSeries/i5/OS DB2 UDB, z/OS DB2, NOMAD-DBMS, IMS/VS, Teradata, Netezza

Database Communication: DRDA, DDM, DB2 CONNECT

Communication Software: VTAM, NSH7, RSCS, SNADS, SNA, TCP/IP

Network Monitoring: NCCF and NETVIEW

Spooling Subsystems: VM/RSCS, MVS/JES2, DOS/VSE/POWER

Programming Languages: DOS/VSE/RPGII, OS/VS/COBOL, DOS/VSE/COBOL, COBOL II, 400/COBOL, 400/COBOL ILE, z/OS Enterprise COBOL, 400/RPG III, 400/RPG ILE, COBOL 390 for VM and MVS, REXX, REXX NEATWIND, REXX/SQL, FORTRAN, EXEC 2, SQR, UIM, CL, CLLE, PL/SQL, ICCF PROCEDURAL LANGUAGE, QUICKJOB, EASYTRIEVE, NOMAD, COBOL/CICS COMMAND LEVEL) and BMS ASSEMBLER MACROS

Development Software:

Oracle: SQL *FORMS, SQL*PLUS, PL/SQL Developer, iSQL*PLUS, Oracle Forms 6i, Oracle Forms 11g, TOAD

Mainframe(z/OS): IDCAMS, JCL, JES, DITTO, JOBSCAN, PREP, JCLCHECK, FileAid, AbendAid, INTERTEST, XPEDITER, XCHANGE. SDSF, IOF, MIGRATOR, ISPF Dialog Development, Rexx DSNREXX, Rexx QMF DSQCIX

PC Mainframe Software: SPF/PRO, KEDIT, QMF for Windows

CICS: BMS, CECI, CEDF, CEMT, SDF II

AS/400 (iSeries): SDA, PDM, SEU, DFU, PC SUPPORT, CONNECT DIRECT, CONTROL-M, ISQL, QM, OPNQRYF, QUERY 400, CODE, APIs.

ETL Software: Pervasive - Data Junction/Data Integrator

Change Management Software: i5/OS Aldon, Turnover z/OS Panvalet, Endevor

Email Software: Outlook, Outlook Web Access, Outlook Express, Lotus Notes, Novell GroupWise

PCs: VISIO, PC/DOS, MS/DOS, OS/2, WINDOWS 3.1, WINDOWS 95, WINDOWS 98, WINDOWS NT, WINDOWS XP, EXCEL, WORD, FRONTPAGE, ACCESS, LOTUS 123, AS/400 Client Access, OPS Navigator, iSeries Access, iSeries Navigator

Internet/Web development: HTML, JAVA SCRIPTING. Designed and maintained http //main.nc.us/yancey/ for MAIN (Mountain Area Information Network).

Insurance Application Software: CSC POWER/MHS 4.7 and 5.0, CSC POINT, BCBSA LRSP, Perot Systems DIAMOND 950 (Paradigm), QNXT

Computer Operations/Job Scheduling/Display Software:

VM/SP Software: VMTAPE, VMOPERATOR, VMBACKUP, VMBATCH, VMARCH, VMSECURE, PASSTHRU, ICCF, REXX EXECS, GML, SCRIPT/VS, DCF,XEDIT, BOOKMASTER, CMS, and PROFS. z/OS Software: Control-M, Control-M Desktop for PC, JHS, SDSF. i5/OS: Robot/Alert, Robot/Network, Robot/Reports, Robot/Schedule, Robot/Console, Robot/LPAR, Native i5/OS Scheduler, BRMS, Passthru, Control-M.

QA Software/Mercury: Mercury QC, ClearQuest, Confidential QC

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

  • Practice Solutions to AFS conversion
  • Worked with IBM support to create File Manager templates for VSAM files with segmented data.
  • Attended conversion and data mapping meetings.
  • Corrected SRs (service requests) and moved into production.
  • Used JCL, BATCH, and IBM Debugger to test new program changes.
  • Setup ODBC connections for MS Access to SQL Server

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

  • Included coding in Oracle SQL/Netezza SQL
  • Implementation of FSR (Financial Systems Roadmap)…switching legacy Ledger to new eLedger SAP
  • Included coding in a z/OS COBOL/JCL/VSAM
  • Unit/Dev/SIT/UAT with full regression testing and using Confidential Quality Center
  • Conversion of Teradata legacy utilities TPUMP, MLOAD, Xport to Teradata TPT (Teradata Parallel Transporter) scripts, included DEV/SIT/UAT and regression testing.
  • SIT/UAT testing of for Teradata TTU upgrade from 1 .10.
  • Implemented several ISPF/Rexx programmer utilities for SIT/UAT testing and development work.

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

  • Created DB2 Stored Procedures, called by Web Services to replace VB6 screen scrapers
  • Created DB2 Stored Procedures, called by Web Services, called by IVR. This also included, creating unit test case scenarios and uploading into Confidential Quality Center for QA testing
  • Updated CICS screens and unit tested for Automate Deposit Review project. Included using Intertest debug for unit testing.
  • Created and used Rexx/DB2 DSNREXX, QMF API DSQCIX, ISPF Dialog (panels, execs, etc)
  • Also, because of lack of staff, used as a QA tester for Automate Deposit Review project
  • 122 Test cases in Confidential Quality Center
  • Run queries to obtain data for S1 test environment from production data
  • Load data into S1 test environment
  • Execute batch jobs and run new JCL/program changes and Billing cycle
  • Run queries and execute Confidential Quality Center Test Cases

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

  • Used BTEQ unload utility to extract data from tables in Teradata into mainframe flat files.
  • This was done with JCL and parameter file setup with Teradata SQL queries and Teradata BTEQ session control commands and Collect Statistics.
  • The Teradata SQL also used attribute functions to translate the column data from Teradata to different formats for the flat files that the COBOL could READ. This data was later translated into pure CHAR format and sent to either Oracle/Unix or Netezza/Linux.
  • Unix/Oracle environment using:
  • PL/SQL
  • PL/SQL Developer
  • TOAD
  • Shell scripts and CTL files with SQL Loader loading Oracle tables
  • Linux/Netezza environment using Aginity Netezza Workbench, WinSCP, Putty and verifying data once loaded in Netezza tables.
  • All sending of data to Oracle/Netezza included mapping of mainframe data to Oracle/Netezza table columns. z/OS/Mainframe environment using COBOL, JCL, SDSF, Rexx, ISPF Dialog Development, ISPF C/S and WSA, VSAM, NDM, SORT, ICETOOL, CA-7, SAR, DFSMShsm, PODS
  • Worked with Changeman administrator and help test new compile procedure for IBM Debug
  • Worked with z/OS support tools group and tested new IBM tools: IBM Debug, File Manager, and Fault Analyzer
  • Developed several utilities with ISPF C/S and WSA, ISPF Dialog Manager, Rexx, DFSMShsm, and File Manager

Confidential, Glen Allen, VA

PL/SQL Developer

Responsibilities:

  • Develop and maintain programs using OPM COBOL, ILE COBOL, ILE COBOL/SQL in an i5/OS environment.
  • Create custom enhancements to i5/OS ASI software: screens and programs.
  • Backup i5/OS operations: tape, printing, and user support.
  • Migration of Oracle Forms 6i to 11g (Oracle).
  • Included updating PL/SQL in forms
  • Included writing/testing/implementing new PL/SQL Procedures
  • Crystal Report 9 reports (Oracle)
  • .Net Excel Viewer reports (Oracle)
  • Gathering project requirements from users and updating and designing technical specifications or make suggestions for alternative solutions.
  • Software Used:
  • DB2 UDB V5R4
  • SQL, ISQL, Query Manager, RUNSQLSTM, iSeries Navigator, Squirrel, ILE Debugger, Stored Procedures, iDate
  • Separate LPAR with iCluster for capturing data changes with journaling
  • I5/OS Web Access
  • DDL for Oracle and DDS for i5/OS
  • Turnover
  • DB relational modeling of i5/OS files to Oracle tables or materialized views
  • Oracle Gateway 9i and 11g
  • Oracle PL/SQL Developer and TOAD
  • IFS using CPYTOIMPF, CPYFRMIMPF, CPYTOSTMF and CPYFRMSTMF
  • IFS using Windows NetServer Commands thru command STRPCCMD

Confidential, Boston, MA

PL/SQL Developer

Responsibilities:

  • Maintained and created programs using Enterprise COBOL/DB2/SQL, DB2 stored procedures in Batch and CICS environments for PWI Brokerage Systems.
  • Designed TSD and developed new jobs, procs, COBOL/SQL, for FDIC Max project using Waterfall and Agile methodology.
  • Old and new programs unit tested and QA SIT and UAT tested in different regions and LPARs.
  • Converted business requirements into high level and technical design specifications and created and maintained technical systems documentation.
  • Created and maintained ISPF programmer utilities using Rexx, ISPF Services, ISPF C/S WSA, DB2 DSNREXX, QMF DSQCIX, and DSNESC01 FUNC(SPUFI).
  • Executed QMF and SPUFI queries against DB2 to identify patterns of data.
  • Created Test Plan and executed Test Cases using Mercury Quality Center (QC). Tracked QA defects using Clear Quest.
  • DB relational modeling of z/OS DB2 tables

Confidential, Southfield, Missouri

PL/SQL Developer

Responsibilities:

  • EDI X12 HIPPA transactions to front end systems
  • Mainframe LRSP to QNXT/QITS conversion project, data mining, data mapping, data analysis, data conversion.
  • Converted in-house programs for ITS releases 9.3, 9.4 and 10.0. This included VSAM to DB2 conversion for ITS REL 10.0 which included coding, unit, regression and parallel testing.
  • Created and maintained in house conversion utilities using ISPF Dialog and Rexx
  • Converted in-house programs for NPI and LDLA. This included coding, unit, regression and parallel testing.
  • Consultation on ALIM (Aid Line Item Manager), Host Integration Server (HIS), LU6.2 Mainframe CICS Connection
  • Converted business requirements into high level and technical design specifications and created and maintained technical systems documentation.
  • Provided 24/7oncall support and researched/resolved system problems and user questions.
  • AS/400 and OS/390 cross platform development using COBOL/DB2/SQL/CL, DB2 Stored procedures.
  • Software Used:
  • DB2 OS/390 and AS/400
  • IBM Migration Utility - COBOL II to Enterprise COBOL
  • SQL, COBOL/SQL ILE, ISQL, Query Manager, RUNSQLSTM, Ops Navigator, ILE Debugger
  • DDS for i5/OS
  • Aldon
  • IFS

Confidential, Bedford, Texas

Developer

Responsibilities:

  • Mainframe LRSP to Perot Systems DIAMOND 950 conversion project using HIPPA compliance.
  • Data mining, Data Mapping, data analysis, data conversion, programming/development.
  • Analysis of JCL job streams, VSAM files, SQL Stored procedures, COBOL and Easytrieve source code.
  • Also used Fileaid to examine data files.
  • Developed packages, procedures, and functions using PL/SQL and PL/SQL Developer in a Oracle 9i environment.
  • Developed Business and System requirement document for data conversion process which included Acceptance Testing requirements for System Test and Corrections, DIAMNOD 950 Test and Corrections, Integration Test and Corrections, and UAT Test and corrections. Worked with QA/UAT team in developing Test Strategy/Test Plan. This included structured data test strategy, notifications of bugs, and incident determination process.
  • LRSP data was extracted from IMS and populated into an Oracle ODS (Operational Data Store) environment. The ODS data was then used for conversion into the (Oracle) DIAMOND 950 environment. Responsible for Premium Billing and Authorization conversions.
  • Introduced to and used ETL software - Pervasive Software - Data Junction/Data Integrator (VB script oriented).
  • Extracted data from Oracle to MS Access and MS Excel for queries and ad-hoc reporting.

Confidential, Richmond, Virginia

PL/SQL Developer

Responsibilities:

  • Developed Functional, Technical, and Test Plan documents.
  • All testing, end-to-end was done by programmer as no QA testing team existed in company.
  • RPG III/ILE and COBOL/DB2/SQL/CL programming languages in an AS/400 environment.
  • Adhoc reports for reporting of insurance data; this includes the following:
  • Accident results for 2003 - Paid loss/expense, Reserve Loss/expense, total incurred
  • Accident results for 2004 1st Qtr - Paid loss/expense, Reserve Loss/expense, total incurred
  • Total Losses that exceed $50,000.00 since 1999, Paid loss/expense, Reserve Loss/expense, total incurred
  • Extract policy information for glass coverage and build converted/formatted outfile to send to vendor.

Confidential, Wilmington, Delaware

PL/SQL Developer

Responsibilities:

  • Upgrading insurance application in an AS/400, z/OS 390 environment using HIPPA compliance.
  • Tools used include: Endevor, Easytrieve, Fileaid, JCL, VSAM, COBOL, Aldon, OS utilities and FTP.
  • Coding interfaces to CSC POWER/MHS and writing adhoc reports using AS/400 COBOL, and COBOL/DB2/SQL and CL.
  • Data mining, Data conversions/interfaces between AS/400 and mainframe.
  • AS/400 and OS/390 cross platform development using COBOL/DB2/SQL/CL
  • Software Used:
  • DB2 OS/390 and AS/400
  • SQL, COBOL/SQL ILE, ISQL, Query Manager, RUNSQLSTM, Ops Navigator, ILE Debugger
  • DDS for i5/OS
  • Aldon
  • IFS
  • Worked with QA in developing Test plan and test cases and validating test results. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.

Confidential, Edison, New Jersey

PL/SQL Developer

Responsibilities:

  • Analysis on Oracle Forms, databases, stored procedures, PL/SQL, etc. for an Oracle to AS/400 DB2 UDB conversion.
  • Software Used:
  • DB2 AS/400
  • Oracle

Confidential, Durham, North Carolina

P/A-Lead Developer

Responsibilities:

  • Developed and maintained COBOL programs in an AS/400 DB2 UDB, OS/390 DB2 UDB, IMS DB/DC environment. Programs extracted information from IMS and either updated DB2 table on OS/390 or were sent to AS/400 were DB2 tables on AS/400 were updated. Programs extracted information from AS/400 tables and data was sent to update DB2 tables on OS/390 or update IMS files. Also, used 400/RPG III, 400/RPG ILE and C++ programming languages for exit programs and utilities. Easytrieve and Fileaid were also used.
  • Used PL/SQL scripts to extract data from Oracle and send to AS/400 and mainframe applications.
  • Lead team in developing and implementing DRDA (distributed relational database architecture, AS/400 DB2 to OS/390 DB2 ) standards between AS/400 and OS/390 platforms for HIPAA. Included connectivity issues from AS/400 to OS/390 and OS/390 to AS/400. As well as, developing/implementing DB2 stored procedures on both AS/400 and OS/390 and database triggers on AS/400.
  • Responsible for POWER/MHS EOB prompt pay, ITS EOB letters, premium billing, transfer and reformat for HCFA and UB92 claims, letter correspondence, claim throughput daily, weekly and monthly reports, VRU interface, and HIPAA Confidential Communications. This included developing functional and technical specifications and working with QA in developing test plan and test cases and validating results. . This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
  • ITS/POWER/MHS batch adjudication and reports, Claims Payment Cycle and reports, posted claims and reports and ITS Home Claims Purge Report. This included developing functional and technical specifications and working with QA in developing test plan and test cases and validating results.
  • Created and maintained utilities for programmers. FTP utility using REXX/400 - see i5OS FtpFile.htm. SEU line command utilities - see example Cobol Source i5OS SEU editor.htm.
  • Contributed to iSeries Network newsletters - SEU and JCL: see links on my website - Newsletters I have Contributed to: Resume.htm
  • Developed REXX execs on mainframe using ISPEXEC services, which automated program compiles. The execs allowed programmers to submit compiles directly from an edit session while either in ISPF EDIT or Panvalet. This eliminated having to store separate JCL members for program compiles which standardized the compile process for the team.
  • Provided technical support for implementing ALIM across a TCP/IP network using ANYNET. Also, designed and maintained network monitoring screen for the ALIM connection, which updated automatically when a device or controller connection dropped.
  • Data mining, Data conversions between AS/400 and mainframe using HIPPA compliance.
  • Provided SPM support for AS/400. Included enforcing coding standards for COBOL ILE and CLLE. Also, provided additional AS/400 for team members and technical expertise for DB2 UDB.
  • Administered and tested performance enhancements for AS/400 DB2 UDB (Load Testing and Stress testing). This included using the new iSeries database SQL Performance Monitor feature and use of the QAQQINI file.
  • Received 3 Confidential Blue Ribbons in recognition for working on projects and recommended for 1 Confidential Blue Star in recognition for providing technical support on new features of iSeries Navigator and received 1 Letter of Recognition for work on the PowerMHS 4.7 implementation.
  • Software Used:
  • DB2 OS/390 and AS/400
  • SQL, COBOL/SQL ILE, ISQL, Query Manager, RUNSQLSTM, Ops Navigator, ILE Debugger
  • DDS for i5/OS
  • Aldon
  • IFS

Confidential, Raleigh, North Carolina

P/A-Lead Developer

Responsibilities:

  • Prepared RF Home Accounting Update and reports.
  • Delivered POWER/MHS EOB/EOP messages and letters.
  • Worked with QA in developing Test plans and test cases and validating results.
  • This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
  • Data conversions between AS/400 and mainframe.
  • Software Used:
  • DB2 OS/390 and As/400
  • SQL, COBOL/SQL ILE, ISQL, Query Manager, RUNSQLSTM, Ops Navigator, ILE Debugger
  • DDS for i5/OS
  • Aldon
  • IFS
  • Fileaid, Easytrieve, and Visio used in AS/400 mainframe environment.

Confidential, Raleigh, North Carolina

P/A-Lead Developer

Responsibilities:

  • Maintained PARS, dBASE IV - Friday Center, Conferences and Institutes and PARS Personnel Activity Reporting System - Batch applications.
  • Converted batch VS COBOL II/VSAM application to COBOL/SQL/Oracle - all VSAM files were converted to Oracle databases, which included data conversions. Oracle was running in the UNIX Shell on an OS/390 mainframe.
  • Used PL/SQL for producing reports on converted data.
  • Managed DBase IV. Responsible for adding and setting up User IDs for database access.
  • Completed programming requests for new forms, screens and programs.
  • Performed maintenance and enhancements to CICS applications, Fileaid, Easytrieve.

Confidential, Cary, North Carolina

PL/SQL Developer

Responsibilities:

  • Examined and verified all code for date-related issues.
  • Developed Confidential Integrated Test Plan and test cases, tested and validated results of application for compliance on test LPAR (logical partition). This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections. Programmer did all testing, as no QA Testing Team existed in company.
  • Fileaid, Easytrieve, Visio used.
  • Examined and verified all code for date-related issues.
  • Developed a Confidential Integrated Test Plan and Test cases, tested and validated results of application for compliance on test LPAR. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections. Programmer did all testing, as no QA Testing Team existed in company.
  • Mercury testing tool was used for automation of test cases.
  • Fileaid, Easytrieve, Visio used.
  • Examined and verified all code for date-related issues.
  • Developed Confidential Integrated Test Plan and test cases, tested and validated results of application for compliance on test LPAR.
  • This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections.
  • All testing was done by programmer as no QA Testing Team existed in company..
  • Mercury testing tool was used for automation of test cases.
  • Fileaid, Easytrieve, Visio used.
  • Examined and verified all code for date-related issues.
  • Developed Confidential Integrated Test Plan and test cases, tested and validated results of application for compliance on test LPAR. This included System Test and corrections, Integration Test and Corrections, and UAT Test and Corrections. Programmer did all testing, as no QA Testing Team existed in company. . Mercury testing tool was used for automation of test cases.
  • Fileaid, Easytrieve, Visio used.

Hire Now