PROFESSIONAL SUMMARY:

• Over 7 years of IT experience with strong Functional experience in PeopleSoft with hands on experience in Requirement/Data Analysis, Fit/Gap Analysis, Customization, Upgrade, Testing, End User Training and Maintenance of PeopleSoft FSCM applications (9.0 and higher) for full life cycle implementations.
• Experience in Implementation, Application Support, Upgrade & Maintenance of PeopleSoft projects
• Experience in PeopleSoft Finance 9.2,9.0,8.9,8.8,8.7,8.0 etc. with the modules Accounts Payables, Purchasing, e - Procurement, Inventory, Accounts Receivables, Asset Management, Project Costing, and General Ledger.
• Excellent understanding of functional aspects of various finance and supply chain modules in PeopleSoft - Asset Management, Lease Administration, Accounts Payable, Purchasing, eProcurement, Inventory, Commitment Control(Budget), Billing, Project Costing, Accounts Receivable, Cash Management, Order Management, General Ledger and Integration with General Ledger.
• Extensive experience in GUI Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, and End to End Testing.
• Experience in Client interface to work as liaison at Client site includes requirements gathering, developing and implementing Software QA/Testing processes, programs and teams, working with business users and SME's.
• Excellent working knowledge of People Tools (including Application Designer, Application Engine, Workflow, building Integrations Broker, XML Publisher, Security, Import Manager, Data Mover, Process scheduler, Work Centers, Fluid, Change Assistance, PUM, Tree Manger, Query and all other People Tools)
• Technical experience in working with People Tools - Application Designer, Application Engine, People Code, Process Scheduler, PS Query, File Layout, Excel to CI, PeopleSoft Security.
• Served as a functional lead for finance/supply chain modules for PeopleSoft system upgrade from 9.1 to 9.2.
• Experience in cross platform integration of PeopleSoft with various legacy system (IBM Mainframe, Ariba, Maximo).
• Strong SQL skills, ability to write and execute advance SQL on Oracle and MySQL server database.
• Worked in PeopleSoft Finance modules like GL, AR, AP, Cash Management, SCM, Commitment Control, Allocations, Asset Management, Project Costing and PeopleSoft HRMS modules like HR, Benefits and having knowledge of G/L business process and financial reporting. Also knowledge of Contracts, Billing, and enterprise price with strong App Designer.
• Firm knowledge of different methodologies of SDLC including Agile and Waterfall.
• Strong knowledge in Test Automation - configured and developed automated test scripts in PeopleSoft Test Framework.
• Proficient at writing Test Plans and Test Strategies and strong working experience in HP Quality Center.
• Possess excellent SQL skills in various Database models - Oracle 11g/9i/8i, MS SQL Server 2008, DB2 8.1.
• Expertise on Data mapping and Data Analysis between Legacy systems and PeopleSoft System.
• Proficient in developing new Inbound and Outbound SQR Interfaces with or without mainframe JCLs that are well suited to the Business Requirements.
• Extensive experience on data mapping and conversion of data from legacy systems to PeopleSoft systems using Integration Broker, SQR, App Engine, Component Interfaces, and Excel-To-CI tools.

TECHNICAL SKILLS:

PeopleSoft Skills: People Tools 8.54 & lower, Financials/SCM 9.2, 9.1, 9.0, Enterprise Portal 9.1, CRM 9.2, 9.1, ELM 9.0, 9.1, Campus Solutions 9.0

Database: Oracle, MS-SQL, SQL Server 2008, IBM DB2

Programming: People Code, SQL, PL/SQL, Shell Scripting, SQR

People Tools: Configuration Manager, Application Designer

Microsoft Office Suite: MS Project, MS Excel, PowerPoint, MS Visio, MS SharePoint.

Reporting Tools: XML Publisher, SQR, PS Query, Data Stage ETL, BI Publisher.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Sr. PeopleSoft Financial Consultant

Responsibilities:

• Worked on upgrade of PeopleSoft AP & GL from 9.1 to 9.2 which include Fit-Gap analysis.
• Worked on Report Conversion process from SQR/Crystal to XML publisher in PeopleSoft 9.2 environment.
• Analyzed, gathered and documented requirements, conducted a fit/gap analysis of the business requirements against functionality, developed functional design, completed application configuration, and developed training material.
• Provided Production support for PeopleSoft finance modules (Accounts Payable, Accounts Receivable, Cash Management, General Ledger and Billing)
• Create Queries for PS Payroll 9.2 to reconcile data discrepancies between PeopleSoft\ Payroll and GL Interface data in JDE and SAP.
• Implemented application customizations based on fit-gap analysis and enhancements for Projects, Grants, Commitment Control Billing, Projects, AR, AP, AM, Travel & Expense, Contracts and GL modules.
• Worked on AP module and Customized the Journal Entry page, People Code in GL to store certain custom information. Customized the Ledger Inquiry and Journal Inquiry pages.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Worked on nVision and Customized and worked on the following Pages/processes in AR, Online Pending Item Entry, Regular Payments, Express Payments, Worksheet Application, Receivable Update process, Lockbox process and Payment Loader process.
• Developed several PeopleSoft queries to match receiving with contract and Purchase order.
• Loading data from external source to PeopleSoft using application engine and SQR.
• Design/Developed Hyperion feed for PeopleSoft chart fields and Ledger using store procedure and SQR.
• Tested GL Interface that loads data from various external systems into PeopleSoft General Ledger using SQR which includes implementing complex business rules like Combo Rules, subtotals on Business Unit level, grand totals, error handling procedures, printing multiple output reports and processed file report.
• Developed interface to load Customer data from PeopleSoft CRM System to PeopleSoft Financial using integration broker and application messaging.
• Developed various queries and reports in eProcurement, Purchasing, Billing and AP to provide the users with the data they need in their daily activities.
• Carried out Data Mapping between Legacy Systems and PeopleSoft Accounts Payable Tables from the legacy systems.
• Designed Unit Test Scripts for FX transactions within AP, Expenses, CM, and GL and extensively used PeopleSoft Query Manager to support users as requested.
• Strong in various SDLC methodologies, agile, waterfall frameworks and various tools like JIRA, HP Quality Center/ALM, Microsoft Project and Clarity PPM.

Confidential, Minneapolis, MN

PeopleSoft Functional Consultant

Responsibilities:

• Involved in full life cycle - from design to production support - of successful implementation of FSCM 9.1
• Worked on PeopleSoft Financials modules based on organizational needs and requirements. Co-ordinated between business and Technical team to create Functional design documents.
• Worked on FSCM 9.1 GL AM AP and PO People Tools 8.52.
• Analyzed requirements, developed technical specifications for development, interface, and report requirements.
• Analyzed, designed and documented technical design specifications to carry forward numerous custom objects and customizations to delivered AP Pages, PeopleCode, Records, Fields, Application Engine programs, database triggers, etc.
• Conducted fit gap sessions, requirement gathering, process optimization 'AS-IS and TO-BE' sessions, Prototype Use-Cases to focus on 'cradle to grave' business transactions
• Define application problem by conferring with clients; evaluating procedures and processes.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Interacted with the development team to report bugs and discuss the status of bugs in daily and weekly meetings with the testing team and team lead to discuss the progress of script development, execution and troubleshooting.
• Configuring Accounts Payables module (Procure to Pay Process), setting up Payment processing using Pay Cycle Manager, setting up EFT process and positive file process (for check payment).
• Participating in Fit Gap analysis sessions (Upgrade) of Asset Management, Accounts Payables, Purchasing, whereby, the current process was analyzed to be mapped to PeopleSoft and the design changes of the current process were suggested to customize the PeopleSoft environment
• Worked on Account Payable (AP), eProcurement, purchasing order, General Ledger and Involved on data and application integration components into a end-end interface solution and Requirements gathering for new Enhancements, Design and Unit Testing and Preparing Technical Design documents for enhancements in different modules.
• Worked on epro, purchasing order, Order to Cash process, Inventory, Purchasing and Oracle, Component Interface and Worked on following Pages/processes in BI: Online Bill Entry page, Billing Interface process, Load AP Pending Items process, and invoicing process.
• Developed custom Inquiry pages in the Admin module. Designed pages, built custom records, used People Code, PS query.
• Identified the existing customizations for PeopleCode, Asset Management, Order Management, Pages, Records, SQR Programs, Queries and other PeopleTools objects from the design documents and Application Engine to perform background processing against the data.

Confidential, Atlanta, GA

PeopleSoft Consultant

Responsibilities:

• Responsible for PeopleSoft architecture and technology on Implementation project for PeopleSoft HCM 9.0
• Performed fit gap analysis with the client to gain understanding of the current business process and recommending applicable PeopleSoft solutions based on decisions and discussions with upper management.
• Provided end user support for PeopleSoft FSCM phases including troubleshooting of issues, use of the application functionality and training of specific functionality in support of job functions.
• Worked on end to end life cycles of AP and GL like Requisition to-PO-to- voucher- to- journal edit and journal posting.
• Drafted Requirements Documentation (Scope Document, Use Cases, Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs) and User Interface Documents).
• Proficient in performing fit gap analysis, assessment, documentation, User interaction, estimation, maintenance and testing in PeopleSoft financials 9.0
• Proficient at writing Test Plans and Test Strategies and strong working experience in PeopleSoft Test Framework and HP Quality Center.
• Designed all enhancements for the PeopleSoft Financial online and reporting systems including new SQR programs and enhancements to delivered SQR programs.
• Developed reporting and data migration solutions on PeopleTools 8.52 using SQR, Application Engine and Component Interface
• Created Use cases, Use Case Diagram, Business flow diagram, Work and Navigation flow diagram using Unified modeling language (UML).
• Created Requirement Traceability Matrix (RTM) to map requirements and test scripts based on the business rules and functional requirements.
• Worked with Application Engines, File Layout, Component Interface and People Code for loading the data in to PeopleSoft system.
• Providing support to GL, MSS, Chart Field Interfaces to integrate PeopleSoft HR with PeopleSoft Finance Systems. PeopleSoft Production support for Finance & Accounting and SCM.
• Wrote functional requirements and non-functional requirements based upon the approved business requirements by following UML processes and standard procedures for developing use cases, use case diagrams, and other supporting documentation.
• Data Conversions from legacy system to PeopleSoft for Active assets in Asset Management, Trial Balance data in General Ledger, Project Costing Projects with the transaction data, Vendors, Inventory Items data.
• Maintained PeopleSoft user security using PeopleSoft Security Administrator by configuring the appropriate Permission Lists, Query Roles, Tree Manager and User Profiles.
• Development of new Reports in Project Costing viz. Project Analysis reports, Trial Balance reports in General Ledger both Accounts and Alternate Accounts wise using nVision, New Zealand specific GST report using Crystal report
• Successfully Reconciled the converted data in PeopleSoft with Legacy data by means of writing SQL scripts in PeopleSoft, using PS delivered reports and matching them with extracted reports from legacy system.

Confidential, New York, NY

PeopleSoft Analyst

Responsibilities:

• Worked on AP, Purchasing, AM and Expense in solving P1, P2, P3 and P4 in PO, AP, AM, Expense Modules tickets.
• Gathered user requirements from the Business users to configure the system to meet user needs and preferences.
• Prepared the technical & functional design for enhancements/customizations PeopleSoft Financials GL, BI & AP 8.9.
• Created AS-IS Business Process Flow and TO-BE PeopleSoft flows which incorporated Finance.
• Gained thorough knowledge/understanding of Accounts Payable, customized Pay Cycle Manager process- Payment selection and Payment Selection & creation processes.
• Identified and developed test scripts for custom and delivered functionalities and processes in Asset Management, Lease Administration, Inventory, Purchasing and eProcurement modules.
• Used Application Engine, People Code and SQR extensively to create processes, outbound files and reports.
• Worked in creating Leave without pay, leave taken, Project wise and department wise Leave related SQR reports.
• Involved in various phases of this project such as analysis, design, development, Data Conversion Scripts using SQR & SQL Scripts, unit testing, devising string and integration testing, performance tuning of on-line and batch application.
• Performance tuned SQL, SQR & PeopleSoft programs using Application packages.
• Performed data conversions, report writing, report customizations, page customizations and People Code programming.
• Retrofitting and customizing interfaces and conversions programs written in SQR, Application Engine and Component Interface.
• Involved in customizations in PeopleSoft Project costing using PeopleCode, PeopleTools, Workflow, component interface to develop a unified system
• Developed numerous custom complex reports in AP, PO, AR, INV, OM, AM, GL using Crystal reports, nVision, SQR, XML Publisher and PS Query.
• Develop, build and manage Reporting Services (SSRS) reports using both SSAS cube and relational database sources including distribution of reports using subscription services
• Established a GL business unit and ledger, GL calendar, journal sources, and accounting entry templates to transfer journals from Asset Management to GL.
• Worked in all phases of test cycle including test estimation, test planning, test designing, scripting, execution and identifying/ reporting defects.