Data Analytics Intern (MCA Candidate)
Resume:
Summary
Analytical and detail-oriented MCA student with a strong foundation in SQL, Google Sheets, and data analysis. Skilled in cleaning, organizing, and visualizing data to extract meaningful insights and support data-driven decision- making. Proficient in writing SQL queries, using pivot tables, and applying advanced formulas for reporting and automation. Experienced in identifying patterns, analyzing trends, and presenting insights through clear visual dashboards.
Projects
Employee Salary and Department Analysis
Analyzed employee salary data using SQL queries to identify pay distribution and trends Used GROUP BY to calculate department-wise average salary Used subqueries to find highest and lowest paid employees Improved query performance using indexing
Sales Performance Dashboard
Cleaned raw sales data using filters, remove duplicates, and text functions Used formulas like SUM, AVERAGE, IF, VLOOKUP, COUNTIF Created pivot tables to analyze sales by product, region, and month Built interactive charts and a dashboard for management reporting Skills
SQL, MySQL (Joins, Subqueries, Aggregate Functions), Data Visualization, Python(basics), Data Analysis, Reporting, Google Sheets(Vlookup, Pivot Tables, Conditional Formatting), Oracle, Google Analytics, EDA, Data Cleaning, Statistics(Probability, Correlation, Regression), OpenAI, Problem Solving, Java, Collaboration, Statistical Analysis, Communication Skills
Education
Master of Computer Applications (MCA)
GH Raisoni College of Engineering and Management • Nagpur,Maharashtra 06/2026 Bachelors In Computer Application(BCA)
Saint Francis De Sales College • Nagpur,Maharashtra 07/2024 Higher secondary Certificate(HSC)
Kendriya Vidyalaya Of Ambajhari • Nagpur,Maharashtra 07/2021 Certificates
Google Data Analytics Professional Certificate, SQL For Data Analysis Aniket Singh
*************@*****.***
Nagpur, Maharashtra
Contact this candidate