Mehul Ahire

Research & Data Analysis

• Led the development of a data-driven inventory management system, optimizing stock levels across multiple distribution centers. Utilized SQL to extract, transform, and load (ETL) data from enterprise systems to reduce the stock discrepancies.

• Preprocessed and integrated structured and unstructured data from systems such as SAP, ensuring high data quality. Automated Excel-based reports using VBA for reducing manual effort.

• Conducted data audits using SQL queries to identify inconsistencies and discrepancies in datasets, improving data accuracy for reporting and analysis.

Data Science and Predictive Modeling

• Built predictive models in Python using scikit-learn and statsmodels to forecast transportation delays and optimize inventory planning, reducing late deliveries by 15%.

• Leveraged pandas, NumPy, and Matplotlib for exploratory data analysis (EDA) and trend visualization, identifying inefficiencies in supply chain operations.

Data Visualization / Reporting

• Designed and implemented interactive dashboards in Tableau to monitor key metrics for the EU MDR Program, providing real-time visibility into regulatory compliance and operational performance.

• Collaborated with stakeholders to gather reporting requirements and ensure dashboards met business needs, enhancing data-driven decision-making.

• Optimized logistics and customer service data analysis by integrating SQL-based queries into Tableau reports, streamlining data retrieval and visualization..

• Developed and delivered in-depth financial reports, interactive dashboards, and dynamic visualizations using Microsoft Excel and Tableau that resulted in increasing the reporting efficiency and faster decision-making process for the stakeholders.
• Developed custom visuals and templates in Power BI to enhance dashboard aesthetics, usability, and user engagement, leveraging Tableau's extensibility and customization capabilities.
• Leveraged Python libraries such as Pandas, NumPy and Matplotlib for advanced financial data analysis, statistical modeling, and data wrangling, enhancing data accuracy and uncovering actionable insights
• Designed and optimized data pipelines and warehousing solutions using SQL, Azure Data Factory, and Azure Synapse Analytics, streamlining data retrieval and integration processes to support real-time analytics
• Implemented Key Performance Indicator (KPI) analysis frameworks to monitor financial and operational performance which increase the operational efficiency.
• Articulated complex analytical findings to stakeholders through compelling data stories, detailed reports, and visual presentations, utilizing tools such as PowerPoint and Think-Cell, driving informed decision-making across multiple departments
• Conducted advanced SQL-driven data analysis, including regression modeling, hypothesis testing, and exploratory data analysis (EDA).
• Designed and executed A/B testing frameworks to analyze marketing campaign performance
• Used Google Analytics and Tableau to identify strategies that increased conversion rates and optimized campaign effectiveness
• Introduced basic machine learning techniques using scikit-learn for predictive modeling, forecasting financial trends, and generating insights for proactive business strategies
• Ensured data integrity, compliance, and security by adhering to best practices in data governance, utilizing Alation for data cataloging and Azure Key Vault for secure key management