Peoplesoft Manager

SAKSHI BHARDWAJ

Oracle PeopleSoft Techno-Functional Consultant

Email: ******.***@*****.***

Mobile (US): +1-518-***-****

Location: South Burlington, VT

EXPERIENCE SUMMARY

• Senior PeopleSoft Techno-Functional Consultant with around 12 years of experience in Oracle ERP financial modules and peopletools including scoping, designing, building and testing ERP PeopleSoft solutions.

• Strong Experience in PeopleSoft 9.1/9.2 - Upgrade and Production Support & Enhancement Experience

(People Tools 8.5x) with GE Healthcare Birlasoft Ltd (India and US) and Genpact LLC (USA).

• Functional expertise includes ESA/Financials modules - Project Costing, Customer contracts, Billing, General Ledger, Accounts Payable, Financial Gateway, Banking, Purchasing (PO) and Quote Management and Travel & Expense.

• PeopleSoft Onsite Business Analyst experience on fit-gap analysis, business process consulting, configuring, conversion, end to end system testing, upgrade, support and maintenance.

• Hands on experience Peoplesoft FSCM functional testing and coordinating User Acceptance Testing among various users team.

• Performed Scrum Master and Test Lead role for product controllership rollout.

• Experience on PeopleSoft 9.0 - Implementation and Production Support and Enhancement with Tech Mahindra Ltd.

• Technical experience on People Tools-Application Designer, Application Engine, Peoplecode, Application Packages, Component Interfaces, SQR, BI Publisher and Query, SQL /PLSQL.

• Experience in Production support, maintenance and enhancements of Peoplesoft applications. EDUCATION

Bachelor of Technology in Computer Science and Engineering in 2008. CERTIFICATIONS

@CSM-Certified SCRUM Master -year 2015.

TECHNICAL & FUNCTIONAL DOMAIN

• Functional Domain: - Peoplesoft 9.0/9.1/9.2 -Project Costing, Customer Contracts, Billing, General Ledger, Purchasing, Accounts Payable, Asset Management, financial gateway, Banking, and Quote Management, Travel

& Expense.

• ERP Case Tools: People Tools v8.5x/8.4x: Application Designer, Peoplecode, Application Engine, Integration Broker, Component Interface, Workflow

• Reporting Tools: PeopleSoft BI (XML) Publisher Reporting Tool, PS Query and SQR Reporting Tool

• Languages: Peoplecode, SQL/PLSQL

• Databases: Oracle 8/9i/10g, MS Access

• OS: Windows, UNIX.

• Tools/Utilities: VSS, HP open View, Quality Center and Application Lifecycle Management and ServiceNow, Rally and Jira.

PROJECT DETAILS

1). GEHC Peoplesoft 9.2 Upgrade and Support

Client: GE Healthcare, Burlington, VT, USA July 2017 – Till Date Role: Lead Consultant -Oracle ERP Peoplesoft

Organization: GENPACT LLC, 1155 6th Ave 4th Floor, New York, NY, USA, 10036 Project Description: GEHC Peoplesoft -9.2 Upgrade includes upgrading PeopleSoft 9.1 application to PeopleSoft 9.2 and deploying GEHC acquired business globally - multiple International Legal entities to Peoplesoft starting from system design development, configuration, testing, conversion and Go live and production support. Responsibilities:

• PeopleSoft Functional Consultant financials responsible for Travel & Expense, Project costing, Contracts and Billing, Purchasing, Accounts Payable and GL modules for PeopleSoft 9.2 upgrade.

• Performing initial requirements gathering and fit-gap study for the global rollout from Peoplesoft 9.1 to Peoplesoft 9.2 - worked closely with end users and process owners to cater to business requirements and formulated functional requirement documents for the 9.2 upgrade requirements–URS & FRA documents and getting approval from Business team.

• Designed a new Quote management workbench tool– utility to interface signed quotes from Apttus system and provide ability to modify the attributes associated with lines and create Contracts (allocated and non-allocated), Orders and Projects from tool in peoplesoft which markedly impacted the FCA & CCAs user community efficiency for entering deals and establishing contracts in the system.

• Performing Impact analysis of ASC606 revenue recognition standard that affects customer contracts in Peoplesoft 9.2 with and linking business processes with the setup and business rules of Peoplesoft 9.2

- Creation of new contract allocation summary page to consolidate the management of ASC606 allocation activity onto a single page

- Designed UAR sweep using Peoplesoft 9.2 allocations to sweep unnatural (debit) balance in deferred revenue account to UAR account on contracts where revenue is permitted before invoicing.

• Configuring Peoplesoft 9.2 Billing workcenter and Contracts workcenter for Contract support team and Billing team as per user requirements for CRP test that allows the user to prioritize items, view work lists, access transaction pages, and quickly locate queries and reports.

• Formulating business process driven track specific test plans in collaboration with end user team with sequential test scenarios for OTC and PTP, GL tracks.

OTC track scenarios -Quote management workbench – Apttus quotes to PeopleSoft -Contract creation

(allocated and non-allocated), Revenue Recognition -Fixed and as incurred, Contract Billing Interface multiple invoice format testing (CA, EXP, CLB, RCR, RCV) and running Single Action Invoice- generating invoice pdfs.

PTP track scenarios – Vendor creation, Creating PO, PO Dispatch, Receipt, Voucher entry, Voucher matching and Pay cycle manager, verified bank setups and external bank account setups etc. GL test scenarios - Creating, Validating Journals from sub-ledger- Billing Journals, Revenue Journals, AP journals -Voucher and Payment posting.

• Performing first round of Peoplesoft 9.2 functional system -verifying configuration and end to end testing(IQ, OQ, PQ tests) and logged multiple defects during testing in Jira and found delivered bugs.

• Performing testing with third party applications included in Payment processing from peoplesoft – EPIQ and WEBCASH (GE treasury) team and testing with Vertex team for Invoice tax calculation in test environments.

• Analyzed data through back end SQL developer- writing SQL queries on peoplesoft records.

• Creating Application Lifecycle Management UAT testing scripts for the new requirements for Peoplesoft 9.2.

• Supporting end users for UAT testing by creating UAT test scripts and getting approvals from end users and Validation manager in ALM.

• Helped end users for Data staging needs for Peoplesoft 9.2 Financials testing on new data as per the data template provided by end users.

• Supported GO Live -prepared various training job aids, user manuals and work instructions – making users familiar with Peoplesoft new Fluid user interface and workcenters.

• Provided Quarter & year end Finance closure production support to end users by running multiple data integrity queries.

• Involved in International Legal entities deployments with Peoplesoft 9.2 as Sub-ledger to GLPROD.

• Carried out the Inbound and Outbound testing for flow of invoices and revenue journal information to GLPROD- PeopleSoft to GLPROD Billing Interface, PeopleSoft to GLPROD Revenue Interface, GLPROD to PS Invoice # sync, new Field in Customer Master to Capture GLPROD Customer Number & Customer Master Sync in testing environment prior to UAT testing.

• Supported Peoplesoft 9.2 Virence divestiture – GE healthcare Virence Business spin off to new system – coordinated user training and GE documentation transfer to Virence team.

• Gathering requirements with user for Peoplesoft 9.2 enhancements and coordinating with IT team to develop the enhancement and creating testing sign off documents in test environments

• Providing Peoplesoft 9.2 production support and maintenance and assisted end users in production issues across different PeopleSoft 9.2 FSCM modules.

2). Product Controllership phase 4 GE Healthcare HCIT Client: GE Healthcare, Barrington, IL, USA Mar 2016 – June 2017 Role: Peoplesoft Business Analyst

Organization: BIRLASOFT INC, 399 THORNALL ST,8TH FLOOR, NEW JERSEY, USA,08837 Project Description: HCIT Product Controllership ERP Tools program, aimed at rolling out functionality in multiple systems to enable GEHC medical devices to meet the Federal Drug and Administration (FDA) Unique Device Identification (UDI) regulations. The project includes rolling out the Product Controllership functionalities in multiple systems including PeopleSoft, GLPROD, eDHR, Agile, GPM, ITC/TA and improving the performance of interfaces to/from PeopleSoft and other systems. Responsibilities:

• Assist in the design, development and Product controllership enhancements in Peoplesoft 9.1

• Performed Scrum master role for implementing agile methodology throughout the project lifecycle.

• Responsible for facilitating the daily scrum calls, sprint planning and grooming sessions, ensure on track dev elopment within a sprint, early communication and facilitate help where needed, end user approval of the user stories and reporting of the development sprint.

• Organized sprint showcases, sprint retrospection meeting and responsible for daily and weekly reporting of sprint and development progress.

• As Testing Lead – coordinated end to end testing that comprises of multiple rounds of testing UAT and Integration testing starting from Test Planning-maintaining Traceability matrix, testing kick off, test execution, defect triaging, reporting weekly testing status.

• Conducted Testers training sessions on JIRA testing tool prior to testing – making users familiar with Defect lifecycle and how to choose appropriate defect severity and priority in Jira.

• Ensured Resolved defects are retested and verified by user community for Defect Closure.

• Prepared Test Summary reports out of each round of testing CRP and UAT. Routed Test Summary for QA approval and released in Myworkshop to ensure closure of Project testing cycle for Production Go Live. 3). PeopleSoft 9.1 Deployments & Support

Client: GE Healthcare, Burlington, Vermont, USA Jan 2014 – Feb 2016 Role: Peoplesoft Onsite Business Analyst

Projects -API Healthcare deployment and Caradigm (GE & Microsoft joint Venture) Organization: BIRLASOFT INC, 399 THORNALL ST,8TH FLOOR, NEW JERSEY, USA,08837 Project Description: The Project includes deploying GEHC acquired business as new legal entities for API healthcare and Caradigm existing ERP system Peoplesoft 9.1. The PeopleSoft 9.1 existing application is configured for the new business units for financial modules. Responsibilities:

• Onsite Business Analyst for requirement gathering and mapping out the legacy system functionalities to the PeopleSoft system and involved in full life cycle - from design to production support.

• Responsible for configurations/setups in Accounts Payable, PO, General Ledger,Project Costing and Contracts, Billing module for establishing new Business Unit for API healthcare and Caradigm- configured accounting rules, rate sets, milestones, project team, contracts support team, products and setting up employees Travel and Expense profiles.

• Responsible for setting up bank codes and External bank accounts, payment methods, new paycycle (pay cycles 02CHK and 02ACH) for Caradigm and configured

• Configured new bill type EX2 for Caradigm new invoice format as per business requirement.

• Configured Distribution accounting –Distribution rules, sets and Distribution codes for new legal entity API. Distribution sets defined for combination of each customer group and product group.

• Created Asset Conversion (AM) Data Migration plan with business users for API to convert legacy data as per Health Care system and coordinated data conversion with offshore team.

• Designed Customization and coordinated development with offshore team as per the requirement document -

• Contract Management Workbench for API to facilitate end user’s day to day contracting transactions and update milestone events to initiate billing and revenue recognition.

• Time sheet status tool to cater user requirement – tool to check time sheet status – pending or approved at PM workbench or at Supervisor approval with the approvers SSO IDs

• Concur Inbound and Outbound interface to cater to the expenses entered by Caradigm employees in Concur system and processing Caradigm expenses in PeopleSoft

• Analyzed existing business reports to fit for new Business units logos on customer facing documents and requirements and coordinated changes with offshore team.

• Performed end to end testing– creating invoices out of contracts, contract creation, testing time entry and revenue recognition, testing Single action Invoice(CA, EXP, CLB) sending invoice pdfs to Coakley (taking invoices in PDF format and printing, stuffing them into envelopes and mailing them to customers).

• Tested Caradigm check payments AP-EPIQ interface for vendor payments through checks via middleware to EPIQ - EPIQ is a third-party payment processing vendor that handles printing of checks and mailing for vendor payments.

• Created vouchers for Caradigm and tested voucher matching and payment file processing thru AP-EPIQ interface and WebCash (GE Corporate Treasury Application).

• Performed end to end testing for Billable expense processing through Billing and non-billable expense processing through AP to GL.

• Performed GL testing- interfaced data from subledgers for journal creation – Billing journals and Contracts Revenue Journals, Voucher posting and Payment posting.

• Supported all rounds of user testing including Functional testing and UAT testing by helping users running test scripts, testing the system using Quality center and resolved issues logged by users during testing.

• Provided training to end users, business users and Project managers-created user manuals and work instructions before Go Live.

• Provided Production support and enhancements support after GO Live. 4). PeopleSoft 8.4 to 9.1 Migration and GAMS production support Client: GE Healthcare, Barrington, IL, USA Nov 2010 – Dec 2013 Role: Peoplesoft Technical Consultant

Organization: Birlasoft LTD, D-195, Sector-63, Noida, India -201301 Project Description: The Project includes Implementation of modules of the PeopleSoft 9.1 suite for multi-million dollar US business units (currently on legacy systems) along with an upgrade of the existing PeopleSoft 8.4/9.0 instance to 9.1 and developing new enhancements/ Utilities/Tools in PeopleSoft 9.1 to meet changing business requirements and supporting production.

Responsibilities:

• Performed initial requirements gathering and fit-gap study for the global rollout of PeopleSoft suite and worked with user team to prepare Data migration plans for conversion of data from PeopleSoft 8.4 to PeopleSoft 9.1.

• Led the complete development effort which included Code retrofitting- Designing new pages and customizing existing ones using Application Designer, programming in People Code, extensively using PeopleSoft Workflow technology to send notifications using e-mails and worklists, developing Component Interfaces for seamlessly integrating different applications and developing numerous SQRs to generate reports to be used by the various ERP end users.

• Built the Recurring billing system in Peoplesoft 9.1 contracts.

• Created Conversion application engine programs to migrate the data for Projects and Contracts modules from PeopleSoft 8.4 to PeopleSoft 9.1 using database link to 8.4 and by applying necessary transformations on the 8.4 data to get mapped with 9.1 records as per the Data mapping sheets.

• Worked on Mercury 9.0 Quality center for preparing test scripts for CRP, DRY RUN and UAT testing and got it reviewed and approved through Validation Manager in Application Lifecycle Management.

• Coordinated Migrations of code with DBA team to migrate code changes from DEV instance to TST & STG instance and then to Production for Go Live.

• Provided Production support & maintenance after Go Live and handled production issues both technically-created DML, SQL queries and functionally for OTR track- PeopleSoft Financials. 5). PeopleSoft 9.0 HR-FIN Implementation and Support for Tech Mahindra Ltd. Client: Tech Mahindra Ltd, Pune, India Aug 2008 – Oct 2010 Role: Technical Associate

Project Description: The Project is an implementation project from PeopleSoft 8 to PeopleSoft 9.0 for the Organization's HR and Financials Business process which involved development of solutions through PeopleSoft using People Code, SQR, and Application Engine.

Responsibilities:

• Involved in End-to-End Implementation and Involved in the various upgrade passes including compare reports, retrofitting and end to end testing of PeopleSoft financials modules in an upgrade project.

• Prepared Technical Design Document from the Functional Design documents.

• Customized delivered functionality or develop new functionality according to user requirement.

• Created new records, views, pages, components, menu, approval workflow to design the new functionalities to meet the business requirement and numerous ERP reports using SQR and XML Publisher like CASUM (Contract Summary Report), Project details, Project team reports, MIS Detail Report,Resource Allocation Report etc.

• Perfomed Data analysis from backend by writing using SQLs using SQL Developer.

• Involved in providing inputs and for data conversion to Data migration for Application engine for data conversion.

• Performed Impact analysis for all customizations and Implemented and maintained security matrix.

• Carried unit testing as developer for the custom functionalities developed and understood inter module dependency and provide solution accordingly.

Contact this candidate