Peoplesoft Fscm Integration And Development Specialist Resume
Pittsburg, PA
SUMMARY
- Confidential is a Manager at Cognizant Technology Solutions, Certified Oracle Fusion Financials AP/GL and Peoplesoft 9.2 Financials Implementation Specialist, 19+ years of functional Architect and integration Expert in Peoplesoft/Oracle fusion Financials and Supply Chain applications.
- He has worked on multiple Implementation, Consulting, Upgrade, Product development, integration, Functional configuration and Support assignments.
- He has been working in various roles in the project life cycle including Project Lead, Configuration Lead, Functional Consultant and ERP Systems Analyst.
- He has in depth Knowledge and strong requirement analysis in CAS(Claims submission) and PAS(Premium payment systems) in Insurance and health care domain.
- Has Deep understanding of HIPAA basics
- He has In depth Understanding of Oracle Fusion Financials GL configurations, Accounts Payables Configurations, Fixed Assets and Cash Management Modules.
- He has in depth understanding and strong functional experience on various process flows like P2P, O2F and R2R cycles of PeopleSoft Financials. And Supply chain functions
- He has 2 years of functional experience with Oracle Financials GL configuration - Ledger, Legal Entities,COA Mapping, Calendar, Currency and SLA and Intercompany system options configurations, Fixed Assets Configurations and involved testing of entire process of Payables transfer to GL,AP Asset creation and Mass additions creation through Accounts Payables
- He has in Depth understanding and integrations expertise with Workday Financials Supplier Accounts and Payment Settlements, Business Assets and Financial Accounting
- He has 14 years of Functional experience in PeopleSoft Financials GL, AP, PO, AR, Billing Contracts, Order Management, Asset Management and Inventory modules and is an expert with reporting tools like nVision and Crystal and PS Query
- He has worked in multiple collaborative models involving onsite-offshore, multi-vendor, multi-stakeholders. He has worked with clients in US, UK/CE, APAC, and Europe.
- He has experience in leading and managing teams in onsite and offshore delivery model-designing & re- engineering of business processes across Supply Chain, Financials applications at various industries like Retail, Higher Education, Health Care and Life Sciences, Banking & Insurance, etc. As part of various engagements worked on Implementation, Re-Implementation, Upgrade, Enhancement and application.
- He has good experience on integrations between PeopleSoft FSCM and Coupa (Source to Pay) Spend Management Saas Solutions. Extensively worked on requirement gathering, data mapping and functional designs for Vendor data, User profiles, Account codes, Budget line information,Invoice payments integrations to Coupa and Purchase order/Revisions, Receipts to AM, Invoice data integrations from Coupa to Peoplesoft FSCM application
- He has worked on integrations between Peoplesoft Financials and other 3rd party Sass solutions like Concur for travel and expense invoice to pay integrations and Configured exclusive Pay Cycle for BOA credit card payments and worked on integrations for Corrigo and Expesite,Costar and Tango for Capital projects and facilities and Lease SAAS solutions for invoices and payments sharing from Peoplesoft AP.
- Experienced in System Analysis and functional configurations.
- Expertise in Analysis, Writing Specifications and Interacting with Users for Application Implementation, Upgrade, and Enhancements.
- Experience in designing and analyzing process/data flow of PeopleSoft Financials.
- Good expertise In Integration between OM, Inventory and Manufacturing Functionalities.
- Experienced in Business Requirement Study, Fit Gap Analysis, As-Is-Process Analysis, To-Be-Process Definition and Functional Configuration, Functional Testing, SIT, UAT, Implementation and Post Go Live Support functions
- Have experience in implementation, customization, testing, tuning, data conversion and maintenance of PeopleSoft FSCM applications from versions 8.x to 9.2.
- I have good working knowledge in PeopleSoft Financials/SCM Modules like Accounts Payable, Purchasing, Treasury, eProcurement, Project Costing, Contracts, Billing, Expenses, Accounts Receivable, Inventory, Order Management, Manufacturing, Asset Management, General Ledger, Customer and Vendor Setups.
- Proficient in PeopleSoft Internet Architecture, People Tools, and Automation Testing tools, Application Designer, troubleshooting AE programs, Workflow, SQR, nVision, Crystal, Application messaging, Integration Broker, Process Scheduler, Security Administrator, Import Manager, Data Mover, File layout, PS Query.
- QA expertise includes system specification analysis, test plan formulation, Functional and Technical Testing, Integration Testing, Performance Testing, Regression Testing and System Testing. Has expertise in manual testing and using automated testing tools such as QTP, Test Director and Quality Center(Mercury).
- Excellent team player with managerial, good analytical, problem solving and communication skills and also am a self-motivated quick learner of any new concepts and technologies.
TECHNICAL SKILLS
Applications: Oracle ERP cloud Financials and Procurement, PeopleSoft 8.x, PeopleSoft 9.1 and 9.2, PeopleSoft Portal, PeopleSoft FSCM (PO, AP, AR, BI,CA, GL,eProcurement, Inventory and AM), Oracle Fusion Middleware Products, Fast Track Upgrade Analyzer., Workday Financials ( Supplier Accounts, Procurement, Business Objects),Oracle Fusion Financials( Invoice to Pay, General Ledger, Fixed Assets)
Saas Applications: Coupa (Source to Pay), TANGO(IWMS), Corrigo (Facilities and Maintenance),Expesite( Capital Project work order management), CoStar\AMT (Lease Management),Chrome RIver
Development Tools: Application Designer, People Code, Application Package, Application Engine, Component Interface, Workflow, Integration broker, UPK3.5.1.,Soap,Jason
Administration Tools: Configuration Manager, Process Scheduler, Data Mover, Change assistant, Security.
Reporting Tools: SQR, PS Query, nVision, Crystal, XML Publisher and Cognos.
PROFESSIONAL EXPERIENCE
Confidential - Pittsburg, PA
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- worked as Functional lead for AP, T&E, PC and Fixed Assets Functions
- Understand the requirement from Business Leads and Financial Controllers for configuring New Legal Entities
- Worked as L1 support for AP, T&E, PC and Fixed Assets Functions
- Working with Users in providing resolutions and make sure application is working as per the configuration
- Supporting Month end processes and make sure all the processes are completed as per schedule primary contact for all production support related issues in FSCM system and make sure all issues resolved with in SLA preparing the test cases and coordinating with users for completing UAT for any new enhancement works
- Leading the LE onboarding team to configure new LE’s for the new locations and replacing existing Rep office to LE’s
- Working with CITI and AMEX card vendors for T&E payments
- Coordinating the offshore work activities to meet Client SLA’s
- Hosting Weekly meetings with Business leads and Team to go over the issue resolution and statuses
- Worked on Inpleo Prepay Auditor Auto approval process and provided Functional design and Testing the solutions
- Worked on PC AM capitalization issues
- Worked on Asset Transfer and adjustment project for big list of existing assets
- Worked on AP and T&E sub ledger LE’ Configurations for new legal entities and worked with AP and T&E user teams For UAT as part of LE onboarding
- Worked with Project Costing team business leads to provide solution and fixing the existing issues with QPR ‘s
- Worked with Project Fund distribution business leads to make sure all funds and costs are distributed and capitalized.
- Working with Oracle Fusion implementation teams for providing BNYM specific requirements and processes
- Coordinating with L2 teams for Technical resolutions for user data related issues
- Working with Audit teams for providing requested information from PFN.
- Worked with Recon teams to make sure Posted subledger to Ledger balances for each period
- Analyzing Fixed Asset issues and providing the solutions
- Preparing Monthly and Weekly status reports and presenting it to business
Confidential, Dallas,TX
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- worked as Integration and functional Analyst for ERP Financials configurations
- Understand the requirement and study the existing processes as part of KT with Parent company
- Analyzing and Creating the Data mapping conversion process
- Configure As is setups for existing supplier and AP/GL Business units, setting procurement options for GL business unit
- Establishing Voucher Origins for various inbound invoice integrations
- Establishing 1099 processing rules for Vendor invoices
- Configure PO dispatch email/print method
- Worked on Integrations with Corrigo (Facilities and Maintenance work order system) to Peoplesoft AP for Capital and expense invoice integrations
- Created Pay cycles for ACH and EFT payment methods
- Worked on Integration for Concur expense and travel invoices inbound to AP and payment out bounds to Concur, Created BOA credit card (Employee credit card) Pay cycle and send the payment file to BOA for payments
- Worked with Expesite for the Capital project work order invoices integration process to AP
- Worked on Functional integrations design document for TANGO(IWMS) to source Purchase orders and receipts to Peoplesoft, Configured to source Invoices from Po's and setup the Matching for TANGO invoices
- Establishes Tax proration rules for PO's to AP
- Worked as Production Support after the post go live and monitoring and creating process manuals for User training
- Responsible for application support to business users, Requirement analysis, coordinating development tasks, making sure all incidents is addressed based on priority
- Create a resolution and root cause analysis document and hosting weekly status meetings
- Supporting the Audit for Change requests and batch failures
- Proposing solutions to automate P2P transaction processing
- Worked with Workday Financials implementation team and go through all the P2P processes and provided requirements to Workday Financials team for Supplier accounts, Procurement and Business Assets function configurations
- Provided Data conversion solution for Invoice history/Active Vendor(Supplier) Connections, Business Assets into Workday EIB's
- Converted supplier Integrations with Peoplesoft to Workday Financial Applications
- Build the EIB’s to Business asset submission to Workday Financials
- Build EIB’s to convert Supplier and Remit to connection data into Workday
- Build Supplier withholding EIB as per data conversion requirement.
- Work with AP manager for Supplier 1099 year end processing and supported Moth end/year/Quarter close
- Coordinating with Offshore team for any production issues and Enhancements work.
Confidential
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- worked as functional Analyst for ERP Financials Production Support Involving multiple Applications like PeopleSoft, Passport, Powerplant and Basware etc.
- Responsible for application support to business users, Requirement analysis, coordinating development tasks, making sure all incidents is addressed based on priority create resolution and root cause analysis document and hosting weekly status meetings supporting Audit for Change requests and batch failures
- Working on Enhancements and coordinating with Technical team for End to End testing of integration
- NV Energy has highly customized and diversified applications for various services, worked as a Integration analyst for Peoplesoft integrations with Passport,Maximo to PC,Bassware to AP, Hi Jump Handheld device to Peoplesoft inventory,
- Documented all P2P process and worked extensively resolving the Requisition/change PO issues, configured Pay cycles to vendor payments
- Configured Automatic Bank reconciliation for AP disbursement Bank accounts
- NV Energy uses Purchasing function as a backbone of the procurement process and configured automated sourcing of Requisitions, Requisition Approval workflow and sending emails to Approvers
- Integrating Purchase Order functions with Inventory ( PO is auto raised for in Demand and putaway processes) and Accounts Payable( 3-Way matching configuration and Adjustment voucher configuration)
- Configured the system for buyers to create inventory and non-Inventory PO's
Confidential
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- providing Application support to Business users, Requirement analysis, coordinating development tasks, Fit gap Analysis for Peoplesoft upgrade, Brainstorm with Business Leads on issues and determine possible solutions and narrow down to most appropriate solution.
- Create Functional requirements document and FDD's and review the Functional designs with Stakeholders and coordinate the Development effort with offshore
- Troubleshooting and Resolving functional issues, Document business processes which included most of the Financial modules like GL, Expenses, AP,AM and PO.
- Worked as functional integration expert in design and Creating requirement document for Coupa to People soft Financials integrations, Creating functional Design document with data mapping details for Coupa to Poplesoft Procure to pay functions, like Supplier /Accounts code User profiles and Invoice Payment outbound integration processes.
- Worked on coupa purchase order/Revisions and Receipt inbound process to capitalize the received goods into Asset management and Invoice to Pay integration for Supplier payments
- Configuring Matching Process for 3-Way matching for PO, Receipt and invoices, send the exceptions notification email to Coupa
- Configuring Approval workflow to Journal Entry for online
- Worked on integrations for providing User hierarchical data from Workday HCM and Peoplesoft financials.
Confidential
PeopleSoft FSCM Integration and Development Specialist
Responsibilities:
- Setup and demonstrate what is involved in creating / processing work orders from Backlog sales Orders.
- Defined the message exchange structure needed to integrate with their Manufacturing Function at Netherland.
- Customize the PeopleSoft Delivered Production Processes to make it auto mate their OM, Inventory, Production processes as touchless Orders to Production.
- Process and message exchange to do cycle counts with 3rd party logistics provider.
- Design process to release email notification when a product/item is released that requires setup of information Global Fulfillment Compliance.
- Setup intercompany processing for transfers to/from KIRIN (since that is an inventory held in DKK and the other inventories that it would exchange with would be in USD).
- All of Confidential ’s other inventories are in USD and do not require intercompany processing.
- Meetings with management on status and issues.
- Co-ordinate with DBAs to integrate Application level changes like indexes and migrations across all the PeopleSoft FSCM instances.
- Developed and Customized People code changes, Component Interfaces, App Messages, Application Packages, Application Engine Programs
Confidential, California
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- Thorough study and understanding of the client’s business process in order to identify the basis for the Upgrade
- Review of all the setup and configurations for GL and AP modules
- Review of 3rd party applications and interfaces integrated with the system
- Documented existed customizations like Journal entry Upload, AP Voucher Upload and Amex Vendor creation.
- Requirements gathering & preparing functional fit gap document
- Executing functional tasks in Change Assistant job
- Involved in the design and development of reports for GL, AP and PO modules using nVision and Crystal Reporting tools
- Involved in writing test scripts and executing the scripts for testing the delivered processes in AP and PO modules after
- End-to-end testing of all the delivered processes per client requirements after Upgrade.
- Functional testing of PeopleSoft delivered processes in AP, and GL modules including Voucher Creation, Budget Check, Voucher Post, Pay Cycle, Payment Post, Journal entry, Edit and Posting Journals, Allocations, Confidential JE Upload customization process etc
- Bug fixing and issue resolution that occur during the testing phase
- Training users on new system
- Setup Document Attachment functionality at Voucher entry and Journal entry levels
- Configured Journal Approval Workflow and Voucher Approval workflow with multiple Stages, Paths and Steps in order to trigger Approval workflow process at multiple levels.
- Configured ACH Process for the Business Units. Defined the Ach setup at various levels like Vendors, Bank setup, Pay cycles for ACH etc.
- Configure Prepayment Vouchers setups - Defining Prepaid Expense Account, Associate the prepaid expense account in the Template and Specify the Prepayment amount limits at the User profiles.
- Define Template Vouchers for the Business Requirements in AP.
- Customize Existing Queries to better assist the client requirements in various modules like AP and GL.
- Define new Time Spans, Calendars and nVision Layouts for Balance Heet, revenue and expense reports by departments and Operating Units.
- Customize existing nVision reports by defining Scopes in order to retrieve reports for Multiple Business Units.
- Created New Queries for Voucher Unpost Activity, Unposted Journals activity, AP Outstanding Payments Activity.
- Customize Crystal reports in AP and GL and deploy the same.
Environment: Windows 2008/Linux, Oracle 11g, PeopleSoft Financials 9.1, PeopleTools 8.51
Confidential, CA
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- Presented and implemented Data archiving process for SCM In demand fulfillment process using PeopleSoft Data Archiving Manager
- Presented its performance level benefits and statistical metrics of archiving process after and before analysis
- Monitoring the day to day processes and recoding process runtimes through Process monitor.
- Solving and Bug fixing on the reported and assigned issues.
- Tracing through various PeopleSoft troubleshooting options to improve performance of the processes.
- Configured and tested People tools data archiving for major transactional tables
- Fixed Vendor withholding issue in AP voucher payment.
- Fixed AP Vendor approval workflow process
- Fixed and improve the PO Budget Check Processor performance.
- Performance Tuning Specialist and Data Conversion and Archiving Team Lead
- Tuned SQL’s for PO Dispatch SQR process
- Improved Product Orders, In demand and Order hold related Queries
- Tuned Order Reservation and fulfillment processes in inventory.
- Customized Inventory Cycle counting procedure and tuned Inventory Balance report.
- Tuned and Fixed the delivered Cost accounting Process for Inventory transaction accounting entries
- Improved the performance of GL Journal Copy, Journal Edit and Post processes
- Fixed Allocation and Translation Processes.
- Prepared the functional Specifications documents for R2R transactional data conversion and Archiving process.
- Configured Eliminations and consolidations process for Q, Month end processes and nVision Layouts for Consolidation reports.
- Improved (Tree) Ledger based and query based YTD, Income Statement Flash and Trial Balance nVision reports to make month end close process smoother.
- Documenting the solutions on the cases resolved, in the Confidential Planet Share point
- Co-ordinate with offshore developers.
- Review of documents & corrections with business users.
- Meetings with management on status and issues.
- Co-ordinate with DBAs to integrate Application level changes like indexes and migrations across all the PeopleSoft FSCM instances.
- Requirement gathering and Designing Data Archiving process prototype using Demand Fulfillment transactional records and related GL transactions in the FSCM Order to Fulfillment process.
- Building custom Data archiving Template objects and Archiving queries, Developed new Pre and Post Archiving Application engine programs.
- Developed test scripts and ran the UAT and moved all unused and aged transactions to historical records to meet the Confidential Requirement upon submitted performance metrics to the Confidential
Confidential
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- Functional and Interface testing Team Lead
- Create a detailed test plan
- Create test scripts to test vanilla and client specific (customized) processes and features in all modules
- Interview business users and IT to understand customizations, chartfields and combination values used for testing.
- Review test scripts with business users and modify as needed to produce a final script
- Conduct functional test, configuration test and system integration test
- Document all test results and review with users
- Verified the vendor functional process to generate PO’s for a vendor.
- Customized Application Messages to reflect Products, Customers in CRM
- Assist users in the User Acceptance Test phase and support them with troubleshooting, bug/fix etc.
Confidential, San Francisco
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- Worked and customized Vendor based Voucher EDI inbound process to create invoices into AP
- Performed manual testing, prepared test cases and scripts for creating regular vouchers through EDI and voucher build process.
- Resolved day today user issues Troubleshoot, debugged technical and functional issues.
- Designed, modified and customized SQR and Crystal Reports to meet the customer’s requirement.
- New vendor setups has been done for newly created UK global AP Business Units.
- Created External Billing interface process to load invoices into billing through delivered interface tables.
- Created test cases and performed integration testing for external invoices loaded into billing and through AR and GL.
- Setting up new business units for their new offices and integrating Billing, AR to GL, consolidation process setups for new business units, Customizing Consolidation.
- Documented Business unit setup flow and integrated AP and GL, AR, billing and GL.
- Made Enhancement to the custom developed objects as per the latest requirements.
- Tested and migrated developed objects to Production Database.
Confidential CA
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- As Team Lead Co-ordinate with business users for requirement gathering.
- Process review, Understanding of Customizations and Processes.
- Task allocation and Monitoring.
- UPK Development, Testing, Publishing and documenting.
- Co-ordinate with offshore developers.
- Review of documents & corrections with business users.
- Meetings with management on status and issues.
- Co-ordinate with application DBAs to integrate the custom UPK content with PeopleSoft content and help.
Confidential
PeopleSoft FSCM Integration and Development Specialist
Responsibilities:
- Created High Level and Detailed Design documents.
- Defined GL accounts and mapped the chart field combination for AP, GL integration and Inventory and GL Integration. Done manual testing for AP, GL integration by posting voucher accounting entries and generated subsystem AP journals and posted to the ledger.
- Determined necessary customizations.
- Worked on cleaning up the data vendors, ultimately supplying the list of vendors to be loaded into PeopleSoft 9.0, along with any data mapping values necessary to perform conversion.
- Identified the active vendors and converted their associated information. Configured new Vendor IDs for the vendors that were converted.
- Developed various reconciliation queries between AP, AM, AR, BI, PO, and GL and reported the reconciliation using Crystal and SQR.
- Configured DEV and created detailed configuration workbook.
- Worked extensively on Vendor data cleanup and configured the vendor structure.
- Implemented PO Amount and Requisition approval Work Flow process.
- Customized Dispatch PO Print SQR process.
- Provided Functional Specification for single payment vendor information conversion program.
- Provided Production support and user training to the financial staff of Confidential .
- Developed the training documentation for AP, GL, PO, AR, BI, and AM modules for the end users.
- Tested and Migrated developed objects to Production Database.
Confidential
PeopleSoft FSCM Integration and Development SpecialistResponsibilities:
- Provided Production support and user training to the financial staff of One & Confidential, South Africa.
- Resolved day to day user issues Troubleshoot, debugged technical and functional issues.
- Designed, modified and customized SQR and Crystal Reports to meet the customer’s requirement.
- Created High Level and Detailed Design documents.
- Worked on cleaning up the vendors, ultimately supplying the list of vendors to be loaded into PeopleSoft 9.0, along with any data mapping values necessary to perform conversion.
- Developed various reconciliation queries between AP, PO, and GL and reported the reconciliation using Crystal and SQR.
- Developed Component interfaces and entry templates to load item related data into inventor tables, Custom Queries, nVision Reports, customized the PeopleSoft delivered components (Tables, Pages, and Menus) to meet the customer’s requirement.
- Developed Vendor Item price bidsheet interface
- Made Enhancement to the custom developed objects as per the latest requirements.
- Developed new custom objects to meet the client’s new requirement.