Oracle Sql

Summary:

• Oracle EBS Technical consultant with over 7 years of extensive experience in Application Development, Implementation of ERP (Oracle Apps) Application, Oracle SQL, PL/SQL Development (Oracle 10g/9i), Performance Analysis, Production Support, SQL*PLUS.

• Hands on experience in Software development life cycle, leading and executing deliveries and supporting global clients & customers

• Hands on experience in Implementation, Development, Enhancement and support of Oracle Modules (Account Payables/ Order Management/ General Ledger/ Purchasing/ Cash Management/ Inventory/ Manufacturing)

• Hands on experience in creating and migrating AOL objects such as Concurrent programs, Value sets, Menus, functions

• Expertise with ERP implementation and Data Conversions

• Experience in designing Oracle Interfaces

• Experience in Oracle E-Business Suite 11i and R12 and Oracle Developer Suite

• Expert in writing efficient SQL and PL/SQL code (Stored Procedure, Functions, Triggers, Autonomous Transactions and Packages) on TOAD to analyze very large data sets

• Extensive knowledge of Dynamic SQL and queries

• Extensive experience in Performance Tuning (Using TKPROF, SQL TRACE & Explain Plan, Analyzing Indexes) etc

• Excellent Analytical skills to understand the business process and functionality, requirements and to translate them to system requirement specifications

• Experience in various phases of SDLC like Gathering Requirements, Analysis/Design, Development, Testing and deployment, Go-live and Post GO-live support

• Experience in preparing Test plans, Test Data and execution of Test cases to ensure application functionality meet the user requirements

• Experience in working on SQL Loader, UTL FILE operations

• Well versed with UNIX Scripts and UNIX Shell Scripting

• Experience in handling Production cases and escalations

• Expertise in system integration testing, preparing design documents

• Ensured Project compliance to Quality and Standard implementation methodology – Drive QA processes for the project in the program, Participate in CMMI Level 5, Identify, communicate and implement opportunities for process/solution improvement; Establish CMMI process to control defects and improve customer satisfaction

• Have good experience in Onsite-offshore model execution of projects

• Excellent documentation and presentation skills, great verbal and written communication skills

• Analytical thinker, quick learner and proficient problem solver who envisions business and technical perspectives to develop workable solutions

Contact this candidate