PROFESSIONAL SUMMARY:

• Confidential is a Senior PeopleSoft Consultant with 11 years of extensive experience in Financials and Supply Chain and Business Processes.
• Confidential has good experience in requirement gathering; project planning, designing, execution, support and documenting business processes.
• Additionally, she worked on testing including development of test plans, test scripts, end user testing. She has excellent communication skills and be able to influence teammates across the organization.
• She has led multiple teams composed of technology and business members to resolve application issues and provide timely resolution as part of her job in various projects.
• Confidential has a strong foundation in functional and technical development, Unit Testing, System Testing, User Acceptance Testing, User Training, Report Design and Testing, Interface Design and Testing, Production Support. Her experience also includes Application Security configuration and maintenance across multiple Business Units.
• She has implemented Security across multiple locations all over the Globe based on the Business Unit, User access level requirements. Confidential has hands on experience in designing the security system during the implementation phase based on the user specific access at the application level for various modules like AP, AR,GL,BI and Contracts.
• Confidential has 9 years of Functional experience in PeopleSoft Financials GL, AP, PO, AR, Billing and Contracts modules and is an expert with reporting tools like nVision and Crystal and PS Query.
• Her experience is extended to Allocations, Intercompany account, Multi - currency and booking gain/loss on foreign exchange.
• She posses good experience on Global consolidations .She has created Various nVision reports supporting Global Consolidations in various projects and posses an excellent hands on experience on nVision reports .
• While working with Confidential, she has configured and setup ACH processing in AP across various Business Units all over the Globe.
• She possesses an extensive experience on various aspects of Accounts payable module like Business Unit Configuring, Document Sequencing setup, 1099 Vendor Setup and processing.
• Confidential has adept understanding on the Multi-Currency environment and has configured and supported various regions like Confidential and APLA under multibook environment.
• Confidential has good experience on various process flows like Procure to pay, Record to report, Order to Cash etc. She has a good understanding and exposure to the flows and has extensively worked on projects like upgrade, Support, and report developments for these flows.

SKILL:

PeopleSoft 7.x through 9.1 - Payables, Receivables, General Ledger, Billing, Contracts and Purchasing and a fair understanding on Asset Management, module .

PeopleTools 8.xx, Application Designer, Tree Manager, Application Engine, Query, Crystal and nVision.

Oracle, DB2 and MS SQL Databases.

Oracle Certified Consultant (Implementation Champion - PeopleSoft Financial Management).

PROFESSIONAL EXPERIENCE:

Confidential, California

Financial Techno- Functional Consultant/Business System Analyst

Responsibilities:

• Provide a consolidated summary of billing information on one single invoice with a detail breakup of invoice lines grouped per billing location (Cost center).
• Generate multiple invoices based on multiple customer billing locations to ensure each single bill is sent to the respective location for payments.
• Understanding the Business Requirements by participating in the discussions with Business and technical teams.
• Design the Custom Cost center billing Functionality process .
• Create a Functional Design Document with cost center functionality and the customizations and configurations required to setup the process.
• Custom program has been designed to identify the cost center customers and based on the type of billing requirement segregate the billing data of each customer cost center before importing the same into the PeopleSoft tables.
• Provided the feature of Holding customers before billing (before creation of Invoice) so that users can View and modify the billing data as per customer and business requirements.
• Developed custom reports for the Billing Users, which provides billing information like unmapped customers, unmapped products, unmapped cost centers and customers in hold and customers billed.
• Customized existing Invoice print crystal report as per the new functionality defined.
• Perform a study on the current Monthly billing process at Confidential and all the integrations surrounding to it .
• Create an Analysis document with the Current Business Process, drawbacks and the to be process .
• Identify the pain points and analyze possible solutions for overcoming them in the new re-defined process
• Re-Design the PeopleSoft objects in order to map them to the current requirement
• Document the Application Engine program changes from a functional stand point of to view to arrive at the right Invoice output.
• Redesign the input logic to import the data from the staging table into the PeopleSoft system in order to enhance the current invoice by adding more field values .
• Co-ordinate with the Technical resource to customize the Application Engine program to
• In process of working through the changes to get to the right output
• Project involves configuring the Requisition /Purchase Order Workflow for all the Purchasing Business Units within the system.
• Conduct the Business requirements gathering sessions with the Business Users and Management team to understand/Collect the Business requirements .
• Perform Functional Analysis to perform the Business requirements mapping against the PeopleSoft delivered Workflow functionality to arrive at the right solution.
• Identify the Customization aspects of the process in order to match the workflow design to the Business requirements based on functional analysis.
• Create the Functional design document for the Amount based Workflow
• Design the Workflow process based on the Monetary amount limits provided for the approval process .
• Design the parallel workflow processing to the approvers based on the amounts for the 3 levels of amount based Approvals.
• Define the stages, paths, steps, recipients, and notifications for each approval process .
• Define Route Control Types, Route Control Profiles Required for the Department and Business Unit configuration requirements
• Make customizations to the PeopleSoft delivered Workflow process in order to accommodate department level workflow process
• Create the Workflow roles required for routing the approval transactions
• Design the Business Process, Approval Rule Set definitions and Activity as part of the workflow configuration
• Design the Customization, Page, Record and define the Audit requirements to capture the approvals at all stages of the Requisition process before creating the PO.
• Liaison between the technical team and the Business Users in order to work on the customization requirements in the Workflow
• Test the customizations and the workflow design in order to ensure the Workflow triggers according to the Business Requirements
• Demo the Workflow to the Users and train them on the same
• Create Test Scripts to be provided to the Business Users for testing
• Provide day to day support for the PeopleSoft in order to ensure the Business runs with no issues
• Create New queries in order to help data reports for the various Business requirements
• Modify the Crystal reports based on the Business Requirement changes
• Support 1099 Processing during the year end for a smooth processing
• Co-ordinate the technical team to make code modifications to avoid issues on the day to day processing
• Support the Audit requirements (SOX)

Environment: Oracle9i Enterprise Edition Release 9.2.0.5.0, PeopleSoft Financials 8.9, PeopleTools8.46

Confidential, Florida

Financial Functional Consultant/Business System Analyst

Responsibilities:

• Study the current Business Process at Force in order to understand the data flow to help with the Data extraction and migration process.
• Conduct the Business Process session for Intenvitve team to help understand the Confidential data flow.
• Conduct Data extraction requirement sessions with Inventive team to design/define the Data extraction business Process rules and logic.
• Analyze, identify and list out all the Archived and Custom records that need to be extracted and provided to Inventive.
• Provide a list of all the PeopleSoft fields that are currently being used to store custom data for Confidential to Inventive.
• Conduct sessions with Inventive to provide an insight of on the custom fields and records and their usage within the system.
• Write the SQl’s for each table (being extracted) based on the business rules and the effective date determined to retrieve the data. In corporate Business Unit /Company /SETID logics to restrict data retrieval for only the Entities that moved to Inventive.
• Design the Customer and Vendor data retrieval logic around the Vendors and Customers listed in the Assignments in the Front Office module along with the Business Unit specifications to ensure the data is restricted to the specific entities.
• Design a template to capture the List of tables, relative SQL and Criteria based on which the data will be retrieved to track the data extraction tables and the extraction rules revolving around the same.
• Create SQL txt file In order to execute and extract the data in the database.

Environment: Itanium, Oracle 11g, PeopleSoft Financials 8.9, PeopleTools8.49

Confidential

Responsibilities:

• Manual Testing of Customizations and Business Process
• Review of all the setup and functionality for all the modules in order to test the application
• Review of third party applications and interfaces integrated with the system
• Involved in writing test scripts and executing the scripts for testing the Customized /delivered processes in all the modules across the Application.
• End-to-end testing of all the delivered processes per client requirements after 1st Pass.
• Functional testing of PeopleSoft delivered processes in AP, and GL Billing and AR Modules including Voucher Creation, Budget Check, Voucher Post, Pay Cycle, Payment Post, Journal entry, Edit and Posting Journals, Diners Voucher Upload process, RI-Online Group Upload etc
• Test and validate the Custom Rev Fact processes and reports to make sure the processes are working as expected in 9.1 version.
• Test the Project Costing to
• Test the Reopening of Closed assignments functionality
• Test the RI-Event request form functionality in order to make sure the integration between the Recruit Max application and PeopleSoft Application works fine.
• Bug fixing and issue resolution that occur during the testing phase

Environment: Itanium, Oracle 11g, PeopleSoft Financials 9.1, PeopleTools8.52

Confidential, California

Financial Functional Consultant/Business System Analyst

Responsibilities:

• Designed the Business Requirements gathering Security Matrix document in order to capture the Roles and User preferences required for the Users in France CSC.
• Coordinated with the Business Community to come up with the France Specific Security Roles design requirements.
• Design the Row Level Security required for the France Security
• Involved in Designing the Pay Cycle Security required for France CSC to come up with the right Pay cycle assignments to the Users.
• Define new roles and Permission Lists across AP, Gl, and worked with the PO and AM BSA’s to come up with the Roles for these modules based on the Business Functions.
• Creating Permission Lists, Roles and User Profiles based on the input received.
• Setup the User preferences for the Profiles based on the Security Matrix.
• Perform SIT across all the application to ensure right role assignments.
• Configuring the Process Groups to support ON-Demand processing.
• Defined Test Plan for the France CSC Deployment.
• Defined Test Scripts for various requirements like User Login validation, Pay Cycle Security, Row Level Security etc.
• Executed and Validated the Testing during the SIT
• Supported the UAT Testing during the implementation.

Confidential

Security Analyst

Responsibilities:

• Designed the Business Requirements gathering Security Matrix document in order to capture the Roles and User preferences required for the Users in France CSC.
• Coordinated with the Business Community to come up with the France Specific Security Roles design requirements.
• Design the Row Level Security required for the France Security
• Involved in Designing the Pay Cycle Security required for France CSC to come up with the right Pay cycle assignments to the Users.
• Designed the Security for the France CSC based on the input provided by the Users
• Define new roles and Permission Lists across AP, Gl, PO and AM modules based on the Business Functions.
• Creating Permission Lists, Roles and User Profiles based on the input received.
• Setup the User preferences for the Profiles based on the Security Matrix.
• Perform SIT across all the application to ensure right role assignments.
• Troubleshoot and support the incidents raised during the UAT to ensure smooth access to the application.

Confidential

Business System Analyst

Responsibilities:

• Define current process and To-Be process
• Define Confidential To-Be process
• Review impacted areas
• Define Assumptions, Constraints and Dependencies
• Testing: Scope, Methodology and Defect Prioritization
• Test Management - Entry and Exit Criteria
• Worked on supporting the PeopleSoft environments for various steams like Procure to pay and record to report for PeopleSoft 8.4 8.9 and 9.1 environments across various regions like Asia Pacific Europe and US locations.

Environment: Windows 2003/2008, Sun Solaris, Oracle 10g/11g, PeopleSoft Financials 8.4/9.1, PeopleTools8.48/8.51

Confidential, California

Functional Lead

Responsibilities:

• Thorough study and understanding of the client’s business processes in order to identify the basis for the Upgrade
• Review of all the setup and configurations for GL and AP modules
• Review of third party applications and interfaces integrated with the system
• Documented existed customizations like Journal entry Upload, AP Voucher Upload and Amex Vendor creation.
• Requirements gathering & preparing functional fit gap document
• Executing functional tasks in Change Assistant job
• Involved in the design and development of reports for GL, AP and PO modules using nVision and Crystal Reporting tools
• Involved in writing test scripts and executing the scripts for testing the delivered processes in AP and PO modules after
• End-to-end testing of all the delivered processes per client requirements after Upgrade.
• Functional testing of PeopleSoft delivered processes in AP, and GL modules including Voucher Creation, Budget Check, Voucher Post, Pay Cycle, Payment Post, Journal entry, Edit and Posting Journals, Allocations, Confidential JE Upload customization process etc
• Bug fixing and issue resolution that occur during the testing phase
• Training users on new system
• Setup Document Attachment functionality at Voucher entry and Journal entry levels
• Configured Journal Approval Workflow and Voucher Approval workflow with multiple Stages, Paths and Steps in order to trigger Approval workflow process at multiple levels.
• Configured ACH Process for the Business Units. Defined the Ach setup at various levels like Vendors, Bank setup, Pay cycles for ACH etc.
• Configure Prepayment Vouchers setups - Defining Prepaid Expense Account, Associate the prepaid expense account in the Template and Specify the Prepayment amount limits at the User profiles.
• Define Template Vouchers for the Business Requirements in AP.
• Customize Existing Queries to better assist the client requirements in various modules like AP and GL.
• Define new Time Spans, Calendars and nVision Layouts for Balance Sheet, revenue and expense reports by departments and Operating Units.
• Customize existing nVision reports by defining Scopes in order to retrieve reports for Multiple Business Units.
• Created New Queries for Voucher Unpost Activity, Unposted Journals activity, AP Outstanding Payments Activity.
• Customize Crystal reports in AP and GL and deploy the same.
• The client currently has Confidential JE Upload Customized Process which needed further enhancement to eliminate the current tedious process. As part of the Upgrade Enhancements, new functionality has been suggested to address the issues.
• Process - Created a Functional design document detailing the new modifications and enhancements to the current process.
• Provided a resolution to consolidate the 5 files and schedule to be uploaded into the system.
• User downloads the AMEX Files from the AMEX manually and then uploads the same into the system into a Customized page.
• On Uploading the same Chartfields are then manually entered into the Customized page before entering the same into the Voucher page.
• Suggested Process - In order to eliminate the Current tedious process, the whole process has been revamped and an Upload using the Quick Invoice Entry has been implemented at the client site.
• This helped the client to overcome the current double entry and also helped them upload the data entry directly into the Voucher pages.
• Upload the Amex file into the Quick Invoice Tables based on the Field mapping and thereafter runt eh Voucher build process to help move the data into the Voucher tables.
• Have been involved in the Asset Management Implementation Business Process Study, Requirements gathering, design process of the AM Implementation.
• Conduct Business Requirement gathering sessions with the client in order to understand the AM Requirements
• Create the Business Requirements document for the AM Implementation
• Come up with the Design document for the AM Implementation
• Troubleshooting issues in current system

Environment: Windows 2008/Linux, Oracle 11g, PeopleSoft Financials 9.1, PeopleTools 8.51

Confidential, California

Project Lead

Responsibilities:

• Understanding new business/user requirements, performing fit gap analysis with existing system for Contracts thru cost Process, Payments and General Ledger modules.
• Lead multiple teams composed of technology and business members to resolve Application issues and provided timely resolution.
• Preparing functional specs for the required customizations and application enhancements.
• Involved in the setup and configuration for Accounts Payable module in certain Locations.
• Preparing business process customization documents for Bill thru collect Process, Contracts to Billing process, GL processes and implementing them.
• Configuration of business units for various Modules like AP, AR, BI, GL and Contracts modules and other functional setups in the system based on the business requirements.
• Also to involve in the Application Strategies such as Keep track of changes in the PeopleSoft enterprise application and analyze the impacts on client’s financial systems and Assist with new implementations
• Co-ordinate with the technical team in developing new reports and customizations based on user requests and approval by VP Finance/ Corporate Controller.
• Maintain user security, Review user security and oracle user log with VP Finance and obtain approval quarterly
• Create and manage user profiles and row level security in the system.
• Provide real-time support and trouble-shooting for PeopleSoft application issues.
• Managing offshore team, technical and DBA task assignment and deliverables.
• Case management; preparing case logs and tracking pending issues in the system.
• People management; performing weekly meetings with offshore team, mentoring them and knowledge transfer.
• Responsible for updating foreign exchange rates
• Run Allocations, Troubleshoot Allocation Issues
• Run currency revaluations
• Run month end and year-end closing processes
• 1099 support, including efile
• Journal entry report for auditors at year end and each quarter
• Track changes and updates to PeopleSoft and analyze the impacts on Client financial systems
• Assist with new implementations, ongoing application development and enhancement
• Run month end and year-end closing processes, Journal entry report for auditors at year end and each quarter.
• Maintain Sarbanes-Oxley (SOX) compliance for PeopleSoft application and Oracle database at various stages of project execution like -
• Creating a new account when a new User needs to be setup in the system
• Deleting /disabling an account when the user leaves the company.
• Periodical security checks of the User Profiles within the system.
• Documenting every manual and automated procedure regarding security changes.
• Adhering to password change Procedures at both application and Database levels.
• PeopleSoft Functional Consulting Services - Data Mapping, Business Logic and Rules, Data Summarization, Data Extraction and Data Validation
• Setup review meetings with project team members, including business partners from APLA, Confidential and US regions and SAP project development team to arrive at the right extraction methods and extraction logics for data extraction .
• Provide input and recommendations to SAP development Team to improve the quality and assurance of the solution being developed.
• Design the Data extraction Templates based on the review analysis.
• Thorough Testing of all extraction routines and validation of all conversion data produced
• Multiple Test Cycles - Starting with small data samples to the full conversion required for cut-over
• Documentation and Knowledge Transfer to Confidential
• Created Functional Design documents for extracting Vendor Master, Customer Master data from the PeopleSoft system to be uploaded into SAP system.
• Have a 13 month year for 2007 for International BU’s. Modify the International BU calendar to be a 13 month calendar.
• Testing of the 13 month calendar
• Testing the solution for the Reversal Entries
• Modify/Correct reports and queries to accommodate the 13th period for 2007.
• Create reports and report requests to meet with the reporting requirements for the period of December 2007.
• Customize Future Revenue/Billing reports that needed to be fixed to accommodate the 13th period in 2007.
• Synchronize both the calendars so that all the Business Units could be reported for the same period of the time, January through December.
• Developed queries to upload data into Hyperion for overall consolidation.
• GL Module implementation and Customization of GL Reports
• Creation of Confidential Specific Business Units for various locations of Europe like Germany, France, Italy, UK, etc.
• Enabling the Document Sequencing for GL.
• Defining the Closing rules.
• Customizing the Accounting entry and the Journal Generator Templates.
• Uploading of Alternate Accounts to the Business Units.
• Functional Analysis of requirements and design of Business Specification Documents based on the analysis of business requirements and fit gap analysis for the Accounts Payable business process
• Design Documents for Importing Voucher information from the legacy system into PeopleSoft.
• Performed field level mapping and created Data Extraction Templates after discussing with Business Users.
• Act as a liaison between the business users and the technical team for the legacy data import.
• Created AP Business Units based on the Business Options defined in the requirement gathering.
• Defined Pay Cycles using various methods like Check, Wire, and EFT for various Business Units based on the Business Unit specific requirements.
• Set up Banks and defined payment formats for the Business Units as needed.
• Design and define the logic to populate the tax applicability and tax codes on the voucher line.
• Assist in Implementing VAT across Confidential business Units.
• Created Query based reports for Sales and Use tax
• Create detailed test plan for AP, GL, AR, BI and Contracts Modules.
• Conducting Functional and Integration Testing for interfaces developed.
• Review test scripts with business users and modify as needed to produce final script
• Conduct functional test, configuration test and system integration test
• Document all test results and review with users
• Assist users in User Acceptance Test phase and support them with troubleshooting, bug/fix etc.
• Security setup for all financial modules in Confidential application. Coordinating with the PeopleSoft Implementation team with regard to the existing customization in PS module processes and reports.
• Providing the Permission List security to Confidential business units
• Business Process Study specific to Security Implementation in the Confidential Region.
• Identification of related Roles and Permission Lists.
• Creating Permission Lists, Roles and User Profiles.
• Creating various Business Unit Permission Lists for APLA, Confidential and US.

Environment: Windows 2000/ Oracle 8i, PeopleSoft Financials 8.40 SP2, Tools 8.44.10

Confidential, California

Functional Analyst

Responsibilities:

• Trouble shoots Allocation issues to provide timely resolution for the same.
• Documenting the solutions on the cases resolved, in the Confidential Planet Share point
• Assisted in modifying the Existing Allocations in order to arrive at the new Allocation requirement.
• Provided assistance in troubleshooting various Allocation issues that were identified Post upgrade.

Environment: PeopleSoft FSCM 9.0, PeopleTools 8.49, Oracle 10g.

Confidential, California

Functional Tester

Responsibilities:

• Create detailed test plans for Procure to Pay, Record to Report, Order thru Cash, Bill thru cash Tracks.
• Create test scripts to test vanilla and client specific (customized) processes and features in Procure to Pay, Record to Report, Order thru Cash, Bill thru cash Tracks. Also perform testing on Project Costing, Treasury modules.
• Interview business users and IT to understand customizations, chartfields and combination values used for testing
• Review test scripts with business users and modify as needed to produce final script
• Conduct functional test, configuration test and system integration test for to Pay, Record to Report, Order thru Cash, and Bill thru cash Tracks.
• Document all test results and review with users
• Assist users in User Acceptance Test phase and support them with troubleshooting, bug/fix etc.

Environment: PeopleSoft Financials 8.4 SP2, PeopleTools 8.50.09, Windows 2003, DB2 9.7, AIX 6.1.

Confidential

Functional Consultant

Responsibilities:

• Reviewing and Designing of Functional Specs, explaining them to the development team and discuss with the concerned users, when necessary.
• PeopleSoft Functional Consulting Services - Data Mapping, Business Logic and Rules, Data Summarization, Data Extraction and Data Validation.
• Created Functional Design documents from the Legacy system to be uploaded into the PeopleSoft system for various Processes like Bill thru cash, Procure to Pay.
• Worked with the Application Software and client teams in understanding the business requirements and design of functional specification documents
• Involved in the design of high-level technical specification documents involving interfaces between the client’s legacy system and PeopleSoft Financials 8.8 Application (AP and PO modules)
• Involved in the design of vendor data processing from legacy system to PeopleSoft 8.8 Application
• Involved in the design for Invoice Processing, and Payment Processing
• Setting up of Customers and importing customer data from legacy system
• Involved in review of File Layouts for the Inbound / Outbound interfaces as per client specifications based on the mapping documents
• Involved in preparing detailed Record Layouts and IOG (Interface Operations Guide) for development of interfaces as per client specifications
• Involved in coordinating the remote development/testing activities, especially developing interfaces between the client’s legacy systems and PeopleSoft Financials Application v8.8
• Assisted the Technical users in the following areas -
• In developing an inbound interface for Agencies that desire to routinely add customers into Aspire.
• In developing inbound interface to load AR Payment Data into Payment table using Application Engine program
• Inbound interface to load Voucher Correction Data from various Agencies into Aspire using Component Interface, Application Engine and File Layouts
• Inbound interface to load Single Payment Voucher data from various Agencies into Aspire
• Inbound interface to load Payment / Cancellation data from various Agencies into Aspire and to create reversal vouchers
• Inbound interface to load Voucher Data from various Agencies into Aspire Payables using Application Engine and File Layouts
• Thorough Testing of all extraction routines and validation of all conversion data produced from the legacy system into PeopleSoft on various aspects like Journal Upload, Voucher enhancement validations, Invoice customizations.
• Multiple Test Cycles - Starting with small data samples to the full conversion required for cut-over
• Verifying the application functionality and report outputs.
• Providing the output results and feedback to the on-site team, coordinating with the development team in coming out with the resolutions
• Functional/Integration Testing on Procure to Pay, Record to Report and Treasury functionality and Load Testing of the online and batch processes using Load Runner for PeopleSoft Financials Application.
• Writing Test Scripts for interfaces developed between the Client’s legacy systems and PeopleSoft Financials 8.8 Application.
• Conducting Functional and Integration Testing for interfaces developed.
• Designed Commitment Control Ledgers based on the requirements.
• Load testing for online and batch processes using Load Runner.
• Managing the testing process using Test Director.
• Manual testing of customized functionality as per Client specifications

Environment: Windows 2000, Oracle 8i, PeopleSoft Financials 8.8, PeopleTools 8.45, Test Director, Load Runner