SUMMARY

• 14 + years of experience in I.T with extensive experience in PeopleSoft as Functional and Business Analyst consultant. Strong functional understanding of the PeopleSoft Financial, Supply Chain & Human Capital Management Applications.
• Extensive experience in requirement gathering, Fit/Gap analysis, Solution design, Business process realignment, development of UAT plan and sign - off documentations, SOX Mega sign-offs, Deployment plan, Post production support, Training and upgrades.
• Strong experience in Interface Design, Data Mapping and Data Conversion.

TECHNICAL SKILLS

PeopleSoft F SCM Modules: General Ledger, AR, Billing, AP, Purchasing, Project Costing, Asset Management,Lease Administration, Commitment Control,Grants and Contracts.

PeopleSoft HCM Modules: Workforce Administration, Payroll and Absence Management.

PROFESSIONAL EXPERIENCE

Confidential, Santa Cruz, CA

Payroll Parallel Testing Lead

Responsibilities:

• The role was similar to my experience in UCSB,Created & provided Time & Attendance file for Payroll Parallel Testing (PPT).
• Created & provided Parking and Transit file for PPT and during production cut-over.
• Provided support for UCPath Pay compute discrepancies identified during PPT and created a feedback loop with UCPath conversion team.
• Identified key conversion data elements and validated Payroll,Absence Management & GL Conversion data until go-live and created a feedback loop with UCPath conversion team.
• Assisted in creating campus Payroll and GL service catalogs.
• Provided post go-live support to UCSB Payroll. Resolving pay issues related to missed time entry, earnings prior to UCPath, employees in multiple pay frequencies, student FICA status and other conversion issues.
• Provided post go-live support to UCSB GL team. Resolving issues related CBR & VLA assessments, Salary Cost Transfers, WorkStudy and Graduate Tuition and fee remission.

Confidential, Santa Barbara, CA

Functional Lead

Responsibilities:

• Involved in full cycle implementation of UCPath 9.2 HCM modules.
• Created & finalized UCPath future state process designs focusing on campus responsibilities & UCPath/UCPC touchpoints. Provided key impacts to the campus communication team.
• Collected & completed configuration items for Payroll/GL modules prior to testing. Updated configuration templates based on test results and business requirements until go-live.
• Provided testing scenarios during Integration & User Acceptance testing. Provided support to testers,provided status updates and communicated defects to the UCPath team.
• Created & provided Time & Attendance file for Payroll Parallel Testing (PPT).
• Created & provided Parking and Transit file for PPT and during production cut-over.
• Provided support for UCPath Pay compute discrepancies identified during PPT and created a feedback loop with UCPath conversion team.
• Identified key conversion data elements and validated Payroll,Absence Management & GL Conversion data until go-live and created a feedback loop with UCPath conversion team.
• Assisted in creating campus Payroll and GL service catalogs.
• Provided post go-live support to UCSB Payroll. Resolving pay issues related to missed time entry, earnings prior to UCPath, employees in multiple pay frequencies, student FICA status and other conversion issues.
• Provided post go-live support to UCSB GL team. Resolving issues related CBR & VLA assessments, Salary Cost Transfers, WorkStudy and Graduate Tuition and fee remission.

Confidential, Santa Barbara, CA

Functional Lead

Responsibilities:

• Involved in full cycle implementation of PeopleSoft 9.1 financial modules.
• Developed a business process for withholding payments for multiple entities including Franchise Tax Board and IRS.
• Assisted extensively in generation 592B quarterly file, 1099 forms and IRS electronic files.
• Used Allocations to create Plant capitalization entries, Federal Interest Output, Overhead calculations and Income accrual journals.
• Designed an interface for feeder system with PC to create Project,Activities,Budgets and Funds Distribution set up.
• Configured rate (Job code and Rate based) based cost generation in PC
• Designed a testing plan for system integration testing.
• Trained users in various functions in PeopleSoft (eg: not limited to: CF setup, Budget/Actual Journal entry, Voucher processing, Tree maintenance, combo edit set up, project budget set up)
• Defined UAT acceptance criteria and helped execute UAT plan.
• Involved in cutover planning and execution.

Confidential, San Mateo, CA

Conversion Lead

Responsibilities:

• Created conversion strategy documents for various modules listed above.
• Provided a strategy to convert KK budgets from department level to project and activity level.
• Ran multiple Mock conversions to test the conversion process defined.
• Assisted business in validating converted data.
• Coordinated testing of converted data with delivered functions and custom processes.

Confidential

Functional Lead

Responsibilities:

• Involved in full cycle implementation of PeopleSoft 9.2 financial modules with full integration with PeopleSoft HCM and Campus Solutions.
• Created configuration workbooks for AM, GL and KK
• Implemented ARO, Capitalization thresholds and automated physical inventory in AM
• Implemented integration between AM and AP for lease payment processing for capital and operating leases.
• Implemented creation of assets from project costing module.
• Implemented Inter/Intra unit accounting and consolidations in GL.
• Integrated generation of journals from HCM and Campus Solutions.
• Designed a AFRS report process to generate OFM report for State of Washington.

Environment: PeopleSoft 9.2, PS nVision, SmartSheet,PeopleTools 8.53

Confidential, San Francisco, CA

Functional/Conversion Lead

Responsibilities:

• Designed and implemented solutions to replace existing chartfields and attributes with new PeopleSoft delivered chartfields.
• Worked with controller’s office and departments and gathered chartfield mapping requirements.
• Created functional design for chart of account mapping tool. Rolled out the developed mapping tool to departmental users and provided training and support.
• Created and maintained project plan on all conversion related tasks.
• Worked with controller’s office to gather conversion validation report requirements and exit criteria requirements.
• Converted General Ledger/Asset Management/Grants/AP/AR data from existing chartfields to new PeopleSoft delivered chartfields.
• Ran validation reports Account balance report, Trial balance report, Capital fund, Loan fund and Research fund balance report and identified items that required reconciliation.
• Reported the reasons for reconciliation items to business users and identified solutions.
• Reconfigured Spreadsheet journals, allocation, combination edits and speed chart definitions.
• Implemented interunit templates for creating balanced entries in interunit journals.
• Converted data from multiple interunit accounts into single interunit account with affiliates.
• Resolved testing data issues and defects in business processes using new chartfields.
• Developed a cut-over plan and ran multiple cut-over rehearsals using that plan to refine the tasks in the plan.
• Converted Balance Sheet and P/L nVision reports to new chartfields. The new nVision layouts used multiple adjustment periods and consolidation business unit.

Environment: PeopleSoft 9.1, PS nVision, SmartSheet,PeopleTools 8.50,SmartSheet SQR, PS Query, PeopleCode, Application Designer, Application Engine, Visio, Oracle

Confidential, Dallas, TX

Senior PeopleSoft Consultant

Responsibilities:

• Involved in planning and executing PeopleSoft FSCM upgrade from 8.9 to 9.2 of General Ledger and Asset Management modules and merging of data from Oracle financials.
• Identified custom objects and its pertaining business processes, compared it against new 9.2 version functions.
• Utilized AWE functionality to redesign journal approval workflow.
• Developed consolidation trees and defined elimination structure in GL and assisted in validation of merged consolidation data.
• Utilized AP integration with Leased asset management to create payment schedules for rents, onetime payment and advance payment types.
• Implemented capitalization threshold limit processing and clearing account reconciliation
• Implemented ARO processing in asset management.
• Created User Acceptance Testing Scripts.
• Developed and tested cut-over plan for General Ledger and Asset Management modules.

Environment: PeopleSoft 9.2, SmartSheet, PeopleTools 8.53, PS Query, PeopleCode, Application Designer, Application Engine, Visio, Oracle

Confidential, Pleasanton, CA

Functional/Conversion Lead

Responsibilities:

• Designed and implemented creation of payable leases in lease administration module using a custom lease rate definition page for various lessors.
• Generated payment transaction and vouchers using delivered lease administration to accounts payable integration.
• Designed and implemented a solution to skip budget checking for vouchers generated from lease payment transactions.
• Created straight-line accounting entries in accordance to FASB 13.
• Converted 250K leased assets and 2K lease contracts. Successfully generated future payment transactions.
• Designed and implemented creation of receivable leases in lease administration module.
• Created customers and mapped appropriate general ledger units and default locations.
• Set up delivered tax tables(Tax authorities and codes) to calculate sales taxes.
• Created billing transaction and invoices using delivered lease administration to billing module.
• Designed and configured a custom allocation set up to recharge rental payment entries from default location and department to custodian location and department.

Environment: PeopleSoft 8.9, PS/nVision, PeopleTools 8.49, SQR, PS Query, Crystal Reports

Confidential, Pleasanton, CA

Senior PeopleSoft Consultant

Responsibilities:

• Two full cycle implementation of Asset management module and two full cycle implementation of commitment control module.
• Worked closely with business to clean up legacy asset profiles and mapped to PeopleSoft Asset profiles.
• Created accounting entry templates for various asset management transactions.
• Worked with procurement teams to build custom asset bundling algorithm and associating assets profile to item categories.
• Designed interfaces between PeopleSoft asset management and HP asset manager (used for asset tracking) system to update location changes of assets to assist in accurate property tax calculations.
• Designed a conversion program and converted more than 800k owned assets.
• Designed asset acquisition,retirement, cost and depreciation reports to aid in generation of PPE reports.
• Designed and configured a custom allocation set up to recharge depreciation entries from owning location and department to custodian location and department.
• Implemented commitment control on all capital purchasing business units.
• Designed a solution to control budgets at project level and track at an activity level.
• Designed and implemented a solution to share budgets across multiple GL business units.
• Converted budgets from legacy project budget tracking tools to budgets in PeopleSoft KK module.

Environment: PeopleSoft 8.9, PS/nVision, PeopleTools 8.49, SQR, PS Query, Crystal Reports, PeopleCode, Integration Broker, Application Designer, Application Engine, Visio, Oracle,TWS

Confidential, Oakland, CA

PeopleSoft Consultant

Responsibilities:

• Two full cycle implementation of General Ledger module.
• Involved in Chartfield mapping and translation of legacy charts. Designed a translation program to convert legacy charts into new chart strings.
• Created current state and future state process flow documents for online journal entry, spreadsheet journal import, interunit entries, journal processing, workflow, and allocation.
• Worked with development team to communicate solution design and assist techno- functionally during the development cycle.
• Worked with system integration testing team to develop relevant testing scenarios.
• Assist development and testing teams in defect cycle process.
• Developing UAT plan- assisting in developing test matrix, identifying users for testing and coordinating dates.
• Assist workforce planning teams in developing roles to position mapping to ensure segregation of duties.
• Developed business process flows and worked with SOX teams to ensure compliance.
• Designed, configured more than 1000 allocation steps to allocate service charges,payroll entries to using departments based on statistics and creating budget entries.
• Designed Journal workflow set up for more than 30 business units at various levels( business unit,ledger and source).
• Designed a standard journal interface layout to be used by third party systems to interface journal data. The interfaced data ran through the translation tool to convert the legacy charts to PeopleSoft chart strings.

Environment: PeopleSoft 8.9, PS/nVision, PeopleTools 8.49, SQR, PS Query, Crystal Reports, PeopleCode, Integration Broker, Application Designer, Application Engine, Visio, Oracle,TWS

Confidential, Washington DC

PeopleSoft Consultant

Responsibilities:

• Involved Global Support and Implementation of PeopleSoft FSCM which included interacting with both management and the users in providing key functional analysis to the project.
• Involved in analyzing end user requirements by conducting report design meetings.
• Created Functional documents and User Training for the custom processes in Global Consolidation module of PeopleSoft.
• Prepared functional specifications in line with account reconciliation reports.
• Created, validated and posted journal entries in GL using pages, spreadsheet journal import and recurring (SJE) entries.
• Participated actively in implementation, customization and testing of various PeopleSoft Financial modules like General Ledger, Accounts Payable and Purchasing.
• Performed analysis with management to understand business processes in GL module.
• Developed detailed project plan and scope for implementation and go live.
• Performed User training, testing and go live for various modules in PeopleSoft.
• Participated actively and conducted Fit / Gap Analysis Sessions for capturing the Business Process requirements accurately.
• Defined new GL Business Units, defined Journal Options, Approval options, and currency options for each new GL Business Unit
• Involved in Chartfield Design, Allocation, and Consolidation in GL Module.
• Participated in designing and implementation of a Journal Upload Process for all bulk non-automated Journal Entries.
• Created User Training documentation for the Journal Upload Process.
• Participated in designing and implementation of Online Journal Entry Template and validation checks for online journal entries.
• Designed and mapped data for a conversion program which reads the data from a flat file and writes it into a file so that Journal load program (GLS9002) will read that data and insert into Journal Tables.
• Troubleshot Journal Generator process for ‘missing Inter-Unit Accounting Lines’, ‘Unbalanced Journal Entries’, ’subscript out-of range’ errors.

Environment: PeopleSoft 8.9/9.0 (GL, AP, PO, AM, AR, BI, Payroll, T&L, Benefits), PS/nVision, PeopleTools 8.48, SQR, PS Query, Crystal Reports, PeopleCode, Integration Broker, Application Designer, Application Engine, Visio, Oracle, Unix/Shell Scripts.

Confidential, Walnut Creek, CA

PeopleSoft Consultant

Responsibilities:

• Participated actively in implementation, customization and testing of various PeopleSoft Financial modules like General Ledger, Accounts Payable, Accounts Receivables, Billing and Purchasing.
• Participated in designing and implementation of a Journal Upload Process for all bulk non-automated Journal Entries.
• Created User Training documentation for the Journal Upload Process.
• Participated in designing and implementation of Online Journal Entry Template and validation checks for online journal entries.
• Designed and mapped data for a conversion program which reads the data from a flat file and writes it into a file so that Journal load program (GLS9002) will read that data and insert into Journal Tables.
• Assisted in Inter Unit Journal Entry setup for General Ledger Journal (GLJ)
• Troubleshot Journal Generator process for ‘missing Inter-Unit Accounting Lines’, ‘Unbalanced Journal Entries’, ’subscript out-of range’ errors.
• Used ‘Ledger Vs Journal Integrity Report (GLS7010) for troubleshooting discrepancies between out-of-sync Ledgers and Journal tables.
• Created various Summary Reports for General Ledger using nVision.
• Worked on to create a schedule of all AM Batch process and tested them.
• Created documents for Conversion maps for all the tables/records in PeopleSoft which shows field level mappings between legacy system tables to PeopleSoft tables.

Environment: PeopleSoft 8.9 (GL, AP, AR, PO, BI, Payroll, T&L, Benefits), PeopleTools 8.47, SQR, Integration Broker, PS/nVision, PS Query, Application Engine, SQR, Crystal Reports, Workflow, Oracle, STAT, Unix/Shell Scripts.