SUMMARY:

• Senior PeopleSoft Certified (PeopleTools 8 Application Developer Certified Expert) consultant with over 9 years of experience and can attend F2F Interviews.
• Expertise and Participated in all stages of Application Development including Business Requirements Gathering, Analysis, Development, Customizations, Production Support, Interfacing/Reporting, Testing, Implementation, Conversion, Upgrade of PeopleSoft FSCM applications.
• Strong expertise with PeopleSoft Technical Skills which include Peoplecode, Application Engine, Component Interface, File Layout, Data Mover, Process Scheduler, PS Query, SQR, Security Administrator, Trees, Application Packages, Integration Broker Service Operations (REST & SOAP web services), AWE, Dashboards & Fluid pages.
• Worked on the latest toolset PeopleTools 8.55. Worked on retrofitting of objects in various upgrade projects.
• Expertise in modifying the existing and creation of AWE configuration (along with necessary code) along with moving the AWE setup to higher environments using Data Mover scripts.
• Extensive knowledge and experience developing and customizing of complex PeopleSoft Reports and Interfaces like SQR, PS Query, XML/BI Publisher, Crystal Reports, n/Vision.
• Expertise in Data Conversions both outbound and inbound with Third party systems using SQR, Application Engine, Component Interface, File Layout, and Excel to CI.
• Developing and Supporting PeopleSoft HRMS application from past four years.
• Having good knowledge on PIA. Good Technical and Functional knowledge on HRMS & FSCM Modules.
• Worked on full length Life - Cycle implementation, Conversion, Upgrade, and Support of PeopleSoft modules.
• Excellent troubleshooting and problem-solving skills. Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities like Peoplecode Debugger, Application Engine Trace for troubleshooting.
• Strong presentation, documentation skills and developed various technical specs with Test Plans and Procedures.
• Excellent analytical, communication skills and adapt to new technologies with ability to work as an individual or part of a team.
• Used STAT and PHIRE to migrate projects.
• Performed End-Users Training, UAT Testing Mentoring and Knowledge Transfer sessions. Acted as a liaison between Client and the Offshore team (Hexaware) in my recent project with NT Bank.
• Expert in waterfall & Agile Software Development process.

TECHNICAL SKILLS:

ERP Solutions: PeopleSoft FSCM and HRMS 9.2, 9.1 and 9.0; Tools Release 8.54, 8.53,8.52,8.51, 8.50 and 8.49.

Financials: Purchase Order, Accounts Payable, eProcurement, Billing, Accounts Receivable, General Ledger, Asset Management.

HRMS: Core HR, NA Payroll, Base Benefits, Ben Administration, Absence Management.

People Tools: Peoplecode, Application Engine, Component Interface, File Layout, Data Mover, Process Scheduler, PS Query, SQR, Security Administrator, Trees, Application Packages, Application Class, Integration Broker Service Operations (REST & SOAP web services), AWE, Dashboards, Fluid pages.

Reports: SQR, PS Query, XML/BI Publisher, Crystal Reports, n/Vision.

Databases: Oracle SQL Developer and SQL Server.

Languages: PeopleCode, Java, HTML, CSS, JavaScript, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior PeopleSoft Consultant

Responsibilities:

• Worked on Development of custom AWE Security Automation App Engine process in FSCM for Purchase Request and ePro roles where the roles/catalog access need to be added/removed depending on the data from HR tables along with Nightly updates.
• Created DMS scripts to Import/ Export AWE setup tables data for the above automation project.
• Provided technical and functional support for PeopleSoft FSCM Full Upgrade Project. For the upgrade efforts, identified and performed code compares, design, build, test, Retrofit custom PeopleCode, Application Engine code where appropriate.
• Participated in test moves to Production passes, as well as overall integration testing of the upgrade process.
• Performed End to End Testing for the seamless integration of Accounts Receivable/Billing/ General Ledger Modules.
• Identified the impacted SQR's and SQC's and retrofitted complex custom SQR's and SQC's in preparation for upgrade to 9.2 based on 9.1 customizations.
• Worked on converting around 40 Crystal reports to BI publisher reports.
• Developed custom Interfaces for Third party systems (Sciquest now called Jaggaer, ARCHER 3PRM) with PeopleSoft by creating custom Application Engine Process.
• Developed PeopleCode to create dynamic grids to populate General Ledger information.
• Designed a custom interface which will accept files from other systems and create Journals into the PeopleSoft General Ledger system.
• Worked on modifying transformation engine for cXML based punch out and Purchase Order dispatch integration with online catalog and ordering solution (Sciquest). Also, did a proof of concept on Purchase Order Acknowledgement (POA).
• Worked on several interfaces to import the journal data from external systems into General Ledger.
• Worked on custom Load Purchase Order and Receipts from Legacy Order management system using Integration broker, Application Engine, and Component Interface. Made modifications on voucher association and costing part of the Three-way match process.
• Configured and customized Invoice as Email attachment functionality in Billing.
• Developed PS queries to match receiving with contract and Purchase order. Worked on enhancements and Workflow activities in modules Billing and eProcurement.
• Supported in troubleshooting of processes like Payment Selection and Creation, Voucher Posting

  (AP PSTVCHR) and Payment Posting (AP PSTPYMNT) in AP.

• Worked on the payment loader (AR PAYLOAD) and lockbox (AR25001) SQR process.
• Proposed a solution to Administrator in making changes on Application server which was blocking access to a site to fetch DTD for xml schema validation for punch out.
• Worked on Customized PeopleCode for Core HR, Time and Labor and NA Payroll modules for different requirements as demanded.
• Customized the Benefit enrollment letter for terminated employees.
• Identified & written custom scripts to enable users to specify which ABBR to use for a Benefit Plan. (Multiple Annual Base Benefit Rates).
• Developed an Application Engine Program which fetches data from PS EMPLOYEES table based on pay group criteria and send email.
• Resolved issues regarding Leave Accrual and customized the Time Reporting page.
• Worked on Development of AWE Escalations/Delegations in HRMS for Absence Management where the Absence Management request needed to be Escalated/Delegated to higher authority till it reaches Bureau of Directors.

Confidential, Harrisburg, PA

Senior PeopleSoft Consultant

Responsibilities:

• Worked on custom Application Engine designed to import Billing information from a flat file and load it into billing staging tables.
• Created BI Publisher Reports in General Ledger Module using PS Query, XML as Data Source.
• Customized the Billing interface process, Invoice Pre-process and finalize process and Invoice printing process.
• Modified (AR DUNNING) Application Engine in Receivables, to create report of all accounts for which the customers are past due and send them to Collection Processing.
• Designed an interface program to load pending items from a third-party billing legacy system in to PeopleSoft Receivables pending tables.
• Engaged in daily Accounts Receivable maintenance which included, but was not limited to, application of previously unidentified cash receipts, write-offs, invoice reversals, processing refunds to Primes and to the US Government and application of invoices to each other.
• Worked on AP module and Customized the Journal Entry page, People Code in GL to store certain custom information. Customized the Ledger Inquiry and Journal Inquiry pages.
• Developed Payment Interfaces to load bank recon data into PeopleSoft Payables from bank transaction files.
• Designed app engine programs to read duplicate assets from asset table and mapping table and create new asset ids. These new assets were inserted into the mapping table along with their business units.
• Implemented PeopleCode to dynamically change prompt table for account on journal line, based on commitment control amount type selections. This involved use of component level PeopleCode, passing row set objects from component level to field change PeopleCode.
• Created custom application engine process that automatically initiates the "submit Journal" process for journals with external system sources. This program allows the journals to be sent into workflow without any manual intervention from users making it more streamlined and user friendly.
• Modified Journal Edit application engine process to avoid anchor concept. Added new AE Sections/Steps/Actions to implement Fund Balancing concept while generating offsets as a part of Journal Edit Process.
• Provided support in solving Problems related to Voucher Posting and Payment Posting (App Engine Processes), AP matching process, GL, Purchasing modules.
• Troubleshoot billing interface program by adding intermediate commits to billing interface to avoid table locking and improve performance.
• Customized PeopleSoft delivered BI Publisher reports in Payables like Vendor Detail, Vendor Summary, Closed Voucher, APY1010 - Voucher Register, APY1010A - Posted Voucher Register, APY1040 - Open Voucher Report, APY2015 - Check Register.
• Customized the BIIF001 App Engine to avoid populating the fields ACTIVITY ID and BUSINESS UNIT PC in the BI HDR table as per the Functional user requirements.
• Modified the outbound Interface program which sends AP Payments data to external system. Developed AR Open Item Conversion process to load into AR tables PS GROUP CONTROL, PS PENDING ITEM.
• Designed and developed Voucher and General Ledger integration broker interfaces using service operations, app messages, app packages and PeopleCode.
• Implement Integration Broker setup which involved in enabling Publish and Subscribe services between cross platform PeopleSoft applications.
• Developed various Outbound and Inbound Interfaces for transmitting employee Data to Benefits vendors and process the receiving data to insert into various PeopleSoft Tables
• Modified different Paycheck Templates and tested all XMLP reports
• Developed several Ad-hoc reports using PS Query for department salaries, salary plans, and deduction, participants in Benefit Programs, salary change Report, salary Mass Updates.
• Worked on customizing the Benefits module by customizing the savings plans such as 403(b), 457.
• Used integration broker to integrate data from HRMS to FSCM for travel reimbursement through AP.

Confidential, Dallas, TX

Senior PeopleSoft Consultant

Responsibilities:

• Worked on upgrading PeopleSoft Financials Upgrade from 9.1 to 9.2.
• Worked with SYSAUDIT and DDDAUDIT reports in analyzing the data redundancy and identifying the inconsistencies and orphaned objects.
• Designed and developed custom General Ledger functionality to accommodate the need for approval Process for the University to be in compliant with the state and Federal regulations.
• Worked on SciQuest integration to PeopleSoft Projects. Wrote AE, CI to create a Purchase Order from a requisition.
• Developed PeopleCode to create dynamic grids to populate Ledger information relating to budgets, encumbrances and actual from Finance, HRMS and Student Admin modules.
• Work involved supporting the day-to-day operations of users in Purchasing and eProcurement modules.
• Configured Punch-out and PO Dispatch Nodes in eProcurement.
• Developed a new online inquiry page to view Open commitment on the Purchase order by comparing the data related to the Requisition and Receipts.
• Developed Static and Dynamic AWE workflow paths depending on the requirement.
• Involved in writing SQR, which moves data from ESI system to PO tables like PO HDR, PO LINE and PO LINE SHIP etc.
• Modified the Sales Order Report OMS1000 (SQR) to include the detailed information of the customer.
• Created custom email messages to notify employees about their expense report status.
• Fixed the AR UPDATE process which did not insert values into PENDING ITEM when an item is created via a payment worksheet.
• Created the Technical designs for Invoice extract process changes, new invoice layout designs for SFS, Contracts to Billing Interface changes, and Expense Employee Data update changes to the delivered Application Engine program, Accounts Receivable Update changes.
• Designed Outbound Process to schedule master files extracts daily. The agencies use these master file extracts to sync-up their systems with SFS.
• Involved in the PO - AP matching issues in PeopleSoft allowing the system to match the Purchase Order, Receipts and Vouchers - as the converted data was manually matched in legacy system. For this, I developed an interface inbound/outbound Application Engine process to make sure the data in PeopleSoft AP table are consistent with the ones in the third-party system.
• Worked as a payroll production support analyst. UTD processes payroll for about 13000 employees every pay period.
• Worked on Conversion project where I developed custom Application Engine programs and CI to load data from ADP Payroll to PeopleSoft system.
• Developed and ran PeopleSoft queries to generate daily, weekly, bi-weekly, and monthly payroll reports.
• Developed an App Engine program that sends Forecasted Payable time hours to Payroll and e-mail the hours to the manager.
• Worked on Outbound interface related to ACA and developed a App engine program to send the file to deloitte.
• Data keying in job data component for both regular hourly and salaried employees to impact payroll processing.
• Creating Portal registries for different menus and extensively worked on HR, PAYROLL Modules.
• Implemented the exception logic for payroll exceptions by modifying application engines according to the business requirements.
• Worked on Absence management module by building pages from scratch according to the business requirements.
• Worked on customizing Employee self-service(ESS) and manager self-service modules(MSS).

Confidential, Miami, FL

Senior PeopleSoft Consultant

Responsibilities:

• Worked involved customizing external bidder for eProcurement. It also involves customizing external facing procurement so that only limited PeopleSoft application is exposed to them.
• Implemented integration between PeopleSoft Financials 9.2 and its interfaces using Application messaging Webservices/SOA and IBM WebSphere is considered as an intermediary system for all the transactions between them.
• Coordinated and assisted Users during UAT testing for Asset Management customizations. Provided product assistance/training to end user and assisted users in performing UAT.
• Executed and prepared test scripts for Integration Broker (xml messages) to load data from third party systems to Accounts Receivables/BILLING modules.
• Wrote AE programs as part of data conversion process using CI to load data from Third party systems to PeopleSoft General Ledger Module.
• Customized eProcurement Purchase Orders and other reporting templates to modify company formats using PeopleSoft XML Publisher from crystal reports.
• Performed verifications and code walkthrough in team deliverables in eProcurement, Accounts Payable, and General Ledger.
• Worked on enhancements and Workflow activities in modules Billing and eProcurement.
• Worked on order management, Billing, Accounts Receivables& Inventory including order to cash (OTC).
• Introducing XML publishing and BI for the first time in the company.
• Designed/developed matching controls, matching rules and troubleshot matching process. Work involved modifying PeopleSoft supplied match rules as well as developing quite few new rules.
• Responsibility includes design and developing Stored Procedures, performance tuning. Development of complicated sql for PeopleSoft application engine and SQR.
• Loading data from external source to PeopleSoft using application engine and SQR.
• Design/Developed Hyperion feed for PeopleSoft chart fields and Ledger using store procedure and SQR.
• Worked on Archiving PeopleSoft Data.
• Designed complex custom payroll process for redistribution of payroll data on per day basis. Developed a custom run control page to populate run control ids for several payroll processes so that they can be run from a single page in a job stream.
• Checking stats update of invoices in PeopleSoft and providing reports to AP (Accounts Payable) management
• Perform Accounts Payable and general accounting activities using the JAMIS accounting system and PeopleSoft procurement system.
• Involved in testing User Training for Creating and Assigning Billing plans, Creating Orders and assign Orders for a Contract/Project under Billing, Order Management and Contracts modules.
• Worked on supporting year end processing such as W2 generations and Comp leave payouts.
• Modified and implemented custom SQRs to print the monthly/weekly payroll summary statements for employees.
• Involved in Day-to-day interactions with the Users on the Project Costing, Accounts Receivable, BILLING and Travel & Expenses business requirements and test cases.
• Supported Payroll (Payroll Administration - Pay Sheet, PayCalc and Pay Confirm Processes) and worked on issues related to payroll.
• Worked on delivered eProcurement AWE workflow and helped with design and development of custom workflow.
• Worked on plan mapping process related to Aetna and UHC.
• Worked on Application Engine programs to figure the issues and add the dependents to the enrollment summary page.
• Modified PeopleCode by displaying the Managers name and Emplid for all the delegate Job Change Request, Approve and Status pages.

Confidential, Tallahassee, FL

Senior PeopleSoft Consultant

Responsibilities:

• Extensive production troubleshooting and tuning duties. Recent examples include creation of Requisition was taking 3-4 minutes and reduced it to 5 seconds by tuning some views and making changes on Application server which was blocking access to a site to fetch DTD for xml schema validation for punch out.
• Worked on delivered eProcurement AWE workflow and helped with design and development of custom Voucher workflow.
• Extensively worked on Travel and Expense module by making enhancement to the pages and processes as per the requirements.
• Worked on modifying transformation engine for cXML based punch out and Purchase Order dispatch integration with online catalog and ordering solution (SciQuest). Also did a proof of concept on Purchase Order Acknowledgement (POA).
• Involved with Request for Proposal (RFE) process when choosing a new Imaging solution.
• Worked in several modules eProcurement, Travel and Expense, Asset Management, General Ledger, Commitment Control, and Inventory management.
• Worked on several interfaces to import the journal data from external systems into GL.
• Worked on exposing the journal data to external systems using web service.
• Developed Invoice Pro Forma PDF's using XLMP to be imported in imaging system.
• Involved with banking related file encryption and FTP.
• Helped with any technical issues related Fiscal year end closing.
• Experience with job scheduling software called UC4 formerly known as AppWorx.
• Developed GL interface that loads data from various external systems into PeopleSoft General Ledger tables JRNL HEADER, JRNL LN using SQR, which includes implementing complex business rules like combo rules, Error Handling Procedures, Maintenance, and Input File Information.
• Modified the Purchase Order POPO005.SQR to eliminate the Line totals, include Bill to address, sales tax, eliminate Freight and Misc. charges etc.
• Modified the Requisition PORQ010.SQR as per the requirements.
• Design and developed Requisition status page which displays all the requisition details as well as its corresponding PO details and receiving details.
• Developed Various Custom reports according to client requirements using SQR, Crystal Reports for General Ledger and Accounts Payable modules.
• Worked on design and development of a complex custom encumbrance process for the client. This process is run every pay period and calculates the encumbrances for all the current/future employees for the remaining pay periods. This process calculates the earnings, taxes and deduction encumbrances.
• Was responsible for maintaining and troubleshooting the commitment accounting processes such as PSPPFUND, PAYGL03, PAYGL02, PYAP XDEDN, PSPY TAXN, and PYAP VCHPOST
• Made complex changes to Paygl02.sqr to populate a custom table for one-point stop payroll reporting needs.
• Thorough understanding of end to end processing between Payroll, AP and GL using delivered interfaces.
• Worked on enhancements in eRecruit such making changes to the job application process by injecting additional pages as per the requirements
• Worked in ePerformance modules to help setup templates and build employee evaluation PDF's using a XMLP batch process.

Confidential

Senior Associate PeopleSoft Developer

Responsibilities:

• Involved in the PeopleSoft Implementation Project for FSCM modules. Worked on Conversion project where I developed custom Application Engine programs and CI to load data from Microsoft Great Plains to PeopleSoft system.
• Involved in Development of GL Interface sqr, which reads flat file containing journals and loads into PS JRNL HEADER, PS JRNL LN and custom table NP JRNL TRAILER. The file is opened for reading with open command when header row is loaded it checks for header edit rules and valid header data is inserted into Jrnl Header if line data is loaded.
• 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.
• Modified the Packing Slip - INS6500.SQR not to print the Packing slips that were already printed and added additional functionality of reprint.
• Modified the Picking Plan INS6000.SQR to print the Orders in the sort of Business Unit, Demand Source, Source Business Unit, Order Number, Item ID, Storage Area, Storage levels.
• Enhanced the core requisition workflow, which includes the approval/ deny requisition activity and the chart field/amount approval rule set to meet the requirements of the E&P business segment.
• Did the analysis of existing customizations, conversion, interfaces, and report programs and identified the changes that needed to be made and documented the impact from technical perspective.
• Developed two stage requisition workflows, Project approval and immediate Supervisor approval based on requisition approval limits to meet the requirement of PIPE business segment using virtual approver.
• Experienced in the design of the Workflow, which was primarily used to develop Work lists, Events and Routings for various business needs.
• Carried a major customization (Attachments) in AP, GL and AR which allows the users to attach (add, replace, delete) any softcopies related to transaction. Extended the dev work and used the same in other modules like T&E.
• Provided Production support for existing Finance modules like Accounts Receivables, Billing, and Purchase Order etc.,
• Worked on analyzing multiple BI related delivered and customized SQRs to adopt the same logic in later designed reports.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Expertise in PeopleSoft Security, creating permission lists and roles, assigning them to users.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins and sub-queries.
• Conducted training on SQL. Helping other team’s PS-HCM with the complex technical issues as and when needed.
• Worked on loading data into Billing module using EXCEL to CI. Worked on several interfaces to load data from the legacy systems into PS PO module using component interface and application engines.

Confidential

Associate PeopleSoft Developer

Responsibilities:

• Got trained for 6 months from Industry experts where I got a chance to come to know the power of ERP package solutions.
• Involved in Creation/Development and Customization of Records, Pages, Components and Menus, Application Engine processes and File Layouts using Application Designer.
• Read to records and writing to the files by using the File Layout and App Engine process.
• Coordinated with users during User Acceptance Testing.
• Acquired knowledge on EXCEL to CI.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Involved in enabling and updating Security Definitions for Pages, Components, and Menus to restrict users to the Database tables holding sensitive data.
• Got a chance to learn Functional flow for PeopleSoft Purchase Order, Accounts Payable, eProcurement, Billing, Accounts Receivable modules.
• Developed and Modified PeopleCode for various validations as required by our business process.
• Configured and customized the PO Amount Approval workflow which requires 2 chains of approval based on PO coming from approved and non-approved requests.
• Performed debugging Analysis and provided online help to customers.
• Resolved customer issues related PeopleCode, SQR, Query, crystal Reports and Process Scheduler.
• Design and developed the applications with Application Designer, Application Engine, PeopleCode, Component Interface, PS/Query.
• Ran Compare Reports and identified the objects that had to be reapplied.
• Custom wrote an Application Engine and generated a flat file pulling out FSIs for a physical year in GL.
• Worked with DDDAUDIT and SYSAUDIT reports in analyzing the Orphaned data redundancy and identifying the inconsistencies and orphaned objects.
• Customized the OMBILL SQR process as per the business requirements.
• Developed an Application engine to interface Asset management and General Ledger Module.
• Used Process Scheduler for creating SQR reports for General Ledger reports.
• Developed search capability on location based on certain criteria.