SUMMARY

• 8 Years of extensive experience as PeopleSoft Functional Consultant in Oracle PeopleSoft FSCM. For PeopleSoft Customization, Implementation and Design & Development
• Expertise in PeopleSoft Financial processes throughout lifecycle, including design, configuration, development, integration, testing, and deployment.
• Worked on PS Finance module - General Ledger, Project Costing, Resource Management, Billing module, Account Receivable, Account Payable, Purchase Order.
• Proficient in PeopleSoft FSCM 8.9-9.2(General Ledger, Project Costing, Billing, Receivables), PeopleTools 8.52, PeopleTools 8.4X, Application Designer, PeopleCode, Application Engine, Workflow Technology, Component Interface, Data Mover, Structured Query Reporting (SQR), oracle 9i/10g etc.
• Instrumental in coordinating between the on-site and offshore teams.
• Responsible for working with the Offshore/Onshore delivery, coordinating work efforts and ensuring project delivery dates are met on time. Also coordinates User acceptance testing, parallel and Go-live support activities.
• Strong Ability to facilitate and perform Business and Application requirements gathering.
• Extensive experience in the analysis of business processes, setups, and report customization, upgrades, data conversion from Legacy Systems to PeopleSoft application databases, writing interface programs, testing, trouble shooting and providing online support.
• Worked with users to analyze their needs to successfully develop PeopleSoft modules.
• Production support, Troubleshoot/Debug processes and fixing data/code issues in DEV/TST and migrating to PRD.
• Strong documentation and written presentation skills, and developed various functional and technical specifications with Test Plans and Procedures.
• Experience and expertise in developing Application Engine Programs and performance tuning of Application Engine Programs using traces.
• Excellent communication skills, has clear understanding of business procedures and ability to work as an individual and also as a part of team.
• Thorough experience on software development methodology and Quality process. Worked in various projects adhering to phases of software development life cycle, which includes system study, analysis, design, development, testing and implementation
• Process oriented person with proven reputation for client expectation management
• Experience in 24 * 7 Production support
• Expertise in application programming and database concepts.
• Excellent communication, presentation, and analytical skills.

TECHNICAL SKILLS

ERP: PeopleSoft Financials 8.x, 9.1 (FSCM- AP,AR, PO, GL, Project Costing, Resource Management,P2P)

Software: PeopleTools 8.51, SQR, TOAD, Oracle 11g

Tools: Application Designer, PeopleCode, Application Engine, Component interface, Process Scheduler, Application Package, SQR, Work Flow, Integration Broker

Job Scheduler: Control-M

Reporting: SQR, PSQuery, Crystal Reports

OS: Windows XP, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential

PeopleSoft Functional Consultant

Responsibilities:

• Worked as a Team Lead in Functional requirement gathering of customer’s needs, analysis, planning and estimation, reviewing the developments, defect prevention.
• Involved in preparing Functional /Technical specifications and relevant documentation in line with customization/enhancement/bug fixing requirements.
• Customized the delivered pages; debugged the PeopleCode and the SQR reports for the requested requirements for AP and AR Aging reports.
• Worked closely with Onsite colleagues to accommodate many changes to requirements and get the results on time.
• Since Project is in Maintenance and support phase so worked on fixing Defects and Incidents.
• Worked as a Developer/Team Member in the project.
• Prepare Technical design documents as per the Functional Design document.
• Prepared interface fit gap for all the SQR interface program
• Involved in developing and customizing the reports using the tools PS Query SQR.
• Worked on Data mover scripts to export Data from one environment to other.
• Collaborate with internal and external clients to identify process improvement opportunities.
• Involved in user enhancement of PeopleSoft financials (AP,AR, and GL) utilizing PeopleTools and SQR reports.

Environment: PeopleSoft FSCM 8.9 Project Costing, AR, AP, Billing. Peopletools 8.52, Application Designer, People Code, Application Engines, SQR.

Confidential, Atlanta Georgia

PeopleSoft Functional Consultant

Responsibilities:

• Involved in preparing Functional/Technical specifications and relevant documentation in line with customization/enhancement requirements for Billing Module.
• Involved in preparing Interface Design Documentation specifications and relevant documentation in line with Interface requirements for Billing Module.
• Worked closely with Onsite colleagues to accommodate many changes to requirements and get the results on time.
• Since Project is in Design phase so worked on creating various POC’s for Enhancements and Interfaces tasks.
• Complete Connectivity Testing for incoming transaction files through gateway Servers.
• Conducted KT sessions to team members on application functionality.
• Supported Functional Activities for AP & GL modules.
• Developed AE program to report details of voucher matching.
• Developed Custom Billing interface program;
• Developed Custom Billing Online Components to Review Billing Summary and Custom processed data
• Developed Enquiry page for Billing Invoices for Custom Billing interface run.
• Involved in creating a process to build inventory demand; verified the inventory table BU ITEM INV and then consequently checked the inventory availability; calculation process developed to source PO using Purchasing module

Environment: PeopleSoft FSCM 9.2 Project Costing, Billing, Purchase Order,P2P . Peopletools 8.53, Application Designer, People Code, Application Engines, SQR, Component Interface.

Confidential, Chicago

PeopleSoft Functional Consultant

Responsibilities:

• Worked as a Team member in Functional requirement gathering of customer’s needs, analysis, planning and estimation etc.
• Involved in requirement specification, Peoplesoft application customizations, functional and technical design documentation according to business need of the clients.
• Performed support for General Ledger and other financial modules by answering questions, providing user and offshore team training, resolving issues and identifying the root cause of the problem.
• Worked on implementing Connect Direct Setup for transferring files between different Systems.
• Implemented multithreading and parallel processing using Jobs and JobSet.
• Designed and developed a very efficient, fully configurable Publish and Subscribe process to publish and subscribe the Chartfield and Non-Chartfield related data between PeopleSoft-PeopleSoft and PeopleSoft-Non-PeopleSoft based systems. Implemented several complex algorithms to make the process as faster as possible even after reporting Emergency Changes and any Conflicts in the subscribe. It is written in highly re-usable and implemented in 4 regions already without any major changes.
• Develop the Chart of Accounts, GAAP and STAT tree hierarchies
• Configure the chartfields and accounting periods within PeopleSoft GL.
• Worked on GL Chartfield configuration process.
• Extensively used Process scheduler for setting up the reports to run at specific time and used Process Monitor to monitor the status of reports.
• Designing the process for the functional and technical specifications
• Develop core conversions engines using Component Interface and Application engine program.
• Prepare test strategies and unit test plans.
• Performed planning and data conversion activities.
• Prepared report fit gap documents for all the PeopleSoft Customization
• Prepared interface fit gap for all the SQR interface program
• Configured data archive method in PeopleSoft to transfer the data to archival (SQL) server.
• Developed UNIX script to get the log details from control-m jobs which failed.
• Development/Customization of SQR, Application Engine, UNIX shell scripts based to meet business requirements.
• Trouble shooting, batch monitoring and ensuring the system online within the respective SLA’s of the countries
• Developed UNIX scripts to trigger JGEN process from Control-M.ConfiguredBusiness Units, Ledgers and Ledger Groups.
• ConfiguredJournal Sources.
• Involved in PeopleSoft Financials upgrades from 8.4x to 9.0 involving data warehousing, migration, and reconciliation.
• Worked with Advanced Job Schedulers (Control-M) and developed jobs
• Created Process Definition, Run Control Record, Page, and Component to run the batch program through Process Scheduler; scheduled the jobs through process scheduler.
• Worked on resolving tickets related to module like GL, RDMF, and RMF.
• Worked on test cycles and related defects.
• Involved in helping Training department as Subject Matter Expert (SME) for one of important module of project.
• Provided technical and overall support to team members in all stages of the project.
• Functional assistance to the client.
• Lead team for some of new activity e.g. building new test environment, implementing new functionality.

Environment: PeopleSoft FSCM 9.2 General Ledger and Custom Confidential Modules. Peopletools 8.53, Application Designer, People Code, Application Engines, SQR, Component Interface.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Worked as a Team member in requirement gathering of customer’s needs, analysis, planning and estimation, reviewing the developments, defect prevention.
• Involved in preparing technical specifications and relevant documentation in line with customization/enhancement/bug fixing requirements.
• Interacted with the users and customized the product as per requirement
• Worked on customized Project Costing, Resource Management, Account Receivable and Billing module.
• Interacted with the client regularly to get the Functional requirements and preparing Technical Documents.
• Customization of the pages and PeopleCode as per the user requirement.
• Created test cases, unit test plans and technical specification documents.
• Support to onsite/offshore end-users for effective resolution of issues faced by them.
• Responsible for interaction with Onsite User, Conference Call & sending detailed email communication as a part of production support.
• Code Migrations between servers.
• Worked as SPOC (Single Point of Contact) for Production Go-live.
• Put application tracing, Research and isolating the issues.
• Performed smoke/unit test to make sure the process and online applications are working per the requirements after the migration.
• Performed system integration testing and supported the end users in user acceptance testing.

Environment: PeopleSoft FSCM 8.9 Project Costing, Contracts, Time Sheet, Expenses, Account Receivable and Billing. Peopletools 8.52, Application Designer, People Code, Application Engines, SQR.

Confidential

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Experienced in WFM (Work Force Management that is related to Workforce Administration) team to view the Assignment related information of various employees in OSP.
• Enhancement in the portal, Branding and Maintaining the Oracle One portal.
• Involved in preparing technical specifications and relevant documentation in line with customization/enhancement/bug fixing requirements for Oracle One portal.
• Customized the pages and PeopleCode as per the user requirement.
• Worked on the security and data migration scripts.
• Created test cases, unit test plans and technical specification documents.
• Involved in Migration of Projects through Application Designer and Handled some PS- Admin related issue for the Portal.
• Assigned the roles to all those associates who are in OSP (Oracle Solution Practice) group to access the portal.
• Code Migrations between servers.
• Customized and developed components, Pages, & records using People code.
• Played an important part in identifying, analyzing and solving defects.
• Customized various online pages according to the user needs

Environment: PeopleSoft FSCM 8.9 PeopleSoft Work force Administration. Peopletools 8.52, Application Designer, People Code, Application Engines, SQR.