Nalin Arora
Maroubra,NSW
Summary
Data Analyst with 3.5+ years of experience in data engineering, visualisation and analytics, specializing in building scalable ETL/ELT pipelines for leading pharmaceutical clients. Demonstrated track record in delivering high-performance data solutions, improving efficiency, and ensuring data integrity across complex data ecosystems. Strong foundation in data governance and analytics-ready data modeling.
Overview
4
4
years of professional experience
3
3
Certification
Work History
Data Associate
Axtria - Ingenious Insights
Noida / Gurugram, India
07.2022 - 01.2026
- Project: Gilead – Leapfrog NBA & Reporting
- Developed and optimized end-to-end Databricks (PySpark, Spark SQL) pipelines powering Leapfrog NBA dashboards across 8 countries, enabling actionable insights across omnichannel engagement and HCP interactions.
- Improved pipeline performance and data reliability by implementing efficient joins, aggregations, and execution window optimizations, supporting large-scale reporting across EU and US markets.
- Project: Takeda - CDW - EDB Migration
- Enforced clean coding protocols, applying unit testing, exception handling, and logging, contributing to 30% decline in bugs reported in production.
- Project: Merck - Data Genie - Unified Commercial Solution
- Constructed robust Python and SQL-driven ETL pipelines enhancing data transformation efficiency by 25% through development of analytics-ready datasets (ARDs)
- Project: Merck - VIDA Vaccine Datamart
- Developed domain ARDs to enhance response capability for broad inquiries regarding vaccine administration, locations, age demographics, HCP specialties, and competitor products.
- Project: Merck - USGAIN WELIREG
- Engineered solution ARDs in collaboration with Merck stakeholders and data visualization teams to reconcile sensitive datasets, aligning all output within a variance of ±1%.
- Project. ITCI (Intracellular Therapies) Data Management Implementation
- Utilized Axtria's native DataMax tool and Snowflake to enhance data efficiency and maintain a single source of truth. Earned organization-wide recognition in BIM Applaud forum for exemplary execution.
Research Analyst
World Quant LLC
Remote
12.2018 - 12.2019
- Engineered over 500 quantitative trading models (alphas) across EU and US equity markets.
- Implemented strategies of mean-reversion, behavioral finance, and statistical analysis to extract meaningful insights from significant financial datasets.
- Leveraged Python alongside WebSim platform to process data, conduct backtesting, and assess performance of trading strategies.
Education
Master of Science - Data Science And Decisions
The University of New South Wales
Kensington, NSW02-2028
MSc - Mathematics
Birla Institute of Technology And Science
Pilani01-2022
BE - Chemical Engineering
Birla Institute of Technology And Science
PilaniSkills
- Python, C, and C programming
- SQL and database management
- Data engineering with PySpark
- Cloud computing with AWS
- ETL tools: Informatica BDM and Matillion
- Data warehousing with Databricks and Snowflake
- Data visualization with Power BI & Microsoft Fabric
- Workflow orchestration with Airflow and Tidal
- Continuous integration with Jenkins
- Data governance with Collibra
- Machine learning & Statistical Modelling
- Pharmaceutical and financial analytics
Certification
- BIM Applaud, Axtria, Ingenious Insights, 2025
- Bravo Award, Axtria - Ingenious Insights, March/April 2023
- Certificate of Excellence in Data Structures and Algorithms in C++, Coding Ninjas, 2021
Publications
Correlating thermophysical properties of PCMs with end-use application behavior, research publication, SET Istanbul, 2022
Link: https://nottingham-repository.worktribe.com/output/17381128/set2022-19th-international-conference-on-sustainable-energy-technologies
Timeline
Data Associate
Axtria - Ingenious Insights
07.2022 - 01.2026
Research Analyst
World Quant LLC
12.2018 - 12.2019
Master of Science - Data Science And Decisions
The University of New South Wales
MSc - Mathematics
Birla Institute of Technology And Science
BE - Chemical Engineering
Birla Institute of Technology And Science