Oracle Sql

Vijay Shankar BM Email : **************@*****.***

Oracle Apps Technical Consultant Mobile : +91-974*******

Professional Summary

• Having around 3 Years’ experience as Oracle apps Technical Consultant (SCM, Finance,

HRMS) with hands on working experience includes Development & Customization of AOL

concepts and RICE Components on Oracle Applications R12.

• Excellent skills in Oracle’s SQL, PL/SQL, Developer 2000 (10g).

• Experienced in Developing, Customization & Debugging of PLSQL Subprograms like Procedures,

Functions and Packages.

• Experience in Oracle Application Framework Development, Customization and Personalization of

OAF pages.

• Development and Customization of XML Publisher Reports, Interfaces and Conversions.

• Good Experience in Development and Customization of Alerts through Alert Manager.

• Good Technical knowledge of the Distribution Modules ( Oracle Purchasing, Order

Management, Oracle Inventory ), Financial Modules (Oracle Payables, Receivables, General

Ledger and Property Management ) and HRMS Modules.

• Development and Customization of seeded and custom Workflow and AME Setup Configuration.

• Proficient in writing stored procedures, packages using PL/SQL, SQL and experienced in using

tools like SQL*Loader.

• Knowledge on Forms personalization.

• Development of XML Publishers and DISCOVERER Reports.

• Hands on experience on Workflow, Capable of working independently and as well as a part of

team.

Educational Details

• Pursued B.E. in Computer Science from Visvesvaraya Technological University, Belgaum in

2011

Work Experience

• Currently Associated with Mobily InfoTech India Pvt. Limited, Bangalore from Apr’2012 to Till

Date.

Technical Skills

Oracle Applications E Business Suite R12

ERP

PO, AP, HRMS, INV, OM, AR, GL, SYSADMIN, AOL

MODULES

SQL, PL/SQL

Languages

Oracle 9i/10g/11g

Database

Reports & Forms (10g), Discoverer 11g, Workflow Builder, Oracle

GUI

Application Framework 10g

Tools Toad, SQL*Plus, SQL * Loader, SQL Developer, SSH Secure Shell,

WINSCP and Putty.

XML Publisher

Reporting Tools

Windows XP, 7 and UNIX

Operating System

Project #1

Client : Mobily, Saudi.

Designation: Software Engineer

Roles and Responsibilities:

Developed Custom OAF Pages this includes Menus, Tables, Buttons, LOV’s and all major

•

components.

Developed the custom OAF pages and customized standard pages.

•

Registering the OAF Pages to Oracle Apps.

•

Worked on SQL* Loader to load all the data given in flat files with various special characters

•

and comma delimiters.

Worked on the Developing new Reports, Customizing Oracle Reports for INV, OM, AR, PO,

•

HRMS, PN and AP using Oracle Reports 10g.

Developed UNIX Shell Scripts. Customized and developed Oracle Reports using.

•

Customized standard reports such as AR Customer Invoice Report, Pack Slip Report, Open

•

Order Report, Purchase Order Report.

Developed new reports using Report Builder 10g and also customized seeded reports in

•

purchasing (PO) and AR module.

Designed reports in Discoverer based on the business requirements in AP, AR,

•

and GL modules.

As per the company requirements, created and implemented XML/BI Publisher reports for

•

different products like PO, AP, AR, INV, HRMS, GL and PN.

Developed XML Bursting reports for AR to automate the invoice via email.

•

Worked on the Form Personalization.

•

Developed the custom workflow and Customized Seeded standard WORKFLOW such as AP

•

Invoice workflow using Workflow Builder 2.5.

Developed the custom Workflow by creating Functions, Processes, Attributes, Lookups,

•

Events, messages and Notifications.

Worked on the Payment Workflow Process for approvals on AME.

•

Worked on setting up Attributes, Conditions, Rules and Approver groups on AME for Payment

•

Workflow.

Performed end to end testing on the AME setup for invoice approval process.

•

Developed PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views

•

etc.

Registering Tables for custom applications.

•

Worked with performance tuning tools like Explain Plan to improve the performance of

•

various custom PL/SQL Packages, Procedures and Reports developed.

Register generated reports, Flex fields. Defined Descriptive Flex fields, value sets,

•

Lookups and also registered PL/SQL stored procedures, SQL*Plus scripts etc.

Performed Various System Administrator activities like defining a Concurrent Program,

•

Executable, Request Groups, Creating Users, Menus and Responsibilities.

Analyzed the design document for code changes, understand the intricacies, provide estimate

•

of timeframe in which this code change can go live.

Prepared technical (MD070, MD050) and Design documents for reports, interfaces and

•

concurrent programs as per client business logic.

Developed technical design and test documents complying with Oracle AIM standards.

•

Contact this candidate