PROFESSIONAL SUMMARY

• 10+ years of experience as a HRMS technical consultant, with experience in analysis, design development, upgrading and production support of PeopleSoft HRMS Applications.
• Professional experience in PeopleSoft HCM modules (HR, Time&Labor, Base Benefits, Benefits Admin, NA Payroll, Payroll Interface, Canada Payroll).
• Participated in all phases of ERP life cycle like Implementation, Customization, Development, Production Support and Upgrade.
• Extensive experience in requirement analysis, fit gap analysis, technical design, conversion strategies, data mapping, development, major customization, issue resolution, performance tuning, testing and training.
• Extensively worked with Application Designer, Peoplecode, Application Engine, Process Scheduler, Security Administrator, Data Mover, File Layout, Object Security, Component Interface, Integration Broker, PS Query, Tree Manager, SQR, XML, Workflow, nVision and Crystal Reports.
• Involved in applying PeopleSoft Patches and Bundles.
• Worked closely with Business Users in understanding the Business Processes.
• Experience in working with ETL tools
• Gained exhaustive functional knowledge by working with end users on a daily basis.
• Participated in complete Payroll processes and resolving issues for Payroll.
• Worked on PeopleSoft Security - User Profiles, Roles, Perm Lists, Components, Pages, Menus, CI, Process Groups, Query Security, and Department Security etc.
• Vast experience in Peoplesoft Administration activities.
• Strong collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.
• Extensively worked on CA single sign on and implemented single sign-on across the enterprise.
• Great understanding towards the needs of the client to provide invaluable support from design to post-production stages.
• Possess excellent data modeling, analytical and problem solving skills.
• Very good team player with excellent communication skills.

TECHNICAL SKILLS

People Tools: (8.54,8.51,8.48)Application Designer, PeopleSoft Internet Architecture, People Code, Upgrade Assistant, Change Assistant, Process Scheduler, Configuration Manager.

Integration Tools: Application Engine, File Layout, Component Interface, Application Messaging, Application package, Integration Broker.

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

Data Management Tools: Data Mover, ETL,DatabasesOracle 9i, Oracle 10g, SQL Server 2000, SQL Server 2005,DB2, Teradata

Programming Languages: People Code, SQR,SQL, C/C++, Java

Operating Systems: MS Windows 98/NT/2000/XP, UNIX,Mainframe

Other tools: STAT, Atlassian

PeopleSoft: HRMS Modules(9.2,9.1,9.0)Core HR, Time and Labor, Base Benefits, Benefits Administration, NA Payroll, Payroll Interface, Canada payroll

PROFESSIONAL EXPERIENCE

Confidential, Mooresville, NC

HR/Payroll Consultant

Roles and Responsibilities:

• Hands on experience on designing the new Interfaces.
• Built integrations for employee benefit information, hosted on Peoplesoft and from other vendors that handle Benefits, to run data analytics and provide personalized recommendations.
• Developed integrations and SQR programs to send pay check data.
• Played key role in outsourcing Ben Admin process to a vendor.
• Implemented a benefit program Evive - comprehensive benefits portal that use predictive analytics to show individuals real-time opportunities for health and savings.
• DoubleNetPay implementation - Implemented finances management tool that tracks and seamlessly schedules payment around their paycheck cycles.
• Built APP engine and SQR programs to calculate Incentives for commission based employees.
• Created new SQR Programs for inbound and outbound benefit interfaces.
• Created new SQR programs to handle quarterly state and federal Tax reporting.
• Functionally analyzed and tested the interfaces.
• Implemented online and batch customizations in HR, Payroll and Time and Labor , Benefits and Benefits Administration modules as per functional requirements
• Advised customers on discrete business problems, formulates options including assessing their relative merits and risks, and works with customer(s) to determine the best solution.
• Assist with maintenance and troubleshooting of scheduled processes.
• Demonstrates expert understanding in all PeopleSoft HCM applications development processes, serving as a resource to others.
• Performed Peoplesoft Admin activities to prepare for various testing and production implementations.
• Supported all level of users within the company and in projects in a support mode
• Coordinated and applied number Bundles & Patches to keep the system to latest patch.
• Worked directly with clients in managing their requests, understanding their requirements and translating functional requirements to technical specifications through hands-on analysis and coordinating with the onsite and offshore team for development.
• Worked with the support team to fix issues coming in as a part of production support.

Environment: PeopleSoft 9.1/2 HCM, Benefit, payroll, People Tools 8.53/5,  Oracle 11G, PL/SQL 11.2, Windows NT

PeopleSoft HCM Techno-Functional Consultant

Responsibilities:

• Responsible for design analysis, technical specifications, development, implementation, support, and maintenance of PeopleSoft HCM 9.1 and PeopleTools 8.51.
• Delivered SQR program to create yearly compensation statements for employees.
• Technical Design and Build for the new requirements and enhancements.
• Developed/Enhanced SQR Programs scheduled to run monthly to submit Personal and Payroll data.
• Customized the Self Service Transactions Pages. Additional fields and component People Code was written to enhance the functionality to meet customer requirement.
• Developed on-line customizations, custom interface programs for Benefits, Payroll.
• Set up Integration Broker services(such as gateways, nodes, services and service Operations)
• Created User Profiles, Roles, Permission Lists, Components, Menus, Pages, Process Groups, Query Security, etc.
• Involved in User security (Roles, Permission lists) and row level security using Department tree.
• Provided programming and analysis support for customizations made to HR, Benefits and Payroll modules.
• Reviewed and improved performance for online and batch routines, including App Engine, SQR, and PeopleCode routines.
• Developed customized Benefits reports for Open Enrollment, New Hires, and Employee Benefits.
• Provided production support for Benefits, Payroll and HR systems.

Environment: PeopleSoft HCM 9.1 (HR, Payroll, Time & Labor, Benefits), PeopleTools 8.51, PeopleCode, SQR, XML Publisher, Workflow, SQL, PS Query, Component Interface, Application Engine, File Layouts.

Senior PeopleSoft HCM Technical Consultant, Support & Development

• Run and review upgrade compare reports.
• Customization analysis and decide on keep, no keep of the existing customizations
• Retro-fit of existing carry-forward items for existing modules.
• Technical Design and Build for the new requirements and enhancements.
• Built integrations and SQR reports to implement pay card solution.
• Worked on Employee payroll deductions, pay calendars, ran the payroll process (from pay calendar, pay sheet/unsheet, pay calculation to pay confirm/unconfirm).
• Maintained Security.
• Involved in creating permission lists, users, roles and assigned roles to users.
• Unit and integration testing.
• Test plan and end user training support.
• Worked in the Production support team to resolve all production issues and also have frequent interactions with End-users.

Environment: PeopleSoft 9.1 HCM, PeopleTools8.53, People Code, App Engine, Component Interfaces, Integration Broker, SQR, Workflow, SOA, App Packages, XML-Publisher, Crystal, Oracle, Remedy

PeopleSoft Analyst

Responsibilities:

• Created Custom App Engine to create Pay sheet for Inactive employees for one time payments and benefits after termination using Component Interface.
• Worked on PeopleSoft outbound interface (App Engine) that creates Health files in CSV format to vendors Anthem, Delta and Kaiser based on Benefit Snapshot data.
• Customized PAYGL03 process to get data from Custom encumbered records and create accounting line with additional data in custom accounting line record as per the requirement.
• Worked on adding code for one of the data conversion App engines as needed by the requirement.
• Responsible for creating Technical design and Unit test documents for all the developments and issues I worked on.
• Compare report analysis and batch programs to analyze the changes and retrofitting to be performed
• Responsible for peer to peer review for error free delivery of code.

Environment: PeopleSoft HRMS 8.8 (Core HR, Campus Solutions, North America Payroll, Benefits, TAM, People Tools 8.49, SQL Developer)

PeopleSoft HCM Technical Consultant

Responsibilities:

• Performed development, testing, modifying of some of the SQR, Query, existing pages, and various PeopleSoft objects.
• Involved in working and fixing the user requests and change Requests.
• Involved in BATCH processing to setup the jobs in Control – M tool.
• Created the UNIX shell scripts as per the application process.
• Developed new inbound interface programs using AE and File Layout.
• Interacted with Hewitt functional consultants to understand their functional needs and customized the system to incorporate the same.
• Involved in creating Technical design documents and Unit testing.
• Impact analysis of various Tax Updates and Fixes.
• Extensively involved in reapplying customizations to records, pages, People Code, components, menus, permission lists, message channels, portal registry structures and various other PeopleSoft objects.
• Worked extensively on SQR’s and created several inbound and outbound interfaces to meet the client’s requirements.
• Developed and modified UNIX scripts for batch process scheduling.
• Created custom application pages and records as per client business needs.
• Developed different custom reports using PS Query and SQR according to user requirements.
• Modified & Created records, on-line pages, and components according to the requirements using Application Designer.
• Migration of People Tool objects from one environment to another environment through Quest Stat.
• Involved in creating Users Profiles, Roles, and Permission Lists.

Environment: PeopleSoft HCM 8.8(HR/Benefits/Payroll), PeopleTools 8.48, DB2, COBOL, Control-M, DB2, Stat, and UNIX.