Subham Kumar Biswal
Business Analyst | SQL & Python | BI & Operations Analytics
Hyderabad, HyderabadMember since February 4, 2026
Advanced SQLCTEsWindow FunctionsJoinsAmazon S3 Data ExtractionETL Pipeline DesignPandasNumPySciPyScikit-learnFB ProphetARIMAStreamlitMatplotlibSeabornPower BITableauLookerQuickSightExcelPivot TablesExcel MacrosA/B TestingCohort AnalysisFunnel AnalysisKPI Framework DesignBehavioural SegmentationForecastingProcess AutomationWorkflow Standardisation
·
About
Business Analyst with hands-on experience converting raw operational data into measurable supply chain and consumer experience improvements. Proficient in SQL, Python, and BI tools (Power BI, Tableau). Proven track record of building automated reporting pipelines, driving 20–50% efficiency gains, and influencing cross-functional stakeholders across operations, client teams, and product leadership. Bias for action, deep-dive data thinking, and scalable process design.
Experience
Business Analyst — Growth & Operations Analytics - AB Connectz - Bhubaneswar
(2025-11)
- Designed end-to-end SQL + Power BI pipeline tracking 15+ operational KPIs across 10+ client accounts — reduced manual reporting by 30% and cut leadership review time from days to hours.
- Behavioural cohort analysis identified 3 high-value segments (~60% of revenue); actioned by business team to improve campaign ROI by 30% and reduce client churn by 20% QoQ.
- Funnel analysis diagnosed onboarding friction, driving 35% CRM adoption improvement and 40% lead-tracking efficiency gain; standardised reporting templates saved ~8 analyst hours/week.
- Partnered with engineering to define instrumentation requirements for a custom CRM — translated ambiguous business needs into SQL schemas and BI specs, delivered with zero post-launch data discrepancies.
Business Analyst Intern - Verzeo - Bengaluru
(2021-09 - 2021-12)
- Built 4 Tableau dashboards tracking feature adoption and KPIs — increased data accessibility by 40% and eliminated 30% of manual reporting overhead within 6 weeks.
- SQL + Python (Pandas, SciPy) scripts cleaned and modelled multi-source datasets; A/B test results directly informed 3 product roadmap decisions.
Education
MBA - Business Analytics - Lovely Professional University
Skills
Business AnalystSQL & PythonBI & Operations Analytics
