SUMMARY

• 13 years of IT Experience, the last 9 years of which were focused on progressive system advancements using PeopleSoft Financials & SCM
• Involved in a wide variety of Functional / Technical engagements involving requirements gathering, application design and development.
• Worked extensively on PeopleSoft Application Designer, Workflows, Application Engine, People Code, SQRs, Component Interface, Crystal Reports, PS/nVision, PS - Query, Process Scheduler, Business Interlinks, Integration Broker, App Messaging, Upgrade Assistant, Security and other People Tools.
• Involved in development of Test Plans, writing & execution of Test Cases and Generating Test Scripts.
• Solid experience in PeopleSoft Financials Implementation/Upgrade Testing and Technical and Functional development.
• Worked extensively in the PeopleSoft Financial modules (GL, AP, AR, BI, EX, AM, Projects), SCM modules (PO, INV, ePro and OM) with experience in implementations, customizations and workflow setups.
• Developed Upgrade Plans, executed and reviewed Compare Reports, applied Upgrade Application steps, fixes and patches for the upgrade process, and performed Production Test Moves (*passes*).
• Very sound RDBMS concepts and good database programming experience using Oracle 9i/8i, MS SQL Server 2000/7.0/6.5 , SQL, and PL/SQL, DB2
• Expertise in Oracle DBA, Developments and data migrations.
• Very good understanding of RDBMS Design, Object Oriented Design and Structured Methodology Concepts.
• Strong Business analysis/programming capabilities & Functional knowledge in PeopleSoft Financial/SCM.

TECHNICAL SKILLS

ERP: People Soft Financials 9.1, 9.0/8.9/8.8/8.4/7.5

Functional Modules: Financials - AP, GL, BI, AR, Travel & Expenses, Project Costing, e Procurement, Inventory

People Tools: App Designer, Process Scheduler, Application Engine, Security, Component Interface, Import Manager, PS Query, Workflow, Upgrade Assistant, Data Mover, Tree Manager.

Integration Tools: Component Interface, Application Messaging, Business Interlink, File Layout

Reporting Tools: SQR, PS/nVision, Crystal Reports

RDBMS: DB2, Oracle 11g/10g/9i/7.x, SQL Server, Sybase, Access

Languages: C, C++, SQL, PL/SQL, Scripting and Shell languages, People Code, Visual Basic

GUI: Visual Basic 5.0/6.0, Developer 2000

Web Tools: Web logic 6.x/5.x, Tuxedo, HTML, XML, JavaScript, Visual InterDev, Servlets, JSP, Hammock,, CGI, Perl

Operating Systems: DOS, Windows 9x/NT/2000 Server/XP, UNIX.

Other: MS Office (MS Word, Excel, PowerPoint, Access) and Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Lead Consultant

Responsibilities:

• Prepared fit-gap analysis of functional specifications for requested enhancements based upon detailed understanding of PeopleSoft - process best practices, and client requirements
• Utilized functional and technical PeopleSoft knowledge to come up with different alternative solutions to meet client business requirement
• Prepared design specifications including enhancements, configuration & reporting
• In the global roll out worked on country specific VAT requirement
• Provided consultation in Developing, testing and rollout of new functionality, custom interfaces, conversions and reports
• Single point of contact for the offshore team to manage the R(Reports), I (Interfaces), C(Conversion), E(Enhancement) and W(Workflow) deliverables
• Design, developed and implemented the batch schedule for the Global environment
• Worked with clients infrastructure team for various project related requirements
• Provided ongoing functional and technical support for post go-live issues

Environment: People Soft Financials 9.1, GL, AP, PO, PC, AM, T&E, Inventory and E-pro. People Tools 8.52, People Code, PS/Query, SQR, Application Designer, Process Scheduler, Application Engine, Oracle 11g

Confidential, Albany, NY

Advisor - ERP

Responsibilities:

• Developed/tested Income Statement in n Vision Report
• Developed/tested Balance Sheet statement in n Vision Report
• Created custom view in People Tools to provide statistical information for use in GL nVision reports.
• Created reporting to support aggregation of payments collected in AR to be remitted to Insurance Providers by AP.
• Created Custom Tables, views, Queries
• Developed SQR for Disbursement Sign Off process
• Worked on Single Sign On set up
• Worked on PeopleSoft Style Sheets
• Managed and controlled all report requirements through development/test and acceptance
• Supported all Functional team leads

Environment: People Soft Financials 9.1 (GL, AP, AR/BI), People Tools 8.52, People Code, PS/Query, SQR, Application Designer, Process Scheduler, Application Engine, Oracle 11g

Confidential, Columbia, SC

Tech Lead

Responsibilities:

• Implementation of AP, Inventory, Purchasing and e-Pro modules
• Followed Agile Methodology for implementation
• Data mapping of legacy system fields with PeopleSoft fields and functionality.
• Load Vendor information from Meditech to PeopleSoft.
• Setup voucher process and pay cycle.
• Developed File layout and SQR to load Inventory and items.
• Set up Financial Gateway using Integration Broker.
• Developed interfaces for AP, Inventory, purchasing.
• PeopleSoft FSCM upgrade from 8.8/8.49 to 9.1/8.51 for GL.
• Adding new fields and applying people code changes to GL journals and custom journal entry pages.
• Adding new custom fields to JRNL1.XLS and records for Journal spreadsheet upload processing.

Environment: People Soft Financials 9.1, GL, AP, PO, Inventory and E-pro. People Tools 8.51, People Code, PS/Query, SQR, Application Designer, Process Scheduler, Application Engine, Oracle 11g

Confidential, Syracuse, NY

Lead consultant

Responsibilities:

• Involved in identifying table differences from 8.8 to 9.1
• Involved in Fit-Gap Analysis for 8.8 vs. 9.1
• Used Upgrade Assistant tool & Change Assistant tool during the Upgrade.
• Analyze compare reports to identify customizations that need to be re applied to 9.1/8.51.
• Reapplication of Customization by Customization for Online Objects, Reports and Interfaces according to the CTT's
• Re applied customizations from 8.8 to 9.1GL, AP, AM and PO modules.
• Involved in Retrofit 8.8 SQR reports in to 9.1 app engines.
• Involved in Unit testing and system testing for the customizations and processes.
• Developed unit test plan for testing customizations re applied during upgrade.
• All SQR’s and custom queries verified and modified with Record changes.
• Developed spread sheet upload process for vouchers.

Environment: People Soft Financials 9.1, GL, AP, AM and PO, People Tools 8.51, People Code, PS/Query, SQR, Application Designer, Process Scheduler, Application Engine, Oracle 10g and TOAD

Confidential, Bloomington, IL

Sr. PeopleSoft Developer

Responsibilities:

• PeopleSoft FSCM upgrade from 8.8/8.49 to 9.1/8.51 for GL/AP/AM/PO/TE/e-Pro modules
• Analyze compare reports to identify customizations that need to be re applied to 9.1/8.51.
• Using Agile Methodology Re applied customizations object by object from 8.8 to 9.1GL, PO, AM and AP modules.
• Involved in Retrofit 8.8 SQR reports in to 9.1 app engines.
• Supporting and fixing issues with GL and AM processes and customizing pages and components.
• Fixed EDI File layouts in sync with 9.1
• Adding new fields and applying people code changes to GL journals and custom journal entry pages.
• Adding new custom fields to JRNL1.XLS and records for Journal spreadsheet upload processing.
• Involved in Unit testing and system testing for the customizations and processes.
• Worked on nVision Reports and Crystal Reports.
• Worked on Follow up for Payment overdue Aging Report.
• Worked on payment posting process.

Environment: People Soft Financials 9.1, GL, AP,EX, AM, AR/BI, TE and PO, People Tools 8.51, People Code, PS/Query, SQR, Application Designer, Process Scheduler, Application Engine, DB2 and Mainframes.

Confidential, Pittsburgh, PA

Sr. People soft Developer

Responsibilities:

• Involved in identifying table differences from 8.4 to 9.0
• Involved in Fit-Gap Analysis for 8.4 vs. 9.0
• Used Upgrade Assistant tool & Change Assistant tool during the Upgrade.
• Used Data mover to migrate data from one data base to another data base.
• Involved in Retrofit process i.e. modified all customized SQR, App Engine and people code from 8.4 to 9.0.(during the time of Upgrade from 8.4 to9.0)
• Involved in running compare reports.
• Ran the Audit Reports - SYSAUDIT, DDDAUDIT & ALTER AUDIT. Cleaned up any inconsistencies reported
• Automation of PNC approval process- Project Managers can approve projects and Invoices online.
• Data Conversion for 2007 and prior vouchers info: Voucher lines update as per data conversion process thoseby-passed in Data Conversion.
• Job created to populate multi-currency rates.
• SQR developed to load Vendors from newly acquired companies (NCC) into People Soft System.
• Sequence Number Field added to Quick Invoice Entry page.
• Added condition to skip BANK ACCT SEQ NBR field as when voucher coming fromBATCH process.
• New SQR developed GL reconciliation statement for active projects
• SQR modified to load Government vendors into People Soft system and Payables advantage.
• App Engine created to inactivate vendors after 18 months of inactivity.
• Custom page created for Foreign w8 status tab.
• Developed and customized PS queries as per business requirement.
• Voucher Build and Edit App Engines (AP VCHRBLD, APVEDEDIT) modified to process SGLP Vouchers and thro BATCH process.
• Customized Invoice information page, added fields to capture loan number and transaction type for Mortgages.
• For quick invoice entry page customized as per requirement and logic added for business flow using people code.
• APY2021 crystal report modified and changed MICR line format.
• Support and train users with new enhancements of application.

Environment: People Soft Financials 9.0, GL, AP and PC, People Tools 8.48, People Code, PS/Query, SQR, Application Designer, Process Scheduler, Application Engine, DB2 and Mainframes.

Confidential, Las Vegas, NV

PeopleSoft Technical Developer

Responsibilities:

• Involved in the requirement analysis, preparing design specifications, developing and testing reports and Interfaces in GL, AP, AR, PC and AM.
• Fixed issues regarding matching, voucher edit, voucher post, journal edit and AR update processes.
• Experience with People Code events, Editor, Methods and built in functions.
• Designed and scheduled various batch jobs in Process Scheduler.
• Involved in customization of GL interface process and coded the necessary programs. Generated reconciliation Reports as part of the process.
• Wrote custom SQR program in GL to load journals from external interfaces into JRNL HEADER and JRNL LN tables.
• Created validation and Load reports responsible for reviewing design specs and SQR programs and make recommendations.
• Developing the Application Engine Programs for high-volume batch processing using People code, Process Scheduler and SQL.
• Customized AP VCHRBLD to insert the voucher data of specific origin into custom tables.
• Fixed the bugs in the Design those were found in the production. Some of the Distribution lines were not populated in the voucher tables but were deleted by AP VCHRBLD Process.
• Developed an Application Engine program to create Vendor outbound files based on an hour and date for the EDS system to pick up to send the files to the designated branch in the Third Party System.
• Tuned various processes like AP VCHRBLD process.
• Experience in various levels of Production Support, debugging, correcting existing processes and troubleshooting.
• Prepared test cases for various reports and interfaces and successfully executed them.
• Debugged and Traced Application Engine Programs for Journal Edit, Voucher Build, Edit and Pay Cycle Processes.
• Also debugged Journal Entry, Journal Edit, Vendors and Voucher Panels.
• Worked closely with the functional team in resolving many issues.
• Setup Voucher Approval Workflow for one of the business units and customized activities per the requirements.
• Developed several reports using SQR and PS/QUERY and submitted processes to the Process Scheduler to run daily tasks at a specific time to run process recursively at a specific interval.
• Customization for creating Unique Service Order across the all business units.
• Involved in Integration and Parallel Testing.
• Involved in post-production support and resolved various issues.

Environment: PeopleSoft Financials 8.9, GL, AP, AR, BI, AM, PO and PC, People Tools 8.47, People Code, PS/Query, SQR, Application Designer, Process Scheduler, Application Engine, Oracle 9i

Confidential, San Francisco, CA

PeopleSoft Technical Developer

Responsibilities:

• Set up the data flow from Billing to AR and data flow from AR to GL
• Designed and developed in-bound and out-bound interfaces to and from PeopleSoft to existing legacy system.
• Created many design documents related to the modifications identified by the end users.
• Modified Contracts to Billing process to split over the limit amounts proportionately between the regular expense and SFA lines.
• Trained users and in-house technical team in functional and technical viewpoints
• Extensively used PS Query to develop ad-hoc queries, generate crystal reports and to produce analyzing reports using excel.
• Generated Summary Ledger, Detail Reports and Journal Entry Details Reports on a daily basis through nVision using the user defined Chart Fields.
• Worked on data mapping by identifying all the external source tables and fields and identifying corresponding PeopleSoft tables and fields for our Data Conversion.
• Developed an interface using Application Engine and Component Interface to convert all open Vouchers from legacy system into People Soft Accounts Payable
• Coded extract program to create positive pay file to be sent to bank
• Developed a SQR process to calculate the Net Book Value Report for every accounting period for a particular category
• Developed an Application Engine for manually retiring the assets in Asset Management
• Developed a new program to print invoices for Billing module.
• Assisted in Production support to resolve issues regarding Account Receivables, payables and user support

Environment: PeopleSoft Financials 8.8, GL, AR, AP, BI, and IN, People Tools 8.47, People Code, PS/Query, SQR, Application Designer, Process Scheduler, Application Engine.

Confidential, Arkansas

PeopleSoft Technical Analyst

Responsibilities:

• Worked with People Code, Application Engine and Component Interface.
• Developed People Code programs to implement functionality and fix code
• Customized and developed various PeopleSoft objects like Fields, Records, Pages, Components, Menus, File Layout, Query
• Tracking the Requisition build process and PO build process
• Involved in the cleanup of POBUILD staging tables and help users with any errors during the creation of requisitions and POs
• Worked on enhancements in PO and OM using People Code and Application engines
• Track POs all the way through Accounts Payable and make sure Matching ran successfully
• Fixed Data and Formatting issues with the customized POPO005 (PO Print and Dispatch)
• Worked on the Receipt/Put away process and troubleshoot any receipts that are stuck during the put away to inventory
• Support the shipping/storeroom after go-live to troubleshoot some problems like label printing, generation of picking list, Packing slip and invoices
• Developed the following SCM reports using SQR
• Demand Eligible To Buy
• Demand In Excess of Supply
• DPAS Rated Sales Orders Warehouse / Drop Ship
• Item Availability Report
• Over PO report
• Under Supply Report
• Special Cost Warehouse / Drop ship
• Contract Orders Report
• Partial No Orders Fully Allocated Not Ticketed
• Partial Yes Orders Partially Allocated Not Ticketed
• Inventory Aging Report
• Invoice
• Commercial Invoice for Customs
• LMIT Summary Reports by Header, Line, Serial ID
• Invoice Summary Report
• Inventory Backorder Report
• Shipping Report
• Cumulative Daily RAs
• Daily RA by aging by CSR
• Daily Ship Report

Environment: PeopleSoft Financials 8.8, PO, AP, BI, OM, IN, People Tools 8.46, SQR, Designer, Process Scheduler, Application Engine