SUMMARY:

• 7 years of experience in PeopleSoft HCM and Financial modules Accounts payable, General Ledger, Purchasing, e - Pro, Inventory, Payroll, e-Benefits, Receivables, Billing, e-Settlements, Commitment Control, Banking, Cash management, Asset Management, Order Management, Financial Gateway and Project Costing.
• Experience in PeopleSoft technical skills such as People Tools (Application Designer, People Code, Application Engine, Application Package, Component Interface, File Layout, Process Scheduler, Workflow, Query, Tree Manager, BI, XML publisher, Data Mover and SQR).
• Strong experience in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports).
• Experience in Peoplesoft 9.2 Benefit Administration, Base benefit and Payroll.
• Involved in developing Inbound Interfaces customizations in FSCMs 8.4 like OM, INV, GL, e-Pro, Billing, AP, AR, PO, RECV.
• Experience in supporting and maintaining PeopleSoft FMS Public Sector and the encumbrance Commitment accounting application 9.0 and People Tools module include Accounts Payable, Travel and Expense, eProcurement, Purchasing, Commitment Control, General Ledger, Asset Management, Project Costing.
• Experienced in PeopleSoft Finance modules like General Ledger, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing and PeopleSoft HRMS modules like HR, Benefits and having knowledge of G/L business process and financial reporting. Also, knowledge of Contracts and Billing.
• Experience in working on PeopleSoft reporting tools like XMLPUB (BI Publisher), PS Query and Workflow technology for notification Frameworks.
• Workability and experience in People Tools (Application Designer, Import Manger, Data Mover, People Code, Security Administrator, Object Security, Maintain Security, SQR, PS/Query and Crystal Reports, Process Scheduler, Application Messaging, Utilities, Application Engine and Upgrade Assistant).
• Expertise in working with PeopleSoft Development and Application tools like Application Engine, PS Queries, People Code, Integration Broker, CI and basic knowledge of XML Publisher.
• Worked with Static and Agile SCRUM Methodologies using Version One, Behavior driven development (BDD) and Test-driven development (TDD) managed custom PS module, which imports customer data from 3rd party application to PeopleSoft AR.
• Managed staff supporting PeopleSoft Financials Supply Chain Management (FSCM) / Procure to Pay modules.
• Experience writing numerous interfaces to 3rd party vendors like Bill interface load to GL, Bill interface load to AR.
• Involved in developing and customizing the reports using the tools PS Query and SQR.
• Created Various SQR Interfaces (Inbound & Outbound) and Reports to load data from external systems into PeopleSoft GL which in result conducts various Chatfield validations, Combo Rules, Trees, derive various values based on the data from the external system.
• Expertise in using available PeopleSoft 9.1 & 9.2 Time and Labor rules and building new Time and Labor rules.
• Expertise in implementation, upgradation, integration, enhancement/customization and production support of workday modules like Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Billing, Invoicing, Inventory, Commitment Control, Project Costing, Purchasing, Grants Management and reporting.

PROFESSIONAL EXPERIENCE:

Confidential - Charlotte, NC

Peoplesoft FSCM Consultant

Responsibilities:

• Provided vision and aligned Compensation, Benefits and HRMS initiatives with organizational priorities.
• Played a role of a functional consultant for People Soft Financials Asset Management, Purchasing, eProcurement, Accounts Payables, Project Costing, Billing, Accounts Receivables, Commitment Control, General Ledgers, Grants, Travel & Expenses modules and requirement gathering.
• Updated monthly international exchange rates for currency converter management. Reviewed and updated accounting policies and procedures for the General Ledger Department. Manage full breadth of general ledger accounting. Setup and maintain the GAIN SharePoint as GAIN SharePoint Administrator. Completed high level financial analysis for executive accounting team to secure future bonds.
• Extensively worked on rule performance and compilation of rules in Time and labor.
• Designed, Developed, Tested and Supported Report using PS Query (End User) and PS/n-Vision (Balance Sheet).
• Developed custom Purchase Order dashboard component to display Requisition, Purchase Order and General Ledger information related to purchase order.
• Worked developing project plan, milestone and requirement document for Peoplesoft benefit administration open enrollment process and its various vendor interfaces project.
• Designed and Developed Several Custom interfaces to AR, BI, PO, AM, Commitment Control, Inventory, AP and GL Modules.
• Assumed added responsibility for developing Crystal reports for HR users, utilizing SQR and Crystal Reports system.
• Developed Test Plans, Test Scripts and Test Cases for SIT and UAT testing for Payroll and Benefit modules functionality and help troubleshoot root cause issues.
• Designed and developed the student course planner, tool to calculate the future terms GPA, Total credits, Academic standing calculations.
• Running on Demand Event Maintenance, Developing Queries, Plans and Production Support for the PeopleSoft 9.2 for under University of NC.
• Work Flow and Security Validation of the Landing Pages for all roles both on Application and Portal Side.
• Implementation of Supply Chain Management Integration with Enterprise Integration, Documentation, Integration and Management.
• Experience in Running Peoplesoft Benefit Administration process Delivered workflow and Reports.
• Resolved using different tools including SQL, PS/Query and Oracle Support to meet required SLA's and satisfy KPI’s.
• Has been operating budget and maintains efficient tracking of financial resources and transactions, including accounting, purchasing, cash management, and payroll.
• Maintained bookkeeper (billing, invoicing, deposits, payments, collections, payroll, taxes, purchasing, estimates using QuickBooks Pro).
• Implemented Crystal Reports and Business Objects reporting for the Bureau of Automotive Repair (BAR) for smog emissions data analysis.
• Utilized Crystal Reports and SQL (including functions, views, and stored procedures) to deliver customized accounting, sales, and operational reports to clients on time-sensitive deadlines.
• Work closely with Human Resources to ensure student new hire and termination dates, pay rate, leave accrual rates and balances, payroll deductions, and related payroll information is complete and accurate.
• Worked on Peoplesoft HRMS for such functions as performance review and talent management, payroll, recruiting and self-service reporting.
• Getting Time reporter data from a third-party system into People soft system using TCD interface and processing the information to generate payable time for employees.
• Writing Various PS Queries according to the Client requirement to compare the Full Time and Part time employees and various Benefit plans, Queries for developing team for the migration changes, Queries for HR team for the Job Data and Employee Data including Prompts.
• Identifying the Errors on the pages using the Application Designer and migrating the custom Projects to other environments.
• Changing the User Roles and Assigning respective User Roles for Testing and Security Actions for the Portal Side Users.

Confidential, CA

PeopleSoft FSCM Consultant

Responsibilities:

• Reviewed and corrected Order Management (OM), Inventory, Billing and Purchasing Configurations in PeopleSoft.
• Worked on BI publisher, SQR, PS Query reports for majority of Custom AP module and few of delivered PO, GL Fund-Balance reports.
• Led portions of the PeopleSoft 8.2 to 8.5 application and tools full suite financials implementation.
• Conducted the Student Financials delta review and fit/gap analysis in preparation of upgrading from PeopleSoft 8.0 Student Administration to 9.0 Campus Solutions.
• Wrote test Cases for PeopleSoft Financial modules (and assisted in automating scripts using Quick Test Pro).
• Developed Test Plans, Test Scripts and Test Cases for SIT and UAT testing for Payroll and Benefit modules functionality and help troubleshoot root cause issues.
• Designed and implemented Application Engine, Integration Broker and CI based solution for Taleo integration
• Purchase commodities and services for various County Departments according to County procurement policies, practices, procedures and regulations.
• Rectified major corrections to ERP systems and corrected them in SQL Procedures and Crystal Reports.
• Worked on FSCM issue/tickets related to purchasing, Account Payable and General Ledger module. Field to Field mapping from Legacy Systems GP, MCF to Peoplesoft.
• Development of XML publisher Reports, Oracle Alerts, for Oracle Receivables and General Ledger for interfaces and data conversion activities.
• Develop Business critical complex components using PL/SQL, XML Publisher reports, AME, OAF.
• Involved in the PeopleSoft AWE Implementation for GL Journal Approvals, Expense Report and Cash Advance Approvals.
• Participated in fit/gap analysis, detailed design, testing and other aspects of implementation of the PeopleSoft HRMS application at various client sites.
• Purchase commodities and services for various County Departments according to County procurement policies, practices, procedures and regulations.
• Designed and developed of PeopleSoft HRMS for HR, Payroll, Base Benefits, Benefits Admin, Time & Labor and Self-Service modules on client specific functionality.
• Created Various SQR Interfaces (Inbound & Outbound) and Reports to load data from external systems into PeopleSoft GL which in result conducts various Chatfield validations, Combo Rules, Trees, derive various values based on the data from the external system.
• Designed and developed conversion and audit programs to convert into PeopleSoft Grants, Contracts, Customers (Grant Sponsors), GL Journals, Purchase Orders, and Item Categories.
• Performed design of reports for the HR, Time & Labor using SQR, PS/Query and Crystal Reports based on organizational needs.
• Customized the online and batch Degree verify Advising transcript reports to access the students in student center.
• Developed complex custom Time and Labor rules to calculate Late In, Excess Meal & short break, where the associates work in cross over shift and and consists multiple login and logout on same day.

Confidential - Dublin, OH

PeopleSoft FSCM Consultant

Responsibilities:

• Configured NA Payroll and Compensation for Business employees as per the client requirements.
• Customized Position Management pages by adding Key Position, Officer and Manager checkbox to test the Business traveler configuration changes
• Gathering client's requirements from system users and administrators about the HR, Payroll Interface, Benefits and Time and Labor related issues and provided recommendations.
• Proposed PeopleSoft functionalities to enhance the current Business Process.
• Worked on SQR interface programs to export data from PeopleSoft tables to flat files.
• Led Student Financials delta sessions to identify new and changed functionality. Researched options to eliminate or modify existing modifications using delivered functionality.
• Developing the PS Queries for Payroll and Configuring the Earn Codes for the Payroll, working on Vacation payout and On Cycle and OFF Cycle Payroll.
• Worked in PeopleSoft Finance modules like GL, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing.
• Ran the Semi-monthly and Monthly Payrolls (On and Off-cycles) by creating Pay sheets, Calculate Pay, Confirm Pay and produced reports
• Configured total rewards statement is used to increase the employee's awareness of the total value of compensation (both salary and benefits). Explained the client in understanding the importance that compensation and benefits are integral to their ability to keep and attract employees who foster excellence in their jobs.
• Work on all project phases including fit/gap, configuration, and testing of PeopleSoft Fluid User Interface.
• Assist clients in fully integrating PeopleSoft Fluid User Interface technology into their current business environments and provide input on best practices.
• Designed Work Center pages for different departments and customized according to the client requirements. Develop the training documents explaining the functionality of Work Centers. Conducted training sessions and explained the purpose and flow of the Work Center usage.

Confidential - Dublin, OH

PeopleSoft FSCM Consultant

Responsibilities:

• Worked on customizations related to critical HR transactions, such as Hire, Re-Hire, Intercompany transfer, promotion, demotion, Termination, supervisor change, full part time change.
• Conducted sessions on Time & Labor and Absence Management for the project team.
• Identified all the Business Process, Desktop reports and evaluated the required Business processes reports in Core HR.
• Replaced some of the SQLs that were run every year during and after the Open Enrollment with config changes.
• Analyzed Open Enrollment procedures for last few years and prepared a document that was to be followed during this year Open Enrollment.
• Performed functional and user acceptance testing for client and corrected and documented the issues.
• Worked with new vendors to gather the requirements for Medical, Dental and vision vendors to design file layouts and develop EDI format files (HIPAA).
• Gathered the requirements and designed solution for receiving the payroll inbound files from different vendors for both US and CAN employees to load payroll deductions.
• Designed solution for one-time deductions and retro adjustments for any adjustments that will be processed by the benefits vendors.
• Made changes to current benefits system to process benefits using base benefits.
• Gathered Business Process Reengineering sessions, created functional flows, created functional specs for customizations for HRMS and Financials Modules.