satyajit maity

Junior Analyst

Kolkata, West Bengal, India 0+ yrs exp 86 · Excellent

About

Detail-oriented and analytical fresher Data Analyst with hands-on internship and project experience in data collection, cleaning, validation, and analysis using Excel, SQL, and Power BI/Tableau. Skilled in building dashboards, tracking KPIs and operational metrics, and translating business requirements into clear, actionable insights. Comfortable collaborating with cross-functional teams and communicating findings to both technical and non-technical stakeholders. Seeking a Junior Analyst role to apply strong analytical thinking, attention to detail, and reporting skills to real-world business decision-making.

Skills & Expertise (49)

Business Intelligence Intermediate

5.5/10

0.5

Years Exp

SQL Intermediate

5.5/10

0.5

Years Exp

Advanced Excel Intermediate

5.5/10

0.5

Years Exp

Data Visualization Intermediate

5.5/10

0.5

Years Exp

Power BI Intermediate

5.5/10

0.5

Years Exp

Data Analysis Intermediate

5.5/10

0.5

Years Exp

Problem Solving Intermediate

5.0/10

0.5

Years Exp

Attention to Detail Intermediate

5.0/10

0.5

Years Exp

Analytical Thinking Intermediate

5.0/10

0.5

Years Exp

Python Intermediate

4.5/10

0.5

Years Exp

relational databases stakeholder communication Tableau Looker Studio DAX Stored Procedures Data Modeling Drill-through Reports Row-Level Security Pandas NumPy ETL Basics Google Sheets Market Research Cross-Functional Collaboration Documentation Time management VLOOKUP Business Reporting Operational Reporting KPI Tracking Trend Analysis Data Cleaning Data Validation Data Quality Dashboard Creation performance reporting Pivot Tables Window Functions XLOOKUP Power Query Conditional Formatting Charts Advanced Formulas MySql Postgresql SQL Server Joins CTEs

Work Experience

Data Analyst Intern

Onlei Technologies

May 2025 - Nov 2025

Collected, organized, cleaned, and validated business data from multiple sources to improve reporting accuracy and maintain a reliable analytical dataset. Built and maintained a unified Star Schema data model that supported business intelligence reporting and ensured high data integrity. Automated daily, weekly, and monthly reporting by developing a six-page interactive Power BI dashboard, reducing manual reporting effort by more than eight hours per week. Created KPI dashboards and business reports using Power BI, DAX, SQL, and Microsoft Excel to monitor operational performance and support decision-making. Performed data analysis using SQL (Joins, CTEs, Window Functions) to identify customer trends and generate actionable business insights through RFM segmentation. Conducted data validation and quality checks to identify inconsistencies and improve reporting accuracy. Worked closely with cross-functional teams to understand reporting requirements and translate business needs into analytical solutions. Prepared clear summaries and performance reports for stakeholders while maintaining documentation of analytical processes.