Peoplesoft Fscm Techno-functional Resume
Madison, WI
SUMMARY
- Nearly 8 years of professional work experience as PeopleSoft Technical consultant in PeopleSoft Finance domain.
- Strong experience working on ERP implementation, upgrade and support methodology and quality processes benchmarked.
- Involved in design, development and testing of PeopleSoft modules General Ledger, Accounts Payable, Purchasing, eProcurement, Asset Management, Account Receivables and Billing.
- Experience on the Analysis (Fit - Gap), Design and Development of PeopleSoft Financials.
- Worked in a variety of engagements involving all phases of SDLC such as system study, analysis, design, development, testing and implementation.
- Proficient in the creation of complex reports using SQR, XML Publisher / BI Publisher and Crystal Reports.
- Involved in end-to-end project life cycle, starting from initiating the kick-off meetings, Knowledge Transition, documentation, support levels, effort estimates, coordination with the client team to ensure quality of deliverables.
- Experience in fine-tuning the business processes across modules.
- Excellent Communication and Presentation skills.
- Knowledge of best practices followed in IT industry in software development life cycle.
- Ability to work independently and in a team environment and interested to learn new technologies and emerging standards and have the ability to learn quickly.
- Good PeopleSoft technical knowledge and a sincere passion for resolving complex problems and business challenges through technical innovation.
TECHNICAL SKILLS
ERP Package: PeopleSoft Financials (FSCM) 8.4, 8.8, 8.9, 9.1,9.2
Functional Domain: General Ledger, Accounts Payable, Purchasing, eProcurement, Asset Management, Accounts Receivables, Billing
Application Tools: Application Designer, Application Engine, Process Scheduler, PeopleCode, Component Interface, Integration Broker, SQR, PSQuery, Tree Manager, Crystal Reports, XMLP Reports, nVision, Oracle, SQL, PeopleSoft Server Admin, PS Security, Change Assistant, Change Impact Analyzer and Unix Shell scripts, File Layout, Excel to CI, Data Mover
People Tools: PeopleTools 8.42, 8.46, 8.47, 8.49, 8.50, 8.52,8.53,8.54
Reporting Tools: SQR, Crystal reports, PS Query, XML publisher, DMS Scripts, Component Interface
Database: Oracle 9i/10g, DB2, SQL Server 2005
Platform: UNIX, Windows (98/2000/2003/ XP/Vista/7)
Languages: PeopleCode, PL/SQL, Unix Shell Scripts, COBOL
PROFESSIONAL EXPERIENCE
Confidential, Oakland, CA
PeopleSoft Financials Techno-Functional Consultant
Responsibilities:
- Developed functional flow diagrams for all customizations which will be more useful to the users to understand the flow of the customizations.
- Performed requirement gathering, fit-gap analysis, design, development, Testing and documented processes.
- Designed the technical design documents and maintained entire document repository containing Test Case documents, Test Plan output, Backup/BackOut Data Plan (For data issues).
- Involved in team discussions and conferences to solve technical issues and improve project’s performance.
- Developed a custom secured process using application engine which removes secure payment details Information from PeopleSoft system.
- Developed custom inbound process using Component Interface and File Layout for Vendor component to import data from 3rd party system.
- Developed custom outbound interface using SQR to generate a file of approvers for Procurement transactions in 3rd Party system from PeopleSoft.
- Scheduled Data archival process using PeopleSoft Data Archival Manager for Accounts Payable & General Ledger which includes transaction tables with staging tables.
- Worked on customizations in Purchase order dispatch process using SQR.
- Customized existing mass update of open periods which reduces the time for Business Users while updating Financial accounting periods.
- Customized AP check printing process using XML publisher.
- Developed an SQR data conversion program to import payments from a third party system to Cash Management module for bank reconciliation.
- Developed a new SQR process which generates procurement information from new 3rd party system which will be used in AP EDI interface.
- Worked on production issues occurs at every Financial Month end and communicated with Business Teams and Users Effectively with updates while resolving issues.
- 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.
- Created training documents in AP, GL, AR and BI modules and trained the end users.
- Worked in Production Support Team to resolve SQR, People Code, Application Engine issues.
Environment: PeopleSoft Financials/SCM (AP, PO, GL, AM, PC,, CM, eProcurement, and Purchasing) 9.2 People Tools 8.50, Application Designer, Application Messaging, People Code, Component Interface, Application Engine, ExceltoCI, Data Mover, Mass Changes, Data Archival Manager, Security
Confidential, Iowa City, IO
PeopleSoft Financials Techno-Functional Consultant
Responsibilities:
- Involved in PeopleSoft PeopleTools and Application grade from and 9.0 to 9.1 respectively.
- Technical Role includes working on Retrofit activities related to application upgrade.
- Technical design document preparation, Coding, Testing and resolving technical issues.
- Functional Role includes Functional test case preparation and product configuration.
- Developed new system functionalities and customized existing functionalities as per the GAP documents and functional specifications.
- Involved in retrofits of records, views, pages, components, CI, SQLs, Queries, Application Packages, App Engines, SQRs, Record PeopleCode, component PeopleCode, Page PeopleCode and fixing the issues of end users and functional staff.
- Generated and analyzed compare reports of projects between different database instances.
- Performed upgrade testing of PO, AP, AR, Billing, GL, Budgeting, Asset Management, eProcurement.
- Worked closely with functional users in resolving issues during configuration and functional testing.
- Developed custom Approval Workflow engine using Application Package for Contract Approval process which includes setups.
- Developed custom eProcurement Approval Workflow Engine Rules(AWE)
- Involved in customizing the BI invoice report using XML publisher.
- Developed summary reports with PeopleSoft Query in conjunction withCrystal Reportsand Query basednVision Reports.
- Designed and developed various customnVisionledger based Reports inGLmodule, query basednVisionreports for the Project Costing and Asset Management modules.
- Created Report Requests, Timespans, Scopes and added description to the Tree Nodes for propernVision ReportOutputs.
- Developed Data Mover Scripts to move configuration data across multiple environments.
- Fixed PeopleSoft delivered issue with Accounts Payables copy template vouchers.
- Worked on fixing issues with POPO005.SQR Print and dispatch Purchase Orders interface Program.
- Fixed issues relating to Crystal Report Printing of JOBs.
- Resolved issues in releasing contracts when approved contracts are copied to voucher.
- Used SQL and PeopleCode trace in debugging and resolving online issues. SysAudit reports and performed data cleanup.
- Written and reviewed Technical Design documents of new developments and customizations to submit for approval.
Environment: PeopleSoft 9.0, 9.1 (PO, AP, eProcurement, AR, Billing, GL, Budgeting, and Asset Management), PeopleTools 8.49/8.54, Application Engine, PeopleCode, App Package, CI, XML Publisher, SQR, COBOL, SQL, PS/Query, Crystal Reports, SQL*Plus 8.1.7, Oracle 10g, DB2, OS/390, Windows 2003, UNIX.
Confidential, New York, NY
PeopleSoft FSCM Techno-Functional
Responsibilities:
- Involved in requirement gathering and creation of Functional Specification documents.
- Analyzing the functional specifications of various modules and preparing technical design based on the same.
- Developed various customizations as per the business requirement.
- Developed and Customized Reports based on business requirements using SQR, PS-Query, App Engine & Crystal reports.
- Worked on PS Query, to get information as required by the client for reporting purpose.
- Developed queries to run through Query Manager for report reconciliation using PS Query.
- Also worked on Application Engine, PeopleCode, ExceltoCI, XML Publisher, IB, Component Interface.
- Running DMS scripts to Import/ Export data.
- Involved in understanding the functional side of modules like Accounts Payable & Purchasing.
- Preparation of test cases, extensively involved in unit, system & integration testing.
Environment: PeopleSoft Finance 8.9,9.0,9.1 and PeopleTools 8.49, 8.50, 8.52,Accounts Payable, Purchasing, General Ledger, ECT(Bolt on), SQR, PS-Query, App Engine & Crystal reports, XML Publisher, IB, Component Interface.
Confidential, Madison, WI
PeopleSoft FSCM Technical Consultant
Responsibilities:
- Developed multiple inbound interfaces for below components in purchasing module using Component Interface, File layout and Application engine along with custom error handling: Requisition, Vendor
- Developed an interface which loads the data into Requestor Component using ExceltoCI.
- Worked on Accounts Payable, Purchasing and General Ledger modules.
- Involved in meetings with Business Teams and Users while configuring new GL/AP/PO business unit definitions.
- Worked along with functional Team in fixing and troubleshooting problems in designing and development.
- Developed custom audit application on custom PeopleSoft AP, PO applications.
- Implemented workflow in purchasing module which should get approval from the approver.
- Involved in customization of existing pages using People Code using dynamic view and dynamic prompt concepts.
- Involved in migration process of objects between Development, QA, UAT and Production environments
- Worked on PS Query, to get information as required by the client for reporting purpose.
- Developed queries to run through Query Manager for report reconciliation using PS Query.
- Involved in knowledge transfer and training.
- Involved in resolving issues raised during SIT/UAT.
- Involved in modification and fine-tuning of Application Engine, SQR programs.
- Involved in PeopleSoft application security design in Accounts Payable, Purchasing Custom applications.
Environment: PeopleSoft Financials/SCM (AP, purchasing, General Ledger and eProcurement) 8.9, People Tools 8.48,Application Designer, Application Packages, People Code, Component Interface, Application Engine, ExceltoCI, Data Mover, Security, SQR, PS Query, Workflow, Oracle 10g/11g.
Confidential, Miami, FL
PeopleSoft FSCM Technical Consultant
Responsibilities:
- Worked on in customizing the POPO005.SQR Print and dispatch Purchase Orders Program.
- Resolved the issues with the Email dispatch of Purchase Orders in a batch.
- Gathered the functional requirements for the new Pre-Source Processing program from the end users and build a design specification for implementation.
- Created new interface program for Pre-Source Processing to update the status of the requisitions based on the business criteria.
- Developed the Process to Email error log reports to the Requestors and Buyers based the invalid check criteria in the Pre-Source Processing.
- Build a consolidated error report log for Pre-Source Processing in the order of Business Unit, Requisition ID, Requestor, Buyer and Error checks.
- Setting the Process Scheduler to run PSJob.
- Customized people code in resolving issues with shipping of items to Active/Inactive location.
- Modified the inbound interface program to import Item Files from AS 400 into PS Tables. Added the INV ITM UOM table to be populated with data when program is executed. The tables involved are PS MASTER ITEM TBL, PS INV ITEMS, and PS PURCH ITEM ATTR.
- Updated the queries in importing Item Files interface program into PS Tables.
- Modified the working logic in importing item ship-to vendor priority to PeopleSoft.
- Resolved the issues with Private Queries in PS Query. Used query tree manager to add records.
- Customized the pay cycle manager in sending email notices and electronic payments.
- Created new App Designer objects like fields, records and project definitions. Used migration tools to move definitions between different PeopleSoft instances.
- Customized the People Code in PO Header and Line Pages.
- Customized the Add and Update Purchase Order Page in setting the consolidated date to due date when the consolidated date is blank.
- Changed the interfaces programs for importing Food and Beverage requisition flat files in to People Soft Tables. The tables involved are PS PO HDR, PS PO LINE, PS PO LINE SHIP, PS PO LN DISTRIB, and PS PO APPROVAL.
- Customized the PeopleSoft Financial System Retail Pro interface program of import Retail Pro Files into PS.
- Created Unit Test Cases, Integration Test Cases and Test Results for FULL Test Cycle in assisting the client requirements. Documented the test results after the Unit test, System Test of processes. Running trace, debugging the code/programs and fixing errors.
- Build the SQL scripts to update and alter the tables.
- Modified the shells scripts for emailing the daily reports to the users.
- Ran the PeopleSoft trace to check the effected tables in the application. Modified and added the tables in the interface programs.
Environment: PeopleSoft Financials/SCM (AP, purchasing, General Ledger and eProcurement) 8.8, People Tools 8.44,Application Designer, Application Packages, People Code, Component Interface, Application Engine, ExceltoCI, Data Mover, Security, SQR, PS Query, Workflow, Oracle 10g/11g.