PROFESSIONAL SUMMARY

• Over Twenty one years of experience in the IT industry and Fourteen years of Experience in US as a PeopleSoft Senior FSCM 9.2 Business Analyst in PeopleSoft FINANCIALS 9.2, SCM 8.8/91, GL/AP/AR, Asset Management, Inventory and Project Costing.
• Worked in all the Phases of SCM 8.8/9.1 like Procure to Pay, Plan to Produce and Order to Cash.
• Implemented CRM 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.
• PeopleSoft Business Analyst with strong experience in different phases of PeopleSoft development life cycle including Fit/Gap Analysis, Implementation Design and End user training.
• 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 PeopleSoft FSCM 9.2, Financials 9.1, SCM 8.8/91, 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 Server,
• MS Access
• ERP Tools PeopleSoft 6.0, 7.0/7.5, 8.1.6/8.42/8.8/8.9/9.0/9.1
• PeopleTools 6.0, 7.0/7.5, 8.1.6/8.45/8.49/8.52 SQR,
• PeopleCode, 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 2000,
• Windows XP

Confidential Role : PeopleSoft Consultant

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

• 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 Role : PeopleSoft Consultant

Environment :PeopleSoft FSCM 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.

• 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 Role : PeopleSoft Consultant

Environment :PeopleSoft FSCM Financials 9.1 People Tools 8.5, General Ledger, Commitment Control, Application Engine, Oracle 10.2, Windows XP

• Involved in the Production Support of PeopleSoft General Ledger in Creation of Test Cases/Scripts in PeopleSoft General Ledger as a member of GL Admin Group at Hartford. 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 Hartford.
• Involved in Updating the Status of Remedy Tickets in the GL Admin Group 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 General Ledger.
• 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 Role : PeopleSoft Consultant

Environment :PeopleSoft FSCM 8.8/9.1 People Tools 8.5, SCM 8.8/91, General Ledger, Asset Management, Project Costing, Application Engine, Oracle 10.2, Windows XP

• Analyzed and presented the new functionalities of General Ledger 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 General Ledger.
• 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 General Ledger 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 Role : PeopleSoft Consultant

Environment :PeopleSoft Financials 8.8/9.0 People Tools 8.49, Accounts Receivables, General Ledger, Payments, STAT Migration Tool, Application Engine, XML Publisher, SQL Script, Oracle 10.2, Windows XP

• Analyzed and presented the new functionalities of General Ledger, 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 Role : PeopleSoft Consultant

Environment :PeopleSoft Financials 8.9 People Tools 8.45, SCM 8.8, General Ledger, Asset Management, Project Costing, GL, HP-UNIX, COBOL, Application Engine, XML Publisher, SQL Script, Oracle 9.1, Windows XP

• Worked in all the Phases of SCM 8.8 like Procure to Pay, Plan to Produce and Order to Cash.
• Analyzed and presented the new functionalities of General Ledger, 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 General Ledger, AP, and Tested Multi-Currency G/L processing Translations, Revaluations, etc .
• Involved in the Implementation and Production Support of PeopleSoft General Ledger 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 Role : PeopleSoft Consultant

Environment :PeopleSoft Financials 7.5/8.1.6/8.42 , 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

• 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, Training 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.
• Confidential's whole Business Process and set the business rules for different process involved in converting the data from Euro to U.S. Dollar.

Confidential Role : PeopleSoft Consultant

Environment :PeopleSoft Financials 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

• 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 Role : PeopleSoft Consultant

Environment : PeopleSoft Financials 7.0 , Informix, SQR, AP, PO,

• Purchasing Module, PeopleSoft Inventory, Windows 95
• 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.

Confidential

Role : Programmer/Analyst

Environment : IBM PC Compatible, MS Windows 3.1/95, MS Access,

• Visual Basic 5.0/6.0, Crystal Reports
• Automation of daily corporate activities and various other functions such as project planning and scheduling, cost estimations and monitoring etc. The project involved developing screens for scheduling several projects, the human effort estimations, maintenance of data for sub-contract employees, start dates/finish dates, budgeting functions and billing and overall cost estimates.
• Involved in development of screens and reports using Crystal Reports.