SUMMARY:

• Over 14 years of experience in the IT industry, performing Analysis, Design, Development, Implementation and Testing of business application systems.
• Eight years of Progressive techno - functional experience in the implementation, customization and upgrade of PeopleSoft 9.2/9.0/ 8.9/8.8/ 8.4/8.01/7.5 HRMS /FIN Modules.
• An outstanding team player with excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels
• Excellent working knowledge of the PeopleSoft Internet Architecture and the flow of data exchange between various HRMS and FSCM modules.
• In-depth proficiency of functional and technical knowledge, in addition to Design, Development, Implementation, Upgrade, Customization, Testing and Support experience in PeopleSoft HRMS Modules like HR, Recruiting, Benefits, Payroll, TL Modules.
• Proficient in developing custom pages and tables using Application Designer and PeopleCode
• Excellent working knowledge and experience using reporting tools such as BI Publisher, SQR
• Proficient in Module Development, Interfaces, Conversion, Data Migration and Report Writing
• Well versed in writing and calling procedures within the PeopleCode events
• Worked with Panels, Components, Menus, Business Process Maps and Workflow
• Extensive experience in transferring existing data from legacy systems to People Soft application database tables using SQR and Application Engine
• Hands-on experience working with the PIA architecture, Application Engine, Application Message, Component Interface, Integration Broker and Batch Processes
• Reputed Knowledge in creating specifications, project schedules, analyzing the upgrade process to re-customize and reapply the customizations, supervising design activities and interfacing with customers for successful completion of project.
• Possess excellent communication skills and good zeal in adapting to new technologies.

PROFESSIONAL EXPERIENCE:

Confidential, NewYork, NY

Sr. PeopleSoft Developer

Responsibilities:

• Worked as a Techno/Functional consultant in the upgrade of PeopleSoft 9.0/9.2 HCM
• Created the online Pages for all Job Data and Position Update Requests that require approvals, as well as the workflow logic using the Approval Workflow Engine (AWE).
• Updated the delivered Integration programs in HCM, specifically the GL (PAYGL02) and Voucher Payments to AP (PYAP VCHPOST) that integrate to the corresponding Financial modules.
• Due to COVID-19, MTA employees are allowed to work remotely. In order to address this new business requirement, I was involved in the implementation of the PeopleSoft-delivered Telework functionality. Given the business rules associated with the requirement, I applied the customization needed as required by the users for this new functionality.
• Involved in the Implementation of OnBoarding Fluid Functionality.
• Fixed multiple issues identified in the delivered GWI program (HR CMP008) in the Compensation module.
• Created a custom page in the Job Offer component of the Recruiting module to carry forward all the Position data defaults from the hiring process to the Job Data through Manage Hires.
• Created a custom program that sends all the Payroll distribution earnings details to PS Financials Account Receivables (AR) and to third party system for budgeting purposes.
• Define Rules for each functional component in Benefits - e.g. benefit plan eligibility, payroll deductions, leave accruals, life event activities - were applied, tested, and reviewed with customer subject matter experts.
• Developed a custom program to create User Profiles for the new hires.
• Involved in implementing the Module ePerformance.
• Created a Job Offer and Job Opening Approval Process as per MTA Agencies Business rules in Recruiting Module Using AWE.
• Did the analysis on existing customizations, interfaces, and reports, identified the changes that needed to be made and documented the impact from the technical perspective.
• Creating Fields, Records (building records to create database objects related to record), Pages, components and Menus.
• Created HR, Benefits, and Payroll custom interfaces and processes using SQR and Application Engine.
• Designed and developed the Application Engine process to load the applicants' data from 3rd party system to PS applicant tables using People code and Component Interface.
• Set up and maintained interfaces between PeopleSoft Benefits module and legacy benefit system.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People Code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Developing reports using SQR, PS Query. Also creating inbound (program, which takes data from flat data file and puts it into database) as well as outbound (program, which takes data from database and puts it into flat data file) interface programs using AppEngine for data migration between systems.
• Developed SQR and Application Engine programs for Data conversion and migration from Legacy System.
• Resolved the issues related to HRMS, Recruiting, and Payroll during production support.
• Involved in writing different interfaces to the legacy system in various steps in the payroll process
• Developed the Outbound/Inbound interfaces to different agencies within MTA.
• Developed Inquire panels for Dependent Benefits and Employee Benefits.
• Involved in the discussions related to adding contractors to the PeopleSoft. Defined and implemented the process for adding contractors to the PeopleSoft. Modified Records, Translate values, PeopleCode during this process.
• Prepared Test cases and Test Plans.

Environment: People Tools (8.54/8.55), PeopleCode, SQR, Workflow, File Layout, Application Engine, Component Interface, Integration Broker, Data Mover, MS SQL Server, Mainframes, UNIX, Windows NT/Windows XP/2003 Server

Confidential, Houston, TX

PeopleSoft Techno-Functional consultant

Responsibilities:

• Involved in gathering and defining requirements and overall scope definition in terms of functional and technical requirements.
• Conducted fit-gap analysis, compared the new release and business requirements and identified customizations.
• Written new SQR to report Cost by BU report to get all the details of the items for all business units.
• Involved in debugging various PeopleCode events and functions in resolving technical & functional issues.
• Involved in Re-applying of Customizations for 9.0 Upgrade.
• Worked extensively on Customizing and Testing the AP Pay Cycle Process to print the Custom Checks.
• Fixed the AR UPDATE step, which did not insert values into PENDING ITEM when an item is created via a payment worksheet.
• Developed Various Custom reports according to client requirements using SQR and XML Publisher.
• Worked extensively on application engine programs like Payment Predictor, Receivable Update of AR and Voucher Posting, Payment Posting, Matching of AP.
• Customized the POP0005.sqr for printing Purchase Orders.
• Worked on PeopleSoft Receivables Adjustments Application Engine process, PC AR TO PC, moves data from PeopleSoft Receivables to PeopleSoft Projects.
• Designed and developed custom AP to GL interface, AP to PC interface and customized PC to GL interface
• Configured the GL Journal Approval Workflow by adding four approval rule sets to the PS delivered JOURNAL ENTRY APPROVAL and route controls based on the Journal Source and Business Unit.
• Developed custom pages using PeopleCode for AR and Project Costing module
• Involved in unit testing, integration testing, system testing and developed integration test scripts for all the interfaces developed.
• Wrote complex SQL Queries using joins, unions and nested sub-queries. Created index on Queries for improving the performance.

Environment: PeopleSoft FSCM 8.0/9.0, PeopleTools 8.20/8.49, People Code, Application Engine, Integration Broker, SQR, XML Publisher, Workflow, Component Interface, Crystal reports 9.0, Oracle 9i, PS Query.

Confidential, Hartford, CT

PeopleSoft FSCM 9.0 Techno-Functional consultant

Modules: GL, AM, AP, AR, BI, ePro, Inventory and PO

Responsibilities:

• Involved in various phases of this project such as fit/gap recommendations, design and reviews, development, unit testing, devising string and integration testing, performance tuning of on-line and batch application. Conducted detailed work practice reviews for all of the business processes and identified the system requirements for business process improvement.
• Created a component interface to load the vendor components from a flat file.
• Involved in customizing the Voucher Matching AP MATCHING process.
• Created a report for the status of different vouchers for a given vendor.
• Analyzed and solved the issue when the express payment is not working.
• Created a Chart field Report that lists all valid department codes according to the user requirements.
• Resolved the issues related to the eProcurement Punchout (Integration Broker).
• Created a query for the vouchers paid by a particular origin
• Created a query to get the list of all the contracts that are need to be paid in a range of dates
• Modified the page EXPRESS ISSUE5 INV according to the user requirements.
• Solved the issue when the Application Engine AR UPDATE is not picking the groups.
• Involved in creating the journal approval workflow.
• Created an Application Engine to load the Staging tables for the vouchers, after which the voucher build process is run
• Involved in customizing the SQR FIN2025
• Created Billing Interface when the data coming from Mainframes
• Set up Several workflows for different user requirements in Asset Management.
• Created ePro workflow so that the requisition would go to buyer -> department manager -> Department Director.
• Solved various issues with ePro Workflow in UAT and Regression testing
• Did the performance tuning when the nVision report is running very late.

Environment: PeopleSoft FSCM 9.0, PeopleTools 8.49, People Code, Application Engine, Integration Broker, SQR, XML Publisher, Component Interface, Crystal reports 9.0, Oracle 9i, PS Query.

Confidential, Charlotte, NC

PeopleSoft Techno-Functional consultant

Responsibilities:

• Involved in Requirement gathering process for the reporting purpose. The process includes meeting the functional users and the end-users.
• Coordinated with the remote team to develop the code based on Technical Detail Specifications.
• Involved in retrofitting the code to apply changes after applying the bundles.
• Designed the technical document for the conversion approach.
• Developed the conversion App Engine for the conversion of AR and BI from PS8.8 to PS8.9.
• Converted Invoices related to open AR items and All 2008 YTD closed Invoices related to close AR Items to PS 8.9 BI.
• Converted installment and recurring bills, open transactions to PS 8.9 BI
• Converted all Open Items and All 2008 YTD Closed Items to PS 8.9 AR
• Converted Payments related to open items and all 2008 YTD closed Items into PS 8.9 AR
• Converted PS8.8 AR/BI Accounting entries into PS 8.9 AR/BI
• Converted customers identified as active to PS 8.9 AR/BI and Customer Conversations related to all converted Items to PS 8.9 AR/BI.
• Developed the scripts to do the conversion verification.
• Designed & developed an application engine program to import vendor information from third party system into Peoplesoft through the vendor component interface.
• S etting Up Maintaining Users in PeopleSoft eProcurement.
• Designed and developed reports for AP, AR, and Billing modules using Crystal Reports, nVision and PS Query Tool.
• Used PS Query extensively to create custom SQL Queries to generate reports.
• Designed and fully customized the Crystal Layouts (Standard Invoice, Prepaid, Property Damage, Joint Use, Quantity Grid and Consolidated Bill Invoice Crystal Layouts) in the Billing Module.
• Designed and fully customized Dunning Letters and Customer Statement Crystals (AR33000 and AR32000) in the AR Module.
• Involved in Tuning of Queries for Improved Performance..
• Worked on Patches and fixes of the Purchase Order Dispatch process (PV PO DISPATCH).

Environment: People Soft Financials 8.8/8.9, People Tools8.47, People Code, Application Engine, Application Messaging, Component Interface, SQR, Integration Broker, Crystal reports 9.2.3, nVision,Oracle 9i, Mainframes, DB2, SQL Server 2005, UNIX AIX, Ascential Datastages(ETL).