EXECUTIVE SUMMARY

• 7 years of progressive technical experience in Customization, Conversions, Interfaces and Implementation of PeopleSoft 9.2/9.1/9.0/8.9/8.8 HRMS (Basic HR, NA Payroll, Time & Labor, Benefits Administration, Base Benefits and e - modules
• Experience with all PeopleSoft developing tools which includes Peoplecode, App Engines, SQR’s, Integration Broker, Component Interface and others.
• Experience in Batch Processing, Upgrade, Migration and Interfaces Development.
• Extensive experience in Integration tools like integration broker.
• Acquired in-depth knowledge of PeopleSoft modules working on production support.
• Developed various interfaces using applications such as SQR’s and Application Engines.
• Experience in building new components and customizing existing applications.
• Proficient in all phases of the systems development life cycle including requirements definition, data conversion, data mapping, system implementation, system testing and acceptance testing.
• Developed several Inbound and Outbound interfaces for third party applications.
• Extensive experience in reporting using various reporting tools such as SQR’s, Crystal Reports and PSQuery and Xml Publisher.
• Experienced in applying Patches, Fixes, Updates to the application.
• Customized various PeopleSoft objects according to the client’s requirements.
• Documented the processes developed and updated for future references.
• Efficient team player, ability to multitask with excellent communication and interpersonal skills.

TECHNICAL SKILLS

ERP: PeopleSoft 9.2/9.1/9.0/8.9/8.8

PeopleSoft Tools: Application Designer, PeopleCode, Application Engine, Change Assistant

PeopleSoft Modules: HR, Payroll, Benefits Admin, Time & Labor, Base Benefits and emodules

Reporting Tools: SQR, PS Query, Crystal Reports, Xml Publisher

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

Integration Tools: File Layout, Component Interface, Application Messaging, Integration Broker

Databases: Oracle 8.x/9i/10g, SQL Server,DB2

Data Management & Batch Processing Tools: Data Mover, Application Engine, Import Manager and Process Scheduler

Administration Tools: Portal Administration, Object Security, Workflow Administration and Query Security

Operating Systems: Windows 95/98/2K/NT/XP, UNIX, Mainframes

Programming Languages: Java,C,C#,.Net

PROFESSIONAL EXPERIENCE

Confidential, Oakland, CA

PeopleSoft HCM Functional Consultant

Responsibilities:

• Design, implement, and support technical solutions supporting the new PeopleSoft HCM system based on input gathered from a variety of sources.
• Developed tested plans for interface programs for Payroll, Human Resource, Benefits, and Benefits modules.
• Initiated and recommends changes in development, maintenance and system standards. Ensured that System Development Life Cycle and change management procedures are followed and documented to support each system development and change requests.
• Applied advanced applications programming concepts in designing, developing, modifying, debugging, and evaluating highly complex conversion programs.
• Created migrations packages and develop scripts for data and configuration to be migrated across instances.
• Reviewed requirements documents, functional and technical designs, and code.
• Trouble shoots the HR issues.
• Load Time & Labor data into Pay sheets.
• Set up the interface between Time & Labor and Payroll for North America.
• 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.
• Developed custom Time and Labor rules to take care of Rounding Rules, Meal over Times and Scheduled Day off.
• Created custom processes to have hourly employee counts based on the Full or Part Time status and the number of active hours worked.

Technologies: PeopleSoft HRMS 9.2(HR, Payroll, Benefits), People Tools 8.53, PS Query, Dell STAT.

Confidential, Federal Way, WA

PeopleSoft Technical Consultant

Responsibilities:

• Involved in the preparation of Technical Specifications, Design and Development, Testing and issue resolution of PeopleSoft Interfaces and Enhancements objects.
• Developed tested plans for interface programs for Payroll, Human Resource, Benefits, and Benefits modules.
• Produced Application Engine programs for account code conversions.
• Created Components, File Layouts, and Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Involved in online changes to the delivered pages, components, menus and translate values.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Created Queries and SQR Programs according to the requirements and attached the objects to the Process Scheduler.
• Established Inbound and Outbound Interface Programs by using Application Engine and Component Interface/ File Layout/ SQR to load the data into Time and Labor, Payroll and Benefits tables.
• Developed and modified multiple SQR reports and processes.
• Maintained and provided troubleshoot support for employee eligibility data. Provided Benefits Admin processing for employee enrollment and termination from benefit plans.
• Maintained PeopleSoft Base Benefits and Payroll core tables.
• Created and updated technical design documentation relevant to payroll specifications.
• Executed PeopleSoft Testing Framework

Technologies: PeopleSoft HRMS 9.1(HR, Payroll, Time & Labor), People Tools 8.53, PS Query.

Confidential, Oakland, CA

PeopleSoft Time and Labor Techno- Functional Consultant

Responsibilities:

• T&L system setup and configuration. Did entire T&L setup for Workgroups, Task groups, TRCs, TRC programs, Rule Programs, Reporting Templates, and customization of Self Service options for both Employee and Manager.
• Created Workgroups, Rule programs, Value lists. Defined Holiday schedules, Schedule calendars, and Time periods. Built Schedule Calendars.
• Worked on customization of timecard per business requirements.
• Played the key role for setting up the PS and Time and Labor security.
• Designed processes for auto enrollment in the T&L system. This was an automatic process, which looked for certain key job elements to segregate time reporters into different groups.
• Worked on the Approval Workflow Engine (AWE). It is the framework providing capabilities to create, execute, and manage your approval processes.
• Worked on using Approvals and Delegations with Time and Labor.
• Customized the approval process to allow a particular role user to approve time.
• Worked on the implementation of PeopleSoft delivered proxy (delegation) functionality.
• Worked on customizing the options for creating and assigning schedules.
• Performance tuning of Core TL Processes like Time Administration. One of the groups was extremely large, which created bottleneck for the process. Performed analysis to single out SQLs responsible for the bottleneck and redesigned the same for effective and efficient working.
• Designed numerous custom TL Rules. Additionally, created numerous template based rules, which easily satisfied the business requirements.
• Played a key role in the system testing phase. Provided active support during the entire phase of testing. Right from Time Entry to Payroll Load and analyzing exceptions.
• Developed migration scripts. Developed online queries for effective data analysis.
• Developed scripts to track the total TL transaction counts.
• Helped users in understanding the Time & Labor rules and how time is calculated in PeopleSoft.
• Developed PeopleSoft system training materials to provide detailed procedures for entering time data: Employee Time & Labor
• Developed PeopleSoft system training materials to provide detailed procedures for entering time data: Manager Self-Service.
• Developed PeopleSoft system training materials to provide detailed steps to approve time using AWE approval process.
• Developed PeopleSoft system training materials to provide detailed steps to use the PeopleSoft delegation framework.
• Involved actively in day to day production support activities which includes analysis and trouble shooting of the issues and fixing them accordingly.

Technologies: PeopleSoft HRMS 9.1(HR, Payroll, Time & Labor), People Tools 8.50, PS Query, AQT.

Confidential, South Portland, ME

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in developing management reports, correcting several bugs and Data migration from legacy to PeopleSoft System.
• Developed application engine programs for account code conversions.
• Used Data Mover extensively for data moving and worked on data cleanup.
• Customized the various tables and records by adding the required fields in addition and done validations and logic for the fields using People code.
• Scheduled various Programs to run automatically based on vendor requirements. Submitted processes to the Process Scheduler to run daily tasks at a specific time to run process recursively as a specific interval.
• Created new Queries, SQR Programs according to the requirements and attached the objects to the Process Scheduler.
• Used to interact directly with the roll out people and users for creating the specifications, user manuals and logic of the report.
• Experience in assisting customers in similar implementations of this product at more customer sites.
• Created database reports using SQR and SQC.
• Made required changes in TAM module to incorporate Position Management.
• Customized TAM to restrict from creating a job opening for a filled position by looking at the head count which is not a delivered functionality.
• Worked on issues with Candidate Gateway.
• Fixed PAYCALC related issues which was abending due to some bad data inserted in PAYLINE.

Technologies: PeopleSoft HRMS 8.9(HR, Payroll, Workforce Administration), People Tools 8.49, SQR, PS Query, Data Mover, DB2, Application Engine.

Confidential, New York, NY

PeopleSoft Techno-Functional Consultant

Responsibilities:

• Involved in the Full implementation of PeopleSoft HRMS Modules (HR, Benefits, Payroll, and Time & Labor).
• Identified rules and created specs, developed Rule Programs, TRC/TRC Program definitions, Workgroup definitions, and conversion specs for T&L enrollments.
• Active participant for implementation and support of HRMS 9.1 (Fit Gap, Functional Design, Configuration, Implementation, Conversion, Testing, Support, Training and Documentation).
• 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.
• Defined requirements for Fit-Gap analysis, data mapping, legacy system integration and customizations.
• Implemented Employee and Manager Self Service for Time & Labor.
• Implemented T&L Security to support numerous Dynamic Groups attached to Manager’s Access.
• Providing recommendations on reengineering Workgroups, TRC/TRC Programs, Rule/Rule Programs, etc.
• Created and maintained custom Time & Labor Rules, Application Engineto apply specific overtime, holiday, shift and labor rules to 7000 employee population.
• Created Leave program strategy with regard to Time & Labor.
• Created the strategy for Automated Dynamic Group Definitions to also include automated T&L Permission/dynamic group assignment, allowing for automated T&L Security.
• Created TRC (Time Reporting Codes) Rules Definitions and TRC programs.
• Performed Configuration, Testing using PS Query for Core HR, Payroll, T&L, Benefits, and Payroll.
• Designed pages for the Benefits Administration, a new benefit plan for workers, Earnings, Deductions, Benefit plans, Benefit programs, Coverage, Coverage codes, Eligibility codes were configured. Coverage and coverage codes for union & non-union workers were different.
• Project co-ordination between customers and technical staff.
• Prepared presentation scripts illustrating system functionality for the Firms system owners and decision makers.
• Executed unit test plans for medium complexity batch interface programs for Payroll, Human Resource and Benefits modules.
• Conducted Test Coordination meetings with QA teams.
• Involved in the preparation of Technical Specifications, Design and Development, Testing and issue resolution of PeopleSoft Interfaces and Enhancements objects.
• Supporting weekly and biweekly payroll system and resolving issues on N/A payroll 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.

Technologies: PeopleSoft HRMS 9.1 (Payroll, Time and Labor, Base benefits, Benefit Administration, eBenefits, eProfile, ePerformance), People Tools 8.50, Oracle.

Confidential, Minneapolis, MN

PeopleSoft Technical/ Functional Consultant

Responsibilities:

• Involved in HRMS Upgrade Process from 8.8/ 9.0.
• Reviewed the compare reports, mapped the gap between 8.8 and 9.0, tuned the Data, and loaded AE programs.
• Developed and updated technical design documents due to upgrade changes.
• Developed Inbound and Outbound Interface Programs by using Application Engine and Component Interface/ File Layout/ SQR to load the data into Time and Labor, Payroll and Benefits tables.
• Developed and modified multiple SQR reports and processes.
• Developed new SQR and SQC programs as per requirement.
• Modified the SQR custom reports upon the addition, deletion of new fields to make them compatible with new version.
• Generated a process to create interface between Benefits and Time & Labor which compares Employee's leaves recorded in Time & Labor against the allowed leaves.
• Customized and created custom SQRs for Payroll, Benefit and Time and labor.
• Designed the Workflow application, created the Workflow maps to maintain Security using Workflow
• Created Users, Roles, and Permission lists.
• Moved Permission lists from Development to test, to production.
• Monitored the flow of work through the system and troubleshooted the HR issues.
• Involved in Pay Calculation, pay sheet creation process.
• Setting up one time deductions, and Time and Labor dynamic security
• Involved in test run for Time and Labor conformation.
• Involved in setting up Pay Calendars and Pay periods, Company General Deductions.
• Worked on Fast Security Views in the Payroll to Improve the Performance of the Queries like Pay Earnings, Pay check Views, etc.
• Involved in the Application Engine Programs to get data from 8.8 to 9.0.
• Application Engine Performance tuning, Moved People Code between 8.8 to 9.0.
• SQL fine tunings and Update the back end tables upon the user requests.
• Modified the work flow and routings depend on the business process changes.
• Developed Queries using Query Manager which depend on the Functional and Business analyst requirements to see the reports.
• Troubleshooted the Time and labor issues in production.
• Involved in the Upgrade Process and all phases of Testing.
• Involved in preparation of test data, test scripts and test cases.
• Assisted users in user acceptance testing.
• Followed client’s all documentation standards.

Technologies: PeopleSoft HRMS 8.8/9.0, People Tools 8.42/8.49, Application engine, SQR, SQL, People code, Work Flow, Query Manager, SQL Server, Crystal Report, Component Interface, XML Publisher.

Confidential, Erlanger, KY

PeopleSoft Technical/ Functional Consultant

Responsibilities:

• Involved in Fit-Gap analysis, Preparing Technical design documents, developing the Implementation plan, Data mapping, Designing & Conducting Test plans & Test scripts.
• Did the analysis on existing customizations, interfaces, and reports, identified the changes that needed to be made and documented the impact from the technical perspective.
• Performed Retro-fit on Custom SQRs, App Engines, and Pages.
• Provided support for system configuration changes for Event Maintenance. Worked on the design, testing, and implementation of configurable components.
• Analyzed the customizations to the delivered SQR processes & reports and worked with the functional analyst to determine if the customizations need to be reapplied or retired.
• Developed Application Engine programs to convert Position Data, Job Data, Personal Data, Departments, JobCodes and Training Data.
• Developed Component Interfaces to load the job codes, disciplinary actions and union job requisitions.
• Designed and developed the Application Engine process to load the applicant’s data from third party system to PS applicant tables using People code and Component Interface.
• Supported weekly and bi-weekly payroll.
• Created HR, Benefits, and Payroll custom interfaces and processes using SQR and Application Engine.
• Involved in the design of automated benefits enrollment process, core tables in HR and Benefits Administration, defining eligibility rules and creating event rules.
• Analyzed, designed and developed various SQRs like Garnishment reports, General Deductions Report, Termination Report, Absence Report, Fund report, Severance Report, Unemployment Wages Report, New Hires reporting by locations and fund locals, multiple locations worked, Quarter to date Labor hours Report, and employee Benefits report.
• Developed SQR for onetime deduction in Payroll.
• Customized Application Engine program to upload Time to Payroll Paysheets.
• Modified Payroll Check, Print report and Direct Deposit Advice, Print Report programs as per client's requirement.
• Worked with PeopleSoft to fix bugs and provide enhancements.
• Worked on day-to-day requests to fix the Production problems.

Technologies: PeopleSoft HRMS 8.8/8.9, People Tools 8.42/8.49, PeopleCode, SQR, Workflow, Integration Broker, File Layout, Application Engine, Component Interface, Data Mover, Oracle 9i, UNIX.