Monday, September 1, 2008

Sohan Peoplesoft Techno-Functional Profile





HRD – Recruitment,

Dear Madam / Sir,

I am looking for a Techno-Functional / Technical or Functional position in the domain of HCM preferably with ERP touch (Peoplesoft solutions). I believe it will offer me exciting opportunities & a dynamic environment for symbiotic growth.

I bring with me 3+ year of experience in an ERP life cycle Implementation activities.

I believe my education and rich experience leave me in good stead to be a valuable part of your esteemed organization.

Looking forward to a favorable response

Warm regards


Sohan Asgaonkar
Contact no.: +919890825336, +919011838089
sohan251@gmail.com, sohan251@yahoo.com


Bringing onboard


 3+ year of work experience in IT arena.
 Around 1+ year of 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 NT\XP\2K3
Software tools Peoplesoft Application Designer, People Tools, PS Query, VB 6.0, Front Page 2000
Databases MS SQL, Oracle10g, MS Access

Peoplesoft Technical Experience (HRMS) :

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


Peoplesoft Functional Experience (Peopletools)


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.

Professional experience

#1

Project name - Data Migration & PS Implementation
Skills used
App. Designer, Peoplecode, App. Engine, CI, SQR, PIA
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, PIA
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.


Personal details

Name Sohan Asgaonkar
D.O.B 25th Jan 1985
Status single
Contact +919890825336, +919011838089
Email sohan251@gmail.com
Passport details No. G5729488 Issued at Panaji - Goa
Date of issue – 26/11/2007
Date of expiry – 25/11/2017


Reference

Mr Amit Shirodkar
Project Engineer,
Wipro, Bangalore
amit.shirodkar@wipro.com,
Mobile : +919886774196