Ayushi Gupta

Managed Services (ARZ client) involves acknowledging tickets within SLA/ Customer update every 2 days. Worked on customization request from client under enhancement days. Created Talos Report from Smart Reporting and Talos (Created views and reports on Smart Reporting and run data on Talos. Created final Power BI reports.). Attending weekly calls for customers to understand their requirements and providing updates on all issues. Talos/Power BI Project: Worked on creating internal Golden data set and creating the Power BI reports to analyze the correct working scenario within the team. Expertise in Smart Reporting, AI Talos, Tableau, Advanced Excel, Power BI, Python. Worked on ARZ Power BI and tableau reports. Created the views and reports from Smart Reporting and Helix Dashboards. Run AI Talos on the reports from AWS instance. Changing date format, removing extra lines and spaces, removing the empty columns, removing special characters calculated other fields required. Finally created Power BI reports for INC_Categorization, MTTR Insights, Heat Maps, Clustering overview, Product Relationships, Foundation and Data Quality. As Data Analyst: Data Visualization with Tableau, connecting to various data sources, Joins, relationships, union, data blending. Working with metadata in Tableau, Dimensions and Measures, Discrete and continuous and different filters. Creating Charts and Graphs, doing calculations, LOD, Include LOD, Exclude LOD, Fixed LOD and Nested LOD. Creating Dashboards and Stories with Tableau. Working with Advanced Excel to clean data using sort and filter, Group By, Subtotal, Text to Column, Removing Duplicates, Data Validation. Performing Lookup and reference functions with Excel like VLOOKUP, HLOOKUP, MATCH, INDEX and OFFSET and statistical function. Using Macros, Histogram, Solver Add in, Goal Seek, Data Table, Moving Average, Hypothesis Testing, ANOVA, etc. Worked on the project with Python to load data file using pandas, cleaning the data and removing