We provide IT Staff Augmentation Services!

Oracle Ebs Techno-functional Resume

4.00/5 (Submit Your Rating)

Austin, TX


  • More than 15 years of experience in Relational Database, Client Server, three - tier technologies, Internet/Intranet technologies, oracle EBS and business application development for Telecommunication, Pharmaceuticals, Sports Goods and Manufacturing industries.
  • Over last 7 years of Oracle E-Business Suite R12 experience in custom development, functional and technical support.
  • Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, setups, work arounds, interfaces, user training.
  • Intermediate functional and strong technical knowledge of Oracle EBS Account Receivables (AR), Order Management (OM), Oracle Product Information Management (PIM), Oracle Payments, INV, GL, TCA, and EBTAX.
  • Convincing working technical experience in Oracle EBS AR, OM, PIM, TCA, EBTAX and GL of Interfaces, Tables, API etc.
  • Extracting data from Oracle EBS AR, OM, TCA, GL, Payment and EBTAX modules to Management team for analysis and decision.
  • Hands on Experience of Oracle Payments Setup for Paypal or any other customized payment setup with Oracle EBS Payment system, and strong technical experience for Oracle Payment Module Tables, views, Packages, API and custom integration.
  • Good and strong experience of Oracle EBS Order Management for using external system orders into the EBS by using Oracle Order Interfaces, APIs, setups and business logic before injecting into the Oracle EBS OM Modules.
  • Intermediate experience of Implementation and migration of Oracle E-Business Suite Application R12 both technical and functional knowledge of Oracle Product Information Management (PIM), Order Management and Trading Community Architecture (TCA).
  • Developed Oracle Forms and Reports by using Oracle DS10g to integrate with Oracle EBS R12 for user needs and requirements.
  • Strong in SQL Queries using Correlated Sub Queries, Multi-column Sub Queries, Scalar Sub Queries, Inline View Queries, MERGE, Regular Expression and Top N Analysis Queries.
  • Strong working experienced in PL/SQL programming (Functions, Procedures, Packages, Triggers, Indexes, Materialized Views and Database Objects etc.).
  • Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
  • Writing UNIX Shell scripts for batch processing and reports.
  • Strong hands on experienced in Migration of Oracle 8 Database into Oracle 9i Database including Forms and Reports. (Oracle Developer 2000 to Oracle Developer Suite 9i Web based).
  • Experienced in data migration using SQL * Loader and Import/Export.


Application: Oracle EBS Application R 12, AR, OM, TCA, EBTAX, PIM, GL, INV etc.

Database: Oracle 11g, 10g Rel. 2, 9i, 8i and MS Access 2000, SQL Server


Development Software: Oracle Developer Suite 10g (Form & Report Builder), Oracle DS 6i, and later.

Utilities: SQL*Loader and Import/Export. Data Pump 10g

Modeling Tools: ERWIN, Oracle Designer 6i, MS Visio 2003, Oracle BI Publisher

ScriptingUNIX Shell Script (K Shell):

Other Tools: Quest SQL Navigator, TOAD, PL/SQL Developer, and Oracle SQL Developer


Confidential, Austin, TX

Oracle EBS Techno-Functional


  • Production Support for Oracle EBS Order Management, Account Receivables, Product Information Management, EBTAX and TCA Modules.
  • Troubleshoot bug and data issues through debug or oracle FND debug utilities tan open ticket internally or open service request to get halp from oracle support for Oracle EBS issue.
  • Involved and fixed some issues after upgrading the EBS 12.1.2 to EBS 12.1.3 version.
  • Monitor and clear the Order Interface errors, AR Interface errors, Return Receiving errors and AR Receipt batches.
  • Developed the custom return processing by using of Oracle EBS OM, AR, RCV API e.g. Order Import, INV Receiving Interface, AR Receipt API e.g. Unapplied/Applied, AR transaction API and AR Refund Activity for payment by using IBY API.
  • Enhanced the custom order program dat process WEB and POS from SQL Server for different projects e.g. Zero Cost, Hub Store, and Used Club Market Place and so on by the using of PL/SQL Packages, procedures, tables and views.
  • Designed and developed new item master program for newly merged company dat populate data into tables from Oracle PIM for Item Physical Attributes, User Defined Attributes (UDA), Variant Attributes, Categories and Association etc.
  • Developed custom reports for AR, OM, PIM, TCA, Oracle Payment modules by using Oracle Reports and BI Publisher.
  • Developed and modified some forms e.g. Order Entry Forms for Phone Orders, Rebate Form for Finance, Price Changes form etc. by using Oracle Forms 10g.
  • Experienced in Oracle Payment Modules for Functional and Technical Support like Paypal and Credit Card processing.
  • Developed AR - Write-Off Program dat clear the AR transactions Customer Balances by using PL/SQL packages54.
  • Customized Order Workflow to by-pass the Pick/Ship and AR for Retail Cash N Carry Orders.
  • Involved in the team discussion and working with Manager for task estimation and proof of concepts.
  • Lead the Off shore team for Production Support and Enhancement tickets for Oracle EBS AR, OM, TCA and PIM Modules.

Environment: Oracle EBS Application R12 (12.1.3), Oracle 11g Database (, PL/SQL and SQL, Windows 7, PL/SQL Developer.

Confidential, Austin, TX

Oracle Developer


  • Involved in the setup and configuration of Oracle E-Business Suite (EBS) Application R12 for Product Information Management (PIM), Order Management and Customer TCA Modules.
  • Developed mapping of Old Oracle Apps (R11.0.3) to New Oracle Apps R12 for PIM, OM and Customer Information.
  • Retrofitted and developed custom database packages, stored procedures, tables, view and functions to integrate with Oracle EBS R12.
  • Developed and designed the product module for Web (.COM) and Point of Sales System (POS) to provide the Style and SKU items from Oracle Apps R12 PIM system, by using of packages, tables, views, materialized views, synonyms, sequences, functions, indexes and database triggers in Oracle 11g.
  • Designed and developed the processing of Orders from WEB/POS system for OLD format (Oracle Apps R11.0.3) to new format (Oracle EBS Apps R12), database for old format SQL Server and New format in Oracle database 11g. This module TEMPhas New Tables, Packages, data loading & mapping.
  • Worked on the high level architecture and detailed design of the application.

Environment: Oracle EBS Application R12, Oracle 11g Database (, PL/SQL and SQL, Windows XP, PL/SQL Developer.

Confidential, Irvine, CA

Sr. Oracle Database Developer


  • Involved in the designing and development of B2B E-Commerce application by using of Oracle 10g Rel. 2.
  • E-Commerce apps developed in multiple environments (Development, System Integration, User Acceptance, Quality Assurance, Production and Maintenance)
  • Responsible for technical analysis of specifications, identification of data elements, normalization of data as per functional, technical and performance requirements.
  • Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
  • Created and maintained database objects like tables, views, materialized views, synonyms, procedures, functions and database triggers to meet the business requirements.
  • Involved in the project releases on Production and work with DBA to implements DB objects scripts according to the requirements.
  • Developed the Data Pricing Interface (DPI) which is used for loading of external files into Oracle DB by using SQL*Loader and shell script.
  • Developed Batch processes in UNIX shell scripts for processing of business needs by using of PL/SQL and SQL.
  • Developed and implemented the Oracle Advanced Queue (AQ) for the solution of Sync-up of data with using of DB Triggers.
  • Developed and used Dynamic SQL’s in the package and procedure for publish functionality between two schemas.
  • Tuned and Analyzed SQL queries through proper joins and rephrase the queries and build Indexes where as needed according to Explain plan, statistics and reduced consistent gets in the environment of Terabyte Databases.

Environment: Oracle 10g Database (, PL/SQL and SQL, UNIX SUNOS 5.9, Windows XP, Quest SQL Navigator, Toad, MS Visio and ER Win. K Shell Scripting.


Sr. Oracle Developer


  • Maintaining and supporting Confidential Sales & Distribution System by using of Oracle 8 and Oracle 9i.
  • Secondary responsibilities include support and maintenance of ongoing sales and distribution system.
  • Developed initial design of database and normalization using ErWin regarding logical, physical design and reverse engineering of the database.
  • Developed strong SQL Queries for analytical reports using with Correlated queries, sub queries, multi columns sub queries, scalar sub queries, Inline sub queries and TOP N analysis.
  • Used regular expression and merge statement regarding data validation and wild card search patterns.
  • Used advanced PL/SQL to create database stored procedures, functions and triggers.
  • Developed and customized the screens and reports layouts by using Oracle Forms/Reports 9i.
  • Dynamic LOV, Programmatically Record Group handling, Multiple Forms and MDI applications with multiple windows and canvas interfaces, Security Features using Menu Roles.
  • Designed highly complicated Reports using all important typical features of Reports 9i like PDF reports, Placeholder & Formula columns, conditional Report Layouts, Group filters etc.
  • Developed Interface for SAP and ERP-BPCS IBM / AS400 regarding loading of Sales Data through text files from SDS.
  • Developed and Implemented the Audit Trailing on Sales and Distribution system by using DB Triggers and DB object Type.
  • Experienced on migration from Oracle 8 to Oracle 9i, both database and frontend (forms and reports) as well.

Environment: Oracle 9i Database (, Oracle 9i Developer Suite (Forms Builder and Reports Builder), Oracle 8 and Oracle Developer 2000 Rel 2.1 (Forms and Reports) Builder, Window98 and Windows XP, Toad and ERWin.


Oracle Developer


  • Analyzed, developed and maintained Oracle Forms and Reports for newly designed Marketing information System (MIS).
  • Involved in developing Logical and Physical Data Models by using of ERWIN and MS Visio
  • Development included using the security access from the MIS system on user login and different menus for different access levels.
  • Interacted with end-users and business analysts to identified and developed business requirements and transform it into technical requirements.
  • Developed different modules of MIS regarding Field Force Expense, Chemist Club and Sales by using of Oracle Forms 5.0 and Reports 3.0
  • During the development used PL/SQL procedures, functions, packages and triggers to fulfill the business needs.
  • Creating and manipulating various database objects and their maintenance. Performing some DBA tasks, variety of duties such assisting and creating users, database import/export, backups, data transfer within the company sites, data reading sales and fixing errors, ensuring smooth performance of the system.
  • Heavy interaction with users, make them understand the use standard and management reports
  • Worked with team members to share functional and technical knowledge.
  • Extensively loading of external CSV Sales files from distributors into the database by using of SQL Loader scripts.

Environment: Oracle Developer 2000 R2.1 (Forms 5.0 and Reports 3.0, Oracle 8.0.4 Database, MS Visio and ERWin.


Oracle Developer


  • Involved and participated in the development of Human Resource and Management System for different clients and it is the sub module of MERLIN-ERP ( Confidential Enterprise Resource Planning)-ERP system on Oracle 8i and Oracle 6i.
  • HRMS system halped to store personal information of the employees as well as other details like promotions, increments, enhancement courses, experiences and other details for generating various MIS reports.
  • Developed and maintained the system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL.
  • Worked as a team member and had a separate individual development of reports.
  • Made character based reports and laser or bitmapped based reports according to the requirement from clients by using of Oracle Report Builder 6i.
  • Developed enquires, financial reports, group wise and matrix reports using Report Builder.

Environment: Oracle 8i Database, Oracle Developer 6i (Forms 6i and Reports 6i). / Windows 98 and Win NT 4.0

We'd love your feedback!