Dharani Devi Ayyavu | Data Analyst

Power BI, DAX, Power Query, KPI Tracking, Excel, Data Visualizations, Dashboard Development

SQL, ETL, Data Modeling, Cleaning

Python (Pandas, NLP), JS, HTML, CSS

Yellow.ai, Graph API

ZDX, Nexthink, ServiceNow, Azure, Git, Jira, API Integration, Postman, VS Code

Data Analyst | Jan 2022 – Feb 2025 | India & UAE

Developed 50+ Power BI dashboards to monitor KPIs, automate reporting, and deliver real-time business insights to leadership.
Cleaned and modeled large datasets from ServiceNow, Nexthink, and ZDX using SQL, Python, and Power Query.
Created data pipelines and ETL flows that reduced data latency by 40% and improved performance metrics tracking.
Built sentiment analysis models using NLP on IT support feedback to improve end-user satisfaction metrics by 25%.
Collaborated across teams (DevOps, Operations, Business) to resolve data silos and reduce incident resolution time by 30%.
Developed Yellow.ai chatbots integrated with Microsoft Teams, decreasing L1 ticket volume by 35%.
Acted as SME for data tools including Power BI, SQL Server, Nexthink, and ZDX; mentored junior analysts on dashboard design and storytelling.

Created real-time dashboards to monitor app and network latency from Zscaler ZDX APIs.
Reduced IT incident volume by 25% through visual alerting and proactive metrics.
Improved data freshness and response speed by 50% by optimizing SQL transformations.

Developed a unified dashboard by integrating data from Nexthink, ServiceNow, and CareAR.
Enabled real-time monitoring of end-user device health, service desk activity, and incident trends.
Automated performance alerts and root cause detection using and Power BI.
Empowered IT teams with proactive support capabilities, enhancing the digital employee experience.

Integrated ServiceNow feedback, Nexthink sentiment scores, and CareAR data.
Created DEX score visualizations boosting employee satisfaction tracking by 25%.
Applied text analytics and automated scoring via Python scripts and SQL joins.

Built and deployed Yellow.ai bots for IT support workflows within Teams and Webchat.
Reduced human intervention by automating 24x7 L1 issue resolution processes.
Integrated bot analytics with Power BI for usage trends, ticket deflection, and response times.

B.E. Electronics & Communication
Government College of Engineering, Theni
2016 – 2020 | GPA: 6.9