Oracle Technical Consultant Resume

SUMMARY

9+ years of extensive experience as Oracle Technical Consultant in implementation, upgrade and customization of Oracle e - Business Suite Applications (R12, 11i). This includes system study, design, development, post implementation maintenance and support of Oracle EBS.
Responsible for understanding and analyzing the provided RICE component specifications and developing solutions by using Developer-2000 and PL/SQL.
Experience with Oracle and Other Utilities such as TOAD, SQL*Plus, SQL*Loader
Exposure to Discoverer, BI and XML Publisher Reports 10g & 11g.
Experience on OBIEE & ODI
Involved in Full Life Cycle Implementations and Support of Oracle Applications R12, with hands on working experience on Reports, Interfaces, Conversions and Extensions.
Strong Knowledge of Application Implementation Methodology (AIM), Application objects Library (AOL) implementation standards, Trading Community Architecture (TCA) and software Development Life Cycle (SDLC).
Working experience and good functional knowledge on P2P and O2C cycles.
As a Techno Functional Consultant, extensively worked on modules like PO(Purchasing), AP(Payables), AR(Receivables), GL(General Ledger), OM(Order Management),FA(Fixed Assets), PA(Project Accounting) & HRMS
Experience in Performance Tuning, UNIX shell scripting.
Experienced in creating Sessions, Workflows, Mappings, and Mapplets using various available transformations in Informatica, including Router, Aggregator, and Lookup.
Extensive experience in creating executive reports with BI Publisher integrated with OBIEE.
Knowledge on Forms Personalization & Custom.pll
Experienced in design and development of the three layers(Physical/Business Model and Mapping/ Presentation)of an OBIEE Metadata Repository(.rpd) using Oracle BI Administration Tool
Ability to write and revise system and operation documentation for new and existing programs and systems in accordance with company and client standards
Involved at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
Exposure to Oracle APEX(Formerly called HTML DB)
Write technical design documents for conversions, extensions, interfaces, and reports. Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs).
Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.
Interacted with users, fixed the bugs, developed test plans and provides daily Production support.
Knowledge on Project accounting(Costing & Billing)
Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
Developed Data Conversions for AP, PO, GL, AR, FA, PA, OM, INV & HRMS
Knowledge on Oracle Work flows and OA Framework Technologies.
Experience in Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS
Possess excellent oral / written communication and interpersonal skills.
Flexible and adaptable in regard to learning and understanding new technologies.
Strong problem solving & technical skills coupled with confident decision making for enabling effective solutioents in oracle application object library as concurrent programs

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship