AM01 - Financial Reporting Engineer
Skills:
Proficient in using SQL to extract, manipulate, and transform data from multiple databases into actionable insights, including creating common table expressions (CTEs), joins, and stored procedures for Power BI reports and dashboards.
Developed complex Excel solutions using macros, VBA, nested IF statements, Power Pivot, XLOOKUP, and pivot tables to automate processes, reduce manual effort, and streamline reporting.
Created tailored Power BI reports with DAX, M code, and Power Query to support sales quotas, trend forecasting, and strategic decision-making for executives and product teams.
Designed and implemented data integration workflows, leveraging SQL and Excel to enhance reporting efficiency, automate commission payments, and streamline financial tracking for large-scale operations.
Built comprehensive metric databases and reports for global stakeholders
Partnered with international teams to optimize data workflows using SQL, Excel, and Salesforce