We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Miami, FL

SUMMARY

  • Around 8 years of experience in Analysis, Design, Development and Data processing using Oracle Technology on different platforms.
  • Extensively worked on PLSQL - Functions, Stored Procedures, Cursors, Triggers and Packages.
  • Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning.
  • Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelling and design techniques.
  • Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
  • Proficient in advance features of PLSQL programming like Records and Collections, Bulk load, Bind variables, Ref Cursors and Dynamic SQL.
  • Good Knowledge on Client-Server application development using Oracle PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.
  • Experience in designing, modeling, performance tuning and analysis, implementing process using ETL tool Pentaho data Integration tool for data extraction, transformation and loading process.
  • Mediation experience in handling Cedar, Cisco, Broad soft, EMI, AMA, IMS and Huawei Switch raw files with TBMS product.
  • Good experience in UNIX and Perl scripts to create reports and logs based on the business prerequisites.
  • Worked in Agile Methodology.
  • Worked on version control tools such as GitHub, ALM and used JIRA bug tracking tool.
  • Experienced in Production Support Role 24/7 to resolve the issues using in a ticketing system.
  • Collaborate well with Project Management, Business Analyst and Department management teams.
  • Flexible, enthusiastic and project-oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.
  • Worked extensively on Ref Cursor, External Tables and Collections.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • 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.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c, DB2/UDB, SAP Tables and MS Access

Other Technologies: HP ALM/QC, Oracle E-Business Suite 12, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM)

Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, XML, HTML

Dev. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, XCode, C.VS and Visual studio

Tools: TOAD, SQL*PLUS, SQL Developer, SQL*Loader and XML Publisher.

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Oracle PL/SQL Developer

Responsibilities:

  • Interacted with the clients to understand the requirements and Designing module wise Oracle 11g database structure and its implementation on the client server.
  • Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database.
  • Involved in ETL coding using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
  • Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  • Involved in writing the database triggers to furnish the audit details.
  • Troubleshoot performance issues and bugs within packages using DBMS output, explain plan.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Created indexes on the tables for faster retrieval of the data to enhance database performance.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Developed Unix Shell Scripts to automate backend jobs, load data into the database.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Partitioned the fact tables and materialized views to enhance the performance.
  • Define data transfer process through asynchronous web service using REST (HTTP).
  • Solid skills to configure Exadata to meet company internal security requirement.
  • Fix open ticket as created by users that includes code modification and issue data analysis.
  • Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  • Involved in analysis of report design requirements and actively participated and interacted with Technical Manager and worked with Business Analyst to understand the business requirements Provide full support for the team regarding issues, feature discussions and enhancements.
  • Worked on DB table partitioning and deploying various methods of indexing like local indexes and global indexes for tables with huge volumes of data.
  • Involved in writing and maintaining many PL/SQL stored procedures and SQL queries for populating the historical and daily data in production using TOAD.
  • Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  • Provided Tier3 Application support with 24/7 production support.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX Shell Scripting.

Confidential, Houston

Oracle PL/SQL Developer

Responsibilities:

  • Participating in Requirement Gathering sessions with end users.
  • Design and Development of the Oracle 12c Code and DB Objects like Tables, Procedures, Functions, Packages and Sequences, according to the System Requirements of the different modules to do the data quality testing.
  • Perform tuning of PL/SQL scripts and SQL statements or large datasets.
  • Analyze business data using Toad software on Oracle.
  • Communicating with users to collect requests for improving of the data quality.
  • Creating and making enhancements to UNIX scripts.
  • Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse Databases.
  • Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
  • Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
  • Creating Technical Design for the application, working with the Infrastructure team.
  • Involved in the application development, Peer reviews and Unit Testing.
  • Interaction with the clients on the requirements.
  • Analyzing and fixing the issues in the DB and ETL objects.
  • Requirement Analysis for the Development of the Change Requests (CRs).
  • Preparation of Approach Documents, Release Notes, Unit and Module Test Cases, Application and System set-up Documents.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  • Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
  • Involved in writing complex scripts for Data Transformation, ETL process (Extract, Transform & Load).
  • Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse.
  • Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
  • Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, join types and operations and providing hints.
  • Review data transformation rules
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Working with the DBAs and Environmental Engineering teams on the Code deployment.

Environment: Oracle 12c, Web Services, Quality Stage 8.1, Oracle SQL, PL/SQL, TFS (Visual studio), Telerik, XML, SQL, PLSQL, SQL Tuning, WinSCP, Putty.

Confidential, Columbus, Ohio

Oracle PL/SQL Developer

Responsibilities:

  • Involved in development, maintenance of Triggers, Joins, Cursors and Views.
  • Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
  • Azure Networking-VNET, VPN-S2S, P2S, Express route, Sonic WALL, SSL, Azure VMs, Azure Web/App, Azure Logic Apps, Azure Functions, Azure POWER BI, Azure Billing, Azure Subscription and Account management, Azure NSG, Azure Load Balancer, AZURE ASM to ARM migration.
  • Fix open ticket as created by users that includes code modification and issue data analysis.
  • Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
  • Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
  • Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
  • Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
  • Developed UNIX Shell Scripts. Customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
  • Optimized the performance using PL/SQL table types and record types.
  • Did SQL and PL/SQL programming for ODI and oracle.
  • Developed AR Credit memo and AR Customers forms.
  • Worked extensively with ODI Designer, operator and metadata Navigator.
  • Analysis and generation of mainframe commands to add users to missing mainframe groups as well as analysis of RACF permission sets and reporting of access that users may lose based on the clean-up process.
  • Played a major role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
  • Participate in upgrading Oracle database(s) and Oracle Warehouse Builder to Version 11.2.0.4
  • Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed DAO layers in applications to access the db objects from Java.
  • Analyzed queries using SQL Trace facility and Explain Plan utility to obtain the execution process. Optimized the queries by modifying the data access methods, Index strategies, join types and operations and providing hints.
  • Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
  • Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
  • Wrote SQL queries to developed test data for use during test execution.
  • Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.
  • Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers.
  • DataStage jobs were scheduled, monitored, performance of individual stages was analyzed, and multiple instances of a job were run using DataStage Director.
  • Created complicated reports using reporting tool Cognos.
  • Used DS Erwin MetaBroker to import Erwin 4.x Metadata into Data Stage Repository.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g.

Hire Now