Shobhita Sohal

Analyzed market intelligence data from 10+ industries to identify business inefficiencies and growth opportunities, resulting in strategic recommendations projected to increase client ROI by 7-12% YoY. Developed and implemented project execution frameworks for internal stakeholders across all projects, improving coordination and data quality by 35% and driving 20% faster project completions.

Architected a comprehensive BI solution for annual product study worth $500,000, delivering actionable insights that increased market share by 2-3%. Developed automated Excel models and dashboards processing 700+ data points, reducing reporting time by 30%.

Designed an automated data validation framework analyzing data from 12 countries, reducing manual effort by 30%. Developed automated data cleaning pipeline reducing processing time by 21% while improving data quality by 100%.

Conducted in-depth trend and seasonality analysis on sales data using SQL for developing targeted marketing strategies for high- performing months. Built SQL-driven product performance segmentation using window functions and CASE logic, enabling prioritization of product development and pricing decisions.

Analyzed patient wait times by hour using DAX in Power Pivot; uncovered peak hours, enabling 12% improvement in staffing efficiency. Built dashboards to compare referral types and admission rates; revealed direct referrals led to 55% of ER traffic, supporting targeted triage decisions.

Engineered predictive model using Python (NumPy, Pandas) to analyze 7300 vehicle records, achieving 86% accuracy in CO2 emissions forecasting. Created interactive visualizations using Matplotlib and Seaborn to identify key trends across 3 vehicle metrics.

Performed end-to-end data cleaning on a raw Real Estate dataset using SQL, addressing nulls, duplicates, and inconsistent formats. Utilized SQL transformations include string functions, data type conversions, and windows functions to standardize.

Completed a Master's Degree in Operational Research with a specialization in Statistics. The program focused on advanced statistical methods and their application to real-world operational challenges.

Obtained a Bachelor's Degree in Mathematics with Honours. The curriculum provided a strong foundation in mathematical principles and analytical problem-solving.