Akshata Bodhankar

About Akshata Bodhankar

Business Analytics enthusiast with knowledge of pharma datasources including LAAD, specialty pharmacy, internal 852 & 867 data, with particular experience in resipiratory disease & some in oncology. Experience working in commercial analytics teams of large pharma companies.Technical skills: Tableau, SQL, Databricks, Coginity, Python, PowerBI, AlteryxCross functional working experience as a Business Analyst - ERM in a credit services company with ability to collaborate and single-handedly develop tools using the risk and performance indicators identifiedTechnical skills: Tableau, SQL, R, Python, Snowflake, SASCertifications: Decision Scientist Certificate, Business English Certification, Google Analytics IQ, AlteryxAcademic knowledge: T-distribution, rank sum and signed rank tests, ANOVA, Chi-square, F-test, linear regression, PCA, variable selection techniques, logistic regression, k-means clustering, discriminant analysis, CART, bagging and random forest, Causal analytics, Neural Networks, KNN, predictive analytics, econometrics, fixed effects, random effects, A/B testing

Experience

1. Project Leader

   Axtria - Ingenious Insights

   Oct 2022 — Present · San Jose, CA, US

   Conducted cohort-level impact analysis to evaluate provider identifier redaction strategies across clinical and non-clinical populations. Quantified single- vs multi-flag risk effects by provider role (rendering, billing, referring), enabling data-driven recommendations to preserve cohort integrity while mitigating re-identification risk.• Revamped the executive-facing dashboard (used by CEO and senior leadership) to provide a clear snapshot of new account starts, regional performance, and KPI trends over time, enhancing strategic insights. Enabled parameter-based regional drilldowns and summarized breadth, depth, and volume metrics at multiple roll-up levels.• Developed the sole dashboard used by field reps for daily planning, accessible on iPads and laptops, which streamlined planning processes. Integrated multiple data sources (competitor, claims, target tiers, beneficiary data, etc.) into a unified model. Designed real-time opportunity flags using Z-scores (e.g, high % unscreened, high reimbursable potential). Enabled CRM integration, account-level drilldowns, Excel-style filters, and sorting by percentile-based performance tiers. Included weekly scheduled alerts by territory.• Led data analysis initiatives for Sales Team stakeholders, analyzing patient-level datasets and Call Plan data to optimize the samples-to-script ratio; demonstrated insights through dashboards built in PowerBI and Excel.• Supported client’s Oncology brands by reporting on demand in market, field engagement & IQVIA patient level data and provided insights to develop breadth and depth strategy• Developed comprehensive dashboards in Tableau for performance analysis and market expansion in the Asthma space, incorporating Prescriber Level Analysis, Patient Persistence, and Analog Analysis. Utilized Databricks for complex data analysis and predictive modeling, successfully identifying prescribers with high potential for market growth.

Education

• Keshav memorial institute of technology

  Bachelor of Technology - BTech, Electronics and Communication Engineering

• Naveen Jindal School of Management, UT Dallas

  Master of Science - MS, Business Analytics