SUMMARY

• Over 7 Plus years of experience as Peoplesoft Techno functional consultant in the software analysis, design development, New implementation, Upgrade, customization and testing of ERP, client/server, Data Warehouse and Enterprise Performance Management applications, for various clients in areas of Corporate, Consumer, Investment Banking, Hedge Funds, Auditing, Insurance, Commercial Real Estate and Public sector undertakings.
• Five Plus years of PeopleSoft Experience within United States. Extensively worked in implementations of PeopleSoft Financials and EPM applications ranging from versions 8.4 to 9.2.
• In - depth proficiency of functional knowledge, in addition to Design, Fit-Gap Analysis, Implementation, Upgrade.
• Excellent working knowledge of the PeopleSoft Internet Architecture and the flow of data exchange between various FSCM modules.
• In-depth proficiency of functional and technical knowledge, in addition to Design, Development, Implementation, Upgrade, Customization, Testing and Support experience in PeopleSoft AP, PO, GL, BI, AR, OM and AM.
• Extensively worked on AR, GL and Billing modules and interfacing between the modules.
• Proficient in developing custom pages and tables using Application Designer and PeopleCode.

TECHNICAL SKILLS

Hardware: IBM PC Compatibles

Operating Systems: Windows 95/98/2000/NT, Ms-Dos, UNIX

Languages: SQL, SQR, PL/SQL, C and People Code

RDBMS: Oracle (8, 9, 10, 11) SQL Base, MS SQL Server and Sybase

GUI Tools: Forms 4.5 and Reports 2.5, Visual Basic, Autosys.

ERP Packages: PeopleSoft Financials.

People Tools: Application Designer, Security Administrator, Workflow.

Data Management Tools: Data Mover, Import Manager, Application Engine.

Reporting Tools: Query, Crystal, SQR, nVision, Tree Manager, Process Scheduler Component Interface, Excel to CI, Application Messaging

Upgrade Tools: PeopleSoft Upgrade Assistant.

Version Controls: PVCS(Serena Change Man) and Microsoft Visual Source Safe.

PROFESSIONAL EXPERIENCE

Confidential, McLean VA

PeopleSoft Techno Functional Consultant

Responsibilities:

• Detailed test plans and technical documentation
• Involved in setting up the configuration tables, Bank setups.
• Setting up new Business Units, Bank setups, Chart field settings.
• Worked on various SQL performance tuning tasks to reduce the execution time
• Customized the delivered pages and Debugged the peoplecode and the SQR reports for the requested requirements for AP & AR Aging reports.
• Created functional specifications based on business process needs, wrote test scripts and supervised the entire customization process in collaboration with the technical team.
• Assisted the technical team with unit testing and created schedules for integration testing.
• Involved in working with the client in helping them integrate 3rd party products,(within Supply Chain) and helped with the integration testing for these products within Peoplesoft.
• Involved in the setup of business units, configuring the setup options for Supply Chain Modules (AP, Purchasing, eProcurement)
• Created nVison reports and nplode
• Tested Enable Employee Self-service Enhancement where the user is unable to change his/her home address in Update Profile page and enable expense payments to be routed to alternate locations (addresses) other than the address sent from PayServ.
• Attended daily defects meeting.
• Expansively used tools like Process Scheduler and Process Monitor for the execution of SQL and Crystal Reports.
• Provided 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.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR’s & Online.

Environment: PeopleSoft 8.9, Oracle 10G, Windows XP/NT/UNIX

Confidential, Roanoke VA

PeopleSoft Techno Functional Consultant

Responsibilities:

• Provided detailed test plans and technical documentation
• Developed Custom Billing interface program, added functionality for Discounts and surcharges for custom invoices, per client requirement.
• Developed Custom Billing Online Components to Review Billing Summary and Custom processed data.
• Developed Enquiry page for Billing Invoices for Custom billing interface run. nVision teplete build and trouble shooting.
• Created Process Definition, Run Control Record, Page and component to run the batch program through Process Scheduler and Scheduled the jobs through process scheduler.
• As a offshore and onshore team coordinator for China, India and USA.
• Developed a new online inquiry page to view Open commitment on the Purchase order by comparing the data related to the Requisition and Receipts
• Involved in writing SQR, which moves data from ESI system to PO tables like PO HDR,PO LINE and PO LINE SHIP etc.
• 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.
• Created around 20 crystal Reports and ran through the process scheduler.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft (Debugger, tracing etc) for trouble shooting issues on People Code, Application Engine, SQR’s & Online
• Expansively used tools like Process Scheduler and Process Monitor for the execution of Crystal Reports

Environment: PeopleSoft 9.1, Oracle 10G, Windows 2000/NT/UNIX

Confidential, Washington DC

Techno functional Consultant

Responsibilities:

• Develop technical specifications based on the Functional requirement document.
• Created technical specifications and built the online vendor attachments to be added at the vendor level.
• Developed technical specifications and built the process using application engine and People Code for the inbound and outbound interfaces between the PeopleSoft and the Maximo for the Purchasing requisitions and the Purchase Orders.
• Developed the technical specifications for the conversion of the existing projects, project activities, and project budgets, open purchasing documents, budgets, GL balances currently in the PeopleSoft financial database, the creation of grants sponsor/customers, the conversion or creation of grant awards, and the establishment of billed balances by customer contract.
• Excellent experience in troubleshooting, debugging and tracing.
• The scope of Projects for conversion includes open, existing projects including CIP, Rail Construction, ARRA, Reimbursable, and Safety & Security.
• Developed technical specifications to provide MTA with the ability to perform a mass update of the Buyer field on the tables storing Items and Item Categories. The delivered functionality allows the Buyer field must be updated individually for each item and item category. If many updates must be made, it could take a significant amount of time to complete the effort.
• Developed excel to CI component interfaces to mass update the buyer data for the items and the Item Categories.
• Developed the custom SQR programs in addition to the delivered component interfaces for converting the existing data into PeopleSoft finance applications.
• Developed pseudo code and unit testing procedures in the technical specifications for the development team.
• Defined the system testing and integration procedures for System testing and User Acceptance testing.
• Created test scripts and test scenarios based on the functional and the technical specifications.
• Developed control reports, error reports and reconciliation reports for the interfaced and converted data.
• Developed Data integrity reports to validate the orphan data in the PeopleSoft tables.

Environment: PeopleSoft 9.1, Oracle 10G, Windows 2000/NT/UNIX

Confidential

Techno functional Consultant

Responsibilities:

• Developed technical specifications based on the Business requirement document (BRD).
• Created user manual for the end users on the QCare to GL interface process for claims and premiums.
• Developed extract programs using sqr to send outbound and inbound GL and AP data from PeopleSoft programs to external systems QCare Claims and Revenue system.
• Performed data mapping of the external systems to PeopleSoft data.
• Developed user based online PeopleSoft mapping rules pages for the interfaces.
• Created custom records, pages, components for holding the mapping rules online.
• Created application engine program to load the mapping rules from the external files from QCare Claims system.
• Developed sqr programs which are executed on the remote applications (QCare) to improve the performance.
• Created partitions to improve the performance.
• Created different types of Oracle Partitions and sub partitions such as Range Partitions, Hash Partitions, and Composite range harsh partitions.
• Developed pages, components and application engine programs to create and maintain the partitions thru online PeopleSoft as part of the production maintenance.
• Fine tuned the long running custom application engine programs.
• Tuned the custom sqr programs to improve the performance adopting the load lookup tables and the array concepts.
• Fine tuned the custom queries to improve the performance.
• Improved the performance of the online application pages.
• Excellent experience in troubleshooting, debugging and tracing.
• Involved in performance tuning of the Application Engine programs.
• Developed error reports and reconciliation reports to track the errors and reconcile the source and target data.
• Supported the end users in providing the queries and assisted in testing of the interface in UAT.
• Coordinated with the DBA in migrating the PeopleSoft projects from development to SIT and UAT and Prod.

Environment: PeopleSoft 8.8, Oracle 10G, Windows 2000/NT/UNIX