Himanil Arora

About Himanil Arora

Senior Data Analyst | Advanced Analytics, Experimentation & Reporting Automation | SQL, Python, BigQuery, Apache Airflow, Power BIInsight-driven Senior Data Analyst with 5.5+ years of experience applying statistical analysis, experimentation, and analytics automation to drive data-informed decisions across Pharmaceutical, Healthcare, and Enterprise domains. My work bridges advanced analytics, data engineering, and early-stage applied machine learning, with a strong focus on business impact and data quality.Currently at Primotech, I design and optimize SQL- and BigQuery-based analytical pipelines, orchestrated via Apache Airflow, and develop Power BI dashboards supporting large-scale pharmaceutical media campaigns spanning 70+ brands. Beyond reporting, I work extensively on metric design, anomaly detection (such as bot traffic identification), data validation, and exploratory analysis to ensure insights are reliable, explainable, and decision-ready.I bring a solid foundation in Statistics (PG Diploma, Panjab University) and Computer Science, with hands-on experience in hypothesis testing, A/B experimentation, regression analysis, and exploratory data analysis. I work extensively with Python (Pandas, NumPy, Matplotlib, Seaborn) to build feature-ready datasets and deliver clear, business-focused data stories.In parallel, I have started working on applied ML and NLP use cases with an analytics-first mindset, including vector similarity and RAG-based approaches for drug competitor identification, and building metadata-enriched data layers to support downstream advanced analytics and ML initiatives.Previously at IQVIA and TietoEVRY, I supported large-scale data migrations, automated SAS and Python workflows, ETL task, and production analytics systems, often acting as an L3 escalation point. This strengthened my understanding of real-world data reliability, system constraints, and model readiness.Recognized as a Hackathon Winner and recipient of multiple Kudos Awards, I enjoy solving ambiguous problems, improving analytical maturity, and progressively building toward data science–driven solutions grounded in strong analytics and statistics.Interested in roles and projects spanning Advanced Analytics, Experimentation, and analytics-led ML adoption.

Experience

1. Senior Data Analyst

   PRIMOTECH

   Apr 2024 — Present · Chandigarh, IN

   Engineered end-to-end reporting infrastructure for a pharma media group, supporting 100+ brands using BigQuery and Apache Airflow.• Built and deployed pipelines to parse metadata from FTP and managed continuous ingestion via Airflow with logging.• Developed and scaled stored procedures and views in BigQuery to support complex reporting logic and streamline data access.1. Validation Parser Tool Development• Developed a dedicated pipeline to ingest complex, multi-sheet Excel data into BigQuery.• Implemented an automated notification system to email ingestion status (success/failure) for all individual sheets.2. Reporting Tool Metric Extraction• Created a two-part pipeline solution to standardize metric data extraction from a reporting tool.• Designed pipelines to fetch live data from running reports and efficiently process/parse historical data for comprehensive context.3. Data Request & Metadata Layer Automation• Automated Outlook inbox parsing via Microsoft Graph API to extract reporting metadata.• Reduced reporting TAT from days to hours using an Airflow DAG and a BigQuery + Power BI solution to track SLA and ingestion health.• Built an automation layer to download SharePoint data to GCS, generating feature-enriched metadata tables to optimize tagging and boost discoverability.4. ML/NLP – Drug Competitor Identification• Implemented ML/NLP techniques including vector similarity and Retrieval-Augmented Generation (RAG) on FDA drug data.• Employed hybrid graph-based search with Agents2.0 prompt tuning to identify and validate potential drug competitors with SMEs.

Education

• Panjab University, Chandigarh

  Postgraduate Diploma , Statistics

• CHANDIGARH UNIVERSITY

  Bachelor of Technology, Computer Science

  2015 — 2019