Sohil Ansari

I’m a Data Analyst focused on market analysis, ecosystem dynamics, and data-driven strategy in fast-paced environments. In my current role as a Junior Data QA Analyst, I validate large-scale US healthcare datasets (millions of records) to support accurate analytics and reporting, and I automate validation workflows using Python & SQL (BigQuery) to reduce manual effort and improve efficiency. I also worked to reduce client-reported issues from 12% to 4% and partner with data engineers to debug pipelines for reliable end-to-end data flow.

On the analytics side, I built an end-to-end system for “Basket Wise - Retail Analytics & Bundle intelligence” (Python, SQL, Streamlit) to uncover revenue opportunities from POS transaction data. I used co-purchase metrics (support, lift, attach rate) to identify high-impact product bundles and built a decision-focused dashboard to help store owners optimize product mix and increase average order value (AOV). I’ve also done price optimization and revenue modeling by analyzing pricing, sales, and competitor data, modeling price elasticity, simulating dynamic pricing strategies, and training predictive models (Random Forest, XGBoost) to recommend pricing scenarios.