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, Rochester, MN

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, Columbus, IN

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 DesignerApplication 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, 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 DesignerApplication 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.