SUMMARY

• Over Ten Years of professional experience with expertise across multiple platforms and skill sets.
• Background includes extensive experience in Configuration, Analysis, Design, Development Implementation and Production Support of PeopleSoft Financials and SCM Modules.
• Extensive experience in Information Technology, Wireless, Banking and Manufacturing Sectors.
• Worked extensively as a Consultant on a number of Production Support and maintenance projects in PeopleSoft Financials.
• Worked extensively on PeopleTools, People Code, Application Engine and SQR.
• Posses a good knowledge of Integration Technologies such as Integration Broker, Application Messaging and Component Interface.
• Experience with PeopleSoft Upgrade methodology.
• Posses excellent debugging and problem solving abilities.
• Have a good understanding of PeopleSoft Security and SysAudit.
• Have a good understanding of the PeopleSoft Financials Business Processes in Asset Management, Accounts Payable, Project Costing, Purchasing and General Ledger and a comfortable level of knowledge in other PeopleSoft modules like Accounts Receivable and Inventory.
• Have gone through a number of Seminars on Demands on PeopleTools and Financials.

TECHNICAL SKILLS

ERP: People Soft 7.5, 7.5 E&G, 8sp1, 8sp3, 8.4, 9.1 (AM / PC / AP / PO / IN / GL).

Development Tools: Application Designer) Application Engine, PeopleCode, Application Messaging and Component Interface.

Integration Tools: Application Messaging, Component Interface and Business Inter Iinks.

Reporting Tools: SQR, nVision, PS/Query, Crystal Reports, and Tree Manager.

Data Management & Batch Processing Tools: Data Mover, Mass Change, Application Engine, Import Manager and Process Scheduler.

Administration Tools: Security Administrator, Object Security, and Workflow Administration.

Operating Systems: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential

Lead Peoplesoft Systems Analyst

Responsibilities:

• Lead a team of 5 System Analysts for handling the R4 project requirements for the AP module for merging the Verizon Corporate PeopleSoft environment with the Confidential PeopleSoft environment
• Lead Business Requirement sessions and coordinated Fit - Gap sessions with Business teams to gather full scope of requirements.
• Created Design Documents for 60 Work Items for AP module requirements for the R4 project.
• Coordinated development and testing of all AP requirements and supported IT Testing (Ongoing) for 150 Defects till date.
• Coordinated development schedules with 3rd party systems for Peoplesoft AP Interfaces to fit in with planned testing cycles.
• Developed custom AP Generic Interface that receives Voucher data files from 20 Feeder systems to be loaded into Peoplesoft to create Vouchers along with error correction workbench.
• Developed custom Vendor Upload Interface process to accept input file and add Vendors and update Vendors along with error correction workbench
• Developed custom Vendor Setup request functionality and custom Vendor Setup Request Approval Request functional using AWE.
• Developed custom Seeburger Invoice Stage and Seeburger Invoice build Interface processes to receive and build Seeburger Invoices in Peoplesoft.
• Developed custom Invoice extract Interface from Peoplesoft to SAP for Dymax Purchase Order Vouchers.
• Developed conversion process for Withholding data conversion

Environment: PeopleSoft Financials 9.1, Accounts Payable, Asset Management, Purchasing, Project

Confidential

Lead Peoplesoft Systems Analyst

Responsibilities:

• Lead a team of 3 System Analysts for providing shared resources between PeopleSoft 9.1 and Peoplesoft 8.4 for Peoplesoft AM and AP modules.
• Responsible for providing Business Case and requirements documentation for AM and AP modules for Interfaces to non peoplesoft environments.
• Coordinated development and testing of 80 Requirement cases and closure of 400 defects during IT Testing for AM and AP module Interfaces.
• Developed custom AM Month end close automation process that automates the scheduling and error managements of all AM month end related processes along with workbench and monitoring functionality to reduce time from 6 days to 2 days for Asset Management close processing.
• Coordinated Data Mapping and Loading efforts between 8.4 and 9.1
• Developed various AM and AP Reports in 9.1 to map existing 8.4 functionality to new system.
• Coordinated and developed 65 AM and AP Interfaces in 9.1 on the lines of existing interfaces in 8.4.
• Coordinated Project planning and implementation activities with Management.
• Coordinated with User base for requirements gathering and business case development.
• Coordinated with Vendor development team on various work efforts to meet timelines for development activities.

Environment: PeopleSoft Financials 9.1, Asset Management, Project Costing, Purchasing and Accounts Payable.

Confidential

Lead Peoplesoft Systems Analyst

Responsibilities:

• Managed a team of 3 System Analysts for providing end to end support for Peoplesoft AM and PC modules.
• Responsible for Implementation, Customization, Development and Data Conversion in Peoplesoft AM, PC, AP and GL modules
• Provided support of PC and AM month end close activities and tuned related processes to bring close time from 6 days to 4 days by implementing push button Month end close for these modules.
• Designed, developed, tested and implemented solutions using PeopleSoft development tools & other third party software development tools to address business requirements.
• Implemented multiple Interfaces to send and receive AM, PC an AP related data to and from various Intra-Company Groups. Eg: AM and PC accounting and transaction data to Tax group, AP Vendor data to Vendor Management group, AP data to SCM group, Posipay Interface files to Banks, Recon File consumption from Banks, etc.
• Provided Metric Reports for system wide data to Higher Management.
• Used DataMover to export data from conversion database to various database instances.
• Developed SQRs for different General Ledger reports like the General Ledger Activity Report, Account Analysis Report and to track the Mass Allocations over different time periods.
• Worked on posting and unposting journals and handled journal errors during the Journal processing for the General Ledger module.
• Developed and customized financial statements like Balance Sheet, Income Statement and Cashflow and other financial reports for decision making process using nVision and GL.
• Modifications to GL OPEN ITEM DET page and PeoplCode to default JOURNAL DATE TO and JOURNAL DATE FROM fields in GL OI CRITERIA in GL.
• Designed, build workflow applications and create workflow maps according to client requirements.
• Involved in modifying the reports like Invoice Register, Voucher Register, confirmation register, deal approval register, settlement instructions. Involved in creation of reports like commission, Rebate using PS/nVision.
• Customized the delivered Accounts Payable Checks, Advices, Trial register and Match Exceptions report.
• Customized several delivered PeopleSoft objects to address the business requirement.
• Customized/modified SQR programs and PeopleCode to report/in corporate business validations
• Design and developing custom reports in FIN using SQR and PS-Query
• Interacted with client in the Design Document confirmation activities.

Environment: PeopleSoft Financials 8.4, Asset Management, Project Costing, PurchasingInventory and Accounts Payable

Confidential

Senior Peoplesoft Technical Consultant

Responsibilities:

• Project Scope involved support and maintenance of the PeopleSoft 8.4 Financials Application for the AP/PO/AM/PC/IN modules. Responsibilities are to understand User requirements and generate Functional and Technical Approach & Design documents, Implementation, testing and deployment of desired functionality and provide support for various maintenance activities.
• Developed new Application Engine programs for various requirements such as mapping of Inventory data with Asset Information in custom NBV table, Collecting Inventory statistics on a daily basis to be used as a source for various Inventory metrics reports, generating File Extracts using File Layouts for a number of complex queries in AM and PC modules to overcome the timeout problem for complex queries and for loading Capital Interest Data extracts into Custom Tables.
• Modified existing Application Engines and PeopleSoft Components to provide enhancements and code fixes for various month end issues such as such as modifications to the AP to PC process for filtering Asset entries. Modifications to the PC to AM process for chartfield validations, Development of Parallel Transaction Loader process, Modification in PO to make Vendor required when adding Items and, PO pre-save Budget check functionality, PO Hdr & BUD Hdr out of sync issue, Modification to the PO copy process for Inactive Vendors, Cancelled PO’s having active lines, Account update functionality for Kit Items in PO, Vendor Inactivation process validations, in AP, Modification to Pay Cycle process for Vouchers without control groups, Modifications to custom AM and PC Financial Batch transaction processes for various Transaction types, Bulk Adjustment functionality, Bulk Transfer functionality and Inter Unit Transfer functionality in Inventory, PC Resource Adjustments Functionality modifications and Location Inactivation functionality modifications.
• Created and modified various SQR Reports in AM, PC, PO and Inventory modules like AM Asset additions Report, PC Asset Additions report, Depreciation Forecast Report, CIP Detail Report. VNP Resale Report, Vendor spend Report, Open KK no received Report, Inventory transfer Audit reports, Scan transactions Audit Report, Online transactions Audit Report, Cycle Count Accuracy Report, Inventory Counts Report
• Facilitated Archival of various AM Tables that were growing in size over months to improve process and reporting timings on these tables. Also created a new customized Archive Designer to overcome some of the limitations of the delivered PeopleSoft Archive Designer.
• Provided on-call support during month end close processing activities. This required providing Technical support for a set of 15 processes in PC and AM for each month. Activities included ensuring appropriate amount of free data space for new Month end data for major tables in AM, monitoring processes, performing data checks at intermediate intervals to check for data inconsistencies and troubleshooting process errors.
• Provided SQL tuning for a number of AM User Queries used for month end close analysis.
• Created a Technical Document repository for all customized AM and PC Application Engine processes.

Environment: PeopleSoft Financials 8.4, Asset Management, Project Costing, PurchasingInventory and Accounts Payable

Confidential, Downey, CA

Peoplesoft Technical Consultant

Responsibilities:

• Project scope involved maintenance of PeopleSoft Financials BI/AR/AP/PO/AM/GL modules in version 8.8.
• Implemented a Custom Approval process in AR for Deposits to be approved by AR Functional Heads before being submitted to GL and an Approval process for GL Functional Heads to approve Journals from the AR module before they are entered in the GL module. Customized process to handle cash payments and Items separately and generated unique Journal id for all accounting entries for each Deposit to reflect the correct ADB date in General Ledger per Deposit. This customization involved 4 additional customized panel groups and three new SQR processes.
• Implemented Security in Custom Workflow process to implement security at the BU level for custom Workflow use and setup panels.
• Implemented a new SQR in PO module for reporting discrepancies between the Requisition Accounting Line and the Requisition Distribution Line.
• Provided Technical training to Asset Management users and developers on the usage of Asset Management.
• Setup custom Audit tables in GL for auditing on specific fields within some records like BUDGET PERIOD, GL ACCOUNT TBL, and BU LED GRP TBL to track record changes and backing up changes.

Environment: PeopleSoft Financials 8.8, Accounts Payable, Accounts Receivable, Purchasing, BillingAsset Management, PeopleTools 8.48, DB2 MVS, Windows XP.