SUMMARY:

• Over 8 years of overall IT and Project Management experience in Analysis , Design , Development, Support and Implementation of PeopleSoft Financials and HCM Applications.
• Excellent knowledge of PeopleSoft FMS/SCM modules General Ledger, Purchasing, Accounts Payables, Accounts Receivables and Billing.
• Worked in PeopleSoft HCM modules like NA Payroll , Core HR , Benefits .
• Experience in Implementation , Customization , Production Support and Upgrade .
• Worked closely with Business users in capturing requirements and creating Functional Design documents (BRD & FRD) and designing Technical Documents based on FRD.
• Expert knowledge in PeopleSoft technical toolset nVision Reporting tool, (Application Designer, PeopleCode, Application Engine , File Layout, Component Interface , ExceltoCI, Security Administration, Process Scheduler, Workflow, PSQuery, BI publisher , SQR, Crystal Reports, Integration Broker and Data Mover).
• Proficient in the creation of complex reports using SQR , XML / BI Publisher and Crystal Reports .
• Excellent process orientation in performing project scoping , business process re - engineering , fit/gap analysis , requirements gathering , functional design , application configuration , user interactions, testing and production support.
• Worked intensively with Security Administrator to implement Definition Security, User Security ( Single SignOn , and LDAP) , Application Data Security (Creating Permission Lists , Roles and User Profiles), Row level Security and Portal Security .
• Expertise in developing multiple PeopleSoft FSCM interfaces - both Outbound and Inbound - with third party systems using SQR, Application Engine, Component Interfaces and File Layout.
• Excellent hands on experience in configuring and implementing the Integration Broker (for both synchronous and Asynchronous operations) for internal and external (third party) systems, Web services, Component interface based Web services, SOAP based and REST based Webservices.
• Experienced in Batch Processes Scheduling, Customization , Conversion and Migration .
• Resolved time sensitive issues with mission critical programs using traces and debugging code .
• Experience and through knowledge on the Software Development Life Cycle (SDLC).
• Effective communication skills and coordination between globally located teams.

TECHNICAL SKILLS:

Enterprise Software: PeopleSoft 9.2/ 9.1/9.0/8.9/8.8/8.3/8.0/7.5

Language: People Code, Java, C++, SQL, Swift Programming

Tools: People Tools 8.x/I/II (Application Designer, Integration Broker, File layout, Component Interface, Application Engine, Workflow )

Testing Tools: Rational Robot

Reporting Tools: BI Publisher, SQR, PSQuery, Crystal Reports, nVision

Operating Systems: Windows NT 98/2000/2003/ Vista, UNIX, OSX

Databases: Oracle7.x/8.x/10g, DB2 and MS-SQL Server

PROFESSIONAL EXPERIENCE:

Confidential

Senior PeopleSoft Techno - Functional Consultant

Responsibilities:

• Served as a senior member of the AP development team on upgrade and support of Financials (AP, EX, GL, PO and ePro modules).
• Analyzed, designed and documented technical design specifications to carry forward numerous custom objects and customizations to delivered AP Pages, PeopleCode, Records, Fields, Application Engine programs, database triggers, etc.
• Performed full lifecycle development to adapt customizations to the Voucher Build Application Engine programs required for custom AP workflow and interface processing, which was complicated by the extensive differences in Voucher Build between PeopleSoft versions 8.1 and 9.0.
• Carried forward and debugged a customized Application Message and associated PeopleCode to subscribe to messages from PeopleSoft HR containing employee job code changes for use by custom AP workflow. This effort included testing the Service, Service Operation, Queue, etc. set up in Integration Broker to subscribe to the message.
• Modified, debugged and tested delivered and custom AP Pages, PeopleCode, Records and Fields to add a hyperlink to display the scanned image of the associated invoice by use of the dynamically-addressed URL for the image in LiveLink.
• Resolved defects to AP custom and delivered definitions that were discovered during system and integration testing by researching causes of problems with online processing (Pages, Records, PeopleCode, Security, etc.) and batch processing (Application Engine programs, SQR's, etc.), identifying and/or coding solutions, unit testing and obtaining approval for migration of solutions to the affected environments.
• Provided post-implementation support of AP custom and delivered functionality, particularly with customized AP Workflow and Approval processes

Confidential

PeopleSoft Financial Consultant

Responsibilities:

• Involved in the Focus Project (Upgrade & Implementation) of GL , AR and Billing modules with their integration with AP, GL.
• Involved in data conversion from their existing legacy systems to PeopleSoft system (using SQR programs).
• Worked with the People Tools 8.54 Integration Broker and involved in setting up the local gateway and created different target nodes as per the requirement.
• Involved in different phases of QA Testing like Unit Testing , Integration Testing and Regression Testing.
• Wrote complex SQL Queries using joins , unions and nested sub-queries . Created index on database tables for improving the performance.
• Created Dynamic Views and Dynamic Call Sections based on the business requirements for better performance.
• Developed/Modified PeopleSoft objects like Pages , views and people code according to the business requirements.
• Developed different custom reports using PS Query and Crystal Reports .
• Modified Lockbox Interface and Payment Predictor in Account Receivables System .
• Worked in the Post Implementation Production Support for PO, AR & BI modules.
• Developed custom Application message leveraging the People Code and related details from the delivered Vendor Full Sync App Message to include only required details as delivered message was failing for large volume.
• Customized PeopleSoft delivered App Engine processes to send PO's to vendors that are neither direct merchants nor Market Place vendors . The processes modified were Purchase Order Dispatch process (PV PO DISPATCH) and the Batch Dispatch process (PV DISPATCH).
• Supported in troubleshooting of processes like Payment Selection, Payment Creation , Voucher Posting (AP PSTVCHR) and Payment Posting (AP PSTPYMNT) in AP .
• Developed reports for Accounts Payables and Accounts Receivable modules using SQR and PSQuery Tool .
• Creating new Customer Credit Reference Details SQR report which prints out Customer Name , address and Credit amounts and will give Aging Category and Payment History details on As of Date.
• Developed open PO report (SQR Report) to list all open purchase orders.
• Modified the POPO005.SQR to print the Manufacturer's information and Vendor Information for every Item on the Purchase order.

Confidential

Technical Consultant

Responsibilities:

• Involved in PeopleSoft Financials 8.9 Implementation, Enhancements and Support .
• Involved in Conversion Programs from End to End and fine-tuned many conversion programs.
• Developed multiple Inbound Interfaces for the components in Purchasing module using Component Interface, File Layout and Application Engine along with custom error handling.
• Developed an interface, which loads the data into Requestor Component using ExceltoCI .
• Involved in meetings with Business Teams and Users while configuring new GL/AP/PO business unit definitions.
• Worked along with functional Team in fixing and troubleshooting problems in designing and development.
• Involved in Customization of existing Pages using PeopleCode , Dynamic View and dynamic prompt concepts.
• Involved in migration of objects between Development, QA, UAT and Production environments
• Worked on PS Query , to get information as required by the client for reporting purpose.
• Developed queries to run through Query Manager for report reconciliation using PS Query .
• Implemented the AWE for requisitions for PO module and Projects approval for Project Costing module.
• Developed a new SQR process which generates procurement information from new 3rd party system which will be used in AP EDI interface.
• Involved in resolving issues raised during SIT/UAT .
• Involved in modification and fine-tuning of Application Engine, SQR programs.
• Involved in PeopleSoft Application Security Design in Accounts Payable, Purchasing and Custom application s.
• Created Functional Specification and Technical design documentation.
• Customization of REQUSITION, PURCHASING and VOUCHER components based on customer request.
• Worked extensively on Application Engine, Component Interface, File Layout, People code and Crystal Reports
• Wrote technical specifications for the custom applications developed.
• Create new PeopleSoft records, pages and components for setting up Commission and Royalty calculation rules.
• Created complex SQR's for data processing and reporting.
• Responsible for preparing mock conversion programs to identify the performance of the conversion.
• Designed and Developed Custom Crystal reports for Billing and Pay Cycle,
• Helped functional and end users in creating Queries in PSQuery to generate expected results.
• Customized PeopleSoft pages, records, components, and People Code for user requirements.
• Involved in developing and customizing the reports using the tools PS Query SQR, and XML Publisher reports.

Confidential

PeopleSoft HRMS/HCM Technology Developer

Responsibilities:

• Design and review of Business Solution document, High level design and detailed designed documents and coordination between Onsite and Offshore team members.
• Involved in design, development, fit/gap analysis and requirement gathering of enhancements to existing requirements for consolidation.
• Involved in Time and Labor Modules.
• Responsible for requirement gathering, design, testing, Implementation of the Leave Accrual Process within Base Benefits.
• Estimate, plan, assign, assist and track development specific to Core HR and NA Payroll.
• Involved in Payroll Processing and have working knowledge on tables like PAY TAX, PAY CALENDER, PAY CHECK, PAY EARNINGS, PAY DEDUCTIONS, etc.
• Involved in developing the SQRs for benefits out bound interfaces.
• Requirement gathering for Data conversion from PeopleSoft to Oracle fusion HCM.
• Data analysis in PeopleSoft HRMS and developing reports using PSQuery.
• Comparing Oracle HCM fusion and PeopleSoft HRMS functionalities.
• Responsibility included requirement Gathering, Analysis, Design and Estimation.
• Technical Issues Resolution (Analysis, fixing and Tracking)
• Creating complex SQL to retrieve the data from PeopleSoft.
• Preparing test case documents and testing extracts.
• Fixing up technical issue by providing resolution as Technical Fixes for issues as part of code changes and process changes.
• Conversant with Administration Tools such as Process Scheduler, PeopleSoft Security and Data Mover.
• Gathering requirements from Functional team and communicating the requirements with offshore team.

Confidential

Junior PeopleSoft HRMS Technical Developer

Responsibilities:

• Developed and modified various interface SQR programs and reports in HR, Payroll to meet the business requirements.
• Customized the existing interface programs for the HR to send flat files to various vendors for employees enrolled in different medical and dental plans.
• Developed complex SQR program that creates multiple reports dynamically based on various parameters.
• Involved in modifying various online pages.
• Supported in Troubleshooting and fixing of batch processes for HR, Payroll modules.
• Worked with Employee Self Service Module and Manager Self Service Modules.
• Extensively used People Tools for creation and modification of Process Definitions, Records, Pages, components to run Custom SQR's and Application Engine.
• Interacted with QA Team for conducting functional testing, regression and user acceptance testing for PeopleSoft HR, Payroll applications.
• Understanding project plans, templates, checklists and standards.
• Applied bundles and Tax updates to Development environment.

Confidential

Associate Analyst

Responsibilities:

• Involved in Creation/Development and Customization of Tables, Views, Pages, Components and Menus using Application Designer.
• Developed several Queries for the Financial Reporting Purpose in AP, PO & GL.
• Involved in setup like User Preferences & Banking Information.
• Worked on Excel to Component Interface for the Vendor Upload Process.
• Involved in the design of Audit functionality to create various records and implemented effectively.
• Created various New SQR Reports and modified the existing SQRs as per the client requirement.
• Development, Documentation, Design & Unit Testing of Application Engine Programs for FSCM as part of enhancements.
• Developed different custom reports using SQR to meet user specifications.
• Read to records and writing to the files by using the Excel files and App Engine.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins and sub-queries.