Harshit Arora Email & Phone Number

Philadelphia, Pa, Us

Cambridge, Cambridgeshire, Gb

Rare Disease - ATTR

Cambridge, Cambridgeshire, Gb

Rare Disease - ATTR

Cambridge, Cambridgeshire, Gb

Respiratory and Immunology Portfolio

Durham, North Carolina, Us

Won the 2021 IQVIA Impact Award for excellent overall performance, subject matter expertise, and client satisfaction which led to additional engagements for IQVIA amounting $500k+. I am responsible for delivering critical patient analytics, payer analytics, and complex KPI methodology generation and execution as an onsite consultant for leading Healthcare/Pharma firms with IQVIA National & Sub-national data (LAAD, XPO, DDD, etc.) • Managed and automated weekly and monthly portfolio performance tracking and KPI methodology development for 5 drugs with $6B+ combined annual revenue by leading a team of 4 associates and third-party vendors• Executed ad-hoc analysis for a Fortune 50 healthcare client using customer/patient claims, demographics, and credit/financial data to derive insights from complex KPIs such as persistency/drug compliance, source of business, market share, insurance claim approval rates, etc. using SQL, R, and Tableau• Identified customer segments with higher risk of non-compliance using claims/transactional, demographics, and Experian credit data using SQL & Python, contributing to a ~6% drop-in abandonment rate via improved promotional programs• Built a forecasting model to predict COVID vaccine volumes for various age groups, products, and vaccination frequency scenarios utilizing flu-based models as analogs, leading to additional engagements worth $200k+• Designed & led SQL and Excel quarterly training for 15+ employees with 93% participants rating the training 5/5 stars

Atlanta, Georgia, Us

Won the best capstone award for developing a highly-scalable model-based approach aimed at improving in-store visualizations using Machine Learning techniques• Developed a machine learning approach to uncover top-N most impactful product features across 1K+ SKUs, leading to an extensive revamp in online & store visual designs for improved customer experience & ~5% overall sales growth• Analyzed 1M+ online reviews, ratings, and Q&A text data using BigQuery (SQL) and Python (pandas, nltk, numpy, scikit-learn) to determine key product features and user sentiment using TF-IDF scores• Led collaboration with 3 client teams & presented findings and strategic recommendations to senior leadershipTools: Google BigQuery, Python, Microsoft Office Suite

Evanston, Il, Us

• Discovered key factors for low customer retention by analyzing quantitative survey data from 6,000+ customers using R; utilized statistical approaches to determine relative importance and user satisfaction towards product attributes• Reduced annual salesforce cost by 25% by building and deploying a market coverage and optimization model for a major healthcare client in Europe, leading to a $20M+ DTC promotional campaign• Analyzed effectiveness of pilot marketing campaigns using inferential statistics through A/B testing• Delivered roadmap to increase market share by 20% over 3 years by quantifying the consumer pathway and identifying key customer leakage points; Extrapolated results to national level and drafted recommendations for market development tactics

Worldwide, Oo

• Improved service rate by 15% by investigating and eliminating bottlenecks in car service & repair operations of a Fortune 100 automobile client through statistical analysis of observational data• Secured additional engagements worth $100K by recommending unsupervised machine learning techniques to segment customers and improve targeting strategy

Master Of Science In Business Analytics

Bachelor'S Degree, Information Technology