Pavan Gajendragad

About Pavan Gajendragad

Accomplished business and data analyst with 10+ years of excellent Business/Data analytics experience including • Data modeling, Exploratory Data Analysis, Statistical Inference, ML and Custom ETL development. • Tableau Dashboard development on Ad Tech and Financial data. • Data-driven, fact-based strategy development, process optimization and execution. Programming Languages: R, Python, Spark, SQL, Perl. Database Technologies: Big Query, Redshift, PostgreSQL, Amazon Athena Presto-Hive, MySQL. Big Data Analytics Looker, Tableau, R-Shiny Cloud Infrastructure AWS (extensively used), GCP and Azure. Python libraries Pandas, NumPy, Matplotlib,scikit-learn etc Bug Tracking and Version control: JIRA, GitHub Productivity Tools: MS Office Suite (strong w/Excel & PowerPoint).

Experience

1. Data Analyst

   Cinarra Systems, Inc

   Nov 2016 — Present · Cupertino, CA, US

   Tableau: Built Tableau reporting infrastructure after evaluating other tools. Developed financial, product line and performance dashboards for consumption by all teams including CEO and CFO. Dashboards included cohort analysis, YoY product line performance, Revenue and overall market place performance with user level security. • Custom ETL tool development: End to end ETL tool design and development for data ingestion, pipelining and processing on hive-presto, amazon S3, PostgreSQL, ClickHouse. Created separate staging environment. For various teams. Followed Ralph Kimball Data Warehouse and Dimensional Modeling methodology. • Price Modeling: Optimized bid price and clicks for up to 4% improvement depending on the campaign types. Executed simulations models (regression models), in conjunction with offshore mathematicians, to test various product hypotheses • Machine Learning: PCA and K-Means clustering on foot traffic data to observe behavior patterns based on season, time of day, holidays, Industry. Data cleaning and Exploratory analysis done using Amazon Athena on S3. Built Spark framework infrastructure and used jupyter notebook for processing large dataset.

Education

• Visvesvaraya Technological University

  BE, Electronics and Instrumentation

  2000 — 2004

• University of Maryland College Park

  Masters, Telecommunications

  2006 — 2009

• Seshadripuram Main Pre-University College

  12th grade, Physics, Chemistry, Maths, Electronics

  1998 — 2000

• Seshadripuram Boys High School

  10 Grade

  1993 — 1998