Iktisha Prasad
Final-year B.Tech CSE(AI) student and Data Analyst Intern
Talent
LucknowMember since May 14, 2026
SQLPythonJavaMySQLSQLitePower BITableauDAXPower QueryKPI ReportingDashboardingData VisualizationETL AutomationData CleaningData ModelingStar Schema DesignRevenue Recognition ReportingCohort AnalysisChurn & Retention ModelingLTVBehavioral SegmentationPandasNumPyMatplotlibAdvanced ExcelMicrosoft ExcelDashboard DevelopmentPipedreamARPUUnit Economics
·
Hire this person
Send a job offer directly to this candidate
SQLPythonJavaMySQLSQLite
About
Final-year B.Tech CSE(AI) student and Data Analyst Intern with hands-on experience building production BI dashboards, automating ETL pipelines, and standardizing KPI reporting in a live corporate environment. Proficient in SQL, Python, Power BI, Tableau, and DAX, with a track record of turning operational data into decisions stakeholders act on — including churn, retention, and unit-economics analysis across a 5+ dashboard portfolio.
Experience
Data Analyst Intern - A Box of Stories
(2026-02 - 2026-06)
- Built and maintained 5+ live Power BI dashboards (Daily Sales, Subscriptions, UK & US Revenue Recognition) tracking MRR, churn, retention, and sales performance across 60+ engineered DAX measures.
- Automated end-to-end ETL pipelines using Power Query (M) and Pipedream to ingest and reconcile data from Shopify, ReCharge, and Seal APIs, cutting manual reporting effort by 10+ hours/week.
- Audited and validated a 70+ field REST API schema, identifying and resolving data inconsistencies (date formats, type mismatches, null values) to safeguard downstream analytics accuracy.
- Built behavioral and tenure-based churn segmentation across product categories to flag at-risk customer cohorts, supporting proactive retention strategy for the business team.
- Designed unified Daily Sales and cross-channel KPI dashboards consolidating Shopify and Seal & Recharge data, iterating on visuals and filters based on stakeholder requirements.
- Developed unit economics dashboards tracking LTV, ARPU, and net margin to support revenue and profitability decisions.
Education
B.Tech - Computer Science & Engineering (Artificial Intelligence) - KIET Group of Institutions, AKTU (2027)
Class XII - CBSE (2022)
Class X - CBSE (2020)

