Technical Architect / Peoplesoft Administrator / Oracle DBA
As the Technical lead / PeopleSoft DBA, completed major upgrade for PeopleSoft Financials from 8.0 to 8.9 (AR, BI, GL, AP, PO, AM, EX, PO, OM).
- Upgraded PeopleSoft HRMS from 8.8 to 8.8SP1 MP4 and applied 2005/2006 Tax Updates. Upgraded PeopleSoft Tools from 8.45 to 8.46 / 8.47 version.
- Configured single signon across all PeopleSoft applications including PORTAL
- Installed and upgraded CRM from 8.0 to 8.9 version on PT 8.46
- Installed and configured PeopleSoft EPM v8.9 applications. Applied MP4 to all EPM environments. Installed and upgraded BAM servers for interactive reporting.
- Install / Configure and implemented PeopleSoft EPM 8.9 with Ascential DataStage (7.5) for on Window and UNIX servers. Loaded and executed all Ascential ETL's for FSCM and HRMS data marts. Customized ETL's as needed.
- Optimized and tuned all PeopleSoft client applications (FIN, CRM, EPM, HRMS and PORTAL).
- Installed and configured Business Objects dimension reporting tool for EPM. Configured Business Objects LDAP.
- Provided support for the existing CRM 8SP1 / HRMS 8.8 and Portal 8.8 applications.
- Customized PeopleSoft objects as necessary using Application Designer, PeopleCode, SQL, etc.
- Managed all technical aspects of the upgrade projects including designing the technical architecture, running the conversion scripts using the change/upgrade assistant, managing all the development activities, performing PeopleTools upgrades, and setting up the Weblogic web application server, PIA, Tuxedo Application Server, and Oracle 9i databases on UNIX platform.