We provide IT Staff Augmentation Services!

Sr. Pl/sql Developer Resume

Iselin, NJ

EXPERIENCE SUMMARY:

  • 7 years of experience in Software design, development and implementation of Oracle, SQL, PL/SQL applications.
  • Excellent knowledge in Oracle 8i/9i/10g/11g SQL and PL/SQL.
  • Experience in Relational Data Base Management Systems (RDBMS).
  • Extensively worked in Client-Server application development using Oracle 11g/10g/9i/8i Forms 9i/6i, Reports 10g/6i/6.0, SQL, PL/SQL.
  • Proficient in designing, modeling, creating and maintaining oracle database.
  • Experience in writing SQL queries, functions, packages, cursors and stored procedures, database triggers using PL/SQL in Oracle.
  • Experience in application development using various advanced features of Oracle like Collections, Table Functions, Dynamic SQL, Object types and Records.
  • Involved in query performance of slow SQL statements by implementing Index, using FORALL and BULK COLLECT.
  • Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities provided by oracle.
  • Experienced in working with utilities like SQL * loader, External tables, import, export to extract large volume of data.
  • Expert in Oracle database and GUI design and development of high performance technical solutions to meet the challenging business demands to the clients.
  • Expert in Creating PL/SQL procedures, packages, functions, database triggers and other database objects like to generate back-end and front-end reports.
  • Experience in Application Development using Forms, Reports and Discoverer.
  • Strong experience in Oracle Workflows.
  • Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.
  • Experienced in data analysis, data modeling, development, testing and documentation ofprojects.
  • Had good experience with Object-Oriented Design, application design and development using SQL (SQL*Reports, complex queries, views, group queries, tree queries, nested query, sub queries), PL/SQL (Functions, Procedures, Triggers, Packages and Oracle inbuilt packages).
  • Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
  • Excellent working and conceptual knowledge of PL/SQL, HTML and XML Technologies.
  • Knowledge of Database design, E-R diagrams.
  • Experience in Software Development Life Cycle (SDLC) including analysis, logical design, Resource Planning, code development, testing, implanting and maintenance
  • Worked on ETL- extraction, transformation and load.
  • Possess good communication skills.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, SQL server 2000/2005, MS Access (2000, XP)

Languages: SQL, PL/SQL

DB Utilities: Oracle APEX 4.2, Toad, PL/SQL Developer, SQL Developer, SQL Loader, SQL Navigator.

GUI Tools: Developer 2000(Forms 6i/9i/10g, Reports 6i/9i/10g, Graphics), BI, Publisher, XML, MS Excel, Visual studio.

Operating Systems: Windows, UNIX, and Mac.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. PL/SQL Developer

Responsibilities:

  • Involved in the business requirements gathering and analysis, understanding client’s Data Warehousing requirements and system analysis.
  • Creation of database objects like Tables, Indexes, Views, Materialized Views, Packages, Triggers,Sequences and Synonyms.
  • Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries.
  • Used Oracle SQL Developer for creating PL/SQL (trigger, sequence, stored procedure).
  • Developed complex SQL queries for data retrieval from various database objects including tables and views.
  • Used Explain plan and Tkprof to tune the long running and queries and modified scripts.
  • Written procedures for jobs that runs daily.
  • Jobs include inserting new records into the existing table if not present or update the values in table for the records that are already present.
  • Developed procedures for tree views.
  • Tree views contains the hierarchical view of information which can be expanded to reveal the sub-items if exists and collapsed to hide sub-items. Used cast, regular expression regex() functionsfrequently.
  • Created transaction tables from the existing tables by writing procedures.
  • Transaction tables are derived from the original tables in which different rows of transaction table are populated from a single row of the original table.
  • Worked with ArcGIS developers and have a very good understanding of Geographic Information Systems (GIS) concepts.
  • GIS lets us visualize, question, analyze, and interpret data to understand relationships, patterns, trends and it can relate unrelated information by using location as the key index variable.
  • Developed Stored Procedures in PL/SQL for cleaning up data and providing underlying structure for reporting using SQL Involved in review, testing and logging defects of the code designed .

Environment : Oracle 11g, PL/SQL, TOAD, SQL * Developer, UNIX and Windows.

Confidential

Sr. PL/SQL Developer

Responsibilities:

  • Involved in complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing.
  • Ensure conformance to code standards and documentation requirements.
  • Creation of database objects like Tables, Indexes, Views, StoredProcedures, Functions, Packages, Triggers, and Synonyms.
  • Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
  • Developed Installation scripts for all the deliverables.
  • Developed views to facilitate easy interface implementation and enforce security on critical customer information.
  • Used Dynamic SQL programming technique to build and process SQL statements. Used TOAD, PL/SQL developer tools for faster application development.
  • Performed exception handling.
  • Writing validation packages using PL/SQL package using Data Structures.
  • Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
  • Apart from developing, other day-to-day responsibilities involved supporting production with issues related to day-to-day data fixes and debugging aborted processes.
  • Documenting procedures and scripting, and eventually be drafting up them into Unit test plans.
  • Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Performed functionaltesting for the procedures and packages.

Environment : Oracle 11g, PL/SQL, TOAD, SQL * Loader, UNIX and Windows.

Hire Now