Yash Khatavkar Email & Phone Number

Thane, Maharashtra, India

➤ Spearheaded NLP initiative of transforming unformatted customer and company level addresses into structured information by leveraging SpaCy for Named Entity Recognition; Reduced manual processing time by 15 hours.➤ Leveraged ArcGIS to geocode company and customer addresses, enhancing geo-spatial analysis; Reduced processing time by 40%. Computed distances to map nearest customers with branch. Boosted after sales service efficiency by 30%.➤ Implemented AWS Textract to extract essential customer details from invoices, resulting in a reduction of manual data extraction time by 20 hours per week, streamlining processes and enhancing efficiency in customer data management.

Pune, Maharashtra, India

➤ Implemented a Python-based ETL data pipeline for efficient handling of complex datasets. Extracted data via API in JSON, transformed with Pandas for CSV conversion and selective data mapping, reducing data processing time by 40%.➤ Performed data cleaning and preprocessing on a complex dataset using Python. Utilized Neo4j graph database for building intricate relationships by using Cypher; Conducted data visualization with Neo4j Bloom for strategic insights.➤ Developed 4 Tableau dashboards and 5+ metrics to analyze the performance of Indian Startups; Presented KPI trends by developing Executive dashboard that enabled real-time monitoring and identification of cross-sell opportunities.➤ Restructured SQL queries to import 50k+ JSON datasets into PostgreSQL, reducing data processing time by 40%.

Pune, Maharashtra, India

➤ Engineered a Product Scorecard Dashboard on Microsoft Excel and Tableau, regularly used by senior management for effective decision making, resulting in a 15% surge in business revenues, saving 17 hours of manual work each week.➤ Devised strategic data analysis to assess the business and geographic performance of products using QlikSense dashboards; Provided effective business actionable thereby boosting company’s overall product mix by 40%.➤ Designed an Industry Benchmark dashboard comparing financial KPIs of insurers for the senior management using Microsoft Excel, enabling real-time operational analysis, and saving 15 hours of manual work weekly.➤ Collaborated with cross-functional teams to develop Bite-Sized Insurance. Conducted product-level analysis using Microsoft PowerBI; Researched and Analyzed product performance of competition comprehensively.➤ Devised business-intelligence reports on Microsoft Excel, providing business actionables to senior management.

Mumbai, Maharashtra, India

➤ Brainstormed new and creative growth strategies.➤ Designed and maintained our social media presence.➤ Measured and reported performance of all digital marketing campaigns, and assessed against goals. (ROI and KPIs)

Pune, Maharashtra, India

➤ Assisted in the pool campus recruitment process of MITSOM.➤ Assisted in a project survey suggesting improvements in the Common Application Form of Mutual Funds.➤ Attended client meetings along with my supervisors and provided insights about investing in Mutual Funds.

Mumbai, Maharashtra, India

➤ Assisted supervisor on a project on Mobile Number Portability (MNP).➤ Conceptualized different marketing strategies to increase in the port-ins of Vodafone and minimize the port-outs.➤ Organized and marketed a promotional event for Vodafone in relation to the Indian Premier League 2017.➤ Promoted and marketed a sim card exchange (SIMEX) campaign for Vodafone.➤ Conceptualized customer engagement programs.

Mumbai, Maharashtra, India

➤ Assisted in the preparation of the IIFL’s Annual Report.➤ Prepared a project report on the basis of Cash Flow Statement, Income and Expenditure Account and Balance Sheet of IIFL.➤ Vetting of documents and other statements.

Mumbai, Maharashtra, India

➤ Made accounting entries using Tally.➤ Analyzed Income Statements and Balance Sheets.➤ Attended matters before the Income Tax Department and made representations.➤ Attended a bank and stock audit for assessing the company’s financial position.

Mumbai, Maharashtra, India

➤ Assisted in preparation of cash receipts and bill books.➤ Drafted representations made to clients.

Master'S Degree, Business Analytics And Artificial Intelligence

Fall 2023 1.) Advanced Statistics for Data Science 2.) Business Analytics With R 3.) Database Foundations for Business Analytics 4.).

Postgraduate Degree, Data Science

Data Toolkit 1.) Data Analysis in Excel 2.) Introduction to Python Programming 3.) Python for Data Science 6.) Data Visualization.

Postgraduate Degree, Banking And Finance

Mg103 Consumer Behaviour: Behavioural Fundamentals For Marketing And Management

Bachelor Of Business Administration (Bba), Business Administration And Management, General

A Levels Cambridge International Examinations, Commerce