Sagar Singh

Business Analyst with 4 years of experience translating ambiguous business problems into structured analysis and data-driven decision frameworks. Comfortable working cross-functionally with product, engineering, and operations teams to turn raw data into KPI dashboards and actionable insights, using SQL, Python, Power BI, and Excel. Adept at data modeling, trend analysis, and measuring how product and process changes move the underlying business metrics.

Business Analyst - SIM Advisory Inc

(2022-07)

Partnered with Sales, Finance, Pricing and Product teams across multiple regional markets to break down operational pricing problems into structured analytical questions before building anything.

• Supplement Pricing Model: Built an attribute-based pricing model in Excel (ingredient content + Good/Better/Best anchors) replacing cost-plus pricing for a supplement product line; recommended scenario projected ~$2.7M in annual revenue increase (~3.7% uplift) with 90% of buyers under a 6% price increase.
• Rebuild Engine Pricing (SRO): Replaced a manual, subjective rebuild-engine pricing process (losing customers to competitors pricing 10–30% lower) with a structured SRO methodology and a Power BI tracking dashboard; closed a ~3% margin gap between recommended and invoiced pricing across business units.
• Long-Tail Parts Pricing: Used SQL to apply 13 exclusion rules and filter 3 years of sales data across 6 African countries, isolating ~$3.4M in long-tail eligible revenue, then modeled a 20% price increase scenario projecting ~$135K in incremental revenue potential.
• Parts Promotion Strategy: Built a model to frame a product promotion strategy using revenue, volume, and customer segment that helped retain existing customers and win new ones while staying margin-neutral.
• FX Buffer Restructuring: Analyzed FX buffer levels across 6 African markets against 4 years of exchange-rate data and presented recommendations to local leadership; buffers were revised in 5 of 6 markets with a standardized monitoring process adopted.
• Contract & CPH Dashboard: Built a Power BI and Excel-based Contract Performance Dashboard consolidating contract, invoice, service cost, and asset data, giving stakeholders profitability visibility across 42 active contracts.
• Parts Bundling Analysis: Scripted in Python to bundle ~20K parts across 5 business units over five years, then validated the Power BI data model, recommending a one-to-many master/associated-parts structure and building a dashboard for Product Managers to spot upsell opportunities.
• Sales & Margin Realization: Built dashboards measuring the impact of cost, price, volume, and forex in 2024 vs. 2023, and trained the sales team on how to read them, leading to a ~8% improvement in decision accuracy.
• Built an end-to-end BI solution for global sales data (~$8B revenue across 13 years) for a manufacturing business — extracted data via SQL, cleaned and mapped it with Python (Pandas), and built Power BI dashboards and Excel reports for leadership.

B.Tech - Materials Science & Engineering - Indian Institute of Technology Gandhinagar (IITGN) (2018 - 2022)