Shubham Joshi Email & Phone Number

San Jose, Ca, Us

San Jose, Ca, Us

Mountain View, California, Us

Product Data Science/Advanced Analytics:- Championed EDA & Data Preprocessing in the org by templatizing scripts that visualized data using seaborn, checked and handled/eliminated outliers and nulls; clean data frames for regression and feature importance for analyses- Used Random Forests to identify at risk customer segments; implemented K-means for customer segmentation- Used Bayesian Probabilistic Testing approach that requires 50% lesser sample size and time to make faster decisionsProduct Analytics Engineering: - Restructured and optimized queries that accessed huge datasets (clickstream, payload, etc.); reduced execution and response times down to 20% that made 10+ analyst-layer tables more regularly available (also reduced failures)- Generated and maintained data pipeline templates for other analysts to fetch data from complex sources like clickstream and published them using Tableau and Qliksense that enabled leadership with actionable insights.- Coordinated with front end engineers and UI designers to come up with design plans that required embedding beacons on screens for capturing relevant information required for analytics

London, Gb

Marketing Science and Insights- Led the analytics for the Engagement Workstream- Performed A|B Tests for marketing campaigns across Acquisition, Retention and Engagement workstreams- Collaborated with cross functional teams to design A|B Tests; recommend actionable next steps for developing retesting/iteration/scaling strategiesData Engineering and Dashboard- Architected a pyspark job to run 3 days a week and fetch email campaign performance for 4 previous weeks; constructed data pipelines that required creating ad-hoc snapshots of large base data tables before executing the final query- Summarized the data by performing aggregations on Tableau and trained primary users of the dashboard to better understand different values and visualizations

London, Gb

Data Engineering- Developed SSIS pipelines, used C# and T-SQL(stored procedures) to perform ETL. Process Automation- Automated 15 business process and reduced up to 8000 hours of manual efforts across by designing & developing OOPS based solutions; designed databases and schemas to migrate excel based processes to SQL RDBMS

London, Gb

Syracuse, Ny, Us

Interviewed the client to elicit requirements and comprehended the problems faced by the client Devised data migration plans and prioritized tasks to ensure timely delivery by collaborating with a team of six members Conducted weekly internal and external meetings for planning future tasks and evaluating the progress of the assigned tasks

Syracuse, New York, Us

Analyzed a collection of messages and reviews to predict their behavior by composing datasets that assembled indicators, suggest tone of the sentences from the available texts and performing sentiment analysis.Incorporated Bag-of-words with TF-IDF for extracting features from document into numerical vector space model

Thane, Maharashtra, In

Participated in Design, Development, and Testing. Interacted with clients to understand the requirement. My work included modifying back-end stored procedures and writing complex SQL queries. Performed normalization and joins to reduce redundancy and optimize performance. I was also engaged in performing unit testing and do a Regression test with the real life data and match the existing Manual System/Legacy System. The solution environment included operating upon Oracle 11g Express Edition.

Completed 3-months internship in Jackfruit & Mango Media Pvt. Ltd. as a Web Development Intern for the website of a Pharmaceutical Company. My training comprised of gaining expertise in the web development tools like SQL, XML and CSS to develop dynamic professional websites. I was also responsible for understanding the client requirements and desktop support.

Master Of Science (M.S.), Information Science/Studies

Bachelor Of Engineering (B.E.), Computer Science