*
Following is the Profile of Our Oracle Application Developer,KIndly E-Mail
[email protected] for the same ( 972-636-8600)
Name:VR
Location:OK
Relocation:Open
Availability:Immediate
SUMMARY
*
* *
· Over 7years of IT experience as Oracle Applications
Techno-Functional consultant.
· Strong background in conversion, customization, and development of
interfaces for *OM/OE, PO, INV, AR, AP, GL modules*, with strong knowledge
of *AOL and Sys Admin* such as defining value sets, assigning
responsibilities, creating request groups, and defining users.
· Strong knowledge of *Order-to-Cash (O2C)and
Procure-to-Pay(P2P)*cycles including the data flow and functionality.
· Expertise in Design and Development of *RICE
(Reports,Interfaces,Conversions and Enhancements).*
· Expertise in writing Stored procedures, Packages, Database
Triggers and Functions using PL/SQL.
· Worked with Business team for creating Technical (*MD070*) design
document for *AR, AP, OM* Modules.
· Expertise in *TCA (Trading Community Architecture).*
· Experience in data conversion from legacy systems to Oracle
Applications.
· Expertise in *customizing and developing new modules for Oracle
Applications using PL/SQL, Developer 2000 (Forms 4.5/ 6i, Reports 2.5/ 6i),
and PL/SQL, Forms Personalizations.*
· Experience working on *XML Publisher.*
· Experience in Unix Shell Scripting.
· Technical expertise well augmented by excellent analytical,
problem solving, communication, and interpersonal skills, with the ability
to deliver innovative and profitable solutions well within timeframe and
budgets.
* *
*SOFTWARE SKILLS*
· *ERP Modules: *Oracle Applications 12i/11i Order
Management OM, Oracle
Purchasing PO, Accounts Payables AP, Accounts Receivables AR, Inventory INV
General Ledger GL, Application Object Library AOL, System Administration,
Oracle Workflow.
· *Interfacing Tools: *Developer/2000* – *Oracle Forms 10g/6i Oracle
Reports 10g/6i, SQL*Loader, SQL Navigator, TOAD, Oracle Discoverer.**
· *RDBMS: *Oracle 10g/9i/8i.**
· *Operating Systems: *Windows 7, Windows Vista, Windows XP, Windows
NT, Windows 2000, Windows 98, UNIX, HP-Unix, Linux.
· *Languages: *SQL, PL/SQL, HTML, JavaScript, Shell Scripts.
· *Others:* MS Office.
* *
*Retalix, Dallas, TX **
Feb’10- Current*
*Oracle Applications Techno Functional*
*Responsibilities:*
- Involved in *Creation and Customization* of Order Entry, Order Booking,
Reservation, Pick Release, Pick Confirm, Ship Confirm, Enter Invoice and
Close order in *Order to Cash* *(OTC)* cycle.
- Customized *Order Management* reports like Orders by Item Report,
and Order
Discount Summary/Detail report using BI/*XML Publisher*.
- Customized the standard reports Payment batch control report and
Payment Schedule report in *Accounts Payable (AP).*
- Designed and created the MD70s for various Inbound and Outbound
interfaces, Extensions, Conversions.**
- Designed and Developed Staging tables, Data Conversion SQL Loader
Program and *Custom PL/SQL API* to import the Customers using
*TCA*(Parties, Party Sites, Party Accounts, Party Account Uses) Item
Revisions,
Open Sales Orders* *etc., from legacy system.
- *Customized and modified the existing forms* using Form builder
according to the requirement of the Business user.
- Designed and developed staging tables, Custom PL/SQL API have to
load Suppliers,
Supplier Sites, and Supplier Contacts* *from legacy system to *Purchasing
*.
- Worked on Auto Invoice Interface and imported invoices from legacy
system to Account Receivables *(AR).*
*Environment:** *Oracle Applications R12 (AR, GL, PO, INV, OM), Reports 10g,
Forms 10g, Toad, SQL Loader, XML Publisher.
* *
* *
*Citizens Bank, RI**
Dec’08- Jan’10*
*Oracle Applications Techno Functional Developer*
*Responsibilities:*
· Customized standard Invoice on Hold report and Invoice Aging
report in *Accounts Payable (AP)* module as per the client requirements.
· Assigning reports and programs to various user responsibility
groups in applications
developer GUIs.
· Customized Customer Open Balance Letter Report in *Accounts
Receivable (AR)* module using oracle reports.
· Created temporary tables, indexes, sequences, triggers, procedures
and functions using PL/SQL.
· Developed, implemented and unit tested *AP Invoice interface*.
This involved importing data from the legacy system into staging tables
using SQL Loader, validating the data using PL/SQL procedure, inserting data
into interface tables and running the invoice import concurrent program to
load the data into oracle AP tables.
· Used Oracle Application Object Library (AOL) features like Value
Sets, Descriptive Flex fields, Concurrent Programs, Profile Options,
standard request submissions (SRS) and parameters in the process of
development.
· Worked on importing Legacy Journals into General Ledger
using *SQL*Loader,
GL Interface and Journal Import.*
· Designed and developed staging tables, Conversion routines (SQL
Loader Scripts), Custom PL/SQL API’s to load Banks, Bank Branches, and Bank
Accounts etc* *from legacy system to *Payables*.
*Environment:** *Oracle Applications R11.5.10 (AR, GL, PO, INV, OM), Reports
6i, Forms 6i, Discoverer, Toad, SQL Loader, XML Publisher.
*Cypress Semiconductors,Dallas,TX
June’06- Nov’08*
*Oracle Applications Technical Developer*
*Responsibilities:*
* *
- Converted flat files from Excel to Data files and developed the
SQL*Loader program to load the data to staging tables for Order Import
program to import orders. Wrote packages to validate and populate the
interface table.
- Customized existing custom Oracle reports to replace plain text output
to PDF format using *XML Publisher*. Worked on *XML Publisher* bursting
to send PDF reports via email.
- Created new reports and Customized the standard reports in *Accounts
Payable (AP*) like Suppliers report, Invoice validation report.
· Developed Reports using Discoverer, Created business areas, custom
views, new folders, conditions and joins based on user requirements.
· Performed various Sys Admin responsibilities such as defining and
registering concurrent programs and subsequently assigning them to their
respective Request Groups.**
- Interacted with end users to gather requirements and draft
specifications for the development phase.**
- The development includes the interface and conversion of the data from
legacy systems to the oracle database and customizing reports for the
client.
- Defining Values Sets, Parameters, registered reports and concurrent
programs in applications.
- Responsible for writing of *technical design MD-70*.
- Designed and Developed necessary *feeder system* i.e. staging tables,
validation routines using SQL* Loader, SQL and PL/SQL procedures.
- Worked on customization of various reports using Discoverer.
- Developed, implemented and tested *Vendor interface* to import vendor
information from legacy system into Oracle Application tables. This involved
importing data from legacy system into staging tables using SQL Loader and
using the PL/SQL procedure validating the data and inserting into PO Vendor
tables.
*Environment/Tools: **Orale E-Business Suite (EBS),* Oracle Applications 11i
AR, AP, OM, INV, Oracle9i, TOAD, PL/SQL, SQL*LOADER, Reports 6i, Forms 6i,
Workflow builder.
*Genesis Systems, Hyderabad, India
Dec’03
March-‘06
*
*Oracle Applications Technical Developer*
*Responsibilities:*
· Create PL/SQL Stored Procedures, Functions and Packages and
Triggers to implement
business rules into the application.
· Developed *SQL queries and PL/SQL stored procedures* to get the
customer orders.
· Used Toad to Extract and test the data in the database.
· *Create and modified existing forms* for new Business rules.
· Design the form for data entry based on customer requirement.
· Created database objects such as tables, views, synonyms, indexes,
sequences and database links.
· Developed database triggers to enforce security.
· Developed concurrent programs for the *conversion* of customer
data from legacy systems to oracle receivables.
·
Environment:
*Oracle 9i, SQL, SQL*Plus, PL/SQL, WindowsNT/97, UNIX, Forms 4.5
*
--
You received this message because you are subscribed to the Google Groups
"ORACLE DWH DBA" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/oracle-dwh-dba?hl=en.
