We provide IT Staff Augmentation Services!

Senior Oracle Developer Resume

Dallas, TX

PROFESSIONAL SUMMARY:

  • Having 12+ years of experience as Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
  • Experience in Oracle DB Guard configurations for the standby databases
  • Extensive experience in New Implementation projects, Oracle Apps Rollouts & Well - versed with all the phases of Software Development Life Cycle (SDLC).
  • Experience with Data dictionary, Database normalization techniques, Data flow diagrams, Entity relation modeling and design techniques.
  • Expertise in Client-Server application development using Oracle 12c/11g/10g, SQL*PLUS, PL/SQL, SQL Developer and TOAD.
  • Well experience in System Impact Analysis, Design, Systems Architectural Design, Interfaces Process Design, Functional Flow Design, Data Process Flow Designs & presentations.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Strong experience in Data warehouse concepts and ETL.
  • Experience in technical and understanding the design goals of ER modeling for OLTP and dimension modeling for OLAP.
  • Experience in SQL performance tuning using Cost-Based Optimization (CBO).
  • Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
  • Developed materialized views for data replication in distributed environments.
  • Well experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools Cognos.
  • Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
  • Excellent troubleshooting, de-bugging and problem-solving skills.
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g, Data Guard

ETL Tools: Informatica PowerCenter 9.x/10.x, Informatica PowerExchange 9.x, SQL Loader

Reporting Tools: Business Objects Developer Suite 4.x, Cognos Suite 8.x, Crystal Reports, Oracle Reports 9i/6i

Languages: SQL, PL/SQL, Unix Shell Scripts, XML

Operating Systems: Windows 10/7

WORK HISTORY:

Senior Oracle Developer

Confidential, Dallas, TX

Responsibilities:

  • Preparing Technical Specification Documents as per business requirements
  • Involved in continuous enhancements and fixing of production problems
  • Created scripts to create new tables, views, queries for new enhancement in application using TOAD
  • Extensively involved in using hints to direct optimizer to choose optimum query execution plan
  • Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle
  • Involved in SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module
  • Developed Shell Scripts for Data loading and DDL Scripts
  • Involved in building high performance data integration solutions including extraction, transformation and load (ETL) packages for data warehousing. Extracted data from XML file and loaded it into database
  • Developed and modified number of Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied
  • Provided user training and production support
  • Involved in troubleshooting and bug fixing in Oracle 10g technology
  • Used principles of Normalization to improve performance. Involved in improving performance ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
  • Involved in Data Guard Configuration for Physical standby database or logical standby database using RMAN, Offline and active database
  • Improved performance of application by rewriting SQL queries
  • Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs
  • Designed Data Modeling, Design Specifications and to analyze Dependencies
  • Creating indexes on tables to improve performance by eliminating full table scans and views for hiding actual tables and to eliminate complexity of large queries
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE

Senior Oracle Developer

Confidential, Santa Clara, CA

Responsibilities:

  • Preparing Technical Specification Documents as per business requirements
  • Involved in Service Contracts creation and changes to service and Subscription agreements depending on business requirement
  • Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Alerts, Request Sets using PL/SQL technologies
  • Hands on experience in Oracle 10g technology for creation and modification of procedures, packages, triggers and reports.
  • Involved in Water fall report layout changes for column additions and addition to new org's requirements criteria
  • Used SQL*Loader as ETL tool to load data into staging tables
  • Involved in Termination lines changes and subsequent program changes in Event collection and Contingencies release level
  • Used DTS Packages as ETL tool for migrating Data from SQL Server 2000 to Oracle 11g
  • Implemented Data Guard -standby database for disaster recovery purpose
  • Involved in Summarize Data program performance tuning for long time running and glitches when running with Month end bill run process
  • Involved in oracle 10g area for the bugs raised in QA & UAT test cycles
  • Involved in Data Guard Configuration for Physical standby database or logical standby database using RMAN, Offline and active database
  • Resolving Performance issues related Pl/Sql Packages, Procedures & Functions.
  • Supporting QA, UAT and BAT Test Cycles

Oracle Technical Consultant

Confidential, Sunnyvale, CA

Responsibilities:

  • Preparing Technical Specification Documents as per business requirements
  • Involved in 11i To R12 Upgrade End To End process
  • Involved in R12 table level changes for existing Objects like Reports, Programs in 11i
  • Involved for enhancements related to oracle 10g for the existing objects
  • Involved in object changes related to R12 Version and creation of new logic and assignment
  • Identification of objects for R12 changes and modification to required reports, programs and removal of unwanted programs
  • Involved in data from extract, load and transformation (ETL) from EBS to Data warehousing using informatica tool and creation of dimensions and facts for reporting purpose
  • Developed new conversion script to upload customers from A-Log to Confidential system using customer API's
  • Involved in creation of new PI & ramp programs in Oracle 10g for the extract pulling on a monthly basis by Business
  • Extracted data from XML file and loaded it into database of different instances for development, testing purpose
  • Involved in Summarize Data program performance tuning for long time running and glitches when running with Month end bill run process
  • Co-ordination & Interaction with different application stakeholders, cross functional teams per new requirements, changes and acceptance
  • Supporting QA & UAT Test Cycles

Oracle Technical Consultant

Confidential, San Jose, CA

Responsibilities:

  • Preparation of MD70 documents as per business requirements
  • Identification of impacts on other tracks per this new / enhancement process implementation
  • Design and development database Tables, Triggers, Database Triggers, Cursors, Procedures, Stored Procedures, Functions, Forms, and Reports
  • Validated data and populated Payables interface table through Concurrent program which in turn submits standard Payables Interface program in AP
  • Developed various crucial financial analysis reports using oracle pl/sql

Oracle Developer

Confidential, Sunnyvale, CA

Responsibilities:

  • Preparing Technical Specification Documents as per business requirements
  • Fixed issues related to OM - SFDC integration area identified by QA and Business teams
  • Involved in development of forms & reports in Order Management (OM), Purchasing (PO), Accounts Payables (AP), Accounts Receivables (AR), Install Base (IB) & Service Contracts (SC) modules
  • Development of different oracle 10 custom programs as per requirements using PL/SQL technologies
  • Data uploaded from different process using SQL loader process

Oracle Developer

Confidential, San Jose, CA

Responsibilities:

  • Preparing Technical Specification Documents as per business requirements
  • Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms of 20 objects
  • Performed analysis and involved in development of Reports and Interfaces as per requirement
  • Support QA, UAT & BAT cycles

Hire Now