We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Richardson, TX

PROFESSIONAL SUMMARY

  • Over 7 years of experience in Analysis, Design, Development and Data processing using Oracle Technology on different platforms.
  • Expertise in SQL,PL/SQL Stored Procedures, Packages and Triggers, Tables, Indexes, Constraints, Materialized Views in Oracle 12c / 11g / 10g / 9i Databases.
  • TEMPEffectively made use ofIndexes, Table Partitioning, Collections, Analytical Functions, Materialized Views, Query Re - Write.
  • Experience in Query Optimization; performance tuning (PL/SQL) using SQL Trace, Explain Plan, TKPROF, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of Global Temporary Tables and Table Partitioning.
  • Working experience in domains like Airline Passenger Revenue Accounting, Marketing, Utilities and Automotive.
  • Experience withData Flow Diagrams, Data dictionary, Database Normalization Theory Techniques, Entity Relation modelingandDesign Techniques.
  • Expertise inall phases of SDLC includingrequirement analysis, database design, application design, development, testing, implementation andmaintenance.
  • Good experience of Performance Analysis and SQL Query Tuning, while designing scalable applications from scratch and maintaining existing ones.
  • Involved in Full Life Cycle Development (Agile) of building a Data Warehouse on Windows and Unix Platforms.
  • Solid experience in writing complex SQL queries and procedures to extract data from various source tables.
  • Regular activities like Backup & Recovery, Capacity Planning, Database Performance Tuning, Memory Tuning, Security Administration, Space Management and Index management.
  • CreatedTables, Views, Constraints, Indexes(B Tree, Bitmap and Function Based).
  • Experience inOracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
  • Experience in Oracle Cursor Management and Exception Handling.
  • Worked extensively onRef Cursor, External TablesandCollections.

TECHNICAL SKILLS

DB: -Oracle 12c /11g/10g/9i/8i, Sybase 11.

ERP: -Oracle Fusion CRM, Oracle apps R12, 11i.

Reporting Tools: -Oracle Discoverer 10g/4i, XML Publisher, Tableau, APEX, Oracle Reports6i/10g.

Tools: -SQL* Loader, Toad, Scoop, AutoSys, SVN, PVCS, Track-IT, GIT, JIRA.

Languages: -SQL, PL/SQL, HTML, UNIX Shell Scripting, XML, SAS, R, Python.

Operating systems: -SUN Solaris, HP-UX, UNIX, Windows.

PROFESSIONAL EXPERIENCE

Confidential - Richardson, TX

Oracle PL/SQL Developer

Responsibilities:

  • Responsible for migrating the SQL and Windows jobs onto Workload Scheduler.
  • Developed the Power Shell Scripts to execute the store procedures and SSIS packages commands in Tivoli command line.
  • Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors.
  • Creating primary objects (tables, views and indexes) once the application developers design an application.
  • Responsible for keeping all three environments PROD, UAT and DEV in sync for phase wise production releases and DB change management
  • Responsible for creating the Dynamic SQL to load the Data.
  • Experienced in Performance Tuning of poor SQL and PLSQL Procedures with the halp of Explain Plan, DBMS PROFILER and Oracle Optimizer Hints.
  • Experienced in developing Database Types and Objects for front-end applications and call them using a function.
  • Developed Triggers on tables and handled Mutating errors with the halp of PRAGMA AUTONOMOUS Transaction.
  • Developed Views, Materialized Views based on the requirement and refreshed them periodically.
  • Developed PL/SQL Procedures and database triggers for the validation input data and to implement business rules.
  • Experienced in Handling Exceptions in oracle Packages and procedures using Oracle Pre defined exception handlers and DML Error Logging techniques.
  • Experienced in Exception handling using predefined and user defined exceptions with error number and error messages
  • Extensive experience in creating reports by extracting targeted data, transforming it to fit operational needs and loading it into the data warehouse.
  • Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, etc. to import data into the data warehouse.
  • Developed Various SQL Scripts for Automation Process and AD Hoc Report Generation Process.
  • Data loaded from legacy systems (ETL Operations) using PL/SQL, SQL*Loader and SSIS.
  • Involved in SQL and PL/SQL performance tuning using EXPLAIN PLAN, TKPROF and DBMS PROFILER.
  • Hands on experience with oracle Export and Import Utility tools to migrate data through different environments.
  • Worked with Business team to gather the requirements.
  • Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
  • Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
  • Generated CSV Files with the halp of UTL PACKAGES and placed them into FTP Location.
  • Used PRAGMA Autonomous Transaction to avoid mutating error in database trigger.

Environment: Oracle 11g, UNIX, SQL, PL/SQL, Power Shell Script, Tivoli Workload Scheduler, UNIX shell script, Toad 12.6

Confidential, Florence, KY

Senior Member Technical

Responsibilities:

  • Delivery and support of PL/SQL functionalities - packages, cursor management, triggers and exception handling,
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
  • 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.
  • Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
  • Extensive experience in creating and maintaining Database Objects such as Tables, Views, Indexes, Constraints, Sequences, Synonyms and Database Links.
  • Design and develop PL/SQL processes to perform ETL processes using SQL Server Integration Services (SSIS).
  • Experienced in troubleshooting defects and performing system analysis to assist in solving technical and business-related problems/challenges.
  • Implemented best practices and performance tuning/optimizing for Data warehouse.
  • Involved in Major Patch Upgrade and Hot fix Deployments in Production Environments.
  • Consistently coordinating with clients to understand and resolve their queries.
  • Developed Unix scripts for data auditing, scheduling and automation.
  • Good Understanding of Jasper Reports, BO, PRISM, and QC report tools. Creating and modifying scripts as per client requirements.

Environment: Oracle 11g, SQL, PL SQL Developer, SQL *PLUS, Vi Editor, Eclipse, LINUX, Windows, HDFS

Confidential

Oracle PL/SQL Developer

Responsibilities

  • Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Debugging PLSQL objects and ProC (GDB) codes to analyze various issues raised by client.
  • Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
  • Created scripts to create new tables, views, queries for new enhancement in the application.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
  • Involved in using hints to direct the optimizer to choose a query execution plan.
  • Used Oracle PL/SQL jobs using DBMS JOB package.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Creation of database objects like tables, views, materialized views, procedures and packages as per the requirement, using oracle tools like PL/SQL Developer and SQL* plus.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
  • 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.
  • Getting required test environment signoff from client for all major upgrade activity on Production environments, by resolving all the issues rose during testing phase.
  • Improving Product Quality by avoiding temporary workarounds and providing permanent resolution for the redundant issues.
  • Good Understanding of business terms like Agile Methodology, SLA's and Service Credits.

Environment: Oracle 11g, SQL, PL SQL Developer, Putty, WinSCP, Desktop Intelligence (BO), SQL Loader, Beyond Compare, SAP Business Object

Hire Now