Career Timeline & Frameworks

Applying rigorous business analyst methodologies to real-world corporate, digital, and operational challenges. Click each card to reveal full framework-driven details.

I.P. Pharma

Business Operations Analyst Jan 2026 – Present
Ludhiana

Optimizing stock management and representative sales tracking pipelines for a regional, tier-2 city pharmaceutical distributor. Resolving field communication barriers and establishing automated spreadsheet workflows.

PAPAO Analysis Breakdown

Problem
  • Sales representatives operating in highly rigid field environments with manual stock tracking.
  • Invoicing procedures experiencing persistent lag times due to paper-based logs.
  • Supply chain buffers failing to capture seasonal variations, causing frequent medicine stockouts.
Approach
Structuring inventory mapping in Excel to automate order sheets and establish real-time reporting protocols.
Process
Standardizing core stock buffers and dispatch workflows, ensuring sales invoices are verified and orders dispatched within 24 hours.
Analysis
Identifying inventory lag points, pinpointing specific slow-moving medicine categories causing capital stagnation.
Outcome
Reporting latency reduced from 3 days to real-time. Automated forecasting prevents essential stockouts by 25% and frees up tied-up capital.

Labour Law Advisor

Social Media Manager Aug 2024 – Jul 2025
Jaipur

Led end-to-end data and operational mapping for community-led products and digital brands. Handled audience acquisition, standardized media processing, and coordinated cross-functional product pipelines.

PAPAO Analysis Breakdown

Problem
Unstructured organic conversion funnels for consulting packages and low brand community integration on new initiatives.
Approach
Mapped target customer demographic behavior and created standardized SEO pipelines to maximize digital assets.
Process
Standardized search metadata for 50+ high-traffic business videos. Created operational brand pages and launched targeted newsletters.
Analysis
Maintained weekly and monthly analytics sheets, tracking retention trends and click funnels using Google Analytics and Excel.
Outcome
Grew Jagruk.Shop social following from 400 to 4,000+ organic, highly targeted followers (10x growth). Video search click-through rate (CTR) increased by 15% across optimized playlists.

Mad Influence

Data Research Intern Mar 2024 – Jul 2024
Noida

Assisted in influencer campaign operations, tracking data, and building Excel-based client reporting templates for corporate brand partners.

STAR Methodology Details

  • Situation: The marketing agency managed diverse, multi-creator brand campaigns, but lacked standardized performance reports for corporate clients.
  • Task: Aggregate data, calculate key reach/engagement metrics, and build professional dashboard reports to present campaign ROI.
  • Action: Engineered robust Excel reporting templates, pulling cross-platform metrics (Instagram/YouTube) and utilizing automated lookup formulas to eliminate manual entry errors.
  • Result: Successfully managed reporting structures for 5+ major corporate campaigns, **reducing client reporting delivery time by 40%** and improving metric accuracy.

MRM / McCann

Account Management Intern Sep 2023 – Dec 2023
Gurgaon

Supported senior planners in ad spend tracking and budget allocation checks across diverse multi-channel campaigns.

STAR Methodology Details

  • Situation: The media planning team required daily auditing of ad network logs to identify underperforming channel investments and budget leakage.
  • Task: Standardize and clean massive weekly media spends, mapping efficiency metrics to detect channel cost variances.
  • Action: Structuring ad logs using Excel Pivot Tables and conditional scripts to automatically flag cost-per-click (CPC) anomalies.
  • Result: Assisted in monitoring budgets for 3+ major client portfolios, **reallocating underutilized funds to save approximately 8% in wasteful spend.**

Professional Certifications

Microsoft Business Analyst Specialization →

Coursera / Microsoft • March 2026

Rigorous training in Power BI, data warehousing, and enterprise data models.

Deloitte Australia Data Analytics Job Simulation

Forage / Deloitte • June 2025

Completed data validation, dashboard creation, and client communications simulation.