We provide IT Staff Augmentation Services!

Peoplesoft Techno-functional Consultant - Integration Specialist\lead Resume

San, FranciscO

SUMMARY:

  • Over 10 years and 3 months of IT experience and expertise in Analysis, Design, Development, Implementation, Testing and Production support of PeopleSoft Financials/ SCM 9.2/9.1/9.0/8.8 (Accounts Payable, General Ledger, Asset Management, Projects, Inventory, Procurement(ePro), Manufacturing, Expenses and purchasing).
  • Working as focal - point of contact for all the development related activities from onsite.
  • Expertise in almost all modules of Peoplesoft both technically and functionally in Procurement, Travel and Expense, Accounts Payable, Inventory, Manufacturing, Purchasing & General Ledger.
  • Extensive experience in full life cycle implementations, System analysis and design, Development, implementation, Customization, Conversions, Upgrade, Migration, System Integration and Data base Management.
  • Working in development and production support for over 9 years and resolved as many number of critical and high priority defects / tickets and won accolades from clients.
  • As a part of a development project, developed a data masking technique which would be used to scramble / mask all the confidential user data from intruders.
  • Experience in working with PeopleTools such as Application Designer, Application Engine, People Code, SQR, Process Scheduler, PS Query, Crystal Report, Data mover, Configuration Manager, Application Messaging, Component Interface and Workflow.
  • Experience in performance tuning of Application Engine programs, SQRs and good understanding on different levels of trace settings.
  • Excellent report writing skills using SQR, Crystal Reports and PS Query.
  • Created several queries to assist users in the day-to-day production support, month end/year end closing.
  • Involved in requirements gathering in converting the legacy systems data to PeopleSoft staging tables of billing, Receivables, Payables and General Ledger.
  • Performed extensive fit/gap analysis and process discovery for several financial applications, and identified problems and resolutions in implementing the respective PeopleSoft systems.
  • Good understanding of Upgrade methodology, DB compare Report, Retrofitting the customizations, Collision Analysis, Test Moves, analyzing DDD Audit Report and Sys Audit reports.
  • Worked in PeopleSoft upgrade from 8.8 to 9.1 from the start to the end (from retrofitting phase until go-live and stabilization phase) of the project
  • Good understanding of various aspects of PS Security.
  • Strong analytical, problem solving skills and a good team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

ERP: PeopleSoft Financials 8.8/8.9/9.0/9.1/9.2 (AP, AM, Projects, GL, Procurement, Expenses, Manufacturing, Inventory & Purchasing)

People Tools: Application Designer, Application Engine, People code Process Scheduler, Configuration manager, Data Mover, Upgrade Assistant, Change Assistant, PeopleSoft Workflow, PeopleSoft Security, Application Messaging, Integration Broker, File Layout

Reporting Tools: SQR, PS Query, Crystal Reports

Languages: People Code, SQL, PL/SQL, C/C++, XML, HTML, Java, Advanced Java concepts like Swing (J2EE), Visual Basic

Databases: Oracle 8i/9i/10g, SQL Server 2000Operating Systems: Windows 8.1/8/7/XP/2000/NT/98

EXPERIENCE:

Confidential, San Francisco

Peoplesoft Techno-Functional Consultant - Integration Specialist\Lead

Responsibilities:

  • The purpose of this project is to replace FAMIS which is a mainframe system managing HR & Financial activities of the Confidential to PeopleSoft FSCM 9.2. The HR system has already been converted to PeopleSoft, currently working on replacing FAMIS with PS FSCM 9.2.
  • Working as a focal point of contact for all Integrations between HR & Finance and also integrating with external applications managed by various Confidential ’s department such as Retirement systems, DPH (Department of Public Health) etc.
  • Working as a lead developer in multiple development activities in modules such as AP, P2P, Expenses, AM, GL etc.
  • Working as a focal point of contact for integration with Oracle IAM (Identity & Access Management) for identifying users for vendor \ bidder registration.

Confidential, Kansas

Peoplesoft Techno-Functional Consultant - Tech Lead

Responsibilities:

  • The purpose of this project is to replace P2P modules in PeopleSoft (ePro, PO).
  • Working as focal point of contact from onsite for all development related activities.
  • Working with business & customers to gather requirements and generate functional & technical requirements documents.
  • Working with Coupa vendor development team to enable intergration between Coupa & PeopleSoft.
  • Modified the user build processes to send the user data files to Coupa since that would be place going forward which stores all user’s payment & invoice data.
  • Created interfaces to send outbound data for Payment details, Vendor details, Ship-to address details, accounts, asset profiles, departments, projects etc to Coupa system.
  • This project is specifically for those certain users who has been outsourced by the client to run paycycle, payroll and all AP related month end activities.
  • The necessity of this project is not avoid them making any changes to any critical one-time vendor items in Accounts payable.
  • Gathered requirements from business after analyzing on what has been outsourced and what should be done to restrict their access to a minimal in Accounts Payable.
  • Analyzed the requirement to restrict the one-time vendor access for certain set of users who should not be allowed to view or edit the one-time vendors and their corresponding vouchers.
  • Modified the delivered voucher and vendor pages to restrict the one-time vendor access for certain users alone.
  • Modified the delivered query access to restrict those specific users to let them only view and run only certain views they are permitted too.

Environment: PeopleSoft Financials 9.0, People Tools 8.51, PS Security, People Code, Oracle 10g, UNIX and Windows 7.

Confidential

Responsibilities:

  • Analyzed the requirement from one of the external vendor (Saepio) to change the data transformation which is currently being sent from Saepio to PS.
  • Worked on creating Web Services using WSDL to allow the external vendor to send and receive orders.
  • Created new WSDLs to generate web services to process orders from external vendor.
  • Worked on Integration Broker to setup necessary Services, Service Operations, Routings, Messages and Handlers to transform the incoming messages from Saepio.
  • Created new transformation process to transform Saepio order data into PeopleSoft requisitions.
  • Created new XSLT transformations for the purpose of transforming orders into requisitions and to send the order status back to Saepio.

Environment: PeopleSoft Financials 9.0, People Tools 8.51, PS Security, People Code, Oracle 10g, UNIX and Windows 7.

Confidential

PeopleSoft Finance Tech Lead

Responsibilities:

  • Involved in analysis and design phases of the project to determine the technical requirements of the project.
  • Modified the delivered POPO005 SQR to change the company logo and the address in the purchase order PDF.
  • Development new setup pages/components which allow the user to define the leasing/rental rates and market rates which would eventually be used by the custom processes to calculate resale or rental entries.
  • Developed a custom process to generate resale accounting entries for all the non-asset vouchers. Included the code to make the call to a external interface vendor known as vertex to calculate sales tax for all these non-asset vouchers.
  • Developed a custom process to generate rental accounting entries for all asset vouchers. This process would calculate lease payments for asset voucher’s location. Included the code to make the call to a external interface vendor known as vertex to calculate sales tax for all these non-asset vouchers.
  • Engaged the appointment manager team to get the office open days for every location for every month. This would come into peoplesoft on the first day of the month. And our rental process uses this file to determine the lease payment and sales tax calculations for the asset voucher location.
  • This project eventually generated more revenue for the client by reselling and renting the assets and calculating the sales tax each month instead of doing it altogether in the first month itself for the whole leasing period.

Environment: PeopleSoft Financials 9.0, People Tools 8.51, SQR, Crystal Reports, PS Query, PS Security, People Code, Oracle 10g, UNIX and Windows 7.

Confidential

PeopleSoft Finance Tech Lead

Responsibilities:

  • Worked in analysis and design phases of the project to determine the finance modules where the changes need to be applied.
  • Developed new setup pages/components to allow the users to map the new business unit based on account.
  • Developed the setup page/component to allow the users to exclude or include the new business unit defaulting logic based on journal sources.
  • Performed development on all the GL upload interfaces to default the business unit on line level. This would affect all the journals loaded into peoplesoft from external interfaces.
  • Modified the custom payroll to GL Interface to default the business unit of journal lines based on account at the line level.
  • Modified the delivered journal generator process to accommodate the changes done in the journal upload process from HR (Payroll).
  • Modified the customized XML voucher upload process in AP to default business unit based on new defaulting setup.
  • Modified the delivered journal entry component & field journal entry component to default the business unit based on account and override the existing defaulting based on department.
  • Created a new KRONOS accrual interface in finance side to generate accounting entries for HR payroll since the time and labor tool used in Confidential & Confidential (STAR) has been replaced by KRONOS tool to capture time entry and generate payroll in HR side.
  • Created a new setup page/component to modify the item master table which allows the user to change the items without any hassle. This would enable the user to perform the changes online and not to use the custom spreadsheet upload process where the changes done to the spreadsheet would be updated in the item master table.
  • Created a new custom process for an external vendor Blackline to summarize the balance sheet account details from the ledger and generate an output file which would eventually be sent to the vendor. This file would contain both zero and non-zero balance accounts for both current and previous period of the accounting date mentioned in the run control.

Environment: PeopleSoft Financials 9.0, People Tools 8.51, SQR, Crystal Reports, PS Query, PS Security, People Code, Oracle 10g, UNIX and Windows 7.

Confidential

PeopleSoft Finance Tech Lead

Responsibilities:

  • Resolved several critical production issues during AP, GL, EX and AM month-end close.
  • Resolved the voucher upload process issue in production which was failing for “single row subquery returning more than one rows” error. The problem seems to be with some unwanted XML vouchers being pulled into the process flow incorrectly which eventually caused the issue.
  • Worked on AM month end close with the business and resolved issues regarding the AM Depreciation process (AM DEPR CALC) where certain assets does not depreciate properly according to the rate set by the federal government. These did not create proper accounting entries in the journal either.
  • Resolved high priority issues with expenses where some of the reports did not generate the accrual entries which leads the expense processing process to generate incorrect and imbalance expense accounting entries.
  • Resolved performance issues with critical process by determining which part of the process takes time and modularizing the code or recreating the SQL’s in a better way to run the process within minimal time.
  • Resolved issues with the user build process where the process still makes only the seasonal jobcode as active for all the expense related roles even though that employee has a regular active row.
  • Resolved unique constraint issues with critical voucher upload, journal generator process during month end and identified the issue to be with some invalid data got pulled into the process.
  • Resolved issues with user build process which was causing problems for only 3 users whose expense profile and roles are not built properly in the system. The reason found out to be with the way it populates regular and seasonal rows for the employees in the user build process, it overwrites the previous correct empl rcd and jobcodes.
  • Resolved issues with slow performance of the integration broker which seems to be the problem with high volume of messages getting stored in the main IB tables itself instead of being archived. Created a new custom process to archive such very old message data which is no longer needed.
  • Worked on the modifying the existing integration setup for one of the external vendors when they upgraded their system. This allows them to send the orders to PS from their upgraded system. Modified the transformation process to transform their data to the requisitions and send the status back to them.
  • Resolved issue with the user build process for Canada users where atleast 5-10 new Canada users were causing collision with the existing US users with the same OPRID as the US users.
  • Automated the Asset adjustment/transfer process by creating a custom interface which performs both asset adjustment and transfer from the input file provided.
  • Created a new interface to process all the accrual entries and post journals from the new time & labor system in HR since the existing system has been replaced.

Environment: PeopleSoft Financials 9.0, People Tools 8.51, SQR, Crystal Reports, PS Query, PS Security, People Code, Oracle 10g, UNIX and Windows 7.

Confidential, Richmond, VA

PeopleSoft Finance Tech Lead

Responsibilities:

  • Performed Trouble-shooting of day-to-day production support problems from technical as well as functional perspective for Confidential Peoplesoft Finance, an application built around all major modules of Peoplesoft FSCM, business processes.
  • Developed Queries, analyzed processes and modified SQRs in order to support day-to-day needs.
  • Handled issues related matching expectations to actuals, sending draft notifications to lenders, etc...
  • Modified the SQR process FIN2025 for Bank of Montreal payments to generate two kinds of outbound files one for PPD and other for CTX data. Involved in the setup of these two kinds of outbound files.
  • Modified Confidential ’s customized SQR to process all records in return file from Fed.
  • Performed Development, testing and UAT for the people soft security changes.
  • Created new permission lists and roles and modified menu access to permission lists.
  • Implemented a modified Overall Security Design
  • Involved in User Acceptance Testing for PS security project
  • Responsible to maintain the Confidential production related Help Desk Tickets and generating reports time to time from Quality Center (QC 10.0).
  • Generated a custom process to resolve a highly critical Blackley issue (where the expense reports still stays as APY even after they’re paid - Oracle couldn’t able to provide a possible resolution for this). This issue causes all the paid expense to get picked up by the staging process again & again and thus the EX TRAN PRCS fails frequently in production.
  • Resolved high priority VAT issues in Vendors where the Voucher build and auto sourcing process fails due to incorrectly picked up VAT data for the vendors. The fix which Oracle provided was not able to resolve the issue.
  • Resolved issues regarding to punch-out from Confidential vendors like Staples / Standard Register / Computerland by working on the transformation XMLs to fix the issues in the app message while punching out from those vendors while creating requisition.
  • Worked on transferring all the HR related data into Finance through app messaging.
  • Resolved app message posting from Job record from HR to the procurement & T&E table data like the requestor data & employee profile data.
  • Customized the AP Post Payment - AP PSTPYMNT process to fix the issue where the process was failing for multicurrency escheated payments for one particular Canadian BU. The fix provided by Oracle was not able to resolve this issue.
  • Involved in the customization to allow buyer to select Contract Id for each vendor while creating the requisition and carry forward that contract Id correct to the PO once that requisition is sourced into a Purchase Order. Made peoplecode changes in various records and pages for this requirement.
  • Provided on-call support for the post go-live phase of the project (Stabilization phase).

Environment: PeopleSoft Financials 9.1, People Tools 8.50, SQR, Crystal Reports, PS Query, PS Security, People Code, Oracle 10g, QC 10.0 (Quality Center), UNIX and Windows XP

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

  • Involved in the production support of Financials 8.8 (BI, AP, AR, AM, GL) and upgrade to 9.1.
  • Extracted, converted and loaded data from legacy system to PeopleSoft tables.
  • Systems converted - Vendors, Purchase Orders, Receipts, Contracts, and vouchers.
  • Tools used - SQR, Application Engine
  • Customized the most important Purchase Order PDF SQR POP005 SQR according to Confidential requirements.
  • Worked from retrofitting till go-live and stabilization phase of the project and resolved as many number of critical and high priority tickets within the SLAs and won accolades from customer.
  • Worked on the Code comparison phase of the project to compare the code between the current 8.8 environment with the new 9.1 environment, identify all the customizations done for Confidential and retrofitting them in the new 9.1 environment.
  • Developed people code to customize existing and newly added page field and record field definition properties. Developed people code for events like FieldEdit, FieldDefault, RowInit, RowSelect, SaveEdit, SavePreChange, SavePostChange, SearchInit, SearchSave and WorkFlow
  • Debugged the Journal Generator process to correctly populate the VCHR ACCTG LINE record.
  • Administered, scheduled and maintained the Jobs on Process Scheduler.
  • Modified FIN2025.SQR to keep track of Payment files, and created interface to Electronic files transfer the Payment File to Bank using People Code, SQR and UNIX Shell Script.
  • Ran compare reports and analyzed them for the collisions, retrofitted the old customizations.
  • Involved in modification and fine-tuning of Application Engine, SQR programs.
  • Involved in review of DDDAUDIT, SYSAUDIT and ALTER AUDIT reports against production copy to ensure that database is clean.
  • Reviewed interfaces that update PeopleSoft to ensure that data integrity will exist in the upgraded system.
  • Designed and developed several new SQR Reports in PeopleSoft Finance 8.8 to 9.1 and edited several reports in 9.1.
  • Resolved issues regarding to punch-out from Confidential vendors like Staples / Standard Register / Computerland by working on the transformation XMLs to fix the issues in the app message while punching out from those vendors while creating requisition.
  • Fixed upgrade issues regarding various setup issues for the vendor nodes which is used to provide a gateway to punchout from vendors.
  • Resolved the check printing issues with AP module by fixing the crystal reports of the CADCHKS.
  • Resolved the Payment Selecting & Creation issues during AP Paycycle process. Issue was unable to select certain vouchers for payment selection. Issue identified as the setup / config where the vouchers’ BU was not configured properly.
  • Provided on-call support for the post go-live phase of the project (Stabilization phase)

Environment: PeopleSoft Financials & SCM 8.8/9.1, PeopleTools 8.48.8.50, Oracle 9i/10g, Data Mover, Component Interface, SQR, Crystal Reports, Quality Center (QC 10.0), Integration Broker.

Confidential

PeopleSoft Technical/Functional Consultant

Responsibilities:

  • Worked on PS Security, involved in handling the tasks related to security including access to various PS modules/ Pages on an individual user basis and permission lists.
  • Changes to People Code so as to reflect the customizations as per the Clients requirements and execution of Queries on Security tables for Performance checks.
  • Involved in design, development, enhancement and maintenance of the project.
  • Modified people code to check application engine process for checking of errors.
  • Generated new logic using some important network security techniques like hashing to scramble / mask the highly secured user data like credit card number and account number.
  • Created Run control panels, panel groups, attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
  • Generated an application engine to scramble or mask the user related highly confidential data which is used to protect the user data from intruders.
  • Provided on-call support for the post go-live phase of the project (Stabilization phase)

Environment: PeopleSoft Financials 8.8, PeopleTools 8.48, Data Mover, SQR, Crystal Reports, PS Query, PS Security, People Code, Oracle 8i, Windows XP\

Confidential

PeopleSoft Technical Consultant

Responsibilities:

  • Involved from requirements gathering and until go-live phase & stabilization phase of the project.
  • Identified all the objects impacted in the General Ledger module where this project would be implemented and performed development, unit testing and migration of all the changes to production environment.
  • Included the new chartfield “Channel” into all the required components / pages / records wherever the Chartfield combination is defined like in Voucher records / Invoice records / Requisition records etc.
  • Involved in UAT to assist the testing team to identify many of most important defects on the development and resolved them on time.
  • Provided on-call support for the post go-live phase of the project (Stabilization phase)

Environment: PeopleSoft Financials 8.8, PeopleTools 8.48, People Code, Application Engine, Component Interface, SQR, Crystal Reports, Windows XP, Oracle 10g and PeopleSoft Enterprise Portal.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

  • Performed research and study of the existing system tables and business processes.
  • Involved in design, development, unit testing, migration, post go-live (stabilization) phase of the project.
  • Involved in creating many interfaces to load the General Ledger tables like account and dept tables with all the custom accounts & departments data created by the requester
  • Created a custom workflow notification for all the approvers who did not approve the account or department requests from the requesters.
  • Created a custom outbound process to generate the complete data of the chartfield requests created by the requester to add / edit / delete the existing account or department chartfield values and sent to DDE which is a third part vendor where this file is validated to check the count of new / change / delete requests created for each account or department chartfields.
  • Used File Layouts and Component Interface in Application Engine program to load data from flat file into the group control and pending item tables.
  • Written People code to enhance and customize pages.
  • Worked with end users to gather necessary information for the tasks.
  • Wrote inbound interface program using Application Engine and People Code to import Items from a third party application to the custom tables created to process the chartfield requests.
  • Involved in creating custom outbound email interface application engine to generate mails to all the approvers who have pending chartfield requests waiting to get approved.
  • Developed a custom workflow instead of using the peoplesoft delivered AWT workflow to process all the submitted chartfield requests to route to the respective approvers for approval before getting into the delivered GL account & department tables.

Environment: PeopleSoft Financials 8.8, People tools 8.4 xs, People Code, PL/SQL, SQR, Crystal Reports, PS/nVision, Integration Broker, Workflow, Component Interface, Windows XP, Oracle 9i

Confidential

Peoplesoft Technical Consultant

Responsibilities:

  • Worked on several enhancements of the delivered peoplesoft modules.
  • Worked on the enhancement named APC - AP Centralization where the invoices would be created by the contacts and sent for approval prior to get loaded into the quick invoice tables.
  • Worked on the staging process application to stage these custom invoices so that they can be processes to load into the quick invoice tables.
  • Worked on customizations on missing receipts in Inventory Management. Developed a automated process for missing receipts exists in Inventory of Items.
  • Worked on the enhancement in APC to allow the user to copy more than one PO line to the new invoice from the existing approved POs.
  • Worked on the enhancement of the delivered PO PDF process to customize the SQR report as per Confidential requirements.
  • Worked as sole developer in the enhancement to allow the buyer to select the Contract Id whenever a vendor is selected while creating a purchase order.
  • Worked as sole developer in creating custom outbound email interface application engine to generate mails to all the managers who have pending expense reports waiting to get approved.
  • Worked as sole developer in the enhancement to develop an application engine to send out emails to the expense report managers & submitters when the expense report is getting submitted with the non-reimbursable line item.
  • Worked on the enhancement to customize the CADCHKS process to print the checks for Bank of Montreal through Crystal Report.
  • Preparation of Unit test and integration test report documents.

Environment: Peoplesoft FSCM 8.8, Peopletools 8.4x, Oracle 9i, Toad, Windows XP, Citrix Neighborhood, Crystal Reports, CI, Workflow.

Confidential

Peoplesoft Developer

Responsibilities:

  • Involved in setting up position data for all the new & existing employees in position management.
  • Contributed in creating SQRs to pull out payroll related data and generate a report (outbound interfaces).

Environment: Peoplesoft HRMS 9.1, Peopletools 8.51, Oracle 9i, Windows XP, SQR.

Hire Now