Aravind kumar

Data Analyst Intern

GWC Technologies•  February 2022 - August 2022

#Analysed business in a thorough manner successfully created KPI's and Metrics for Customer profitability analysis .Generally as the result stakeholders can track the Return on investment and segregate profitable customers or business users. #Maintained and debugged LookML code, Built user-friendly Explores, Understand various datasets and associated schemas. #Strong Experience in Data visualizations, Scheduling and sharing Looks and dashboards, Table calculations, Looker expressions, Custom and advanced filters, Impacts of pivoting. #Maintained and debugged LookML code, Built user-friendly Explores, Understand various datasets and associated schemas.

SQL Data analyst

Tata Consultancy Services•  January 2019 - October 2020

#Automated Point of sale reconciliation of retail department with Bank statements by creating SQL packages which in turn reduce the manual reconciliation rate by 30%. #Report generation of the reconciliation data to found anomalies in the non reconciled data. #Improvement in automatic catering system and reducing the wastage of food by forecasting the trend of consumption. Implemented the logic in SQL to See the trend and add buffer or reduce the production. #Solved the long run problem of failure in reconciliation due to daylight savings and timezone of bank by introduce the separate logic through SQL.