PROFESSIONAL SUMMARY:

• Over Nineteen years of experience in the IT industry and Fourteen years of Experience in US as a PeopleSoft Senior Functional Consultant in Confidential 9.2, GL/AP/AR, Asset Management, Inventory and Project Costing.
• PeopleSoft Functional Consultant with strong experience in different phases of PeopleSoft development life cycle including Fit/Gap Analysis, Implementation Design and End user .
• Thorough understanding of various PeopleSoft activities including
• Fit/Gap Analysis
• Customization Analysis
• Data Conversion Analysis
• Configuration
• Customizations
• Patches / Bundles / Maintenance Packs
• Upgrades
• New Functionality Implementation
• Reporting
• Integration with 3rd party systems
• Data Reconciliation between various modules as well as 3rd party systems
• Security Analysis, SOX Compliance and Security Administration
• Three Full Life Cycle Implementation experience in Confidential 9.2, GL/AP/AR, Asset Management, Project Costing, STAT Migration Tool, Object Security, Purchasing, CRM 8.8 (Sales, Support, Order Capture, Helpdesk), SCM 8.8(Procure to Pay, Plan to Produce and Order to Cash.), PeopleSoft Inventory, Order Management, and Billing.

COMPUTER SKILLS:

Languages: JAVA, SQR, SQL/PL SQL

Databases: Oracle (7.2/9i/10.2), Sybase/UDB, MS SQL ServerMS Access

ERP Tools: PeopleSoft (6.0, 7.0/7.5, 8.1.6/8.42/8.8/8.9/9.0/9.1/9.2 )

PeopleTools: 6.0, 7.0/7.5, 8.1.6/8.45/8.49/8.52 SQRPeopleCode, XML Publisher, Application Engine, Crystal Reports, Ps/n Vision, Ps/Query, Informatica, STAT Migration tool 5.3.2

RDBMS Tools: PL/SQL. SQL PLUS

Operating Systems: SUN SOLARIS, HP - UNIX, Windows 2000Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, Minnesota, MN

Functional Consultant

Environment: Confidential 9.2, People Tools 8.53, AR, Budgets, Expenses, AP, Billing, GL, STAT Migration Tool 5.6.4, Oracle 10.2, Windows 8.1.

Responsibilities:

• Involved in the PeopleSoft Upgrade from 8.9 to 9.2 and Worked on Different Retrofits from Staging Database to the new 9.2 Development Database.
• Worked on PeopleSoft Retrofits like UM Allocation Target, UM Allocation Target Upload, UM RRC Allocation Target, UM RRC Allocation Target Upload, UM RRC Allocation Target Summary, UM RRC Status and Approval, UM Detailed Budget, UM Budget Development Worksheet Setup, UM Budget Development Worksheet, UM Budget Development Worksheet RRC, UM Budget Office Approval and also Worked on PeopleSoft Expenses Retrofits like UM Reset Authorization Budget Check Status, Expense Reporting Module which involved creation of Queries.
• Created CSRs for all the Retrofits in PeopleSoft Budgets and Expenses and using STAT Migration Tool migrated them to FSTST from FSDEV.
• Used Application Engine for Several Reports using XML Publisher by creating Schema and XML file, Report Definition Template and XML Publisher for Printing the Reports.

Confidential, Troy, MI

Functional Consultant

Environment: Confidential 9.1, People Tools 8.52, AP/AR, Billing, Financial Bundles #11 to #20, Feature Pack #2, Maintenance Pack 8, Application Engine, Oracle 10.2, Windows 7.

Responsibilities:

• Involved in the Production Support and Implementation of PeopleSoft Financial Bundles #11 to #20 in Accounts Payables, Billing and AR Modules and Involved in Creation and Testing of Test Cases/Scripts for Different Customers of Kelly Services Like John Deere, Air Products and Kraft right from Loading the VMS File and doing the Data Mapping and responsible for Testing all the Phases of Projects to Billing, KOVMSIC - VMS Invoice Connector (BI0013B, BI0016, BI0017 and KOPB0143), PB0143 - Project and Activity Creation - OCG CWO, BI0016 - Contract-Contract Line Creation - OCG CWO, BI0018 - Online Error Message Page - OCG CWO, Invoice Processing which includes Direct Pay and Taxes (BIIF001), BI0014 - Load Billable-Payable into Projects - OCG CWO, PC T 01 Load Transactions (PC INTFEDIT), PB0035C - OCG-Update Project Accounting Data, PB0144 - VMS Staging to Projects Balancing Report-OCG CWO, BI D 03 Apply VAT Defaults (BIPVAT00), BI0040 - Apply VAT Defaults, Run Finalize and Print Invoices (BIJOB01), Billing Pre Load Process (BI0039), BI5011-KO BILL1 OCG - Billing, BI5012-KO BILL2 - Post Billing Process, AP0042 Projects to Payables Interface, OCG CWO (Contingent Workforce Outsourcing), AP0044 - Automation of Pay when Paid OCG CWO, AP0043C Paper Check Form CWO CAN, Testing of Positive Pay File, Running Pay Cycle, Selection and Creation of File for Positive Payment, Format Positive Payment, Running Voucher Build Process and Posting Payments, Running AR Update Process, GL Reconciliation Process.
• Used Application Engine for Several Reports using XML Publisher by creating Schema and XML file, Report Definition Template and XML Publisher for Printing the Reports.

Confidential

Functional Consultant

Environment: Confidential (9.1) People Tools 8.5, Confidential, Commitment Control, Application Engine, Oracle 10.2, Windows XP

Responsibilities:

• Involved in the Production Support of PeopleSoft Confidential in Creation of Test Cases/Scripts in PeopleSoft Confidential as a member of Confidential at Confidential .
• Involved in Resolving some of the Remedy Tickets which involve like password reset and Account unlocked issues while logging into EGL environment which happen very frequently at Confidential .
• Involved in Updating the Status of Remedy Tickets in the Confidential on a day to day basis and provided the status of all open tickets as of that particular date.
• Involved in Creation of Security Test Cases/Scripts in Confidential .
• Used Application Engine for Several Reports using XML Publisher by creating Schema and XML file, Report Definition Template and XML Publisher for Printing the Reports.

Confidential, Bloomington, IL

Functional Consultant

Environment: Confidential (8.8/9.1) People Tools 8.5, Confidential, Asset Management, Project Costing, Application Engine, Oracle 10.2, Windows XP

Responsibilities:

• Analyzed and presented the new functionalities of Confidential and Asset Management Modules to users.
• Reviewed existing customization and new functionality with business users to determine what customizations can be replaced by new functionality (or) eliminated due to lack of use.
• Worked in the Upgrade process from PeopleSoft 8.8 to 9.1 and was responsible for Creation of Test Cases/Scripts of many Custom and Delivered Objects considered for upgrade process to 9.1.
• Involved in Creation of Security Test Cases/Scripts in Asset Management and Confidential .
• Involved in Creation of Requirements Rules Inventory Spreadsheet for GL and also matched the Test Case number populated for each CTT(Customized Tracking Tool) with the requirement associated in the Requirements Inventory.
• Reviewed the Functionality of Custom Objects developed in 8.8 and was responsible for deciding which functionalities could be moved to PeopleSoft 9.1 which were beneficial for State Farm in both Confidential and Asset Management modules.
• Ran the Queries using Query Tool to fetch the data in different Asset Management Tables and compared the Results in different environments like FSDBM, FSDEM, FSDBF. FSDBB.
• Used Application Engine for Several Reports using XML Publisher by creating Schema and XML file, Report Definition Template and XML Publisher for Printing the Reports.

Confidential, Sacramento,CA

Functional Consultant

Environment: Confidential (8.8/9.0) People Tools 8.49, Accounts Receivables, Confidential, Payments, STAT Migration Tool, Application Engine, XML Publisher, SQL Script, Oracle 10.2, Windows XP

Responsibilities:

• Analyzed and presented the new functionalities of Confidential, Accounts Receivables, and Asset Management Modules to users.
• Reviewed existing customization and new functionality with business users to determine what customizations can be replaced by new functionality (or) eliminated due to lack of use.
• Involved in the Functional Design Phase WA092 and the Technical Design Phase WA093 to leverage the CalPERS (California Pension System Employee Resumption System) existing PeopleSoft System and provide integration with the PSR (Pension System Resumption) System. Functional Design Documents (FDDs) detail the new CalPERS requirements gathered and documented in Deliverable WA091 - FSIP (Financial System Integration Protocol) General System Requirements Specifications (GSRS). The objective of Deliverable WA093 - Technical Design phase is to provide system flows, program specifications and database specifications that are required to construct the PeopleSoft Financial System. Any component that must be created, configured or modified is documented during this phase. Technical Design Documents do not require actual program code or pseudo code specifications. Middleware Design Documents (MDDs) are also included during this phase of the project.
• Involved in Creation of the documents which covers the to-be-Process including the creation of Receivables in the PeopleSoft Financial System. This includes Receivables that have a payment plan attached in the PSR System and those Receivables without a payment plan in the PSR System.
• Involved in gathering the new CalPERS requirements and documented in Deliverable WA091 - FSIP (Financial System Integration Protocol) General System Requirements Specifications (GSRS).
• Involved in Creation of TDDs and MDDs which are organized by Functional Area (Payments, Receivables, Dunning, GL, Reconciliation, etc…). Collectively, these artifacts create Deliverable WA093 - FSIP Technical Design Document (TDD). The audience for this Deliverable includes the Subject Matter Experts (SMEs) from the Financial System Functional and Technical Support Teams.

Confidential, Dearborn, MI

Functional Consultant

Environment: Confidential (8.9) People Tools 8.45, Confidential, Asset Management, Project Costing, GL, HP-UNIX, COBOL, Application Engine, XML Publisher, SQL Script, Oracle 9.1, Windows XP

Responsibilities:

• Analyzed and presented the new functionalities of Confidential, Asset Management and Project Costing Modules to users.
• Reviewed existing customization and new functionality with business users to determine what customizations can be replaced by new functionality (or) eliminated due to lack of use.
• Involved in the implementation and support for PeopleSoft Confidential, AP, and Tested Multi-Currency G/L processing (Translations, Revaluations, etc).
• Involved in the Implementation and Production Support of PeopleSoft Confidential at Ford Motor Company which helped in Delivering an Extensive Financial Management Solution that goes Beyond Traditional Ledger Functions and includes Actuals, Budgets, Statistics and forecasts to support the Organizations Financial Reporting and was responsible for handling Comprehensive Journal Processing Collecting and Controlling the Data efficiently.
• Used Application Engine for Several Reports using XML Publisher by creating Schema and XML file, Report Definition Template and XML Publisher for Printing the Reports.
• Was Responsible for Running the GL Journal Generator Template Process.
• Created Rules to Distribute Amounts while Maintaining Database Integrity and Producing a Complete Audit Trial in GL.
• Involved in Creation and Maintaining Pages, Components, Peoplecode, SQR Reports and Programs, Unix Scripts, Queries using SQL Plus, Unix Cobol Program.
• Worked with Commitment Control of PeopleSoft GL by Managing Commitments and Expenditures Automatically by Checking them against Predefined, Authorized Budgets.
• Involved in the Applying Fixes to SQR Programs in Asset Management and Project Costing Modules like Project Status with Detail Report.
• Involved in the Modifications of the Pages like Doc Real Time Page and also involved in the Modification of Parent Child Application Engine Program so that when ever an Asset is transferred from one Business Unit to another it should assign a right Parent ID depending on the Tag number.
• Involved in Creation of Scripts for Inserting Rows into Dist ln and Proj Resoucre tables.
• In Asset Management involved in applying PeopleSoft patches.
• Created an Interface Program to Load Assets below a certain value which are not capitalized.
• In Asset Management applied PeopleSoft fixes to sqr programs and created new search capabilities and also involved in the Support for Fixed Asset Systems.

Confidential, Princeton, NJ

Functional Consultant

Environment: Confidential (7.5/8.1.6/8.4 2 ), People Tools 8.43, Asset Management, Support for Fixed Assets System, Accounts Payables, Budgets, Inventory, Order Management, CRM 8.8, SCM 8.8, GL/AP, Oracle 8.1.7, Windows 2000

Responsibilities:

• Involved in the implementation and support for PeopleSoft Asset Management, G/L, A/R, AP, Inventory and nVision reporting and tested multi-currency G/L processing (Translations, Revaluations, etc)
• Involved in implementation and Production Support Inventory Module and involved in writing the Demand Feed Programs for Shipping Notice Feed into PeopleSoft Inventory which provides the standard process for Order Fulfillment and for Shipping Notification Workflow which sends an email to the Customer after a shipment has been made and also for generating Shipping Notice Report and also worked on the Order Management SQR’s of Digital Rivers which gives the latest status on Orders and also worked on Parapro Process which uses service items.
• Implemented CRM 8.8 Solutions (Help Desk, Support, Order Capture) which provided integration between Customer, Financial, Supply Chain and Employee Management Systems and was responsible for Case Creation, Time Entry, giving the Quote’s, Receiving the Orders and sending this information to Inventory, Order Confirmation, and also worked with App Classes and also worked in all the Phases of SCM 8.8 like Procure to Pay, Plan to Produce and Order to Cash.
• Involved in Creation and Maintaining Pages, Components, Peoplecode, SQR Reports and Programs, Unix Scripts, Queries using SQL Plus, Unix Cobol Program.
• Involved in the Detail Design Process, Documenting the Business Process, Unit Testing, User Acceptance Testing, the End users for access of AR Reports like Payment Predictor Detail Report and Shipping Notice Reports in Inventory.
• Worked on Payment Predictor Detail report and also on Ageing Report in AR.
• Involved in the Upgradation process from 7.5 to 8.4 using Application Upgrader by moving object definitions between PS databases and by running the Test scripts and after exporting created the SQL and ran them in 8.4 database.
• Analyzed the Company’s whole Business Process and set the business rules for different process involved in converting the data from Euro to U.S. Dollar.

Confidential, Dallas, TX

Functional Consultant

Environment: Confidential (7.5/8.1.6/8.4 ),Informatica 3.1/5.0, Object Security, Asset Management, Accounts Payables, Inventory, eProcurement, CRM, AR/PO/GL, Oracle 8i, Windows 2000

Responsibilities:

• Involved in Conversion of data using Informatica tool and converted the data from 7.5 database to 8.4 database in the tables of all the modules AP, AR, PO, GL and AM.
• Involved in implementation of eProcurement Module so that it helps in buying the materials needed for Perot Systems online efficiently.
• Involved in the Upgradation process from 7.5 to 8.4 using Application Upgrader by moving object definitions between PS databases and by running the Test scripts and after exporting created the SQL and ran them in 8.4 database.
• Implemented CRM Solutions at Perot Systems Corp which provided integration between Customer, Financial, Supply Chain and Employee Management Systems.
• Involved in Implementation of PeopleSoft Inventory Module for efficiently handling the Inventory and accordingly order of new Purchase items at Perot Systems Corporation the depending on the demand.
• Analyzed the Application Engine Programs and accordingly did the necessary changes in the transformation expressions in the mappings of all the tables which have been converted from 7.5 to 8.1.6 database.
• Did the Archiving Process in AP and AR in 8.1.6 database and got archived the Payment Tables, Voucher Tables and Vendor Tables in AP and also archived Pending Item data tables, Payment Item data tables and Posted Item data tables in AR.

Confidential, CA

Functional Consultant

Environment: Confidential (7.0), Informix, SQR, AP, POPurchasing Module, PeopleSoft Inventory, Windows 95

Responsibilities:

• Involved in the implementation of Accounts Payables system for company so as to provide an efficient way of managing the payments to its different stores all across the country.
• Involved in Implementation of PeopleSoft Inventory Module for efficiently handling the Inventory and accordingly order of new Purchase items in the Longs Drug Stores depending on the demand.
• Involved in Post Implementation of PeopleSoft Purchasing Module and Accounts Payable and trouble shooting problems relating to panels, people code, Application Engine.
• Worked on PeopleSoft Purchasing SQR for Managing Shipment.
• Involved in solving the Problem tickets received from the EDI department.
• Involved in solving the trouble tickets received directly from the stores and provided solutions online.
• Involved in producing the PeopleSoft AP Reports which gives Application Payables Input Listing.
• Developed records, panels and menus and created new queries for giving the list of unapproved vendors.
• Involved in running the SQR reports of Longs Drugs for printing the checks.
• Involved in running the scripts by the computer operations department.