SUMMARY

• Qualified Certified professional with over 8 years of experience in all stages of systems development life cycle including business requirements gathering, design, data conversions, programming, system / integration / user acceptance testing, documentation and exclusive experience in PeopleSoft HRMS/HCM and expert level Skills in PeopleTools.
• More than 8 years of experience in implementation, upgrade, writing interfaces and administration of PeopleSoft HRMS (HR, E - Performance, Payroll, Benefits, eRecruit, TAM, Manager Self Service, Employee Self Service, Time and Labor, Absence Management), PeopleSoft ELM (Catalog, Learners and Enrollment), PS CRM (Call Center).
• Experience in writing PL/SQL queries, Stored Procedures and Triggers and have exposure to different databases, includes SQL Server, Oracle, MS-SQL Server, MySQL, Postgre SQL.
• Created specifications and programmed interfaces to and from PeopleSoft system to satisfy business requirements.
• Specialized in data extraction interfaces and conversion from legacy to PeopleSoft applications.
• Extensively worked with PeopleTools such as Application Designer, Approval Workflow Engine, Application Engine, Integration Broker, Application Messaging, Component Interface, Peoplecode, Security, Tree Manager, Process Scheduler, Data Mover and Query tools.
• Extensive experience in writing Interfaces between PeopleSoft HRMS and Financials.
• Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization, and new development.
• Proficient in gathering and analyzing requirements to successfully design applications based on user needs.
• Provided extensive production support to HR, Payroll and Benefits modules.
• Ability to deliver the best even in the most critical phases of the project.
• Possess excellent communication skills, zeal to adapt to new technologies and good Team Player.

TECHNICAL SKILLS

ERP Module: PeopleSoft Hrms (8.9/9.0/9.1/9.2 ), PS HRMS (HR, Payroll, Benefits, TAM, eBenefits, eProfile, eRecruit, T & L), Workday, PS ELM (9.1/9.0), PS Portal(9.0)

People Tools: Application Designer, Peoplecode, Application Engine, Component Interface, Security, Data Mover

Reporting Tools: SQR, Crystal Reports, Nvision, Business Objects, BI Publisher, OBIEE

Databases: Oracle, DB2 and MS SQL Server

Operating Systems: Windows Server 2008, UNIX (AIX, HP, Solaris).

PROFESSIONAL EXPERIENCE

Confidential, Owing Mills, MD

PeopleSoft Techno Functional Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft HCM 9.2 and People Tools 8.55. Involved in the design, development and testing of all HR, Payroll, Time and Labor, Benefits Administration, Manager Self Service and Employee Self Service.
• Perform Fit-Gap Analysis to come up with requirement matrix based on new features/changes in PeopleSoft 9.2 features.
• Involved in the business process meetings along with Functional resources to identify the customizations.
• Modified the application package people code on different TAM pages like Career and Job Posting pages.
• Modified the existing HR/Payroll interface programs (SQR, Application Engine) as per latest version changes.
• Tested the custom application engine program to extract the data from the PeopleSoft recruitment tables into flat files.
• Modified several classic PIA components to Fluid UI pages.
• Detailed impact analysis was done to identify the objects, compared between old and new model to retrofit. All customized objects were identified, exported and migrated.
• Retrofitted all the customized objects to remove hardcoded database names and Url Definitions.
• Work involved development of interfaces with Component Interfaces to read inbound files and manipulating the PeopleSoft tables.
• Generated WSDL’s using Integration Broker for Externals users to access the PeopleSoft Data
• Set up roles, permission lists including row level security, department based security and created user profiles to establish security for the system.
• Configured request approval functionality, including multilevel approvals and alternate approvers using Employee Self Service, Manager Self Service and Approval Workflow Engine.
• Modified Application Engine programs and processes (SQL and Application Engine Peoplecode) based upon business requirements.
• Set up the open enrollment system for the new employees. Prepared the election analysis reports for the Open Enrollment Process
• 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.
• Upgraded several Custom pages, modified Custom People Code & work flow for new Person Model.
• Managed daily HRMS which consisted of multiple jobs and benefit event maintenance and implementation of yearly Open Enrollment, which consisted of employee choice options and selective Benefit elections of non-choice active and retired employees.
• Compared and Migrated Actuate objects from development to test environment and planned the migrations in the time of Refresh and upgrade Period.
• Developed custom AWE process to implement custom position request form approval process in HR, worked on the setup of transaction registry, approval process setup, user list and wrote code for instantiating/Launching AWE.
• Worked on the T&L customization of overtime request form pages and developed new pages for missed clock form and absence request form for employee self service and approval pages for manager.
• Used Component Interface and Application Engine program for Conversion of JOB data, Personal Data and Payroll Data (Earnings, Deductions, and Taxes) and Base Benefits Data (Dependents Data, Health Benefits, Life ADD Benefits, Disability Benefits, Pension Plan and Savings Plan).
• Developed custom Time and Labor rules to take care of Rounding Rules, Meal over Times and Scheduled Day off. Also, created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Provided production support and successfully resolved the defects raised in Upgrade Process.
• Planning and executing the migrations to next environments and keeping the Projects in Synch.
• Actively involved in the testing and issue resolution of system integration testing and UAT.
• Completely worked in People tools Upgrade project 8.55 and retrofitted all the objects.
• Imported and exported the projects from and retrofitted to keep the Projects in Synch.

Environment: PeopleSoft HCM/ELM v9.1, v9.2 (TAM, CG, T&L, Payroll, Benefits), TOAD, Unix, Tools v8.53, Tools v8.55.12 AWE, App Package

Confidential, Boston, MA

Senior PeopleSoft HCM Techno Functional Consultant

Responsibilities:

• Extensively worked on Implementation of PeopleSoft HRMS System Development, Customization, and Support of HR, Payroll.
• Interacted with Business analysts to understandspecifications of the project.
• Developed Application Engine Program to take the snapshot of the State tax and Tax Distrib records before loading the data from KPMG file and then load the data.
• Developed Application Engine Program to load the newly added states that are received as a part of KPMG file into State Tax and Tax distribution Records.
• Developed an SQR process to generate the audit reports of the State Tax/Tax Distrib data to the newly added states that are loaded as a part of KPMG file.
• Developed Application engine program using component interface to restore back the data to State Tax/Tax Distrib records after the load process.
• Involved in payroll automation configuration set up.
• Wrote Data mover scripts for Migration of Data across Different Databases.
• Developed Application Engine Program to upload Hire Information from Data file into Tables using File Layouts and Peoplecode.
• Designed and developed several critical reports, extract programs and interfaces using SQR.
• Prepared Technical Design Documents and provided KT for the processes.
• Introduced Agile software development life cycle to client to decrease the implement time for few critical and complex requirements.
• Designing & Developing Application Packages, to provide & consume web services using PeopleSoft Integration Broker.
• Created a custom Application Package for implementing error handling for the custom Load Applicant Data and Hire applicant Application Engine programs.
• Customized various pages in Core HR, Payroll as per the client needs. Created custom application package for the Peoplecode.
• Reconfigured the existing learning programs/certifications/activities to resolve issues with integration with HR.
• Designed and developed a custom Run Control Page for the XMLP Application Engine program where user can select the output format (XLS or PDF or RTF or HTML). Output for each interface file generated from the Application engine would Retrofitted the pay check generation (PAY003) SQR process and advice form generation (DDP003) SQR programs to include the client specific XML tags to pay check/advice form data source.
• Involved in Integration, functional and regression testing using Manual Testing methods and QTP Automation Tool.
• Responsible for on time and quality deliverables, preparing day-to-day testing status report.
• Developed the PeopleSoft HR cutover plan to Workday and participated in the overall PeopleSoft HR to Workday cutover planning and activities.
• Developed SQR’s to extract the data from PeopleSoft HR to Workday
• Hands on experience in writing the SQL queries
• Provided mappings for PS translates to match the Workday values.
• Wrote a series of SQR’s such as Hire Employees, Personal Information, Create position, Employee job and Position History, Requisitions, Recruiting, Employee Emergency Contacts etc to extract the data from PeopleSoft to Workday.
• Developed an SQR to retrieve the whole population of PeopleSoft which includes all Active, Contingent workers, POI’s and terminated employees for 1 year.
• Participated in integrations to bring back the Payroll data to PeopleSoft.
• Involved in code review and Participated in Workday data scenario testing.
• Participated in daily conversion meetings and reviewed the PeopleSoft logics for which data to be converted to Workday.

Environment: PeopleSoft HCM/Core HR v9.2 (Payroll), Workday, Tools v8.54, AWE, App Package

Confidential, Wilmington, DE

Senior PeopleSoft Techno Functional Consultant

Responsibilities:

• Extensively worked on Implementation of PeopleSoft HRMS System Development, Customization, and Support of HR, TAM & CG.
• Setting up of TAM & CG related security like Recruiting roles, Recruiting row level permission list
• Functional setups including all Recruitment module setups for the Candidate Gateway and TAM. Functional security and site setups for multiple web site entries for open positions in a World Wide environment.
• Design of the Functional and Technical Specs for the TAM & CG customizations
• Configurations in Recruiting installation.
• Configuration and Administration of TAM & CG transactions Created Custom labor distribution process using App Engine Program.
• Analyzed and designed the customizations of delivered Global Absence management for Vacations and Work Risk leaves for Confidential .
• Online pages to view the Leave balance and Comp time Balance at one place.
• Created training plans and documentation for functional users on the use of the product.
• Created complex queries for functional users to support day to day processing.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Design and developed custom message based web Services to render equipment, personal and task related data to the custom java based Ops Board portal.
• Developed GL Interface that loads data from various external systems into PeopleSoft General Ledger using SQR, which includes implementing complex business rules like Combo Rules, subtotals on Business Unit level, grand totals, error handling procedures, printing multiple output reports maintenance report and processead file report. Used various SQR functions, Arrays, Trees, Views, Load Lookup & SQC (which handles various Invalid Chartfield Combinations).
• 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.
• Provided Technical Support to the business users.
• Created two custom pages, one for displaying the recent paycheck information and the other to display the previous paycheck information.
• Modified Peoplecode to validate the emergency contact information and display the error messages if key information is missing on the pages and to default country to USA if user has selected a different value other than USA.
• Designed and developed an outbound interface for stock options using SQR to send participant transactions for active, terminated and retiree employees.
• Created a new outbound SQR to send all eligible enrollees and dependents to initialize the new Empire plan carrier.
• Created a new outbound SQR to extract all the enrollees who are eligible for low income subsidy as part of the medicare part D module and transmit the extracted file to Part D vendors.

Environment: PeopleSoft HCM/CRM v9.1 (MSS, ESS, HR Help Desk), Portal, Tools v8.52, TAM & CG

Confidential, Houston, TX

PeopleSoft Technical Consultant

Responsibilities:

• Setup, configured and troubleshoot PeopleSoft Enterprise Integration Points (EIP’s) between ELM 9.1 system and HRMS 9.1 PeopleSoft system. Person and Organization, Objective and Competency EIP Messages (Full Sync and Incremental Sync EIP’s).
• Worked with ExcelToCI tool import Learning Resources,update/map Learning references to objectives/competencies and written sql data loading scripts
• Performed installation, maintenance of PeopleSoft ELM software and migration of configuration (i.e setup data between environments.
• Designed and developed many inbound and outbound interfaces to and from PeopleSoft payroll system.
• Debugged and modified several batch processes like Vacation Process, Sub Credit Union Process for the Payroll team.
• Involved in converting data from Legacy system to PeopleSoft using Application Messaging, Component Interface and Application Engine.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Analyzed the Customizations to the delivered SQR reports and worked with the functional analyst to determine if the Customizations need to be reapplied or retired.
• Reapplied the Customizations to SQR reports in the new release.
• Modified custom built SQR interfaces, conversion, and report programs to in corporate new fields and changes that were introduced in new release.
• Worked on custom Disability batch process which calculates the number of pay hours of the Employees who are on disability in the current pay period.
• Worked on Performance tuning of Customized Application Engine and SQR Processes.
• Online development/customizations of pages, queries and online validation using Peoplecode.
• Supported PeopleSoft Payroll by debugging user and system errors in Payroll processes which includes SQR, Component Interface and Application Engine Processes.
• Involved in design and implementation of standard heading SQC’s customized to suit client requirements for all the payroll-related reports.
• Designed and developed several interfaces to load data into PeopleSoft Payroll from different vendors/systems using SQR, Application Engine and Component Interface.
• Designed and developed to modify Health and Safety module to add new fields to track if the accident is the result of the operation of motor vehicle.
• Designed and developed Component Interface to terminate the benefit due to death, Utilized Application Engine to invoke the Component Interfaces.

Environment: PeopleSoft HCM v9.1 (T&L, Payroll, TAM, CG), Tools v8.50, SQR, BI Publisher

Confidential, Washington D.C.

PeopleSoft HRMS 9.1 Consultant

Responsibilities:

• Designing, coding and testing PeopleSoft Human Resource and Payroll modules.
• Involved in converting the general designs to detailed designs for PeopleSoft HR/Payroll products for custom reports and online PeopleSoft processes according to the client requirements.
• Involved in design and implementation of standard heading SQCs customized to suit client requirements for all the payroll-related reports for PeopleSoft.
• Worked on detailed designs for HR module for retrieving the employee’s historical data from Oracle Data Warehouse.
• Worked on Automatic Union Dues Set-Up utilizing PeopleTools and Peoplecode to in corporate new and complex validations.
• Developed many tax calculation reports like percentage of Tax variation from previous quarter current quarter. Federal and State tax reports.
• Requirement analysis & program specifications.
• Involved in impact analysis, design and testing of the Application Engine, SQR reports, SQR Interface, Pages.
• Study of Functional design and Documents provided by Client and prepared the Technical design specifications.
• Set up Workgroups, TRC’s, TRC Programs, Rule Programs, Value Lists, Static and Dynamic Groups.
• Developed Custom Time & Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time & Labor.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.
• Developed Queries to modify reported hours. Queries are using by Task Group employees as they are allowed to report over time.
• Developed data mover scripts to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.

Environment: PeopleSoft HCM(Profile Management, ePerformance, NA Payroll, T&L) v8.9/9.1, People Tools v8.50, AWE, IB, App Engine, Application Packages, Send Master, SOAP UI

Confidential, Charlotte, NC

PeopleSoft Developer

Responsibilities:

• 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.
• Involved in converting data from Legacy system to PeopleSoft using Application Messaging, Component Interface and Application Engine.
• Developed Application Engine Program to upload Hire Information from Data file into PS Staging Tables using File Layouts and People Code, which will be further populated into Corresponding PS tables using Conversion SQR programs.
• Setup EE information in Payroll Module to calculate EE Earnings and Taxation of their Earnings and Benefits.
• Reapplied the customizations to SQR reports in the new release.
• Retrofit the customizations and also involved in running the scripts and upgradation reports.
• Designed and developed international employee's compensation conversion program.
• Involved in Unit, Integration, System and User Acceptance Testing.

Environment: PeopleSoft HCM (Profile Management, ePerformance, NA Payroll, T&L) v9.0,Tools v8.49, AWE, IB