PROFESSIONAL SUMMARY:

• Certified Oracle - PeopleSoft Consultant with over 12 years of experience in all phases of software development life cycle including Analysis, Design, Development, implementation, Testing & Support in different technologies like ERP- Confidential, SCM, HRMS, EPM, CRM, Client/Server architecture.
• Over 12 years of experience in ERP (Enterprise Resource Planning) package and development of applications using PeopleSoft Finance 7.5/ 8.0/8.4/8.8/8.9/9.0/9.1/9.2 modules (Billing, Account Receivables, Accounts Payables, General Ledger, Grants, Contracts, Projects, Purchasing, Travel and Expense, Asset Management, Project Costing, Commitment Control(KK)), SCM (Purchasing, Inventory, Order Management, eProcurement, Contracts), HRMS modules (HR, Benefits, Benefits Admin, Payroll, T&L), CRM(Order, Capture, FieldService, Sales, Marketing), and EPM(Financial Warehouse, Enterprise warehouse, Funds Transfer Pricing, Budgeting and Planning, Activity based management).
• Participated in 5 full implementations, 5 upgrades, 6 Customizations, and 6 Production Support projects.
• Proficient with Internet Architecture, Portal Technology, and Development tools such as Application Designer, Application Engine, AWE Workflow, PeopleCode, Integration Tools like Application Messaging, Integration Broker, Component Interfaces and Business Interlinks, Upgrade Assistance. Administrative Tools like Process Scheduler, Process Monitor, Data Mover, Import manager, Tree Manger for Security and Reporting Tools like PSnVision, PSQuery, Crystal Reports and SQR.
• Expertise in deploying PeopleSoft web services between PeopleSoft to PeopleSoft, PeopleSoft to Oracle-Fusion, and PeopleSoft to non-PeopleSoft using various web technologies such as XML, SOAP, WSDL, WSDL URL, SOAPTOCI, Java API’s and XSLT.
• Expertise in Interfacing and Conversions from Legacy Systems and External Systems to PeopleSoft Systems using Component Interface, Application Engine, File Layout, and Application Packages.
• Extensively worked in PeopleSoft Enterprise Integration Points between the PeopleSoft applications Financials/SCM<->CRM, Financials/SCM<->HRMS, CRM<-> HRMS/HCM, HRMS <-> ELMS, and integrating third party systems with PeopleSoft systems and with Fusion Middleware.
• Proficient in the use of Application Designer, Application Messaging, Application Engine, Integration Broker, Component Interface, Application Package, SQR, Crystal Reports, Query/Crystal, Data Mover, Import Manager, Maintain Security/Security Administrator, PS/nVision, PeopleCode, MassChange, Workflow and Database agent, ETL DataStage 7.5, Allocation Manager, CTI, Tree Manager, Data Manager, Data Loader, Upgrade Assistance, AWE, STAT tool, PHIRE migration tool, and Message agent.
• Designed and implemented Web Services-based real-time interfaces between PeopleSoft and the third-party systems, and Heavy use of Integration Broker, Application Messaging, and Application Engine to generate and send XML interface files to various Peoplesoft/non-Peoplesoft systems.
• Designed and Developed AWE workflow for Purchase Orders with dynamic commodity routing using Route Control Profiles/Role Queries.
• Strong technical expertise in module Interfacing, Upgrading, Conversion, Development, Data Migration, Module Development and Reporting based on People Tools and writing/debugging PeopleCode.
• Extensively involved in the design and development of various inbound and outbound interfaces using SQRs and Application Engine programs.
• Applied Tax Updates, Patches & Fixes to the System as delivered by the PeopleSoft.
• Used PS/Query and Tree Manager for reporting purpose to fulfill company’s specific needs.
• Workflow (AWE, Virtual Approver, Manual)
• Worked in developing front-end/web applications using Visual Studio 6.0/. NET, having excellent knowledge in RDBMS concepts including writing stored procedures and performance tuning SQL.

TECHNICAL ENVIRONMENT:

ERP Package: PeopleSoft Financial/SCM 7.5x/ 8.0/8.4/8.8/8.9/9.0/9.1/9.2 (Billing/Accounts Receivables/Accounts Payables/Contracts/Inventory/ Grants/ Purchasing/Inventory/Travel and Expense/ Order Management/eProcurement/Commitment Control(KK)/Asset Management/Cost Management), CRM(Order, Capture, FieldService, Sales, Marketing), EPM 8.8/8.9 (Enterprise warehouse, Financial Warehouse, Funds Transfer Pricing, Budgeting and Planning, Activity based management), and HRMS modules (HR, Benefits, Benefits Admin, Payroll, T&L)

Integration Tools: Integration Broker, Component Interfaces,Service, Service Operation, Routing, Application Messaging, Business Interlinks, File Layout, Java API’s

People Tools: Application Designer, People Code, Application Engine, Component Interface, SQR, Application Messaging, Change Packer, Upgrade Assistant, Tree Manager, Tree Loader, Import Manager, Allocation Manager, Data Loader, Data Manager, Integration Tools(Data Mover, Workflow, File Layout)

Reporting Tools: Crystal reports with Crystal Enterprise 8.5/9.0/10.0 , SQR, PS/Query, nVision

Programming Languages: PeopleCode, Pascal, COBOL, C, C++, C#, Visual Basic, SQL, PL/SQL, Shell script

Tools: & Scripts: HTML, XML, JavaScript, VBScript

Operating Systems: UNIX, Sun Solaris, Windows NT/95/98/2000/XP, MS DOS, Unix/Linux

Databases: Oracle 11g/10g/9.x/8.x/7.3, MS SQL Server 2000/7, DB2, MS-Access

Application Server: Tuxedo, Web Logic

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

PeopleSoft Sr. Financials/SCM Technical and Functional Consultant

Responsibilities:

• Created Business Requirement Documents (BRD) for all financial modules where the customizations/enhancements were identified and listed, High Level Design (HLD) document, High Level Flow, Low Level Design (LLD) and Deployment documents.
• Developed integration between Confidential and External System Cicero (CTI) through the middleware Oracle-Fusion by using integration technologies WSDL, Component Interface, Java Classes, and Oracle Fusion. This integration will pass the Financials related (AR, Billing) information to Single UI desktop used by the Customer Support team.
• Worked closely with the Functional team to design and develop AWE workflow for Purchase Orders, code to initiate base classes, SQL definitions for user lists, registering the transactions and configuring the transaction.
• Responsible for the detailed design(HLD/LLD) and development of new Integration/Interfacing/Conversion of Confidential with Non- Confidential Systems using component interface, integration broker, Application Engine, Middleware(Oracle-Fusion, JCAPS), Java API’s and Classes, JAR Files, File layout, Application packages, WSDL, SOAP, XML, and PeopleCode.
• Took over and re-wrote large portions of an existing Customer Conversion utilizing Component Interface.
• Developed process to integrate currency exchange rates from third party vendor to PeopleSoft financial systems using integration broker.
• Built complex custom inbound and outbound Application Engine interfaces to support custom transmission of sales order information to warehouse distribution as well as confirmation of sales order shipping
• Customized Putaway Page by writing PeopleCode which enabled express Putaway to putaway items in one step so that as soon as the Putaway Page is saved, item balances are updated and the quantity is available for shipping inventory and Order Management.
• Involved in fixing the issues related to Transaction Costing and Accounting line creation process.
• Wrote PeopleCode and App-engine program to determine item balance, enhance item search capabilities and designed work-flow to generate replenishment requisition based on current stocking levels, economic Order quantity (EOQ), and reorder point. Use flexible, ad hoc requisition for back Order Management.
• Developed inbound interface using File Layout & AE program to upload and store timesheet information from legacy system (PeopleFirst) in to custom labor-hour detail record, FL LBR TIME DTL. Program checks for vendors that are not currently in ASPIRE. For those that do not exist in ASPIRE, the interface creates them. When created in ASPIRE these vendors will immediately be placed on DOR hold. For those that do currently exist in ASPIRE, the interface only place them on DOR hold, not overwrite any information previously contained in ASPIRE.
• Involved in developing conversion programs and customizing the interfaces for open payments from People Soft HR Benefits module into Accounts receivable.
• Developed interface process to load bulk load new assets into financial system.
• Involved in troubleshooting AR UPDATE process, which is used to process and update customer balance and history information, corresponding item information, and item activity.
• Created File Layout (FIXED format) to provide an output file for the vendors to view their payment history online. Created an AE Program to extract data from Peoplesoft tables, this program extracts all payment history values and corresponding vendor values stored within the Aspire application and send it to Vendors through the webpage.
• Customized Budget journal Inbound Interface in GL to read data from Budget journal in to PS financial system. The AE Program (KK JRNL IMP) is utilized to load the data from the LAS/PBS file into the corresponding File layout Objects and then inserts into KK BUDGET HDR & KK BUDGET LN.

Environment: Confidential /SCM 9.1, HCM 9.2, People Tools 8.52, People Code, Integration Broker, AWE workflow, Application Engine, Component Interface, SQR, Process Scheduler, and Oracle 11g, MVS, IBM Mainframes, DB2

Confidential, Loveland, CO

PeopleSoft Technical and Functional Consultant

Responsibilities:

• Worked on Technical Designs, Data Mapping and Test Conditions for converting the legacy data into People Soft tables in GL, AR, AP.
• Developed SQR Programs to convert General Ledger Balances from Legacy system and generated Journals to accommodate the year-end closing process in GL. Used extensively the Journal import batch process using xml.
• Involved in customizations on Payables/Receivables modules.
• Created Interfaces to process journals to update the General Ledger from Account Receivables.
• Created Credit card billing and check acceptance interfaces for AR modules.
• Validated and Audited the AR UPDATE process.
• Created Interfaces for AR to give the flexibility to the users.
• Involved in creating, validating and setting Component Interface Security and used the interface keys, properties, collections and methods.
• Developed Component Interfaces and programmed in PeopleCode by generating PeopleCode template and used several classes.
• Extensively used integration tools like Component Interface, App Messaging, and Business interlinks to integrate People Soft modules with external applications.
• Used Integration Broker to define and troubleshoot Gateway nodes, Connectors and FTP/HTTP Nodes to set up Flat file import and processing for Bank Statements and Commitment control Budgets.
• Developed SQR programs to convert customer set up data from legacy system to People Soft in Accounts Receivables.
• It was required to load employee flat file into PeopleSoft Expenses table from a flat file. To do these two SQR’s were written. First one to convert it into the required format for the EDI process to run successfully and then to load it from staging tables to PeopleSoft tables.
• Wrote an App Engine interface which loads HR Employee Data into Expense tables.
• Used XML messages to load data from foreign database on a real time basis to be displayed in the Portal.
• Implemented Single link (sign-on) capability between Enterprise Portal & Content Provider databases (SCM, HRMS & EPM) avoiding the user to login to the various applications of PeopleSoft again and again. Also worked on Branding.
• Designed and developed inbound and outbound interface with Application engine for Project Costing.
• Developed a Crystal Report which tracks the details of invoice numbers and associated dollar amounts that fall with in specified criteria.
• Developed and used extensively data mover scripts to migrate customer, item balances and information between different environments in Inventory and AR modules to sync all environments.
• Developed and customized crystal reports for aged receivables by invoiced and non-invoiced reports in Accounts receivables.
• Customized the Run control pages for Raisers Reconciliation Payment Details accounting entries in AR.
• Customized the Pay Cycle by defining new steps and including them into Pay Cycle. This included the process, which I developed to generate the positive pay file for the payments. Defined new Pay Cycle Criteria to replace the bank accounts beside the regular Pay Cycle Criteria’s.
• Customized the delivered Open Liability application engine Process APY1405 to take care of all the chartfield combinations in Accounts Payable
• Implemented custom Security for AP users by customizing online pages with user defined Roles and Permission Lists.
• Customized the PeopleSoft delivered SQR process for Depreciation calculation and involved in troubleshooting copy asset functionality for owned assets in Asset Management Module.
• Worked extensively in setting up FTP, flat file import and customized accordingly the Budget Import Application Engine process KK JRNL IMP in General Ledger.
• Involved in setting up importing Bank statements and Bank reconciliation in Accounts Payables and also involved in troubleshooting with formatting issues in BAI, BAI2 and PSBD1.
• Customized the delivered crystal AP checks, advices and positive pay file crystal reports and resolved the issues for printing digital signatures and micro font on checks.

Environment: Confidential and SCM 9.1 (Billing, Cash Management, General Ledger, Accounts Payables, Accounts Receivables, Expenses, PO, Inventory and Asset Management ), PeopleTools 8.51, Crystal Reports, SQR, COBOL, nVision, Oracle 11g, DB2.

Confidential, South Portland, ME

PeopleSoft Sr. Financials/SCM Technical and Functional Consultant

Responsibilities:

• Actively involved in the entire PeopleSoft FSCM upgrade project starting from building the demo environment to various phases of the project life cycle. One point source of issue resolution during the upgrade project.
• Identify the changes/retrofit of the customization, and interfaces due to this upgrade. Wrote several technical design documents for the changes identified.
• Provide the development support changes in application engine programs, SQRs, PeopleCode, file layout, Component Interfaces, Integration Broker, and portal structure.
• Designed and Developed Conversion of Merchant Paybase Settlement System to PeopleSoft AP System to build a single settlement and reporting tool for the business end-user running on WEX’s most current hardware and software. This will allow the end user to maintain settlement issues through a single, integrated, stable environment. It will allow WEX Tech Ops to support the tool by utilizing its most cost effective hardware and software.
• Worked extensively with configuring/developing Integration broker between Confidential, Oracle-Fusion and Non-PeopleSoft (Siebel, Java, and .Net) Applications.
• Designed and Developed Interface to Confidential to reduce customer credit risk by receiving treatment recommendations from a third party credit risk analysis and scoring engine (DNBi) by using Component Interface, File Layout and Application Engine.
• Developed 1099K withholding (28%) process to support new legislation from the IRS around reporting gross sales settled by Credit Card Issuers to merchants and withholding a percentage of gross sales from merchant payments when required.
• Interfaced Goodyear revenue file with WEX Confidential systems to create Credit Vouchers in Accounts Payables for the total of all the early pay discounts and interchange received, with individual accounting distributions for each revenue account identified in the early pay discounts and interchange file.
• Designed and Developed Bank Feed Interface to load the Corecard daily bank feed into the PeopleSoft Interface tables(ACCT INTERFACE, APP TRACKING INTERFACE, CREDIT INTERFACE, TRANSACTION INTERFACE etc..)
• Developed File Transfer Process to load the WEX ACH Settlement(*.ACH), PositivePay(POSHAR***), and paybase(CCD*.txt) files to Harris bank Website
• Developed AWE supporting definitions, configuring metadata, creating template definitions, configuring transactions.
• Perform troubleshooting, debug application errors and performance tuning of various SQL scripts that were run during the upgrade. Used change assistant tool to run various application upgrade steps.
• Reviewed the compare reports, audit reports and identified different client customizations. Performed analysis and retro-fitting of various client customizations.
• Performed unit testing for customizations in (Purchasing, Inventory and Payables) and verified customizations and key functionalities in different environments.
• Customized the eProcurement Direct connect vendor set up and Punch-out functionality. Set up the Integration Broker setup, updated the IB related application packages to include security details and worked on trouble shooting of the Punch-Out set up.
• Helped with the design and retrofitting of Procurement contracts inbound interface. Performed integration testing & worked with the integration of loaded contracts within the Procure to Pay life cycle.
• Designed and Developed Customers Integration from Siebel to PeopleSoft using Integration Broker, Application Packages, Services.
• Developed Interface to Load AP Feed from External Financials System (Core Cord) to PeopleSoft AP using Application Engine, File Layout, and PeopleCode.
• Developed Interface to Load AR Feed from External Fin Application (CoreCard) to PeopleSoft using the File Layout, Application Engine and Developed pages, Components, PeopleCode, SQL to Setup Transaction Codes.
• Developed Automation Process to load the Convenience and NSF Fees in the AR Module using Application Engine.
• Tight security is enabled on PeopleSoft Webservices using PeopleSoft Security Objects (Roles, Permission List, Folder Security, Portal Structure Security, and User Profile Access).
• Tested and performed the technical analysis of new GL functionality Financials Audit Framework. It provides efficient tracking of transaction processing that results in enhanced visibility and detailed audit trails. Audit logging is available for GL Journal Processing.
• Developed UI to Setup Relationship codes to the Funder which determines who owns the receivables of the program and this is used in the AR Feed and AP Feed Interfaces with CoreCard Financials System.
• Used to support production on daily basis till the processes are transited to the Production team.
• Developed reports to support credit management users by using Crystal, SQR, and PSQuery.

Environment: Confidential 9.1 (Accounts Payable, Accounts Receivable, Billing, Contracts, Purchasing, Asset Management, Inventory, project costing, Order Management, General Ledger, and eProcurement modules), Tools Release 8.50, Oracle Fusion, CoreCard, Database: Oracle 10g, Integration Broker, SQR, PeopleCode, Application Messaging, Application Engine, Application Package, FileLayout, Data Mover, Crystal, PSQuery, Application Designer, SQL.

Confidential, Irving, TX

Confidential /SCM Integration/Interfacing/Customization Developer

Responsibilities:

• Implemented and upgraded PeopleSoft FSCM 9.0 from 7.5, and PeopleSoft CRM 9.0 from Vantive 8.x and prepared groundwork for upgrading including evaluation of Customizations, Project Plan and Fit-Gap Analysis, and continued Supporting FSCM/HCM applications once after go-live.
• Involved in Upgrades, Bundles and Patches and used extensively Change Assistance to maintain the tools/application upgrades.
• Module owner for contracts, and order to cash integration process (CRM Order Capture/FieldService to FSCM (Transaction Billing Processor)), and heavily customized Transaction billing processor, contracts, billing, and account receivables modules in FSCM to accommodate both FSM and CRM billing user requirements all the way from CRM orders to the general ledger posting.
• Interfacing and loading inventory/parts legacy data into Confidential system using application engine and component interface, and syncing the same data to CRM module using integration broker using service operations in SOA architecture.
• Developed conversions programs for contracts and billing module to convert PS 7.5 data into PS8.9 using application engine.
• Loading sales orders from non-Peoplesoft legacy system to Peoplesoft CRM system by processing the XML data and loading that into the Peoplesoft system.
• Configured Application Server and Web Server for application Integrations between PeopleSoft and non PeopleSoft systems. Developed/Customized Full Sync and Incremental Async & Synchronous EIP between PeopleSoft FSCM 8.8, CRM 8.9, and HCM 8.8 applications using Application Messaging, Integration Broker & Business Interlinks.
• Developed/Customized around 80 Integration Points (EIP’s) between FSCM, CRM, and HCM applications (i.e. CUSTOMER SYNC, CONTACT SYNC, CONTRACT REQUEST, CONTRACT RESPONSE, CONTRACT TXN, INVENTORY ADJUSTMENT, Confidential MAT CHK SYNC, PRODUCT SYNC, Confidential INV INQ SYNC, ITEM SYNC, DEPT SYNC, PURCHASE REQUISITION LOAD CRM, SOAPTOCI etc...).
• Created CI based web services for non-Peoplesoft system integrations to sync customers and contacts.
• Worked in integrating Peoplesoft CRM with the non-Peoplesoft NOC order system to sync service orders for billing process.
• Integrated FSCM Inventory items and products to PeopleSoft CRM.
• Customized FSCM contracts billing interface AE process CA BI INTFC to accommodate on-demand CRM service order billing which is triggered through transaction billing processor for the CRM on-demand billing functionality.
• Developed new app message error notification process to notify when ever integration fails in all the three application (FSM, CRM, and HCM).
• Developed around 20 to 30 new application engine processes for FSM business requirements (Ex: Contracts Conversion, Projects Conversion, Billing Conversion, Region ID update process, region chartfield/storage location/Distribution code reclassification process, Product group reclassification process, global Email ID change from unified to NECAM process, etc..) .
• Involved in integration with People Soft Billing and People Soft Projects to generate invoices for all contract lines.
• Implemented application customizations, modifications and enhancements for Contracts, Projects and Billing modules.
• Developed custom application to reprocess/change CRM Agreements related contracts for the future contract/billing transactions.
• Developed interfaces to import receipts into Peoplesoft purchasing.
• Developed BI Interface which loads data from 3rd party system into PeopleSoft billing interface tables first, then doing various data validations and then loading into billing main tables BI HDR and BI LINE.
• Customizations deemed necessary to upgrade after thorough review were implemented and tested to ensure new functionality did not come into conflict with older adjustments.
• Modified an Application Engine program which loads Purchase Orders to Purchasing from a flat-file via a Component Interface.
• Customized invoice print SQR/SQC processes to accommodate the customizations based on the user requirements for FSM/CRM billing users.
• Transferred vendor data from legacy systems, Application Messaging, to PS Vendor tables using Component Interface & Application Engine.
• Converted FSM 7.5 SQR inbound/outbound interfacing programs into Application Engine programs by using Component interfaces so that the data is loaded by passing all the component business functionality rules like triggering EIP’s so that the data changes are synced between FSM/CRM/HCM.
• Customized Putaway Page by writing PeopleCode which enabled express Putaway to putaway items in one step so that as soon as the Putaway Page is saved, item balances are updated and the quantity is available for shipping inventory and Order Management.
• Modified an existing Application engine Program (BI INTFC) to load the billing details got from a third party order management system into Billing staging tables. The process read the XML file and after passing the Component interface edits was loaded into the billing staging table (PS INTFC BI).
• Involved in fixing the issues related to Transaction Costing and Accounting line creation process.
• Workflow customization for Amount Approvers.
• Involved in updating the data from the back end - missing Department, Distribution Type and wrong accounts in CM ACCTG LINE Table.
• Developed inbound interface using File Layout & AE program to upload and store timesheet information from legacy system (PeopleFirst) in to custom labor-hour detail record, FL LBR TIME DTL. Program checks for vendors that are not currently in ASPIRE. For those that do not exist in ASPIRE, the interface creates them. When created in ASPIRE these vendors will immediately be placed on DOR hold. For those that do currently exist in ASPIRE, the interface only place them on DOR hold, not overwrite any information previously contained in ASPIRE.
• Involved in configuring the contacts structure and customizing Notes page for Internal Contract Components.
• Created File Layout (FIXED format) to provide an output file for the vendors to view their payment history online. Created an AE Program to extract data from PeopleSoft tables, this program extracts all payment history values and corresponding vendor values stored within the Aspire application and send it to Vendors through the webpage.
• Customized the milestone page to trigger email notifications and implemented Security using milestone classifications in grants and contracts.
• Customized Budget journal Inbound Interface in GL to read data from Budget journal in to PS financial system. The AE Program (KK JRNL IMP) is utilized to load the data from the LAS/PBS file into the corresponding File layout Objects and then inserts into KK BUDGET HDR & KK BUDGET LN.
• Created File layout, Component, Menu, Record, Page and AE program (FL AP VEFTIN) for Vendor/Payee EFT Data Updates to process input flat file, process data and load data in PS system.
• To interact with Financials payables form Financial Expenses, used the utility App Messaging.
• Customized the delivered grants invoice SQR process to modify the company logo, the format changes and also fixed the calculation of cumulative amounts by contact number.
• Involved in scheduling jobs through process scheduler.
• Involved in sending the PO to the vendor electronically, using XML pages.
• Used Application Message agent Tool to send information from PeopleSoft System and get the information from other system.
• Trained the permanent employees at the Confidential in using Integration Broker, App Messaging and Component interfaces.

Environment: Confidential /SCM 9.0/7.5 (Billing, Contracts, Account Receivables, Account Payables, Inventory, Purchasing, Order Management, Purchase Order, General Ledger, e-Procurement, and Assets), CRM(Integrated FieldService, Sales), HCM(Base Benefits, Payroll, Time and Labor) Tools Release 8.49/8.45.17 , Database: Oracle 9i, SQR, PeopleCode, Application Messaging, Integration Broker, Business Interlinks, Application Engine, Application Package, FileLayout, Application Designer, SQL.

Confidential, Cleveland, OH

PeopleSoft Sr. Technical consultant

Responsibilities:

• Extensively working on SQRs. Customers has requested a variety of enhancements that permit more efficient use of the AR data.
• Modified an SQR so that process should distribute reports according to the output defined.
• Developed an Excel version of the statement that can be automatically distributed by email.
• Modified MBNA custom applications.
• Worked in the process of integrating Tax-ware Vertex with Peoplesoft FSCM.
• Added logic to display separate totals by currency at the end of the statement. When the statement does not have multiple currencies then the currency field displayed the currency only at the end of the statement.
• Designed and implemented a Web Services-based real-time interface between PeopleSoft and the third-party system to load vendors/quotes.
• Developed and formatted an Excel version of the statement that can be automatically distributed by email.
• Added logic to sort invoices (amounts > zero) by due date with subtotals for the 10th and 25th of each month.
• Fixed many defects that end users discovered after going live.
• Involved in discussions with the Users about the requirements and analyzed the need.

Environment: Confidential /SCM 8.9 (Billing, Contracts, Accounts Payables, Accounts Receivables, General Ledger, Purchasing, Purchase Management, Warranty, and Asset Management), Tools Release 8.48.08, Database Type: ORACLE.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Extensively worked on online development using PeopleCode, Application Packages to add customizations to the out of the box functionality.
• Developed ETL processes using application engine and data stage to load financial data into the EPM system, loaded dimensional tables(Account, Product, Department, Affiliate, and Region), Financial FOO tables and build financial datamart for reporting purpose.
• Self Authorizations and Authorization by users comes Out of the Box. We had end users requirement that need department authorizations i.e. the employee can create the expense report for the employees under his department. To accomplish this task, we developed a few pages and modified EX EE AUTH application engine program to get department authorizations.
• We have also performed an audit for many application engine programs by inserting data for the fields in LASTUPDOPRID, OPRID ENTERED BY, DTTM CREATED, and DTTM MODIFIED.
• Developed Conversion SQLs to insert bank information and Credit Card Information in UPDATE Profile.
• Accounting Defaults at Header and Detail level for Travel and Expense and Authorizations: Written a PeopleCode to automatically enter Fund Code, B+R and Mars based on the project ID.
• Set up the values for Resource Type and Resource category for Authorizations and Travel. Written a PeopleCode to automatically enter Resource Type and Resource Category for Travel and Authorizations based on the project ID. Modified Record PeopleCode Modified is: FUNCLIB PCINTFC.
• Developed pages and application to maintain ‘Foreign Travel Management System’.
• User Defaults: we made a dummy Employee ID which has ‘USER DEFAULTS’ that every employee should have.
• Extensively worked on Stat v5.3 (Change Management tool) to migrate projects between environments.
• Developed HR Interface - LBNL found easier to maintain data through SQL rather than achieving same through Integration Broker. Written SQLs to migrate and maintain data from HR for PS PERSONAL DATA, PS JOB, PS PERS DATA EFFDT, PS EMAIL ADDRESSES, PS PERSONAL PHONE, and PS EX APPROVAL TBL.
• Did a major customization on SAS APPROVER. Out of the box functionality needs approval from all the approvers from the list before user finish and submits. End users found it difficult and long process and we customized an Out of the Box functionality so that the user can select one approver from the list for Expense report, Authorizations and Cash Advances.
• Build a new component for the Guest profile (Non employees) which let the guests to update their profiles.
• Conducted meetings with users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.
• Involved in discussions with the Users about the requirements and analyzed the need.

Environment: Confidential 8.80(Travel and Expense, General Ledger, Accounts Payables, Accounts Receivables, and Purchasing), PeopleSoft EPM (Enterprise warehouse), Tools Release 8.47, Oracle, Peoplecode, PeopleTools, Application Engine, Application Designer, SQL, Stat (Change Management).

Confidential, Memphis, TN

PeopleSoft EPM 8.9 Implementation

Responsibilities:

• Extensively worked on Matching issues, 2 Way and 3 Way matching, and resolved the issues in production.
• Worked on requisitions, requisition approvals and responses.
• Developed applications to run in the background using Application Engine.
• Customized various App. Engine programs such as AR to BI, AP to PC, CA to BI Interfaces and CA LOAD GL1 etc.
• Worked on Project costs for Distributing among multiple sources using PC FND DIST Application Engine Process.
• Worked on Pricing Engine for Pricing the Project Costs.
• Applied Patches provided by PeopleSoft related to Item-Price-Tolerance, which affects ReqLoad, Requisition and PO Build process. This comes into picture when the Suggested Price is different than the Item Vendor Price.
• Modified Journal Edit process to avoid anchor concept delivered by PeopleSoft by making changes to Application Engine Process.
• Worked in allocation manager to allocated FDIC amount to the NAMD.
• Built NAMD datamart for the EPM financial ware house system for reporting purpose.
• Modified the PeopleCode to display a warning so the user knows when a duplicate order number has been used but can continue on it if it is entered. . This was accomplished by moving the People code in the Field Edit event to Field Change event of BI HDR’s, ORDER NO.
• Worked T&E workflow process and worked on automated email notification option.
• In grants customized search views for award profile component and made changes to funding, resources, and milestones panels.
• Worked in integrating Confidential with Peoplesoft EPM.
• Used web services to process XML based message and edit Peoplesoft user information.
• Customized maintain proposals and submit proposals pages in the grants module as per the client requirements.
• Involved in Security Setup ( Security tables, roles and user profiles)
• Modified budget status SQR report to display all commitment control ledger amounts (budgeted, pre-encumbrance, encumbrance, Expense, collected, recognized) and the available balance for the budgets the user selects.
• Created and Customized Record definitions, Pages, Components, Menus and PeopleCode to enhance the functionality of existing application like adding the Sales contact information and addresses in the Customer Pages as well the OM entry page.
• Added new AE Sections/Steps/Actions to implement Fund Balancing concept while generating offsets as a part of Journal Edit Process.
• Extensively created reports using Crystal and also SQR.
• Involved in troubleshooting of Purchasing and Inventory issues.
• Wrote inbound interfaces to import Voucher, Item lines and distribution data from their legacy system to PeopleSoft
• Designed and Developed workflow approval rules in AP for voucher matching exceptions. Defined approval rule sets depending on unmatched Amount. This required approval by authorized person to approve depending on amount. Associated Business process and Activity for the approval rule sets. Assigned roles in activity for workflow Security. Developed application engine batch process which would invoke component interface every one hour to check for exception match rules after voucher edit and send it to authorization of the concerned person.
• Setting up inter unit transfers. Define transfer prices. Establish Inventory business unit pairs
• Customized RMA SQR Report to display RMA transactions for internal and external locations in Inventory module

Environment: Confidential 8.4/8.8 (Grants and Contracts, Commitment Control(KK), Accounts Receivables, General Ledger, Accounts Payables, Contracts, Projects, Time & Expense and Budgets), PeopleSoft Distribution (Purchasing, Order Management, Inventory, and Billing), PeopleSoft EPM (Financial warehouse, Funds Transfer Pricing, Budgeting and planning), PeopleTools, PeopleCode, EDI, SQR, Crystal Reports, PS/nVision, Oracle, Win NT.