OBJECTIVE : To work as a Peoplesoft Developer and assist my team in Implementing and Developing Peoplesoft Applications.

SUMMARY OF QUALIFICATIONS:

• 5+ Years of Experience in PeopleSoft Technical Development.
• Extensive Experience in Analysis,Design,Configuration Deployment,Testing and Enhancement of the Peoplesoft Application.
• Team Member of Peoplesoft HCM Implementation,Upgrade and Conversion Projects.
• In Depth Knowledge of PeopleSoft Modules like HCM,Payroll,Benefits,Recruitment,GL,AP,AR,Billing and Self Service Modules include ePay,eBenefits,eProfile,eCompensation.
• Worked in PeopleSoft v8.9/8.8/8.3 Releases and People Toolset experience includes PT v8.x
• Well Versed with the Software Development Life Cycle.
• A Self Motivated Induvidual and also a good team player.

EDUCATION:

• Bachelor of Technology

TECHNICAL SKILLS:

Application Engine,Component Interface,SQR,Integration Broker,File Layout

Reporting Tools

NVision,XML Publisher

Programming Languages

PeopleCode,SQL,JAVA,HTML,JSP,Servlets,COBOL

RDBMS

SQL Server,Oracle 8i,9i,10g

Database Tools

SQL Plus,Toad

PlatForms

Windows,Unix,Linux

Upgrade Tools

Change Assistant,UpgradeAssistant,Security Administration

WebServers

Apache Tomcat and WebLogic

AREAS OF INTEREST:

• SQL Performance Tuning.
• Shell Scripting.
• Exploring the Functional Side of People soft Modules.

PROFESSIONAL EXPERIENCE:

Confidential, (ORANGEBURG, NY) MAY ’08 TILL DATE
PeopleSoft HCM 8.9,Payroll 8.9 Conversion and Production Support

Responsibilities:

Conversion of PeopleSoft Payroll 8.9 And Prod Support:

• I was part of the Consolidation Project, which involves a lot of Functional and Technical Aspects of People soft HRMS.
• Customized the Pay Calendar Creation Program so that we can run a Daily Off Cycle.
• Developed Application Engine Program to hire the acquired company employees into People soft System.
• Developed a Custom SQR to load the Garnishment Data of a newly Acquired Company into People soft Garnishment Tables.
• Customized the Delivered Payroll Summary Report PAY018 so that we can get payroll summary for multiple Pay End Dates rather than single Run ID.
• Written SQR’s for California Compliance Project which Populates the Employee Self Service Table according to the rules required by CA State Law.
• Written Online People Code so that CA Compliance SQR’s trigger for CA Employees while creating an Online checks.
• Written Online People code to store data into Audit Table whenever Employee changes his direct Deposit Information.
• Written an Application Engine using Component Interface to restructure the data in the Direct Deposit Table for all the Employees.
• Customized the Benefit Outbound SQR Hewitt_O, which sends the benefit Information to the Vendor Hewitt.
• Written an Application Engine with Component Interface to upload data into Onetime Tax Component from file.
• Customized the Payroll Outbound SQR which sends a file to the vendor CARTUS who provides the Employee Relocation Benefits for Verizon.
• Written an Application Engine with Component Interface to upload data into Onetime Deduction Component from file.
• Written Custom SQR for Providing Commuter Benefits for SFO Employees which inserts data into General Deduction Table.
• Modified many of the custom SQR as a part of remediation process i.e. removal of SSN data from the outbound files.
• Developed a Custom SQR for Finance Department, which prints the Earnings, Deductions, and Taxes for a Range of Pay End Dates Column Wise with each column representing one Pay Cycle.
• Written an Application Engine using Component Interface to load data into Onetime Deduction and Garnishment Components.
• Written an SQR Programs, which inserts Run Control Records into the Run Control Tables for Automated Processing.
• Written Technical Specification for the Developed Programs and updating the Technical Specifications for the Programs I customized.
• Written Unix Shell Scripts to encrypt the files that needs to be sent to the vendor using PGP and Network Data Model Encryption (NDM).
• Responsible for Unit Testing of all my Programs.

Environment:

Application: PeopleSoft HRMS/HCM 8.9(Benefits, Core HR, Payroll)
People tools: v 8.49, SQR, PS/Query, Application Engine, People Code, Component Interfaces
Database: Oracle 10g
Operating systems: Windows XP, UNIX

PeopleSoft Talent Acquisition Manager Upgrade 8.9, Payroll 8.9 HCM 8.9
Role: PeopleSoft Technical Consultant.

Implementation of Talent Acquisition Manager:

• Involved in setting up the module and its interactions with the core HR system.
• Generating the Recruitment Letters online and attaching them to the Applicant Record of the employees i.e. existing employees who were hired before a certain period of time.
• Enabled the AutoSave feature in the new version so that there are no restrictions on the number of Results returned by VerityMB search.
• Modified the Report, which displays the considered applicants so that it displays applicants related to some specific categories.
• Modified the functionality of Manager 360 Page, which forms the heart of Talent Acquisition Manager.
• Designed a Setup Page, which determines the dispositions, which a given Role can view on the 360 Page. Employees can view specific dispositions based on his Role.
• Responsible for adding code to the Application Package HRS_RECRUITMENT_TRACKING, which displays dispositions on the 360, Page based on the new set up Page.
• Modified the People Code associated with the Page HRS_PREP_FOR_HIRE according to the Client Requirements.
• Involved in solving some of the issues, which are seen while opening some Job Requisitions.

North American Payroll:

• Developed custom SQR Report “Year To Date” Report which summarizes the Employees
• Earnings, Deductions and Taxes for a given year
• Customized the Delivered DDP003.sqr to add file transmission functionality to transmit check and advices to Moore for printing.
• Developed Hours Paid Report as a tool in Manager Self Service where a Manager can view the Hours Paid for his Direct and Indirect Reports for a given Pay Period.
• Responsible for writing complex SQL’s for updating the Leave Accrual Tables as per the Client Requirements and added some fields to the Leave Accrual Page.
• Modified the SQR Report mptostf2.sqr, which is a custom SQR in Manpower, which gives a list of employees to Web Solutions for which the Timesheets should be generated for the next Pay Period.

• Linking the existing Contingent Worker Data to the new Contingent Worker Enhancements i.e. Contingent workers can be associated to individual Tasks as well as High Level Contracts.
• Involved in setup of the Profile Management feature through which employees can search and update their profiles using eDevelopment.
• Modified the default workflow associated with the I-9 compliance feature where an employee can collect and store all the I-Information.
• Developed an custom Application Engine Program using File Layout, which Inserts an Effective Dated Job Row into the Job Record by reading the Data from an Excel File.
• Involved in developing an Application Engine Program, which sends out Emails to Employees and their Managers on certain Events like Hire and Termination.
• Modified the People soft Delivered Component LOCATION_TABLE by adding a new page M_LOCATION that provides details of the Parent Location and Location Usage as per the Client Requirements.
• Modified the ID Management Application Engine Program, M_ID_IN, which creates a New Profile in PeopleSoft for an Employee when he is newly hired of if there is a Name Change.
• Wrote PeopleCode, which generates the Appraisal Report in an HTML format when View Printable Evaluation is clicked in EP_APPR_MAIN Component (ePerformance Component)underManager Self Service.
• Updated the custom component M_HOD_PHONE which is used by Management to update Employees Business Telephone Number and it updates the same table as used in eProfile i.e.PERSONAL_PHONE.
• Written Application Message Code to send Job Data to finance whenever there is a change in Job Data for an Employee.
• Used STAT Tool for migrating Projects from Development to Test and Production Environments

Environment:

Application: PeopleSoft HRMS/HCM 8.9(Benefits, Core HR, Payroll), e-Pay
People tools: v 8.47, SQR, PS/Query, PS AP engine, People Code, HTML, SQL and Crystal report.
Database: Oracle 10g, CGI.
Operating systems: Windows NT/2000, UNIX

Confidential, ( ELMHURST, IL) OCT ’06 JUL ‘07
PeopleSoft Financials v 8.8(AR, BI, AP, AM, GL, PO, PC) Implementation
Role: PeopleSoft Technical Consultant.

Responsibilities:

• Developed and customized new PeopleSoft Application engine programs to read data from a file to staging tables and then to PeopleSoft tables.
• Created application engine programs to load customers, modifying invoice print SQR, BILLING interface application engine program BIIF0001.
• Worked on interfaces between Billing and AR modules.
• Modified Budget Checking Batch Process Status report (GLC8530) to group transactions by vendors and to display detail information for each vendor.
• Debugged the delivered projects process PC_RPO for it was not generating necessary project costing reports.
• Worked on Accrued Bill Lines Report (BIACCR01) and BI Accounting Entry report (BIGLRT01).
• Worked on Application Engine processes like VCHRBLD, VCHREDIT, PO_CALC and PO_CREATE.
• Involved in customizations of Journal Entry, Voucher Entry, Maintaining Vendors, Buying agreements and Requisitioning items using Application designer and PeopleCode.
• Involved in maintaining the payment process by creating/modifying pay cycles, running the match process and creating payments.
• Designed Application Messaging process to synchronize the data in the tables with other instances and external legacy system.
• Developed Conversion SQR to load the data from the Legacy System to Interim Tables in PeopleSoft Asset Management that contains financial asset data (INTFC_FIN), and Physical Asset Data (INTFC_PHY_A and INTFC_PHY_B).
• Modified APY2050.RPT (Payment History by Payment Method) to include vendor location (address) into the report. Included sort option to sort report by vendor ID.
• Was responsible for administering PeopleSoft Portal, which included managing folders/ content references, portal objects and general portal settings.
• Loading the Exchange Rates into PeopleSoft Tables from NewYork Stock Exchange Site by creating a webservice using Integration Broker and subscription Code
• Created Parallel test plans and conducted Parallel Testing and compared the results.
• Used Security to restrict and enable users to access existing and new pages.

Environment: PeopleSoft Financials/SCM V8.8 (AP, AR, GL, Purchasing, PC, AM and Billing) People tools 8.1, People Code, SQR, Application Engine, nVision, Crystal Reports, Process Scheduler, Workflow.

Confidential, (Princeton,NJ) OCT ’05 SEP ‘06
PeopleSoft Financials (v 8.8) Implementation.
Role: Technical Consultant

Implementation of Financials:

• Understanding the Functional Specifications given by functional person as a part of the Implementation.
• Reversed Pricing Engine PC_PRICING process to apply burdens on project resource transactions and then apply the rates on to the burdened resource transactions.
• Involved in development of several customizations like providing Account override feature in the Burden template which is not provided by delivered Peoplesoft.
• Implemented a customization to re-calculate burdens called Burden re-calc process which re-calculates the burdens applied even after the transactions are passed to General ledger.
• Developed a process to update the burden rates PC Burden Maintenance for specific template ids with new effective date.
• Customized the Payment Predictor process AR_PREDICT in Accounts Receivable module to suit the clients requirement of only one payment worksheet to be generated after payment predictors Auto Maintenance process while the SP2 delivered process generated a single worksheet for each customer. The fix later came up in AR 8.4 SP1 Bundle #1.
• Developed nearly six interfaces which involved pushing the sub-system information into General ledger through Journal generator process.
• Developed custom Application messages as part of sending Financial rate information to HRMS system as part of an interface which is run from the HRMS system to generate feeds for some third party software which is an interactive cost estimating system.
• Made use of Component Interfaces to load core HRMS tables like Job, personal data etc.
• Debugged several delivered process failure issues like BILDAR01, AR_PAYLOAD, PC_PRO etc and provided solutions or customized necessary items to cover those issues.
• Created some custom reports in Contracts and Projects modules.
• Provided a helping hand in Performance Tuning of some custom processes in Inventory and Projects module.
• Developed Test Plans and been part of Integration Testing and Unit Testing.

Environment: PeopleSoft Financials/SCM V8.4 (AP, AR, GL, Purchasing, PC, AM and Billing) People tools 8.1, People Code, SQR, Application Engine, nVision, Crystal Reports, Process Scheduler, Workflow.

Confidential, (RICHMOND, VA) SEP ’04 OCT ‘05
PeopleSoft HRMS/HCM Upgrade 8.8 to 8.9, e-Modules Implementation
Role: PeopleSoft Techno- Functional Consultant.

Responsibilities:

Upgrade of HCM:

• Involved in Fit/Gap Sessions in identifying the objects, which needs to be moved to upgrade environment.
• Responsible in writing Technical Specifications for the interfaces & reports, which need upgrade.
• Running DDDAUDIT.SQR and SYSAUDIT .SQR to review the incompatible Objects and Orphaned PeopleCode Objects.
• Involved in Upgrade process in upgrading the current SQR reports from Employee model to Person Model.
• Wrote conversion programs to load the Employee Model database to Person model upgrade 8.9 databases.
• Extensively Used People Code in customizing the delivered pages, Components, records for proper functionality.
• Wrote complex queries using PS QUERY to manipulated the databases and generate reports.
• Hided the Search Box on the PeopleSoft Portal Menu.
• Perform Parallel Comparison of the outbound batch process interfaces output reports/files.
• Wrote People Code to Enforce security level setting for group and User Profiles to maintain security.
• Written Online People code on Job Component to validate the Employee Benefit Program when saving his Job Data.
• Written Online People code to trigger a workflow to the new Supervisor whenever the Employee Supervisor is changed on the Job Component
• Loading the hired Employee Data in PeopleSoft using Application Messaging and Component Interfaces.
• Used Changed Assistant Tool in performing the Upgrade.
• Customizing and developing components, pages and fields to satisfy technical requirements

Upgrade of Benefits Modules:

• Worked with functional people to identify all the objects that need to be upgraded.
• Involved in upgrade process of our custom ben100.sqr which updates the Benefits reporting tables with the new Person model of PeopleSoft v 8.9
• Customized the SQR interface ben105a.sqr to include the benefits plans like Health plans, Life plans, pension plans.
• Involved in setting up the Eligibility Rules and Events Rules.
• Helping in Setting up the system for Open Enrollment.
• Customized the benefits reports like ben001, ben002 & quite a few SQR programs, which reflect the Person Model of new version of people soft.
• Written Online Peoplecode to trigger workflow to Benefit Administrator to terminate his Benefit program when an employee gets terminated.
• Involved in writing new PeopleSoft Interfaces for Fidelity, Tri-Ad, BCBS benefits providers as per the File formats provided by the vendors.
• Involved in writing Shell Scripts, which are triggered by the Control-M’s, which are used to send the parameters to the Interfaces.
• Resolved errors related to Benefits after the Benefits Administration process ran.

E-Modules Implementation:

e-Benefits:

• Involved in Analysis and Development of Application Engine program to create & Delete UserIds & passwords dynamically when Open Enrollment starts & ends every year.
• Customized the Open Enrollment Forms Interface to not to show SSNs, Dependent benefits from dependent records and deleted department IDs, Location, Bas Group IDs from Employee Record.

e-Comp:

• Customized page HR_SS_WP_AGREEMENT to attach the electronically signed Agreements online.
• Customized the Components related to Profit Sharing Amount Page which dynamically populates the data from third party website.
• Involved in designing & developing custom Synchronous Application Messaging inbound & outbound with third party web servers.

e-Pay:

• Customized the Direct Deposit Information page to encrypt the routing number and account number after saving the Information.
• Created a custom page which triggers in creating Duplicate W-2 Form page after approval from Manager.
• Customized the e-paycheck view page as per the requirements.

e-Development:

• Customized the Approval workflow for training to involve more steps of approvals.
• Involved in customization of delivered components and pages as per the requirements.
• Customized the Job profile and Personal profile pages as per the requirements.
• Involved in writing Custom Report from the scratch, which generates all list of employees, who has wish list for particular job or whose profiles matches to job opened.

Environment:

Application: PeopleSoft HRMS/HCM 8.9(Benefits, Core HR, Payroll) e-Benefits, e-Pay, e-Profile, e-Compensation, e-Development, Portal Solutions.
People tools: v 8.47, SQR, PS/Query, PS AP engine, People Code, HTML, SQL and Crystal report.
Database: Oracle 9i, CGI.
Operating systems: Windows NT/2000, UNIX.