Oracle Application Express Programmer Resume
Plattsburgh, NY
SUMMARY:
Certified IT professional with experience in design, development and implementation of Oracle database solutions. Technical expertise in PL/SQL database programming and Oracle APEX. Effectively analyzes and implements solutions to user requests. Integrates applications to enhance user experience and efficiency. Enhances existing systems with new technologies, features and performance improvements.
TECHNICAL SKILLS:
Technologies:: Banner ERP, IBM Cognos BI, Oracle 12c, APEX 5.0, AmCharts JavaScript Charts 3.2, JSON, PL/SQL, jQuery, SQL Developer, Atom, Git, APEX Front End Boost .
PROFESSIONAL EXPERIENCE:
Confidential, Plattsburgh, NY
Oracle Application Express Programmer
Responsibilities:
- Data modeling.
- Analysis of client requirements and development of technical specifications.
- Coding and testing.
- Preparation of reports and manuals regarding project status, operations and maintenance of applications.
- Created navigation for application.
- Built dashboard page.
- Integrated AmCharts visualization libraries.
- Created forms for data entry.
- Built workflow processes.
- Created JavaScript event handlers to provide interactivity between charts and interactive report.
- Implementation involved extensive use of jQuery and Dynamic Actions.
Confidential
Responsibilities:
- Built a Technical Certificate Approval workflow process that allows authorized users to create and submit new Technical Certificates for approval by the Ohio Department of Higher Education. This replaced a stand - alone web form.
- Developed scheduled email notifications for workflow.
- Created administration screens for approval process.
- Enhanced reporting capabilities.
Confidential, Great River, NY
Software Developer
Responsibilities:
- Automated the integration of Sakai Learning Management System with the Banner Student module. This involved loading grades into Banner and uploading students, courses and members to Sakai.
- Integrated Banner with Interspire CRM system to initiate first contact with recruits.
- Automated integration between Banner AR module and student health insurance vendor using PL/SQL and Banner APIs, saving more than 240 work hours per year.
- All integration work involved extensive use of Banner APIs to implement business logic.
- Introduced University to Oracle APEX as a tool to expose applications securely to the faculty.
Confidential, Melville, NY
Senior Developer of Business Applications
Responsibilities:
- Developed and supported Cognos reporting system, Oracle PL/SQL and Oracle APEX systems.
- Designed, developed and implemented workflow application that automated HR separations process for a 100 store brand reducing processing time by 30%.
- Reduced data mart load time by 35% by redesigning PL/SQL packages providing critical data to users with a greater buffer period.
- Managed release of custom code modifications to facilitate change to the Chart Of Accounts to provide the business with greater financial reporting capabilities.