Maintenance System

Lonny Millikin

**** ****** *****, *****, ***** 75098 - Home 972-***-**** - Cell 918-***-**** - *******@*****.***

MISSION

To work within a corporate IT environment using my skills and expertise as an IT Technician.

PROFESSIONAL SUMMARY

My experience includes the areas of internal and external training, and customer support. Skilled in designing infrastructure and implementing technology to support large user groups, supporting users at corporate headquarters as well as multiple remote locations. Ability to translate business needs into technology requirements that support the company’s business objectives. Participate in all phases of projects from analysis and requirements definition, coding, testing, documentation, implementation, and training (SDLC). COBOL, COBOL II, SQL, PL/SQL, and SQLPLUS development and use skills are excellent. View, Procedure, Function, and Trigger development skills for ORACLE, SQL SERVER, and DB2 tables are very good.

TECHNICAL SKILLS

APPLICATIONS: MICROSOFT OFFICE SUITE, VISIO, PROJECT

SPECIAL TRAINING: PROBLEM SOLVING, TIME MGMT., TEAM MGMT., DIVIRSITY, PROJECT MGMT.

LANGUAGES: COBOL, COBOLII, VISUAL COBOL, ACCUCOBOL, MICROFOCUS COBOL, PLI, CICS, EASYTRIEVE, SQL, SQL PLUS, PLSQL

TOOLS: TSO/ISPF, SPF/PC, QEDIT, ULTRAEDIT, VPLUS, SUPRTOOLS, PLUSMENU, PANVALET, SQL DEVELOPER, TOAD, BZR, FTP

DATA FORMATS: DB2, IMS, RBASE, ACCESS, VSAM, KSAM, IMAGE DB, ORACLE, SQL SERVER

PLATFORMS: IBM MAINFRAME OS/VS (JES2/JES3), HP3000 MAINFRAME, IBM/PC, UNIX, LINUX

EXPERIENCE

Conversion Specialist, Oral Roberts University, Tulsa, Ok. 06/2009 – 01/2014

Support Banner Scholastic System ORACLE, SQL Server, SQL, SQL Plus, PLSQL UNIX/Linux Script

Develop and process ETL using cross reference tables, functions, and stored procedures to scrub and store data.

Convert various legacy systems using flat file, SQL Server and Oracle data into Banner Oracle tables.

Development and maintain PL/SQL procedures, triggers, and functions.

Develop Ad-Hoc and structured customer reports using ARGOS reporting tools

Develop customer online access to add, change, and delete class schedules using PERL.

IT Technician, EDS/HP, Tulsa, Ok. 2/2007 – 6/2009

Maintenance support Reservation System to ORACLE, COBOL, SQL, UNIX Script

Develop, document, and implement program unit and system test plans.

Assist Team Leader developing and implementing test plans for Server Fail Over testing.

IT Technician, Dollar/Thrifty Group, Tulsa, Ok. 6/2005 – 4/2006 (Consultant)

Converting flat file Reservation System to ORACLE, COBOL, SQL, UNIX Script

Develop, document, and implement program unit and system test plans.

Perform analysis and code required changes for flat file to oracle sql conversion.

Develop, document, and implement data conversion process.

IT Technician, Community Care Healthcare, Tulsa, Oklahoma, (7/02 – 1/03 ) (4/2006-2/2007) (Consultant)

Converting AMISYS based Healthcare system from an HP3000 mainframe to ORACLE, MICROFOCUS COBOL, SQL, UNIX Script

Converting mainframe JCL to UNIX script shells.

Worked with the Information Technology Department of Community Care Healthcare to develop a HIPAA compliant delivery solution as outlined in HIPAA regulations. (HP Mainframe)

Analyze and modify custom AMISYS reporting capabilities to meet HIPAA regulations for compliance.

Participated in a project to design and develop a new FORMSPEC interface for the current claims management system to provide the user more flexibility in navigation and submission of claims operations.

Tools used include: ROBELLE Solutions Technology QEDIT for Win32; COBOL II; Image Databases; KSAM files; SUPRTOOLS; HP VPLUS FORMSPEC VFORM design; PLUSMENU; MINISOFT 92 v4.4 for Win32 and Reflections emulation packages for an HP3000 Mainframe platform; Data Junction Integration Studio 7.5 for PC.

IT Support Analyst, Texaco, Houston, Texas, 3/99 – 9/01 (Consultant)

All maintenance and support, analysis, coding, unit testing, system testing, code integrity and 24 hour on-call support of each system.

Performed maintenance support and enhancements of Asset Depreciation system consisting of COBOL, DB2, and CLIST.

Performed maintenance support and enhancements of Budgeting system consisting of COBOL, DB2, SQL, and CLIST. The support on this system was mostly writing COBOL programs which included embedded SQL for selecting and formatting the data for special year end processing of budget items for each department.

Performed maintenance support and enhancements of the Electronic Payment System (EDI) consisting of COBOL, PEP+, VSAM, and SQL. This system required close observation when bank deposits were transferred. COBOL programs were used to manipulate and report the information and then passed files to a server using TCIP scripts and then passed on to the banks server. Safeguard enhancements were built in to contact the support person via email when a problem was detected.

Participated in the year 2000 code conversion, testing, and production installation for the Corporate Financial Reporting, Budgeting, Accounts Payable, and Asset Depreciation systems. This project included the development of “Date Functions” which were incorporated into the current code rather than changing the current date usages. This technique was very successful and reduced our conversion time drastically. Processing interruption risk was also lessened because each program became independent of the other using the functions.

Served on a team of supervisor and project leaders assigned the task of developing a test environment for year 2000 changes. The system was designed and developed to prevent interruption of production processing while presenting all of the challenges of a production environment. This included supplying production like data for realistic testing.

Supervised the design and development of a mock disaster recovery process for the Corporate Financial Reporting, Budgeting, Accounts Payable, and Asset Depreciation systems. The process included recovery of system software, program recover, data recovery and actual processing comparisons after recovery.

IT Analyst/Project Leader, Supervisor, Texaco, Tulsa, Oklahoma, 1/85– 3/99

Project Leader responsible for all of the financial installed systems for the corporate offices and all remote locations including London.

Responsible for developing a performance plan including meaningful objectives with measurable tasks, obtainable goals, and semi-annual reviews. The attainment of these objectives was related directly to the salary increases.

Developed, programmed, installed, and maintained a distributed Accounts Payable system corporate wide using VSAM, CICS, and COBOL.

Performed maintenance of Corporate Financial Reporting consisting of PLI, IMS, EASYTRIEVE, and FILEAID.

Performed maintenance support of Asset Depreciation system consisting of DB2, COBOL, and EASYTRIEVE.

Performed maintenance support of Cash and Banking interface system consisting of VSAM, COBOL, and EASYTRIEVE.

Performed maintenance support of Voucher Accounting system consisting of VSAM, COBOL, and EASYTRIEVE.

Converted all above systems from JES2 to JES3.

Designed, developed, programmed, tested, installed a complete PC based Bond Tracking system consisting of CICS, COBOL, and VSAM which interfaced with a mainframe accounting system (AS400).

Successfully converted the Voucher Accounting System from Getty into the Texaco Financial Reporting System.

Developed and maintained a twenty-four hour support schedule for the Financial Reporting System utilizing all analyst and programmers.

Assisted in the study, planning, and conversion of the Getty Accounts Payable system. Converted from the IBM 3790 distributed system to CICS system.

Personally responsible for installing the new CICS system in all remote Getty locations.

KEY SKILLS

COBOL 20+

PLI 5

CICS 5

EASYTRIEVE 5

SQL 10+

PL/SQL 5+

VSAM 20+

IMS 10+

ORACLE 10

DB2 8

IBM/OS 20+

UNIX/LINUX 9

Contact this candidate