Kiran Vijay

BNY · Chennai, India

• Lead a team of 5 delivering enterprise BI solutions, curated analytical datasets, and automation across finance and operations.
• Architect end-to-end analytical datasets on Snowflake — scalable, performant, reusable across reporting and AI use cases.
• Own enterprise-curated datasets (expense, headcount, operational metrics) with governed data models and standardized business logic.
• Design Power BI semantic models aligned to star schemas, governed measures, and calculation groups.
• Rolled out Microsoft Fabric and Power BI Copilot from POC to production, enabling AI-assisted exploration and natural-language analytics.
• Integrate Snowflake, Vertica, Impala, and Oracle into unified leadership-reporting models.
• Established dataset governance — metric definitions, refresh strategies, performance tuning, access controls.
• Built RAG-based GenAI solutions on internal LLM platform (Eliza) for expense variance and headcount analysis; applied prompt engineering (few-shot, structured prompts) for output consistency.
• Automated reporting workflows, saving 1,460+ hours annually.
• Mentor analysts on dataset design, Power BI best practices, and practical AI adoption.

Snowflake · Power BI · Microsoft Fabric · Copilot · Vertica · Impala · Oracle · LLM / RAG

BNY · Chennai, India

• Designed scalable Power BI dashboards using calculation groups for dynamic time intelligence and incremental refresh.
• Solution architect for data integration and reporting using SQL and Alteryx.
• Built UiPath automation refreshing reports for 100+ lines of business, cutting processing from hours to minutes.
• Saved 300+ hours of manual effort annually through automation.
• Resolved complex data quality and performance issues for business-critical reporting.
• Received the Brilliance Award for high-impact analytics and automation delivery.

Power BI · Alteryx · UiPath · SQL

BNY · Chennai, India

• Developed scalable analytics for headcount and deposit classification using Alteryx, cutting manual intervention.
• SME for deposits and headcount analytics, supporting multiple stakeholder groups.
• Built paginated Power BI reports for regulatory and operational needs.
• Created interactive dashboards with advanced DAX for liquidity management and client analytics.

Power BI · Alteryx · DAX · Paginated Reports

Philips GBS · Chennai, India

• Managed Power BI Premium capacity performance for large-scale enterprise reporting.
• Built Power Apps and Power Automate solutions to automate data collection and validation.
• Developed a server-usage tracker in Power BI driving 25% cost savings.
• Created Power Platform solutions supporting employee engagement during remote work.

Power BI Premium · Power Apps · Power Automate

Philips GBS · Chennai, India

• Led development of inventory and project tracking dashboards using Power BI and Tabular Editor.
• Delivered end-to-end analytics using DAX, calculation groups, and Power Query.
• Partnered with stakeholders to translate business requirements into scalable BI solutions.

Power BI · Tabular Editor · DAX · Power Query

Encore IT Solution · Chennai, India

• Led SSRS to Power BI migration for a healthcare client, improving reporting usability and insights.
• Built and optimized ETL pipelines using SSIS.
• Developed JavaScript-based analytics components to improve customer engagement.

SSIS · SSRS · Power BI · JavaScript

Indian Institute of Management, Nagpur

Anna University · Jeppiaar Engineering College