Aakash Patil

Experience

• 

  Yulu

  Dec 2019 - Apr 2021

  Demand Prediction and Optimization: Developed a central demand prediction model by aggregating city-level data and predicting trends across warehouses, traffic, and logistics. Leveraged MySQL and Excel to optimize bike allocation, maximizing operational efficiency and minimizing costs.Team Management and Ground Operations: Managed a team of 18-20 field personnel in Delhi and Pune, overseeing ground operations such as relocation, recovery, and screening. Implemented strategic measures to ensure smooth operations and improved overall team performance.Data Analysis and Fleet Management: Created custom workflows, queries, and processes for various teams using MySQL (Sprinkle) and Excel. Analyzed city-level trends with the central data team to employ data-driven strategies, enhancing fleet management and productivity for the Delhi team. Show less

  • Operations Specialist

    Feb 2021 - Apr 2021

  • Operations Associate

    May 2020 - Feb 2021

  • Operations Analyst Intern

    Dec 2019 - May 2020
• 

  Mettl

  Apr 2021 - May 2022

  Analyst, Marketing Strategy and Growth

  Data-Driven Performance Analysis: Provided comprehensive analytical support by creating dashboards using SQL and Excel to monitor data quality and analyze performance metrics. This facilitated informed growth decisions and business reviews, driving strategic improvements.SEO and Organic Growth: Achieved 80% organic growth across blog, website, and YouTube channels by implementing advanced SEO techniques, including backlink acquisition and regional optimization. Utilized Google Analytics to track and enhance SEO efforts.Website and Project Management: Took full ownership of the global Mettl website's growth, overseeing design, content refinement, and deployment. Successfully managed the development of a testing application, coordinating with web development and UX design teams for seamless execution. Utilized multiple web analytics data points to benchmark, measure, and improve online campaigns, while ensuring timely delivery and efficient resource allocation. Show less

• 

  G2

  May 2022 - Aug 2024

  Data Analytics: Leveraged Python, R, SQL, Google Sheets, and Sigma Computing to perform extensive data assessments, from extraction to presentation, enhancing customer value and operational efficiency.Key projects included developing an ROI Calculator model that processed ~2 million rows of customer pipeline data using R and SQL, delivering actionable insights into customer ROI from G2 offerings.Revenue Impact & Customer-Facing Solutions: Influenced ~$9 million in revenue by delivering over 300 customer-ready data assessments and value presentations. Provided technical consultations and data-driven insights on product integration and API workflows, empowering customers to operationalize G2 data effectively and optimize Martech utilization.Process Automation & Development: Generated automated presentations for Sales and Partnerships teams using Matik, SQL and Looker. Developed SQL queries and robust data models on Snowflake Data Warehouse for internal teams. Show less Automation and Development Impact: Streamlined presentation generation for Sales and Partnerships teams by implementing automation solutions using Matik, SQL, and Looker. Designed and executed efficient SQL queries and developed robust data models within the Snowflake Data Warehouse.Data-Driven Analysis and Strategic Insights: Harnessed Python, SQL, and Google Sheets to perform comprehensive data evaluations. Employed the same skills for multiple impactful projects to enable customer success and prove value in G2's offerings. Show less

  • Solutions Consultant

    Apr 2023 - Aug 2024

  • Data Analyst - Solutions

    May 2022 - Apr 2023