We provide IT Staff Augmentation Services!

Sr. Peoplesoft Technical Consultant Resume

Nyc, NY

SUMMARY:

  • 12 Years of Experience as PeopleSoft Techno Functional Consultant in Analysis, Implementation, Design, Development, Upgrade, Production Support and Testing of PeopleSoft Finance and PeopleSoft HCM applications.
  • 12 years of progressive technical experience in Customization, Conversions, Interfaces and Implementation of PeopleSoft 9.2/9.1/9.0/8.9/8.8 Finance (GL, AM, AP, AR, PO, Expense) and HCM (Core HR, Time & Labor, Benefits Administration, Base Benefits and e - modules.)
  • Experience with all PeopleSoft developing tools which includes PeopleCode, App Engines, Application Packages, XML BI Publisher, SQR’s and others.
  • Experience in building pages using Fluid User Interface
  • Experience in Batch Processing, Upgrade, Migration and Interfaces Development.
  • Extensive experience in Integration, well versed in Web Services and Application Messaging
  • Acquired in-depth knowledge of PeopleSoft modules working on production support.
  • Developed various interfaces using applications such as SQR’s and Application Engines.
  • Experience in building new components and customizing existing applications.
  • Proficient in all phases of the systems development life cycle including requirements definition, data conversion, data mapping, system implementation, system testing and acceptance testing.
  • Extensive experience in reporting using various reporting tools such as SQR’s, Crystal Reports and PSQuery and Xml Publisher.
  • Customized various PeopleSoft objects according to the client’s requirements.
  • Documented the processes developed and updated for future references.
  • Efficient team player, ability to multitask with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

ERP: PeopleSoft 9.2/9.1/9.0/8.9/8.8

PeopleSoft Tools: PeopleTools 8.55/8.54/8.53

PeopleSoft HCM Modules: HR, Benefits Admin, Time & Labor, Base Benefits and e-modules

PeopleSoft Finance Modules: GL, AM, AP, AR, PO, Expense

Reporting Tools: PS Query, Crystal Reports, Xml Publisher, SQR

Debugging Tools: SQL Trace, PeopleCode Debugger, Application Engine Trace

Integration Tools: Web Services, Application Messaging, File Layout, Component Interface

Databases: Oracle 11g/10g, SQL Server,DB2, Sybase

Data Management & Batch Processing Tools: Data Mover, Application Engine, Process Scheduler

Administration Tools: Portal Administration, Object Security, Workflow Administration and Query Security

Operating Systems: Windows 95/98/2K/NT/XP, UNIX

Programming Languages: Java, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Sr. PeopleSoft Technical Consultant

Technology Stack: PeopleSoft FSCM 9.2 (GL, AM, AP, AR, PO), Oracle, Component Interface, Application Engine, PeopleCode,, XML BI Publisher

Responsibilities:

  • Integrated PS FSCM and PS HCM with custom Java application (SMART) using Inbound and Outbound web services.
  • Developed custom Application Messages to integrate HCM and FSCM applications
  • Developed custom Fluid pages in PS HCM application.
  • Developed application engine interface to load assets from legacy SCAN system to PS FSCM 9.2
  • Developed application engine interface to load citywide NYCAPS employee data into PS HCM 9.2. Developed interface for both one time and incremental load.
  • Developed application engine interface to load CityTime absence data into PS HCM 9.2.
  • Developed application engine interface to load eligible candidates from legacy DCAS system to PS HCM 9.2
  • Developed several custom XML BI Publisher reports for PS HCM and PS FSCM applications
  • Involved in comparison between 9.2 demo and Copy of production for upgrade.

Confidential, Denver, CO

Sr. PeopleSoft Technical Consultant

Technology Stack: PeopleSoft v 9.1 (GL, AM, AP, AR, PO), Oracle, Component Interface, Application Engine, PeopleCode, Workflow, Crystal Reports

Responsibilities:

  • Responsible for categorizing the PS objects into RICEW (Reports, Interface, Conversion, Enhancements and Workflow) objects.
  • Developed several custom SQRs for AM, AP, AR and GL modules
  • Involved in comparison between 8.9 demo and Copy of production to analyze the technical environment.
  • Involved in analyzing the retrofitting work and retrofitted several objects required.
  • Involved in analyzing the existing technical environment (FSCM) and filter out the unnecessary objects.
  • Created Technical Design Specifications for interface, customization, data conversion and reports.
  • Unit and Integration Test Plan Preparation prepared Test Plans and Test Cases
  • Involved in resolving the upgrade issues from PeopleSoft 8.9 to v9.1
  • Involved in upgrade and customization of SQR's.
  • Analyzed and assessed organizational requirements, in order to successfully develop and customize Workflows for PO approval, Payment approval, monitor overdue accounts.
  • Designed and configured 9.1 AWE (Approval Workflow Engine) to set up multi-level PO approvals based on the amount and PO type (Asset, Expense)
  • Designed and Developed Custom AP workflow for Vouchers with different origins.
  • Designed and developed user test scenarios, test scripts and test data
  • Documented Functional Design specifications and Technical design documents for the business requirements.
  • Involved in setting up the delivered Excel to CI utility to load the data into Asset Management staging tables, AP ship to Locations.

Confidential, Erlanger, Kentucky

Sr. PeopleSoft Techno-Functional Consultant

Technology Stack: PeopleSoft v8.9 to v9.1 (GL, AM,. AP, AR, PO, Expense), Xml Publisher, Oracle, Component Interface, Application Engine, PeopleCode, Workflow.

Responsibilities:

  • Developed Metadata documents for records to help upgrade project team understand record changes in V8.9 and V9.1
  • Documented Design specs and Technical Specs for the custom created modules.
  • Extensively used Change Assistant to apply Patches, Fixes and Bundles.
  • Developed multiple AP Extracts for multiple countries with details like Voucher and payment for a particular day.
  • Coordinated development and testing efforts between functional, technical and user groups.
  • Designed and developed an interface to load the bank details of Global Employees. The bank information comes in the form of flat file and custom programs loads the information in Expense related tables.
  • Involved in troubleshooting AR UPDATE process, which is used to process and update customer balance and history information, corresponding item information and item activity.
  • Customized the Application Engine AP PAYSELECT so that it picks up the vouchers only after the accounting entries have created.
  • Designed and developed user test scenarios, test scripts and test data
  • Developed SQR programs to convert customer set up data from legacy system to PeopleSoft in Accounts Receivables.
  • Developed Payment Interfaces to load payment data into PeopleSoft Receivables from bank transaction files. Designed and implemented payment-invoice matching algorithms to automate payment matching process in PeopleSoft Receivables.

Confidential, Miami, FL

Sr. PeopleSoft Technical Consultant

Technology Stack: PeopleSoft Upgrade and Re-implementation 9.0/9.1(Core HR, Time &Labor, Security), Oracle, Component Interface, Application Engine, PeopleCode, Workflow, Application Messaging, Integration broker, People Tools 8.52., Crystal Reports

Responsibilities:

  • Used People Tools in carrying over the customizations from the existing version to new upgrade version. Extensively used Application Designer for creating new objects, modifying the existing customizations and bringing them over successfully.
  • Developed a SQR’s process which creates hierarchy for employees and contractors based on supervisor to create an outbound file.
  • Worked on various inbound and outbound interfaces based on business requirements.
  • Worked on customizations for delete user, add user, clone user which uses a component interface and application engine for security.
  • Modified the MSS termination transactions for only voluntary terminations and added international logic.
  • Used PeopleSoft delivered Time and Labor rules and also developed and custom Time and Labor rules which included Holiday, Weekly Threshold, Daily Threshold, Day Breaker Rules.
  • Developed outbound interfaces for third party vendor’s, which consisted of employee benefit related data.
  • Fit and Gap analysis/impact of the existing customizations to that of the functionality of the new release.
  • Designed Technical Specifications for both Online and Batch/Interface Programs in client specified format based on the functional requirements
  • Modified existing SQR’s, SQC’s, Views to in corporate and implement the changes.
  • Performed design of reports for the HR, Payroll and Benefits Administration modules using SQR, PS/Query and Crystal Reports based on organizational needs.
  • Retrofitted custom SQR reports for payroll.
  • Analyzed the customizations to the delivered SQR reports and worked with the functional analyst to determine if the customizations need to be reapplied or retired.

Confidential, Boston, MA

Sr. PeopleSoft Technical Consultant

Technology Stack: PeopleSoft Upgrade and Re-implementation 9.0/9.1(Core HR, Time & Labor, Benefits, MSS), Sybase, Component Interface, Application Engine, PeopleCode, Workflow, Application Messaging, Integration Broker, People Tools 8.52., Crystal Reports

Responsibilities:

  • Worked on integration broker to send Accounting line data PAYROLL ACCTG TRANSACTION from HR to Finance.
  • Created a Component Interface to insert a row into UHC NEW HIRE Component when an employee is rehired.
  • Retrofitted PAY003 (Online Check Print) based on UHG requirements.
  • Added logic for Post job save Processing.
  • Worked on retrofitting of custom sqrs like TALX Employment Verification Interface
  • Worked on Integration broker configuration to receive DEPT SYNC data from HR to Finance.
  • Retrofitted and migrated Time and Labor rules from v9.0 to 9.1.
  • Involved in creating an Application Messaging Programs, in order to send an email to the Benefits Administrator, Payroll Administrator when a new employee is hired.
  • Adhere to SDLC steps of Plan, Design, Develop, Test and Migration of the projects.
  • Worked on reapplying the customization in ESS Timesheet.
  • Retrofitted a lot of custom sqr’s Census Report, Anniversary Report and Anniversary Notification to Managers for Table changes in 9.1.
  • Developed, unit tested programs using SQR, Application Engine, Component Interface and Integration Broker for HR, Benefits.
  • Developed Interfaces for Payroll, such as Deduction Calculation: this SQR generates deduction codes for each employee’s benefit plans elected for that particular year; these deduction codes are used by the payroll department to process (Benefits Billing Process) the pay of employees.
  • Created Workflow in order to send information as a Notification when a new employee hired into the company.
  • Documented Unit testing scenarios.

Confidential, Cincinnati, OH

Senior Technical Consultant

Technology Stack: PeopleSoft v8.9 (GL, AM, AP, AR, Cash Management), SQR, Xml Publisher, Workflow, Component Interface, Application Engine, PeopleCode

Responsibilities:

  • Responsible for preparing technical design document, TDD review, code walkthrough, TDD sign off and formulating the design for interfaces and Conversions.
  • Involved in development/enhancement, support, conversion, security and interface design.
  • Developed various PO and AP reports for as part of the roll out.
  • Developed custom AP application to load the service invoices into AP. The custom App Engine makes use of file layouts to read the data, process and load Voucher staging tables. VCHRBLD loads the AP voucher tables during nightly batch process.
  • Modify the application engine to communicate with employees the payment made during the day as well as notify prepay auditors about the expense reports due for approval by 15 working days.
  • Coordinated development and testing efforts between functional, technical and user groups.
  • Worked on requirement gathering, documenting process flow and configuring the Cash Management module and related configuration of AP and GL modules.
  • Lead the business users through design workshops and validation, configuration, testing, and deployment cycles.
  • Set up accounting templates in Cash Management for various accounting events to create accounting entries to send to GL.
  • Set up AP, Cash Management Banks for EFT, Bank Transfer and their Transfer Templates.
  • Configured for Bank Reconciliation (Semi and Automated) and set up the rules to reconcile the Bank Statements with Payables and Receivables and other external transactions and Book to Bank Reconciliation.
  • Integrated AP, AR and Cash Management with external banks and configured settlement through Financial Gateway.
  • Set up Workflow to approve the Settlements and created security Roles and Permission lists for Cash Management Modules.
  • Set up Cash Position Trees and Cash Position Worksheets to analyze the cash positions. Created new queries and reports to view the Opening and Closing Balances and total EFT, Check, ACH amounts of each Bank account.
  • Set up process to load the Bank Statements in BAI2 format to Cash Management, Automated Accounting Process and Fiscal Period end close.
  • Support day-to-day operations.

Confidential, Sterling, VA

PeopleSoft Finance Consultant

Technology Stack: PeopleSoft Finance 8.9 (PO, AP, AR, GL), Application Engine, Component Interface, Application Messaging, PeopleCode, SQR

Responsibilities:

  • Responsible as a primary contact for all production support related issues in FSCM system.
  • Handling the urgent production support activities as and when required.
  • Worked on several enhancements for Account payables, Account receivables and GL.
  • Developed Conversion program using Application Engine and Component Interface for loading open Vouchers from legacy system into PeopleSoft Accounts Payable.
  • Written Technical Design Specs for all of the Interfaces and Reports those were customized or newly developed.
  • Responsible for requirement gathering, preparing the test cases and coordinating with users.
  • Designed developed a custom SQR program to load billing data from mainframe application in to PeopleSoft billing interface tables.
  • Worked on AR DUNNING Application Engine process and performed troubleshooting and fixed issues.
  • Modified POPO005.SQR to get the line and Header comments printed properly. Modified the program to print the Logo and Signatures. Helping user in overcoming issues with PO Build Process.
  • Customized AR Aging reports like AR30001, 30002 as per the User Requirements.
  • Developed Test scripts for additional processes in PS AR such as Pending Items creation, Receivables update, Deposit Entry and Payment application through worksheets.
  • Customized queries inside BIIVCEN.sqr when it's extracting from extract invoice tables before printing crystal reports like BIPRNT00 in Billing.

Confidential, Phoenix, AZ

PeopleSoft Finance Consultant

Technology Stack: SQR, PeopleCode, Application Engine, Component Interfaces, SQL, PS/Query, Query Manager, Sybase

Responsibilities:

  • Responsible for development work for this upgrade project.
  • Closely interacted with the customer and business analysts during fit-gap analysis between the as-is and to-be systems.
  • Was involved in analysis of compare reports and identification of customizations to the existing system.
  • Was involved in providing valuable inputs in preparation of the technical design documents for multiple development work and the retrofitting of existing customizations.
  • Resolved several challenging issues encountered during the multiple phases of project execution.
  • Was accountable for the design and development of several critical deliverables.
  • Designed the interfaces between AP Banks and Cash Management for Bank Reconciliations and configured AP External Banks for Checks/ACH/Positive pay.
  • Customized process and reports in Application Engine, PeopleCode, Component Interface, Integration Broker, SQR, Crystal Report, XML Publisher, DMS and SQL.

Confidential, Tampa, FL

PeopleSoft Finance Consultant

Technology Stack: PeopleSoft HCM 8.8, HR, Payroll, Time & Labor, Benefits, SQR, PeopleCode, SQL, Oracle, Windows, PS/Query, Query Manager, Query Viewer and Toad.

Responsibilities:

  • Responsible for Implementation of HCM Modules Payroll, Benefits, Time and Labor.
  • Wrote SQR reports right from Scratch in Benefits.
  • Modified the existing interface reports using SQR’s to interface Benefits with AR.
  • Designed, implemented strategy for loading data from Legacy HR system into PeopleSoft HR core tables.
  • Involved in Customization of Health Plan, Disability Plan, and Life & AD/D plan Benefit panels in Benefits.
  • Wrote Interface reports using SQR’s to interface Payroll with GL.
  • Created Pay Groups for employees with different sets of earnings benefits and attached PeopleCode in the record definitions and at panel levels for validations.
  • Wrote conversion reports using SQR’s for mapping and dumping data from Legacy Systems into the existing system.
  • Supported reports and Benefits, HR, Payroll interfaces like Aetna, MetLife, Cigna Healthcare, New Hire and Department Change report, Pay Sheet Upload.
  • Used PeopleCode Debugger for debugging PeopleCode.
  • Involved in Development and Customization of on-line panels and Menus using PeopleTools and PeopleCode for assigning Employee ID’s, entering Personal Data, Employment and Job Data.
  • Involved in customization of Task fields in Time and Labor.
  • Modified existing SQR reports used for verification purposes in PS Time and Labor.
  • Customized several work group rules panels in Time and Labor.
  • Modified several SQR’s, scheduled them using Process Scheduler and developed reports using Crystal, PS/Query.
  • Created SQR reports to export data to Excel.
  • Involved in the performance tuning of App Engine programs and PeopleCode.
  • Generated ad-hoc reports to update data in tables.
  • Worked extensively on PeopleTools to setup the employee data security by creating Security Views to restrict or grant access to end user to Employee Data.
  • Used Import Manager to move data into PeopleSoft system from the flat file after data mapping and performed system edits as per the user specifications.

Hire Now