sohan251

Bringing onboard § 2.10 years of work experience in IT arena. § Experience as a Peoplesoft Techno-Functional in application implementation, customization, conversion and support activities. § Good skills in Peoplesoft Development and Administration. § Functional knowledge on HRMS 9.0, Global Payroll, Base Benefits, Absence Management. § Developed Interfaces, SQR, Customized Peoplesoft Application in HRMS. § Have a strong background in People Tools, People Code, Application Engine Programs, Interfaces and SQR. § Having expertise on database like oracle 10g with SQL, PLSQL and XML. § A good team player with ability to work in a team or individual. § Have the basic idea of normal Lifecycle of an ERP Implementation. § Involved in writing customized Application Engine Programs by using Peoplecode, extraction of data from database and populating in to Peoplesoft system. § Was involved in Data Migration activity carried out to migrate the enterprise client data to Peoplesoft application. § Have the basic idea of XML, PHP. Education § Bachelor of Engineering, RIT, Shiroda, Goa - Major: Information Technology With 64% (2003 – 2007). Technical skill profile Programming languages Peoplecode, SQR, VB 6.0, Java Script, Html Peoplesoft concepts Application Engine, Component Interface, PIA, Security, Process Scheduler, PS Query, File Layout, Workflow Operating systems Windows 95, 98, Windows NTXP2K3 Software tools Peoplesoft Application Designer, People Tools, PS Query, VB 6.0, Front Page 2000 Databases MS SQL, Oracle10g, MS Access Peoplesoft Functional Experience (HRMS) Core HRMS HRMS Products & Business Process Categories HR foundation table Setup Sequence & assigning Organizational Relationship i.e. Adding a Person, Adding the relationship. Payroll Global Payroll Organization framework & Processing framework. Familier with Primary, Supporting Elements, Element Group, Eligibility Group, Pay Group, Payee, Pay Entity, Also Process List, Section and Elements. Establishing payee data, running the Global Payroll Process, Viewing Payroll result. Setting up Trigger, Offcyle, Retro Activity. Base Benefits Base Benefits process phases – setting up of Benefit plan, then assigning it to benefit program and then to assigning Employees, finally calculating Benefit related deduction. Base Benefit core tables, Benefits Plans, Benefit Program Dependent & beneficiary Information, Enrolling participants, saving plans, FMLA plans, Leave Plans, COBRA. Absence Management Creating Organizational, Processing & calendar Frameworks, Building rules for tracking absences and accrued time off, creating & assigning work schedules, Entering absences & forecast entitlement balances, sending absence data to your payroll system. Describing self service absence functionality. Peoplesoft Technical Experience (Peopletools) Admin and Installation Peoplesoft Architecture and Installation. Admin activity of configuring Oracle, BEA Weblogic, Tuxedo, Peopletool and Peoplesoft Applications. Running SQL scripts for Tablespace, Datafiles and Datamover script. Creating Permission list, Role and User profile. Running AE & SQR report using process scheduler. Application Designing Creating fields, records, pages, components, menus. Building records, Registering and Assigning Permission List to menu. Maintaining keys, Translate tables & Prompt tables – Dynamic prompt etc. Effective dating concept for history, current and future data. Subrecord, Secondary Pages, Subpages, Scroll area, Grid level. SQL views, Dynamic views for displaying joined record. Peoplecode Peoplecode for specific event type and their flow in add & update mode. Validation with Peoplecode -traversing, auto increment, SQLexec Writing Peoplecode for Data Migration in AE. Using File Layout in Peoplecode. Application Engine Application Engine with State table, Temporary table & Actions. Creating AE programs using Peoplecode, SQL. File Layout - flat file with CSV file format to target table. Runcontrol utility to run AE Component Interface Synchronous access to Peoplesoft component with Component Interface. Excel to CI utility to load data from Excel into Peoplesoft database. SQR Developing & customizing SQR reports, developing interface reports using SQR to read the data from files & load it into Peoplesoft tables & send data from Peoplesoft to other interfaces. Runcontrol utility to run SQR Professional experience #1 Project name Data Migration & PS Implementation Skills used App. Designer, Peoplecode, App. Engine, CI, SQR Technolgies Peoplesoft 8.48 & HCM V.9, Oracle Database 10g Description • This project involves the implementation and customization of different modules. • It involves two main stages viz importing the PeopleSoft data into flat files for Outbound Programs and the vice versa for Inbound Programs. To achieve this, an intermediately data structure file layout is used. • Also it consists of data uploading from legacy system in to Peoplesoft database using component interface API classes. Role Team Member Responsibilities • Understanding technical specification document for data migration implementation. • Customizing and designing fields, records, pages, components and menus for the requirements. • Was involved in HCM data migration activity carried out to migrate the enterprise client data to Peoplesoft database. • Involved in writing customized application engine program by using Peoplecode, extraction of data from database and populating in to Peoplesoft system. • Running batch process by using temporary table and migrating Peoplesoft data. PS Implementation – Absence Management Module • Involved in defining Absence Entitlement, Absence Take and Supporting Elements (Duration, Formula, Bracket etc) • Also defined elements involved in organizational, Processing and Calendar framework. • Involved in maintaining Entitlements with respect to Generation Control, Special Leave, Sick Leave, Study Leave etc. • Forecasting the Entitlements before calculating. • Running Retro and Offcycle activity. #2 Project name Peoplesoft HR – Administer Training Skills used App. Designer, Peoplecode, App. Engine, CI, SQR Technolgies Peoplesoft 8.48 & HCM V.9, Oracle Database 10g, isqlplus. Description • This project involves the implementation and customization of the Enterprise Learning module as per requirement for the different centers of organization across the globe. The customizations include change in the page layout, writing application engine program, writing reports. • The project consist of online student enrollment to the training assigning instructor, prepare classroom, deliver course, evaluation etc. • Data model for student customer, instructor course session, training location, training material were made. Role Team Member Responsibilities • Involved in understanding functional design specification for training application like table relationship, functional design and so on. • Also involved in understanding technical specification like definition specification, security and navigation. • Created application engine program for loading data from flat file to target table. • Running batch process by using temporary table and migrating Peoplesoft data. • Loading data from excel to CI. • Involved in writing SQRs for creating reports. Academic Projects #3 Ballast Water Reporting Software in National Institude Of Oceanography (NIO)(2006-07) Skills used - Php, Phpmyadmin, MySQL, Apache #4 Shopping Mall in Shri Rayeshwar Institude Of Engi. and Info. Tech (RIT) (2006) Skills used - VB, MSSQL Training(s) attended § Oracle training, Peoplesoft Peopletools and Peoplesoft Functional training organized by iWarelogic, Pune. Hobbies/interests Riding bikes, playing cricket, adventurous sports, reading, Listening to music. Passport details No. G5729488 Issued at Panaji - Goa Date of issue – 26/11/2007 Date of expiry – 25/11/2017