Oracle Project

Sara Mantha

Contact No: 310-***-****

aca4pd@r.postjobfree.com

Professional Summary:

Oracle Applications / OBIA Techno Functional Developer with over 8 1/2

years of experience on e-Business suite, 3 years on OBIA, 5 years of

OBIEE, about 10 years in the software profession. I have both Technical &

Functional experience in the 11i and R12 e-Business suite and OBIA. I have

strong background in systems conversion, systems design and implementation

of Oracle E-Business Applications and strong background on implementation

of OBIA Project. In addition, I also have experience in development of

custom interface programs to Oracle ERP, CRM Applications and the ability

to organize and manage multiple tasks in a fast-paced environment.

Summary of Experience:

> Expertise in Oracle Applications Releases 11i and R12

> Expertise on OBIA, OBIEE 10g and 11g

> Successfully completed OBIA project on oracle ERP supply chain modules

> Expert in OBIA financial ETL configurations

> Strong experience on OBIA DAC and Informatica

> Developed custom informatica mappings, workflows session

> Experienced with DAC Configurations

> Experience on running DAC ETL jobs.

> Successfully completed several full life cycle implementations of

Oracle Applications release 11i (11.5.10) and R12 (12.0.4)

> In depth knowledge of Oracle application modules Order Management(OM),

TCA, Inventory, Pricing, AOL and Sysadmin, Alerts manager, Account

Receivables(AR), Purchasing(PO), Account Payables (AP), General

Ledger(GL), Service Contracts.

> Strong experience in TCA, Conversions, Interfaces, Customizations

(Forms/Reports), Personalization, Extensions and Shell Scripting

> Experience in Conversions and Interfaces.

> Expert in developing Custom PL/SQL API's, new Reports, Customizing

Reports and shell scripts

> Experience in gathering Business requirements and providing flexible

and generic solutions.

> Developed interfaces between Oracle ERP/CRM and legacy systems

> Strong knowledge of Application Object Library (AOL) features

> Experience in Admin tasks like Creating Users, Responsibilities,

Menus, and Functions

> Strong knowledge of Application Object Library (AOL) features

> Expertise in writing Stored Procedures, Functions, Packages & Triggers

using SQL and PL/SQL.

> Company liaison OBIA implementation.

> Involved in OBIA Implementation supply chain and Order Management

analytics, Financial Analytics

> Experience with DAC and Informatica for OBIA Implementation

> Experience with analyzing OBIA ETL jobs

> Developed Customizations Product Management Objects for OBIA processes

> Experience with OBIEE 10g Admin Tool and Analytics.

> Developed OBIEE Reports / assigning users to BI Rpd, adding new

columns to business / logical / presentation layers

> Developed Oracle Reports, Oracle Discover reports

> Experience with BI-Publisher Report

> Error Handling OBIEE Reports - Tracking SQL scripts in OBIEE Analytics

> Implemented custom data ware house / Data mart for OBIEE Reports

> Experience with Development tools: OBIEE, OBIA, Oracle Discoverer,

Oracle Reports (versions 2.5 to 6i), SQL Loader, SQL, PL/SQL

> Conducting a Conference Room Pilot and documenting requirements

Technical Skills:

Application Software:

* Oracle Distribution: Order Management (OM) and Purchasing (PO)

* Financials: General Ledger (GL), Accounts Receivables (AR), Accounts

Payables (AP)

* CRM: TCA, Service Contracts

* Inventory, BOM, Pricing

* PL/SQL, Reports, Kintana, OBIEE 10g, OBIEE 11g, OBIA, DAC,

Informatica, Oracle Discoverer

Software, Tools & Languages, Database:

* OBIEE, OBIA, Oracle Discoverer, BI-Publisher, SQL*Plus, SQL*Loader,

SQL, PL/SQL, Oracle RDBMS 6.x to 8i, Toad, Tortoise CVS, Oracle Forms

4.5/6i, Reports 2.x/6i, DAC, Informatica.

Technologies:

* Hardware & Operating Systems

* HP-9000, Sun Solaris, Windows NT / XP, Unix, Linux, Oracle 11g

Database, Oracle 10g Database,

* Oracle Application 11.5.10, Oracle Application R12, OBIA, OBIEE,

Informatica, DAC

Environments:

* NT Server, MS Windows, SUN-Solaris

* PL/SQL, Excel

PROFESSIONAL Experience:

CLIENT: J and B Medical Supply INC

July 2013 - Current

. Supporting production OBIA project

. Worked closely on OBIA out of the box reports - OBIA analytics area.

. Good understanding and thoroughly referred OBIA out of the box

configuration documentations, data lineage documents

. Familiar with OBIA - OBAW tables, stage tables and target tables..

. Experience with Oracle Applications R12 OM, AR, INV, PO, AP, GL,

Oracle Financial Modules

. Created custom wrapper around AR Invoice creations using Interface

tables and AR adjustment creation

And customer creation using oracle API's

. Supporting Production support issues on Oracle Rebates, Oracle AR and

..etc..

. Build some custom procedure and views for online website usage

. Involved in tuning some Discover report views and BI publisher views

. Build some oracle Alerts using Alert manager modules for users

. Implemented better error logging methods in OM Order creation and AR

adjustment creation processes.

. Build custom reports on out of stock inventory modules.

CLIENT: Murad INC. - El Segundo, CA

Jun 2007 - Current

Responsibilities:

. Implemented OBIA Project - source of Oracle Applications supply

chain and financial, hands on experience 3 years

. Hands on experience on OBIA DAC configurations, Informatica

mappings, workflows and sessions

. Created custom ETL objects informatica and DAC level

. Worked closely on OBIA out of the box reports - OBIA analytics

area.

. Good understanding and thoroughly referred OBIA out of the box

configuration documentations, data lineage documents

. Familiar with OBIA - OBAW tables, stage tables and target tables..

. Currently supporting OBIA project - remotely

. Technically supporting on OBIEE 10g and 11g project since 5 years

. Build custom wrapper packages and procedure, functions for OBIEE

10g

. Involved in the implementation of Oracle Applications R12 OM, TCA,

INV and Pricing.

. Experience with Oracle Applications 11.5.10 OM, AR, INV, Pricing,

PO, Order-to-cash

. Created Custom Wrapper around Order Import API to validate Order

according to Business rules and call Order Import API to load into

Oracle tables.

. Developed Customer Interface to create new customers using Custom

Interfaces.

. Developed OBIEE Reports

. Developer and implemented BI-publisher report

. Designed, developed and implemented new reports to suit custom

requirement using Oracle Reports 6i in OM.

. Worked on customizing and creating several reports using reports

6i, Oracle Discoverer.

. Updating Price list and Pricing Modifiers / qualifies

. Good knowledge in creation and usage of price lists, pricing

modifiers / qualifies. Good understanding in functional area.

. Worked on various custom API's for unit testing and preparation of

test cases.

. Involved in club Member Order creation Interface program code

changes / updates and full production support on order process

. Support and troubleshoot applications for Business users.

. Worked on forms personalization in R12.

. Worked in custom pll in 11i

. Production support on Order imports process.

. UAT on new campaign test order process

. Involved in FTP and SFTP shell scripts code implementations

. Involved new order import process design with third party vendor

team and in- business meeting

. Involvement in assign Oracle users logins and responsibilities in

sys admin / Sales reps, alert notifications, AOL objects LOV, DFF

. Actively involved in verifying functional setups like in Item

Master attributes, Order transactions forms, Order forms, advanced

pricing / qualifiers / modifiers, customer standard forms, more

setups.

. Build custom responsibility for particular user group. Copied

existing OM menu and functions and restricted other objects from

standard features and build a new responsibility for users

. Production support on OM interfaces error, Customer Interface error

- daily.

. Implemented custom Data warehouse / Data mart for reporting.

. Developed a program to copy 11i orders and migrate and define

orders in R12 - Order import and customer imports. Used OM

interface and TCA Apis

. Developed codes on creating pre-scheduled orders in oracle systems

. Developed and implemented Item Swap / Sku swap OM Api for Backend

order situations for every 3 months.

. Supporting and Worked aas Business Analyst support more than 3

years

. Build custom views for third party Order systems / SQL Server

. Build table Indexes, tables, views, synonyms, grants, Materialized

views, procedures, functions, packages, concurrent programs, alert

notifications, explain plans.

. Worked under Multi-org environments

. Worked in Single Org Environments

. Involved in updating Pricing qualifiers / modifiers. UAT.

. Using Core FTP tool, putty, Leach FTP tools for data File

migrations.

. Good understanding on Business process on Order creation / customer

creation / promotions creations / freight charges flow, tax on

freight process, order-to-cash flow process.

. Involved in build Custom Source code / key values - design for

order behavior variations.

. Involved in AR process. Fixing Invoice print options. Supported AR

interface errors.

Environment: Oracle applications R12, Oracle Apps 11.5.10, OM, TCA, INV,

Pricing, AR, GL Oracle 9i, AOL, Reports 6i, Oracle Discoverer, OBIEE, OBIA,

Data ware house, Informatica, OBIEE DAC, UNIX, Windows NT, core FTP, PUTTY,

Leach FTP, SFTP.

CLIENT: ADP Claims and solutions - Bay area, CA

May 2005 - May 2007

Responsibilities:

. Developed custom Requisition Interface for Oracle Purchasing.

. Developed Customer creation interfaces for customer creations

. Build scripts for Data Extraction and Data files migration to FTP

servers

. Worked on Purchase Document Conversion project - 11i to 11.5.9

Oracle PO

. Involved in the implementation of Oracle Applications 11.5.9 PO,

AR, AP, INV and GL

. Designed, developed and implemented custom forms and reports using

Oracle Forms/Reports 6i in AP, PO.

. Support and troubleshoot applications for Business users.

. Migration of AOL objects and custom code using Kintana

. Customized standard User setup form using CUSTOM.pll

. Customization of standard Invoicing and Accounting rules setup form

using CUSTOM.pll

. Developed SQL reports

Environment: Oracle applications 11i and 11.5.9 PO, AP, INV, Workflow, AR,

GL, Oracle 9i, AOL, Forms 6i, Reports 6i, UNIX, Windows NT, Kintana

Roles

Implementation/Conversion Developer

Technical Consultant

Techno-functional Developer

Business Analyst

OBIEE Developer

Education:

Masters in Arts, Andhra University, INDIA

Post Graduate Diploma in Computer Applications, INDIA

Immigration status

American Citizen

Contact this candidate