EXECUTIVE SUMMARY:

Human Capital Management Senior Consultant with over eighteen years of PeopleSoft experience. He specializes in Human Resources, MSS, ESS, AWE and legacy workflow, Payroll, Benefits Administration, Absence Management and Time and Labor. During his most recent experience at Confidential, he served as a PeopleSoft Senior Developer. He re - implemented MSS, performed upgrades using Change Assistant to upgrade HRMS 8.9 to HCM 9.2 and ELM 9.0 PeopleTools upgrade only. He assisted the upgrade team to streamline all PeopleSoft applications to the same PeopleTools 8.54.08 level. In addition, he wrote data conversion scripts to reset all core HR data and foundation tables to the start of the new Confidential company.

CORE COMPETENCIES:

PeopleSoft: HCM, Payroll, Absence Management, Time and Labor, Employee Self Service, Manager Self Service, ePerformance, Portal, Benefits Administration, eProfile, Accounts Payable, General Ledger

PeopleTools: PeopleCode, SQL, Workflow, AWE, User Acceptance Gateway, SQR, MICR DIMM, FLASH DIMM, ACH, COBOL, iScripts, HTML/Java Code, DMS Scripts

WORK EXPERIENCE:

Confidential

PeopleSoft Workflow Developer

Responsibilities:

• Customized the Voucher Approval page to allow approvers to change the workflow data and re-submit the Voucher for approval. Maintain the old approval chain history and automatically approve a step in the new approval chain if the same approver already approved on the old
• Customized the Voucher Regular Entry page to allow requesters to add the appropriate approval routing for processing Non-PO credit vouchers
• Created a custom Workflow Hierarchy structure to store Approval Levels and route workflow as an override
• Created a custom Workflow Hierarchy structure to store Reviewers for Approval Levels and dynamically route to the Reviewers if existed
• Implemented workflow escalation to notify participants and advance approval steps if the transaction time out
• Configure the Voucher Approval and Requsition transactions for AWE approval routings and notifications based on the requirements
• Created DMS scripts to migrate all AWE configurations, GL and AP system configurations
• Created SQL scripts to deny pending workflow transactions for cutover
• Participated in Systems and Integration Tests and resolved defects from testing

Confidential

PeopleSoft Upgrade and Senior Developer

Responsibilities:

• Install Oracle VM VirtualBox and PeopleSoft Update Image 9
• Created documentations on how to install and maintain PeopleSoft Update Images
• Assisted management with upgrade planning, decision making and ensured the certified upgrade path is followed
• Downloaded all pertinent upgrade information and materials from the Oracle upgrade home page
• Assisted the team to layout the hardware, software, infrastructure and other requirements and certify with Oracle
• Created an upgrade schedule for each upgrade pass so the upgrade process can be repeated early instead of rehearsing late and right before the final cutover
• Performed the upgrade passes using Change Assistant to upgrade HRMS 8.9 to HCM 9.2 and ELM 9.0 PeopleTools upgrade only
• Created upgrade lessons learned after the initial pass and reviewed with the upgrade team
• Installed PeopleTools 8.54.08, TOAD and other developer tools on VM client machines and enabled them for remote desktop connection
• Participated in MSS fit-gaps and design sessions
• Re-implemented MSS custom transactions for Lateral Job Reclassification, Promotion, Financial Attribute, Pay Rate and Job Data Changes
• Disabled the delivered MSS transactions
• Coded all MSS transactions and configured AWE approval routings and notifications based on the requirements
• Created DMS scripts to migrate all AWE configurations and performed migrations upstream
• Created data conversion scripts to reset all core HR data and foundation tables to the start of the new Confidential company
• Applied custom branding to Interaction Hub 9.1 after reinstallation
• Applied user security to Interaction Hub 9.1 after reinstallation
• Applied custom pagelets to Interaction Hub 9.1 after reinstallation
• Applied custom single sign-on PeopleCode to Interaction Hub 9.1 after reinstallation
• Configured Navigation Collection Pagelets, Links Pagelets, and Pagelets for Queries for WorkCenters and Dashboards to access HCM and ELM contents
• Used Application Data Sets to migrate WorkCenter configurations
• Supported and resolved issues from the full lifecycle testing of the Interaction Hub 9.1 reinstallation
• Provide ongoing production support

Confidential

PeopleSoft Developer and Workflow Specialist

Responsibilities:

• Implemented MSS Transfers and Promotions transactions using full position management functionality
• Customized MSS Promotion with the ability to include salary changes
• Coded and configured AWE approval routings and notifications based on MSS requirements
• Created DMS scripts to migrate all AWE configurations and performed migrations
• Conducted ePerformance fit-gaps and analysis and documented the new requirements
• Configured ePerformance template ID, definitions and sections for the 2013 performance evaluation cycle
• Configured ePerformance template ID, definitions and sections for Interim and PIP evaluations
• Coded and configured AWE approval routings and notifications for ePerformance
• Lead the ePerformance systems and UAT testing
• Created DMS scripts to migrate all AWE configurations, template Ids, definitions, sections and performed migrations
• Assisted the Benefits team to configure Open Enrollment for the 2014 year
• Created DMS scripts to migrate all Open Enrollment configurations, tax rate updates and new benefit tiers
• Assisted the Payroll team to install ADP Tax Extract interfaces in HCM and testing with ADP
• Assisted the HR team to create Taleo interfaces and provided testing support
• Assisted the HR team with eCompensation processing and generating eComp statements for managers
• Assisted the functional team to perform fit-gap analysis and document the gaps on Absence Management and Time and Labor 9.1
• Assisted the functional team to configure Absence Management and Time and Labor 9.1
• Customized the Time and Labor timesheet heavily to implement Quantech’s time reporting policy
• Configure Integration Broker between HCM and FSCM 9.1 for the following service operations PROJECT ACTIVITY SYNC, PROJECT ACTIVITY TEAM SYNC, PROJECT SYNC, PROJECT STATUS DEFN SYNC, PROJECT STATUS SYNC and PROJECT TEAM SYNC
• Create custom query reports for Time and Labor reconciliation, missing timesheets and other reporting requirements
• Create custom dms scripts to migrate Time and Labor configurations and rules package to migrate Absence Management configurations
• Participated in Functional, Systems, Integration, User Acceptance Tests and resolved defects from testing
• Assisted the IT Department to refresh databases from production
• Provided production support for HCM, FSCM and ELM 9.1

Confidential

PeopleSoft Workflow and Developer

Responsibilities:

• Modified the Delegation Framework to enabled managers to delegate their initiate and approval authority to multiple proxies
• Modified the Ad Hoc Salary transaction to be enabled for delegation
• Modified the Direct Reports UI to include a custom search capability available only to initiate proxies
• Documented the MSS functionality enhancements and performed knowledge transfer with the team
• Participated in Functional, Systems, Integration, User Acceptance Tests and resolved defects from testing
• Created DMS scripts to migrate all AWE configurations and performed migrations
• Created DMS scripts to migrate all AWE configurations and performed migrations
• Created an AE program for Job Earnings Distribution conversion based on the redesign Chart of Accounts from FSCM
• Created an AE program to sync the Combo Codes between FSCM and HCM due to redesign Chart of Accounts
• Created an AE program to avoid transactions being posted to the GL to inactivated departments or projects
• Created an AE program to report and track Payroll Salary commitments by project budget year
• Created a custom EIP to perform a full table sync of delivered FSCM table PS GM AWD FUND PD from FSCM to HCM

Confidential

PeopleSoft Workflow and Developer

Responsibilities:

• Assisted the teamimplementing MSS with technical design, coding and unit testing
• Assisted the team implementing MSS with configuring AWE for workflow routings, notifications and administrations
• Documented the MSS functionality and performed knowledge transfer with the team
• Participated in Functional, Systems, Integration, User Acceptance Tests and resolved defects from testing
• Created DMS scripts to migrate all AWE configurations and performed migrations

Confidential

PeopleSoft Developer

Responsibilities:

• Participated in upgrade fit gap analysis, documentation of upgrade retrofits and change management processes.
• Reapplied existing customizations to the upgraded databases.
• Participated in Functional, Systems, Integration, User Acceptance, Parallel and Performance Tests and resolved defects from testing.

Confidential

PeopleSoft Workflow SME and Developer

Responsibilities:

• Assisted the teamimplementing MSS Phase II with technical design, coding and testing
• Assisted the team implementing Template-Based Hire with technical design, coding and testing
• Assisted the team implementing HCM Delegation Framework with technical design, coding and configuration
• Created a proto-type for MSS with the ability to process multiple Job transaction types
• Demo Integration Broker and Web Services to the team

Confidential

PeopleSoft Developer

Responsibilities:

• HCM: NA Payroll, ESS, MSS, ePerformance
• Participated in upgrade fit gap analysis, documentation of upgrade retrofits and change management processes.
• Reapplied existing customizations to the upgraded database.
• Participated in Functional, Systems, Integration, User Acceptance, Parallel and Performance Tests and resolved defects from testing.

Confidential

PeopleSoft Workflow SME and Developer

Responsibilities:

• Demo the new features of Approval Workflow Engine (AWE) to the team.
• Created a bolt-on MSS module with AWE and Delegation enabled to be used for proof-of-concept demo, analysis, define requirements and level of effort.
• Implemented a new bolt-on Manager Self Service module to allow managers to perform Reporting Change, Residency Status Change, Voluntary Retirements and Terminations for their direct reports all in one place. Deactivate the delivered Manager Self Service pages.
• The new bolt-on Manager Self Service displays side-by-side comparison of old and new job change information for originators to request transactions, users to preview, approvers to approve, and administrators to manage transactions.
• Integrated the bolt-on Manager Self Service module with Direct Reports UI Application Packages and Approval Workflow Engine (AWE) in PeopleSoft HCM 9.1.
• Implemented Approval Workflow Engine (AWE) to provide the framework to configure, create, run, and manage all approval processes.
• Implemented the Approval Workflow Engine (AWE) Status Monitor to display steps of the approval path and action status of the transaction.
• Enabled the Delegation framework and integrate with the new bolt-on Manager Self Service module.

Confidential

PeopleSoft Developer

Responsibilities:

• Modify the MSS text catalog entries to enhance the introductory/instructional text to include hyperlinks.
• Modified the Ad Hoc Salary Change, Transfer, Promotion and Reporting Change pages to add new fields, defaults, field labels and other look and feel changes.
• Modified the Notification Templates for Promotions, Reporting Changes and Transfers to add new custom texts and bind variables.
• Changed the Ad Hoc Salary notification e-mails to custom message catalog entries. Updated the appropriate e-mail parts on the PS SS EMAIL TEXT and PS SS BIND GRP to point to the new message catalog entries.
• Created an MSS Dashboard which is a summary view/count of all MSS Transactions a manager has initiated, approved, denied or pending the manager’s approval. Each summary total is a drill-down link which will take the manager to the detail transaction.
• Created dms scripts to migrate the custom changes to upstream environments.
• Created an App Engine process to build the company’s Org Structure at the employee level into a static table that is refreshed daily.
• Created a Web Service to send employee accomplishments to downstream systems. Leverage all the new features in Integration Broker and PeopleTools to build the service.
• Assist the team with production support and enhancements.

Confidential

PS Developer

Responsibilities:

• Manager Self Service, Employee Self Service, Payroll and Time and Labor
• Participated in upgrade fit gap analysis, documentation of upgrade retrofits and change management processes.
• Reapplied existing customizations to the upgraded database.
• Created custom SQL scripts to resolve upgrade conversion issues.
• Participated in Functional, Systems, Integration, User Acceptance, Parallel and Performance Tests and resolved defects from testing.
• Implemented a new bolt-on Manager Self Service module to allow managers to perform Promotions, Transfers, Job Data, Pay Rate, Location, Reporting and Terminations for their direct reports all in one place. Deactivate the delivered Manager Self Service pages.
• The new bolt-on Manager Self Service displays side-by-side comparison of old and new job change information for originators to request transactions, users to preview, approvers to approve, and administrators to manage transactions.
• Integrated the bolt-on Manager Self Service module with Direct Reports UI Application Packages and Approval Workflow Engine (AWE) in PeopleSoft HCM 9.1.
• Implemented Approval Workflow Engine (AWE) to provide the framework to configure, create, run, and manage all approval processes.
• Implemented the Approval Workflow Engine (AWE) Status Monitor to display steps of the approval path and action status of the transaction.
• Integrated all AWE Workflow routings, approvals and notifications using the Department Security Tree.
• Created a custom AWE Process Definition for Timekeepers to configure, manage all approval processes and approve payable time.
• Customize the Check Print programs and set up View PDF Pay Checks through Employee Self Service. The impacted programs are PAY003.SQR, PYSSPXML.SQC, PAY003 US XSD.xsd (Check Print XML Schema) and PYUSCHKB.rtf (PDF Template).
• Customize the Advice Print programs and set up View PDF Advices through Employee Self Service. The impacted programs are DDP003.SQR, PYSSPXML.SQC, DDP003 US XSD.xsd (Check Print XML Schema) and PYUSADVB.rtf (PDF Template).

Confidential

PS Developer

Responsibilities:

• Created functional specification to provide performance ratings to downstream systems.
• Build the web service using integration broker to provide performance ratings to downstream systems.
• Configured and integrated the ePerformance module with the Enterprise Portal for self-service requirements.
• Created custom navigation collections, html and manage content pagelets.
• Participated in unit tests, code reviews and documentation of the ePerformance and Portal implementation project.
• Participated in Systems, Integration, User Acceptance, and Performance Tests and resolved defects from testing.
• Performed knowledge transfers and portal training to the implementation team.

Confidential

PS Developer

Responsibilities:

• Also MSS, ESS, Payroll and Benefits Admin Implementation 9.0
• Reapplied existing customizations to the upgrade database.
• Participated in unit tests, code reviews and documentation of upgrade retrofits.
• Participated in Functional, Systems, Integration, User Acceptance, Parallel and Performance Tests and resolved defects from testing.
• Created a custom Component Interface to insert and delete from Job Data for Payroll and Benefits Administration conversion.
• Implemented a bolt-on eProfile Manager Desktop (Manager Self Service) module to allow managers to perform Terminations, Transfers, Promotions, Demotions, Job Data and Pay Rate changes for their direct reports.
• Integrated the bolt-on Manager Self Service module with Direct Reports UI Application Packages and Approval Workflow Engine (AWE) in PeopleSoft HCM 9.0.
• Implemented Approval Workflow Engine (AWE) to provide the framework to configure, create, run, and manage all approval processes.
• Implemented the Approval Workflow Engine (AWE) Status Monitor to display steps of the approval path and action status of the transaction.
• Integrated all Workflow routings, approvals and notifications using the Department Security Tree.
• Created Manager Self Service pages with side-by-side comparison of old and new job change information for originators to request transactions, users to preview, approvers to approve, and administrators to manage transactions.
• Implemented Employee Self Service as delivered.
• Created a flexible interface program to load time files from Legacy time keeping system to PeopleSoft.
• Created a custom Paysheet load program to insert approved hours into Paysheets.
• Created technical specifications for Payroll balances conversion from Legacy System to PeopleSoft Payroll 9.0.
• Implemented the new SmartHire (Template-Based Hire) feature in release HCM 9.0 to allow HR Managers to use specific jobs, schools or brand template to hire employees.
• Implemented the Manage Hire module to manage new hires and rehires using SmartHire (Template-Based Hire).
• Created hire templates to default all common job and personal data information to reduce the time it takes to enter hire data and configure the templates to allow or disallow users from overriding template data.
• Implemented row-level security for SmartHire (Template-Based Hire) using Template ID and Template Control access type.
• Created user guides for Manager Self Service and SmartHire (Template-Based Hire).
• Assisted the security setup and security implementation for the HCM 8.8 to 9.0 Upgrade with Payroll, Benefits Administration and Manager Self Service 9.0 implementation.
• Created and documented the Development Coding Standards and Naming Convention.
• Integrated the eProfile Manager Desktop (Manager Self Service) modules with the Enterprise Portal for self-service requirements using Single Sign-On.
• Modified and tested the Text Catalog entries for Candidate Gateway (e-Recruit) to fit each school’s brand. The Candidate Gateway modules will dynamically display each school'spage titles, page instructions, group box labels, grid labels, field labels and link titles as required.
• Tested the following Candidate Gateway (e-Recruit) modules through the Enterprise Portal: Search for Job Openings, E-mail Job Openings to Friends, Applying for Job Openings and Uploading and Viewing Resumes.
• Defined and mapped legacy HR data to PeopleSoft HR data structure.
• Defined and mapped legacy Payroll data to PeopleSoft Payroll data structure.
• Defined and mapped legacy Benefits data to PeopleSoft Benefits data structure.
• Defined and created the overall conversion strategy for the project.
• Defined and created the testing strategy for the project.
• Created an SQR interface program to load time files from Legacy time keeping system to PeopleSoft Payroll.
• Created a custom SQR load program to insert hours into Paysheets, where hours might split into multiple jobcodes and departments on the paysheet.
• Created a custom component interface application engine program to convert legacy personal data records into PeopleSoft to create employees.
• Created a custom component interface application engine program to convert legacy hire details into PeopleSoft to create hire records in job data component.
• Created a custom component interface application engine program to convert legacy job history records into PeopleSoft to create job history.
• Created a custom component interface application engine program to hire employees from a third-party daily interface feed.
• Created a custom application engine program to feed HR data on a daily basis to a third-party system for data entry validation.
• Created a custom page to map PeopleSoft Location codes to legacy school codes.
• Created a custom page to map PeopleSoft Earnings codes to legacy earnings codes.
• Defined and created the detail cutover plan for the project.

Confidential

PS Developer

Responsibilities:

• Reapplied existing customizations to the upgrade database
• Participated in unit tests, code reviews and documentation of upgrade retrofits
• Participated in Systems, Integration, User Acceptance and Performance Tests and resolved defects from testing.
• Participated in the fit-gap and technical design of e-Profile 8.9
• Implemented e-Profile 8.9 with heavy online and multiple approvers workflow customizations. The impacted modules include Addresses, Email addresses, Emergency contacts, marital status, Name changes, Phone numbers, Ethnicity/Race and Work Locations.
• Integrated the e-Profile module with the Enterprise Portal for self-service requirements.

Confidential

Partner Affairs, Technical Lead/PS Developer

Responsibilities:

• Created an Oracle reporting table to store K-1 data.
• Created setup tables to map K-1 data to Turbo Tax file requirements.
• Created new PeopleCode function to read K-1 data, format into Turbo Tax TXF file and import the TXF file into Turbo Tax.
• Collaborated with Intuit to enhance the Turbo Tax product to accommodate PwC's taxation requirements.
• Reapplied existing customizations to the upgrade database.
• Prepared project plan and managed the entire upgrade effort from beginning to end.
• Monitored progress on the upgrade project plan and tasks, and coordinated communications between the upgrade team members, clients and third party vendors.
• Facilitated weekly meetings with the project team to discuss progress and issues, and altered the scope of the upgrade or obtained additional resources, as required, to ensure that the project is completed on schedule.
• Provided weekly project health status to management and sponsors on tasks, issues and budget.
• Assembled the upgrade resources into teams to focus on architecture, online, batch, testing, training, job scheduling, security and sponsor/business; and supported the upgrade team in all upgrade efforts.
• Built the upgrade analysis plan/approach and facilitated all compare report reviews and fit gap analysis.
• Implemented change management process to integrate emergency production fixes, tax updates and regulatory updates into the upgrade gold database.
• Created and implemented the visions/strategy for training, testing, issues management, upgrade migrations, upgrade environments build out and final move to production.
• Coordinated and tested the disaster recovery plan and environment build out at disaster recovery site.
• Integrated HRMS 8.1 with Vignette Epicentric enterprise content management using SOA Standards for ERP.
• Implemented Single Sign-On with third party portal application using Netegrity SiteMinder as the security mechanism.
• Re-architect the PeopleSoft Internet Architecture to be more service oriented by adding a virtual IP address 11k switch and an apache server to host the SiteMinder agent.
• Implemented Single Sign-On with third party benefits vendor Minnesota Life Insurance.
• Implemented Single Sign-On with third party benefits vendor Benefits Express.
• Integrated HRMS 8.1 with Lotus Notes Domino environment to dynamically and instant publishing domino contents, compose e-mail questions, manage communications and key dates, and update the US Firm Directory.
• Created a Me@PwC dashboard to personalized contents for US PwC partners. The dashboard focuses on the partner latest information and releases, what's new, key dates, partner communications and general links.
• Created a Balance Sheet dashboard to personalized contents for US PwC partners. The dashboard displays up-to-date balances of wealth accumulation resources, links to supporting detail pages and consolidated summary of all related balance sheet information.
• Created an Income and Cashflow dashboard to personalized contents for US PwC partners. The dashboard contains distributable base income, actual year end income, on-line year end settlement projection, latest pay and expense statements, and consolidated summary of all related income information.
• Created a Benefits dashboard to personalized contents for US PwC partners. The dashboard contains exhaustive list of all benefit programs and links to other sites with additional benefit programs, related coverage and premium information and consolidated summary of all related benefits information.
• Created a Taxation dashboard to personalized contents for US PwC partners. The dashboard focuses on the partner's latest taxation information/releases, what's new, key tax dates, taxation communications and general taxation links.
• Created a bolt-on application to originate process and manage loans dynamically.
• Created, tested and documented a loan payments page for adding new payments (en masse) for existing loans in the PeopleSoft Loans system.
• Created, tested and documented a loan portfolio data page to display existing high level data for each loan
• Created, tested and documented a loan payments page similar to the quick-entry (en masse) page for adding new payments for existing loans; however, users may choose to fully pay off a loan.
• Created, tested and documented a display only page showing the complete loan history for a single loan.
• Created, tested and documented a display only page showing the summary statement data for all loan types.
• Created, tested and documented a data entry and display page showing the payroll deduction data for all loan types.
• Created, tested and documented a display page showing the amortization statement for active loans for all loan types.
• Created, tested and documented a loans-terms page (setup) to be used for loan calculation, repayment, processing, interest rate, number of grace months and loan months.
• Created, tested and documented an SQR process to apply deductions from payroll to the loan system and verifies amounts.