Oracle Database Developer
- 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.
Oracle Database Developer
- 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