SUMMARY

• Over 12 Years of Experience in IT and 11+ years in Oracle EBS and Fusion cloud implementation and Enterprise Applications Practice with proven experience in Developing, Customizing and Supporting Oracle Applications (11i & R12), AOL of Oracle E - business Suite. These include Analysis, Design, Development, and Implementation of different projects for applications based on Relational DBMS, and in the field of Oracle e-business Suite.
• Good Expertise in developing applications using SQL, PL/SQL, Database Triggers, Stored Procedures, Oracle 10g/9i/8i/8.0.5/7.x and Developer 6i and 10g.
• Worked on Fusion Cloud (R13) OTBI reports and Oracle Fusion Cloud BI reports.
• Worked on Oracle Fusion Financials and Fusion Procure to Pay and Order to Cash cycles.
• Experienced in oracle fusion cloud implementation procurement and financials.
• Knowledge on Data warehousing technologies. Involved in Data warehousing testing and used RightData Comparsion tool.
• Expertise in RICEW (Reports, Interfaces, Conversions, Extensions and Workflow).
• Highly proficient in requirements gathering, business systems study, technical solution design, and system document preparation using AIM methodology
• Good Expertise in functionality of Accounts Receivables (AR), Accounts Payables (AP), General Ledger (GL), Oracle Purchase Order (PO), Oracle Order Management (OM), Oracle Projects (PA), Oracle Inventory (INV), Bill of Material (BOM), Work in process (WIP), Costing, Oracle HRMS, Oracle Service Contracts (OKC), Install Base, Master Data Management (MDM) Oracle Configurator and Oracle Application Object Library (AOL).
• Functional knowledge on Cash Management (CM) module.
• Good Expertise in developing automated processes using Oracle Workflow 2.6 /AME
• Good Knowledge in developing self service applications using Oracle Application Framework (OA Framework) using Oracle Jdeveloper 9.0.3/10g.
• Good Expertise in Query and Performance tuning in Oracle.
• Extensive experience in conversion of legacy data into Oracle Applications using SQL Loader and PL/SQL.
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Extensive Experience in using Oracle Application Object Library (AOL) features including implementation of Flexfields (Like Implementing Cross Validation Rules, Implementation flexfields in reports, Security rules), creating and scheduling of Concurrent programs etc.
• Experienced in Full software development life cycle implementation (SDLC).
• Extensive experience in design and development of applications under UNIX and Linux environments.
• Setup and Configured applications to support client requirements.
• Good Expertise in TCA (Trading Community Architecture).
• Good functional expertise on Open Interfaces (Includes both inbound and outbound interface) in Oracle Manufacturing and Financials.
• Experience in E-R Modeling to create Data Models both Logical and Physical design using ER Win.
• Experienced in working with Huge Datasets comprising of at least greater than 10 Mill records.
• Competent in Tuning the SQL and PL/SQL Procedures by enforcing HINTS and OPTIMISER and by using SQL Trace, Explain Plan and TKPROF Tools.
• Exposure to data support on Multiple Environments like UAT, SIT, INT, INT2, Training, and Production Environments on an Enterprise Level. Responsible for data consistency and integrity across the board.
• Enthusiastic to learn new skills with a shorter learning curve.
• Excellent Communication, Good Work Ethics, and a Team Player.

TECHNICAL SKILLS

ERP: Oracle Applications Release 12, 11i, and Release 10.7.

Modules: Oracle Inventory (INV), Oracle Purchasing (PO), Oracle Order Management (OM), Oracle Work in Progress (WIP), Oracle Payables (AP), Oracle Receivables (AR), Oracle General Ledger (GL), Oracle Projects (PA), Oracle iProcurement and Oracle iExpense and TCA

Others: Oracle Application Object Library (AOL) and Oracle System Administrator (Sysadmin), Oracle Workflow version 2.6 and Oracle XML Gateway, Data warehousing Tool

Primary Skills: Oracle Apps Techno functional

Databases: Oracle 11g, 10g, 9i, 8.x/7.x/6.x, SQL Sever (v7.0).

Development Tools: Oracle Developer - Forms 10g/6.x/5.0, Reports 6.x/3.0/2.5 Oracle Discoverer 4i, 3.0, Oracle JDeveloper 11g, Workflow 2.6.3

Programming Languages: Core Java, SQL, PL SQL, HTML, XML, WSDL

Operating Systems: Windows 2000, Windows NT, Windows 98/95, UNIX, Sun Solaris, AIX, HP-UX, IRIX.

Hardware: Intel Based Servers and Workstations, HP DEC Alpha, DEC VAX.

Case Tools: Oracle Designer 2000

Version Control Tool: PCVS, DELL STAT, SVN and Microsoft Visual studio, GITHUB

Tools: TOAD, SQL-Navigator, SQL Loader, SQL Developer and Pl/Sql Developer

Scripting: ksh/ C shell

PROFESSIONAL EXPERIENCE

Confidential

HNI and Walls Integration Architect

Environment: RICE Elements, Linux Scripting, SQL, PL/SQL of Oracle 12c, Developer 12C Oracle Developer (OAF Personalisation, SOAP UI, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME, Oracle Cloud BI Reports, Fusion OTBI Reports

Responsibilities:

• Working as an Oracle EBS/ERP Cloud Architect.
• Worked as an Oracle EBS Cloud Developer and developed OTBI Reports.
• Experienced in implementing fusion oracle cloud procurement and financials setups.
• Worked on Oracle Cloud BI Publisher Reports.
• Responsible for technical objects design and development in Oracle EBS.
• Worked on Oracle WebADI and uploaded payables invoices.
• Customized and built oracle workflows and business events.
• Developed RICEW objects, XML Publisher Reports, Integration Objects in OM, AP, AR, PO, GL, HRMS, WMS, Inventory, and Shipping modules.
• Worked on Picking and shipping outbound bound interfaces in WMS.
• Developed inbound and outbound data interface/integration experience between Oracle and 3rd party systems using standard APIs.
• Responsible to fixing the issues in Test and PROD environments.
• Co-Ordinating with Offshore folks and arranging client meeting if they required any.
• Making the require code changes and migrating the objects if business wants to fix on any object on urgent basis.
• Customized Oracle Configurator workflows for both ATO and PTO configurations.
• Troubleshooting long running jobs and assisting on the performance tuning.
• Working on forms personalization’s, customizing the report objects, XML reports, and using Custom and Standard APIs.
• Expertise in using the Bitbucket, Flex deploys, Microsoft Visual Studio, SVN, PVCS and Kintana tools for version control and migrating objects from instance to instance.
• Working with Oracle Support Team and get the fixes for Oracle standard bugs.

Confidential

Computer Programmer

Environment: RICE Elements, R12.2.5, 11i, UNIX Scripting, SQL, PL/SQL of Oracle 11g, Developer 10g Oracle Developer (OAF Personalisation, SOA, BPEL, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME. Discoverer 10g

Responsibilities:

• Developed AR Auto invoice open interface
• Developed Sales Order shipping confirmation alert using Oracle Business Events.
• Worked on AP unpaid invoice report.
• Worked on install base open interface.
• Retrofitted objects of PO, OM, AP, AR and GL in accordance to 12.2.5 standards.
• Developed/Retrofitted AP check printing program according to R12.
• Developed Expenditure extraction outbound interface.
• Developed/Retrofitted AP check printing program according to R12.
• Worked on supplier extraction outbound interface and transmitted the data to third party systems using secured file transfer protocols.
• Developed a script to update missing credit receiver’s information in Oracle projects
• Worked on Project transaction client extensions.
• Worked on project accounting expenditure report.
• Customized Invoice print report in AR module.
• Co-ordinated with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.
• Worked on Oracle purchasing requisiton and Maximo interfaces.
• Developed UNIX shell scripts
• Expertise in using the SVN, PVCS and Kintana tools for version control and migrating objects from instance to instance.

Confidential

Oracle Techno functional consultant

Environment: RICE Elements, R12.2.2, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 11g, Developer 10g Oracle Jdeveloper (OAF Personalisation, SOA, BPEL, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME., Discoverer 10g

Responsibilities:

• Worked on PO Print Report.
• Worked on Project transactions extensions.
• Worked on ACE and Oracle Interface
• Worked on ACE Information Report.
• Developed Inventory item Outbound interface.
• Developed discrete job routing with MIS information report.
• Developed sales order extraction outbound interface and transmitted the data to third party systems using secured file transfer protocols.
• Developed Intercompany report in Oracle Order management.
• Developed on Project commitment report.
• Worked on project accounting expenditure report.
• Worked on OAF customizations in Oracle Order Management module.
• Worked on duplicate project report.
• Developed the OAF customizations in Customers pages which are changed from Forms to OAF.
• Co-ordinated with offshore team in compiling the custom forms and reports in 10g which are developed in 6i.
• Co-ordinated with offshore in retrofitting other module objects.
• Involved in arranging the sequence of objects for migration activities.
• Expertise in using the PVCS and Kintana tools for version control and migrating objects from instance to instance.

Confidential

Oracle Apps Technical

Environment: RICE Elements, R12.2.5, 11i, UNIX Scripting, SQL, PL/SQL of Oracle 11g, Developer 10g Oracle Jdeveloper (OAF Personalisation, SOA, BPEL, Web services), XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME. Noetix, Discoverer 10g

Responsibilities:

• Developed AP Invoice Open Interface
• Worked on outbound pull the information from Oracle systems and provided to SAP
• Worked on Out bound interfaces and integrated the Airgas systems.
• Worked on couple of scripts by pulling the customer information, item and supplier and fixed assets information and provided to Airgas system.

Confidential

Flowserve Oracle Apps Techno functional

Environment: RICE Elements, R12.1.3, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:

• Developed functional and technical specifications as well as test plans and test scenarios using AIM methodology.
• Gathering User requirements and implement them in the best possible way and document the process.
• Experienced with P2P and O2C cycles.
• Defined the Qualifier and Modifier setups in pricing module.
• Automated Employee vendor Bank Account in synch with Payroll Bank Account for Electronic payment.
• Worked on Invoice prepayment report.
• Customised AP EDM Invoice Report.
• Customised I-Supplier Self serviced pages to capture Bank Account Details.
• Developed INBOUND and OUTBOUND Interfaces based technical specifications.
• Developed custom reports (including BI Publisher) in Financial Modules based on user requirements.
• Configured descriptive (DFF) flex fields for storing custom information.
• Developed, Personalized & Configured through Oracle Forms, Oracle Reports, Oracle Workflow, Oracle ADI, Oracle APIs, Fast Formulas, Oracle 10g, PL/SQL, UNIX for Writing registration Scripts for Application Object Library objects, also used FND LOAD to migrate object from one instance to another.
• Post production maintenance for the conversions and interfaces in Oracle Applications.

Confidential

Computer Programmer

Environment: RICE Elements, R12, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:

• Preparing MD070 documents based on MD050.
• Experienced with P2P and O2C cycles.
• Gathering User requirements and implement them in the best possible way and document the process.
• Done the Configuration for GL, AP, AR, and Cash Management modules as per the client needs.
• Interact with third Party vendors like Citibank to setup them as Vendors in Oracle AP module and process invoices, electronic payments for these Vendors.
• Designed Technical Designs for RICEW elements based on Functional Specs.
• Projects Expenditure Transactions Process.
• Developed INBOUND and OUTBOUND Interfaces based technical specifications.
• Developed custom reports (including BI Publisher) in Financial Modules based on user requirements.
• Implementing Forms personalization.
• Internal Sales Order/Internal Requisition process was Configured to establish a simplified Intercompany sale across operating Units
• Developed custom self serviced pages using Oracle Jdeveloper.
• Development of Custom Packages, Procedures and Functions in ERP. Involved in Performance Tuning of the SQL Statements to reduce the process time. Conducted Business meetings for the Project plan.
• Writing registration Scripts for Application Object Library objects, also used FND LOAD to migrate object from one instance to another.
• Developed shell scripts to automate the processes using Autosys scheduler.
• Post production maintenance for the conversions and interfaces in Oracle Applications.

Confidential

Oracle Apps Technical

Environment: RICE Elements, 11i,, UNIX Scripting, SQL, PL/SQL of Oracle 10g, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:

• Oracle Apps Technical Consultant for support and m aintenanc e project.
• Involved in the day-to-day activities of production support of Oracle applications environment in AP, PO, OM, INV, AR, iExpense, iProcurement and GL.
• Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/reports/forms and updating the ticket with the appropriate information.
• Work on the development activities as part of issue resolution. Perform Unit Testing, Migrate to next environments, assist user testing and closing the tickets.
• Support includes the transaction integration for Sales Orders, Purchase Orders, and Customer Returns etc. Setup related integration for Items, Vendors, and Customers etc.

Confidential

Ingersoll Rand Oracle Techno Functional

Environment: Oracle 9i RICE Elements, 11i, UNIX Scripting, SQL, PL/SQL, Developer 6i/10g Oracle Jdeveloper (OAF, SOA, BPEL, Web services), Oracle Jdeveloper Extensions, XML Publisher, Forms Personalization, SQL*LOADER, Shell script and Oracle Workflow Builder 2.6/AME.

Responsibilities:

• Worked as team member in the team.
• Developed RDF reports and XML publisher reports.
• Exclusively worked on WMS module and integrated Oracle EBS systems with third party system by developing Inbound and Outbound interfaces.
• Developed and customized on Oracle interfaces by using third party applications like SOA and Web Methods.
• Registration of Concurrent Program Executables, Concurrent Programs, Parameters, Value Sets, Request Sets.
• Worked on Picking and shipping Outbound Interface.
• Developed Internal Requisition Interface by using XML gateway.
• Developed on Debit and Credit Memo Invoice Report.
• Customized on Oracle Supplier and Supplier sites Reports.
• Developed custom Inventory material transactions error XML report as per my client requirement.
• Migration of AOL and Non AOL objects from one Instance to another Instance by using Kintana tool.

Confidential

Environment: Oracle 9i, Oracle Apps 11i, Developer 2000, SQL, PL/SQL, Unix, Brio, HTML, Word, MS SQL Server, Windows NT and Data Loader.

Responsibilities:

• Worked as Oracle apps Technical Consultant.
• Extracted data from existing data source by using SQL, PL/SQL, and UNIX.
• Created tables, views, procedures, SQL scripts.
• Worked on On-hand quantity conversion
• Worked on Data loading activities using Data Loader tool.
• Physical and Logical Database Backups. Export/Import Tables.
• Developed forms using Forms 6i using advanced GUI features like pop-ups, stacked canvasses etc.
• Designed & developed reports using Oracle Reports, SQL, PL/SQL.
• Requirement gathering and analysis.
• Implementation of new organizations.
• Development of inbound interface.
• PL/SQL packages, procedure and function creation and modification.
• Enhancing requisition approval workflow by adding new nodes and attributes in requisition workflow.
• Creation of attributes, processes, functions, roles, messages, Notifications in using Oracle workflow builder.
• Carrying out testing from Req creation to invoice creation.
• Analysis of impacted reports including PO print rdfs.
• Providing Support on Postproduction issues.