AHAMED RAFEEQUE CHERKELA

Assistant Manager Application Development

Al Fardan Exchange,Dubai.

Mobile No.: +971-********* E-Mail: ad1onl@r.postjobfree.com

Assistant Manager Application Development with 16 years of rich technical design and support of large scale enterprise solutions (ERP, Finance & Health Care domain) using Oracle Apex, Oracle Pl/Sql.

Possesses technically expertise in Oracle Apex (4 & 5.1,18.x,19.x,20.x,21.x), Oracle PL/SQL, HTML, CSS, Java Script,Oracle form and Reports, Web Integration RESTful Services JSON, SOAP.

Migration from Oracle Form to Oracle apex application.

CAREER SUMMARY

Working as a Technical Assistant Manager(Application Development) and guiding my team technically in Al Fardan Exchange, Dubai from August 2022 to till Date.

Involved and lead the design & development of various Integration for Al-Fardan Exchange UAE.

Involved in the design & development of Western Union Integration for Al-Fardan Exchange UAE.

Designed and Developed API for Mercury card Integration for Al-Fardan Exchange UAE.

Involved in the design & development of COVID 19 application (Developed in Oracle Forms & Reports) for Ministry of Health, Oman.

Having previous 16 Years of experience as a Sr. System Analyst/ Senior Oracle Developer with diversified exposure in analysis, design, development and implementation of Desktop and web-based applications.

Hands on experience in designing and developing distributed and multithreaded applications with technologies such as Oracle Apex on various latest version and Oracle Forms and Reports.

Good understanding in business processes ERP, finance, health care, real-estate & retail.

Application system design over Oracle Forms & Reports with security, robustness, transaction management as prime goal.

Strong programming skills in designing and implementation of multi-tier applications using web-based technologies like PL/SQL,Oracle Apex, Java Script and JQuery.

Experience with Oracle Apex as the development framework to build a single-page application.

Oracle Apex 18 practices in commonly used modules and creating regions, LOV’s, lists, breadcrum, rest service etc.

Worked as Oracle Consultant in the maintenance and development of remittance application.

Exceptional skills in Agile Development and Test Driven Development

Transaction-aware programmer with solid foundation in Oracle Sql & Pl/SQL.

Organized and rewrote cycle process UNIX and Dos batch scripts on Third Party Tool (SysAdmiral).

Designed/modified/implemented stored procedures, triggers in Oracle 11g and 12c using PL/SQL.

Increased performance, speed, and error handling of process by 60%.

Designed, developed, coded, tested, documented, and implemented data modeling features using TOAD and other third party tools.

Experienced in version control tools like GIT and ticket tracking platforms like JIRA.

Strong working Experience on Linux based and Windows environments.

Respond quickly/effectively to production issues by taking responsibility for seeing those issues through resolution.

Well planning of time and set realistic schedule to accomplish multiple deadlines.

Unit testing Proficiency.

HONORS & ACHIEVEMENTS

Implemented Integration with Western Union for Al-Fardan Exchange.

Implemented COVID 19 application for Ministry Of Health, Oman.

Implemented AML module for Gulf Exchange Co.

MOH Oman. awarded star performer for the year 2019.

SKILL SET

Build Tools: Oracle Apex (4 & 5.1,18.x,19.x,20.x,21.x), PL/SQL Developer.

Desktop Technologies: Oracle Forms, Oracle Reports & Oracle Graph.

Web Technologies: Oracle Apex, HTML, CSS,

JavaScript, JQuery, AJAX, JSON, XML.

Databases: Oracle 12c,Oracle 11g Oracle 10g, MySQL.

Database Management Tool: Oracle Toad, Pl/Sql Developer,Sql Developer.

Code Development Tools: Eclipse, STS, Visual Studio.

Version Controlling tools: Git.

Methodologies: Agile, Scrum, Waterfall.

Project Development: GIT, JUnit, CVS, Subversion.

Severs: Web Logic, Apache Tomcat, JBOSS EAP.

Design Patterns: Singleton, Factory

ACADEMIC CREDENTIALS

3year Diploma in Computer Engineering State Board of Technical Education Kerala, India.

Completed Graduation in Bachelor of Computer Application.

WORK EXPERIENCE

Al Fardan Exchange UAE (Dubai)

Sep 2020 - Present

Technical Assistant Manager

As a Manager, I am managing, guiding and supporting in all way to my team members to meet the projects deadline and client satisfaction.

Al Fardan Exchange UAE (Dubai)

October 2020 - Present

Senior System Analyst/ Senior Application Developer

Oracle Form& Report to Oracle Apex Migration

I have converted the 20 years of running full functionality exchange domain oracle forms and report which was build in version 6i to Apex version. I was leading a team of 5 developers. I was the main key developer who built logics and design and developed for this migration project. duration - NOV 2021- till present.

Project: Western Union Gateway Integration

Successfully integrated western union gateway integration into AFEX (Al Fardan Exchange System) core system, which allow AFEX users to make WU (Western Union) transaction from AFEX system itself instead of using WU portal or websites. It Include Web service calls using SOAP request and response.

Analyze client Requirements. Involved in developing the system with Full Software Development Life Cycle (SDLC) from Design to Deployment using agile methodologies.

Developed UI in oracle forms & Reports and designed database objects in oracle database.

Developed Web service which uses GET and POST method to communicate with WU gateway.

Performance tuning of the application using optimizing and tuning technique of oracle pl/sql.

Providing End to End support for the testing activities during System Testing and UAT.

Production support for the application and handling of critical issues in timely manner.

Environment: Oracle Apex18, Oracle 12c, Javascript, HTML, JIRA, Agile, Apache Tomcat.

Ministry of Health, Oman

December 2015 -October 2020

Senior System Analyst/ Senior Oracle Developer

Project: COVID 19 Application

A web based application developed for Ministry of Health Oman to Keeps you up to date with the number of Corona virus cases and recoveries and deaths across the Sultanate and across the GCC. The system provides user of the option of clicking on a governorate or walayat of their interest to see the number of corona virus cases, deaths or recoveries in that place. The system provide an interface for the health department to register the case and also provide the facility to allow self reporting your symptoms. Based on the registered information an ARI notification is created with all the information including case type, travel history and laboratory tests needed to carried out.

Analyze client Requirements. Involved in developing the system with Full Software Development Life Cycle (SDLC) from Design to Deployment using agile methodologies.

Developed UI in oracle forms & reports and designed database objects in oracle database.

Performance tuning of the application using optimizing and tuning technique of oracle pl/sql.

Providing End to End support for the testing activities during System Testing and UAT.

Production support for the application and handling of critical issues in timely manner.

Project : Incident Reporting System

Environment: Oracle forms & reports, Oracle 12c.

A web-based incident reporting system and multidisciplinary collaborative projects for patient safety in Oman hospitals.

When patient safety programs were mandated for Omanis health care institutions, a safety culture, a tool for collecting incident reports, an organizational arrangement for multidisciplinary collaboration, and interventional methods for improvement had to be established.

Involved in Developing Application with Full Software Development Life Cycle (SDLC) from Design to Deployment using agile methodologies.

Developed UI in oracle forms & reports and designed database objects in oracle database.

Performance tuning of the application using optimizing and tuning technique of oracle pl/sql.

Providing End to End support for the testing activities during System Testing and UAT.

Production support for the application and handling of critical issues in timely manner

Environment: Oracle forms & reports, Oracle 12c.

Project : AlShifa System

Al-Shifa is comprehensive healthcare information management system developed as complete solution for a healthcare facility management from electronic medical records to Assets, Inventory, and HR management.

Involved in system support and development of new modules in oracle forms & reports and oracle database.

Participated in Agile Development Team, and having daily SCRUM meeting for progress reporting as well as task distributing.

Developed package and other database object using oracle pl/sql.

All the functionality is implemented using oracle forms & reports, oracle and some parts in oracle apex.

Developed applications using oracle forms & reports, oracle apex and oracle database.

Experienced in developing applications in ERP, Healthcare, Finance and Banking industrial domains.

Appreciated by clients for handling of critical issues.

Gulf Exchange Company Qatar

Apr 2011- Nov 2015

Oracle Consultant

Project: Real Time System for Exchange House (RTS)

Environment: Oracle Forms & Reports, Oracle 11g, Oracle Apex, Javascript, HTML, GIT, STS, JIRA, Agile, Tomcat.

This is web service application designed to use in Exchange Houses for making transactions of Portals like Xpress Money, Transfast, EZ Remit etc.

Involved in Developing Application with Full Software Development Life Cycle (SDLC) from Design to Deployment using agile methodologies.

Developed UI in oracle forms & reports and designed database objects in oracle database.

Performance tuning of the application using optimizing and tuning technique of oracle pl/sql.

Providing End to End support for the testing activities during System Testing and UAT.

Production support for the application and handling of critical issues in timely manner.

Project: Gulf Exchange System (GECO)

Environment: : Oracle forms & reports, Oracle 12c,Oracle Apex, Javascript, HTML, JIRA, Agile, Apache Tomcat.

GECO is comprehensive money exchange system developed as complete solution for money exchange. It has facility for remittance, inward remittance, cash sale, cash purchase etc..

Involved in system support and development of new modules in oracle forms & reports and oracle database.

Participated in Agile Development Team, and having daily SCRUM meeting for progress reporting as well as task distributing.

Developed package and other database object using oracle pl/sql.

All the functionality is implemented using oracle forms & reports, oracle and some parts in oracle apex.

Developed applications using oracle forms & reports, oracle apex and oracle database.

Experienced in developing applications in ERP, Healthcare, Finance and Banking industrial domains.

Appreciated by clients for handling of critical issues.

ItecSoft Pvt Ltd, Thrissur, India (Dubai) Aug 2007- Mar 2011

Jr Oracle Developer

Project: Optem4 Solution

Environment: Oracle forms & reports, Oracle Apex 4, Oracle 12c, Javascript, HTML, JIRA, Agile, Apache Tomcat.

It’s a complete ERP solution which included accounts, inventory, contrasys etc.

Involved in system support and development of new modules in oracle forms & reports and oracle database.

Participated in Agile Development Team, and having daily SCRUM meeting for progress reporting as well as task distributing.

Developed package and other database object using oracle pl/sql.

All the functionality is implemented using oracle forms & reports, oracle and some parts in oracle apex.

Developed applications using oracle forms & reports, oracle apex and oracle database.

Experienced in developing applications in ERP, Healthcare, Finance and Banking industrial domains.

Appreciated by clients for handling of critical issues.

Environment: Oracle forms & reports, Spring, Hibernate, Restful web service, Postgres SQL, Tomcat 6, Eclipse IDE, SVN, Apache Tomcat.

References will be furnished upon request.

PERSONAL DETAILS

Date of Birth 05/Jun/1982

Hobbies Cricket

Permanent Address Kerala.

Current Address Sharjah, UAE.

Contact this candidate