SKILLS:PeopleSoft:  9.X, 8.X, 7.X

PeopleTools - Release: 8.4X/8.5X  People tools, People Code, Application Engine, Application Packages, Component Interface, BI Publisher, Integration Broker, Work Centers, SQR, Crystal Reports and Phire.

Databases:  DB2, Oracle 11g/10g/9i, SQL Server, Sybase

HRMS modules:  HR, Base Benefits, Payroll (North American Payroll), Ben Admin, Compensation, Time & Labor, Self Service, Manager Self Service, E-Profile, E-Benefits and E-Performance.

CRM modules:  Help Desk, Customer Support

Operating Systems:  DOS, Windows NT, 95, 2000, XP, 2007 and Sun Solaris and HP UNIX

Reporting Tools:  XML Publisher, SQR, Crystal Reports, n-Vision and XML publisher.

Other tools:  Kronos, Developer 2000, Visual Basic 3.0/5.0 HP Quality Center, Java Script, XML Publisher

EXPERIENCE

Confidential

Houston, TX

PeopleSoft HCM

• EIN Project
• Worked on modifying several SQR and Application Engine programs for the effort.
• Preformed complete testing and documentation of all the mods.
• Created Hartford Billing Report which calculates Premium dues for all the Benefit plans Energy Transfer offer. Plans include Life, Supplemental Life, Long Term Disability, Short Term Disability, Employee Assistance Program and FMLA. The Report applies all eligibility rules for employees across all companies of Energy Transfer and calculates premium due.
• Prepared OSHA Report.
• Created Turnover reports.
• Made few changes for e-benefits pages for new hire event.
• Supported team during open enrollment process.
• Created a new program to load ACA eligibility.
• Created detailed Tech specs for all the customizations.
• Good working knowledge in Benefits, Ben Admin, Payroll.
• 9.2 upgrade
• Prepared scripts to cleanup as result of SYS and DDD Audit in preparation for 9.2 upgrade
• Performed compare between 9.1 and 9.2
• Identified customizations and worked with functional leads to confirm if the customization(s) are still needed.
• Prepared detailed analysis report and presented to the Project Leads.
• Analyzed SQRs for 9.2 upgrade.
• Retrofitted customizations which includes Pages, PeopleCode, Application Engines and SQRs.
• Designed and developed a new WorkCentre for Bonus module (bolt on)
• Coordinated with functional team to complete 3 rounds of testing and worked to fix issues.
• Completed specs for all the customizations.

Environment: PeopleSoft HCM 9.1/9.2, Oracle, Windows 7/10, People tools 8.52/8.55, People code, SQR, Application Engine. Toad, Phire.

Modules: HR, Benefits, Ben Admin, E-Benefits, Payroll, Time & Labor.

Houston, TX

PeopleSoft HCM

• Upgrade from PeopleSoft 88 to 91
• Technical developer in charge of creating new processes & reports using Application Engine & SQR.
• Retrofit customizations across Benefits, Budgets & Encumbrances (Commitment Accounting) and LMS modules.
• Used Integration Broker to process financial account code data into PeopleSoft.
• Involved in end to end testing and implementation.
• Implementation - OPM - Online Position Management
• Utilized Approval Workflow Engine (AWE) to customize positions management for District.
• Developed end to end technical solution
• Beginning with requesting new/change/close positions
• Customizing the workflow based on School/non-school based.
• Process the approved requests back to PeopleSoft.
• Emails communications are customized to let the users & approvers.
• Configured delegation setup.
• Employee Self Service implementation
• Developed full implementation solution for ESS using Workcenter Frame work.
• Using ESS, District employees now can access Personal, Benefits, Payroll and compensation info.
• Modified Paycheck & Direct deposit XML report definitions to match current HISD standard Paycheck copy.
• Customized W2 so that employees can access and print W2s directly from ESS.
• Customized direct deposit ESS page to match HISD standards.
• ACA mods
• Created custom pages to hold ACA data.
• Created a new process to identify potential employees who are ACA eligible.
• Worked with ADP vendor for other program changes affected by ACA inclusion.
• Production support
• Technical Production support provided for all modules.
• Responsibilities include customer assist, writing Sql queries for providing data for users, bug fixes etc.
• Working SAP & Success Factors teams to assist in data conversion.

Environment: PeopleSoft HCM 9.1, SQL Server, Windows XP/7, People tools 8.52, People code, SQR, Application Engine, Application Packages, CI, File Layouts and XML Publisher Reports and Integration Broker.

Modules: HR, Benefits, Payroll, Time & Labor, LMS, Commitment Accounting, E-Performance, ESS and MSS.

Cincinnati, OH

PeopleSoft HCM 9.1 upgrade & e-Performance implementation

• Savings Plan consolidation. Consolidated 40 plus Savings Plan into 4. Utilized Ben Admin to convert Employees into new Plans based on Eligibility Rules.
• Wrote custom wrapper Programs to Automate Ben Admin for the conversion.
• Worked with Functional team to conduct full conversion test.
• Worked on E-Profile and E-Performance implementation. This includes Profile conversion from Success Factors. Work Centers for Mid-Year Review, XML Publisher Reports for E-Performance implementation.
• Complete documentation of every customization.
• Knowledge transfer to the end users.

Environment: PeopleSoft HCM 9.1, SQL Server, Windows XP, People tools 8.51, People code, SQR, Application Engine, Application Packages, CI, File Layouts and XML Publisher Reports.

Modules: HR, Benefits, Payroll and E-Performance.

Minnetonka, MN

PeopleSoft HCM 9.1 Upgrade

• Developed 20 technical specs with detailed pseudo code.
• Developed/ modified new batch programs using Application Engine and SQR.
• Developed Work Center customization for MAP (Employee Review application) and Contractor Express.
• Developed process to avoid hardcoding of security roles in PeopleCode. Process contains setup page where values are stored. Developed application package to read and store these values using Rowset cache method.
• Completed online enhancements to incorporate UHG’s customizations.
• Modified Paycheck and advice templates to need client’s requirements. This is done by modifying XML, XSD and SQR.
• Developed reports using XML publisher (BI).
• Modified HR accounting line information IB to send confirmed Payroll information to PeopleSoft Financial system.
• Mentor / knowledge transfer all customizations that are completed including PeopleCode, Work Centers and Integration Broker.
• Used HP quality center (QC) for issue resolution.
• Did complete documentation & testing.

Environment: PeopleSoft HCM 9.1, Oracle 10g/11g, Windows XP, People tools 8.51/8.52, People code, SQR, Application Engine, CI, File Layouts, Integration broker, BI Reports and Application Package.

Modules: HR, Benefits, Payroll, Commitment Accounting, ESS and MSS.

Charlotte, NC

PeopleSoft Bonus management consultant

• Technical development consultant working on Bonus management tool.
• Worked on enhancements, fixes, improving performance.
• Converted Objective distribution from online posting to batch (App Engine)
• Converted JCLs from legacy to DTS system.
• Customized reports using XML reports.
• Worked with Business partners to gather requirement, conduct technical analysis, coding & implementation.
• Used Integration broker to send data in real time to Comp Express - 3dr party tool where bonus amounts are stored.
• Created complex Reports & interfaces using SQR programming tool for Comp Express module.
• Mentor / knowledge transfer all customizations that are completed including PeopleCode, Work Centers and Integration Broker.
• Used HP quality center (QC) for issue resolution.
• Did complete documentation & testing.

Environment: PeopleSoft HCM 8.9, DB2, Windows XP, People tools 8.47, People code, SQR, Crystal reports, Application Engine, CI, File Layouts, Workflow, Data mover, Process scheduler. Integration broker.

Modules: HR, Bonus management and Payroll.

Sacramento, CA

PeopleSoft HCM 8.9 Support and Upgrade consultant

• Support PeopleSoft HCM 8.9 Time and Labor, Learning Management system, Certificate and Licensing system, Security.
• Automated Annual Individual development plan system (Employee Annual Review process) in PeopleSoft. Created a Crystal Report to generate the complete form for signing purpose.
• Automated Supervisor Annual / Probation Report in PeopleSoft. Also used crystal report to generate the completed form for singing purpose.
• Worked on several enhancements for Time and Labor and LMS systems.
• Assisted the architecture team in applying several PeopleSoft patches which resolved many T&L issues like duplicate time, in-correct and missing time etc.
• Helped other team members in completing complex queries, PeopleCode etc.
• Worked with DBA to improve performance of T&L time admin process.
• Created Integration broker message to send CALTRANS personal and training information data to department of Human services.
• Modified several T&L Reports using SQR to add additional requirements. Also created several new T&L reports (Overtime monitoring report, Leave hour calculation, Payroll interface Report to SCO)

Environment: PeopleSoft HCM 8.9, Oracle 10g, AIX Unix, Windows XP, People tools 8.47, People code, SQR, Crystal reports, Application Engine, CI, File Layouts, Workflow, Integration Broker, Data mover, Process scheduler,

Modules: HR, Payroll, Time & Labor, LMS, C&L, ESS and MSS.

Fremont, CA

PeopleSoft HCM 8.9 Support and Development consultant

• Support PeopleSoft HCM 8.9 Time and Labor, Learning Management system, Certificate and Licensing system, Benefits, Benefits Admin and Security.
• Helped out Financial upgrade team with reapplying customizations, bug fixing, reports adjustments etc.
• Created new programs to determine employee pension eligibility. These programs are developed from very complex set of business and company rules.
• PeopleSoft. Created a Crystal Report to generate the complete form for signing purpose.
• Worked on several enhancements for Time and Labor and LMS systems.
• Assisted the architecture team in applying several PeopleSoft patches which resolved many T&L issues like duplicate time, in-correct and missing time etc.
• Modified several interface programs using SQR.
• Helped other team members in completing complex queries, PeopleCode etc.
• Worked with DBA to improve performance of T&L time admin process.

Environment: PeopleSoft HCM 8.9, Oracle 10g, AIX Unix, Windows XP, People tools 8.47, People code, SQR, Crystal reports, Application Engine, CI, File Layouts, Workflow, Data mover, Process scheduler.

St. Paul, MN

PeopleSoft HCM 8.9 Upgrade, Support and Development consultant

• Assisted functional team in identifying and resolving errors/issues during testing and UAT phase of the project.
• Worked on completing some upgrade steps and resolved data migration issues. Fine-tuned COBOL programs in Payroll and T&L modules.

Re-applied customizations:

• Time and Labor customizations from 8.3 to 8.9. Worked with DBA to improve performance of T&L admin process.
• Customizations to the Payroll - commitment accounting page.
• Re-created several views due to table changes in 8.9.
• Customized employee review pages and added new validations as per client’s requirement.

Created new app engine(s):

• Load one time earnings, deductions and taxes on to pay sheets.
• Loaded benefits - new rates for Open enrollment. Worked on the confirmation statement program to apply custom changes.
• 3 new programs are created to send employee, payroll and leave information from Met council (PeopleSoft) to Metro transit (Sybase database). Oracle gateway is utilized to send information to Sybase system.
• Reset Benefit Billing and Leave accrual - 2 processes are created to reset Benefit billing and leave accrual processes. This eliminates SQL requests.
• Improved performance on delivered employee refresh program.

Created new SQR programs:

• Identify blanks in PS ACCT CD TBL (T&L), fix them and email results to all the users involved.
• New interface file to Benesyst using SQR and automated the process of FTP using UNIX shell script.
• Performed customizations with E-Benefits and E-Pay module.
• Tax updates – applied tax updated 07b to 07f. Also helped the users to complete year end tasks.
• Created several datamover scripts to restore operators and user quires.
• Mentored junior programmers on the team.
• As part of E-settlements implementation (PS Financials 88) team, worked on customizations, workflow and PeopleCode modifications.

Environment: PeopleSoft HCM 8.9, Oracle 10g, AIX Unix, Windows XP, People tools 8.48, People code, SQR, Crystal reports, Application Engine, CI, File Layouts, Workflow, Datamover, Process scheduler, Shell Scripts.

Modules: HR, Payroll, Ben Admin, Benefits billing, Commitment account, Compensation, Time & Labor and ESS.

Bloomington, MN

PeopleSoft HCM 8.9 

New development: App Engine:

• Paysheet load: Created application engine to read spreadsheet and load data into PS PAY OTH EARNS table. Along with load, created detailed report of the load including processed and rejected processed records with totals by earnings code and employees.
• New program to process mid-year salary increase.
• Consolidated reporting project: New program created to create a consolidated database between 8.9 and 8.8 systems as part of public data management / reporting project.
• Programs to update supervisor field on Job record
• Process to update Job information.
• Tax updates: applied tax update - 07b, 07c.
• New Pension plan: Created program to load new pension plan in general deduction table for all eligible employees. Completed data setup. Applied changes to ddp003 and pay003 programs.

Self Service changes:

• W-4 mod: performed several design enhancements to the self-service W-4 page. Added PeopleCode validations to allow new hires to update W-4 choices thru self-service pages. Inserted specific messages. Modified the workflow to add new fields and messages to the email generated.
• View Paycheck Page: modified SQL statements to correct totals issue.
• Modified/updated workflow messages around Personal name, address, marital status and time tracking.
• Provided day to day support by creating SQL requests.
• Customized quick time entry and time sheet pages according to client’s request. Worked on Time Admin process to improve performance.
• Detailed documentation done for every mod worked

Environment: PeopleSoft HCM 89, Oracle 10g, Sun UNIX, Windows XP, People tools 8.48, SQR, Crystal reports, Application Engine, CI, File Layouts, Process scheduler, shell scripts.

Modules: HR, Payroll, Ben Admin, Benefits, Time & Labor, Compensation and ESS.

Shoreview, MN

PeopleSoft 8.3 Payroll support and development

• Created App engine program for making mass data changes to employee job information. This includes creating a file layout to read file provided by customer and use component interface to make mass changes.
• Created several new reports for financial system (SAP) with payroll information which are run after regular payroll is confirmed.
• Customized quick time entry and time sheet pages according to clients request. Worked on Time Admin process to improve performance.
• Made enhancements and fixes to the existing interfaces and reports for on-going development. The modules include Payroll, Compensation, commissions and benefits.
• New application is created to maintain contractor information in PeopleSoft. This includes creating tables, on-line pages. Application engine program to load historical contractor information.
• Worked on Boston Scientific and Abbott separation project to separate data for Abbott. Key data include Job, Personal data and payroll data.
• Created quires to support Payroll, compensation and commissions customers.
• Detailed documentation done for every mod worked.

Environment: PeopleSoft HRMS 8.3, Oracle 9i, Sun Unix, Windows XP, People tools 8.16, SQR, App Engine and CI. FTP, PGP, Shell scripts, UNIX

Modules: HR, Base Benefits, Ben Admin, Payroll, compensation, commission, Time & Labor and ESS.

Charlotte, NC

PeopleSoft HCM 89 upgrade and development

• Converted SQR Programs and Processes from 8.19 to 8.9. Follow all the steps of customizations and prepare for day one of the upgrade.
• Converted existing E-recruit customizations into 8.9. These include building custom pages, PeopleCode and associated SQR reports.
• Assist on going production support issues with payroll and benefits. Identified and fixed several data issues using SQL and SQR.
• Customized existing T&L SQR’s to add more validations and rules due to union agreements.
• Developed App Engine program to load 2006 pledges for United-way. This application engine uses Component Interface and file layout.
• Created and scheduled a new process for Pleatue (LMS).
• Created quires to support Payroll, compensation and commissions customers.
• Detailed documentation done for every mod worked.

Environment: PeopleSoft HRMS 8.16/8.22.05 HR, Base Benefits, Payroll, Time and Labor, Self-Service applications, Position management, SQR, Application Engine, Component Interface, Oracle 8.i/9.i and Windows XP

Baltimore, MD

PeopleSoft HRMS Consultant

• E-pay / E-Benefits Implementation: Worked as technical consultant. Worked on the E-Pay and E-Benefits pays by modifying to client’s needs. Modifications include Adding custom PeopleCode, Adding additional fields on the W4, W2, and direct deposit pages.
• Customized View Pay Stub/check page by adding a additional secondary page to print the current pay stub in a PDF format. This is achieved by use of ISCRIPT PeopleCode. This customization is done to reduce printing and mailing costs.
• Implemented 401 K plans for new hires. This includes modifying PeopleCode change the options and also run an update SQR program along with delivered COBOL program.
• Position Data Leveling: T. Rowe uses Position management process, wrote Application Engine program to insert new effective date with new 2005 bonus information.
• Parking Program: Application engine created to load data into additional Pay Data table to pay for parking expenses.
• E-Comp Project: Developed 24 reports for the higher-level management committee. These reports contain bonus and performance data of all T.Rowe Associates, for the year. Utilized SQR tool to develop these reports
• Day to day PeopleSoft production support during Payroll week by writing quires either by query tool or SQL.
• PeopleTools Upgrade 8.22 – Involved in PeopleTools upgrade from V 8.16 to V 8.22.05. Upgraded also included Tuxedo and web server upgrade to newer versions. Worked with UNIX admin to install new COBOL complier 2.2. Worked with Oracle DBA to upgrade the Database version from 8i to 9i.
• Detailed documentation done for every mod worked.

Environment: PeopleSoft HRMS 8.19/8.9 Hr, Base Benefits, Ben Admin, Payroll, Time and Labor, Self-Service, Position management, SQR, Application Engine, Component Interface, Oracle 8i, Windows XP, Unix

Hartford, CT

PeopleSoft HRMS Consultant

• Worked as team member in supporting HRMS systems including Payroll, Benefits and Self service systems and Administer Work Force systems.
• Worked on Self Service Module to make several changes which comprises of creating new pages to hold self service information. Wrote custom PeopleCode for all the validations.
• Resolved several T&L issues. SQL are generated to compare data and worked with users to resolve data and logical issues.
• Created several Management reports that are sent to the Vice-President/ HR delivery managers in New York on the last working day of the month. The reports are created using SQR and are scheduled through Main Frame scheduling system CAProds. For this new jobs are created using JCL. Several procs and parts are created to complete the customization.
• Worked on improving performance of base tables like Personal Data, JOB, Escalate table etc. Developed achieving structure for all the tables. Jobs will run on the first working day of the month. These programs will delete past data from the tables writes to flat files and these files are maintained on the main frame.
• Solved 10 to 15 work requests per version month.
• Mentored junior programmer on the team with PeopleTools, PeopleCode, TSO, Endeavor, JCL etc.
• Detailed documentation done for every mod worked.

Environment: PeopleSoft HRMS 8.3 HR, Base Benefits, Payroll, Unix, Time and Labor, Main Frame including TSO, Endeavor, CAProds, NDM, DB2, Oracle 9.i, Application Engine, SQR, Crystal Reports.

PeopleSoft 8.8 CRM Support Implementation – Reports team lead

Responsibilities:

• Worked with the Business users to finalize on the Report designs and helped them understand the reports after they are done. Worked on technical design documentation for customizations to CRM. Worked with Mercury Test Director Tool during testing phase of the project. Documented Report Specs and developed detailed test scripts for all the reports developed.
• Modified existing out-of-the-box Crystal Reports to suit the client’s need; the modifications included changing the query behind the Crystal Report by adding additional fields and criteria; added more input data filers to the run control page.
• Reports used detail Input screens where the user chooses different input selections to obtain the report; every report gives 4 different out puts depending on user input; the programs also created data extract file along with the reports where the data can be further manipulated to obtain specific reports using MS Excel Macro. Incorporated extensive PeopleCode validations to make the application real bullet proof.
• Created Data-Conversion programs using Application Engine (with file object) to load Customer contacts and Accounts from flat files.
• Customized Run Control page where in the PeopleCode uses ISCRIPT object and accepts PDF as report format and WEB as destination location; this code runs the report and produces the output in a new window as and when the report is run successfully.
• Performed Customizations to main Case page; added some additional fields for reopened cases.
• Helped the team in performing stress-testing phase. Helped with Load Runner tool to perform this activity.

Environment: PeopleSoft CRM 8.8 Customer Service Module, Mercury Test Director, Load Runner, PeopleTools 8.4, PeopleCode 8.4, Application Engine, SQR, Crystal Reports, Process Scheduler, Windows XP, Unix, Oracle 9i.