Data Analyst Power Bi

Resume

Prajakta Madhukar Wadhai (Data Analyst)

Mobile No. 703-***-****

Email ID. ***************@*****.***

Objective:

Results-driven Data Analyst with 2 years of IT experience. Analytical and detail-oriented Data Analyst seeking to leverage strong skills in data collection, analysis, and visualization to help organizations make data-driven decisions. Proficient in SQL, Excel, Python, and Tableau, with a passion for turning complex data into actionable insights that support business growth Technical Skills

• Excel: Advanced functions, pivot tables, and data manipulation.

• Macros: Macros are sets of instructions or code that automate tasks in software applications.

• VBA Programming: Using macros and VBA in Excel to automate repetitive tasks.

• Power BI: Data visualization and dashboard creation, Dax, Date modeling, Developing dashboards and reports

• Data Warehousing: Knowledge of ETL processes.

• SQL: Database querying, data extraction, and management.

• Python: Data manipulation (pandas, NumPy) and visualization (Matplotlib, Seaborn)

• Operating Systems: Windows XP, 7, 8, 9, 10;

Work Experience

Data Analyst at Iconsteam Pvt Ltd, Pun

(June 2023 – Present)

• Project Name: Finance and Management System

• Domain: Investment Banking and Finance (Loan)

• Client: Bajaj Finance, India Analysis Methodology Purpose:

Analyse internal departmental requirements and complex datasets to develop automated reporting solutions that improve efficiency and decision-making. Techniques:

• Collect, clean, and organize large datasets

• Build dashboards and reports to communicate findings

• Use tools like SQL, Excel, Python, Power query editor, Power BI Key Responsibilities:

1) Data Collection & Cleaning

• Gather data from multiple sources (databases, APIs, surveys, etc.)

• Clean, transform, and validate data to ensure accuracy and consistency 2) Data Analysis & Interpretation

• Analyse large datasets to identify trends, patterns, and correlations

• Use statistical methods to interpret data and provide insights 3) Reporting & Visualization

• Create reports and dashboards using tools like Excel, Power BI

• Present insights clearly to both technical and non-technical stakeholder 4) Database Management & Querying

• Write and optimize SQL queries to extract and manipulate data • Maintain and update databases as needed

MIS Executive at SoftGrid Info Pvt Ltd, Pune (Oct 2022 – June 4, 2023)

• Project Name: Finance Loan and Management System

• Domain: Investment Banking and Finance (Capital Market)

• Client: Equitas Small Finance, India

Educational Qualification

• Bsc Computer Science – 84%, Swami Ramanand Tirth Sub-center, Latur (2019-22)

• HSC – 70%, Savitribai Fule Higher Secondary College, Anjankhed (2018-19)

• SSC – 82.60%, Kai Dipla Naik Vidhyalay, Palaiguda (2016-17) Personal Details:

• Date of Birth : 07-01-2001

• Marital Status : Unmarried

• Gender : Female

• Nationality : Indian

• Languages Known : English, Hindi, Marathi

• Permanent Address : At post Bhorad, Tq. Mahur Dist. Nanded-421721

Contact this candidate