We provide IT Staff Augmentation Services!

Peoplesoft Techno-functional Consultant Resume

3.00/5 (Submit Your Rating)

San Antonio, TX

PROFILE SUMMARY:

  • Around 6+ years of experience in Implementation, Upgrade and Development of PeopleSoft Financials modules like General Ledger, Account Payables, Accounts Receivable, Purchasing and Billing.
  • AR/Billing Functional SME assisting with conversion of Accounts Receivable from Lawson to PeopleSoft. Duties include configuration of Billing and AR for the new Business Units, advising on Customer conversion, of end users, and advising on Business Process changes.
  • Peoplesoft 8.9 to 9.1 Upgrade - Fit Gap analysis, creating functional and technical design documents, configuring new functionality, developing/retrofitting HR, Payroll, Benefits self-service and MSS applications.
  • Excellent Knowledge of PeopleSoft Financials (GL, AP, AR, AM) PeopleSoft Distributions (Billing, Purchasing, Inventory and Order Management), Supplier, Travel and Expense and Asset Management and PeopleSoft Project Costing, Contracts and Travel & Expenses modules.
  • Extensively worked on Application Designer, People Code, Application Packages Application Engine, AWE, Security, Portal, Query, File Layout, Process Scheduler, Tree Manager, Data Mover, Custom Interface and Reporting tools (SQR and BI Publisher).
  • Extensively used SQL and PL/SQL for writing Stored Procedures, Functions, Triggers and Packages.
  • Currently working on upgrading PeopleSoft AP & GL from 9.1 to 9.2 which include Fit-Gap analysis.
  • Used Job, personal data, employee tax data, Time and Labor component interfaces to insert the employee related data into PeopleSoft using Integration Broker custom messages
  • Providing technical assistance to Tribal 638s and precise interpretation of the ACA as mandated.
  • Strong understanding of RDBMS concepts and experience in database design and development.
  • Configured the Payment Terms, Entry Types, Letter Codes, Aging ID, Statement ID in AR module
  • Expertise with PeopleSoft FSCM 9.2; 9.1; 8.9; 8.x and People Tools 8.51; 8.50; 8.48; 8.47, 8.49 in changes assistant.
  • Experience spans in developing and analyzing requirements of various HR modules like Core HR, Base Benefits, Ben Admin, NA Payroll in of Business Systems Analyst and various Consulting roles with diverse clients. Having good experience on benefits and payroll.
  • Worked with GPI Team in Data Mapping and Data Cleanup of AP Vendor and Historical Payables Data.
  • I have worked in various Implementations, Upgrade & Support projects of PeopleSoft FSCM 8.8 to 9.2
  • Used to PeopleSoft Application Designer's Project Copy functionality to copy integration metadata between PeopleSoft databases.
  • Experience developing complex interfaces into legacy and 3rd party systems
  • Experience in SQL and PS/Query for reviewing data, troubleshooting and testing/validating source system data.
  • Responsible for filing 1095¬C and 1094¬C tax forms for "escalated" and "top 100 revenue" Paychex clients that met the Affordable Care Act requirements established by the IRS
  • Expertise in Business Analysis, Business Technology Optimization, Process Management, Software Design, Analysis, Data Modeling and Testing of PeopleSoft solutions.
  • Extensive experience in documenting Use Cases, Business Requirements Document (BRD), Functional Specifications Document (FSD), Test Specifications/Plans, and UI Navigation Documents.
  • Excellent skills in Development of applications using SQL, PL/SQL, Oracle Database 11g, 10g, 9i. DB2. Having good understanding of Workflow, SOAP, Web Services, and Enterprise Portal.

WORK EXPERIENCE:

Peoplesoft Techno-functional Consultant

Confidential, San Antonio, TX

Responsibilities:

  • Developed time schedule and strategy for development, testing, and quality assurance for the following projects: Cost Management System phase II, People Tools upgrade, and multiple PeopleSoft application bundle upgrades. Work with team members to meet the milestones per the schedule.
  • Prepared and executed strategy for cutover and deployment of IT projects, including responsibility for preparing cutover checklists and running mocks to provide task implementers with hands-on experience in preparation for go-live, coordinate UAT and resolve issues.
  • Performed monthly maintenance on Cobol Tables (both shared/non-shared) and completed performance- related maintenance such as archiving messages to reduce system load, etc.
  • Extensive experience in developing interfaces with various applications using different technologies like XML, flat files, SQR, etc. In-depth knowledge of Oracle database and portal environments. Performed development using new tools and technologies to fulfill business requirements.
  • Fit gap analysis of the acquired company’s business processes with WM’s existing business processes and Establish business units, Distribution Codes, journal sources and accounting entry templates.
  • Configure and Customize Allocations logic for monthly journals to create based on dynamic pool data coming from third party systems.
  • Used integration broker to integrate data from HRMS to FMS for travel reimbursement through AP.
  • Involved in extensive PL/SQL scripting for validation of the input data.
  • Involved in retrofitting the customize objects of NA Payroll and benefits as per PeopleSoft 9.2.
  • Expertise in the development of Conversion and Interface programs using SQR, Component Interface and Application Engine, Integration Broker.
  • Worked on setup procedures for Reconciliation process in AP and customized Pay Cycle Manager in AP for business needs.
  • Implemented approval workflow for general ledger and customized workflow for interunit journals.
  • Learned the functional concepts of NA Payroll and resolved the issues which we faced while running the payroll jobs and NA Payroll.
  • Expertise in enhancements and issue resolution including technical and functional understanding of the Application and good knowledge of processes like APPBVCHR, Pay Select, Voucher and Payment posting in AP, Transaction Loader, Depreciation Calculation and Accounting Entry creation process in AM, PC to AM process, AP to PC process and Journal generator (FSPJGEN) from all Financial modules to GL, etc. Experience with processes in COBOL SQL, Application Engine, SQR’s and People Code.
  • Knowledge of Application functionality and technical helped to resolve or develop new functionality.
  • Changed and ran DMS scripts to fix stored statement errors related to Allocations, GL edit and GLPPOST processes in GL.
  • Analyzing the current FSCM system as per the reporting requirements of client and their integrations with external systems using Agile methodology.
  • Configured ImageNow to Integrate PeopleSoft with Imaging System so Users can Enter and Store Receipts.
  • Requirement gathering and functional design of new enhancements in Payroll, Benefits, Compensation and Core HR area.
  • Created more Non-shared Temp tables to improve performance of online GL Edit. This enabled the system to avoid using the shared table as often. Performance increased dramatically after the change.
  • Fixed/Enhanced application features to address issues occurred and resolved them by making changes in Application Designer for PS Objects, Application Engine, SQR’s and DMS scripts, etc.
  • Worked extensively on Application Engines, Component Interfaces, Application Packages, Approval Work Flow Engine, Integration Broker, Excel2CI, SQL, SQR and PS Query.
  • Developed GL Interface that loads data from various external systems into PeopleSoft General Ledger using SQR, which includes implementing complex business rules like Combo Rules, subtotals on Business Unit level, grand totals, error handling procedures, printing multiple output reports maintenance report and processed file report.
  • Involved in day to day production support for all the financial modules like AR/BILLING, AP, EXPENSE, GL.
  • Developed several GL SQR reports such as Daily Transactions by Dept, Daily Transactions by Account, Statement of Condition (Daily, Monthly) and Earnings reports (Daily, Monthly).
  • Handled BI, AP, PO and GL production issues.
  • Integrated, Designed, Developed interface programs for Travel Expense module with Accounts Payable for payments of employee expense reports.
  • Developed outbound interface to send GL Actuals and Budgets data in a pipe-delimited file.
  • Built custom Application Engine programs to stage expense and time entries to PC EMP RES TM table those are to be pulled into Projects.
  • Resolved GL, AP and BI month end close issues.
  • Modified invoice print programs for specific requirements.
  • Developed Payable Interface for uploading the custom Invoices in to AP using component Interface.
  • Configured and Customized PC AP TO PC process as needed by the project team to capture the details of Category based on the accounts.
  • Developed Projects Workflow and maintained with enhancements.
  • Category search functionality has been added on the PO line.

Peoplesoft Consultant

Confidential, New York, NY

Responsibilities:

  • Worked as a techno functional consultant for the support and enhancement of PeopleSoft Financial Applications.
  • Designed, Configured and developed Integration Broker xml messages to load data from third party systems Ops Technology to AR/BILLING modules. Which includes creating setup, develop message people code and testing, documentation of web services technology.
  • Worked on AWE Approval workflow engine to setup workflow for approving expense, vouchers.
  • Designed and developed interfaces for Accounts Payable using Integration Broker messages, and Application engine/file layout for file-based integration.
  • Working as a PeopleSoft Techno-Functional SME in FSCM by handling Day-to-day Production support activities.
  • Involved in design and development of conversion programs using SQR for transferring of data from legacy system to PeopleSoft HRMS.
  • Worked on developing, tuning and testing Oracle SQL's.
  • Applied patches, bundles and maintenance packs to the PeopleSoft systems.
  • Implemented T E expense rules for reviewing and Prepay auditing expense reports.
  • As a Techno-Functional Consultant involved in the analysis of Core HR & Payroll modules.
  • Responsible for the Implementation of Expense module for UDR Inc.
  • Designed customized custom approval processing for Expense processing and reporting.
  • Developed Several Custom Validations that need to be Done Prior to Expense Report and Cash Advance Submission
  • Designed and Developed interface programs for PeopleSoft General Ledger with Hyperion reporting system.
  • Work on outbound interfaces for benefits providers Using PeopleSoft Application engine and File Layouts.
  • Extensively worked on integrating Accounts payable data with PNC Banks for payments to Vendors.
  • Designed and configured workflow for Approving Vouchers in AP module.
  • Extensive experience in developing and customizing reports using PeopleSoft Query, SQR, Crystal Reports and nVision
  • Designed and developed custom XML Publisher reports for AP, AR/BILLING, PURCHASING, EXPENSE and GL modules.
  • Resolved expense workflow issues for HR supervisor, Prepay auditor approvers.
  • Designed and developed XMLP reports for AP, EXPENSE, GL modules.
  • Configured and developed programs for reconciliation of payments with Banking and AP module.
  • Resolved Asset Transfer issues for Asset Management between different Business Units.
  • Trained business users for the custom processes in AP, AR/BILLING, EXPESNE module.

Business Consultant

Confidential, San Diego, CA

Responsibilities:

  • Participate as a technical consultant in PeopleSoft projects in the technical / infrastructure area.
  • Customization of on-line various Records, Pages and Component definition according to the client’s requirements by using application designer.
  • Day to day support to the PeopleSoft HRMS system.
  • Prepare the Technical Design Documents for the enhancements.
  • Resolved technical requests raised by Client as fix.
  • Analyzed and developed SQR programs, People Code, Application Engine programs.
  • Developed Run control Pages as per corporate requirements and attached to menu to run the SQRs online through Processes.
  • As a Technical Consultant involved in the analysis of keep/drop sheet of the TAM, Core HR &Payroll modules.
  • Implemented approval workflow for EFT and WIR in cash management and deal management.
  • Used App Engine, File Layout and Component Interfaces when inserting data into PeopleSoft Tables comes from Third Party Customization as well as new enhancement in existing system.
  • Did the analysis of existing customizations, conversion, interfaces, and report programs and identified the changes that needed to be made and documented the impact from technical perspective.
  • Involved in converting data from Legacy system to PeopleSoft using Application Messaging, Component Interface and Application Engine.
  • Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People Code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
  • Developed Crystal reports for Business users to enter HR Forms job data.
  • Customized Application Engine to generate Crystal report for succession planning report, employee Interim and Year End performance.
  • Prepared the test cases for the issues fixed and verifies the code in different scenarios.
  • Work on high priority code fixes and new enhancements.

Business Analyst

Confidential

Responsibilities:

  • Involved in the Customization and analysis of Payroll Reports.
  • Implementation of Change Requests.
  • Involved in the testing of e-recruit modules
  • Create Application Engine with Component Interface with data migrations Competency information
  • Creation of application engine programs with file layouts for outbound interfaces for Fidelity benefits data-based interface
  • Support for Stock and Benefits Modules.
  • Provided BRD for AP payment register report to make changes related to company name, amounts and other fields.
  • Enhancements Worker's compensation process SQR report, ISERP Sheltered employee retirement program are some of the processes modified.
  • Design of core HR data migration interfaces Job data, Personal Data and Benefits.
  • Customizations related to component interface for processes involving mass updates.
  • Analyze PeopleSoft workflow and emailing requirements Based on self-service ESS MSS.

We'd love your feedback!