PROFESSIONAL SUMMARY:

• Peoplesoft HRMS Technical resource with extensive in system analysis, design, development, testing and implementation of ERP applications.
• Experience in customization, implementation, and upgrades of PeopleSoft HRMS/HCM 8.9/9.0/9.1/9.2 , including Human Resource, Talent acquisition Manager, Candidate gateway, Base Benefits & Employee self Service.
• Experienced in design of technical/functional specification based on the end user interaction.
• Being a Consultant expert in dealing with HRMS, explains them the pros & cons of developing projects & provides innovative and alternate solutions for their requirements.
• Expertise in Peoplecode, Application Engine, SQR, Application package, Integration Broker. Has also worked on Web Services.
• Proficient in performing fit gap analysis, design, Interfacing, conversion and report writing using People tools, People code, application Engine & SQR.
• Experience in full life cycle implementation for Global deployment.
• Possess good understanding about Roles, Permission List and PeopleSoft Row Level security.
• Strong functional expertise in Human Resources, Employee self - service, Base benefits.
• Solid experience in complex reporting using SQR, PS/Query.
• Expertise in Designing Functional & Technical Specifications as Per CMM Level 5 & 6-sigma Standards. Experienced with TFS ( Team Foundation Server )
• Commendable experience in Data Conversion, Migration, Import and Upgrade involving the tools like People Tools, SQL,SQR, AE programs, Component Interfaces, Data Mover and Import Manager.
• Expertise in developing interfaces to Taleo Applications.
• Experienced in Unit testing and Integration Testing of Peoplesoft objects and work products.
• Expertise in developing Oracle PL/SQL, SQL stored procedures.
• Worked on Web application tool Oracle Application Express tool (APEX)

TECHNICAL SKILLS:

PeopleSoft ERP: PeopleSoft 8.9/9.X HCM (Workforce Admin, Talent acquisition Manager, Candidate Gateway, Base Benefits, Employee self-service)

People Tools: (Version 8.5x)Application Designer, Application Engine, Component Interface, Workflow, Application Messaging, File Layout, Query Manager, Change Assistant, Data Mover, Configuration Manager, Process Scheduler, Web services

Programming Languages: People code, SQL, PL/SQL, Sql Server, SSIS

Reporting Tools: SQL, SQR, Toad

Data Bases: Oracle 9i/10g, 11g, SQL Server

Operating Systems: UNIX, Windows NT/2000/XP.

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

PeopleSoft Techno Functional Consultant

Responsibilities:

• Implemented Talent acquisition Manager and Candidate Gateway Module.
• Customized delivered component as per requirements.
• Created workflows for the automated processing.
• Developed interface to load the applicant data with no job openings from legacy system to PeopleSoft System.
• Created technical and functional specification documents.
• Created training material documents for new modules implemented.
• Guided the users in UAT in testing interfaces and reports
• Participated in user acceptance meetings to guide the users.

Environment: ERP: PeopleSoft HCM (TAM and CG) 9.2Languages/Tools: SQL, People Tools 8.53, People Code, Application Engine, Application packages, Component Interface

Confidential, Secaucus, NJ

PeopleSoft Techno Functional Consultant

Responsibilities:

• Developed SSIS scripts to import data from different database.
• Involved in change requests for database fixes which included writing complex sql scripts. Have fundamental knowledge on sql joins pl/sql.
• Used File Layouts to import/export data in/out of PeopleSoft system using App Engine
• Created technical specification for reports/interfaces
• Used Application Engine /SQR interfaces/reports to send Payroll information to vendors
• Created application engine programs for outbound/inbound interfaces
• Created online pages/components/People Code validations for dynamic data interface bolt on application.
• Developed component Interface for Taleo information load through application engine.
• Created component interfaces to load data in to additional country feeds.
• Prepared and tested ExceltoCI to load data in to PeopleSoft through component interfaces
• Guided the users in UAT in testing interfaces and reports
• Build online pages and components to store setup data for bolt on applications.
• Performed data conversions and security setups as needed for each country deployment.
• Participated in user acceptance meetings to guide the users.
• Developed interfaces to convert data from legacy systems to PeopleSoft as part of conversion project.

Environment: ERP: PeopleSoft HCM (HR, Payroll, Workforce Admin, Employee Self-service, Base Benefits) 9.1

Confidential

PeopleSoft Technical Consultant

Responsibilities:

• Created fields, records, pages and components using Application Designer.
• Created new test cases and Technical design documents according to the BRD.
• Used people code to implement the business logic according to requirement.
• Created new application Engine programs using the File Layout concept to import the data from the Flat files to PeopleSoft database
• Provide production support on critical interface issues.
• Run Periodic security jobs and run portal security Sync when required.