Oracle Sql
Resume:
Havish
Email id # *****@**********.***
Summary:
Over 7 years of Oracle Applications experience in Design, Setup, Configuration, Development, Conversions, Customizations,
Interfaces, Implementation of business applications using Oracle ERP, Client/Server, EDI and Internet Technologies. Over 5 years
of R12 experience with 2 full cycle R12 implementations with all major modules (Financials and supply chain). Well experienced in
application development tools, specifically Development and Customization of Oracle Financials & Oracle Manufacturing
Applications (OE, BOM, WIP, INV, Purchasing, AR, AP, GL, AOL, System Administration, Alerts).
Expertise:
1 Experience in development using Oracle ERP technology (Oracle-Business Suite Application, Oracle Reports & XML
Publisher Reports, Workflow Builder and Oracle Application Framework).Exposure to backend system using PL/SQL with
Relational databases such as Oracle 9i, 10g.
2 Experience in Oracle Applications Modules – Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL),
Order Management (OM), Oracle Inventory (INV), Oracle Purchasing (PO), Work in Progress (WIP), Oracle Pricing
(QP), iProcurement, System Administration, Application Object Library (AOL) and Bill of Material (BOM).
3 Detailed knowledge on Order to Cash (O2C) and Procure to Pay (P2P) transactional flows with experience in related
setups.
Work experience in Oracle Customer Relationship Management ( CRM) modules- Oracle Contracts and Services, Oracle
Billing and Oracle Projects.
Expert in custom Form Development and form Personalization.
Generated Reports in XML Publisher in different modules.
Experience in Development, Customization of RICEW (Reports, Interfaces, Conversions, Extensions and Workflow)
Objects, Concurrent Programs, Application Programming Interfaces (APIs) and creation of Technical Design Documents.
Extensive Experience in development of Conversions, Open Interfaces, Concurrent Programs and Request Sets.
Design and development of Interface/Conversion programs to import data from legacy systems and integrate it into Oracle
Applications using open interfaces and APIs.
Excellent knowledge of Flex fields and Multi-Org.
Extensive Experience in Implementation and Product development of Oracle Applications.
Perform Production support activities for Oracle R12 Application.
Expertise in OA Framework customizations in R12, XML & Discoverer reporting strategy with hands on experience.
Excellent development and customization experience using Oracle R12/11i, SQL*PLUS, PL/SQL, SQL*Loader.
Expertise in Preliminary System Requirements Study, System Analysis & Development, Test Plan Preparation, Unit
Testing, System Integration testing and documentation.
Strong knowledge of Application Object Library (AOL), Trading Community Architecture (TCA) and knowledge of
System Administrator activities.
Proficient in writing PL/SQL Packages, Stored Procedures, Functions, Database Triggers, SQL * Loader scripts and shell
scripting.
Responsible for design and development of Interface Programs.
Worked on writing technical design documents for conversions, extensions, interfaces, reports and Troubleshoot issues,
including creation/follow-up of Oracle service requests (SRs).
Responsible for development of Data Conversion Scripts.
Preparing both Functional and Technical documentations like MD50, MD70 based on requirements.
Responsible for Fit-Gap analysis and documenting the Fit Gap documents. Analyzing the Gaps and fixing the Gaps
which also need coordination with Oracle Support.
Worked on Error Handling System in storing all the errors that occur during interfacing and loading data from Flat Files.
Written several PL/SQL packages to validate the data in the process of data conversion.
Responsible for performing systems analysis and application configuration on the Oracle ERP application.
Extensive knowledge in analyzing business process and identifying opportunities for improvement.
Support team members and help to troubleshoot application issues and develop creative solutions to support business
needs.
Tuned the application code using the Tkprof, SQL Trace and Explain Plans.
Page 1 of 8
4 Experienced in Baseline, Integration, Installation, Business Functionality, Performance, Regression, System, User
Acceptance, and Volume & Stress Testing manually.
5 Used Bulk Collect feature to improve performance.
6 Experience in UNIX Shell Scripting, XML, HTML, VBScript and Java Script.
7 A good team player and a quick learner adaptable to new technologies.
8 Interact with people at all levels; possess excellent communication skills, problem solving skills and work ethics.
9
10 Technical skills:
11
Languages C, C++, PL/SQL, SQL, .NET, JAVA, Java Script
ERP Oracle Applications R12/11i, RICE
Application Modules GL, AP, AR, PO, OM, INV, BOM, WIP, OFA, AOL, Sys Admin, AIM, iProcurement
Database Oracle 10g/9i/8i, SQL Server 2000
Operating Systems Windows XP/NT/2000/98, Unix, Linux, Sun Solaris
Packages MS-Office 2007
GUI Reports 6i/10g, Forms 6i/10g, XML Publisher
Reporting Tools Discoverer 9i/10g
Source Control Visual Source Safe (VSS)
Other Tools Toad, SQL *Developer, SQL *Plus, SQL *Loader(Export/Import), Work Flow Builder,
WinSCP, Reflections, File Zilla
Web Technologies HTML, XML
Summary of Projects:
12 JPMorgan Chase &Co, Houston, TX
13 Nov 2011 – till date
14 Oracle Applications Technical Developer
15 JPMorgan Chase & Co. is the name of the holding company and the firm serves its customers and clients under its Chase
and J.P. Morgan brands. This company is a leader in investment banking, financial services for consumers, small business
and commercial banking, financial transaction processing, asset management and private equity.
16
17 Environment: Oracle Applications Suite R12 (AP, AR, GL, iProcurement, INV, PO and AOL), Reports 10g, Forms 10g, XML
Publisher, SQL*Plus, TOAD, SharePoint, LINUX and RDMS 11g.
18 Responsibilities:
19
Worked on Financial modules like (GL-General Ledger, AP-Oracle Payables, AR-Oracle Receivables, CM-
Cash Management and FA-Fixed Assets).
Worked in preparation of AIM (Application Implementation Methodology) documents for Functional and
Technical specifications of Interfaces and Reports customizations.
Experience in developing custom Oracle Forms using Oracle Forms 10g.
Involved with business users in the process of recognizing revenue by Revenue Accounting in Account
Receivables (AR).
Setting up of the Options – Purchasing / Receiving / Financials.
Provide solutions based on business requirements.
Implemented interfaces to a third party application using application API’s. These interfaces where used to
provide seamless access to a third party application from within our application. This resulted in utilizing the
processing abilities of another application without modifying it or redeveloping it.
Responsible for preparing implementation strategy for smooth implementation of Oracle Applications,
preparing process flows, preparing implementation documents, specifications, Business Requirements
documents, Functional Mapping Documents, Module Limitation documents and Functional gap
documents. Constructed a Design Document for present state and future state.
Page 2 of 8
Experience in developing inbound and outbound Interfaces for Oracle General Ledger, Accounts
Receivables, Purchasing and Inventory modules.
Trouble shooting in critical issues in AR, GL and AP Modules in R12 environment.
Setup Project users, Setup roles, role lists, project roles for orgs. Setup Project and Organization security,
responsibility, role based security. Setup Project security extension. Setup Task statuses, task types and
priorities.
Worked on R12 AP Payment process changes.
Used TOAD for application development. Registered Forms and Reports using AOL.
Strong knowledge in Development and Customization of Forms/Reports with sound understanding of
Application Object Library (AOL).
Developed reports and customized standard Oracle reports using Report Builder 10g, Discoverer and
BI/XML Publisher.
Migrated data from legacy system to Oracle Apps using standard API’s and PL/SQL procedures.
Used the System Administrator responsibility to create users, responsibilities, Value Sets and Request Sets.
Designed customer conversion strategy, data mapping and development using API’s.
Extensively used DBMS, UTL packages and collections to develop PL/SQL code.
Worked with Customer Interface in Oracle Receivables to load multiple addresses and Multiple Contacts for
customers.
Zoom feature is enabled using custom.pll, and whenever user in sales order form clicks the zoom button. It
displays the discount amount calculated for that order basing on the payment terms of the order.
Developed several PL/SQL packages, procedures, functions, triggers from UI events or database triggers, to
implement complex business logic.
Modified and created new concurrent programs as well as executable files when new reports were created.
Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the
daily and historical tables.
Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility)
Raising Oracle TAR's (P1, P2, P3) and worked for solving the problems.
Handling functional issues related to Oracle Accounts Payables and Oracle Purchasing related to Requisition,
PO, Invoice, GL, Receipt, etc.
Designing and development of custom interfaces in the Oracle AR and Oracle AP.
Trouble shooting the Reports10g and Discoverer issues in R12.
Imported Invoices from various feeds into Oracle AP using standard interface process.
Did testing and documentation of the reports.
20
21 Safeware Insurance, Columbus, OH
22 June 2010- Nov 2011
23 Oracle Applications Technical Developer
24 Safeware is one of the most recognized providers of comprehensive insurance policies and extended service plans for
a variety of product lines. Safeware is a full service insurance agency and warranty administration facility. Our
insurance products are underwritten by Fortegra Financial Corporation.
25
26 Environment: Oracle Applications Suite 12i (AP, AR, GL, OM, QP, PO, INV), Reports 10g, Forms 10g, XML Publisher,
SQL*Plus, TOAD, SQL*Developer, Discoverer 10g and UNIX.
27 Responsibilities:
28
Responsible for implementation of Order Management, Account Payables, Account Receivables, General
Ledger, Oracle Pricing, Oracle Purchasing and Inventory.
Worked on Oracle Order to Cash (O2C) cycle.
PL/SQL procedures and functions necessary for Purchase Order validations before loading records into
Purchase Order Interface tables.
Modified the Oracle reports, SQL reports, PL/SQL programs for changes in Payables and General Ledger
module tables.
Using XML publisher, Sales order Acknowledgement Report have been developed and also customized AR to
GL Reconciliation Report.
Page 3 of 8
Created flex fields as required in the forms of various modules like AP, AR and GL.
Developed a report, which showed requisition details, purchase order details, receiving details, invoicing
details and payment details in Oracle Procure to Pay (P2P) Cycle.
Developed Mapping Documents and Conversion Program to validate Vendors and Account Payables Invoices
before loading into base tables.
Involved in developing the functional requirements and technical design documentation for OM and PO
modules.
Technical Design and Developed Data Conversion Scripts for CRM conversion objects (Service Contracts,
Systems and Installed Base).
Developed several custom reports as per the requirements of the users in Receivables and Payables. Such as
Credit Memos applied to invoice report, Receipt and Payment report by Receipt and check date sales by
category report.
Modified Invoice before Purchase Order report.
Developed Reports like Individual price list, Product Financial Analysis and Market compare list in Reports
10g.
Used Order Import to import data into Order Entry/Shipping for processing.
Worked on Payables Open Invoice Interface in AP.
Experience in creating master detail forms and adding alerts.
Worked on Data Conversions for Matched Open AP invoices and Open AP invoices in Accounts Payables.
Customized XML Publisher Pick Slip and Pack slip reports.
Developed Various Error Correction forms in the interface process. These forms are used in correcting the
error records in staging tables and interface tables.
Worked extensively to import sales orders to oracle applications using sales order conversion i.e., order
import interface.
Setting the System Profile options at Site, Responsibility and User level for INV& OM modules.
Involved in Interfaces to import Items from the Legacy System.
Extensively worked on RICEW objects to view, transfer and modify the data in the same or different system.
Developed new forms using Template.fmb (AU_TOP/forms/US).
Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, Explain Plan,
Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
Developed a package containing different procedures and functions using PL/SQL to cross validate invoice
information and load automatically invoices into auto invoice interface tables.
Diagnostics for troubleshooting application and SQL issues.
Involved in performance tuning of custom PL/SQL programs and reports.
Developed several PL/SQL packages, procedures, functions, triggers from UI events or database triggers, to
implement complex business logic.
Worked extensively with tools such as EXPLAIN PLAN, SQLTRACE.
Resolve crucial issues related to Accounts Receivables by coding customized PL/SQL programs to populate
the missed billing data in interface tables.
Coordinate with Business analysts, onsite and offshore team to complete deliverables.
Setting Up Auto Invoice.
Collecting the requirements from other organizations’ heads for Costing tool implementation.
Provide solutions based on business requirements.
Involved in Interface designing and Documentation and implementation of these as per AIM.
Migrated data from legacy system to Oracle Apps using standard API’s and PL/SQL procedures.
Analyzed existing elements for pre-conversion processing.
Performed data mapping for the Legacy Systems to Oracle and identified API’s needed for conversion.
29 Qwest Communications, Columbus, OH
30 Apr 2009- Jun 2010
31 Oracle Applications Technical Developer
32 Qwest Communications is a telecommunications company that offers services to telecom carriers, businesses and homes
using an extensive fiber-optic network throughout the U.S.
33
Page 4 of 8
34 Environment: Oracle Applications Suite R12 (AP, OM, QP, AR, GL, iProcurement, INV, PO and AOL), Reports 10g, Forms
10g, XML Publisher, SQL*Plus, TOAD, Oracle BI Discoverer 10g, SQL*Developer, SharePoint and UNIX.
35 Responsibilities:
Responsible for implementation in Order Management, Inventory, Account Receivables, Account
Payables and General Ledger, Purchase Order, Costing, BOM and WIP.
Developed code for Conversions to extract legacy journals and to load them to GL Interface tables using
Journal import.
Worked on Procure to Pay and Order to Cash Processes.
Built custom forms using Oracle Forms 10g Builder to fulfill the business requirements of the client.
Experienced in validation and defaulting, processing constraint checks and releasing order holds and
scheduling of shipments using Order Import interface on OE_ORDER_HEADERS_ALL,
OE_ORDER_LINES_ALL.
Populated data into table OE_HEADERS_IFACE_ALL which is a multi-org table for Sales Order Headers
Open Interface.
Worked on the customization of forms, which included development of new forms and customization of the
existing forms in Order Entry and Inventory, AP and PO.
Designed and developed a single interface program to import invoices into Oracle Payables from three
different sources and registered this as a single concurrent program which was used by these sources.
Involved in customization of several standard reports to serve important business processes very specific to
the client which include Invoice on hold report, vendor, payments, and analysis reports in AP, and also
Customer receipts, invoice, and adjustment reports in AR.
Used the features of BI Publisher such as Sort, Group, Total, Subtotals to make data intense operations
happen at the template level.
Created customer invoices, credit memos, debit memos and account credits using auto invoice interface in
account receivables.
Involved in Customer Conversion to load Customer details into HZ tables by creating staging tables and
performing validations and finally loading them in to base tables using TCA APIs.
Developed a report, which showed requisition details, purchase order details, receiving details, invoicing
details and payment details in Oracle Procure to Pay Cycle (P2P).
Developed data entry forms, complex and template forms in Forms 10g.
Developed control files to transfer data to staging table using SQL*Loader and validate the date for the
Standard Items in INVENTORY and load the data using item import interface to MTL_SYSTEM_ITEMS_B
table.
Extensively used of advanced PL/SQL concepts such as collections and bulk processing to achieve best
performance. These were used in large data conversion scripts, to process records within a procedure or
package before updating them to the database.
Tested Interface and conversion objects and trouble shouted many issues in testing phase and documented the
whole process to report to management.
Writing and review of functional and specs for purchasing objects including Purchase orders conversion and
Interface and PO Receipts Interface.
Developed RICEW development matrix to support cutover plan and project management planning and status
Reports to executives.
Enhanced performance of large complex SQL queries using SQL performance tuning methods such as
explains plan and hints. Based on the results of explain plan, appropriate Index were created and joining
clauses used.
Designed and Developed Custom Reports for Quote to order Conversion, Closed PO Report, Sales Analysis
Report, etc., using Discoverer 10g.
Involved in design and testing of RICEW objects from Purchasing, Project Accounting, Inventory,BOM and
AP.
Preparation of project plans, estimates and other technical documents.
Resource allocation to the project.
Communication with other units like Finance, Corporate Services, Collaboration Units for requirements
gathering for new customizations.
Define functional requirements and develop functional and Technical design for custom modules.
Preparing both Functional and Technical documentations like MD50, MD70 based on requirements.
Provide solutions based on business requirements.
Page 5 of 8
Setting up of the Requisition Templates/Document Types – Blanket PO/Freight Carrier etc.
Setting up Payment Terms, Transaction Types & Sources, Standard Memo Lines, Accounting & Invoicing
Rules.
Defining Shipping, Picking – Defining Pick Slip, Grouping Rule, Defining Release Sequence Rule, Container
Load, Carrier Ship Method, Freight Cost Type.
Setting up of Customers, Customer Profile Classes.
Setting up Payment Terms, Transaction Types & Sources, Standard Memo Lines, Accounting & Invoicing
Rules.
Coordinate with Business analysts, onsite and offshore team to complete deliverables.
Provide solutions based on business requirements.
Customized Print Requisition Report by adding one more field Accounting_Id description only then End User
may identify under which the Account is distributed.
Involved in Interface designing and Documentation and implementation of these as per AIM.
Analyzed existing elements for pre-conversion processing.
Performed data mapping for the Legacy Systems to Oracle and identified API’s needed for conversion.
Responsible for Fit-Gap analysis and documenting the Fit Gap documents. Analyzing the Gaps and fixing
the Gaps which also need coordination with Oracle Support.
Perform data conversion and provide data validation support during data conversion.
Support team members and help to troubleshoot application issues and develop creative solutions to support
business needs.
Developed appropriate systems and user documentation to support deployment of applications.
Bentley Systems, Covington, LA
May 2008 - Apr 2009
Oracle Applications Technical Developer
Bentley Systems provides software solutions for sustaining infrastructure on wide variety of fields like plant design engineering.
Bentley’s mission is to empower its users to leverage information modeling through integrated projects for high-performing
intelligent infrastructure.
36
37 Environment: Oracle Applications 11i (GL, AP, OM, INV and AR), Reports 6i, Forms 6i, BI/ XML Publisher, SQL*Plus, TOAD,
SQL *Developer, Discoverer.
38 Responsibilities:
39
Responsible for of General Ledger, Account Payables, Order Management, Oracle Inventory and
Account
Receivables.
Interacted with users and analyzed their requirements to develop custom code, forms and reports as per
their need and registered with application.
Developed Interface Anonymous PL/SQL blocks for loading Orders to Oracle Order Management tables
and importing the Orders using standard API program, Order Import.
Worked on customization of reports such as AR Customer Invoice Report, Pack Slip Report, Open Order
Report and Purchase Order Report.
Responsible for the technical design, program development, unit testing and migration of AP Invoice
Interface.
Defining Shipping, Picking – Defining Pick Slip, Grouping Rule, Defining Release Sequence Rule,
Container Load, Carrier Ship Method, Freight Cost Type.
Customized the following workflows: PO Approval Workflow: Implemented notification reminder and
Timeout needs for the PO Approval workflow PO Account Generator Workflow.
I have got good exposure in different technologies like Oracle SQL, PL/SQL, Oracle Applications and
Oracle Forms.
Interface programs for AR Customers and OM Open Sales orders were written using API and used
extensively to import the data into base tables.
Created custom packages and procedures using PL/SQL in AR, OE and PO and registered under the
concurrent.
Developed conversion program to load AR invoice transactions.
Worked on Employee, Assignments, Addresses, Phones, Contacts, Payment Methods and Salary
Conversions along with their history using API’s and PLSQL Scripts.
Page 6 of 8
Extensively used PL/SQL to implement cursors, triggers and packages and to develop stored procedures,
functions and critical reports.
Used TOAD, SQL Developer and SQL Navigator for code development, executing queries.
SQL Performance tuning was done using Explain plan, correct Index creation, Analyzing table stats and
creating the right data model.
Developed dynamic SQL Scripts within the procedures to create process specific SQL statements. This
ensured that SQL generated was optimized for the options selected for that process. This has greatly helped in
the performance of the application.
Used Oracle SQL loader to load large group client’s information provided in a formatted text file to the
database.
Interacted with clients understanding the operational requirements, troubleshooting data and application
issues, reporting bugs and following it up to resolution.
Creation of new responsibilities and new menus based on the type new report and form customizations.
Preparation of Technical Documents MD 50, MD70, Install guides and User Manuals.
Define functional requirements and develop functional and Technical design for custom modules.
Writing Technical specs based on functional specs on various Interface and conversion objects inclusive
of Account Payables, Purchasing and Project Accounting.
Performing Quality reviews and Code reviews and Debugging Activities.
Interface designing and Documentation and implementation of these as per AIM.
Computer Sciences Corporation (CSC), Noida, India
Dec 2005- Apr 2008
Oracle Technical Developer
Computer Sciences Corporation (CSC) is an American multinational corporation that provides information technology (IT) services
and professional services. CSC is a global powerhouse in business and technology transformation.
Environment: Oracle Applications 11i (OM, AP, INV), SQL, TOAD, PL/SQL, SQL * PLUS, SQL *LOADER, SQL*Developer,
Forms 6i and Reports 6i.
40 Responsibilities:
41
Created Custom reports using
Reports 6i.
Created stored procedures,
Packages, Functions and triggers using SQL & PL/SQL.
Involved in user meetings
regarding integration of Oracle Applications with the existing Legacy systems.
Developed Program to load
item information coming from legacy systems using SQL * Loader and PL/SQL.
Handled various custom reports
and customized standard Oracle reports like Vendors on Hold Report, Employee Listing as per the business
requirements.
All the security roles and
privileges are stored in the database tables and the logic is implemented using functions and views. Promoted
the security feature to the existing reports with a very minor code change in the actual reports.
Required Data Extraction from
oracle applications base tables in a flat file format using UTL_FILE package.
Development of new reports
using Reports 6i and SQL*Plus. Extensively used several Oracle supplied packages for the different types of
report and data extraction.
Designed and developed
Interfaces using PL/SQL and SQL*Loader and UNIX Shell Scripts, to load the data into Oracle Applications
from legacy systems.
Performance Tuning:
Analyzing, tuning and optimizing for Oracle Server Applications by using performance monitor.
Worked on Error Handling
System in storing all the errors that occur during interfacing and loading data from Flat Files.
Page 7 of 8
Mapping documents MD 70 are
developed by looking MD 50 documents using AIM methodology.
Education:
Bachelors in Computer Science, JNTU, India.
Page 8 of 8
Contact this candidate