Summary
Overview
Work History
Education
Skills
Languages
Project Completion
Timeline
Hi, I’m

Umi Sharmila Malek

Johor Bahru

Summary

I’m a curious and hands-on Junior Financial Analyst with a background in accounting and a growing passion for making finance work smarter—not harder. I started in GL and reporting, but quickly found myself drawn to tools like Power BI, Power Apps, and Excel to improve the way we work.

I enjoy spotting gaps, asking “why do we do it this way?”, and turning problems into practical solutions—whether it’s automating a manual process, building a dashboard, or creating templates that actually help people make decisions. I don’t just follow the process—I look for ways to improve it.

My goal is to grow into a Financial Solution Architect—someone who not only understands the numbers, but also designs better ways to work with them. To get there, I want to face more real-world problems, across systems, teams, and processes. If you’re looking for someone who can bring a different point of view, challenge the usual way of doing things, and turn ideas into practical solutions—I’m in.

Overview

7
years of professional experience

Work History

Handal Indah Sdn Bhd

Junior Financial Analyst
06.2023 - Current

Job overview

  • Transitioned from a General Ledger-focused role in accounting to a data-driven financial analyst position, aligning finance operations with modern reporting and automation tools.
  • Supported finance and accounting teams in month-end closing and GL reconciliations, ensuring accuracy and compliance.
  • Created and maintained detailed financial models, variance analyses, and operational dashboards to support business decisions.
  • Developed a Power BI dashboard to track daily cash collection and overall performance, enabling faster performance insights and improved transparency.
  • Designed and implemented a custom Power Apps solution to streamline the daily cash collection process, reducing manual errors and processing time.
  • Conducted in-depth data analysis to support financial forecasting, budgeting, and cost optimization.
  • Trained colleagues on data tools including SQL, Power BI, and Excel to improve reporting and team capability.
  • Facilitated internal audits with timely documentation and cross-functional support.
  • Proactively improved data structure and reporting processes, reducing manual workload across departments.

MB Vest Sdn Bhd (Capri by Fraser Johor Bahru)

Accountant
05.2022 - 05.2023

Job overview

  • Promoted after leading the successful setup and implementation of the Purchasing and Inventory modules in Sage 300, streamlining procurement and stock management processes across departments.
  • Saved significant man-hours for the Purchasing team by automating quotation price comparisons, eliminating the need to manually re-enter and validate vendor data.
  • Resolved month-end inventory bottlenecks by configuring the system to automatically apply latest purchase prices to inventory items—replacing a manual, error-prone process that previously involved physical stock counts and invoice lookups.
  • Developed and automated a food cost analysis template in Excel, linking it with real-time purchasing prices to improve cost accuracy and support pricing strategies in F&B.
  • Negotiated improved pricing and terms with vendors, contributing to measurable cost savings on recurring operational supplies.
  • Supported smooth system upgrades by collaborating with the IT team, ensuring minimal disruption during financial and operational transitions.
  • Managed full spectrum of monthly closing: accruals, prepayments, P&L generation, stock count adjustments, and leading P&L meetings.
  • Prepared SST documents for bi-monthly tax submission and ensured compliance with reporting timelines.
  • Maintained accurate and complete schedules for contracts, licenses, permits, and insurance coverage; liaised with government and regulatory bodies when required.
  • Provided audit support and documentation for both internal and external auditors.

Syed Alwi, Ng & Co.

Account Associate
11.2021 - 04.2022

Job overview

  • Law Firm at City Square Johor Bahru

MB Vest Sdn Bhd (Capri by Fraser Johor Bahru)

Account Executive
10.2019 - 10.2021

Massiv Advisory Sdn Bhd

Account Associate
04.2018 - 09.2019

Job overview

  • An account firm at Taman Ponderosa

Education

UNIVERSITI TEKNOLOGI MARA (UITM) ARAU, PERLIS

BSc. Mathematics Management
01.2017

University Overview

GPA: 3.44

UNIVERSITI TEKNOLOGI MARA (UITM) PUNCAK ALAM, SELANGOR

Foundation of Science
01.2014

University Overview

GPA: 3.22

Skills

  • Microsoft Office
  • Microsoft Power
  • Financial Management
  • Preparing budgets
  • Report Preparation and Presentation
  • Attention to Detail
  • Financial Data Analysis

Languages

Bahasa Melayu
Proficient
C2
English
Proficient
C2

Project Completion

Current Company

(Junior Financial Analyst, Handal Indah Sdn Bhd – Transportation Industry)

  • Successfully transitioned from an accounting-focused role to a financial analyst position by adopting and applying tools like Power BI, Power Apps, Excel, and SQL to drive data accuracy and operational efficiency.
  • Designed and deployed a Power BI dashboard for tracking daily cash collection, enhancing real-time visibility and supporting management reporting.
  • Developed a custom Power Apps form to digitize the daily cash collection process—reducing manual input, minimizing errors, and streamlining cross-departmental reporting.
  • Automated the summary of hire purchase schedules for over 100 buses, improving clarity of financial commitments and reducing reporting time.
  • Constructed a consolidated group management account model with detailed analysis across projects and routes, enabling data-driven decision-making.
  • Designed an intuitive budgeting template using historical trends, simplifying the forecasting process for department heads and improving budgeting accuracy.
  • Trained colleagues on key data tools and financial systems, boosting internal analytical capabilities and adoption of digital tools.
  • Known for proactively identifying process gaps, implementing practical solutions, and clearly communicating improvements to stakeholders.

Previous Company

(Accountant / Accounts Executive, Capri by Fraser – Hotel Industry)

  • Promoted from Accounts Executive to Accountant after leading the successful implementation of the Purchasing and Inventory modules in Sage 300, significantly reducing manual processes for the Purchasing and F&B teams.
  • Eliminated hours of manual work by automating quotation comparisons and vendor price checks, increasing purchasing accuracy and speed.
  • Streamlined the inventory month-end process by linking real-time pricing to inventory data, eliminating manual invoice lookups and reducing stock valuation delays.
  • Developed an automated food cost template in Excel, integrated with real-time purchasing data, which enabled the Head Chef to monitor costs and margins more effectively.
  • Played a key role in cost control through vendor negotiations, ensured timely tax (SST) submissions, and led smooth and accurate month-end closings.
  • Actively liaised with auditors and regulatory bodies, maintained compliance documentation, and ensured operational readiness across financial functions.

Timeline

Junior Financial Analyst

Handal Indah Sdn Bhd
06.2023 - Current

Accountant

MB Vest Sdn Bhd (Capri by Fraser Johor Bahru)
05.2022 - 05.2023

Account Associate

Syed Alwi, Ng & Co.
11.2021 - 04.2022

Account Executive

MB Vest Sdn Bhd (Capri by Fraser Johor Bahru)
10.2019 - 10.2021

Account Associate

Massiv Advisory Sdn Bhd
04.2018 - 09.2019

UNIVERSITI TEKNOLOGI MARA (UITM) ARAU, PERLIS

BSc. Mathematics Management

UNIVERSITI TEKNOLOGI MARA (UITM) PUNCAK ALAM, SELANGOR

Foundation of Science
Umi Sharmila Malek