Sr. Application Developer /dba Resume
SUMMARY:
- Sr. level Operations Tech / Business Analyst / Project Lead / Developer with 30 plus years of IT experience.
- Responsibilities have included Project management, new development, production support, enhancements, user training, and testing.
- Gathered requirements in the development of many IT applications including Financials, HRMS, Procurement and Data Warehousing
- Developed both functional and detail design specifications which required heavy user interface
TECHNICAL SKILLS:
COBOL, COBOL II, BAL(Assembler), DB2, JCL, File Aid, SDSF, TSO/ISPF, SYNCSORT, AbendAid, CICS, PL/1, ADSC, ADSA, MAPC, SDSF, TSO/ISPF, CICS, EASYTRIEVE, IMS DB/DC, VSAM,Change MAN, PEOPLESOFT, PEOPLECODE, PEOPLETOOLS, MVS/ESA, IDMS DB/DC, ORACLE, DB2, SYBASE, PL/1, ADS/O, DMLO, OLQ, MS PROJECT, DOS/VSE, WINDOWS, CLIST, WorkFlow, Microsoft Access, Microsoft Excel, Microsoft Outlook, Microsoft Power Point, Xpediter, Intertest, ADABAS/Natural , File - aid, Microsoft Word, PeopleSoft, Windows2000, REXX, DATASTAGE, Panvalet, Windows NT, SQL, PL/SQL, GEAC/MSA, C, IE, MQ, Easytrieve, EMR,, CA7/11, CRYSTAL REPORTS, nVision, SQR, ORACLE FORMS, & REPORTS, BRIO, SQL LOADER, OEM, SQL PLUS, Query, TODE, DYL280, JAVA, ColdFusion, Unix & HTML
PROFESSIONAL EXPERIENCE:
Sr. Application Developer /DBA
Confidential
Responsibilities:
- Provided Operations Technical and Production Support for mainframe applications.
- Developed test plans, and set up test data, to test program updates.
- Used DB2, JCL, File Aid, SDSF, TSO/ISPF, SYNCSORT, AbendAid, CICS, PL/1, COBOL, VSAM, Change MAN, BAL, IMS, IDMS and EASYTRIEVE to develop systems in an MVS environment. Was also involved in developing design specifications, which included High-level systems documentation.
- Develop data migration scripts to load system with data from various data sources.
- Worked with users and managers to develop requirements, and reports.
- Tasks included gathering all requirements, documenting the requirements and following the Company Policies and Procedures.
- Did extract and load procedures.
Sr. Application Developer /DBA
Confidential, Montgomery, Alabama
Responsibilities:
- Provided Operations Technical and Production Support for the ABPS - GUIDE application.
- Developed test plans, and set up test data, to test program updates.
- Used DB2, JCL, File Aid, SDSF, TSO/ISPF, SYNCSORT, AbendAid, CICS, PL/1, COBOL, VSAM, BAL, and EASYTRIEVE to develop systems in an MVS environment.
- Was also involved in developing design specifications, which included High-level systems documentation.
- Develop data migration scripts to load system with data from various data sources.
- Worked with users and managers to develop requirements, and reports.
- Tasks included gathering all requirements, documenting the requirements and following the Company Policies and Procedures.
- Did extract and load procedures.
Sr. Application Developer/DBA
Confidential, Washington, DC
Responsibilities:
- Provided Operations Technical and Production Support for the MBS application.
- Developed test plans, and set up test data, to test program updates.
- Was also involved in developing design specifications, which included High-level systems documentation.
- Work heavily with DMSII.
- Converted DYL280 programs to COBOL.
- Worked with users and managers to develop requirements, and reports.
- Did database updates. Used DB2, CICS, & COBOL.
Consultant
Confidential, Roanoke, VA
Responsibilities:
- Developed DB2, COBOL, Change Man & CICS programs in the support of a Federal Safty Management System; also developed extract and load programs for data conversion from IDMS to DB2. Used PL/1; did upgrades to source programs to Confidential Enterprise PL/I for z/OS Version 4 Release.
- Developed user documentation which included design specifications
- Work heavily with SQL, Microsoft Access & Excel. Used DATASTAGE to load ETL.
- Developed an implementation strategy for new development and upgrades.
- Provided production support for the Peoplesoft HR/Financials application(s), GL, AP w/Expense, & AR using SQR, PL/SQL, ORACLE, PS Query, NVision ORACLE reports & CRYSTAL REPORTS
- Worked with users and managers to develop requirements, and reports.
- Developed extract programs to generate data files of GL, & AR data needed in the conversion process for the implementation of the Oracle Financials application
Consultant
Confidential, Nashville, TN
Responsibilities:
- Provided Operations Technical and Production Support for the state Unemployment application(s).
- Used Cobol, DMS, Honeywell Bull, and GCOS Developed Cobol programs, user jobs, reports, test plans, and test data.
Consultant
Confidential, Columbia, SC
Responsibilities:
- Provided Operations Technical and Production Support for the Confidential voter application(s). Used COBOL, PL/1; modified PL/1 programs & JCL for dataset upgrade, DB2, IDMS, ADSA, ALC, MAPC, IDD, DMLO, OLQ, TSO/ISPF, SDSF, ADSO, JCL, OPC, CLIST, CICS, VSAM, IOF and SAS.
- Developed user jobs, reports, test plans, and test data. Did program and dialog migrations.
- Made changes to database and file record formats.
- Provided user documentation.
- Did backup and restores of Database and VSAM files
Consultant
Confidential, Memphis, TN
Responsibilities:
- Provided Operations Technical and Production Support for the Peoplesoft application(s).
- Used SQL, Oracle, UNIX.
- Modified and updated ETL using SQR. Did program migrations.
- Made changes to database and file record formats.
Consultant
Confidential, Memphis, TN
Responsibilities:
- Provided Operations Technical and Production Support for the PEOPLESOFT HR application which included Payroll, Time and Labor, Benefits, Costing, and Travel.
- Developed reports using SQR, PL/SQL, ORACLE, ORACLE reports, CRYSTAL REPORTS, People tools, People code, & interface programs
- Developed user documentation which included design specifications
- Work heavily with SQL, Oracle, UNIX, Microsoft Access & Excel.
- Developed an implementation strategy for new development and upgrades.
Consultant
Confidential, Tampa, FL
Responsibilities:
- Provided Operations Technical and Production Support for the Peoplesoft application(s).
- Developed test plans, and set up test data, to test program updates.
- Was also involved in developing design specifications, which included High-level systems documentation.
- Worked with users and managers to develop requirements, and reports.
- Provided production support for the Peoplesoft HR/Financials application(s), GL, AP w/Expense, & AR using SQR, PL/SQL, ORACLE, PS Query, NVision ORACLE reports & CRYSTAL REPORTS
- Developed extract programs to generate data files of GL, & AR data needed in the conversion process for the implementation of the Oracle Financials application
Consultant
Confidential, Denver, CO
Responsibilities:
- Provided developmental support for the implementation of a Peoplesoft Accounting system in an Oracle environment.
- Modify & write SQRs, SQLs and Queries .
- Created extract and load files for the population of Peoplesoft tables.
- Developed test plans, and set up test data, to test program updates.
- Was also involved in developing design specifications, which included High-level systems documentation and flowcharts which detailed the inputs, outputs, & major processing logical.
- Work heavily with SQL to create and test batch interface programs.
- Worked with users and managers to develop requirements, and reports.Developed and maintained project plans needed in the conversion process for the implementation of the appli cation.
- Provided production support for the Financials application(s), GL, AP w/Expense, & AR using SQL, PL/SQL, ORACLE, ORACLE reports & CRYSTAL REPORTS .
- Worked with users and managers to develop requirements, and reports.
- Developed extract programs to generate data files of GL, & AR data needed in the conversion process for the implementation of the Oracle Financials application
Consultant
Confidential, Indianapolis, IN
Responsibilities:
- Provided production support for applications using OS/390, IDMS, ADS/O, CICS, converted PL/1 programs to Cobol, and COBOL.
- Developed test plans, and set up test data, to test program updates.
- Work heavily with MAPRII, IDD, MAPC, CLIST, ADSC, OLQ, DMLO, JCL, OPC, COBOL, REXX and TSO/ISPF to modify and test both batch and online programs.
- Worked with managers to develop system requirements, & reports.
- Used PeopleSoft & Oracle to generate reports ad-hoc queries using SQL, CRYSTAL REPORTS & PL/SQL.
- Developed test plans and coordinated and performed unit, systems and integration testing.
- Provided analysis, documentation, and developed technical specifications.
- Assisted programmers in creating SQR programs for PeopleSoft HR, and Benefits.
- Provided system setup, training, and production support for the HR / Payroll.