We provide IT Staff Augmentation Services!

Oracle Sql Developer Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Information technology professional with over 15 years of experience.
  • Proficient working with relational databases.
  • More than 15 years of Oracle backend programming experience.
  • Experience database designing and tuning process.
  • Performed analysis and translated business needs to create high - quality business requirements and functional specifications documentation.
  • Experience in full circle application programming, implementation and support.

TECHNICAL SKILLS:

Environment: s: MS-DOS, OS/2, Windows 3.11/95/98/2000/ XP/NT, UNIX

Languages: Crystal Report 9.0/8.0/6.0/5.0/4.6 , Oracle Forms 6i/4.5,PowerBuilder 10.0/8.0/5.0/4.0 , Visual Basic 6, EDGE Development.

Database Related: ORACLE 8.x, 9i, 10G, SQL, SQL* Plus, PL/SQL, Sybase 10.02, Watcom SQL 4.0. Neteeza

Applications: Oracle Enterprise Manager, Business Objects 5.1, PL/Vision 98.1,Toad 10, SQL Navigator 4.4, InfoMaker 5.0/4.0., Discoverer 10.1, Warehouse Builder 10g, SQL Developer, PL/SQL developer

EXPERIENCE:

Confidential

Oracle SQL Developer

Responsibilities:

  • Creating new and optimizing existing complicated SQL statements, creating PL/SQL packages, procedures and functions for dataload into reporting(staging) tables on Oracle 11g (Data Warehouse) for marketing reports and dashboards.

Confidential

Oracle Developer, Consultant

Responsibilities:

  • Created and modified packages, stored procedures and functions for preparing data for marketing analysis reports using Oracle 11g on large size databases.
  • Creating complicated SQL statements and PL/SQL scripts for packages, stored procedures, functions and triggers on Windows NT platform using Toad, SQL Developer and PL/SQL Developer.
  • Performed SQL statements optimization and created materialized and log views for optimizing data extract process. Participating in data modeling for existing and new reports.

Confidential

Programmer/Analyst

Responsibilities:

  • Created scripts for data loading, producing auditing merchandise reports using Oracle 9i/10G(10.2) on large size databases . Wrote complicated SQL statements, PL/SQL packages, stored procedures, functions and triggers on Windows NT and Unix and Linux platform.
  • Participated in data modeling for existing and new reports.
  • Created tables, views, indexes , triggers, Oracle stored procedures, functions, packages, PL/SQL scripts using Oracle 9i/10G(10.2) .
  • Was heavily involved in all stages of moving process to Oracle RMS package. Participated in project discussions, created scripts using SQL, PL/SQL and Unix shell scripts for data transferring, provided QA testing for different stages of moving process. Participated in creation and support of replenishment system.
  • Performed tuning of PL/SQL scripts and SQL statements optimization for large database.
  • Analyzed business data using Toad software on Oracle databases and Squirrel software for verifying correctness of data loads into Neteeza database.
  • Creating reports using Discoverer 10 .
  • Communicating with users in order to collect requests improving the data quality.
  • Creating auditing reports using SQL*Plus .
  • Creating technical and user’s documentation.
  • Creating and making enhancements to Unix and Linux scripts, using Tarantella software.
  • Creating ETL maps, using Warehouse Builder 10g .
  • Creating scripts for data migration in Oracle Retail Package project frame.

Confidential

Oracle Database Developer

Responsibilities:

  • Creating backend scripts for producing quality reports using Oracle10G.
  • Create PL/SQL packages , procedures, functions, triggers on Windows NT and Unix platform.
  • Participating in data modeling for existing and new reports.
  • Creating Oracle stored procedures, functions, packages using Oracle 10G .
  • Analyzing business data using SQL Navigator software.
  • Using the Tortoise SVN for proper distribution and updating scripts and documentation.
  • Communicating with users in order to collect requests improving the data quality.
  • Creating statistical reports using SQL*Plus , Crystal Reports.
  • Creating detailed technical and user’s documentation.

Confidential, Philadelphia, PA

Oracle Developer Consult

Responsibilities:

  • Heavily involve in data maintenance process on large size databases ( over 1TB ) using Oracle9i/10G(10.2), PL/SQL procedures, functions, triggers on Windows NT and Unix and Linux platform.
  • Participating in logical and physical design of data loads for data repairing tasks.
  • Creating Oracle stored procedures, functions, packages using Oracle 9i/10G .
  • Performed tuning PL/SQL scripts and SQL statements to process large data volume.
  • Analyzing data in daily data loads using TOAD, SQL Navigator software.
  • Communicating with users in order to collect requests improving the data quality.
  • Creating statistical reports using SQL*Plus .
  • Creating detailed technical and user’s documentation.

Confidential, Glen Mills, PA

Senior Consult

Responsibilities:

  • Playing a key role in designing and creating data flow process using SQL Server, Oracle10G, PL/SQL procedures, functions, triggers on Windows NT and Unix and Linux platform. Participating in data base design.
  • Create SQL Server database procedures, views, using SQL Enterprise Manager.
  • Participating in logical and physical design of data loads for new users.
  • Creating Oracle stored procedures, functions, packages using Oracle 9i/10G .
  • Creating VB Scripts for effective data loads into Oracle data base.
  • Analyzing data in daily data loads using TOAD software.
  • Communicating with users in order to collect requests for creating new and improving the performance of existing applications.
  • Creating statistical reports using Crystal Reports and SQL*Plus .
  • Creating detailed technical and user’s documentation.

Confidential, Oaks, PA

Senior Staff Consult

Responsibilities:

  • Maintained SQL Server database using SQL Enterprise Manager.
  • Created triggers, database procedures and functions utilizing PL/SQL .
  • Performing maintenance and enhancements for applications utilizing PowerBuilder 8.1, 10.
  • Analyzed data in daily data loads, reprocessed loads using Paragon software.
  • Created schedules in order to process daily data loads using Main Frame .
  • Created VB scripts in order to process daily tasks.
  • Made enhancements, created new forms and modules for existing project using Visual Basic 6.
  • Created statistical reports using Crystal Reports .
  • Created technical and user’s documentation.

Confidential, Bristol, PA

Oracle Application Developer

Responsibilities:

  • Performed Tracker, Inventory database design, created indexes, keys, database procedures and triggers.
  • Fully supported and maintained production Design Tracker, GSP Mailing Tracker, GSP Web Tracker, Inventory System, and Event Notification System applications.
  • Built and supported Fashion Tracker application.
  • Created database objects, indexes, data files, table spaces, partitions using shell scripts and Oracle
  • Enterprise Manager for test and production databases.
  • Creating, testing and implementing Oracle PL/SQL procedures, functions, packages and triggers utilizing ORACLE 8.0, 9i & 10G on Unix and Windows NT platform .
  • Analyzing and maintaining style’s mailing and shipment data.
  • Loading daily shipment, sale and inventory data from AS400 system into Oracle Data Base using SQL*Loader and Oracle PL/SQL procedures.
  • Created new forms, modules for new and existing projects using Visual Basic 6.
  • Performing enhancements for existing applications utilizing PowerBuilder 8.1, 10.
  • Insuring the proper data integrity.
  • Communication with users in order to determine the incoming data problems
  • Creating reports using Crystal Report Professional 8.0, creating universes and report templates using Business Objects 5.1
  • Managing user’s accounts for Design Tracker, GSP Mailing Tracker, GSP Web Tracker, Event Notification System, and Business Objects.

Confidential, Langhorne, PA

Programmer/Analyst

Responsibilities:

  • Design of database utilizing ORACLE 7.3 & 8.0, SQL*Plus 3.2, PL/SQL 2.2, SQL*Loader and build in Oracle packages.
  • Create Stored Procedures, Triggers, Functions using PL/SQL .
  • Meet with users to determine job specifications and client’s marketing requirements.
  • Create applications using EDGE Development System, a product proprietary to the telemarketing industry, that works on Windows NT and Unix platform .
  • Create EIS applications under UNIX environment.
  • Create reports utilizing SQL*Plus, Crystal Report Professional 5.0 & 6.0.

Confidential, Torofare, NJ

Programmer/Analyst

Responsibilities:

  • Participated in the full - cycle design, development, implementation and maintenance of the following systems
  • Imprint Management System, Warehouse Tracking System and Company Benefits System utilizing PowerBuilder 5.0/4.0, SQLSybase Engine, SQL and SQL*Plus.
  • Created triggers, database procedures and functions utilizing PL/SQL .
  • Met with users to gather specifications, business direction and flow of application.
  • Designed, developed, implemented and maintained multiple systems utilizing PowerBuilder, SQL Sybase Engine and SQL.
  • Created reports using SQL*Plus, Infomaker and PowerBuilder.

We'd love your feedback!