mandar mhatre

Data Analyst

Indiana University•  January 2024 - Present•  Bloomington, IN

Developed an ETL pipeline using Python, enabling near real time data ingestion, resulting in better resource utilization and increasing scope for scalability. Developed a comprehensive data warehouse using Snowflake, enabling efficient querying and reducing analysis time by 60%. Created dashboards using Power BI and utilized DAX to provide insights into volunteer performance and application metrics. Designed and implemented A/B testing protocols to evaluate the effectiveness of different training modules, resulting in a 15% increase in overall program efficiency. Generated comprehensive monthly reports on volunteer performance metrics, facilitating data-driven decision-making for program improvements resulting in a 20% improvement in average test scores.

Data Analyst

Energy Justice Lab•  August 2023 - December 2023•  Bloomington, IN

Developed dashboard using Dash and Plotly by integrating GeoJSON data with real-time outage data from service providers. Developed a data pipeline for ETL and data modeling using python, increasing data accessibility by 60%, enabling more granular service territories level analysis. Optimized data processing by leveraging Mapshaper to reduce polygon complexity, improving dashboard loading times by 70%. Developed a comprehensive data documentation suite, including data dictionaries and analytical reports, leveraging advanced Excel functions such as VLOOKUP and pivot tables, boosting data interpretability and a 30% increase in team productivity. Conducted code review to enhance code maintainability, resulting in an 85% reduction in bugs and improved overall quality.

Associate Software Engineer

GEP•  June 2021 - December 2021•  Mumbai, India

Automated inbound requisition mapping by extracting data from REST APIs and loading it into a SQL Server database, resulting in a 70% reduction in manual processing hours. Performed query optimization utilizing indexing, material views and window functions resulting in a 40% performance boost. Developed stored procedures to dynamically filter product data based on user-selected criteria, reducing load times by 50%. Worked with CI/CD pipelines leveraging Azure DevOps, deploying across multiple environments, ensuring 100% success rate for over 35 critical releases. Worked within a cross functional team under an strict Agile(scrum) environment leveraging JIRA and Confluence ensuring productive collaboration and timely completion of milestones.