Open to opportunities

Ansh Bhavsar

@anshbhavsar

Financial Data Analyst using SQL, Power BI, and Python to automate reporting, uncover anomalies, and drive data-driven decisions.

United States

Message

What I'm looking for

I’m looking for a finance/analytics role where I can automate reporting, strengthen data quality, and partner cross-functionally to improve KPI visibility and decision-making through SQL, Power BI, and Python.

I’m a Financial Data Analyst with experience supporting financial planning, budgeting, forecasting, financial reporting, KPI analysis, and process improvement across finance and consulting environments. I use SQL, Power BI, and Python to analyze operational performance and deliver data-driven business insights.

In my current role at Bloomberg Limited Partners, I analyze 10,000+ institutional FX transactions and investigate pricing anomalies, exceptions, and data quality issues using SQL-based analysis. I improved reporting accuracy by 20% through automated QA, data validation, and exception analysis, reducing manual effort by 25%, while partnering with Engineering, Product, and Analytics to improve reporting workflows.

Previously, I built budgeting, forecasting, and financial planning models and performed variance, profitability, and ratio analysis to support operational decision-making and cost optimization. I also developed automated Power BI dashboards and KPI reports from market and portfolio datasets, and I’ve applied valuation and risk modeling through projects like DCF, Monte Carlo simulation, and scenario analysis.

Experience

Work history, roles, and key accomplishments

Current

Financial Data Analyst

Current

Bloomberg Limited Partners

Nov 2025 - Present (9 months)

Analyzed 10,000+ institutional FX transactions across spot, forwards, swaps, and NDF products to identify pricing anomalies and market risk. Improved reporting accuracy by 20% through automated QA, data validation, and exception analysis, supporting monthly reporting cycles.

FX Analysis Market Risk SQL Data Quality Data Validation Automated QA Financial Reporting KPI Analysis Process Improvement

Financial Consultant

Small Business Development Center, Temple University

Sep 2024 - May 2025 (8 months)

Evaluated small business financial statements, cash flow, and working capital to assess financial health and lending readiness. Built budgeting and forecasting models, performed variance and ratio analysis, and supported KPI dashboard reporting with improved client cash management by 20% and operating margins by 10%.

Financial Statement Analysis Cash Flow Analysis Working Capital Budgeting Forecasting Financial Modeling Profitability Analysis KPI Reporting Stakeholder Communication

Financial Analyst

Shah Investors Home Ltd (SIHL)

Jan 2021 - Jul 2023 (2 years 6 months)

Analyzed historical market and portfolio datasets to identify investment trends and market inefficiencies and validated data to resolve reporting discrepancies. Built automated Power BI dashboards and KPI reports to support operational performance monitoring and executive decision-making.

Financial Analysis Market Trends Data Validation Excel SQL Power BI KPI Reporting Dashboard Development

Education

Degrees, certifications, and relevant coursework

Temple University - Fox School of Business

Master of Science, Financial Analysis

Grade: GPA: 3.83 (Dean’s Scholarship Recipient)

Activities and societies: Relevant coursework: Derivatives & Risk Management, Fixed Income, Financial Econometrics, Financial Mathematics, Data Science.

Earned a Master of Science in Financial Analysis from Temple University (Fox School of Business), graduating May 2025. Received a Dean’s Scholarship and achieved a GPA of 3.83.