Financial Analyst Power Bi

Vaibhavi Bembalkar

470-***-**** *************@*****.*** Atlanta, Georgia, United States LinkedIn WORK EXPERIENCE

Project Financial Analyst, Pune, India Feb 2023 - Jul 2024 Emerson Export Engineering Centre

Synthesized and aggregated data for around 1500 active projects of MEA region to facilitate statutory audits, proactively addressed auditor's inquiries ensuring precise and timely audit outcomes. Presented monthly Power BI dashboards to regional leadership, highlighting financial KPIs and performance metrics across $50M in MEA projects to support strategic decisions. Streamlined the control accounts summary and aging reports by creating a dynamic Excel spreadsheet with interactive slicers, reducing monthly processing time by 6 hours. Assessed $20 million in revenue for projects within Machine Automation Solutions BU, meticulously analyzed key documents to ensure adherence to IFRS 15 revenue recognition standards. Conducted monthly reviews for 10 long-duration projects of approx. $5M each, ensuring accurate cost allocation, revenue recognition, and investigated cost overruns. Led reconciliation of sub-ledgers and general ledgers (GL), supported month-end close activities, and prepared MIS reports leveraged by MEA leadership for financial decision-making and performance tracking. Apprenticeship - Assurance & Advisory, Pune, India Jul 2018 - Jul 2021 Chandorkar & Limaye Chartered Accountants LLP

Performed monthly variance analysis to identify cost drivers and inefficiencies, enabling an 10% reduction in overhead through targeted recommendations.

Executed internal audit of payroll processes for an automobile company with a turnover of approximately $100 million, promptly detecting non – compliance with labour laws leading to savings of $1 million in potential penalties. Independently led and executed end-to-end financial statement audits for Four small companies with annual revenue turnover up to $5 million, also delivering actionable insights to enhance financial reporting accuracy. Provided strategic tax planning for individuals and corporations, resulting in an average tax liability reduction of 15% through optimized deductions and exemptions.

Spearheaded a team of 3 in financial statement audit for a company with a turnover of $20M overseeing planning, execution, and reporting phase.

EDUCATION

Georgia State University, Atlanta, United States - Master of Science, Finance Aug 2024 - Dec 2025

(Emphasis on Corporate finance, Asset Valuation, Financial Data Analytics, AI in Finance, Blockchain.) The American Institute of Certified Public Accountants - CPA Present Institute of Chartered Accountants of India - Chartered Accountant, Jun 2016 - Nov 2022 Cleared all three levels in the top 8-15% percentile.

(Emphasis on Audit, Taxes, Financial reporting, Strategic Financial Management, Corporate Strategy) Savitribai Phule Pune University, Pune, India - Master's, Commerce Dec 2020 - Dec 2022 Savitribai Phule Pune University, Pune, India - Bachelor's, Commerce Jun 2016 - May 2019 SKILLS

Technical Skills : Microsoft Excel, Python, Machine Learning, Power BI, Oracle Financial Skills : Auditing and Assurance, Financial Reporting, Variance analysis, Forecasting, Financial Modelling, Financial Statement Analysis, DCF Valuation Professional Memberships : World Affairs Council of Atlanta, Portfolio Management Club, Panthers Consulting Club, Institute of Chartered Accountants of India

Awards : Rising Star Award (Emerson Export Engineering Centre) Certifications : Data Visualisation in Power BI, Bloomberg Market Concepts ACADEMIC PROJECTS

Managed a $250K simulated multi-asset portfolio across equities, bonds, crypto, futures, and options during volatile markets; outperformed the S&P 500 by optimizing Sharpe ratio through strategic hedging and dynamic asset allocation. Pitched two stock recommendations for a $50K allocation in the Consumer Discretionary sector of a $10M student- managed portfolio. Led investment analysis and conducted detailed company valuations using DCF and Comparable Companies (COMPS) approach.

Contact this candidate