Summary
Overview
Work History
Education
Skills
Project Details
Certification
Timeline
Generic

M. ANANTHI

Chennai

Summary

Aspiring Data Analyst proficient in Power BI,SQL and Excel, with a strong background in data cleaning, analysis, and visualization. Proven ability to derive actionable insights from complex datasets through academic projects and self-directed learning. Dedicated to contributing effectively to organizational goals and fostering a positive work environment.

Overview

1
1
Certification

Work History

Data Analyst Intern

Besant Technology
Chennai
04.2024 - Current
  • Internship as a Data Analyst at Besant Technology
  • Worked with SQL, Excel, PowerBi.
  • Collected and cleaned data from multiple sources, ensuring accuracy and readiness for analysis.
  • Employed advanced Excel functions (VLOOKUP, Pivot Tables) for in-depth data analysis and report creation, increasing workflow efficiency.
  • Created data visualizations using Excel and Power BI to present actionable insights.
  • Maintained and optimized databases by refining SQL queries for efficient data management.

Education

Masters of Science - Mathematics

Manonmaniam Sundaranar University
Tirunelveli, TN
06-2023

Bachelors of Science - Mathematics

Manonmaniam Sundaranar University
Tirunelveli, TN
05.2016

Skills

  • Excel : Pivot Tables, Power Query, Formulas(sum,if,avg,count,index,match) Conditional Formatting, Charts,Visualization, Generating Reports
  • Power BI : ETL (Extract, Transform, Load), Data Modelling, DAX Functions, Data Analysis, Data Visualization, Dashboard Designing
  • SQL : Queries, Subqueries, Joins, CTEs, Window Functions, Views, Stored Procedures

Project Details

Project Title: B2B E-Commerce

Objective: Create a data-driven analytics platform for B2B transactions to enhance decision

making and operational efficiency.

Tool : Power BI

Key Achievements:

Created interactive dashboards to visualize key performance indicators.

Analyzed sales data to identify trends and forecast future performance.

Monitored customer behavior to inform marketing strategies.

Managed inventory data to streamline supply chain operations.

Evaluated financial performance to support strategic planning.

Project Title : Sales and Finance Report for Retail Company

Tools : Microsoft Excel, Power Query, Power Pivot, DAX

Sales Analytics:In this project,Microsoft Excel was employed to develop Profit & Loss and Sales

Performance reports aimed at refining the company’s sales approaches,boosting customer

satisfaction and ultimately,increasing revenue.

Utilized Excel's ETL capabilities, incorporating Power Query to automate data cleaning, saving approximately 4 hours of repetitive manual work.

Implemented DAX measures, achieving a 90% improvement in reporting accuracy and efficiency.

Project title: SQL

OBJECTIVE:

  • Analyzed pizza sales data to find useful insights and help improve business decisions.
  • Used SQL to gather and organize data from different sources.
  • Looked at important metrics like total sales, average order value, customer groups, and busy sales times.
  • Created reports and charts to present findings clearly to the team.
  • Improved SQL queries for faster data processing.
  • Worked with different teams to understand their needs and provide data solutions.

Certification

  • Completed Excel course at BESANT TECHNOLOGY,CHENNAI.
  • Completed Power BI course at BESANT TECHNOLOGY,CHENNAI.
  • Completed SQL course at BESANT TECHNOLOGY,CHENNAI.
  • Complete HACKERRANK Basic SQL certificate.

Timeline

Data Analyst Intern

Besant Technology
04.2024 - Current

Masters of Science - Mathematics

Manonmaniam Sundaranar University

Bachelors of Science - Mathematics

Manonmaniam Sundaranar University

Similar Profiles

CREATE PROFILE
M. ANANTHI