Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Adarsh Gupta

San Francisco,CA

Summary

Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.

Overview

7
7
years of professional experience

Work History

Data Engineer

Pax Labs Inc
07.2024 - Current
  • Designed and implemented data pipelines to enhance data processing efficiency.
  • Developed ETL processes to integrate diverse data sources into centralized systems.
  • Collaborated with cross-functional teams to define data requirements and specifications.
  • Optimized database performance through indexing and query tuning strategies.
  • Led initiatives to automate reporting processes, reducing manual intervention significantly.
  • Conducted regular data quality assessments to ensure accuracy and reliability of datasets.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.

Data Analyst

Client: PAX Labs, Employer: InfoObjects, Inc.
01.2019 - 07.2024
  • Worked on collecting the data from the Salesforce portal and cleaning the data to make it available for consolidation.
  • Worked on data profiling and pivoting the data using Excel to automate the depletion reporting process
  • Involved in migration of enterprise dashboards over to a new integrated BI tool in the company (Superset)
  • Used Dbeaver SQL tool to make updates in the data stored in Redshift
  • Involved in the data migration process from Redshift to Salesforce (making Salesforce a single source of truth for the data)
  • Worked on the Looker BI tool to visualize the data and make it available for the presentation.
  • Worked on Sales data to collect information from various brand partners to make it readily available for data improvement and final reporting
  • Worked on Excel and Google Sheet to perform various operations on the Sales Brand Partner and Market Share data
  • Automated the Executive Level Market Performance dashboards in Superset Viz. tool

Data Analyst Intern

UCSF
01.2018 - 06.2018
  • Performed quality checks on the data derived from APIs before processing and analyzing it.
  • Implemented Google Analytics on the website to analyze the data coming through the website
  • Designing the surveys related to patient’s questionnaire using the Qualtrics tool
  • Worked on data validation, and data profiling techniques to check for the integrity of the data.

Education

M.S. - Business Analytics

Golden Gate University
San Francisco, CA
09.2018

Skills

  • SQL, Superset, Looker, SalesForce, Python (intermediate), Airflow
  • ETL development
  • Data warehousing
  • Data modeling
  • Data pipeline design
  • Scripting languages
  • SQL expertise
  • Real-time analytics
  • SQL programming
  • Data analysis
  • Business intelligence
  • ETL processes
  • Data visualization

Timeline

Data Engineer

Pax Labs Inc
07.2024 - Current

Data Analyst

Client: PAX Labs, Employer: InfoObjects, Inc.
01.2019 - 07.2024

Data Analyst Intern

UCSF
01.2018 - 06.2018

M.S. - Business Analytics

Golden Gate University

Similar Profiles

CREATE PROFILE