Summary

• Confidential has over Twelve Years of Experience in Design and Development of Applications in IT industry which includes Client Server, Relational Database and internet/intranet Environment.
• Possess More Than Ten Years of progressive Technical and Functional experience in customization and implementation of PeopleSoft 6.0/7.0/7.5/8.x/9.x. Functionally proficient in understanding business process, gathering and analyzing requirements, creating design specifications and user training. Technically proficient in module development, upgrades, interfacing, conversion, data migration and report writing.
• Successfully Implemented various Peoplesoft modules in Fortune 100 companies, such as Confidential, Confidential based on their organizational needs.

Peoplesoft PRODUCT EXPERIENCE

• Peoplesoft Global Payroll for Mexico
• HRMS/HCM 6.0/7.0/7.5/8.3/8.8/8.9/9.0/9.1/9.2: HR, Payroll, Payroll Interface, Time Labour, Payroll Accounting/Commitment Accounting, Absence Management, ePay, eCompensation, eRecruit, Benefits and Beneifts Admin.
• PeopleTools, PeopleCode, PS Query, SQR, Crystal Reports, Integration Broker, Application Engine, Applicatin Messaging, XML Publisher, Component Interface, PS/nVision,Tree Manager

TECHNICAL SKILLS

• Development Tools: Application Designer, Tree Manager, People Code, Integration Broker, Import Manager, Application Engine, Workflow, Upgrade Assistant, Component Interface, Application Messaging, XML Publisher, Data Mover Administration Tools: Security Administrator, Performance Monitor, Data management Batch Processing: Mass Changes, Process Scheduler, File - Aid Reporting Tools: SQR, XML Publisher, PS/Query, Crystal Reports, Shell Scripts, PS/n Vision, Operating Systems: Windows, UNIX, Mainframe, Sun Solaris, Linux and AS/400
• Languages: Java, C, C, COBOL, JCL, Easytriveve, SQL
• Database Systems: Oracle, DB2, Teradata, Informix, and SQL Server.
• Graphical User Interfaces: Visual Basic 5.0/6.0, Developer 2000
• Enterprise Resoure Planning ERP Products: Peoplesoft HRMS 6.0/7.0/7.5x/8.x/9, Lawson 9.0

PROJECT HIGHLIGHTS

Confidential

Peoplesoft

• Developed Custom application for Payroll/Commitment Accounting module.
• Written Application Engine programs to process the transactions related to Direct and Budget Retro.
• Involved in preparing the T L rules as per the customer needs.
• Generated Workflow setup for Payroll/Commitment transactions to get the proper approvals before processing them into GL Interface.
• Developed Application Engine Program, to auto enrolls employees into T L system with various validations.
• Involved in identifying the proper rules to identify the right group of employees in T L system integration.
• Discussed with Functional user and core HR team on Requirements and changes to corresponding documents for proper code development.
• Modified Graduate assistant process to integrate with new PeopleSoft version using Messages in integration Broker between HR and CS applications.
• Modified Annual Benefits Base Rate ABBR process for employees and Generated Report using Application Engine Program as per Benefits Team requirements.
• Generated Community Fund Drive process as per Payroll Team requirements.
• Modified Self-Service page to provide W4 Tax information for State level with other State Mandatory level validations.
• Modified couple of Recruitment pages, to include new validation as per University Standards.
• Generated 1042 Tax Balance reports as per University Standards.

Environment: PeopleSoft 8.9/9.2, HR, Payroll Accounting/Commitment Accounting Base Benefits, Benefits Administration, Recruitment, Payroll, Time and Labor, Absence Management, People Tools, SQR, Integration Broker IB, XML Publisher, Data Mover, People Code, Oracle SQL Developer, Stat, Oracle Unix.

Confidential

Peoplesoft HCM/Financials

• Design and Developed an Integration process between Peoplesoft System and external Visual Basic to retrieve Employee Job and pay related data through Integration Broker.
• Conducted meetings with users to identify the problems and issues involved in the development of Peoplesoft Pages, components, interfaces, reports, etc.
• Interacted with users regarding their requirements and helped them in understanding the new system.
• Developed a process to Auto Enroll employees into Time Labor system, with predefined validation values of Employee Class, FLSA Status, Employee Type, Department id and Job code.
• Involved in defining the T L rules for the customer as per their validations.
• Created an Application Engine Program to feed Retirement Plans and Savings Plans such as 401k Benefits data into Peoplesoft Benefits Tables.
• Created an Application Engine/Integration Broker Connection between different universities and third party Worker Compensation Team.
• Created an Application Engine Program to finalize all Open Events on a specific date range, to run the process daily.
• Fixed an issue with multi-job employees Time Reporting page, previous week and next week link issue and opened a ticket with oracle to fix the bug.
• Auto Enrolled Employees into Absence Management, by their Employee Class Value.
• Created a new file layout for Amex data transactions to insert into Peoplesoft Finance System Custom Tables and from there generated an XML publisher Report as per customer requirements.
• Modified Peoplesoft delivered XML data mapping process between Citi Bank's Procurement and Travel Expenses transactions to load into Delivered Peoplesoft Finance Tables System.
• Created couple of new records and pages, according to the new customizations required by the end-users.
• Modified couple of People codes and corresponding validations as per user's requirements.
• Modified couple of SQR's to re-direct the output files to required FTP Folders.

Environment: Peoplesoft 9.1, HR, Base Benefits, Benefits Administration, Recruitment, Payroll, Time and Labor, Absence Management, Procurement, Travel and Expenses, People Tools, SQR, Integration Broker IB, XML Publisher, Data Mover, People Code, Oracle SQL Developer, Stat, Oracle Unix.

Confidential

Peoplesoft HRMS/HCM

• Provided the Peoplesoft data and setup related information to Team to convert/Map the corresponding information from Previous Versions.
• Acted as a liaison between the users and technical team for Peoplesoft to provide the in depth business flow information.
• Analyzed and provided the information on Confidential HR System to Develop New Peoplesoft Security application, which can be utilized through out company wide for different applications.
• Involved in FIT-GAP Analysis with Business on reviewing the existing customizations.
• Modified the Workflow process related to Employees Name Change, Date of Birth and Created new workflow on Banked Vacation Process as per the client needs.
• Provided necessary suggestions on customizations to move them from 8.9 to 9.1 systems.
• Interacted with users regarding their requirements and helped them in understanding the new system.
• Written couple of SQR's to extract the data from previous environment to new 9.1 Environment.
• Modified couple of People codes and corresponding validations as per user's requirements.

Environment: Peoplesoft 9.1,HR, ESS, MSS, Benefits, eRecruit, eCompensation, Payroll, Time and Labor, People Tools, SQR, Data Mover, People Code, Toad, Oracle Unix.

Confidential

Peoplesoft HRMS

• Involved in Application Conversion from Peoplesoft to Lawson System.
• Responsible for Conversions, design and development of inter module Interfaces of Peoplesoft and Lawson.
• Converted the Benefits Bonus Flow to new version, where the bonus will be paid to Store Manager and Co-Managers for both Confidential and Sams Club Stores.
• Provided the Peoplesoft data and setup related information to Lawson Team to convert/Map the corresponding information in Lawson Related tables.
• Developed an Interface for Peoplesoft which can load all the HR transactions which are created in Java based customized application Global Associates information Network GAIN, using Cobol and SQR which executed in Unix and Windows applications.
• Acted as a liaison between the users and technical team for Lawson and Peoplesoft to provide the in depth business flow information.
• Provided the Peoplesoft Time and Labor Component interface to Java application to interact with Peoplesoft.
• Analyzed and provided the information on Wal-Mart HR System to Develop New Peoplesoft Security application, which can be utilized through out company wide for different applications.
• Data has been loaded through Cobol Programs into Security system by formatting the information from Peoplesoft for different applications such as Coaching, CPRS, Training and Development and access for Core HR.
• Modified the Core Peoplesoft Department alignment flows when certain Departments need to change their Seitd information.
• Modified various organizations wise reports that are used various Directors and Vice Presidents according to their requirements.
• Written couple of Cobol Programs that will be extracted from Peoplesoft tables and loaded into Data warehouse system, which is in Teradata.
• Written couple of Shell Scripts for Lawson to execute in Lawson Environment that loads the flat files data into Lawson tables.
• Written a Cobol Program, which runs in Mainframe to calculate the Store benefit amount, RPZ Regional Pay Zone for employees.
• Written an SQR process, which will update the job information that will maintain the data integrity between the position data and job data for the associate's supervisor information.
• Customized and Modified couple of Peoplesoft Time and Labor application modules to fit the organization needs..

Environment: Peoplesoft 8.x, Lawson 9.0, HR, Benefits, Payroll, Time and Labor, Payroll Interface, Unix Shell Scripting, People Tools, SQR, People Code, DB2, Cobol, JCL, Easytrieve, OS/390, Mainframe, Import Manager, Java, Teradata, WinNT UNIX

Confidential

Peoplesoft HRMS

• Developed the Peoplesoft Benefits Peoplesoft Payroll processes and reports in HRMS using COBOL and SQR.
• Conducted meetings with users to identify the problems and issues involved in the development of Peoplesoft Pages, components, interfaces, reports, etc.
• Interacted with users regarding their requirements and helped them in understanding the new system.
• Developed a Component Interface to load the Setup tables from input files using Application Engine.
• Assisted in Application upgrade from 7.5 to 8.3 for US, Canada and Mexico countries.
• Setting up of process scheduler to enable end user to do multi- process jobs to run at client or at server and also used process monitor to keep track status of the report
• Customized the Infonavit, Fonacat loans screens to fit the client requirement.
• Written Cobol program to extract the data from a flat file for Associates Cash Savings Commission data to load into table, which further to print in the associates paycheck payroll.
• Developed an on-line screen to accept the Miscellanies Deductions that should be taken out from associate's paycheck.
• Configured the web-based end users to view their reports online through nVision.
• Written an SQR which calculates the Associates bonus and loads the data into Customized bonus tables in Peoplesoft.
• Migrations of HR data using Import Manager, DMS scripts and Analyze setup .sqc and other global SQCs for system compliance.
• Written various SQL's that are executed in Informix in Unix environment to extract the data into a flat file those are transferred to Mainframe to load into DB2 tables.
• Demonstrated capabilities of loading the test data and verifying the data by running the audit programs, performing the parallel testing of the people soft system, documenting, and providing support to application team.

Environment: Global Payroll and HRMS 8.x Peoplesoft 7.5/8.x, HR, Benefits, Payroll, Payroll Interface, Component Interface, Application Engine, People Code, Mainframe, DB2, Cobol, JCL, Easytrieve, OS/390, People Tools, SQR, Import Manager, Informix, WinNT UNIX

Confidential

• Assisted in Application upgrade from 7.5 to 8.0. Ran compares reports Upgrade assistant scripts. Modified delivered scripts for security migration.
• Ran the Payrolls various payroll patches to upgrade the system to in sync with the federal rules and regulations.
• Interacted with users regarding their requirements and helped them in successfully storing the data, as well as generating reports.
• Development various data transfer process programs to insert the data into eRecruitment module tables.
• Analyzed and validated various resumes and their information to process into eRecruitment tables.
• Provided Security Access to the various users for the eRecruitement on-line screens.
• Developed new On-line eRecruit pages, according to customer Requirements.
• Modified the existing, so that the information on the pages provides sufficient information according the user requirements.
• Environment: PeopleSoft 7.5/8.x, HR, Benefits, Payroll, Payroll Interface, People Tools, SQR, Crystal, People Code, eRecruit, ePay, eCompensation, Oracle, Import Manager, Informix, Unix