Objective

• I have 9 plus years of extensive experience as PeopleSoft Financials & HRMS Consultant for IT, Pharmaceutical, Government, Insurance, Retail and Finance industries.
• I’m seeking to work in a challenging position where I can employ my knowledge, skills and creativity to achieve mutually rewarding growth.

SUMMARY

• 8 and half years of experience in PeopleSoft Financial implementations, Customizations, Upgrades and Production Support as a technical consultant involving hands on experience in Application Designer, PeopleCode, Application Engine, Process Scheduler, Component Interface, Integration Broker, AWE Workflow, PS Query, cXML, Punchouts, Crystal Report, nVisions and BI Publisher.
• Designed and developed customizations in core financial modules of PeopleSoft like Purchasing, eProcurement, Project Costing, Contracts, General Ledger, Billing, Travel &Expenses and Account Receivables.
• Expertise in providing functional and technical support to the P2P Team (AP, PO, ePro and INV modules), including but not limited to leading and assisting with the requirements gathering, fit - gap analyses, conference room pilots, functional and technical designs, configuration design, system configuration, test plans and scripts, testing, report creation and documentation using RICEFW standards and applying Accenture methodologies, during an Agency-wide consolidation of multiple legacy systems to a large, single PeopleSoft FSCM and HCM 9.0 system .
• Proficiency as functional consultant in FSCM Modules: Project Costing, Contracts, Travel & Expenses, General Ledger, Account Receivables, Billing, Purchasing and ePRO.
• 1 year of experience supporting HCM modules: Workforce Administration, Time and Labor, Leave Administration and iLearn . Also worked on supporting the flow of data between Time and Labor to Project Costing and vice-versa via Integration Broker.
• Worked on implementation phase which included installation of hardware and software, configuration of Application server and PIA and tuning of the PeopleSoft environment. PeopleSoft components such as Web server, Application server, Integration broker and Process scheduler were configured. Performance monitoring was done during testing phase in order to identify problem areas and tune the system accordingly. Additional monitoring scripts were setup to monitor and notify on critical system events.
• As a Technical Architect involved in implementation of core financial modules which involves responsibilities like performing FIT GAP analysis, Creating design documents and coordinating with technical team to get the customizations developed.
• Experience in managing/leading Onshore-Offshore projects.
• Experience in PS Upgrades including Bundle Upgrades. Worked on upgrading ESA applications from Bundle 9 to Bundle 32 in PS 8.9. Also worked on application upgrade of PS SCM and ESA from 8.9 to 9.1 involving the database upgrade from 10 G to 11 G.
• Extensive experience in PS Reporting Tools like PS Query, SQR Reports, NVision Reports, Crystal Reports and BI Publisher.
• Proficient in debugging and analyzing online and application servers’ logs and traces. Hands on experience in tracing application engines, online pages, components, integration broker messages and application packages in order to debug issues.
• Proficient in performance improvements for NVision reports, application engines and SQRs. Worked on with the PS Admins in fine tuning of high cost SQLs in terms of adding hints and indexes to reduce the processor load. Also worked on setting the optimization parameters at the database level to improve performance. Also, worked on minimizing the load on Process scheduler for the long running reports and processes and developed new interfaces catered to a broader and wider user set. Extensive experience in working with Oracle Database Analysts to address the database level inconsistencies in running same/similar processes.
• Experience in working on STAT tool for managing Project and PS objects.
• 4 years of experience of supporting end to end Month end/Quarter End/Year End close cycles of GL and other subsystem modules like Project Costing, Contracts, Billing, Accounts Receivables and Travel Expenses from Day - 5 to Day + 5. Also experienced in working on the job schedules for the sub system modules to be in sync with the respective close dates.
• Experience in working with ESB tools like TIBCO to interact with PeopleSoft applications via Custom developed Integration Broker messages being called from Custom Application Engine processes.
• Experience in working on Control M to schedule jobs and processes in PeopleSoft to eliminate the inconsistency of the PeopleSoft Scheduled Jobsets.
• Created application engines to provide the data feed for OBIEE. Also, worked with the OBIEE team to move the long running reports to Data Warehousing.
• Created custom load files for the Balance Sheet and Revenue Reporting for Hyperion.

TECHNICAL SKILLS

Peoplesoft: PeopleSoft Financials (FIN) 8.x,9.0, 9.1/8.51, PeopleCode, PeopleTools SQR, Application Engine, Component Interface, Tree Manager, Data Mover, Application Messaging, Punch Outs, Crystal reports, BI Publisher, Microsoft Office Suite, MS Project, Visio, QuickBooks

RDBMS: Oracle Server V 8.x, /8i, 9.2.0.7, 11g, SQL, PL/SQL, SQL*Loader

Web Severs: Web Logic 5.1/6.1 SP9/8.1 SP5, Apache, Microsoft IIS 4.0

GUI: HTML,DHTML,JavaScript

Tools: & Utilities: XML Spy,Crystal Reports,PS Query,Ultra Edit

Operating Systems: Solaris 2.6/2.8/2.9, HP UX 10.x & 11.x and IBM AIX 4.3x, Windows 2003/2000

PROFESSIONAL EXPERIENCE

Confidential, NYC

Senior PeopleSoft Techno Functional Consultant

Environment: Win 9x/2000/XP/2003

Responsibilities:

• Developed new EIPs between the Finance and HR system.
• Performed performance tuning for Buyer’s Workbench in Purchasing to improve the processing time in Cancel/Close PO’s from timing out to less than 3 minutes for over 3000 POs.
• Fixed multiple PO rollover issues, where the rolled amount was incorrect for a voucher associated with multiple POs.
• Worked with Oracle on fixing multiple issues in FS BP(Commitment Control) around performance, hyperion and BO integration with budgeting that have been released between Bundle 14 and 23 in PS Financials 9.1
• Supported that the AP MATCH issues in the mock year close environments.

Confidential, NJ

Technical Architect

Environment: Win 9x/2000/XP/2003

Responsibilities:

• Ongoing support of the end to end Procure to Pay cycle.
• Worked on setting up Direct connect, Approval Workflow for ePro requisition and tuning the procure-to-pay system.
• Designed/Developed/Configured the synchronous and asynchronous messaging between HCM and Financials using the Integration Broker.
• Developed 15 different rowset and query based reports using XML Publisher.
• Designed and assisted in the development, configuration and testing of a flexible, custom Application Package based Voucher Approval Workflow program, with multiple approver levels, email notifications, worklist updates and ad hoc approver/reviewer insertion capability, leveraging the delivered PO Requisition Approval Workflow Engine (AWE).
• Support of Peoplesoft Project Costing Module for 25 business units. Performed a detailed analysis of business unit set up, project creation and integration.
• Actively involved in implementation and set up of Travel & Expenses and Billing modules.
• 24/7 Support for General Ledger and Customer Contracts.
• Developed a custom interface to integrate the Image Now solution with T&E and trigger the Approval Workflow only upon the receipt receiving in EX SHEET HDR
• Developed Application Eng Program to create flat file from External party for GL Import
• Monitor GL delivered Batch processes, external interfaces and custom processes including the Reuters Daily Rate load.
• Developed Application Engine to transfer daily posted journal data to 3rd party system(CMS)
• Migrated the Crystal Reports in Billing to BI Publisher
• Requirement Analysis and design as part of new interfaces into GL
• Designed SQR reports, PS Queries and XML Reports based on User requests.
• Unit testing of applications.
• Control M set up of the batch schedule year on year for the full year for Scheduled processes and jobs.

Confidential, Washington DC

Technical Architect

Environment: Win 9x/2000/XP/2003

Responsibilities:

• As a lead architect for this implementation did a Fit-Gap analysis on the current IMF Business process
• For Phase 1 of the Bundle Upgrade, went through the release notes from Oracle to identify the major scope changes for Project Costing, AR, GL and Customer Contracts
• Created the Project Plan for the Bundle Upgrade for PS 8.9 from Bundle 9 to 32.
• Performed the Retro fit analysis for the existing customizations for IMF
• Individually implemented and tested the retrofitting with the upgraded bundles.
• For Phase 2, along with the tasks from the Phase 1 did another fit gap analysis to highlight the functionality changes that needed to be addressed as a part of the Upgrade to 9.1.
• Solely responsible for the performance improvements in Billing Interface, Post Liabilities and Post Payments in TE, and nVisions for General Ledger
• Actively worked with DBAs and PS Admins for database level improvements in Application Engines and nVisions.
• Also worked on the integration with the Upgraded ImageNow and Travel and Expenses
• Also performed the HR Finance Full Sync post upgrade to ensure the Updated Job Data for Travel and Expense creation.

Confidential, Washington DC

Technical Architect

Environment: Win 9x/2000/XP/2003

Responsibilities:

• Involved in performing Fit-Gap Analysis and came up with a plan to work on the high priority and critical issues and stabilize the support of Billing, Purchasing, EProcurement, Inventory
• Ongoing support for the Billing Interface(BIIF0001) for the transactions coming from Contracts, and the 3rd party systems via Project Costing.
• Customizing the invoicing crystal reports for the ever changing client addresses, details etc.
• Support for the complete invoicing cycle - from creating the proforma mockup, finalizing the invoice(BIIVC000), running the currency conversion(BICURCNV),applying the chart field inheritance by running the preload process(BIPRELD), loading the pending AR entries(BILDAR01), GL accounting entries(BILDGL01) and generating AP vouchers(BIGNAP01)
• Discussions with business users to gather functional requirements for the ongoing enhancements.
• Created technical specs for the enhancements and followed the change control processes established to get the documents signed off.
• Support for PeopleSoft eProcurement and PeopleSoft Purchasing modules which was closely integrated to enable the sharing of common control data, such as item definitions for both PO and ePro. This included the support for the requisition creation to sourcing and creation of the Purchase Orders.
• Set up and daily the batch schedule for PO AUTO SRC across the various Business Units in Confidential .

Confidential, NYC

Technical Architect

Environment: Win 9x/2000/XP/2003

Responsibilities:

• As a lead architect for this implementation did a Fit-Gap analysis on the current AXA Business process
• HRMS Archival Solution - Over 20 Gb of Benefits and Payroll Transactional was archived.
• Designed, developed and implemented the PS Archival Solution for NA Payroll and Benefits
• The Archival Solution consisted of development of SQRs for archival and on need basis the option for Restore.
• It also consisted of the development of Rearchival pages and the corresponding SQRs for Payroll and Benefits respectively, to rearchive the restored employee data.
• An additional feature provided to the Client was - the ‘Error Handler’. The error handler was to revert the committed transaction in case of an incomplete transaction or the un archival of a successful archival for a particular year.
• Fine Tuning of SQRs - the SQRs were performance tuned to archive the Benefits Transactional data for one year in less than 10 minutes, and the huge amounts of Payroll Transactional data for 1 year in 25 minutes.
• Different rounds of Testing
• Post Implementation Support for the new development.
• Involved in creating permission lists, users, roles and assigned roles to users (Maintain Security).

Confidential

Technical Consultant

Environment: Win 9x/2000/XP/2003

Responsibilities:

• Production Support of Workforce Administration including the support of Integration Broker
• Production Support of Time and Labor, iLearn
• Also involved the support for Confidential ’s in house customization for implementation of Leave.
• Involved in solving the user issues that were raised via a ticket tracking tool Remedy within the defined SLAs.
• Customizations to the existing system with detailed documentation on the functional and technical aspect of the change being made.
• Migration of Projects, SQRs via STAT
• Peer Reviews for the customizations made.

Confidential, NewYork

Environment: Win 9x/2000/XP/2003

Responsibilities:

• Configuration and Set up of the TE Transaction Definition, Approval Profile,Installation Options, Expenses ERApproval and ERPostPayAuditor Process Definition, Transaction Registry and Transaction Configuration
• Developed customizations in the form of application engines dealing with Component Interface.
• Involved in Workflow customization which introduced multiple approvers at multiple levels
• Involved in creating permission lists, users, roles and assigned roles to users (Maintain Security).
• Unit Testing, Support in SIT, UAT and final implementation of the module
• Used Peoplesoft Set Up manager for loading set up data.
• Developed Binds, Wizards, and Question groups according to the user requirements.
• Designed and Created Document Configurators according to user inputs.