SUMMARY

• I am a PeopleSoft techno/functional consultant with over 8+ years of IT experience.
• I have been part of implementing PeopleSoft Financials & Supply chain modules for different clients which includes Full - Life Cycle (SDLC) implementation, Upgrades to 9.X, Production Support and have extensive Functional and Technical Experience in implementation of PeopleSoft Financial & Supply Chain Modules like Project Costing, Contracts, Billing & AR, Purchasing, AP, Inventory, Treasury, Grants, KK, Order Management, Travel & Expense and GL modules (Version 9.2, 9.1, 9.0, 8.9, 8.8, 8.4, 8.1, 7.5).
• Techno-functional Proficient in FIT-GAP Analysis, Design, Development, Customization, Upgrade and Maintenance of PeopleSoft Applications.
• Expertise in PeopleSoft technical development, upgrade, interfacing, conversion, data migration / mapping, security administration, tech Support and Report writing using App Engine with XML Publisher, SQR, Crystal and other PeopleTools.
• Proficient in the use of: Application Designer, Application Engine, Component Interface, SQR, People Code, Workflow, AWE, Cobol, Data Mover, Import Manager, Security Administrator, PS/Query/Crystal Reports, XML publisher, n Vision.
• Good functional Understanding and working experience in Accounts Payable, Purchasing, Accounts Receivable, Billing, General Ledger, Cash Management, Treasury, Projects, and e-Procurement, Benefits, Benefit Administration, Payroll, Payroll Interface, Time and Labor.
• Expertise in applying patches, bundles and maintenance packs to the PeopleSoft systems.
• Developed multiple PeopleSoft FSCM &HRMS interfaces - both outbound and inbound - with third party systems using SQR, Application Engine, Component Interfaces, Integration Broker and File Layout.
• Extensively worked with PeopleSoft reporting tools like SQR Reports, Crystal Reports, PS/nVision, PS Query and Tree Manager, App engine with XML Publisher.
• Excelled in the areas of PeopleSoft Internet Architecture (PIA) and Open Integration Technology tools like Component Interface, Integration Broker for interacting with in and outside PeopleSoft.
• Good experience on working with Share point tool.
• Proficient in the usage of Quest STAT 5.3.1, a change management and version control tool.
• Possess good knowledge in RDBMS, Web/Client-Server applications and security.
• Served as the key point of contact/Liaison between on and offshore resources.
• Excellent oral/written communication and presentation skills and a good team player.

TECHNICAL SKILLS

Application: PeopleSoft Financials v8.0-9.2(AR, AP, GL,AM, GL,Billing,Treasury, PO, Project Costing, Contracts, ePro, Grants, KK, T&E and Inventory)HRMS - 9.2/9.1/9.0 - NA Payroll, Core HR, T&L, Benefits, Benefit Admin

Development Tools: Application Designer, People Code, Application Engine, Process Scheduler,SQR,Cobol, Data mover Component Interfaces, Application Messaging, Integration Broker.

Reporting Tools: PS Query, PS/nVision, SQR, Crystal Reports, Xml Publisher, OBIEE

Administration Tools: Security Administrator, Object Security and PeopleTools Utilities, Data mover

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

Languages: SQL, PL/SQL, SQR, COBOL, Java, .NET, HTML, JDK, C, C++.

Databases: Oracle 9i, MS SQL Server.

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

PeopleSoft Functional consultant

Responsibilities:

• Working as a techno functional consultant for the support and enhancement of PeopleSoft Financial Applications.
• Used OBIEE to develop several Business Intelligence reports on the Data Warehouse
• Designed, Configured and developed Integration Broker (xml messages) to load data from third party systems (Ops Technology) to AR/BILLING modules. Which includes creating setup, develop message people code and also testing, documentation of web services technology.
• Worked on AWE(Approval workflow engine) to setup workflow for approving expense, vouchers.
• Designed and developed interfaces for Accounts Payable using Integration Broker messages, And also Application engine/file layout for file based integration.
• Integrated, Designed, Developed interface programs for Travel& Expense module with Accounts Payable for payments of employee expense reports.
• Extensive experience in developing and customizing reports using PeopleSoft Query, SQR, Crystal Reports and nVision
• Designed and developed custom XML Publisher reports for AP, AR/BILLING, PURCHASING, EXPENSE and GL modules.
• Resolved expense workflow issues for HR supervisor, Prepay auditor approvers.
• Designed and developed XMLP reports for AP, EXPENSE, GL modules.
• Configured and developed programs for reconciliation of payments with Banking and AP module.
• Resolved Asset Transfer issues for Asset Management between different Business Units.
• Involved in day to day production support for all the financial modules like AR/BI, AP, EXPENSE, GL.
• Trained business users for the custom processes in AP,AR/BILLING,EXPENSE module.
• Involved in impact analysis, design and testing of the Application Engine, SQR reports, SQR Interface, Pages.
• Study of Functional design and Documents provided by Client and prepared the Technical design specifications.
• Set up Workgroups, TRC’s, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed Custom Time & Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time & Labor.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Developed Queries to modify reported hours. Queries are using by Task Group employees as they are allowed to report over time.

Environment: PeopleSoft FIN/SCM 9.1, OBIEE, STAT, PT 8.52, Windows NT, UNIX and Oracle.

Confidential, Folsom, CA

PeopleSoft Techno/Functional consultant

Responsibilities:

• Worked as a techno functional consultant for the integration of PeopleSoft Financial Applications with clients Invoicing systems
• Designed functional and technical documents for the seamless integration of AR/BILLING/GL/TRAVEL & EXPENSE with invoicing application system.
• AWE Implementation: Setup AWE Approval Workflow for GL Journal Approvals, Expense Report Approvals and Vendor Approvals
• Configured the AWE (Approval Workflow Engine) for Expense Reports and Cash Advances
• Customized the GL Journal Entry Approval AWE Setup and Added new User List Application Package Criteria
• Developed several UNIX Shell Scripts for SFTP and Emailing from Batch Jobs
• Developed Programs to run from Unix Shell commands for Control M Scheduling Agent
• Participated actively in Fit / Gap analysis sessions. Analyzed existing business processes.
• Set up new Payables Business Units. Defined Table Set sharing, SetId and Record Groups.
• Configured AP matching rules, established AP accounts, distribution codes and set-up payment terms.
• Designed and tested GL Interface.
• Defined and setup SET IDs. Defined GL Business units and setup GL security with Permissions Lists, User Roles and Profiles.
• Designed and developed complex SQR programs for report writing and integrating data with third party systems.
• Performed AP-GL reconciliation and created queries to check flag status to assist in future.
• Designed, configured and tested ACH and check payments with Bank of America.
• Created test scripts for Journal Entry, Journal Upload and Journal Processing.
• Created and executed Test Scripts for unit testing in GL for testing ‘Journal Entry’, ‘Open a Period’, ‘Close a Period’, etc functionality.
• Established Pay Cycles and troubleshot pay-cycle exceptions.
• Built complex custom inbound and outbound Application Engine interfaces to support custom transmission of financial data to warehouse distribution as well as confirmation of invoicing.
• Configured Accounts Payable to utilize Payment Matching and generation of annual 1099s.
• Designed test plans for AP Vendor related functionality like, Vendor Definition, One-time Vendor Definition, 1099 Vendor Definition, Inactive Vendor and Vendor Maintenance.
• Designed and configured vendor categories and withholding codes (1099).
• Resolved day to day production issues on AR/BILLING/GL modules.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Analyzed the Customizations to the delivered SQR reports and worked with the functional analyst to determine if the Customizations need to be reapplied or retired.
• Modified custom built SQR interfaces, conversion, and report programs to in corporate new fields and changes that were introduced in new release.
• Worked on custom Disability batch process which calculates the number of pay hours of the Employees who are on disability in the current pay period.
• Online development/customizations of pages, queries and also online validation using PeopleCode.
• Supported PeopleSoft Payroll by debugging user and system errors in Payroll processes which includes SQR, Component Interface and Application Engine Processes.
• Involved in design and implementation of standard heading SQC’s customized to suit client requirements for all the payroll-related reports.

Environment: PeopleSoft Fin 9.1, People Tools 8.52, Windows NT, UNIX, Quest STAT, and Oracle

Confidential, San Jose, CA

Senior PeopleSoft Techno/Functional consultant

Responsibilities:

• Perform Fit-GAP Analysis of New Features in 9.2, Compare report Analysis, Customization that can be removed due to delivered features in 9.2
• Responsible for the Upgrade of PeopleSoft 9.0 to 9.2 Tools 8.55
• Developed technical specifications based on the Functional requirement document
• Configured the AWE (Approval Workflow Engine) for Expense Reports and Cash Advances
• Customized the GL Journal Entry Approval AWE Setup and Added new User List Application Package Criteria
• Customized various online pages according to the user needs
• Tuned various application engine programs like Billing Interface Program, Billing Preload, AR Update, Payment Predictor, Voucher Build and Post processes for optimum performance.
• Designed and developed a program that loads assets from a comma delimited file into asset interface tables.
• Developed several BI Publisher Reports and made use of Bursting to Send Emails of PDF Reports by Department ID
• Resolved Crystal to BI Publisher Conversion of AP Check Printing Process in 9.2
• Established Pay Cycles and troubleshot pay-cycle exceptions
• Worked on the Implementation of Pivot Grids, Connected Query Reports and Work Centers in new 9.2
• Participated as a one of the technical Member for the PeopleSoft FSCM 9.0 to 9.2 upgrade project
• Technically I was also heavily involved in the re-application of Clients customizations to the new 9.2 application. This included custom approval work flows, re-writing client custom SQRs in BI Publishers, Queries, Application engine programs, Application Packages and Page/Component changes.
• Compared new enhancements with current customizations, performed code merged, tested.
• Revised technical documentation for the Upgrade
• Assisted functional teams with development of test plans and scripts, and respond to all technical issues and queries that arise during the integration testing..

Environment: PeopleSoft Fin 9.2, People Tools 8.55, Windows NT, UNIX, Quest STAT, and Oracle.

Confidential Dallas, TX

Senior PeopleSoft Techno/Functional consultant

Responsibilities:

• Perform Fit-GAP Analysis of New Features in 9.2, Compare report Analysis, Customization that can be removed due to delivered features in 9.2
• Responsible for the Upgrade of PeopleSoft 9.1 to 9.2 Tools 8.53
• Developed technical specifications based on the Functional requirement document
• Customized various online pages according to the user needs
• Designed additional tables to hold billing data received in PeopleSoft from the 2 additional source systems and enhanced the Staging Process (SQR program) and Billing Interface (BIIF0001) accordingly.
• Receiving notification customization - Created an application engine program which notifies users if a Purchase Order has not been received for 4,8,12, or 16 day’s after the due date.
• Tuned various application engine programs like Billing Interface Program, Billing Preload, AR Update, Payment Predictor, Voucher Build and Post processes for optimum performance.
• Designed and developed a program that loads assets from a comma delimited file into asset interface tables.
• Developed several BI Publisher Reports and made use of Bursting to Send Emails of PDF Reports by Department ID
• Resolved Crystal to BI Publisher Conversion of AP Check Printing Process in 9.2
• Worked on the Implementation of Pivot Grids, Connected Query Reports and Work Centers in new 9.2
• Participated as a one of the technical Member for the PeopleSoft FSCM 9.0 to 9.2 upgrade project
• Technically I was also heavily involved in the re-application of Clients customizations to the new 9.2 application. This included custom approval work flows, re-writing client custom SQRs in BI Publishers, Queries, Application engine programs, Application Packages and Page/Component changes.
• Compared new enhancements with current customizations, performed code merged, tested.
• Revised technical documentation for the Upgrade
• Assisted functional teams with development of test plans and scripts, and respond to all technical issues and queries that arise during the integration testing..

Environment: PeopleSoft Fin 9.1, People Tools 8.52, Windows NT, UNIX, Quest STAT, and Oracle.

Confidential, Houston, TX

PeopleSoft Techno/Functional consultant

Responsibilities:

• Worked as a techno functional consultant for the support and enhancement of PeopleSoft Financial Applications.
• Used OBIEE to develop several Business Intelligence reports on the Data Warehouse
• Designed, Configured and developed Integration Broker (xml messages) to load data from third party systems (Ops Technology) to AR/BILLING modules. Which includes creating setup, develop message people code and also testing, documentation of web services technology.
• Worked on AWE(Approval workflow engine) to setup workflow for approving expense, vouchers.
• Designed and developed interfaces for Accounts Payable using Integration Broker messages, And also Application engine/file layout for file based integration.
• Integrated, Designed, Developed interface programs for Travel& Expense module with Accounts Payable for payments of employee expense reports.
• Extensive experience in developing and customizing reports using PeopleSoft Query, SQR, Crystal Reports and nVision
• Designed and developed custom XML Publisher reports for AP, AR/BILLING, PURCHASING, EXPENSE and GL modules.
• Resolved expense workflow issues for HR supervisor, Prepay auditor approvers.
• Designed and developed XMLP reports for AP, EXPENSE, GL modules.
• Configured and developed programs for reconciliation of payments with Banking and AP module.
• Resolved Asset Transfer issues for Asset Management between different Business Units.
• Involved in day to day production support for all the financial modules like AR/BI, AP, EXPENSE, GL.
• Trained business users for the custom processes in AP,AR/BILLING,EXPENSE module.
• Involved in impact analysis, design and testing of the Application Engine, SQR reports, SQR Interface, Pages.
• Study of Functional design and Documents provided by Client and prepared the Technical design specifications.
• Set up Workgroups, TRC’s, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed Custom Time & Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time & Labor.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Developed Queries to modify reported hours. Queries are using by Task Group employees as they are allowed to report over time.

Environment: PeopleSoft FIN/SCM 9.0, OBIEE, STAT, PT 8.50, Windows NT, UNIX and Oracle.

Confidential

PeopleSoft techno/functional consultant

Responsibilities:

• Handling Business Process Workflows for the PeopleSoft Financials & HR modules (AR, BI, GL, AP, AM, PO, Contracts, PC, Travel and Expense, NA Payroll, Core HR, Benefits, T&L) in a technical capacity.
• Extensively working on Integrating PeopleSoft Financial modules with HRMS & Third party applications using Integration Broker, Component Interface, and Financial Gateway & Application Engine.
• Integration Broker Full Sync Messages: Developed Integration broker Messages to Sync Vendors between Finance and HR. Used Chunking of Messages so that Large Volume of Vendors can be sent based on Max Message size between the 2 systems
• Designed and developed interfaces for Accounts Receivable, BILLING to sync data from third party systems using Integration Broker(xml messages).
• Designed and developed Application engine with Component interface to upload the contract rate data.
• Designed and configured to route vouchers from Accounts payable clerks to voucher coders using Approval workflow engine.
• Developed several SFTP Unix Scripts from Windows/NT to UNIX and also Mail-X Commands for the process to send out Emails on UNIX Servers
• Developed nVision reports for multi-currency reporting that were being created manually. Created query and crystal reports used in an initiative for better Cash flow reporting.
• Designed and development xml publisher reports for BILLING/Purchasing modules.
• Designed and developed interface between General Ledger and Congo’s reporting system using SQR to have the ledger balances.
• Extensively worked Application Engine, Component Interface to load the external data into PeopleSoft modules.
• Supported the testing group to resolve the issues and trained business users in processing the customized applications.
• Designed and developed interfaces for AP modules to load the voucher data from third party systems.

Environment: PeopleSoft Financials 9.1, People Tools 8.51, Windows NT, UNIX and Oracle.

Confidential

PeopleSoft techno/functional consultant

Responsibilities:

• Handling Business Process Workflows for the PeopleSoft Financials & HR modules (AR, BI, GL, AP, AM, PO, Contracts, PC, Travel and Expense, NA Payroll, Core HR, Benefits, T&L) in a technical capacity.
• Involved in Day-to-day interactions with the Users on the Project Costing, Accounts Receivable, BILLING and Travel & Expenses Development requirements and Change requests.
• Involved in writing functional and technical specifications for ARBI 199 a new custom process to secure customer bank account information.
• Extensively working on Integrating PeopleSoft Financial modules with HRMS & Third party applications using Integration Broker, Component Interface, and Financial Gateway & Application Engine.
• TCD Interface: Developed Application package Handler Peoplecode on the Inbound service Operations to Collect Timesheet Information and load into Time and Labor using Integration Broker
• Built custom Additional Pay and General Deduction Process to read from Custom Retiree Payroll interface for their elected Benefit Programs and prepare the data for payroll processing.
• Developed control reports, validation/reconciliation reports and custom reports, also wrote the SQL scripts for the data cleanup and re-sequencing.
• 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.
• Involved in converting data from Legacy system to PeopleSoft using Application Messaging, Component Interface and Application Engine.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People Code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Reapplied the customizations to SQR reports in the new release.
• Retrofit the customizations and also involved in running the scripts and upgradation reports.
• Involved in Unit, Integration, System and User Acceptance Testing.

Environment: PeopleSoft Financials/HRMS 9.0, People Tools 8.50, Window NT, UNIX and Oracle.