Muhammad Abdul Qaium
Oracle Apex Developer / Database Engineer
Overview:
Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Atlanta, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, Power BI, Qlik Sense, OBIEE.
Summary:
●
Deputy
team leader of utility and Islamic banking oracle apex modules.
●
Manage,
assign tasks and provide support to team-members and clients.
●
Experienced
Oracle Developer in the area of Banking, Finance and ERP solutions.
●
Excellent
working experience on database development languages SQL and PL/SQL.
●
Expertise
on application development, implementation, Maintenance with Oracle Apex, HTML, CSS, JavaScript, XML, Oracle application server.
●
Very
Good Knowledge and Experience on SDLC,
ERD Diagram, Data Model Design and Data
normalization.
●
Expertise
in Oracle collections, analytical function, use of hints, regular
expressions
●
Proficient
in Installing, configuring, managing and supporting (24X7) Oracle 12c/11g/10g/9i production, QA/staging
and development databases in a different types of operating systems.
●
Have
knowledge of writing Shell Script,
PowerShell Script to automate the development works.
●
Have
knowledge of DB2, SQL Server, MySQL databases.
●
Have
Working Experience in Virtualization
Environments with VMware vSpehere and Oracle VM.
●
Extensive
experience in creating custom templates, and also use of HTML, CSS, JavaScript and jQuery for client-side experiences
●
Very
good Experience in API communication
between databases using Oracle PL/SQL, APEX
Web Service and Java.
●
Expertise
in Jasper report and ORDS.
●
Extensive
expertise in writing complex queries, Stored Procedures, Functions, Packages,
Database triggers using SQL and PL/SQL on oracle databases.
●
Good
knowledge of using tools like SQL*Loader, TOAD,
SQL plus, PL/SQL Developer, SQL Developer, and Postman.
●
Work
experience in Data Modeling, Data Migration, enhancement, implementation,
maintenance and support of applications developed using ORACLE (18c/12c/11g/10g).
●
Experience
with all phases of the Software Development Life Cycle (SDLC) including analysis, Physical and Logical Design, Code
Development, Testing, Implementing and Maintenance.
●
Excellent
banking domain knowledge, problem-solving, analytical, communication skills.
Technical
Skills:
Database: Oracle 10g/11g/12c/18c, SQL
server, MySQL
Languages: SQL, PL/SQL, PHP, Java,
JavaScript, jQuery, Java, HTML, CSS, Ajax, XML, C++, Python, Shell Script, Power shell script.
Analytical Idea: Data Structure, Algorithm, Artificial
Intelligence
Tools and Packages: Oracle Apex, Oracle application server, Oracle Forms developer,
Oracle Reports Developer, TOAD, SQL Developer, Jasper report, MS Visio,
SQL*PLUS, XAMPP, Tomcat, Android Studio, Eclipse, JDK, NetBeans IDE, SQL*Loader,
External Table, Git, GitHub,
VMware, Virtual Machine, Oracle
Data Guard, Oracle RAC, RMAN, Oracle Flashback Technology, Oracle ASM, Oracle
AWR utility.
Education and
Certifications:
●
Bachelor of Science in
computer information system
American International
University-Bangladesh (AIUB), Dhaka.
GPA : B + CGPA: 3.36 out of 4
●
Higher Secondary Certificate
(HSC)
Jalalabad
Cantonment Public School and College, Sylhet.
GPA : A CGPA: 4.50 out of 5
●
Secondary School Certificate
(SSC)
Jalalabad
Cantonment Board School, Sylhet.
GPA : A CGPA: 4.50 out of
● ● Oracle
Business Intelligence (OBI) Foundation Suite 11g
Essentials 1Z0-591
●
Oracle
Autonomous Database Cloud 2019 Certified Specialist
●
Oracle
Cloud Infrastructure 2019 Architect Associate
●
Oracle
Cloud Infrastructure Foundations 2020 Certified Associate
●
Oracle
Cloud Infrastructure 2019 Certified Architect Professional
●
Oracle
Database 12c: Administration
●
Professional
certification MySQL database
●
Professional
certification course on Oracle Apex, SQL, PL/SQL
●
Professional
certification on Islamic Banking.
Profession Experiences:
Role: Oracle Developer
Employer: ERA InfoTech Ltd
June 2017 to Present
ERA InfoTech Limited (ISO
9001:2000 and 27001:2005 Certified) A Joint Venture IT Company in Bangladesh.
Which provide a complete online Banking Solution with various types of delivery
channels as well as ERP solution.
Client: Bank Asia ltd.
Description: Bank Asia is a very dynamic online
third generation public limited commercial bank in Bangladesh. We provided them
end-to-end online banking solutions with lots of delivery channels and complete
database support.
Responsibilities:
•
Developing
CBS (Core Banking System) and Islamic Banking System modules using Oracle
technology such as Oracle Apex, SQL, PL/SQL.
•
Develop
Utility bill collection related all modules, maintained and provide support to
clients.
•
Writing
complex queries, Stored Procedures, Functions, Packages, Database triggers
using SQL and PL/SQL on oracle databases.
•
Created
authentication schemes and authorization for security components
•
On
sight work experience in Application Development and Application Support.
•
Developing
applications using Oracle APEX 4.2/5.0/5.1/5.2/18.1/18.2/19.2
•
Developed
several reports, forms, master detail reports and custom forms using Oracle
APEX 4.2/5.0/5.1/5.2/18.1/18.2/19.2
•
Developed
Apex applications and worked in teams and communicated with different teams at
various levels.
•
Created
few custom templates using HTML, CSS, JavaScript and jQuery for clients
•
Worked
on various API communication between databases using Oracle PL/SQL, APEX Web
Service and Java.
•
Worked
on configuring jasper report, ORDS.
•
Created
an SMS messaging system from APEX.
•
Prepared
test plan and test cases for various types of testing like unit, functional,
performance and regression.
•
Comprehensive
team work with the client to gather requirements for solutions.
•
Designed
Java web services for Soap and Restful Webservices.
•
CIB
system is a financial loan related data collection system provided by
Bangladesh Bank.
•
Dynamic
Bill Collection Module
•
Collateral
Security System (CLS) provided by Bangladesh Bank.
•
Created
Blueprint for the project in MS-Visio.
•
Created
System Design Document SDD.
•
Created
automated Jobs in Linux environment using shell script.
•
Implemented
validating package for the inbound data from the response file.
•
Created
external tables for data interfaces.
•
Wrote
reconciliation scripts in SQL to analyze the day to day transactions that are
happening in the business.
•
Involved
in the continuous enhancements and fixing of production problems.
•
Used
PLSQL developer for debugging the packages and stored procedure
Environment and tools: Oracle Apex 5.1, Oracle 12c, SQL,
PL/SQL, JavaScript, HTML, CSS, Ajax, REST API, Get-Post API, TOAD, SQL
Developer, Jasper report, SQL*PLUS, Tomcat, Eclipse, SQL*Loader, External Table, GitHub, VMware, Virtual Machine, Oracle Data Guard.
Role: Oracle Developer
PC Link IT
July 2016 to May 2017
PC Link IT is startup IT
company based on Dhaka developed multiple in-house software such as Anirban ERP,
Microfin Anirban, Energy Anirban, Microfinance , Accounting ,RMS, HRM and many
other solutions to the end user.
Responsibilities:
•
Creating
database objects using DDL(tables, views, synonyms)
•
Writing
Queries, Stored Procedures, Functions, Packages, Database triggers using SQL
and PL/SQL on oracle databases.
•
PL/SQL
subprograms performance tuning
•
Using
DCL to control rights on database objects and system
•
Using
dynamic SQL and work with cursors, record, varray, Joins, Indexes and
sequences.
•
Experience
in writing dynamic SQL Statements using EXECUTE IMMEDIATE and DBMS_SQL.
•
Understanding
Client requirements.
•
Configuration
of database environment ERP solution.
•
Unit
and System testing of newly integrated elements and configured products and
packages.
•
Deployment
of Solution in production system.
•
Generated
reports on statistics of various processes as per the requirement.
•
Designing
the database for the ERP solutions.
•
Developing
the program code for migration of Data from one source to another source.
•
Performance
Tuning of the queries being used in ERP, HRM
solution.
•
Defined
Process flow developed Template for invoice generation.
Environment: MySQL, Oracle 12c, SQL, PL/SQL,
JavaScript, HTML, CSS, TOAD, SQL Developer, Jasper report, SQL*PLUS, XAMPP,
Tomcat, Eclipse, JDK,
SQL*Loader, External Table, GitHub.
Extra Activities:
● Founding member of Oracle Apex Community
in Bangladesh.
● Love to teach and do support to Oracle
developer peoples.
● Debating and public speaking, member of
AIUB debate club (AOC)
● Worked as a trainer of A2I government
project from Microsoft.
● Volunteer of street child free school,
Ecche Ghuri.
● Have experience of event management at
AIUB.
Regards
Muhammad Abdul Qaium