Human Resource Data

Neil Olenick 609-***-****

* ******** ***** *****, ** 08081 ****.*******@*******.***

Experience:

Extensive experience developing and maintaining Client/Server and Legacy

RPG ( RPG IV, RPG ILE, RPG Free, Embedded SQL) & COBOL (COBOL/400, ILE,

Embedded SQL) applications on AS400. Many years of experience with manual

data integration and conversion and automated experience with Pervasive ETL

tool.

5 years Financial Systems Applications Development Manager on AS400. Able

to translate users needs into

cost-effective user friendly solutions. Ability to identify multilevel

processes that can be transformed into well streamlined automated

applications. Displays a high level of critical thinking in bringing

successful resolution to high impact, complex, and/or cross functional

problems. Easily ramps up to learn any new or legacy application and is

always willing to learn new software and processes. Comfortable working

independently as well as in a team environment.

Knowledge:

CLP, CLLE, RPG III, RPG/400, RPGIV, RPGILE with embedded SQL, RPG Free,

COBOL & COBOL/400, COBOL ILE with embedded SQL, SQL, QMQuery, Query for

AS400, Oracle PL/SQL, SQL Stored Procedures/Triggers, Oracle SQL Developer,

PERVASIVE Integrator (ETL data integration and conversion tool), Integral

Systems Human Resource/Payroll Package, MKS Implementer, OS/400, TCP/IP,

FTP, Client Access, AIX, Websphere Development Suite Client (WDSC),

Microsoft Word, Microsoft Excel, Microsoft Project, Visio, Windows (2000,

XP, Vista).

Current responsibilities:

Technical lead on team to divest two water and sewer utility areas to a

third party software to be owned by another division of the current utility

company. Developed automated process to extract the master data

information to be used to load the new third party software.

Developed paperless billing process for CIS system using stored procedures

and FTP process utilizing the IFS on an Iseries.

Developed automated process to allow mass closing of contract billing

services for outside municipalities for major water company.

Developed automated process to allow mass premise attachment to relate

premises to sewer authorities for municipalities for a major water company.

Support and enhancements to main extension Developer refund process

applications.

Proficient in Pervasive integrator data integration and conversion tool

which was used to convert data from outside data source and integrate to

standard file format from most outside data formats. Used for water

company acquisitions.

Maintenance and enhancements to cross connection install and testing and

customer letter generation process.

Experience:

Accenture LLC

Senior Application Technical Support Specialist

April 2010 to Present

American Water Service - Voorhees

Senior Applications Developer/ Support Specialist July

2003 to March 2010

Proficient in Pervasive integrator data integration and conversion tool

which was used to convert data from outside data source and integrate to

standard file format from most outside data formats. Used for water company

acquisitions.

Developed reporting system to determine collect-ability percentages of

aging balances over 180 days based on certain categories of account status.

Support and enhancements to main extension Developer refund process

applications.

Designed and developed major enhancement to automate Utility Bill Message

change move process

Neil Olenick ****.*******@*******.***

between test and production that allowed IT business analyst to perform

this task in an extremely efficient manner.

Support and development for the Back Flow Device Cross Connection systems

applications across all States.

Designed and developed major enhancement to automate rate change move

process between test and production environments that allowed business

users to handle this outside of IT intervention.

Documentation and conversion program development for the SAP conversion

project for E'Town using SQL, Embedded SQL RPGLE which was acclaimed by

senior VP as the best company conversion to date.

Support for business issues and problems and developing solutions for Bill

messages and inserts setup and O&M billing setup.

New Jersey-American Water Company - Haddon Heights, NJ August

1998 to July 2003

Software Development & Support Consultant

Support and program enhancements in the EDIS CIS system in the S36 AS400

environment for seven

operating centers with a total of twenty three districts as well as two

Contracted Billing companies.

Programmed and developed process to add four separate water company

acquisitions to ORCOM production environment.

Developed process to create new Contract Billing services in the ORCOM

environment from existing billed water accounts.

Conversion of two Contract Billing systems for Y2K remuneration.

Developed Commodity demand billing system for water resale.

Converted usage data system from accessing data from the Legacy CIS system

database to the ORCOM system database after conversion from Legacy system.

Abington Memorial Hospital - Abington, Pa September

1992 to August 1998

Financial Systems Applications Development Manager

Management of three Senior Programmer Analysts, one Programmer Analyst, one

Senior Systems Analyst and one Database Analyst in the assignment,

prioritization and completion of Financial Systems

projects. Developed interface strategy using TCP/IP FTP sending files to

the Patient Accounting System (AS/400) from the Pharmacon Pharmacy Billing

system (RS/6000), from the Patient Accounting system to the HCC Managed

Care Contract analysis and Modeling system (RS/6000) and using SNA for the

interface from the Patient Accounting system to the Ontario Credit &

Collection System (RS/6000).

Responsible for Capital and Operating budgets for the Financial Systems

Development group.

Project leader for conversion of ISI Payroll/HR system to Software Plus

Payroll/HR.

Project leader for SYS/38 conversion to AS/400.

Abington Memorial Hospital - Abington, Pa. July 1987

to September 1992

Sr. Programmer / Analyst

Conversion of Payroll Budgeted Hours subsystem from Burroughs COBOL to IBM

S/38 COBOL.

New release upgrade for Integral Systems Human Resource/Payroll Package.

This entailed total research and documentation of previous enhancements

prior to this new release.

Solely responsible for the research and development to convert of weekly

Payroll to bi-weekly Payroll.

Solely responsible for the research and development to bring Direct deposit

enhancement to Human Resource/Payroll package.

Solely responsible for the research and development to bring the Addition

of pre-tax flex accounting to Human Resource/Payroll Package.

Developed Outpatient referring Physician Reporting Subsystem.

Developed accrued leave hours status reporting subsystem to advise

department managers when employees will lose benefit hours.

Developed Long term disability and Life Insurance eligibility reporting

subsystems.

Set up AS400 as backup for Payroll system and programmed the continuous

migration of payroll data from S/38 to AS400. Also setup to be a test

system for payroll program changes.

Neil Olenick ****.*******@*******.***

Developed and programmed an Executive Support system which gathered daily

information on a system/38 and sent this information to an AS400 where

files were updated and accessed via inquiry displays.

EDUCATION

Peirce Jr. College

Associate in Computer Science

Penn State University

B.B.A. - Business Administration

PROFESSIONAL

EDUCATION IBM Inc. - System/38, OS/400.

HARDWARE IBM S/38, AS/400.

SOFTWARE CLP, CLLE, RPG III, RPG/400, RPGIV, RPGILE with embedded

SQL COBOL & COBOL/400, COBOL ILE with embedded SQL, SQL, QMQuery, Query for

AS400, Oracle PL/SQL, SQL Stored Procedures/Triggers, Oracle SQL Developer,

Integral Systems Human Resource/Payroll Package, PERVASIVE Integrator (data

integration and conversion tool), MKS Implementer, OS/400, TCP/IP, FTP,

Client Access, AIX, Microsoft Word, Microsoft Excel, Microsoft Project,

Visio, Windows (2000, XP, Vista).

Contact this candidate