# data[].attributes.body
Continue on the previous task assigned:

Genset-Invoice Analysis

Gather and compile the data from 56 invoices related to the genset comprises on the details about rental charges, mobilization expense and diesel filling records from two authorized vendor companies. - Comparative analysis to the memo price.

# data[].attributes.body
Site Assignment Pre-audit tasks.

Assists my team in generating insights from the big data.

Conduct data cleaning from the big data for pre-audit data verification related to the site assignments to ensure that the audits findings are accurate.

Utilized MS Excel formulas to carry out this task; Pivot Table, Vlookup, IF Function

# data[].attributes.body
Resume the previous day task:

Site Assignment Pre-audit tasks.

Assists my colleague in generating insights from the big data.

Conduct data cleaning from the big data for pre-audit data verification related to the site assignments to ensure that the audits findings are accurate.

Utilized MS Excel formulas to carry out this task; Pivot Table, Vlookup, IF Function

# data[].attributes.body
8.30am

Arrived office located at the Mof inc Tower | Platinum Park

9.00am

Had a briefing about the company, all the offices, and departments and all the benefits to the employees.

Setting-up the face recognition for attendance purposes.

9.30am-10.30am

Joined a meeting with team leader, senior manager and managers of my department, reporting their ongoing and previous audit assignments.

10.30am onwards

Got all the equipments (laptop, mouse,monitor)

Registering with the company email, outlook, teams and DNB Portal (Internal).

Assessing all the internal files (Audit Reports)

1pm-2pm

Break

2pm to 4pm

Got briefing on the corporate assurance department. The flow of the auditing process in DNB. The scopes covered in the audit includes data analytics, ERP, regulatory, contract management, Letter of Authority (LOA), Letter of Offer (LOO) and all the neccessary documents required for audit purposes.

Since DNB is a sole provider of the 5G network company, I also got exposed on network systems in telecommunications. The scopes also covered the installation process of the 5G tower that related with 'infraco' which means Infrastructure Company etc.

# data[].attributes.body
8.45am

Arrived at the office

9am -10am

Had a meeting with the Head of the team, briefing on all the network process, costs included on deploying the 5G network, the purpose of the related documents etc.

10am onwards

Reading and understanding all the audit procedures and reports at DNB

1pm-2pm

Break

2pm-3pm

Had a meeting with the manager of engineering, briefing and understanding the network process

3pm onwards

Start assessing and understanding all the audit reports including the audit procedures, the costs related (One-time charges costs, variation costs, Basic Fee etc).

Going through all the previous neccessary documents include the LOO (Letter of Offer) from the Infraco (Infrastructure Company) to deploy tower for 5G network.

# data[].attributes.body
8.45am

Arrived at the office

9pm onwards

Continued assessing and understanding all the audit reports

Going through all the previous neccessary documents include the LOO (Letter of Offer) from the Infraco (Infrastructure Company) to deploy tower for 5G network.

1pm-2pm

Break

2pm onwards

Brifieng on my upcoming tasks, by my supervisor, Ms. Yap Kuan Yung (Senior Manager, Financial & Operations Auditor) on the audit process on HR (Training & Development), including all the necessary informations and documents needed.

Did some research on the Human Resources Development Funds (HRDF) regarding the reimbursement, costs, law, criteria and categories covered. Especially the

PSMB Act 2001
An act to provide for the imposition and collection of a human resources development (HRD) levy for the purpose of promoting the training and development of employees, apprentices and trainees, the establishment and the administration of the Fund by the Corporation and for matters connect therewith.

# data[].attributes.body
8.50am

Arrived at the office

9pm onwards

Continued on the research on the Human Resource Development Funds (HRDF)

1pm-2pm

Break

2pm onwards

Start extracting the Letter of Offer (LOO) files by the infraco (Infrastructure Company) on excel by its site ID, Costs, locations, Network Facilities Provider (NFP) etc

# data[].attributes.body
Digital Nasional Berhad (DNB) was established in 2021 to deliver the following key outcomes in line with the goals of the Malaysia Digital Economy Blueprint (MyDIGITAL):

Accelerate deployment of 5G infrastructure and network in Malaysia

Realise the potential of 5G in Malaysia to spur economic activity

Promote service-based competition within the communications industry

Bridge the urban-rural digital divide and improve the current state of infrastructure

Optimise the use of scarce resources such as spectrum

*At present, DNB is in the initial stage of expediting the implementation of 5G infrastructure and networks in Malaysia.

DNB GOAL 2023

Accelerate 60% of 5G coverage in populated areas around Malaysia

# data[].attributes.body
My position: Intern, Corporate Assurance (Internal Audit)

Department: Corporate Assurance

Supervisor: Yap Kuan Yung (Senior Manager, Financial & Operations Auditor)

# data[].attributes.body
8.45am

Arrived at the office

9pm onwards

Continued extracting the Letter of Offer (LOO) files by the infraco (Infrastructure Company) on excel by its site ID, Costs, locations, Network Facilities Provider (NFP) etc.

1pm-2pm

Break

2pm onwards

Continued extracting the Letter of Offer (LOO) files by the infraco (Infrastructure Company) on excel by its site ID, Costs, locations, Network Facilities Provider (NFP) etc.

# data[].attributes.body
Hari Raya Aidilfitri Holiday celebration.

*Leave approved by Supervisor

# data[].attributes.body
Hari Raya Aidilfitri Holiday celebration.

*Leave approved by Supervisor

# data[].attributes.body
9.00am - 12.00pm

Daily task continued:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

2.00pm onwards (After Break)
Request for Half-day Leave for Raya Haji Celebration.

*Leave approved by Supervisor

# data[].attributes.body
PUBLIC HOLIDAY:
RAYA HAJI AIDILADHA CELEBRATION

# data[].attributes.body
Raya Haji celebration leave.

*Leave approved by supervisor.

# data[].attributes.body
Public Holiday: Labour Day

# data[].attributes.body
Public Holiday: The Yang di-Pertuan Agong's Birthday

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Genset-Invoice Analysis

Gather and compile the data from 56 invoices related to the genset comprises on the details about rental charges, mobilization expense and diesel filling records from two authorized vendor companies. - Comparative analysis to the memo price.

# data[].attributes.body
Continue on the previous task assigned:

Genset-Invoice Analysis

Gather and compile the data from 56 invoices related to the genset comprises on the details about rental charges, mobilization expense and diesel filling records from two authorized vendor companies. - Comparative analysis to the memo price.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Hari Raya Aidilfitri Holiday celebration.

*Leave approved by Supervisor

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Cross-reference check on the Supplier Details Report
Files involved: Supplier details report.

Performed vouching and cross-reference verification for about 800+ details between the supplier party and the invoice date (Obtained from the ERP Oracle System) to verify whether the supplier has been approved before or after the transactions made.

# data[].attributes.body
Continue previous task assigned:

Cross-reference check on the Supplier Details Report
Files involved: Supplier details report.

Performed a cross-reference verification for about 800+ details between the supplier party and the invoice date (Obtained from the ERP Oracle System) to verify whether the supplier has been approved before or after the transactions made.

# data[].attributes.body
Public Holiday: Wesak Day

# data[].attributes.body
Continue previous task assigned:

Cross-reference check on the Supplier Details Report
Files involved: Supplier details report.

Performed a cross-reference verification for about 800+ details between the supplier party and the invoice date (Obtained from the ERP Oracle System) to verify whether the supplier has been approved before or after the transactions made.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Task Assigned: Comparative Analysis of the Total Monthly Site Leasing

Develop a comprehensive table consists of the following categories: State, District, Structure Type, Lowest, Average and Highest total monthly fees. - Facilitate a comparative analysis on the fees charged based on the structure type, state and district.

Deploy pivot table - more organized and comprehensive presentation of the data.

# data[].attributes.body
Continue the previous task assigned.

Task Assigned: Comparative Analysis of the Total Monthly Site Leasing

Develop a comprehensive table consists of the following categories: State, District, Structure Type, Lowest, Average and Highest total monthly fees. - Facilitate a comparative analysis on the fees charged based on the structure type, state and district.

Deploy pivot table - more organized and comprehensive presentation of the data.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Pre-audit data verification.

Files involved: LOO Site Leasing Approval Rate Rental - April 2023
From the above file, I assist my colleague in;

Performed data cleaning that involves simplifying big data by selectively considering characteristics by; Site IDs, Structure types, Structure and building heights.

Simplify the complex data in a table, aiming to make it more understandable and concise.

Optimize data by employing pivot table, for ease of viewing.

# data[].attributes.body
Continue the previous task assigned:

Files involved: LOO Site Leasing Approval Rate Rental - April 2023
From the above file, I assist my colleague in;

Performed data cleaning that involves simplifying big data by selectively considering characteristics by; Site IDs, Structure types, Structure and building heights.

Simplify the complex data in a table, aiming to make it more understandable and concise.

Optimize data by employing pivot table, for ease of viewing.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Pre-audit data verification.

Files involved: LOO Site Leasing Approval Rate Rental - May 2023
From the above file, I assist my colleague in;

Performed data cleaning that involves simplifying big data by selectively considering characteristics by; Site IDs, Structure types, Structure and building heights.

Simplify the complex data in a table, aiming to make it more understandable and concise.

Optimize data by employing pivot table, for ease of viewing.

# data[].attributes.body
Continue previous task assigned:
Pre-audit data verification.

Files involved: LOO Site Leasing Approval Rate Rental - May 2023
From the above file, I assist my colleague in;

Performed data cleaning that involves simplifying big data by selectively considering characteristics by; Site IDs, Structure types, Structure and building heights.

Simplify the complex data in a table, aiming to make it more understandable and concise.

Optimize data by employing pivot table, for ease of viewing.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
9.00am-12.00pm
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

12.00pm-2.00pm
Lunch Break

2.00pm onwards

Continue my daily assigned tasks.

Participated in Learning Friday: DNB Procurement Policies and Procedures.

Gained deeper understanding of DNB's procurement and processes, policies and procedures.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Participated in the VO (Variation Order) Audit with the team.

Gather and compile data for the VO (Variation Order) audit, focusing on a sample of 30 sites distributed across 6 regions; Central, Northern, Southern, Eastern, Sabah, Sarawak.

Create a comprehensive list of the BOQ (Bill of Quantity) for the power supply work conducted at each of the selected sites.

Cross-reference checks with the LOO (Letter of Offer) and the SLAF (Site Leasing Approval Form) files associated with the respective site IDs.

Ensure accuracy and consistency in the data gathered, for further review and analysis.

# data[].attributes.body
Continued the previous task assigned:

Participated in the VO (Variation Order) Audit with the team.

Gather and compile data for the VO (Variation Order) audit, focusing on a sample of 30 sites distributed across 6 regions; Central, Northern, Southern, Eastern, Sabah, Sarawak.

Create a comprehensive list of the BOQ (Bill of Quantity) for the power supply work conducted at each of the selected sites.

Cross-reference checks with the LOO (Letter of Offer) and the SLAF (Site Leasing Approval Form) files associated with the respective site IDs.

Ensure accuracy and consistency in the data gathered, for further review and analysis.

# data[].attributes.body
Continued the previous task assigned:
Participated in the VO (Variation Order) Audit with the team.

Gather and compile data for the VO (Variation Order) audit, focusing on a sample of 30 sites distributed across 6 regions; Central, Northern, Southern, Eastern, Sabah, Sarawak.

Create a comprehensive list of the BOQ (Bill of Quantity) for the power supply work conducted at each of the selected sites.

Cross-reference checks with the LOO (Letter of Offer) and the SLAF (Site Leasing Approval Form) files associated with the respective site IDs.

Ensure accuracy and consistency in the data gathered, for further review and analysis.

# data[].attributes.body
9.00am-12.00pm
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

12.00pm
Lunch Break

3.30pm-4.00pm
Practicum Visit Meeting with the Visiting Supervisor.

Brief of my tasks and responsibilities during my internship with the visiting supervisor.

Visiting Supervisor:
Dr. Mohd Yushairi bin Mat Yusoff

Supervisor in Charge:
Ms. Yap Kuan Yung (Senior Manager, Financial and Operations Auditor)
Chris Yong (Manager, Corporate Assurance)

4.00pm-6.00pm
Been assigned a task on:

Cross-reference check and verify the sign-off on the Self Declaration Authorized Letter of Acceptance (ALOA) by the respective Person in Charge (PIC)

Identify discrepancies and variations founded from my observation.

# data[].attributes.body
Public Holiday: Muharram/Islamic New Year

# data[].attributes.body
Files involved: 5G Master Rollout

Utilizing Excel's VLOOKUP function, the big data was processed to simplify it for pre-audit purpose.

Develop a table summarized based on the 4 key items: Site IDs, Infrastructure company (InfraCo), Total monthly Site Leasing Rate and Total Variation Order (VO) for each sites.

# data[].attributes.body
Continued the previous task assigned:
Files involved: 5G Master Rollout

Utilizing Excel's VLOOKUP function, the big data was processed to simplify it for pre-audit purpose.

Develop a table summarized based on the 4 key items: Site IDs, Infrastructure company (InfraCo), Total monthly Site Leasing Rate and Total Variation Order (VO) for each sites.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Pre-audit data verification: Verification of Payments

Perform a checking to verify the accuracy of payments made to the vendor company.

Conduct a cross-reference check between the payment amount, and the party receiver with the Letter of Offer (LOO) and the Site Leasing Approval Form (SLAF).

Jotting down all the initial observation/discrepancy obtained to facilitate discussion with other departments.

# data[].attributes.body
Proceed with my previous assigned task:
Pre-audit data verification: Verification of Payments

Perform a checking to verify the accuracy of payments made to the vendor company.

Conduct a cross-reference check between the payment amount, and the party receiver with the Letter of Offer (LOO) and the Site Leasing Approval Form (SLAF).

Jotting down all the initial observation/discrepancy obtained to facilitate discussion with other departments.

# data[].attributes.body
Proceed with my previous assigned task:
Pre-audit data verification: Verification of Payments

Perform a checking to verify the accuracy of payments made to the vendor company.

Conduct a cross-reference check between the payment amount, and the party receiver with the Letter of Offer (LOO) and the Site Leasing Approval Form (SLAF).

Jotting down all the initial observation/discrepancy obtained to facilitate discussion with other departments.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

# data[].attributes.body
9.00am-12.00pm
Repetitive tasks: Proceed with my daily assigned task:

Assists to extract the information from the Letter of Offer and data injection into Excel Files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyzed the information stated in the Letter of Offer aligned with the corresponding data specified in the Excel tracking files.

12.00pm-2.00pm
Lunch break

2.00pm - 6.00pm

Complete the Exit Clearance Form - Last day internship

Exit Clearance Form: Request for sign-off from person in-charge (PIC) from respective departments

Hand over all the assets assigned (Laptop, Access Card, Mouse)

# data[].attributes.body
Support the team by performing daily tasks to support the internal audit process.

Perform data cleaning from the big data to ensure that all the findings are supported with reliable and accurate information.

Assist to extract information from the letter of offer and data injection into Excel files as a centralized master file for all information which helps to provide a meaningful overview.

Cross reference and analyze the information stated in the letter of offer aligned with the corresponding data specified in the Excel tracking file.

Assist the team to validate pre-audit data verification to ensure its accuracy before commencing audit process.

Perform vouching to audit evidence to ensure service delivered as per supporting documents provided.

# data[].attributes.body
Supervisor: Ms. Yap Kuan Yung (Senior Manager, Financial and Operations Auditor)