Provide database and system support for HR, Benefits and Payroll.

Provide database and system support for HR, Benefits and Payroll.

• Performed all aspects of database development and administration for multiple Oracle 8i, 9i and 10g databases on various platforms including UNIX (Sun Solaris, AIX, HPUX), Windows and Linux platforms• Configured client/server connections• Managed user security through privileges and roles• Created cold, hot and RMAN physical backups as well as logical backups via export and export data pump utilities• Provided remote technical support • Worked in conjunction with offshore resources to provide 24 x 7 “follow the sun support”• Patched and upgraded Oracle software on UNIX and Windows platforms• Utilized Oracle Enterprise Manger, Grid Control and DB Control• Developed and maintained complex SQL & PL/SQL scripts • Developed and maintained Windows and UNIX shell scripts• Performed SQL and Database Tuning• Performed resource and capacity planning • Developed disaster recovery plans and participated in disaster recovery activities• Participated in the development of corporate SQL standards• Developed detailed documentation using Microsoft Office Word, Excel and PowerPoint• Provided all levels of support to end user communities

Accomplishments• Performed all aspects of database development and administration for ADP HRizon 7.3.4, 8.0.5, 8.0.6 Oracle databases on the Windows NT platform• Performed all aspects of database development and administration for JDEdwardsOneWorld Oracle 8i databases on the HP/UX platform • Installed and upgraded Oracle software on Windows and HP UNIX platforms • Installed and configured Oracle client software on end user workstations • Established and maintained high availability replicated database environments via Quest SharePlex software• Designed and created new databases for various projects on both the Windows and UNIX platforms• Served as system administrator for ADP HRizon application (third party vendor software)• Served as lead technical support contact for the in house ADP HRizon end user community • Designed and developed seamlessly integrated customized components to the HRizon application using HRizoncode, HRizon Tools, HRizon Process Scheduler, PL/SQL, ReportSmith report writer and SQR (Structured Query Report writer)• Administered ReportSmith report writer tool • Configured ODBC, SQL Net and Net8 connectivity to Oracle databases • Served as lead tech in legacy HR and Payroll system conversion project • Designed and developed SQL scripts, PL/SQL scripts, SQR programs, DOS batch scripts and UNIX shell scripts• Created test plans and test scripts• Conducted and participated in change management procedures, including quality assurance walkthroughs and reviews• Developed detailed system documentation using Microsoft Office Word, Excel and PowerPoint• Developed detailed project plans using Microsoft Project Plan• Created data models / entity relationship diagrams using ERwin

• Provided primary technical support of McCormack & Dodge (later Dunn & Bradstreet) Accounts Payable, General Ledger and Millennium applications• Supported GEAC legacy Payroll system• Designed, tested, implemented and supported, in both the VM and MVS environments, financial applications developed using Information Builders’ FOCUS 4th generation language• Designed and developed mainframe legacy system programs written in COBOL and COBOL II