SUMMARY

• Around 8 years of IT industry experience in implementation, upgrade and maintenance of PeopleSoft Financials, Accounts Receivables, General Ledger, Accounts Payables and Purchasing.
• Proficiency in upgrade, development & maintenance of PeopleSoft Applications
• Extensive experience in PeopleSoft Analysis, Implementation, and Upgrade & Production support experience.
• Experience inImplementation,Production Support,Customization,Upgradesand Troubleshooting inAP, PO, GL, ARandAMmodules.
• In - depth knowledge of PeopleSoft Development Life Cycle(PDLC) - Fit/Gap Analysis, Design, Data Conversion, User Interface Customization, Unit / Integration / System /Acceptance Testing,End User Training.
• Thorough understanding of Peoplesoft Financials Management process throughout lifecycle, including design, configuration, development, Integration, testing and deployment.
• Specialized in Functional analysis, designing and developing customizations of Pages, Components interfaces, and reports.
• Process expertise inProcure to PayandRecord to Reportbusiness processes inFinancial Services and Transportation industry verticals.
• Experience in Database - SQL Server, Oracle, SQL Base, MS-Access, DB2
• Strong RDBMS skills and hands on experience inOracle 8i/9i/10g and SQL Server 2000, DB2using tools like SQL Navigator, Toad for performing SQL.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Experience in retrofit ofSQRsduring upgrade from Finance 8.8 to Finance 9.0.
• Experience in Business Requirements gathering, Fit-GAP analysis and writing Functional and Technical Specifications.
• Involved in Unit Testing and Systems Integration Testing during up gradation of PeopleSoft.
• Excellent Interpersonal and Communication skills, problem solving and Strong analytical skills to convert Functional design specifications into Technical Design specifications.
• Experience in Upgrade, Support, Customization and Implementation of PeopleSoft Financials 9.0/8.9/8.8/8.4/8.0.
• Good Understanding of record structures and data flow of PeopleSoft Financial modules like Asset Management, Accounts Receivables, General Ledger, Inventory Accounting.
• Good Understanding of development of reports using XML Publisher.

TECHNICAL PROFICIENCIES

ERP: PeopleSoft Finance(8.8, 8.9, 9.0) (PO, GL, AR, AP, Epro, INV)

People Tools: People Tools 8.22, 8.45,8.49, 8.50, Application Designer,People Code, Application Engine,Component Interface, Workflow, File Layout.

Platform: MS DOS, Windows.

Report Tools: XML Publisher, SQRsandPS Query,Crystal Reports

RDBMS: Oracle10g/9i/8i, SQL Server, DB2, Access.

Tools/Packages: MS Office, MS Project, Visio

Operating Systems: Windows Vista, XP, Windows 2000, Windows NTEducation

PROFESSIONAL EXPERIENCE

Confidential Minneapolis, MN

PeopleSoft Functional Consultant

Responsibilities:

• Worked with Users, Application owners, Managers and team to draw up specifications and gather requirements for Peoplesoft FSCM (PO, Inventory, ePro, BI, GL, AP, AR).
• Gathered requirements, fit/gap, configured system to implement financials 9.2 from legacy system
• Helped business users to improve business process from their current process
• Configured Financial gateway to interface with banks
• Implemented out sourcing of check printing
• Designed & Implemented integeration of PeopleSoft Financials with HR and non Peoplesoft applications
• Assisted in streamlining the SCM Process as per requirements and anticipated deliverables. Designed and developed several custom interfaces to BI, PO, AM AP and GL Modules.
• Worked extensively with AR update and Payment predictor Process. Customized AR statement process with the interface with BI.
• Designed purchasing workflow process and Troubleshoot GL Journal Edit issues.
• Supported and customized INV and ePro Interface and Worked with Business Unit, Setup Ledger
• Customized nVision Reports. And Apply Peoplesoft upgrades and patches. Configured/enhanced Check Printing.
• Customized crystal invoices as per the company’s requirements. Designed, Developed and implemented custom schedule billing online pages.
• Interacted with Users and Functional Analysts to come up with new requirements for the business unit.
• Customize PO Dispatch process, Fix issues related to matching
• Involved in different phases of QA Testing like Unit Testing, Integration Testing and Regression Testing
• Customized AP trial Register and other AP Crystal reports.
• Performed testing of AP voucher post, Payment post, Pay Cycle Processes
• Troubleshoot and helped to resolve supplier purchase order and invoice issues
• Implemented Workflow and Journal Approval for General Ledger Journals.
• Worked in the Post Implementation Production Support for the PO, ePRO, AP & GL modules.
• Involved in setting up the Chartfield Combination Setup. (General Ledger).
• Modified security settings after gathering requirements from user groups to determine security structure.
• Involved in the analysis and implementation of PeopleSoft OM for Capturing and Validating Orders.
• Ran compare reports before and after applying the patches/fixes
• Migrations of customizations like Record definitions, pages, Components, Run control pages, Portal Registries, A.E Programs and Component Interfaces for all modules.
• Fixing of problems and issues which come across during various stages of implementation like development, User acceptance and live of project costing
• Involved in Post-Production Activities, Documentation

Environment: PeopleTools 8.50, FSCM 9.0 (AP, PO, ePro, GL, AM, AR, PC), SQL, Crystal Report, SQR, Oracle 11g

Confidential, Newark, DE

Soft FSCM Functional Consultant

Responsibilities:

• Worked with team and users to gather requirements, anticipated functionality deliverables and determine the specifications for implementation.
• Responsibilities include preparing fit/Gap analysis, proto-type, build, functional design document, configuration document, data conversion plans and technical design document.
• The university did not had an AR system the past, designed a new AR business process for AR and implemented that process.
• Experience in using Commitment control for AP, AR & Billing.
• Experience in converting legacy data to PeopleSoft. Heavily used Excel to CI in this project.
• Assisted in testing & troubleshooting eProcurement module.
• Configured their system to meet their internal controls such as segregation of duties.
• Worked in PeopleSoft Security module (Security Admin) this includes building roles, permission list (assigning Process groups, Query tree access groups, web libraries, Component security, nVision reporting security).
• Reconciling Grants/Project costing to Billing/AR
• Identify data conversion issues and proposed solution to fix the data
• Designed and interfaced to load data to AR from external system
• Setup of procedures to validate each processes on how to reconcile between PC/Billing & AR
• Document functional/technical specifications for RICE elements.
• Involved in developing Inbound Interfaces customizations in FSCMs 8.8 like OM, INV, GL, ePro, Billing, AP, AR, PO, RECV by using App. Messaging.
• Assisted users with P-card processing.
• Created and modified several new reports and queries.
• Generated Crystal reports for updating the status of Order Schedules, for Processing Inbound and Outbound transactions for order, for reporting all contracts and their status.
• Working with Business People and getting their requirements and customizations, Drawing Process Diagrams that helps other team members to understand system easily.
• Configuration OM, INV, AP, GL, AR setup data (like Business Units, Control data, Vendor Location, Origin, Items etc)
• Fixed errors in billing for several interfaces, printing invoices etc
• Evaluation, customization and setting up of workflow for Journal Entry Approval, Asset Transfers approval and Voucher Approval Processes, Receivable processes.
• Performed Fit gap analysis for various processes and helped users in finalizing various processes.
• Involved in Post-Production Activities, Documentation

Environment: PeopleSoft 9.0,People Tools 8.49, Oracle 11g,AP, AR, GL, AM, BI, ePro, OM, PO, INV

Confidential, Memphis, TN

Peoplesoft Financial Functional Consultant

Responsibilities:

• Designed and mapped data for a conversion program which reads the data from a flat file and writes it into a file so that Journal load program will read that data and insert into Journal Tables.
• Performing production support and daily enhancements for PeopleSoft Finance Modules like Asset Management, Purchasing, Project Costing and Accounts Payables.
• Posted all AP transactions to create accounting entries and closed Pay-Cycles prior to upgrade of the AP module.
• Involved in designing and Data mapping for several interfaces in GL and AP likeCIS to AP interface, ACH interface, Pro-Card Interface.
• InstalledUpgrade Assistantand created Upgrade Assistant jobs.
• Modified, ran and reviewedUpgrade Compare Reportsand Upgrade compare process.
• Involved in unit, system, and integration testing for AP, PO, and GL modules.
• Applied PeopleSoft fixes and patches to Order Management and Inventory.
• Interacted with users and collecting business requirements and prepared functional and technical specification documents.
• Custom modified Pay Cycle Details page and Payment Selection Criteria page in AP. A Workflow was created for approvals needed after payment selection process but before payment creation process.
• Modified Pay Cycle Details page for adding and viewing attachments.
• Worked with Accounts Payable, General Ledger Cash Management on various customizations, which involves Positive Pay, Vendor Interface, Automation of journal entries, Service Fee Automation, Cash Reserve Priority.
• Involved in estimating theScope, Budget and Time-linefor People Tools,Application and Customization upgrades.
• Created test scripts for Journal Entry, Journal Upload and Journal Processing.
• Created and executedTest Scriptsforunit testingin GL for testing ‘Journal Entry’, ‘Open a Period’, ‘Close a Period’, etc functionality.
• TroubleshotJournal Generator processfor ‘missing Inter-Unit Accounting Lines’, ‘Unbalanced Journal Entries’, ’subscript out-of range’ errors.
• Used ‘Ledger Vs Journal Integrity Report’ for troubleshooting discrepancies between out-of-sync Ledgers and Journal tables.
• Created variousSummary ReportsforGeneral LedgerusingnVision.
• SetupBanksfor Accounts Payable. Involved in setup ofSales and Use Taxdefaults and options.
• Setup Payment Timing codes,Single and Multiple Pay Terms.
• EstablishedVendors, Vendor Locations and Vendor Pay Group Codes.

Environment:PeopleSoft 8.8/8.0, Oracle 9i, Windows XP, Visio, Crystal Reports 9, nVision, PS-Query (GL, AP, PO, AM & EPM)

Confidential, Georgetown, KY

PeopleSoft Financials Functional Analyst

Responsibilities:

• Responsibility includes Core Process Analysis covering -
• Current System Functionality, Fit-Gap Analysis, Facilitation and Documentation, Specifications Development and Reviews, Core User Training, Security Analysis.
• Understanding and analyzing the business requirements, preparing the functional specs and getting signoff from the business.
• Providing the effort estimates from the functional perspective for the Functional design specification, configuration, testing and UAT.
• Co-coordinating meetings and taking key decisions in the project.
• Designed the PeopleSoft interface process and Functional Design Document for the Maximo PeopleSoft Interface.
• Working with the Technical team to provide the understanding on the business requirement.
• Wrote Technical Design Documents for different requirements using the Business Requirement Document. Developed the requirements according to the Technical Design Document.
• Worked on E-Receipts module and Rewrote the process to make it as one process instead of separate steps.
• Creating Test cases by covering People-soft delivered functionality, customization and additional configuration covering all the business requirements.
• Involved in Query and Reports Security design, development and testing.
• Involved in generating Security and Auditing Reports at different Department-wise.
• Worked on Item Inquiry to include all transaction groups and sort properly and include correct status.
• Involved in design, development and testing of Permission lists, users, Roles and assigned roles to users for diff Business units.
• Worked with Business Analysts to get the Business process information for the custom built pages and Custom Records for Query.
• Working on PeopleSoft e-Commerce Implementation project.
• Created custom Vendor Inquiry page according to the user requirements.(Payables).
• Modified the delivered search for items in e-procurement according to requirements.
• Solved the issues in Workflow, inGL (General Ledger), when the workflow is not being routed to correct people.
• Created Archive process to remove older MRPs from the MRP tables for Material Request Page.
• According to the requirements, controlled dispatch of Purchase Orders from Procurement Contracts.
• Involved in the Setup of Financials at Business Unit Level.
• Responsible for supporting key financial processes such as Year-End/Month-end close, Combo edit rules, spreadsheet journal imports.
• Modified Report which summarizes all payments by vendor, payment bank account, payment date, and employee ID.
• Involved in printing the Purchase Order copy at the desired FAX machine.

Environment: PeopleSoft FSCM 8.9, People Tools 8.50, People Code, Application Engine, Integration Broker, SQR, Component Interface, Crystal reports 9.0, Oracle 11g, PS Query

Confidential

PeopleSoft Financials Developer

Responsibilities:

• Developed outbound interface to send GL actuals and Budgets data in a pipe-delimited file.
• Worked on Application Classes and People code.
• Prepared Technical specifications depending on the functional specifications.
• Worked on application engine programs like Payment Predictor, Receivable Update of AR and Voucher Posting, Payment Posting, Matching of AP.
• Involved in customizations of pages, components and PeopleCode related to all Financials & SCM modules.
• Extensively involved in development and bug fixing across all modules.
• Providing technical solutions for complex problems.
• Responsible for Unit Testing and Bug Fixing.
• Responsible for solving STR (System Trouble Reports) at the time of IST (Integrated System Testing) and preparing STR documents.
• Responsible for development of change control arising at the time of IST.
• Worked with business to do Fit Gap Analysis, suggest changes to system or configurations to accommodate business needs and also suggest best solutions in PeopleSoft.
• Worked in Production Support Model for Asset Management module which involved Loading Assets from interface tables into PeopleSoft, Fixing jobs abends related to Calc Depreciation process, resolving business user’s issues or inquiries regarding asset transfers. Balances.
• Worked on creating Application Engine Programs for automation of repetitive tasks for business users.
• Modified invoice print programs for specific requirements.
• Worked on writing Excel to CI interfaces to help business load burden rates, Bill Of Materials into PeopleSoft using excel.
• Designed and developed custom app engine programs to read data from external files load them into PeopleSoft and perform processing.
• Developed a program to load Project Resource table from AR item tables.

Tools: Peopletools 8.45, Peoplesoft, Peoplesoft Order Capture, SQR, PS Query, Integration Broker, Application Designer, Application Packages and Application Engine