Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Timeline
Generic

KIRTI KALRA

Hyderabad

Summary

Results-driven Business Intelligence Analyst with 2.5+ years of experience in ETL, data visualization, and decision-making. Expertise in maintaining data integrity and providing actionable insights through compelling reports and dashboards. Skilled at translating complex data into strategic recommendations to drive business performance and achieve organizational goals.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Business Intelligence Analyst - Analytics Tech

Aion-Tech Solutions Limited
04.2024 - Current
  • Collaborated closely with various business users to gather requirements, ensuring alignment with organizational objectives and user needs.
  • Development of the dashboards in Tableau, including data validation in MS Excel for data accuracy.
  • Designed and implemented Market Intelligence dashboards for the Europe and North America Team, reducing manual efforts of stakeholders by 50% for comparing market position with multiple market competitors.
  • Fetched data from the Google Cloud platform while limiting the data using custom SQL queries in the Tableau environment, resulting in a 30% increase in dashboard performance.
  • Developed Pricing Dashboard to get daily updates on what prices the team has decided to sell products, to keep tabs on price variations, and external and internal floor prices for each product, leading to a 40% improvement in data-driven decision making.
  • Deployed Tableau dashboards with independent server management, managed server permissions, and scheduled refreshes.

Jr. Business Intelligence Analyst - Analytics Tech

Aion-Tech Solutions Limited
07.2022 - 03.2024
  • Analyzed pharmaceutical data, generating trial-level and cohort-based insights that enabled strategic decision making to grow the customer's oncology portfolio, mitigate risks, and identify partners.
  • Applied expertise in leveraging Alteryx for precise data cleansing and management.
  • Utilized Tableau's contextual features alongside relevant value filters to achieve hierarchical data filtering
  • Developed dashboards for monthly drug trials and their corresponding programs in different segments of pharmaceutical data.
  • Publishing Dashboard on Tableau server, using alerts, subscription, and comments at server level while using Row-Level security for different Business Users.
  • Published Tableau dashboards on server, optimized and embedded them on internal website.

Associate Analyst

Aion-Tech Solutions Limited
01.2022 - 05.2022
  • Executed hands-on POCs in Tableau, Power BI, and Alteryx to refine data integration methods, resulting in a 30% increase in client satisfaction ratings.
  • Enabled businesses to effectively harness analytics for valuable insights through demonstration

Education

Bachelor of Technology - CSE Specialization in Oil And Gas Informatics

UPES
Dehradun, Uttarakhand
05-2022

Skills

  • Tableau (Desktop, Prep-Builder, Server)
  • Alteryx
  • SQL
  • Power BI
  • Advanced Excel
  • Stakeholder Management
  • Requirement Gathering
  • Problem-Solving Abilities
  • Use Case Design
  • Time-Management
  • ETL process
  • Data Visualization
  • Data Analysis
  • Cross-Functional Collaboration
  • KPI Tracking and Reporting
  • Data Governance

Certification

  • Tableau Desktop Specialist
  • Altreyx Designer Core

Languages

Hindi
First Language
English
Advanced (C1)
C1

Timeline

Business Intelligence Analyst - Analytics Tech

Aion-Tech Solutions Limited
04.2024 - Current

Jr. Business Intelligence Analyst - Analytics Tech

Aion-Tech Solutions Limited
07.2022 - 03.2024

Associate Analyst

Aion-Tech Solutions Limited
01.2022 - 05.2022
  • Tableau Desktop Specialist
  • Altreyx Designer Core

Bachelor of Technology - CSE Specialization in Oil And Gas Informatics

UPES
KIRTI KALRA