JAYASURYA B

Analytical and detail-oriented Data Analyst with hands-on experience in Data Wrangling, KPI analysis, and optimising ETL processes. Skilled in transforming complex datasets into actionable insights using SQL, Python (Pandas, NumPy), and Power BI. Experienced in designing interactive dashboards to support data-driven decisions and drive business growth. Dependable and analytical with keen eye for detail and passion for numbers. Understands foundational accounting principles and proficient in financial reporting and data analysis. Capable of making significant impact through accurate financial tracking and reporting.

MONTHLY QC VARIANCE DASHBOARD - POWER BI 

• Extracted and cleaned data from multiple sources, handling missing values, duplicates, and ensuring accuracy.
• Built a data model in Power BI by defining relationships between data tables and utilizing DAX to create calculated columns and measures for custom metrics.
• Developed interactive visualizations (bar charts, pie charts, cards) to represent quality control variances, improving the ease of understanding for non-technical stakeholders. Exported data to Excel for additional analysis and tracking of target achievements.

AMAZON LAPTOP SALES DASHBOARD - ADVANCED EXCEL 

• Performed an in-depth analysis of Amazon laptop pricing trends using Advanced Excel, focusing on key factors such as RAM size, price, and ratings to identify purchase patterns.
• Calculated total sales in dollars, assessed stock availability, and utilized Excel slicers for brand-specific insights.
• Designed dynamic charts and graphs for the top 3 laptop brands, providing actionable insights to support informed decision-making.

EMPLOYEE DATABASE SYSTEM - MYSQL

• A comprehensive presentation to master database querying, manipulation and management using MySQL

Data Scientist - Besant Technologies