Peoplesoft Fscm Functional Consultant Resume
Professional Summary:
- Over 8 years of experience in PeopleSoft (7.5/8.0/8.4/8.8/8.9) extensive experience in PeopleSoft FSCM (OM, INV, AP, GL, AR, PO, BI, Contracts, AM, Expenses & PC)
- Extensive experience in PeopleSoft Analysis, Implementation, and Upgrade & Production support experience.
- Proficient in the use of: nVision, SQR, Application Designer, Data Mover, Import Manager, Maintain Security/ Security Administrator, Query/Crystal, Application Engine, PeopleCode, Mass Change, Workflow & Database Agent, Message agent
- Specialized in Functional analysis, designing and developing customizations of Pages, Components interfaces, and reports
- Responsible for Developing Interface and Data conversion for FSCM modules (AP, INV, OM, PO, ePro) using Component Interface, Application Engine, Excel to CI, File Layout.
- Proficient in writing complex database reports and customizing PeopleSoft Delivered Crystal Reports and SQR Files
- Self Study of SOX (SOX (Sarbanes-Oxley)
- Experience in Database –SQL Server, Oracle, SQL Base, MS-Access, DB2
- Excellent in Production Support, Documentation, End-Users training and Knowledge transfer
- Served as the key point of contact/Liaison between on and offshore resources
- Excellent oral/written communication and presentation skills
Skills:
Application:
PeopleSoft Financials v8.0-8.9 (AR, AP, GL, AM, Billing), SCM v8.0-8.8 (OM, BI, INV, PO, PC), HR v8.3 (HR, BA, Payroll, BB, TA, T&L), CRM (Sales, Marketing, Order Capture)
Development Tools:
Application Designer, PeopleCode, Application Engine, Process Scheduler, Component Interfaces, Application Messaging, Business Interlinks
Reporting Tools:
PS Query, PS/nVision, SQR, Crystal Reports, Hyperion Reports, Tree Manager
Administration Tools:
Maintain Security/Security Administrator, Object Security and PeopleTools Utilities
Operating Systems:
Windows XP/2000/NT 4.0/ 95/98, UNIX, NovellNetware3.12
Tools:
SQL, PL/SQL, SQR, COBOL, HTML, JDK, C, C++, Crystal Info and Visual Basic 5.0/6.0, Developer 2000.
Databases:
Oracle, MS SQL Server, SQL Base and MS Access, FoxPro.
Software:
People Tools 6.01/7.55/8.13/8.3/8.40.09/ v8.45.12, Visual Basic, Developer 2000, and MS Office, Business Objects
Experience:
Confidential, May’09 – Till Date
- PeopleSoft FSCM Functional Consultant
- PeopleSoft FSCM upgrade ver. 8.0 to 8.8 and 9.0, Enhancements, Support
- Interacted and assisted Tech Team to modify interfaces to convert legacy Asset data to PeopleSoft Asset Management.
- Designed Purchasing workflow process.
- Troubleshoot GL Journal Edit issues.
- Worked with Business unit, setup Ledger
- Designed and support of INV and ePro interfaces.
- Design and Develop nvision reports.
- Coded batch program for creating bills and email notifications to users basing on custom Schedule Billing.
- Performed Testing of AP Voucher Post, Payment Post, Pay cycle processes.
- Troubleshoot and helped to resolve supplier purchase order and invoice issues
- Developed customizations using Application Designer for BI, AP, ePro, PO and INV.
- Involved in the analysis and implementation of PeopleSoft OM for Capturing and Validating Orders.
- Built and customized Component Interface and used Excel to CI PS delivered feature for Item Loader process
- Enhanced existing SQR’s to print invoices, purchase orders, price confirmations and request for quotes. Receiving Vendor, Item, Receipt Date and Receiving Log by Date, Item reports.
- Ran compare reports before and after applying the patches/fixes
- Interacted with the Users and Functional analysts to come up with new requirements for the business unit.
- Migrations of customizations like Record definitions, pages, Components, Run control pages, Portal Registries, A.E Programs and Component Interfaces for all modules.
- Fixing of problems and issues which come across during various stages of implementation like development, User acceptance and live of project costing
- Extensively involved in Post-Production Activities, Documentation and end user training
Environment: PeopleSoft 8.4/8.8/8.9 FSCM (OM, AP, PO, ePro, INV, GL, AR, AM, BI),
Confidential,NC Oct’07 – May’ 09
- PeopleSoft FSCM Consultant
- PeopleSoft Upgrade FSCM 8.4 to 8.9 and Enhancements, support
- Involved in designing and developing the interface programs to move data from legacy system to PeopleSoft tables using App. Messaging through Integration Broker.
- Worked with team and users to gather requirements, anticipated functionality deliverables and determine the specifications for implementation.
- Assisted users with P-card processing.
- Having a strong experience working with Multi Currency.
- Involved in developing Inbound Interfaces customizations in FSCMs 8.8 like OM, INV, GL, ePro, Billing, AP, AR, PO, RECV by using App. Messaging.
- Created and modified several new reports and queries.
- Solve the interface related issue - Debugging the SQR and Application Engine Program and Fix the error
- Involved in the development and customization of on line modifications.
- Generated Crystal reports for updating the status of Order Schedules, for Processing Inbound and Outbound transactions for order, for reporting all contracts and their status.
- Involved in defining Approval Rule Sets for Purchase Order Approval in PO.
- Used PS8 Features such as Buyer station for creating, editing or approving purchase orders and search criteria in eProcurement.
- Worked on SQR’s to create report for calculating a sales contract rebate for each customer ties to the contract, for creating Sales Order Acknowledgement report, to create Material Authorization, for displaying all Sales Orders with their order totals.
- Applied PeopleSoft fixes and patches to Order Management and Inventory.
- Customized RMA SQR Report to display RMA transactions for internal and external locations in Inventory module.
- Wrote an AE batch process to do the inter-unit transfer i.e. transfer of stock between two inventory business units on a daily basis in PeopleSoft Inventory.
- Supported the multiple testing tracks, prepared summary of test results as well as involved in troubleshooting issues uncovered.
Environment: PeopleSoft 8.4 FSCM (GL, AP, AR, AM, BI, ePro, OM, PO, INV).
Confidential, Feb’05 – Sep’07
- PeopleSoft FSCM Consultant
- PeopleSoft Support, Upgrades, Implementation
- Wrote technical specifications for SQR’s and interfaces in PeopleSoft OM, INV, ePro, AP, PO, Billing modules.
- Exported matched invoices to A/P system and created custom categories for tracking invoice data
- Performed a Security Clean up of all the Production and Development Databases
- Extensively worked with Integration Broker to send a XML document across databases and schemas to synchronize data for members such as personal information, contract data, and dependency data.
- In order to validate the routing no and account no with alliance partners during the customer registration process with the online check-free payment process used Integration Broker setup for outbound synchronization.
- Worked on Configuring Query Security and Object security for the system.
- Apply PeopleSoft upgrades and patches. Configured/enhanced AP Check Printing.
- Developed and customized crystal invoices as per the company’s requirement. Designed, developed and implemented custom Schedule Billing online pages
- Deliver technical expertise by troubleshooting and resolving technical issues, writing and modifying code, creating reports and queries, developing new applications, scheduling batch processes, and assisting end users.
- Troubleshoot and resolve supplier purchase order and invoice issues
- Tested modifications to ensure they meet customer’s specifications. Provided on-call support to the end-user.
Environment: People Soft 8.4 FSCM (GL, AP, AR, ePro, OM, PO, INV)
Confidential,Bangalore Aug’03 – Dec’05
- PeopleSoft Functional Consultant
- Working with Business People and getting their requirements and customizations, Drawing Process Diagrams that helps other team members to understand system easily.
- Configure and setup tables 8.0 setup banks, bank accounts, inter unit accounts using centralized inter/intra unit functionality, sales/use pack defaults and option, withholding environment.
- Assisted in vendor data conversion
- Prepared training document for payables, and trained key payable users for changes in payable 8.1
- Configuration OM, INV, AP, GL, AR setup data (like Business Units, Control data, Vendor Location, Origin, Items etc)
- 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
- Developed test cases/plans to test various applications.
- Communicated between systems using App Messaging and business interlinks, by defining Message channels, nodes, by Publish and subscribe methods, configuring transactions.
- Evaluation, customization and setting up of workflow for Journal Entry Approval, Asset Transfers approval and Voucher Approval Processes, Receivable processes.
- Developing new components, pages, records and people code customizations added.
- Migration and upgrade the customized people code on various record events.
- Setting up of process definitions and process scheduler jobs for various processes.
- Fit gap analysis for various processes and helped users in finalizing various processes.
EDUCATION
- Bachelors of Engineering in Computer Science.