Supported sales management by providing Lead source analysis, turning data entries coming through a Google Sheet into charts by transforming the customer entries into BigQuery tables that are loaded into Looker for data visualization, after joining the tables. The bar chart allows the sales manager to compare the marketing performance of all marketing sources across the last 90 days, and confirm the ROI on Paid ads. Supported the sales team by providing information about the leads that need to be closed, narrowing down the leads that are in progress and removing the leads that were lost from the whole list, so they can focus on the real prospects. Supported CEO by providing insights on Month to Date revenue compared to the MTD revenue in the last year and last month. This enables the executive board to improve their strategies to ensure growth. Supported Operations by giving information about the number of jobs completed this month compared to the same period a month ago and a year ago. Also, providing the total cost expenditure per job and providing a profitability analysis. Maintained databases and dashboards, managing internal reports for ad-hoc analysis. Supported cash flow management by aligning billing, collections, and client payments with expected inflows and outflows, and flagging outstanding payments. Supported P&L and balance sheet preparation by providing category-based income and expense reports. Managed executive calendars, inboxes, and internal communication, ensuring priorities, deadlines, and follow-ups are handled efficiently. Prepared presentations and written communications for internal and external stakeholders.