Professional Overview

• Over 15 years of strong technical and functional experience. For the last twelve years, I have been working with PeopleSoft Financials and HCM. I have extensive experience in upgrades, patch/bundle applications, migrations, implementations, conversions, interfaces, customizations, testing, tuning and product support. I have created instances, built application servers, process scheduler and web servers. I have participated in all major phases of project development including requirement gathering, analysis, functional design, technical design, development, testing, deployment and production support for multi-national clients.
• Prior to PeopleSoft, I designed and administered data centers with IBM's midrange AS/400, Novell Network and their WAN. I handled hardware capacity/resource management, implemented and supported packages like General Ledger, Purchasing, Accounts Payable, Fixed Assets, Warehouse, Payroll, Benefits and Account Receivable on AS/400 platform.
• PeopleSoft Applications: Project Costing, Contracts, Travel and Expense, Accounts Payable, Asset Management, Budgets, ePro, General Ledger, Inventory, Purchasing, Grants, HR, Payroll, T L and Benefits.
• PeopleSoft Technical Skills: PeopleSoft Search Framework, Informatica ETL, PS Application Designer, Application Engine, Web Services, Application Messaging, Integration Broker, Component Interface, XML Publisher, Crystal Reports, Data Mover, PeopleCode, Application Class, PS Query, Pagelets, Process Scheduler , Security Administration, SQL, SQR, Tree Manager, PeopleSoft Troubleshooting Tools, Upgrade Assistant, PeopleSoft Workflow.

Experience

Confidential

• Installed PeopleSoft PIA Architecture components with Tools 8.53 on Linux Red Hat.
• Installing PeopleSoft Finance 9.2
• Implementing search engine using Oracle Secure Enterprise Search SES ver 11.1.2.2.0
• Implementing PeopleSoft Search Framework and testing integration between PIA and SES.
• Creating Connected Queries and Queries for creating Source Definitions.
• Deploying Source Definitions and Source Categories, scheduling indexing and crawler. Use Search Framework Administration to interface between SES and PIA using Integration Broker
• Debugging delivered Application Packages and fixing the PeopleCode.

PeopleSoft Senior Analyst

Confidential

• Assisted in developing high level Integrated Systems and Business Process Flow diagram to illustrate the current and future systems and it's processes. It involved twelve sub-ledgers, three ledgers, two data warehouses systems, two reconciliation and analytical systems, and the feeds to the reporting tools Essbase Cube and Business Objects . Three different feed types were involved Movements, Inventory and HO Feeds .
• Created detail technical documents and Visio process flow diagrams for the existing systems. This involved analyzing numerous scripts Perl, Shell , programs C/C and stored procedures.
• Based on NY and Paris Head Office requirements, designed a new application called Trans-Codification Layer TCL . The application homogenizes, transforms and enriches the Movements Feeds. It, then, applies various accounting treatments e.g. FX-Treatment, Auto-Balancing, 999-Split and file creation and creates balanced journal entry for PeopleSoft GL Matisse System .
• Performed a Fit-Gap analysis on the proposed TCL system. Created data for Matisse Feeds from the existing production system data to demonstrate the fits and gaps.
• For TCL, helped to design and develop specs for the repository and mapping table architecture. This involved numerous teleconferencing and F2F meeting with Paris and NY user.
• Wrote Technical Specs for the new Movements Feeds coming from twelve sub-ledger systems, keeping the development efforts to a minimum.
• Assisted in creating grouping of the sub-ledgers into four perimeters. This was done to establish the functional requirements of various data elements by perimeter level rather than at sub-ledger level.
• Developed Functional Specs to convert existing Inventory Feeds to handle new Regulatory Reporter Feed.
• Created and delivered Technical Specs for the Accounting Treatments. The core process was developed using Sybase ASE stored procedures.
• Built Sybase ASE stored procedures for data manipulation and developed parsers in Perl for data extraction from existing report.
• Designed and developed Informatica ETL for the data archival system to transfer data from the Sybase ASE to Sybase IQ.
• Designed and developed Manual Accounting Templates for four perimeter using Excel Macros. Used ADO technology for database connectivity with Sybase ASE.
• Involved in the full end to end testing cycle for all the systems and rendered 24x7 production support.

PeopleSoft Analyst/Senior Developer

Confidential

• Resolving performance issues for processes.
• Building new pages using PeopleTools for home grown application.
• Build Application Engine programs for automation of clean up process.
• Build Application Engine program to create flat file from PeopleSoft Trees.

PeopleSoft Functional Consultant

Confidential

• Participated in the meetings with the business users on the requirements revisits and revised business requirement documents.
• Involved in setups and functional configurations.
• Created Functional design documents and assisted the team with the functional testing processes.
• Created the SIT test plan, test scripts and assisted the team in executing the test scripts and capturing the test results.
• Created the Defect reports and managed the defect reductions.
• Worked with the users for the UAT test phase and led the UAT test sessions.
• Assisted the users with the UAT test plan.
• Create BRD's for the financial business processes.

PeopleSoft Sr.Functional Consultant

Confidential

• Created Functional design documents and assisted the team with the functional testing processes.
• Created the SIT test plan, test scripts and assisted the team in executing the test scripts and capturing the test results.
• Modified the BRDs based on the UAT test phase results and coordinated with the technical team on the defects, corrections to the programs.
• Worked with the users for the UAT test phase.
• Assisted and coordinated with the users with the UAT test plan.
• Involved in the performance testing using Mercury tool.
• Involved in the regression testing.
• Executed the test scripts and captured the test results.
• Analyzed bugs and reported to the technical team for the corrections.

PeopleSoft Functional Consultant

Confidential

• Worked on customizations and acted as a liaison between technical team, quality team and business team.
• Created functional design documents and BRDs for the new customizations.
• Coordinated with the technical team on the design and development.
• Created test plans, test scripts and executed test cases.
• Analyzed bugs in the customizations and coordinated with the technical team for the resolutions.
• Suggested process improvements, facilitated automation efforts.
• AP /EX /ePro/PO, Expense Subject Matter Expert on PeopleSoft 9.1 Implementations.
• Design the BRD documents, fit-gap analysis, suggest process improvements, facilitated the process automation efforts.
• Functionality support for the Implementation, post-production activities for the PeopleSoft Financials systems.

Confidential

PeopleSoft Techno-Functional Analyst

• Windows and IBM AIX.
• ComponentInterface, SQL, SQR, Crystal Reports, Oracle 10g,
• Application Engine, Integration Broker, Application Messaging,
• Environment: PeopleSoft FSCM9.0, People Tools 8.51, People Code,
• Conducted Fit-Gap analysis of ePro, Purchasing and Inventory modules.
• Worked with Users, Application Owners, Managers, and team to draw up specifications and gather requirements for PeopleSoft FSCM PO, Inventory, ePro, GL, AP, AR .
• Implemented ePro, Purchasing, Inventory for a multi-business units and multi-currency.
• Assisted in streamlining the SCM process as per requirements and anticipated deliverables.
• Supported inventory items procurement and fulfillment for 36 panels in both Americas and EMEA.
• Designed, Developed and supported custom ePro workflows as per business needs.
• Involved in several customization on-line, batch programs using people code, sqr, crystal and App engine.
• Implemented and customized Dunning letters in AR for multi country and multi-language using different formats.
• Developed several reports and queries to assist business needs.
• Production support and Training for a 500 user base.
• Integrated ePro with AP, AM.
• Designed and developed custom Interfaces in inventory for inventory fulfillment and non-inventory based receipts coming from external systems.
• Used excel to CI to item conversion, add new vendors and voucher upload.
• Support and maintain items, item catalogs and categories.
• Support Finance users during month end close by clearing all inventory issues and provide assistance in reconciling inventory to GL accounts.
• Designed and Developed custom Receipt Accrual program as business needs.

Confidential

ERP Specialist/ SCM Techno-FunctionalLead

• Ware house Advantage, AtPar, SCL, Windows and IBM AIX
• ComponentInterface, SQL, SQR, Crystal Reports, Oracle 10g, High Jump
• Application Engine, Integration Broker, Application Messaging,
• Environment: PeopleSoft FSCM9.1, People Tools 8.50, People Code,
• Conducted Fit-Gap analysis of ePro, Purchasing and Inventory modules.
• Redesigned process flow for Inventory, Purchasing, and Receiving.
• Configured Receiving functionality in Purchasing.
• Configuredand setup Securityfor Inventory and Purchasing.
• Coordinated all Development efforts to create customizations and resolve any issues which came up during System test and User acceptance testing.
• Facilitated meetings with SCM team members to identify business requirements.
• Written test scripts to help test scm module during different phases of implementation.
• Co-ordinated testing with users and record results and reported back to management.
• Trained around 40 users all aspects of inventory and purchasing/receiving module
• order fulfillment,replenishments, item maintanence,b2b transfers, adjustments, cycle count, physical counting, recon, receipts, putaway,RTV's, and basic PeopleSoft skills .
• Implemented and supported AtPar handheld devices for UT hospitals for their cart replenishments.
• Recommended configuration design changes as required.
• Re-design and enhance overall business process related to Receiving to SCL interface and reporting.
• Did item conversion item/vendor/purchasing attributes to peoplesoft from legacy system.
• Created custom CI's to load on-hand balances into peoplesoft from legacy system
• Created BPR work books on conversion and reconciliation from legacy system to peoplesoft.
• Modify SQR programs to improve performance and meet requirements of business process re-design ins6000, porc920, inordrls, ins9090, ins7000 .
• Created BPR Work books to help business understand Peoplesoft inventory, purchasing
• Designed, Developed, tested and implemented custom interface between receipts to SCL third party app to keep track of proof of delivery
• Designed, created and modified reports to help business come up with their metrics.
• Created several sql scripts to monitor business for go-live and debug issues.