Senior Consultant
John
Avia
Contents
Experience
3/2008– Present Senior PeopleSoft Administrator
Piedmont Natural Gas Co.,
Applied Tax updates
Worked on Chart of Accounts Restructuring Project
Retrofitted SQRs and Online objects for new Chart of Accounts
1/2008– Present Senior PeopleSoft Administrator/DBA
IBM Applications on Demand
PeopleSoft System Administration
Performed upgrades on Campus Solutions, Enterprise Portal, Financials and HCM from 8.x to PeopleSoft Version 9.0
Setup Integration Broker in PeopleSoft Version 9.0
Maintained Databases for PeopleSoft using Oracle and Microsoft SQL Server
Built new App Servers, Web Servers and Process Schedulers
Applied Release Bundles for PeopleSoft Version 9.0
11/2003 – 1/2008 Senior PeopleSoft Administrator/DBA
Cox Enterprises,
PeopleSoft System and Oracle Database Administrator
Kronos System Administrator.
Applied Kronos and PeopleSoft patches, bundles and tax updates.
Wrote Kronos to PeopleSoft Time and Attendance interfaces for approximately 35,000 employees.
Tuned the Kronos and PeopleSoft database environments.
Tuned and maintained Kronos Connect links.
Wrote and modified Kronos and PeopleSoft Crystal reports.
Upgraded PeopleSoft system from 8.3 to 8.9.
Developed SQRs, Applications Engines, PeopleCode events, HTML, SQL Scripts,
10/2002 - 11/1/2003 Senior PeopleSoft Consultant
Piedmont Natural Gas Co.,
PeopleSoft Administrator and Developer
Participated on the team that upgraded the PeopleSoft system from 7.5x to 8.8.
Tuned SQR, SQL, Queries and COBOL modules.
Troubleshooter for issues that occurred during the upgrade.
Successfully modified COBOL Retroactive Pay COBOL program.
Rewrote the Payroll to General Ledger Module.
8/2000 - 10/2002 Senior PeopleSoft Consultant
Cox Enterprises,
PeopleSoft System and Oracle Administrator
- Installed PeopleSoft Version 8.3 eRecruit System.
- Installed Mohomine Resume processing, Verity Search software.
- Tuned WebLogic Web Server.
- Tuned Tuxedo Application Server
- Tuned Oracle Database
- Wrote Application Engine programs
Technical team Lead on a project to replace a legacy Payroll data warehouse with a Custom PeopleSoft data repository using state of the art design techniques.
- Lead Joint Application Design sessions.
- Wrote technical program specifications
- Designed a methodology using Oracle utilities to load over 20 million records on a weekly basis.
- Used my DBA skills to tune the online and batch processes.
PeopleSoft HRMS Benefits Administration / Open Enrollment technical specifications and interface development.
PeopleSoft Version 8 experience.
- Part of a team installing PeopleSoft e-Recruit module.
- Technical lead on the team assigned to perform the PeopleSoft upgrade to Version 8.x.
Developed numerous
Provided technical support for the PeopleSoft Financial Applications.
Authored a Payroll system feasibility study.
Wrote numerous SQR processes to realign the Payroll setup data relating to COX employees.
8/2000 - 12/31/2000 Senior PeopleSoft Consultant
The City of
PeopleSoft System administration, performance tuning and troubleshooting.
- Applied PeopleTools application fixes.
- Applied PeopleSoft tax updates.
- Wrote Program technical specifications and developed the corresponding SQRs.
9/1998 - 07/2000 Senior PeopleSoft System Administrator
Piedmont Natural Gas Co.,
Lead a team that installed PeopleSoft HRMS and Financials version 7.0 and used PeopleSoft's methodology to upgrade to version 7.5. I also assisted with the parallel project to upgrade the Oracle DBMS to 8.0.6.
Installed and tuned PeopleSoft's web-enabled self-service applications. This task included installing a web server, BEA system's Jolt internet relay and a Jolt listener.
Installed various PeopleTools and Application releases including 7.03, 7.57 and 7.01.
Worked extensively tuning the whole PeopleSoft environment. This includes Oracle system tuning, SQL tuning, Tuxedo tuning, UNIX tuning, COBOL and SQR batch tuning, n/Vision tuning, Crystal tuning, PS/Query tuning and workstation tuning. Also wrote Oracle scripts to aid in this process.
Wrote SQR conversion programs to load legacy data into PeopleSoft delivered
tables. Customized PeopleCode to create
enhanced paysheet security.
Helped author, test and implement a PeopleSoft disaster recovery plan.
Screened and interviewed potential employees.
Trained employees on best practices to administer PeopleSoft system.
6/1995-9/1998 Senior PeopleSoft System Administrator
Public Service Company of NC,
Installed version 5 of the HRMS module
Led Fit/Gap analysis for benefits and payroll modules
Managed full upgrade to version 6 of the HRMS module
Wrote conversion SQRs and Import scripts for
implementation of
HRMS module
Assisted with setting up payroll, benefits and HR system setup
tables
Wrote PS/Queries to assist HR and Payroll department
Used Oracle utilities to load conversion data
Applied 1997 and 1998 tax updates to payroll module
Wrote paysheet update interface into payroll module
Installed PeopleSoft Financials AM, GL, PC and BD version 7.5
Setup PeopleSoft security using delivered security tools
Setup Payroll W2 process to fit client needs
Converted PeopleSoft system from using SQLBASE to Oracle DBMS
Setup Paycheck printing process to meet client needs
Tuned SQL, COBOL and online system performance
Installed Platinum plan analyzer to assist with performance tuning
Created and tested a PeopleSoft disaster recovery plan
Modified several panels and peoplecode events to meet
client requirements
Created application engine modules to perform several database
purge functions
Installed Crystal reports for end user reporting
Installed process scheduler, Tuxedo and Citrix clients
Installed Microfocus COBOL compiler for Windows/NT
Trained end users to use the Payroll and Benefits modules
3/1995-6/1995 Senior Database Administrator
National Council on Compensation Insurance
Tuned DB2 and Oracle SQL statements
Performed DBMS system tuning
Performed database re-orgs
Created a backup recovery plan and implemented the plan
6/1993-3/1995 PeopleSoft System and Database Administrator
Blue Cross and Blue Shield of TN,
Install PeopleSoft GL Version 3 using DB2
Used import utility to load conversion data into PeopleSoft system
Participated in Fit/Gap analysis
Tuned PeopleSoft Gupta gateway
Tuned PeopleSoft GL batch and online processes
Wrote SQRs to report Financial information
Setup process scheduler to run on IBM mainframe
Corrected several Peoplecode errors delivered with
module
Tuned nVision reports
Customized DB2 indexes to enhance online performance
Applied patches to PeopleSoft system
Used Platinum RC/Migrator to migrate relational
tables betweeen systems
Sized PeopleSoft tables and tablespaces to meet
future growth requirements
Wrote JCl to run stand-alone batch COBOL and SQRs
Compiled PeopleSoft COBOL modules on the mainframe
5/1989-6/1993 Programmer/Analyst and Database Administrator
GEICO Insurance Company,
Installed MicroFocus COBOL compiler
Designed and implemented IMS and DB2 databases
Tuned DB2 and IMS system software
Maintained CICS application systems
Used BMC and Platinum Database tools to maintain databases
Installed and Supported Xpediter batch COBOL debugger
Installed and supported DB2/2 and XDB DBMSs
Performed evaluation of PeopleSoft HRMS software
Hardware
- HP/9000 K460 and K260 Servers
- Data General Aviion Servers
- Compaq 6000 Servers
- IBM 3090 mainframes
- Compaq, Dell, IBM and Gateway/2000 Personal Computers
Back to Top
Software
PeopleTools, PeopleCode,
SQR, SQL*Plus, Platinum plan analyzer, Crystal, N/Vision, Excel, Microsoft
Word, Lotus Notes, Crystal, Oracle’s SQL-loader, export, and import, JCL, VSAM,
DB2, IMS, Ultra-edit, Q-database monitor,
Tuxedo, MicroFocus COBOL, Expediter, PVCS,
Glance-plus, Maestro for UNIX, Exceed and FTP for UNIX, Microsoft Internet
Explorer, QMF, Tmon for DB2 and MVS, BMC reorg plus utilities
Back to Top
Education
1985–1989 Bloomsburg University
B.S., Computer Science.
Back to Top
Contact Information
Electronic mail address
JohnAvia@johnavia.com
Web address
http://JohnAvia.com
Office phone
704-651-0190
Home phone
704-651-0190
Back to Top
Tell me what you think about the web site