About
Highly motivated and detail-oriented Data Analyst intern with foundational knowledge in data analysis, visualization, and reporting. Proven ability to apply analytical skills, problem-solving, and hands-on experience using Excel, SQL, Power BI, and Python to support data-driven business decisions and organizational growth. Eager to leverage strong communication skills to translate complex data insights for both technical and non-technical stakeholders in an entry-level role.
Work
Business Insights Dashboard
|Data Analyst
Remote, Remote, India
→
Summary
Developed and automated an Excel-based dashboard to track key performance indicators (KPIs) and streamline reporting processes.
Highlights
Created dynamic Excel dashboards utilizing pivot tables, slicers, and charts for effective KPI tracking and visualization.
Automated reporting mechanisms within Excel, significantly improving efficiency and reducing manual effort in data presentation.
Enabled stakeholders to quickly access and interpret critical business insights through user-friendly dashboard interfaces.
Exploratory Data Analysis (EDA)
|Data Analyst (Python Specialist)
Remote, Remote, India
→
Summary
Executed comprehensive exploratory data analysis using Python (Pandas) to uncover trends, patterns, and anomalies in datasets.
Highlights
Performed robust data cleaning, handling missing values, and outlier treatment using Pandas to ensure data integrity.
Conducted in-depth exploratory analysis to identify significant trends, patterns, and anomalies within various datasets.
Summarized and communicated key insights through descriptive statistics and visual interpretation, supporting data-driven conclusions.
Customer & Order Analysis
|Data Analyst
Remote, Remote, India
→
Summary
Conducted in-depth customer transaction analysis using SQL and Excel to identify valuable customer segments and purchasing behaviors.
Highlights
Analyzed customer transaction data utilizing SQL joins, aggregations, and filtering techniques to extract meaningful patterns.
Identified and segmented repeat and high-value customers based on order frequency and total spend, informing targeted marketing strategies.
Developed comprehensive Excel reports, incorporating pivot tables and charts to effectively visualize and present key customer insights.
Sales Performance Analysis Dashboard
|Data Analyst (Project Lead)
Remote, Remote, India
→
Summary
Led the development of an interactive Power BI dashboard to analyze sales performance, providing critical insights for business decision-making.
Highlights
Collected, cleaned, and transformed raw sales data using Power Query, ensuring data accuracy and readiness for analysis.
Designed and implemented interactive Power BI dashboards, enabling comprehensive analysis of sales trends, regional performance, and product revenue.
Developed advanced DAX measures to calculate key performance indicators (KPIs) such as total sales, average order value, and growth rate.
Delivered actionable insights through data visualization, directly supporting strategic business decision-making.
Education
JIS University
→
Bachelor of Technology (B.Tech)
Computer Science
Languages
English
Certificates
Data Science & Analytics with AI
Skills
Data Analysis
Data Cleaning, Data Validation, Exploratory Data Analysis (EDA), Trend Analysis.
Business Intelligence
Power BI, DAX Basics, Data Modeling, Interactive Dashboards.
Databases
SQL, Joins, Aggregations, Subqueries, Filtering.
Spreadsheet Tools
MS Excel, Pivot Tables, XLOOKUP/VLOOKUP, Charts, Slicers.
Programming
Python, Pandas, NumPy.
Soft Skills
Analytical Thinking, Problem Solving, Communication, Attention to Detail.