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