Data Analyst Power Bi

Priyanka Mupparaju

SUMMARY:

Experienced Data Analyst proficient skilled in SQL, Excel, Python, Tableau, Power Bi, data cleaning, visualization, creating interactive dashboards, ETL processes, predictive modeling, and statistical analysis methods with a passion for leveraging data to solve real-world business challenges. Skilled at solving complex problems and coordinating with the teams to deliver analytics-based solutions.

TECHNICAL SKILLS:

Programming Languages: SQL, Python

Databases: Oracle, MySQL, PostgreSQL

Data Visualization & Bi Tools: Tableau, Power Bi, Excel (VLOOKUP, Pivot Tables, Charts), Matplotlib, Seaborn for creating dashboards and visual insights.

Data manipulation & Analysis: Pandas, NumPy, Scikit-learn and Excel.

Statistical Analysis & Predictive Model: Regression, Clustering, Time Series Forecasting, Trend Identification, Descriptive Statistics.

Data Cleaning and Validation: Data cleaning such as handling with missing data and validation of large datasets, ensuring accuracy and readiness in SQL and Python.

Data Engineering & ETL: API and ETL pipelines.

Operating Systems: Windows, MacOS, Linux

SOFT SKILLS:

Problem-Solving Teamwork Communication Skills Time Management Ability to work Independently Decision Making Innovative Attention to detail Critical thinking

Experience:

Wipro Pvt Ltd (Bangalore) Data Analyst Jan 2021 to Jun 2022

• Creating the interactive Tableau dashboards to allow stakeholders and monitor the KPIs such as revenue growth and the conversion rates.

• Automated data processing workflows using Python to improve efficiency, reduce manual effort, and enhance the scalability of analytics processes.

• Utilized SQL to extract, transform, and query data from relational databases to support reporting and analysis needs.

• Provided ongoing support for data collection, transformation, and reporting initiatives, ensuring timely and accurate delivery.

• Performed statistical analysis on large datasets to derive insights and support business strategies.

• Developed ETL pipelines to streamline data processing and automate reporting workflows.

• Optimized Power BI performance through efficient data modeling, query optimization, and minimizing report load times.

• Utilized statistical methods to analyze datasets and uncover trends to support decision-making.

Inspire Infosol(Hyderabad) Data Analyst July 2019 to Dec 2020

• Developed advanced SQL queries for the data extraction, transformation, and reporting across the relational databases.

• Applied statistical methods and data modeling techniques to uncover underlying trends and support predictive analysis efforts.

• Automated data cleaning and transformation tasks using Python reducing manual effort by 40%.

• Leveraged Python libraries such as Pandas and NumPy to preprocess, clean, and transform raw data for downstream applications.

• Collaborated with data analysts to design and deliver dynamic Excel dashboards with built-in calculations.

• Developed and maintained interactive Power BI dashboards and reports to present key business metrics and performance indicators to stakeholders.

• Performed data validation checks to ensure accuracy, completeness, and consistency across multiple datasets.

PROJECTS:

• Analysis of Heart Attack Risk: worked with Python Programming

Developed a machine learning model to predict heart attack risk using patient health metrics and lifestyle factors. Conducted data preprocessing, feature engineering, and model comparison (Logistic Regression, Random Forest, KNN) to identify the most accurate model for deployment.

• Crime Rate Prediction: Analyzed crime patterns in Los Angeles using Python and machine learning models by implementing the Logistic Regression, K-Means Clustering and ARIMA forecasting to predict crime trends.

EDUCATION:

University of North Texas, Denton, Texas

Master of Science in Advance Data Analytics. December 2024

Contact this candidate