SUMMARY

• 14+ years of experience in design, development, migrations, Data Conversion, Upgrade, implementation Maintenance and Production support of PeopleSoft HCM 8.9/9.0/9.1/9.2 and FSCM 8.9/9.0/9.1/9.2 Modules.
• Experience in wide range of PeopleSoft HCM modules including Core HR, Base Benefits, Ben Admin, NA Payroll, Time and Labor, TAM, Candidate Gateway, Absence Management, MSS, ESS, Pension Administration, General Ledger, AP, AR, Billing, Purchase Order, E Procurement, Grants Treasury and Project Costing.
• Extensively worked with People Tools (8.1X, 8.4X, 8.57), Application Designer, and People Code, Application Engine, Application Package, Integration Broker, Component Interface, iScript, File Layout, and Workflow/AWE tools.
• Experienced in applying TAX updates/Patches/Bundles, Migrations using STAT&PHIRE, Data loads in Prod.
• Experienced in trouble shooting the Production issues, retrofitting the Bundles and upgrade objects.
• Closely monitor the online pages and jobs, improved the performance by applying the hints.
• Wrote DMS/Execute the scripts to move the data from one instance to another instance.
• Experienced in latest tools Page composer, Page field configurator, Drop zones & related content service.
• Ensure the integrity of People soft applications by running the Audit Reports and fix them accordingly.
• Designed, developing and customized Fields, Records, Pages, Component, Menu and wrote People Code at all events of record, component record and Page Activate.
• Created various Reports using PeopleSoft Reporting Tools, SQR, Crystal Reports, XML/BI publisher, PS Query. Developed and tuned SQL queries.
• Experienced in converting Classic Pages to Fluid Pages and build and troubleshoot the Fluid pages.
• Expert in customizing the WORK CENTERS and DASH BOARDS.
• Experience in PeopleSoft Enterprise Integration Points such as People soft CRM< - >Financials/SCM & Financials/SCM<->HRMS. Also worked for integrating middleware (web services, MQ Series) with People soft system
• Experienced in converting the Autosys jobs into People Soft Process Scheduler.
• Experienced in retrofitting CEMLI’s migrating from SQL server to ORACLE 10g.
• Installed PeopleSoft HCM 9 and PeopleSoft Financials 9 on People Tools 8.49 as a demonstration/sandbox environment
• Experienced in Change Packer/PUM, Upgrade Assistant, Compare reports Tree Manager, Data Mover and data administration tools such as Process Scheduler and Configuration Manager.
• Worked on providing PeopleSoft Security thru Permissions and Roles, also worked on PS Application security, department security.
• Created Functional, Technical Documents, User guide and training material.
• Expert in troubleshooting the production applications.
• Experienced in retrofitting online Pages, SQR’s, People Code, COBOL, AE’s, IB’s after the Tax Update /Bundles/PUM images applied.
• Extensively used defect tracking tools such as JIRA, HP ALM, service now, Rational tool (CCM)

TECHNICAL SKILLS

Programming Languages: People Code, SQL, C, C++, JavaERP: HRMS/HCM 8.3/8.8/9.0/9.2 , FSCM 9.0/9.1/9.2.

People Tools: Application Designer, People Code, Application Engine, Application Package, Integration Broker, Component Interface, Application Messaging, Upgrade Assistant, Tree Manager, Integration Tools, Data Mover, Workflow/AWE, File Layout, Business Interlink.

Reporting Tools: SQR, Crystal Reports, Tree Manager, PS/Query, XML/BI publisher

PeopleSoft Administration Tools: Process Scheduler, Configuration Manager, Security (Permission & Roles), Compare reports, Project migration, Autosys, PHIRE, STAT.

Database Technologies: Oracle 9i/8/7.x,10g, SQL Server 2005, MS Access, TOAD, PL-SQL, SQL developer.

Application/Web Servers: Web logic, Tuxedo, Jolt

Operating Systems: Windows 95/98/2000/NT/XP, UNIX/Linux, Putty, Winscp, SFTP, Shell Scripting.

Web Technologies: HTML, XML, SOAP/RESTFUL, Java Script, JIRA, ASM.CCM.

PROFESSIONAL EXPERIENCE

Confidential, Austin

Senior PeopleSoft Developer

Responsibilities:

• Design and develop the custom AE program to trigger missing IDX messages.
• Work with Business Users to gather and document requirements to apply system solutions to business needs.
• Involved in the design and development of BI publisher reports for AR/BILLING/Purchasing modules.
• Resolved the support issues raised by users.
• Modified the PSFT HCM GL(General Ledger) interface as per the business requirement.
• Troubleshoot the production tickets of HCM 9.2 & FSCM 9.2
• Modified the cash forecasting page and implement the code as per the business requirements.
• Worked on AWE (Approval workflow engine) to setup workflow for approving Bidders/Suppliers.
• Developed the supplier load, invoice load and AM load interface between PeopleSoft and Ivalua procurement system.
• Prepare test scripts for AM, PO, AP(Account Payable) and GL(General Ledger) modules and testing the configured scenarios, Unit testing, System and Integration Testing.
• Customized the cash forecasting page and display the data by writing custom code to meet the business requirements
• Setup Expense ReportApproval Workflow Engine as per requirements.
• Modified the on boarding application package to provide early access to both existing clients and new clients.
• Design and developed the XML schema to read the CLSR & early access date field from NH Form.
• Modified the date of hire change SQR to reflect actual hire date.
• Wrote the code to gray out the Business unit field and default the value from PF client.
• Retrofitted the people code/SQR objects after the tools and PUM image upgrade to 8.57.
• Applied Tax updates and conducted payroll testing for SAL and HRL Pay groups after applying tax updates.
• Wrote the code to update the dates such as Hire date, rehire date, service date, orig start date with actual hire date.
• Made a configuration changes as per the business requirements.
• Integrated the Peoplesoft with third party system and load the hire data into PSFT using component interface.
• Create the CAPI project and migrate the code changes by using big bucket pull request.
• Worked on defects during system testing/Integration testing.
• Performed the unit testing and fix the issues during unit testing.
• Integrating the PeopleSoft HCM with Passport /Green stack system using Integration Broker.
• Worked in JIRA stories in agile /Sprint environment and provide the estimates in grooming sessions.
• Troubleshoot the legacy bulk hire application engine and fix it as per the business requirement.
• Create the schedule id and run the ben admin program to verify the employee’s benefits start date.
• Design and develop the custom page in job data component to accommodate alternate emplid and email id.
• Write the people code to enforce the validations to implement business rules.
• Develop the various reports using the SQR/PS Queries.
• Modified the application package people code to create the service order in PeopleSoft CRM.
• Troubleshoot the issues that are related to tax distribution page updated with incorrect date.
• Modified the PL/SQL stored procedure to sync the data back to HR portal.
• Migrate the AMBROSE legacy HR data into Trinet HR system using Bulk Upload method.
• Run the pay sheet, pay calculation and pay confirmation process to check the employees pay data in QEB environment.
• Create the service request against oracle and apply the fix provided accordingly.
• Wrote the code to audit the elapsed time data modified by the employee.
• Wrote the bulk SQL update to update the incorrect data.
• Run batch security programs to resolve the security issues.
• Modified the Term application engine program to reflect actual termination date.
• Ran the periodic pension process to check employee pension balances.
• Troubleshoot the carrier feeds third party benefits interface issues.

Environment: People Tools 8.54/8.57, Oracle 12c, Windows Server 2012, UNIX.

Confidential, New York State, NY

Senior PeopleSoft Developer

Responsibilities:

• Applied Tax updates and conducted payroll testing for SAL and HRL Pay groups after applying tax updates.
• Developed the custom application engine to interface check payments received in FIN to apply against customer loans in HCM.
• Create the PHIRE project to promote the changes from one instance to another instance.
• Ran the SYSAUDIT & DDAUDIT report and cleanup the orphan objects in UATB.
• Worked on defects during system testing/Integration testing.
• Performed the unit testing and fix the issues during unit testing.
• Integrating the PeopleSoft HCM with OPA system using Integration Broker.
• Design and develop the custom loan application where end users can apply the loans.
• Design and develop batch AE program to calculate the insurance and interest rates of loans monthly.
• Design and develop the self-service pages where end users can apply for the loans.
• Develop the custom BI publisher reports to send the notifications to member and employer.
• Created Custom setup pages and components and developed process for GL(General Ledger) interface between PeopleSoft HCM and PeopleSoft Finance to transfer data from transaction table to HR Accounting Line table in HCM and HR accounting Line table is FSCM.
• Write the people code to enforce the business validations at various events.
• Develop the various reports using the SQR/PS Queries.
• Troubleshoot the Interfaces developed by using the Integration broker, SQR’s, Application Engine
• Extensively used SOAP UI tool to test the integration between PeopleSoft and OPA.
• Responsible for customizing fluid pages, and developing Tiles for ESS, MSS.
• Expert in Application Engine, People Code, Component Interface, Integration Broker, Application Packages (Object Oriented Programming), Data Mover, SQR, Process Scheduler and PS Query
• Created outbound interface that sends enrollment/termination details of the employees for the plans provided by Benefit vendors.
• Retrofitted the customized SQR’s due to tax updates and applied the customizations due to PUM Images.
• Design and develop the custom AE program to import the data from custom payment table to open item table.
• Work with Business Users to gather and document requirements to apply system solutions to business needs.
• Customized the payment predictor process to develop custom algorithms to apply the payments made against loans as per the business requirements.
• Ran the periodic pension process to check employee pension balances.

Environment: People Tools 8.55, Oracle 11g, Windows Server 2012, Linux.

Confidential, Florida

Senior PeopleSoft Developer

Responsibilities:

• Ran compare reports and identified the customizations from the compare report and performed project migration. Coordinated with testing team to perform Unit and Integration Testing
• PeopleSoft Senior Financials Developer Financials 9.1 and Supply Chain Management. Development, Enhancements, Performance Improvements and Support of Accounts Payable, Purchasing, Workflow, Cash Management and Treasury Applications.
• Work with Business Users to gather and document requirements to apply system solutions to business needs.
• Converted the Custom pages into the fluid Pages to make necessary changes as per customer requirement.
• Responsible for Retrofit of SQR’s, People Code and Application Engine programs, online objects and people code (PUM Image) .
• Cash flow and Treasury XMLP reports
• Responsible for Converted the Custom crystals Reports (AR, Billing) into BI Publisher.
• Performed the unit testing and fix the issues during unit testing.
• Responsible to configure Fluid approval page by using the PeopleSoft Page composer.
• Configured and troubleshoot the AWE related to Bidder /Supplier/PO’s/Voucher as per business requirement.
• Configured the Work center/Dashboard as per the business requirement.
• Configured the Fluid Homepage as per the business requirements.
• Worked on defects during system testing/Integration testing.
• Raised the SR against oracle support team and extract the individual fix from PUM and applied the same to testing environment.
• Responsible for customizing fluid pages and developing Tiles for all home pages.
• Work with Business Users to gather and document requirements to apply system solutions to business needs.
• Created the custom triggers on tables for audit purpose.
• Performed the testing from order to Cash Cycle.
• Extensively worked on issues related to e-Procurement.

Confidential, Arizona

Senior PeopleSoft Developer

Environment: People Tools 8.54/8.55, Oracle 12c, Windows Server 2012, AIX

Responsibilities:

• Work with Business Users to gather and document requirements to apply system solutions to business needs.
• Document system enhancement proposals, outline issues, alternatives and provide recommendations detailing performance, costs, scheduling, time and benefits.
• Upgrade Preparation, analyzing the PS 9.1 customizations and compare with 9.2 functionality. Bring new functionality in 9.2 to the users notice.
• Retrofit the customizations and migrate to the test environment.
• Responsible for customizing fluid pages, and developing Tiles for ESS, MSS and Workforce Administrator.
• Perform all PeopleSoft Time & Labor, Benefits and North American Payroll configuration to meet new business requirements. Performs functional testing
• Retrofit the HR, Payroll and Time and Labor customizations from 9.1 to 9.2 upgrade environments.
• Have done bug fixes in the T&L-Time Admin and Loader processes.
• Migrated T&L Rule programs and Rules migrations to the upgrade environment and tested.
• Responsible for writing T&L custom rules - Sunday Premium, and shift rules, also responsible for Unit and system Testing.
• Applied Tax updates and conducted payroll testing for SAL and HRL Pay groups after applying tax updates.
• Worked on Production support tickets, analyzed the root cause of the issues and provided solutions.
• Customized the HR TREE BLD application engine program to display the vacant positions at org chart Viewer.
• Modified the application package people code to hide vacant position based upon the custom setup.
• Developed the custom HIRE pages which will hire the employee after certain approval and load the data into the PeopleSoft JOB, PERSONAL DATA components.
• Setup AWE for employee related transactions such as promote, Pay Rate change etc..
• Designed the custom run control page which is being used to run all custom programs.
• Wrote the custom application engine to pull employees benefits data to send to vendors.
• Modified the existing BI Publisher of paycheck to meet business requirements.
• Designed the functional specifications as per the business requirements and prepared the technical design based upon functional specifications.
• Wrote the custom PS Queries as per business needs.
• Performed Impact analysis during the Code fixes, so that the fix provided wouldn’t affect the current structure and anywhere else where the objects are being used.
• Extensively involved in Code Debugging and Code Fixes during the User Acceptance Testing.
• Converted the classic pages into the FLUID pages as per the business requirements.
• Reapplied the customizations due to customizations were not fitting due to 9.2 changes.
• Extracted the PUM 19 image and applied the individual fix.
• Retrofitting the PT Branding Objects after the tools upgrade to 8.55.
• Used the defect tracking tool JIRA to track the progress of the defect.

Confidential, Columbus, Ohio

Senior PeopleSoft Developer

Environment: People Tools 8.53, Oracle 12c, Windows Server 2012, AIX.

Responsibilities:

• Implemented the new Time and labor validations and rules, wrote necessary SQL objects.
• Work with Business Users to gather and document requirements to apply system solutions to business needs.
• Troubleshoot the TL TIMEADMIN process and improved the performance by applying the hints.
• Load the employee data Such as Personal Data, Job Data from legacy system to PeopleSoft by using the CI and AE program.
• Retrofitted the customized SQR’s due to tax updates and applied the customizations due to bundles.
• Worked on PeopleSoft to HIRERIGHT Background check request using SOAP based web service Integration (Configured the IB (Gateways, Nodes, Messages, Services, and Service Operations and People Code)
• Consumed the WSDL provided by HIRERIGHT and generated message, Service and service Operations.
• Created outbound/Inbound interface that sends enrollment/termination details of the employees for the plans provided by Benefit vendors.
• Customized pages foreBenefitsto deliver Benefit Enrollment pages, Health Plan pages, Managing Insurance Plans an employee can access.
• Loaded the Promotions, Pay Rate changes into Job Data by using the Excel to CI.
• Developed the custom HIRE Bolt on Application to meet customer business requirements
• Setup AWE for custom HIRE and built necessary pages, components for approval process.
• Converted the crystal Reports into the BI Publisher as crystal Reports are deprecated in higher version.
• Designed pages and wrote custom application package code for employee bonus and salary increase letter and built BI Publisher Report, Email Notifications
• Designed the functional specifications as per the business requirements and prepared the technical design based upon functional specifications.
• Created Records, Pages, views, Menus, Permission list objects to build Bolt on Application.
• Retrofit of SQR’s, People Code and Application Engine programs, online objects and people code due to patches and bundle changes.
• Ran the DMS Scripts to migrate the data from once instance to another instance.
• Applied Tax updates and conducted payroll testing for SAL and HRL Pay groups after applying tax updates.
• Worked on Production support tickets, analyzed the root cause of the issues and provided solutions.
• Responsible for Post upgrade production support.
• Developed conversion programs for PeopleSoft Payroll Components like Earning Balances, Special accumulator Balances, Deduction Balances, Payroll Data, Check Balances, Tax Data, and Tax Distribution.
• Developed custom programs to enable the system to perform the business process for the Leave Accrual Component
• Developed Several Complex Reports for Payroll, Benefits and Time and Labor Module
• Maintain and modify real time and batch rules used by time administration process. Work with the business users to clear up low and medium exceptions. Recognize high exceptions generated through Time Administration and Payroll Calc and works to correct any configuration set-up errors that resulted in the high exception.
• Used the defect tracking tool JIRA to track the progress of the defect

Confidential, Ohio

Senior PeopleSoft Developer

Responsibilities:

• Work with Business Users to gather and document requirements to apply system solutions to business needs
• Retrofit of SQR’s, People Code and Application Engine programs, online objects and people code due to patches and bundle changes.
• Wrote custom people code as the bundle changes are impacting the customizations.
• Applied individual fix as per the fix provided by oracle.
• Raised the SR against product support to get the individual fix.
• Involved in tools upgrade and retrofitted the impacted objects.
• Closely monitor the performance of system during the student’s enrollment and open enrollment.
• Customized the class search page as it was completely changed to due to the bundles.
• Reapplied the customizations due to the tools upgrade.
• Created the Phire Project for the modifications and promoted the changes till Production.
• Applied Tax updates and conducted payroll testing for SAL and HRL Pay groups after applying tax updates.
• Retrofitted the customized SQR’s due to tax updates and applied the customizations due to bundles.
• Worked on Production support tickets, analyzed the root cause of the issues and provided solutions.

Environment: People Tools 8.51/8.53, Oracle 11g, Windows Server 2008, Linux

Confidential

PeopleSoft Techno - Functional Consultant.

Responsibilities:

• Deploy the changes from once instance to another instance and finally to Production by using application designer and tools such as STAT /PHIRE.
• Work with Business Users to gather and document requirements to apply system solutions to business needs
• Provided the data fix and run them in Production.
• Load the data into the production system.
• Worked on Production support tickets, analyzed the root cause of the issues and provided solutions.
• Applied Tax updates and conducted payroll testing for SAL and HRL Pay groups after applying tax updates.
• Developed the Custom payroll SQR as per the business requirement.
• Maintain data integrity by running SYSAUDIT & DDAUDIT reports and perform the cleanup accordingly.
• Perform the functional setup such as table set sharing for departments.
• Build the PS Query as per the customer needs.
• Closely monitor the batch jobs and fix them if it fails.
• Ran the DMS Scripts to migrate the data from once instance to another instance.
• Improved the performance by applying the hints to both Batch Jobs and online pages.
• Retrofitted the customized SQR’s due to tax updates and applied the customizations due to bundles.
• Used the defect tracking tool JIRA to track the progress of the defect

Environment: People Tools 8.51/8.54, Oracle 12g, Windows Server 2008, Linux

Confidential

Senior PeopleSoft Developer

Responsibilities:

• Performed Impact analysis during the Code fixes, so that the fix provided wouldn’t affect the current structure and anywhere else where the objects are being used.
• Extensively involved in Code Debugging and Code Fixes during the User Acceptance Testing.
• Provided technology estimates for the Change Requests raised by the Business stakeholders.
• Retrofitted all the objects which are having schema references.
• Ran compare reports and identified the customizations from the compare report and also performed project migration. Coordinated with testing team to perform Unit and Integration Testing
• Applying customizations on the objects in higher version
• Responsible for retrofit of SQR’s, People Code and Application Engine programs (CEMLI’s) .
• Responsible for Post upgrade production support.
• Provided the weekly status reports to project management.

Environment: People Tools 8.51, Oracle 11g, Windows Server 2008, Linux

Confidential, Omaha, NB

Senior PeopleSoft Developer

Responsibilities:

• Prepare record field mapping and identify the changes in new version, 9.1
• Apply technical changes listed, on the code as per the mappings
• Applying customizations on the objects in higher version
• Responsible for retrofit of SQR’s, People Code and Application Engine programs (CEMLI’s)
• Customize PSqueries using PS Query tool and compare the generated reports
• Retrofit crystal reports as per the changes in 9.1
• Work on SR’s raised by the client and provide solutions Apply individual fixes for any delivered defects in the new version
• Conduct CEMLI related dry run activities
• Retrofitted all the objects which are having DB link references.
• Ran compare reports and identified the customizations from the compare report and performed project migration. Coordinated with testing team to perform Unit and Integration Testing.

Environment: People Tools 8.50, Oracle 11g, Windows server, Linux

Confidential

Senior PeopleSoft Developer

Responsibilities:

• Involved in creating the Technical design documents, Functional documents and preparing the test case documents
• Retrofitting the CEMLI’s (AE, SQR, Online objects etc) after the tools upgrade/migration or Data base migration from SQL server to ORACLE.
• As part of tools upgrade from, configure the Gateways, nodes, Service operations and routings after custom application messages upgraded into service operations.
• Wrote DMS/Execute the scripts to move the data from one instance to another instance.
• Configure instances like TEST, PROD by Promoting Retrofitted CEMLI’s (Online and file system objects) from one instance to another instance.
• Analyzed the impact of patches/Bundles on customized objects by running the Compare reports and also retrofitting customized objects after the patches are applied.
• Coordinated with Functional team to perform Unit and Integration Testing.
• Ran the SYSAUDIT, DDAUDIT Reports to ensure the integrity of People soft applications.
• Build and execute SQL scripts to update the paths in run control pages and also list out all the custom/customized objects in people soft.
• Provide the estimates for upgrade projects/Enhancement projects.
• Converted all Autosys jobs into process scheduler and schedule them accordingly, added notifications also. Modified the existing UNIX scripts to make them work with Process Scheduler.
• Wrote the New MetLife/Health Equity interfaces (In and Out) for auto & home plan by using the app engine programs.
• Enhanced the existing Interfaces either by AE or SQR as per request provided by the Customer.
• Tailored People Code to implement data validation and to enforce field level security.
• Used Application Designer to customize records, pages, Components and menus.
• Installed PeopleSoft HCM 9 and PeopleSoft Financials 9 on People Tools 8.49 as a demonstration/sandbox environment.
• Build the team and Train the interns on people soft.

Environment: People Tools 8.49, Oracle 11g, Windows XP, UNIX

Confidential, Ohio

Senior PeopleSoft Technical Developer

Responsibilities:

• Worked extensively in Time & Labor, Benefits and North American Payroll (including Canadian Payroll) modules.
• Administering Open Enrollment and Event Maintenance. 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 the whole Time Labor process of receiving the files from third party till loading the data into pay sheets.
• Developed and modified various interfaces SQR programs and reports in HR, North American Payroll, Canadian payroll and Benefits.
• Involved in creation of component interface to load data to the health benefit and dependent benefit tables.
• Involved in implementation of Customized performance module for the Client.
• Gathering Requirements and work closely with the client requirements to define the Business process flow.
• Prepared detailed design specs for development process and wrote functional, technical specifications.
• Created 6 New Pages to Enter the Data for Employee/Manager/HR using Application Designer.
• Created new Fields/Records/Style sheet/HTML/Pages/Components/Menus using Application Designer.
• Used People Code for addressing wide range of business requirements, including data validation, maintaining referential integrity, and updating database tables. Expensively Used Scroll Functions/Functions.
• Assigned the maintain security to provide access of components to different users using People Tools- User Profile/Roles/Permission List.
• Developed SQR to send mails between EE/MGR/HR & running the SQR from Shell script in UNIX (Workflow).

Environment: People Tools 8.1, Oracle 9i, HRMS 8.3, Windows XP, UNIX