Ranjith

Data Analyst

Hyderabad, India 2+ yrs exp 84 · Excellent

About

Results-driven Data Analyst with 2+ years of experience transforming complex data into actionable business insights. Specializes in Power BI dashboard development, SQL optimization, and ETL automation. Delivered 15+ enterprise dashboards tracking 50+ KPIs across 3+ business units, saving 80+ hours annually through intelligent automation. Microsoft-certified (PL-300, AI-102, AZ-900).

Skills & Expertise (24)

Power BI Advanced

8.0/10

Years Exp

DAX Advanced

7.5/10

Years Exp

Dashboard Design Advanced

7.5/10

Years Exp

Excel Intermediate

7.0/10

Years Exp

Power Query Intermediate

7.0/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

T-SQL Intermediate

6.5/10

Years Exp

ETL Pipeline Design Intermediate

6.5/10

Years Exp

Python Intermediate

6.0/10

Years Exp

Advanced DAX Microsoft Azure validation Workflow Automation M Language Postgresql MySql Query Optimization Indexing Stored Procedures Dashboarding Pivot Tables Report server RLS

Work Experience

Associate Engineer – Data Analyst

Genzeon India Pvt. Ltd.

Nov 2024 - Jun 2026

Built 5+ interactive Power BI dashboards tracking 40+ KPIs daily for 3+ business units, enabling real-time monitoring and reducing time-to-insight by ~30%. Analyzed 10,000+ employee records to identify leave and attendance trends; improved resource planning accuracy by 23%. Optimized SQL via strategic indexing and query refactoring; cut execution time by 32% and dashboard refresh time from 8 to 5 minutes. Engineered advanced DAX measures for complex KPI calculations, reducing manual analysis effort by 35%. Automated Power Query ingestion pipelines for daily refresh cycles, eliminating 40% of manual effort and reducing data errors by 25%. Implemented row-level security (RLS) and role-based access controls across 5+ departments, ensuring data governance and compliance. Delivered automated reporting solutions eliminating 5+ hours of weekly manual work for Operations and HR teams (~260+ hours/year).

SQL Developer Intern

ESEM ECO FRI Pvt. Ltd.

Dec 2022 - May 2023

Designed and maintained a SQL database tracking 500+ incidents with 100% compliance for regulatory reporting. Performed end-to-end data cleaning and normalization, reducing data errors from 40% to under 5% and improving audit reliability. Optimized database schema with targeted indexing strategies, achieving a 28% reduction in average query response time.