Kiran Vijay

Vice President

image

Experienced data professional with a strong background in business intelligence, data analysis, and automation. Skilled in Power BI, Alteryx, Azure, and various Microsoft technologies. Proven track record of leading teams, developing efficient solutions, and driving data-driven decision-making across multiple functions.


Work Experiences

Vice President

BNY Mellon | May 2024 - Present
  • Promoted to Vice President, expanding leadership role to cover both FMA and Controllers functions.
  • Leading an expanded team of 7 members to develop automation solutions across multiple functions.
  • Spearheaded automation efforts resulting in 1460 hours saved, significantly improving operational efficiency.
  • Architected end-to-end BI solutions using Power BI, establishing backend connections with Impala, Vertica, Oracle and leveraging SQL for efficient data processing and visualization.
  • Translated complex business requirements into technical specifications, developing executive dashboards that enhanced data-driven decision making.
  • Acted as mentor for Interns and Analyst hires from IIM grad schools, fostering talent development.

Lead Data Analyst

BNY Mellon | Apr 2023 – Mar 2024
  • Led a 4-member team to develop automation solutions for various functions with FMA.
  • Played the role of a solution architect to design and deliver efficient automation solutions.
  • Acted as the key resource for the team, fostering effective problem-solving and knowledge-sharing while resolving complex use cases and data-related issues.
  • Developed and delivered key dashboard for the executives.
  • Consistently delivered top-quality data solutions leveraging advanced features of Power BI, Alteryx, UiPath and other data tools.

Senior Data Analyst

BNY Mellon | Jun 2021 - Mar 2023
  • Improved process efficiency by 60% by developing scalable solutions for Headcount movement and IB/NIB Deposit classification using Alteryx.
  • Recognized as the Subject Matter Expert for Deposits and Headcount solutions.
  • Reduced manual reporting by 50% by creating automated BI reports/dashboards for Client liquidity, CT CLR run-off, and Headcount using Power BI.
  • Delivered detailed, printable reports of large datasets to meet business requirements through the development of paginated reports.

Deputy Manager- Data Specialist

Philips GBS | Nov 2020 - Jul 2021
  • Responsible for creating one source of truth for Inventory
  • Working on Azure data lake and Azure Synapse as data source for the supply chain reports

Asst Manager-BI Developer

Philips GBS | Jun 2018 - Nov 2020
  • Headed Power BI report development for Inventory report from scratch
  • Created multiple business solution for markets using tools like PowerApps and Power Automate
  • Worked with subject matter experts to translate business requirements into highly scalable Power BI solutions
  • Responsible for Administrative activities on Power BI Premium Capacity
  • Created scalable and reliable backup solutions to maintain report quality
  • Worked on SSIS to create multiple ETL projects

Software Developer

Encore IT | Sep 2015 - May 2018
  • Worked on SSRS to Power BI migration project for a Healthcare provider
  • Gained experience on SSIS and Power BI
  • Worked on JavaScript analytics for customer engagement projects

Achievements

  • BNY - FMA Brilliance Award – for UiPath based RPA solution.
  • Passion for Excellence – BNY Spotlight – for Oracle cloud migration project.
  • PHILIPS Employee Recognition Award – for delivering Inventory analytics dashboard which helped Operations team gain process efficiency.
  • Team up to win – PHILIPS Quarterly Recognition
  • Recognition for timely completion of Project tracking dashboard from markets SME
  • Won PEC award (Philips Excellence Competition) – Health System category – for Project Tracking dashboard.
  • GBS head recognition for delivering Inventory tracking solution for a critical COVID ventilators order management process.