Highly-skilled software development professional bringing more than  years in software design, development and integration. Advanced knowledge of Oracle EBS, SQL,PLSQL
Linux Shell Scripting
Oracle Forms Report Builder
Oracle Workflow Builder
Oracle EBS 11.5.10 - 12.1.3
Oracle EBS Consultant, 06/2013 to Current VMWare Inc. – Palo Alto, CA
Developed account receivable (AR) Reports for the deposit
checks, cash receipts. Migrated
Customer Data (Customers, Sites, Uses and Contact information) from
legacy system to Oracle EBS TCA Architecture in Multi- Organization
environment using Sql*Loader,
PL/SQL and API's. Defined
Modifier and Qualifier to give customer discount based upon
customer category and product category in Advanced Pricing. Create Apex
triggers for different functions of the application including database
and report triggers Loaded
Purchase Order and PO Receipt data to Oracle EBS using Sql*Loader, Custom API's. Created Single
signed used login page for oracle EBS users using oracle apex page. Developed
MS Excel feeds using Discoverer
Reports for Revenue Recognition
and various other requirements and creating views for analytical reports
using PL/SQL. Developed PL/SQL packages for
generating XML files from oracle database using PL/SQL, and UTL_FILE. Acquired
a thorough knowledge about the latest and most widely used accounting
guidelines VSOE, BESP etc. Worked
in the Integration project of Service and Subscription Extension Process. Onsite
– offshore coordination. Wrote PL/SQL Programs/Libraries (Stored Procedures, Functions & Packages).
xml publisher reports for PO printing,
Invoice Printing, AR Statement and Check printing using XML/BI Publisher.
Defined business areas, queries/Views/Materialized
Views and Defining security for user and multi organization using Discoverer Administrator/Desktop/Plus
Customization as per business requirements through CUSTOM.pll and Form
Journals data into GL_INTERFACE
table using SQL*LOADER and Web ADI and run Journal Import in oracle
Applications. All interface programs are designed to run as concurrent programs.
various Key Flex fields for Item Master, Descriptive Flex Field (DFF) and
Value sets for all the above custom processes and Reports based on the
business requirements. Involved
in defining the AP/GL/ AR Lookup Codes, Profile options etc. to satisfy business
Oracle EBS Consultant, 12/2012 to 06/2013 Crossbeam Systems – Boxborough, MA
Tree type menu and tied to oracle
apps responsibilities using oracle Apex.
with business Users to collect requirements and converting into functional
data conversion from legacy system to oracle EBS using PL/SQL and API's.
Install Base and Service Contract Data from legacy
system to Oracle application EBS using
Sql*Loader, PL/SQL and API's.
Qualifier to exclude service renewal
from discount in Advanced Pricing.
few reports for Inventory
transactions, order management and Service Contract with drill down capability
using Oracle Apex.
Executables, Programs, Custom responsibilities, DFF, Value sets, Attachments,
Document Types, Custom Profile and Custom Application.
Service Contract workbench using Service contract API, Oracle Forms, Report,
custom QA Check Programs and PL/SQL.
Install At locations, Marketing location, Contact persons and contact points
for customers from Legacy System in TCA and multi-organization environment using Sql*Loader,
PL/SQL and API's.
XML/BI Publisher reports for Service
Sales Quote, Service Contract Welcome Package, Check Printing, Packing Slip,
Pick Slip, Bill of Landing, AR Invoice, Consolidated AR Invoice Report, AR
Aging, Customer Statement, AP Invoice Aging, Commercial Invoice, Purchase
Order, Traveler Receipt, Sales Order acknowledgement, WIP Discrete Job Report,
Inventory Value Report etc. using XML/BI Publisher.
AR Auto Invoice pre-processor to import data from Other sources and recognize
revenue into different buckets. Designed a custom
package to import sales orders from external system into Order Management using
Order Import API/Open Interface. Customized OM
workflow to add export compliance check functionality and apply hold before
like Buyer, vendor, Payment Options , Bank/Bank Branches. etc.
Oracle EBS Consultant, 01/2012 to 11/2012 SafeXpress Pvt. Ltd – New Delhi, India
Involved in OU
(Operating Unit) rollout Project in Oracle Application EBS R12. Involved in
setups for Customers, ship-to address, bill-to address, ship-to contact,
bill-to contact and customer
Legacy Customers and Vendors data into Oracle EBS using SQL Loader and API. Created new APIs for synchronizing DFFs with Accounts Payables
Distributions. Involved in
PO Setups for Buyer, vendor and MOAC etc.
Defined variable Descriptive Flex
Fields for INV, PO, AP and AR) and created values set. Wrote Server side PL/SQL Programs (Stored
Procedures, Functions & Packages) and Object libraries.Created functional and technical
design documents for Reports.
and customized various Reports using Oracle Reports10g.
scripts using standard APIs to create Parties(Person, Organization), party
sites, Locations, customer, customer site and site uses.
custom package to import Purchase orders from legacy system into purchasing
base tables by executing Import Standard Purchase Orders program.
Requirements gathering and UAT.
Oracle EBS Consultant, 06/2011 to 12/2011 Access InfoTech Pvt.Ltd – Chandigarh, India Developed new reports and customized existing reports as per business requirements
(formatting, addition/deletion of columns, formulas etc.) in Oracle Financials
as per the requirement of business processes. Designed a
custom package to import sales orders from external system into Order
Management using Order Import program.
Created Single sign-on page for oracle EBS users using oracle apex.
oracle alerts to provide information to business users with details of sales
orders stuck in Standard interface tables
custom package by executing Import Standard PO to import Purchase orders from
legacy system into purchasing base. Customized Forms
as per business requirements using CUSTOM.pll and Form Personalization
reports for sales invoice printing,
purchase order printing, Stock report, Salary register, Costing report etc. using
report 6.0 and PL/SQL.
and designed Materialized View/Complex Queries/Stored Procedure/Functions /
Database Triggers etc.
design (MD50) as per Oracle AIM methodology.
Publisher reports like AP Invoice Aging,
Consolidated AR Invoice Report, Check Printing, Check Printing etc.
Oracle EBS Consultant, 02/2010 to 06/2011 SQL Star International Ltd – Hyderabad, India
in customization of AR reports (Dunning Letter, Invoice, Billing and
Payment History and AR Statement)
Using reports 6i. Developed
custom interface program for data loading from legacy system to GL_INTERFACE Table using PL/SQL and Forms6i.
to register reports in AOL and attaching to the required Responsibilities.
and developed custom forms for legacy system using Oracle Forms6i.
and customized reports for Print Invoice, Discounts Taken and Lost Report, Payment Register, Purchase Requisition
Report, Purchase Order Report.
business areas, custom folder, reports using Discoverer Admin and Desktop
and developed custom reports for Order
Management as per specific needs.
views for analytical reports using PL/SQL.
Package for monthly salary calculation using PL/SQL and convert data
into excel sheet using TEXT_IO/UTL_FILE
Oracle EBS Developer, 06/2009 to 02/2010 Swaraj Mazda Ltd – Chandigarh, India
Reports like (RFQ Report and Purchase
Order Report, Aging -4 Bucket, 7
Bucket Report, Dunning Letter and Invoice Print).
Payable open interfaces program for loading invoice data into AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE Tables.
legacy data to Oracle Application database 9i Using PL/SQL, SQL Loader and API's.
some transactional/analytical reports using
and developed interface for data extraction, transformation, and loading to the
Oracle application (GL_INTERFACE)
from legacy system using SQL*Loader,
reports for Sales Order and Sales
representative Order Acknowledgement
Developed ad-hoc and dynamic SQL for reporting and data validation purpose
using SQL, PL/SQL.
Un-invoiced Receipts Report and Supplier on Hold Report in Purchasing
Provided 24X7 supports to users of
various levels for month-end, quarter-end and year-end activities, and worked
closely with Oracle support as and when needed.
Developed few views/materialized views
for analytical reports using PL/SQL
Bachelor of Science: Computer Science, 2009 Rajiv Gandhi Technical University - Bhopal, India