MD Ripon Hossain

Senior Oracle ProgrammerFull Time

• Job Details:• Design, development & Modification Oracle E-Business Suite (EBS) Custom Forms & Reports using Oracle Forms & Reports10g, Database 12C, Oracle BI Publisher. • Analysis of the Functional Requirement Document (FRD). • Design, development & modification Attendance & Payroll management system using Oracle Apex 19.2, Database 12C, BI Publisher reporting tools as per management requirements. • Developing the interactive dashboards, forms, model, non-model dialogue page, Reports, Charts, Graphs, Theme customization using Apex tool. • Sending email notification to the user by using smtp email from database by using PL/SQL trigger and Apex email. • Sending Mobile SMS using UTL_HTTP.REQUIST from PL/SQL procedure. • Client-side validation using JavaScript & jQuery. • Developing Reports (PDF, Excel, CSV, E-text etc.) using Oracle Report, BI Publisher, Jasper & Birt Reporting Tools. • Design & develop analytical report. • Develop API using Oracle Apex RESTful Services. • Writing the database procedures, functions, packages, and triggers according to business requirement using SQL, PL/SQL, PGSQL, T-SQL. • Complex Query writing, Query Optimization, Database Process development, Indexing, Table Partitioning, Materialized View, Analytical Function, Job Scheduler for process & Database performance optimization in various database like Oracle (9i,11g,12C), PostgreSQL, Microsoft SQL Server, MySQL. • Testing & UAT - unit testing, integration testing and UAT of the module.