Project Oracle

ORACLE APPS TECHNICAL CONSULTANT

NAME:NAGARAJU E-mail:****.********@*****.*** Phone: +91-996*******

OBJECTIVE:

To seek an opportunity to serve an organization of repute with quality environment, where I can utilize my knowledge, experience and ability to further explore and enhance my skills.

PROFESSIONAL SUMMARY:

Total 3+ Years of Experience in IT Industry which includes 3+year’s relevant experience in Development and Customization of Oracle applications 11i and Release 12 using Form Builder ,Report Builder, XML Publisher and Discoverer Tools.

Good team player having good communication skills and flexible for learning new technologies.

Worked on RICE Components Like Reports, Interfaces, Conversions, Extentions and UTL_FILE Packages.

Worked on XML Publishers Reports , Discoverer Reports and Forms.

Preparing Technical documents like MD’s,CV’s .

Experience in creating SQL*Loader control programs and PL/SQL validation scripts for validating and pre-import processing legacy data from feeder system to Oracle applications.

Involved all phases of Development of Oracle Apps 11i Conversant with modules and Good functional Knowledge like AP,GL,AR,PO,OM,INV.

Having very good experience in the Procure to Pay cycle and as well as Order to cash Cycle.

Capable of working independently and as well as a part of a team.

EXPERIENCE DETAILS:

Working as a Technical Consultant in ITIANA Tec Pvt Ltd, Bangalore From JUN 2008 To Till Date.

EDUCATION:

B.SC(Electronics) From S.V.University

TECHNICAL SKILLS:

Technical Skills

ERP: Oracle Applications 11i and R12

Modules: OM, PO, INV,AP,AR, GL

Work area: Interfaces, Conversions, Extensions, Reports,Forms

Reports Customization, Packages & Concurrent Programs, AOL.

Operating Platforms: Windows NT/ 2000/XP

DBMS/RDBMS: Oracle 8i , 9i and 10g

Languages: SQL, PL/SQL, C,C++ and J 2SE

GUI: Developer 2000, Report Builder10g, Form Builder10g, Xml Publishers, Discoverer9i.

Tools & Utilities: TOAD, SQL*Loader, File Zilla, WIN SCP,Developer2000,XML Publisher,

Discoverer

PROJECT DETAILS:

PROJECT #1:

Client : Sandoz

Project : Implementation Project

Software : Oracle Applications Release12

Role : Technical Consultant

Tool : Report Builder10g, Form Builder10g, XML Publisher, Discoverer,

TOAD, File Zilla, SQL* Loader, UTL FILE

Description:

Sandoz, a global generics leader, develops, produces and markets medicines that are no longer protected by patents, along with pharmaceutical and biotechnological active substances. Sandoz offers patients approximately 1.000 molecules worldwide. Sandoz medicines are available to about 90% of the world’s population. Sandoz produces far more than just traditional off-patent products. We differentiate ourselves from other companies by developing and producing differentiated products that require an exceptionally high degree of expertise and knowledge and often involve complex high-tech delivery systems. These range from oral solids and inhalers through patch technologies to state-of-the-art biosimilars – approved versions of biopharmaceutical medicines

Responsibilities:

Developed XML reports as per the client requirement by using the .rtf formats and developed new .rdf files.

Developed Customized and generated the reports and registered them as concurrent programs in Oracle Applications using AOL.

Developed sql queries to obtain specific information as per requirements

Involved in coding design of the form. Create tables, indexes and sequences, Developed packages, procedures and functions. Developed many pl/sql blocks for the validation of the form.

Created new and customized existing standard oracle reports using oracle reports and SQL*Plus.

Developed Packages to extract the data from base tables into flat files by using UTL_FILE package.

Developed Interfaces to upload the data from legacy system to Oracle Applications Base tables

Involved in the Sys Admin Module for the registration of various front end objects and the database objects.

Adding the Descriptive Flex Fields in various Forms as per the Client Requirement.

Reports:

Developed PO Report with Revision amount Report.

PO Report with Matching criteria with Item Cost.

Developed AP&PO analysis Report.

Developed Approved Purchase Order Report.

Developed Inventory Item cost Report

Interfaces:

Inbound Interface

Developed the GL Inbound Interface to import the journals data from legacy system to Oracle Applications GL Base Tables.

Developed ITEM conversion to import items into ORACLE APPLICATIONS Inventory Base tables

Outbound Interface

Developed the Inventory Outbound Interface to extract the data from Oracle Applications Base Tables to Flat Files .

Developed the Blanket PO Outbound Interface to extract the data from Oracle Applications Base Tables to Flat Files .

Forms:

Developed Form Development based on Client Requirement by using TEMPLATE.FMB

Working on Personalization of Forms in various application forms.

PROJECT #2:

Client : Dura Feed

Project : Implementation Project

Software : Oracle Applications 11i

Role : Technical Consultant

Tool : Report Builder, Form Builder, XML Publisher, Discoverer, TOAD, File

Zilla, SQL* Loader, UTL FILE.

Description:

Dura Feed, Inc. designs and manufactures vibratory part feeder systems. Our technicians have the capabilities and experience to handle your toughest components. We make every effort to exceed all of your expectations. We are committed to a high level of quality and service, while keeping your costs as low as possible. We do whatever it takes to make on time deliveries. Our dependable systems will keep you and your customers satisfied for years to come.

Responsibilities:

Being a part of the offshore supporting team and responsible for the following Technical Components.

Understanding the report functionality and analysis and review of high level documents mainly MD 050s.

Performed sys admin activities for technical work including setting – up of user responsibility, request group

Preparation of Technical specifications from the functional specifications received from the functional team.

Developed Discoverer reports as per client requirement.

Writing custom packages to develop interface programs

Developed Packages to extract the data from base tables into flat files by using UTL_FILE package.

Development of Interface Programs to import the data from Legacy System to Oracle Applications Base Tables by using SQL*Loader Program.

Creation of Value sets in various Modules of the application

Reports:

Developped List Of Stopped Invoices Using XML Publisher.

Devlopped Reverse Journal Report Using XML Publisher.

Rejected and Return Quantities to the vendor.

Interfaces

Developed the Purchase Order inbound interface to import the PO Details from legacy system to Oracle Applications PO Base Tables.

PROJECT #3

Client : Penwell

Project : Implementation Project

Software : Oracle Applications 11i

Role : Technical Consultant

Tool : Report Builder, Form Builder, XML Publisher, TOAD, File

Zilla, SQL* Loader, UTL FILE.

Description:

PennWell Corporation is a highly diversified, business-to-business media company providing authoritative print and online publications, conferences and exhibitions, research, databases, online exchanges and information products to strategic global markets.Since 1910 PennWell has been known for providing comprehensive coverage of several strategic markets.Today PennWell publishes 45 business-to-business magazines and newsletters, conducts over 60 conferences and exhibitions on six continents, and has an extensive offering of books, maps, directories and database services.

Responsibilities:

Being a part of the offshore supporting team and responsible for the following Technical Components.

Registration of concurrent programs, parameters for custom reports specific to Applications.

Designed, developed a package for sales order conversion by using API and tested as per unique business requirements.

Application System Administration activities like application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs and printers

Written stored procedures, functions and triggers using PL/SQL.

Developing GUI Screens and Reports using Forms 6i and Reports 6i.

Customized menus so that the application will be menu driven easy for navigation.

Registrations of Custom Tables and Concurrent Programs.

Performed sys admin activities for technical work including setting – up of user responsibility, request group

Contact this candidate