Summary:

• Over 7 years of IT experience in system analysis, design, development, testing and implementation of ERP applications.
• Completed Oracle PeopleSoft Developer I: PeopleTools PeopleCode 1Z0 - 241 Certification in April 2011.
• Experience in customization, implementation, and upgrades of PeopleSoft HRMS/HCM, including Human Resource, 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. Has also worked on Web Services and Integration Broker.
• 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.
• 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.
• Experienced in the SSIS package for cross platform integration also worked on sql server.
• Experienced in using version control tools TFS Team Foundation server .
• Experienced in using Remedy tools Service Now.
• Motivated, hardworking individual with excellent communication skills.
• Utilizing the APP Designer tool, researched the Field, Page or Record layout to expedite the development team's resolution to functional issues.
• Produced many ad-hoc reports using PL/SQL, SQL and PS Query to verify data within the system data tables.
• Worked on Web application tool Oracle Application Express tool APEX

Technical Skills:

• PeopleSoft ERP : PS HRMS 9.2 / 9.1 / 9.0 / 8.x - HR, Workforce Admin, Base Benefits, Employee self-service and Manager self service
• People Tools : People Tools 8.5x / 8.4x- Application Designer, Application Engine, Component Interface, Application Messaging, File Layout, Query Manager, Change Assistant, Data Mover, Configuration Manager, Process Scheduler, Web services
• Programming Languages: People code, SQL, PL/SQL, SqlServer, SSIS
• Reporting Tools : XML Publisher, SQR, Toad
• Data Bases : Oracle 9i/10g, 11g, SQL Server
• Operating Systems : UNIX, Windows NT/2000/XP.

Work Experience:

Confidential

PeopleSoft Techno Functional Consultant

Environment:

• ERP : PeopleSoft HCM HR, Employee self-service and Base Benefits 8.9
• Languages/Tools : SQR, SQL, People Tools 8.51, People Code, Application
• Engine, Application packages, web services and Integration Broker.
• Database : Oracle 11g

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
• Create technical specification for reports/interfaces
• Application Engine /SQR interfaces/reports to send Payroll information to vendors
• Create application engine programs for outbound/inbound interfaces
• Create online pages/components/People Code validations for dynamic data interface bolt on application.
• Component Interface for Taleo information load through application engine.
• Create component interfaces to load data in to additional country feeds.
• Prepare and test ExceltoCI to load data in to PeopleSoft through component interfaces
• Guide the users in UAT in testing interfaces and reports
• Developed web services to update the data feed from third party applications using integration broker.
• Build online pages and components to store setup data for bolt on applications.
• Perform migrations and security setups as needed for each country deployment.
• Participated in user acceptance meetings to guide the users.
• Develop interfaces to convert data from legacy systems to PeopleSoft as part of conversion project.

Confidential

PeopleSoft Techno Functional Consultant

Environment:

• ERP : PeopleSoft HCM HR, NA Payroll, Employee self-service and Base Benefits 9.0/9.1
• Languages/Tools : SQR, SQL, People Tools 8.51, People Code, Application
• Engine, Application packages.
• Database : Oracle 11g

Responsibilities:

• Prepared Technical design documents based on the functional design.
• Prepared technical specification from functional specification and Fit- Gap analysis for Retro-Fitting.
• Retro-Fitting of customized Fields, Records, Pages, and Components
• Retro-Fitting of Application Engine and SQR programs.
• Prepared Test Cases and Test Results for business process, AE and SQR programs.
• Performed Unit Testing, System Integration Testing for PeopleSoft objects, and SQR programs.
• Prepared Technical Design Documents for the SQR's