PAVAN BORALA
Hyderabad
Summary
Power BI Developer & Data Analyst with 3+ years of experience in SQL, DAX, and data modeling. Skilled in building interactive dashboards, optimizing data models, and automating reporting processes. Experienced in Power BI Service, data transformation, and ETL workflows, delivering actionable insights to improve business performance.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst
TATA CONSULTANCY SERVICE
Hyderabad
03.2022 - 07.2025
- Integrated data from MySQL, JIRA, ServiceNow, and Excel across teams, reducing manual effort by 30% and standardizing SLA reporting
- Created DAX measures to analyse Service-Level Agreement (SLA) metrics and incident response patterns, improving operational monitoring accuracy by 60%
- Delivered interactive reports via Power BI Service for stakeholders, implementing Row-Level Security (RLS) and scheduled refreshes to ensure 100% secure access
- Partnered with cross-functional teams to interpret insights, enabling faster decision-making and reducing data review time
- Achieved measurable impact by increasing service efficiency by 28% and lowering resolution time by 35% using real system logs
- Automated recurring reports using Power Query and Power BI Service scheduling, reducing manual effort for the operations team by 25%
- Client: London Stock Exchange Group (LSEG)
Education
Bachelor of Technology - Electrical engineering
GURU NANAK INSTITUTIONS TECHNICAL CAMPUS
Hyderabad01-2021
Skills
- Power BI
- Power BI Service
- Power BI Desktop
- DAX
- Power Query (M)
- SQL
- Advanced SQL
- Data Modeling
- Star Schema
- ETL
- Data Warehousing
- Dashboard Development
- Data Visualization
- KPI Reporting
- Query Optimization
- Data Transformation
- Data Cleaning
- Microsoft Excel (Advanced)
- Snowflake
- Azure Data Factory (ADF)
- SSRS
- SSAS
- MS Fabric
- Python (Basics)
- Data Governance
- Data Quality
Projects
- Business Performance 360 - Brick & Mortar and e-commerce, Built multi-department Power BI dashboard (Sales, Finance, Supply Chain) analysing 1M+ records to improve decision-making., Optimized DAX and data model performance, reducing storage load and improving refresh speed.
- Village Savings Committee - Financial Analytics, Transformed financial reporting by converting 66 months of handwritten records into a structured system with KPIs and visuals, accelerating review time by 90%, Improved financial transparency and reporting speed by 90%, enabling year-over-year insights on fines and interest.
Certification
- AI Data Analytics Bootcamp (Power BI, SQL, Excel), From Code Basics
Timeline
Data Analyst
TATA CONSULTANCY SERVICE
03.2022 - 07.2025
Bachelor of Technology - Electrical engineering
GURU NANAK INSTITUTIONS TECHNICAL CAMPUS