Mangesh Chavan

Data Analyst with experience delivering data-driven insight and operational reporting for scalable application backends, integrating .NET-oriented development concepts to support RESTful API analytics and system performance monitoring. Strong skills in data analysis and statistical inference, data visualisation and storytelling, and SQL-based data manipulation and ETL, applied with ADO.NET-style patterns and complex SQL to improve reliability and productivity. Built dashboards and automated reporting pipelines that informed product and marketing decisions and reduced manual reporting time by X, while leveraging Azure-enabled workflows, in-memory caching (Redis) for faster data access, and AI tools (including LLMs) to enhance development quality; open to hybrid roles in Pune with health insurance benefits and ready to discuss current CTC.

Data Engineer - Datametica Solutions pvt. ltd. - Pune

(2020-01 - 2021-12)

• Developed and maintained SQL-based ETL pipelines to consolidate transactional and product data for reporting, using .NET-aligned data access patterns (ADO.NET-style connectors) to support scalable application data flows and improve system performance and reliability.
• Built interactive dashboards in Tableau to monitor core KPIs and presented insights to product and marketing teams; achieved adoption by X stakeholders monthly while exposing API-sourced metrics and caching frequently used extracts to reduce refresh latency.
• Conducted A/B test analyses and regression-based experiments to measure feature impact and guide roadmap prioritisation, leveraging RESTful API event data and Azure-hosted datasets to validate results and bolster reliability of findings.
• Automated recurring reports and scripts to reduce manual reporting time by X hours per week, using AI tools (including LLMs) to accelerate development and improve productivity, with lightweight Redis caching to minimise repeated queries.

.Net developer - Itboostup - Pune

(2018-01 - 2019-12)

• Designed data models and semantic layers to support self-serve reporting in Power BI, aligning schemas for high-performance backend consumption by .NET applications and ensuring reliability at scale.
• Partnered with finance and operations to translate business questions into analytics requirements and prioritized reporting requests, defining RESTful API specifications for data services and coordinating with development to streamline delivery.
• Optimised queries and table structures to reduce dashboard load times; improved query performance from X to Y by introducing indexing strategies and server-side caching, enhancing overall system performance and reliability.
• Produced monthly performance reports that informed budget allocation and contributed to a X% improvement in campaign ROI, incorporating Azure-based pipelines and API integrations to ensure timely, reliable delivery.

Computer Engineering - Computer Engineering - Vit (2019-06 - 2022-08)

Diploma in Computer Engineering - Computer Engineering - Mit (2016-08 - 2019-08)