We provide IT Staff Augmentation Services!

Peoplesoft Technical Consultant Resume

3.00 Rating

Houston, TX

SUMMARY

  • Six years of experience in the software analysis, design development, new implementation, upgrade, customization/testing of ERP, client/server, Data Warehouse, and Enterprise Performance Management applications; various clients in areas of Consumer, Investment Banking, Hedge Funds, Auditing, Insurance, Commercial Real Estate and Public sector undertakings
  • Include more than five years of PeopleSoft Experience within United States
  • Extensive work in implementations of PeopleSoft Financials and EPM applications ranging from versions 8.4 to 9.1
  • Expertise in technical role and functional understanding during implementations on various (Reports, Interfaces, Conversions, Enhancements and Workflow) development, upgrades, migration, production support, operational procedures, scheduling, performance tuning, application development, and database solutions
  • Analyze/resolve support issues raised by the functional support team; guide/train support teams on new technology and functionality
  • Industrial domains include Energy, Transportation, Healthcare, Financial Insurance, and Construction

TECHNICAL SKILLS

Hardware: IBM PC Compatibles

Operating Systems: Windows 95/98/2000/NT/XP/7 Pro, Ms - Dos, UNIX

Languages: SQL, SQR, PL/SQL, C, and PeopleCode

RDBMS: Oracle (8, 9, 10, 11) SQL Base, MS SQL Server 2000/2005/2008 R2, and Sybase

GUI Tools: Forms 4.5 and Reports 2.5, Visual Basic, Autosys

ERP Packages: PeopleSoft Financials Version (9.1/9.0/8.9/8.8/8.4 ), MM, eProcurement, PO, Inventory, Project Costing, AP, AR, GL, AM, Travel, Expenses, and Billing

PeopleTools: version ( ), Application Designer, Security Administrator, Workflow

Data Management Tools: Data Mover, Import Manager, Application Engine

Reporting Tools: Query, XML Publisher, Crystal, SQR, nVision, Tree Manager, Process Scheduler, Component Interface, Excel to CI, Application Messaging

Upgrade Tools: Upgrade Assistant

Version Controls: PVCS (Serena Change Man) and Microsoft Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

PeopleSoft Technical Consultant

Responsibilities:

  • Developed technical specifications based on the Functional requirement document
  • Customized various online pages according to the user needs
  • Customized peoplecode in Application Package (WM WO) method to restrict updates for system Generated Work order’s.
  • Developed Conversion Process using Application Engine and CI, to load data provided by the Catapult Systems into PeopleSoft records (AM METER TYPE, METER READ, ASSET METER, WM PM SCHD, WM PM SCHD DTL, WM PM SCHD MTR……)
  • Customized the delivered work order page for the Component Changeout activity secondary page (WM WO TASK CC SEC) added new custom push buttons to the subpage (WM WO CC SBP) and added a custom work record to to the component WM WO so that to perform view and copy actions for removed components.
  • Added custom Peoplecode to the delivered Application packages (WM WO, WM WORKBENCHES) methods like (WM WO: Controllers: WmWOHandler) to meet the functional needs for the work order page.
  • Put application tracing, Research and isolating the issues.
  • Customized the delivered asset Basic Add page (AM OM ASSET ADD) and added the custom sec page to add Legacy Asset Ids.
  • Modified the delivered subpages (WM TSK SRCH SBP) and added the custom search fields to search the work order.
  • Developed a custom Run Control Interface page to load data from four .csv files through App Eng to load the data into eight custom Records for the custom pages.(Asset Hierarchy)
  • Created permission lists and roles security for pages to access for different users
  • Performed smoke/unit test to make sure the process and online applications are working per the requirements after the migration.
  • Developed custom XML Publisher Report for the pages delivered process and work order task detail report options(WM WO RPT and WM RPT OPTNS).
  • Created a custom connected Query Definition data source using the delivered query (WM10001 WO HDR X) and custom Query’s to Generate XML Publisher report.
  • Performed system integration testing and supported the end users in user acceptance testing.
  • Documented and designed the technical specifications for interfaces, reports, data conversion and validation.

Environment: PeopleSoft FSCM 9.1,PeopleTools 8.52, SQL Server 2008R2, Windows 7

Confidential, Houston, TX

PeopleSoft Techno Functional Consultant

Responsibilities:

  • Created Detailed test plans and technical documentation
  • Performed extensive debugging and performance tuning of various processes;well versed in utilizing tools and utilities provided by PeopleSoft (Debugger and tracing) for troubleshooting issues on PeopleCode, Application Engine, SQR’s, and Online
  • Worked on various SQL performance tuning tasks to reduce the execution time
  • Customized the delivered pages; debugged the PeopleCode and the SQR reports for the requested requirements for AP and AR Aging reports
  • Customized various online pages according to the user needs
  • Customized GL reports and interfaces according to new integration conversion rules
  • Customized Component Interface PeopleCode to add extra functionality and validation
  • Worked extensively on Application Designer to modify the existing record definitions, pages, components, and menus
  • Involved in user enhancement of PeopleSoft financials (AP,AR, and GL) utilizing PeopleTools and SQR reports
  • Designed new pages and the SQR Reports for the new enhancements; requested by the users from Tax Department for BUnits under an Account for specific period of that physical year on modules AP, AR, GL modules tables (PS LEDGER, PS JRNL LN, PS JRNL HEADER, PS VCHR ACCTG LINE, PS VOUCHER, PS VENDOR) from AP and GL Tables
  • Expansively used tools like Process Scheduler and Process Monitor for the execution of SQL and Crystal Reports

Environment: PeopleSoft 8.8, Oracle 10G, Windows XP/NT/UNIX

Confidential, Roanoke, VA

PeopleSoft Techno Functional Consultant

Responsibilities:

  • Provided detailed test plans and technical documentation
  • Developed Custom Billing interface program; added functionality for discounts and surcharges for custom invoices, per client requirement
  • Developed Custom Billing Online Components to Review Billing Summary and Custom processed data
  • Developed Enquiry page for Billing Invoices for Custom Billing interface run
  • Created Process Definition, Run Control Record, Page, and Component to run the batch program through Process Scheduler; scheduled the jobs through process scheduler
  • Worked as an offshore and onshore team coordinator for China, India, and USA
  • Developed a new online inquiry page to view Open Commitment on the Purchase Order; compared data related to the Requisition and Receipts
  • Involved in writing SQR, which moves data from ESI system to PO tables like PO HDR,PO LINE and PO LINE SHIP
  • Written Conversion Process using Component Interface and Application Engine for Conversion of Open PO’s, Master Item Data, Vendors, and Customers into PeopleSoft
  • Developed Conversion Process using Application Engine and CI; Converted Contracts and Projects Data into PeopleSoft
  • Developed Vendor Conversion and Item Conversion Application Engine Process
  • Involved in Purchasing Application Configuration validation of current environment
  • Involved in eProcurementApplicationConfiguration
  • Set-up ePro Punch out between Client and Dell, OfficeMax, Lenovo, and other Vendor Websites
  • Resolved Issues with SSL Certificates and Digital Certificates Installation on Server
  • Customized the Catalog Entry Page HTML Area
  • Customized the ePro Requisition Entry Pages
  • Set-up AWE Workflow for eProRequisitions;customized the Workflow Approval Process as per clients requirements
  • Involved in System and Integrated testing
  • Involved in preparing test scripts and work with client ePro/PO for testing
  • Supported ePro related processes like Create Requisitions, Process/Manage/Dispatch PO;integrated data between ePro, Purchasing, and AP modules
  • Developed eProcurement pages for users;usersupdated their own personal information;used the My Profile page, user updates his or her email address, password, favorites list, and personal templates
  • Involved in various phases of project: analysis, design, development, Data Conversion Scripts using SQR and SQL Scripts, unit testing, devising string, and integration testing; performance tuning of online and batch application
  • Streamline invoice processing and dispute resolution; leveraged early payment discounts when possible by leveraging and communicating the match exceptions and disputed invoices on-time
  • Provided Indirect Suppliers with self service capabilities; means to submit invoices online, managed key contact info, and visibility to procure to pay settlement data
  • Provided the reports with required customization to fit the business requirements: Hold Voucher Aging report, Hold Payment Aging report, Match Exception Aging report, Workflow List Aging report, and Match Exception report; sorted by matching exceptions
  • Involved in creating a process to build inventory demand; verified the inventory table BU ITEM INV and then consequently checked the inventory availability; calculation process developed to source PO using Purchasing module
  • Customized/validated the Packing Slip - INS6500.SQR not to print the Packing slips that were already printed; added additional functionality of reprint
  • Performed extensive debugging and performance tuning of various processes;well versed in utilizing tools and utilities provided by PeopleSoft (Debugger and tracing) for troubleshooting issues on PeopleCode, Application Engine, SQR’s, and Online
  • Expansively used tools like Process Scheduler and Process Monitor for the execution of Crystal Reports

Environment: PeopleSoft 9.1, Oracle 10G, Windows 2000/NT/UNIX

Confidential, Washington, DC

Techno functional Consultant

Responsibilities:

  • Developed technical specifications based on the Functional requirement document
  • Created technical specifications and built the online vendor attachments to be added at the vendor level
  • Developed technical specifications and built the process using application engine and PeopleCode for the inbound and outbound interfaces between the PeopleSoft and the Maximo for the Purchasing requisitions and the Purchase Orders
  • Configured/customized the Approval workflow for PO requisition approval based on supervisors and dollar amounts;created new Route Control profiles
  • Worked on EDI Configurations transactions - 180 Return to Vendor Dispatch process, 810 - Vendor Invoice transactions, 850- PO Dispatch Process, 855- PO Acknowledgments,and 856- Advance Shipment Notifications
  • Prepared proof of concept documents for Requisition sourcing - Inventory Demand, PO Calc, PO Create, and Sourcing Workbench in Purchasing
  • Involved in creating a process to build inventory demand; verified the inventory table BU ITEM INV; consequently checked the inventory availability; calculation process was developed to source it to a PO using Purchasing module
  • Tested/validated the Picking Plan INS6000.SQR to print the orders in the sort of Business Unit, Demand Source, Source Business Unit, Order Number, Item ID, Storage Area, and Storage levels
  • Developed the technical specifications for the conversion of the existing projects, project activities, project budgets, open purchasing documents, budgets, and GL balances currently in the PeopleSoft financial database;created grants sponsor/customers;converted or created grant awards;established billed balances by customer contract
  • Scope of Projects for conversion included: open and existing projects; including CIP, Rail Construction, ARRA, Reimbursable, and Safety and Security
  • Developed technical specifications to provide Client with the ability to perform a mass update of the Buyer field on the tables storing Items and Item Categories;delivered functionality allowed Buyer field that must be updated individually for each item and item category;many updates were made;tooka significant amount of time to complete the effort
  • Developed excel to CI component interfaces to mass update the buyer data for the items and the Item Categories
  • Developed the custom SQR programs in addition to the delivered component interfaces for converting the existing data into PeopleSoft finance applications
  • Developed pseudo code and unit testing procedures in the technical specifications for the development team
  • Performed the Customizations to the Shipping Inventory for processing stock depletion in the Inventory module
  • Performed the Customizations to the Item Balance by storage Location page for the Inventory module
  • Interfaced Maximo with PeopleSoft Inventory
  • Responsible for the creation/maintenance of Item Catalogs; set-up of Users for ePro
  • Worked on development of complex reports for Asset Management and Inventory
  • Developed control reports, error reports, and reconciliation reports for the interfaced and converted data
  • Developed Data integrity reports to validate the orphan data in the PeopleSoft tables

Environment: PeopleSoft 9.1, Oracle 10G, Windows 2000/NT/UNIX

Confidential, NJ

Techno functional Consultant

Responsibilities:

  • Developed technical specifications based on the Business Requirement Document (BRD)
  • Created user manual for the end-users on the QCare to GL interface process for claims and premiums
  • Developed extract programs using SQR to send outbound and inbound GL and AP data from PeopleSoft programs to external systems QCare Claims and Revenue system
  • Performed data mapping of the external systems to PeopleSoft data
  • Developed user based online PeopleSoft mapping rules pages for the interfaces
  • Created custom records, pages, and components for holding the mapping rules online
  • Created application engine program to load the mapping rules from the external files from QCare Claims system
  • Customized template to create requisitions in PeopleSoft eProcurement
  • Customized Approval requisition page for PeopleSoft eProcurement
  • Integrated PeopleSoft eProcurement with direct connect suppliers; connected to suppliers using punch outs
  • Customized the pages used to link to suppliers by punch outs; involved in setting up node information for punch outs
  • Fixed problems in dispatching purchasing orders in PeopleSoft eProcurement and in its approval workflow
  • Customized Requisition Schedule and Distribution (PV REQ APP DTL GRD) page to display the Category ID and its description and line comments; per requirement
  • Modified Look up Category (PV CAT SELECT SEC) page and its related records;modifiedPeopleCode to display Account and its description along with category ID and description in Requisition Creation page
  • Wrote page level PeopleCode in PV REQ FROM and PV REQ HDR DEFAULT pages; prevented the users from entering chart field values per client requirement
  • Involved in Travel and expense approval workflow engine customizations
  • Modified Purchase order dispatch SQR POPO005.SQR; included logo and also printed digital signatures according to PO amount
  • Customized the Purchase Order Consolidation process; allowed for consolidation based on the Ship To locations in order to accommodate vendor requirements
  • Created partitions to improve the performance
  • Created different types of Oracle Partitions and sub-partitions; Range Partitions, Hash Partitions, and Composite range harsh partitions
  • Developed pages, components, and application engine programs; created/maintained the partitions thru online PeopleSoft as part of the production maintenance
  • Fine-tuned the long running custom application engine programs
  • Tuned the custom SQR programs to improve the performance adopting the load lookup tables and the array concepts
  • Fine-tuned the custom queries to improve the performance
  • Improved the performance of the online application pages
  • Performed excellent troubleshooting, debugging, and tracing
  • Involved in performance tuning of the Application Engine programs
  • Developed error reports and reconciliation reports; tracked errors and reconciled the source and target data
  • Supported the end-users in providing the queries; assisted in testing of the interface in UAT
  • Coordinated with the DBA in migrating the PeopleSoft projects from development to SIT and UAT and Prod

Environment: PeopleSoft 9.0, Oracle 10G, Windows 2000/NT/UNIX

Confidential, NY

PeopleSoft Techno Functional Developer

Responsibilities:

  • Developed custom interfaces using App Engine program to load the data from the external AS400 Commissions System into PeopleSoft Applications such as Outside Brokers Payroll
  • Developed Independent Contractor payroll process custom interfaces using App Engine program to load the data from the external AS400 Commissions System into PeopleSoft Applications
  • Developed custom SQR process to capture the currency exchange rates from Bloomberg into PeopleSoft;sent the rates from PeopleSoft to OutlookSoft
  • Automated the existing month end interfaces in PeopleSoft for the Operations
  • Developed control reports, reconciliation reports, and data integrity/validation reports for the conversion data
  • Customized the delivered ACH/EFT payments process to fit in the business requirements
  • Developed application engine program to load the incoming check reconciliation data from the CITI and the Chase banks into the PeopleSoft Bank statement tables
  • Customized the delivered (Pay cycle) Payment selection and creation process
  • Developed application engine program using PeopleCode to extract the AMEX data from PeopleSoft expense data; generated the file to be sent to the American Express
  • Developed summary, detail, and comparative Income Statement and Balance Sheet reports using PeopleSoft nVision
  • Created new layouts, report requests, scope definitions, and used Report books to run the reports
  • Developed Expense Open Liability Report
  • Developed Summary and Detail Payment History report, Positive Payments Report and the Voucher register Reports in Accounts Payable
  • Developed Expense Report Detail Report and Expense reports by Business Unit in Travel and Expense Module
  • Customized the delivered check printing Crystal Report according to the business requirements
  • Developed multiples reports in General Ledger; Ledger Verse Journal Integrity report, Custom GL Activity Report for AP/EXP, and all accounts by Department ID
  • Modified the existing check printing Crystal Report
  • Worked on resolving the performance issues and fine-tuning of the Query/SQR programs
  • Migration/SIT/UAT; Testing and Production Support
  • Explained the delivered PeopleSoft reports and their functionality to the end-users
  • Provided 24/7 after hours support during the month-end closing as and when necessary
  • Provided Level 3 support
  • Migrated PeopleSoft projects, objects, configuration data, and various other components of the application into multiple database instances
  • Performed Data Quality issues and day to production issues
  • Performed smoke/unit test to make sure the process and online applications were working per requirements after the migration
  • Created Test requirements documents based on the functional specifications
  • Developed test cases and test scenarios based on the testing requirement documents
  • Tested the Online customizations
  • Documented/tested the PeopleSoft Batch process, inbound, and outbound interfaces
  • Tested the Reports for Data validations and reconciliation reports
  • Performed fit/gap analysis and system configuration
  • Configured the business units, banks, pay cycles for Voucher Payments, and vendors
  • Changed the fixed assets depreciation calculation from Half Year Convention to Following Month for Straight Line method
  • Documented/designed the technical specifications for interfaces, reports, data conversion, and validation
  • Worked with the end-users and gathered information for designing the specifications for Vendor/Customer set-up, Business Unit set-up, and EDI file

Environment: PeopleSoft 9, SQL Server, Windows 2000/NT/UNIX

Confidential, VA

PeopleSoft Technical Developer

Responsibilities:

  • Developed custom interface using App Engine program to load the data from the external legacy billing system into PeopleSoft Accounts Receivable
  • Used Application Engine to convert the historical data from the legacy system into PeopleSoft AR
  • Customized the delivered ACH/EFT payments process to fit in the business requirements
  • Customized the delivered Positive Payment creation process (Crystal Check) to generate the file to be sent to the Chase bank
  • Kept trace, debug options, and researched trace file to isolate the issue
  • Developed application engine program to load the incoming check reconciliation data from the CITI and the Chase banks into the PeopleSoft Bank statement tables
  • Customized the delivered (Pay cycle) Payment selection and creation process
  • Developed application engine program using PeopleCode; extracted the AMEX data from PeopleSoft expense data to generate the file to be sent to the American Express
  • Developed summary, detail, and comparative Income Statement and Balance Sheet reports using PeopleSoft nVision
  • Created new layouts, report requests, scope definitions, and used Report books to run the reports
  • Tested the Online customizations
  • Tested the Reports for Data validations and reconciliation reports
  • Involved in performance testing and fine-tuning of the Query/SQR programs

Environment: PeopleSoft 8.9, Oracle, Windows 2000/NT/UNIX

We'd love your feedback!