✦ Open to Opportunities · New Delhi, India

Satyam Chauhan Data Analyst

MIS & Data Automation Specialist crafting real-time dashboards, KPI systems & automation pipelines that turn data chaos into clear decisions.

View My Projects Get in Touch ↓ Download Resume
Apps Script ⚡
KPI DASHBOARD
Automation Impact · 2024
Efficiency by Tool
Adv. Excel
92%
Power BI
85%
G.Sheets
78%
MySQL
70%
Python
65%
Power BI 📊
01 / About Me

Turning raw data
into decisions
that matter.

Hi! I'm Satyam Chauhan, a Data Analyst with 1 year 7 months of hands-on experience building automation solutions and interactive dashboards. Based in Dwarka Mod, New Delhi.

As an MIS & Data Automation Specialist, I design real-time reporting systems, automate manual workflows using Google Apps Script & Python, and build Power BI dashboards that make complex data approachable for every stakeholder.

My automation work has reduced payroll errors and improved reporting efficiency by 40% — transforming tedious manual processes into smooth, scalable pipelines for solar infrastructure and manufacturing clients.

1.7
Yrs Experience
40%
Efficiency Gain
7+
Projects Built
Work Experience
Aug 2025 – Present
Data Analyst
Avi Couture Private Limited · Moti Nagar, New Delhi
Managing the Field/Flow Management System (FMS), automating key processes using Google Apps Script to reduce manual work and improve data accuracy across operations.
Sep 2024 – Aug 2025 · 10 months
MIS Executive
Sugs Lloyd Limited · Noida Sector 16
Developed and maintained automated MIS reports using Advanced Excel, Google Sheets, Power BI, Apps Script, MySQL, Python & HTML for data-driven decision-making on solar infrastructure projects.
Graduated 2025
BCA – Bachelor of Computer Applications
Swami Vivekanand Subharti University, Meerut
02 / Skills & Tech Stack

My toolkit for
data-driven
excellence.

Advanced Excel✦Power BI✦Google Sheets✦Google Apps Script✦MySQL✦Python✦Looker Studio✦AppSheet✦HTML & CSS✦MIS Reporting✦KPI Tracking✦Data Visualization✦ Advanced Excel✦Power BI✦Google Sheets✦Google Apps Script✦MySQL✦Python✦Looker Studio✦AppSheet✦HTML & CSS✦MIS Reporting✦KPI Tracking✦Data Visualization✦
Data & Reporting
Advanced Excel
MIS Reporting
KPI Tracking
Data Management
Data Analytics
Visualization & BI
Power BI
Looker Studio
Dashboard Development
Data Visualization
Google Sites
Automation & Scripting
Google Sheets Automation
Google Apps Script
Process Automation
Google AppSheet
Python
Database & Web
MySQL
HTML
CSS
Wage Management
Payroll Automation
03 / Projects

Work that
speaks for
itself.

01 · Featured
Production, Payroll & KPI-Based MIS Automation System

Designed and automated a full production & payroll management system using Google Sheets and AppSheet. Enabled real-time wage calculation, tri-monthly payroll automation, and live KPI dashboards. Reduced payroll errors and improved reporting efficiency by 40% through end-to-end process automation.

Google SheetsAppSheetGoogle Apps ScriptKPI TrackingPayroll Automation
02
Process Automation & Flow Management System

Designed and implemented a full FMS using Google Sheets & Apps Script. Automated data entry validation, auto-timestamps, and status-based calculations — eliminating key manual bottlenecks.

Google SheetsGoogle Apps ScriptProcess Automation
03
SalesIQ: Python EDA Pipeline

Engineered a Python EDA pipeline analyzing sales data across 12 dimensions. Applied Pareto 80/20 & discount impact modeling, finding discounts above 10% reduce profit margins by ~8 pts. Auto-generated 12 business insight charts.

PythonMatplotlibSeabornPandasEDA
04
NHAI & NTPC Rooftop Solar MIS

Managed MIS & Data Automation for large-scale solar projects in Delhi, creating Power BI dashboards to track installation progress, KPIs, and compliance across an 11-month engagement.

Power BIExcelGoogle SheetsMIS Reporting
05
BREDA SSL — Solar Streetlight MIS

Prepared automated MIS reports and maintained project data for BREDA's solar streetlight installations. Streamlined reporting workflows using Google Sheets, Excel, FCA, and Power BI.

Google SheetsExcelPower BIFCA
04 / Live Dashboards

Dashboards
built to
perform.

01 · Production
● LIVE
sites.google.com · Avi Couture Pvt Ltd
Production Dashboard — Avi Couture
Production Dashboard
End-to-end production tracking for Avi Couture Pvt Ltd. Monitors 68K+ planned units across cutting, stitching, bundling, quality check, and packaging — with live fabricator-wise and table-wise breakdowns.
68K+
Units Tracked
8
Stages Monitored
Live
Real-Time Data
Google SheetsApps ScriptAppSheetKPI TrackingLooker Studio
→
02 · Operations
● ACTIVE
sites.google.com · Avi Couture Pvt Ltd
Checklist Dashboard — Avi Couture
Check List Dashboard
Department-wise task tracking system for daily (D), weekly (W), monthly (M), and quarterly (Q) operations. Tracks 2,000+ tasks across 7 team members with status breakdowns — Done, Pending, and Not Today.
1,982
Tasks Done
6
Departments
7
Team Members
Google SheetsApps ScriptGoogle SitesTask AutomationLooker Studio
→
2
Live Dashboards
68K+
Units Monitored
Real-Time
Data Sync
40%
Efficiency Gained
05 / Contact

Let's build
something
with data.

Have a project involving dashboards, MIS automation, or data reporting? Let's connect and turn your data challenges into real results.

✉ chauhansatyamsilika@gmail.com 💼 linkedin.com/in/satyamchauhan2005 🐙 github.com/SatyamChauhan2005
✓ Message sent! I'll get back to you soon.