Peoplesoft Techno/financial Functional Resume
Richardson, TX
SUMMARY
- Over 8+years of experience as a HRMS/FSCM techno - functional consultant, with expertise in creating requirements based on client’s needs. Maintenance and Production Support of PeopleSoftHCM/HRMS/FSCM modules (NorthAmericanPayroll, TimeandLabor, HRCore, Self-Services, Manager Self-Services, GL, AR, Contract, Billing).
- Thorough understanding of PeopleSoft FinancialsandSupply Chain Management modules, including AP, PO, GL, AM, Strategic Sourcing, Project Costing, Contract, Billing, Financial Learning Resources, Payment Method, Catalog Structure.
- Strong knowledge & understanding of industry standard methodologies including Software Development Life Cycle(SDLC) and Project Life Cycle.
- Excellent Management and Problem solving skills with thorough knowledge in Application Designer, People Code, SQR, PSQuery, Application Engine, Component Interface, Security Process Scheduler and PeopleSoft Development Tools.
- Has Extensive HCM implementation experience in MSS, ESS, Recruiting, Absence Management, NA Payroll, Time and Labor, Core HR, Benefits, Etc.
- Strong Knowledge on Performance Tuning of SQL, SQR and Application Engine Programs. Played various roles within projects - Team Lead, TechnicalConsultant, Techno/Functional Consultant and Defect Prevention Analysis(DPA).
- Strong collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
- Great understanding towards the needs of the client to provide invaluable support from design to post-production stages.
- Experience in working with Onsite/Offshore model.
- Excellent knowledge in the people tools like Application Designer, People Code, SQR, component interface file layouts and Application Engine Etc.
- Hands on experience in setting up the configurations for PeopleSoft 9.0,9.1 & 9.2 Time and Labor, NA Payroll, GL, AR.
- PeopleSoft SQR experience in Data Conversion to facilitate the migration of data from legacy applications to PeopleSoft using SQR, FileLayout Application Engine and Component Interface.
- Good understanding of PeopleSoft9.2 Time and Labor, Overtime Request process uses the Approval Workflow Engine(AWE) technology, which can automatically trigger workflow notifications.
- Experience also includes Debugging and Performance Tuning of Processes. Well versed with Debugging tools like SQLtrace, PC debugger, and Application EnginetraceforTroubleshooting.
- Expertise in Project Management, Project Scheduling, Project Tracing, Risk Management, and Team Management.
- Good understanding of PIA, App Serverconfiguration, Internet Architecture Process Scheduler, Web Server, Tuxedo and Jolt.
- Conversant with AdministrationTools such as Process SchedulerPeopleSoftSecurity and Data Mover.Strong Interpersonal and excellent communication skills.
TECHNICAL SKILLS
PeopleSoft Modules: PeopleSoft Financials … GL, AR, AP, PO, Inventory, eProcurement, Purchasing, Inventory, Energy & Utilities, Treasury … Enterprise Portal …PeopleSoft-HRMS … Core HR, Time and Labor, Base Benefits, Benefits Administration, NA Payroll, Payroll Interface, Absence Management.
People Tools: Application Designer, Application Engine, Component Interface, Data Mover, Tree Manager, Query Manager, PS Security, Process Scheduler, PS/Query, Import Manager, Application Messaging, Configuration Manager, Process Monitor, Application Package, Workflow, Integration Broker, Process Scheduler, People Code Debugger, etc.,.
Reporting Tools: PS Query, SQR, XML Publisher, BI Publisher
Data Management Tools: Data Mover
Databases: Oracle 9i, Oracle 10g,Oracle 11g, SQL Server 2005, SQL Server …
Programming Languages: People Code, SQL, C/C++, Java
Operating Systems: MS Windows … UNIX.
Microsoft Tools: Visio, Projects, Access, Excel, Word, PowerPoint, and Outlook.
PROFESSIONAL EXPERIENCE
Confidential, Richardson, TX
PeopleSoft Techno/Financial Functional
Responsibilities:
- Designed and configured Chart-fields for Confidential . Modified and customized Chart-field labels to suit Confidential business.
- Configured Business Units, LedgersandLedgerGroups.
- Configured Journal Sources.
- Designed and configured combinationEditsandClosing rules.
- Designed GLJournalApprovalWorkflow.
- Created nVisionBalance Sheet reports. Modified and maintained Income Statements, Trial Balances and Cash flow Statements for existing Business Units.
- Configured new Allocations including Inter-Unit Allocations.
- Configured ACHlayout, Payment sourceandPay-Cycle steps.
- Designed and configured payment handling codes and payment term timing codes.
- Designed and configured vendor categoriesand withholding codes(1099).
- Designed Configured and Tested ACHand check payments with Confidential .
- Designed APVoucherapprovalworkflow.
- 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.
- Configured new Allocations including Inter-Unit Allocations.
- Assisted users in suspense Journal Corrections. Worked with enhanced 8.8 Spreadsheet Loader and Excel to CI utility.
- Performed Month-end and Quarter-endclose. Troubleshoot out of balance-sheets.
- Configured new Journal Source and troubleshoot new GLInterface issues.
Environment: PeopleSoft 9.0, Oracle 9i, Windows XP, Visio, Crystal Reports 11, nVision, PS Query (GL, AP, PO, AM, Expenses, ePro)
Confidential, Dublin, CA
PeopleSoft Techno Functional Consultant
Responsibilities:
- Working as a Functional Consultant for core finance system that includes GL, PO, ePro AP, PC, KK, AM, Contracts and AR modules.
- Responsible for day to day Production support financial issues and Responsible for Enhancements of the modules.
- Recorded Test cases using PeopleSoft Test Framework in Requisition, Purchasing, eProcurement and AssetManagement, Security modules.
- Developed custom PeopleSoft Fluid Applications using PeopleTools.
- Developed PeopleSoftDashboards.
- Involved in Business Unit Consolidation - Setups table set control changes, Interface testing.
- Integrated PeopleSoft subsystems like Asset Management, Account Payables, and Expenses into General Ledger.
- Integrated various interfaces from external systems which generate a flat file and developed customized process to ensure the standard journals are created.
- Setup the File Layout to match the standard journal template and involved in setting up accounting entry definition and journal templates.
- Played an important role in developing excel to flat file conversion to load General Ledger Journal and Commitment Control Journals.
- Worked on the concepts of Accounting Open Periods and its dependency on the PeopleSoftsubsystem validations.
- Developed a GL Daily Reconciliation report that provides information on what is recorded on Journals and what is the PeopleSoftsubsystem expected to pay.
- Experienced in Setting up workflows for Requisitions and Purchase orders using WorkFlow Technology and Route Control Profiles.
- Involved in Purchasing Set Ups including Buyer, Requestor, and User Preferences.
- Integrated Purchasing including Requisitions and Purchase Orders into ProjectCosting using delivered PeopleSoft Interfaces.
- Expertise in developing interfaces to create automating vouchers using Voucher Build Process.
- Involved in coordinating with Data Stage to read the files from the External system and send the data to the Account Payables system to create vouchers using Voucher Build Process.
- Integrated interfaces with PeopleSoftSubsystems like Expenses to read the files and directly create the vouchers.
- Involved in Year End Activities for Tax Reportinginvolving1099.
- Involved in Fiscal year Accrual Activities to accrue the commitment amount from one fiscal year to next fiscal year.
- Experienced in Setting up Projects and Activities using delivered set ups in Project Costing.
- Involved in understanding the interfaces from various PeopleSoft subsystems into Project Costing including Purchasing, Account Payables and Expenses.
- Knowledge on various analysis types coming from PeopleSoft subsystems that determine the remaining budget in project costing.
- Integrated external systems to read the projects and activities from Project Costing and insert into their customized tables.
- Worked on the Excel to CI utility that helps in loading budget into Project costing.
- Worked on various reports to track budgets in Project costing.
Environment: PeopleSoft Financials 9.1, General Ledger, Accounts Payable, AR, Purchasing, Workflow, Application Engine, People Code, Component Interface, PeopleTools 8.44, SQL, nVision and SQR-3, Windows XP, UNIX, Oracle, PL/SQL.
Confidential, Bethesda, MD
Sr. PeopleSoft HCM Techno-Functional Consultant
Responsibilities:
- Involved in preparing the Technical Specification documents from the Functional Specification documents for the Simplex-PeopleSoft Time Attendance Project.
- Developed the Outbound Application Engine Programme to send the daily active employee badge information to the Simplex system.
- Developed the Inbound Application Engine Programme using the File-layout to load the elapsed time (CSV) file from Simplex system.
- Developed the new SQR process, Simplex compare process to load the exceptions into the custom tables we created for this project. An exception is created if there is a difference between the elapsedtime from the simplex system and the payable time from PeopleSoft Confidential the tolerance level set by the Payroll team.
- Developed the Application Engine Programme to send-out the emails to the respective Time approvers if there are any exceptions from the Simplex compare process.
- Developed new Outbound Application Engine Programme to send the Leave Balances (Personal, Vacation and Sick balances) for the Exempt, Non-Exempt and part-time employees from the MBUSACustomerCare department. Created custom views on PS LEAVE ACCRUAL table to pull the leave balances.
- Involved in requirements gathering, interacting with Business Users, and Demonstrating the PeopleSoft XML Publisher capabilities.
- Designed & developed several complex reports using Application Engines and XML Publisher.
- Developed recurrences and assigned them to various Process Scheduler programs to automate them as per the client request.
- Created online Portal Registry Structures, Content References for the newly created or modified pages processes as per the requirements of version 8.49 people tools.
- Created Roles, Permission Lists and User Profiles as part of Security and assigned different roles to various users based on the pre-determined guidelines.
- Coordinated with Developers, Users and Testing Team in successfully implementing the business requirements and customizations into PeopleSoft Application.
- Involved in Performance Tuning of PeopleSoftTimeAdministration process.
- Customized pages for eBenefits to deliverBenefitEnrollment pages Health Plan pages, Managing Insurance Plans.
- Customized pages for ePay to deliver Paycheckinformation, Direct Deposit information, W4 online.
- Worked on various ADPinterfaces like ADPcheck print process etc. to accommodate the proposed customizations from the client.
- Applied the ADP Tax-updates for the 3rd and 4th quarters to the PeopleSoft system.
- Provided the 24/7 Payroll and T & Lsupport to the multiple business units.
Environment: PeopleSoft HCM 9.0, HR, Benefits, NA Payroll and Time & Labor, People Tools 8.49, Windows NT/AIX64, DB2 9.5.
Confidential, Mountainair, NM
Senior PeopleSoft Consultant
Responsibilities:
- Served as one of three PeopleSoft technical developers on Implementation of 9.1 PeopleSoft FinancialsSCM(AP, AM, and GL modules).
- Added a link to Perceptive Software ImageNow imaging application from the PeopleSoft AP, Voucher page.
- Assisted in setting up Vendor website Punch-outs via Integration Broker.
- Modified the delivered ACH and Positive Pay SQR programs as required to meet Gentiva’s and their bank’s requirements for the company’s Accounts Payable function.
- Developed numerous GL and AP interfaces and /or reports in SQR and AppEngine.
- Assisted with Data Conversion ofVendors, Assets, Etc.
- Served as one of the PeopleSoft technical developers on implementation of PeopleSoft9.1 HCM (HCM, Benefitsand Payroll modules).
- Assisted in setting up Web Services (e.g. Payroll Accounting to GL and Vendor Sync) in Integration Broker.
- Developed numerous HR, Benefits and Payroll interfaces in SQR and App Engine, and Payroll Reports in PeopleSoft Query Manager.
- Assisted with Data Conversion and Configuration (e.g. Benefits Vendors, Employee Direct Deposit, Earnings Balances, Garnishments and PTO/Sick Balances).
- Assisted with Control Data Configuration of GLChartFieldCombination codes and Expense Mapping.
Environment: PeopleSoft HCM 9.1 (HR, Payroll, Time & Labor, Benefits), PeopleTools 8.51, PeopleCode, SQR, XML Publisher Workflow, SQL, PS Query, Component Interface, Application Engine, File Layouts.
Confidential
PeopleSoft Consultant
Responsibilities:
- Development & Customization using People Tools in Sales and Marketing Module of PeopleSoft to achieve the Business Requirements.
- Analysis, design, construction and implementation of new PeopleSoft components
- Part of core team for incorporating Customizations and providing support for Out-of Box delivered People Soft CRM.
- Created the Application Packages for inbound interfaces which uses this application package
- Design, development and testing of the assigned enhancements and bugs.
- Prepared technical design documents.
- Fixing the production issues within the agrees SLAs
- Review Design documents and Code along with the test scripts.
- Supported the testing team in resolving functional queries during the testing phase, to check the Data dependency in the PeopleSoft Application
- Preparation of Implementation plans and Migrationchecklistfor pre-migration and post- migration
- Involved in offsite support and production support and enhancement to the application to enable to the proper use of End users
Environment: PeopleSoft CRM, PeopleTools, Crystal Reports 9, People Code, Application Engine, Data Mover, Flow, Security, Application Package, DB2.
Confidential
PeopleSoft Consultant
Responsibilities:
- Applied PeopleSoft knowledge to help business partner analyze data and provide recommendations for business and system related issues.
- Configure PeopleSoft Integration Broker
- Used JBuilder to create mapping
- Provide and consume web services with third-party systems
- Test connector and message processing using the Send Master utility
- Used Transformation test to test the transformation engine
- Used handler tester to test service operations
- Creating an Application Engine Transform Program using J Builder
- Developed a transformation engine for outbound and inbound messages
- Send Master and the Handler Tester Utility Tester utility to test the integrations
Environment: PeopleSoft Financials - Payables 9.0, v9.0 with MP21, People Tools, Integration Broker, People Code, Application Engine, Data Mover, Flow, Security, Application Package, Fusion Middle 2.5 Ware and Seibel CRM 8.2 .