More than 10 years of PeopleSoft Technical/Functional experience with major banking/brokerage/financial firms in NY/NJ area. More than 6 years of Peoplesoft Financials experience and 2+ years of implementation experience with Peoplesoft EPM. Around 4 years of consulting experience with a BIG 4 consulting firm. Worked on different versions of Peoplesoft Financials and EPM including 9, 8.8, 8.4, 8.0 and 7.5. More than 10 years of experience using ORACLE.
Peoplesoft Financials Technical experience:
More than 7 years of Peoplesoft FSCM development and production support experience involving GL/AP/AM/TR/TE/PO/AR/BI/PC modules. Extensive Peoplesoft development using App Designer in order to create app engines, peoplecode, pages, components, business processes and workflow. 8 years of experience creating and running Data Mover scripts. 10 years of experience creating queries using PS Query. More than 5 years of experience creating reports using reporting tools nVision, Crystal and SQR in all aspects of Peoplesoft Financials requirements. Created and maintained trees, tree tables and tree selector tables.
Also extensive experience in debugging, fixing and supporting applications and application processes using SQL, app engine traces, peoplecode traces, SQR and various other PeopleTools. Excellent knowledge of Peoplesoft Integration Broker, setting up gateway connectors, PS appserver messaging processes and Report node definition.

Peoplesoft EPM experience:
More than 2 years of PS EPM development and production support experience involving setting up EPM Warehouse processing such as setting up Record, Tablemap, and datamap metadata. Also setting up tree metadata and tree flattener records. Setting up data manager rules, rulesets, and jobstreams. Creating ETL maps using Informatica for loading data into Warehouse. Creating workflow and business processes for approval process. Also experience in setting up allocations and consolidations.
Peoplesoft Financials Functional:
Extensive PSGL and PSAP functional setup experience including BU, Setid, tableset sharing, journals, ledgers, summary ledgers, vouchers, pay cycle, check re-start and vendor. More than 6 years of experience in various PSAM and PSPO functions including asset functions, depreciation process, Purchase requisitions, RFQ, processing Purchase Orders and receiving shipments and integrating with AP. Extensive experience in customizing purchase order POPO005.sqr. Around 2 years of experience working in Travel & Expenses reports and expense processing. Also 2 years of experience working in Treasury involving banking and cash management functions.

Peoplesoft Upgrade/Admin experience
More than 2 years of Peoplesoft upgrade and administration experience. Experience upgrading Peoplesoft Financials from 7.5 to 8.0. Installing PS codesets, PIA components and creating the PS database. Installing and maintaining appservers, process schedulers and web servers. Upgrading using PS upgrade assistant from 8 to 8.8. Also using upgrade assistant to apply tools patches and various application service packs and bundles. Experience downloading patches and application bundles from PS Customer Connection site.

Performing day-to-day project migrations using Application designer. Extensive experience running compare reports between development and various environments. Also experience using STAT tool.

Client/Server Practice:
5+ years of experience in creating Client/Server applications using MS VISUAL BASIC, Oracle applications, ORACLE DB, MS SQL SERVER, SYBASE and DB2 UDB.

Education: B.E (Electronics & Communication)

Project Highlights:

Confidential, (Jan ’09 - Current), INDIA
Peoplesoft 9.0 FSCM Upgrade
Software: People Tools 8.49/Oracle10g, Windows Server 2003, Web logic 9.2
Install Peoplesoft FSCM 9.0/PeopleTools 8.49 and supporting on site and off shore peoplesoft development and production support for GL/AP/AM/PO. Being part of performing Fit-Gap analysis with the existing system and creating customization documents and user specifications. Also leading and performing the upgrade from Peoplesoft 8.4 to Peoplesoft 9. Unit testing and UAT testing the processes and reports. Creating new processes using SQR and App Engine. Creating nVision reports and tuning them for performance. Also created Crystal Reports using PS queries. Migration of PS objects and trees using Application Designer.
Creating PS users, roles and permission lists in the development environments and providing page security, component security, process security, query security and query trees for all PS users and developers.

Confidential,NY (Dec ‘06-Dec ‘08)

Software: PeopleTools 8.44/ORACLE 9.2.0.4, Solaris 8, Weblogic 6.1, Windows 2000

Worked as a PS Financials 8.8 production support primarily on the PS Treasury and T& E modules. Modifying treasury wire and bank transfer pages as per the Nomura requirements. Debugging SWIFT formatting related issues and updating the PMT_DISPATCH app engine related to EFT and bank transfers. Also supporting the message subscription peoplecode for bank statement loads and imports. Fixing issues related to automatic and manual bank reconciliation. Support T& E page issues and workflow issues. Worked on the expense report creations, modification and approvals. Customized T& E workflow to send e-mails to the submitter after the last approver has approved the expenses. Created app engine to send reminder e-mails to the submitter to submit any pending docs to the pre-pay auditors. Worked on many page and component related issues on Treasury and T& E.

Support GL issues related to journal creation using journal generator from various sources including T& E, AP, AM and Treasury modules. Supporting AP issues related to voucher and vendor maintenance, approvals, voucher posting, payment creation and payment posting. Creating nVision reports and queries using LEDGER. Setting up Report Explorer feature for GL nVision reports. Also worked on few AM Depreciation related issues and Project Costing issues.

Client: Confidential,NY (Jan \'04 Dec’ 06)
Project: Peoplesoft EPM/FIN 8.8 Implementation
Software: PeopleTools 8.42.13/ORACLE 9.2.0.4, Solaris 8, Weblogic 6.1, Windows 2000
Hardware: Sun Ultra
Loading journal and Ledger data from various GL sources into PS EPM. Setting up EPM Financial Warehouse processing using Record, Tablemap, and datamap metadata. Also setting up Tree metadata and Tree Flattener records. Also experience in setting up allocations and consolidations using data manager rules, rulesets, and jobstreams. Creating ETL maps using Informatica for loading data into Warehouse. Creating workflow and business processes for approval process. Writing App Engine and Peoplecode programs to load and validate inbound data into Warehouse tables. Assisting in writing reports using Crystal Reports.

Client: Confidential, NY (Dec’ 01 Dec’ 03)

Project: Confidential, (Dec\'02 - Nov03)
Software: PeopleTools 8.42/DB2 UDB 7.2, AIX 4.3.3 Weblogic 6.1/Websphere 4.0.3, Windows 2000
Hardware: IBM P660/P640, Compaq DL 380
Worked as an Upgrade specialist for a Peoplesoft 8 to 8.4 upgrade project for GL, AP and AM modules. Running compare reports between demo and upgrade databases using Application Designer, identifying customizations and re-applying them. Fixing App Engine, Peoplecode and SQR programs regarding the upgrade. Creating user specs for the system and user testing.
Performing upgrade cycle including fit-gap analysis, downloading the upgrade templates from customer connection, performing the upgrade using Upgrade Assistant for development and testing instances, assisting in various phases of testing and production upgrade.
Installing PeopleTools 8.42 patches and fixes for the upgrade. Installing and creating PeopleTools 8.42 appserver, webserver and process scheduler on UNIX and Win2K servers. Configuring PeopleBooks, Verity search engine using webserver. Administering and setting up 8.4 portal, security and content references. Setting up the new 8.4 event notification app server process PSRENSRV for online report distribution.

Project: Confidential, (Dec \'01 - Dec \'02)
Software: People Tools 8.14.10/DB2 UDB 7.2, AIX 4.3.3 Windows NT 4.0, Web logic 5.1
Hardware: IBM P660/P640, Compaq DL 380
Development and production support for GL/AP/AM/e-procurement including fine tuning PS Queries, nVision and SQR reports. Creating user specifications and setting up various batch interface processes including GL spreadsheet upload, positive pay/bony bank transmission using SQR and App Engine. Also setting up EDI Inbound map definition to load vouchers from external source such as TELDATA, CUSHMAN and WAKFIELD using EDI Manager. Performing fit-gap analysis for ADP interface to Peoplesoft, bank re-conciliation. Debugging vendor related issues and 1099 withholding process.

Debugging and fixing Peoplecode, Application Engine, SQR, nVision, Crystal and PSquery. Migration of PS objects and trees using Application Designer. Experience with AM in asset addition, retiring, transferring and depreciation. Experience creating Asset runoff/depreciation process and reporting. Working and reporting experience in Purchasing module including Purchase requisitions, RFQ, processing Purchase Orders and receiving shipments and integrating with AP. Extensive experience in customizing purchase order POPO005.sqr.
Creating database indices to improve performance of Peoplesoft reports and processes.
Performing Peoplesoft administration and maintenance activities for Peoplesoft 8.0 PIA architecture. Installing and maintaining Peoplesoft app servers, batch servers, weblogic, People Books, Verity search engine, Report Node Distribution for development and production instances. Downloading application patches for GL, AP, AM and e-procurement modules from Peoplesoft customer connection and applying using Application Designer. Identifying and raising cases with Peoplesoft for bugs and fixes, applying the patches, bundles and resolutions in both the development and production instances.

Project: Confidential,(Jul \'00 - Nov \'01)
Software: PeopleTools 8.14.10, ORACLE 8.1.3, Solaris 8, Weblogic 5.1, IIS, Windows NT/2000
Hardware: Sun E 6500 & Sun E 4500
Worked as a Support & Integration lead for Upgrade/Implementation of PeopleSoft Financials 8.0 Internet Architecture. Also involved in the conversion to ORACLE from Sybase database. Installation and administration of an EPM database. Installing Informatica Powermart 4.7.2, Hyperion Essbase 6.0 and supporting tools to extract data from Peoplesoft Financials to EPM database and produce various reports. Installation and administration of application server, process scheduler and UNIX web server, PIA, n-tier/2-tier, PVCS, Control-M server, Essbase server for Hyperion Replacement in various sites including New York, London and Asia-Pacific. Upgrading PeopleTools 8.12 to 8.13 and 8.13 to 8.14.10 using Upgrade Assistant. Experience using Data Mover and Import Manager for data migration.

Project: Confidential, (May \'99 - Jun \'00)
Software: PeopleTools 7.5, SYBASE 11, Solaris 7, Windows NT 4.0
Upgrading existing GL, AP, AM, Purchasing & Inventory modules from 7.0 to 7.5 and implementing AM, Purchasing & Inventory modules. Excellent experience of PeopleTools records and functional/transaction records in all modules. Updating statistics on Sybase tables for performance. Performing database backup. Implementing & Supporting Peoplesoft Financials 7.5 on Singapore, Australia and New Zealand sites.

Project: Confidential, (Jan \'99 - May \'99)
Software: PeopleTools 7.0, SYBASE 11, Solaris 7, Windows NT 4.0
Experience in AM module including Asset Addition, maintenance and Depreciation. Understanding various tables for asset management and processing asset addition, retiring, transferring and depreciation. Writing various specs and designs for reports and processes using Crystal and SQR. Working and reporting experience in purchasing module including requisitions, RFQ, processing purchase orders and receiving shipments and integrating with AP. Replaced existing AR system with Peoplesoft GL open item functionality and aging in Peoplesoft 7.5.

Project: Confidential, (Jun \'98 - Dec \'98)
Software: PeopleTools 7.0, SYBASE 11, Solaris 7, Windows NT 4.0
Guided reporting team to implement PeopleSoft 7.0 GL & AP. Extensive experience working with users, identifying requirements, writing report specs and design. Also creating reports using nVision, Crystal Reports, Peoplesoft Query and SQR for Peoplesoft 7.0 and SYBASE for GL and AP. Tuning nVision reports using Tree performance options. Writing drill-down queries and customizing nvsuser file.

Confidential, (Sep \'97 - May \'98)
Design, develop and implement HR/payroll system using VB/MS SQL Server. Developing front-end GUI screens and reports. Creating tables, views, indexes, triggers, and stored procedures.

Confidential, (May \'97- Sep \'97)
Design and develop Data Communications modeling system. Led a team to develop Data screens, reports and database objects using Visual Basic/ORACLE.

Confidential, (Dec \'96 - May \'97)
Supporting and maintaining Promissory notes system using VB and MS ACCESS. Creating data entry screens and reports to maintain ADB, loan statements and credits/debits.

Confidential, (Jun \'96 - Oct \'96)

Worked as a team lead for Automated Pawn system. Designed, developed and implemented a GUI based system using Visual basic and SQL Server. Collecting user requirements and designing Crystal reports

Confidential, India. (Jun \'95 - Jun \'96)
Designing, developing and implementing a Financials Accounting system, Inventory management system using VB, ORACLE and MS SQL Server. Writing front-end screens and complex querying screens with multiple options. Writing complex queries and writing crystal reports using stored procedures.

Hardware and Software Skills

PeopleSoft products: FSCM, EPM, HR, CRM
Peoplesoft versions: PeopleTools 8.8/8.42/8.10/7.5/7.0
PeopleTools: 8.4 Portal CREF security, Integration Broker, App Engine, PeopleCode, SQR, App Designer, EDI Manager, Data Mover, Informatica, Essbase/OLAP, Upgrade Assistant, nVision, Report Books, Import Manager, Process Scheduler Manager, Process Monitor, Tree Manager, PS Query, Crystal Reports, Cube Manager, Object Security, LDAP.
Hardware Sun Sparc & E series, RS/6000, HP-9000, IBM AIX 4.3.3, Solaris 8/7, HP-UX, Windows 2000/NT/98/95
Databases Oracle, DB2, Sybase and MS SQL Server