SUMMARY

• Around 7 years of experience in Information Technology dat 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 noledge 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 teh 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 teh implementation of teh project.
• Solid working noledge 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.

• 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
• Tree Manager§ Integration Broker§ SQR
• PS Query § Crystal Reports § Production Support
• Performance Tuning§ Trouble Shooting
• PL/SQL § Data Mover § nVision
• Windows xp,2000,server 2000,2003§ UNIX/LINUX/SOLARIS
• Oracle 11g/10g/9i/8/7.x§ MS SQL Server§ DB2
• HR § Time and Labor

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Modules: HR, Payroll, Benefits, e-Performance, Contract Pay, Time & Labor. ELMS, Online Position Management.

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 teh customizations of teh 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 dat are identified in Payroll, Benefits, contract Pay, Compensation modules during Testing Phase.
• Responsible for Security Nightly Refresh. Responsible for maintaining integrity of all teh 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. dis 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

Modules: HR, Workforce Administration, Payroll, Recruiting Solutions, Manager Self Service, Pension & Benefits, Benefits Administration, e-Profile and Time & Labor.

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 teh customizations of teh 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 teh user selection on teh run control page specific process will execute and send teh 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 teh correct Chart of Account in teh General Ledger.
• Carry forward an existing SQR and enhance its functionality to report Retirement dates for Benefits Module users. dis report assists workforce planning when department or Business Unit Downsizing required.
• Developed an enterprise interface to SABA for our Learning Management System ELMS dat 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 teh 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 teh Value lists in SYNC throughout all Environments.
• Re-Applied all teh 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 dat teh 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. dis 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 TEMPhas 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 teh 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 teh 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 incorporate these changes.
• Modified DDP001.SQR (Create Direct Deposit File) to meet Bank of America and Client requirements.
• Even though teh run control page RUNCTL PAYINIT2 TEMPhas off cycle parameters SQR is not processing off cycle. Fixed teh 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

Modules: HR, TAM, Employee Self Service, Manager Self Service, Payroll, Time & Labor

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 teh compare reports along with other team members and carried over teh customizations of teh client application from 8.3 to 9.1.
• Created and customized Workflows to automate teh 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 teh client requirements.
• Involved in teh modification of pages/components and validating teh 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 teh customizations to teh delivered SQR reports and worked with teh functional analyst to determine if teh customizations need to be reapplied or retired and Developed SQR for one time deduction in Payroll.
• Retrofit teh customizations and also involved in running teh scripts and upgrade reports.
• Developed some custom pages to fetch teh Total reported hours to teh Payable Time and Labor distribution summary for teh 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. Teh client gave a word format for teh company and had to change accordingly.
• 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 from data source.
• Developed App engine programs to calculate teh flat rate for deductions and earnings of employees. Teh need of dis application engine arose due to teh removal of rate specific tables in version 9.1 such as Flat rate table, page rate table.
• Customized Job Data page to default teh FICA status field from teh COMPANY TBL, after entering teh position number.
• Developed custom Time & Labor Queries to enable Functional users to identify specific employees.
• Involved in Data mapping between teh 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 teh pay sheets with teh approved daily time records in T&L, replacing teh COBOL process.
• Developed Employee Review Reports, Personal Data reports, Year-to-date tax balances and earning balances reports.

Environment: PeopleSoft HRMS 8.3/9.1(HR, TAM, Base Benefits, Payroll, Time & Labor), LinuxOracle 11g, People Tools 8.22/8.51.

Confidential, Madison, WI

Responsibilities:

• Involved in conversion mapping. Mapping was done by reviewing PeopleSoft required fields, tan identifying teh legacy source and rules for moving teh 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 teh data from teh files for all defined contribution savings plans and load them into teh 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 teh proper earnings code to meet payroll requirements.
• Worked on payroll process such as Pay Sheets, Pay calculation, Pay confirmation and created Paycheck for teh 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 teh client requirement.
• Written Data mover scripts for Migration of Data Across Different Databases for teh Custom and Delivered Tables to fix teh 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 noledge transfer sessions with employees to go through issues, which could come up in future.
• Interacted with teh client to implement setup issues related to Benefits and North American Payroll configuration.
• Setting up of teh 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 teh 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 teh corresponding punch.
• Worked on customizing timesheet page to change teh way security is used in T&L. Based on teh role, managers and timekeepers get different access based on teh Pay period.
• Developed functional documents for Sqr reports in T&L to be retrofitted by teh offshore team. Examples of these reports include exception report, overtime report etc.
• Worked with Absence management team to design teh process flow for AMS and T&L. Since, their was no global payroll and AMS data was not going through T&L we had to get all teh 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 teh 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 teh employees.
• Created Test scenarios, End User training procedures during teh project cycle implementation
• Worked on mapping teh 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 teh 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 teh 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