PROFESSIONAL SUMMARY:

• Qualified Certified professional wif 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 TEMPthan 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 has 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 wif 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 teh best even in teh most critical phases of teh 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 teh 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 wif requirement matrix based on new features/changes in PeopleSoft 9.2 features.
• Involved in teh business process meetings along wif Functional resources to identify teh customizations.
• Modified teh application package people code on different TAM pages like Career and Job Posting pages.
• Modified teh existing HR/Payroll interface programs (SQR, Application Engine) as per latest version changes.
• Tested teh custom application engine program to extract teh data from teh PeopleSoft recruitment tables into flat files.
• Modified several classic PIA components to Fluid UI pages.
• Detailed impact analysis was done to identify teh objects, compared between old and new model to retrofit. All customized objects were identified, exported and migrated.
• Retrofitted all teh customized objects to remove hardcoded database names and Url Definitions.
• Work involved development of interfaces wif Component Interfaces to read inbound files and manipulating teh PeopleSoft tables.
• Generated WSDL’s using Integration Broker for Externals users to access teh PeopleSoft Data
• Set up roles, permission lists including row level security, department based security and created user profiles to establish security for teh 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 teh open enrollment system for teh new employees. Prepared teh election analysis reports for teh Open Enrollment Process
• Improved system productivity and processing execution time of Open Enrollment.
• Interaction wif 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 teh migrations in teh time of Refresh and upgrade Period.
• Developed custom AWE process to implement custom position request form approval process in HR, worked on teh setup of transaction registry, approval process setup, user list and wrote code for instantiating/Launching AWE.
• Worked on teh 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 has hourly employee counts based on teh Full or Part Time status and teh number of active hours worked.
• Provided production support and successfully resolved teh defects raised in Upgrade Process.
• Planning and executing teh migrations to next environments and keeping teh Projects in Synch.
• Actively involved in teh testing and issue resolution of system integration testing and UAT.
• Completely worked in People tools Upgrade project 8.55 and retrofitted all teh objects.
• Imported and exported teh projects from and retrofitted to keep teh 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 wif Business analysts to understandspecifications of teh project.
• Developed Application Engine Program to take teh snapshot of teh State tax and Tax Distrib records before loading teh data from KPMG file and then load teh data.
• Developed Application Engine Program to load teh newly added states dat are received as a part of KPMG file into State Tax and Tax distribution Records.
• Developed an SQR process to generate teh audit reports of teh State Tax/Tax Distrib data to teh newly added states dat are loaded as a part of KPMG file.
• Developed Application engine program using component interface to restore back teh data to State Tax/Tax Distrib records after teh 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 teh processes.
• Introduced Agile software development life cycle to client to decrease teh 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 teh custom Load Applicant Data and Hire applicant Application Engine programs.
• Customized various pages in Core HR, Payroll as per teh client needs. Created custom application package for teh Peoplecode.
• Reconfigured teh existing learning programs/s/activities to resolve issues wif integration wif HR.
• Designed and developed a custom Run Control Page for teh XMLP Application Engine program where user can select teh output format (XLS or PDF or RTF or HTML). Output for each interface file generated from teh Application engine would Retrofitted teh pay check generation (PAY003) SQR process and advice form generation (DDP003) SQR programs to include teh 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 teh PeopleSoft HR cutover plan to Workday and participated in teh overall PeopleSoft HR to Workday cutover planning and activities.
• Developed SQR’s to extract teh data from PeopleSoft HR to Workday
• Hands on experience in writing teh SQL queries
• Provided mappings for PS translates to match teh Workday values.
• Wrote a series of SQR’s such as Hire Employees, rmation, Create position, Employee job and Position History, Requisitions, Recruiting, Employee Emergency Contacts etc to extract teh data from PeopleSoft to Workday.
• Developed an SQR to retrieve teh whole population of PeopleSoft which includes all Active, Contingent workers, POI’s and terminated employees for 1 year.
• Participated in integrations to bring back teh Payroll data to PeopleSoft.
• Involved in code review and Participated in Workday data scenario testing.
• Participated in daily conversion meetings and reviewed teh 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 teh Candidate Gateway and TAM. Functional security and site setups for multiple web site entries for open positions in a World Wide environment.
• Design of teh Functional and Technical Specs for teh 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 teh customizations of delivered Global Absence management for Vacations and Work Risk leaves for ACSI.
• Online pages to view teh Leave balance and Comp time Balance at one place.
• Created plans and documentation for functional users on teh use of teh 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 teh custom java based Ops Board portal.
• Developed GL Interface dat 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 teh business users.
• Created two custom pages, one for displaying teh recent paycheck information and teh other to display teh previous paycheck information.
• Modified Peoplecode to validate teh emergency contact information and display teh error messages if key information is missing on teh pages and to default country to USA if user has selected a different value other TEMPthan 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 teh new Empire plan carrier.
• Created a new outbound SQR to extract all teh enrollees who are eligible for low income subsidy as part of teh medicare part D module and transmit teh 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 wif ExcelToCI tool import Learning Resources,update/map Learning s to objectives/competencies and written sql data loading scripts
• Performed installation, maintenance of PeopleSoft ELM software and migration of configuration (me.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 teh 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 teh Customizations to teh delivered SQR reports and worked wif teh functional analyst to determine if teh Customizations need to be reapplied or retired.
• Reapplied teh Customizations to SQR reports in teh new release.
• Modified custom built SQR interfaces, conversion, and report programs to in corporate new fields and changes dat were introduced in new release.
• Worked on custom Disability batch process which calculates teh number of pay hours of teh Employees who are on disability in teh 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 teh 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 teh accident is teh result of teh operation of motor vehicle.
• Designed and developed Component Interface to terminate teh benefit due to death, Utilized Application Engine to invoke teh 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 teh general designs to detailed designs for PeopleSoft HR/Payroll products for custom reports and online PeopleSoft processes according to teh client requirements.
• Involved in design and implementation of standard heading SQCs customized to suit client requirements for all teh payroll-related reports for PeopleSoft.
• Worked on detailed designs for HR module for retrieving teh 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 teh Application Engine, SQR reports, SQR Interface, Pages.
• Study of Functional design and Documents provided by Client and prepared teh 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 has hourly employee counts based on teh Full or Part Time status and teh 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 teh analysis of existing customizations, conversion, interfaces, and report programs and identified teh changes dat needed to be made and documented teh 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 teh customizations to SQR reports in teh new release.
• Retrofit teh customizations and also involved in running teh 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