Shrey Arora

Work Experience

Tesla, Fremont CA

Data Engineering Intern

Aug 2023 – Dec 2023

• Developed Lexicon, an automated data dictionary mapping tool integrated with Code-X CI/CD, utilizing Apache Airflow for deployment. Achieved 85% accuracy in mapping data-mart columns to pipeline sources and displaying results on ZIPLABS dashboard through hierarchical recursive queries.
• Worked on proof-of-concept to transition ETL data pipelines storing Apache Kafka streaming data from Vertica to Clickhouse database, optimizing resource usage and advancing toward a scalable in-house solution.
• Developed an ETL pipeline for packaging data mart table, alongside ODS and STAGE layer tables in Vertica database. Deployed the pipeline on Apache Airflow for efficient data processing and management.

American Express, India

Analyst - Risk & Info Management

Aug 2023 – Dec 2023

• Developed forecasting machine learning models using Python(Numpy, Pandas, Sklearn) for predicting transaction volumes and setting quarterly targets for the Sales and Account Management Team.
• Created new triggers, built data quality checks, analyzed big data using Pyspark and provided actionable insights for lost transaction volume, which led to a 30% reduction in annual lost charge volume.
• Optimized SQL queries and ETL scripts that reduced data pre-processing time by 2 hours, which earned me a Strategic Mindset Recognition.

Prione (Amazon), India

Business Intelligence Analyst

Sep 2020 – Sep 2021

• Conducted root cause analysis on success metrics of onboarded vendors, leveraging exploratory data analysis techniques and A/B Testing to understand the web behaviour of end customers which improved annual Sales and Views by 40%.
• Created dashboards and visualizations, and maintained data pipelines using Python, SAS, Airflow and Tableau that helped the pricing and performance insights team in data-driven decision-making in tracking churns, sales and transactions.
• Created data visualizations for weekly business reviews and other ad-hoc projects using matplotlib, seaborn and BI tools like Tableau and QlikView, which enabled real-time visibility of metrics for team leads and external stakeholders.

Happay (CRED), India

Data Scientist

Jun 2019 – Sep 2020

• Developed a classification machine learning model trained on transactions, subscriptions and user profiling features, performed feature engineering and hypothesis testing, added complexity to model as needed that reduced churn by 28%.
• Created a K-means clustering unsupervised ML model that helped in prospecting clients for a new fuel card product by establishing priority scores which helped in increasing sales conversion by 35% from the expected number.