EXPERIENCE SUMMARY:

• Having 12.3 years of experience in PeopleSoft as a Technical and Techno - Functional Consultant.
• Having experience in PeopleSoft I mplementation, upgrade, production support and maintenance of application including analysis, design, development, testing, customization and documentation.
• Hands on experience in FSCM/Finance modules Order to Cash such as Time and Expenses, Accounts Payables (AP), Billing (BI), Accounts Receivables (AR), General Ledger (GL), Asset Management (AM), e-Procurement(ePRO), and Purchasing (PO).
• Provides Design, Development and support for the Peoplesoft FSCM Modules.
• Good understanding of PeopleSoft HCM Modules - Core HR, Base Benefits, Employee Self Service (ESS) and Manager Self Service (MSS).
• Expertise in people tools like Application Designer, Application Engine, Component Interfaces, People Code, File layout, Excel to CI Utility, Spreadsheet upload, Integration Broker, SQR, Crystal Reports, n-Vision, XML publisher (BI Publisher), PS Query, Security, Data Mover, Process Scheduler, Workflow (AWE), PeopleSoft Test Framework and Data Migration Workbench.
• Gather the workflow requirements from a business users and prepare a requirement document
• Extensively worked on Approval Workflow Engine (AWE).
• Experience in design, development and deployment of Peoplesoft webservices. This includes SOAP-based webservices and REST api development.
• Developed generic webservices based on Component Interfaces. This includes exposing the delivered PS Component Interfaces to third parties as a generic WSDL end-point.
• Design experience in config-driven development of the PS functionality to make the PS functionality generic.
• Developed generic utility within Peoplesoft, such as Encryption, File Attachment over SOAP, email functionality etc.
• Install and Configure PeopleSoft Test Framework (PTF)
• Experience in coordinating and scheduling the meetings with Business, Risk Architecture, testing and development teams where and when required to manage and track the priorities and making sure the team meets the deadlines in specified time.
• Strong SQL skills and SQL Tuning, scheduling jobs through Control-M Scheduler.
• Proficient in using Process scheduler for running reports & processes and monitoring them using Process Monitor.
• Experience in interacting with users to analyze and create design documents for the implementation of new functionalities and Change Enhancement Requests as per business requirements.
• Extensively involved in FIT/GAP Analysis and preparation of Test Cases and Test Scripts and planning and execution of test cases resulting in test reports.
• Worked on Design Process flows and technical solution documents.
• Ability to implement the business requirements as functionalities in the software product.
• Strong Interpersonal and Communication skills.

SKILLS:

• PeopleSoft FSCM/Financials 8.9, 9.0, 9.1 & 9.2
• PeopleSoft HCM 8.8 & 9.2
• People Tools 8.46, 8.48, 8.49, 8.50, 8.51, 8.53, 8.55, 8.56

SKILLS PROFILE:

Application Development Tools: App Designer, People code, Application Engine, Component Interface, PS Query, SQR, Crystal Report, nVision and BIPublisher reports.

Application Package: PeopleSoft FSCM, HCM & CRM

Databases / DB Tools: Oracle, SQL Server and DB2

Operating Systems: Unix and Windows

Programming Languages: C, People code, Java

Testing Tools: Manual Testing, PTF

Enterprise Manager Tools: Control-M (Version 6.4.01.200 ), PHIRE

Markup languages: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Developed multiple Webservise using ROWSET as well as NON-ROWSET based WS for third party and Peoplesoft.
• Developed generic webservices (Vendor) based on Component Interfaces, which includes exposing the delivered PS Component Interfaces to third parties & Peoplesoft HCM as a generic WSDL end-point.
• We created configuration page for Vendor webservice to specify the default values with respect to the third-party system.
• After creating the vendors in PeopleSoft FSCM, next the same system will send attachments for the newly created vendor based on response.
• Peoplesoft facilitates MTOM protocol for sending and receiving binary data using service operations. While you can send and receive binary data using SOAP, doing so requires that you Base64-encode the data for security using algorithms.
• Developed generic utility within Peoplesoft, such as Encryption, File Attachment over SOAP, email functionality etc. with which we can utilize the same for all the projects need bases.
• Performing AMS for PeopleSoft System for all the modules including Order to Cash such as Billing, Accounts Payable, Accounts receivable, GL, eProcurement, and Security in Financials. Review the fit gap documents with business before finalizing.
• After completing this we will have detail technical design document and walk through with technical team and users to get approval.
• After getting approval we will follow the QA, UAT and production.
• Worked as a techno functional consultant in PeopleSoft FSCM Application Upgrade project from version 9.0 to PeopleSoft 9.2 and People Tools version from
• Responsible for reading compare reports and creating objects to retrofit.
• Worked closely with functional lead and client during fit gap and provided technical inputs to customizations.
• Modified P2P Interfaces(Ariba).
• Recognized the mappings of records and fields that had changed, renamed, added and deleted in FSCM by comparing it with vanilla version.
• Retrofitted several SQRs, Crystals, Pages and Components and was accountable to its proper functionality.
• Converted all Crystal reports into BIP reports.
• Worked extensively on Check Print reports using BI Publisher & Withhold reports, which are converted from Crystal reports to BIP Reports using MICR line.

Technology/Tools: PeopleSoft FSCM 9.2, People Tools8.56, SQL Developer.

Confidential, Chicago, IL

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Understand business requirements and functional specifications and translate to technical solutions.
• Resolved day to day issues and implemented solution for various change requests as a part of support activities.
• Wrote technical specifications for SQR’s and interfaces in PeopleSoft Application engine.
• Exported matched invoices to A/P system and created custom categories for tracking invoice data
• Performed a Security Clean-up of all the Production and Development Databases
• Involved in the design, coding, and unit testing for all customization carried out as per the business rules.
• Involved in requirement analysis & design for change request.
• Interacting with business and IT users to obtain the system details and to prepare the requirement specification document and for some critical CR’s develop approach document.
• Deliver technical expertise by troubleshooting and resolving technical issues, writing and modifying code, creating reports and queries, developing new applications, scheduling batch processes, and assisting end users.
• Worked extensively on Consolidated and non-consolidated Invoice reports using BI Publisher(XML)
• Tested modifications to ensure they meet customer’s specifications. Provided on-call support to the end-user.
• Worked extensively on Application Designer, People Code, Application Engine, Component Interface, File Layout, Data Mover, SQR, Integration Broker, Workflow, PS Query, Security, Process Scheduler, Spread sheet Upload, PeopleSoft Test Framework.
• Worked as a shadow resource to assist the team on Peoplesoft Test Framework (PTF).
• High level Quality review updates to management in Senior Review meetings.
• Designed and developed inbound and outbound interface using App engine.
• Extensively used People Code for customization of pages and validating the data.
• Review of the deliverables i.e. designs, unit test cases and technical documents of other team members.
• Responsible for conducting Quality meetings.

Technology/Tools: PeopleSoft FSCM 9.0, People Tools8.49, SQL Server.

Confidential, Louisville, KY

Senior Application Developer (FSCM/HCM & CRM)

Responsibilities:

• Worked as a techno functional consultant in PeopleSoft FSCM Application Upgrade project from version 9.0 to PeopleSoft 9.2 and People Tools version from
• PeopleSoft HCM Application Upgrade project from version 8.8 to PeopleSoft 9.2 and People Tools version from
• Gather Requirements from business users related to their business functionality and understand their current system
• Provided technical analysis, feasibility study and estimate efforts for the new requirements.
• Responsible for reading compare reports and creating objects to retrofit.
• Worked closely with functional lead and client during fit gap and provided technical inputs to customizations.
• Recognized the mappings of records and fields that had changed, renamed, added and deleted in FSCM by comparing it with vanilla version.
• Retrofitted several SQRs, Crystals, Pages and Components and was accountable to its proper functionality.
• Developed various conversion programs using AE and CI.
• Created numerous conversion programs using Application Engine to load the data in to the custom tables with multi threads.
• Recognized the mappings of records and fields that had changed, renamed, added and deleted in FSCM by comparing it with vanilla versions.
• Created inbound and outbound interfaces to load and export the data to other systems.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Provide production support for FSCM applications.
• Analyse and resolve problem tickets in a timely manner.
• Resolve all issues related to FSCM process on a day-to-day basis.
• Perform Fit Gap Analysis based on the current and new PeopleSoft System for all the modules including Order to Cash such as Billing, Accounts Payable, Accounts receivable, GL, eProcurement, and Security in Financials using agile methodology. Review the fit gap documents with business before finalizing
• Prepare High level functional and technical designs based on the fit gap document and provide the design to the business users
• Used Application upgrader to migrate objects from Demo to Target instance.
• Gather the workflow requirements from a business users and prepare a requirement document
• Finalize the reporting requirements with users & provide specifications for the same to the technical team.
• Analysis of compare report between 9.1 and 9.2
• Analyse and gather requirements from Security administrator related to current security design and prepare High level design using Agile methodology
• Assist the users in designing the system using PeopleSoft Set Ups for Financials
• Develop enhancements and customizations for FSCM modules include AWE using People Tools Components, Pages, Records, Menus, Folders and Nodes according to technical specifications.
• Ran System Audit Reports to compare data structures defined in the People Tools tables against the underlying database to uncover inconsistencies.
• Upgraded projects using Application Upgrader to move objects (panels, queries, records, Fields, etc.) between databases and to compare the base version with the version available currently. Then, upgrade the Application, based upon the upgrade report and copy the latest version to the target database.
• Migrate developed code from development to testing environments and provide assistance to the users in User Acceptance Testing.
• Convert Crystals to BI Publisher and develop new BI Publisher reports.

Technology/Tools: PeopleSoft CRM 8.9/9.2, PeopleSoft FSCM 9.0/9.2,PeopleSoft HCM 8.8/9.2People Tools 8.49/8.53, DB2 9.7, ORACLE 11g

Confidential, New York

Senior PeopleSoft FSCM Application Developer

Responsibilities:

• Responsible for developing Interfaces for AR, Billing and Vendors from PeopleSoft
• Involved in the functional design gathering for new enhancements.
• Created BI Publisher Reports for Monthly, Quarterly & Yearly using PS Query.
• Worked on testing the Integration Broker that sends file to third Party Vendor.
• Learned the functional concepts of Recruiting and created job openings hosted in online for job seekers.
• Involved in debugging the complex Application package codes and resolved most of the issues.
• Development and Unit test plan creation.
• Interacted and provided my expertise with peers on their issues whenever required.
• Involved in design and development of GL interfaces from 3rd party system to PeopleSoft
• Supported Cash Management and Purchasing & Accounts payable issues
• Developed Interface to create Purchase Orders with in PeopleSoft from the user requirement
• Developed an application engine program in General Ledger to load flat file accounting entries from FTP folders into journal staging tables.

Technology/Tools: PeopleSoft FSCM 9.1, People Tools 8.52, ORACLE11g.

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• This engagement is a Level 2 support.
• Monitor the Scout PeopleSoft daily, weekly and monthly processes, applying fix for process failures.
• Developed ad-hoc queries based on data request from business users.
• Fix Scout live issue (In/Out bound Interface Process failure, Customer data issue).
• Worked on Scout data migration tasks.
• Create/update Scout PeopleSoft codes.
• Apply new enhancements or changes to Scout PeopleSoft CRM application using Change Assistant.
• Performed PeopleSoft admin activities (Application and Web server maintenance, PeopleSoft application maintenance).

Technology/Tools: People Soft 8.9 People Tool 8.48 Oracle 10g , TOAD.

Confidential

Oracle Consulting, Application Developer

Responsibilities:

• As a PeopleSoft Application Developer involved in Analysis, Coding, Testing of PeopleSoft FSCM Applications.
• Applied HCM bundle 3 and 4 for John Diversey client.
• Applied HCM bundle 3, 4, 5 and 6 for Lonestar client and UAT is in progress.
• Customized BI interface spreadsheet to include the table BI LINE DST DFR.
• Fixed the Buyer Setup issues for Confidential and Involved in with-holding report control information and Vendor 1099 Withholding setup.
• Involved in Ticket analysis, solving crucial tickets and production support issues.
• Involved in Ticket resolving & Root cause analysis.
• Developed Queries using Query Manager depending on the Functional and Business analyst’s requirements.
• Took up the role of Primary on Call, dealing with Production issue failures (Batch Process failures, rollback errors, script Failures, etc. and its resolution.
• Developed custom AE program in GL to load journals from external interfaces into JRNL HEADER and JRNL LN tables. Created validation and Load reports
• Involved in designing the Interfaces, Reports and customization of the reports for the AR, AP, and GL Modules

Technology/Tools: People Soft 9.1/9.0, People Tool 8.48/8.50, Oracle10g.

Confidential

PeopleSoft Application Developer

Responsibilities:

• Involved in the System study and creating High level Technical Design Document and Detail technical design document based on the Functional design document and getting approval from the client.
• Creating test cases for unit testing and System test and regression testing.
• Responsible for interacting with the customers for clarifications and share the information with the responsible person.
• Developed Queries using Query Manager depending on the Functional and Business analyst’s requirements.
• Responsible for all the reviews and involved in the walk-through to get understand by client and get the sign-off.
• As per the migration checklist migrate the object to another Environment.
• Providing the pre-production support for the Phase-1email addresses from common library scripts.

Technology/Tools: People Soft 9.1, People Tool 8.5, Oracle 10g.

Confidential

PeopleSoft Application Support Engineer

Responsibilities:

• As a PeopleSoft Application Support Engineer, involved in system study and Impact analysis based on the maintenance Requirement document.
• Creating High-level Technical Design Document and Detail technical design document and getting approval from the client.
• Creating test cases for unit testing and System test and regression testing.
• Responsible for interacting with Confidential users from Australia and Regional users for all the day-to-day problems along with the batches in Regional Accounts Payable and Regional General Ledger internal modules.
• Providing the Level-1 and Level-2 Support
• Involved in a Triage as part of production support, assign the tickets and provide the support to the team.
• Involved in Ticket analysis, solving crucial tickets and production support issues.
• Involved in Ticket resolving & Root cause analysis.
• Developed SQR, Crystal reports and Queries using Query Manager depending on the Functional and Business analyst’s requirements.
• Took up the role of Primary on Call, dealing with Production issue failures (Batch Process failures, rollback errors, script Failures, etc. and its resolution.
• Involved in creating the checklist Document which reflects the day to day status of the Control-M jobs (Night batch jobs)
• Performed Unit Testing on Various modules and prepared suitable test cases.
• Developed Crystal reports depending on the Functional and business analyst’s requirements.
• Coding/Designing/Testing as per change request.

Technology/Tools: People Soft 8.4 SP2, People Tool 8.45, Oracle9.2, TOAD.

Confidential, St. Louis, MO

PeopleSoft Application Developer

Responsibilities:

• Having the walk through with the client for document specifications.
• Developed fields, records, pages, components and menu definition objects related to this project based on the Technical design document.
• Prepare the Detail technical design document and walk-through with client.
• Creating test cases for unit testing and System test and regression testing.
• Involved into Development of online screens and inquiry screens.
• Move all the objects from One Environment to another Environment.
• Developed the reports Using PS Query and Crystal reports.
• Carrying out page design, Interfaces, Data migrations, Coding and testing of Application Engine, Reports. Importing data into PeopleSoft systems from Flat files using File Layout and App. Engine.

Technology/Tools: People Soft 9.0, People Tool 8.5, Oracle9i.