Kiran Vijay

BNY

• Lead a team of 5 analysts delivering enterprise Power BI solutions, curated analytical datasets, reporting automation, and AI-enabled analytics across finance and operations.
• Own the design and delivery of enterprise Power BI solutions for finance analytics, including executive dashboards, variance analysis, self-service reporting, and curated datasets.
• Build scalable Power BI semantic models with star-schema design, governed DAX measures, calculation groups, RLS, reusable metric definitions, and optimized refresh patterns.
• Create curated analytical datasets on Snowflake and Vertica to support expense, headcount, and operational reporting across finance leadership use cases.
• Convert complex stakeholder requirements into structured BI products, covering data model design, KPI logic, report UX, drill-down flows, and performance requirements.
• Improve report performance and model reliability through DAX optimization, relationship redesign, aggregation logic, query tuning, and refresh strategy improvements.
• Combine data from Snowflake, Vertica, Impala, Oracle, and Excel inputs into unified reporting models with standardized business rules and governed definitions.
• Apply AI-assisted analytics using Microsoft Fabric, Power BI Copilot, and internal LLM tools to support natural-language exploration, variance commentary, and insight generation.
• Built RAG-based GenAI solutions on an internal LLM platform to explain expense variance and headcount movements using structured prompts and business-context retrieval.
• Automated recurring reporting and data preparation workflows, improving reporting consistency, refresh reliability, and reducing manual effort across finance reporting processes.

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

BNY

• 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

• 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

• 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

• 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

• 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