SUMMARY

• Professional experience of 7 years in development and support of PeopleSoft 8.x/9.x Financial and Supply Chain Management module: Purchasing, e - Procurement, Account Payables, General Ledger, Asset Management, Billing, Accounts Receivables, Order Management, Inventory.
• Have experience on PeopleSoft Development Tools likeApplication Designer, Process Scheduler, Workflow, AWE, Component Interface, People Tools, People Code, SQR, Application Engine, and PS Query File Layout, Permission lists, Roles.
• Worked on the Code PeopleSoft Financials Modules like Requisitions, PO, AP, AM, BI, AR, Expanses, GLs.
• Used Application Engine to perform background processing against the data.
• Created new reports using SQR, XML Publisher and modified the existing ones as per the changes specified
• Created and customized SQR reports as per the requirements and scheduled them using Process Scheduler
• Experienced in preparing test documents such as Test Cases, Logs and Defect Reports, Requirement Design, Functional Design and Technical Design Documents.
• Experienced in Business Requirements gathering, Fit-GAP analysis and writing Functional and Technical Specifications.
• Involved in Unit Testing and Systems Integration Testing during up gradation of PeopleSoft.
• Strong analytical skills to convert Functional design specifications into Technical Design specifications.
• Ability to work well in a team based and have excellent communication and interpersonal skills.

TECHNICAL SKILLS

ERP: PeopleSoft Financials (Account Receivables, Account payables, General Ledger) and Supply Chain Management (Order Management, Inventory, Purchasing, P2P, O2C), Sourcing, eProcurement, Asset management, Billing 9.1/9.2, 8.8

People Tools: Application Designer, Application Engine, Workflow, Component Interface, Integration Broker, People Code, AWE, Query, Process Scheduler, Data Mover, Security, File Layout, Application Messaging, Excel To CI.

Scheduling Tools: Process Scheduler, Control M, Tivoli, Zena

Languages: People Code, SQL, PL/SQL, Unix Shell Scripting, ASP 3.0, VB 6.0, HTML, VBScript, JavaScript, UNIX, Java, C/C++

RDBMS: SQL Server 7.0, 2000, Oracle 11g, 10g, 9i, 8i, 7.3

Administration Tools: Portal Administration, Object Security, Workflow, AWE and Query Security.

Reporting Tools: SQR, Crystal Reports 8.x, PS Query, nVision, XML publisher, BI Publisher, QlikView, Tableau, Business Objects

Operating Systems: Windows NT 4.0/XP/ 2000/2003/98/95 , Red Hat Linux, AIX 6.1, Sun Solaris 5, HP Unix

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Senior Techno Functional Consultant

Responsibilities:

• Created nVision Balance Sheet reports for new Business Units. Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing Business Units.
• Worked on requirements from users and designing the Functional documents.
• Provided functional assistance to users in case of any difficulties for transaction processing.
• Designed the dup checking functionality in AP module.
• Designed the reconciliation process from start to end in AP module.
• Supported UAT for the development done by the off-shore team.
• Designed the nVision report from scratch in General Ledger (GL) module for one of the GL month end processes.
• Resolved issues in Voucher Posting and Payment Posting (App Engine Processes).
• Designed the department and operating unit Excel to Component Interface’s (CI) in Asset management (AM) Module.
• Designed a custom interface which will accept files from other systems and create Journals into the PeopleSoft GL system.
• Assisted in Fit and Gap Analysis, business requirement gathering, configuring the system, demo, test plans, resource allocation and issue allocation.

Confidential, New York, NY

Senior Techno Functional Consultant

Responsibilities:

• Gathered requirements from users and designing the Functional documents.
• Coordinated with legacy system consultants to comprehend the data volumes in AP, AR, GL modules and decide cut-off date for data migration.
• Performed record field mapping for delivered records.
• Worked extensively on issues related to Asset Management module.
• Customized various pages to include features for customer at Voucher level.
• Configured core tables for integration of AM module with other modules.
• Developed a fresh CI for users to run SQL for correction of wrongly entered data.
• Worked extensively on writing PS Queries for enabling various functionalities to the system.
• Worked on several development requirements like SQR report development and Page customization in AM module.
• Performed Asset maintenance - Asset Adjustments, Re-categorizations and Transfers. Retired and reinstated assets.
• Provided functional assistance to users in case of any difficulties for them to process transactions.
• Supported production team in resolving critical issues after development.
• Configured and monitored various operations in the system for better user experience.

Confidential, Buffalo, NY

Techno Functional Consultant

Responsibilities:

• Worked in retrofitting application packages of expenses and purchasing for workflows.
• Analyzing and modifying 9.0 customizations in procurement modules and payables and asset management and billing, account receivable retrofitted objects to ensure 9.0 customizations work on 9.2 also.
• Developed Integrations to and from Peoplesoft HCM to Peoplesoft CRM.
• Retrofitting various SQR, Crystal and XML reports on various modules.
• Prepared code review and unit test documents and test logs.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Prepared detailed functional specification document and user training manuals.
• Working with the team members to enable them to know the tables involved in order to help them while formulating the queries.
• Involved in documentation of Unit and Integration Test Plans.
• Modification of SQR Reports as per user requests.
• Worked in Production Support and handling tickets for all the financial modules.
• Prepared code review and unit test documents and test logs.
• Business requirement gathering and analysis, mapping business requirements, application configurations, solution interfaces/customization.
• Worked on the modification of Expenses for employee’s pages.
• Worked on the Workflow changes in the Expenses and Travel authorizations.
• Created Excel to CI to Expenses data upload.

Confidential, MN

Technical Consultant

Responsibilities:

• Worked on the complete Procure to pay process as a part of production support.
• CustomizedeProWorkflow Requisition Amount Approval Activity according to the business requirement.
• Analysing and modifing 9.0 customizations in procurment modules and payables and asset management and billing, account receivable retrofitted objects to ensure 9.0 customizations work on 9.2 also
• Customized the PeopleSofteProCreate Requisitionpage to develop interfacing between ePro and third party systems.
• CreatedApproval Process Definitionfor ePro requisitions: 3 stages: Fiscal approval, Board Review and Sourcing. Fiscal stage had 2 steps. Both 'Approval User Lists' were based on SQL definitions.
• AutomatedPODispatchrun control page by creating a default set of run controls for each user, with appropriate parameters preset. A nightly batch job will be created as part of this work unit, which will reset those run controls back to the default settings. Any outstanding process requests for the user run control will be cancelled at this time. The processes that are getting affected are Requisition Print,POPrint,PODispatch, and Receiving Delivery Report.
• Configured and tested the PO RECVLOAD process for loading the receipts from EDX files.
• Configured and tested the PO CHNGLOAD change load process for loadingPOchanges from EDX files.
• DevelopedPurchasing InterfaceusingFile Layout, Application Engine,andComponent Interface, which loads data from flat file into staging tables while doing various data validations usingAE PeopleCodeand finally loads into PeopleSoft tables throughComponent Interface.
• Customized the application Engine programAP PSTPYMNT.BC050to populate the APPL JRNL ID for the journal Generator to create journal lines.
• Troubleshoot the Problems inVoucher Posting and Payment Posting.
• As a part of the AP outbound interface developed thecustom SQR & SQCprograms for creating the EFT files for Bank Giro & Post Giro banking systems.
• Interacted with Business users and collected business requirements and prepared functional and technical specification documents.
• Customized various SQR's and Crystal Reports and troubleshoot Application Engine Programs, Pages and PeopleCode.
• Developed/Analyzed Business Requirements and provided estimates for every production ticket.
• Trained Client on Implementation of Pagelets in the HCM portal pack.
• Good knowledgeable interaction with the end users in gathering their concerns and issued with the postproduction and providing solutions to resolve them.
• Involved in PeopleSoft application security design in Accounts Payable, Purchasing Custom applications.

Confidential - Salt Lake City, UT

Technical Consultant

Responsibilities:

• Effectively involved in requirement gathering.
• Developed various reports in PS Query, SQR in various modules like Expense, Travel, Account Payables and Billing and GL.
• Designed and developed interfaces in Application Engine using File-Layouts based on the specifications.
• Prepared of test cases and testing the code.
• Reviewed and tested codes prepared by peers.
• Developed new reports and customized standard reports as per the client’s requirement.
• Application Designer: Created Pages, Components and Menus for Web Client.
• People Code: Written extensive People Code for validations and used all the events available in People Code.
• Workflow: Developed new workflows to generate work lists and send email to managers.
• Designed interfaces in SQR based on the specifications.
• Developed Conversion programs using App Engine, File layout and Component Interface to load data from the Legacy system to People Soft tables.

Confidential

Jr. Technical Consultant - Finance

Responsibilities:

• Design and Development of Item Definition and Assign Purchasing Attributes. If system gave any error while saving Purchasing attribute Component interface and Item definition component Interface save should Rollback.
• Involved in Creation/Development and Customization of Tables, Views, Pages, Components and Menus using Application Designer.
• Developed several Queries for the Financial Reporting Purpose in AP, PO & GL.
• Involved in some Setup, like User Preferences & Banking Information.
• Worked on EXCEL to Component Interface for the Vendor Upload Process.
• Involved in the design of Audit functionality to create various records and effectively implemented.
• Created various New SQR Reports and modified the existing SQRs as per the client requirement
• Development, Documentation, Design & Unit Testing of Application Engine Programs for FSCM as a part of Enhancements
• Developed different custom reports using SQR to meet user specifications.
• Involved in the performance tuning of SQR and SQL.