Aman Devrath

Software Engineer

Saint-Gobain India•  June 2019 - Present

---- Designed and published 15+ Tableau interactive dashboards using Tableau Public and Tableau Desktop incorporating bar graphs, scatter plots, maps, heatmap & other visualizations. ---- Constructed 30+ interactive filters, parameters and calculations for dashboards and worksheets in Tableau. ---- Processed Python and SQL to understand, transform, clean 70,000+ records from JIRA leading to improved efficiency in all processes. ---- Leveraged JIRA ticket data by performing EDA and built a PowerBI Dashboard that delivered significant business solution resulting in a 25% increase in ticket resolution ---- Collaborated as an integral part of a team to develop a Multi-Brand Customer Portal aimed at streamlining appointment bookings for 432 Showrooms throughout France, with the objective of reaching 120,000 annual appointments. ---- Incorporated the Microsoft Graph API into the system to enable real-time calendar management for showroom Managers and Salespersons, integrated Faxbis for sending SMS notifications. ---- Leveraged REST API Services from SAP Hana and SAP to efficiently retrieve data of 432 Showrooms and identify showroom members. ---- Developed a KPI reports application with OutSystems 11 which expanded user base from 2 to 55 resulting in 90% of reduced manual work. ---- Collaborated with a team to develop an OutSystems application with 2000+ user base facilitating the sale of tickets for French league football matches across 3 different leagues. ---- Resolved 13+ different Code Analysis Patterns in Architecture Dashboard for a Reactive Application using OutSystems 11. ---- Development of Short POCs for a Tablet Application which handled Construction vehicles for 300+ showrooms across 18 French Agencies and their construction materials.