Yasangi Gamage Working as Financial Analyst,Excel, power BI
No reviews yet

In my role as a financial analyst, I've mastered the art of transforming numbers into compelling narratives. What truly sets me apart is my passion for crafting visually stunning Power BI dashboards and utilizing advanced Excel formulas. I don't just crunch numbers; I orchestrate them into dynamic visualizations that not only tell a story but captivate audiences.

Picture this: financial data brought to life through interactive Power BI dashboards, where every trend, every anomaly, speaks volumes. I thrive on the challenge of creating a symphony of data visualizations that not only look impressive but also serve as powerful decision-making tools. My approach goes beyond the ordinary – it's about turning raw numbers into a visual journey, making financial analysis not just insightful but downright captivating.

And when it comes to Excel, I don't see formulas as mere equations; they are the building blocks of precision and accuracy. I'm dedicated to integrating these formulas seamlessly, ensuring that the financial insights generated are not only comprehensive but also reliable. Together, Power BI and Excel become my dynamic duo for unraveling financial complexities, presenting a clear roadmap for strategic decision-making

Subjects

  • Writing skills and Creative writing Beginner-Intermediate

  • Power BI dashboard Beginner-Intermediate

  • Excel charts Beginner-Intermediate

Experience

  • Financial analyst (Apr, 2023–Present) at Oscar Wylee-Remotely working from Sri Lanka Cloud Atlantic International (Pvt) Ltd
    •Reporting to Oscar Wylee Client an Australian led eyewear retailer and optometry service provider
    •Developing Power BI Dashboards and analyzing data with comparisons Developing & preparing performancereports P&L variance analysis
    •Proactively review and audit data held in business systems.
    •Drive continuous improvement of reporting
    •Proactively update and resolve system errors.
    •Weekly and Monthly sales report insights to Management
    •Preparation of financial models
  • Assistant Accountant (May, 2022–Apr, 2023) at SAS Sport Ltd-Remotely working from Sri Lanka
    •Preparation of Monthly and Annual accounts Preparing financial statements, budgets, forecasts, or other reports using spreadsheets or databases
    •Cash flow management and Banking Handling of client Invoices and Arranging Supplier Payments
    •Intercompany Reconciliation Preparation of Sales report
    •Create informative, actionable and repeatable reporting that highlights relevant business trends andopportunities for improvement with Ratio analysis and preparing monthly presentations
    •Coordinate with the New Zealand team Analyzing financial data and reporting results to senior management
    •Reviewing financial statements and preparing forecasts of future performance based on current trends
    •Reviewing financial transactions to detect errors or fraudulent activity
    •Perform additional duties in line with the current role
  • Accounts Executive (Jan, 2021–Apr, 2022) at SAS Sport Ltd-Remotely working from Sri Lanka
    •Invoicing,Local and Import shipments Entering to the Accounting System- Accredo
    •Receipting and Allocation of receipts on time
    •Preparation of Margin reports with Analysis
    •Preparation SAS Creative presentation to the Management
    •Contribute to team effort by accomplishing related results as needed
    •Compiling charts, tables, and other elements of data visualization for Margin Analysis
    •Conduct insightful analysis to investigate operational issues
    •Analyzing financial data, taking into account company’s goals and financial standing
  • Junior Associate Finance Operations (Jun, 2019–Dec, 2020) at MAS Legato (Pvt) Ltd-Biyagama,Sri Lanka
    •Executive recovery activities and ensure proper follow - up mechanisms are put in place to recover moneywithin the set credit period Ensure discrepancies are followed - up and resolved prior to the month end closure.
    •Maintain proper documentation of follow up efforts
    •Ensure receipts are cleared in keeping with the SLA
    •Preparation of customer account reconciliations and other MI reports as assigned
    •Ensure SOPs are kept up to date.
    •Active involvement in knowledge sharing initiatives within the department
    •Provide necessary management information reports for decision making

Education

  • MSc Business Analytics (May, 2022–now) from Robert Gordon University, Aberdeen
  • Professional Qualification (Aug, 2020–Feb, 2021) from The Charted Institute of Management Accounts
  • ACCA (Jul, 2018–Oct, 2018) from Association of Charted Certified Accountants
  • BSc. (Hons) Accounting and Finance (Mar, 2016–Jun, 2019) from NSBM Green University affiliated with Plymouth University UK–scored 1st Class

Fee details

    රු2,500–3,500/hour (US$8.54–11.95/hour)

Reviews

No reviews yet. Be the first one to review this tutor.