SUMMARY:

• Confidential has been a Functional and/or Techno - Functional Consultant with PeopleSoft HCM.
• Confidential has worked extensively with PeopleSoft HCM leading or as a team member of various implementation projects including the Core HCM modules such as HR, North American Payroll, Benefits, Benefits Administration, eApps, Self Service, Global Payroll, Security Administration, and Enterprise Portal Integrations.
• Confidential has worked for clients in various industries including Public Sector, Law Firm, Finance, Securities Brokerage, Risk Management, Retail, amongst others, on Domestic as well as Global organizations.
• He has performed light System Administration (Project Migrations system maintenance), functions (including DBA) and has exposure to other PeopleSoft modules.
• Confidential started working with PeopleSoft at release 3 and recently completed implementations and support of HCM 8.9, Portal 8.9/9.0, Global Payroll 9.0 and upgrade to HCM 9.1, via 9.0.
• Confidential is an experienced Analyst as well as being proficient with PeopleTools from 3.02 thru 8.5x and satellite tools.
• Confidential ’ experience includes mainframe, mini and microcomputer systems, two-tier and multi-tier; custom online and batch analysis; design and development; implementation and integration of various kinds of systems; conversions; migrations, interfaces in and out with low volume from systems with over 150,000 persons; and major and minor release upgrades.
• Confidential ’ major asset is his ability to analyze the user requirements and delve into any level of detail as needed to arrive to the appropriate solution(s), interacting with internal and external team members.

SKILLS:

Industries: Global and Domestic Finance and Accounting Services, Global and Domestic Insurance - Risk Management, Confidential, Legal (Law Firms), Outsourcing, Confidential (Medical Devices, Procedures and Research), Energy, Mining, Multi Business Enterprises, Manufacturing, Global Electronics, News and Entertainment, Retail, Fast Food Chain, Distribution.

Packaged Applications: PeopleSoft HCM (HRMS including Workforce Admin, Labor Relations, Training Admin-ELM, Profile Management amongst others)/ Payroll/ Benefits/ Benefits Administration, PeopleSoft Enterprise Portal, Global Payroll, Time and Labor, Recruiting, CSS/HRizon, Exposure to CRM Clarify, Remedy, eCase, INFOREM, SBT, Forte Accounting, Exposure to PeopleSoft Financials.

Client/Server/Web Technologies: PeopleSoft PeopleTools (Application Designer - Page, Component, Component Interface, Record/Fields, File, HTML, CRefs, Menu, Peoplecode, etc., including up to Release 8.5x and Upgrades/Tax Updates, Fixes/Patches/Service Packs, Bundles up to 9.1), Change Assistant, Data Mover, Business Process Design (Workflow), Process Scheduler, Application Engine, Application Messaging/ Integration Broker, PS Security, SQR for DOS/Windows/Unix, PS/Query-Crystal Reports, XML Publisher, Toad, Sybase ISQL, SQLPlus, Rdb-RDO, 2-tier, 3-tier, Basic HTML, Basic XML, Web Publishing, Front Page Express, FTP, WebLogic, Tuxedo, SiteCM (Web Content Management System - SaaS model).

Other- Software: MS-Office, WordPerfect, Lotus 123, Kedit DOS/Windows, Xedit Unix, Norton Utilities, Lotus Notes, MS Outlook, Visio, Winbatch, Kix, WinSCP, Refection FTP, Putty, Araxis & other utilities.

Database: Oracle 11g, 10g, 9i, 8i, MS SQL Server up to 2005, Sybase SQL Server, SQLBase, Rdb, SmartStar ISQL, Mainframe IDMS DB/DC, Mainframe DL/I (IMS/DB) and light DB2, VSAM, xBase, light MS Access.

Other- Languages: PeopleCode, Application Engine, SQR, light PL/SQL, Unix Scripting, Unix Scheduling under Autosys, Maestro and Control-M, light Visual Basic, FORTRAN, ALGOL-W, light C, MARK IV, DBASE, FOXPRO, CLIPPER & various libraries.

Operating Systems and Tools: Windows 7, XP, 2K, 2K3, NT, 9x, WinFrame/Metaframe, Unix/Linux/Xenix, HPUX, Sun OS, AIX, VAX/VMS, VAX/DCL, MS/PC-DOS, Novell Netware, Pathworks. VM/CP/CMS, DOS/VSE, OS/MVS, JCL, CICS, VSAM, ISPF, FILEAID, EZTRIEVE, INTERTEST.

Hardware: PC (Windows based), HP9000, RS6000, Sun Sparc, DEC VAX 2xxx, 3xxx, 4xxx, IBM Mainframe.

ASSIGNMENT HISTORY

Confidential, NY

Senior Techno-Functional PeopleSoft Consultant

Responsibilities:

• Responsible for Analysis, Design and implementation of multiple units of work associated to the second release of PeopleSoft at this client, reporting to the Director of Application Development. Various additional agencies were being integrated into PeopleSoft Human Resources, Finance, Enterprise Learning, Enterprise Performance and Enterprise Portal 9.0, adding approximately 55,000 more employees to the system.
• Lead the Analysis and technical efforts to design and implement a consolidated Self Service component that includes Employee HR, Benefits and Payroll information in a set of unified pages for the employees to view most of their own information; providing the ability to navigate to other self service pages to update their information if desired, accessible via an Extranet Portal (PeopleSoft Portal 9.0).
• Lead the analysis of new requirements to customize the PeopleSoft delivered Wage Progression processes (Labor Relations) and design a solution to minimize the exceptions management process efforts, developing an application engine process to acknowledge the exceptions based on desired criteria. A new custom exceptions report was also designed and developed to provide additional information and allow user to make better decisions.
• Analyzed requirements and developed a custom outbound Unemployment Information Interface to Talx.
• Analyzed and modified a custom time and labor report to eliminate duplicate information resulting from information correlation between the new consolidated PeopleSoft system and the originating agency system.
• Customized eRecruitment’s on-line application presentation to minimize the incidence of incomplete applications.
• Developed and modified various other interfaces as needed.
• Assisted in retrofitting legacy system applications to the new release of PeopleSoft as well as resolution of errors during the testing phase of the implementation.
• Provided production support resolving issues related to HR, Payroll, Time and Labor and Recruiting modules.
• On the Enterprise Portal end, analyzed the requirements to modify the majority of content of multiple home pages, such as Sign-on Page, Employee Home, Retirees Home, and Frequently Asked Questions. This involved the content modification of HTML based pagelets as well as managed content based pagelets, including the construction of pagelets that allow downloading documents stored in a separate document management system.
• Other Portal related activities include the addition of navigation collection items to connect to folders or specific components on HR, ELM, or Finance Target systems, and the application of branding layout from the production-like system to other life-cycle environments.
• Amongst the tools used in this implementation are: PeopleTools 8.49, Oracle 11g, SQL Developer and Toad, Office 10, Phire (Migration Tool and change management system for PeopleSoft), Siebel CRM.

Confidential, NJ

Senior Techno-Functional PeopleSoft Consultant

Responsibilities:

• Modified all the existing Application Engines with Component interface programs to work properly to support Singapore & Taiwan and subsequently enhanced them to support Australia and New Zealand data needs.
• The data interface include Configuration tables, such as Company, Business Unit, Department, Job Codes, Location, States and a subset of JPM category types; and Employee data tables for Person, Personal Data Effective dated, Primary and Preferred Names, Addresses, National Id, Phones, Bank Accounts, Prior Work Experience, Job Data (Hire and Transactions), Net Pay Distribution, Dependent Data and JPM Memberships and Languages.
• Developed Microsoft SQL Server Integration Services (SSIS) Packages to pull a subset of the foundation and Employee data tables from the Data Repository and place them in staging tables in the PS Global Payroll System for the Application Engine + Component Interface processes to do the rest.
• Modified PeopleSoft Process Scheduler by creating a custom Process Type to be able to schedule the SSIS packages under Process Scheduler and setup batch schedules for the entire integration flow.
• Performed necessary Global Payroll configuration to be able to run payrolls and unit/system test the integration applications.
• Customized Global Payroll Net Pay distribution elections to track net pay distributions to Partners’ beneficiaries and produce year end advances statements.
• Developed Global Payroll Data extracts to be used by XML Publisher to produce reports, utilizing PS Query as the main data source. Report Templates prepared to output in pdf, xls and rtf formats.
• Performed system administrations functions in the Development, Test and UAT database environments that included, Setup Application Server, Process Scheduler and Weblogic Web server, SQL Server Database Backup and Restores, Project and full database compares and migrations, amongst other activities.

Confidential

Senior Functional Analyst HCM PeopleSoft Consultant

The environment and tools utilized included: PeopleSoft HCM 8.3, 9.0 and 9.1, PeopleTools 8.22 and 8.5x, Secure FTP, SQR, Oracle 10g and 11g, SQLPlus, Toad, Weblogic, Tuxedo, Process Scheduler, Integration Broker, Process Scheduler, Office Suite, Source Safe Version Control Software, amongst others.

Responsibilities:

• Acted as Sr. Functional Lead Consultant in the PeopleSoft upgrade project, from HCM 8.3 to 9.0 and 9.1. Identified, analyzed, documented and specified retrofit requirements for existing and new functionality. Tested and troubleshot new functionality and customizations under the upgraded 9.1 environments. Supported user acceptance testing. HR Modules included but not limited to Workforce Admin, Profile Management, ELM (Training Admin), Merit Based Salary Increases, etc.
• Acted as go-to-person for a significant number of HCM issues, including HR, Benefits, Payroll, Security, People tools, SQL, SQR, as well as for potential solutions to issues at hand.
• Responsible for analyzing 8.3 vs. 9.0 and 9.1 security, applying critical security changes and supporting security transition from 8.3 to 9.0 and 9.1. Worked heavily with PeopleTools (App designer, App Engine, PeopleCode, Component Interface, Pages, Records, Integration Broker, etc)
• Responsible for evaluating the feasibility of implementing new functionality provided by the Template Based Hire (aka Smart Hire) module.
• Responsible for analysis and configuration of Profile Manager (Person) module.
• Designed and implemented an extension to the Enterprise’s GL interface to accommodate new and special requirements of recently acquired companies.
• Re-designed and implemented a PeopleSoft HCM to an Enterprise Learning System interface where the target system was Mzinga/KnowledgePlanet.
• Functionally & technically led a reorganization of one of the firm’s major operating companies, creating a new organizational structure of around 2500 departments and mass transferring approximately 22,000 employees and non-employees from their old departments to the new ones. The existing batch mass TRANSFER process was enhanced to handle international employees as well as non employees, incorporating to the sqr, the most recent modifications done to PeopleSoft online with respect to defaulting and calculating Std Hours, FTE, Salary Admin Plan, Salary Grade and Cost Code.
• Designed an HR and Payroll Interface between PeopleSoft and ADP as the target system in UK.
• This effort includes the design of configuration pages to support what ADP calls the fixed data elements to be fed, their output format and whether they are enabled for each operating company or not. The batch Payroll Interface is designed to feed 9 independent UK ADP payroll databases with logic to handle inter-company transfers as if they were leavers (terminations). This in-house interface replaced the ADP Connection product.
• Gathered requirements, designed and implemented an Interface between PeopleSoft HCM and ADP (PFN) target system in Australia/New Zealand for the firm’s principal operating companies. This effort included the design of custom components to maintain Australia/New Zealand specific compensation data elements not supported by the current release of PeopleSoft at this client, and a dynamic pay calendar as well as the implementation of new international companies and pay groups and data conversion and synchronization between PFN and PeopleSoft.
• Designed a Generic Mapping tool to be used by various existing and new PeopleSoft applications. This tool was originally planned for use in the Australia/New Zealand HR/Payroll Interface, but was eventually leveraged for many applications as well, becoming a standard tool to map data values and control selection criteria.
• Supported the current production environment by analyzing new requirements, specifying application design modifications, guiding developers on the solution implementation and testing the modified modules. Identified and guided developers in fixing a Mass Supervisor Id load process. Specified and implemented a modification to the email notification functionality for when employees or HR users update Primary Names or Education qualifications of employees. Specified and guided developers on a modification to the User Profile Creation process to incorporate personalization options such as date format.

Confidential, FL

Senior Techno/Functional HCM and Portal PeopleSoft Consultant

The environment and tools utilized included: Enterprise Portal, HCM, PeopleTools, Secure FTP, SQR, Oracle 9i, SQLPlus, Toad, Weblogic, Tuxedo, Process Scheduler, Integration Broker, Process Scheduler, Office Suite, and Source Version Control Software.

Responsibilities:

• Gathered security requirements and Implemented Integration between PeopleSoft Enterprise Portal 8.9 (Tools 8.46.09) as the Portal to HCM 8.9, Authoria and Other Intranet and Extranet Content Providers.
• Performed as Sr. Technical/Functional team member for the Benefits Administration 2007 Open Enrollment (OE) Periods for USA and Ireland (Oct 2006 - Jan 2007). Customized Benefits Enrollment forms to support the new OE 07 requirements. Worked closely with lead functional resource in design changes of event rules, external application of defaults and Pre-Enter values. Designed and developed a process to globally assign BAS Group Ids and Annual Benefit Base Rate as required for the new year period. Performed modifications and guided other technical team members in modifying eBenefits to support new affidavits to be displayed during the self service enrollment process. Modified PeopleCode to default Ben Admin fields such as Bas Group Id, Elig Configx, etc. Modified various Benefits vendor interfaces to support new and modified benefit plans. Developed process to calculate FSA employee contribution amounts.
• Gathered requirements to design and develop a printer friendly version of ePay statement to be accessed thru Enterprise Portal.
• Participated in benefits open enrollment process for an acquired company, developing customized enrollment and confirmation forms specific for the acquired population, as well as modifying existing processes and interfaces to support the new population.
• Troubleshot issues during Dev, QA, UAT and move to production.
• Performed as a technical and functional team member for upgrade from HCM 8.3 to 8.9. Retrofitted/adjusted 8.3 customizations into the upgraded environment, including pages, components, PeopleCode, sqrs, application engine, component interfaces associated to HCM, Base Benefits, Benefits Administration and Payroll Interface. This included troubleshooting application upgrade issues as well as tuning performance issues, including issues associated with the new 8.9 Person Model.
• Gathered requirements to design and develop an outbound interface from HCM to a CRM application - eCase - providing demographic data for the entire 40,000+ employees and non-employees.
• Built various custom security permission lists to support a training environment. Troubleshot security issues with existing permission lists and roles as well as new ones associated with development, QA, user acceptance and production environments.
• Prototyped and designed a customized Portal’s Forgot Password functionality to allow users with or without email addresses to reset their own password without the need to call the help desk.
• Designed and developed an automated user profile creation process to allow 22,000+ active employees performing self-service functions in HCM via Enterprise Portal. The application engine process included synchronization of the user profiles, created with the use of component interfaces and based on a template user profile, between HCM and Enterprise Portal via application messaging. The process was designed to handle the initial creation of the existing population as well as new hires on a nightly basis. Assisted system admins in setting up and troubleshooting Integration broker for HCM and Portal as well as single sign-on between HCM and Portal.
• Gathered requirements and designed the components to assign dynamic roles to self-service users in HCM and synchronize with Portal via application messaging. These included dynamic roles for USA, Ireland and other international employee self-service and manager self-service users. The components included roles, query roles for employee self service and manager self service, scheduling of dynrole publ with sufficient time lag between this process and the user profile creation process to allow for user profile messages to arrive to the target nodes before the dynamic role criteria gets evaluated.
• Designed and developed an application engine process to assign static roles to select users, based on input file, via component interface, and synchronize the modified user profiles with Enterprise Portal using application messaging.
• Gathered requirements to design and develop an approach to integrate Cognos into the Enterprise Portal environment allowing Portal users to initiate Cognos sessions by single signing on into it. Extended the single sign-on functionality so it could be used with other third party tools, such as Vurv (Recruiting application), Plateau (LMS).
• Acted as primary technical resource and guide functional resource to help implementing Benefit Administration for Ireland employees in an aggressive timeline of 9 weeks. USA Ben Admin setup was leveraged to speed up the implementation process. As part of this effort developed application engine/component interface processes to integrate Dependent/Beneficiary information into HCM for Ireland employees as well as their Health enrollment options formerly managed by a third party vendor. The component interface approach prevented the storage of bad data by leveraging business logic already in PeopleSoft application vs. the sqr approach, which usually leads to data integrity issues.
• Assisted in production support by troubleshooting production issues and finding resolution to them.
• Designed and developed Application Engine processes and Component Interface to lock and Unlock User Profiles depending on employees’ employment status changes, synchronizing the HCM user profiles with Enterprise Portal.
• Gathered security requirements for a so called Phase III in the implementation of Roles to be impacted or newly developed for the PeopleSoft HCM and Portal implementation.
• Gathered requirements and analyzed alternative method of using permission list based row level security as a potential replacement of the Department Security Tree for the same row level security purposes. Set up a prototype utilizing various PS delivered and custom fields proving some or all of the Dept Security tree row level security could be replaced by permission lists based row level security. Implemented the approach for access to Non Employees based on Business Unit - Location. Implemented permission list based row level security utilizing custom fields from Job Jr and others.
• Worked closely with DBA team for system configuration in Unix environments, including the setup and troubleshoot of integration broker, single sign-on, security and database and application messaging performance issues.
• Provided application development consultation to other team members as well as assisted in resolution of various HCM and Portal implementation issues.

Confidential, NJ

Senior Technical PeopleSoft Consultant

The environment and tools utilized included: Enterprise Portal, HCM, PeopleTools, Unix Scripting (Korn), XML, OraXML, OracleXML, Secure FTP, SQR, Oracle 8i and 9i, SQLPlus, Toad, Weblogic, Tuxedo, Process Scheduler, Integration Broker, Control-M, Office Suite, Unix SCCS, MS Visual Source Safe.

Responsibilities:

• Implemented PeopleSoft Enterprise Portal 8.8 (Tools 8.45.15) as a Portal to HCM 8.8, Performance Management, Authoria and Other Intranet and Extranet Content Providers.
• Upgraded PeopleTools from 8.45.12 to 8.45.15. Evaluated PeopleTools 8.46 and Portal 8.9.
• Applied Enterprise Portal Bundles to update the application to 8.8 MP1 Bundle 8 and various other patches.
• Set up Unix PS Home environment for development, system and acceptance test environments.
• Coordinated tools and application updates with middleware personnel - App Server, Web Server.
• Designed and developed multiple interfaces to integrate HCM employee data into Portal database and to be presented in portal pagelets. This involved the processing of XML files created on the HCM side, placed on common servers to be transferred via secured ftp to the portal side, validate against xml schemas, loading into staging tables and finally loading into portal tables.
• Designed and developed a process to automatically maintain (create, lock, unlock, purge, update) user profiles for eligible employees on the portal side and enable single signon.
• Designed and developed a process (including run control page and options page) to rename HCM user profiles to match user ids from the portal side and support single sign on for the entire population to access the Portal and HCM (approx. 25,000 US employees).
• Designed and develop customized process to update dynamic roles on the portal database and allow users to get access to select portions of the portal content.
• Designed and developed various UNIX scripts to perform system maintenance.
• Performed and assisted in unit tests, buddy tests, system and acceptance tests of online home pages, pagelets, navigation options and other content, and batch processes throughout the project live cycle.
• Designed and developed process to generate various Portal Usage reports displaying number of unique users logging to the Portal system during a period of time (given as parameters) and by various employee categories such as Rank code, Business Unit and Location, with multiple options for data range selection and generation of a timeline chart when process is run in windows environment.
• Designed Portal pagelets to expose data interfaced in from a Performance PeopleSoft Database.
• Provided assistance during overall system configuration on Windows and Unix environments, which included the set up and troubleshooting of integration broker, Portal Search feature, and security. Provided application development support to other team members as well as resolution of various implementation issues.

Confidential

Senior Technical PeopleSoft Consultant

Responsibilities:

• Participated in upgrade of PeopleSoft HRMS 7.51 to 8.3 HCM and 8.4 Enterprise Portal, developing multiple Application Engine and sqr processes, as well as online customizations. A partial list of assignments under version 8 follows:
• Developed Payroll and Benefits Acquisition related processes (Application engine + component interface) to assist in integrating acquired businesses into existing system.
• Developed App Engine to automate creation of off-cycle or special pay calendars based on existing pay calendar sets (run id).
• Developed app engine to interface Payroll data to Executive Compensation in effort to support the 35% supplemental tax regulation.
• Developed outbound interface of Group Umbrella Life insurance.
• Developed process to automate departmental transfers for multiple employees (batch), with special rules based on particular mass transfers.
• Lead technical efforts to make Application Messaging/ Integration Broker work between HR 8.3 and Portal 8.4 synchronizing User Profiles between the disparate technologies. Also customized and corrected other PS-delivered related Application Messages and associated components and component interfaces.
• Automated the process of creating User Profiles in large groups (utilizing Group Build functionality).
• Corrected PS delivered HR FASTVIEW due to missing functionality not carried over from version7.5 by PS.
• Automated process of mass deleting user profiles upon employee terminations or transfers when they required a complete change of the employee’s user profile (App Engine/App Message/Integration Broker).
• Automated process to update dynamic roles (security related) and synchronize them with Enterprise portal via App Messaging/Integration Broker.
• Developed Application (App Engine) to monitor, in batch mode, execution of Messages in HR DB and Enterprise Portal and alert system administrators of error or blocking conditions.
• Developed custom components for Manager’s Self Service functions to be used by HR representatives, such as Job code changes, location changes and others originally assigned to other team members.
• Customized HR components to synchronize business email between HR and Enterprise Portal via App Mess/Integration Broker.
• Optimized multiple PS delivered processes, amongst them: PERS REFRESH (made it a client custom version going from about 6 hours to about 15 minutes), the FAST Security Part of HR FASTVIEW, reducing run time from about 50 minutes to 15 seconds. Other processes were optimized with dramatic reduction in processing time, including Component’s payroll dialog boxes/pages.
• Developed and maintained various batch and online processes PS delivered and custom developed.
• Acted as technical guide to Client employees in multiple assignments to improve development time.
• Provided post implementation production technical support, troubleshooting arising issues and implementing corresponding solutions