SHRIKANT PATEL.

978-***-****

jh0jzl@r.postjobfree.com

(USA Work Authorization – Green Card)

Experience Summary:

• An industrious and motivated Oracle Applications Techno-functional Consultant with 6+ years of IT Industry experience, which includes over all of experience in EBS (Oracle Applications 11i/12i Financials).

• Oracle 11i Financial certified Professional Consultant, General Ledger.

• Experience in Oracle Applications Modules: General Ledger (GL), Account Payables (AP).

• Good understanding of Application Object Library (AOL) and System Administrator Responsibility.

• Involved in defining cross-validation rule and security rule on chart of account.

• Experience on both Inbound and Outbound Interfaces.

• Involved in coding Open Interfaces, Conversions and Enhancement programs.

• Involved in defining mapping rule, translate data for consolidation.

• Experience in Interface Programming using PL/SQL and SQL*Loader to load and validate data.

• Participation in the analysis, development, debugging, modification, and enhancement of financial modules.

• Involvement in registering concurrent programs, forms, reports, tables in custom applications using AOL.

• Very strong in full suite of Oracle Tools including Reports, PL/SQL, SQL*Loader, TOAD.

• Strong in designing and coding PL/SQL packages, procedures, functions, database triggers.

• Exposure to Performance Tuning and Optimization of SQL Queries.

• Worked with Customizations, Cross validation rules and Value sets.

• Experience in customization by extension and modification of the standard application suite using Application Object Library.

• Quick learner with the ability to meet tight deadlines and work with cross-functional teams.

• Great leaning skills to adapt the rapid changing technologies and implementing the same at work.

Certification and Training:

• Completed 11i E-Business Suite Essentials for Implementers ED4 Course from Oracle University.

• Completed 1Z0-200 Oracle 11i E-Business Suite Essential exam.

• Completed 1Z0-211 Oracle General Ledger Fundamental exam.

Education:

• Bachelor of Engineering Information Technology from Pune University at India.

Technical Skills:

ERP : EBS 11i/12i (Oracle Application E-Business Suite 11i,12i).

MODULE : General Ledger-GL, Account Payable-AP, Purchase Order-PO.

TOOLS : Workflow Builder 2.6, SQL Loader (8), SQL Developer 3.0.

RDBMS/4GL : ORACLE (8i, 9i), FORMS 6i, Reports 6i, MS-VB (6.0), MS-ACCESS.

LANGUAGES : C, C++, PL-SQL, SQL*PLUS, JAVA.

OS : Linux, DOS (6.22), UNIX, WINDOWS (XP, NT, 2000).

Techno -Functional Consultant. June 09– March 10.

Exxon Mobil Corporation – Huston, TX

We are the world's largest publicly traded international oil and gas company, providing energy that helps underpin growing economies and improve living standards around the world.

Responsibilities:

 Assisted in GL setup.

 Involved in defining SOB and design the cross-validation rule, security rule of chart of account. Also

Defining mapping rule, preparing data, revaluate and translate data, transfer to parent SOB for consolidation.

 Define object for the FSG.

 Performed System Administration tasks in Oracle Financial Application by defining Responsibilities, Users, and Menus, Concurrent programs, Request sets and Request Groups.

 Worked as System Administrator including Oracle Applications managing concurrent managers, application user setup, defining responsibilities, values sets, flex-fields, registering menus, forms, reports, concurrent programs.

 Worked on General Ledger Interface Table GL_INTERFACE and imported Journal details into tables GL_JE_HEADERS, GL_JE_LINES, and GL_JE_BATCHES.

 Developed validation programs to validate the data before loading into interface tables.

 Customized Trial balance detail report add column to display to account type.

 Prepared Technical Requirement Specifications based on the Business Requirement Documents.

 Involved in monitoring, debugging and bug fixing of day-to-day issues as part of Support team.

Environment: Oracle E-Business Suite 11i(EBS 11.5.10.2), Oracle9i, AOL, GL, AP, Forms and Reports, SQL, SQL*Plus, PL/SQL, SQL*Loader.

Techno- Functional Consultant June 08 - April 09.

Black Diamond Performance Reporting – Jacksonville, FL

At Black Diamond Performance Reporting, our mission is to provide a highly valuable, customizable performance reporting solution to independent wealth managers and financial advisors. Our solutions provides in consolidation and return , ad hoc and client base report ,flexible and customization reporting level , financial advisor report . We are eager to put our application and experience to work for you today.

Responsibilities:

 Involved in design and development of Oracle Apps 11i modules GL, AP.

 Involved in development of conversion scripts to move data from legacy systems using SQL* Loader.

 General ledger data migration from legacy system. Populated the data in GL Interface Table and load data into GL Batches, headers and lines tables using Journal Import.

 Involved in loading Daily Rates in GL using GL_DAILY_RATES_INTERFACE.

 Customized standard forms using CUSTOM.pll library according to clients requirement to enable ZOOM functionality.

 Developed various stored procedures, database triggers, and functions.

 Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.

 Created and updated MD70 documents for all the Development work done.

Environment: Oracle Applications 12i , Oracle9i, AOL, GL, AP, Forms 6i and Reports 6i, SQL, SQL*Plus, PL/SQL, SQL*Loader, Unix.

Technical Consultant. June- 06 – May 08.

Info gain System. -IL

Info gain is an enterprise IT and business solutions company that specializes in superior IT architecture design, end-to-end project implementation, and managed services. As a premier services company, our customers are our top priority and your success is our objective.

Responsibilities:

 Involved in Conversion of data from Legacy System to Oracle Applications by using SQL* Loader and PL/SQL.

 Involved in the development of interfaces to load the invoice data from the legacy system into Oracle Accounts Payables AP.

 Involved in the development of interfaces to load the Budget data from the spared-sheet into Oracle General Ledger – GL.

 Customized Invoice on hold report by adding amount ordered, amount received, amount due columns.

 Customized Invoice History report by adding bank detail with supplier details. Name of the bank and payment method field will be added in the report.

 Customized Distribution set listing report with description of account details.

 Developed various stored procedures, database triggers, and functions.

 Developed SQL queries to obtain specific information as per requirements.

 Created Value sets for report parameters and registered them in apps using AOL.

 Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL packages and procedures, forms and reports.

Environment: Oracle Applications 11i (EBS-11.5.10.2), Oracle9i, AOL, GL, AP, AR, INV, Forms and Reports, SQL, SQL*Plus, PL/SQL, SQL*Loader.

Software Engineer And Technical Support Oct 04 – March 06.

Gurukrupa InfoTech. – Pune, IND

Gurukrupa InfoTech small scale company and deal with developing software application and retailing computer hardware. They have many clients for developing desktop application and give support. Involving in design and developed desktop application of payroll systems.

Responsibilities:

 Customized Distribution set listing report with description of account details.

 Developed various stored procedures, database triggers, and functions.

 Developed SQL queries to obtain specific information as per requirements.

 Design database diagram documents in UML.

 Create the database in oracle 9i.

 Developed Form and report in VB 6.0 accordingly attendance and generate payroll receipt.

 Write a SQL query for retrieving data from database in VB forms.

 Debugging and testing PL-SQL store procedure and function.

 Involved in Generate Executable.

 Setup the network and installation application.

Environment: Oracle Applications 11i (EBS-11.5.9), Oracle9i, AOL, GL, AP, AR, INV, Forms and Reports, SQL, SQL*Plus, PL/SQL, SQL*Loader, VB 6.0, UML.

Contact this candidate