SUMMARY:

• Around 7 Years of experience in Implementation, Customization, Upgrade, Reporting, Production Support and Maintenance of various HRMS/HCM modules such as Core HR, Benefits, Payroll (Global & NA), Time & Labor and Self - Service (ESS, MSS).
• Strong experience in Module Development, Production/On-Call Support, Customizations, Change Enhancements in Reports, Interfaces, Conversions and Workflow using People Code, SQR’s, People Tools 8.x.
• Well versed with PeopleTools and worked extensively in Application Designer, People Code, Application Engine, Component Interface, Integration Broker, PS Query, Data Mover, Tree Manager, Application Package, Process Scheduler, SQR, Excel to CI, AWE, BI publisher, XML publisher and File Layout.
• Provided extensive production support to HR, Payroll and Benefits modules.
• Extensive knowledge in developing and customizing reports using reporting tools such as SQR, XML Publisher BI Publisher to create and organizational decision-making and complex reports.
• Proficient in utilizing Software Development Life Cycle methodology (Scope, analysis, design, development, deployment, testing) to execute the PeopleSoft projects.
• Ability to deliver the best even in the most critical phases of the project.
• Adept in scheduling recurring process, conditional scheduling of successive process, setting up the reports to run at specific time and implementation of batch processing using Process scheduler and Process Monitor to monitor the report status.
• Customized delivered functionality in different modules as per client needs using App designer, Component Interfaces, Application Engine, SQR, IB etc.
• Participated in Knowledge Transfer about process methodologies to offshore team after working closely with subject matter experts onsite
• Experience in Integrating PeopleSoft applications with other PS Applications as well as third party partners using Integration Broker.
• Experience in creation of Web services, Service Operations and Service Handler code and have knowledge of debugging and resolving issues in web service handler code.
• Experience in creating SQL scripts within database environments in Oracle DB etc.
• Excellent Communication, Interpersonal skills and can learn quickly and adapt to changes as per need and can work efficiently individually and as a Team Member.
• Experience in interacting with users to analyze and create design documents for the implementation of new Functionalities and Change Enhancement Requests as per business requirements.
• Excellent analytical and programming skills. Capacity for Work - Meeting Deadlines. Diagnostic ability to go to the core of the problem.
• Having great deal of initiative, willing to learn and adapt to new challenges.
• Received many Client/Onsite Appreciations and Recognitions for the good work done within the team.
• Good ability to write technical documentation, conduct presentations and trainings.
• Created complete bolt-on applications for benefits module.

TECHNICAL SKILLS:

ERP: PeopleSoft 9.1/9.0/8.9/8.8

People Tools 8.54/8.53/8.51/8.49

People Tools: Application Designer, Application Engine, Component Interface, People Code, Workflow, Application Packages, File layout, Integration Broker, Data Mover, Process Scheduler, Process Monitor, Tree Manager

Modules: HR, Payroll, Base Benefits, Benefits Administration, Time and Labor, eProfile, eRecruit, eBenefits, ePay, Manager Self Service.

Reporting Tools: XML Publisher, BI Publisher, SQR, PS Query

RDBMS: SQL Developer, TOAD, Oracle 11g/10g/9i.

Programming Languages: People Code, Java, PL/SQL, SQL, C++, C.

Operating Systems: Windows 98/ XP/ Vista/ 7/ 8.

PROFESSIONAL EXPERIENCE:

Confidential, Denver, CO

PeopleSoft Techno Functional Consultant

Responsibilities:

• Closely worked with the client to get better understanding of the requirements and was part of requirement gathering.
• Perform fit/gap analysis on functionality of existing legacy system against delivered 9.2 Time & Labor.
• Responsible in designing & implementing custom Time & Labor module as per client requirements.
• Created custom components to allow users to review & approve Timesheets submitted by employees/students.
• Built logic to pull in timesheets into Offcycle/OnCycle payroll as per client requirements.
• Involved in Setup data migration of HR/GL, Payroll, Benefits, ePerformance and Profile Management modules.
• Mentored the junior engineers in the team and guided them to achieve success on their tasks.
• Responsible for creating Functional Design Specifications document, and establishing business process flow for Bolt-on Modules.
• Conducted technical feasibility study and suggested solutions to address customer requirements on PeopleSoft HCM application.
• Created/modified new Records, fields, pages, components, Menus and Component Interfaces per business requirements.
• Extensively used People Code for customization of pages and validating the data.
• Customized SQL views, records and People Code functions comprising SQLExec and Scrollselect.
• Implemented business functionality using PeopleSoft programs like PeopleCode, Application Engines.
• Implemented complete Bolt-on applications for Flexible Benefit Plan declaration, Income tax declarations and claims/ reimbursement modules for Employees as well as for Admins to declare on behalf of employees.
• Used PS Query and BI publisher tools to generate report on Income tax declarations page and Claims/ Reimbursement module.
• Incorporated Barcode on claims report using BI publisher reporting tool.
• Designed and generated monthly reports claimed by employees using PS Query and BI publisher as reporting tool.
• Created Component interface on the custom component created for the Flexible Benefit plan declaration, to import history data of employees into new system.
• Utilized on Excel to CI functionality to load previous year’s declarations to new system.
• Extensively used PS Query and Application engine for developing Ad-hoc reports for Employee Self-service and also to send email notifications to employees to finish their FBP/IT declaration in-time.
• Simplified the naming standards for customized objects to minimize impact on PeopleSoft objects.
• Audited the data consistency periodically between PS query and Oracle database data to meet the highest level of operation standards and significantly reduced production issues.
• Implemented PeopleSoft Security and permission list to restrict users accessing processes.
• Executed unit tests to verify error validation and code coverage on negative scenarios.
• Performed system tests to confirm code conformance to functional specification and business requirements.
• Worked on Component Interfaces to update component.
• Participated in deep technical discussions on various modules with peers which enabled the team to resolve issues within SLA.
• Setup regular meetings with clients and served as point of contact to resolve critical issues and requirements proactively.
• Analyzed the defects raised and prepared Root Cause Analysis to assist business analysts in resolving the issues.
• Worked closely with end users on user acceptance testing and thereby enriched customer experience on final product.
• Always adhered to the timelines and delivered modules on-time.
• Got many appreciations from client as well as from my senior management on the quality of work done.
• Trained business users and provided go-live support.
• Supported and worked after work hours, available for help at any time.

Environment: PeopleSoft HRMS 9.2, People Tools 8.54, People Tools 8.49, Application Engine, Application Messaging, People Code, SQR 8.X, PL/SQL Developer 9.0.6.1665 , PS/Query, Wiki, Oracle 11g release 11.2.0.2.0 , Windows 8.

Confidential, Cupertino, CA

PeopleSoft Sr. HCM Developer

Responsibilities:

• Worked from Development phase to Support phase.
• Involved in analyzing people code and developing the required functionality.
• Created Unit test scripts to test the business functionality for the delivered code based on the requirements.
• Migrated the PeopleSoft Objects to Integration, User Acceptance environments from Development and done unit testing in all the environments.
• Review and approve code implemented by other developers in the team.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Experience in using Integration Tools including Component Interfaces, Integration Broker for interacting with in and outside PeopleSoft applications.
• Experience in creating services, service operations, messages, nodes and routings.
• Problem solving and 24/7 Support for the Support team.
• Tracking the incidents raised in the production.
• Fixing and resolving the issues based on priority. Reporting the root-cause and resolution steps.
• Developed several Component Interface based Web Services for effective communication between PeopleSoft and External tool
• Created Several Row-set based and Non-Row-set based Messages, Service Operations, Routings, Handlers and Services for Integration Broker
• Developed five different Component Interfaces which in turn exposed as web services
• Applied security for Integration Broker objects as well as the Component Interfaces
• Created and Used Application engine programs, Menus, Components, Pages, Records, Fields and several complex SQL Definitions to achieve functionality.
• Developed several complex reports using the reporting tools such as XML Publisher.

Environment: PeopleSoft CRM 9.0, People Tools 8.49, Oracle 10g, 11g, Application Engine, Application Messaging, Integration Broker, People Code, SQR 8.X, COBOL, SQL, PS/Query, Windows 8.

Confidential

PeopleSoft Techno-functional consultant

Responsibilities:

• Provided consultation on unit and Integration testing in preparation for PeopleSoft HCM upgrade from 9.0 to 9.2.
• Project executed using Agile Methodology.
• Extensively utilized Compare reports for retrofitting the application by identifying differences between databases and to also compare the base version with the target version.
• Retrofitted the customized objects, based on the compare report and analyzed to retain vanilla or to reapply customization.
• Identified the impacted SQR’s and SQC’s and retrofitted complex custom SQR’s and SQC’s in preparation for upgrade to 9.2 based on 9.0 customizations.
• Done customizations on Manager Dashboard to meet client’s requirements.
• Closely worked on Manager Dashboard pagelets.
• Customized the Alerts, Direct Line Reports, Pending Approvals, Announcements and Useful links pagelets.
• Created Application Engines to populate data on Manager Dashboard which improved performance of loading the Dashboard.
• Configured various set up pages like workflow transactions, Approval Pagelet set up, and Direct Deport Pagelet set up.
• Created/modified new Records, fields, pages, components and Menus per business requirements.
• Extensively used PeopleCode to implement specific business rules to validate the business process.
• Customized SQL views, records and PeopleCode functions comprising SQLExec and Scrollselect
• Identified test scenarios and prepared technical specifications, test data for unit, system and integration testing
• Also, done Quality Analysis on various modules like Manager Dashboard, Absence Management, Global Payroll, ESS and MSS after retrofitting is done.
• Resolved post production support issues during upgrade project which led to meet the efficiency within SLA timeline.
• Closely worked with client during Quality Analysis to ensure correct Business Functionality and received client appreciations for the test results prepared.
• Created Application Engine to report employees who have negative super contributions.
• Created new PeopleSoft Objects like Records, Pages, Components and SQLs.
• Extensively documented the customization made as part of business requirements.
• Tailored delivered SQR process to suit the client’s requirements.

Environment: People Soft 9.2 HCM, People Soft 9.0 HCM (HR, Payroll, Benefits, Ben Admin, e-Applications, e-Profile, e-Benefits, e-Pay, e-Compensation), People Tools 8.53, People Tools 8.49, Application Engine, People Code, SQR 8.X, COBOL, SQL, PS/Query, SQL*Plus 8.1.7, Oracle 11g, Windows XP.

Confidential

Responsibilities:

• Retrofitted all the customizations with the upgrade to 9.0
• Implemented all the new customizations with the newer version
• Created Training documentations for all the new functionalities.
• Created Application Engine to update the timesheets statuses.
• Involved in online changes like adding customized-translate values, modifying People Code, adding fields to Record Definitions and pages
• Actively involved in Unit, Integration and System testing. Also, responsible for documenting the test scenarios.
• Developed new reports using SQR and PS Query Reporting tool.
• Also, created PS Queries to be used by HR/Benefits/Payroll key users for reporting and testing purposes.
• Customized number of existing SQRs /PS Queries/Crystal Reports to suit to the business requirements. Worked extensively on SQRs to bring them in sync with the new features brought in PS 9.0
• Configured Salary Plans, Grades, Steps, rating scales.
• Retrofitted the existing customizations on objects including People Code.
• Attended postproduction support issues from time to time.
• Customized a page to meet up the business requirements.
• Created required fields, records, run control pages and components.

Environment: PeopleSoft 9.0 (HR, Benefits, Payroll, Time and Labor, Manager Self Service, Employee Self Service), People Tools 8.49, Application Engine, Component Interface, People Code, SQR 8.x, COBOL, SQL, PL/SQL, PS/Query, Oracle 10g, Windows XP.

Confidential, Cupertino, CA

PeopleSoft Developer

Responsibilities:

• Created Component Interface based WSDLs to Integrate PeopleSoft system with the third-party system.
• Thoroughly tested the Component Interfaces and created CI based WSDLs.
• Setup Integration broker configuration and nodes.
• Created Technical design documents and prepared unit test plans.
• Worked on analysis, coding, testing and review phases of work based on user requirement.
• Moved application data between two PeopleSoft databases using Data Mover.
• Coordination of the work with on-site development team and conducting conference calls.
• Involved in Data mapping between the two systems.
• Involved in developing various routines to transform the date to the Client database format by using SQRs and Application Engine programs.
• Maintained PeopleSoft user security using user profiles, roles & permission lists.

Environment: PeopleSoft CRM 8.80, People Tools 8.49, Oracle 10g.