Headline

Data Analyst | 4.5 Years of Experience | Advanced Excel | MySQL | Power BI | Data Modelling | Dashboard | KPI Tracking | KPI Analysis | KPI Reporting | Data Insights | DAX

About

Results-driven Data Analyst with 4.5 years of experience turning complex, multi-source datasets into clear, actionable business strategies. Specialized in end-to-end data solutions—from writing advanced MySQL queries and optimizing data models to crafting dynamic Power BI dashboards that deliver real-time operational clarity. Equipped with strong expertise in Advanced Excel, DAX, VBA automation, and advanced data visualization, I focus on automating repetitive reporting workflows and bridging the gap between raw figures and executive decision-making. Core Technical & Analytical Capabilities: Data Visualization & Business Intelligence: Power BI, Interactive Dashboards, KPI Tracking & Reporting, Advanced Data Visualization Data Management & Advanced Querying: MySQL, Relational Data Modelling, Complex Joins, Advanced Query Optimization Spreadsheet Engineering & Automation: Advanced Excel, Pivot Tables, Dynamic Financial/Operational Models, VBA Scripting Analytical Problem Solving: KPI Analysis, Root-Cause Analysis, Trend Forecasting, Actionable Data Insights Whether streamlining KPI frameworks or diagnosing performance bottlenecks, I thrive on delivering precision analytics that drive growth and operational efficiency.

Location

Bengaluru

AI stack

claude

gemini

Work experience

Executive at CogentHub, Apr 2022 - Apr 2025 · 3 yrs 1 mo, Kolkata, Data Modeling & Advanced Querying: Wrote optimized MySQL queries using CTEs, complex joins, and window functions to extract, clean, and integrate high-volume relational data into unified data models. BI & Dashboard Development: Designed and deployed interactive Power BI dashboards using DAX to track core KPIs, delivering actionable insights directly to executive leadership. Process Automation: Automated recurring daily and weekly reporting workflows using VBA macros and Power Query, reducing manual processing time significantly. Advanced Analytics & Optimization: Conducted deep-dive KPI analysis and trend modeling to identify operational bottlenecks and uncover revenue growth opportunities across core processes.

Executive at ThatRank Technologies, Aug 2021 - Apr 2022 · 9 mos, Kolkata, KPI Dashboarding & Visualization: Built dynamic performance tracking dashboards in Advanced Excel utilizing dynamic charts, conditional formatting, and custom KPIs for cross-functional teams. Data Cleansing & Validation: Performed structured data validation, deduplication, and data transformation on multi-source datasets to ensure reporting accuracy. Advanced Querying & Joins: Authored MySQL queries to join disparate tables, aggregate campaign performance metrics, and prepare clean data layers for downstream visualization. Strategic Reporting: Synthesized complex quantitative analytics into weekly executive summaries to optimize resource allocation and project execution.

Executive at ZTS | Zebra Techies Solution| AI DigitalEngineering & Marketing | 15+ Yrs Code to Conversion Legacy, Jan 2021 - Aug 2021 · 8 mos, Kolkata, Spreadsheet Engineering: Created structured reporting templates using Advanced Excel functions (XLOOKUP, INDEX/MATCH, nested IFs) and Pivot Tables for rapid data summaries. Market & Operational Research: Extracted and analyzed performance metrics to benchmark business trends and evaluate competitor intelligence. Data Validation & Hygiene: Established automated data checks and formatting rules to streamline initial data entry and eliminate manual verification errors. Stakeholder Reporting: Developed consolidated weekly operational reports to deliver clear, data-backed updates to project leads.

Education

Bachelor of Technology, Electrical and Electronics Engineering, RCC Institute of Information Technology

High School Diploma, Electrical Engineering, Murshidabad institute of technology