Oracle Manager

Mail Id: ****************@*****.***

Selvapandian T

Mobile: +919*********

Summary

. Has around 2.1 years of total experience in the field of Information

Technology on Oracle Applications ERP/CRM Technology.

. Extensive experience in Oracle Applications R12/11i iStore, Order

Management, Account Receivables, iPayment(Oracle Payments), Shipping

Execution, Inventory, General Ledger, Oracle Content Manager.

. Experience in Functional Requirement Gathering, As-Is documentation,

Business Process Mapping, Application Configuration and Test Script

Preparation.

. Experience in Development iStore Customizations, Integrated Payment

System Gateway with Oracle EBS modules (iStore, OM, AR, Service)

using Java, JSP and PL/SQL and Customization of OAF page.

. Experience in Configurator item creation and GUI design.

. Experience in Payment system integration with Oracle E-Business suite

for online credit card processing.

. Experience in OAF page personalization, customized the R12 iStore

login page without affecting the oracle application login page.

. Designing OA Framework page and integrating with custom

responsibility to generate the overall Report for transaction

details.

. Experience in Controller class extension in OAF.Customize the

iReceviable page to extend the class using jdeveloper.

. Experience in Configurator item creation and GUI design.

. Experience in custom Menu, Function, Responsibility, Lookup, Value

set, Flex-field and Profile creation.

. Experience in Concurrent program executable, program creation and

mapping it to the corresponding application group.

. Experience Sales order processing like order creation, updation,

cancel, applying hold, defining transaction types, Holds, Hold

Release Reason and Return order processing.

. Experience in Manual invoice, Debit memo, Credit Memo, Charge back

creation and applying it to the Receipts.

. Experience in Defining General Ledger account period for the every

year and opening in the current period in related modules.

. Experience in Business to customer, Company, Business to Business and

Partner user registration process and approving the Business user.

. Experience in Custom Payment system and Payee creation.

. Experience in Normal Item creation as well ATO and Kit item creation

process assigning it to different warehouse organization and adding

price in corresponding price list.

. Experience in Bills of Material for ATO and Kit item setup.

. Experience in Different Content item, Media objects creation and

mapping it to the corresponding Media objects or Products.

. Excellent in PL/SQL Programming.

. Excellent in iStore Site Administration and Customer Applications

management.

. Strong Analytical and Problem solving skills coupled with excellent

communication and inter-personal skills.

. Good knowledge on Order to Cash Cycle.

Professional Experience

Employer: Yantro Software Pvt Ltd.

Designation: Oracle Apps Techno Functional Consultant.

Skills Profile

ERP Oracle Applications 11i/R12 (IBE, OM, AR, AP,

CS, GL, INV, IBC, FND, SYSADMIN) OAF, Order to

Cash

Database 9i/10g/11g

Tools Form Builder 6i/10g, Net Beans, Eclipse, SQL

Developer, WINSCP, Putty, MS Office, ADF, Toad,

JDeveloper

Languages SQL, PL/SQL, Java, JSP, Java Script, Shell

script, HTML

Operating System Windows XP, Windows 7, Windows 8, Red Hat Linux

Projects

UL BUY&PAY iStore Development

Underwriters Laboratories, USA

Mar 2013 - Present

Techno Functional Consultant

Responsibilities

. Done with iStore basic configuration setup, to implement iStore and

other integrated modules such as Order Management, Configurator.

. Developed foundation for iStore to facilitate various Branding (Look &

Feel) and Item Catalog solutions for various branded specialty stores.

. Created the different sites catalog sections and site groups to group

the iStore sites.

. Enable/disable shipping functionality for all non-shippable and ATO

items as per the client requirement.

. Enabled functionality to convert Ordered Cart to Active Cart.

. Customized R12 login pages without affecting the oracle standard

process using OA Frame Work and personalization process.

. Customized R12 login pages and mapped to the iStore custom

responsibility.

. New Responsibility and menus are created and assigned to the

speciallity sites.

. Custom menu with function created and mapped to the custom

responsibility.

. The Browse bin is customized to display the section catalog hierarchy.

Also customized the catalog section and subsections.

. Custom Batch creation, developed shell scripts for applying the

custom objects from one server to another servers.

. Used FNDLOAD for downloading and uploading the LDT files from one

instance to other instance.

. The custom FND_MESSAGE is created based the requirement by making the

dynamic process in iStore speciallity site.

. Enabled the Product comparison, Express checkout, Direct item entry

and other features branded all iStore pages.

. JSP'S are customized and mapped it to the corresponding templates and

sites. Template mapping details are exported/imported using concurrent

program.

. Created Custom Roles and Responsibilities assigned to the iStore

customers to enable/disable the permissions.

. Configuring iStore in Oracle Applications 12i environment including

enable/disable the Check Out permission for particular iStore users

and setup items in inventory and integrated in iStore catalog.

. Customized Oracle iStore modules to integrate custom business

processes for Order-to-Cash.

. Working on Functional and Technical documents, developed multiple test

scripts and performing unit/integration testing.

Description

UL is a global independent safety science company offering

expertise across five key strategic businesses: Product Safety,

Environment, Life & Health, Verification Services and Knowledge Services.

In this project we are providing the required information to the client on

time, with the use of proper maintaining the whole webpage using iStore

module.

ORACLE APPLICATIONS 12x with CRM, iStore, Order Management, Inventory,

Account Receivables, Quoting, Configurator, Partner, General Ledger,

Application Object Library, HTML, JAVASCRIPT, JAVA, JSP, PL/SQL, XML,

SERVLETS, OA FRAME WORK, WINDOWS XP, ORACLE10g, LINUX.

Eaton iPayment Powering Systems

Eaton Corporation, USA

Jul 2012 - Feb 2013

Techno Functional Consultant

Responsibilities

. Payment system integration (FirstData, Heartland, CyberSource,

PayPal, Google Checkout, Chasepaymentech and First Data E4) with

Oracle EBS.

. Discussing with business experts, analyzing existing setup,

foundation issues and recommend the best solution, building GAP

analysis and design & develop custom extensions for

iStore/iPayment/Content manager.

. Developed High Level Design, Functional Design (BR100), Solution

Design (MD050/MD070/MD120/TE40) documents and discussing with various

module track leads and technical resources to get development and

integration done.

. Configuring iStore, Quoting, iPayment and other mandatory modules in

Oracle Applications R11and R12 environment.

. Customized Oracle iStore, Quoting and other modules to integrate

custom business processes for Order-to-Cash.

. Branded iStore site using Oracle Content Management and Catalog

Management with different template and layout.

. Developed complete presentation on Oracle Application environment and

other related area for PCI Compliance requirements including patches

and required setups for iPayment (Oracle Payments).

. Designing OA Framework page and integrating with custom

responsibility to generate the overall Report for transaction

details.

. Experience in Controller class extension in OAF Page.Customize the

iReceviable page to extend the class using jdeveloper.

. Custom Responsibility and Menu's are created and assigned to the

Minisites. Custom FND Messages created for dynamic process in iStore.

. Integrated Google Checkout, FirstData, Heartland, CyberSource,

PayPal, Chasepaymentech and FirstData E4 payment systems to process

the secure Credit Card transactions in Oracle Applications (OM,

AR,iReceviable and CS).

. The Different types of Order processing are done with use of the

above payment system.

. Customizing JSP, PLL, PL/SQL, etc to integrate the payment systems

with Oracle Applications.

. Integrated custom servlet, which can be called from Oracle iPayment

Servlet by creating Payment System gateway in iPayment and adding

Custom servlet entry in Orien-web.xml.

. Enables Existing Credit Card option with Oracle standard in Web

based, Form based and iPayment Non - Supported Modules when Payment

system has 'Save Option'.

. Enabled Re-Authorization process with Payment Systems, used when the

order expires.

. Developed seamless components for Oracle form and web based

applications for internal customer support can accept credit card,

without modifying oracle standard process flow.

Description

Eaton is an American global diversified power management company they

using iStore for online purchasing they enabled the iPayment solution with

different type of payment system for online credit card processing. They

are using the payment system who are all providing the hosted payment page

for customer credit card entering and enabled tokenization process for

customer process the order quickly.

ORACLE APPLICATIONS 11i and R12x with CRM, iStore, Order Management,

Account Payables, Inventory, Account Receivables, Quoting, Shipping

Execution, General Ledger, Application Object Library, HTML, JAVASCRIPT,

JAVA, JSP, PL/SQL, XML, SERVLETS, OAF, WINDOWS XP, ORACLE10g, LINUX.

Personal Information

Name: Selvapandian T

Date of Birth: 19-JULY-1987

Email Id: ****************@*****.***

Phone No: +919*********

Languages known: English, Tamil, Telugu

PAN Number: EJXPS1474N

Education

Education Details: MSc (Software Engineering) with 62.40% Sathyabama

University.

12th with 60.20% Kalaimagal Kalalaiya Matriculation HR SEC

School.

10th with 44% Government Boys Higher Secondary School.

(Selvapandian T.)

Contact this candidate