Inventory Management and Customer Services

• A Designed, developed, and tested various Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.• As a Power BI and Tableau SME responsible for the design, development and production support of interactive data visualizations used across the company.• Extracted data from USM system by creating bash script and writing SQL queries• Automated XML to CSV conversion & auditing of data using Python script thereby improving efficiency by 95%• Fixed structural errors, filtered outliers, handled missing data and created calculated fields using Python libraries like Pandas and Numpy on the dataset having 6k+ rows• Designed dashboards with Tableau to showcase performance of different stations with area wise drill down• Analyzed data extracted from different sources thereby figuring out data logging issues for 67 parameters using Python and VLOOKUP, Pivot Tables in Excel