Peoplesoft Technical Consultant Resume Profile
Albany, NY
PROFESSIONAL SUMMARY:
- Over Seven years experience in Information Technology that included gathering user requirements, systems analysis, systems design, integration, data conversion, stabilization, training and support of Client Server and ERP applications.
- Seven years of PeopleSoft Financials experience in wide range of modules including Accounts Payable, Purchasing, Travel Expenses, General Ledger, Commitment Control, Accounts Receivables, Billing, Deal management, e-Procurement, Contracts, Project Costing on UNIX and Windows platforms.
- Immensely worked in wide variety of industries like State project, Banking, Telecom and Consulting Industries.
- Expertise in PeopleSoft technical skills such as PeopleTools Application Designer, PeopleCode, Application Engine, Application Package, Component Interface, File Layout, Process Scheduler, Workflow, Query and Data Mover , SQR and Crystal Reports.
- Strong PeopleSoft functional experience with solid understanding of accounting principles and transactions used to conduct business.
- Participated in all phases of ERP full-life cycle Implementation, Customization, Development, Production Support and Upgrade.
- Involved in upgrade projects like people tools upgrade and application upgrade.
- Performed extensive debugging and performance tuning of various processes.
- Well versed in utilizing tools and Application Engine trace for troubleshooting.
- Extensively worked with Security Administrator to implement security in various levels such as Creating Roles, Permission Lists, User Profiles, Portal Security, folders and Content References.
- Good experience in data extraction System Integration from legacy and third-party systems to PeopleSoft application database tables and Integration of PeopleSoft system with various applications, handling issues while mapping data and migrating data into PeopleSoft environments.
- Performed ongoing support for applications including system/batch monitoring and processing, handling user questions and queries, investigating and solving system problems, and providing on-call support services 24x7 supports .
- Excellent troubleshooting, analytical, interpersonal, problem-solving skills good understanding of business procedures and ability to work as an individual and also part of the team.
- Good Understanding of PeopleSoft n-tier architecture and infrastructure.
- Interacting with QA team in completion of testing process to produce Test plans, scripts and cases.
- Work with users and other teams to gather project requirements.
- Extensively worked with Development Tools, Administration Tools, Reporting Tools and PeopleCode.
- Technically proficient in Upgrading, Integrating, Conversion, Data Migration, Component Interface and Application Messaging.
- Worked closely with end-users in resolving issues, providing application support and troubleshooting user access and performance issues.
- Extensively developed report applications using SQR, PS Query and Crystal Reports.
TECHNICAL SUMMARY:
ERP PeopleSoft Functional | PeopleSoft FSCM 9.1/9.0/8.9/8.8/8.4 Account Payable, Purchasing, e-procurement, T E, General Ledger, Commitment Control, Account Receivable, Billing, Treasury, CDM, Project Costing, Contracts |
ERP Tools | Application Designer, Application Engine, Component Interface, Integration broker, File Layout, Application package, Data Mover, Maintain Security, Query, Process scheduler, Tree Manager, Application Messaging, File Layout, Workflow. |
Languages | PeopleCode, XML and PL/SQL |
Database | Oracle 8i/ 9i/ 10g/ 11g and MS SQL Server |
Reporting Tools | SQR, PS/Query and Crystal Reports. |
Other Tools | Quest STAT, ODI Oracle Data Integrator , MS office. |
PROFESSIONAL EXPERIENCE:
Confidential
PeopleSoft Technical Consultant
Responsibilities:
- Involved in system study, analysis, design, coding, testing and debugging of implementation.
- Extensively worked on the Accounts Payable, Purchasing, Travel Expenses, General Ledger, Commitment Control, Deal management, Accounts Receivables, Billing, Contracts, Project Costing and Custom Modules.
- Involved in the Implementation of PeopleSoft 9.0 Financials and SCM Modules.
- Developed complex custom modules using Component Interfaces, Application Engine Programs, Packages and efficient Exception Handling techniques.
- Designed and development entire Lien modules to capture vendor payments related to liens.
- Developed a custom application engine processes to create/update liens based on input file and to generate a file based on the Vendor data.
- Worked extensively on developing bolt on custom Audit Filters Module to release vouchers and expenses for payments based on various filter criteria.
- Modified PC EX TO PC Application Engine program to Include custom project types.
- Worked on ODI Oracle Data Integrator to load data from legacy systems into staging tables.
- Integrated ODI with PeopleSoft using Integration broker and Application packages and excel to CI to load Vouchers, Purchase orders, Expenses, budget journals, GL Journals and Direct journals.
- Created many custom application packages to handle scenarios like PO Add, Change orders, Cancel, Voucher changes and cancellations for data coming from external systems.
- Developed custom Application Engine processes to capture cash and corresponding revenue/Expense transactions for AP, T E, GL, TR and AR to create journals in CASH ledger to maintain Cash basis System.
- Created an Accounting Entry Definition and General Journal Template to create journals from custom accounting table.
- Developed custom page to maintain cash ledger set up which maintains accounts/funds/Sources to exclude based on Sub-System.
- Developed custom program to load journals from MOD ACCRL ledger to ACCRUAL ledger based which is used for reporting purposes.
- Developed custom application engine program to extract payroll budget chart strings for payroll system.
- Worked on creating Web Services to invoke PeopleSoft Budget check process and Custom Application Engine.
- Worked on Outbound Interfaces to send Transactions from PeopleSoft to Agencies by using ODI Oracle Data Integrator .
- Developed SQR for displaying the data for State and Agency users.
- Actively involved in Production Support by Performing Tests using Mercury QTP, Trouble Shooting and Bug Fixing.
- Provided support for the project during the deployment of the code into production.
- Created batch scheduling document for scheduling jobs in production.
- Prepared Technical specifications, Functional specifications, Test Case docs, release notes, training materials and other documentation and provided cross training to users on the developer tools.
- Responsible for maintaining projects/code in DEV, Unit test, System test, UAT and Production systems by generating compare reports and resolving discrepancies.
- Extensively worked on Migrations through STAT.
Environment: PeopleSoft Financials 9.0, PeopleTools 8.49, PeopleCode, SQR, Application Engine, PS Query, Application Designer, HP Quality Center, UNIX, STAT, Oracle 11g.
Confidential
PeopleSoft Technical Consultant
Responsibilities:
- Involved in the Upgrade of PeopleSoft 8.8 version to 9.1.
- Worked on impact analysis of the Upgraded objects.
- Involved in Retrofit of the delivered and custom PeopleTools objects.
- Developed technical specifications for the custom applications.
- Worked extensively on Application Engine, PeopleCode.
- Involved in migrating objects between different PeopleSoft instances.
- Involved in system testing of the objects that were retrofitted using the client's existing system test scripts.
- Resolved issues in Query Manager and fix the issue to accommodate Users request.
Environment: PeopleSoft 9.1/8.8, PeopleTools 8.50/8.48, Application Engine, Data Mover, PS Query, Oracle, UNIX, Oracle 10g.
Confidential
PeopleSoft Technical Consultant
Responsibilities:
- Involved in the Upgrade of PeopleSoft 8.8 version to 8.9 version and production support of 8.9.
- Worked Extensively on Retrofit of the Custom and delivered PeopleTools objects.
- Worked extensively on Application Engine, Peoplecode and SQRs.
- Wrote technical specifications for the custom applications developed.
- Extensively used Application Designer to create projects for development and migration purposes.
- Participated in system testing of the retrofitted objects using existing scripts.
- Resolved issues with the Expense reports in Travel and Expense module.
- Maintained all Application Engine applications like ARUPDATE, GLPEDIT, VOUCHER EDIT and VOUCHER POST processes on day-to-day activity.
- Resolved issues in Query Manager and fix the issue to accommodate Users request.
- Responsible for the development of custom reports in Accounts Payables, Accounts Receivables, Project Costing, and Billing Module.
- Resolved Client's PO Issue i.e. PO copy method was processing PO with a vendor that has vendor status inactive and vendor unavailable for ordering.
- New Interfaces were written using SQR to get data from legacy system into PeopleSoft Billing.
Environment: PeopleSoft 8.9/8.8, PeopleTools 8.49/8.47, SQR, Application Engine, Integration Broker, Data Mover, PS Query, Oracle 10g, UNIX, STAT.
Confidential
PeopleSoft Technical Consultant
Responsibilities:
- Involved in Implementation support of PeopleSoft Financials modules GL, AR, BI, AP and T E and SCM modules Purchasing and Inventory 8.9
- Resolved issues in Travel and Expense modules like Expense Report creation.
- Developed complex custom bolt-on modules using Application Packages, Application Engine Programs and Component Interfaces.
- Resolved issues for Employee Load Program and Employee Payment Notification in Travel and Expense modules.
- Created a script to run when PC EX TO PC Application Engine program fails to clear the staging tables and the temp tables.
- Developed Data Mover scripts to import and export between different databases.
- Created custom Pages in Travel and Expense module as per Business requirements.
- Resolved issues related to Workflow. The PO was getting routed to wrong supervisor.
- Resolve issue with Combo Edit process in General Ledger module.
- Resolved issues with the Expense module for Expense reports not get approved.
- Customized SQRs in the Accounts Receivable module.
- Extensively used Peoplecode in the App. Engine to work with Flat files using different formats.
- Built new Queries and modified existing ones for AP using PS Query.
- Used Utilities for creation of new messages in message catalog as per Business requirements.
Environment: PeopleSoft Financials 8.9, GL, AR, TE, AP, BI, PO, CA, PC, SQR, Crystal Reports, Workflow, People Tools Application Designer, Application Engine, Integration Broker, PS Query , Oracle 9i, STAT.
Confidential
PeopleSoft Consultant
Responsibilities:
- Involved in Support and Customization of PeopleSoft Financials modules.
- Extensively supported GL module and AP module.
- Worked on creating Web Services to invoke PeopleSoft Budget check process and Custom Application Engine.
- Created Messages, Message Channels, Transactions and PeopleCode methods to handle the sending and receiving of messages that contain the high security business data.
- Resolved issues and apply customization to various modules as per Business Requirements.
- Extensively used Application Designer to create projects for development and migration purposes.
- Built new Queries and modified existing ones using PS Query for Accounts Receivables.
- Extensively used Integration Broker to integrate and communicate with third party systems from PeopleSoft applications.
- Created new messages in message catalog as per Business requirements.
- Developed and customized reports based on user need using SQR, PS/Query and Crystal Reports.
- Wrote User documentation for the Travel and Expense module.
- Resolve PeopleCode related issues on Pages, Components and Records.
Environment: PeopleSoft 8.8 GL, AP, TE, AR, BI , PeopleTools, Application Engine, Integration Broker, PS/Query, SQR, Workflow, Crystal Reports, MS SQL Server.
Confidential
PeopleSoft Consultant
Responsibilities:
- Design and developed the custom bolt-on applications.
- Developed complex custom modules using Component Interfaces, Application Engine Programs, Packages and efficient Exception Handling techniques.
- Created custom SQRs in the AR and GL modules.
- Developed custom components to facilitate the data entry for each of the applications.
- Wrote PeopleCode for the validation of data entry and to default data to various fields in the components. Extensively worked on PeopleTools.
- Developed Data Mover scripts to import and export between different databases.
- Extensively used Application Designer to create projects for development and migration purposes.
- Wrote technical specifications for the custom applications developed.
- Worked extensively with Accounts Receivable and Billing module.
- Involved in requirements gathering, design and development of custom applications.
- Created Messages, Message Channels, Transactions and PeopleCode methods to handle the sending and receiving of messages that contain the high security business data.
- Extensively used Integration Broker to integrate and communicate with third party systems from PeopleSoft applications.
- Used Application Designer to create projects for development and migration purposes.
- Used Utilities for creation of new messages in message catalog as per Business requirements.
Environment: PeopleSoft Financials 8.4 AR, BI, T E, GL , PeopleTools, SQR, Application Engine, Integration Broker, Data Mover, PS Query, Oracle 8i, UNIX.