PROFESSIONAL SUMMARY:

• PeopleSoft certified HCM, EPM and FMS developer.
• SQL Server and Oracle certified SQL developer.
• US Federal Security clearance.
• More than 15 years of experience in development and consulting on Peoplesoft Applications.
• Production support, design, implementation, coding, testing PeopleSoft ERP Modules.
• Customization PeopleSoft reports using Hyperion, SQR and Crystal Reports.
• ORACLE, DB2, MS SQL Server development using SQL and ODBC drivers.
• OLTP, Warehousing, ETL data processing experience.
• PeopleSoft version and platform upgrades.
• Data migration between client’s and PeopleSoft databases.
• Experience with gathering and analyzing user requirements, performing fit/gap analysis and prototyping.

TECHNICAL SKILLS:

Software Tools: PeopleSoft Application Designer, BI (XML) Publisher, Workflow Approval Engine, Integration Broker, PeopleSoft Query, Crystal Reports, SQR, nVision, Mass Change, Data Mover, Process Scheduler, Application Engine, T - SQL, PL-SQL

Peoplesoft Modules/ HCM: Time and Labor, Payroll, Position Management

FSM: General Ledger, Asset Management, Accounts Payable, Accounts Receivable, Treasury, Performance Management, Order Management, Inventory, Billing, Project Costing, Allocation Manager.

EPM: Budgeting Planning, Warehouse Data Marts, Data Loader, Global Consolidations.

Warehouse ETL Tools: IBM Websphere DataStage, Informatica

Programming Languages: People Code, Peoplesoft Application Packages/Classes, SQR, COBOL

Data Bases: Oracle, DB2, MS SQL Server, Sybase

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco.CA

Peoplesoft Consultant

Tools: PeopleTools 8.54, Application Engine, PS Query.

Responsibilities:

• Functional design and implementation of Confidential of from elapsed time processing to Kronos based Punch Time Clock.
• Configuration of Time & Labor tables to setup Shift, Schedule, Workgroup data and development of migration scripts to propagate changes to the production instance.
• Development of the Punch Time Clock rules using Peoplesoft Time & Labor Rule Processor. Creation Time & Labor custom rules as well as usage of delivered template rules.
• Troubleshoot development issues in the Time Administration process using AE Trace and stage data in the temporary tables.
• Integration Absence Management data into Peoplesoft Time & Labor Module.
• Implementation of PS Query to compare payable time of the elapsed and punch schedules. PS Query results were presented as excel report with side by side comparison.
• Development PS Query reports for verification and analyses of Time Administration data.

Confidential, Portland, OR

Peoplesoft Consultant

Tools: PeopleTools 8.54, Application Engine, SQR, PS Query, PeopleCode, BI (XML) Publisher, Workflow Approval Engine.

Responsibilities:

• Time & Labor, Benefits Administration upgrade 9.1 to 9.2. Resolving rules issues related to the new design
• Created Time and Labor custom module for electronic transmittal of school coaches punch carts.
• The process was designed to transform paper forms to electronic data entry.
• Implemented using PeopleCode, SQR and Workflow Approval Engine.
• Developed improvements and customizations for HCM Workforce Development Module.
• Improvements were targeted to reduce support efforts and make the module technical support free in the future.
• Provided customizations for HCM Contract Payment Interface (CONTPAY1.SQR).
• Improved Contract Payment calculations logic and created PS Query Tool reproducing the same calculations and used as verification method.
• Implementation of Benefits 9.2

Confidential, CA

Peoplesoft Consultant

Tools: PeopleTools 8.4, Application Engine, Integration Broker, Allocation Manager, Data Manager, PeopleCode, Oracle, PL-SQL, nVision, Component Interface

FSM Applications 8.9 - 9.1: General Ledger, Accounts Payable, Accounts Receivables, Planning & Budgeting, Projects

Responsibilities:

• Worked as a Technical Lead with hands-on the upgrade of Accounts Payable 9.0 and General Ledger 9.0 modules from 8.9 version.
• Designed and configured chart-fields for the new version 9.0 of Peoplesoft Financials.
• Modified and customized chart-field labels to suit client’s business.
• Configured Business Units, Ledgers and Ledger Groups.
• Configured Journal Sources.
• Designed and configured combination edits and closing rules.
• Provided post migration support on debugging invalid combo edits.
• Designed and implemented GL Journal approval workflow.
• Created nVision Balance Sheet reports. Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing Business Units.
• Configured and implemented new Projects Allocations including Inter-Unit Allocations of the Forecasted Budget.
• Configured and coded ACH layout, payment source and pay-cycle steps.
• Designed and configured payment handling codes and payment term timing codes.
• Designed and configured vendor categories and withholding codes (1099)
• Designed, configured and tested ACH and check payments with Confidential and Confidential .
• Designed AP Voucher approval workflow.
• Created nVision Balance Sheet reports for new Business Units.
• Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing Business Units.
• Maintained Business Units and Accounts reporting trees using Tree Manager.
• Assisted users in suspense journal corrections. Worked with enhanced 8.8 Spreadsheet Loader and Excel to CI utility.
• Performed month-end and quarter-end close. Troubleshot out of balance Balance-sheets.
• Configured new Journal Source and troubleshot new GL Interface issues.
• Worked on Peoplesoft Planning & Budgeting 9.0 upgrade. Module customization to provide multi Business Unit handling in the same Budgeting Model.
• Developed PS custom application module to handle “Quarterly Federal Budget Forecast”.
• The module consisted of rule based setup, batch processing, on-line page based analytical tool and BI XML reporting functionality.

Confidentail, Plesanton, CA

Peoplesoft Support Consultant

Tools: PeopleTools 8.4, Application Engine, PeopleCodeHCM Applications 8.8 - 9.0: Time & Labor, Payroll, Absence Management, Benefits, Core HR

Responsibilities:

• Resolved day-to-day production tickets in HR and Payroll.
• Upgraded SQR’s, PeopleCode to 9.0 based on 8.8 customizations.
• Retrofitted Time & Labor and Payroll based on new requirements and customizations.
• Created customized Application Engine programs based on user requirements.
• Developed PeopleCode to customize the delivered objects for HR records.
• Worked on several customs Table Audits and created Test scripts for functional test.
• Suggested and fixed the Payroll Interface COBOL time-out issues.
• Configured and maintained all the tables involved in Payroll processing, such as Pay calendar, JobCode, Deductions and Processes such as Paysheet creation, PayCalc, Payconfirm, Tax Tables etc.
• Supported weekly and biweekly payroll with functional team and error solving.
• Developed interface to send payroll deduction information to 3rd party vendors.
• Applied tax updates and retrofitted customizations after each tax update.
• Automated process to add new pay groups to all the customizations.
• Identified Uni-code problem in data, which crashed the COBOL process called by the Payroll Interface.
• Developed custom error messages on Benefits records and pages to hide beneficiary information based on different Plan Types.
• Retrofitted several views to carry forward 8.8 customizations to 9.0.
• Created Unit test scripts to test the business functionality for the delivered code based on the requirements.