SUMMARY

• Over Seven years of experience in Information Technology that included gathering requirements, analysis, design, development, and implementation of business applications systems in PeopleSoft.
• Progressive Functional and Technical experience in customization, implementation, development, deployment, integration, data conversion,, reporting and support of PeopleSoft HRMS 9.2/9.1/9.0/8.9 which includes HR, Payroll, Benefits, Benefits Administration, eBenefits, ePerformance, Time and Labor, Pension, Self Service, Position Management,Enterprice Learning Management(ELM).
• Strong PeopleSoft technical skills include People Tools (Application Designer, People Code, Application Engine, Component Interface, File Layout, Process Scheduler, Integration Broker, Workflow, Query, Data Mover, Security Administrator, and Definition Security), SQR, n - Vision and Crystal Reports.
• Proficient in preparing complex reports using XMLP (BI Publisher), SQR, Crystal reports & PS Query
• Proficient experience in Document writing and User .
• Experience in using Integration Tools like Component Interfaces, Integration Broker and Application messaging for interacting with in and outside People Soft applications.
• Excellent troubleshooting and problem-solving skills.
• Detail-oriented, multi-tasker with strong organizational skills.
• Exceptional verbal & written communications skills and Presentation skills

TECHNICAL SKILLS

ERP: PeopleSoft HRMS/HCM/ELM 8.3/8.8/8.9/9. X

PeopleTools: Application Designer, PeopleCode, Application Package, Application Engine, Data Mover, Tree Manager, Change Assistant/Upgrade Assistant, PS/Query, Ps Admin utility, Workflow, Integration Broker, Approval Workflow Engine and Approval workflow Engine (AWE)

Reporting Tools: SQR, PSQuery, Oracle Forms, Oracle Reports, Crystal Reports, Xml Publisher

PS Integration Tools: Integration Broker, Component Interface, File Layout, SQR

Debugging Tools: SQL Trace, PeopleCode Debugger, Application Engine Trace

Administration Tools: Workflow Administration, Security Administration, STAT

Development Tools: Toad, SQL Developer

Databases: Oracle 9i/10g/11g/12c, SQL Server, DB2, MS Access

Operating Systems: Windows NT, Unix

PROFESSIONAL EXPERIENCE

Confidential - Houston TX

Sr PeopleSoft HRMS Techno Functional Consultant

Responsibilities:

• Developed Application Engine programs to export Personal Data - Name, date of birth and address information to flat files using File Layout.
• Developed Conversion Application Engine programs to export Job Data information to flat files.
• Developed programs to extract setup information Departments, Job Codes, Locations, and Department security to flat files to send to SAP.
• Compared the exported information from PeopleSoft to the imported information to data dumps from SAP.
• Worked on various queries to provide information for TPIA requests.

Environment: PeopleSoft HRMS 9.1 and People Tools 8.52 (Application Designer, People Code, Application Engine, Component Interfaces, App Packages, AWE, XMLP), SQR, Microsoft SQL Server, Enterprise Learning Management(ELM),CRM.

Confidential - Houston, TX

Sr. PeopleSoft HRMS Consultant.

Responsibilities:

• Provided an analysis of the number of objects impacted by the upgrade for estimating the scope of work.
• Worked on retrofitting custom objects to work with the new 9.2 system.
• Retrofitted the custom sections of the resume template to work with the new train stop model.
• Designed and developed a custom process to send rejection emails to other applicants when a job opening is filled.
• Responsible for retrofitting the customizations in Recruiting module.
• Customized the AWE thread status App Package to fix the issue opening history approvals from the Portal.
• Designed and developed a custom solution to integrate the HCM, Finance and ELM worklists on the Portal.
• Created a Bonus request form with AWE approval.
• Retrofitted the Pay Check templates.
• Redesigned and fixed custom App engine process that transfer leave balances when an employee transfers between companies.
• Designed and developed a custom component as part of MSS for managers to request employee promotions, demotions and lateral transfers. The page involves AWE approvals with approvals up to the VP level of the Business Unit.
• Worked extensively in setting up Workflow in AWE.
• Setup integration between Confidential and Kenexa for applicant assessments.
• Modified existing Workflow to fix issues.
• Designed and Developed a Bolt on Application Engine program to clean up Worklist tables. The program is being used in both HCM and Finance systems.

Environment: PeopleSoft HCM, ELM 9.1/9.2, FIN 9.2 and People Tools 8.53/8.54 (Application Designer, People Code, Application Engine, Component Interfaces, Workflow, App Packages, AWE, App Messaging), SQR, Oracle 12c,CRM.

Confidential - Minneapolis, MN

PeopleSoft Technical Consultant

Responsibilities:

• Analyzed, designed and developed a new Component for rehire check and quick hiring/rehiring which involved in development of new custom pages to look up data from the Personal Data and Job Data.
• Validations in the Component ensured data quality, thus preventing bad into the Personal Data and Job Data components in the Peoplesoft system.
• Designed and developed a new component for Location - Shift Management which is not managed using the Table Set Sharing.
• Analyst and Developer for Express Release Projects group, a project to analyze users’ requests and develop customizations on a monthly basis.
• Analyzed, Designed and Customized the Business Title Field to be Effective Dated.
• Customized the search for Job Data, Personal Data and other components to enforce search based on the custom fields - Login name and Phone tool name.
• Designed and developed a new Application Engine with Component Interface which would automate a supervisor change in the Job Data for an employee when the supervisor is terminated.
• Developed a Job an SQR as an interface to the Badging system and Time Management systems and a new Application Engine which would send errors to the corresponding supervisor.
• Analyst, Designer and Developer for the cleanup of duplicate data in the Personal Data Component.
• Developed SQR to Read from file and Write to file as part of the Data Cleanup.
• Customized the PeopleSoft Employee License Management System. As part of it developed a new Application Engine to manage and notify, the employee, supervisor and the business partner of any employee licenses nearing its expiration.
• Developed new SQR to generate reports based on the License Management System.

Environment: PeopleSoft HRMS 8.9 (HR, Benefits, Payroll), PeopleTools 8.46.05, PeopleCode, Application Designer, Application Engine, Component Interface, File Layout, Process Scheduler, Query, SQR, Toad, Oracle 10G, UNIX

Confidential, Strongsville, OH

PeopleSoft Technical Consultant

Responsibilities:

• Worked extensively on integration of PeopleSoft Compensation, Variable Compensation, Payroll for North America, Benefits and Benefits Administration.
• Designed and developed custom PeopleSoft components with extensive People Code, conversion and interface programs for the HR, Payroll, Benefits and Benefits Administration.
• Involved in the conversion phase of Variable Compensation, HR, Payroll and Time & labor modules as a technical team member.
• Populated Base Pay Budget Current, used and remaining balances and percentages using peoplecode and JavaScript in Base Pay.
• Modified the PAY018 - Payroll Summary report, DDP004 and PAY004 programs.
• Created BEN384NC SQR for TODD Payment Processing report which will read Excel file as input and generates Excel file output with specified fields.
• Worked on the technical specification design and development of critical interfaces to payroll to bring data from third party time and labor systems.
• Responsible for running Payroll tests in order to confirm that Payroll would run successfully with needed updates to the Open Enrollment processes.
• Written several SQRs for updating employee level record on benefits, compensation, Payroll and also to accomplish periodic database updates and correct data errors
• Worked with business users to determine if certain requirements are needed or not and accordingly fixed or decommissioned the functionality.
• Performance tuned the core scheduling application engine program to run faster, and also fixed many defects in the program which were causing incorrect shifts to be created.
• Developed an online customization for On-Demand Termination of the employees in Managerial Self Service (MSS).
• Involved in workflow redesign processes and implementation of self-service technologies for managers and employees.
• Created new Application Engine & Component Interface program to upload employee’s new Compensation rates from input file to Job component.
• Added drill up and drill down functionality using peoplecode to pull the employees under manager in various online pages.
• Retrofitted SS EE COMP HIST Component of Employee Self Services which is used by employees to review or verify compensation history transaction. Details of stock options granted through a variable compensation plan can also be viewed. The employees can also view stock options details.
• Modified SS MG COMP HIST Component of Managerial Self Services which is used by managers to review or verify an employee’s compensation history transaction. Total compensation includes base salary, regular bonus, seniority, stock, monetary s,, Non-monetary s, and adhoc s. The managers can also view the total compensation for selected employees.
• Resolved and logged various day to day issues in Mercury.
• Customized pages for ePay to deliver Paycheck information, Direct Deposit information, W4 online.
• Worked on ePay to enable the employees to view, edit or discontinue direct deposit information and to request duplicate W-2forms.
• Experience in participating Mock conversions before go live.
• Wrote Application Engine programs to send the workflow notifications to the managers.
• Developed NCC PLCODES Application Engine Interface using File Layouts to load data from flat files to tables in various PeopleSoft environments.
• Extensively used PS/Query to develop ad-hoc queries, generate Crystal Reports and to produce analyzing reports using excel.
• Worked on Change Assistant for applying bundles, Tax Updates 10C through 10E.
• Proficient in migrating various objects from Development to Test and from Test to Production environment.
• Ran Compare Reports and moved Objects from one Database to another when required.
• Worked on various online reports in Compensation and variable compensation using SQL views and peoplecode.
• Generated excel files by writing SQL’s to Functional team for testing during mock conversions and go live.
• Designed and developed a new Application Engine with Component Interface which would automate a supervisor change in the Job Data for an employee when the supervisor is terminated.
• Developed several custom conversion programs using SQR and Application Engine Programs to load custom application data into PeopleSoft Time and Labor.
• Logged various issues in Enterprise Issue Log during Mock conversions and Go-Live.
• Developed Technical specs for the interface and reports in HR, Payroll and Benefits.
• Set up Task Templates, Task Profiles, Task groups and Workgroups.
• Defined Time and Labor Static and Dynamic work groups for specific group of time reporters.
• Set up Row security permission list to grant/limit the access of records and fields for time reporters based on the group .
• Set up and customized Work Schedules by creating Shifts, Workdays, and Schedule Definitions as per user requirements.
• Customized Daily Time Calendar, Weekly Elapsed Time Entry, and Punch Time Entry and Manager Time Approval pages as per the requirements. Extensively used PeopleCode and PeopleTools during the customization.
• Set up and build delivered / customized Time Period, Calendar, and Work Schedules.
• Developed Template/Custom Built Rules using Daily Threshold, Holiday, and Guaranteed Hours and customized the rules using SQL objects, actions and conditions as well as user exits.
• Set up Time Collection Devices (TCDs) for reporting time into PeopleSoft time and Labor.
• Developed interfaces to capture time from Kronos Management System into PeopleSoft Time and Labor System.
• Developed an interface for reporting time from a flat file using File Layout, Component Interface, and Application Engine into the PeopleSoft Time and Labor system.

Environment: PeopleTools 8.46.08, HRMS 8.9, Oracle 10g, UNIX, SQR, PeopleCode, Mercury Quality Center 9.0, Toad.

Confidential, New York, NY

PeopleSoft Technical Consultant

Responsibilities:

• Involved in full development life-cycle and new implementation of PeopleSoft HCM 9.0.
• Collaborated with various resources during meetings to discuss business requirements.
• Analyzed, designed and created technical specifications for Data Conversions.
• Applied Tax Updates for the fiscal year 2009 using Change Assistant.
• Developed conversion programs to convert the data from the legacy system to HR, Benefits and Payroll tables.
• Involved in running a payroll error tracking report before and after pay confirmation to debug payroll errors.
• Verify the configuration changes by running the BenAdmin to create OE event for all the EE’s. Make changes to the benefits of the test Emplid’s and run the BenAdmin followed by customized confirmation page process BAS005.
• Customized delivered Open Enrolment Confirmation Form BAS005, and developed online confirmation form to provide employees the ability to print their own Confirmation Statement.
• Customized payroll delivered SQR’s to meet the client’s requirements like PAY018, DDP001, PAY003 and PAY004.
• Modified BEN100 Process to run successfully after the Payroll changes.
• Customized delivered BAS004 that generates Leave of Absence enrolment forms for employees who go on leave, so they can make their elections during Open Enrolment.
• Implemented Time and Labor Security to support numerous Dynamic Groups attached to Manager’s Access.
• Worked on changing the online OE forms placed on the portal for the EE’s during Open Enrollment.
• Enhanced BEN100 Run Control Page to enable user to run the snapshot by scheduling it and also to be able to run it manually when needed.
• Setup Pay groups, Time Periods, Validation Set, Workgroups, Compensatory Time Plans, Time Reporting Template, Rapid Time Template, Rules Programs.
• Resolved Issues related to TL TA000900 Time Administration Process related to validating data and issue exceptions, rounding rules.
• Enhanced the Carrier EDI834 Changes File Interface to give a report to the user that has list of people who terminated from the benefit plan with a termination date other than the end of month.
• Supported data and process conversions from legacy systems to PeopleSoft tables.
• Created TRC (Time Reporting Codes) and TRC Programs along with functional users.
• Developed new SQR reports like Employee earnings history report EMP E HIS by from/thru dates range, Garnishment Deduction details etc.
• Involved in analyzing the Data Errors that occurred when off cycle payroll is run and fixed those Issues.
• Developed and maintained Manual Checks Detail Report. This report is intended to provide complete details of the manual checks issued in a pay cycle.
• Developed a custom Application engine program using Component Interface to create User Profiles in HR for all employees based on their location.
• Customized and Printed SQR Report ‘Tax910PR’ for the layout of W-2 forms as per the client requirement.
• Developed data mover scripts (DMS) to migrate Rules, SQL Objects, Messages and Message Catalogs, and Exceptions.fdbf
• Developed workflow to automate the notification for the employee about the open enrollment dates and changes occurred in the benefits and payroll rules.
• Configure, troubleshoot and Support all the tables involved in Payroll processing like Pay calendar, Job Code, Deductions and processes such as Pay Sheet creation, Pay Calc, Pay Confirm, Tax Tables etc.
• Reviewed client data and prepared Data Mapping for File Layouts from legacy to PeopleSoft formats.
• Produced PDF and spreadsheets report formats for HR by creation of SQR processes.
• Migrated customized objects from Development to Test Instances using STAT.
• Composed Queries and Crystal Reports for generating reports for modules HR, Benefits, Time and Labor.
• Handled security related issues for certain roles and also gave department level security through Tree Manager.
• Debugged and resolved various issues on SQRs, Application Engines, Application Packages and Component Interfaces.
• Created SQL’s to generate one time report as per the client requirements.

Environment: PeopleSoft HRMS/HCM 9.0, People Tools 8.48, HR, Benefits, Time and Labor, e-Pay, e-Benefits, MSS, ESS, SQR, Oracle 9i, UPK, Crystal report Version 10.