PROFFESSIONAL SUMMARY:

• Professional experience of 10+ years in development, Implementation and support of PeopleSoft 8.x/9.x HCM, Financial and Supply Chain Management module: Purchasing, e - Procurement, Commitment Control, Account Payables, Cash Management, General Ledger, Contracts, Project Costing, Asset Management, eSupplier, Billing, Grants, Accounts Receivables, Order Management, Inventory.
• Sound knowledge in enhancements and support of PeopleSoft FSCM 9.2/9.1/9.0 modules: Purchasing, e-Procurement, Account Payables, General Ledger, Asset Management, Billing, eSupplier, Accounts Receivables, Order Management, Inventory Commitment Control, Cash Management.
• Extensive experience in Requirements Gathering, Upgrade, Development, Conversion and Testing & Production support experience.
• Experience in PeopleSoft business processes mapping and in the day-to-day activities of ERP advisory engagements for various clients including process analysis and design, gap analysis, functional system design and specifications, system configuration, development of system tests, procedures, and documentation
• Experienced in preparing test documents such as Test Cases, Logs and Defect Reports, Requirement Design, Functional Design and Technical Design Documents.
• Expertise on Data mapping and Data Analysis between Legacy systems and PeopleSoft System.
• Expert experience with Peopletools 8.52,8.53, 8.54, 8.55,8.56 - Application Engine, People Code, Page Design, Database Process Scheduler, Data Mover, File Layout, Performance Monitoring, Application Designer, Workflow (AWE) and PeopleSoft Integration Tools EXCEL2CI, Component Interface, Integration Broker, PeopleSoft Fluid Framework.
• Expertise in using available PeopleSoft 9.1 & 9.2 Time and Labor rules and building new Time and Labor rules.
• End-to-End Implementations and Upgrades (9.0,9.1,9.2).
• Worked in the recent technology of PeopleSoft Fluid User Interface.
• Expertise in creating PeopleSoft Technical Design Documents as per the business requirements.
• Expertise in writing functional specifications for business requirements and test cases.
• Contributed my part in several stages of system life cycle, including defining business requirements, interviewing end users, development, testing, conversion, end-user and functional documentation.
• Expert with Reporting tools - SQR, Crystal Reports 8.x, PS Query, nVision, XML publisher, BI Publisher.
• Experience in Database - SQL Server, Oracle, SQL Base, MS-Access, DB2
• Sound knowledge on SQL Language Definitions i.e. DDL, DML and DQ.
• Excellent in Documentation, End-Users and Knowledge transfer
• Served as the key point of contact/Liaison between on and offshore resources
• Excellent oral/written communication and presentation skills
• Highly organized with the ability to manage multiple projects and meet deadlines
• Excellent Problem solving and Interpersonal skills. Has clear understanding of business procedures and ability to work as an individual and part of the team.

TECHNICAL SKILLS:

• Accounts Payable
• Accounts Receivable
• General Ledger
• Asset Management
• Cash Management
• Expenses
• Billing eSupplier
• Project Costing
• Supply Chain Management
• Order Management
• Inventory
• Purchasing
• Order to Cash
• Procure to Pay eProcurement
• PeopleSoft People Tools Experience (8.53/8.54/8.55 )
• People Code
• Application Designer
• PS Query
• XML/BI Publisher
• Application Engine
• Crystal Reports
• Component Interface
• SQR
• Process Scheduler
• Configuration Manager nVision
• Approval Workflow Engine (AWE)
• Excel to Component
• Interface
• Data Mover
• Application Package

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Environment: - PS 9.1, PT 8.52,8.54

Senior Techno Functional Consultant

Responsibilities:

• Worked as an Independent consultant to implement an Integrated- Bolton solution.
• Implemented multiple real-time interfaces between PeopleSoft and Salesforce using PeopleSoft Integration broker.
• Participated in requirement gathering session with functional team and business to understand the requirements.
• Build inbound interface to create Suppliers and Supplier Contracts using Web services, Application Engine, Component Interface, Application Package and Non-Rowset based messages.
• Supported PeopleSoft 9.2 Upgrade on (GL/AP/PO/EXP/AR) modules for the users across the country with both Functional and Technical issues.
• Implementation of Expense Module for Pew Research Center.
• Analyzed and modified PS Query, BI publisher reports for multi-currency requirements.
• Modified Application Engine to make sure all USD amounts are sent to third party.
• Developed a Payment file upload into Western Union for Multi-Currency Implementation.
• Responsible for Design, Coding and Unit testing before handling it over to Functional team for system Integration testing.
• Involved with various set up and configuration issues relating to Chart fields and Accounts.
• Designed and configured chart-fields and combo-edits.
• Hands on experience of simulated tools such as Handler Tester and SOAP UI to debug testing issues with Salesforce.
• Proficient at writing Test Plans and Test Strategies and strong working experience in PeopleSoft Test Framework and HP Quality Center.
• Responsible for migrating projects across the environments.
• Also retrofitted the same bolt-on in different tools version of Application Designer.
• Wrote various SQL queries for various operations on databases to accomplish user functionality.

Environment: PeopleSoft 9.2, Peopletools 8.54, SQL Developer, Accounts Payable, Accounts Receivable, General Ledger, Purchasing, Expenses, SOAP Web Services, Integration broker,Phire, Application Package, Application Engine, SQR, Application Designer, Crystal Reports, BI Publisher, SOAP UI, Component Interface.

Confidential, San Antonio, TX

Environment: PS 9.2

Senior Techno Functional Consultant

Responsibilities:

• Worked with a team of 5 people towards People soft upgrade of Finance 9.1 to Finance 9.2 patches/Bundles and applying fixes.
• Work with Business Analysts and Functional users to finalize the Business requirements and develop Functional and Technical Design Documentation.
• Customize functionality as per business requirements using People tools 8.55 (People Code, App Engine, Crystal reports, workflow, SQR, component interfaces, nVision, UNIX).
• Created and modified nVision, BI Publisher, Queries, Component Interfaces, Application Designer and Application Engine Programs.
• Responsible for system testing the financial systems, including AP, GL, and PO. Participated in system test and UAT. Prepared document for the use of Fluid in the new version of PeopleSoft 9.1 to 9.2 Upgrade.
• Gave support for end users to create reports using PS Query and nVision.
• Configured Guided Self-Service pages for Fluid Interface and Develop few Fluid UI pages as part of custom application enhancement for increased mobility.
• Delivered an assessment of current state and our options and recommendations for the leadership team. Role is specific to Treasury, Cash Management, Billing and Accounts Receivable modules.
• Configuring PeopleSoft Fluid Interface to work with multiple browsers/mobile devices
• Developed various reports in PS Query, SQR in various modules like Account Payables, O2C, Billing and GL.
• Designed the nVision report from scratch in General Ledger (GL) module for one of the GL month end processes.
• Resolved issues in Voucher Posting and Payment Posting (App Engine Processes).
• Developed Payroll to GL interface.
• Designed enhanced funds distribution feature in Project Costing that exceeds the functionality delivered in PeopleSoft v9.2.
• Involved in Integration of Peoplesoft Financials (AP/AR/AM/GL) modules.
• Used SQL queries for data setup and data verifications
• Responsible for change control management using STAT tool.
• Supported PeopleSoft 9.2 General Ledger, Accounts Payable, NA Payroll, Accounts Receivable, Asset Management, Purchasing, Inventory, Project Costing, eProcurement modules for the users across the country with both Functional and Technical issues.
• Developed a fresh CI for users to run SQL for correction of wrongly entered data.
• Responsible for change control management using STAT tool.
• Work with Finance group to develop/enhance vision reporting for the Month-end close process.
• Work with Functional teams/users to identify issues, provide resolutions and work arounds.
• Well versed SDLC (Software Development Life cycle) and PDLC (Project Development Life Cycle).
• Assisted in Fit and Gap Analysis, business requirement gathering, configuring the system, demo, test plans, resource allocation and issue allocation.

Confidential, Omaha, NE

Senior Techno Functional Consultant

Responsibilities:

• Act as a Liaison between different business groups.
• Extensively used People Tools, SQR, Integration Broker, Application Designer and Application Engine to develop various inbound/outbound interfaces and reports.
• Created various PeopleSoft pages, components and menus to run on-demands job related to various inquiry pages.
• Involved in Vendor Payment Tracking implementation project (Self Service eSupplier module to provide insights into payment status/PO/Compliance reporting/Bids).
• Work with team of Developers and Functional consultants.
• Resolved setup and configuration issues for Semi-Automatic Bank Reconciliation for Cash Management team.
• Trained the business leaders how to update the date tolerances on the recon rule’s engine. Once we enabled these changes, the wires and direct deposits reconciled using the automatic reconciliation. Huge time saving for our time strapped Cash Management team.
• Established Chart of Accounts accommodating local statutory reporting needs via Alt-Account functionality
• Configure Change Assistant for using PeopleSoft Update Manager (PUM) for People Tools
• Developed various prototypes and interfaces in Accounts Payable and Billing as per business requirements.
• Involved in Client Meetings for testing GL data loads based on various sources.
• Worked on merging of two Financial PeopleSoft Project version 8.8 and version 9.0 integration to new system PS V9 with complete chart of accounts redesign.
• Developed, modified and validated multi-currency nVision layouts and reports.
• Worked on allocations/Ledger copy processes from Maestro.
• Worked with enhanced 9.0 Spreadsheet Loader and Excel to CI utility.
• Worked in retrofitting application packages of expenses and Purchasing for workflows.
• Created custom job schedules and jobs definitions using Maestro tools.
• Maintenance and Support of PeopleSoft financial applications along with non-production activities in General Ledger module and Project Costing across multiple environments.
• Worked on COBOL, nVision and SQR related issues.
• Created new Application Engine to send CSV file to 3rd party. This file identifies employees terminated within the last 180 days.
• Designed and developed single Client feed which is the Fidelity interface for stock information.
• Created Bureau of Labor Statistics Report for Hourly Employees report using SQR. This report consists of hourly employees’ location, hours, wages, and gender data from various.
• Developed an Application Engine program to create Direct Deposit transmission files for the operating companies simultaneously.
• Customized SQL Views, records and People Code functions like SQL Exec, Scroll Select etc.
• Created a Positive Pay application in SQR to be a part Pay Final in Payroll run. This application performs the extraction of Positive Pay file from paycheck, pay calendar and pay distribution tables.
• Created an SQR extract that retrieves the employees’ information from 12 different tables and then send them over the gateway to mainframe part of the system.
• Created an Audit report in SQR that reports the changes made for any employees tracked by Audit tables for the main tables like job, personal data, employment, etc.
• Developed an outbound interface for generating Flexible Spending Account (FSA) deductions for the current pay period.

Confidential, Dallas, TX

Techno Functional Consultant - PeopleSoft Finance

Responsibilities:

• Worked on upgrading FSCM 9.0/9.1 using change assistant.
• Enhancement Lead for the team of 3 people in offshore.
• Applying patches, bundles or fixes updates using PUM.
• Responsible for customizing Billing, Accounts Receivable, Contracts, eProcurement, Expense, Accounts Payable, General Ledger and Time and Entry modules.
• Responsible for configuring and coding Approval work frame (AWE) for Accounts Payable and Expense.
• Worked with users on Multi Currency configuration for Accounts Payable, Asset Management, Order2Cash, General Ledger, Accounts Receivable and Expenses and helped users resolve issues related multicurrency.
• Managed a team of 3 technical developers in nVision/Crystal development of all reporting needs for a large utilities company.
• Key participant in PeopleSoft FSCM to offer comprehensive solutions to manage client's business processes requirements.
• Conducted global support and trouble shoot for PeopleSoft 9.1 Order Management application.
• Initiated strategy and implementing PeopleSoft (ERP) nVision report Deployment for 350 remote sites including integration of different systems and Business Process Reengineering.
• Responsible for automating report generation using various utilities like shell scripts or scheduling software.
• Participated in Hardware Planning and evaluation.
• Provided SQL tuning for several AM User Queries used for month end close analysis.
• Develop test plans/cases using Mercury quality center, Document BR (Business requirements), Perform UAT, Document failures and provide re-testing.
• Interfaced with different departments of the organization to identify their reporting needs both regulatory and internal.
• Interviewing consultants / Employees for the Client.
• Evaluated third party report deployment tools.
• Interfaced with users, Programmers to develop report needs for the end-users.

Confidential, New York City, NY

Technical Consultant - PeopleSoft Finance

Responsibilities:

• Worked on Accounts Payable, Purchasing, Asset Management and Expense in solving P1, P2, P3 and P4 in Purchasing, Asset Management, Expense Modules tickets.
• Developed an Enterprise Integration strategy for integrating SCM and Financial by Setting up the Gateway, Nodes, and Messages using Integration Broker.
• Implemented the AWE for requisitions for Purchasing module and Projects approval for Project Costing module
• Analysis, Design and Testing for the Time and Labor customization process using Microsoft Word to document the client requirements and the process flows, unit testing steps that are set and documented by the business in a Microsoft word document. Also, SQR (Structured Query Reporting), SQL (Structured Query Language) were used during testing.
• Involved in Conversion programs from End to End and fine-tuned many conversion programs.
• Involved in the Fit Gap Analysis in the beginning of the project and prepared the functional design documents for the Gaps.
• Used Accentual data stage to load the data from legacy system to PeopleSoft
• Created the new Crystal Reports as per the client requirement.
• Worked on QTP for the performance testing.
• Developed multiple inbound interfaces for below components in purchasing module using Component Interface, File layout
• Responsible for developing and customization of 9.1 Application for Time and Labor, NA Payroll.
• Integration of AM/AP to Time and Labor to enable the processing of time information and to generate payable time data that is subsequently loaded into Payroll for North America and third-party payroll interface.
• Analyzed and developed solutions to correct critical data issues by creating complex SQL updates.
• Worked on retrofitting and reapplying the customizations in 9.1.
• Designed the data conversion programs in Application Engine for data conversion from for Purchase Orders, Receipts and Items, Commitment control, Projects.
• Modified existing custom nVision reports.
• Involved in troubleshooting of Integration broker for integration of data.
• Involved in troubleshooting app engine program PO PO EMAIL.
• Developed new Workflow functionality for Change Order Approvals.

Confidential, DC

Technical Developer - PeopleSoft Finance

Responsibilities:

• Involved in Creation/Development and Customization of Tables, Views, Pages, Components and Menus using Application Designer.
• Developed several Queries for the Financial Reporting Purpose in Accounts Payable, Purchasing & General Ledger.
• Involved in setup like User Ps & Banking Information.
• Worked on Excel to Component Interface for the Vendor Upload Process.
• Involved in the design of Audit functionality to create various records and implemented effectively.
• Created various New SQR Reports and modified the existing SQRs as per the client requirement.
• Development, Documentation, Design & Unit Testing of Application Engine Programs for FSCM as part of enhancements.
• Developed different custom reports using SQR to meet user specifications.
• Read to records and writing to the files by using the Excel files and App Engine.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins and sub-queries.
• Used various normalization techniques for Database Normalization while temporarily administering the databases.

Confidential, New York, NY

Environment: PS 9.2, PT 8.54

PeopleSoft Techno Functional Consultant

Responsibilities:

• Worked on Accounts Project development
• Created New Pages/Screens - Accounts, Accounts Maintenance ownership.
• Worked on App Engine Process/SQR Report - Add New Accounts into COA tables, Accounts Process (Auto), GL Hash Report (Reconciliation between PS Ledger Balances and COA Balances)
• Supported Financial Modules (AP/AM/GL/PO)
• Worked on Converting Crystal Reports to Bi Publisher Reports. Created PSQUERY, Data Source, BI Publisher Template, Report Definition.
• Mapping of Chart of Accounts to Coupa from design point of view
• Developed multiple inbound interfaces for below components in purchasing module using Component Interface, File layout
• Used Integration Broker, Web Services and SOA to Integrate PeopleSoft Financials with third party services and publish the employee information from PS Financials to other application.

Environment: PeopleSoft 9.2, Peopletools 8.54, SQL Developer, Accounts Payable, Accounts Receivable, General Ledger, Purchasing, BI Publisher, Asset Management, Web Services, Integration broker, Application Package, Application Engine, SQR, Application Designer.

Confidential, Phoenix, AZ

Environment: PS9.2, PS 9.1, PT 8.55

PeopleSoft Upgrade and Analyst

Responsibilities:

• Supported PeopleSoft 9.2 Upgrade on (GL/AP/AM/PO/PC/AR) modules for the users across the country with both Functional and Technical issues.
• Worked on retrofit of various customizations such as Interface, extension and reports as part of PeopleSoft Finance (9.2).
• Defined Summary Ledger Chart-Fields to be used in Summary Ledgers for most commonly used Summary Reports.
• Worked with PeopleSoft Fluid UI in creating a completely responsive device independent design providing advanced user experience. Improve our UI delivery using Fluid Dashboards, Work centers, Activity Guides, Tile and Pagelet Wizards, Interactive content, Search tools.
• Worked on functional specs pertaining to customizing the e-supplier functionality.
• Have complete understanding of how suppliers acknowledge the PO, creates ASN and invoice using e-settlement self-service.
• Customized the new supplier user registration functionality to create an auto-numbered supplier user id.
• Well versed with the set ups related to buyer registration, supplier on boarding and automatic security roles for new supplier user.
• Maintained and created new Chart of Accounts values, Trees for reporting, allocations, and configured the system completely for a new GL BU.
• Assist business with configuration, enhancements and reporting for the PeopleSoft General Ledger and Commitment Control modules.
• Set up, configured new Peopletools version 8.55 features such as Fluid Technology (Fluid UI as the default), Navbar: Navigator (faster and context sensitive navigation), Tile Wizard, and PeopleSoft Cloud Architecture (PCA).
• Responsible for change control management using STAT tool.
• Worked closely with business stakeholders to understand requirements, prepare designs, perform configuration, coordinate testing, manage environment changes, and provide post-implementation support.
• Worked on COBOL, nVision, BI Publisher and SQR related issues.
• Worked on Performance tuning of Various Batch jobs (Application engines & SQR’s) issues related to GL, AP, AR after version upgrades like Average Daily balance, AR UPDATE, AR PGG1, Check Printing Issue.
• ESP Job Scheduler infrastructure setup, Job creations, Testing, Design, and troubleshooting.
• Responsible for Splunk Installation in PeopleSoft production Severs (Unix/Linux and Windows).
• Created the Reports and built the dashboards in Splunk to avoid manual intervention for certain tasks.
• Implemented Website and Infrastructure monitoring Apps Provided by Splunk for PeopleSoft Application where we can find Web traffic, CPU, Memory Utilization.
• Worked on Converting Crystal Checks to BI Publisher Checks, Customized BI Publisher Checks for bank Payments like Printing MICR, Authorization signature and check format.
• Worked on Various Customizations and integrations between PeopleSoft and third-Party Applications like PAS, TM1, Concur, Workday (Receive the employee details, Payroll transactions to load into GL from Workday and, we had an outbound integration to send Cost Center details from PeopleSoft), Ariba.
• Work closely with Treasury department to resolve issues and analyze bank accounts.
• Strong PeopleSoft GL module support (Maintain and update system configuration, including Chart of Accounts, chartfield setup/combo edits, business unit setup, multi-ledger and tree maintenance)
• Work with Functional teams/users to identify issues, provide resolutions and work arounds. wrote application engine to send the incremental GL activity from Peoplesoft to workday system
• Used SFTP Protocols to transfer files between Various Third-Party vendors.
• Involved in Planning of Peopletools Upgrade from .
• Used Zenoss Tool to monitor the Performance of Servers.

Environment: PeopleSoft 9.2, Peopletools 8.55,8.56, Fluid UI, Splunk, Oracle 11g, Accounts Payable, Accounts Receivable, General Ledger, Purchasing, Project Costing, Asset Management, BI Publisher, STAT,Web Services, Integration broker, Application Package, Application Engine, SQR, Application Designer.