SUMMARY

• Diligent and dedicated professional with over 7 years of experience in Oracle PeopleSoft Applications, specifically Finance Applications including AP, GL and Purchasing.
• Experience with People Tools, People code and Approval Workflow Engine (AWE).
• PeopleSoft Tools: Application Engine, SQRs, Application Designer, SQLs, File Layout, Component Interface, People Code, Data Conversion, PS query, PeopleSoft HRMS/FSCM (Modules: Absence Management, Compensation, HRIS, AP, GL), Integration Broker, web service, application messaging.
• Conversant with Administration Tools such as Process Scheduler, People Soft Security and Data Mover.
• Organized, resourceful and detailed professional with exceptional communication skills.
• Self - motivated and energetic, team player, problem-solver and ability to multi-task.
• Proficient in software including Job Trax and Microsoft Office suite.

TECHNICAL SKILLS

People Tools Objects: Application Designer, Process Scheduler, Application Engine, People Code, PeopleSoft Security, Component Interface, PS Query, SQR, XML Publisher reports, Data Mover Workflow, Application Packages, Approval Workflow Engine, PeopleSoft Test Framework, Asset Management and Project Costing and HCM (Manager Self Service, HR, Payroll, Base Benefits, Time & Labor, Pension Administration and eRecruit) modules applications.

Modules: PeopleSoft Data Security, Administer Workforce, Time and Labor, Employee Self Service, Manager Self Service, e-Performance, Absence Management, Compensation, HRIS, Oracle 11g.

PROFESSIONAL EXPERIENCE

PeopleSoft Techno-Functional Consultant/ Sr. Developer

Confidential, Ohio

Responsibilities:

• Involved in Object and Fit - Gap analysis between PeopleSoft 9.1 and PS 9.2(FSCM).
• Modified and customized PeopleSoft SQR s according to 9.2 requirements.
• Involved in delivering and completing documentation for all new processes and interfaces of 9.2.
• Technical design and development done for Buyer, Accounts Payables and General Ledger Work Centre's.
• Designed and developed the Approval workflow for Purchasing and GL modules.
• Supporting and Monitoring the PeopleSoft jobs.
• Analyzed the production support issues, fixing the issues and migrating to respective environment.
• Modified Application Engine to push Asset and Lease data to Payables.
• Analyzed PeopleSoft compare reports for identifying the affected PeopleSoft objects due to Bundles upgrade and created artifacts to reduce the effort of analyzing impacted objects using SQLs on PeopleSoft metadata.
• Customized the delivered objects Records, Pages and Application Engine according to Customer requirement.
• Retrofitted existing carry-forward items for existing modules.
• Involved in Application Security Configuration from 9.0 to 9.1 tools and application data migration from source environment to target environment.
• Extensively worked with Integration Broker to dispatch XML documents across different databases and to synchronize data for members such as Billing rates, Project data and Discount data.
• Installed security for SQL reports and nVision reports.
• Performed Unit Testing and Integration testing on Objects developed.
• Created custom permission list and give access to the Work Centre pages for the corresponding users in
• 9.1 applications.
• Coordination with onsite team and client interaction on daily basis.

Environment: PeopleSoft FSCM 9.2 (AP, GL, Purchasing, eProcurement), People Tools 8.51 (Application Designer, Application Engine, People Code and AWE and SQL Developer), Oracle 11g.

PeopleSoft Consultant

Confidential, VT

Responsibilities:

• Developed SQR reports to show capital spending summary and detail from asset management and Commitments from PO by capital budget number and totals for division, group and sub (company level).
• Coordination with onsite team and client interaction on daily scrum.
• Worked extensively in Application Engine and File layout during development phase involved in the creation of Records, Pages, Components and Menus.
• Worked on Integration within PeopleSoft systems and third party systems.
• Created many interfaces to pull the data from legacy system to PeopleSoft.
• Developed many application engines to perform DB tables to refresh on daily basis.
• Conversion of Purchase Orders, Invoices and Vendors.
• Developed SQR to create run control parameters for PO calculations and PO Create process in Purchasing.
• Created new Application Engines for outbound interfaces
• Preparing the Knowledge Technical Documents for the applications.
• Involved in documentation of technical specifications, developing test cases and technical design.
• Involved in the Retrofitting phase of the project and worked on Interfaces, Activities, Pages, and Component set.
• Worked extensively on SQR's and created several inbound and outbound interfaces to meet the client's requirements.
• Involved in writing and optimizing nVision reports.
• Created the complete understanding documents for new requirements for the future reference.

Environment: PeopleSoft FSCM 9.1(AP, Purchasing), People Tools 8.51 (Application Designer, Application Engine, People Code, File Layout, PS Query, Component Interface), Reporting Tools (SQR), Oracle 11g.

PeopleSoft Developer

Confidential, San Antonio, TX

Responsibilities:

• Technical Design and Build for the new requirements and enhancements.
• Created various artifacts and documents related to the existing system for various modules including ESS, MSS, Benefits, and Purchasing and accounts payables.
• Involved in the designing of Manager Self Service enhancements as per Client requirement.
• Involved in setting up different services such as Gateways, Nodes, Services, and Operations to configure automatic updates between HRMS and Finance by using Integration Broker.
• Worked extensively on SQL to pull the data of employees and managers and their reporting structure.
• Developed SQL's to get the employees benefits compensation.
• Worked on Crystal reports based on customer requirements.
• Assisted the Upgrader in solving the data related problems during the Data Migration steps.
• Customizing ESS e-Performance documents for enabling importing of data from past performance documents.
• Implemented PeopleSoft Payroll Tax Updates utilizing Application Designer, Data Mover, and Ultra Edit.
• Migrated projects between various development environments.
• Gathered requirements from HRIS to create technical specs for customizations.
• Wrote SQL for testing, and data validation.
• Utilized Excel formulas to automate the writing of SQL update, and insert scripts.
• Performed modifications and enhancements to nVision reports and nVision drills.
• Developed new inbound interface programs and XLS based reports using AE and File Layout.
• Modified & Created records, on-line pages, and components according to the requirements using Application Designer.
• Involved in creating Users Profiles, Roles, and Permission Lists.

Environment: PeopleSoft FSCM/HCM9.1 (AP, PO, ESS, MSS, Benefits), People Tools8.51 (Application Designer, Application Engine, People Code, File Layout, PS Query, Component Interface, Crystal reports, SQL) Oracle 11g.

PeopleSoft Techno-Functional Consultant

Confidential

Responsibilities:

• Requirements understanding with the Business Enabling team.
• Creation of Technical design document (TDD).
• People Code development for page field processing, row set processing and workflow.
• Changes control, impact assessment and advice on the impact and effort variances.
• Unit/Integration testing and provided testing support for the business users.
• Interacted with Users to understand the business requirements and developing technical specifications for various tasks involving object modifications, developing new objects, customizing delivered interfaces/reports and developing new interfaces and reports.
• Creation of objects specified in Technical Design document and changes the design as and when requires to match the client requirement.
• Rigorously tested the Custom Reports to identify error
• Developed custom Application Engine to generate employees based on feed received from ADP using Component Interface.
• Used Process Scheduler to run the processes & reports through PeopleSoft pages and used the process monitor to view the status of the reports.
• Maintained Security. Involved in creating permission lists, users, roles and assigned roles to users.
• Customized existing SQR's/ PS Queries to suit to the business requirements.

Environment: PeopleSoft FSCM /HCM 9.1 (Billing, AR, AP, ESS, MSS, Benefits), People Tools8.51 (Application Designer, Application Engine, TDD, People Code, Component Interface, SQL Loader, SQR), Oracle 11g.

PeopleSoft Consultant

Confidential

Responsibilities:

• Worked on defects and bugs on developed Application Engines and fixed the defects
• Analyzed Data Mover Scripts as part of Upgrade process
• Worked on existing SQR reports.
• Attended weekly status meetings and provide detailed status report to the client.
• Performed Unit Testing and Integration testing on Objects developed.
• Worked on ePerformance Approval Workflow engine. Responsible for application of ePerformance 9.1 fixes without affecting the already implemented modules.
• Coding and Unit Testing according to technical specifications.
• Interacted with business (internal and external) to understand and document their knowledge on impacted business processes and requirements.
• Understand the requirements and issues from business team and design, develop, enhance or implement appropriately leveraging technical artifacts including People Tools.

Environment: PeopleSoft FSCM/HCM9.1 (AP, PO, ESS, MSS, Benefits), People Tools8.51 (Application DesignerApplication Engine, People Code, PS Query, Component Interface, Crystal reports) Oracle 11g.