Rohan Patil Oracle Apps Techno Functional

Phone: 651-***-****

: abpprw@r.postjobfree.com

Resumes ID: 48992

Location:, California

Posted: 04.13.2012

Resume Details:

SUMMARY –

Rohan is a member of the functional focus team and about 7 years of IT experience, with a primary concentration on Oracle ERP/CRM implementations and business process re-engineering projects. He is a Techno Functional Consultant specializing in Oracle Application, specifically Financials and Distribution module. His extensive Technical experience has given her an insight into the interactions between Oracle’s modules and project implementation methodologies. His business experience and background have helped to foster a detailed knowledge of best practices regarding the development Process of the Oracle e-Business suite system.

Over 7 years experience in IT industry which includes experience in Accounts Receivables (AR), Accounts Payables (AP), I-Expense, i-Procurement, General Ledger (GL), Purchasing (PO), Oracle Order Management (OM), Inventory (INV), AOL and System Admin and integrated custom applications.Experience with Oracle User Productivity Kit (UPK) and Oracle Tutor.

Extensive experience with the Revenue Recognition Process in AR Module

He is extremely skilled on Procure to Pay as well as Order to Cash business flows.

He has extremely good communication and interpersonal skills, experience with dealing with all levels of Business Users.

Extensively worked on Designing documents (MD.050, MD.070, MD.120, CV.040, CV.050, CV.060) using AIM methodology and developing code for RICEW (Reports, Interfaces, Customization/Conversions, Extensions/Enhancements, Workflow) using oracle technologies.

Experience with process analysis, process design, mapping, process/software gap analysis, troubleshooting and issue resolution while Oracle Applications module implementation and use, test script creation, user training programs, post-implementation support and documentation and demonstrated to interact with end user independently and resolved issues.

Extensive experience in developing / designing Oracle applications extensions / enhancements, reports using, conversions, interfaces, Workflows using Oracle Forms and Reports (4.5/6i, 10g), Workflow Builder, Discoverer, SQL*Plus, PL/SQL, SQL*Loader, PRO*C, TOAD, XML Publisher, Data Load Pro.

Expertise in new implementation as well as tweaking existing code for conversions /integration of Legacy System to Oracle Applications. Worked extensively in developing PL/SQL Stored Procedures, Functions, Triggers, Packages, Interfaces and data Conversions using SQL * Plus, TOAD and SQL* Loader and having strong knowledge of inbuilt PL/SQL APIs and libraries available in Oracle E-Business Suite modules.

Extensively worked on Order-To-Cash (OTC) modules implementation and enhancements. Wide experience in Oracle TCA (Trading Community Architecture) model and in inter-relationships between Parties, Customers, Suppliers, Employees.

Very good exposure of UNIX / Linux / MS Windows Operating System environments and Possessed very high level experience in creating UNIX Shell Scripts for file / process manipulations and shell scripts for installation/migration of the RICEW.

Experience in SystemAdministration activities (FND, AOL) like defining / assigning responsibilities, value sets, flex fields, forms personalization, reports customization, managing concurrent programs, printers and providing support to Apps end users.

Gained experience in Performance tuning using tools like Explain Plan, TKPROF and CEMLI for to improve performance of various custom PL/SQL Packages developed.

TECHNICAL EXPERIENCE:

ERP

Oracle Financials (10.0.7, 11.03 and 11i) –

i-Procurement, i-Receivables, iExpense, Oracle Accounts Payables, Oracle General Ledger, Oracle Purchasing, Oracle Federal Financials, Oracle Order Management and Oracle Accounts Receivables

Oracle Selling Point 4.2

Scheduling Software

APPWORX

Databases

Oracle 8.x/7.x, Working Knowledge of MS SQL Server

Tools/Utilities

SQL, PL/SQL.

Developer 2000 Oracle Forms 4.5, Oracle Reports 2.5, (Forms 5.0, Reports 3.0).

Developer 6i (Forms6 and Reports6).

Oracle Workflow.

Oracle Discoverer.

SQL * Loader.

Oracle Export / Import utility.

Languages

PL/SQL

Basic, Cobol, Html, Working Knowledge of Java.

Case Tools

Designer 2000

PROFESSIONAL EXPERIENCE –

Client Name: AEES, San Antonio, TX AUG 2010 – TILL DATE

Project Name: Oracle e-Business Suite Roll Out of Release 12.1.1

Role – Techno Functional Consultant

AEES designs, validates, and manufacturers complete electronic / electrical distribution systems for the automotive and the commercial transportation markets. These systems include wire harness assemblies, distribution centers, connectors, terminals, and other related components.

Worked as Techno functional Consultant in implementation of Oracle Applications 12.1.1. Involved in implementation of OM, GL, Advance Pricing, PA, AP, AR, INV and PO. Involve in RICEW Design and Development for conversion / Integration of 65 different legacy systems in the scope of project.

Responsibilities:

Involved in process analyzing & scoping business requirements, architecting solutions, configuring and testing for implementation of OM, QP, GL, AR, PA, AP, INV, PO

Designed MD070, MD.120, CV040, CV050, CV.060 using AIM methodology. Involved in reviewing MD.050 belongs to O2C(Order to Cash) implementations and input comments/suggestions for technical solutions and feasibility of proposed requirements/solutions for the RICEW.

Designed MD.050, MD.070 and developed Code and Forms for Pricing Tally configuration and Lineal Foot Tally Configuration extensions for functionality of custom OM Configurator (Ordering items having Parent-Child Relationships).

Designed MD.070 and developed Custom Reports using XML Publisher and Report Developer for Quote Format, Customer Listing – Detail, Pick Slip, Yard Receipt and Sales Order Acknowledgement.

Developed Code and Form for Extension to create Special Order Item on the fly while user is on the sales order form without going to Inventory (INV) application.

Designed MD.070 and Developed code for an Extension to Maintain (Add / Update) Customers Quickly for Market Users (AR). It’s Oracle form for this extension allow to create Customer, Customer Accounts, Customer Contacts, Customer Addresses, Business Purposes, Contacts and roles for Address, Site uses, pay methods for customer, business purpose. It’s also allows to attach Customer Profile Class to the customer and Bill to Site uses.

Modified existing Customer Listing –Detail Report (AR) using Report Builder as per the requirements and used it to generate XML output, which is consumed by XML Report Builder template (.rtf) to generate the formatted report.

Worked on Revenue Recognition in Oracle AR module. Worked on a customization around the Revenue Recognition process to add business rules as to when revenue can be recognized.

Worked on all of the Item Conversions, Item Catalogs, Item Categories, Item Templates, Item On hand Balances.

Designed specification and developed Extension to define Price Matrix (based on Price Plans and Price Levels for the hierarchy of different markets) in Advanced Pricing (QP) and another extension (Get custom price) for margin and non-margin items which uses this Pricing matrix to get custom price on sales order form as per pricing formulas defined in Advanced Pricing (QP) for margin based items and non-margin based. This functionality implemented using DFF (Descriptive Flex Fields) and standard formula building functionality within Advanced Pricing with supporting PL/SQL Package.

Designed CV.040 for Project Expenditures Conversion (PA) written code for validation rules, Default rules, and customization, attribute compatibility and did functional setup for to define transaction sources and specified the processing rules for each transaction sources entered in PA_TRANSACTION_INTERFACE_ALL table.

Created DataLoad template for Conversion of Blanket Sales Agreements (OM), Employee/Vendor, Expenditure (AP, PO, HR), automatically using DataLoad Pro utility.

Designed Technical Document (MD.070) for margin threshold (QP)Extension, Import Quote to Sales Agreements(OM Extension), Weights for sales order lines and Total Orders(OM Extension), Defaulting Rules (OM Setups), Packages/Sub-packages(OM Extension)load price list(QP) received from vendor in MS Excel, using WebUtil functionality of Oracle Forms.

Designed CV.060 for Conversion of Open Bids (OM). Price Lists (QP), Employee & Buyer (PO, AP, HR), Customers (AR) and items, Item Costs and Quantities (INV).

Environment: Oracle E-Business Suite Release 12.1.1, Oracle DB 10.2.0.3.0, Load Runner, Win Runner, Quality Center, QTP, Windows XP, UNIX, Ms-Office

ROSENDIN Electricals, San Jose, CA MAY 2008 – JUL 2010

Oracle Applications Release 12i Upgrade from 11.5.10.2, Production Support and Business Process Re-Engineering

Role – Techno Functional Consultant

Worked as a Techno functional Consultant in upgrade of Oracle Applications from 11.5.10.2 to 12.0.3. Involved in entire implementation life cycle of GL, AP, AR, INV, PO, QP, OM, WSH modules. Involved in Data conversions from legacy systems to Oracle.

Responsibilities:

involved in process analyzing & scoping business requirements, architecting solutions, configuring and testing the Accounts Receivables(AR), Order Management(OM) and Advanced Pricing(QP) modules.

As a team member of Order-To-Cash implementation (OTC) team Involved in to Create interface for to process files received by EDI (Electronics Data Interchange).

Prepared accounting period closing activity guideline for closing, AR, INV to ensure all the journals are posted in GL and closing balance of accounts updated appropriately in GL before closing GL.

Created Pricing list and Formulas for Various Items and enabled in Advanced Pricing (QP).

Created SQL scripts to create staging tables and prepared SQL*Loader control files to load data into AR interface tables from flat files received from Legacy System.

Prepared PL/SQL to load the inventory data from flat file to staging tables, validate it and transfer it into Oracle AppsINV interface tables.

Worked on Revenue Recognition Process in AR Module

Developed several revenue reports pertaining to Revenue Recognition process in AR Module.

Involve in Implementation/Setup of the PO module by interacting with the client to understand user requirements.

Worked as ad-hoc Technical team lead to collect, manage and allocate work to developers and represent the development status report to management.

Created PL/SQL package to populate PO Requisition Interface table to import requisitions received from EDI.

Developed custom programs to import data from legacy system to GL base tables GL_JE_HEADERS, and GL_JE_LINES.

Worked on Consolidation Workbench (GL) to setup Chart of Accounts (COA), Map / prepare / transfer / combine / analyze consolidated data.

Customized PO_Approval workflow to implement changes in business process.

Imported the bulk of Journal Entry Transactions into GL_INTERFACE table and successfully created the Journal Entries in GL.

Developed PL/SQL scripts to validate Invoice data against constraints in Invoice base tables in Apps while importing it from legacy system.

Worked on Forms, Reports and Workflow customizations as per the requirements of client.

Created a UNIX shell script for to take cold backup of oracle data files and registered this script as concurrent program and assigned it to a responsibility.

Worked with Oracle Discoverer 10g in creating ad hoc reports for end users. Involved in the creating Business Areas, Custom, Complex

Created custom report in OM, AR, INV and PO using XML Publisher and PL/SQL Package for to detail listing of Assets by Project in Oracle Fixed assets.

Environment:Oracle Applications R12 and 11.5.10, Oracle 10g, Oracle Developer Suite 10g, SQL*Loader, Jdeveloper, SOA, PL/SQL, TOAD for Oracle, LINUX, MS Windows 9x/2000/NT/XP, Discoverer 10g, Web server (Apache).

Client – Terra Graphics Environmental Engineering, Inc Kellogg, Idaho FEB 2007 - APR 2008

Oracle Applications 11.5.10.2 Implementation (US, Brazil, Spain and UK)

Responsibilities:

Extract Payment data and Run Lockbox Interface. Worked in Lockbox Execution report and Post Quick Cash Execution report to resolve errs. Responsible for providing the report form for reconciliation of AR Receipts payments.

Prepared documentation for Implementing Multiple Organization Support like defining Business group, Legal entities, Accounting SOBs, Operating entities, Inventory orgs. Define inter company relations. I had performed setup steps in GL for to enable MRC (Multiple Reporting currency), for that had Defined SOBs (Set of Books), Define Reporting currency, define reporting SOBs, Defined conversion options for different journal source applications, Assigned reporting responsibilities to user.

WroteTechnical Documents (TDS) for various custom reports and outbound interfaces developed in AP, PO, FA and AR modules.

Developed PL/SQL scripts to validate and load PA_TRANSACTIONS_INTERFACE_ALL table in PA. Import process was run from the applications, which validated the data in the interface table and populated the PA_EXPENDIUTRE_GROUPS, PA_EXPENDIUTRES and PA_EXPENDIUTRE_ITEMS tables.

Developed interface to load Open Invoice Interface from Legacy System into AR using Auto Invoice program.

Customization of Standard Consolidated GL/AR/OM/INV/WIP/BOM/PO Reports and Involved in creating Business Areas using Discoverer. Worked in Design, testing, implementation for Discoverer reporting.Develop various Reports in AR, APand GL using Oracle Discoverer.Designed and implemented Extension / Customization of Oracle Forms, Reports and Menus

Written several scripts to validate data in staging tables and developed SQL*Loader control files to load the data from flat files into the staging tables

Fully involved in the data mapping and conversion of

conversion SQL script for to fetch detail information according to Internal and External Reporting Requirement, which includes Payables (Invoice, Payments), Receivables (Sales Invoice, Credit Memo, Debit Memo, Credit Memo Applications, Trade Receipts, and Misc Receipts), Project Accounting (Labor Cost, Usage Cost).

Implemented / Customized oracle workflow for Order Fulfillments to meet business processes requirements.

Involved in analysis, design and coding of data extraction and loading the data in table.

Created / Customized Built in Reports as well as new reports in Cash Management as per the requirement.

Prepared MD50, MD70 for implementation of Applications.

Environment: Oracle E-Business Suite11.5.10 (GL, AR, AP, PO, OM, INV, PA), Discoverer 10g, Oracle 10g, Reports 6i, PL/SQL, SQL*Loader, Toad, Oracle XML Publisher 5.6.2, Jdeveloper, BPEL

Continental Engines Limited, Mumbai India JUN 2006 - JAN 2007

Oracle Applications 11.5.10.2 Implementation

Role – Oracle Apps Technical Consultant

Continental Engines Limited (CEL) is an 100% Export Oriented auto Components Company. CEL is first manufacturing company at Indian where Oracle 11i Special Edition (SME version) is implemented.

Responsibilities -

New implementation of Oracle Applications 11.0.3, modules include GL, AP, AR, INV, PO, OM.

Customization of reports and data conversions from Legacy Systems to Oracle for D N JEWELS a diamond jewelry manufacturing company.

Prepared SQL*Loader control scripts and PL/SQL packages for to load invoice data from flat file into staging tables, validate it and created interface (API using PL/SQL) to transfer it into auto invoice interface tables.

Involve in Setup Oracle 9i database on Windows 2000 server and migrated existing Oracle 7.3 Database (Windows NT) to Oracle 9i (Windows 2000) for to meet capability requirements of database and enhance the system performance requirements at Star diamond house (a diamond manufacturing company).

Enhanced/tuned existing SQL and PL/SQL scripts for creating tables, views, synonyms, indexes, users, roles, privileges, procedures, functions and triggers to make it functioning with existing Delphi as front end.

Created customization of Oracle reports according to client requirement in key indicator report and distribution detail report like Account Status Report and Transaction Detail Report.

Created an interface using Oracle Forms for creating users and modifying the privileges for users.

Loaded data into Oracle tables using SQL*Loader and dbms_utility package.

Responsible for developing and customizing complex Reports (6i) as per the client requirements in INV and OM modules.

Used Order Import to import data into Order Entry/Shipping for processing.

Design, development and import of invoice information into INV.

Performed SQL tuning using Explain plan and tuning database with appropriate indexes.

Maintaining concurrent manager and assigning priorities.

Environment: Oracle 9i database server Oracle apps 11.0.3, Oracle D2K, PL/SQL, SQL*Loader, FoxPro, LINUX, MS Windows 9x/2000/NT/XP, Oracle Reports, MS SQL Server 2000

Hikal Limited - Mumbai, Maharashtra, India FEB 2006 - MAY 2006

Oracle Applications 11.5.10.2 Implementation

Oracle Applications Technical Resource

Hikal is a technology-driven Specialty Chemicals 100% Export Oriented company. Hilkal has implemented EMS and integrated it with Oracle 11i. Hikal has 6 different factories located at diverse and remote locations. This project was implemented with Oracle Consultancy Group-Software consultancy division of Oracle India.

Worked as a functional Technical Consultant to implement Oracle Application 11.5.10.2 involving PO, i-Expense, i-Procurement, Project Billing, Project Resource Management, Project Management, AP, AR, GL and FA Modules Meet with customers to understand their system and service requirements and then Writing Technical Design Scripts for the end to end testing, coordinating with the technical team to develop load testing scripts for all of the data conversions as well as inbound and outbound interfaces.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), PO, AP, i-Expense,i-Procurement, AR, GL and FA.

Aurobindo Pharmaceuticals Limited - Hyderabad, India OCT 2005 – JAN 2006

Role – Oracle Apps Developer

Aurobindo Parma Limited based at Hyderabad, India manufactures Generic pharmaceuticals and Active Pharmaceutical Ingredients. The Company is selling its products in over 100 countries.

Aurobindo is the earliest Indian Company, where Oracle 11i was implemented. This has ensured that customer can utilize information in ERP for their Exports/Imports reporting and management requirements and there is only single point data entry.

Oracle Applications 11.5.10 Implementation

Involved in the full life cycle of software development like system analysis, requirement gathering, planning, ERD(Entity Relationship Diagrams) and DFD (dataflow diagrams), development, implementations, documentations, training to end users and post implementation support.

Involved in design, coding, testing, and implementing various programming using Oracle,PL/SQL, and UNIX Shell scripting.

Created forms using Oracle Developer/2000 for creating/managing/extracting master data of customers, entering / managing various Fixed Deposits schemes in the system, managing funds of customer.

Integrated custom application (FDMS) with Oracle Financial Analyzer (OA) and created reports for to evaluate the bank performance.

Created Tables, Views, Synonyms, Sequences, Procedures Functions and Triggers.

Monitored Object fragmentation.

Performed routine checks and kept track of space utilization and free space in table spaces while system was in the production.

Environment: Oracle 8, Oracle e-Business suite 11.5.3, Oracle Developer 2000, FoxPro, UNIX, MS Windows 9x/2000/NT/XP, FTP Server.

SRF Limited - New Delhi, India MAY 2005 - SEP 2005

Oracle Technical Consultant

SRF Limited is world leader in manufacturing Refrigerant gases. SRF has developed and implemented Exports and Imports Management system and integrated it with Oracle ERP (11i). SRF exports gases, which are packed in special cylinders. These cylinders are returned to SRF by customer after consumption. Chenab has developed a utility for tracking all the cylinders and penalty /duties in case cylinders are not returned. In addition to this various business optimization utilities like – Pending Works report, access control and order activity planner has helped customer in Managing its business.

Oracle Applications 11.5.10 Implementation

Provide Technical expertise to Oracle Applications users comprising of modules: AP, AR, PO, OM, FA and INV. Meet with customers to understand their system and service requirements. Assist in the regression testing of Oracle Modules as required. Developing and modifying the reports as per the need did extensive study to Implement MRC.

Environment: Oracle 8i, Developer 2000(6i), PL/SQL, SQL, Oracle Financial Applications 11i(11.5.10) with Multi-Org, AP, AR, PO, OE, FA, INV (Functional & Technical – AOL, Sys admin), SQL Net, Oracle Workflow, Oracle Discoverer, Designer 2000, TOAD, SQL Loader, Unix.

NAME OF EMPLOYER: SQL Star International Ltd. FEB 2002 – May 2005

DESIGNATION: Oracle Apps Technical Consultant

Responsibilities -

Created SQL scripts for to create tables, views, and indexes to assign/create privileges to user and PL/SQLprocedures, triggers, functions for data manipulation in table with ensuring integrity of the database.

Created an interface to import data from text files generated by FoxPro program (existing system) to the Oracle Database using SQL*Loader.

Developed reports using Oracle Reports to analyze the performance of the institute by processing results of examinations held at SVNIT for various branches of engineering and technology.

Setup ePrints software for online publication of research papers prepared by doctorate students and professors at SVNIT.

Developed SQL and Perl scripts to customize ePrints software according to the requirements.

Enhanced SVNIT website Using Java Script, ASP, HTML, CSS with dynamic updating functionality, so that to make updating in various section like Announcements, What’s New, Quick Links, News@SVNIT, Menu Links, Faculty Profiles, etc. can be easy and manageable.

Prepared PL/SQL stored procedures, functions and triggers to implement integrity of database.

Developed a utility using MS Visual Basic 6.0 and C++ (Winsock programming) as front end and MS SQL server 2000 as back end for to calculate student’s lab usage time.

Environment: Oracle 8.0 database server on MS Windows NT, FoxPro, LINUX, MS Windows 9x/2000/NT/XP, ASP, HTML,CSS, VBScript, Java Script, Perl Script, Oracle D2K, MS Visual Basic 6.0, Visual Interdev, MS SQL Server 2000, various servers like FTP, NIS, DNS, Proxy, DHCP and Web (IIS, Apache).

Environment: Oracle Applications v.11.5.3 (AR, AP, GL, FA, CM), Forms, Reports 6i, SQL, PL/SQL, SQL*Loader

Contact this candidate