Pilli Venkata Dharani

Pilli Venkata Dharani

Data Analyst
India
Telugu, English
Internship On-site

About Me

NASSCOM Gold Certified Data Analyst with 1 year of internship experience in data cleaning, KPI dashboard development, and business reporting using Python, SQL, Power BI, Tableau and Excel. Skilled at transforming complex…

Experience

Data Analyst Intern

ExcelR Solutions · Bengaluru , Karnataka , India
Aug 2025 - Jan 2026 · 5 months

<p>Cleaned and standardised 15,000+ records using Python and SQL - identified critical data quality issues that improved weekly reporting accuracy and reduced preparation time by 40%.</p><p> Built 3 interactive dashboards in Power BI, Tableau, and Excel tracking 8+ KPIs - delivered weekly automated reports to support data-driven decisions across cross-functional stakeholder teams.</p><p> Performed EDA on structured datasets to uncover business trends and communicated findings through clear visual reports to management.</p>

Python & MySQL Intern

ThopsTech · Bengaluru , Karnataka , India
Sep 2024 - Dec 2024 · 2 months

<p>Wrote 10+ SQL queries using joins, filters, and aggregations to extract and validate data from MySQL databases - ensured data accuracy for structured business reporting.</p><p> Applied Python (Pandas, NumPy) to clean, transform, and automate data preparation tasks - reduced manual effort and improved data pipeline consistency.</p>

PROJECTS

CRM Analytics

ExcelR Solutions · https://github.com/pillidharani27-alt/CRM-Analytics
Duration : 07-Oct-2025 - 11-Nov-2025

<p>Queried and analysed 5,000+ CRM records using SQL - identified 2 critical sales funnel drop-off points and uncovered a 15% gap in sales efficiency to support leadership pipeline decisions. • Designed 2 dashboards in Power BI and Tableau tracking 5 KPIs (lead conversion, win rate, churn, retention, revenue) - enabled management to visualise performance trends and take corrective business actions </p>

Certifications

Data Analyst

Excelr solutions · Bengaluru , Karnataka , India · 2025

Skills

Python Pandas NumPy SQL MySQL Power BI DAX Power Query Tableau Excel Charts KPI Dashboard Development Stakeholder Reporting Automated SQL Reports Data Cleaning EDA ETL KPI Tracking Process Automation ML Modelling Microsoft Excel Pivot Tables VLOOKUP XLOOKUP Conditional Formatting Git VS Code PyCharm MySQL Workbench
Report this Profile?