Arul Anton

913-***-****

Email: abht3o@r.postjobfree.com

SUMMARY

> Oracle Apps Techno-Functional Consultant with 10 years of ERP experience

in Analysis, Design, Development, Testing and Implementation in

R12/R11i Oracle Financials AP, AR, GL, Cash Management, iProcurement,

iExpenses, Oracle Supplier Networks, Project Costing, Grants Accounting,

Project Billing, iSupplier Portal, HRMS, OM, PO, CRM, MFG Modules.

> Expertise in Integrating Third Party HR system (Ultipro) with Oracle

Financials to synchronize Employees with Financial Workflows.

> Automated the ACH, WIRE and CHECKs Transactions with BONY, SVB,

American Express and Bank of America.

> Developed Custom Interface to import External Transactions from SINGLE

VIEW AR system into Oralce CASH Management and AUTORECONCILED against

Bank Statements.

> Expertise in Banks Statements Auto Reconciliation Process in CASH

Management

> Expertise in developing Custom Inbound and Outbound HRMS/Payroll

Interfaces for vendors CIGNA, CBIZ, Fidelity, COBRA, MetLife and LRN.

> Successfully migrated FBR Oracle Financials into In House Data Centre

from Oracle Hosting Vendor AT&T (USi).

> Worked on HRMS migration from FBR Oracle HRMS to Ultipro HR System and

extensively developed Custom interfaces to bring Employee new Hire,

Assignments, Jobs, Addresses, Expense Accounts, Termination, Reverse

Termination and Supervisor Information into Oracle Financials.

> Sound functional knowledge on Order to Cash and Procure to Pay.

> Expertise in R12 XML Gateway Integration with Suppliers cXML, OSN (Oracle

Supplier Networks), Oracle Exchange to send OUTBOUND POs and receive

INBOUND Invoices.

> Expertise in R12 iProcurement Punch out cXML for iProcurement Suppliers.

> Experienced in enabling SSL for OXTA (Oracle XML Transport Agent) in R12.

> Expertise in customizing and troubleshooting on Oracle Workflow including

OECOGS, OEOH, OEOL,APEXP, APINV, POAPPRV, REQAPPRV,HRSSA with AME,

Project Expense Report Account Generator, Project Supplier Invoice

Account Generator, PO Approval Account Generator, PO requisition Account

Generator.

> Experienced in configuring Java Workflow Mailer on SSL Environment.

> Expertise in Data Conversion on oracle Suppliers, Suppliers sites,

Invoices, General Ledger, Project Costing, Grants Accounting, HRMS

Employees, Assignments, Jobs, Addresses, PO and Requisitions.

> Sound Knowledge in Jdeveloper, OA Framework, Personalization, Partial

Page Rendering using SPEL, Extensions and BPEL.

> Involved in 5 full cycle Oracle application implementation

> Experienced on various roles including Technical lead, Team Lead and

Technical team member.

> As a Technical Lead, capable of providing technical specification to

technical team of 5 or more technical persons.

> Expertise in developing BI/XML Publisher reports for all Oracle Modules.

> Excellent experience in Requirements Analysis, Mapping Requirements,

Process Flow-Charting and Gap Analysis leading to Functional Setup of

Accounting and related Management Information Systems.

> Excellent Functional and Technical Knowledge of Oracle applications

10.7NCA, 11.03 and 11i versions in the Financial Modules, Supply chain

Modules, Projects, Human Resources and Payroll modules.

> Excellent technical knowledge of creating new Oracle Alerts and customize

the existing alerts for various business requirement.

> Experience in preparing AIM 3.0 (Application Implementation Methodology)

technical and Functional documents for data conversion and applications

extension

> Sound Knowledge of Form customization, Report customization and

developing new reports.

> Sound Knowledge of Programming Standards, Methods, Techniques and Version

Control aided by rich programming experience in a wide range of third

generation languages.

> Sound Knowledge of the Oracle apps Database Architecture, SQL Plus and

PL/SQL.

> Performed SQL tuning by using EXPLAIN PLAN and TKPROF.

> 5 Years of Experience in supporting 75 + clients including (Motorola,

World Vision, Dresser, Chipotle, FBR, Tecumseh, BARCLAYS, ADIC, Allegro,

LGPC, FA- Frontier Airlines, First NLC, First American, Navini, Nabors,

Teletech, Quantum, CNL Financials, Caspian, Champs, Calix, Igloo,

Ionics, Ironport, Republic Financials, Turin, Ultimate, Seacor, United

Components, RFMH, etc) in various streams like Financial, HRMS,

Manufacturing, Order Management and CRM.

> Extensive experience in planning and managing Oracle Application system,

unit, integration and user acceptance testing strategy and procedures

> Possess Good Communication and Interpersonal Skills

Personal Details

Visa Type: H1B Valid up to Jan 2013

Employer: Knowledge Systems, VA.

Contact: abht3o@r.postjobfree.com

Technical Summary

ERP Oracle Applications R12, 11i, 11.5.10, 11.5.9, 10.0.3

iProcurement, iExpense Project Costing, Grants

Accounting, GL, AP, AR,HRMS, PayRoll, PO, OM, INV,CRM,

AOL, XML Gateway, OSN, iSupplier

Operating UNIX, Windows NT

Systems

Languages SQL, PL/SQL, Java, HTML and XML

RDBMS ORACLE 8i/9i/10g

Front End Developer 6i /9i/10g (forms & reports), JDeveloper, XML

Tools Publisher5.5, Discoverer 4i,

OA Framework, BPEL, XML Map Designer

Tools & TOAD, SQL*Loader, Workflow Builder 2.6.3.5, ADI

Utilities

Education

Master of Science (M.S Cyber Tech - Computer Science)

Bachelor of Science (B.Sc Computer Science)

Professional Experience

Employer: Knowledge Systems, Vienna, VA

Duration: Sep 2010 - Till now

Project Oracle Financial Implementation.

Duration Sep 2010 - Till now.

Client Arbinet Corp - Herndon, VA (Arbinet Corporation is a leading

provider of international voice and IP solutions to

carriers and service providers globally. With more

than 1100 carriers across the world connected to the

Arbinet Network, and over 1400+ destinations, Arbinet

combines global scale with sophisticated platform

intelligence, call routing and industry leading

credit management and settlement capabilities.)

Position Oracle Application Techno Functional Consultant.

Environment Oracle Application R12/11i, Oracle Financials(Payables, Cash

Management, Internet Expenses) Oracle 10g/Developer

10g(Forms, Reports) on Red hat LINUX.

Project Description Arbinet Corp implements Oracle Financials to

Automate their Payment process with Silicon Valley

Bank.

Roles/Responsibilities:

> As an Oracle Application Techno Functional

Consultant, participated on high level meetings

with the client to understand their Financial

Systems and Supplier Banks to automate the

Payment Process.

> Analyzed the NACHA File Specification for SVB

Bank for Direct Transmission.

> Customized the NACHA Payment Format to bring

the new Entry HASH calculation, Check Digit,

Addenda Count, Total Debit Dollar Amount,

Receiving DFI Identification and External Bank

number as per SVB NACHA Standards.

> Analyzed the WIRE File Specification for SVB to

do the direct Transmission.

> Developed new PL/SQL Package for WIRE Payment

to bring the File Header, Batch and Trailer

Records with delimited Record Layout.

> Analyzed the SVB Standard Check Format.

> Developed new BI Publisher Template with

Arbinet Logo, MICR Font, Double Signatures

functionality to print the check in Secure

mode.

> Developed Custom Interface to import External

Transactions from SINGLE VIEW AR system into

Oracle CASH Management and AUTORECONCILED

against Bank Statements.

> Customized the package CE_999_PKG, and views

CE_999_INTERFACE_V, CE_999_TRANSACTIONS_V for

Auto Reconciliation Process in Cash Management.

> Customized the Internet Expense Workflow to

update the Approval Hierarchy and send the

notifications to Approvers come from Third

Party HR system.

Employer: FBR Capital Markets Corporation, Arlington, VA

Duration: Jan2010 - Aug 2010

Project FBR Oracle R12 Financials Integration with UItipro HR System,

FBR Oracle R12 Financial Migration in House from

Hosting Vendor.

Duration Jan2010 - Till now.

Client FBR Capital Markets - Arlington, VA (FBR Capital Markets

Corporation (FBR Capital Markets; NASDAQ:FBCM) is a

top ten investment bank with an international

franchise, one of the strongest equities distribution

capabilities in the securities industry and an active

asset management business.)

Position Oracle Application Developer.

Environment Oracle Application R12, HRMS, Oracle Financials, Oracle

10g/Developer 2000(Forms 6i, Reports6i) on Red hat

LINUX.

Project Description FBR migrates Oracle HRMS to Ultimate Ultipro HR

System also migrates Oracle Financials from Hosting

Vendor AT&T(USi) to Manassas In House Data Centre.

Roles/Responsibilities:

> As an Oracle Techno Functional Consultant,

participated on high level meetings regarding Data

Center Setup, Hardware Procurements, Environment

Study on Legacy HRMS and Target HR System,

Identifying Interfaces, Gap analysis for Integrating

TWO Different ERPS(ORACLE -Ultipro), Data Conversion,

UAT and Go Live.

> Analyzed the potential Interfaces on HRMS for

seamless integration between Oracle Financials and

Third Party HR System.

> Performed the Gap Analysis between Ultipro HR and

Oracle Financials

> Prepared Mapping file for the Interfaces which are

integrating two ERPs.

> Designed the Functional Specifications for the

Interfaces Employees, Assignments, Addresses, Jobs,

GL Code combinations, Supervisor.

> Developed on Going Custom Interfaces using HRMS APIs

Persons, Addresses, Assignments and Termination.

> Developed FTP Job to download the Flat file for

Employees from Ultipro server into Oracle Server.

> Scheduled concurrent job to read the flat file and

input to the custom interfaces to create or update

Employees, Assignments, Addresses, Jobs and Update

Supervisor Information.

> Made sure Oracle Financial Workflows able to receive

updated employees and Supervisor information

synchronize with Ultipro HR System.

> Deactivated Oracle HRMS and Payroll modules and went

live with Ultipro.

> Performed GAP Analysis for Ultipro Payroll and Oracle

General Ledger and developed the mapping file to

integrate Ultipro Payroll with Oracle General Ledger.

> Designed the Functional Specification for Ultipro

Payroll Transfer to Oracle General Ledger.

> Developed on Going Interface for Ultipro Payroll

transfer to Oracle GL.

> Developed the FTP Job to download the flat file for

Payroll from Ultipro Server to Oracle Server.

> Scheduled concurrent job to populate Payroll data

into GL Interface Table.

> Developed NACHA Payment format for BNY, American

Express and Bank of America.

> Developed Xtiva Client Interface to extract Expense

Sales, Presales data for IB Mertrix.

> Customized iExpense workflow to disable the Preparer

approves his own Expenses when the Approver setup

vacation Rules for Reassign to preparer.

Employer: Advance Computer Associates CORP, Overland Park, KS.

Duration: Sep2008 - Dec2009

Project R12 Implementation for SIMR: Stowers Institute for Medical

Research

Duration Feb2009 - Dec2009

Client Stowers Institute for Medical Research, Kansas City, MO

(aspires to be one of the most innovative biomedical

research organizations in the world. The Institute

conducts basic research on genes and proteins that

control fundamental processes in living cells to

unlock the mysteries of disease and find the keys to

their causes, treatment, and prevention. )

Position Oracle Techno functional consultant

Environment Oracle Application R12, Oracle Oracle 10g, Forms 10g, Reports

10g, OSN 5.1, XML Gateway, Projects Costs, Grants

Accounting, iProcurement, HR Payroll, Purchasing,

Payables, iExpenses on Red hat LINUX.

Project Description Stowers migrated from Lawson Legacy System to Oracle

R12.

Roles/Responsibilities:

> Designed the mapping of the legacy Lawson Projects

structure with oracle project structure and developed

of interfaces to bring the legacy transactions into

projects.

> Designed and developed the project Budget interface

(Grant API)

> Design and develop the project billing events

interface (Both Revenue and Billing)

> Design and develop API for loading legacy asset

information into Oracle Assets.

> Design and developed custom extension for labor

distribution cost (Total time accounting) which is

fully integrated with Payroll and OTL.

> Designed and developed the Data Conversion for

Suppliers, Supplier Sites, PO, Invoices.

> Customized/Created OTL related Fastformulas.

> Customized purchase Order, Purchase Requisition

account generator workflow in Oracle Purchase.

> Customized project supplier invoice account generator

workflow in Oracle Payables.

> Customized Project Expense Report Account Generator.

> Designed XML Gateway mapping with Trading Partners

OFFICE DEPOT, VWR, Transnetyx, SIGMA Aldrich,

Invirogen, Fisher Sci, Office Max, etc.

> Setup Trading Partners in Oracle Suppliers Network

with DUNS.

> Created Punch out Stores in iProcurements for the

clients OFFICE DEPOT, VWR, Transnetyx, SIGMA

Aldrich, Invirogen, Fisher Sci, Office Max.

> Performed cXML and XML Punchout and brought the

catalog info into iProcurement then created

Requistions, upon approval generated XML PO and sent

it to supplier via XML Gateway and received Invoice

electronically.

> Prepared MD050 and MD070 for customizations

> Configured SSL for the secure Transaction between

Buyer and Suppliers with .

Project APC R12 Implementation, E3R1.5 OTD Shipping

Documents on BI Publisher

Duration Sep 2008 - Jan 2009

Client APC- American Power Conversion, West Kingston, RI, USA.

Position Technical Lead ( 5 Technical people)

Environment Oracle Applications R12, Oracle 10g, Forms 10g, Reports 10g, BI

Publisher/XML Publisher on Red hat LINUX.

Project Description APC upgraded Oracle 11i to R12 along with converting

Oracle Reports into BI Publishers Reports for

Shipping Documents.

Roles/Responsibilities:

> Designed and Developed Data Conversion on Suppliers,

PO, Supplier Sites, Invoices

> Developed BI Publisher/XML Publisher Reports for APC

Costa Mesa Team.

> Created Templates, XML Data definitions and

configured the concurrent programs with the custom

templates.

> Developed APC - Commercial Invoice (by Delivery

Name) report, Designed new Template for Commercial

Invoice and integrated with EBS

> Developed APC- Sales Order Acknowledgement Report,

template, Data Definition.

> Developed APC- Pack Slip Report, Template, Data

Definition.

> Developed MD 70s for Commercial Inovice, SOAR and

Pack Slip

> Created Md120 and TE 20 Documents for Commercial

Invoice, SOAR and Pack Slip

> Customized COGS account generator workflow in Oracle

Order Management

> Customized OEOH and OEOL workflow for sending email

notification to customer while Book and Ship the

order.

> Created new notification Alerts for various business

needs.

Employer: USi, an AT&T Company, Bangalore, INDIA.

Duration: May2004 - Aug2008

Project BGI Business Master- Oracle Financials,

iExpenses

Duration Aug 2007 - Aug 2008

Client Barclays Global Investors, US

Position Techno-Functional consultant

Environment Oracle Applications 11.5.10.2/R12(Oracle Financials) Oracle

10g, Forms 6i, Reports 6i, Workflow 2.6, and XML

Publisher 5.5, Jdeveloper 9i on SUN SOLARIS 8.

Project Description This is an Oracle Financials R12 Upgrade project.

Roles/Responsibilities:

> Worked on OA Framework including the Personalization,

Partial Page rendering using SPEL, Application

Modules, View Objects, Entity Objects, Model View

Controller.

> Developed BPEL Process for Purchase requisition in

iProcurement .

> Developed interface programs (BGI UK GBP Business

Master Interface, BGI UK Non GBP Business Master

Interface) for upload of payments details from legacy

system after validate the data.

> Developed Oracle Reports (BGI UK BAC format Payment

and BGI UK Non GBP format Payment) to generate report

on Payment Batches created for GBP currency and Non

GBP.

> Worked on BGI- AP Invoice Workflow customization to

send the attachments from Invoice Headers to the

approver through email Notification along with

Approval History and Distribution details.

> Design and Development of Data Conversion on

Suppliers and Supplier Sites .

> Configured XML Gateway for send and Receive PO and

Invoices.

> Developed ACH Payment Format.

> Customized iExpense Workflow to allow multiple

vacation rules between preparer and Approver includes

Reassign, Forward.

Project Oracle 11i Financial Upgrade with iExpenses and XML

Publisher Reports Development.

Duration Feb 2006 - July 2007

Client IRONPORT, San Bruno, CA, USA (Cisco acquired IronPort Systems

in June, 2007. Now a part of the Cisco product

family, IronPort email and web security appliances

protect organizations of all sizes against spam,

viruses, malware and other Internet threats -

combining powerful performance with preventive and

reactive security measures that are easy to deploy

and manage. These award-winning products and

solutions are available from your local account team

and through authorized resellers.)

Position Oracle Technical Consultant.

Environment Oracle Applications11.5.10.2 (OM, PO, Payables, iExpenses)

Template Builder, XML Publisher 5.5, Workflow Builder

2.6

Project Description Ironport upgraded Oracle 11i (11.5.10) from 11.0.3.

Roles/Responsibilities:

> As a Technical Consultant, I was responsible for

mapping the chart of accounts of 11.0.3 to

application 11.5.10.

> Was responsible for design and development of

interface to bring the open documents (PR, PO and

Open Invoices) from both 11.0.3 to 11.5.10instance.

> Customized iExpense Workflow

> Developed XML Publisher Reports

> Created Templates, XML Data definitions and

configured the concurrent programs with the custom

templates.

> Implemented the MICR fonts in the AP Check format.

> Installed the MICR fonts and supporting Printer

Drivers in APPs Tier

> Configured the MICR fonts with XML Publisher Template

using XML Publisher Administrator

> Converted the Seeded Reports AP Check Formatted

Payments, Pack Slip Report, Sales Order

Acknowledgment, Printed Purchase Order, Invoice Print

Selected Invoice into XML Publisher Reports.

> Worked on OA Framework Personalization to customize

the Workflow notification OA Region using the System

Mailer Workflow.

> Developed BPEL Process for Purchase Requisition.

> Developed Test Scripts for BI Publisher QA Testing.

Project Item Conversion and Open Opportunity Conversion

Duration July 2005 - Jan 2006

Client GXS, US (GXS is a global B2B e-commerce and integration

services company. We deliver global B2B e-commerce

integration solutions to over 70 percent of Fortune

500 companies. Through the company's key

offerings, GXS Trading Grid and GXS Managed

Services, we enable simplified document exchange,

enhanced supply chain visibility and streamlined

communications with trading partners.)

Position Oracle Technical Consultant.

Environment Oracle Applications 11.5.9(INV, CRM), Oracle 8i/Developer

2000(Forms 6i, Reports6i, Workflow Builder 2.6) on HP

Unix

Roles/Responsibilities:

> As a Technical Consultant, was responsible for design

and development of interface to bring the data from

legacy system to Oracle 11i.

> Developed new interfaces to load the legacy data sets

from various inventory compiled into one Master

inventory file using SQL*Loader.

> This file contains table structure of the Oracle Open

Items Interface API tables. Any data not meeting

Oracle's requirement loaded into error table

> Developed interfaces to populate legacy data from

various staging tables of telesales Module to Oracle

base Tables using the Standard API

"AS_OPPORTUNITY_PUB".

> Developed MD70 documents for item and Open

Opportunity Conversions.

> Worked on Interfaces for Inv module to insert data

into MTL_SYSTEM_ ITEM_INTERFACE table.

Project Oracle 11i Implementation: Oracle RMA - Order Flow: Return with

Approval - OM Workflow and SLW Bills of Material WIP

Loop Report

Duration April 2005 - June 2005

Client LSI -Logic, US

Position Oracle Apps Technical Consultant

Environment Oracle Applications11.5.9 (BOM, WIP, OM), Oracle 8i, Reports

6i, Workflow Builder 2.6

Roles/Responsibilities:

> As a Technical Consultant, was responsible for

developing customized objects like Reports, Workflow,

Packages, and interfaces.

> Developed Reports to list the WIP Jobs in addition to

the BOM where a loop in encountered.

> Developed Data Conversion for Items

> Customized the OM Order Workflow to populating the

Line Level DFF of the RMA with the DFF Information

entered on the Original Sales Order (Shipment) along

with the Original invoice number.

> Registered the RMA workflow as a Runnable object.

> Assigned the new Custom RMA Flow generic workflow to

the Transaction Type- RMA.

> AOL set up like registering the Executables,

Concurrent Programs, assigning in Request Groups and

Run the Request from corresponding responsibility.

> Customized existing Oracle Reports and developed new

Alerts

Project Oracle 11i Implementation: Dresser Conversion

Duration May 2004 - MAR 2005

Client Dresser, US

Position Oracle Apps Technical Consultant

Environment Oracle Applications11.5.9 (INV, AP, PO), Workflow Builder 2.6

Roles/Responsibilities:

> As a Technical Consultant, was responsible for

developing customized objects like Reports, Workflow,

and Packages.

> Developed new interfaces to load the Purchase Orders

legacy data from the legacy systems (CINCOM, MAS200,

BPCS) into Oracle for four Locations viz.

Wayne/Austin Production, Wayne/Fremont, Wayne/Austin

Service, Wayne/Service Group.

> developed data validation scripts to validate the

purchase order data loaded into Oracle

> Developed new interfaces to the load the Item from

legacy system to Oracle interface tables.

> developed data validation scripts to validate the

Item data loaded into Oracle.

> Developed new Interfaces for all open Invoices in

legacy system and load them in to Oracle

> Customized PO Approval workflow.

> MD70 documents for item, AP Open Invoices and

Purchase Order Conversions.

> Worked on Interfaces for Inv module to insert data

into MTL_SYSTEM_ ITEM_INTERFACE table.

Employer: Chainsys, India.

Duration: May2002- April 2004

Project Oracle 11i Implementation

Duration May 2002 - April 2004

Client Jindal Vijaynagar Steel Industries

Position Oracle Apps Technical Consultant

Environment Oracle Applications11.5.9 (INV, AP, PO, OM), Workflow Builder

2.6

Roles/Responsibilities:

> As a Technical Consultant, was responsible for

developing customized objects like Reports, Workflow,

and Packages.

> Developed custom form to enter the Debit notes on the

employees

> Developed PLSQL Package to validate the debit raised

and call the workflow

> Handled 3 levels of escalation for the notification

generated.

> Worked with the client on Requirement gathering and

Integration testing

> Developed support documents as per AIM Standards.

> Developed Data conversion scripts for PO, Items.

Employer: Doorway systems, Trichy, INDIA

Duration: May2000 - April 2002

Project Oracle 11i Implementation

Duration May 2000 - April 2002

Client Doorway Systems

Position Software Engineer

Environment J2EE, Oracle Applications10.0.7 (INV, AP, PO, OM), Workflow

Builder 2.3, SQL, PL/SQL

Roles/Responsibilities:

> As a Developer, was responsible for developing

customized objects in J2EE

> Developed inhouse custom Forms and Reports

> Got Training on workflow Mailer Configuration,

Customizing seeded workflow using Workflow Builder,

Troubleshooting Stuck Email Notifications.

> Experienced on setup AOL objects DFF, Value set,

Responsibility, SYSADMIN

> Got Exposure on how to develop Functional and

Technical specification based on AIM Methodology.

> Developed custom packages, triggers, cursors and

Alerts.

> Worked on workflow Technical support team.

Contact this candidate