Associate Data Analyst with 2+ years in Power BI, SQL & Excel
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Experienced in building dashboards, data models, and analytical reports using Power BI (DAX, Power Query), SQL Server (CTES, JOIN, Stored Procedures, Aggregate, subqueries, window functions), and MS Excel (Pivot Tables, Power Pivot). Hands-on experience through a data analyst internship at ZenYData Technologies and three self-driven projects covering OTT analytics, sales reporting, and hardware data analysis. Seeking a full-time data analyst role to deliver actionable insights for business decisions.
Bengal Institute of Business Studies
MBA IN DIGITAL MARKETING · Digital Marketing
August 1, 2020 – June 30, 2022
Rastraguru Surendranath College
B.SC IN COMPUTER SCIENCE (HONOURS) · Computer Science
August 1, 2016 – June 30, 2020
ZenYData Technologies Pvt. Ltd.
Data Analyst Intern
September 22, 2025 – March 31, 2026
India
Cube Consultancy services
Cube Consultancy services (non-technical experience)
May 1, 2023 – September 30, 2025
India
Data Analysis of AtliQ Hardwares using SQL
May 1, 2025 – May 31, 2025
Here I have analyzed the dataset of AtliQ hardwares where sales dataset contains 9.7 lakh rows. Created a new fact table fact_costs by joining gross price and manufacturing cost data, ensuring data integrity by assigning a composite primary key (product_code, fiscal_year). Engineered new date-based field (quarter) in the fact_sales table to enable quarter-wise sales trend analysis as Atliq's FY starts in Sept and ends in Aug. Leveraged Common Table Expressions (CTEs) and window functions to identify the top 3 best-selling products in each division for the fiscal year 2021. Performed in-place schema evolution and updates to support deeper sales insights without disrupting the existing data structure. Applied grouping, aggregation, and partition-based ranking efficiently across a high-volume dataset
View ProjectSales and Financial analysis of AtliQ Hardware using Excel
March 1, 2025 – April 30, 2025
Built Sales performance report on Fiscal Year and Monthly Basis using Excel. Data cleaning using Power Query, Created Date table using M Language in Power Query Have connected the tables dim_customer, fact_sales, dim_market, dim_date, dim_product in Power Pivot Skills used: VLOOKUP, REPLACE, SUMIF and many other functions for data cleaning in excel. Power Query for data cleaning, making dim_date table and other steps of ETL process Power Pivot for making a relational model by connecting the dimension tables with the fact_sales table, making the metrics like net sales, gross margin, COGS, GM% Have used Pivot Table, Conditional Formatting for making the report in MS Excel
View ProjectData Analysis of OTT platforms using Power BI
February 1, 2025 – April 30, 2025
Analyzed the data of 2 lakh+ subscribers of Liocinema and Jotstar from the datasets of Jan, 2024 to Dec, 2024. Cleaned the data using Power Query, Data Transformation: 1. Appended the two datasets of subscribers of OTT platforms Liocinema and Jotstar, merged the appended table with the individual subscriber tables to fetch the subscription cost details using Power Query. 2. Have created a table for Revenue Analysis from the existing appended tables using DAX functions and connected the tables using effective Data Modeling technique. Have made the KPI like Revenue, Avg Revenue per user, CLV, Avg watch hours, Churn rate, total inactive users etc. using DAX code. Have connected the revenue, subscribers, content consumption tables to make an effective relational model.
View ProjectExcel: Mother of Business Intelligence
Unknown
January 1, 2023 – Present
Power BI: Get Job Ready: Power BI Data Analytics for All Levels 3.0
Unknown
January 1, 2023 – Present
Cultural Fit Analysis
The candidate's project diversity, covering OTT platforms, sales, and financial analysis, indicates a broad interest in applying data analysis across different domains. The combination of an MBA in Digital Marketing and a B.Sc in Computer Science, along with practical data analysis skills, suggests a well-rounded profile that could adapt to various business contexts. The target role of 'Associate Data Analyst' aligns well with the candidate's demonstrated skills and internship experience, indicating a good fit for an entry-to-mid level data analysis position.
Soft Skills & Operational Fit
The candidate demonstrates a proactive approach to learning, evidenced by self-directed upskilling in Advanced Excel and personal analytics projects. Their experience in building reports and dashboards suggests an ability to translate data into actionable insights, which is crucial for an Associate Data Analyst role. The non-technical experience at Cube Consultancy services, while not directly technical, shows an ability to manage operational responsibilities and apply analytical thinking to business problems.