Skip to main content
Vaishnavi Karnam

Vaishnavi Karnam

Data Analyst | MIS & Dashboard Reporting | Financial Services

Talent
Bengaluru/BangaloreMember since November 11, 2026
SQLPower BIAdvanced ExcelPivot TablesVLOOKUPDashboard DesignGen AIReconciliationMIS ReportingBloombergFactSetIDCISINCUSIPSEDOLLean Process Improvement
·

Hire this person

Send a job offer directly to this candidate

SQLPower BIAdvanced ExcelPivot TablesVLOOKUP

About

Data analyst with 9+ years in financial services at HSBC and State Street Global Advisors, specializing in MIS reporting, dashboard design, and validation of large third-party datasets (Bloomberg, FactSet, IDC). Skilled in SQL, Power BI and advanced Excel, with a record of turning complex data into clear insights for senior stakeholders and clients across APAC and EMEA. Available to join immediately.

Experience

Assistant Manager, Data Management at HSBC (2022-09 – 2024-10)

  • Collecting, cleaning, validated, and analysing large datasets from multiple internal and external sources of HSBC.
  • Develop and maintain dashboards, KPIs, reports, and analytical models for clients and internal teams.
  • Analysing business performance and operational metrics.
  • Used SQL to extract, transform, and manage data from databases.
  • Created interactive dashboards and visualizations using Power BI and Excel.
  • Worked closely with business stakeholders to understand reporting and analytical requirements.
  • Developed automated reporting processes to improve data accuracy and efficiency.
  • Ensure data quality, consistency, integrity, and confidentiality.
  • Present analytical findings and insights to management and relevant teams.
  • Mentor junior analysts and support the development of analytical best practices.

Senior Associate, Client Reporting & Services at State Street Global Advisors (2019-06 – 2022-05)

  • Delivered customized client valuations reports across daily to annual cycles, consistently meeting or exceeding SLAs.
  • Led the onshore-to-India GCC transition of Dutch Cost Reporting with zero client impact: documented the process, trained the India team, and automated delivery with IT using Excel macros.
  • Automated holdings and transactions client reports, freeing analyst capacity for higher-value servicing and exception management.
  • Validated data from Fund Performance and Reconciliation teams for accuracy; prepared monthly MIS statistics reports for senior management.

Associate II, MIS & Market Data Reference at State Street Global Advisors (2017-02 – 2019-06)

  • Consolidated data from Operations, Fund Performance and Reconciliation into Excel dashboards (pivot tables, VLOOKUP, conditional formatting, charts) for senior management.
  • Gathered requirements directly from leadership, defined key metrics, and tracked operational process metrics to surface trends and anomalies; primary contact for ad hoc reporting requests.

Associate, Market Data Reference at State Street Global Advisors (2015-12 – 2017-02)

  • Managed Missing Price Reporting using Bloomberg, FactSet and IDC within strict tolerance controls; validated ISIN, CUSIP and SEDOL reference data and escalated tolerance breaks.

Intern at State Street Global Advisors (2015-08 – 2015-11)

Education

M.Com – Dayananda Sagar Business School, Bangalore University (2013 – 2015)

B.Com – Vijaya College, Bangalore University (2010 – 2013)

Skills

Data AnalystMIS & Dashboard ReportingFinancial Services

Reviews

Related