SUMMARY

• Certified technical PeopleSoft professional with over eight years of experience in all stages of systems development life cycle including business requirements gathering, documenting, design, data conversions, programming, system / integration / user acceptance testing, documentation and exclusive experience in PeopleSoft Human Capital Management and Technical Experience in implementation of PeopleSoft Human Capital Management Modules like Core HR, Payroll, e - performance, Benefits, Absence Management, Time and labor, Work Force Administration (Version 9.2, 9.1, 8.x).
• 8 years of experience in implementation, upgrade, writing interfaces and administration of PeopleSoft applications.
• Act as a Liaison between cross- organizational team to build products and services.
• Documenting all the customer requirement and creating Functional Design Documents.
• Experienced in coordinating with onsite and offshore teams to resolve issues related to application business processes and security.
• Extensively worked on system Security to implement security in various levels creating Roles
• Permission Lists, User Profiles, Portal Security, Definition Security, Query Security & Row level security
• Knowledge of PeopleSoft Enterprise Learning Management (ELM)
• Extensive work experience with MS Word, Excel and Visio.
• Experience in writing PL/SQL queries, Stored Procedures and Triggers and have exposure to different databases, includes SQL Server, Oracle, DB2.
• Worked on JAVA and HTML extensively during my projects.
• Coordinate and communicate with team members and business users and strong organization skills
• Strong critical thinking, problem solving, negotiation and facilitation skills.
• Proactive in completing the job with minimum supervision.
• Specialized in data extraction interfaces and conversion from legacy to PeopleSoft applications.
• Extensively worked with People Tools such as Application Designer, Approval Workflow Engine, Application Engine, Integration Broker, Application Messaging, SOA architecture, Component Interface, People Code, Security, Tree Manager, Process Scheduler, Data Mover and Query tools.
• Extensive experience in writing Interfaces between PeopleSoft HRMS and Financials.
• Worked intensively with Security Administrator to implement Row Level Security, Single Sign on, creating Roles, Permission Lists, User Profiles, Portal Security and Definition Security.
• Extensive experience on PeopleSoft Internet Architecture (PIA), PeopleSoft implementation, upgrade, tax updates, conversion, customization, and new development.
• Worked on wide variety of complex tasks and capable of taking ownership.
• Possess excellent communication skills, zeal to adapt to new technologies and excellent Team Player.

TECHNICAL SKILLS

ERP Module: PeopleSoft HCM (8.x/9.0/9.1/9.2), PS HCM (Core HR, Work Force Administration, Payroll, Benefits, Absence Management, Time and labor)

People Tools: Application Designer, People Code, Application Engine, Component Interface, Security, Data Mover

ETL Tools: Oracle Data Integrator (ODI), Microsoft SQL Server Integration Services (SSIS)

Reporting Tools: SQR, Crystal Reports, Business Objects, BI Publisher, OBIEE

Databases: Oracle, DB2 and MS SQL Server

Operating Systems: Windows Server 2008, UNIX (AIX, HP, Solaris).

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

PeopleSoft Functional Consultant

Responsibilities:

• Analyzing Pages, Components, and Menu Definitions for ASM tickets. Develop policies, procedures, and strategies related to the use, rights, access, and work flow relevant to Oracle and/or PeopleSoft Human Resources systems.
• Worked as Benefits Consultant with extensive knowledge of PeopleSoft Benefits Administration, Base Benefits, Absence Management, and Payroll.
• Finance experience with a focus on General Ledger.
• Worked in PeopleSoft upgrade from 8.9 to 9.2 for CRM, SIM and HCM.
• Post implementation 24/7 support.
• Worked with Integration Broker and PeopleSoft Web Services.
• Keeping track of new Functional Design Documents by assigning developers to the FDD.
• Worked with the security of the application.
• Solid understanding of waterfall methodology.
• Impact Analysis of issues and monitoring the progress made towards issue resolution
• Testing/Fixing of Change Requests. Write system specifications for customizations, reports, queries or other needed specifications
• UAT Support and focus on continuous growth and improvement.
• Production support and monitor the jobs. Monitor and report on the status of project.
• Environment: PeopleSoft 8.8, People Tools 8.49, SQR, People Code, Application Engine, Oracle 11g, CA Service Desk, UNIX.
• Provided PeopleSoft ePerformance module support to the client after upgrade.
• Development of SQRs as per the requirements

Environment: PeopleSoft 8.8, People Tools 8.49, SQR, People Code, Application Engine, Oracle 11g, CA Service Desk, UNIX.

Confidential, Charlotte, NC

Senior Functional Consultant

Responsibilities:

• Implementation Specialist for PeopleSoft 8.9 Ben Admin and E-Benefits modules.
• Modified payroll SQRW reports for custom Benefits features.
• Business Analysis in creating PS Query and to use the financial system modules Billing, AR, AP, GL, SQL, SQR,
• Configured and implemented Time and Labor module
• Optimized array sizes for the Ben. Admin. COBOL program, eligibility and configuration values.
• Developed SQR process to upload BAS Activities from a spreadsheet into the BAS ACTIVITY Table.
• Customized on-line pages for eBenefits using Application Designer and Peoplecode.
• Developed SQR and Crystal Reports for Ben Admin

Environment: PeopleSoft HCM 8.9, People Tools 8.49, PS Query, PeopleCode, Application EngineOracle, XML Publisher

Confidential, Houston, TX

Senior PeopleSoft Functional Consultant

Responsibilities:

• HRMS Global implementation production and intervention of oil and natural gas wells. It has presence in all the oil & natural gas regions
• Reduced the effort spent by the HR admins in the Job change activities.
• Requirements gathering.
• Termination activities are carried out, in one single navigation, with custom approval levels.
• This Confidential is leading oil and natural gas services company, providing drilling, evaluation, completion,
• Involved in requirements analysis, design & development of HRMS application from offshore.
• Modified several delivered pages & components, to take care of additional or modified fields.
• Worked in development of a major custom module, through which all hiring, job changes &
• Worked on the customizations required by the business, which were identified as a part of
• Worked predominantly on Core HR and Performance modules.

Environment: PeopleSoft HRMS 8.9, People Tools 8.49, Payroll Interface.

Confidential - New Jersey

PeopleSoft Functional Consultant

Responsibilities:

• Confidential & Company is a leading American Publishing and financial information firm, which is a part of News Corp group.
• Involved in HRMS system enhancements, and various customizations.
• Worked extensively on preparing functional specifications for all new requirements.
• Involved in effort and cost estimation for various new enhancements.
• Handled CWR hiring customizations which involved extensive usage of Component Interfaces and inputs from interface processes.
• Involved in Unit Test scripts, SIT, UAT and implementation plans.

Environment: PeopleSoft HCM 8.9, People Tools 8.49, PS Query, People Code, Application EngineOracle, XML Publisher

Confidential, Dallas (TX)

PeopleSoft Technical Consultant

Responsibilities:

• Involved in the Analysis and Support of PS HRMS 8.3.
• Developed programs using SQR for HR, Payroll, Benefits and T&L.
• Involved in customization and development of PeopleSoft applications using various People Tools such as Application designer, People Code, maintain security.
• Involved in setting up the core tables for HR module and Benefits module.
• Developed reports for HR, Payroll and Benefits.
• Developed SQR Interface from ADP Payroll to General Ledger
• Created Intermediate tables to store ADP Payroll Values in PeopleSoft.
• Created run control record and run control page to run the SQR.
• Modified People Code, Pages and Components to enhance the functionality as per client requirement.
• Created Record definitions, Page definition, Components, Run control panels, attached them to required menus through Application Designer and made them available to various operators through Maintain Security to have the reports run under Process Scheduler.
• Involved in running compare reports for tax updates. Analyzed the compare reports and retrofit the customizations.
• Involved in cleaning up the copy of production based on the DDDAudit and SYSAudit reports.
• Involved in troubleshooting and fixing bugs and problems.
• Prepared development documentation and migration documents for the object migration.
• Extensively executed SQL on DB2 tables to determine successful transaction of data from the application.
• Involved in Year End Processing Team.
• Involved in Documentation, Production Support and User Training.

Environment: PeopleSoft 7.5/8.3 (HR, Global Payroll, T&L, Salary Plan, Benefits) self-service.