George - Oracle Apps Technical Consultant - Bangalore, KA, India

Justin George

Bangalore, KA, India

Services

Oracle Apps Technical Consultant

Summary:

 Design, Development and Customization of RICE components.
 Doing feasibility analysis and preparing technical design documents MD-070.
 Coding and Development of RICE as per Naming and Coding Conventions.
 Define Concurrent program, Request Sets and Executable.
 Performing Unit testing and Code review for developed RICE Components.
 Preparation of MD120 doc for Code migration.
 Monitoring the deliverables during each phase of project.
 Attending the weekly status calls and weekly reporting.
 Writing SQL queries according to customer requirement.
 Designed master-detail and Multi-layout templates using RTF method for XML Publisher.
 Expertise in creating inbound and outbound feeds, creation of automated processes using Application Program Interfaces (API).

Work History

Team Member

From May 2012

Environment Oracle Applications R12(Implementation)
Modules OM, PO, INV, AP, AR, GL
Duration May 2012 to till date

Client Description:
The project main aim is implemention of Distribution and Manufacturing Module of Oracle Applications and builds a Custom Solution to support integration of Oracle Applications. This is a purely integration project. Under this project we will be doing all the Sales and Service part, other legacy systems will be used as Oracle Interface.
Responsibilities:
➢ Design, Development and Customization of RICE components.
➢ Doing feasibility analysis and preparing technical design documents MD-070.
➢ Coding and Development of RICE as per Naming and Coding Conventions.
➢ Define Concurrent program, Request Sets and Executable.
➢ Performing Unit testing and Code review for developed RICE Components.
➢ Preparation of MD120 doc for Code migration.
➢ Monitoring the deliverables during each phase of project.
➢ Attending the weekly status calls and weekly reporting.
➢ Writing SQL queries according to customer requirement.
➢ Designed master-detail and Multi-layout templates using RTF method for XML Publisher.
➢ Expertise in creating inbound and outbound feeds, creation of automated processes using Application Program Interfaces (API).
➢ Data Conversion from Flat files to Oracle using Oracle SQL* Loader and SQL*Loader scripts.
➢ Developed XML Publisher Reports using Pl/sql.
➢ Designed Template Based XML Publisher Reports.
Reports:
➢ Developed AP Invoice Report.
➢ Developed Supplier Wise Invoices.
➢ Developed Sub inventories Quantity Report.
➢ Developed PO Submit Purchase Order Report.

Interfaces:
➢ Developed GL Inbound Interface to import the Journals data from Legacy to Oracle applications GL base tables using the standard program 'Journal Import'.
➢ Developed Sales Order Inbound interface to import the sales orders data from Legacy to Oracle applications base tables.

Project #2:

Oracle applications Technical consultant

Domino

From August 2011

Projects

Project#1:
Client Name Domino

Team Member

Transworld

August 2011 - April 2012

Environment Oracle Applications11i, Oracle 10g(Implementation)
Modules PO, OM, INV, AP, AR, GL
Duration August 2011 to April 2012

Description:
Located in the Jebel Ali South Zone in Dubai, the Transworld warehouse is home to several top brands in diverse sectors including garments, FMCG, pharmaceutical, retail and other consumer goods. A separate Warehouse facility at Dubai Cargo village caters for companies' need in short storage time, fast turn-around and rapid access to air transport. In this projects we will mainly implement oracle apps module for the logistics tracking system.
Responsibilities:
➢ Design, Development of RICE components and related Aim Documents.
➢ Designed technical documentation, and provided solution for interfaces, and reports.
➢ Concurrent program definitions and Executable.
➢ Developments and customization of reports based on Client requirements.
➢ Involved in development of interfaces which will extract the data from base tables into flat files using UTL_FILE.
➢ Development of executables, concurrent programs, creating value sets and registering them into oracle applications.
➢ Writing SQL queries according to customer requirement.
➢ Understanding customer issues.
➢ Deployment to other test environments.
➢ Post Production support.
➢ Preparation of MD070 and MD120 installation documents.
➢ Define value sets, lookups and concurrent programs.
Reports:
➢ Developed Inventory item Detail Report.
➢ Developed Quotation Report
➢ Developed Order Acceptance Acknowledge Report.
➢ Developed Invoice Report.
Interfaces:

➢ Developed interface program to Upload Requisitions into PO interface tables from Legacy System in Oracle Base table and Used SQL* Loader to upload data from Flat Files and wrote PL/ SQL Procedures for all the business validations.

Qualifications & Certifications

b.tech in information technology

S.K.P Engineering College (Anna University

st michaels high school

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more


Supported Countries
Choose your country

×