SUMMARY:

• Over 12+ years of experience as a PeopleSoft FSCM Lead Techno - Functional consultant. Experience in Implementation, Customization, and Upgrade and Development of PeopleSoft Financials applications.
• Managed and led teams through all stages of the software development life cycle including defining the project scope, designing the application architecture, executing fit-gap analysis, designing, developing, testing major customizations to modules and training end users.
• Experience in implementation, upgrade, support, customization, writing interfaces and administration of PeopleSoft Financials/SCM (AP, AR, GL, Project Costing, Contracts, Billing, Purchasing, Vendors).
• Experience in PeopleSoft FSCM 8.1 through 9.2- Purchase Order (PO) and Procurement (ePro), Accounts Payable (AP), Accounts Receivables (AR), General Ledger (GL), Project Costing, Contracts & Billing (PCB)
• Possess extensive experience working in three full-cycles PeopleSoft Finance upgrade (PeopleSoft Finance 9.0 to 9.2, PeopleSoft FSCM 9.0 to 9.1 and PS Finance 8.9 to 9.1) engagements.
• Strong experienced on PeopleSoft HCM, HRMS and FSCM modules like HR (Human Resources), Benefits, North American Payroll, ELM, Global Payroll, Time & Labor, Compensation, and ePerformance, FMS, Order Management, BI, Inventory, Purchasing and GL modules.
• Technical expert in using Application Designer, SQR, People Code, Application Engine, Excel To CI, Integration Broker, Component Interface, Crystal Reports, nVision, Process Scheduler, PS Query, Process Monitor, Data Mover and File Layout.
• Strong technical expertise in module interfacing, data conversion, data migration, data archiving, reporting and writing/debugging PeopleCode.
• Involved in full upgrade of PeopleSoft HRMS versions 8.0 to 8.8, 9.0 to 9.2 using Upgrade Assistant/Change Assistant, Application Designer and Data Mover Scripts.
• Involved in design, development and testing of PeopleSoft modules General Ledger, Accounts Payable, Purchasing, eProcurement, and eSupplier, Strategic Sourcing, Asset Management, Account Receivables, Billing, Inventory and Order Management. 
• Experience in Oracle Database including Oracle PL/SQL, DB2, Oracle 10g, 11i, SQL.
• Developed Reports using SQR, Crystal report, XML Publisher, PS Query and OBIEE.
• Strong experience in PeopleSoft Payroll enhancements and full cycle Payroll testing, Talent Acquisition Manager, Performance Management and worked in FSCM and HCM upgrades from 9.0 to 9.1 and 9.1 to 9.2.
• Expertise in upgrading PeopleSoft from FSCM 8.9 to 9.2.Worked on several reports relating to FSCM modules AP, AR, PO, IN and GL relating to aging, vendors, matching, Stock Status and payments along with multiple projects and versions of PeopleSoft Financial modules moving to a single instance of PeopleSoft FSCM 9.1.
• Extensively developed report applications using BI Publisher, PS Query, SQR, Crystal Reports.
• Excellent functional knowledge and project experience in the areas of PeopleSoft FSCM Core modules AP, AR, BI, PO and GL.
• Profound knowledge on SQL and RDBMS concepts such as Normalizations, SQL optimization and tunings.

TECHNICAL SKILLS:

Programming Languages: PeopleCode, SQL / PLSQL, Java, HTML, XML, Visual Basic, C++, Java / VB Script, ASP, COBOL. 

ERP: PeopleSoft Financials (9.2/9.1 / 9.0/ 8.9 ) - AP / GL / AR / AM / PC/ CA/ OM/ BI/epro/ INV/ PO) 

People Tools: People Tools … People Code, Application Engine, Integration Broker, Component Interfaces, Excel to CI, Application Messaging, Security, DMS, Import Manager, Tree Manager, PS-Query, Process definitions and Report Manager . 

Reporting Tools: PS-Query, SQR, XML Reporting, BI Publisher, Crystal Reports, nVision, OBIEE. 

Database Technologies: Oracle … SQL Server 2000/7, Mysql, DB2 8, MS Access, TOAD, Golden, PL-SQL, Putty, PS Data Management tools, Data Mover, BORM model.

Operating Systems: Windows XP/2000/ 95/98, UNIX/LINUX.

ERP Modules: Core HR, Benefits, NA Payroll, Recruiting, Self-Services, Finance Accounts Payable, E-Procurement, Purchase Order, General Ledger, Cash Management, Deal Management, Banking, Commitment Control, Project Costing, Billing, Accounts Receivables.

Microsoft Tools: Visio, Projects, Access, Excel, Word, PowerPoint, Outlook, Publisher, Front Page.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Peoplesoft FSCM Techno Functional Consultant

Responsibilities:

• Interacted with the Business Users to understand the requirements and presented the Functional Specification Documents. 
• Worked in implementation team in creating a complete Vendor Payment tracking by contracts, vendors and subcontractors. The project involved financial modules of Accounts payable, Purchasing, General Ledger, eProcurement, Strategic sourcing 
• Supporting PeopleSoft modules Order Management, Inventory, Accounts Payables, Travel and Expense, EDI, Accounts Receivables, Billing, Purchase Order 
• Development, customization and configuration for PeopleSoft FSCM 9.0. Worked with Functional team to setup Inventory, Purchasing, eProcurement, Strategic Sourcing, Supplier Contract
• Integrated PL/SQL packages into BI Publisher reports and automated report generation process using pre/ post triggers for data processing
• Analyzed Integrated Peoplesoft FSCM application with PS HRMS application in order to pass employee information from Job Information to Expense Employee Profiles by Integration Broker using Workforce Sync Service operation.
• Co-ordinate with Business Users, Functional Users and Technical Team on day to day support and on new requirements. 
• Requirement gathering for new Lutheran Archiving project and building programs to build custom tab les to store legacy data for reporting purposes.
• Build Archiving programs for GL and AP module to integrate third party applications such as QuickBooks etc.
• Involved in customizations in PeopleSoft Project costing using PeopleCode, PeopleTools, Workflow, component interface to develop a unified system for all the different types of projects. 
• Implementation/Upgrade of PS 9.0/9.2 (AP, PO, eSupplier, eProcurement, TR, AM, PC and EX) 
• Worked on PeopleSoft Upgrade for FSCM as a technical consultant. 
• worked on upgrading PeopleSoft AP & GL from 9.1 to 9.2 which include Fit-Gap analysis
• Worked in Production Support Team to resolve SQR, People Code, Application Engine issues. 

Confidential, New York, NY

Peoplesoft FSCM Techno Functional Consultant

Responsibilities:

• Worked on PeopleSoft Project Costing, Asset Management, Inventory, eProcurement, Invoice, Billing, AR, AP, Purchasing, GL, Vendor management in FSCM modules 
• Worked on PeopleSoft Time & Labor, Absence Management HRMS modules.
• Worked on Integrations & EIP between T&L, Expenses, Service Procurement, GL, Project Costing. 
• Worked with Functional, Testing, PS Administrators, PeopleSoft security, Change management teams during complete software development lifecycle using Waterfall methodology for new production support, and Agile methodology during development & implementation of custom functionality. 
• Transformation of how processes are efficiently managed in a new 9.2 environment. Work involved taking this implementation through proof of concept and then guide client until it is fully implemented. 
• Worked on requirements, fit gap, design and configuration of PeopleSoft CM, GL, GM, AR, BI, AP, GM modules for countries such as UK, Canada 
• Major work includes fit-gap analysis, designing functional and technical specification documents for various financials modules such as CM, GM, AP, AR, BI, GL, AM 
• Developed new SQR programs to pull the Payroll related data from PeopleSoft HCM database to generate Flat files for determining the total Earnings, Deductions and Taxes for the employees. 
• Involved in the modification of pages/components and validating the data fields using People Code. 
• Extensively used PS Query to develop various queries based on User requirements. 
• Performance tuning of various SQRs in Payroll, HR and Benefits modules. 
• Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables, and send data from PeopleSoft to other interfaces. 
• Performed People Code and Component Interface troubleshooting in the HRMS, Payroll and Benefits modules. 
• Written several SQRs for updating employee level record on benefits, Payroll and also to accomplish periodic database updates and correct data errors. 

Confidential, New York, NY

Senior Peoplesoft Consultant

Responsibilities:

• Involved in designing and developing the interface programs to move data from legacy system to PeopleSoft tables using App. Messaging through Integration Broker.
• Worked with team and users to gather requirements, anticipated functionality deliverables and determine the specifications for implementation.
• Involves in Resolving day-to-day Production Tickets in PeopleSoft FSCM system. Configure Account Payable System (Pay cycle), Pay cycle processing eProcurement, AR deposit, Purchasing, EDI process and notifications for the PO. 
• Assist with impact analysis, decision making, workarounds, and designs related to the functionality being implemented in AP and eProcurement, Billing & Asset management module. Interfaces done from 3rd party system using integration broker. 
• Helped modify requisition, PO, voucher and receipt pages so that the asset information flows through correctly from the source systems to the asset management tables 
• Involved in developing Inbound Interfaces customizations in FSCMs 8.8 like OM, INV, GL, ePro, Billing, AP, AR, PO, RECV by using App. Messaging.
• Created and modified several new reports and queries.
• Solve the interface related issue - Debugging the SQR and Application Engine Program and Fix the error
• Involved in the development and customization of on line modifications.
• 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.
• Involved in defining Approval Rule Sets for Purchase Order Approval in PO.
• Used PS8 Features such as Buyer station for creating, editing or approving purchase orders and search criteria in eProcurement.
• Worked on SQR’s to create report for calculating a sales contract rebate for each customer ties to the contract, for creating Sales Order Acknowledgement report, to create Material Authorization, for displaying all Sales Orders with their order totals.
• Applied PeopleSoft fixes and patches to Order Management and Inventory.
• Customized RMA SQR Report to display RMA transactions for internal and external locations in Inventory module.
• Wrote an AE batch process to do the inter-unit transfer i.e. transfer of stock between two inventory business units on a daily basis in PeopleSoft Inventory.
• Supported the multiple testing tracks, prepared summary of test results as well as involved in troubleshooting issues uncovered.

Confidential, Boston, MA

Senior Peoplesoft Consultant/HRMS

Responsibilities:

• Extensively worked on PeopleSoft HRMS System Development, Conversion, Customization, Migration and Support of HR, Benefits, Benefits Administration, Payroll and Training modules.
• Involved in fit gap analysis for the current and future states.
• Setting up pages, Created views and summary pages according to the client requirement.
• Added new translate values, PeopleCode, Pages and Menus for HR, Payroll and Base benefits.
• Provided application technical support for implementation of new functionality, development of user requested modifications to the system, coordinating updates from PeopleSoft support, and user training. 
• Engaged in extensive fit/gap analysis and business process discovery. 
• Used App Designer to modify the existing records and created some new Records, Pages and Menus based on the functional specifications. Developed an SQR program to generate an electronic statement of monthly bank statements. 
• Designed application Engine program to get finance data into HRMS system for employee salary calculation. Customized the PeopleCode for semi manual reconciliation.
• Worked extensively on SQR in leave system; generated reports based on the functional specification. 
• Developed SQR reports for reconciliation data. Set up PeopleSoft out of the box cash management module for reconciliation of AP and AR data. In order to get GL data in the system created an application engine program to get GL data in to application table for reconciliation.
• Designed and developed Employee Stock purchase program which included various interfaces like Initial enrollment of employees, setting up payroll deduction after the purchase by quarterly and sending payroll deduction information to 3rd party vendor.
• Designed and developed several critical reports, extract programs and interfaces using SQR.
• Wrote Applications Engine Program, Tenure and Leave without Pay (AE process) and used Component Interface in application Engine PeopleCode for inserting new records in related table

Confidential

Peoplesoft Consultant

Responsibilities:

• Detailed legacy application conversion planning and data mapping to PeopleSoft Products/Applications. Designed customized Faculty management applications and an accreditation tracking and academic resume building process. 
• Designed detailed functional solution specifications for logically grouped requirements. 
• Technical duties included developing/implementing technical requirements using PeopleSoft Tools 8.48, these tools include Application Designer, PeopleCode, CI, Work Flow, SQL, SQR, Crystal reports, Interfaces (inbound and outbound) 
• Used Change Assistant to apply bundles and maintenance packs to the application. Created bolt-on tools and applications for reporting and data consolidation. Involved in documentation of test scripts and executing functional unit testing, system testing and data conversion validation testing. 
• Worked on several Application Engines, SQR's and PeopleCode changes based on the client's requirements. Wrote batch scripts using UNIX Scripting and created Control-M jobs. Created several reports using SQR and PS Query. 
• Developed interfaces using File layout and Application Engine program and converted the data from legacy system to PeopleSoft database, using flat files. Designed the Run control pages for running reports; these run control pages are added in report menu bar. 
• Analyzed the functionality delivered in the Bundles with the impacted objects, and created conclusion reports for the Keep or Drop of the customization decisions. 
• Dedicated ERP professional with hands-on experience right from design to maintenance phase of applications using PeopleSoft FSCM and developed workday report for new implementations and create calculated fields for Custom Reports to ensure required custom report. 
• Managed the internal reporting requests for various Peoplesoft Applications by developing and writing queries, architected and configured internet facing proxy and web servers for PeopleSoft apps. 
• Managed UNIX / Linux backend for PeopleSoft databases, file system and web servers and integrated secondary systems into PeopleSoft Financials and HR to further enhance operational efficiencies. 
• Provided operational analysis and created office-wide protocols for PeopleSoft and Financials business processes and defined test cases and coordinated end-to-end testing for the HCM, Advanced Comp, Talent, Time and Absence. 
• Provided Production support for PeopleSoft finance modules (Accounts Payable, Accounts Receivable, Cash Management, General Ledger and Billing), facilitated and collaborated conversion/data mapping. 
• Developed functional design specifications for Payroll, Time and Labor, Base Benefits, and Core Human Resources for 3rd party interfaces and provided system application and subject matter expertise in payroll, employee benefit entitlements, Time and Labor, and payroll interfaces.

Confidential

Peoplesoft HRMS Consultant

Responsibilities:

• Technical Implementation of PeopleSoft HRMS modules (Core HR, Payroll and Benefits).
• Interpreted Functional Documentation to Technical Documentation.
• Design and developed the applications with Application Designer, Application Engine, PeopleCode, Component Interface, PS/Query.
• Creating Portal registries for different menus and extensively worked on HR, PAYROLL Modules.
• Developed new Records, Online Pages, and Run Control Pages using People Tools for the specific needs of the company. Implemented PeopleCode for online validations and user interface.
• Developed complex SQR reports and SQC’s to suit the needs of the company. Used Process Scheduler to make SQR available from within PeopleSoft.
• Extensively used People Tools for creation or modification of Process Definitions, Records, Pages, and Menus to run Custom SQR’s through PeopleSoft environment.
• Tuned SQL/SQRs to improve performance using advance features like Load lookup and Arrays.
• Modified Time and Labor Pages according to user requirements.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.
• Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables, and send data from PeopleSoft to other interfaces.

Confidential

Peoplesoft HCM Developer

Responsibilities:

• Responsible for support of all HR related applications, including Compact Compensation Application, Success Factors, Work brain, and PeopleSoft HCM 9.0. Designed, developed, and supported processes to maintain data integration between PeopleSoft and all third-party systems, making use of security information from tree tables to ensure that system users can only view information of their own employees.
• Maintained PeopleSoft security using department tree, roles, permission lists and row level security.
• Team member on successful upgrade of PeopleSoft HRMS 8.3 to PeopleSoft HCM 9.0. Accomplishments include retrofit of customizations to accommodate 9.0 Architecture.
• a process to sync location changes between PeopleSoft and the facilities system.
• Developed and supported a custom MSS module.
• Performed fit/gap analysis for the following PeopleSoft modules: eProfile, eCompensation, eProfile Manager Desktop and eBenefits. Main focus of the analysis was related to Workflow requirements including roles, rules and routings.
• Provided training to HRIS business analysts on version 9.0 enhancements including person model, security setup, queries and workflow engine.
• Maintained and supported all reports and interface programs. Performing daily validation of all scheduled programs through Process Scheduler and Process Monitor.