Post Job Free

Resume

Sign in

Oracle Sql

Location:
Chennai, TN, India
Posted:
January 20, 2015

Contact this candidate

Resume:

PRADEEP BALAKRISHNA Extensive experience in working

with PL/SQL packages, Stored

Procedures, Functions and

Triggers.

Expertise in creating custom tables,

views, custom responsibility.

#M-48, 8th Cross,

Documenting technical specification

Lakshminarayan puram,

using AIM/ OUM.

Srirampuram.

Bangalore-560021 Documenting Technical specification

Karnataka, INDIA using MD050 and MD070.

Mobile : +91-740*******

Modified OM Workflow to send a

Email :abjlra@r.postjobfree.com

notification to the e-mail group when

OBJECTIVE:

a brand new item is booked.

To work as a key player in a Migrated concurrent programs and

challenging and creative professional

value sets using FNDLOAD utility.

environment which provides me with

Customized forms using

opportunities to apply my skills and enhance

them in order to contribute to the CUSTOM.pll.

organization’s objectives along with

Worked in changing display prompt,

achievement of personal growth.

displaying message to the end user,

SUMMARY: hiding a field, adding menu to the

tools drop down list, auto checking

Experience in developing,

the detailed box using forms

customizing, modifying forms,

personalization.

reports existing in Oracle

Developed SQL*Loader control file

Applications according to the

to import the Payable invoice

business requirements and

information provided in the form of

specifications.

flat files into staging tables .

Extensive experience in Oracle

Hands-on experience in analyzing

Application Modules which include

the Oracle SQL Raw Trace and

Accounts Payable (AP), Accounts

TKPROF trace files in working

Receivable (AR), Purchasing (PO),

query and database performance

Inventory (INV), Order Management

issues.

(OM), General Ledger (GL), System

Administration, Oracle Projects, System Administration activities

Oracle Time and Labor (OTL), AOL. like managing concurrent program

managers, application user setup,

Proficient in functional knowledge of

defining responsibilities, values sets,

Order to Cash and Procure to Pay

flex fields, registering menus, forms,

cycles.

reports, concurrent programs, and

Expertise in SQL*Plus, PL/SQL,

printers providing support to apps

Reports 10g, Forms 10g, Discoverer

users for any technical issues.

& XML Publisher.

In-depth Experience in creating and (Reports, Interfaces, Conversions,

scheduling of Concurrent programs Enhancements/Extensions)

etc. components.

Developed Project costing custom

reports.

Developed Time and Labor reports.

Developed new reports for Oracle

Payables as per Business

requirement.

Generated custom views for auditing.

Extensively utilized Application

Object Library (AOL) to register

PL/SQL stored procedures, forms,

reports, SQL programs and SQL

*Loader concurrent programs.

Created several requests and request

set to attach the PL/SQL procedures.

Customized AR aging report.

Responsible for reviewing co-

developers code.

Performance tuning of several

custom oracle application views.

Communicated with oracle support

by creating SR (Service Request).

Involved in system integration

testing, User Acceptance Testing and

Go-live activities.

Involved in proof of concept

meeting.

Involved in production support.

Setting the delivery number to a 7

digit number.

Experience in setting up of ADI.

Understanding and fixing item

attributes for Inactive items.

In depth understanding of CEMLI

(Configurations /Customizations, Worked with Oracle support on

Extension, Modification, payment batch stuck issue.

Localization, & Integration) / RICE

Analyzing cost doubling issue

related to lot consolidation.

Modified the reservation form to

accept ingredients reservation

quantity in a batch.

Created costing view for NAFTA

calculation

Troubleshooting and fixing Un-

invoiced receipts report

Developed production sheet report

Developed various views required

for auditors

Created procedures/Functions for

Mass Substitution form to replace an

item with another item

Setting up of Data loader.

Setting up of Remittance program to

send emails.

Excellent interpersonal,

communication skills and

understanding of Business

applications. Willing to take up

challenging assignments and

interested to work in different kinds

of modules and emerging

technologies.

Strong analytical, diagnostic and

troubleshooting skills and ability to

work in a fast-paced and team

oriented environment.

TRAINING COURSES UNDERTAKEN:

Oracle database 11g, R12 E-Business

Suite Essentials

TECHNICAL SKILLS

ERP: ORACLE E-BUSINESS SUITE

R12.1.1, 12.1.3, 11i

ERP Modules : GL, AP, AR, OM, PO, INV,

PA, OTL

Languages : SQL, PL/SQL,HTML, XML

Database : Oracle 11g Performing all SQL statements like

Tools/Utilities : TOAD 9.6.1.1, TOAD 12, Data Retrieval (Select), DML(insert,

SQL*PLUS, Oracle Reports 10g, Oracle update, delete, merge),DDL (create,

Forms 10g, Oracle Workflow builder alter, rename, truncate),Transaction

2.6.3.5, BI PUBLISHER, SQL*Loader Control(Commit, Rollback)

VERSION CONTROL SYSTEM: PVCS Created database trigger to store

concurrent requests data in the history

table.

Analyzing the explain plan when query

is executed.

Creating views and functions using

Oracle SQL, PL/SQL for developing

reports.

Creating Materialized Views for

complex reports for the better

performance of the reports.

PROFESSIONAL EXPERIENCE

Developed PL/SQL Scripts,

Company: Ananya Solutions pvt. Ltd

[Oct 2012-Till Procedures, Packages, Functions,

Date] Triggers and created Custom Tables.

Client : Confidential

Carried out Integration, Regression,

Role : ORACLE APPLICATIONS

Validation and Functional Testing in

TECHNO-FUNCTIONAL CONSULTANT.

different Modules.

Involved in the implementation of Oracle

financial modules Assisting the other team members in

Developing Complex Reports.

Worked in Creating Value sets, DFF's,

Lookups.

Responsibilities:

Database Verification using SQL

Analyze the business requirement

queries.

and functional requirement

specification for the report design.

Involved in the development &

modification of Forms & AdHoc

Reports.

Developed PL/SQL Packages,

Procedures, Functions for validating

the invoices and payment information

from the legacy system and imported

into Oracle Applications using the

Payables Open Interface Import

program and populated the base tables.

Secured “YOUNG INVESTIGATOR AWARD” f

Conference organized by Interscience Research Netw

Technology (CSIT-2012) held at Bangalore on 19th May

Technical paper got selected for publication in Inte

Research Applications (IJERA).

ACHIEVEMENTS:

• Participated in National Convention held in AIT, Chikma

• Actively participated in national level technical paper pr

Environment: Oracle Apps 11i / R12, INV,

• Participated in VTU Chess.

PO, OM, PL/SQL, Reports 10g, Forms 10g,

• Secured prizes in Carrom & Chess .

Oracle Workflow builder 2.6.3.5, BI

Publisher.

EDUCATIONAL QUALIFICATION: EXTRA-CURRICULAR ACTIVITIES:

PERSONAL PROFILE:

POST GRADUATION

College : R.V College of Year of Birth : 1987

Gender : Male

Engineering, Bangalore.

Languages known : Kannada, English,

Course Branch Telugu, Hindi

Telephone : +91-740*******

M.Tech Digital VisvesvarayaReference

Technological University,iven upon request

:G

Communication

Declaration:

GRADUATION

I declare that the information given above is true

BE Specialization : Electronics and

to the best of my knowledge.

Communication

ACADEMIC PROJECTS:

Date:

M.TECH Project Title : GLRT DESIGN OF MIMO RADAR IN COMPOUND- GAUSSIAN

Place: Bangalore, INDIA

CLUTTER (PRADEEP

Duration 8 months (2012) BALAKRISHNA)

O.S: Windows XP

Environment

This project mainly deals with the target detecting problem using a MIMO radar

Description

against compound-Gaussian clutter with an unknown covariance matrix. The space-

time coding MIMO radar model has been adopted and developed to compound-

Gaussian case. The detector based on generalized likelihood ratio test (GLRT) criterion

is studied, and two-step design procedure is adopted. Specifically, the GLRT is derived

by assuming known covariance matrix, and then, a suitable estimate based on

secondary data is inserted into the derived detector to make the derived detector fully

adaptive so that the derived GLRT

the adaptive loss is acceptable..



Contact this candidate