Oracle Apps. Functional Consultant

Oracle Apps. Functional Consultant

Surlin Solutions


Oracle Apps. Functional Consultant


To associate myself with a professionally run organization that

has potential for growth both organizational and personal in the area of Enterprise Resource Planning (ERP) in Information Technology, and

Provides me with a scope to learn, develop, improvise and implement.


I have around five years of post qualification experience. Having completed my Master of Science and Bachelor of Science in Computers from OsmaniaUniversity – Hyderabad.

I have got an experience in the Analysis, Design, Development, Testing, Implementation and support of commercial, manufacturing & web based applications using Oracle, Oracle iProcurement, Oracle Applications 11i (GL, AP, AR, Purchasing, Order Management, Inventory), Application Object Library (AOL) and System Administrator modules for large customers in US, Singapore, Sri Lanka and India.

Currently part of an ERP Implementation team where all the finance, distribution and Process manufacturing modules are being implemented for a pharmaceutical company called Granules India Limited. Prior to this role, I was involved in Oracle Purchasing, iProcurement Application’s rollout and support projects for the GE Corporate and GE Capital Corporate businesses.


  • Working as an Oracle Apps functional consultant at SQL Star International Ltd., INDIA from November -2003 to till date.
  • During this tenure I had mainly worked at GENPACT (GE Software Solutions) for two years as a vendor resource associated with SQL Star International Ltd., INDIA from November –2003 to December -2005.
  • Worked as a Software Engineer with Buxton Software Solutions Ltd., INDIA from Aug –2001 to Nov -2003.


  • Master of Science in Computers (M.Sc. Comp) from OsmaniaUniversity.
  • Bachelor of Science in Computers (B.Sc. Comp) from OsmaniaUniversity.


Software: / SQL*Plus 8.x, PL/SQL, SQL*Loader, Forms 6i, Reports 6i, Visual Source Safe, Visual Basic 6.0, C, C++, JAVA
ERP: / Oracle Applications 11i (GL, AP, AR, CM, Purchasing, Order Management, Inventory, AOL and System Administration) and Oracle iProcurement applications.
Databases / Oracle 8/8i
Operating systems: / UNIX, WINDOWS – NT, WINDOWS 95 / 98, WINDOWS 2000/2003 Professional Servers
Web Technologies: / HTML, JavaScript, Servlets, JSP

1 # ERP Implementation for GRANULES INDIA LIMITED.

Duration: / Jan ’2006 – till date
Modules being Implemented: / Oracle General Ledger, Payables, Receivables, Cash Management, Fixed Assets, Purchasing, Order Management, Inventory and all the OPM modules.


Granules India Limited is a fully integrated pharmaceutical formulations manufacturer and it is

Offering one-stop solutions to pharmaceutical companies and integrated backwards into the manufacture of several pharmaceutical formulation intermediates (PFIs) and active pharmaceutical ingredients (APIs).

The project involved implementation of Oracle Applications 11i - GL, AP, AR, FA, CM, Purchasing, Order Management, Inventory and other OPM modules in Multi Org Environment and analysis including BR100 and RD20 preparations.


Actively involved in the requirements gathering from the client and also the process of data analysis of their As Is system of manufacturing, commercial, marketing and finance departments.

Interacted with the client to set expectations for the entire project including functionality being provided in implementation, and have also participated in the main discussions where in the Organization structure and Accounting structure is finalized as per their legal requirements.

As a Functional Consultant accomplishment includes:

  • Define Set of Books with Chart of Accounts, Accounting Calendar and Currency.
  • Creation of value sets, defining flex fields, Cross-validation rules.
  • Multi Organization Setup for the OPM environment.
  • OPM Organization setup and finance integration through fiscal policies.
  • All the Purchasing Setups like Positions, approval assignments, approval groups, defining Approval hierarchies (Job Supervisor and Position), defining financial, purchasing and receiving options and other setups.
  • Created Suppliers, Customers, Payment terms, Distribution set.
  • Order Management & AR Setups like System Options, Transaction sources, Transaction Types, Receipt Sources/ Classes, Auto accounting, shipping parameter setups and other setups.
  • Inventory setups like Items, Sub inventories, warehouses, Locations, Planning, Counting
  • India Localization setups

2 # Oracle Purchasing support and enhancement project

Client: / GE Corporate, Fairfield, USA.
Duration: / Sept ’2004 – December’ 2005
Environment: / Oracle Purchasing, iProcurement, System Administration, Workflow, PL/SQL, SQL*Loader, and TOAD


This project involves post implementation support for GE Corporate and GE Capital Corporate groups mainly in iProcurement and purchasing in addition to Oracle Financials and Distribution modules. This project is a part of SSS (Shared Sourcing Service), which is the world’s largest iProcurement system.

The Process supports the already implemented Oracle Apps iProcurement ERP system. Apart from identifying and removing the existing bugs in the system, the additional tasks involve analyzing the business’s new requirements and customizing the ERP system accordingly.


As a Functional team member involved in Regression testing of each functionality in iProcurement and purchasing modules.

Successfully carried out the Regression testing for the implemented sites for complete functionality on Oracle Application modules iProcurement, PO etc. with pre and post application of various patches/patch sets and release upgrades.

Supervised and supported the oracle purchasing testing team in successful completion of testing and in meeting time specific targets with utmost care to quality.

Effectively managed the solution of application functionality issues by continuous follow-up and communication and by providing the necessary information and effective validation of the solution/Fix.

Providing Post-implementation support in terms of:

  • Define Purchasing, Receiving and Financial options
  • Reviewing, updating and expediting Requisitions
  • Managing both employee supervisor hierarchy and Position hierarchy.
  • Auto-create Purchase Orders
  • Purchase Orders transmitting to Suppliers and AP.
  • Flex-field maintenance
  • Set up Organizations, define Set Of Books, and change Document Type setting (if needed)
  • Maintain GL, PO, AP and INV periods
  • Re-assign Workflow Notifications
  • User and Supplier maintenance
  • Positions and Approval Assignments
  • Setting up Buyers and Approval Groups
  • Providing ADHOC reports using TOAD
  • Creating / updating of SOP documents.

Solving of problems, off shore support and giving online training in Purchasing and iProcurment modules to the GE Corporate users in US.

As an only technical member in the project involved in Preparing SQL Scripts and Generate customized reports using SQL-TOAD as per Client’s requirement.

Responsible in maintaining the tax codes and tax rates in the system by scheduling an interface manually.

Attended training relating DMAIC methodology and Oracle Apps (Functional).

Creation, consolidation and ongoing modification of all the standard operating procedures (SOPs) pertaining to the Sysadmin role. Maintaining and undertaking enhancements on the GE Corporate Sourcing support central community page ( -Repository for complete document for purchasing projects).

Received words of appreciation from the client (GE Corporate) for actively supporting this portal’s testing team based out of Fairfield, CT.

Got an award for standing out as the Best Team Supporting the Buy to Pay Initiative in GE Corporate Initiatives Group.

3 # Oracle Purchasing Implementation Project

Client: / GE Commercial Finance
Duration: / Feb ’2004 – Aug’ 2004
Environment: / Oracle Purchasing, iProcurement, System Administration


Implementation of the Oracle PO and AP cycle for 9 Business Groups and 21 Operating Units. I was involved in the PO implementation for the above-mentioned business.


Interacted with the client to set expectations for the entire project including functionality provided in implementation, customization required and time lines as per the SSS train calendar guidelines and 6 Sigma methodology.

Interacted with business clients and SSS (Team owning the application in GE) for preparing the Code Move Sheet document for organization setups.

Multi Org, SOB Setups in Tests and Production instances.

Creation of value sets, defining flex fields, Cross-validation rules, Positions, approval assignments, approval groups, defining Approval hierarchies (Job Supervisor and Position), defining financial, purchasing and receiving options and other setups.

4 # GEO Code Billing Re-Organization – GEC IT Solutions

Client: / GE Capital IT Solutions, USA.
Duration: / Nov ’2003 – Feb ‘2004
Environment: / Oracle General Ledger, Account Receivables, Order Management, PL/SQL, SQL*Loader, and TOAD


Geography is one of the segments (segment5) in 9-segemented GL accounting string in GEC ITS. This project had a requirement of an Enhancement in re-organizing Geography segment. The scope of customization covers mapping of geography segment value in the GL accounting string to Ship-To address of customer by passing auto accounting set up and cost of goods sold account by modifying the existing program to implement GEO Code Based on Ship-To address for Order Management Transactions.


As a team member involved in legacy data conversions using SQL Loader and also responsible for updating the historical data (mass data updating) in the existing application.

Involved in testing – creating all types of orders, approving orders through workflow.

Also involved in monitoring the whole cycle {Order creation -> Receivable interface program -> populate RA_Interface_Lines, RA_Interface_Salescredits -> Custom program -> populate RA_Interface_Distributions table-> Auto Invoice ->Populate Base tables ->GL transfer Program -> GL_Interface table -> Journal upload -> Posting}


Client: / IXEL (S) Pte. Ltd.
Duration: / Dec ’2002 – Nov’ 2003.
Environment: / Oracle Applications Release 11i (AR, AP, INV, PO and GL), PL/SQL, SQL*Loader, Reports6i and TOAD


IXEL (S) Pte Ltd. aimed at the Singapore as well as Malaysian market for selling Skin Care, Home Decor and Kitchen products. The modules being implemented involve Oracle General Ledger, Oracle Receivables, Oracle Payables, Inventory and Oracle Purchasing. The Development work involves developing Custom Interfaces, Conversions and reports as per the client requirements and Support across different phases of implementation. This includes the development of PL/SQL scripts, SQL Loader Control files, Shell Scripts etc. for data Migration from the Client’s legacy system to Oracle applications, Development of Outbound Interfaces and Reports.


Involved in Analysis, Design and Development of Legacy system conversions and interfaces that involved automating data interfaces to Oracle Financial modules.

Responsible for development of the interface for Journal Upload. This interface program includes loader script, validation program, design and mapping document.

Worked on the Oracle Vendor Extract for Legacy Interface -- Outbound Interface to extract Vendor Information for the Legacy system.

Worked on the Salesperson DFF Update – Script to update the attribute of all the salespersons reading the values from the data feed.

Worked on the development of receivable reports such as AR Customer Invoice Report, AR VAT GUI Reconciliation etc.

Worked on the Application object library to register the reports as a concurrent programs

Experience on Application Object Library to maintain integrity of Oracle Applications


Client: / Buxton Software Solutions Pvt Ltd.
Duration / Jan’2002- Nov’2002
Environment: / Oracle 8.0,PL/SQL, Forms 6i, Reports 6i, Windows98


This is a generalized package useful for computer training Institutes, Schools and H.R. Divisions of Software Companies. This package facilitates the clients to conduct on-line examination at their institute like MCP exam. It allows them to create their own question banks for different subjects and allows the examiner to decide the exam pattern and time allotted etc. It generates reports like Memo for each student, Passed and Failed student lists subject-wise etc.


Involved in development of forms & reports for this application. Responsible for system designing and coordinating. System designing includes the setting of database tables and defining relations among them considering the concepts like normalization, data redundancy etc. And was involved in deploying the application at client side. Responsible for designing and development of the Question entry form and Exam Paper form.


Client: / Prathiba Groups
Duration / Aug’2001- Dec’2001
Environment: / Oracle 8.0, PL/SQL, Forms 6i, Reports 6i, Windows98


Real-estate Management System is a complete solution for Prathiba Groups, Real Estate Wing business Management, consisting of Management of Plot holder details such as their Initial payment for a plot, No. Of installments they paid. It also contains details about Agent management also like Agent details, amount deposited details, no. Of plots they booked etc. And it also creates all types of monthly and yearly reports.


My responsibility includes raising the alerts, creating the necessary record groups, List of Values, grouping all procedures to make a package. I was also involved in developing reports like monthly, daily and between given dates. All in all I created 10 tables that includes Agent Master, Plot master, Deposit master, management master, installment master etc.

  • Have recently gone through the EPB (Enterprise Planning and Budgeting) initial training at Oracle Corporation (IIIT Campus, Hyderabad)
  • Had Six Sigma Green Belt Training at GE Software Solutions (GESS).

Green Belt Quality Training

DMAIC quality training

  • Had Account Payables and Get-Services (3rd party application) training at GESS, Hyderabad
  • Oracle Purchasing & iProcurement at GE Software Solutions, Hyderabad
  • Oracle Application integration at GE Software Solutions, Hyderabad, India.


A division of Surlin Consultants Pvt Ltd, 561 Yavapia hills drive, PrescottAZ86301

Phone 001 - 805 624-6499