Peoplesoft Techno/functional Consultant Resume Profile
Houston, TX
SUMMARY:
I am a PeopleSoft techno/functional consultant with over Ten years of IT experience. I have been part of implementing PeopleSoft Financials Supply chain modules for different clients which includes Full-Life Cycle SDLC implementation, Upgrades to 9.X, Production Support and have extensive Functional and Technical Experience in implementation of PeopleSoft Financial Supply Chain Modules like Project Costing, Contracts, Billing AR, Purchasing, AP, Inventory, Sales Order Management, Travel Expense and GL modules Version 9.1, 9.0, 8.9, 8.8, 8.4, 8.1, 7.5 .
- Techno-functional Proficient in FIT-GAP Analysis, Design, Development, Customization, Upgrade and Maintenance of PeopleSoft Applications.
- Expertise in PeopleSoft technical development, upgrade, interfacing, conversion, data migration / mapping, security administration, tech Support and Report writing using App Engine with XML Publisher, SQR, Crystal and other PeopleTools.
- Proficient in the use of: Application Designer, Application Engine, Component Interface,SQR,People Code,Workflow, Cobol,Data Mover, Import Manager, Security Administrator,PSQuery/Crystal Reports,xml publisher, n Vision.
- Good functional Understanding and working experience in Accounts Payable, Purchasing, Accounts Receivable, Billing, General Ledger, Cash Management,Treasury Endorsements,Projects , e-procurementHR, Benefits, Payroll, Payroll Interface, Time and Labor.
- Expertise in applying patches, bundles and maintenance packs to the PeopleSoft systems.
- Developed multiple PeopleSoft FSCM HRMS interfaces both outbound and inbound with third party systems using SQR, Application Engine, Component Interfaces, Integration Broker and File Layout.
- Worked with Security Administrator to implement security in various levels. Creating Roles, Permission Lists, User Profiles, Portal Security, folders, Content references and Definition Security.
- Extensively worked with PeopleSoft reporting tools like SQR Reports, Crystal Reports, PS/nVision, PS Query and Tree Manager, App engine with XMLPublisher.
- Excelled in the areas of PeopleSoft Internet Architecture PIA and Open Integration Technology tools likeComponent Interface, Integration Broker for interacting with in and outside PeopleSoft applications.
- Good working experience in BEA Web logic Portal .1
- Hands on Experience in configuring Integration Broker with third party systems and PeopleSoft systems.
- Proficient in the usage of STAT 5.3.1, a change management and version control tool.
- Possess good knowledge in RDBMS, Web/Client-Server applications and security.
- Good at Analytical thinking, Testing, troubleshooting, and Error fixing.
- Served as the key point of contact/Liaison between on and offshore resources.
- Excellent oral/written communication and presentation skills and a good team player.
Technical skills:
Application | PeopleSoft Financials v8.0-9.1 AR, AP, GL,AM, GL,Billing,Treasury, PO, e pro and HRMS Core HR, North American Payroll, Global Payroll, Benefits administration, T L |
Development Tools | Application Designer, People Code, Application Engine, Process Scheduler,SQR,Cobol, Data mover Component Interfaces, Application Messaging,Integration Broker. |
Reporting Tools | PS Query, PS/nVision, SQR, Crystal Reports, Xml Publisher |
Administration Tools | Security Administrator, Object Security and PeopleTools Utilities, Data mover |
Operating Systems | Windows XP/2000/NT 4.0/ 95/98, UNIX. |
Languages | SQL, PL/SQL, SQR, COBOL, HTML, JDK, C, C . |
Databases | Oracle 9i, MS SQL Server. |
Web Programming | ASP, HTML, DHTML, JavaScript, Java Applets, Servlets. |
Professional Experience
Confidential
Title: PeopleSoft Techno/Functional consultant
- Resolved day to day production issues for Financial Supply chain modules.
- Performed viability assessment for XML Publisher now BI Publisher for batch reporting needs.
- Designed and developed xml publisher reports for Grants department using application engine BI publisher
- Created a one-click solution enabling the option of running XML Publisher reports to a new window in either Excel or PDF in single mouse click bypassing process monitor .
- Provided complete training and documentation for technical staff.
- Worked on resolving issues with AP Pay Cycle Manager, Voucher Posting, Matching Processes.
- Worked on trouble shooting the issues related to various Application Engine programs like PO AUTOSRC,PO CALC.
- Setup transactions between PeopleSoft Trapeze using Integration broker, Created custom handlers for inbound / outbound transactions.
- Worked on the customization of PeopleSoft delivered PO Approval Workflow process to provide multiple levels of approval based on Amounts.
- Worked to customize the PO Dispatch SQR program as per client requirement.
- Created Crystal reports to List all the Open Purchasing Order's.
- Developed Interface program using File Layout, Application Engine, and Component Interface, which loads data from flat file into staging tables while doing various data validations using AE PeopleCode and finally loads into PeopleSoft tables through Component Interface.
- Trouble shooted complex SQR programs to resolve reporting issues for custom module
Environment: PeopleSoft Financials 9.1, People Tools 8.52, Windows NT, UNIX and SQL Server.
Confidential
Title: PeopleSoft Technical consultant
- Designed and developed custom Asset Management component to enable operational users to create Assets for off shore drilling business units.
- Extensively involved in customization of Asset management module to facilitate various business requirements.
- Customized issuing inventory work order page to launch main Asset Management entry component facilitating to pass the search values from work order page.
- Customized meter reading page to default reading of meter values for new meters.
Environment: PeopleSoft Financials 9.1, People Tools 8.5x, Windows NT, UNIX and Oracle.
Confidential
Title: PeopleSoft Techno/Functional consultant
- worked as a techno functional consultant for the integration of PeopleSoft Financial Applications with clients Invoicing systems
- Designed functional and technical documents for the seamless integration of AR/BILLING/GL/TRAVEL EXPENSE with Invoicing application system.
- Participated actively in Fit / Gap analysis sessions. Analyzed existing business processes.
- Set up new Payables Business Units. Defined Table Set sharing, SetId and Record Groups.
- Configured AP matching rules, established AP accounts, distribution codes and set-up payment terms.
- Designed and tested GL Interface.
- Defined and setup SET IDs. Defined GL Business units and setup GL security with Permissions Lists, User Roles and Profiles.
- Provided complete training and documentation for technical staff.
- Configured Business Units, Ledgers and Ledger Groups.
- Designed and developed complex SQR programs for report writing and integrating data with third party systems.
- Performed AP-GL reconciliation and created queries to check flag status to assist in future.
- Designed, configured and tested ACH and check payments with Bank of America.
- Created test scripts for Journal Entry, Journal Upload and Journal Processing.
- Created and executed Test Scripts for unit testing in GL for testing 'Journal Entry', 'Open a Period', 'Close a Period', etc functionality.
- Established Pay Cycles and troubleshot pay-cycle exceptions.
- Built complex custom inbound and outbound Application Engine interfaces to support custom transmission of financial data to warehouse distribution as well as confirmation of invoicing.
- Configured Accounts Payable to utilize Payment Matching and generation of annual 1099s.
- Designed test plans for AP Vendor related functionality like, Vendor Definition, One-time Vendor Definition, 1099 Vendor Definition, Inactive Vendor and Vendor Maintenance.
- Designed and configured vendor categories and withholding codes 1099 .
- Resolved day to day production issues on AR/BILLING/GL modules.
Environment:PeopleSoft Financials 9.0, People Tools 8.50, Windows NT, UNIX and Oracle.
Confidential
Title: PeopleSoft Techno/Functional consultant
- Worked as a techno functional consultant for the support and enhancement of PeopleSoft Financial Applications.
- Designed, Configured and developed Integration Broker xml messages to load data from third party systems Ops Technology to AR/BILLING modules. Which includes creating setup, develop message people code and also testing, documentation of web services technology.
- Worked on AWE Approval workflow engine to setup workflow for approving expense, vouchers.
- Designed and developed interfaces for Accounts Payable using Integration Broker messages, And also Application engine/file layout for file based integration.
- Applied patches, bundles and maintenance packs to the PeopleSoft systems.
- Implemented T E expense rules for reviewing and Prepay auditing expense reports.
- Integrated, Designed, Developed interface programs for Travel Expensemodule with Accounts Payable for payments of employee expense reports
- Integrated, Designed, Developed interface programs for Travel Expense module with Accounts Payable for payments of employee expense reports.
- Responsible for the Implementation of Expense module for UDR inc.
- Designed customized custom approval processing for Expense processing and reporting.
- Developed Several Custom Validations that need to be Done Prior to Expense Report and Cash Advance Submission
- Configured ImageNow to Integrate PeopleSoft with Imaging System so Users can Enter and Store Receipts.
- Designed and Developed interface programs for PeopleSoft General Ledger with Hyperion reporting system.
- Extensively worked on integrating Accounts payable data with PNC Banks for payments to Vendors.
- Designed and configured workflow for Approving Vouchers in AP module.
- Extensive experience in developing and customizing reports using PeopleSoft Query, SQR, Crystal Reports and nVision
- Designed and developed custom XML Publisher reports for AP, AR/BILLING, PURCHASING, EXPENSE and GL modules.
- Resolved expense workflow issues for HR supervisor, Prepay auditor approvers.
- Designed and developed XMLP reports for AP, EXPENSE, GL modules.
- Configured and developed programs for reconciliation of payments with Banking and AP module.
- Resolved Asset Transfer issues for Asset Management between different Business Units.
- Involved in day to day production support for all the financial modules like AR/BILLING, AP, EXPENSE, GL.
- Trained business users for the custom processes in AP,AR/BILLING,EXPESNE module.
Environment: PeopleSoftFinancials 9.0, People Tools 8.50, Windows NT, UNIX and Oracle.
Confidential
Title: PeopleSoft techno/functional consultant
- Handling Business Process Workflows for the PeopleSoft Financials modules AR, BI, GL, AP, AM, PO, Contracts, PC, Travel and Expense in a technical capacity.
- Involved in Day-to-day interactions with the Users on the Project Costing, Accounts Receivable, BILLING and Travel ExpenseDevelopment requirements and Change requests.
- Extensively working on Integrating PeopleSoft Financial modules with HRMS Third party applications using Integration Broker, Component Interface, and Financial Gateway Application Engine.
- Evaluating the delivered applications and designing developing the enhancement to fit the business requirements.
- Designed and developed interfaces for Accounts Receivable, BILLING to sync data from third party systems using Integration Broker xml messages ..
- Designed and developed batch process for integrating Project Costing data with third party applications using SQR.
- Developed custom pages for Project Costing modules to process the data from external systems.
- Designed and developed Application engine with Component interface to upload the contract rate data.
- Designed and configured to route vouchers from Accounts payable clerks to voucher coders using Approval workflow engine.
- Developed nVision reports for multi-currency reporting that were being created manually. Created query and crystal reports used in an initiative for better Cash flow reporting.
- Designed and developed interface programs for Accounts Payable to read flat file data and load into payables transaction tables using Application Engine.
- Designed and development xml publisher reports for BILLING/Purchasing modules.
- Designed and developed interface between General Ledger and Congo's reporting system using SQR to have the ledger balances.
- Customized the delivered pages for Accounts Payable as per the business requirements.
- Customized delivered pages, peoplecode to fit the business requirements.
- Extensively worked Application Engine, Component Interface to load the external data into PeopleSoft modules.
- Supported the testing group to resolve the issues and trained business users in processing the customized applications.
- Designed and developed interfaces for AP modules to load the voucher data from third party systems.
Environment:PeopleSoft Financials 9.1, People Tools 8.51, Windows NT, UNIX and Oracle.
Confidential
Title: PeopleSoft Technical Consultant
- Worked closely with end users and business analysts to understand client functional requirements and designed technical specifications.
- Customized Delivered applications using People Tools, People Code, Application Engine.
- Interacted with users to understand the business requirements and developed technical specifications. And assisted existing team with report and interface development.
- Support Development on Student Records, Student Financials and Contributor Relationship
- Created new Aid Year specific objects which includes creating records, pages, components, Peoplecode, AE, File Layouts SQR, COBOL etc from the previous years.
- Used Person Model Concept for retrieving data from HRMS tables to be used for Campus Solution processes.
- Designed and developed conversion and audit programs to convert into PeopleSoft Grants, Contracts, Customers Grant Sponsors , GL Journals.
- Worked extensively in resolving the defects in various phases of testing of the application.
- Worked in the production support team to resolve SQR, ApplicationEngine andPeople code issues.
- involved in end to end testing of the PeopleSoft modules Purchasing, Inventory, Accounts Payable and General Ledger.
- Designed and developed the custom Application Packages to enhance the business process for custom modules.
- Customized PeopleSoft delivered Posted Voucher Listing Crystal report APY1020.rpt for AP module.
- Carried out Integration test, System test for Accounts Payable Interfaces and trained Business Users processing the interface voucher data.
- Developed custom online pages as per the Business needs which will intern benefited for entering the daily transactions.
- Supported day-to-day operations like applying updates and fixes, analyzing production support issues.
- Extensively worked on Functional areas like Billing, General Ledger, Accounts Receivable and Accounts Payable to address the production defects.
- Used the Application Engine for writing the Component Interfaces in Admissions and Financial Aid modules for reapplying the business logic associated with PeopleSoft delivered components using the existing PeopleSoft Component APIs.
- Designed and developed an Application Engine which uses Component Interface while loading third party Billing System into PeopleSoft Account Receivables
- Defined security user profiles, roles, and permissions
- Developed various reports as per customer requirements
- Developed a new report from scratch using XML Publisher to generate the count of students that were awarded degrees for the last 5 years. Sort by academic plans. Sort by degree type. Sort by gender. Sort by ethnic origin.
- Provided production support to fix the bugs and to customize new enhancements.
Environment:PeopleSoft Campus Solutions 9.0, Financials9.0, People Tools 8.49/8.50, Window NT, UNIX and Oracle.
Confidential
Title: PeopleSoft Techno/Functional Consultant
Responsibilities:
- Worked as Techno/Functional consultant for the implementation of PeopleSoft8.8 System from the legacy PeopleSoft 7.5 financials.
- Involved in the Requirements Gathering Phase for AP, GL, AR,BILLING and designed functional design documents for AP ,AR,BILLING GL.
- Involved in mapping the business requirements implemented in PeopleSoft 7.5 financials to FSCM 8.8 system.
- Did configuration setup for GL, AP, and AR which includes setting up core people soft GL Tables. Setting up chart field value setup, inter and intra unit processing for NEC, setting up vendor tables and customer tables.
- Developed the conversion programs for the conversion of Customers, Customer Conversations, Bills, Items, Vouchers andPayments from PS 7.5 to PS 8.8.
- Designed and configured the Integration Broker setup between PeopleSoft Financials and PeopleSoft CRM to do the full synchronization of Customer information between two systems.
- Designed and developed Interface programs using Application Engine,EDI Managerfor Accounts Payableto generate vouchers from third party Travel expense system concur
- Carried out Integration test, System test for Accounts Payable Interfaces and trained Business Users processing the interface voucher data.
- Designed and Developed interface programs using Application Engine EDI Manager for PROCUREMENTmodule to import the external PCard Data.
- Designed and Developed Several SQR programs to interface the Procurement Data for ARIBA system Spend analysis system .
- Carried out Integration test, System test for ADP to GL and trained Business Users in running the ADP process to GL.
- Created UNIX shell scripts to enable the transfer of files through Secured SFTP process and carry on the acknowledge process and backup process.
- Extensively worked on SFTP process by creating UNIX shell scripts for providing files to interface programs and creating backup directories for the processed files.
- Designed and developed Vendor Import program to import vendor information from third party system to people soft Accounts payable using Application Engine, Component Interface and File Layout.
- Extensively working on Production support and resolved issues in BILLING/AR/GL/PO Modules based on the priority levels.
Environment:PeopleSoft 7.5, FSCM 8.8, People Tools 8.48, Window NT, UNIX and Oracle 9i.
Confidential
Title: PeopleSoft Techno/Functional Consultant
- Prepared technical design documents for ORDER MANAGEMENT, Purchase Orders Requisition Contracts for Vendors.
- Lead the report development team for developing new reports, testing handled the production issues for the new reports.
- Integrated the legacy Purchase Orders Requisition Contracts Printing Process into FSCM9.0 using XMLPUBLISHER reporting tools.
Environment: PeopleSoft FSCM 9.0, People Tools 8.48, SQR UNIX and Oracle.