We provide IT Staff Augmentation Services!

Resume

5.00/5 (Submit Your Rating)

Oracle Pl Sql, DevelopeR

Hire Now

SUMMARY:

  • Over 9 years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
  • Extensive experience in Project Life Cycle including requirement gathering and Analysis, Database design, Database development, Application development, Test and Support.
  • Strong knowledge of Oracle 9i/10g/11g, PL/SQL.
  • Extensively worked in Oracle environment using Oracle SQL developer, SQL*Plus, SQL*loader, UNIX, Toad and Oracle Forms/Reports.
  • Expert in creating PL/SQL Packages, Subprograms, Triggers, Views, Indexes, Constraints, Sequences, Exception Handling, Collection Types, Record Type, Object Type using SQL Developer.
  • Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors
  • Experienced in Performance Tuning and Optimization of SQL statements.
  • Knowledge in UNIX shell scripting.
  • Knowledge in using analytical functions, hierarchical queries.
  • Experience in writing dynamic SQL statements using EXECUTE IMMEDIATE and DBMS SQL.
  • Working Knowledge on Extraction, Transformation and Loading process (ETL).
  • Good knowledge in data flow diagrams, data dictionary techniques, Entity Relation modeling, database normalization.
  • Working knowledge on using new partitioning techniques like Interval, reference and extended composite (List - List, List-Range) partitioning.
  • Strong experience in end to end SDLC project implementations.
  • Knowledge in Informatica and Data Warehouse concepts.
  • Knowledge on Microsoft SQL Server 2008 and Analysis Services (SSAS).
  • Familiarity with Oracle data warehousing features such as star & snowflake data modeling schemas, materialized views, Dimensions, Facts etc.,
  • Experience in on-call 24*7 support in production environment.
  • Excellent communication and interpersonal skills and ability to work independently and in a team with minimal supervision to meet the deadlines.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g/12c, MS SQL Server 2000, MS Access, DB2

Tools: SQL* Plus, Toad, SQL Developer, PL/SQL Developer, Crystal Reports, MS Visio, Text Pad, ERWIN, SAP Business Objects Data Services, Query Management Facility (QMF), IBM File Manager, Job Management Report (JMR), Rational Clear Quest, CCCA Tool

ETL Tools: SAP Business Objects Data Service designer 14.0, Informatica Power Center 9.1, SQL*Loader, UTL FILE, SSIS

Web Technologies: HTML, CSS, XML, JAVA

Languages: C, C++, Sql, PL/SQL, COBOL, JCL, JAVA, C#

Operating Systems: Windows, UNIX, LINUX

Processes: Defection Prevention, Configuration Management, VSS source management, VFS source management, CA Harvest

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL developer

Responsibilities:

  • Extensively worked in Oracle environment using Oracle SQL developer, SQL*Plus, SQL*loader, UNIX, Toad and Oracle Forms/Reports.
  • Expert in creating PL/SQL Packages, Subprograms, Triggers, Views, Indexes, Constraints, Sequences, Exception Handling, Collection Types, Record Type, Object Type using SQL Developer.
  • Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors
  • Experienced in Performance Tuning and Optimization of SQL statements.
  • Knowledge in UNIX shell scripting.
  • Knowledge in using analytical functions, hierarchical queries.
  • Experience in writing dynamic SQL statements using EXECUTE IMMEDIATE and DBMS SQL.
  • Working Knowledge on Extraction, Transformation and Loading process (ETL).
  • Good knowledge in data flow diagrams, data dictionary techniques, Entity Relation modeling, database normalization.
  • Working knowledge on using new partitioning techniques like Interval, reference and extended composite (List - List, List-Range) partitioning.
  • Strong experience in end to end SDLC project implementations.
  • Knowledge in Informatica and Data Warehouse concepts.
  • Knowledge on Microsoft SQL Server 2008 and Analysis Services (SSAS).
  • Familiarity with Oracle data warehousing features such as star & snowflake data modeling schemas, materialized views, Dimensions, Facts etc.,
  • Experience in on-call 24*7 support in production environment.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship