Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

ANSHITAA KHANNA

Summary

With an MBA in Finance and a passion for numbers and strategy, I’ve consistently aligned my career choices to build deep expertise in core finance. Starting with hands-on tax consulting at Deloitte USI, I developed precision in financial reporting, regulatory compliance, and advanced Excel modeling. To strengthen my market understanding, I pursued the NCFM certification and gained practical exposure in stock market fundamentals and investment analysis. My internships and academic projects allowed me to dive into financial modeling, valuation (DCF, WACC, IRR), and data-driven decision-making. I’m now looking to apply this foundation in a core finance role where I can contribute to investment analysis, strategic planning, and value creation through financial insight.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Tax Consultant

Deloitte USI
11.2024 - Current
  • Preparation and quality review of US federal and state tax returns for corporate and partnership entities, ensuring full compliance with IRS and state regulations.
  • Engineer complex Excel workpapers using advanced Excel capabilities (e.g., dynamic arrays, nested logic functions, scenario modelling) to support tax calculations and audit trails.
  • Conduct comprehensive reconciliation of trial balances and financial schedules, proactively resolving discrepancies and improving reporting accuracy.
  • Drive process optimization through cross-functional collaboration among the teams to enhance tax preparation workflows.
  • Participate in strategic knowledge-sharing forums to remain abreast of legislative changes and support training initiatives within the team.
  • Maintain strict confidentiality protocols while handling high-volume sensitive tax and financial data.

Tax Intern

Deloitte USI
05.2023 - 07.2023
  • Streamlined tax compliance by preparing and filing 30+ federal and state entity tax returns using advanced tax software, boosting team efficiency and ensuring 100% accuracy.
  • Designed and maintained robust Excel workpapers, documenting entity-specific calculations and tax positions to support filing integrity and internal consistency.
  • Prepared individual, trust, partnership and corporate tax returns.
  • Contributed to successful client engagements by providing reliable support during busy season deadlines.

Finance Intern

Panasonic
01.2023 - 02.2023
  • Supported financial reporting by synthesizing large datasets into actionable reports for senior finance leadership.
  • Assisted in variance analysis and forecasting during budget cycles, providing data-driven insights and adjustment recommendations.
  • Automated invoice tracking and contributed to the integrity of profit & loss records through meticulous reconciliation.
  • Executed month-end bank and ledger reconciliations to validate transaction accuracy and improve audit preparedness.

Education

MBA - Finance

LM Thapar School of Management
Punjab
05.2024

Bachelor of Commerce -

Panjab University
Chandigarh
07.2022

Higher Secondary School Certificate -

KBDAV Sr. Sec. School
Chandigarh
03.2019

Skills

  • Advanced Microsoft Excel
  • Stock market and equity research
  • DCF and relative valuation
  • Financial modeling and valuation
  • Financial statement analysis
  • Investment and portfolio analysis
  • Corporate taxation
  • Data visualization
  • US federal and state tax compliance
  • Analytical and critical reasoning
  • Presentational skills
  • Excellent communication skills
  • Cross-functional collaboration
  • Strategic time and workflow management

Certification

  • NSE Academy's Certification in Financial Markets (NCFM)
  • Financial Modelling and Valuation
  • Advanced Excel

Projects

Financial accounting and valuation:

  • Conducted in-depth corporate valuation through discounted cash flow (DCF) and comparable company analysis using real-time market data
  • Built multi-layered financial models to compute key investment metrics such as WACC, NPV, IRR, and sensitivity projections supporting capital budgeting decisions.

Sustainability in practice:

  • Designed and executed a large-scale mental health analytics project, leveraging survey tools and Excel-based visualizations to uncover high-risk stress indicators among the student population
  • Synthesized complex data into strategic reports and presented actionable findings to academic leadership for policy development

Excel modeling

  • Developed interactive Excel-based financial dashboards and data models to conduct competitive benchmarking in the mobile technology sector
  • Applied scenario analysis, logical functions, and visualizations to extract insights on market segmentation and pricing strategies
  • Engineered complex Excel models that facilitated financial forecasting, thereby enabling strategic business decision-making

Timeline

Tax Consultant

Deloitte USI
11.2024 - Current

Tax Intern

Deloitte USI
05.2023 - 07.2023

Finance Intern

Panasonic
01.2023 - 02.2023

MBA - Finance

LM Thapar School of Management

Bachelor of Commerce -

Panjab University

Higher Secondary School Certificate -

KBDAV Sr. Sec. School
ANSHITAA KHANNA