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