Umar Ali

Experience

• 

  Shocklogic

  Aug 2017 - Jul 2019

  Finance Officer
• 

  One Aldwych

  Jul 2019 - Apr 2020

  Accounts Receivable Assistant
• 

  RICS

  Jun 2021 - Mar 2022

  In my role as a Billing Administrator in Birmingham, I have effectively supported the Billing Team Leader in overseeing the billing function, ensuring both accuracy and timeliness in invoicing and refunds. I’ve managed tasks such as raising invoices and credit notes, preparing BACS journal entries, processing write-offs, and addressing related queries with precision.My collaboration with the Sales Ledger, Credit Control, and other teams has been instrumental in enhancing billing operations and driving process improvements. I’ve consistently managed daily workflows, maintained high standards of accuracy, and adapted to changes within the team, ensuring smooth and efficient billing processes. My contributions have been key to maintaining the integrity and effectiveness of our billing operations. Show less Partnered with management to identify and resolve a substantial backlog of outstanding invoices, refunds, and data discrepancies, optimising financial and operational workflows through data-driven insights.Designed and implemented advanced Excel tools to clean and analyse raw datasets, develop dynamic dashboards, and track progress in backlog resolution, leading to improved efficiency.Analysed subscription data for UK and international accounts, ensuring accuracy in data allocation while identifying key trends to inform strategic business decisions.Extracted, transformed, and validated data for reporting and visualisation purposes, ensuring precision and alignment with organisational objectives.Leveraged SQL and Python to monitor transaction data patterns, generating actionable insights to improve data integrity and operational efficiency.Conducted root cause analyses of data inconsistencies, proposing and executing solutions to enhance workflows and minimise errors.Developed automated reports and dashboards using SQL, Python, and Power BI, enabling real-time tracking of critical metrics and trends. Show less

  • Billing Administrator

    Sept 2021 - Mar 2022

  • Analyst

    Jun 2021 - Sept 2021
• 

  Bupa Global

  Jul 2022 - Jun 2023

  Junior Data Engineer

  In this role, I was responsible for conducting in-depth data analysis to uncover trends, patterns, and actionable insights that supported strategic business decisions. Utilising SQL, Python, and Tableau, I extracted, manipulated, and visualised datasets to create engaging dashboards and reports that effectively communicated findings to stakeholders.Key achievements include automating daily cash receipt allocations using Python scripts to enhance accuracy and efficiency, collaborating with cross-functional teams to deliver business-aligned insights, and documenting workflows with Visio to improve communication and operational clarity.I also supported reconciliation and root cause analysis by leveraging SQL and Python, resolving discrepancies within tight SLAs. Additionally, I prepared data-driven reports and presentations for senior analysts and applied advanced statistical methods to address complex business questions, contributing to company-wide data initiatives. Show less

• 

  Envisia Learning

  Jul 2023 - now

  Data Engineer

  In my role as a Data Engineer, I successfully designed and implemented a comprehensive data warehouse, integrating data from multiple proprietary and third-party platforms to support analytics and decision-making across the organisation. I developed and optimised ETL pipelines using Apache Airflow, ensuring efficient and reliable data workflows. For example, I built custom pipelines to extract, transform, and load data from Notion into MySQL, enabling the creation of real-time dashboards in Metabase that deliver actionable insights to stakeholders.I also specialise in developing interactive dashboards and data visualisations using tools like Power BI, Tableau, and Metabase, translating complex datasets into clear, impactful visuals for business use. Collaborating closely with cross-functional teams, including senior leadership, I ensure data solutions align with strategic objectives and client needs. My work has driven improved operational efficiency and enabled data-driven decision-making across the organisation. Show less