We provide IT Staff Augmentation Services!

Sr. Peoplesoft Consultant/ Advanced Bi Publisher Developer Resume

3.00/5 (Submit Your Rating)

Bethesda, MD

PROFESSIONAL SUMMARY:

  • 8+ years of as a Sr. PeopleSoft Consultant, experienced in all aspects of the product from installation to customization and administration. Expert knowledge and skills in PeopleSoft FIN PeopleTools (8.4x,8.53,8.54,8.55), Tools Upgrades, PS Architecture, PS setup on NT/2000/UNIX, PeopleSoft Internet Architecture (PIA), Web Servers, WebLogic and associated systems.
  • Have worked in diverse applications Sr. PeopleSoft FSCM & HRMS Technical Consultant.
  • Excellent in troubleshooting SQR’s, Application Engine Programs Performance related issues and creating complex reports using SQR, Crystal Reports, and nVision.
  • Have Worked on the implementation Financial/Supply Chain Management modules of Account Payables ( AP ), Account Receivables ( AR ), General Ledger ( GL ), Order Management ( OM ), Cash management ( CM ), Asset Management ( AM , purchasing ( PO ), Billing ( BI ) and Have worked on modules like NA Payroll, Recruiting, Core HR, Benefits, Absence Management.
  • Designed and Tested the Self - service and Manager Customs modules PeopleSoft Fluid UI
  • Hands on experience in Business intelligence publisher (XMLP/BI) and related content.
  • Extensive experience in developing Application Package, Application Engine, SQR, Pages.
  • Experience integrating with PeopleSoft systems using Component interface, Web services.
  • Hands on experience in Integration Broker, Application Messaging
  • Involved in Debugging, testing, and Testing Support.

TECHNICAL SKILLS:

ERP Packages: PeopleSoft FSCM 8.8, 8.9, 9.0, 9.1,9.2, HRMS 9.1,9.2,9.0,8.9, PeopleTools Versions: 8.48, 8.49, 8.50, 8.52, 8.53, 8.54, 8.55

FSCM Modules: AR, BI, AP, GL, PO, Inv, AM, eApplications, CM

HCM Modules: ESS, MSS, Core HR, Benefits, Time &Labor, NA Payroll, Absence

PeopleTools: 8.4x Upgrade Assistance, 8.5x Change Assistance, PeopleSoft Integration Broker/Tools, Application Engine, Application Designer, Application Package, BI/XML Publisher, PeopleSoft Internet Architecture, Administration, Process Scheduler, PeopleSoft Workflow, Component Interfaces, PeopleCode, File Layout, PS-Query and Tree Manager.

Reporting Tools: SQR, nVision, Crystal Reports, BI Publisher (XML publisher) and PS/Query 

Language: PeopleCode, XML, HTML, SQL and PL/SQL

Databases: Oracle8.x/10.x/11g, DB2 and MS-SQL Server 6.5/7.0/2000 ,Toad.

Text Editors: Ultra Editor, Notepad++

Operating Systems: Windows NT/2000 servers, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Bethesda, MD

Sr. PeopleSoft Consultant/ Advanced BI Publisher Developer

Responsibilities:

  • Involved in requirement analysis and prepared requirement design documents and functional design documents according to business user’s requirement.
  • Based on user requirements and technical objectives, identified the interfaces that contain pertinent transactions and determine the impact the new application.
  • Prepared sample prototype as per user’s requirement and functionality.
  • Development of custom XML/BI publisher and RTF reports for employee’s compensation and bonus.
  • Worked on advanced BI publisher RTF techniques.
  • Customized a couple of SQR’s as per client requirement with new effective date changes.
  • Created Application Engine process to generate compensation and bonus reports and make it available in Self-service (ESS & MSS) modules for an employee to review their compensation.
  • Customized/ modified ACA application engine process to generates employee benefits data and HR data files.
  • Created an application to load external attachments to PeopleSoft self-service modules.
  • Created an application engine process to load CSV file data to PS.
  • Modified custom application engine for AP cut off functionality as per requirement.
  • Created PS query that the transaction goes from AP and hit the GL account as per user requirement.

Environment: PeopleSoft HCM 9.2, FSCM 8.9, People Tools 8.54,8.49, Oracle, MS Office products, Utilities (Notepad++), Windows NT/ 2000.

Confidential, Plano, TX

Sr. PeopleSoft Consultant

Responsibilities:

  • Excellent process orientation in performing fit-gap analysis, retrofitting, user interactions, gathering, functional and technical design, configuration, testing, End user training and production support.
  • Expert knowledge in applying fixes & patches, performing upgrade tasks, developing interfaces and converting & migrating data.
  • Involved in Writing Technical Specifications, Development and Testing Support/Defects fixing defects and customizations.
  • Designed and Customized of Employee Self-service and Manager Customs Modules Fluid UI.
  • functional experience HRMS- Core HR, Workforce Administration , North America Payroll, Benefits Administration and Base Benefit.
  • Have extensively involved in customization of HRMS modules including North America Payroll, Core HR, Workforce Admin, Person Model, Base Benefits, Benefits Administration, Compensate Employees and Self Service (MSS, ESS, Applicant, e-Benefits, e-Performance, e-Pay), Recruiting solutions, Profile Management, Absence Management etc.
  • Administer PeopleSoft Security, including ESS and MSS, by troubleshooting and maintaining Security Setup by creating Row level security, Roles, and Permission Lists, and amending the security access based on approved requests.
  • Worked as a payroll production support analyst.
  • Developed audit records for core absence records.
  • Coordinates employee payroll request between unions and payroll for employees on leave of absence. 
  • Created new process for Long Leave and Maternity Long Leave reports it is used by variable pay calculations based on revenue enablers.
  • Extensive knowledge of Payroll, HR, eRecruit, ePerformance, Benefits modules.
  • Implemented AP, AR, BI, AP, Purchasing, GL, AM, and Projects Costing.
  • Development of custom XML publisher and RTF reports in Purchasing (PO) and in Account Payabl e (AP) modules .
  • Developed SQR’s, Application Engine Programs and CI for Conversion, Interfaces, and Enhancements.
  • Involved in the development of an interface between third-party Sale system to PeopleSoft Custom page using CI based Integration Broker service.
  • Presented and Mentored Integration Broker/ Web services providing and consuming using both SOAPUI and RESTFUL service methods.
  • Involved in designing/developing and deployed multiple SOAP Integrations from PeopleSoft to the third party.
  • Developed Programs for Convert Vendors (6.5 million), Customers and Vendor Banking Data.

Environment: PeopleSoft FSCM 9.1/9.2, HCM 9.1/9.2, People Tools 8.53,8.54,8.55, Oracle, MS Office products, Utilities (Toad, WinSql, Ultra Edit), Windows NT/ 2000, Unix.

Confidential, Pasadena, CA

Sr. PeopleSoft Consultant

Responsibilities:

  • Involved in design and development of customizations and enhancements using PeopleCode, PeopleTools, Integration tools and Reporting tools.
  • PeopleSoft HRMS programs which include set-up, testing, parallels, and final outcomes. researchers to solution functional issues within PeopleSoft. Responsible for programming changes to insure legislative.
  • compliance with respect to administration and reporting of respective HRMS applications within PeopleSoft modules. Troubleshoots and problem solve all issues relative to PeopleSoft HRMS modules.
  • Involved in analysis, development/customization of various PeopleSoft modules like Time and Labor, Core HR modules, Benefits and NA payroll modules.
  • Wrote SQRs related to time and labor, Core HR modules, Payroll modules such as track greater than 3-hour shifts, HR Employee Demographic report etc. 
  • Maintain and test PeopleSoft table setups for Ben Admin, North American Payroll, and other modules.
  • Ensure timely implementation of Tax Updates to PeopleSoft HRMS 9.1 system. Tax updates keep the company in compliance with payroll tax laws.
  • Designed and developed conversion programs to load legacy data into PeopleSoft tables.
  • Designed and developed integration broker interfaces for inbound/outbound interfaces.
  • Designed and developed Voucher and GL integration broker interfaces using service operations, app messages, app packages and PeopleCode.
  • Developed custom Purchase Order dashboard component to display Requisition, Purchase Order and General Ledger information related to each purchase order.
  • Customized the AP-Positive pay file as per the client's bank requirement.
  • Involved in configuring and testing the check printer.
  • Customized the delivered check to add company logo and second signature line.
  • Customized the delivered PO SQR as per client requirement.
  • Assisted AP users to Excel voucher upload process and Journal import process.
  • Customized AP and GL XMLP reports as per the business requirement.
  • Configured delivered and developed custom workflow processes using AWE.
  • Configured Requisition, Voucher and Purchase Order approval processes using AWE and developing custom objects.
  • Extensive debugging to find the data integrity problems and data conflict errors.
  • Designed and developed multiple complex SQR, crystal and XMLP reports as per the business requirement.
  • Developed Data Mover scripts to move the data from Development database to QA and to Production Databases.

Environment: PeopleSoft FSCM versions 9.0, 9.1, PeopleTools 8.53, Windows NT/ 2000, UNIX.

Confidential, Lancaster, CA

PeopleSoft Technical Developer

Responsibilities:

  • Primary responsibilities included supporting the day to day operations of version 9.1 PeopleSoft technical PeopleSoft skills.
  • Interacting with clients for business requirements gathering, preparing technical specification documents. 
  • Resolved issues on HCM, Benefits and NA Payroll
  • Worked on Multi-job functionality, Pay data entry, Off-cycle checks etc.
  • Extensive experience in Scoping, Requirements Analysis, Design, Development, and Maintenance of PeopleSoft HRMS for full life cycle projects.
  • Study of current HR processes and identification of GAP/Workaround.
  • Validating the result for UAT and Integration testing to meet the business requirements.
  • Analyzed Human Resources/ Time & Labor/ Payroll/Benefits/ Time Capture business processes work with business owners to achieve consensus for business process changes, and facilitate the transition to best practices as supported by PeopleSoft HCM 9.1,9.2.
  • Worked with PeopleSoft - HCM Core HRMS 9.1-HR, Base benefits, Benefits Administration, vendor Profile, deductions, Earnings, Compensation, calculation rules and NA payroll & its interfaces.
  • Providing Production support for own developed and existing Finance modules. 
  • Modified BIIVCPN process to print custom Invoices as per the client need in BI.
  • Supported in troubleshooting of processes like Payment Selection and Creation, Voucher Posting (AP PSTVCHR) and Payment Posting (AP PSTPYMNT) in AP.
  • Used integration broker to integrate data from HRMS to FMS for travel reimbursement through AP customized Voucher Workflow.
  • Modified a Custom interface AE process in BILLING to eliminate duplicate entries from a flat file and load a single entry to interface tables, and generates a report with all duplicates entries as a batch.
  • Created an interface to load accounting entries from third party systems into account entry in GL.
  • Involved in general user support for nVision reporting, General Ledger, and Accounts Payables modules.
  • Created custom accounting entry table, Journal template and accounting entry definition in GL to load journals from custom accounting entry table into JRNL HEADER and JRNL LN tables.

Environment: PeopleSoft FSCM 9.0, 9.1, PeopleTools 8.52, PeopleCode, Windows NT/ 2000, UNIX.

Confidential

PeopleSoft Consultant

Responsibilities:

  • Involving in Creation/Development and Customization of Records, Pages, Components and Menus, Application Engine processes and File Layouts using Application Designer. 
  • Writing PeopleCode for validating the data in the pages and for implementing the functionalities in the Application. 
  • Development, Customization, and Support for AR, BI, AP, PO and GL modules
  • Involved in technical support and online support in various stages of development to Production environments. Developed Fixes for Issues
  • Written Interface Programs for Data Transfer between Applications using App Engine.
  • Involved in Application and Reports designing. Modified SQR and Crystal Reports solving problems related to reports.
  • Creation and modification of fields, records, panels, PeopleCode and Application Engine Programs. Developed several run control panels to run programs from panels.
  • Worked on various People Tools such as App Designer, Maintain security, Object Security, Process Scheduler, Process Monitor, PS Query, nVision, Mass Change, and App Engine.
  • Involved Data conversion, loaded Invoice, Items and Customers data. Customization of Item Invoice, Orders, and Assignments.
  • Communicated with functional users to map fields from other systems to PeopleSoft System and participated in post-implementation reviews.
  • Created design documents, programmed customizations, interfaces, performed system administration and provided technical support for the business users.
  • Extensively using Process scheduler for setting up the reports to run Confidential a specific time and used Process Monitor to monitor the status of reports. 
  • Knowledge transfer and mentoring to client employees who are new to PeopleSoft.
  • Acquired knowledge of EXCEL to CI.

Environment: PeopleSoft FSCM 8.9, 9.0, PeopleTools 8.49, 8.50, Windows NT/ 2000, UNIX.

Confidential

PeopleSoft Consultant

Responsibilities:

  • Prepare design documents for the requirements and thus enabling Technical Specification
  • Customization of SQR interfaces and reports from 8.9 version to 9.0 version
  • Prepared Technical design documents for Retrofitted SQRs.
  • Worked on Application Engine to validate the conditions in 8.9 and 9.0 versions.
  • Lab testing the application by migrating to sample environments. Monitoring the migration activities during migration to Production. 
  • Worked on performance issues cases.
  • Build new test cases on TAM interface, created new tars and solving them.
  • Extensively worked on different customization and new implementation of both TAM/CG Modules.
  • Adding some additional customization and adding fields on Job Details, Job Posting, find Applicants and Manage Applicants page.
  • Customized/Added Permission lists, Roles, and Users.
  • Generated several Queries using PS Query.
  • Involved in running Upgrade Compare Reports between Demo database and Copy of production before we do the upgrade copy.
  • Read to records and writing to the files by using the File Layout and App Engine. 
  • Involving in designing and customizing the reports using the tools PS Query, SQR. 
  • Created the PeopleCode to implement the business logic according to requirement.

Environment: PeopleSoft FSCM 8.9, 9.0, PeopleTools 8.48, 8.49, Windows NT/ 2000, UNIX.

We'd love your feedback!