Nikhil Suryawanshi

I’m a data analyst with an MS in Data Science from Rochester Institute of Technology and a strong foundation in computer engineering. I focus on translating raw, production-grade data into clear decision, especially where performance, risk, and business outcomes intersect.

In my current role as a Data Analyst Volunteer at Saayam for all, I designed a Super Admin Application Analytics dashboard by querying 10K+ production records from MySQL/PostgreSQL to monitor request lifecycle performance and detect service delays. I combined historical AWS S3 data with live application tables to measure resolution-time trends and deliver weekly insights that guide volunteer allocation. I also implemented AI-assisted reporting by integrating an LLM-powered search layer with structured datasets and automating weekly S3-based refresh workflows to improve consistency and reduce manual reconciliation.

Previously, I supported major cost initiatives as a Data Analyst Intern at Coherent Corp by analyzing ERP post-acquisition financial data with SQL, Python, and Excel, presenting GAAP/non-GAAP insights (EPS, revenue, COGS) to the C-suite to support a $150M cost-saving reallocation strategy. I designed and deployed seven sector-specific Power BI dashboards for a $700M cost-saving initiative and instituted enterprise-wide data governance in the Amplify platform (RBAC, anomaly detection, and hygiene processes), improving data accuracy by 25% for 10+ stakeholder teams. I’ve also built analytics systems like SmartQuery AI (LangChain + RAG) to speed up natural-language exploration, and I apply the same rigor to projects like LTV modeling and portfolio risk analysis with interactive dashboards.