Amit Rawat Email & Phone Number

Gurugram, Haryana, India

Expertise in providing end-to-end business intelligence solutions using Tableau Desktop/Server.Interacted with business users in gathering, analyzing and documenting the business requirements and translate them into technical specifications.Build Tableau reports utilizing complex Calculated fields, Table calculations, Advance LOD’s, parameters & Sets and expertise in Data Blending, Joins, Filters and Actions.Expertise in creating highly interactive dashboards/data visualizations reports and Worked with end users in creating complex dashboards.Developed multiple reports/dashboards using Dual Axes charts, Histograms, filled map, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.Developed interactive KPI’s and Text tables.Well versed in using Multiple Data sources (Live and Extract both). Created various custom SQL’s and having Working knowledge on Data Joining, Data Blending, connecting to various data sources –Azure Databricks, SQL server & Excel.Modified ETL logic using Azure Databricks and written complex SQL queries as per the business requirement.Used ALM tool to deploy the dashboard in Production environment.Well versed in Tableau Server Content management security, involved in creating users & groups and assigning access levels on tableau server.Worked in all stages of BI full life cycles including analysis, design, development, unit testing, deployment, post-production maintenance, documentation and end-user training.

Gurugram, Haryana, India

Used SQL queries to gather the extra data apart from csv to gain the more insight of the data.Processing, cleaning, and verifying the data using Python.Performed exploratory data analysis.Performed Bivariate and multivariate analysis.Handled impurity of data like outliers, missing values etc.Performed various operations on dataset using different python functions.Used Tableau tool to visualize the data for better understanding.

Gurugram, Haryana, India

Responsible for data analysis using SQL and MS-Excel. Also, responsible for delivering reports and presentations to the relevant stakeholders and management.Used Application database server to resolve the data related issue and perform CRUD operation on live database for APAC, Europe, US and UK clients.Used SQL to fetch the data as per client requirement and share it with clients on daily basis within SLA.Shared the KPI and SLA report to the management on daily and monthly basis.Responsible for the team's roster and other management activity.Provided training to new associates and support them while facing any issue to resolve the application issue.Hands on multiple tools like ServiceNow, SQL managements studio, Excel, Jira tools etc.

Gurugram, Haryana, India

Provided application support to the applications users.Used Application database server to resolve the data related issue and perform CRUD operation on live database for APAC, Europe, US and UK clients.Resolved Application related issue and maintain its availability all the time.Participated in data migration activity on DR and Production server.Responsible for delivering weekly and monthly report to the stakeholders using MS- Excel.Involved in ticket creation using ServiceNow tool and resolve the tickets within SLA.