SUMMARY:

• Around 9+ yrs. of work experience in IT/Finance industry as a Financial Consultant in PeopleSoft, Process Expertise in Procure To Pay and Record To Report business process on various domain as Retail, Automobile, Trading, Media, Banking, Consumer Goods, Healthcare etc.
• Strong organizational skills, in particular, an attention to detail and the ability to prepare reports in a timely and effective manner.
• Backed by strong credentials of verifying financial documents/statements, reports, skill in analyzing and interpreting financial data, Defect Management & Triage Management. An advanced command of various Finance/Accounts process, testing suites, waterfall/agile methodologies and monitoring tools.
• Ability to communicate effectively, verbally and in writing with leaders and personnel and to establish and maintain effective working relationships with employees, business partners and company officials.
• Ability to prepare business cases as needed to support a growing technology business.
• PeopleSoft FSCM 9.1 to 9.2 Implementation of AR/BI/Grants/Contracts & Re - implementation- Confidential .
• PeopleSoft FSCM 9.0 to 9.2 Implementation & Production Support- Confidential .
• PeopleSoft HCM 8.8 to 9.1 Upgrade - Confidential .
• PeopleSoft FSCM 8.8 to 9.0 Upgradation - Confidential .
• PeopleSoft Finance Upgrade 8.4 to 8.9 - Confidential .
• PeopleSoft HCM Business Analyst- Confidential
• PeopleSoft Re-implementation of Finance/SCM 8.8- Confidential
• Proficient with PeopleSoft 8.0/8.4/8.8/8.9/9.1/9.2, Advance Excel (V-Lookups, Pivots, Functions), ALM QC, Quick Base, Rally, Manual Testing & Defect/Triage Management & STLC process.
• Extensive experience in SAP Implementation, PeopleSoft Analysis, Implementation, and Upgrade & Production support experience.
• Specialized in Functional analysis, designing and developing customizations of Pages, Components interfaces, and reports.
• Responsible for Developing Interface and Data conversion for FSCM modules (AP, OM, PO, eProcurement, Inventory, Lock Box, Payment Predictor, Grants & Contracts, PC, AR/BI, Invoicing, Cash Management, Treasury Management, Bank Reconciliation process, Deal Management, AM).
• Budgeting & Forecasting, GAP Analysis.
• Working Experience on Application Designer, Application Engine, People code, Component Interface, SQR, Crystal Reports, XMLP, Integration Broker and Security.
• Handling pressure with 100% accuracy of delivery.
• Experience in Database - SQL Server, Oracle, SQL Base, MS-Access, DB2
• Excellent in Production Support, Documentation, End-Users training and Knowledge transfer
• Served as the key point of contact/Liaison between on and offshore resources and Finance and Supply Chain Team.
• Excellent oral/written communication and presentation skills
• Open line item processing, claims processing, Month End Closing Process, Quality Check, Rectification Entries, Balance Sheet Accounts Reviews& Reconciliation process.
• Prepare Journal Entries to reverse accruals in Journal Entry Template designed for uploads in SAP system.
• In-depth knowledge of PeopleSoft Development Life Cycle (PDLC) - Fit/Gap Analysis, Design, Data Conversion, User Interface Customization, Unit / Integration / System /Acceptance Testing, End User Training.
• Strong experience in interface design, data mapping and data conversions.
• Strong Experience in nVision and Crystal reporting.
• Knowledgeable in Integration tools like Application Messaging, Component Interface and Business Interlinks.
• Adept at analyzing business processes and user requirements.
• Well-versed in Workflow design.
• Expertise in writing People Soft Queries.
• Suggest Process Improvement.
• Ability to adopt quickly to New Systems & Technology.

TECHNICAL SKILLS:

Application: PeopleSoft Financials v8.0-8.9 (AR, AP, GL, AM, Billing), SCM v8.0-8.8 (OM, BI, INV, PO, PC), HR v8.3 (HR, BA, Payroll, BB, TA, T&L), CRM (Sales, Marketing, Order Capture).

Reporting Tools: PS Query, PS/nVision, SQR, Crystal Reports, Hyperion Reports, Tree Manager

Databases: Oracle, MS SQL Server, SQL Base and MS Access, FoxPro, SAP ECC5.0/6.0

Software: People Tools 6.01/7.55/8.13/8.3/8.40.09/ v 8.45.12/8.55, Visual Basic, Developer 2000, and MS Office, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, MI

PeopleSoft Financial Consultant

Responsibilities:

• Worked with Users, Application Owners, Managers, and team to draw up specifications and gather requirements for PeopleSoft FSCM (GL, AP, AR, BI, Grants, Contacts) Assisted in streamlining the SCM process as per requirements and anticipated deliverables.
• Designed and Developed Several Custom interfaces to AR, BI, PC, AM, Grants & Contracts and GL Modules.
• Worked extensively with AR Update and Payment Predictor process.
• Customized AR statement process with the interface with BI.
• Interacted and assisted Tech Team to modify interfaces to convert legacy Asset data to PeopleSoft Asset Management.
• Designed Purchasing workflow process.
• Troubleshoot GL Journal Edit issues.
• Worked with Business unit, setup Ledger
• Designed and support of Grants and Contracts.
• Designed and Developed nvision reports.
• Fixed issues related to Matching. Designed and Developed interfaces for p-card processing.
• Performed Testing of AR/BI, Grants & Contracts, GL, PC.
• Tested modifications to ensure they meet customer’s specifications. Provided on-call support to the end-user.
• Developed customizations using Application Designer for Grants & Contracts.
• Involved in the analysis and implementation of PeopleSoft AR/BI, Grants & Contracts.
• Fixing of problems and issues which come across during various stages of upgradation like development, User acceptance and live of project costing
• Extensively involved in Post-Production Activities, Documentation and end user training

Environment: PeopleSoft 9.1/9.2 FSCM (GL, AR, AM, BI, Grants & Contracts)Confidential, Richmond, VA

PeopleSoft Techno Functional Consultant

Responsibilities:

• Involved in developing and customizing the reports using the tools People Soft Query and SQR.
• Interacting with users and collecting business requirements and prepared functional and technical specification documents.
• Core Team member in the upgrade of PeopleSoft 9.0/9.2.
• Responsible for the analysis of 8.8 and 9.0 release notes and involved in the impact assessment and prepared upgrade documents.
• Performed Vanilla compare between production (copy) databases to demo database to identify all customizations to be carry forward with upgrade.
• Involved in resolving the upgrade issues from PeopleSoft 9.0 to v9.2.
• Involved in upgradation and customization of SQR's.
• Worked exclusively on the Account Receivables Part of the business units.
• Created interface that will be used to generate the flat file with details of all checks for payment and cancellation this was used for the Bank Reconciliation by the Client.
• Involved in Fit-Gap analysis, Requirement gathering, design, development, testing, implementation of People soft Enterprise Portal.
• Troubleshooting project costing budgeting.
• Created Excel to CI templates to the functional team.
• Design and development of Grants Post-Award conversion to upload grants conversion data from DFMS into the PeopleSoft Post Award records The Component Interfaces developed for the completion of this conversion task are GM AWARD CI, CA HDR PNG CI, PROJECT GENERAL CI, and GM BUD DETAIL CI. An Application Engine was developed and the Component Interfaces are called in “Update” mode to load the necessary data for the already created Award.
• Responsible for customization of purchase order, requisition activities pages in eProcurement.
• Involved in Facilitating meetings, process mapping, and knowledge transfer.
• Good knowledgeable interaction with the end users in gathering their concerns and issued with the postproduction and providing solutions to resolve them.
• Troubleshot and fixing problems on development, Test Environment and moving changes to Production Environment

Environment: PS Financials 9.0 (GL, Inventory, PC, eProcurement, Billing, Grants, Contracts) modules.

Confidential, Herndon, VA

PeopleSoft Techno-Functional Consultant

Responsibilities:

• To understand the existing business processes of client across the varied functional areas and map those on PeopleSoft HRMS landscape.
• To design business solution enabling automation and bringing in operational efficiency in.
• Business processes along with achieving seamless integration among different business processes.
• Liaison and communicate with technical team to develop and conceptualize the bespoke.
• Requirements of client across varied functional areas. Identify and propose the solution which can take over business processes and Operations with minimum bespoke developments and brings in efficiency in different business processes along with realization of quicker ROI.
• Designed business solution enabling automation and bringing in operational efficiency in business processes along with achieving seamless integration among different business processes.
• Ensuring a smooth and time-bound transition of client’s business processes to new application landscape from legacy system or manual processes.

Environment: PeopleSoft 8.9/9.0 FSCM (PC, AP, Grants, Contracts, GL, AR, AM, BI) ALM QC, iTrack, Excel (V Lookup, H LOOKUP, Index, Filter, Formulas)

Confidential, Irvine, CA

PeopleSoft Functional Consultant

Responsibilities:

• Worked with Users, Application Owners, Managers, and team to draw up specifications and gather requirements for PeopleSoft FSCM (PO, Inventory, ePro, BI, GL, AP, AR, Grants, and Contracts).
• Assisted in streamlining the SCM process as per requirements and anticipated deliverables.
• Designed and Developed Several Custom interfaces to AR, BI, PO, AM, Inventory, AP and GL Modules.
• Worked extensively with AR Update and Payment Predictor process. Customized AR statement process with the interface with BI.
• Worked with Sprint developers, testing team to test out Asset Management Business Units and Processing Options.
• Worked with Sprint users in the finance department to set up Asset Category, Asset Profiles and Accounting Entry Templates
• Tested the Asset Management batch process for daily, nightly, weekly, monthly cycles to verify each job completed with success and no error codes.
• Set up Asset Addition, Adjustment, Transfer and Recategorization.
• Created Retire and Reinstate Assets.
• Assisted the Asset Management finance users with Depreciation Processing.
• Interacted and assisted Tech Team to modify interfaces to convert legacy Asset data to PeopleSoft Asset Management.
• Designed Purchasing workflow process.
• Troubleshoot GL Journal Edit issues.
• Performed Fit-GAP analysis to gather requirements for GL and Grants and Contracts implementation.
• Worked with Business unit, setup Ledger.
• Designed and support of INV and ePro interfaces.
• Design and Develop nvision reports.

Environment: PeopleSoft 8.8/8.9 FSCM

Confidential

PeopleSoft FSCM Functional Consultant

Responsibilities:

• Worked with Business People and getting their requirements and customizations, Drawing Process Diagrams that helps other team members to understand system easily.
• Configured and setup tables 8.8 setup banks, bank accounts, inter unit accounts using centralized inter/intra unit functionality, sales/use pack defaults and option, withholding environment.
• Assisted in vendor data conversion
• Prepared training document for payables and receivables.
• Configured AM, AP, GL, AR setup data (like Business Units, Control data, Vendor Location, Origin, Items etc.)
• Designed, developed and implemented custom Schedule Billing online pages
• Coded batch program for creating bills and email notifications to users basing on custom Schedule Billing
• Fixed errors in billing for several interfaces, printing invoices etc.
• Developed test cases/plans to test various applications.
• Communicated between systems using App Messaging and business interlinks, by defining Message channels, nodes, by Publish and subscribe methods, configuring transactions.
• Evaluation, customization and setting up of workflow for Journal Entry Approval, Asset Transfers approval and Voucher Approval Processes, Receivable processes.
• Developing new components, pages, records and people code customizations added.
• Migration and upgrade the customized people code on various record events.
• Setting up of process definitions and process scheduler jobs for various processes.
• Fit gap analysis for various processes and helped users in finalizing various processes.

Environment: PeopleSoft 8.4/8.8/8.9 FSCM (AM,AP, PO, INV, GL, AR, PC, BI)

Confidential, Confidential

Sr. Business Analyst

Responsibilities:

• Reviewed, evaluated and analyzed benefits processes and user needs.
• Made recommendations on online and functional application processes, identified and documented delivered functionality that fulfill processing needs.
• Prepared requirement, design and application configuration documentation.
• Annual Open Enrollment OE configuration, scheduling, program, plan, rate deductions and eligibility changes.
• Created functional business requirements and test scripts. Functional 9.1 ecompenstation implementation lead Benefits subject matter expert.
• Lead benefits fit gap analysis and resolution.
• Evaluated business process problems to determine system issues and resolution required to resolve the issues.
• Created Statement of Work SOWs for functional and technical services.
• Responsible for resolution of all benefits related service and incident requests.
• UAT lead, developed and implemented testing methods to perform functional Health and Welfare and Defined Benefits testing.
• Provided the test area with parameters for sample testing and specify tests approach and plans.
• Compiled data and define changes required in testing procedures or new testing requirements.
• Wrote test scripts using business requirements documents, designed test procedures.
• Analyzed test results and metrics.

Environment: PeopleSoft HCM 9.0, 9.1

PeopleSoft FSCM Junior Consultant

Confidential

Responsibilities:

• Active participant for Re-Implementation of FSCM/SCM 8.8 through the entire life cycle of the project (Fit Gap, Functional Design, Upgrade, Configuration, Implementation).
• Performed Fit Gap Analysis, provides Current System Business Process, Process Flows, Security, Issues, Defects, Reports information and mapping to Future system with certain definitions like Gap, Adequate, In Adequate.
• Gathered and Defined requirements, overall scope definition in terms of functional & technical requirements, Gap-Fit analysis, data mapping, legacy system integration, and customizations.
• Online support to the users.
• Involved in customizations needed for the users.
• Involved in developing and customizing the reports using the tools PS Query and SQR.
• Worked on reports bill of lading, user preferences report, finished goods and new inventory by area report, Open order report, Die costed inventory report.
• Effectively communicated with business users, functional and technical team also interpreted functional specifications and built solid technical specifications.
• Project co-ordination between customers and technical staff.
• Created new SQR that read the data from text file and updates the PeopleSoft delivered tables to store item related information.
• Provided Solutions to Gap, Adequate, and Inadequate items by Matching with PeopleSoft 8.8.
• Created Job Aids, Trained End user, Process Design.
• Performed customization in eProcurement to transparently include inventory items in search category only to prevent from purchasing goods that is already in stock.
• Interacting with Functional consultants and users to discuss new requirements across the business.
• Involved in developing and customizing the reports using the tools PS Query and SQR.
• Designed and developed new panels and panel groups according to the parameters required and attached to Menus and given security to run reports.
• Online support to the user on Workflow related issues.
• Created Quality assurance plan for post go live usage. Created all testing, training and end user documentation for FSCM.
• Working with customers to analyze and design systems functionality to meet business requirements.
• Prepared test cases for Functionality testing and UAT.
• Involved in writing queries to verify the results from the financial tables and documented them in test scripts.

Environment: People Soft 8.4 FSCM (GL, AP, AR, PO)