Data Analyst Power Bi

Hema Gunapati

Philadelphia, PA

*****@******.*** 445-***-**** Hema Gunapati LinkedIn

EXPERIENCE

Sans America, Remote July 2024 – September 2024

Data Analyst Intern

Extracted and profiled datasets using SQL, resolving data discrepancies, and improving data accuracy by 15%, which

enhanced the reliability of insights used in key business decisions.

Designed interactive Power BI dashboards, enhancing real-time insights, and reducing report generation time by 30%.

Collaborated with over 4 business teams to translate requirements into analytical solutions, optimizing data workflows.

Information Services Group, India June 2021 – August 2023

Data Analyst (April 2022 – August 2023)

Associate Data Analyst (June 2021 – April 2022)

Automated provider comparison reports with Python, cutting manual report preparation by 20 hours per cycle.

Developed Power BI dashboards with DAX measures, enabling 50+ stakeholders to spot market trends and improve

decision-making speed.

Built a 4-year integrated dataset from unstructured data, enabling market performance analysis and revenue insights.

Northern Trust, India

Analyst, Melbourne Trade Operations Team July 2020 – March 2021

Validated data inputs and outputs for trade processing systems, resolving data integrity issues that caused failing trade

executions for 5 APAC clients.

Shirdi Sai Electrical Limited, India

Business Analyst July 2018 – May 2020

Conducted market analysis that led to a 15% increase in sales by identifying high-demand product segments.

Collaborated with stakeholders across teams to align business goals and created reports, 5+ Power BI dashboards, and

presentations, improving stakeholder visibility and transparency.

Bosch, India

Data Analyst Intern August 2019 – October 2019

Developed and deployed a predictive model (ARDL) to forecast auto sales trends based on historical data, achieving 93%

accuracy in predicting key influencing factors.

Leveraged Python and EViews, contributed to the building of an autoregression model that forecasted future auto sales

with 90% accuracy.

EDUCATION

Drexel University, LeBow College of Business, Philadelphia, PA

Master of Science in Business Analytics (GPA: 3.9) March 2025

Christ University, India

Master of Arts in Applied Economics

Bachelor of Arts in Media Studies, Economics and Political Science

Awarded “University Rank Holder” for achieving #1 place in a class of 60

ACADEMIC PROJECTS

Capstone Project for Precisely Inc, Drexel University (September 2024 – December 2024)

Extracted and processed large datasets with 30000+ rows using Python, APIs, and advanced data manipulation

techniques.

Applied K-means clustering technique to group 15000+ residential customers based on features and demographics,

identifying high-potential future customers for targeted marketing initiatives.

Designed strategies for improving customer acquisition rate based on demographic data, resulting in at least a 10%

increase in customer acquisition.

Jobs and Salaries in Data Science, Drexel University (January 2024 – March 2024)

Analyzed salary trends for data science professionals to assess market demand and compensation benchmarks for 4

years.

Visualized data science salary distributions using Tableau across job roles in data science and identified 5+ factors that

contributed to higher salaries.

Showcased salary insights as compensation benchmarks in 20+ roles, helping professionals make informed career

decisions.

SKILLS

Programming: Python, Java, EViews

Python Libraries: NumPy, Pandas, Scikit-learn, Matplotlib, Seaborn

Data Science Techniques: Regression, Data Mining and Wrangling

Databases: MYSQL

Data Visualization: Power BI, Tableau, Alteryx, and MS Excel

EXTRACURRICULAR

Revitalized a stalled strategic initiative within six months, earning the 'Dazzling Debut' award. (March 2022).

Spearheaded community awareness campaigns for Zenith Climate (an NGO) across 3 villages (March 2021 – January

2022).

Led a Student Council initiative, mining feedback data to identify three main causes of student dissatisfaction,

implementing changes at Christ University, India (August 2019 – March 2021).

Contact this candidate