Back to home
Download PDF

Arun S. Prema

Revenue Operations | GTM Strategy | Sales Strategy & Operations | Commercial Planning

KPI Governance | Forecasting & Planning | Revenue Analytics | Cross-Functional Leadership

Pittsburgh, PA arunshanmugamprema@gmail.com +1 (724) 359-9803
Portrait of Arun S. Prema

Professional Summary

Revenue Operations and GTM Strategy leader with extensive experience building scalable commercial operating systems across enterprise and consumer businesses. Proven track record driving forecasting accuracy, KPI governance, channel transformation, incentive design, and operational efficiency across $1B+ environments. Experienced leading cross-functional initiatives spanning Sales, Finance, Product, Supply Chain, and Executive Leadership to improve revenue performance and planning rigor. Deep expertise in SQL, Power BI, and Excel modelling and translating complex operational data into executive-grade strategic decisions.

Professional Experience

Regional Channel Marketing Manager | Sales Strategy & Operations Lead, Bajaj Electricals Ltd. Jun 2017 – May 2023
~$100M regional P&L | 200+ distributors | 200,000+ retailers | ~100-person team | National channel operations
Retailer Incentive Program Redesign | Revenue Operations & Channel Engagement Transformation
  • Redesigned end-to-end national retailer loyalty program for 200,000+ retailers and 350+ field reps after structural complexity drove participation to 15%; incentive budget generating zero behavioural change across 85% of retailer network, with 35% of targeted retailers remaining inactive despite direct rep outreach.
  • Drove cross-functional alignment with Finance and Sales leadership using Excel scenario modeling to migrate from 13 irregular 28-day cycles to standardized 12-month structure; partnered with Product team to deploy app-based weekly self-tracking for 200,000+ retailers, simplifying qualification from multi-variable tiers to straightforward value/volume targets, and led change management across 350+ reps for consistent last-mile adoption.
  • Scaled retailer participation from 15% to 55% within 3-6 months, reactivated 35% of previously inactive targeted retailers, delivered 15% sales uplift, and drove 25% increase in SKU billing depth across 200,000+ retailer network.
Distributor ROI Improvement | Revenue Operations & Working Capital Optimization
  • Diagnosed distributor profitability gap across 100 distributors and 50 reps where ROI ran at 18-20% against 24-30% target; market outstanding at 1.5-2x monthly sales blocked working capital while sales teams remained incentivized purely on revenue with zero collections accountability.
  • Redesigned incentive structure using Excel-based dual-trigger payout modeling to reward both sales achievement and same-day collection milestones; operationalized real-time CRM-tracked collection workflows for 100 distributors, and designed structured range-selling training for 50 reps to shift SKU mix toward mid and premium products, improving inventory rotation and distributor ROI contribution.
  • Reduced market outstanding from 1.5-2x to 1.2x monthly sales, improved payment collections by 55%, increased distributor ROI by 25-50% toward 24-30% target, and shifted 50-rep field execution from revenue-only selling to collections-and-profitability-driven channel management.
Stock Availability Optimization | Inventory Planning & Revenue Recovery Transformation
  • Identified 15-25% recurring monthly sales loss across 200+ distributors, 50 territories, and 600+ SKUs caused by chronic stock-outs eroding retailer confidence; 40% of SKUs experienced persistent unavailability, permanently destroying demand in high-margin mid and premium segments.
  • Built SKU-wise stocking norms in Excel for 600 SKUs using sales velocity, seasonality, and demand-frequency analysis; collaborated cross-functionally with Supply Chain and Territory leadership to enforce minimum stock thresholds; implemented ERP-driven replenishment cadences with weekly rep-level execution reviews to standardize ordering behavior across 50 territories.
  • Reduced monthly sales loss from 15-25% to near zero, improved SKU availability by 45% across 200+ distributors, recovered 15-18% incremental sales growth within 2 quarters, and rebuilt retailer order fulfillment confidence across mid and premium product categories.
Digital Retailer Loyalty Infrastructure | 0→1 QR-Based Loyalty Platform Build
  • Designed QR-based digital loyalty program from zero for 1,000 retailers to address premium product mix stagnating at 15%, with retailers actively recommending competitor brands; representing estimated 10% in recoverable premium revenue loss and zero digital infrastructure to track or influence recommendation behavior at scale.
  • Conducted 50+ field retailer interviews to map recommendation behavior, ran 84-retailer pilot to validate program mechanics and points economics using Excel analysis, then launched QR-based self-tracking and digital redemption flows across 1,000 retailers; coordinating 25 reps through structured onboarding playbooks and coaching for consistent activation quality.
  • Activated 49,000+ loyalty points redeemed within 6 months (~$100K in retailer incentive value), improved premium product mix from 15% to 20%, shifted 1,000 retailers from passive stock holders to active brand advocates, and established region's first scalable digital loyalty infrastructure replicable for national rollout.
COVID Inventory Liquidation | $2M Revenue Recovery, Zero Incremental Spend
  • Executed fully remote sales campaign to liquidate $2M of $8M in aged premium inventory during COVID lockdown; market hours restricted to 3 hours daily, 95 reps unable to visit retailers, logistics halted for non-essentials, and conventional distribution channels effectively shut across 15 regions.
  • Launched WhatsApp Business-led campaign repositioning anti-viral premium fans as COVID-relevant products; produced and distributed product demo videos to replace in-person sales conversations; engineered frictionless remote ordering via Google Forms; activated 95 reps across 15 regions within one week through daily Excel-tracked performance dashboards and structured objection-handling coaching.
  • Reached 4,000+ retailers across 15 regions, generated $2M in revenue and liquidated 25% of total aged inventory within 3 days; hitting full liquidation target with zero physical visits and zero incremental spend, and established remote selling model subsequently scaled nationally across 95 reps.
Allegheny County Department of Human Services (AC DHS) Jul 2023 – Present
Budget Analyst II
$1B+ annual budget | 8 departments | 4 vendor contracts | Pittsburgh, PA
Enterprise KPI Governance | 0→1 Performance Framework Build
  • Built county-wide KPI governance system from zero across 8 departments and 4 vendor contracts managing $1B+ in annual spend; no unified performance framework existed, every cross-functional review required custom data pulls, and 5-6 ad hoc requests per month consumed significant analyst and leadership time with no mechanism for proactive strategic gap-closure.
  • Extracted and validated performance data across 8 departmental sources using SQL, defined 8 standardized KPIs covering performance, utilization, and compliance; facilitated structured alignment sessions with 8 department heads and 4 vendor leads to build cross-functional consensus; deployed Power BI dashboards organization-wide and published self-serve reports via SharePoint; delivering full system with 2-person team in 2 months.
  • Reduced ad hoc data requests by 55% within 2 months of deployment, standardized 8 KPIs across 8 departments and 4 vendor contracts, enabled leadership to shift from reactive data-chasing to strategic gap-closure in quarterly reviews, and delivered replicable governance model for future program expansions.
Multi-Department Budget Forecasting & Planning | $1B+ Portfolio
  • Inherited $1B+ annual forecasting problem across 8 departments generating 50-60 fund reallocations per year; approximately $100M in funds were misallocated at any given time, 10% forecast error rates made confident expense planning impossible, and each reallocation cycle consumed 12 person-days of manual effort across 16 department heads and stakeholders.
  • Queried 5 years of historical spending data across all cost centers using SQL to identify trend patterns, seasonality drivers, and variance outliers; built multi-scenario forecasting models in Excel incorporating trend analysis and policy-driven expense flags; facilitated alignment sessions with 16 department heads to validate projections; built proactive reallocation early-warning system in Excel linked to Workday Financials to automatically flag budget drift before formal approval was required.
  • Reduced fund reallocations from 50-60 per year to 10-15 (80% reduction), cut manual effort per cycle from 12 days to 3 days (70% efficiency improvement), freed approximately $100M in previously misallocated funds, and reduced forecast error from 10% to near zero across all 8 departments.
Executive QBR Reporting Transformation | Cycle Compression & Governance Redesign
  • Redesigned executive QBR reporting infrastructure for $1B+ organization where 8 departments manually assembled reports in sequential handoffs; consuming 5 full days every quarter before single leadership decision could be made, with 50+ stakeholders dependent on fragmented, disconnected outputs that lacked single version of truth.
  • Mapped all QBR data requirements across 8 departments using SQL; directed data team to integrate all departmental sources into unified Power BI data layer; rebuilt 5 fragmented reports into standardized reporting system; managed change across 50+ stakeholders through structured communications and walkthroughs; establishing single-owner repeatable workflow distributed via SharePoint.
  • Compressed QBR cycle from 5 days to 2 days (60% reduction), reduced report ownership from 8 coordinating departments to 1 person with zero handoff dependencies, freed 50+ stakeholders from data assembly cycles, and delivered scalable repeatable reporting system across 5 rebuilt dashboards serving full $1B+ portfolio.

Earlier Career

Bajaj Electricals Ltd. — Regional Sales Manager Jan 2014 – May 2017
Channel sales leadership — 50+ distributors, 10,000+ retail accounts, South India
Godrej & Boyce / Zopper — Area Sales Manager / Key Account Manager 2012 – 2014
Consumer durables and retail technology sales across South India
Philips India / Samsung India — Territory Sales Manager 2007 – 2012
Consumer electronics field sales and distributor management
Asian Paints India — Territory Sales Officer 2004 – 2007
Dealer network development and territory sales management

Education

McCombs School of Business, The University of Texas at Austin 2022
PG Diploma in Data Science & Analytics
St. Joseph's College, Bharathidasan University 2004
B.Sc. Mathematics

Tools & Skills

Tools: SQL (PostgreSQL, BigQuery) | Power BI | Tableau | Excel (advanced modeling, scenario analysis, Power Query) | Salesforce | Workday Financials | SAP | ERP systems | SharePoint | Google Workspace | Slack
Skills: Revenue Operations | GTM Strategy & Planning | Sales Strategy & Operations | KPI Governance (0→1) | Forecasting & Budgeting | Incentive Design & Optimization | Channel Strategy & Transformation | Channel Operations | Executive Reporting | Commercial Analytics | Cross-Functional Leadership | Process Transformation | 0→1 System Builds