We provide IT Staff Augmentation Services!

Senior Peoplesoft Technical Developer Resume

2.00/5 (Submit Your Rating)

St Louis, MO

PROFESSIONAL SUMMARY:

  • Qualified Certified professional with over 8+years of experience in all stages of systems development life cycle including business requirements gathering, design, data conversions, programming, system / integration / user acceptance testing, documentation and exclusive experience in PeopleSoft Financials and expert level Skills in PeopleTools. implementation, upgrade, writing interfaces and administration of PeopleSoft Financials/SCM (GL, EX, BI, ePro, KK, OM, PO, AM, MM, RM, PC, Grants, AR, AP, SF, INV).
  • Production Support and Technical Experience in implementation of PeopleSoft Grants, Project Costing, Billing, Accounts Receivable, Sales Order Management, Inventory, eProcurement, Asset Management, Purchasing, Accounts Payable.
  • Experience in implementation, upgrade, writing interfaces and administration of PeopleSoft HRMS/HCM (PayRoll, Time and labour, Benefits administration, Employee Self - Services, Manager Self-Services, eBenefits, ePerformance, eCompensation).
  • Expertise in Inventory, Purchasing and Order Management modules.
  • Extensive IT experience in Java and J2EE Technologies including Web Services, Servlets, JSP, JDBC, XML, HTML, CSS.
  • Experience in writing PL/SQL queries, Stored Procedures and Triggers and have exposure to different databases, includes SQL Server, Oracle, DB2.
  • Worked with reporting and analyzing tools such as XML Publisher, Feed publishing Framework. Used PS/Query, Connected Query and Tree Manager for reporting purposes to fulfill company’s specific needs.
  • Created specifications and programmed interfaces to and from PeopleSoft system to satisfy business requirements.
  • Specialized in data extraction interfaces and conversion from legacy to PeopleSoft applications.
  • Extensively worked with People Tools such as Application Designer, Approval Workflow Engine, Application Engine, Integration Broker, Application Messaging, SOA architecture, Component Interface, Configuration Manager, Application Engine, People Code, Security, Tree Manager, Process Scheduler, Data Mover and Query tools.
  • Created, updated, tested and migrated PeopleSoft nVision layouts and queries.
  • Extensive experience in writing Interfaces between PeopleSoft HRMS and Financials.
  • In depth understanding of the Software Development Life Cycle (SDLC) including QA analysis, planning, execution and test management.
  • Experience in preparation of Technical Design Documents, Development, Unit Testing, User Acceptance Testing and production support activities.
  • Worked intensively with Security Administrator to implement Row Level Security, Single Sign on, LDAP integration, Creating Roles, Permission Lists, User Profiles, Portal Security and Definition Security.
  • Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization, and new development.
  • Proficient in gathering and analyzing requirements to successfully design applications based on user needs.
  • Proficient experience in Healthcare applications.
  • Strong working knowledge on PeopleSoft Test framework.
  • Provided extensive production support to HR, PeopleSoft Financials/SCM modules.
  • Ability to deliver the best even in the most critical phases of the project.
  • Possess excellent communication skills, zeal to adapt to new technologies and good Team Player.

TECHNICAL SKILLS:

ERP Module: PeopleSoft Financials (8.0/8.4/8.8/9.0/9.1/9.2 ), PS Financials (General Ledger, Accounts Payable, Purchasing, Accounts Receivable, Billing, Commitment Control, Asset Management, Project Costing)

People Tools: Application Designer, PeopleCode, Application Engine, Component Interface, Security, EDI Manager, Data Mover

ETL Tools: Oracle Data Integrator (ODI), Microsoft SQL Server Integration Services (SSIS)

Reporting Tools: SQR, Crystal Reports, Nvision, Business Objects, BI Publisher/XML Publisher, OBIEE

Databases: Oracle,DB2 and MS SQL Server

Operating Systems: Windows Server 2008, UNIX (AIX, HP, Solaris).

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Senior PeopleSoft Technical Developer

Responsibilities:

  • Interacted with the user and the functional team for the requirement documents and prepared Functional Design Document.
  • Worked on people soft 9.2 for finance modules (AR, AP, Billing and GL).
  • Designed and tested Peoplesoft menus, components, pages, PeopleCode and Process.
  • Developed Receivables Interface using File Layout, Application Engine, and Component Interface, which loads data from flat file into staging tables while doing various data validations using AE People Code and finally loads into PeopleSoft tables through Component Interface.
  • Developed an Application Engine which uses Component Interface while loading third party Billing System into PeopleSoft Account Receivables.
  • Worked on SOC 2 Processing Integrity control assessment to capture the results through different interfaces.
  • Designed Pages, records and component for Soc project to capture the results.
  • Worked on Commissions interface controls, Billing invoices and Customer aging data.
  • Modified Application Engine programs for PTD and CTD process to get correct dates.
  • Designed and Developed interface programs using Application Engine.
  • Experience writing numerous interfaces to 3rd party vendors like Bill interface load to GL, Bill interface load to AR.
  • Designed BI Publisher Report Definitions, Templates and Data Sources to generate ePerformance reports using PeopleCode and Process Scheduler.
  • Created custom roles and permission list for job responsibilities for Purchasing, Billing, Accounts Receivable (AR) implemented these into PeopleSoft Security along with setting up user ps for user’s OperID’s
  • Migrating various objects from one environment to another environment.
  • Assisted with Billing/AR run controls including documenting batch schedule according to client specifications and created Chartfields.
  • Created different Billing Invoice layouts, Pro forma, SQR Reports and testing the reports in various environments.
  • Performed on-line and batch mode unit testing, PeopleCode and SQR debugging. Troubleshooting in Application Engine Create Documents business process to resolve technical issues.
  • Wrote SQRs for Billing,, AR, Projects and PayBill.
  • Performed PeopleCode analysis, modifications, system test and implementation using Application Designer, Peoplesoft PIA, PeopleCode Debugger and PeopleCode trace file.
  • Worked on the Agile methodology environment including acceptance test driven design and continuous integration/delivery.
  • Hands on experience in XML Publisher and Approval Frame Work Engine AWE. File layout, datamover, SQR, integration broker, work flow, security etc.
  • Designed and created Process flows, touch points for various processes.
  • Worked on Technical design documents and production support documents for different processes.
  • Involved in Unit testing and created test cases.

Environment: Application Developer for PeopleSoft Finance modules v9.2. People tools 8.55/8.56 and FSCM.

Confidential, Tulsa, OK

PeopleSoft Finance Techno Functional Consultant

Responsibilities:

  • Single point of contact as Technical Production support lead specialist for PeopleSoft modules Manufacturing, General Ledger, Cost Management, Travel and Expenses, AR,AP, Billing, Purchasing, Asset Management.
  • Worked on people soft 8.4 for finance modules (GL, T&E, Cost Management, AR, AP and Billing) and people soft 7.5 for manufacturing module.
  • Involved in developing Inbound Interfaces customizations in FSCMs 8.4 like OM, INV, GL, ePro, Billing, AP, AR, PO, RECV by using App. Messaging.
  • Executed the interfaces for Accounts Payable using Integration Broker messages, and also Application engine/file layout for file based integration.
  • Setup security roles, permission lists and user ids for Order Management, Inventory and Finance users. In addition to the standard security setup, configured feature security for the order management users.
  • Build and deployment of Minor and major enhancements as part of change requests.
  • Building and creating new customer setup in manufacturing module as per the business requirement.
  • Interacting with users and collecting business requirements and solving the issues in the production and test environments and handling the job abends.
  • Worked and supported on Nvision reports (Monthly Balance sheets, trail balances, income statements, allocations ledger, cash flow reports) and Nvision drilldown reports.
  • 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 tress using Tree Manager.
  • Worked and supported on Cash advance report and expense reports.
  • Created different Expense reports, cash advances, time reports, travel authorization reports and set up integration broker to process.
  • Worked on the PeopleSoft Asset Management AM team for a Maintenance Management MM implementation.
  • Created interfaces with third party vendors using SQR, PGP encryption and SFTP.
  • Used Journal Generator process (FSPGJGEN) to convert Financial Forecasting accounting entries to Journal entries. Edited and Posted Journal entries to the new Forecast Ledger.
  • Post implementation support of PeopleSoft order to cash process.
  • Troubleshot, corrected, updated, tested and migrated PeopleSoft nVision layouts and queries.
  • Coordination with various stakeholders for successful development, testing and deployment of new interface setup in General ledger, Cost Management modules with ADP and various vendors.
  • Created change requests for migration of code from one instances to other and Change management document with required changes in other non PeopleSoft environments for firewall connections and FTP.
  • Performed on-line and batch mode unit testing, PeopleCode and SQR debugging. Troubleshooting in Application Engine Create Documents business process to resolve technical issues.
  • Reviewed and corrected Order Management (OM), Inventory, Billing and Purchasing Configurations in PeopleSoft.
  • Reviewed and setup the Project Costing/Contracts/Billing/AR System Configuration by validating the data for General Setups and Structured Project Option Setups.
  • Designed and developed in-bound and out-bound interfaces to and from PeopleSoft to existing legacy system.
  • Designed an inbound interface in Accounts Payable which loads the invoices sent in xml format by the vendors through the EDI 810.
  • Interacting with Business owners with various business units for manufacturing modules, new customer setup.
  • Designed and developed conversion and audit programs to convert into PeopleSoft Grants, Contracts, Customers (Grant Sponsors), GL Journals, Purchase Orders, and Item Categories.
  • Experience in Datacenter migration activities in PeopleSoft HRMS and Finance.
  • Resolved issues related to ledgers, journal generator, Nvision reports, and Elimination ledgers.
  • Created nVision Balance Sheet, Income Statements, Trial Balances and Cash flow statements reports.
  • Participated actively in implementation, customization and testing of various PeopleSoft Financial modules like General Ledger, Accounts Payable, AM, AR and Purchasing, Billing.
  • Configured Employees to handle EFT and ACH Payments for Expense and CASH Advance Payments.
  • Updated Application engine program, with people code and SQL.
  • Answering user queries and providing clarifications.
  • Developed a custom version of Vertex Sales tax software specifically for Toyota to handle large volumes.
  • 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.
  • Development of SQL Scripts, Application Engines, Component Interfaces for Data Migration.
  • In-depth knowledge of PeopleSoft Grants, Billing and Receivables and PeopleTools in the Citrix program environment and Terminal Services. App Designer, Nvision and PSQuery.
  • Performed month-end and quarter-end close. Troubleshot out of balance Balance sheets, multi - currency and ADB issues
  • Tuning nVision reports using Tree performance options. Writing drill-down queries and customizing nvsuser file.
  • Handling production issues and enhancement to the existing live portals.
  • Resolving the production issues related to manufacturing, Order process to the customer and Shipping and labeling issues and ASN issue.
  • Assisted in the testing of the Operations and Portfolio modules, which included work order management and system configuration.
  • Worked Tier 1 and Tier 2 support for the Production Support Center providing functional knowledge with Order Management, Inventory, and Manufacturing problems.
  • Worked on Technical design documents and templates.
  • Setup security roles, permission lists and user ids for Order Management, Inventory and Finance users. In addition to the standard security setup, configured feature security for the order management users.
  • Designed, developed and implemented custom Schedule Billing online pages.
  • Coded batch program for creating bills and email notifications to users basing on custom Schedule Billing.
  • Fixed errors in billing for several interfaces, printing invoices etc.
  • Provided Support and On-call whenever the critical issue comes up.
  • Coordinated with offshore team with all daily activities and project status.
  • Understanding the client requirements and communicating the same to offshore team.
  • Activities in the project include closely co-coordinating with the client for requirement gathering and delegating work across teams and assigning work to our offshore team, have been a part of onsite team in managing offshore team working 24/7.
  • Developed & Setup EDI transactions between PeopleSoft and other using Integration broker, Created custom handlers for inbound / outbound transactions.
  • Assistance with the Business users for System testing and EDI setups for inbound and outbound files for customers.
  • Involved in Code review and Unit Testing.
  • Executed and created the test cases for the custom process that captures the vendor ids as a part of the AP/GL interface which populates the Journal Entries to GL module.

Environment: Application maintenance/production support for PeopleSoft Manufacturing and Finance modules. People tools 8.55/8.56 and FSCM.

Confidential, Orange, CA

PeopleSoft Technical, BI Publisher Reporting Oracle Consultant

Responsibilities:

  • Interacted with the user and the functional team for the requirement documents and prepared Functional Design Document.
  • Created PS Queries as per the Functional Design document.
  • Created Data Sources and Report Definitions using PS Query and XML files.
  • Designing Process Schedulers and giving Permission lists to the process.
  • Developed New Pages, records and Components in the Application Designer and modified the existing People Code based on the specific needs of the client.
  • Creating Application engine program in Application Designer using people code and SQL.
  • Created various Bi Reports using PS Query and Xml files in different modules.
  • Designed the Run control pages for running reports.
  • Created STAT CSR’s for the project and migrated to the testing environment.
  • Set up, configured new PeopleTools version 8.55 features such as Fluid Technology (Fluid UI as the default), NavBar:Navigator (faster and context sensitive navigation), Tile Wizard, and PeopleSoft Cloud Architecture (PCA).
  • Worked on mapping functional requirements to technical requirements. Involved in documentation of technical specifications, developing test cases and technical design.
  • Migrating various objects from one environment to another environment.
  • Created different Billing Invoice layouts, Pro forma, SQR Reports and testing the reports in various environments.
  • Expertise in writing, tuning and debugging the PeopleCode, SQR and Application Engine programs.
  • Prepared and modified various BI publisher/XML publisher reports as per the client request.
  • Designed and Developed Record Definitions, Pages, Sub Pages and Components based on Business requirements.
  • Involved in the PeopleSoft AWE Implemenation for GL Journal Approvals, Expense Report and Cash Advance Approvals.
  • Developed Security design for eProcurement/Purchasing roles and permissions lists and Workflow.
  • Used STAT for all versions of your PeopleSoft objects (including non-application designer objects) AND flat files (including COBOL, SQR, SQL, nVision, Crystal, SQL scripts, etc.,) are versioned and stored indefinitely in the Stat repository.
  • Proficient in PeopleTools, PeopleCode, Application Designer, Application Package, Application Engine, Integration Broker, XML Reporting, Component Interface, Process Scheduler, Upgrade Assistant, Tree Manager, Process Monitor.
  • Created & customized Reports from various data sources using SQR, PS-Query, Crystal reports, XML Publisher, nVision.
  • Extensively used automation testing using PeopleSoft test framework.
  • Created many queries using PS-Query tool for creating XML publisher report templates and for other data validation.
  • Tested extensively on Application Messaging, PeopleCode, Application Engine, Integration Broker, Component Interface, Workflow, PS Query, SQR and Oracle PL/SQL.
  • Worked on Various Defects in the project using HP Quality center application.

Environment: Conversion of Crystal reports in to BI Publisher Reports and SQRs. Upgrading from 8.4 to 9.2. People tools 8.55

Confidential, Branchburg, NJ

PeopleSoft Financial Techno Functional Consultant

Responsibilities:

  • Interacted with users and collected reporting requirements and prepared functional and technical specification documents.
  • Tuned SQL/SQRs to improve performance using advance features like Load lookup and Arrays.
  • Designed, developed various BI Publisher reports across various modules for specific requirements.
  • Worked on BI publisher to get the Interface data for client request.
  • Designed BI Publisher Report Definitions, Templates and Data Sources to generate AP/BI/AR/GL/PO/KK module reports using
  • People Code and Process Scheduler.
  • Generate output that comply JSON standards and respond to the requests received by iScripts.
  • Involved in Grants business process by creating several proposals, establishing the proposal budget, processed the ‘Print a signature page’ for authorization and copied an existing proposal to create new proposals.
  • Designed XMLP Data Sources using PS Query, XML File and Connected Query.
  • Performed XMLP troubleshooting and reverse engineering in the CONQRSMGR, QUERYITEMPROMT and Process Report
  • Application Packages to resolve Connect Query queries prompt values.
  • Design and built SOA composites with best practices, perform filtering, transformation operations on it before inserting into end systems or send to partners using Oracle B2B.
  • Analyzed scripts, Application Engine programs and provided resolutions/support for issues faced during upgrade and data conversion.
  • Developed, analyzed, modified and validated nVision, SQR, Crystal and XML reports.
  • Developed a vendor and region-wise nVision report to forecast the accounts payable in the following month. This report shows the region wise cash requirement by scheduled pay date.
  • Worked extensively in nVision reports in GL. Developed Matrix & Tabular layouts for Income statement reports, Cash-flow statement reports, Balance sheet reports, Equity Reports.
  • PeopleSoft Retrofitting and Enhancements:
  • Involved in fit-gap analysis from PS9.0 to PS9.2 version. Designed the document for master customization list which will take care of all the gaps should be fulfilled in PS9.2 version.
  • Technical Functional Proficient in Design, Development, Customization, Upgrade and Maintenance of PeopleSoft FSCM 9.x PO, Receipt, AP, T E, AM.
  • Implementation lead for PeopleSoft purchasing, supplier contracting, Strategic sourcing, e-supplier connection modules.
  • Implemented Supplier self-service, Bidder registration, RFQ response via e-Supplier connection.
  • Review and understand established Should-Be state for Purchasing (PO) and ePurchasing (ePro) business processes for strategic improvement including eProcurement Workflow Approval Process
  • Generated AP Vouchers and populated the AP external interface staging tables (PS VCHR HDR STG, PS VCHR LINE STG, and PS VCHR DISTRIB STG) with Inter Unit Billing Information from the PeopleSoft Billing tables.
  • Created complex queries for functional users to support day to day processing.
  • Performed Fit-GAP analysis to gather requirements for GL and AP implementation.
  • Purchasing and eProcurement sourcing from inventory Business processes implemented.
  • Develop manuals for Grants Management, Accounts Receivable and Revenue Recovery areas which utilize PeopleSoft Grants, Billing, AR and Customer Contract modules.
  • Built security module for the PeopleSoft Order Management users with user ps and custom pages. Setup permission lists, roles and user ids.
  • Involved in Development of GL Interface SQR, which reads flat file containing journals and loads into PS JRNL HEADER, PS JRNL LN and custom table M JRNL TRAILER. The file is opened for reading with open command when header row is loaded it checks for header edit rules and valid header data is inserted into Jrnl header. If line data is loaded.
  • Analyzed the existing customization of pages in AP, GL & AR and collaborated with the functional team in deciding the re-application of the existing customizations.
  • Participate in integration testing and provide data required for integration testing involving Vertex O Series.
  • Creation of New Environment Request document to setup the infrastructure for Vertex O Series installation and deployment.
  • Worked with ChartField configurations, ChartField validation, combo edit checks in GL.
  • AWE Implementation: Setup AWE Approval Workflow for GL Journal Approvals, Expense Report Approvals and Vendor Approvals.
  • Defined Asset Categories and created Assets Accounting Entry Templates.
  • Configured Locations, Calendars, Asset Books and created AM Business Units
  • Configuration of GL, Grants, AR, Projects, Customer Contracts, Billing and Commitment Control and Suppler Contract PeopleSoft modules.
  • Troubleshoot AP PSTVCHR process, which is used to post the vouchers.
  • Designed and Developed a Report Table according to the requirements of the agency to have the Source, Fund Distribution and Target transactions in one line by using PROJ RESOURCE Record joined multiple times and deleting the unwanted rows in an App Engine Program.
  • Interacted and assisted Tech Team to modify interfaces to convert legacy Asset data to PeopleSoft Asset Management.
  • Supported in troubleshooting AP and GL issues like offset balance between the AP and GL reconciliation by running the sub system reconciliation process and analyzing the vouchers by business unit and voucher IDs.
  • Performed SQR, COBOL, SQL, and Peoplesoft Query troubleshooting and performance tuning.
  • 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.

Environment: Upgrade of PeopleSoft Financial systems from v9.0 to v9.2 and Implementation of New modules: Real Estate, Asset Management, Project Costing, Inventory and OM. Commissioning of new departments,companies into PeopleSoft.

Confidential, Houston, TX

PeopleSoft Developer

Responsibilities:

  • Re-Designed and Developed 6 core integrations between PeopleSoft Purchasing/eProcurement and IBM Maximo system. variety of technologies, mainly People tools in developing these integrations on getting the data mappings of these interfaces.
  • Designed and configured GL and AP business units.
  • Integrated Financial application with Third party vendors - VERTEX (Taxes & GeoCodes), OANDA (Exchange Rates).
  • Worked with Accounts Payable, General Ledger Cash Management on various customizations, which involves Positive Pay, Vendor Interface, Automation of journal entries, Service Fee Automation, Cash Reserve Priority.
  • Designed, configured and developed the approval framework for the PeopleSoft v9.1 Procure to Pay (PTP) business processes (Requisitions, Purchasing, Vouchers, Vendors, Journals, Commitment Control) and credit invoices using the new approval workflow engine (AWE).
  • Vertex configuration for tax integration between ERP and Vertex application.
  • Provided functional support for SAP FICO Accounts Payable (AP) module and various modules like Accounts Payable (AP), Purchasing (PO), General Ledger (GL), Asset Management (AM), Inventory, and Project within PeopleSoft Financials environment.
  • Extensive Development experience with TOAD, PL/SQL Developer.
  • Experienced in the design of the Workflow, which was primarily used to develop Work lists, Events and Routings for various business needs.
  • Good understanding for Critical aspects of PC Fund Distribution and Pricing. Worked with Oracle to resolve some critical issues with these processes.
  • Created the Crystal reports using Oracle tables and tested the reports by cross checking and verified data against the reports generated from the legacy system.
  • 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 processead file report. Used various SQR functions, Arrays, Trees, Views, Load Lookup & SQC (which handles various Invalid Chartfield Combinations).
  • Consumed third party web service to create service operations, nodes and Message schemas.
  • Generated outbound synchronous SOAP doc and manipulating response using SOAP doc classes.
  • Customized Application Engine IN ITMLOAD during item load process.
  • Customized the PO Dispatch and Print SQR (POPO005) to print the Ship To comments at the Ship To label, which is used for printing the address. This change is made specifically for customized Ship To’s with just single Ship To address. Also made changes to accommodate the standard Ship To comments for customized single Ship To’s at the Ship To label.

Environment: This project is a PeopleSoft Financial upgrade from v8.8 to v9.1 and production support of v8.8 version

Confidential, Temecula, CA

PeopleSoft FSCM Techno Functional Consultant

Responsibilities:

  • Involved in fit-gap analysis from PS9.0 to PS9.2 version. Designed the document for master customization list which will take care of all the gaps should be fulfilled in PS9.2 version.
  • Created the Technical designs for Invoice extract process changes, new invoice layout designs, Contracts to Billing Interface changes, and Expense Employee Data update changes to the delivered Application Engine program, Accounts Receivable Update changes.
  • Design and modify the PO dispatch process to attach the pdf file for Condition and Terms.
  • Designed and Developed Outbound Interface which is sending a Current eligible Employee personal, Spouse and Dependent information for the Medical plans to the Vendor.
  • Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans. Developed complex SQR program that creates multiple reports dynamically based on various parameters.
  • Experience on financial deployments including PeopleSoft Accounts Payable, Receivables, General Ledger, Asset Management, Grants, Budgets, Contracts, Cash Management and eProcurement.
  • Developed Purchasing Interface using File Layout, Application Engine, People Code and Component Interface, which loads data from flat file into staging tables while doing various data validations using Application Engine People Code and finally loads into PeopleSoft tables through Component Interface.
  • Designed and developed custom process to allow approx. 25 to 50,000 vendor requests and invoice entries through batch. Process has allowed the freeing up of several individuals in AP to focus on other more important tasks.
  • Involved in the PO - AP matching issues in PeopleSoft allowing the system to match the Purchase Order, Receipts and Vouchers - as the converted data was manually matched in legacy system. For this, I developed an interface inbound/outbound Application Engine process to make sure the data in PeopleSoft AP table are consistent with the ones in the third-party system.
  • Participated in fit gaps for Projects, Grants and Billing modules.
  • Performed programming analysis and customizations in the journal edit and post processes using Process Scheduler, DB2, MVS JCL, TSO/ISPF and COBOL.
  • Created Reconciliation process (SQL scripts, Word Doc, etc.) in order to validate and verify the accuracy of the results.
  • Added indexes to JGEN ACCT ENTRY and ITEM DST tables to tune the FS JGEN application engine process and worked with Oracle global support team on the performance tuning of ARUPDATE job in financials version 9.0.
  • Developed a Custom App Engine to perform the Conversion of Customer Data from PS9.0 to PS9.2. Used PeopleCode to perform Long Data type inserts from PS8.8 to PS8.9 for Customer Conversation Conversions.
  • Involved in Customizing and Testing the AP Pay Cycle Process to print the Custom Checks.
  • Designed and developed a modal PTF (PeopleSoft Test Frame) in PIA and developed a custom application engine process to generate multiple test cases for different test types like test, shell test etc., the design differs for each type. Also, developed a search component whose functionality is simulation of PTF tool, to make user easy to search the specific test script related details.
  • Created a new custom component for Vendor Management System for Vendor tracking using PeopleSoft Activity guides and work centers. This customization is to mimic the PeopleSoft Vendor Management system which is decommissioned by the client.
  • Used Integration Broker, Web Services and SOA to Integrate PeopleSoft Financials with third party services and publish the employee information from PS Financials to other application.
  • Enabled access to Financials from Enterprise Portal by setting up a single link to PeopleSoft Financials application content provider and set up the single sign on.
  • Setup and configured purchasing Approval framework.
  • Customized the BIIF001 App Engine so as to avoid populating the fields ACTIVITY ID and BUSINESS UNIT PC in the BI HDR table as per the Functional user requirements.
  • Receiving notification customization - Created an application engine program which notifies users if a Purchase Order has not been received for 4,8,12, or 16 days after the due date.
  • Tuned various application engine programs like Billing Interface Program, Billing Preload, AR Update, Payment Predictor, Voucher Build and Post processes for optimum performance.
  • Prepared and modified various BI publisher/XMl publisher reports as of client request
  • Designed and developed a program that loads assets from a comma delimited file into asset interface tables.

Environment: Worked with Users, Application Owners, Managers, and team to draw up specifications and gather requirements for PeopleSoft FSCM (PO, Inventory, ePro, BI, GL, AP, AR) Assisted in streamlining the SCM process as per requirements and anticipated deliverables. Implementation of new modules and Upgrade of PeopleSoft Financials v9.2,Tools 8.53 on Oracle and UNIX.

We'd love your feedback!