Muhammad Ikhmal Email & Phone Number

Subang Jaya, My

Project domain: AirlineProjects Involved: Commercial Data Warehouse 2 (CDW2) and Customer 360 (C360)Data model:- Develop data mapping strategies to organize and structure data effectively within the data mart.- Develop logical data model (LDM) documentation to illustrate the structure of the data mart.- Develop an entity-relationships diagram (ERD) to illustrate the relationships between fact and dimension tables.- Collaborate with the reporting team to understand data requirements and ensure accurate mapping.Data mart:- Design and implement ETL processes for the development of data marts using Pyspark and sql spark in Databricks platform. - Implement incremental load based on batch date for the data loading. Data quality:- Perform data validation before ingesting to the data mart to ensure that the data are as per the requirement.- Implement audit logger for data processing and capturing the info on each function and sub-functions.- Implement email alert to trigger an email when the data validation fails.Unit Testing:- Perform system integration testing (SIT) complete with case scenarios to ensure the compatibility of the pipeline works correctly and any interactions are appropriate and safe

Malaysia

A program provided by The CADS, sponsored by Yayasan Peneraju that provides online classes that focuses on Python, Data Storytelling, Data Visualization (Tableau), SQL, NoSQL, and Big Data with Apache Spark.Project: Capstone Project (Customer Purchasing History and Focused on Determining Potential Customer)• Data Wrangling - Cleaning & Merging: Check and handle the existence of missing values, the type of variables, and the integrity of data• Exploratory Data Analysis: Analyze data to summarize their main characteristics• Feature Engineering: Make new features and change the current features• Feature Selection: Choosing the best features• Queries using SQL to query the data

Malaysia

• Handle projects assigned by director with guidance by project lead. • Prepare tender document comprising bill of quantities, specifications, and schedules accordance to standards. • Prepare tender evaluation report with recommendation to client on acceptance of tender. • Contract administration including review and comment on the contractor’s submission of shop drawings, method of statements, materials, and inspections. • Prepare monthly progress claim certificates. • Prepare cost estimates for Variation Order. • Attend meetings and coordinate with all other internal and external team members. • Liaise with relevant authorities for submission and approval of all the drawings and documents.Projects Involve: Pavilion Damansara Height Parcel 1, Pavilion Damansara Height Parcel 2, UOA The Park Residence 3

Malaysia

• Conducted technical records management in a timely manner. • Perform any other duties and responsibilities directed by immediate superior.

Petaling Jaya, Selangor, Malaysia

• Prepared technical quotations and costing to customers.• Managed customer questions, inquiries, and complaints.• Liaised with contractors over technical issues.• Maintained good business relationships with customers.• Attended to any other duties and responsibilities as may be assigned by immediate superior or the Management from time to time.• Attended site visit and inspection invited by customer.• Coordinated with customer, contractor, and service team in the commencement and completion of repair job.• Monitored contractors on site.

Kl East Mall

• Coordinated with technician to compile and track building defects before the mall opens to the customer. • Coordinated with procurement department to acquire quotation from various contractors, consultants, and suppliers to conduct tender evaluation.• Participated in building systems training provided by the contractor.• Managed weekly handover meeting with township, contractor, and consultants.• Managed and compiled tender documents for internal audit.• Assisted in site inspection, evaluation, and handover by inspecting and evaluating work of scope during handover.• Assisted in tender management and execution by preparing tender documents, analysing quotation for comparison, and clarifying quotation.• Tender executed:1. Proposed Reconfiguration Works for Tenant Lot G1-29 (Focus Point)2. Proposed Reconfiguration Works for Tenant Lot G2-17 & G2-18 (Qaira Hijab)3. Proposed Reconfiguration Works for Tenant Lot G2-26 & G2-27 (Chef wan)4. Proposed Reconfiguration Works for Tenant Lot G3-17A & G3-17B (Oppo)5. Proposed Reconfiguration Works for Tenant Lot LG-25 (Pets Wonderland)6. Proposed Reconfiguration Works for Tenant Lot G1-39 & G1-41 (Starbucks)7. Proposed Reconfiguration Works for Tenant Lot G3-25 (Jungle Gym)8. Appointment of Mechanical & Electrical Consultant for Reconfiguration Works at KL East Mall

Selangor, Malaysia

• Assisted in preparing un-invoiced billing and complaint reports by collecting, re-checking, analysing, and summarizing information.• Analysed schematic diagram and drawing for circuit analysis of landlord tenant issues.

Bachelor Of Engineering - Be, Electrical Power Engineering, Cgpa: 3.21

Foundation Degree, Engineering, Cgpa: 3.63

Malaysian Certificate Of Education (Spm), Pure Science, 8A 1B