PROFESSIONAL SUMMARY:

• Around 7 years of experience in Information Technology that included gathering user requirements, Systems Analysis, Design, Development, Implementation, Upgrade, Testing and Production Support of various Client Server and ERP applications.
• Around 7 years of experience in wide range of PeopleSoft HRMS modules including PeopleSoft HR, Time and Labor, Benefits, Recruitment Solutions, Workforce Administration and Payroll Applications.
• File Layout, Application Packages, Workflow, Process Scheduler, Data Mover and Reporting tools like XML Publisher, SQR, Crystal Reports, PS Query.
• Well versed with project development life cycle, System Business Process Analysis, Requirements Study, Fit - Gap Analysis and Post-Implementation support.
• In-Depth knowledge in Integration Tools including Application Engine, File layout, Component Interfaces, and Integration Broker (Application Messaging).
• Specialized in Data Extraction Interfaces and Conversion from legacy to PeopleSoft applications using SQR programs and Application Engine.
• Proficient with PeopleSoft HCM database and RDBMS concepts and good database programming experience using Oracle 11g/10g/9i/8i, MS SQL Server 7.0/6.5, SQL, PL/SQL and SQL Loader.
• Excellent Documentation skills in the creation of Technical Design Documents, Test Scripts and Detailed Design Documents using Oracle’s User Productivity Kit.
• Organizational PeopleSoft Support to end-users as well as development team during and after the implementation of the project.
• Solid working knowledge of reporting tools like SQR, Crystal Reports, PS Query and XML Publisher.
• Strong database skills include data modeling, database design, Oracle server-side programming in PL/SQL and Oracle database administration.
• Knowledge of app server configuration, PIA, Process Scheduler, web server.
• Excellent troubleshooting and problem-solving skills.
• Team player with excellent interpersonal communication skills and technical documentation skills.

TECHNICAL SKILLS:

PeopleSoft: HRMS 9.1,(9.0,8.9, 8.8, 8.3, 8.x)/People Tools (8.52/8.51/8.50/8.49/8.48/ 8.20 ),Application Designer People Tools People Code

Application: Engine File Layout Component Interface, Object Security Portal Workflow Tree Manager Integration Broker SQR, PS Query Crystal Reports Production Support

Performance Tuning Trouble Shooting: PL/SQL Data Mover nVision

Operating Systems: Windows xp,2000,server 2000,2003 UNIX/LINUX/SOLARIS

Databases: Oracle 11g/10g/9i/8/7.x MS SQL Server DB2

Applications: HR Time and Labor, Payroll for North America Pension & Benefits, Workforce Administration Recruiting Solutions, Benefits

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft HRMS from 8.8 to 9.1 with HR, Payroll, Benefits, Time & Labor. carried over the customizations of the client applications from 8.8 to 9.1.
• Created customized Value List Process.
• Customized Print Pay Advice (DDP003), Deduction Register, Payroll Summary Reports.
• Customized Garnishment Interface.
• Archived several Time&Labor, Payroll Tables TL PAYABLE TIME, TL RPTD TIME, TL EXCEPTION etc.
• Customized Job Code Component JOBCODE TBL by Adding a page for Appraisers/Apprisees.
• Created queries to identify employees who don’t have any Appraisers and identified employees whose appraisers are no longer qualified as Appraisers.
• Created Queries to identify e-performance Employees, Manager and Appraisers. Assigned Dynamic role for these queries.
• Created Courses, Training sessions and Enrolled employees into Courses which impacts PS TRAINING, PS COURSE, PS COURSE, PS COURSE DESCR, PS COURSE LICENSE, PS COURSE LANGUAGE Tables etc.
• Identified Security for Benefits, e-Performance Users and created Roles for individual Groups.
• Created Business Process Documents and Test scripts.
• Responsible for Unit Testing, System Testing, Regression Testing, Integration testing, User Acceptance Testing for Benefits and e-Performance Module.
• Resolved several defects that are identified in Payroll, Benefits, contract Pay, Compensation modules during Testing Phase.
• Responsible for Security Nightly Refresh. Responsible for maintaining integrity of all the custom projects throughout all environments like HCM91DEV, HCM91INT, HCM91TST, HCM91STG, HCM91FIT, HCM91PRD.
• Developed SQL Scripts to move data from Old Environments to New environments using a Link Server.
• SAP to PeopleSoft Account Code Load - Customized Integration broker to Load SAP Account Code data in to PeopleSoft. This is done publishing Asynchronous Message.
• Dynamic Role assignments IB message - Adjusted IB message/People Code to fix PeopleSoft bug.
• Created App Package for Approval Workflow Engine implementation
• Created Test scripts by using User Porductivity Kit (UPK)

Environment: PeopleSoft HRMS 8.8/9.1(, Payroll, Benefits, e-Performance, Contract Pay, Time & Labor.), SQL Server 2008 R2, People Tools 8.49.14/8.52.

Confidential, Houston, TX

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft HRMS from 8.9 to 9.1 with HR, Workforce Administration, Payroll, Recruiting Solutions, Self Service, Pension & Benefits, e-Performance, Benefits Administration and Time & Labor. carried over the customizations of the client applications from 8.9 to 9.1.
• Besides doing customizations for Upgrade project, I was involved in Testing Phase and Production Support.
• Primary point of contact for all Interfaces issues after go-live.
• Responsible to Migrate projects from Development environments to different TEST Environments.
• Developed a new outbound interface which generated XML Interface file to send job postings information to Monster, Workopolis Job sites.
• Rebuilt an existing 2 interfaces and make them into one interface. Depends on the user selection on the run control page specific process will execute and send the file to 3rd party.
• Rebuilt 2 existing interfaces into one outbound interface to send Job, Position and GL Data (General Ledger) from People soft to Khalix Ensight to identify budget for Workforce Planning Cycle in future.
• Developed an Interface to send all Payroll expenses and liabilities to be posted to the correct Chart of Account in the General Ledger.
• Carry forward an existing SQR and enhance its functionality to report Retirement dates for Benefits Module users. This report assists workforce planning when department or Business Unit Downsizing required.
• Developed an enterprise interface to SABA for our Learning Management System ELMS that Confidential uses to track and manage all in-house training sessions.
• Developed Benefits Flex Credit Audit Report to ensure Employees are not over allocated flex credits to Health Spending Account.
• Developed Unix Shell Scripts to FTP the files To/From people soft to External Servers.
• Integrate 3rd party systems and People soft systems with each other using People soft Integration Broker.
• Developed Data Mover Scripts (DMS) to keep the Value lists in SYNC throughout all Environments.
• Re-Applied all the customizations to Delivered/Customized Processes after Infrastructure team applied Maintenance Packs and/or Tax updates 11D/E/F, 12A/B/C/D/F.
• Tuned SQR to enhance Performance and to reduce Run Time by using Load-Lookups, Arrays.
• Included Time & Labor Security for some reports.
• Loaded data into HR Set up Tables by using File Layout and Component Interface.
• Developed an Application Engine outbound Interface for Annual Non-Discrimination Testing for all Confidential Employees to make sure that the company’s contributions made on behalf of Highly compensated employees is proportional to contributions made on behalf of not Highly compensated employees towards 401K Plan. File is sent to T.Rowe Price for further investigation.
• Developed Employee snap shot report for employees by using XML Publisher and App Packages. This report is widely used by Human Resource team, Recruiters & Management team to assist with Decision Making on Transferring, Promoting Employees. Report consists of Previous Employment, Compensation History, Bonus History, Education Details etc.
• Developed a PS Query to retrieve Employees who has more than one Active Flex Credit rows.
• Modified PreNotification Process functionality as per Client Requirements by changing people code on DIR DEP DISTRIB Record and by modifying PY IC DD DTA VW view.
• Fixed issues with Direct Deposit Account changes for USA Employees by adding Dynamic Prompt on BANK CD Field of PY IC DD DTA VW Record.
• Customized PAY105CN.SQR (Create ROE Web Export File) as per client Requirements.
• Developed Proration Garnishment Report for CANADA.
• Customized TL MNG PAY DET VW Page for Time & Labor users as per client Requirements.
• Identified and fixed issues with TIMEADMIN Process to help TIME & LABOR users.
• Users were not able to create New Template Build Rule in Time & Labor. Identified the issue and populate PS TL TMPLT PARMS Table (53).
• Re-Arranged Portal Navigation paths for custom reports/processes/interfaces on Payroll and Benefits Modules.
• Developed a custom table with around 120 fields and used the table as a base for Reporting on Employee Data.
• Customized PENSION PLAN Record as per client Requirements.
• Customized RUNCTL DDP001 Page as per Client Requirements and Modified DDP001.SQR to in corporate these changes.
• Modified DDP001.SQR (Create Direct Deposit File) to meet Bank of America and Client requirements.
• Even though the run control page RUNCTL PAYINIT2 has off cycle parameters SQR is not processing off cycle. Fixed the people soft bug on DDP002.SQR (Direct Deposit Register) to process Off Cycle selection.

Environment: PeopleSoft HRMS 8.9/9.1(HR, Workforce Administration, Payroll, Recruiting Solutions, Pension & Benefits and Time & Labor.), UNIX, Oracle 11g, People Tools 8.49/8.51.

Confidential, TX

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in upgrade of PeopleSoft HRMS from 8.3 to 9.1 with HR, TAM, Payroll and Time & Labor.
• Analyzed the compare reports along with other team members and carried over the customizations of the client application from 8.3 to 9.1.
• Created and customized Workflows to automate the process of Job Audits. Workflows involved creation of a number of Business Process Maps, Activities, Events etc., in generating different work lists, Notifications.
• Worked on PER099 (EMPLOYEE REFRESH Process) Application Engine Program according to the client requirements.
• Involved in the modification of pages/components and validating the data fields using People Code.
• Delivered XML Publisher using PS Query to generate reports for reported time data of employees.
• Developed inbound interface which loads/updates T&L tables using CI 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 Component Interface.
• 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 and Developed SQR for one time deduction in Payroll.
• Retrofit the customizations and also involved in running the scripts and upgrade reports.
• Developed some custom pages to fetch the Total reported hours to the Payable Time and Labor distribution summary for the person logged in Self Service using People Tools and People Code.
• Modified delivered XML Publisher templates PYCHKUSA and PYADVUSA for check printing / advice form printing specific to client requirements. The client gave a word format for the company and had to change accordingly.
• 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 from data source.
• Developed App engine programs to calculate the flat rate for deductions and earnings of employees. The need of this application engine arose due to the removal of rate specific tables in version 9.1 such as Flat rate table, page rate table.
• Customized Job Data page to default the FICA status field from the COMPANY TBL, after entering the position number.
• Developed custom Time & Labor Queries to enable Functional users to identify specific employees.
• Involved in Data mapping between the two systems, reports included Absence History, Employee Review Audit, and Department Salaries using SQR for Human Resources.
• Developed a new SQR process to update daily time records (replacing TLPTLRUN COBOL process). Also, developed SQR process, to update the pay sheets with the approved daily time records in T&L, replacing the COBOL process.
• Developed Employee Review Reports, Personal Data reports, Year-to-date tax balances and earning balances reports.
• Involved in conversion mapping. Mapping was done by reviewing PeopleSoft required fields, then identifying the legacy source and rules for moving the data. Data integrity was maintained throughout for employee records.
• Developed new Application Engine conversion program associated with Component Interfaces for Personal Data, Job Data for Employees and Contingent Workers, Emergency Contacts, Security/ User Profiles, and Badge Numbers.
• Designed and developed an Inbound Interface to read the data from the files for all defined contribution savings plans and load them into the PS SAVINGS PLAN and PS GENL DEDUCTION table with appropriate Pre-Tax, After-Tax, Catch-Up employee deduction percentages, hardship withdrawals new loans and loan payoff amounts.
• Setup calendars, workgroups, Taskgroups, TRC’s, Schedules, Dynamic groups, Security, and Time reporter data.
• Designed and customized a weekly elapsed time entry screen to include hourly totals, PTO balances, and holiday balances. Developled rules for overtime, holiday, time reporter status, TRC approvals, and comp time.
• Established workgroups based on employee’s duties, jobs, departments and unions. Defined workgroup defaults and options.
• Provided day breaker and rounding options, Value Lists, Rule Program ID, TRC program ID both for Positive Time and Elapsed time.
• Enrolled employees through Enroll Time Reporter page into T & L and assigned workgroup and task group to them here.
• Mapped time reporting codes to the proper earnings code to meet payroll requirements.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for the employees on off cycle and on cycle basis.
• Customized SQR reports BEN102.sqr, BEN105.sqr to change field format.

Environment: PeopleSoft HRMS 9.0(HR, Base Benefits, Payroll, Time & Labor), PeopleTools 8.49, PeopleCode, SQR, Crystal Reports, and MS SQL Server.

Confidential, Tucson, AZ

PeopleSoft Technical Consultant

Responsibilities:

• Developed custom Time and Labor Queries to enable Functional users to identify specific employees.
• Manage exceptions for Time reporters and approve time by Time reporters, requesting batch approval processes, reviewing attendance history.
• Extensively used workflow for self service applications in ESS and MSS. Customized pages like Personal information, Leave apply, emergency, contact information pages. Changed routing system as per the client requirement.
• Written Data mover scripts for Migration of Data Across Different Databases for the Custom and Delivered Tables to fix the Data conversion Issues
• Performed Interfacing, Conversions, data migration and report writing (using People Code, People Tools and SQR).
• Worked on setting up base HR tables, writing interfaces from HR to a third party Database as well to a third party Time Collection device called ACTIVE.
• Developed several SQR programs and associated People Tools objects for interfacing between PeopleSoft and Fidelity Investments for 401(k) administration. Outbound interfaces included passing PeopleSoft HR data for specific employee events, data changes, 401(k) contributions and loan payments.
• Worked on testing issues in Test and stage environments.
• Set up knowledge transfer sessions with employees to go through issues, which could come up in future.
• Interacted with the client to implement setup issues related to Benefits and North American Payroll configuration.
• Setting up of the module control tables in Benefits such as benefit plan table, coverage group table, leave plan table, salary rate table, retirement plan table, include field for employee deduction and company contributions. Load employee data from the existing Legacy system to PeopleSoft tables.
• Interfacing, Conversions, data migration and report writing (using People Code, People Tools and SQR).

Environment: PeopleSoft 8.9, PeopleTools 8.46, Expenses, Time & Labor, Benefits, Query Manager, Application Engine, People Code, SQL, SQR, Oracle 9i, Windows NT, Unix.

Confidential, Madison, WI

PeopleSoft HRMS Developer/Analyst

Responsibilities:

• Was responsible for successful UAT, and parallel testing of T&L rules.
• Developed an outbound interface file to send HR data from PeopleSoft to 3rd party system.
• Performed Fit Gap Analysis, provides Current System Business Process, Process Flows, Security, Issues, Defects, Reports information and mapping to Future system with certain definitions like Gap, Adequate, In Adequate.
• Developed a custom SQR to populate missing dependent data during open enrollment.
• Customized Time Admin to prevent single IN punches or OUT punches from going to exceptions, instead called another application engine from TL TA000600 to populate the corresponding punch.
• Worked on customizing timesheet page to change the way security is used in T&L. Based on the role, managers and timekeepers get different access based on the Pay period.
• Developed functional documents for Sqr reports in T&L to be retrofitted by the offshore team. Examples of these reports include exception report, overtime report etc.
• Worked with Absence management team to design the process flow for AMS and T&L. Since, there was no global payroll and AMS data was not going through T&L we had to get all the AMS data into T&L for rules processing.
• Created and maintained custom Time & Labor Rule Application Engine module to apply multi-site, multi-contract specific overtime, holiday, and shift and labor rules to 7000 employee population.
• Developed custom leave accrual process to send time data from T&L to Benefits for the calculation of leave accruals in Benefits.

Environment: PeopleTools 8.43, HRMS version 7.5/8.8, Time & Labor, Payroll, SQR, Application Engine, Component Interface, SQL, People code.

Confidential, OH

PeopleSoft Technical Consultant

Responsibilities:

• Worked on requirement gathering, Fit Gap Analysis, creating Functional Design Documents for a number of complex Custom Rules, which take care of Holiday, Holiday premium, Call Back and Comp Time pay for the employees.
• Created Test scenarios, End User training procedures during the project cycle implementation
• Worked on mapping the Time Reporting Codes to Earning Codes, created Leave Plans, Benefit Plans as well Benefit Programs.
• Worked on Creating and Updating Static and Dynamic Groups.
• Enrolled Time Reporters into the System. Defined Badge Details, Group membership.
• Involved in setting up Row Security Permission Lists for employees enrolled in Time and Labor.
• Developed Custom Time and Labor Reports which included Compare Reports, which were extensively used while transferring data from a Third party system to PeopleSoft Time and Labor
• Created Test Scripts which were used for System as well as Parallel Test cycles.
• Wrote a number of SQR Reports, which included delivered data as well custom records.
• Did extensive troubleshooting as well as tuning on the Time Admin process.
• Worked on trouble shooting issues with Payroll, which included Pay Calc and Pay Confirm.

Environment: People Tools v8.20, HRMS version 8.3, Time & Labor, Payroll, SQR, Application Engine, SQL, People code, Crystal Reports