SUMMARY:

• 7+ years of PeopleSoft FSCM Consultant/Business Analyst experience in PO, Purchasing, eProcurement, EDI, Order Management, Inventory, Accounts Payable, General Ledger, Accounts Receivable, Billing, Project Costing.
• Involved in design, development, implementation, FSCM Upgrades, Testing, Maintenance and post - production support of Oracle/PeopleSoft FSCM applications.
• Strong experience in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports).
• Involved in developing Inbound Interfaces customizations in FSCMs 8.4 like OM, INV, GL, ePro, Billing, AP, AR, PO, RECV by using App. Messaging.
• Experience in supporting and maintaining PeopleSoft FMS Public Sector and the encumbrance Commitment accounting application 9.0 and People Tools module include Accounts Payable, Travel and Expense, eProcurement, Purchasing, Commitment Control, General Ledger, Asset Management, Project Costing.
• Handled worldwide support, develop, trouble shoot of whole suits of PeopleSoft Financial and Supply Chain, which includes GL, AR, AP, Purchasing, eProcurement, Inventory, OM and BI for 8 different business entities from v.8.9., v.9.0, v.9.1, v.9.2.
• Experience in business critical and complex components using PL/SQL, Oracle reports 10g, forms 10g, XML Publisher, Workflow, OAF, AME.
• Experienced creating various PL/SQL stored procedures, views, functions and temporary tables for data input to the Crystal Reports.
• Experienced in PeopleSoft Finance modules like General Ledger, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing and PeopleSoft HRMS modules like HR, Benefits and having knowledge of G/L business process and financial reporting. Also, knowledge of Contracts, Billing, and enterprise price with strong App Designer.
• Strong expertise in FSCM-Collection management, Dispute management and Credit management.
• Excellent working knowledge of the PeopleSoft Internet Architecture (PIA) and the flow of data exchange between various FSCM modules.
• Comprehensive experience in setting up security in HRMS, Financials, CRM, EPM, and Portal environments
• Developed Component Interface and Application Engine Program to upload the employee Re-hire job information to the PeopleSoft system from the feed files.
• Experienced in application development using People Tools and has knowledge on application designer, people code, component interface, application engine, PS query and sqr reports and is well conversant with PS HCM and PeopleSoft Financial applications.
• Expertise in working with PeopleSoft Development and Application tools like Application Engine, PS Queries, People Code, Integration Broker, CI and basic knowledge of XML Publisher.
• Tier 2 support for PeopleSoft Supply Chain Management (SCM), Inventory, Contracts, Purchasing (PO), Accounts Payable (AP), General Ledger (GL) modules and overall system configuration.
• Responsible for the design and development of key processes for the PeopleSoft Financial modules Purchasing (PO) Accounts Payable (AP), General Ledger (GL) Accounts Receivable (AR) & eSupplier.
• Managed custom PS module, which imports customer data from 3rd party application to PeopleSoft AR.
• Managed staff supporting PeopleSoft Financials Supply Chain Management (FSCM) / Procure to Pay modules.
• Experience writing numerous interfaces to 3rd party vendors like Bill interface load to GL, Bill interface load to AR.
• Involved in developing Inbound Interfaces customizations in FSCMs 8.4 like OM, INV, GL, ePro, Billing, AP, AR, PO, RECV by using App. Messaging.
• Provided monthly system hands-on and virtual classroom to Human Resources Specialist, Bureau of Fiscal Service (shared service center), Human Resources Specialist, Classification Specialist, Administrative Officers, Senior Executives, Managers and Selecting Officials on the use of the Career Connector System.
• Created Various SQR Interfaces (Inbound & Outbound) and Reports to load data from external systems into PeopleSoft GL which in result conducts various Chatfield validations, Combo Rules, Trees, derive various values based on the data from the external system.
• Expertise in using available PeopleSoft 9.1 & 9.2 Time and Labor rules and building new Time and Labor rules.
• Expertise in PeopleCode, Application Engine, Integration Broker, PS Query and Component Interface.
• Executed and created the test cases for the custom process that captures the vendor ids as a part of the AP/GL interface which populates the Journal Entries to GL module.
• Analyzed the existing customization of pages in AP, GL & AR and collaborated with the functional team in deciding the re-application of the existing customizations.
• Supported in troubleshooting AP and GL issues like offset balance between the AP and GL reconciliation by running the sub system reconciliation process and analyzing the vouchers by business unit and voucher IDs.
• Performed research and study of the existing system tables and business processes. Also involved in the in- depth study of the customizations made in the GL, AP, AR, PO, INV modules.
• Experience in customizations to Allocation Workbench in Fulfilling Stock Orders (Added Group by Item and Group by Bill To search).
• Technical knowledge of PeopleSoft encompasses a familiarity with PeopleCode, Security, PeopleTools, Application Designer, SQR Programs and AE.
• Proficient in customization of PeopleSoft objects including Page, Records, Application Engine, Component Interface and Menus to suite the client's requirements
• Expertise in implementation, upgradation, integration, enhancement/customization and production support of workday modules like Accounts Receivable (AR), Accounts Payable (AP), General Ledger (GL), Billing, Invoicing, Inventory, Commitment Control, Project Costing, Purchasing, Grants Management and reporting.
• Involved in developing Inbound Interfaces customizations in FSCMs 8.4 like OM, INV, GL, ePro, Billing, AP, AR, PO, RECV by using App. Messaging.
• Experience in Datacenter migration activities in PeopleSoft HRMS and Finance.
• Expertise in PeopleCode, Application Engine, Integration Broker, PS Query and Component Interface.
• Creation of PS queries for KERN users in modules like Inventory, Purchase order, AP.
• Aided OHD with procurements over $25K that go through DGS by handling administrative duties associated with solicitations, evaluating and ing contracts according to the State Procurement Laws (COMAR).

WORK EXPERIENCE:

Confidential, Austin, TX

Peoplesoft FSCM Consultant

Responsibilities:

• Provided vision and aligned Compensation, Benefits and HRMS initiatives with organizational priorities.
• Involved in design, development and testing of PeopleSoft modules General Ledger, Accounts Payable, Purchasing, eProcurement, eSupplier, Strategic Sourcing, Asset Management, Account Receivables, Billing, Inventory and Order Management.
• Extensively worked on rule performance and compilation of rules in Time and labor.
• Designed, Developed, Tested and Supported Report using PS Query (End User) and PS/nVision (Balance Sheet).
• Developed custom Purchase Order dashboard component to display Requisition, Purchase Order and General Ledger information related to purchase order.
• Assumed added responsibility for developing Crystal reports for HR users, utilizing SQR and Crystal Reports system.
• Application Engine for PeopleSoft HR, Benefits, Payroll and Pension modules. Involved in tracing and fixing the problems for Benefits and Payroll interfaces.
• Wrote test Cases for PeopleSoft Financial modules (and assisted in automating scripts using Quick Test Pro).
• Designed and Developed Several Custom interfaces to AR, BI, PO, AM, Commitment Control, Inventory, AP and GL Modules.
• Designed BI Publisher Report Definitions, Templates and Data Sources to generate AP/BI/AR/GL/PO/KK module reports using people Code and Process Scheduler.
• In Resolved using different tools including SQL, PS/Query and Oracle Support to meet required SLA's and satisfy KPI’s. perating budget and maintains efficient tracking of financial resources and transactions, including accounting purchasing, cash management, and payroll.
• Bookkeeper (billing, invoicing, deposits, payments, collections, payroll, taxes, purchasing, estimates using QuickBooks Pro).
• Worked in PeopleSoft Finance modules like GL, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing.
• Implemented Crystal Reports and Business Objects reporting for the Bureau of Automotive Repair (BAR) for smog emissions data analysis.
• Modified the functionality in Order Management to disallow change or cancellation on orders if the item on the order is on allocation, reservation or confirmed status.
• Worked on Integration Broker and Application Class PeopleCode and AWE Allocation Workbench in Fulfilling Stock Orders.
• Created invoicing and posting routines for accounting system using commitment control using Synon CASE.
• Ensured the efficient allocation of resources to deliver business results utilizing appropriate resource planning tools.
• Utilized Crystal Reports and SQL (including functions, views, and stored procedures) to deliver customized accounting, sales, and operational reports to clients on time-sensitive deadlines.
• Procurement responsibilities by ordering supplies and/or equipment when needed
• Work closely with Human Resources to ensure employee new hire and termination dates, pay rate, leave accrual rates and balances, payroll deductions, and related payroll information is complete and accurate.
• Interface with Finance; journal entry adjustments and reconcile general ledger accounts associated with payroll.
• Act as a liaison between ADP and Enerflex to ensure payroll taxes and returns are prepared timely and submitted timely and accurately.
• Worked on Peoplesoft HRMS for such functions as performance review and talent management, payroll, recruiting and self-service reporting.
• Getting Time reporter data from a third-party system into People soft system using TCD interface and processing the information to generate payable time for employees.
• Developed business critical complex components using PL/SQL, Oracle reports 10g, XML Publisher, Workflow, AME.
• Project Manager for upcoming implementation of Requisition Self Service module (RSS) to better able the P Design and configure Global HR and Self-Service module including foundation objects, approval workflow, personalization etc.
• Fine-tuning performance issues of SQR, Application Engine, Crystal Reports coordinating with Database administrator Involved in documenting the business process by identifying the requirements. worked as a Lead Consultant for various Oracle HRMS modules like Core HR, Compensation Administration, Profile Management, Security and Self Service etc.
• Project Manager for schedule and delivery of Employee Self-Service and Performance Management Systems.
• Responsible for implementing PeopleSoft platform Employee Self-Service module and Performance Management module enterprise-wide.

Confidential, Wilmington, DE

PeopleSoft FSCM Consultant

Responsibilities:

• Reviewed and corrected Order Management (OM), Inventory, Billing and Purchasing Configurations in PeopleSoft.
• Worked on BI publisher, SQR, PS Query reports for majority of Custom AP module and few of delivered PO, GL Fund-Balance reports.
• Designed and implemented Application Engine, Integration Broker and CI based solution for Taleo integration
• Purchase commodities and services for various County Departments according to County procurement policies, practices, procedures and regulations.
• Rectified major corrections to ERP systems and corrected them in SQL Procedures and Crystal Reports.
• Worked on automating the redundant work being performed for nearly 8 months by developing a new Application Engine.
• Developed and supported number of online and batch applications based on business needs using People Tools, PeopleCode, SQR, Application Designer, Application Engine, PS Query, and Tree Manager, CI, and Workflow.
• Component Interface, Application Engines, Application packages, Security Administration, PS Query.
• Built and Supported PS Query Reports, SQR, PS/NVision and BI Publisher Reports for Financial Reports.
• Worked on BI publisher, n-vision, PS Query reports for majority of Custom GL reports related to Consolidated Income Statement, Balance Sheet & trial balance.
• Worked on FSCM issue/tickets related to purchasing, Account Payable and General Ledger module. Field to Field mapping from Legacy Systems GP, MCF to Peoplesoft.
• Analyze all activity between AP/AR departments, and Key performance indicators, come up with suggestions to do activities better if need be (payment type incoming and outgoing, receipts - total dollars and counts, Invoicing - received and sent out, forms of payments and count by type, AR/AP associates activity/errors).
• Worked on Combo-edit rules issues such as retirement-combination edit error for valid combo when asset is retired.
• Development of XML publisher Reports, Oracle Alerts, for Oracle Receivables and General Ledger for interfaces and data conversion activities.
• Develop Business critical complex components using PL/SQL, XML Publisher reports, AME, OAF.
• Involved in the PeopleSoft AWE Implementation for GL Journal Approvals, Expense Report and Cash Advance Approvals.
• Participated in fit/gap analysis, detailed design, testing and other aspects of implementation of the PeopleSoft HRMS application at various client sites.
• Purchase commodities and services for various County Departments according to County procurement policies, practices, procedures and regulations.
• Designed and developed of PeopleSoft HRMS for HR, Payroll, Base Benefits, Benefits Admin, Time & Labor and Self-Service modules on client specific functionality.
• Created Various SQR Interfaces (Inbound & Outbound) and Reports to load data from external systems into PeopleSoft GL which in result conducts various Chatfield validations, Combo Rules, Trees, derive various values based on the data from the external system.
• Designed and developed conversion and audit programs to convert into PeopleSoft Grants, Contracts, Customers (Grant Sponsors), GL Journals, Purchase Orders, and Item Categories.
• Provided subject matter expertise guidance for PeopleSoft SCM (OM, Inventory) existing functional and technical usage and additional customization recommendations for various strategic project needs.
• Functional Analyst Supporting Accounts Payable, Travel & Expense, Procurement, Projects, Commitment Control.
• Created Research to billing custom interface during FSCM 9.2 upgrade and created Test Strategy for PeopleSoft 9.2 Upgrade.
• Performed design of reports for the HR, Time & Labor using SQR, PS/Query and Crystal Reports based on organizational needs.
• Picked up the SQL codes from SQR, then modified/tested the SQL codes through SQL Developer.
• Developed complex custom Time and Labor rules to calculate Late In, Excess Meal & short break, where the associates work in cross over shift and and consists multiple login and logout on same day.
• Performed design of reports for the HR, Time & Labor using SQR, PS/Query and Crystal Reports based on organizational needs.
• Write up SOPs (Standard Operating Procedures) for both AP and AR department.

Confidential, New Albany, Ohio

Peoplesoft FSCM Consultant

Responsibilities:

• Worked with Users, Application Owners, Managers, and team to draw up specifications and gather requirements for PeopleSoft FSCM (PO, Inventory, BI, GL, AP, AR) Assisted in streamlining the SCM process as per requirements and anticipated deliverables.
• Worked on FSCM issue/tickets related to purchasing, Account Payable and General Ledger module. Field to Field mapping from Legacy Systems GP, MCF to Peoplesoft.
• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll and Base Benefits modules.
• Monitored contracts and grants operational management for the client and acquired Expertise in testing PeopleSoft HRMS, FSCM and Security Administration.
• Consulted FSCM team on best practices to implement Security Re-design and User Provisioning project (FSCM 9.0), Served as lead PeopleSoft consultant for FSCM modules to assess the impact of COA changes
• Maintenance of Peoplesoft 9.0 system involving the following modules: eProcurement, Purchasing, Accounts Payable, Travel & Expenses, Customer Contracts, Billing, Receivables, Grants, Project Costing, General Ledger and Commitment Control.
• Monitored contracts and grants operational management for the client and acquired Expertise in testing PeopleSoft HRMS, FSCM and Security Administration.
• Support inbound HR/Payroll interface, security administration, production support.
• Designed and implemented HR GDW, ADP and Taleo interfaces for core HR, recruitment, Benefits and payroll.
• Designed and implemented Application Engine, Integration Broker and CI based inbound interfaces for Variable.
• Developed interfaces using SQR to create regulatory files to be sent to government agencies.
• Imports external pay files (time and labor management, commissions, etc.
• Proficient in customization of PeopleSoft objects including Page, Records, Application Engine, Component Interface and Menus to suite the client's requirements.
• AWE Implementation: Setup AWE Approval Workflow for GL Journal Approvals, Expense Report Approvals and Vendor Approvals.
• Support and maintenance of business processes of Financial Aid and Student Financials PeopleSoft modules in relation to ing, packaging, authorization and disbursement (i.e. FA student account to SF student account) and troubleshoot user problems to resolve operating difficulties.
• Designed and Developed Several Custom interfaces to AR, BI, PO, AM, Commitment Control, Inventory, AP and GL Modules.
• Verified active job appointments and percentages in PeopleSoft HR Management System (HRMS) as well as student financial account charges in PeopleSoft Campus Solutions.
• Develop enhancements and customizations for FSCM modules include AWE using People Tools Components, Pages, Records, Menus, Folders and Nodes according to technical specifications.
• Developed two nightly processes which include Application Engine and Component Interface to insert the HR Self Service transaction data into job component performing all the job component validations.
• Set up and maintained interfaces between PeopleSoft Benefits module and legacy benefit system.
• Customized the Student Financials module student's account along with account history with changes in fines.
• Customized the access to the Student Financials module limited primarily to the Student Financial Services staff and Customer Service Center Staff for tuition calculation and all fee adjustments.
• Developed data conversion reconciliation reporting with SQL scripts, BI (XML) Publisher reports, HCM Extracts on data conversion metrics.
• Worked with the end users to resolve issues with contract activation, initial grants billing and amount allocation for amount-based contract lines.
• Worked extensively with Debugging issues (SQR, App. Engine) and resolved many critical tickets related to Payroll module.
• Designed and developed Standard Printable Applicant's resume using PeopleCode and SQR.

Confidential

Business Analyst

Responsibilities:

• Designed and developed various UI configuration functionalities using appropriate Pages, Popups, Screens, Detail Views, List Views and Input Sets.
• Implemented the functionality for Auto Enrollment payment process from the external systems like credit cards and different banks.
• Designed, developed, and maintained complex stored procedures, user defined functions, triggers, views, indexes, CTEs, temporary tables and other SQL objects to meet business objectives.
• Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and scripts.
• Created SQL Server Drill down, Drill through, Adhoc, dashboard, Cross tab report using SSRS to fit business requirements.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Created User Defined Functions, views, stored procedures to encapsulate frequently and commonly used business logic making the system more modular, secured, and extensible.
• Created complex stored procedures, views, joins to populate shared and embedded datasets.
• Created interactive reports for upper management with functionalities like drilldown reports, drill through reports, parameterized reports, reports with multiple levels of cascading parameters.
• Created executive-level dashboards used by upper management to gauge regional and district level sales performance on a daily, monthly, quarterly, and annual basis by product and brand.
• Created database objects like tables, views, indexes, triggers and stored procedures based on the specifications as part of the development process.
• Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and scripts.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Implemented Error Handling in SSIS packages and notified process results to various users and business unit.
• Identified problem areas performed troubleshooting when execution errors occurred and Deployed reports to Report Manager.
• Evaluating information harvested through surveys and workshops, task analysis, and business.
• Defining and implementing the required business transformation rules and logic (ETL development).