Gayathri Thiyagarajan

Data Analyst

Based in Schaumburg

About

I am a Data Analyst , Data Visualization specialist who loves to work with data and bring out the actionable insights from them to make the meaningful impact in the business success

Skills

Projects

Sales Insights – AtliQ Hardware business

Showing the Revenue Analysis and KPIs for Atlique Hardware in a Tableau Dashboard

Covid-19 Global Vaccine Tracker

This Dashboard clearly shows how many people are Partially, Fully and Not vaccinated around the globe

HR Analysis - Employee Attrition

In this HR Analysis project , i have analyzed what could be the reasons for employee attrition by exploratory data analysis ,statistical data analysis, and through data visualization.

Coffee Sales Dashboard -Excel

Created the coffee sales dashboard which features the KPIs Total sales over time for the roast type ,Top 5 customers, Total sales by country, Best of all we can filter all these sales visualizations by Month, Year, Roast Type, Size of Coffee Package, Loyalty type.

London Bike Rides

In this project, I have designed and implemented a interactive dashboard utilizing a Kaggle dataset to present insightful information about total bike rides in London. The dashboard provides a visual representation of the correlation between bike rides and various factors such as wind & temperature.

Experience

2010-2013

Java/J2EE developer/Programmer Analyst

Developed and Maintained the web service application for the insurance party information services in java spring framework and struts framework .Developed the Spring Hibernate Module individually which has increased the code performance by 25%.Involved in code migrations and enhancements.

2023 - till date

Data Analyst

• Responsible for developing Business users reports to provide on demand data analysis using excel Pivot tables, VLOOKUP, Index, Match, XLOOKUP, Formulas, Measures, Charts and Excel Power query for data transformation. • Expertise in manipulating data for exploratory data analysis in SQL and EXCEL • Experience in developing SQL queries for data manipulation and analysis in SQL Server using Joins, Where, Group By, Order BY, Having and SQL functions. • Designed and developed interactive Excel dashboards for Revenue analysis, providing real-time insights into Revenue related metrics and KPIs which makes them take informed decisions. • Experience in creating different visualizations using bars, lines, scatter plots, pie chart, Slicers, Timelines

Education

2023

Google Data Analytics Certificate

Gained an immersive understanding of the practices and processes used by a junior or associate data analyst in their day-to-day job Learned key analytical skills (data cleaning, analysis, & visualization) and tools (spreadsheets, SQL, R programming, Tableau) Understood how to clean and organize data for analysis, and complete analysis and calculations using spreadsheets, SQL and R programming Learned how to visualize and present data findings in dashboards, presentations and commonly used visualization platforms

Bachelors of Engineering,ECE,Anna University