ANILKUMAR P Email: acqs18@r.postjobfree.com

Oracle Apps Technical Consultant Ph No: +91-966*******

Carrier Objective:

Looking forward for an opportunity in a challenging environment, where I can utilize my experience and skills in contribution effectively to the success of the organization and also for the improvement of my personal skills.

Summary:

Having 3 Years of Relevant Experience in Oracle Applications and Worked extensively in Development, Enhancement and Support projects of Oracle Apps R12.

Involved in Full Life Cycle Implementations and Support of Oracle Applications R12, with hands on working experience on Reports, Interfaces, Conversions and Extensions

Excellent exposure to Oracle eBusiness Suite in various modules depending on the client requirement in understanding and analyzing the provided RICE components.

Good Technical knowledge of the Financial Modules (AP, AR, GL,PN) and Distribution Modules (PO, INV, OM,EAM).

Worked with Procure to Pay (P2P) and Order to Cash (O2C) cycles.

Had good exposure in Development of Conversions and Interfaces (Data Migration).

Experience in Inbound Data Migration using SQL* Loader and Outbound Interface using UTL_FILE package.

Worked on XML Publisher Reports.

Strong experience in Oracle Technologies like SQL, PL/SQL and Developer Reports (RDF)10g/6i.

Knowledge on From Personalization and OAF

Proficient in writing stored procedures, Packages and functions using SQL & PL/SQL.

Strong knowledge in Application Object Library (AOL) module.

Preparing Technical Documents like MD’S, CV’S and TE’S using AIM Methodology.

Professional Experience

Working as an Oracle Apps Technical Consultant for Dhanush InfoTech Pvt Ltd, Hyderabad from Jun-’12 to Jun-’15.

Educational Qualification:

B.Tech (B.E) from JNTU Kakinada, A.P, India.

Technical Skills:

Oracle Applications

Oracle Applications R12/11i

RDBMS

ORACLE 8.x, 9.x Enterprise Edition

Reporting Tools

Developer 2000(6i&10G),XML Publisher, Discoverer(4i&10G)

Utilities Tools

TOAD, SQL *Plus, SQL *Loader, FTP, Sql Developer

Operating System

UNIX, Windows NT 4.0/95/98/2000.

DBMS Packages

Oracle 9i/10g

Programming Languages

SQL, PL/SQL

Projects Profile:

Project 4 #

Client

Idea Cellular Limited, India

Project type

Oracle Applications (R12) Support

Organization

Idea Cellular Limited, Pune

Duration

Dec-’14 to Till Date

Modules

SCM, FIN

Environment

Oracle Applications R12,, BMC Remedy Tool,TOAD,Oracle10G, PL/SQL,SQL

Role

Technical Consultant

Team Size

5

Client Description

Idea Cellular Limited (IDEA Cellular) is a national telecom service provider in India. The Company is engaged in the business of Mobility and Long Distance services. The Company operates in two segments: Mobility Services and International Long Distance (ILD). Mobility Services segment provides General Packet Radio Service (GSM) based mobile and related telephony services. Its Idea ConCall is an audio conferencing service. The Company offers hosted Interactive voice response (IVR) solutions that help Enterprises to manage various business processes without investing on hardware and database servers thereby managing resources in their core business domain.

Responsibilities

Resolving issues in Custom Reports and Development of Reports as per the Client Requirements.

Working on Supplier Merging.

Coding and Development of Reports and Forms as per Naming and Coding Conventions

Creating the Inventory items and Suppliers /Supplier sites on daily bases through interface.

Involved in client discussions and gathered information directly with client.

Involved in the development of Stored Procedures and PL/SQL Packages.

Discussion with functional team regarding finalization of the templates.

Resolving issues based BMC remedy tool tickets.

Helping to functional consultant, where AP invoices are not loaded...etc.

Interacting with users and resolving their issues.

Project 3 #

Client

MTN Group

Project type

Oracle Applications (R12) Implementation

Organization

Wipro, Chennai

Duration

Dec-13 to Dec-14

Modules

PN,AR,AP,INV,EAM-Data Migration Developer (Interface, conversions)

Environment

Oracle Applications R12,EDQ,ODI

TOAD,Oracle10G, PL/SQL,SQL

Role

Technical Consultant

Team Size

6

Client Description

MTN Group is a leading emerging markets mobile operator which is the forefront of the technological changes sweeping the world .MTN invest significantly in advanced communications networks, connecting more than 203, 8 million people in 22 countries across Africa and the Middle East. MTN leverage the talent of nearly 27,000 employees to offer innovative products and a quality customer experience. MTN Group Limited’s head office is in Johannesburg, South Africa, where the Group is listed on the exchange operated by the JSE Limited under the share code ‘MTN’.

Responsibilities:

Developed custom API for

FND data, FND add responsibility

Property manager lease creation

Customer Update, Contact Update

Customer Profile, customer amount profile update

Supplier Bank Creation, Branch Creation, Supplier update

EAM (Meter, Meter Reading, Active Association, Active Association Template, PMSchedule, PMSchedule Template, Meter Association Template)

Worked on open interface program for AP & AR Transaction invoice data migration.

Worked on open interface program for Customer creation.

Involved in Preparation of Technical Design Documents.

Involved in Preparation of Unit Test Cases and prepared recon report.

Involved in Development and Customization of Reports.

Involved in Development of AOL objects like

Defining Concurrent Programs, Executables.

Creation of Value sets, Lookups and DFF’s in various Modules of the application.

Created various PL/SQL procedures/packages according to the Client requirements.

Preparing Technical Designing Documents before/after completion of the component.

Prepared Deployment document from UAT to PROD for all objects by using FNDLOAD.

Project 2 #

Client

Galana Oil Kenya Limited

Project type

Oracle Applications R12 Implementation & Support

Organization

Dhanush Infotech,Hyderabad

Duration

Apr-’13 to Nov-’13

Modules

PO,OM,INV,AR,AP,EAM

Environment

Oracle Applications R12, XML Publisher, Discoverer

TOAD,Oracle10G, PL/SQL

Role

Technical Consultant

Team Size

4

Client Description

GALANA-OIL Kenya limited is a fully fledged oil company and top oil marketer in Kenya with a large network of service stations across Kenya. Galana holds exclusive rights to trade under the brand name of DELTA in the network station. Galana Oil Kenya Limited is committed to providing and distributing quality petroleum products to meet and exceed stakeholders' expectations through outstanding customer service delivery with great regard to the environment.

Responsibilities:

Development and Customization of Developer Reports.

Involved in development of Conversions & Interfaces.

Development of XML Publisher Reports in AP, PO, INV module.

Involved in Form personalization.

Code review and testing and fixing the problems.

Involved in preparing documents as per standards.

Registrations of Concurrent Programs.

Creation of value sets as per client requirements.

Created various PL/SQL procedures/packages according to the Client requirements.

Provided instant solutions to issues which were reported in the production instance.

Tested and corrected errors and refined changes to data base

Preparation of Technical Documents like MD70 using AIM

Maintaining the daily & weekly technical reports and customize the documents for the same.

Active participation of weekly meetings with the team leads and provides the work done reports.

Preparation of installation guide for AOL components like concurrent programs, value sets, request groups etc.

Downloading and Uploading the AOL objects using FND LOAD

Project 1 #

Client

Gulf Energy limited

Project type

Oracle Applications R12 Implementation

Organization

Dhanush Infotech, Hyderabad

Duration

Aug-’12 to Jan-’13

Modules

PO,OM,AP,AR,INV

Environment

Oracle Applications R12, XML Publisher, TOAD,WinSCP,Oracle 9i, PL/SQL

Role

Associate Consultant

Team Size

6

Client Description

Gulf Energy limited is a locally incorporated oil trading and marketing company, with operations in east and central Africa. Jade Petroleum has a wide diversity in its clientele – ranging from leading corporate entities, small and medium sized enterprises, and individuals in all the regions covered by them.

To be the market leader in the east African region in the provision of quality oil products, whilst at the same time being the foremost client oriented oil trading, marketing, and retailing company in the oil industry.

Responsibilities:

Development and Customization of Developer Reports.

Involved in developing out-bound interfaces using UTL_FILE package.

Development of XML Publisher Reports in AP, PO module.

Deployed the reports one instance to another instance by using FNDLOAD script.

Registrations of Concurrent Programs.

Creation of value sets as per client requirements.

Code review and testing and fixing the problems.

Involved in preparing documents as per standards.

(Anil Kumar)

Contact this candidate