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
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
Similar Profiles
Yashvvi JangidYashvvi Jangid
Senior Risk Analyst at AmazonSenior Risk Analyst at Amazon
Vivian MaxwellVivian Maxwell
Associate at AmazonAssociate at Amazon
Abdallah AdawiAbdallah Adawi
Language Manager at AmazonLanguage Manager at Amazon
JACKSON EDWARDSJACKSON EDWARDS
Warehouse Associate at AmazonWarehouse Associate at Amazon
Ismail MohammedIsmail Mohammed
Data Specialist at S&P GlobalData Specialist at S&P Global