We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Pittsburgh, PA

SUMMARY:

  • Dynamic professional with 8+ years of extensive experience as an Oracle PL/SQL Developer with ETL, shell scripting experience in diverse sectors including Finance, telecommunication, Health care.
  • Expertise in Software Development Life Cycle(SDLC) of client implementations including requirements gathering, business analysis, system configuration, design, development, testing, technical documentation and support.
  • Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 12c/11g/10g database.
  • Strong experience in providing technical documentation and status reports of teh applications as per teh requirement.
  • Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i, Reports10g/9i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
  • Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
  • Strong technical background with approximately three years of production support experience in SQL, PL/SQL, Oracle, UNIX, and Shell Scripting.
  • Proficient in loading data from flat files into database tables using SQL*Loader scripts.
  • Involved in Oracle Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQLTrace and TKPROF.
  • Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL Plus,FileZilla, WinSCP.
  • Working experience in Data Extraction, Transmission and Loading (ETL).
  • Experience in using data sources/targets such as Oracle 12c/11g/10g, MS SQL Server 2008/20012, DB2, XML and Flat files.
  • Good understanding of data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
  • Developed Oracle Forms and Oracle Reports using 11g,10g depending on teh functional requirement document.
  • Proven ability to work efficiently in both independent and team work environments.
  • Excellent communications and analytical skills.
  • Having experience as Lead. Lead offshore team.
  • Having knowledge on TALEND.
  • Highly organized and efficient to prioritize and manage multiple tasks.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g, MS SQL 2008/2012, MS Access, DB2

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming

Oracle Tools/GUI: Forms 9i/10g, Reports 9i/10g, Discoverer 11g

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, JavaScript, CSS, DHTML, XML

Operating Systems: Windows Family, MS-DOS

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Oracle PL/SQL Developer

Responsibilities:

  • Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
  • Worked in PL-SQL code tuning System Analysis, Design, Coding, Testing, Development and Documentation.
  • Created schema objects like tables, indexes, synonyms, sequences, stored procedures, functions, packages and views.
  • Heavily involved in UNIT testing teh database code for data integrity, module testing for validating each module independently, application testing for application functionality and integration testing of all modules together.
  • Worked on both proactive and reactive SQL Tuning and Query Optimization Techniques for complex SQL Statements.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of databases.
  • Worked on Query Optimization Techniques for complex SQL hints Statements. Used Performance Monitor and Explain Plan for performance tuning to enhance teh performance of databases.
  • Fixing performance problems with PL/SQL programs.

Environment: Oracle 11g client version,12c, SQL Developer, UNIX Shell Scripts, Perl programming, ETL, SQL*Plus, MS Excel, MS- Visio, VI Editor, HTML, Java script, CSS.

Confidential, Rochester, NY

Oracle PL/SQL Developer

Responsibilities:

  • Custom tables and new custom objects were designed as per business requirements.
  • Involved in all phases of SDLC as active participant.
  • Designing, Developing, Enhancing and Maintaining Data warehouse Oracle ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.
  • Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
  • Used various Indexing and partition techniques to improve teh query performance.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Improved teh performance of teh application by rewriting teh SQL queries.
  • Created Materialized Views, tables, complex SQL queries, correlated sub queries, Nested Queries, Views and Function Based Indexes for effective Business Application Development.
  • Designed and developed Oracle PL/SQL Procedures, Functions and Database Triggers and involved in creating and updating Packages to meet business requirements.
  • Created PL/SQL stored procedures, functions and packages for moving teh data from staging area to data mart.
  • Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures.
  • Used Dynamic SQL to implement DDL statements in PL/SQL programs.
  • Created scripts to create new tables, views and queries for new enhancement in teh application using TOAD.
  • Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
  • Leading offshore team.

Environment: ORACLE 11g, SQL Developer, TOAD, UNIX, FileZilla & WinSCP, WebLogic, Vector wise.

Confidential, king of Prussia, PA

Oracle PL/SQL Developer

Responsibilities:

  • Created numerous stored procedures and used procedural parameters to work with packages & exception handling.
  • Designed and developed Oracle database Tables, Views, Indexes, Sequences and Synonyms.
  • Experience in working with scalar and composite data types.
  • Extensively used PL/SQL Packages, Stored procedures, Triggers and tuned them for performance considerations
  • Used SQL Loaders to load data from flat files into database tables.
  • Dedicated to optimizing teh code written by various developers and worked on performance tuning with optimization techniques in PL/SQL.
  • Wrote feed handlers using Perl and DBI to update an Oracle 10g/11g database.
  • Collaboratively worked with DBA on performance tuning.
  • Used oracle forms and created various reports using Oracle Reports Builder for day to day validations.
  • Involved in performance testing of teh overall application and tune teh SQL Queries and database where needed using Explain plan.
  • Expertise in solving complex queries and improves teh performance of application by performance tuning.
  • Implemented ETL processes, Data flows and Data Marts based on business requirement.
  • Understanding and Troubleshooting complex customer issues on production environment. Responsible for identifying any bugs occurring in teh applications as well as fixing them.

Environment: Oracle 11g, Forms 9i, Reports 9i, SQL Loader, SQL Developer, Windows 7, UNIX Shell Scripts, Perl programming, ETL, MS Excel, MS- Visio, VI Editor, HTML, JavaScript, CSS.

Confidential

PL/SQL Developer

Responsibilities:

  • Implemented views for security purposes. Assigned views to other schemas when needed to hide teh business information.
  • Developed stored procedures and triggers to facilitate consistent data entry into teh database.
  • Developed Oracle Forms and Oracle Reports using 10g depending on teh functional requirement document.
  • Involved in database migration from Oracle 9i to 10g database and generated oracle forms and reports.
  • Actively involved in system analysis and data modeling to create tables, views, indexes, synonyms, triggers, functions, procedures, packages and cursors.
  • Worked on advanced concepts of PL/SQL such as Records, Collections and Dynamic SQL.
  • Created Database triggers for quickly retrieving a row and performed validations.
  • Used pipelined functions for faster data accessibility.
  • Expertise in solving complex queries and improves teh performance of application by performance tuning.
  • Resolved teh issues in conflicts between teh target and source database in gloden Gate.
  • Expertise on performance tuning on SQL using Auto Trace, Explain Plan utilities.
  • Created various stored procedures, functions, packages and triggers using TOAD environment.
  • Wrote feed handlers using Perl and DBI to update an Oracle 11g database.

Environment: Oracle 11g, Crystal Reports XI, Data Integrator, MS Excel, TOAD, WebLogic, XML, XSLT, UNIX, Microsoft Office, Version Control Software, UNIX Shell Scripts.

Confidential

Oracle Developer

Responsibilities:

  • Created well defined stored procedures, functions, packages, collections, triggers & object types.
  • Improved Data optimization and manipulation of staged data using PL/SQL packages.
  • Proficient in SQL DDL, DML, DCL, TCL & SELECT statements.
  • Involved in database migration and identified various scenarios during teh upgrade for oracle 10g.
  • Worked on complex SQL and PL/SQL queries. Implemented cursors, ref cursors, sub queries, correlated sub queries.
  • Developed Test Cases in Unit Testing and System Integration Testing.
  • Created SQL code for generating PRIMARY KEY using Oracle SEQUENCE objects.
  • Worked with Erwin for data modeling. Participated in code review meetings with teh development team.
  • Effectively used Oracle predefined functions such as Single row and multiple rows.
  • Documented and archived historical data for future auditing purposes. Responsible for production support and troubleshooting teh production issues.

Environment: Oracle Database 10g, Windows XP, TOAD, SQL Loader, JavaScript, LINUX.

Confidential

Jr. Oracle Developer

Responsibilities:

  • Analyzed business requirements of teh project by studying teh Business Requirement Specification Document.
  • Creation of database objects like tables, views, procedures, packages using Oracle utilities like SQL Plus, SQL Loader and Exception handling.
  • Designed teh front-end interface for teh users using oracle Forms, Reports using 8i
  • Timely monitoring of database and system backups developedOracle stored procedures, functions, packages and triggersthat pull data for reports.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
  • Participated in Performance Tuning for query optimization and program performance.
  • Involved in Technical Documentation, Unit testing, Integration testing and writing teh Test plan.
  • Use joins on various tables and display data from multiple tables.
  • Automated Quality Check tasks by creating PL/SQL cursors, functions and dynamic SQL.

Environment: Oracle 10g, SQL Plus, Windows XP, UNIX, HTML, Oracle SQL Developer, Erwin, Oracle, InformaticaPowerCenter 8.6/8.1, Java, MS Access 2000/2002.

Hire Now