Aditya Aryan

01 / summary

Analytics professional with a Master's in Data Science and 3+ years across BI and data engineering. Builds governed pipelines in dbt, BigQuery, and GCP, then turns them into Power BI and SQL reporting leadership acts on. Drove a 65% rise in dashboard adoption, cut reporting cycles 40%, and lifted source reliability to 95%.

02 / experience

1. May 2025 – Dec 2025

   Data engineer

   Nissha Medical Technologies · Buffalo, NY

   • —Designed automated testing routines in Python with pandas and NumPy, lowering manual production review effort by 35% across validation phases.
   • —Investigated 4,500+ manufacturing logs through EDA and statistical analysis, raising variance tracking consistency by 27%.
   • —Engineered anomaly-filtering logic with feature engineering and model checks, removing recurring calculation faults.
   • —Implemented monitoring triggers on yield variables, shortening factory inspection cycles by 31% through real-time streaming.
   • —Validated preprocessing routines under Git version control, decreasing false-positive anomaly flags by 18%.

   Python · pandas · NumPy · OpenCV · Git

2. Mar 2024 – Jul 2024

   Data analyst, business operations & reporting

   Constituents AI & Technology · Remote

   • —Developed 10+ Power BI dashboards with DAX and Power Query, merging marketing and operational clusters and expanding self-service usage by 65%.
   • —Mined 1.2M+ transaction records via SQL on PostgreSQL, running cohort and retention analysis that lifted conversions by 12%.
   • —Modeled subscriber shifts through time-series forecasting, lifting quarterly forecast accuracy by 20%.
   • —Standardized metric definitions and ran A/B testing with segmentation logic, cutting review prep timelines 40% and entry errors 90%.
   • —Facilitated requirements gathering with stakeholders, aligning raw operational metrics against structured RDBMS schemas.

   Power BI · DAX · Power Query · PostgreSQL · SQL

3. Jun 2022 – Mar 2024

   Data analytics & reporting analyst

   Google · Remote

   • —Consolidated reporting assets in Power BI and Excel across 10+ business units, shrinking manual spreadsheet work by 40% for leadership reviews.
   • —Optimized BigQuery and Spark transformation jobs feeding daily reporting, tuning partitioned query logic to stabilize production loads across dozens of migrated finance sources.
   • —Automated reconciliation checks enforcing data quality and governance across warehouse layers, flagging schema drift early to protect reporting integrity through platform transitions.
   • —Translated raw operational feeds into governed warehouse tables using dimensional modeling, documenting column-level lineage back to validated upstream finance sources.
   • —Produced standardized reporting packages from reconciled MySQL datasets, giving stakeholders consistent month-over-month figures and cutting historical gaps 95%.

   GCP · BigQuery · dbt · Airflow · Spark · Power BI · Excel · MySQL

03 / education

04 / selected projects

• Aug 2026 – present

  NYC subway reliability pipeline

  The MTA never records when a train actually arrives. This pipeline infers it.

  Python · BigQuery · dbt · GCP

• Jan 2025

  Bank marketing strategy

  43,193 telemarketing calls, normalised to 3NF, three classifiers — and a dashboard you can actually drive.

  Python · scikit-learn · SQLite · Dash · Plotly

• Aug 2025 – Dec 2025

  AI print inspection system

  Defect detection on high-speed print lines, 69% → 95% mAP.

  OpenCV · YOLOv8 · Python

• Jan 2025 – Feb 2025

  Customer churn prediction

  87% test accuracy on 10K telecom records, surfaced in Power BI.

  Python · scikit-learn · Random Forest · Power BI

• Jan 2025 – Feb 2025

  Real-time fake news detector

  TF-IDF and ensemble models at 91% precision, streamed to a live dashboard.

  spaCy · TF-IDF · SVM · Logistic Regression

• Jan 2025 – Feb 2025

  Marketing campaign segmentation

  75K customer records segmented; found the cohort running 19% below ROI.

  R · rpart · dplyr · Power BI

• Aug 2022 – Dec 2022

  Mineral mapping and classification

  Remote sensing plus ML for mineral exploration. Paper under review.

  CNN · Random Forest · Remote sensing

05 / capabilities

Languages

SQL · Python (pandas, NumPy, scikit-learn) · R · DAX · Power Query · Git

Analytics & reporting

Power BI · Tableau · Excel · Microsoft Fabric · KPI dashboards · Data storytelling · Executive reporting

Statistical methods

Regression · Time-series forecasting · A/B testing · Cohort & retention · Segmentation · Feature engineering · EDA · MLOps

Data operations

ETL/ELT · dbt · Airflow · Spark · Dimensional/star-schema modeling · Warehousing · Cleansing · Validation · Governance

Platforms & databases

BigQuery · Snowflake · GCP/AWS/Azure · PostgreSQL · MySQL · SQL Server · LLMs · RAG · Prompt engineering · Vector DBs

06 / certifications

• Google · Coursera · Crash Course on Python
• Google · Coursera · Using Python to Interact with the Operating System
• Google · Coursera · Introduction to Git and GitHub
• Google · Coursera · Troubleshooting and Debugging Techniques
• Google · Coursera · Configuration Management and the Cloud
• Vanderbilt · Introduction to Programming with MATLAB
• Oracle Academy · Database Foundations
• Red Hat Academy · RH124 — Red Hat System Administration I
• Red Hat Academy · RH134 — Red Hat System Administration II