Power Bi Data Analyst

Head Office: ** Clyde Rd, Suite ***, Somerset, NJ 08873

Sales Office: 2450 Atlanta Hwy, Unit 1902, Cumming, GA 30040 Phone: 732-***-**** Fax: 866-***-****

GEERVANI BELLAMPALLI

PROFESSIONAL SUMMARY

• Aspiring Data Analyst with practical knowledge in SQL, PL/SQL, Power BI, and Python, gained through hands-on learning and self-paced courses.

• Focused on the healthcare domain, with project experience in analyzing patient pending authorizations, denied procedures, authorization approval rate and turnaround times.

• Built interactive Power BI dashboards using simulated healthcare data to derive insights and visualize trends.

• Experienced in data modeling, cleaning, validation, and creating filters and slicers to allow dynamic exploration of the dataset within Power BI.

• Proficient in writing SQL queries and transforming raw datasets into meaningful reports.

• Passionate about leveraging data to identify bottlenecks, improve healthcare efficiency, and drive evidence-based decision-making.

• Committed to continuous learning and excited to contribute to data-driven decision-making in healthcare organizations.

• Strong analytical mindset with a proactive approach to solving real-world problems through data. TECHNICAL SUMMARY –

Description Technology

Operating System • Linux, Windows

Languages • SQL, PL/SQL

Data Tools • Power BI, Excel, SQL, Python

Data Visualization • Dashboards, KPI Tiles, Line/Bar Charts, Pie Charts Analytics Skills • Data cleaning, Data modeling, KPI development Head Office: 13 Clyde Rd, Suite 201, Somerset, NJ 08873 Sales Office: 2450 Atlanta Hwy, Unit 1902, Cumming, GA 30040 Phone: 732-***-**** Fax: 866-***-****

CERTIFICATION SUMMARY -

• Power BI for Data Analysts – Udemy

• Advanced Excel for Data Analytics – LinkedIn Learning

• Google Data Analytics Certificate – Coursera(ongoing)

• PowerBI (PL-300) – Microsoft(ongoing)

EXPERIENCE SUMMARY –

Company Name: HexaCorp

Designation: Data Analyst (Trainee)

Duration: March 2025 – Present

Location: Remote

Technologies Used: Python (Pandas, NumPy, Faker), Power BI, Excel Key Technologies Used as Part of the Project:

• Python: Used libraries like Pandas, NumPy, Faker to generate and prepare synthetic healthcare data.

• Power BI: For building interactive dashboards and visual reports.

• Excel: For initial data checks, basic validation, and quick summaries. Responsibilities:

• Created realistic synthetic datasets for healthcare scenarios such as patient visits, authorizations, procedures, and denial tracking.

• Used Python to simulate complex data relationships between providers, departments, and procedures.

• Designed and built Power BI dashboards with visual breakdowns by provider, procedure type, and status.

• Developed KPIs to monitor pending authorizations, turnaround time, and denial frequencies.

• Ensured data consistency and usability through validation, formatting, and cross-checking.

• Developed a “Pending Authorizations” dashboard with filters by provider, patient demographics, and department.

• Applied conditional formatting and DAX calculations to highlight high-risk or delayed authorizations within the dashboards.

• Created custom visualizations including stacked bars, trend lines, and KPI cards to display key metrics. Head Office: 13 Clyde Rd, Suite 201, Somerset, NJ 08873 Sales Office: 2450 Atlanta Hwy, Unit 1902, Cumming, GA 30040 Phone: 732-***-**** Fax: 866-***-****

• Built a “Top Denied Procedures” analysis view with filters for denial reasons, submission dates, and departments.

• Simulated date logic (submission date vs. approval/rejection date) to analyze turnaround time effectively.

• Organized data tables to mimic a real-world schema including Authorizations, Visits, Procedures, Patients, and Providers. EDUCATION SUMMARY –

• Bachelor of Technology – Electronics And Communication Engineering

Contact this candidate