Abilash Aila

Data Analyst

Hyderabad, Telangana 4+ yrs exp 95 · Outstanding

About

Data Analyst with 5 years of experience using SQL, Excel, and Power BI to turn raw data into clear, actionable insights. Skilled at writing optimized SQL queries, building advanced Excel reports, and designing Power BI dashboards backed by solid data models. Strong track record of validating data accuracy and partnering with business and technical stakeholders to deliver reliable, decision-ready reporting.

Skills & Expertise (28)

SQL Advanced

8.0/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

T-SQL Advanced

7.5/10

Years Exp

Complex queries Advanced

7.5/10

Years Exp

DAX Advanced

7.5/10

Years Exp

Data Validation Advanced

7.0/10

Years Exp

Data Cleaning Advanced

7.0/10

Years Exp

Data Automation Advanced

7.0/10

Years Exp

Basic Python Intermediate

5.5/10

Years Exp

Reporting CTEs Data visualization best practices Power BI Service Snowflake Schema Star Schema Data Modeling Power Query Query Optimization Performance Tuning ETL What-If Analysis Data Warehousing concepts XLOOKUP VLOOKUP LOOKUP functions Pivot Charts Pivot Tables Advanced Formulas

Work Experience

Data Analyst

TAO Digital Solutions

Nov 2025 - Apr 2026

Analyzed cross-functional Project Delivery, HR, and Travel data, delivering Power BI dashboards and Excel reports that kept stakeholders informed with accurate, up-to-date information. Wrote and optimized SQL Server queries to extract and transform data from SharePoint Online and SQL Server, using Power Query to integrate multiple sources into clean, analysis-ready datasets. Performed revenue reconciliation against financial data using Excel and SQL, supporting reporting governance and documentation standards.

Data Analyst

ICROZ Solutions Private Limited

May 2023 - Nov 2025

Independently analyzed business requirements and delivered interactive Power BI reports and Excel-based analyses across three departments, working directly with business and technical stakeholders. Wrote and optimized complex SQL queries to extract, transform, and integrate large datasets from multiple source systems, ensuring accuracy for downstream analysis and reporting. Built advanced Excel reports (pivot tables, lookup formulas) alongside DAX measures and calculated columns, turning ad-hoc business questions into fast, self-service analysis. Gathered requirements from cross-functional stakeholders, trained end-users on interpreting dashboards and reports, and maintained supporting documentation.

Data Analyst

Infor Pvt Ltd

Dec 2022 - Apr 2023

Analyzed business requirements and translated them into SQL queries, Excel reports, and Power BI visualizations/KPIs, reducing reporting turnaround time by 30%. Automated manual reporting workflows using advanced Excel formulas and SQL scripting, cutting manual effort by 25% and improving reporting reliability.

Reporting Analyst

Swift soft Infotech Pvt Ltd

May 2021 - Nov 2022

Built Excel reports and MIS dashboards using Pivot Tables, lookup functions, SUMIFS, and advanced formulas to track KPIs and business performance. Prepared daily, weekly, and monthly business reports using advanced Excel and SQL to support management and operational decision-making. Extracted, analyzed, and validated data using SQL queries, joins, filters, and aggregations to ensure accurate reporting and identify data discrepancies.