TECHNICAL SKILLS:

PeopleSoft Campus Solutions, Portal, HCM, Financials, EPM, PeopleTools, Integration Broker, Crystal, SQR, nVision, Informatica ETL, Hyperion Essbase OLAP, EIS and Analyzer, Quest STAT, Netezza Performance Server, IBM DB2, Oracle RDBMS, Microsoft SQL Server, Sybase, C++, C, UNIX, Microsoft Windows, DOS

EXPERIENCE:

Bethpage, NY, USA

PeopleSoft Consultant 

Responsibilities:

• PeopleSoft HCM 9.2
• Upgrade of PeopleSoft HCM from 9.1 to 9.2 (image 21)
• Customized Employee and Manager Self Service transactions, Payroll and Time and Labor modules using PeopleTools 8.55Fluid pages and components.
• Development and customization of PeopleTools modules - Query, Crystal Reports, Application Packages, Workflow, Data Mover, Application Engine, SQR, PeopleCode, Component Interfaces, Integration Broker, and XML Publisher modules.
• Customized PeopleSoft HCM 9.2 Company Directory modules

PeopleSoft Interaction Hub Consultant

• PeopleSoft Interaction Hub 9.1, HCM 9.2, Financials/SCM 9.2
• Upgrade of PeopleSoft HCM from 9.1 to 9.2 (image 17)
• Use of PeopleTools Change Assistant in the upgrade of PeopleTools to version 8.55 and HCM to version 9.2
• Executed, debugged and tuned upgrade and data conversion Data Mover, SQL and Application Engine programs.
• Applied updates and patches using the PeopleSoft Update Manager in version 9.2
• Ran and analyzed multiple SYSAUDIT, DDDAUDIT, ALTER AUDIT and upgrade comparison reports and implemented corrections suggested by the reports.
• Upgraded multiple HCM environments, QA and troubleshooting.
• Installation, configuration, troubleshooting, and performance tuning of PeopleSoft HCM search using Oracle Secure Enterprise Search
• Development and customization of PeopleTools modules and interfaces - Query, Crystal Reports, Application Packages, Workflow, Data Mover, Application Engine, SQR, PeopleCode, Component Interfaces, Integration Broker, and BI Publisher modules.
• Implementation and configuration of a PeopleSoft Interaction Hub system to provide integrated access to PeopleSoft HCM, PeopleSoft Financials/SCM, and legacy non PeopleSoft systems utilizing PeopleTools 8.55 fluid UI and integrated reporting to support desktops and remote mobile devices.
• Configuration and setup of Time and Labor and integration with Absence Management, GL, Procure to Pay (PTP), Payroll, Talent Acquisition Manager (TAM) and Candidate Gateway
• Customized Time and Labor, Absence Management, GL, Payroll, Talent Acquisition Manager (TAM) and Candidate Gateway for integration with RSS feeds from job bulletin boards using XML documents and Integration Broker.

  PeopleSoft Interaction Hub Consultant 

• PeopleSoft Interaction Hub 9.1, Campus Solutions 9.0, HCM 9.2, Financials/SCM 9.2, Enterprise Learning Management 9.2, HCM Hybrid Cloud
• Design and development of a customized PeopleSoft Interaction Hub solution with client specific branding to provide integrated access to PeopleSoft HCM, CS, ELM and Financials environments.
• Implementation of a jQuery based accordion navigation collection, and jQuery colorbox based modal window to transact with CS, HCM, ELM and Financial source systems.
• Developed and customized multiple ELM, TAM, Candidate Gateway and CS pagelets including a customized version of the CS Student Center.
• Modified existing HTML templates to display an accordion menu, and context sensitive help on the same page along with transaction data from CS, HCM, ELM and Financials source systems. The accordion navigation menu, transaction iframe and help iframe could be individually minimized.
• Integrated the Favorites menu with the accordion menu.
• Customized the branding header to display dynamic data.
• Integration with Google Analytics.
• Migration of select HCM data to a public HCM cloud and integration with the onsite HCM modules.
• Troubleshoot issues.
• Analysis of integration with SAML.

PeopleSoft Interaction Hub Consultant 

• PeopleSoft Interaction Hub 9.1, HCM 9.2, Financials/SCM 9.2, Enterprise Learning Management 9.2
• Design and development of a customized PeopleSoft Interaction Hub solution with client specific branding to provide integrated access to PeopleSoft HCM, Financials and ELM environments including Payroll, Time and Labor, Talent Acquisition Manager (TAM) and Candidate Gateway, Person Profile, Self Service, GL, AP/AR, PO and Billing modules, and ELM enterprise pagelets
• Modified existing HTML templates to display a Quick Links menu on the same page along with transaction data from HCM, Financials and ELM source systems. The Quick Links menu and transaction iframe could be individually minimized.

PeopleSoft Developer/Analyst 

• PeopleSoft Interaction Hub 9.1, Campus Solutions 9.0, HCM 9.2, and ELM 9.1
• Upgrade of PeopleSoft HCM from 9.1 to 9.2.
• Use of PeopleTools Change Assistant in the upgrade of PeopleTools to version 8.53 and HCM to version 9.2
• Executed, debugged and tuned upgrade and data conversion Data Mover, SQL and Application Engine programs.
• Ran and analyzed multiple SYSAUDIT, DDDAUDIT, ALTER AUDIT and upgrade comparison reports and implemented corrections suggested by the reports.
• Upgraded multiple HCM environments, QA and troubleshooting.
• Development and customization of PeopleTools modules - Query, Crystal Reports, Application Packages, Workflow, Data Mover, Application Engine, SQR, PeopleCode, Component Interfaces, Integration Broker, and XML Publisher modules.
• Interaction Hub branding, security customization and custom Interaction Hub development.
• Development and customization of PeopleTools, Application Engine, SQR, PeopleCode, Component Interfaces, Integration Broker, and XML Publisher modules.
• Troubleshooting of Interaction Hub, Campus Solutions and HR processes and PeopleSoft Process Scheduler.
• Integration and customization of ELM pagelets and display them on the Interaction Hub
• Configuration and setup of Talent Acquisition Manager (TAM) and Candidate Gateway
• Customized Talent Acquisition Manager (TAM) and Candidate Gateway for integration with RSS feeds from SEEK systems using XML documents and Integration Broker

Jacksonville, Florida, USA

PeopleSoft Consultant

• PeopleSoft HCM 9.1/9.0, Interaction Hub 9.0, Enterprise Learning Management 9.1
• Implementation of ePay, eCompensation , eRecruit, ePerformance, Talent Acquisition Manager (TAM), Candidate Gateway and Call Center modules
• Interaction Hub branding, security customization and custom Interaction Hub development to integrate delivered and customized ELM pagelets.
• Automation of HCM Payroll processes using MVS OS390 PeopleSoft Process Scheduler.
• Customized delivered Application Engine, SQR, Crystal and XML Publisher modules to handle Payroll, Pay Cycle, General Deductions, W2 and 1099 withholding on a DB2 environment.
• Worked extensively on PeopleSoft batch processes running on MVS OS390 platform.
• Worked extensively with Quest STAT version 5 for PeopleSoft objects change management
• Worked extensively with MVS OS390 change man packages for change management in the mainframe environment.

Virginia, USA

PeopleSoft Consultant/Technical Lead

• PeopleSoft HCM 9.1/9.0, Interaction Hub 9.0, ELM 9.0
• Upgraded PeopleSoft HCM from version 9.0 to 9.1 along with data conversion from 9.0 to 9.1
• Upgraded PeopleTools from version 8.49 to 8.51
• Use of PeopleTools Change Assistant in the upgrade of PeopleTools to version 8.51 and HCM to version 9.1
• Executed, debugged and tuned upgrade and data conversion Data Mover, SQL and Application Engine programs.
• Ran and analyzed multiple SYSAUDIT, DDDAUDIT, ALTER AUDIT and upgrade comparison reports and implemented corrections suggested by the reports.
• Upgraded multiple HCM environments, QA and troubleshooting.
• Implementation of ePay and eCompensation modules
• Interaction Hub branding, security customization and custom Interaction Hub development to integrate delivered and customized ELM pagelets.
• Automation of HCM Payroll processes for more than 50 subsidiaries using Cisco Tidal Enterprise Scheduler version 6.x.
• Configuration and setup of Talent Acquisition Manager (TAM) and Candidate Gateway
• Customized Talent Acquisition Manager (TAM) and Candidate Gateway for integration with RSS feeds from Dice systems using XML documents and Integration Broker
• Designed and implemented a unique approach to standardizing Payroll batch steps using a standard and dynamically configurable Tidal job group with job steps that could be dynamically enabled and disabled based on a subsidiary’s business requirements
• Developed multiple Application Engine modules to import and export data extracts using File Layouts for transmission to and from thirty party vendors. Also converted data from and to PeopleSoft proprietary and customized formats
• Customized delivered Application Engine, SQR, Crystal and XML Publisher modules to handle Pay Cycle, General Deductions, W2 and 1099 withholding, ProBiz and ADP.

Charlotte, North Carolina, USA

PeopleSoft Consultant/Technical Lead

• PeopleSoft Interaction Hub 9.0, EPM 9.0, Financials 9.0
• ETL of TWC’s customer transactional data from multiple source systems into a PeopleSoft EPM implementation using Ascential Datastage.
• Interaction Hub branding, security customization and custom Interaction Hub development.
• Construction of data marts and implementation of OLAP models using Microstrategy BI version 8.
• Design, development and implementation of multiple extracts from PeopleSoft EPM, and Financials (GL, AP, AR) data warehouses running on Netezza TwinFin Performance Server engines to feed them to external vendor applications running on SalesForce.com. Converted data from PeopleSoft and customized formats to third party formats
• Scheduled IDL and incremental extracts using Cisco Tidal 5.2. Created job groups, jobs, events, and alarm points along with multiple calendars for automated execution of extracts. Migrated job groups across environments.
• Upgraded PeopleSoft Financials from version 8.8 to 8.9 and to 9.0 along with data conversion from 8.8 to 9.0
• Upgraded PeopleSoft CRM from version 8.8 to 8.9 and to 9.0 along with data conversion from 8.8 to 9.0
• Upgraded PeopleTools from version 8.42 to 8.44 to 8.45 to 8.46 to 8.49 and to 8.50

Bethesda, Maryland, USA

PeopleSoft Consultant

• PeopleSoft Financials 8.9, HCM 9.0, Interaction Hub 9.0
• Implementation of a customized PeopleSoft data warehouse using PeopleSoft Financials Project Costing and PeopleSoft HRMS Time & Labor data into a Netezza Performance Server engine. Data Modeling of PeopleSoft Data Marts, and ETL design and development
• Interaction Hub branding, security customization and custom Interaction Hub development.
• Analysis of PeopleSoft HRMS and Financials Menus, Components, Pages and PeopleCode for modeling PeopleSoft data marts
• Responsible for the development of custom Menus, Components, Application Engine, SQRs, PeopleCode to extract transactional data. Development of multiple Informatica ETL transformations, maps, sessions and jobs for extracting and converting transactional data from source PeopleSoft HRMS systems.
• Upgraded PeopleSoft Financials from version 8.8 to 8.9 along with data conversion from 8.8 to 8.9
• Upgraded PeopleSoft HCM from version 8.8 to 8.9 and to 9.0 along with data conversion from 8.8 to 9.0
• Upgraded PeopleTools from version 8.42 to 8.44 to 8.45 to 8.46 to 8.49 and to 8.50
• Use of PeopleTools Change Assistant in the upgrade of PeopleTools to version 8.50 and HCM to version 9.0
• Executed, debugged and tuned upgrade and data conversion Data Mover, SQL and Application Engine programs.
• Ran and analyzed multiple SYSAUDIT, DDDAUDIT, ALTER AUDIT and upgrade comparison reports and implemented corrections suggested by the reports.

Washington DC, USA

PeopleSoft Consultant

• PeopleSoft Enterprise Portal 8.8, HCM 8.8
• Implementation of a customized PeopleSoft Portal system to provide integrated access using Integration Broker and Application Messaging to PeopleSoft HCM Time & Labor, HR, Benefits, eBenefits , eRecruit , Payroll, Payroll Interface, eModules , eManager Desktop , and legacy non PeopleSoft systems with a unique look and feel that is radically different from the traditional PeopleSoft interface
• Customization of the internals of PeopleSoft Portal and PeopleSoft Time & Labor to deliver a custom look and feel to access PeopleSoft T&L configuration and security setups. Integration of LDAP security.
• Configuration of PeopleSoft HCM Time & Labor, workgroups, time reporting codes, work schedules, static and dynamic groups, and T&L security, and integration with Employee and Manager Self Service
• Developed automated functional and system performance test scripts utilizing Mercury LoadRunner
• Upgrade of PeopleSoft 8.4 Portal and 8.4 HRMS to version 8.8 Portal and HCM respectively along with data conversion of HRMS data from 8.4 to 8.8.
• Use of PeopleTools Change Assistant in the upgrade of PeopleTools and HCM
• Executed, debugged and tuned upgrade and data conversion Data Mover, SQL and Application Engine programs.
• Ran and analyzed multiple SYSAUDIT, DDDAUDIT, ALTER AUDIT and upgrade comparison reports and implemented corrections suggested by the reports.

New York, New York, USA

PeopleSoft Consultant

• PeopleSoft Financials version 8.4 and 8.8.
• Upgrade PeopleSoft Financials from 8.4 to 8.8 along with data conversion from 8.4 to 8.8. Troubleshoot issues with configuration and customizations throughout financial database. Worked with security teams on design of operator and row level security for financials. Designed and developed queries, crystals and nvision reports. Designed and developed peopletools customizations and enhancements
• Provided production support for AP, AR and GL.

Bethesda, Maryland, USA

PeopleSoft Consultant

• PeopleSoft EPM (Financials) version 8.8
• Implementation of PeopleSoft Enterprise Performance Management data warehouse for strategic assessment and to enable client to measure financial performance of its products and operations as well as to offer its customers advanced reporting capabilities
• Performance tuning of delivered PeopleSoft EPM Application Engine processes.

New York, New York, USA

PeopleSoft Consultant

• PeopleSoft Financials version 8.4
• Responsible for the development and tuning of custom SQRs and PeopleCode.

Mclean, Virginia, USA

PeopleSoft Consultant

• PeopleSoft EPM versions 8 and 8.8, Budgeting (Financials) 8.8
• Upgrade of PeopleSoft 8 Enterprise Performance Management (EPM) 8 SP1 to version 8.8
• Responsible for the development of custom SQRs and PeopleCode. Customization of various PeopleTool objects including, Application Engine, Application Messaging, and the new version 8 role-based security. Integration of LDAP with PeopleSoft single sign-on. Developed automated functional and system performance test scripts utilizing Mercury LoadRunner.
• Development of multiple Informatica ETL transformations, maps, sessions and jobs for extracting transactional data from source PeopleSoft Budgeting systems.

New York, New York, USA

PeopleSoft Consultant

• PeopleSoft EPM version 8.3, HRMS 8.0
• Implementation of PeopleSoft Enterprise Performance Management data warehouse for strategic assessment and to enable client to measure financial performance of its products and operations as well as to offer its customers advanced reporting capabilities including forecasting.
• Responsible for the development of custom SQRs and PeopleCode. Created custom global email distribution system using Application Designer and PeopleCode to disseminate notifications to multiple departments using HRMS organization trees. Customization of various PeopleTool objects including, Application Engine, Application Messaging, and the new version 8 role-based security. Integration of LDAP with PeopleSoft single sign-on. Developed automated functional and system performance test scripts utilizing Mercury LoadRunner.
• Development of multiple Informatica ETL transformations, maps, sessions and jobs for extracting transactional data from source PeopleSoft HRMS systems.
• Development of Hyperion Essbase ROLAP models, meta-outlines, and cubes for multi-dimensional reporting of PeopleSoft EPM data marts
• Implementation and upgrade support for HRMS Payroll, Benefits, and eModules including ePay, eProfile, and eBenefits Online Open Enrollment

Naples, Florida, USA

PeopleSoft Consultant

• PeopleSoft HRMS version 8.0
• Implementation of an Application Messaging based driver to propagate PeopleSoft HRMS transactional data to client’s LDAP based Active Directory engine that facilitates provisioning and de-provisioning of its workforce.

Arlington, Virginia, USA

PeopleSoft Architect/Consultant

• PeopleSoft HRMS versions 7.0, 7.5 and 8.0
• Provided technical expertise in the areas of PeopleSoft HRMS Benefits Administration, Base Benefits and Payroll, Payroll Interface, and the new release 8.0 PeopleSoft Internet Architecture. Designed automated system performance test scripts utilizing Mercury LoadRunner. Prioritized, ranked, and sized test cases. Executed test plans and test.
• Implementation and customization of version 8.0 eRecruit, eProfile, ePay, eCompensation, eDevelopment, Manager’s Desktop, and Payroll Interfaces.
• Upgraded from 7.0 to 7.5 and 7.5 to 8.0. Responsible for data conversion from 7.0 to 8.0 and 7.5 to 8.0 and data mapping, setup of the physical and logical Web, Application, and Database servers and perform functions as HRMS Security Administrator. Interfaced VB web-based systems with PeopleSoft .

Cleveland, Ohio, USA

PeopleSoft Consultant

• PeopleSoft Public Sector Financials versions 7 and 7.5
• Lead Developer for General Ledger and Accounts Payable, assisted with Purchasing implementation. Setup table values, tested and resolved issues. Provided database support for Oracle database server. Corrected existing SQR, Crystal and nVision reports and developed new requests. Trained and provided onsite production support for City staff. Corrected all post production issues.
• Lead role in the upgrade of Public Sector Financials from version 7 to version 7.5 along with data conversion from 7 to 7.5

Washington, DC, USA

PeopleSoft Consultant

• PeopleSoft Federal HRMS version 7.
• Provided post-production design and implementation of security classes and request forms for the Global Employee Management System (GEMS). Corrected production security issues in HRMS. Developed Security panels, menus, views and SQRs. Modified custom records and sub-systems with security views. Recommended and implemented back-end policies and guidelines for development and production environments. Developed client specific documentation for on-going PeopleSoft security maintenance. Provided database administration support and worked in developing upgrade and patching processes.

Falls Church, Virginia, USA

Principal Consultant

• PeopleSoft HRMS and Financials versions 5, 6, and 7
• Coordinated the timely delivery of hardware installations, table setup, and design/development for all phases of PeopleSoft Financials and HRMS implementations at several client sites. Delivered technical design documents within schedule. Designed and developed interfaces and ancillary subsystems. Data mapped legacy data to PeopleSoft for conversions. Worked to retrofit tax upgrades and fixes/enhancements for HRMS. Coordinated training for end-users, production maintenance and cutover methodology.
• Developed SQR, Crystal and nVision reports for Benefits Administration, Payroll, General Ledger, Projects, Accounts Receivable, Accounts Payable, Purchasing, and Billing modules and mentored client organization staff. Design, customization and modification of panels, records, fields, reports and PeopleCode to client specifications using PeopleTools and Application Designer. Responsible for unit and integration testing of new and customized objects. Performed code walkthroughs and code reviews. Performed system testing for delivered PeopleSoft functionality to ensure maintenance updates and version upgrades are loaded successfully and without error.