Yash Shah

For a Top 4 Telecommunications Conglomerate: Self Service Data Platform • Acting as co-Solution Owner and leading the Discovery effort for over 80 use cases across Field Operations, Product Engineering, Product Pricing, Sales, Retention and more. • Collaborating with Data Engineers, Platform Engineers, Business Owners, Analytics Leads and Domain Experts to setup the platform for long term success. For a Top 4 Telecommunications Conglomerate: Service Visit Reduction • Led a Data Science pod to find pathways to reduce annual Service Visits by 300K • Created an interaction risk score that accounted for the end-end service visit workflow: modem signal health(RF) and outage clusters, call center performance, and technician routing. For a Telecommunication Conglomerate: Propensity Models • Built a model to determine propensity to upgrade to higher speed/product tiers for Business Line accounts and led the effort to move to AWS while improving model documentation (config files, model cards, source control etc.) across the marketing team.

For a Top 4 Telecommunications Conglomerate: Ad Spend Optimization • Set up automated analytics workflows and frameworks to improve insights sharing and time to action. • Built an outlier detection model to optimize and rebalance direct ad-spend in tandem with the in-house Analytics and Marketing orgs, as well as Media Agency partners. For a Multinational Tech Company: Scaling Self Service Analytics • Led working sessions with business users and the analytics team to align on methodologies and reporting POV's to enable consistent and repeatable workflows. • Performed ad-hoc data analysis to identify process gaps and data quality issues as part of a larger Salesforce build. • Scaled reporting capabilities for one of the business verticals to enable rollout of operational and compliance related org-wide changes. For a Multinational Media Conglomerate: Content Performance and Taxonomy Optimization • Unified Taxonomy: Leveraging AWS suite, built a data ingestion pipeline and topic extraction workflow (using BERT) to classify media content per industry standard taxonomy (IAB). This enabled the company to refine their analytics across verticals, enrich metadata and taxonomy tagging on the ad-platforms for better ad-content pairings to extract better CPMs, and optimize cross-brand content recommendations to boost impressions and engagement. Also ran tests to recreate a similar workflow using Google's Gemini, improving metadata contextual depth and consistency. AWS Proof of Concept: • Utilized AWS’s Media Replay Engine, SageMaker, Comprehend, Rekognition and S3 to create an automated video replay solution based on key segments, and presented this to media executives at and outside Slalom. Project Proposals: • Assisting leadership in scoping Advanced Analytics projects and drafting proposals, timelines, staffing plans, and deliverables.

For a Multinational Tech Company: People Insights and Analytics • Collaborated with the internal insights team to enhance data analytics and reporting capabilities, facilitating the transition from descriptive analytics to diagnostic analytics for several supported departments. • Managed the end-to-end data process: requirements gathering, scoping, building out data pipelines using Presto/Airflow, and creating data maps to enable reporting on new metrics. • Designed and developed multi-level dashboards in Tableau and CRM Analytics along with detailed user guides. For a Multinational Cosmetics Company: CRM Migration • Led the migration of data from Zendesk to Salesforce post-acquisition. • Conducted data modeling and reformatting to align it with parent company schemas. • Created a comprehensive data crosswalk, providing non-technical users clear visibility into data manipulations. Slalom's ESG Accelerator for Tableau: • Helped define key business questions, the right metrics with definitions, and source data. • The accelerator was submitted to Salesforce Inc. and is actively used by Tableau customers to help them give a head start on their ESG roadmap.

• Building an operationalized predictive maintenance model on AWS SageMaker for critical components using survival analysis, feature engineering and boosted random forest, to reduce downstream effects of unscheduled outages • Working towards creating a dynamic optimization model for S&OP and developing the data pipeline for the model in Snowflake and Talend Studio • Evaluated trends in inbound truck wait times and built a proposal on increasing data visibility to benefit all stakeholders • Built a Public Sentiment tracker based on Google Search results and Tweets using Python and PowerBI, to assist the PR team in tracking overall sentiment and short-term swings in score

Graduate course assistant for the class "Design Digital Operating Models". The goal of the course was to enable students to design data-driven digital strategies (ad revenue, viral growth, network effects etc.) and begin to manage digital teams and projects using models learnt throughout their core curriculum.

Helping Athletes navigate core subjects like Math, Calculus, Physics, Chemistry, Optimization, Mechanics and Biology so they can excel academically while being consistent on the field

• Scraped “Wealth Management” twitter data, to pin point what people and established competitors are talking about, and carried out sentiment analysis after separating out topics of interest • Designed a survey and analyzed 3200 responses to zoom in on people’s pain points with existing products and technology • Identified characteristics of coherent groups of people above a threshold WTP using clustering and feature importance techniques, in order to better target Facebook Ads and increase conversion rate while constraining acquisition costs

• Analyzed consumer data to design solutions for enhancing safety and rider confidence in the PATH transit system as New York re-opens, and determined leading concepts through focus groups and Voice of Customer surveys • Built a PowerBI dashboard for Talent Management to track satisfaction and sentiments of newly hired employees throughout their initial year, to ensure low staff turnover • Collaborated with Procurement to create value stream and customer journey maps to locate bottlenecks in the vendor contract conformance process for construction management, to standardize turnaround time and reduce it by 20% • Designed lean training sessions to equip project managers with the tools to successfully run their continuous improvement efforts

• Developed a model to calculate the COGS and efficiently select vendors that best fit requirements through a ranking system based on MOQ, Lead time, cost/unit, and package sizes • Forecasted short term demand using internal data and competitor trend data • Managed procurement and production cycles in collaboration with suppliers, co-packers, and warehouse manager

• Performed cross functional process mapping for physical inventory movement and corresponding information transfer in the SAP S4 HANA ERP system, to eliminate redundant activities and troubleshoot inventory tracking issues • Collaborated with line owners to define manpower standards and improve efficiency by 17% through time study methods • Created a Tableau dashboard using data from several IOT devices, which the Management team located across the world used to easily track important KPIs like production efficiency, volume, capacity utilization, and QC conformance rates

• Computed a schedule for internal inventory movement using simulations and transportation matrices, reducing waiting time of the fleet of vehicles by 4.6% • Facilitated a reduction in waste and error rate by applying the 5S quality improvement principles • Researched methods to automate assembly by analyzing impact of increase in throughput rate and NPV of the project