Mohamad Azri Abd Rahim Email & Phone Number

Subang Jaya, Selangor, Malaysia

1. Tabung Haji Data Warehouse Development:• Perform data source gathering and develop a comprehensive data dictionary (column mapping) for reference.• Automate the column mapping and data dictionary creation process through Python scripts, minimizing manual intervention.• Design and implement dimensional data modelling for storing fact and dimension tables in the data warehouse, specifically for Hajj and Deposit modules.• Develop ETL pipelines using SSIS for both full and incremental loads, accommodating one-time events and regular schedules.• Deploy SSIS packages, schedule jobs, and continuously monitor the pipeline’s performance, addressing failures and optimizing processes as needed.• Create data marts for reporting on Hajj and Deposit data, facilitating business insights.• Involve in TOT sessions with both business users (Hajj and Deposit) and technical teams.• Enhance ETL performance through indexing, SSIS configuration adjustments, and the removal of redundant tasks or functions.2. Smart Parking (PSP & KSP) & Open Project:• Orchestrate ETL processes using Apache Airflow, developing Python scripts to streamline workflows.• Ensure smooth ETL operations by monitoring processes and addressing issues promptly.• Apply data transformation techniques using Power Query, DAX, and M-language in Power BI, followed by visualizing the data effectively.3. JPJ MyStat:• Develop DB2 views for generating statistical reports required in dashboards.• Execute data transformation tasks in Spotfire prior to visualization.4. MOTAC:• Support dashboard development in Grafana, adhering to business specifications.

Petaling Jaya, Selangor, Malaysia

1) Lead and execute migration projects (ETL development) in multiple APAC countries (Taiwan, Philippines & Indonesia).2) Support and engage in transition project for APAC countries (Malaysia, Vietnam & Hong Kong).3) Participate in process standardization to improve efficiency with Global team.4) Engage with Technology team to perform UAT (User Acceptance Test) before deploying new requirements in Production system.5) Analyse and identify gaps for improvement in daily operational activities.6) Provide end-to-end training to juniors in managing the whole scope in a transition project.

Petaling Jaya, Selangor, Malaysia

1) Lead and execute core transition projects for APAC countries (New Zealand, South Korea & Singapore), resulted to 70% improvement in productivity & processing time-saving.2) Support and engage in core transition project for APAC country (Australia).3) Engage with stakeholders to collect input and coordinate tasks from each team to achieve project milestones.4) Provide technical training to operation team before each transition project going LIVE and support operation team in managing operational-related issues .5) Develop comparison report to address similarity/disparity between old and new platform's output.6) Script R studio to process files in various format involving data wrangling techniques and transform it into desired formats.

Australia

- A good team player as working with vast international employees.- Improved communication skills.- Completed the courses such as professional behaviours program, environmental awareness, and safe manual tasks to increase professionalism during work.

Bachelor Of Science - Bs, Mathematics

International Baccalaureate Diploma