SUMMARY

• Professional experience of 7 years in development and support of PeopleSoft 8.x/9.x Financial and Supply Chain Management module: Purchasing, e - Procurement, Account Payables, General Ledger, Asset Management, Billing, Accounts Receivables, Order Management, Inventory.
• Sound knowledge in enhancements and support of PeopleSoft FSCM 9.2 modules: Purchasing, e-Procurement, Account Payables, General Ledger, Asset Management, Billing, Accounts Receivables, Order Management, Inventory Commitment Control, Cash Management.
• Good Knowledge on PeopleSoft HCM 9.0 modules: Payroll, Time and Attendance, Employment Data and Workforce Administration.
• Expertise on Data mapping and Data Analysis between Legacy systems and PeopleSoft System.
• Expertise in writing functional specifications for business requirements and test cases.
• Expertise in creating PeopleSoft Technical Design Documents as per the business requirements.
• Expertise in PeopleSoft Concepts and related tools like Application Designer, People Code, People Tools, Application Engine, Integration Broker, Component Interface, PS Query, Process Scheduler, Security, Data Mover, SQR, BI Publisher, XML Publisher, envision and Excel to CI.
• Expertise in writing PS Queries for creating reports.
• Expertise in Workflow design and implemented effectively for various Change Order Approvals.
• Profound knowledge on SQL and RDBMS concepts such as Normalizations, SQL optimization and tunings.
• Sound knowledge on SQL Language Definitions me.e. DDL, DML and DQL.
• Contributed my part in several stages of system life cycle, including defining business requirements, interviewing end users, development, testing, conversion, end-user training and functional documentation.
• Excellent analytical, communication and problem solving skills. Very strong in client interaction and interpersonal skills.

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, People Code, Application Messaging and Component Interface.

Integration Tools: Application Messaging, Component Interface and Business Inter Inks

Reporting Tools: SQR, envision, 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, Dallas, TX

PeopleSoft FSCM Techno Functional

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.

Environment: PeopleSoft Financials 9.1, Accounts Payable, Asset Management, Purchasing, Project Costing and General Ledger, People Tools 8.51, Oracle 11g.

Confidential, Chevy Chase, MD

PeopleSoft FSCM Techno Functional

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.
• 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, People Tools 8.51, Oracle 11g.

Confidential, SFO, CA

PeopleSoft FSCM Techno Functional

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. Egg: AM and PC accounting and transaction data to Tax group, AP Vendor data to Vendor Management group, AP data to SCM group, Pasay Interface files to Banks, Recon File consumption from Banks, etc.
• Provided Metric Reports for system wide data to Higher Management.
• Used Data mover 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 unsporting 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 Cash flow and other financial reports for decision making process using envision and GL.
• Modifications to GL OPEN ITEM DET page and People Code 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/envision.
• 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 People Code 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, Purchasing, Inventory and Accounts Payable, People Tools 8.44 & 8.49, Oracle 10g.

Confidential, Omaha, NE

PeopleSoft FSCM Techno Functional

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 chart field 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 Her & BUD Her 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 dat 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. dis 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, Purchasing, Inventory and Accounts Payable, People Tools 8.44, Oracle 10g.

Confidential

PeopleSoft FSCM Techno Functional

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. dis 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, Billing, Asset Management, People Tools 8.48, DB2 MVS, Windows XP.