Oracle Database Developer Resume

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Developer

Responsibilities:

Enhancements and corrections to the Confidential SNAP program using Oracle 12c and JSON and Oracle Database 12c based on user requirements: Oracle Reports modifications: adding new columns, modifying text version and PDF versions, rearrange column titles and data placement
Extensive troubleshooting for all Oracle based applications. Escalation point for all Oracle development.
Oracle Forms modifications: add additional items to blocks, add items to screen displays, sort LOV based on user keywords.
Business analysis and recommendations for the Unified Timekeeping System for the 29,000 NYC Bus and Subway employees. The ORACLE framework consists of Forms 11g, Oracle Database 12c
Working with database objects and forms objects, i.e. triggers, packages, overloading, grants, etc.
Interview candidates for project work: Oracle Database skills, Oracle Forms skills, AIX skills.

Confidential

Oracle Database Developer

Responsibilities:

Developed Oracle 11g PL/SQL and Forms developer involved in new and maintenance projects
Completed 10g to 11gR2 upgrade covering Oracle Forms and database: byte/char conversion, semantics, AL32UTF8, remote dependencies mode.
Maintain and upgrade the in - house legacy Warehouse Management System (WMS) using C, ksh, UNIX, Oracle Forms 10g and Oracle 11g PL/SQL. Use of Stacked, Content, Horizontal, Vertical and Tab Canvases
Provide technical assistance and trained team members using ORACLE Forms 10g, C and PL/SQL
Work with Oracle 11g packages, functions, procedures, triggers, shared objects, global temporary tables.
Create synonym and grant scripts for DBAs., Oracle Experience: (11gR2/10g/9.x)
Query Oracle when necessary using data dictionary views.
Designed and implemented email application that notified users for various Oracle events using dbms utl.send email with BLOB attachments
Developed Oracle interface using socket connection and data transfer to a Global Logistics System
Interfaced to different servers using XML data transfer including Oracle eBusiness Suite and Transportation Management System (TMS)
Modified formsweb.cfg for message generator development using Oracle Forms 10g
Migrated legacy 60gbyte TIFF files to Oracle database with new development with Oracle Forms and packages
Wrote XML architectural design documents for off shore group. Managed project development.
Oracle skill set experience: SQL, PL/SQL, XML Stored Packages, Procedure, Functions, Database Triggers
Designed email utilities, csv file generation using many DBMS xxx Oracle functions
Designed and developed message generator using Oracle Forms
Estimation of Physical storage requirements for online database
Developed Master-Detail Forms using Control & Base table blocks
Forms Hierarchical tree control, Dynamic Record Groups, Alerts, Property Classes and Visual Attributes
Distributed database features, network and client-server programming
OID, SSO formsweb.cfg
ETL for analysis, projects

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship