Operations · Analytics · Lucknow, IN

Turning messy
workflows into
clear decisions.

Operations Analyst with 2+ years building BI dashboards, automating reporting, and driving 15–30% efficiency gains across cross-functional teams.

// Impact Snapshot 2024–26
Workflow turnaround 20%
Onboarding time 30%
Reporting hours saved 3+/wk
Data accuracy sustained 98%
SOPs standardized 12+
01 / About

The Approach

I work where operations meet evidence — building the dashboards, queries, and process maps that turn day-to-day chaos into decisions leaders can actually make.

My toolkit is BI dashboards in Power BI and Looker Studio, SQL for the heavy joins, Python for the automation, and Excel for everything in between. But the real work is upstream: figuring out what to measure, why it matters, and how to make the answer obvious.

Currently at Mastroke, where I've cut workflow turnaround by 20% and reduced stakeholder reporting time by ~3 hours/week. Looking for Business or Operations Analyst roles where process improvement and stakeholder communication both matter.

Operations & Process
KPI tracking · SLA reporting · Root-cause analysis · Process optimization · SOP documentation · Stakeholder reporting · Data quality auditing
Data & Querying
SQL (joins, CTEs, window functions, subqueries) · Python (Pandas, NumPy, Matplotlib) · Statistical analysis · A/B testing
BI & Visualization
Power BI · DAX · Power Query · Looker Studio · Excel dashboards · Matplotlib
Tools
JIRA · Notion · Confluence · MS 365 · Google Workspace · Git
02 / Experience

Where I've Worked

Process Associate — Process Analytics
Mastroke, Lucknow
JUN 2024 — PRESENT
  • Designed and deployed a Looker Studio operational dashboard tracking 6 live workflows for a 15-person cross-functional team, enabling real-time SLA compliance monitoring and reducing stakeholder reporting time by ~3 hours/week.
  • Authored SQL queries and Excel-based data models to consolidate workflow data from multiple sources, enabling consistent KPI tracking across 4 operational functions.
  • Diagnosed and resolved 8+ process bottlenecks across 3 departments using root-cause analysis, delivering a 20% reduction in workflow turnaround time.
  • Standardized 12+ SOPs with data-backed process maps, cutting new-hire onboarding time by ~30% and improving clarity across 4 operational functions.
  • Conducted monthly data quality audits across 500+ records, sustaining 98% accuracy and full compliance with internal reporting standards.
  • Delivered weekly performance reports and KPI summaries to senior leadership, translating raw workflow data into actionable prioritization decisions.
  • Collaborated with department leads to identify pain points, define success metrics, and align reporting outputs with business priorities.
03 / Projects

Selected Work

// PROJECT HOURS · 8 PROJECTS DEC '24
P1
P2
P3
P4
P5
P6
P7
P8
CASE · 01 — DASHBOARD

Employee Project Time Tracking Dashboard

Built an end-to-end Looker Studio reporting solution giving leadership real-time visibility into how a 30-person team was spending its hours across 8 active projects. The org was running on gut-feel resource allocation, with weekly status reports taking hours to compile manually.

+15% team productivity Surfaced that 40% of project hours were concentrated in just 2 of 8 projects. Insight directly informed a resource rebalancing initiative.
Looker Studio Power Query Excel
CASE · 02 — ANALYSIS

Employee Meeting Time Analysis

A data-driven investigation into a recurring complaint: employees felt overwhelmed by meetings. Rather than acting on anecdote, I analyzed actual calendar data for 50+ employees to quantify the problem and identify exactly where the friction was happening.

+2 hrs/week recovered per employee Pinpointed Tue–Thu, 10am–12pm as peak congestion. Findings drove a scheduling policy change — roughly 100+ hours of recovered focused work weekly across the org.
Python Pandas Matplotlib
// MEETING DENSITY · WEEK JAN '25
9AM
10AM
11AM
12PM
2PM
3PM
M
T
W
T
F
04 / Education

Foundations

B.Tech, Electrical Engineering

Veer Bahadur Singh Purvanchal University
JAUNPUR, UP · NOV 2020 — JUN 2024 · CGPA 6.9/10

Certifications

  • Data Analytics with Generative AI — PW Skills MAR '26 →
  • Project Management Fundamentals — Simplilearn 2024
  • Programming with Python — Internshala 2023
// 05 / GET IN TOUCH

Have an operations problem
that needs clearer answers?

I'm open to Business Analyst, Operations Analyst, and Process Analyst roles — full-time or contract. Always happy to chat about dashboards, SQL, or process design.