We provide IT Staff Augmentation Services!

Oracle Developer Resume Profile

4.00/5 (Submit Your Rating)

UsA

Hire Now

SPECIALITIES:

  • Oracle SQL
  • PL/SQL Programming
  • Shell Scripting
  • ETL using Informatica PowerCenter
  • Job Scheduling Automation Control-M

SUMMARY

Oracle Certified PL/SQL developer having ten years of experience in Design, Development, Enhancement and Maintaining applications in Oracle 8i/9i/10g/11g using SQL, PL/SQL in Windows and UNIX environments. Experienced in systems analysis, programming, addressing unique issues of architecture and data management. Strong Oracle SQL and Oracle PL/SQL skills Strong UNIX Shell Scripting skills. Knowledge on Performance tuning using Explain Plan. Strong Informatica and Control-M Job scheduling skills. Experienced in different types of testing which includes Unit, Black Box, Regression and System Testing. Experienced in creating functional and technical specification documents with high standards. Excellent logical and analytical skills to solve complex problems Highly capable of learning new technologies and adapt to new environment in quick time. Good team player. Worked extensively in Financial Services domain.

TRAINING WORKSHOPS

SQL Performance tuning, Fidelity workshop 2 Days

Training on Shell scripting, Fidelity workshop - 2 Days

ETL using Informatica tools, AavisPro workshop - 3 Days

TECHNICAL EXPERTISE

Languages SQL, PL/SQL, Shell Scripting, Pro C and Visual Basic RDBMS Oracle 8i/9i/10g/11g

Database Tools TOAD, SQL Developer, SQL Navigator and SQL Plus

Platform Windows, AIX and UNIX ETL Tool Informatica PowerCenter Web Development HTML, XML and VB Script Testing Tools Quality Center, QTP and Clear Quest

PROJECT EXPERIENCE

Confidential

Environment: Oracle 11g, PL/SQL, Toad, Shell Scripting, Control-M, Informatica

Role:

  • Performance enhancements using query optimization techniques and indexes
  • Develop new modules using oracle packages and shell scripts.
  • Design and analyze all enhancements to the database application.
  • Coordinate with data suppliers to configure daily data feeds.
  • Build and maintain report and notification system for the data staging.
  • Coordinating with the data analysts for production release.
  • Automating job scheduling using BMC Control-M.
  • Developed Informatica objects - mappings, sessions, and workflows based on the prepared low level design documents.

Confidential

Environment: Oracle 10g, PL/SQL, Toad, Shell Scripting, Control-M, SSRS

Role:

  • Developed the Forms Authentication Custom Security Extension for the SQL Server 2005 Reporting Services.
  • Developed the business logic, stored procedures, functions and triggers to supplement report specification and feed calculated data to the reports.
  • Processing and loading weekly data files
  • Automating job scheduling using BMC Control-M.

Confidential

Environment: Oracle 10g, PL/SQL, Toad, SQL Plus

Role:

  • Extensively involved in creating database packages, procedures, functions, cursors and triggers using PL/SQL.
  • Preparation, Maintenance and Enhancement of PL/SQL Procedures and Functions.
  • Analyze business systems requirements and design technical solutions based on those requirements
  • PL/SQL code review and modification for the development of new requirements.
  • Optimized SQL queries for better performance.
  • Created batch jobs using ETL tool for loading database tables from Flat Files with SQL Loader.
  • Used PL/SQL tables, array structures as a part of oracle collections
  • Supporting existing programs and modules.
  • Extensively used UNIX Shell Scripts for automating batch programs.
  • Involved in the Requirement Analysis and Preparation of functional Specification Documents.
  • Developed Technical specification documents Change Request documents.
  • Developed unit and integration test scenarios to support new programs, program changes and configuration.

Confidential

Environment: Oracle 9i, PL/SQL, Toad

Role:

  • Designed/developed tables, views, various SQL queries, stored procedures and functions.
  • Extensively developed complex PL/SQL packages for EBS systems.
  • Preparation, Maintenance and Enhancement of PL/SQL Procedures and Functions.
  • Analyze business systems requirements and design technical solutions based on those requirements.
  • PL/SQL code review and modification for the development of new requirements.
  • Extensively involved in creating procedures, functions, cursors and triggers using PL/SQL.
  • Optimized SQL queries for better performance.
  • Extensively used UNIX Shell Scripts for automating batch programs.
  • Developed functional specifications and prepared Technical Change Request documents.
  • Involved in Unit Testing and Integration Testing.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship