SUMMARY:

• Over 8 years of experience in implementation, upgradation and customizations of PeopleSoft Financials (9.2/9.1/9.0/8.9/8.4/8.0 ), SCM and HRMS modules.
• In - depth proficiency of functional and technical knowledge, in addition to Design, Development,
• Implementation, Upgrade, Customization, Testing and Support experience in PeopleSoft Proficient in developing custom pages and tables using Application Designer and People Code.
• Excellent working knowledge and experience using reporting tools such as Crystal Reports, SQR and XML Publisher
• Expertise in XML Publisher Report Using PSQUERY, XML Doc Objects, Row sets and XML File types.
• Performed 2 full-lifecycle Implementations and 2 full-lifecycle Upgrade projects with emphasis on design, customization and production support.
• Expertise in Approval workflow and sending email Notifications using work flow email functionality and also using Application packages.
• Customized new Application Packages to Generate XML Report and expertise in writing XML code in Template level to get expected Results.
• Proficient in Module Development, Interfaces, Conversion, Data Migration and Report Writing.
• Well versed in writing and calling procedures within the People Code events.
• Worked with Panels, Components, Menus, Business Process Maps and Workflow.
• Extensive experience in transferring existing data from legacy systems to People Soft application database tables using SQR and Application Engine.
• Hands-on-experience working with commitment control, encumbrances and fixing issues related to them.
• Expertise in Creating nVision & Crystal Reports from the Scratch.
• Hands-on experience working with the PIA architecture, Application Engine, Application Message, Component Interface, Business Interlinks and Batch Processes.
• Reputed Knowledge in creating specifications, project schedules, analyzing the upgrade process to re-customize and reapply the customizations, supervising design activities and interfacing with customers for successful completion of project.
• Expert in PeopleSoft Internet Architecture (PIA) and Open Integration Technology People Tools such as Application Designer, Application Engine, Integration Broker, Application Messaging, Business Interlink, Component Interface, People Code, Security, Web Services, Tree Manager, Process Scheduler, Data Mover and Query tools.
• Expertise in Mainframes to write and modifying JCLs for program execution and scheduling jobs and Report Distribution.
• Expertise in Foundation Tables, Common Definitions, Product Related, System Administration, T&L rules, PS security, organizational relationships, Template-Based Hires, compensation packages for core HCM & Self-Service modules including integration setup between FSCM, CRM & ELM
• Strong working knowledge in RDBMS (ORACLE, SQL Server and DB2).
• Expert in creating documentation for business requirements, technical design, training, architecture and test scripts.

TECHNICAL SKILLS:

ERP Package: PeopleSoft HRMS 9.2/9.1/ 9.0/8.9/8.8/8.3/8.0/7.5 ( HCM Payroll, Benefits, Workforce Admin, Compensation, Time & Labor) Peoplesoft FSCM(9.2)

Modules: HR, Payroll, Base Benefits, Ben Admin, Time & Labor and TAM. eBenefits, eProfile, eRecruit, ePay and ePerformance, Real Estate Management, AP, GL, PO, Grants, CA, AR, Contracts & Project Costing.

Databases: Oracle 11g/10g/9i/8.x/7.x/6i, DB2, SQL Server 2000 and Informix (7.2).

Web Technologies: XML, ASP, HTML, Java Script and VB Script.

Servers: BEA Web Logic server, Web sphere, Apache and IIS.

People Tools: People Code, App Messaging, Integration Broker, Security, Process Scheduler, Application Engine, Workflow and Tree Manager.

Reporting Tools: SQR, Crystal Reports, nVision, BI Publisher, PS/Query and Connected Queries.

Languages: SQL, SQR, PL/SQL, C/C++, Java, COBOL and Shell Scripts.

Operating Systems: Windows 98/NT/2000/XP, Mainframes (MVS/TSO), MS-DOS, Unix (AIX, HP, Solaris) and Linux.

Testing Tools: Win Runner, QTP and Quality Center

Other Tools: Developer 2000, Ultra Edit, Quest TOAD, SQL Plus & Developer and Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr.PeopleSoft Techno/Functional Consultant.

Responsibilities:

• Extensively involved in Real Estate Management (REM) Module lifecycle from Creation of SAR (Site Acquisition Request) to Creating Lease and then processing the Monthly Payments to AP.
• Extensively applied complex customization on REM Module Page(s) and created Custom Complex pages to provide additional functionality as per Users requirements.
• Customization on adding Multiple Lease Approval attachments, creating different Financial Terms - Base Rent, Miscellaneous Rent, and Operating Expenses.
• Worked on New Chatfield Request Workflow & Lease Activation Workflow from PeopleSoft to Unifier.
• Worked on Denial Process of Lease Activation Request.
• Worked on Lease schedule Payments Report and Lease detail Report using BI Publisher that needs to be sent to Unifier a third party system at the time of Lease Activation Request.
• Worked on Email Notification Process using custom page data information and sending emails with attachments.
• Monthly running Manage to AP/ Billing Process for all the Leases that are scheduled for monthly Rent payment and then building the vouchers for those payments.
• Created Application Engine Program to send daily reminders to Unifier of any pending Request that needs approval.
• Involved in modification of Application Package and created new Application Package based on client’s requirement.
• Worked with Accounts Payable on various customizations, which involves Manage Vouchers, EDI Processing, Pay Cycle, AP Processing, AP Interfaces, Refund Processing, AP Reports and AP Security.
• Extensively worked on Excel to CI for Activating the Converted Leases.
• Extensively worked on Conversion & Archiving of different Lutheran Hospital systems to PeopleSoft.
• Developed Purchasing Interface with File Layout, Application Engine, AE Peoplecode and Component Interface. It loads data from flat file into temporary staging tables and queries external database via Database link to retrieve chartfield information. This interface performs various data validations using Application Engine PeopleCode, finally loads validated data into PeopleSoft tables through Component Interface.
• Created permission lists, roles and assigned to users.
• Worked extensively on SQR, Crystal Reports, PS Query and App Engine Programs.
• Extensively worked on building Archival Reports using PS Query.
• Created Dashboard for Lutheran Entities to Access their data from one place.
• Created Navigation Collections & Pagelets for Dashboard and built custom XSL for Pagelet design.
• Extensively worked on Creating Tiles for Fluid Dashboard.
• Expertise in Creating PeopleSoft Fluid page UI, Created Fluid Pages, and Registered Fluid components. Converting the classic Pages to Fluid Pages.
• Involved in Production Support after Go-Live for REM.

Environment: People Tools 8.55, PeopleSoft Application 9.2 ( Real Estate Management, AP, GL, PO) Oracle 11g/10g, SQR, Application Designer, Crystal Reports, People Code, PS Query, Data Mover, Component Interface, Application Engine, Integration Broker, XML Publisher.

Confidential, NY

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Modified Change Assistant templates such as adding steps to template, editing steps, deleting chapters, tasks and updating scripts.
• Extensively Involved in PeopleSoft Upgrade 9.2 and Tools 8.54.
• Designed & developed integration between PeopleSoft CRM & FSCM as per business requirements.
• Ran compare reports to get all customizations in Production environment. Also worked on Fit gap analysis to detect applicable new functionalities implemented in PS 9.0/9.2 v.
• Ran SysAudit and Alter audit reports and have cleared Target environments by deleting inconsistent tables and orphaned objects.
• Involved in discussions with Financial and HR functional teams for Upgrade Project Planning And for listing new functionalities to be applied. Completed initial test pass and Move to Production phases of upgrade.
• Strong Experience in nVision and Crystal reporting
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing Debugger, tracing tools for trouble shooting issues on People Code, Application Engine and SQR’s.
• Applied customization on SES search Index for Recruiting on Job postings. Also applied customizations on connected queries related to SES index FEED process.
• Worked on Deploy and UnDeploy for HRS HC JOB POSTING index FEED.
• Expertise in Creating PeopleSoft Fluid page UI, Created Fluid Pages, and Registered Fluid components.
• Created nVision Balance Sheet reports. Modified and maintained Income Statements, Trial Balances and Cash flow statements for existing Business Units
• Creating custom reports on aging details and summary for regular bills and Expense bills.
• Creating a report for the Account Receivable on Pending items that runs and gives report periodically, that gives the list of all Pending Items, and Pending Payments.
• Created permission lists, roles and assigned to users.
• Created Vendor Aging Report,Tuition Reimbursement Report and Work force Analysis Report using XML Publisher.
• Created various Summary Reports for General Ledger using nVision
• Developed an Application Engine program to modify the Serial Controlled inventory item into a non-serial Controlled Item.
• Developed Purchasing Interface with File Layout , Application Engine , AE Peoplecode and Component Interface. It loads data from flat file into temporary staging tables and queries external database via Database link to retrieve chartfield information. This interface performs various data validations using Application Engine PeopleCode, finally loads validated data into PeopleSoft tables through Component Interface.
• Customized PO Dispatch/Print to change headings and print in duplex mode for Company Terms & Conditions.
• Worked on Barcode Generating using XML publisher also Expertise in using EXEC commands through People code and using BI Publisher.
• Expertise in Creating PDF templates for Government forms using BI Publisher.
• Expertise in Creating Upgrade documents and Involved in Fit Gap Analysis.
• Expertise in converting Resumes into PDFs and merge PDFs into one file. For this used Application Engine and Visual basics combination. Expertise in using EXEC commands to RUN VB script executable files.
• Involved in Production Support after Go-Live for PeopleSoft 9.2 Upgrade.
• Designed and executed Unit Test scripts for nVision functionality like ‘Setting up a Report Book’, ‘Testing Drilldowns and ‘Testing Queries’.
• Provided Technical Assistance to the functional and testing team, resolved issues and documented resolutions
• Worked with Accounts Payable on various customizations, which involves Manage Vouchers, EDI Processing, Pay Cycle, AP Processing, AP Interfaces, Refund Processing, AP Reports and AP Security.
• Creating queries for all Open invoices and Modifying Invoice Print Crystal in PS Billing.
• Worked with Asset Managements on various modifications, which involves Enter Assets, Asset Cost Transactions, and Month End Processes, AM Interfaces, AM Reports and AM Security.
• Created AWE workflow Queries and Wrote Root Application Package people code for AWE process. Also created Custom approval Steps for workflow using AWE.
• Converted Mail Merge Reports to Bi Publisher Reports as per Client Requirement.
• Involved in Crystal Reports ODBC setup and Created Custom Crystal Reports for New York City Transit Agency.
• Provided support & enhance for CRM modules. Scheduled Jobs & control parameters for process
• Excellent understanding of CRM Data Model, Created & tuned complex SQL Queries record joins, filtering criteria & Effective Dated Active status rows
• Expertise in Creating Pivot Grid and Pivot tables. Also created complex PSQUERY and connected queries inline up on user request.
• Expertise in Integration Broker Synchronous, Asynchronous app messaging in between Internal and external messaging. Expertise and created custom setup to transfer files using Integration Broker Application messaging through FTP option.
• Developed GL interface that loads data from various external systems into PeopleSoft General Ledger using SQR process, while implementing combo rules and checking invalid Chart field combinations, Subtotals on Business Unit Level, grand totals, Error Handling Procedures and Printing Multiple output Reports.
• Created permission lists, roles and assigned to users.
• Worked extensively on SQR, Crystal Reports, PS Query and App Engine Programs.
• Modifying People code on Item Enquiry Page to show letter of credit data.
• Worked with Compare Reports and Estimate Fix Related Modifications and reapplying the fixes.
• Modified/Created SQR reports/interfaces, Crystal reports and Modified custom PS objects.
• Developed new reports using SQR, Crystal and PS-Query. Writing and running Test cases/scripts, Defect tracking and fixing.
• Used Upgrade Assistant to automate some of the upgrade tasks and to keep track of the begin time and end time to run a process.
• Expertise in creating new Phire issue tracking and Change Requests and create compare reports between different Environments using Phire.
• Developed nVision reports for multi-currency reporting that were being created manually. Created query and crystal reports used in an initiative for better Cash flow reporting
• Formulated and executed standards relating to reporting strategies. Assisted on identification of efforts for every development task.
• Implemented technical specifications and executed functional specifications. Coordinated with project staff about project status and risks.
• Extensively Experienced in XML Publisher in Writing People code to Generate and Distribute the XML Reports.
• Created and Modified XSD, XML and Templates according to the Requirement and preferred Format.
• Involved in running Upgrade Compare Reports between Demo database and Copy of production before we do the upgrade copy.
• Expertise in Using Phire to Migrate Objects to testing Environments.
• Created new pages, derived work records, Functions and PeopleCode validations for custom templates. Created Translate records and translate values for templates.
• Involved in Fine Tuning of Database Tables, which are used in Data Conversion Application Engine Programs to increase the performance.
• Expertise in Using Phire to compare people code, Queries, SQLs, Fields, Records, Pages and Components between multiple Environments and creating version sets with changes in object history.
• Involved in Customizing all AM and AR Corning reports to remove custom chart field.
• Creating new report Customer Credit Reference Details including Customer Name, address and Credit amounts and also will give Aging Category and Payment History details on As of Date.
• Developed training material and conducted training sessions to raise overall knowledge of nVision
• Developed various kinds of SQR’s, which include conversion, Interface Batch Processing and Reporting SQR’s. Customized several SQR and Crystal reports like Pending items, aging reports like AR30001, AR30002, AMPS1000.sqr, Invoice printing (BIIVCEN).
• Involved in Supporting and Resolving issues in Production system.

Environment: People Tools 8.49/8.50/8.54 , PeopleSoft Application 8.4/9.0/9.2 (GL, AP, AR, AM, PO, BI, ePro, Projects, Contracts, Travel & Expense and OM) Oracle 11g/10g, SQR, Application Designer, Crystal Reports, People Code, PS Query, Data Mover, Component Interface, Application Engine, Integration Broker, XML Publisher.

Confidential, WI

PeopleSoft Financial Technical Consultant

Responsibilities:

• Analyzed legacy system data structures and created data maps, developed technical specifications for conversion, interface, and report to convert the data from legacy system to PeopleSoft.
• Involved in user enhancement and maintenance of PeopleSoft Financials (General Ledger, Account Payables, Purchasing, Receivables) utilizing People Tools and People Code.
• Involved in PeopleSoft Portal Development/Customization - Homepage design, Page lets Navigations and Search Indexes, Company news, Content Management.
• Configured Single Sign on between 8.8 Portal and 8.8 Financials applications.
• Developed and customized the records, pages, menus and reports as per the client functionality.
• Fixed multi-currency issues due to configuration errors and created custom nVision reports for multi-currency reporting.
• Involved in Customization and implementation of Account Payables, Purchasing and Project Costing modules using Application Designer and People Code.
• Involved in customization of reports as per the user requirements using Crystal Reports and SQR.
• Integral asset to acquired company converting to Peoplesoft in training of all aspects of the system as well as creating custom reports using nVision and Query. Created a significant number of the Financial Statement reports used after implementation.
• Modified App engine programs delivered with PeopleSoft8 to add new custom fields to various sections in the Payables module.
• Evaluation, customization and setting up of workflow for Journal Entry Approval, Voucher Approval Processes.
• Extensively used People soft Integration Tools including Application Messaging, Integration Broker, Component Interfaces and Business Interlinks.
• Generated Crystal Reports for creating Slow Moving Inventory Report, Shipping Container Labels, and Transaction Register Report.
• Written and modified several nVision reports and processes for Financials.
• Enhanced existing SQR’s to print invoices, purchase orders, price confirmations and request for quotes. Receiving Vendor, Item, Receipt Date and Receiving Log by Date, Item reports.
• Provided technical assistance to the functional and testing team, resolved issues and documented resolutions.
• Written and Modified like Project Resource Report, Project Level Variance Reports using Projects Cube Manager.
• Worked on Cobra Eligibility Benefits Administration Reports using SQR process, Tuition Reimbursement Report using XML publisher with Application Engine Process.
• Extensively involved entering the Temporary employee’s hours in Corporate Labor.
• Worked on New hire Report using XML Publisher using Application Engine Process.
• Modified/Created SQR reports/interfaces, Crystal reports and Modified custom PS objects.
• Developed new reports using SQR, Crystal and PS-Query. Writing and running Test cases/scripts, Defect tracking and fixing.
• Used Upgrade Assistant to automate some of the upgrade tasks and to keep track of the begin time and end time to run a process.
• Uploading legacy data into Database server using People soft administration tools like Data Mover, SQR, PL/SQL and import/export utilities.
• Worked on GL, Payables and Purchasing modules in process of Testing, before final move to Production.
• Developing the test cases and documenting the test results after the Unit Level test of all pieces of Process. Running trace, debugging the code/programs if need.
• Converting Development to Production Environment
• Supporting / Resolving various issues in Production system
• Create/customizing the Crystal, SQR reports.
• Legacy data conversion/translation and loading the data using SQR, PL/SQL, import/export tools.
• Setting the Process scheduler for various jobs on regular basis.

Environment: PeopleTools 8.45/8.47, PeopleSoft Application 8.8/8.9 (AP/ AM/BI/AR/GL/INV/eProc/PO),SQL Server 2000, Windows 2000, SQR, Crystal Reports, People Code, Application Designer, Application Engine, SQl, Component Interface, Data Mover, Integration Broker, nvision.

Confidential, Houston, TX

PeopleSoft Financial Technical Consultant

Responsibilities:

• Analyzed legacy system data structures and created data maps, developed technical specifications for conversion, interface, and report to convert the data from legacy system to PeopleSoft.
• Implementation of PeopleSoft Account Receivables and order management Involved in Designing Receivable system by defining general options, customer processing options, receiving processing options, setting up of Banks etc.
• Defining General options, Order Management, Products, establishing order processing options, Structure pricing, commissions etc.
• Involved in PeopleSoft Portal Configuration - Homepage, Page lets Navigations, Session Cookies and Company news.
• Involved in Configuring Load Balancing and portal running under SSL to use HTTP Connections to PIA on the same server.
• Involved in Customization and implementation of Account Receivables, Order Management modules using Application Designer and People Code.
• Developed programs using SQR to convert data from Legacy System to the PeopleSoft tables.
• Developed and modified the SQRs as per the requirement of the end users.
• Developed Interfaces for Interfacing Customer data and receiving payments.
• Involved in customization of Chart fields as per the requirement of the end users.
• Creation and modification of the reports like Payment predictor, Statement, Dunning letters and Payment Summary etc. as per the user requirements using Crystal Reports and SQR.
• Generated dynamic prompt tables to some of the pages through people code.
• Involved in the postproduction support.

Environment: People Soft 8.8, Application Server (Tuxedo, Jolt), Web logic Server, People Tools 8.48, Integration Broker, SQR, Component Interface, Crystal Reports, Oracle 8i, Windows 2000, HP UNIX.

Confidential, Houston, TX.

PeopleSoft Financial Technical Consultant

Responsibilities:

• Performed data conversion and imported data from legacy system into temporary tables using file layouts. Component Interface program was then used to validate the data in these temporary tables and import it to the PeopleSoft system.
• Used Integration Broker to notify the GL system whenever the time entered for an employee was different from the estimated amount.
• Setting up of General Ledger to implement the Journal processing, detailed ledgers, Summary ledgers and Converting Accounting entries to PeopleSoft Journals, defining Journal Generator Templates, transferring journals to General Ledger.
• Automated the Adjustment journals and year-end closing procedures to effectively manage Journal processing flow.
• Involved in customization of Chart fields as per the requirement of the end users
• Involved in Designing Payables system by defining general options, customer-processing options, and Payment processing options, setting up of Banks, Vendors etc.
• Involved in setting up of Purchasing to share vendor information with Accounts Payable and Asset Management to streamline the entry of assets into the financial system..
• Involved in defining the business processes, roles and routings as per the business requirement and to customize the workflow process.
• Customized the tables and pages as per the requirement of the end users.
• Modified the People Code as per the business rules laid down by the client.
• Used Application Engine to perform background processing against the data.
• Modified existing SQRs to take care of the changes suggested by the users.
• Developed programs using SQR to convert data from Legacy System to the PeopleSoft tables.
• Involved in customization of reports as per the user requirements using Crystal Reports and SQR.
• Involved in the postproduction support.

Environment: PeopleSoft 8.0, Oracle 8i, People Tools 8.16, Application Messaging, eApplications, SQR Reports, nVision, Crystal Reports.