Summary:

• Seven years of experience in Information Technology that included gathering requirements, analysis, design, development, and implementation of business applications systems in PeopleSoft and databases likeOracle, DB2 and SQL Server.
• Progressive Technical and Functional experience in customization, implementation, development, deployment, integration, data conversion, training, reporting and support of PeopleSoft 9.0/8.9/8.8/8.4/8.0Financials (General Ledger, Accounts Payables, Accounts Receivables, Billing, Asset Management) SCM (Inventory, Order Management, Purchasing, e-Procurement, Cost Management,) ESA (Projects, Contracts, Expenses and Treasury).
• Very good knowledge on PeopleSoft HRMS Modules like HR (Person Model), Base Benefits, Benefits Administration, Self Service and Payroll.
• Strong PeopleSoft technical skills include PeopleTools (Application Designer, PeopleCode, Application Engine, Component Interface, File Layout, Process Scheduler, Integration Broker, Workflow, Query, Data Mover, Security Administrator, and Definition Security), SQR, nVision, Crystal Reports.
• Extensively used QA tools such as Mercury Quality Center for creating Requirements, created Test Cases, developed Test scenarios and created Defects.
• Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production Support and Upgrade.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities PC Debugger, Application Engine trace for troubleshooting.
• Extensively worked with Security Administrator to implement security in various levels. Creating Roles, Permission Lists, User Profiles, Portal Security, folders, Content References and Definition Security.
• Strong presentation, documentation skills and developed various functional and technical specs with Test Plans and Procedures.
• Excellent troubleshooting and problem-solving skills.
• Detail-oriented, multi-tasker with strong organizational skills.

Technology Expertise:

ERP Package: FSCM 8.x/9.1, HRMS 8.x/9.0Development Tools:Application Designer, Application Engine, Component Interface, People Code, Application Classes, Pagelets, Archiving, Workflow, Integration Broker, Excel To CIAdministration Tools:Configuration Manager, Tree Manager, Process Scheduler, Process Monitor, Upgrade Assistant, Security Administrator, Data Mover, Portal, Lotus Notes, EWM toolReporting Tools:SQR, Crystal Reports, PS Query, PS/nVisionLanguages Known:C, C++, Java, PL SQLDatabase :Oracle 8.x/9.x,10g, DB2, MS SQL ServerOperating Systems:Windows 98/NT/2000, UNIX, DOS

Experience:

PeopleSoft Developer Jun 2010 – Present Client: Confidential,Mellon, NY PeopleSoft Financials Implementation 
Environment: Financials 9.1, PeopleTools 8.51, DB2, UNIX, CI, Integration Broker, SQR, PS Query, PeopleCode, STAT and Mercury Quality Center
Modules: GL, AP, AM, EX, Purchasing, ePro

• Developing, maintaining and supporting PeopleSoft Financials modules.
• Involved in setting up the business units, banks, ledgers, pay cycles, vendors etc.
• Actively involved with the team for designing, implementing and testing business processes
• Analyzed end-user’s requirements for bridging the gap between delivered functionality and the requirements.
• Interacted with the client and technical team for development of interfaces for specific data from systems.
• Documented and designed functional and technical specifications for interfaces, reports and data conversions.
• Performed Functional Testing of the enhancements, interfaces and conversions developed and ensured zero-defects by closely working with technical development teams (both local and remote) and coordinating periodic review meetings with development team leads.
• Participated in reworking and redefining the Functional Specifications for the customizations to suit the changed needs of the client.
• Involved in setting up of Chartfield’s, Accounting Entry templates and Banks in GL and AP modules
• Customized the delivered Positive Payment creation process (Crystal Check) to generate file to be sent to bank.
• Worked on the setup part of the pay cycle to process the ACH/EFT payments.
• Developed custom workflow to accommodate the approval process in GL Journal accounting entries upload.
• Developed complete Expenses process including Workflow and lot of customizations.
• Experience with the STAT change control package.
• Setup Voucher Posting and Payment Posting processes.
• Performed Functional Unit Testing and System Testing the AP, GL, TE modules to assure the required edits and control using Mercury Quality Center for tracking and resolution of defects.
• Gathering requirements for problem tickets resolve issue and queries and propose solutions for production and system problems, implementing solutions, coordinate production moves.

• Participated actively and conducted Fit / Gap Analysis Sessions for capturing Business Process requirements accurately.
• Worked on various PeopleSoft Financials customizations for Kelly IRL, UK, US and Canada. Also involved in Business design documents and co-ordinate those with Technical design documents.
• Documented and designed the functional and technical specifications for interfaces, reports, data conversion and validation.
• Involved in setting up of Integration Broker to load Employee data from HCM to FIN applications.
• Developed Conversions and Interface programs to load bulk of data from third party systems into PeopleSoft using Integration Broker.
• Involved in setting up of Interunit and Intraunit Accounting and ChartField Inheritance for the Payments made using the Payment Predictor Application Engine process (ARPREDCT).
• Worked with the end users and gathered information for designing the specifications for Customer setup, Business Unit setup, Entry Type/Reason, Lockbox files, Payment Predictor in Receivables.
• Done customizations to Billing and GL reports as per the client’s changed business requirements.
• Setting up of Receivables which sends accounting entries to General Ledger through the Journal Generator Application Engine process.
• Set up General Ledger business unit and configured PeopleSoft ledger tables for consolidation and report generation at the corporate level.
• Responsible for integration of AR with Billing and GL.
• Involved in Customization of Manual Cash application, Billing Invoice printing process etc.
• Worked on Dunning process in AR and did customization for CA_BI_NTFC between Contracts and BI.
• Involved in entering invoices and credit memos in Billing and interface them to Receivables.
• Developed GL Interface that loads data from various external systems into PeopleSoft General Ledger using Application Engine, which includes implementing complex business rules like Combo Rules, subtotals on Business Unit level, grand totals, printing multiple output reports and processed file report.
• Responsible for reconciliation of data between General Ledger and Sub Ledgers. Created banks functionally and involved in Bank Reconciliation process. Created process on object migration to production as result of support ticket resolution. Involved in Data Mapping meeting sessions.
• Involved in designing a custom SQR to load bank information into the PeopleSoft AR/AP system.
• Involved in upgrading Tools and applying bundles using Change Assistant.
• Gathering requirements for problem tickets resolve issue and queries and propose solutions for production and system problems, implementing solutions, coordinate production moves.

PeopleSoft Consultant / Upgrade Jan 2007 – Sep 2008 Client: Confidential, AZ 
Environment: PeopleSoft Versions 8.8/8.0, PeopleSoft Financials and SCM, PeopleTools 8.x, PS Query, SQR, Application Messaging, Integration Broker, PeopleCode, CI, Crystal Reports and PL/SQL, SQL Server 2005
Modules: GL, AP, AR, BI, PO & INV

• Involved in the upgrade of PeopleSoft versions from 8.0 to 8.9. Worked on evaluation of customizations, project plan, Technical/Functional Fit-Gap Analysis. Developed and Tuned scripts for data conversion using SQL/SQR, Application Engine and Data Mover.
• Configured Upgrade assistant and ran the upgrade steps using PeopleSoft certified way to upgrade from 8.0 to 8.8, also applied the Bundles and Fixes from PeopleSoft Customer Connection to the PeopleSoft 8.8 module
• Analyzed and aided in taking decisions to retain customizations based on upgrade compare reports.
• Upgraded components/pages and application engine programs like Billing Interface and Payment Predictor and other SQR programs in Billing and Receivables from PeopleSoft Rel 8.0 to 8.9
• Customized Bill Entry pages for pages as per the requirement and incorporated required functionality.
• Customizing crystal reports on AR Invoices by billing location, Open Invoices and Credit memos by billing point, open invoices and Open items, AR Balances by State and Country and Customer Activity.
• Creating a report for the Account Receivable on pending items that runs and gives report periodically, that gives the list of all Pending Items, and Pending Payments.
• Involved in setting up of AR to Billing modules.
• Developed Application Engine program to Change the Inventory Items from a Staged Date Controlled item to a non-staged Date controlled item.
• Developed an Interface with 3rd Party Order management system and PeopleSoft using Application messaging to perform Fulfillment processing in PS against their Orders.
• Developed an Application Engine program in purchasing, which loads receipts data for multiple Business Units from flat file via Component Interface.
• Various data validations are performed using Application Engine PeopleCode.
• Customized PO Dispatch/Print to change headings and print in duplex mode for Company Terms & Conditions.
• Customized PeopleSoft delivered Crystal reports in Payables like Vendor Detail, Vendor Summary, APY1010 – Voucher Register, APY1010A - Posted Voucher Register, APY1040 - Open Voucher Report and APY2015.
• Involved in debugging Application Engine programs and PeopleCode using PeopleCode Debugger.
• Interacted with client, Functional and Technical resources to ensure business needs are achieved. Provided detailed test plans and technical documentations.
• Identifying the Change requests and the development needs along with the customer and implement the same successfully.

PeopleSoft Consultant Aug 2005 – Dec 2006 Client: Confidential, IL Environment: People Tools 8.45, PeopleSoft FSCM 8.8, Component Interface, PeopleCode, SQR, Oracle 8i and Windows 2000.
Modules: Purchasing, AP, Billing, AR, GL, Projects, Contracts

• Involved in preparing technical specifications as well as Functional specifications.
• Developing Application Engine programs, component interfaces, SQR’s based on given data flow diagrams, conversion logics and business rules.
• Developed and tested detailed functional designs for business solution components and prototypes.
• Extensively worked with Application Designer to create the new record definitions, Views, new pages and adding the pages to components, used PS query in developing queries and worked on security access issues.
• Used Excel to CI workbook to pass data from flat files to chartfields records by applying state Business rules.
• Developed the Application Engine program for Unreserved Fund Balances to select fund balances for all the funds that had an activity in given fiscal year with the distinction between Governmental and Proprietary funds.
• Defined SetId and Record Groups for control data.
• Worked with chartfield conversions, chartfield validation, combination edit checks in General Ledger.
• Developed and modified queries for reporting using PS/Query.
• Developed an interface to create Journal and Adjustment vouchers and load Voucher Correction Data from various Agencies using Component Interface, Application Engine and File Layouts.
• Developed Application Engine Programs to load customer data, Voucher data, and Asset data from client’s legacy systeminto PeopleSoft System.
• Developed an outbound interface to send Projects data from PeopleSoft to various agencies using Application Engine and File Layouts.
• Involved in creating new vouchers and posting or creating new pay cycles.
• Customized delivered Voucher Page to include Vendor Invoice Date & Receipt date.
• Involved in Integration and System Testing for all the interfaces developed.
• Created File Layouts, Component Interfaces and App Engine Programs for Data conversion.
• Preparing Unit Test Planning.
• Preparing Object Migration Request to migrate the development objects across the instances.