Muhd Hafidz Khan Bin Rosman Khan | Freelancing Malaysia

Muhd Hafidz Khan Bin Rosman Khan Senior Oracle PL/SQL, C# Developer & Excel/Power BI Data Specialist

10 years experience 0 projects worked Malaysia

RM55.00 /hr RM0 earned

App DeveloperC# ProgrammingData AnalystData EntryExcelSQL

Senior software engineer with 10+ years of experience in Oracle PL/SQL, SQL,

C# (.NET WinForms), and enterprise database systems. Background includes

defence sector systems (Royal Malaysian Air Force, Royal Malaysian Navy) and

financial banking platforms.

Services offered:

– Oracle SQL/PL/SQL development, query optimization, and database migration

– C# WinForms application development and legacy system maintenance

– Excel data cleaning, Power Query automation, and Power BI dashboard setup

– Crystal Reports/RDLC report development

Available now for freelance/contract projects, part-time or full commitment.

Based in Selangor, Malaysia.

Portfolio

Work History (0)

There are no activities yet.

Work Experiences

Add work experience to your profile. (optional)

Software Engineer
Caidmark Sdn Bhd
December 2015 - October 2023
8 years developing and maintaining enterprise systems for defence sector
clients (Royal Malaysian Air Force, Royal Malaysian Navy, Jabatan Penjara
Malaysia), primarily on ECMS (Engine Component Maintenance System) — a C#/
Oracle-based aviation component tracking system.
– Developed complex Oracle SQL/PL-SQL views with CTE-based logic for
component life tracking, including hierarchy traversal using CONNECT BY
PRIOR for multi-level component relationships
– Built and maintained C# WinForms applications, including custom UI
components (TreeView, ListView), and integrated Crystal Reports/RDLC for
reporting
– Designed and built Power BI dashboards for tracking component life,
maintenance indicators, and operational KPIs
– Performed Excel data cleaning and consolidation across multiple
operational data files, standardising formats and validating data before
system integration
– Developed Power Query workflows for multi-file Excel data loading —
including loading data by sheet position (bypassing sheet name mismatches)
and capturing sheet metadata alongside data
– Performed data migration and cleanup across enterprise tables using MERGE,
INSERT, UPDATE, and DELETE operations with strict data integrity controls
– Conducted query performance tuning using EXPLAIN PLAN — identified full
table scans, replaced correlated subqueries with joins, and recommended
indexing strategies
– Performed Oracle database administration tasks including schema export/
import and data migration via external tables
Technologies: Oracle PL/SQL, SQL, C# (.NET WinForms), Power BI, Power Query,
Excel Data Cleaning, Crystal Reports, RDLC, Oracle Database Administration,
CTE, Query Optimization
System Consultant
INFORPRO Sdn Bhd
November 2023 - December 2025
Developed and maintained financial front-office banking systems using Oracle
Forms and Oracle Database.
– Troubleshot and deployed fixes for banking modules, ensuring high system
availability and compliance with financial standards
– Created, updated, and maintained Oracle Stored Procedures and Functions to
support core banking business logic and system operations
– Analysed and optimised long-running SQL queries for performance, reducing
execution time and improving system responsiveness
– Performed Oracle DBA tasks including user access management, Data Pump
import/export, audit trail configuration, and database backups
– Installed and configured Oracle Database across multiple versions (11g,
12c, 19c) for development, testing, and production environments
– Drafted Functional Specification Documents (FSDs) through client
requirement-gathering sessions and system behaviour analysis
– Performed unit testing on developed features before QA handover, and
collaborated closely with QA teams during testing of complex banking
functions
– Served as technical communication bridge between engineering teams and
clients throughout project delivery cycles
Technologies: Oracle Forms, Oracle PL/SQL, SQL, Stored Procedures, Query
Performance Tuning, Oracle DBA (11g/12c/19c), Data Pump, Banking Systems,
Requirement Gathering, FSD Writing

Certification

Add work certification to your profile. (optional)

Oracle Database SQL Certified Associate
Oracle
August 2018 - August 2018
Certified in fundamental SQL concepts required for database development
projects, including SQL queries, INSERT/UPDATE/DELETE statements, Data
Definition Language (DDL) and Data Control Language (DCL), query
optimization, table and index design, data modeling, and normalization on
Oracle Database.

Education

Add work education to your profile. (optional)

Computer Science (Software Engineering)
Universiti Malaysia Pahang
June 2011 - October 2015
Bachelor’s degree with focus on software engineering fundamentals, database
systems, and application development.

Profile of Muhd Hafidz Khan Bin Rosman Khan

Portfolio

Work History (0)

Work Experiences

Software Engineer

Caidmark Sdn Bhd

December 2015 - October 2023

System Consultant

INFORPRO Sdn Bhd

November 2023 - December 2025

Certification

Oracle Database SQL Certified Associate

Oracle

August 2018 - August 2018

Education

Computer Science (Software Engineering)

Universiti Malaysia Pahang

June 2011 - October 2015

Welcome back!

Send an email to this freelancer

Select project(s) to invite Muhd Hafidz Khan Bin Rosman Khan to join

Forgot Password?

Send Message