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