Back to Developers
Shauvik Sarmah

Shauvik Sarmah

Data Analyst

Bengaluru, Karnataka, India 5+ yrs exp 90 · Outstanding

About

Data and MIS professional with 5+ years of experience across business intelligence, reporting automation, and marketing analytics. Owns end-to-end MIS and performance reporting — building Power BI dashboards, writing SQL queries, and automating Excel and CRM reporting for sales and marketing teams. Delivered 30% faster reporting turnaround and cut manual reporting effort by 40% through standardized templates and automated workflows. Has worked across datasets of 1.5M+ records, with strengths in SQL, Power BI, DAX, Power Query, Advanced Excel, data cleaning and validation, and funnel analysis.

Skills & Expertise (33)

Reporting Automation Advanced
8.0/10
5
Years Exp
Power Query Advanced
8.0/10
5
Years Exp
Power BI Advanced
8.0/10
5
Years Exp
Advanced Excel Advanced
8.0/10
6
Years Exp
DAX Advanced
7.5/10
5
Years Exp
SQL Advanced
7.5/10
5
Years Exp
Data Visualization Advanced
7.5/10
5
Years Exp
Data Cleaning Advanced
7.0/10
5
Years Exp
Marketing Analytics Advanced
7.0/10
5
Years Exp
ETL Concepts Intermediate
6.5/10
4
Years Exp
Sales Analytics Intermediate
6.5/10
4
Years Exp
CRM Data Management Intermediate
6.0/10
4
Years Exp
Monday.com Asana Mailchimp Zapier HubSpot CRM Trend Analysis ROI Analysis Funnel Analysis Google Workspace Google Sheets Power Pivot Index-match VLOOKUP XLOOKUP PivotTables Data Segmentation Data Validation Data Transformation KPI Reporting Dashboard Development Data Modeling

Work Experience

Manager – MIS and Program

NICMAR (National Institute of Construction Management and Research)

May 2025 - Jul 2026

Automated recurring Power BI and Excel reporting workflows using Power Query and standardized templates, delivering 30% faster reporting turnaround for weekly and monthly business reviews. Built interactive Power BI dashboards tracking lead volume, conversion rates, cost per lead (CPL), campaign ROI, counselor productivity, and enrollment trends, enabling leadership to monitor the full lead-to-enrollment funnel from centralized performance reporting. Owned end-to-end MIS and performance reporting across a 1.5M+ student record base, covering the complete lead-to-enrollment lifecycle and supplying leadership and counselling teams with the data behind day-to-day and strategic decisions. Identified funnel leakages, top acquisition channels, and campaign trends through SQL and Excel analysis, guiding marketing budget allocation across channels. Improved data accuracy by implementing CRM validation checks, standardized reporting templates, and structured data-cleaning controls, reducing downstream reporting errors and manual corrections. Translated complex datasets into insight-focused executive- and board-level reports used in strategic planning discussions. Led end-to-end execution of the NICMAR Common Admission Test (NCAT), covering candidate shortlisting, exam coordination with Mercer Mettl, and post-exam performance analysis.

Influencer Marketing Manager

Flutch Technology Pvt. Ltd.

Mar 2023 - Apr 2025

Designed and automated Excel dashboards and reporting workflows for campaign performance tracking, reducing manual reporting effort by 40% and improving turnaround speed for marketing stakeholders. Managed and segmented an influencer database of 50,000+ creators by engagement rate, niche, and audience relevance, improving targeting accuracy and creator-brand match. Tracked and analyzed campaign KPIs including engagement rate, reach, and content performance across client campaigns, transforming raw platform data into stakeholder reports that informed marketing decisions. Analyzed top-performing creator segments to guide creator selection and campaign planning, and executed campaigns end-to-end from scouting to performance review.

Content Writer

Tridia Solutions

Jun 2020 - Oct 2022

Produced content aligned to campaign and SEO objectives and maintained structured content-performance reporting for stakeholders.

Education

Post Graduate Diploma in Management (PGDM), Data Science & Business Analytics - Great Lakes Institute of Management

2023 - 2025 · Afghanistan

Bachelor of Engineering, Electronics & Communication - Panjab University

- 2019 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation