Pinak Kapoor

Data Analyst & Data Scientist

About Me

Hi, I'm Pinak. I'm a data scientist and data analyst with a background in Data Science and Economics.

I've always tried to make the best decisions I can with the data around me - from my early days as a sneaker reseller to now as a TPM/Data Analyst for Google (as a TVC).

I've been fortunate enough to be utilize the resources around me, and curious enough to seek out what's missing - and that has driven me to help make it easier for others to understand data, gather insights and better prepare themselves for our data enabled world.

Resume

Employment

Google (TVC)Mountain View, CA

2022 - Present

Helped enable analytics on Allegro Pixel Buds Pro for executive dashboard and slide deck to guide software development for internal and release builds.

Worked with various engineering teams and stakeholders to gather documentation on metrics, read proto code and understand the usage of their payloads to ensure that the end result was meaningful for the team to debug their software.

• Standardized SQL queries, with automated test cases and sample data checked into Piper/Google3 for a formalized review process, utilizing mock production log environments to build queries locally to circumvent access restrictions. Proficiency with Google tools: Cider, Test Fusion, Plx, Cloudtop, Blaze, Critique

AppDynamics, Inc. (a division of Cisco, Inc.) – San Francisco, CA 2020 - 2022

Performed deep-dives to clean 4M+ records of unstructured data, enabled automation on 30+ Tableau dashboards improving data quality, translated business needs into actionable requests

• Created SQL queries and performed end to end data analysis – from ETL to Data Visualization; helping guide executive decisions by providing detailed insights and presenting data to cross-functional teams.

• Built a close relationship with Sales, Finance, Marketing and HR stakeholders, meeting monthly and creating dashboards on a timely basis which aligned with their ideal vision.

Kaiser Permanente – Pleasanton, CA 2018 - 2020
Junior Data Analyst

Supported the business with end-to-end reporting and analytics solutions - from ETL to Data Visualization; helping guide executive decisions by providing detailed insights and presenting data. Built a close relationship with Sales, Finance, Marketing and HR stakeholders to ensure the data and visualizations aligned with their ideal vision.

Performed deep-dives to clean our data, enabled automation on dashboards, translated business needs into actionable requests, and led projects to successful completion and delivery.

Daily Collegian Amherst, MA 2017 - 2018
Website Managing Editor

Built a digital community by increasing engagement over 250% in three months, engaged and empowered editorial staff, and enhanced content by serving as a technical copy-writing liaison, leading UX/UI improvements, introducing Google Analytics, and integrating with Apple News.

Managed site security and assured SLA compliance by systematizing front-end and back-end website monitoring.

Kaiser Permanente – Pasadena, CA Summer 2017
Web Development Intern

Performed full-stack web development and debugging, designed the back-end database, and performed extract/transform/load duties.

Created an end-to-end application to ingest Excel files and transformed them into a SQL database. Created a web application to index, display, and manipulate the databases.

SoleHoarder Los Angeles, CA 2016- 2017
Business Owner

Monetized the spread between new apparel retail pricing and digital market demand. Generated markups averaging 75-100% on an online, premium-priced apparel aftermarket store. Built retail relationships around revenue splits. Forecasted demand for new apparel designs prior to product launch and established retail-aftermarket resale agreements. Automated marketing and inventory management systems.

Generated $250,000 in revenue within four months. Ran social media analytics to identify and secure best-selling, newly released products and emerging trends.

Education

University of Massachusetts, Amherst – Amherst, MA Aug 2015 - Dec 2018

Bachelor of Science, Data Science, Economics; Minor: Information Technology

  • Honors: Dean’s Honor List; GPA 3.6

Relevant Coursework:

  • Calculus, Statistics, R, Python, Economics,

Technical Skills

Programming Languages: Java, C#, Ruby

Web Technologies: HTML, CSS

Database/Storage: SQL, R, Python, NoSQL, Oracle

Tools: Hadoop, Spark, Kubernetes, DataIku, Alteryx

Data Analysis: R, pandas, numpy, Keras, Tableau,

Machine Learning Techniques:
Super
vised Learning: Linear/Logistic Regression, k-NN, NLP, Decision Trees

Unsupervised Learning: Clustering