Summary
Overview
Work History
Education
Skills
Timeline
Projects
SoftwareEngineer
ARNAV AGARWAL

ARNAV AGARWAL

Data Scientist
San Diego,CA

Summary

Data Scientist familiar with gathering, cleaning and organizing data for use by technical and non-technical personnel. Advanced understanding of statistical, algebraic and other analytical techniques. Highly organized, motivated and diligent with significant background in predictive modeling and business intelligence.

Overview

2
2

Years of experience

5
5
years of post-secondary education

Work History

Data Science Intern

Apex146 Ltd.
San Diego, CA
2022.07 - 2022.11

Project – Predictive Modeling

  • Increased accurate athlete race predictions by 15% using machine learning-based performance indexing model with statistical techniques and Python in 3 months.
  • Spearheaded cross-functional team of 5 -10 members to train, validate, implement model, and provide feedback to end users.
  • Optimized machine learning models' recall and precision by ~13% using statistical analysis techniques.

Project – Data Warehousing

  • Implemented and maintained centralized SQL database with 94.5% data transfer success rate across departments.
  • Migrated data from on-premise warehouse to AWS Redshift, resulting in 15% reduction in infrastructure costs.
  • Maintained database uptime of 96%, fostering data integrity, scalability, and remediation of performance issues; implemented updates with 97% success rate.

Project – Algorithm Optimization

  • Resolved limitations in index methodologies, increasing ML model accuracy by 5%, using data pre-processing and regression analysis.
  • Optimized predictive outcome of existing indexes by ~12% using back testing of algorithms and hyper parameter tuning.

Business Intelligence Analyst Intern

ActiKnow Consulting
New Delhi, India
01.2020 - 08.2020

Project – Customer Analytics

  • Automated sales pipeline visualization, reducing manual work by 68% using SQL and data visualization on 2M+ rows.
  • Boosted monthly revenue by 30% QoQ through partnership with CCO to develop data-driven go-to-market strategies.

Project – Marketing Analytics

  • Identified $2M in sales opportunities for 60+ sales reps by creating and launching whitespace and greenfield model.
  • Developed and sustained data-driven visualizations using Tableau, providing business partners with average of 4-5 insights per visualization on key metrics and performance indicators.

Full Stack Web Developer Intern

Wildnet Technologies
Noida, India
05.2018 - 07.2018
  • Wrote production-ready code with fluency in modern front-end and back-end frameworks.
  • Assisted with creating cross-platform UI web components and built 13+ responsive applications using front-end frameworks.
  • Used software tools in cooperation with continuous integration and test automation and supported software reuse and refactoring.

Education

Master of Science - Business Analytics

University of California San Diego
San Diego, CA
08.2021 - 12.2022

Bachelor of Technology - Electrical & Electronics Engineering

GGS IP University
New Delhi, India
08.2017 - 07.2021

Skills

  • Data Collection & Analysis
  • Statistical Modeling, Machine Learning
  • Python/R, Tableau, SQL
  • Cross-Functional Collaboration
  • Pandas, Hadoop
  • Data Visualization
  • Strategic Planning
  • AWS, MS Office Suite Spark
  • Snowflake, ETL, SAS
  • Data Modeling Design

Timeline

Data Science Intern

Apex146 Ltd.
2022.07 - 2022.11

Master of Science - Business Analytics

University of California San Diego
08.2021 - 12.2022

Business Intelligence Analyst Intern

ActiKnow Consulting
01.2020 - 08.2020

Full Stack Web Developer Intern

Wildnet Technologies
05.2018 - 07.2018

Bachelor of Technology - Electrical & Electronics Engineering

GGS IP University
08.2017 - 07.2021

Projects

Project – Applications of ETL in Retail Industry

  • Implemented Data warehouse using Python, Snowflake, and Tableau to optimize data reporting for a retail company.
  • Resulting in 65% faster processing and 80% reduction in errors

Project – Experimental Design to find Optimal Job Search Strategy

  • Conducted A/B testing to evaluate the impact of including a portfolio link in resumes on call conversion rate.
  • Resulting in an average increase of 15% in conversion rate by including portfolio link in resume.

Project – Pricing Analytics of Hardware Subscription Model Pricing

  • Executed a Van Westendorp Pricing survey to determine optimal pricing for a potential iPhone hardware subscription model, resulting in a +15% increase in revenue.
  • Developed a launch strategy for the subscription model by analyzing current pain points and user journey, resulting in a +25% increase in customer satisfaction.
ARNAV AGARWALData Scientist