PREM KUMAR AVULA
BUSINESS INTELLIGENCE ANALYST
Hyderabad
Summary
Results-oriented Business Intelligence Analyst with 3+ years of experience in Power BI, SQL, Excel VBA, and end-to-end dashboard development. Adept at transforming complex datasets into intuitive, executive-ready visualizations. Strong understanding of data modeling, ETL processes, and stakeholder management. Passionate about turning data into business insight and storytelling. Proven record of improving processes through automation and advanced analytics.
Overview
4
4
years of professional experience
3
3
years of post-secondary education
2
2
Certifications
Work History
Business Analyst
Amazon
01.2022 - Current
- Built and maintained Power BI dashboards for operations and marketing teams, implementing Row-Level Security(RLS) and custom DAX measures.
- Automated reporting using Excel VBA and macros, cutting down manual workload by 50%.
- Partnered with cross-functional stakeholders to gather and refine analytics requirements for dashboards and ad-hoc reports.
- Optimized SQL queries for campaign and customer data analysis to support strategic decision-making.
- Designed and maintained custom Excel tools that enhanced reporting accuracy and efficiency.
- Applied incremental extraction logic to ETL pipelines to improve performance and reduce resource consumption.
Education
Bachelor's - Computer Science
Adi Kavi Nannaya University
01.2018 - 01.2021
Skills
Power BI
SQL
Tableau
Looker
Excel
Data Modeling
ETL Techniques
Power Query
SharePoint Integration
Business Requirements Gathering
Data Cleaning & Transformation
SQL Server
Certification
SQL Certification, HackerRank, https://www.hackerrank.com/certificates/70631872ce15
Technical Tools
- Power BI
- SQL Server
- Oracle DB
- Tableau (basic)
- Looker (basic)
- Excel VBA
- Power Query
- Alteryx (exposure)
- AWS (EC2, S3)
- Salesforce Data Loader
- Salesforce Data Wizard
Timeline
Business Analyst
Amazon
01.2022 - Current
Bachelor's - Computer Science
Adi Kavi Nannaya University
01.2018 - 01.2021