Pulkit Gupta
Senior Analyst, Data Science Analytics at Tapestry- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Intermediate SQL
DataCampJul, 2021- Nov, 2024 -
PMC Level I
Pragmatic InstituteMay, 2021- Nov, 2024 -
SQL for Business Analysts
DataCampApr, 2021- Nov, 2024 -
The Complete SQL Bootcamp
UdemyOct, 2019- Nov, 2024 -
Excel 2016 Essential Training
Lynda.com
Experience
-
Tapestry
-
United States
-
Retail Apparel and Fashion
-
700 & Above Employee
-
Senior Analyst, Data Science Analytics
-
Jan 2022 - Present
-
-
-
CipherHealth
-
United States
-
Hospitals and Health Care
-
100 - 200 Employee
-
Senior Data Analyst
-
Apr 2021 - Sep 2021
- Used SQL to filter through 2 million patient encounters from 50+ hospitals to assess product efficacy in reducing patient readmissions. Developed 3 case studies (Inpatient, CHF and COPD) showcasing highly favorable results and presented findings to company and executive leadership. Data is now utilized for sales, marketing, and customer success efforts to increase sales and reduce customer churn.- Improved and automated the majority of a manual analysis process by using SQL queries to create efficient raw data exports and Javascript to transform raw data into full powerpoint with charts, tables and chi-squared tests. This automated process reduced time to deliver readmissions analyses 90% from 40 hours to 4 hours.- Improved SQL query process across analytics and data engineering by developing regular code-reviews and knowledge sharing meetings to increase code and process efficiency.- Built internal reporting dashboards using Google Data Studio that merges Centers for Medicare & Medicaid Services hospital data (HCAHPS and Readmissions) and current customer data resulting in clear and accessible historical data that is utilized by customer success and analytics team. Show less
-
-
Data Analyst
-
Jan 2020 - Apr 2021
Given the instant Impact award for 2020.- Delivered 50+ narrative-driven analyses for clients by matching raw patient-level datasets (including EHR and HCAHPS) and company data to demonstrate the value of CipherHealth’s products. Utilized SQL, R and Excel.- Designed and implemented product specific customer benchmarking, enabling customer success team to measure and compare client’s performance on a quarterly basis.- Built macros using Javascript and Excel to automate custom data reports, reducing processing time from 10 hours to 5 minutes.- Developed a text-mining process for patient level comment data using R code that analyzed patient feedback, resulting in increased efficiency. Show less
-
-
-
Attune
-
United States
-
Insurance
-
1 - 100 Employee
-
Accounting Associate, Data Focus
-
Jul 2019 - Jan 2020
- Built a macro that automated a manual billing process and drastically reduced human error, cutting processing time from 50 hours to 3 hours. Utilized Javascript, Google Scripts, and Google Sheets. - Analyzed 50,000 transactions using R language to discover trends in customer behavior. Delivered an interactive dashboard in Tableau with findings and solutions. - Built a macro that automated a manual billing process and drastically reduced human error, cutting processing time from 50 hours to 3 hours. Utilized Javascript, Google Scripts, and Google Sheets. - Analyzed 50,000 transactions using R language to discover trends in customer behavior. Delivered an interactive dashboard in Tableau with findings and solutions.
-
-
-
Code The Future
-
United States
-
Education Administration Programs
-
Co-Founder
-
Aug 2018 - Jan 2020
- Researched and implemented educational programming software, creating new products for business. - Utilized WIX and JavaScript to build website and payment portal, streamlining customer acquisition process. - Text mined 2,000+ school websites and discovered trends in industry, focusing sales strategy. - Researched and implemented educational programming software, creating new products for business. - Utilized WIX and JavaScript to build website and payment portal, streamlining customer acquisition process. - Text mined 2,000+ school websites and discovered trends in industry, focusing sales strategy.
-
-
-
The College of New Jersey
-
Higher Education
-
700 & Above Employee
-
Undergraduate Data Analytics Researcher
-
Nov 2018 - May 2019
- Created an automated process for data extraction and analysis of scholarly articles in R Studio. - Utilizing R Language, text and data mined 10,000+ scholarly articles from scholarly databases. - Libraries used: dplyr, ggplot2, fulltext, tm, wordcloud, tidyr, ggmap, etc. - Created an automated process for data extraction and analysis of scholarly articles in R Studio. - Utilizing R Language, text and data mined 10,000+ scholarly articles from scholarly databases. - Libraries used: dplyr, ggplot2, fulltext, tm, wordcloud, tidyr, ggmap, etc.
-
-
-
KPMG
-
Canada
-
Accounting
-
700 & Above Employee
-
Asset Management Tax Intern
-
Jun 2018 - Sep 2018
- Cleansed and Organized 50+ 1065 and 100+ K-1 documents, increasing team efficiency. - Ensured time-sensitive tax compliance for 15+ Fortune 500 clients, enhancing principal’s productivity. - Created custom reports using Excel, analyzing financial data to ensure the accuracy of tax reporting. - Utilizing GoSystems Tax RS, researched and improved data quality to increase customer satisfaction. - Cleansed and Organized 50+ 1065 and 100+ K-1 documents, increasing team efficiency. - Ensured time-sensitive tax compliance for 15+ Fortune 500 clients, enhancing principal’s productivity. - Created custom reports using Excel, analyzing financial data to ensure the accuracy of tax reporting. - Utilizing GoSystems Tax RS, researched and improved data quality to increase customer satisfaction.
-
-
-
Elementary Robotics
-
United States
-
Education Administration Programs
-
Independent Finance Contractor
-
Jan 2018 - Jun 2018
• Utilizing Quickbooks, consolidated 2017 bank transactions and streamlined accounting processes. • Developed data-driven market sensitivity analysis to support informed pricing decisions. • Conducted quantitative analysis of financial data to forecast revenue and assess business model viability. • Utilizing Quickbooks, consolidated 2017 bank transactions and streamlined accounting processes. • Developed data-driven market sensitivity analysis to support informed pricing decisions. • Conducted quantitative analysis of financial data to forecast revenue and assess business model viability.
-
-
-
HBK CPAs & Consultants
-
United States
-
Accounting
-
300 - 400 Employee
-
Tax Intern
-
Jan 2018 - May 2018
- Using UltraTax and QuickBooks, analyzed 100+ US Federal 1040 and State income tax returns. - Working in a team of 4, researched technical tax compliance laws, ensuring accurate tax compliance. - Using UltraTax and QuickBooks, analyzed 100+ US Federal 1040 and State income tax returns. - Working in a team of 4, researched technical tax compliance laws, ensuring accurate tax compliance.
-
-
-
pH Balance Skincare
-
Trenton, New Jersey
-
Web Marketing Specialist
-
May 2017 - Oct 2017
- Utilizing Mailchimp and Social Media platforms, built and executed several marketing campaigns. - Developed and executed SEO strategy utilizing Google Analytics resulted in 3,000+ visitors. - Utilizing Shopify and Adobe Premier Pro, created website and video marketing content, increasing sales. - Utilizing Mailchimp and Social Media platforms, built and executed several marketing campaigns. - Developed and executed SEO strategy utilizing Google Analytics resulted in 3,000+ visitors. - Utilizing Shopify and Adobe Premier Pro, created website and video marketing content, increasing sales.
-
-
-
Microlight Media
-
United States
-
Co-Founder
-
Jan 2017 - Sep 2017
• Demonstrated entrepreneurial skills by closing 3 client contracts worth $3,500 to develop marketing collateral. • Created business plan including comprehensive financial statements with 3-year projections. • Utilized Adobe CC to create specialized multimedia packages for clients. • Demonstrated entrepreneurial skills by closing 3 client contracts worth $3,500 to develop marketing collateral. • Created business plan including comprehensive financial statements with 3-year projections. • Utilized Adobe CC to create specialized multimedia packages for clients.
-
-
-
Wawa, Inc.
-
United States
-
Retail
-
700 & Above Employee
-
Customer Service Representative
-
Aug 2015 - Aug 2016
• Maintained high standards of customer service during high-volume, fast-paced operations. • Maintained high standards of customer service during high-volume, fast-paced operations.
-
-
-
UPS
-
United States
-
Truck Transportation
-
700 & Above Employee
-
Christmas Helper
-
Dec 2015 - Jan 2016
-
-
-
Saker ShopRites, Inc.
-
United States
-
Retail Groceries
-
200 - 300 Employee
-
Cashier
-
Jun 2015 - Sep 2015
-
-
Education
-
The College of New Jersey
Bachelor's degree, Accounting and Information Technology