Asutosh Khadanga

Data Analyst @AGL - Hakuhodo

Gurugram, IN

Experience in interacting with various business stakeholders and able to gather the business specifications and translate into data visualizations for effective decision-making. Well understanding the business requirements, gathering the business solutions, and creating the Technical and Functional documents as per client request sheet. Extracted the data from non-database sources (XLS, CSV file), Database sources (SQL Server & Treasure Data) and Developed Visualizations by using Power Bi. Developing the Dashboards using different Business KPIs on the basic of YTD, MTD and YOY etc. Working on Row-level security (RLS)in Power Bi. Experienced in creating different visualizations using Bars, Lines, Pies, Maps, Graph, Bubble, Tree Map and Histogram. Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data. Developed SSRS reports and effective dashboards after gathering and translating end user requirements. Publishing reports into Power BI Service, Managing Gateway for refreshing the data sets. 10.Good knowledge on data warehouse concepts Star Schema/Snow flake Schema (Establish relation between Dimension table and Fact Table). 11.Analytics strategy and solution for India\'s Largest Automotive Company to increase campaign leads and revenue. Proficient with Excel features, functionalities and formulas used for creating MIS, Dashboards, and Reports for Business. Extensive knowledge Formulas, Conditional formatting, Pivot table, Slicer, Charts, Data Validation,Data Visualization, Dashboarding, MIS and Report Creation in Excel. Excellent at writing SQL queries involving Select queries, Where, Having, Wildcard, Group by, Order by. Handling Users Access & Users Policy Management In Treasure Data Across The Organization. Managing Weekly & Monthly Report on Workflow,Docker (Custom Scripting), Hive And Presto Utilization in Treasure Data.

Centurion University of Technology and Management

B.tech