Oracle Project

MUKESH KUMAR

Mobile: - 91-971*******

Email: - *.*********@*****.***

SUMMARY:

• Total 7.5 + Years of experience in teaching and training and IT Sector

• 6.5 + years of experience in the Information Technology industry

• Hands-on experience in Oracle Applications (R12,11i) as a Technical & Functional Consultant (AP, AR, GL, Oracle Purchasing, IProcurement, Order Management and Inventory) , Reports 6i, Form 6i, (Oracle 10G), Discoverer 4i Report (Discover 10G), XML Reports, Workflow, and PL/SQL ,AME and Functional Consultant (Oracle Purchasing and Inventory)

• Expertise in development and customization of report and forms as well as interface design

• Expertise in gathering the requirement, preparing functional documents (AIM), designing solution and doing functional setups to mapping business requirement.

• Experience in implementation, customization, and support of projects

• Technical and functional expertise well augmented by excellent analytical and problem solving skills, with the ability to interact with individuals at all levels

SKILLS:

• OPERATING SYSTEMS: Windows 9x/ 2000/ XP

• ERP: Oracle Application 12.x (Financials, GL, AP, AR, PO, OM, INV, iProcurement, AME)

• ERP: Oracle Application 11.x (Financials, GL, AP, AR, PO, OM, INV, iProcurement, AME)

• LANG/ TECH: SQL, PL/SQL, C, Java, JSP, Servlets, Swing, HTML

• DATABASES: Oracle 8i/ 9i/ 10g

• TOOLS: Oracle Reports, Oracle Discoverer Reports, Oracle Alerts, SQL*Loader, Developer/2000 6i/ 10g (Reports, Forms), JDBC, TOAD, Data Loader, XML Publisher, Workflow Builder

EXPERIENCE:

Torus Insurance

Oracle Application R12 (Oracle Financials) Support & Enhancement

Nov2011 – Present

• Working as a Senior System Analysts for Torus Insurance

• Working to resolve functional & technical issues.

• Gathering the requirement from business and preparing functional & technical document.

• Providing the support on AP, AR & GL interfaces.

• Helping business on month end closing.

• Making the changes in existing reports as per new requirement from business.

• Developing new reports & forms.

• Making the changes in existing interface logics.

• Preparing ticket tracker report & WSR presenting to business.

• Involving Quality audits & attending call from business spoc.

• New Operating unit setup.

• Period opening &closing.

• Defining more rates.

• Resolving issues reported in month end closing.

• Assigning values in value sets.

Tricore Solutions Inc.

Oracle Application R12 implementation

Jun 2011 – Nov 2011

• Worked as a Senior System Analysts.

• Worked on Oracle R12 Implementation project for Cumberland Farms Inc. USA

• Worked on Financial Module (AP,AR and GL)

• Worked on Property & Lease management module

• Worked on new custom form developments

• Worked interface & conversion programs

• Worked on xml report development

Fujitsu Consulting India Pvt. Ltd.

Oracle Application R12 implementation

Nov 2010 – May 2011

• Worked as a Senior Systems Executive with Oracle Egypt.

• Worked on Oracle R12 Implementation project for Midor (Onsite-Egypt)

• Worked on Oracle Purchasing, Inventory, payroll and HRMS

• Worked on Financial Module (AP,AR and GL,EAM)

• Done Supplier Conversion

• Done Customer Conversion

• Done AP Invoice Conversion

• Done AR Invoice Conversion

• Done Landed Cost Management Interface

• Done EAM (Enterprise Assets Management Interfaces )

• Done Fixed Assets Conversion

• Done Purchase Orders conversion

• Done Item Conversion

• On Hand Quantity Conversion

• Development of workflows as per their business process

• Development of New Custom reports and customization of existing reports

• Customization of oracle standard reports

Fujitsu Consulting India Pvt. Ltd.

Oracle Application R12 implementation

Mar 2010 – Oct 2010

• Worked as a Senior Systems Executive with Oracle Egypt..

• Worked on Oracle R12 Implementation project for Telecom Egypt (Onsite-Egypt)

• Worked on Oracle Purchasing and Inventory

• Worked on Financial Module (AP,AR and GL)

• Done Supplier Conversion

• Done AP Invoice Conversion

• Done Fixed Assets Conversion

• Done Purchase Orders conversion

• Done Item Conversion

• On Hand Quantity Conversion

• Development of Inbound and Outbound Interfaces

• Development of workflows as per their business process

• Developent of New Custom reports and customizatin of existing reports

• Customization of oracle standard reports

Fujitsu Consulting India Pvt. Ltd.

Oracle Application 11i implementation

May 2008 – Mar 2010

• Worked as a Senior Systems Executive.

• Worked on Oracle Implementation project for GES Exposition Services Inc. USA

• Worked on Oracle Purchasing

• Worked on Order Management

Worked on Account receivable and General Ledger

• Worked on AME and Internet Procurement

• Development of Inbound and Outbound Interfaces

• Development of workflows as per their business process

• Development of outbound interface to extract data from Oracle

• Developent of New Custom reports and customizatin of existing reports

• Customization of oracle standard reports

• Worked on performance tuning

• Used utl_file to extarct data from oracle and create data file on server

• Worked on Form personalization

• Worked on Custom.pll

• Worked on Forms

Wipro Limited

Oracle Application Enhancement and Support

October 2006 - May 2008

• Worked on Support and Customization project for Genpact Global Services Pvt. Ltd

• Worked as a Techno Functional Consultant

• Worked on Oracle Purchasing, Inventory, Accounts Payable, Accounts Receivable, HRMS

• Worked on Internet Procurement

• Worked on AME setup for requisition approval

• Worked on workflow customization

• Worked on Realms

• Worked on Inbound and Outbound Interfaces

• Responsible for building and customizing Oracle Applications reports and Oracle Discoverer Reports

• Provided data from backend as per customized requirement

• Resolved technical and functional issues

• Created modified Alerts

• Executed new operating units setups

• Performed supplier and site creation

• Carried out period opening for inventory and purchasing

• Responsible for corporate rate and calendar defining

• Worked on hierarchy creation

• Assigned and revoked approval limits

• Responsible for vacation rule creation

• Worked on making buyer, temp ID creation, and position creation

• Attached position to the employee

• Performed value set creation

• Worked on personalization and printer setup for bar code generation

• Created request set and Request group

• Defined executable and concurrent programs

• Enabled/ disabled flex fields

• Reassigned workflow approval for requisition and purchase orders

• Resolved stuck purchase requisition and purchase orders in workflow

• Worked on menu, function, and responsibility creation

• Worked on profile value setup

• Created and modified the item category

• Created and modified the unspsc category

Oracle Application 11.5.10 (Financials, AP, AR, Oracle Purchasing, iProcurement, AME), Oracle Reports, Oracle Discoverer Reports, Oracle Alerts

Disha Softech Private Limited.

Oracle Application 11i implementation

April 2006 - October 2006

• Worked on Implementation project for Astron Polymers Pvt. Ltd

• Worked as an Associate Technical Consultant

• Created users and defined responsibilities

• Worked on Reports development and customizations.

• Worked Interface development and conversions

• Developed SQL*Loader to load data into temp tables from CSV files

• Defined executable and concurrent programs

• Worked on value set creation - independent/ dependent and table type

• Invoked concurrent programs in PL/SQL programs

• Defined menu, functions, and responsibility

• Worked on requisition and supplier and supplier site interfaces

• Called concurrent program through PL/SQL procedures

• Created users and responsibility

• Developed UTL_FILE to generate CSV files from Oracle Applications Base tables

Disha Softech Private Limited.

Oracle Applications Customization and enhancement

August 2005 - April 2006

• Worked on Customization project for Panacea Biotec Ltd.

• Worked as an Associate Technical Consultant

• Developed reports from scratch and registered as a concurrent program executables

• Designed Multi_ORG reports

• Responsible for the development of vendor site update interface

• Created value sets of independent, dependent, and table types

• Developed vendor vise invoice list report

• Created Vendor Payment History report

• Worked on profile value setup on user, responsibility, site, and application level

• Responsible for user and responsibility creation

• Defined executable and concurrent programs

Aptech Computer Education Limited.

Computer Literacy Trainer

July 2004 - August 2005

• Worked as senior faculty in Aptech computer education center.

• Delivered the lectures on PL/SQL and Oracle 8i

• Delivered the lectures on C programming Language

• Delivered the lectures on C ++ programming Language and oops concepts

• Delivered the lectures on Java programming Language

• Delivered the lectures on web designing tools like HTML and DHTML and UML

• Provided Lab support to complete the lab simulation and assignments and code compilation

EDUCATION:

• MCA, Guru Jambheswer University Hisar, 2004

• MS in Computer Science, Guru Jambheswer University Hisar, 2003

• BS in Commerce, MD University, Rohtak, 2001

ACHEIVEMENTS

• Won Wipro Spot Award for outstanding performance

• Won Wipro Quarter Star Award for consistent outstanding performance

• Won Torus Quarter Star Award for consistent outstanding performance

• Many times appreciated by direct clients

Contact this candidate