Yashwanth Kumar Yelamanchili

Key Responsibilities: 1. Work with organizations to solve current, emerging, and other interconnected problems with the help of data and analytic tools/ technologies 2. Conduct training and informative sessions on leveraging analytics for local organizations 3. Support data science/ analytics events and symposiums Key Projects: 1. Worked with a local brewery on market expansion, e.g. introduction of existing products in new markets, the introduction of new products in existing markets, etc. - Provided forecasts, competitor analysis, and recommendations 2. Worked with an HR firm on a customer segmentation project to increase the effectiveness of cross-selling - Provided recommendations on what kind of services can be bundled together

In my role as an apprentice leader, I was responsible for managing a $2.5M portfolio for a leading global provider of water, hygiene, energy, food, healthcare technologies, and services. I collaborated with cross-functional teams to identify growth areas in business, convert business requirements into analytical problems, design analytical solutions, and communicate actionable insights to the business stakeholders. Key Responsibilities: 1. Engaging with different business groups and formulating solutions using analytical tools to realize their immediate and long-term outcomes 2. Co-create a transformational roadmap and implementation strategy along with the client (collaborate with clients on how to conceptualize, design, and execute analytical programs) to drive measurable business outcomes 3. Build multi-tier client connects, pursue business development opportunities to maximize revenue 4. Managed a team of 16 data analysts and groomed them in technology and business aspects of solution design Key Projects: Pathogen Prediction Model: o Predicted the presence of Legionella bacteria in industrial cooling towers and classified them into low-risk, medium-risk and high-risk o Data from controllers was combined with external data and inputs from subject matter experts to identify drivers. o Used a decision tree-based algorithm to understand multiple scenarios and achieve higher accuracy o Created a comprehensive dashboard for both business leaders and asset managers to ensure pro-active action across 20k+ sites globally Condenser Issue Prediction: o Identified condenser issues such as scaling, microbial fouling in industrial plants using Random Forest o Water telemetry data such as conductivity, PH, corrosion was monitored, and optimal parameter ranges were identified o Real-time alerts were sent to the field representatives and site engineers to redirect efforts towards critical sites to reduce asset downtime and save up to $2M annually per plant

In this role, I led a team of 10 business analysts through the intricacies of problem identification and solution implementation for the Marketing, Operations, and Customer Insight teams of a leading US airline. I was also responsible for maintaining client relationships from offshore, orchestration of ideation/ brainstorming sessions to drive the team towards operational excellence. Key Responsibilities: 1. Develop, customize and execute projects for individual client engagements as necessary 2. Business Development – Mining for new clients and providing support from pre-sales to operations - IoT solution to alert crew for pre-emptive check-in of bags when the overhead bins are full and thus reduce turn time by ~5% - NLP solution to classify and re-route customer grievance e-mails and thus reduce response time by ~85% 3. Train and strategize on technology, business intelligence, innovation & analytics framework to help clients embrace change and data-driven decision making 4. Mentor 10 data analysts in problem-solving, storytelling and aid them with their professional goals by providing regular feedback 5. Assist in hiring the right talent for the organization Key Projects: Social Media Engagement: o Tracked customer engagement across social media platforms to optimize shift timings of associates o Leveraged text mining to capture customer sentiment and identify critical issues, which led to quicker resolution and eventually a 3% point improvement in CSAT Customer Response Model: o Developed an 85% accurate decision tree in R to identify likely responders to marketing campaigns, which improved audience selection and led to a 2% lift in response rate Predictive Maintenance: o Leveraged data from sensors and manual logs to monitor and identify patterns in data o Performed predictive modeling to pre-empt operational defects arising from maintenance failures

As a data analyst, I was involved in learning operational and functional nuances of the Site Analytics, Marketing, Forecasting & Planning divisions of the E-Commerce wing of the world’s largest retailer. I also picked up different technologies that will help in the design and implementation of simple, yet optimized solutions for complex business problems. Key Responsibilities: 1. Work on various critical and time-sensitive ad-hoc projects 2. Familiarize with new tools and technologies to automate and streamline the existing processes in the team 3. Create business and analytical process flow documents to enable smooth transitions for new team members Key Projects: Forecasting for Category Managers: o Generated 90% accurate forecasts for key KPI’s such as visits, orders & revenue through ensemble modeling in R o Enabled category managers to optimize revenue allocation and goals, thus reducing the operational costs by 0.2% o Collaborated with Finance team to generate plan numbers and spread those at granular levels o Built a scenario builder tool in excel which enabled the business to easily compare multiple scenarios of Forecast vs Plan by maneuvering the levers of revenue E-commerce Strategies for Holiday Season: o Created an analytical roadmap to maximize revenue from the holiday season after understanding e-commerce strategies o Leveraged factor analysis to understand and provide recommendations on important factors affecting customer stickiness o Assisted stakeholders in taking crucial decisions by performing root cause analysis of business softness o Provided hourly performance report for various KPIs at various levels Website Design & Modification to Enhance Customer Shopping Experience: o Analyzed the flow of visitors on the website to enable smooth transitions and improve overall customer experience o Redesigned the website and analyzed impact through multivariate testing which resulted in a 0.8% increase in site traffic