Oracle Project

Resume *****

This resume is listed on

oracle hrms functional consultant

Oracle apps hrms functional, sql,plsql,d2k(forms, Reports)

Desired Positions

Technical Consultant

Work Preferences

Desired Salary

Negotiable per year

Availability

2 Weeks

Desired Job Type

Full Time

Can Travel for Work

Extensively

Highest Education Level

Bachelor Degree

Current Location

Karnataka-Bangalore, India

Relocation

Will Consider Relocation to;

National

Andhra Pradesh-Hyderabad

International

United States

Residency / Visa

Authorized to work in this location

Skills and Experience

Category

Yrs. Exp.

Last Used

Oracle Development Tools

Oracle Developer Suite

Oracle Forms

1

2008

Oracle Reports

1

2008

Oracle E-Business Suite

Self-Service Human Resources

B.Tech with computer science having 3.8years of experience in oracle hrms functional consultant

Industry

Computing - Software

04/2009 to Current

Hello,

This is mohan, working as a oracle hrms functional consultant having 3.8years of experience. Among this i work for oracle manufacturing developer as a technical consultant around 1.8years and presently working as functional consultant for oracle apps hrms around 2.5years of experience.

ORACLE APPS HRMS CONSULTANT

Name: - Mohan Rao. B Email: - ***************@*****.***

Mobile No: +91-810*******

Objective

I aspire to work in a global, professional environment utilizing my skills/experience to the best, there by taking up higher roles and contribute to the development of the organization.

Summary:

3.7+years of experience in IT industry out of which 2.5+ years with oracle Apps HRMS Functional implementation and 1+years in Oracle developer 2000. I have gained expertise and expose in HRMS functional.

HRMS FUNCTIONAL AND TECHNICAL Expertise:

Involved in three implementations of Oracle Applications 11i projects, with hands-on working experience on various Components.

Having good Functional knowledge in HRMS (CORE HR, PAYROLL, SSHR, OLM, and OTM).

As a Technical Consultant, extensively worked on Oracle Applications modules like PO, OM, AP and AR.

Hands on Experience P2P (Procure to Pay) Cycle, O2C (Order to Cash) and multi org

Having Experience on XML Publisher, Discover Reports.

Having experience on Form Personalization & CUSTOM.PLL

Creation and registration of Reports, Menus, Functions, Value Sets, Concurrent programs.

Hands-on experience of working on numerous oracle tools including Oracle Reports 6i, TOAD, SQL * LOADER.

An enthusiastic and project-oriented team player with sound communication, leadership, and problem solving skills to develop creative solution for challenging and customer needs.

Qualification:

B.TECH (Computer Science), Affiliated to JNTU university, Hyderabad in the year 2005.

Work Experience

Working as a Functional Consultant for Accenture, Bangalore from Mar-09 to till date.

Worked as a Functional Consultant for Exult InfoTech LTD, Hyderabad from Jun-08 to Feb-09.

Worked as a Software Engineer for KPIT CUMMINS INFO SYSTEMS LTD, PUNE from FEB-06 toApr-08.

Technical Skills:

Programming Language

PL/SQL,C, JAVA

Interface Language

SQL

GUI Package

Developer 2000

Database

Oracle 8i,Oracle 9i

Environment

Windows, Unix

ERP

Oracle Application 11i,R12,Oracle HRMS functional(Core HR, Payroll, Time Management, Fast Formula)

Module

OM, PO,AP, AR, HRMS Functional

Web Interface

HTML

Tools and utilities

Xml publisher, Discoverer

Oracle Certified Association: -

Introduction to Oracle 9i:SQL

Oracle9i: Program with PL/SQL.

Training Summary:

Program or Course

Coverage

Organization

Oracle Apps Overview

Basic Overview about Oracle apps implementation Methodology, Market Shares etc

Kpit Cummins Info Systems

Oracle Apps Manufacturing

Basic Overview about all the Manufacturing Modules of Oracle apps

Kpit Cummins Info Systems

Oracle Apps HRMS

Core HR, Payroll, OLM, OTM, SSHR, I Recruitment

Kpit Cummins Info Systems

Professional Experience:

PROJECT#1

Organization - ACCENTURE

Client - Kent County Council, UK

ERP module - Oracle apps HRMS, (UK Localization)

Role - Functional Consultant

Environment - Oracle Applications 11.5.10

Project Description

Kent County Council (KCC) has focused investment on front-line services and built a fine reputation for the quality of its service delivery. For its back-office Finance and Personnel processes to be counted among the best in the UK, in the same way as its frontline services are, KCC has embarked on an ambitious programmer of change called Kent Support Services Improvement Programmer (KSSIP).

The aim of KSSIP is to improve substantially the services provided by KCC's Finance and Personnel functions, whilst reducing the cost of delivering the services. KSSIP team in Phase II, embarked on the project of Oracle Payroll Implementation for 15,000 employees. Currently, the payroll processing is outsourced and a third party is running the payroll on UNIPAY system. With this implementation payroll data would be completely integrated with the Oracle HR system. Phase I of the project involved implementation of Oracle HR and Oracle Financials.

My role in the project is as follows:

Development of as-Is and To-Be business Processes.

Mapping of the To-Be processes on to Oracle HRMS and identification of the Gap.

Preparation of solution Design for Oracle payroll.

Co-Ordinating the technical team members at the Onsite.

Responsible for HR and Payroll module implementation.

Reconfiguring HR setup to meet HR and Payroll requirements.

Preparation of solution Design for Oracle HR and Payroll Modules.

PROJECT#2

Client - Diebold Hungary Rollout, United States

Company - Exult Info Tech, Hyderabad

Role - Functional Consultant

Modules - Oracle HRMS

Environment - Oracle Applications 11.5.10

Description:

Diebold, Incorporated is a Global Leader in providing integrated Self-Service delivery systems, Security and Services. Diebold employs more than 14,000 associates with representation in nearly 90 countries worldwide and is Head quartered in North Canton, Ohio, USA. Diebold reported revenue of $2.4 billion in 2004 and is publicly traded on the New York Stock Exchange Under the symbol DBD.

My role as a functional Consultant involved as follows:

Validation Of the Descriptive Flex Fields

Updating the BR100 Docs

Testing the Standard Functionality of Core HRMS

Testing the MD50 s and MD70 s

Testing the Test Scripts

Coordinating the Team members at the Onsite

Reconfiguring HR setup to meet HR and Payroll requirements.

Preparation of solution Design for Oracle HR and Payroll Modules.

PROJECT#3

Project - EDI (Electronic Data Interchange)

Client - Cummins, Fridley (KPIT)

Role - Apps Technical Consultant

Modules - PO, OM, AR

Environment - Oracle Applications 11.5.10, Sql * Loader, Reports 6iDescription:

Commerce Hub is leading Industry of Supplying goods through online.

Commerce Hub is nothing but Costco.com (booking orders, selling goods and Invoicing) all are done on online only. Company is going in for a complete re-design of their processes spanning across Manufacturing and Customer Relationship Management.

Our current order entry process is more suited for commercial orders, rather then consumer goods. In order to compete within the consumer goods industry, orders must be processed within 24 hrs and shipped within 72 hrs. Orders also must be transmitted automatically from the customer s edi d document directly into our order processing system. These transactions must be uploaded into the order processing system a minimum of 4 times a day. Actually, impact will be quicker processing, more accurate reporting and quicker shipping and increased customer satisfaction. Automatic retrieval of customer orders received electronically (via a listener or sweep of the commerce hub) this should occur no less than 4 times per day. The ability to function with 850-860 edi codes effectively.

Responsibilities:

Coding in Pl/Sql Programming.

SQL*Loader control file to transfer data from flat files to Interface tables.

Report Development and Customization.

Worked with PL/SQL coding.

Registering the forms, reports and creation of value sets in oracle applications.

Used SQL*Loader programs to upload data from Flat Files to pre interface table and wrote PL/SQL procedures for all the business validations.

Involved in other activities like registration and creation of custom tables.

Reports:

WIP Report

Shipment Measurement

Order - Ship Confirmation

Promise Date Report

Promise Date Detail Report

Forms:

Attachment Database Form

Offer Form

SKU Cross Reference Form

Interfaces:

Inbound:-

850 - Purchase Order inbound interface.

860 Shipping Order inbound interface.

997 Acknowledgement for order received.

Outbound:-

855- Purchase order Acknowledgement (Outbound).

856- Advance Shipment Notice.

810 Invoices from Oracle will be sent out once a day for all the

Shipped Orders on the day.

PROJECT#4

Purchase Order Generating System

Client - APSARA Printing Inks, PUNE

Organization - KPIT CUMMINS INFO SYSTEMS, LTD.

Database - Oracle 9i

Tool - Oracle D2K(FORMS 6I, REPORTS 6I)

Description: This project has been designed to generate a purchase order for the required materials. Based on the purchase request, Request for Quotation (RFQ) is generated which is sent to the suppliers. The system maintains the price details of various products, which are sent by different suppliers, and it comprises all the information in different tables and it selects the supplier number who quotes the lower value. The purchase order is raised and is sent to the supplier. With the reference to the purchase order, the supplier supplies the materials.

My role in Project as follows:

Support in the back end design of the system.

Creating form modules to keep the information about the purchase order details.

Also created form module to keep the information about the purchase order details.

Reports were generated as per the user s requirements.

Created menu modules for the product customization.

Personal Details:-

Name : Mohan Rao B

Father s Name : Koteswara Rao B

Date of Birth : 14th October, 1983

Passport : Valid passport.

Languages Known : English, Telugu and Hindi

Declaration:

I hereby declare that the information furnished above is true to the best of my knowledge.

Place: Bangalore. (Mohan Rao .B)

Work Related Training & Certification

Completed

Institution

Training / Certification

2006

kpit cummins info systems

Training

Contact this candidate