Dba / Peoplesoft Admin And Technical Lead Resume
Experience
Confidential NOVEMBER 2007 THRU PRESENT
DBA / PeopleSoft Admin and Technical Lead.
Responsibilities as DBA / PSAdmin include Production and Development supporting the PeopleSoft 8.9 implementation of T&E, AP, AR, GL, HCM, and SCM. More specifically Performance and Test Analysis of 12 Modules scripting and implementing LoadRunner Via VUGen and HP’s Performance Center; Backup / Recovery / Disaster Recovery, Conversions, Interfaces, General tasks: Design, Volume and Sizing, troubleshooting, tuning, DDL/DML, GRID/OEM, Backup / Restore, Scripting, Development, and Mentoring.
Supporting Software: Oracle 10, SQL Server, HPUX, NT, W2000, Manage Now, Oracle OEM, DataGuard, Additional support of Quest Products, ImageNow, Application Service, Process Scheduler, OAS Web Service, and Report Distribution.
Confidential JULY 2007 THRU NOVEMBER 2007
PeopleSoft Admin / DBA and Technical Lead.
Responsible for providing DBA support of Siebel, Informatica ETL, OBIE, DataMart, Teradata, COSTIMATER, CLExpressway, WebLogic. General tasks Design, Volume and Sizing, troubleshooting, tuning, DDL/DML, Backup / Restore, Scripting, Development, Mentoring. Supporting Software: Oracle 8, 9 and 10, SQL Server, HPUX and Solaris, NT, W2000, Remedy, ITG, Symantec I3 / oracle GRID.
Confidential APRIL 2007 THRU JULY 2007
PeopleSoft DBA and Technical Lead, and PeopleSoft Admin and trainer for a project staffing 17 people.
Responsibilities include Patch Level support, troubleshooting, System and Database tuning, daily migration and service requests, security, applications support for SQR, App Engine, Crystal, Web Service, Application Service, Process Scheduler, Unix, Shell Scripting / BatFiles, Sybase and Sybase Interface,…liaison w Oracle / PeopleSoft / developers. In a sense, responsible for all technical aspects of this project; including mentoring of staff. Platforms are: AIX 4.3, 5.2, PeopleTools 8.9, 8.18, 845, Oracle 9i, 10g, Apps: PeopleSoft Payroll, AP/AR, HRMS, Benefits, Weblogic 8.1.
Confidential SEPTEMBER 2006 THRU APRIL 2007
Lead DBA and Technical Lead, and PeopleSoft Admin for a project staffing 20 people. Supporting a global in-sourcing implementation of PeopleSoft and ACTA and Business Objects for Accenture. Platforms are Unix 5.2, PeopleTools83, Oracle 9I, PeopleSoft Payroll, HR, FLS and related interfaces and applications. Day to day responsibilities include Database installs, upgrades, patches and packages. Application troubleshooting, performance tuning. PeopleSoft install, maintenance, debugging, tracing. Further responsibilities include mentoring staff members on various aspects of the project.
Confidential AUGUST 2006 THRU OCTOBER 2006
Technical Lead, mentor for a project staffing 40 people, supporting an implementation of PeopleSoft HCM 8.9, Tools 8.43, Financials 8.4.
Responsibilities include, PeopleSoft DBA, Systems Admin work, Performance Tuning, Troubleshooting, implementation of a sophisticated monitoring system for purposes of monitoring the Process(and Master) Scheduling, Application Services, Web Services under the PIA Architecture.
Confidential JANUARY 2006 THRU JUNE 2006
Technical Lead supporting an implementation of PeopleSoft HCM 8.9, Tools 8.47.05.
Responsibilities include managing the Project Plan, Bundles and Updates (with Change Assistant), Conversion from FOCUS/DB2 to PeopleSoft, Object/Data Migration, PeopleSoft DBA, support for 10G/8.47 upgrade, interface between SEARCH and PeopleSoft’s Candidate Gateway.
Confidential JUNE 2005 THRU DECEMBER 2006
Technical Lead managing a team of 20, and an Off-Shore Infrastructure Team.
Implementing PeopleTools 8.44, HRMS, Payroll, GL, numerous Interfaces, PGP
Encryption Sub-System. All aspects Including infrastructure, database, applications,
Migrations change control), operations and client relations. Further responsibilities
Managing the plan, issues log, interfaces log, steering committee interface, budgets, client relations and numerous client’s vendor relationships.
Implemented the PGP Encryption Scheme and Subsystem for all vendor interfaces.
Confidential AUGUST 2004 THRU JUNE 2005
Various Systems Admin / DBA / Architecture support rolls: Supporting Tuxedo 6.5/ PeopleSoft Tools 8.43, Upgrades, patches, etc…
Taught PeopleSoft 8.4 Administration and Migration in formulation of a working environment for developers and Systems Administrators and DBA’s at DCS.
Built PeopleSoft 8[.n] Systems Administration tools to manage the daily operations of this PeopleSoft 8 / Oracle 9.2 Shop including the auto-notification and auto-response and booting Subsystems (IE PUBSUB Services and Ap-Messaging). Further Operations Tools to manage all aspects of App-Services, Process Scheduling Services and Web Services.
Confidential OCTOBER 2003 THRU AUGUST 2004
Functioned as the DBA / UNIX Systems Admin for the development team.
Rolled out PeopleTools 8.4, Application: Financials / Payables upgrading from PeopleTools 7.5.3 under Solaris / Oracle 9 with Upgrade Assistant.
Confidential APRIL 2001 THRU AUGUST 2004
Systems Architect and overall Project Manager.
Managed the Project Plan and Budget, staffing and interface to the client’s staff for this project. Rolled out PeopleTools 8.1.3 HRMS, Benefits, Ceridian Payroll Interface, GL/ AR/ AP / Bi for this major pharmaceuticals marketing company. Main responsibilities are Infrastructure, and application advisory. Also Mr. Pack has upgraded PeopleTools 8.1.3 -> 8.1.6, and AP SP1 -> SP2, Oracle 8.1.7.0 -> 8.1.7.2, 8i for the same client. Worked with EPM for long term repository as well; for warehousing data for long term; and further disaster recovery planning as well.
Note: This project at PDI is cited on PeopleSoft.Com as the first client to go live with PeopleTools 8. I was credited as the Systems Architect of this project.
Confidential March 2002 thru May 2002
Perform and managed the process of validating and proving all aspects of a PeopleTools 8.1.7 HRMS, Benefits, Payroll, ESS / MSSl installation using Mercury Tools (LoadRunner, Controller, Director …). 72,000 employees, continental access. This effort included managing the input of the client’s different departments.
Confidential JANUARY 2001 THRU DECEMBER 2001
Provided upgrade support PeopleTools from 7.5 to 8.0, and Applications, SQLServer, Tuxedo, NetExpress Cobol, for support of GL, AR, AP, Billing and Asset Management.
Responsibilities include the Fit Gap Analysis, sizing, installations, procurement, upgrading and comparing, customizations, troubleshooting and user training.
Confidential JANUARY 2001 THRU JUNE 2001
Management and implementation of Oracle Apps, Order Entry / Financials System (GL, A/P, A/R) for processing orders received from a Web Partner, manufacturing, invoicing, accounting and reporting. Support and write PL/SQL, handlers and real time implementation. Responsibility included managing the development effort and Project Plan for a group of 5. Responsible budget planning, IT Auditing, Staffing, Requirements Review, Fit/Gap Analysis, as well as DBA, and UNIX Systems Admin functions.
Confidential JANUARY 1999 THRU NOVEMBER 2001
Implemented a global rollout of PeopleSoft 7.5 HR, Benefits, Payroll, Compensation, Pension, General Ledger, Financials with related interfaces. Functioned as the Architectural Systems Manager, with extensive hands on resolving all technical issues, managing the Project Plan, budget, vendors, and technical direction of this project, responsibility for all deliverables. Responsible for 8 people, reporting directly as well as 20 people indirectly supporting this project. Data warehoused beyond 6 terabytes. Developer staff was 65 people.
Confidential AUGUST 1998 THRU DECEMBER 1998
Implemented a global rollout of PeopleSoft 7.0 HR/Benefits/Payroll/Pension.
Functioned as the Applications Manager, with extensive hands on, resolving all technical issues, managing the Project Plan, vendors, and responsibility for all deliverables.
Responsible for 25 people reporting directly as well as 70 developers indirectly supporting this project.
Confidential MARCH 1997 THRU JULY 1998
Implemented a global rollout of PeopleSoft 7.0 HR/Benefits/Payroll/Compensation and related interfaces as well as implementing a global compensation system utilizing feeds from the PeopleSoft Data. Mr. Pack has upgraded and installed. PeopleSoft Release 7.0 at the UBS and ISO in the past few months as well. Further responsibilities included the management of the infrastructure staff and the off-shore team and the project plan for this effort.
Confidential NOVEMBER 1996 THRU FEBRUARY 1997
Technical and Infrastructure Lead, 22 people, for an implementation of PeopleSoft 7 Financials, AP, AR, Billing, Project Costing under NT 4.0, SQLBase, and PeopleTools 7.0.
Confidential FEBRUARY 1996 THRU OCTOBER 1996
. Internal consultant for PeopleSoft 6 Financials and related projects. ISO used Solaris, Sybase 11, PeopleTools 6, Financials, AR. AP, and General Ledger.
IBM/ISSC, (AUGUST 1994 THRU SEPTEMBER 1996)
Internal Systems Architect for IBM’s Professional Services (and Global Services):
. AES CAD for purposes of managing Facilities Engineering for multiple sites.
Responsibilities included design, implementation and rollout of product to all sites of this company.
- Design, implementation of an Essbase Financial Planning System. Users are worldwide; including the CEO. (Project is APEX)
- Project technical lead and training programmers in advanced development techniques using AIX. This effort involved training a staff of 31 to support the Enterprise Production Planning System, for the Corporate Logistics and Manufacturing of IBM. Mr. Pack managed 8 AIX Systems Admins and DB2 DBAs. Managed the Project Plan and Technical direction for this effort.
- Provided support and troubleshooting on various projects for IBM’s PeopleSoft / RedPepper consulting practice.
Confidential MAY 1992 THRU AUGUST 1994
Application Designer for an implementation of PeopleSoft 5 Benefits for Human Resources Batch processes:
- Open enrollment
- Payroll
- Benefits administrator
- DedCalc/Conf.
- Process Scheduler
Responsibilities include infrastructural support of programmers and staff for implementing, optimizing and resolving technical issues. As Security Administrator wrote a monitoring program for purposes of protecting the Data Server and confidential data.
This monitor program was challenged by the Security Group but never penetrated.
HeartBeat” remains unbroken and in force today. PeopleTools 3.23, Benefits 4.1, 5.1, SQR v2.5.7, Oracle 7.2.
Responsible for managing and training existing staff in installations, upgrades, programming, release control management, object migrations, Make facility/SCCS, troubleshooting techniques as it relates to PeopleSoft.
EDUCATION:
Computer Science, Physics, Mathematics and Engineering
Business and Marketing
TECHNICAL SKILLS:
Hardware:
Sun, RS/6000, HP 9000/3000, PS2, RT, VAX, MAC, NeXT, IBM 370, VAX, MicroVAX, PDP, Prime, Series I, Rockwell, Cannon, Intel, NorthStar, MAC, Altos, Pitney Bowes
Software:
PeopleSoftTools8/7/6/5/3/2,UpgradeAssistant, ChangeAssistant, VUGen, HP’s Performance Center, DataGuard,HR,Benefits,Payroll,GL,AR,AP,Billing,AssetMgmt,Project Costing, EPM, Quest Performance Analyzer, Spotlight, OEM, Grid, Oracle 10g, Oracle (9.2), Oracle(8i), Oracle Order Entry / Financials, SQR, Sybase, TSQL, C, Unix, DB2, PGP, Mercury(LoadRunner/Controller/Director), IMS, APT, Access, Open Server, DB-Lib/NETLIB, SQL Base, SQL*Server, TCP/IP, PowerBuilder
Operating Systems:
UNIX, AIX, HP-UX, NT, SCO, NeXT, Ultrix, VMS, RSX, OS2, MVS/TSO, VM/CMS/CP, MPE, RJE/NRJE, Primos, GCOS/GMAP, 8080, 6502, MS DOS, Wylbur/Orville, Callos, CP/M, MP/M, Novell
Programming:
PeopleSoft:2/3/5/6/7/8, PeopleSoft PGP, Oracle/API, Sybase/API, FOCUS, Ceridian Payroll Interface, GL/ AR/ AP / Bi, AIX/VS, C, Apt, TSQL, SQR, Access/ODBC, DB2/API, Crystal, AllBase/API, Make, SCCS, FTP, KSH, CSH, BSH, SH, TCP/IP (RPC, IPC), DCL, JCL, OCL, DECnet, Cobol, PL/1, 8080, 6502, BAL, EIS, Basic, Pascal, Fortran, Cobol, MSO