Education

B.Tech. in Information Technology

CGPA: 8.93 / 10
July 2015 - May 2019
Relevant Coursework
  • Database Management Systems
  • Data Analytics
  • Mathematics
  • Data Structures & Algorithms

Online Certification

Google Data Analytics

Visual Analytics with Tableau

Essential Design Principles for Tableau

Fundamentals of Visualization with Tableau

Introduction to Data Science in Python

Dataiku Core Designer

Experience

Indium Software (Uber External)

September 2022 - December 2022

Senior Data Analyst

  • Prepared Uber KPI reports using SQL queries and Google Data Studio (GDS)
  • Automated metrics for experiments (XPs) using an internal tool called uMetric
  • Performed XPs using AB testing method to analyze merchant performance

Digital Product School

January 2022 - April 2022

Software Engineer Intern

  • Built the database and backend architecture for analysis of car battery data using PostgreSQL and Node.js
  • Dockerized and deployed the website on Google Cloud achieving for easy access to the product
  • Applied Scrum framework and developed the model over 12 iterations through git-workflows in cross-functional team and through collaboration with SAP Munich

ZS Associates

July 2019 - Dec 2021

Business Technology Analyst

  • Performed system setup of the Sales Crediting(SC) process using AWS Redshift, S3, EC2 using Agile methodologies
  • Automated sales force operations of a billion $ US pharmaceutical company of about 4500 sales rep which resulted in a cost reduction of 20% by mentoring a team of 5 members
  • Reduced manual intervention by developing an ETL pipeline to ingest data in AWS S3
  • Optimized complex SQL queries and performance tuning which improved database performance by 30%
  • Cleansed, prepared and analyzed HR data to calculate various employee engagement KPIs using Alteryx through 12 data points
  • Designed insightful Tableau dashboards to help the HR leads measure the effectiveness of the program
  • Engaged clients to gather business rules and administered the design process for 3 quarters

ZS Associates

July 2019 - Dec 2021

Business Technology Analyst Intern

  • Drafted detailed business rule documents, SOPs, and process flows for the development phase for 5 therapeutic areas
  • Expanded expertise in the US healthcare domain by working on IQVIA, Claims, Payer datasets

National Informatics Centre, Government Of India

May 2018 - June 2018

Summer Intern

  • Implemented JDBC based Student Exam Application form using Swing GUI and HTML

Projects

  • All
  • SQL
  • Tableau

YouTube Analysis

Netflix Stats

World Metro Systems

California Covid Housing

Chess Games Online

Unicorn Companies

Olympic Games

Leetcode SQL questions