We provide IT Staff Augmentation Services!

Oracle Pl / Sql Developer Resume Profile

Pittsburgh, PA

EXPERTISE:

  • 7 Years of IT experience in analysis, design, development, testing, implementation maintenance of application software in Oracle, SQL, PL/SQL, Oracle Forms, Oracle Reports, and Unix
  • Expert in creating tables, packages, stored procedures, advanced queries, triggers, views, indexes and functions for databases .
  • Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 11g EXADATA , 10g, 9i, 8i.
  • Strong knowledge on oracle architecture and database design.
  • Experience in Database design using Normalization and E/R diagrams.
  • Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views and Table Partitioning.
  • Extensively worked with collections to reduce the overhead and improve the performance using bulk collect and bulk bind. Also handled exceptions in collections using Save Exception and BULK EXCEPTIONS.
  • Experienced with DBA activities like creating users, granting and revoking privileges on database objects.
  • Worked with Cursors and REF Cursors for temporary work area and performed data manipulations.
  • Worked with data transformations and loading using Export/Import file packages and SQL Loader and also created external tables to manage data which is stored at the operating system.
  • Created Instead of triggers for updating join views with DML operations.
  • Created Global temporary tables to maintain session data and improved the performance of data retrieval and created views, indexes, triggers on them.
  • Resolved mutating table errors using the new functionality in Oracle 11g through Compound triggers.
  • Worked with dynamic SQL queries by creating SQL queries at runtime using EXECUTE IMMEDIATE, DBMS SQL.
  • Expertise in optimizing and tuning of SQL Queries and PL/SQL applications using utilities like Explain plan, TKPROF hints, and scheduling the tasks using DBMS JOB/DBMS SCHEDULER.
  • Experience in unit testing and maintenance of the developed code.
  • Strong experience of complete software development life cycle SDLC and software quality procedures and practices.
  • Expert level experience with Oracle 11g, 10g, 9i, 8i, Oracle Forms and Reports.
  • Developed various complex reports like matrix, summary based on the user requirement using Oracle Reports 10g.
  • Excellent analytical skills, logical reasoning, and interpersonal skills.
  • Creative, Aggressive and highly motivated team payer capable enough to work and lead a team besides being capable to work independently.
  • Well versed in basic development tools like TOAD and Oracle SQL developer.

TECHNICAL SKILLS:

Operating System: Win NT, Win 98, Win XP, Win 2000, Win 2000 Server, Win 2003 Server, UNIX

Databases: Oracle 9i, 10g, and 11g EXADATA and RAC

Languages: Oracle SQL, Oracle PL/SQL, Java

Management Tools: SQL Plus, SQL Loader, PL/SQL Developer, Toad

Project Methodologies: Waterfall, Agile, Spiral, SDLC, and UML

Business Modeling Tools: Rational Rose, MS Visio

Requirement Management Tools: Rational Requisite Pro

Business Modeling Tools: Rational Rose, MS Visio

Business Applications: Ms Access, Excel, Word, Outlook, PowerPoint,

Networking: LAN/WAN Environments, TCP/IP Suite, Router Switch Configuration.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL / SQL Developer

Responsibilities:

  • Actively participated in different phases of development like Requirements gathering, Design, Coding, Implementation and maintenance using primarily PL/SQL batch processing.
  • Designed the DDL create Tables, indexes, truncate, etc. as well as analyzed, developed and tuned the DML Update, Insert, Delete of the daily and monthly ETL.
  • Wide variety of applications housed by the different departments of the university needed data in a structured fashion as per their requirements. Gathered requirements, analyzed them, and designed and implemented a secure way to transfer sensitive and non-sensitive data to various departments of the University for their Individual Application Needs
  • Provided 24 7 application support for mission critical applications
  • Also provided critical nightly support for the daily and monthly ETL throughout the night usually after any issues with ETL or change management
  • In order to facilitate the end user reporting of different data as presented through conformed dimensions, Materialized views were designed, developed, implemented and optimized.
  • Extensively involved in writing SQL queries Sub queries, Nested queries and Correlated , PL/SQL
  • Programming using analytical functions likes ROW NUMBER, Rank, Dense Rank, Pivot/Unpivot, List/Lag, LISTAGG etc.
  • Used the advanced features of PL/SQL like collections, nested table, vary and dynamic SQL
  • The PL/SQL code was developed in development environment moving it to testing and then after the extensive testing to production. As per university's standard SDLC practices were used to move the code between environments
  • Worked extensively with DBAs to gather requirements and resources on the Real Application Cluster RAC database running on oracle 11gR2 11.2.0.4
  • Tested new enhancements and bug fixes before deployment into the production environment

Environments: Oracle 11g RAC Environment , Toad, SQL Plus, SQL developer, Talend, Win XP

Confidential

Oracle PL / SQL Developer

Responsibilities:

  • Worked with the Business Analysis team to define requirements
  • Developed a proof of concept data models to validate request were attainable
  • Created a number of adhoc data pulls to review with the business to validate the data
  • Conformed to Giant Eagle PL/SQL coding standards
  • Followed and enforced Giant Eagle data governance policies
  • Designing of Data Modeling the design specifications and to analyze Dependencies
  • Responsible for creating and maintaining the Packages, Stored Procedures, Functions and Cursors
  • Maintaining the Database changes according to the client's requirements
  • Created Database objects such as Tables, Views, Synonyms, Indexes, Sequences and Database links as well as custom Packages Tailored to business need
  • Created External tables that are receiving data files from source systems which are then utilized for the ETL processes within the DW
  • Developed various ETL processes extracting data from different sources using db link and performed transformations using PL/SQL to load them into the various DW environments
  • Developed various complex PL / SQL Packages, using Oracle's latest features such as Nested Objects, VARRAYS, Materialized Views
  • Optimized the SQL Query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful indexes.
  • Performance Tuning of SQL and PL / SQL objects
  • Participated in day time batch support for the Data Warehouse
  • Creating the Control files to implement the latest database changes in the existing database
  • Involved in Unit level Testing, Module level Testing and System Testing
  • Wrote Documentation for implementing Packages jobs to run daily and weekly
  • Tested new enhancements and bug fixes before deployment into the production environment
  • Developed UNIX Script to create FTP Jobs
  • Worked as part of a team to launch new application releases under strict time deadlines
  • Developing UNIX Shell Script to download data from different data sources SAP
  • Designed database tables using various normalization techniques and database rules
  • Developing Control files using SQL Loader to perform bulk data loads into database tables from external data files

Environments: Oracle 11g EXADATA , SQL Loader, SQL Plus, Harvest, SVN, Autosys, Win XP

Confidential

Oracle PL / SQL Developer

Responsibilities:

  • Involved in Gathering Business Requirements from the business users on a regular basis to collect specifications to achieve goals.
  • Involved in configured and designed Entity Relationship Diagram ERD with data design team to
  • Illustrate the logical structure of database.
  • Involved in Designing of Data Modeling the design specifications and to analyze Dependencies
  • Responsible for creating and maintaining the Packages, Stored Procedures, Functions and Cursors
  • Creating Flat files by using the Built-in Packages to support the Planning administration
  • Maintaining the Database changes according to the client's requirements
  • Created Database objects such as Tables, Views, Synonyms, Indexes, Sequences and Database links as well as custom Packages Tailored to business requirements
  • Developed various complex PL / SQL Packages, using Oracle's latest features such as Nested Objects, VARRAYS, Materialized Views
  • Optimized the SQL Query performance with modification in PL/SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful indexes.
  • Performance Tuning of SQL and PL / SQL objects
  • Designed applications using Oracle 10g forms while working with Front end team.
  • Creating the Control files to implement the latest database changes in the existing database
  • Involved in Unit level Testing, Module level Testing and System Testing
  • Wrote Documentation for implementing Packages jobs to run daily and weekly
  • Tested new enhancements and bug fixes before deployment into the production environment
  • Developed UNIX Script to create FTP Jobs
  • Worked as part of a team to launch new application releases under strict time deadlines
  • Developing UNIX Shell Script to download data from different data sources SAP
  • Designed database tables using various normalization techniques and database rules
  • Developing Control files using SQL Loader to perform bulk data loads into database tables from external data files

Environments: Oracle 10g/9i, Oracle 10g forms and reports, SQL Loader, SQL Plus, Win XP

Confidential

PL/ SQL Oracle Developer

Responsibilities

  • Designed and developed the system using Oracle CASE Generation Methodology
  • Interacted with business users and analysts and gathered and documented the technical and business metadata.
  • Involved in ER diagrams Physical and Logical using Erwin and mapping the data into database objects. Created and configured the database, created the tables, created the indexes having required constraints.
  • Created new database objects like stored procedures, Functions, Triggers, Indexes, packages ,Join in PL/SQL
  • Programming with Transact SQL Batches, Transactions, Developed complex SQL queries using various Joins and Sub-queries.
  • Designed application with Oracle 10g forms and generated reports using oracle 10g reports.
  • Provided solutions for storing and faster retrieval of data from Oracle DB using indexes and fine tuning of SQL queries using SQL TRACE, TKPROF, EXPLAIN PLAN DB Performance Monitoring on daily basis
  • Analyzed and modeled data for Logical to Physical Data models using Erwin
  • Created SQL and PL/ SQL scripts, calling C external routines from within PL/ SQL for transfer of data between the databases
  • Designed and Generated reports using REF cursors
  • Integrated and implemented the system responsible for troubleshooting
  • Involved during User Acceptance Testing of the application
  • Participated in Code and Design Reviews for the ODS project for backend data population and reporting system
  • Participated in status meeting and walkthroughs
  • Used Shell Scripts for day-to-day use of queries on Data Dictionary and other common tasks on UNIX
  • Implementation at the Clients site and imparting user training

Environment: Oracle 9i, SQL PLUS, Oracle 10g forms and reports, PL/SQL, UNIX

Hire Now