Vaishnavi Karnam
Data Analyst | MIS & Dashboard Reporting | Financial Services
Hire this person
Send a job offer directly to this candidate
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)

