PROFESSIONAL SUMMARY:

• Certified Oracle - PeopleSoft Consultant wif 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- PeopleSoft Financials, 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 wif 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 teh PeopleSoft applications Financials/SCM<->CRM, Financials/SCM<->HRMS, CRM<-> HRMS/HCM, HRMS <-> ELMS, and integrating third party systems wif PeopleSoft systems and wif Fusion Middleware.
• Proficient in teh 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 teh 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 wif 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 teh design and development of various inbound and outbound interfaces using SQRs and Application Engine programs.
• Applied Tax Updates, Patches & Fixes to teh System as delivered by teh 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 noledge in RDBMS concepts including writing stored procedures and performance tuning SQL.

TECHNICAL SKILLS

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 wif 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

Responsibilities:

• Created Business Requirement Documents (BRD) for all financial modules where teh customizations/enhancements were identified and listed, High Level Design (HLD) document, High Level Flow, Low Level Design (LLD) and Deployment documents.
• Developed integration between PeopleSoft Financials and External System Cicero (CTI) through teh middleware Oracle-Fusion by using integration technologies WSDL, Component Interface, Java Classes, and Oracle Fusion. dis integration will pass teh Financials related (AR, Billing) information to Single UI desktop used by teh Customer Support team.
• Worked closely wif teh Functional team to design and develop AWE workflow for Purchase Orders, code to initiate base classes, SQL definitions for user lists, registering teh transactions and configuring teh transaction.
• Responsible for teh detailed design(HLD/LLD) and development of new Integration/Interfacing/Conversion of PeopleSoft Financials wif Non-PeopleSoft Financials 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 teh Putaway Page is saved, item balances are updated and teh quantity is available for shipping inventory and Order Management.
• Involved in fixing teh 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, teh interface creates them. When created in ASPIRE these vendors will immediately be placed on DOR hold. For those that do currently exist in ASPIRE, teh interface only place them on DOR hold, not overwrite any information previously contained in ASPIRE.
• Involved in developing conversion programs and customizing teh 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 teh vendors to view their payment history online. Created an AE Program to extract data from Peoplesoft tables, dis program extracts all payment history values and corresponding vendor values stored wifin teh Aspire application and send it to Vendors through teh webpage.
• Customized Budget journal Inbound Interface in GL to read data from Budget journal in to PS financial system. Teh AE Program (KK JRNL IMP) is utilized to load teh data from teh LAS/PBS file into teh corresponding File layout Objects and tan inserts into KK BUDGET HDR & KK BUDGET LN.

Environment: PeopleSoft Financials/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 teh 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 teh year-end closing process in GL. Used extensively teh Journal import batch process using xml.
• Involved in customizations on Payables/Receivables modules.
• Created Interfaces to process journals to update teh General Ledger from Account Receivables.
• Created Credit card billing and check acceptance interfaces for AR modules.
• Validated and Audited teh AR UPDATE process.
• Created Interfaces for AR to give teh flexibility to teh users.
• Involved in creating, validating and setting Component Interface Security and used teh 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 wif 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 teh required format for teh EDI process to run successfully and tan 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 teh Portal.
• Implemented Single link (sign-on) capability between Enterprise Portal & Content Provider databases (SCM, HRMS & EPM) avoiding teh user to login to teh various applications of PeopleSoft again and again. Also worked on Branding.
• Designed and developed inbound and outbound interface wif Application engine for Project Costing.
• Developed a Crystal Report which tracks teh details of invoice numbers and associated dollar amounts that fall wif 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 teh Run control pages for Raisers Reconciliation Payment Details accounting entries in AR.
• Customized teh Pay Cycle by defining new steps and including them into Pay Cycle. dis included teh process, which me developed to generate teh positive pay file for teh payments. Defined new Pay Cycle Criteria to replace teh bank accounts beside teh regular Pay Cycle Criteria’s.
• Customized teh delivered Open Liability application engine Process APY1405 to take care of all teh chartfield combinations in Accounts Payable
• Implemented custom Security for AP users by customizing online pages wif user defined Roles and Permission Lists.
• Customized teh 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 teh 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 wif formatting issues in BAI, BAI2 and PSBD1.
• Customized teh delivered crystal AP checks, advices and positive pay file crystal reports and resolved teh issues for printing digital signatures and micro font on checks.

Environment: PeopleSoft Financials 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. 8.9 to 9.1 Upgrade/Integration/Conversions/Customization/Support of PeopleSoft Financials and Supply Chain Management AP/AR/GL/Billing/Assets/Inventory/ eProcurement /Order Management

Confidential, ME

PeopleSoft Sr. Financials/SCM Technical and Functional Consultant

Responsibilities:

• Actively involved in teh entire PeopleSoft FSCM upgrade project starting from building teh demo environment to various phases of teh project life cycle. One point source of issue resolution during teh upgrade project.
• Identify teh changes/retrofit of teh customization, and interfaces due to dis upgrade. Wrote several technical design documents for teh changes identified.
• Provide teh 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 teh business end-user running on WEX’s most current hardware and software. dis will allow teh end user to maintain settlement issues through a single, integrated, stable environment. It will allow WEX Tech Ops to support teh tool by utilizing its most cost TEMPeffective hardware and software.
• Worked extensively wif configuring/developing Integration broker between PeopleSoft Financials, Oracle-Fusion and Non-PeopleSoft (Siebel, Java, and .Net) Applications.
• Designed and Developed Interface to PeopleSoft Financials 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 wifholding (28%) process to support new legislation from teh IRS around reporting gross sales settled by Credit Card Issuers to merchants and wifholding a percentage of gross sales from merchant payments when required.
• Interfaced Goodyear revenue file wif WEX PeopleSoft Financials systems to create Credit Vouchers in Accounts Payables for teh total of all teh early pay discounts and interchange received, wif individual accounting distributions for each revenue account identified in teh early pay discounts and interchange file.
• Designed and Developed Bank Feed Interface to load teh Corecard daily bank feed into teh PeopleSoft Interface tables(ACCT INTERFACE, APP TRACKING INTERFACE, CREDIT INTERFACE, TRANSACTION INTERFACE etc..)
• Developed File Transfer Process to load teh WEX ACH Settlement(*.ACH), PositivePay(POSHAR***), and paybase(CCD*.txt) files to Harris bank Website
• And send email notifications to WEX and HARRIS bank users wif teh total transactions and Amount in teh Files transferred.
• 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 teh upgrade. Used change assistant tool to run various application upgrade steps.
• Reviewed teh 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 teh eProcurement Direct connect vendor set up and Punch-out functionality. Set up teh Integration Broker setup, updated teh IB related application packages to include security details and worked on trouble shooting of teh Punch-Out set up.
• Helped wif teh design and retrofitting of Procurement contracts inbound interface. Performed integration testing & worked wif teh integration of loaded contracts wifin theProcure to Paylife 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 teh File Layout, Application Engine and Developed pages, Components, PeopleCode, SQL to Setup Transaction Codes.
• Developed Automation Process to load teh Convenience and NSF Fees in teh 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 teh 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 teh Funder which determines who owns teh receivables of teh program and dis is used in teh AR Feed and AP Feed Interfaces wif CoreCard Financials System.
• Used to support production on daily basis till teh processes are transited to teh Production team.
• Developed reports to support credit management users by using Crystal, SQR, and PSQuery.

Environment: PeopleSoft Financials 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, ApplicationDesigner, SQL.

Confidential - Irving, TX

PeopleSoft Financials/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 teh 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 teh way from CRM orders to teh general ledger posting.
• Interfacing and loading inventory/parts legacy data into Peoplesoft financials system using application engine and component interface, and syncing teh 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 teh XML data and loading that into teh 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 (me.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 wif teh 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 teh CRM on-demand billing functionality.
• Developed new app message error notification process to notify when ever integration fails in all teh 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 wif 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 teh 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, tan doing various data validations and tan 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 wif 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 teh customizations based on teh 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 teh data is loaded by passing all teh component business functionality rules like triggering EIP’s so that teh 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 teh Putaway Page is saved, item balances are updated and teh quantity is available for shipping inventory and Order Management.
• Modified an existing Application engine Program (BI INTFC) to load teh billingdetails got from a third party order management system into Billing staging tables. Teh process read teh XML file and after passing teh Component interface edits was loaded into teh billing staging table (PS INTFC BI).
• Involved in fixing teh issues related to Transaction Costing and Accounting line creation process.
• Workflow customization for Amount Approvers.
• Involved in updating teh data from teh 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, teh interface creates them. When created in ASPIRE these vendors will immediately be placed on DOR hold. For those that do currently exist in ASPIRE, teh interface only place them on DOR hold, not overwrite any information previously contained in ASPIRE.
• Involved in configuring teh contacts structure and customizing Notes page for Internal Contract Components.
• Created File Layout (FIXED format) to provide an output file for teh vendors to view their payment history online. Created an AE Program to extract data from PeopleSoft tables, dis program extracts all payment history values and corresponding vendor values stored wifin teh Aspire application and send it to Vendors through teh webpage.
• Customized teh 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. Teh AE Program (KK JRNL IMP) is utilized to load teh data from teh LAS/PBS file into teh corresponding File layout Objects and tan 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 wif Financials payables form Financial Expenses, used teh utility App Messaging.
• Customized teh delivered grants invoice SQR process to modify teh company logo, teh format changes and also fixed teh calculation of cumulative amounts by contact number.
• Involved in scheduling jobs through process scheduler.
• Involved in sending teh PO to teh vendor electronically, using XML pages.
• Used Application Message agent Tool to send information from PeopleSoft System and get teh information from other system.
• Trained teh permanent employees at teh Confidential in using Integration Broker, App Messaging and Component interfaces.

Environment: PeopleSoft Financials/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, ApplicationDesigner, SQL.

Confidential, Cleveland, OH

PeopleSoft Sr. Technical consultant

Responsibilities:

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

Environment: PeopleSoft Financials/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 teh out of teh box functionality.
• Developed ETL processes using application engine and data stage to load financial data into teh 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 teh Box. We had end users requirement that need department authorizations me.e. teh employee can create teh expense report for teh employees under his department. To accomplish dis 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 teh 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 teh project ID.
• Set up teh 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 teh 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 TEMPhas ‘USER DEFAULTS’ that every employee should of.
• 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 teh box functionality needs approval from all teh approvers from teh list before user finish and submits. End users found it difficult and long process and we customized an Out of teh Box functionality so that teh user can select one approver from teh list for Expense report, Authorizations and Cash Advances.
• Build a new component for teh Guest profile (Non employees) which let teh guests to update their profiles.
• Conducted meetings wif users and teh testing team and involved in discussing their problems and helped them out in finding teh proper solutions for their requirements.
• Involved in discussions wif teh Users about teh requirements and analyzed teh need.

Environment: PeopleSoft Financials 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, ApplicationDesigner, SQL, Stat (Change Management).

Confidential, Memphis, TN

Upgrade of PeopleSoft 8.8 FIN/SCM Applications

Responsibilities:

• Extensively worked on Matching issues, 2 Way and 3 Way matching, and resolved teh issues in production.
• Worked on requisitions, requisition approvals and responses.
• Developed applications to run in teh 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 teh Project Costs.
• Applied Patches provided by PeopleSoft related to Item-Price-Tolerance, which effects ReqLoad, Requisition and PO Build process. dis comes into picture when teh Suggested Price is different than teh 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 teh NAMD.
• Built NAMD datamart for teh EPM financial ware house system for reporting purpose.
• Modified teh PeopleCode to display a warning so teh user nos when a duplicate order number TEMPhas been used but can continue on it if it is entered. . dis was accomplished by moving teh People code in teh 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 Peoplesoft financials wif Peoplesoft EPM.
• Used web services to process XML based message and edit Peoplesoft user information.
• Customized maintain proposals and submit proposals pages in teh grants module as per teh 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 teh available balance for teh budgets teh user selects.
• Created and Customized Record definitions, Pages, Components, Menus and PeopleCode to enhance teh functionality of existing application like adding teh Sales contact information and addresses in teh Customer Pages as well teh 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. dis required approval by authorized person to approve depending on amount. Associated Business process and Activity for teh 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 teh 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: PeopleSoft Financials 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.