• Having 10 years of experience in PeopleSoft applications as a Technical/Techno functional Consultant implemented, upgraded, customized, and maintained PeopleSoft HCM/FSCM and Oracle based applications.
• Highly expertise in usingPeople Tools APPLICATION DESIGNER, PEOPLECODE,APPLICATION ENGINE, FILE LAYOUT,COMPONENT INTERFACE, APPLICATION PACKAGES Integration Broker, Data Mover and PS/Query .
• Developed various interfaces using APPLICATION ENGINE,SQR, andData Conversionprograms.
• Good functional knowledge inPS HRMS/HCM Version 7.5 to 9.2 Workforce Administration, Benefits, ESS, MSS,Recruiting, TAM, NA Payroll, Global Payroll and FSCM AP, AR, PO, Billing, GL .
• Analyzed Functional requirements on basis of Functional design documents and also part of team while gathering the business requirements from clients.
• Prepared Technical design documentationfor various developing/customized developments.
• PerformedPeer reviews in onsite/offshore models.
• Highly commended for performance and commitment from the customers and clients. Possess very good client interactive and communication skills.
• Proficient in customizing and developing various reports usingSQR, PS/Query,XML Publisher and Crystal reports.
• Expert in fixing performance issues of SQR reports,APPLICATION ENGINE programs and online application by tuning SQL.
• Having experience in resolving production issues and solving data related issues.
• 24/7 on call support for Production and Support Applications.
• Worked and followed agilemethodology forvarious projects to updatethe status of the tasks.
• Extensively worked with PS SQL and proficient TOAD/SQL developer tools.
• Running jobs using Putty tool and Shell scripts.
• Very Good knowledge in maintainingSecurity and User profiles.
• Proficient in customizing modules based on organizational needs and requirements.
• Worked on various environments likeMainframe, UNIX and Windows.
• Involved in project meetings and status meetings with Onsite consultants and/or Clients
• Good Knowledge in SDLC ,Manual Testing like UAT, Functional, System SIT and Regression.
• Good Knowledge in Java/J2EE, LDAP, SAOP and web services.

Confidential

Role : Techno-functionalConsultant

Environment : Windows, Oracle11g, PeopleSoft HCM 9.1 People Tools8.52 Application Designer, People Code, Application Engine, Component Interface, File Layout, PS Query, Data mover,XML Publisher and IB and SQR.

• Worked as a NA Payroll Team member to resolve tickets and develop new interfaces.
• Improved system productivity and processing execution time of Open Enrollment.
• Interaction with end-users to define system setup, improve benefits system processing and data requirements for Benefits and Open Enrollment.
• Provided Gap and Business Analysis to identify modifications and business requirements, functional and technical programming for HRMS, Benefits Administration, Payroll, Employee Self-Service, Workflow, eBenefits modules which consisted of design documentation, table structure setup and modification of workflow process for daily event processing and Open Enrollment functionality.
• Implemented complex technical and system design specifications for benefits, eBenefits and Self-Service.
• Designed Benefits Administration system to allow for flexible independent cost, geographical restraints, and complex eligibility requirements.
• Extensively worked on Tax Updates in functional implementation parts and involved in yearend tasks particularly by applying payroll tax updates for running the payroll as expected.
• Created and managed Approval processes by using AWE Approval work flow Engine in PMD/ESS module. Maintaining User Security and User Preferences and permission lists.

Confidential

Role : Technical Consultant

Environment :Unix,Oracle11g PeopleTools8.52 Application Designer, People Code, Application Engine, Component Interface, File Layout,IB, PS Query, Data mover and SQR, Toad.

Responsibilities :

• Analyzed and helped in developing System Requirements for business.
• Developed Employee OptinProcess ,where an employee can choose stores to work in Hiring Circle.
• Developed Web services and provided service to external applications to consume using PeopleSoft integration technology.
• Consumed a secured Web service from Oracle Fusion service bus and developed PeopleSoft objects to support HR data provision to Oracle fusion application.
• Developed App Engine programs and Integration objects to build custom Time reporting application.
• Created batch programs to export time reporting data to Kronos and import calculated time segments from Kronos.
• Created parallel processing batch programs to handle heavy loads of data.
• Worked with Business closely to study their Requirement and guide through SRD as a PeopleTools .
• Done peer review for other developments which are done teammates.

Citizens Bank, RIJun 12 to Feb13Role : Techno FunctionalConsultant

Environment :Unix,Oracle11g,PeopleSoft HCM9.1 PeopleTools8.52 Application Designer, People Code, Application Engine, Component Interface, File Layout, PS Query, Data mover and SQR,Benthic.

Confidential

Responsibilities :

• Developed an Interface for Cost of Employer contribution Health Coverage on Employee W2s with SQRin Benefits/Payroll modules.
• Designed and developed SQR outbound interfaces to generate Flat Files to be sent to the respective carriers, listing all the terminations and enrollments into various Base Benefit Plans during the Year-end/Open Enrollments
• Enhanced the interfaces like Credo, Computer share, LOA interfaces with adding new fields and changing file formats as per client requirements.
• Involved in setup and design of automated benefits enrollment process, setting up core tables in HR and Benefits Administration, defining eligibility rules and creating event rules.
• Customized the Self Service Transactions Pages. Additional fields and component People Code was written to enhance the functionality to meet customer requirement.
• Developed Data Conversion programs EDI using Component Interface and Application Engine to upload legacy HR data like Personal Data, Job Data, Education, Dependent Data, Benefits Components
• Customized the Refresh Employee Compensation Process HR CMP015 in compensation module, modified the compensation rate code on the compensation tab in the Job data.
• Analyzed and resolved performance issues in existing interfaces.
• Resolved performance issues and debugging the App Engine and SQR processes.
• As a technical team member, involved in 12D/12E tax updates and performed impact analysis.

Confidential

Techno Functional Consultant

Environment :Unix,Oracle11g,PeopleSoft HCM9.0 PeopleTools8.51 Application Designer, People Code, Application Engine, Component Interface, File Layout, PS Query, Data mover and SQR,AQT.

Responsibilities :

• Interacted with Users to understand the business requirements and developing technical specifications. Assisted and guided employees with report and interface development.
• Performed the design and development of several HR Payroll interfaces using Application Engine, SQR and Data conversion programs.
• Responsible for Developing and modifying inbound and outbound Interfaces using Application Engine, File Layout, SQRs for vendors.
• Involved in online changes like adding customizations, modifying People Code, adding fields to Record Definitions and pages.
• Involved in Tax updates and Bundles and analyzed customizations and impact.
• Analysis, Coding, Testing and Review of various interfaces, reports and customizations.
• Made extensive edits on PAY003 and DDP003 SQR's and made the same changes in Paycheck in ESS.
• Involved in setting up Time Labor module. Extensively worked Time administration on set-up of Time periods, Shifts, Reason Codes, Task Profile Templates, Task Entity Codes, Task Groups and Work Groups.
• Created work groups and time reporting codes for work groups. Involved in creating task groups. Have a thorough understanding of functionality provided by Time and Labor.
• Customizing pages and components and created necessary records tables , menus and portal objects.
• Modifying People Code and running Application Reviewer, trace, debug People Code to fix any issues.
• Performed troubleshooting the problem areas in setting up HR tables that serve as the foundation of Financials system and in producing Financials reports.
• Developed multiple SQR Reports and Troubleshooting Crystal/SQR Reports Problems.
• Implemented Row Level Security by creating Views, which will be used as Search Records
• Reviewing trace files for the processes, reviewing a trace for the workflow email notification Process, recovering from an abnormal termination trouble Shooting , unlocking and rerunning an application engine process and preparing resolutions.
• Configured security controls for User setup, Page permission access, Data permission access, and Role setup.

Confidential

Role :Sr.TechnicalConsultant

Environment : Windows, Oracle11g, PeopleSoft HRMS/HCM 8.9/9.1 People Tools 8.48/8.51 Application Designer, People Code, Application Engine, Component Interface, File Layout, Workflow, PS Query, Data mover and SQR,Toad.

Responsibilities :

• Modified and upgraded the pages in e-Performanceand Manager Self Service.
• Customized and developed Benefit Interfaces like Caremark Interface.
• Developed the interface of Taleo process by using the Application Engine and Component Interface CI program for uploading the data of applicant's in PeopleSoft system.
• Worked interfaces from PeopleSoft to third party system in Payroll interface.
• Played vital role in fixing few issues in data conversion in upgrade.
• Involved inCustom SQRs, App Engines programs are analyzed and retro fitted in 9.1 systems and also worked to enhance performance.
• Worked with Off-shore team to fix the issues and tickets and support as Team Lead.
• Taken responsibility of the whole module NADM.
• Involved in uploading data in Location Table and JOB Data conversion.
• Performed and fixed the data validations for various data conversions and interfaces.
• Developed and upgraded many pages with HTML areas as per client requirements.
• Co-Ordination and working with off shore and onsite team as a Techno-functional consultant in the upgrade of PeopleSoft 8.8/9.1HCM.

Confidential

Role : Sr.Technical consultant

Responsibilities:

• Worked as a Techno/Functional consultant in the upgrade of PeopleSoft 8.9/9.1 HCM.
• Worked interfaces from PeopleSoft to third party system.
• Did the analysis of existing customizations, conversion, interfaces, and report programs and identified the changes that needed to be made and documented the impact from technical perspective.
• Performed Retro-fit on Custom SQRs, App Engines, and Pages.
• Designed and developed SQR outbound interfaces to generate Flat Files to be sent to the respective carriers, listing all the terminations and enrollments into various Base Benefit Plans during the Year-end/Open Enrollments.
• Created Data Mover scripts to migrate setup data between environments.
• Customized Application Engine programs to load payable times to Pay Sheet table from the Time Labor table to meet the client's business requirements.
• Involved in mapping TRC to earning codes. Tested the Application Engine programs with respect to Time and Labor for performance issues and proper functionality.
• Developed rules using Rules templates and compiled to add relevant section in the Application Engine TL TA RULES controlling the time administration process.
• Created work groups and time reporting codes for work groups. Involved in creating task groups. Have a thorough understanding of functionality provided by Time and Labor.
• Created a new page in the Manger Self Service where the manger is allowed to see his employees and upon selecting an employee he/she can view the Leave Balances of that employee.
• Approval rule set and Activities were modified to route approval transactions and email notifications to administrators based on location.
• Involved in Setup of Eligibility rules and Plans in Benefits Administration.
• Applied Tax-Updates. Retro fitted several PayCalc issues.
• Followed by Agile methodology to update the status of the tasks.
• Used Stat tool for migrate the projects and version control.

Confidential

Role : Techno Functional consultant

Environment : WindowsXP,Oracle10g, PeopleSoft HRMS/HCM 7.5/8.3/9.0People Tools8.5 Application designer, PeopleCode, Application Engine, Component Interface, File Layout, Workflow,Data mover, PS Query and SQR,Toad.

Responsibilities:

• Customized delivered components according to user requirements and extensively worked on the Resume Processing application in e-Recruiting/TAM module.
• Customizing the Direct Deposit ACH transmittal file DDP001 in NA Payroll.
• Created a People code Function name - UO 180 Day Rule to handle the 180 day rule logic that is called from the JOB record save in Benefit module.
• Resolved complicated defects related to their Pre hire and Rehire.
• Profile, Meal Period, Time Keeper Code, Device Group, Accrual Profile and Workforce Manager.
• Developed Data Conversion programs using Component Interface and Application Engine to upload legacy HR data like Personal Data, Job Data, Education, Dependent Data, Benefits Components.
• Many fields validations like Address field validations and Performed with People Code ,and also used data traversing classes for retrieving the data in Component buffer .
• Customized and Retro fitted SQRs with new enhancements.Developed new SQRs according to requirements.
• Resolved performance issues and debugging the App Engine and SQR processes.
• Resolved performance issues like SQL tuning.
• Created and managed Approval processes by using AWE Approval work flow Engine in PMD/ESS module. Maintaining User Security and User Preferences and permission lists.
• Resolved production issues and Performance issues and Written Technical SpecificationDocumentation.
• Done Technical specifications Documentation.
• Interacted with Business people to gather requirements along with functional consultants.

Confidential

Role : Techno-Functional consultant

Environment :Unix, SQL Server, PeopleSoft HRMS/HCM, People Tools 8.48 Application designer, PeopleCode, Application Engine, Component Interface, File Layout, Workflow, PS Query ,and SQR.

Responsibilities:

• Designed and developed custom components under Employee and Manger Self service using the application designer based on the business requirement to incorporate reporting and approval of the Discipline and Ethic cases by the Managers.
• Developed e-Leave customized module which is facilitates the employee to apply leave and asks for Manager's approval.
• Involved mainly in the customization of the tasks related to the benefits module reports
• 401 k interface has been developed in Pension module.
• Extensively worked with application designer to modify record definitions, pages, components, menus and giving access to them by using maintain security.
• Involved in creating Application Engine programs, File layout object for reading and writing from flat files by adding new sections, steps and actions through application designer
• Developed new records and pages definition as well as putting many reports and interfaces PeopleSoft online.
• Excessively worked with SQR for generating customize reports as required by the client.
• Process scheduler was used to run the SQR Reports. Created new process definitions for SQR Reports to run from the process scheduler
• Created queries for HR and Benefits using PeopleSoft Query tool.
• Developed and tested Excel to CI.
• Executed jobs on Putty tool and analyzed Perl Scripts.
• Data accessed in to Component buffer by Data traversing classes.
• Concentrated in design, code, develop, and debug new and existing reports, interfaces using people tools, SQL/SQR and PeopleCode.
• Toad is used to check the SQL scripts.
• Done Technical specifications Documentation.
• Done peer reviews and performed Unit Test cases.

Confidential

Role : Technical consultant

Environment:PeopleSoft HRMS/HCM 8.9 HR,ESS, MSS,Benefits,e-Recruitment, Global Payroll and GL People Tools 8.42 SQR, Application Engine, Component Interface, File Layout, Workflow, PS Query,Oracle8i, SQR,Crystal Reports, Windows2000.

Responsibilities:

• Many Field validations have done on Personnel information pages like addresses,city,phone number by using PeopleCode according to Client's requirements
• All existing PS/Queries areanalyzedand created by user specifications.
• Made extensive edits on PAY003 and DDP003 SQR's and made the same changes in Paycheck in ESS.
• An interface developed between PS systems to non-ps Payroll system to send a Tax-exclusion code.
• Customized Application Engine programs to load payable times to Pay Sheet table from the Time Labor table to meet the client's business requirements.
• Created and customized new objects like Field,record,page, component and menu according to Client's requirements.
• Few page fields are modified according to Clients requirements by using Application designer.
• ManySQRprograms are tested,analyzed and Peer reviewed of other team mates developed.
• By Using file layout data been uploaded into PeopleSoft system.
• By Using SQR have developed reports like Employee details of Employee status,joining date, termination date etc.
• Many interfaces have been developed by using SQR for inbound and out bound operations.
• Done Technical specifications Documentation.