Vinoth Kumar Dhandapani

-Developed and maintained infrastructure for various HELM entities, aligning with business requirements and utilizing Azure resources and ETL pipelines -Assisted internal colleagues by creating ETL pipelines based on business requirements, significantly reducing manual effort in report creation -Built ETL pipelines using Azure Data Factory, integrating data from source systems including SAP, Salesforce, IBM DB2, HubSpot, Eco Vadis, Internal Servers, and SharePoint

- Built ETL pipelines for new source systems like Personio, Retain and monitored and optimized old ETL pipelines. - Designed Data Warehouse with Azure Data Factory and Postgres DB which has data from Jira, Personio, HubSpot, Retain, and internal tools adhering to the business owners. - Helped the team in understanding the data and enabling them to create ad hoc reports.

- Improved data standards by creating data quality reports for each team with 35+ quality checks using PostgreSQL and Power BI - Built and maintained 4 + self-service BI (Power BI) apps that acts as an internal reporting system. - Performing Ad-hoc analysis for team-leads and top management

- Developed a mobile crop advisory app for farmers and gardeners with a new UX feature to assess its adaptability. - Conducted statistical analysis, including A/B testing, z-test, and confidence intervals, using the provided dataset to evaluate the usefulness of the new UX feature for new users and track business KPIs

- POC to predict payment scoring and improve the process in Buy Now Pay Later Markets (BNPL) payment score. - Developed a recommendation engine to predict (supervised ML Model) when the customer is likely to make payment and send personalized reminders based on it when ordering products online.

- Implemented end-to-end automated reporting system using Pentaho to create ETL pipelines, MySQL to store raw and production data. - Identified KPI and created an automated reporting system to analyze and visualize order and warehouse efficiency, and product insights using Tableau

- Derived insights and created elaborated report and visualizations on parts and product failures using Power BI - PoC delivered for new features and functionalities for improving aftersales product - Implementing data governance principles to reduce data transformation efforts from 3 steps to 2 steps - As product owner worked with business team on improvising features in the product for next release Projects: A Diagnostic tool to manage ECU in the vehicle. Implementing MS Dynamics as CRM Software.

- Created sales report and shared inventory insights with the sales team, warehouse team, and inventory team using Tableau - Elevated reporting practices by migrating from Excel/PowerPoint to Tableau, resulting in a remarkable 90% reduction in manual effort and enhanced data visualization capabilities. - As part of the digital transformation team, gathered requirements from the business team and created PoC , shared the requirement to IT team, & oversee the development until the product is used by end users