Project Sales

Kishore

A PEOPLEOSOFT CERTITFIED PEOPLETOOLS

*************@*****.***

Mobile No: 480-***-****

Objective

To achieve a responsible and challenging position utilizing my past experiences on ERP.

Professional Summary

Kishore Yerraguntla has over 15 years on Development and on testing on ERP applications of experience in diversified fields of Application Software Development, Implementation projects and Client Server environment.

Techno- Functional Knowledge on PS- HCM (Core-HR, Payroll, Absence Management and Benefits), PS-CRM (Help Desk Module), ERMS, PeopleSoft Portals, PS-FSCM (Accounts Payable & Asset Management), PS –EPM (Budgeting and Forecasting and Scorecard Modules).

Complete functional knowledge on PeopleSoft CRM & expertise on any kind of issues.

Involved in estimation methodologies & allocation techniques.

Involved in designing the CTQ’s for each projects

Functional Knowledge on SAP- HR components such as PA, PD, OM, Payroll and Benefits

Expertise on SQR enhancements & Application Engine process.

Expertise on Integration Broker in order to integrate data within the PeopleSoft.

Experience in defining test cases, developing and maintaining test scripts, analyzing errors, interaction with team members in troubleshooting.

Expertise in writing test plans, defining test cases, developing and maintaining test scripts, analyzing errors, interaction with team members in fixing the errors.

Ability to lead and interact with team members in fixing the errors.

Proficient in testing methods like Integration testing and User acceptance testing (UAT).

Supporting PeopleSoft application on any environment.

Able to Install PEOPLESOFT on any environment.

Knowledge on Workday CRM integrations

MDM data expertise

Designed the extracts from PS CRM to SFDC

He has worked on Windows-NT, 95, 98, Vista and Mainframe platforms. He is conversant with quality procedures while executing Projects.

Technical Details

Hardware

Pentium, 80 X86

Operating Systems

Win-95, 98, NT

Languages

C, C++, Java / J2EE

Databases

MS-SQL Server, MS-Access, Oracle (7.x, 8i)

GUI

Swings and AWT

Web Related

HTML, DHTML, JavaScript, Servlets/JSP and XML

People Soft Expertise

Development Tools

Application Designer, People Code, Application Engine, Tree Manager

Reporting Tools

SQR, PS/Query, Crystal Reports, PS/n Vision

Data Management Tools

Data Mover, Mass Change, Process Scheduler and Import Manager.

Administration Tools

Security Administrator, Object Security, People Tools Utilities

1. Project title:

PeopleSoft HRMS 8.9

Client

JDA Software, Scottsdale, AZ

Role

Functional Lead & SPOC for PSFT QA Team

Organization

JDA Software, Scottsdale, AZ

Client and Work Location

JDA Software, Scottsdale, AZ

Duration

1st,July’14 –till date

Environment’s

HRMS 8.9

As a functional Consultant, I have done the following:

Worked on PeopleSoft HCM Modules Core HR, Time and Labor and Absence Management

Benefits -Manage Automated Enrollment

Benefits -On-Demand Event Maintenance

Worked on all phases of a project development, testing, production support, etc.

Configured, Verified and validated the Payroll setup’s and configuration

Created business requirement document (BRD) and functional requirement document (FRD) for change requests.

Doing the System Study of existing HRM/HCM processes and integration to CRM

Mapping their requirement with functionality and capabilities of PeopleSoft HCM and finding the Gaps.

Assisting our technical team on customization of PeopleSoft AND/OR integration of PeopleSoft HCM with our in-house developed HRMS products.

Perform thorough unit testing on all updates

Support QA team during testing cycles

2. Project title:

PeopleSoft HRMS 8.9,

CRM 8.9 Helpdesk Module implementation and support & maintenance,

ERMS(Email Response Management Systems),CRM integrations with FMS and Building the Customer Portal

Client

JDA Software, Scottsdale, AZ

Role

Project Manager/BA/SPOC

Organization

JDA Software, Scottsdale, AZ

Client and Work Location

JDA Software, Scottsdale, AZ

Duration

1st,July’09 –30th,May ‘14

Environment’s

HRMS 8.8 & CRM 8.9

Project Details: JDA’s sales and marketing solution is being supported by Salesforce.com, a non–Peoplesoft based application. Whereas Peoplesoft based CRM solution caters to customer support worldwide.

1.JDAUser.com - is internet Peoplesoft CRM portal meant for JDA’s end customer.

2.CSS Portal - This is internet Peoplesoft CRM portal only meant for JDA employees especially CSS (Customer Support Solution) team. This internet version of JPower is placed out of JDA’s firewall.

3.Extensively worked on People Code and Workflow and developed new processes (EL, HPL).

4. Interacted with the functional people for requirements and changes. Imparted training to end-users, process owners.

5. Involved in the customizing and developing PeopleSoft objects like records, pages and Components.

6.ERMS implementation for JDA

7.Environment Module implementation for JDA

Following are major business process involved in the application:

1.Maintain Employee data

2.Maintain Customer Data

3.Maintain Customer contract, agreements

4.Maintain Installed Products & Integration of Products with i2

5.Maintain Workforce & Integration of i2 workforce

6.Customer contact management

Worked on Couple of Project Management activities:

7.Agrees and delegates project activity

8.Checks, measures and reviews project progress and associated staff performance

9.Communication and people management; project management facilitates the need for clear communication in relation to required goals, responsibility, performance, expectations and feedback

10.Estimations and allocation of ad-hoc tasks to different stake holders

3. Project title:

PeopleSoft HRMS.8 support,

CRM 9.0 Upgrade – Helpdesk Module implementation and support

Client

Countrywide,USA

Role

Project Lead/Offshore Coordinator

Organization

BA Continuum India

Client and Work Location

BA Continuum India

Duration

Dec’06 – 30th,June’09

Environment’s

HRMS 8.8 & CRM 9.0

Project Details:

Acting as a techno functional consultant for HRMS 8.8 & CRM 9.0 to give the role based access and to identify the delivered vanilla. Changed the functionality on SSN number formats and implemented the feauture of integration with HRMS and also worked on customizations on CRM 9.0 upgrade.

Acting as a final Approver for all Objects which are moving to Production of HRMS 8.8 & CRM 9.0.It involves all objects whichever developers developed according to enhancements provided by customers or Business Analysts. Our team will work all kinds of objects (Interfaces, Reports and Process) to see whether it matches with requirements or not.

HRMS Support Outline

Core HR Support

Base Benefits -Set up and maintain benefit plans and benefit programs

Enroll employees into benefit plans

Define Automated Benefits

Changes in Payroll Interfaces

Integration of CRM and HRMS module

CRM Support Outline

CRM Enterpise Portal Knowledge – Setting configuration & publishing of pagelets

Implementation of several Change Requests(Folder Roles Permission Report_

Roles and Responsibilities:

* Assigning and allocating tasks and doing the peer reviews.

* Responsible for delivery of the projects from offshore with all the environments.

* Prepare documents to understand the business needs and peer needs.

* Capacity Plans and Estimation Methodologies

* Reviewing and Creates, documents, executes, tracks, analyzes, test plans, test scripts and test cases.

* Participates in Q.A. reviews and validation of requirements and specification documents.

4. Project title:

PeopleSoft HRMS Production Support for ANSWERTHINK

Client

Answerthink,USA

Role

Senior Consultant – Project lead

Organization

Answerthink India, Hyderabad

Client and Work Location

www.answerthink.com

Hyderabad

Duration

Apr’06-20th,Dec’06

Environment

MVS,DB2, Windows, Citrix(Remote Access),People Tools 8.42,Peoplesoft HRMS 8.8,STAT for migration to different Environments

Project Details:

* Identifies, analyzes and documents defects, questionable functions, errors and inconsistencies in software program functions, outputs, online screens, content and security.

* Works closely with the User Documentation team in the preparation of customer documentation for tested applications.

* Facilitates meetings, conference calls and provides and/or coordinates training for customers.

* Giving the training on PeopleSoft SQR, Application Engine Programs and People tools

* Debugging SQR and working on enhancements on SQR and Interface changes using Application Engine programs

* Assigning and allocating tasks and doing the peer reviews.

* Expert in creation of several interfaces using SQR’s, Application Engine & Query tool.

5. Project title:

Implementation of Custom e-Merit Module for TARGET on PEOPLESOFT EPM

Client

Retail Groceries

Role

PeopleSoft HR Developer – Team lead

Organization

Infosys Technologies, Hyderabad

Client and Work Location

Retail Groceries, USA, INFOSYS Hyderabad

(www.ttsi.target.com)

Duration

Oct’05-Mar’06

Environment

MVS,DB2, Windows, Citrix(Remote Access),People Tools 8.42,Peoplesoft HRMS 8.8,STAT for migration to different Environments

Project Details:

On an annual basis Total Compensation requires a system that will facilitate the merit process from beginning to end. They will need the system to be configurable by setting up different schedules that will include different groups of people.

The schedules and the groups of people attached to the schedules would be completely configurable by the user allowing them to apply different time frames and business rules to different groups of people for processing. They will be able to apply different merit matrices that are configurable to the different schedules.

The following programmes are defined: Global Configuration,Define Performance Score Model, Define Merit Matrices, Create Queries for Users and Schedules,Define PeopleSoft Groups for Schedules,Execute PeopleSoft Group Build Process For Schedules,Define Merit Schedules (Attach Groups to Schedules), Assign Security Roles for Worksheet Owners,Execute Group Definition Process, Adjust Group Definitions,Execute the PS Group Build Process for Worksheets, Audit Groups & tested the reports as well as process

The Reviewer Level summary report will be used to prepare a Summary report for Reviewers. The report will only analyse reviewers on one worksheet, and would not perform a roll up of various levels of Worksheet.

The Leave of Absence report will be used as an audit by Total Compensation to make sure that people who are on LOA or have had certain Disciplinary/Corrective Actions are being treated appropriately. This report will be divided into two sections, the first section will list all of those people that are on leave of absence at the time of merit and the second section will show anyone,that is on corrective action at the time of merit

The Merit Increase Extract File Process is an Application Engine batch program that will be used to generate an extract file containing the review score and the pay increase that is a result of the merit process. The output file would be an input to a MAX process, which will insert a corresponding row in the JOB table and the EMPLOYEE_REVIEW table.

Role:

Developed new interfaces using application engine.

Identifying the Reports for testing and comparing with Legacy Systems.

Preparing the specifications for test scripts and planning the testing process.

Primarily responsible for generating scripts that covers some of the key business functions.

Prepared test plan specification

Prepared matrix report and testing of the system.

Bug reporting was done at the end of every release

6. Project title:

PeopleSoft production support and Developing of new Customizations peoplesoft HR for KPMG

Client

KPMG,UK

Role

PeopleSoft HR Developer

Organization

IBM Global Services, Bangalore

Client and Work Location

KPMG, Watford, UK

Duration

Nov’04-Aug’05

Environment

Dynix 4.4.6 (Unix system V Release 4.0) (Server),Bourne Shell (Server),$Universe 5(Server),Oracle 8i (Server),Peoplesoft 7.5(Server),PeopleTools 7.63 (client),SQR 4.3.2 (Server and Client),Crystal Reports 6 ( Server and Client),Windows XP SP1(Client) – testing SP2

Project Details:

PeopleSoft HR is an application for KPMG ICT. It Administers, Develops and Maintains the information of KPMG staff which is useful for KPMG HR.

Setting up KPMG Administer Workforce Business Process describes the Set up codes to use in Personnel Administration tasks and to maintain employee data. Hiring KPMG Workforce reviews the steps involved in hiring new employees. Entering Additional Worker Information describes additional information you can track for employees, including emergency contact data, prior work experience, absences and benefits. PeopleSoft HR Intergrates with other systems for DataTransfer. This Integration with other Systems will happen by means of Interfaces. There are many Inbound and Outbound Interfaces defined for this processes.

These Interfaces will be initiated by the Unix Shell Scripts defined for each Job and are scheduled via $Universe System.

PeopleSoft HRMS is utilized to process Human Resources/Benefits/Payroll/Training information.

Developed several interfaces

1) Active Directory interface

• Description: Produce extract of current employee changes.

• Shell Script: hr75_kg_inthrad.sh

• SQR Program: inthrad.sqr

• Run Frequency: Weekly

• Output Format: CSV

• Criteria: Current employee

• Destination: Active Directory (accessed by KICS and Smart force systems)

• Type: Snapshot

• Tables Used: PS_KG_ACT_DIR_CNTL, PS_KG_ACT_DIR_NEW, PS_KG_CUR_RPT_TBL, XLATTABLE XLDD

2) ADP Payroll

• Description: To an interface between KPMG’s PeopleSoft HR system and ADP.

• Tables: The following new tables are required to hold this snapshot information:

• PS_KG_PPA_CURR_NEW,PS_KG_PPA_CURR_OLD,PS_KG_PPA_JOB_NEW,PS_KG_PPA_JOB_OLD

• In addition the following control records will need to be created.

• PS_KG_PPA_ACTIVE,PS_KG_PPA_CNTL.

• Shell Script Name: Hr75_kg_inthrppa.sh

• Frequency: Daily

• Criteria: Extract the current employee payroll details for interface into the ADP PayPower Adv@ntage payroll system.

7. Project title:

Implementation of Payroll for Cargill Home Foods

Client

Cargill lnc.MN,USA

Role

Developer

Organization

IBM Global Services, Bangalore

Duration

May’04-Sept’04

Environment

PeopleSoft HRMS 8.80.000,PEOPLETOOLS 8.44.06

Project Details:

Building several interfaces on Payroll using Application Engine

Smith Barney/AST Interface (ID:#127): Smith Barney is Cargill’s partner is stock administration. They work with the communications and are the first point of contact for employees when they wish to exercise their options. In order to fulfill their obligations, Smith Barney needs basic employee data from both the US and International employees. This interface will only provide the US and Canadian employees (BiT provides data on the rest of the world). Since they are also consulting on exercises they need up to date information on employee tax information

8. Project title:

PEOPLESOFT Development & Integration of data within the peoplesoft modules Application Messaging for HRMS8.81,FSCM8.41,CRM8.81

Client

PEOPLESOFT INC, CA, USA

Role

PEOPLESOFT TESTER

Organization

Hexaware Technologies, Bangalore

Duration

Jan’04-Apr’04

Environment

People Soft HRMS 8.81 PEOPLETOOLS 8.44

Project Details:

Here the Project Involves creating of new Messages, Message Channels, creation of new transactions, configuration of local Gateways as well as remote gateways.

By Using EIP ShellExcell tool we can publish data from source HRMS 881 to different targets defined in the client’s requirement document.

People Soft has developed a tool PS Script Enterprises that is used to test the People Soft 8.8 HRMS application. The individual scripts pertaining to each module are developed in the basic form. These scripts have to be customized and debugged to suit to the existing application

Role:

Involved in designing system test cases for the entire Soft Cart.

Involved in System Testing, Performance Testing the entire application.

Performed Functionality Testing, Regression Testing and System Testing.

9. Project title:

PEOPLESOFT SYSTEM FOR SATYAM GE-GDC HR MODULE

Client

GE-GDC

Role

Technical Consultant(Contractor)

Organization

Satyam Computer Services Ltd.

Duration

Jan’02-June’03

Environment

People Soft HRMS

Project Details:

At this client the initial responsibilities included design, development and Implementation of People Soft reporting system for HR module. Designed and implemented SQR'S to create new hiring requisitions for seasonal associates across all divisions based on individual customer specifications. Modified People Code to accommodate new design for employee ID assignment.

-Designed and implemented inbound and outbound feed SQR’S between People Soft Job Requisition and divisional interfaces. Worked on Application Engine for Providing security.

Analysis of the specifications provided by the clients

This system provides ability to the users to select the report and define criteria, sort order summarization and page breaks just before running the report. Developed and modified SQR reports and gave user support. Responsible for solving test problem reports related to divisional software installation and conversion issues.

10. Project Title

PEOPLESOFT SYSTEM FOR MADI’S HR MODULE AND FINANCIAL MODULES

Client

Madi International DUBAI, UAE

Role

People soft Technical Consultant

Organization

Master.com Software Ltd., Hyderabad

Duration

December 2000-March 2002

Environment

People Soft HRMS 7.5, People Tools 7.07, People Code, Oracle 8i,Crystal Reports 6.0/7.0, SQR 3.1/4.0.

Project Details:

At this client the initial responsibilities included design, development and Implementation of People Soft reporting system for HR module and Financial Modules. Later Transitioned into team lead of three consultants and assisted them in constructing the reports. Conducted interviews with client personal to collect the reporting requirements. Developed interfaces to General Ledger And involved in the chart-field customizations.

Addition and modification of records, panels, menus, etc. utilizing PeopleSoft's Application Designer and People Code. Design and coding of SQR’S to accomplish periodic database updates and correct data errors. Design and coding of SQR’S to perform People Soft Leave Accrual processes, 401K and bank interfaces, and GL interfaces.

Developed a customized online People Soft reporting system using People Code. This system provides ability to the users to select the report and define criteria, sort order summarization and page breaks just before running the report. Developed a customized General Ledger and Account Receivables Module for Customization. Developed and modified SQR reports and gave user support.

11. Project Name

Designing of Multi-theaded Server

Client

RGP-JavaLineTechnologies, HYDERABAD

Role

Team Member

Organization

Master.Com Software Ltd., Hyderabad

Duration

April 1999-August 1999

Environment

Core JAVA and Networking Concepts

Project Details:

The rapid growth of Internet has greatly influenced the importance of Network Programming. This Project consists of three modules. The first Module compares the performance of an Application using TCP against UDP. The Second module comprises the working of SMTP and HTTP webserver. The third Module involves the implementation of multithreaded Server. Each thread renders services to each client as well as with the server. The communication is through thread interaction. Developed Java Application and Applets using JDK. HTML was used for Intranet application and java-script for client side validations. As a team member, responsible for Analysis of the specifications provided by the clients

Responsible for overseeing the Quality procedures related to the project.

12. Project title:

SALES FORECASTING SYSTEM

Client

Dolphin Inc.Solutions, TX

Role

Team Member

Organization

Master.com Software Limited, Hyderabad

Duration

Oct’1999-September 2000

Environment

JSP, HTML, Java Script, Servlets, JRUN3.00.3694

Project Details:

Forecasting Management System provides accurate, timely forecasts of revenue and customer demand, enabling managers and executives to help the sales organization close more deals, bring higher profits to the company, and align expenses with revenue growth. Forecasting Management also gives the rest of your company and your supply chain partner's visibility into future product and service demand levels. Sales professionals can use forecasting to generate extremely accurate forecasts. Executives can track forecasts at any organizational level including an individual representative

Real-Time Forecasts Leverage the real-time transparency of your sales pipeline and generate extremely accurate forecasts, giving everyone in your organization including field sales, manufacturing, purchasing, and corporate executives a clear, reliable understanding of near-term future events so they can focus their resources accordingly. Customizable Forecasts Use any forecasting methodology you choose and view sales data by timeline, manager, territory, individual sales rep, and more. Roll up sales information across unlimited levels of sales regions, and use subjective insight to adjust it as it rolls up the management chain. Data Export easily export reports to Microsoft Excel™ for further manipulation and analysis Benefits: Forecast revenue accurately. Identify trouble spots early and use historical trends to better predict future patterns. Manage and mentor your sales reps. Reduce administration time and effort.

Contact this candidate