Ashutosh Kumar

Experience

• 

  AnalytixLabs

  Nov 2020 - Sept 2021

  Trainee Analyst AnalytixLabs

  As part of trainee, I am working on different assignment on Excel, SQL, Tableau, R, Python and also worked on multiple projects pertaining to marketing analytics and Risk Analytics PROJECTS UNDERTAKEN Microsoft ExcelProject 1: Sports event analysis and reportingProject 2: Airlines data analysis and reportingLearnt and executed how to standardize the dataset, data formatting, summarizing the data via Pivot Tablesand Excel functions and generation of interactive KPIDashboard throughout the project. Microsoft SQL ServerProject 1: Retail Store in USA Project 2 :CellPhone Store in AustraliaAim for retail store was to understand customerbehavior using their point of sale via three differenttables provided in the dataset. Schema was alreadygiven along with the data set. Target for phone storewas to understand state wise sales behavior of storeprovided with a dataset consisting 06 various tables byClient, created a Schema of all 06 tables to identify thedifferent types of KEYS and further Analyzed the datausing full SELECT Statement.TableauProject 1: Leading Retailer of SportsEquipment across Globe Project 2: LaptopRetail Chain in LondonSports Equipment: Examined combined revenuegenerated in given year across different countries;facilitated dynamic and interactive storyboard fulfillingthe business context. Laptop Retail Chain: I wasprovided with dataset of 03 different tables leading tobuild a relationship between them and to createinteractive client centric KPI storyboard visualizing thesummary of data facilitating client to understand thevisualization. Show less

• 

  Nokia

  Sept 2021 - Sept 2023

  Power BI Developer

  Responsible for designing, developing, and implementing business intelligence solutions using Microsoft Power BI.Key responsibilities include:• Gathering and analyzing data from multiple sources to create data models and visualizations.Designing and implementing reports, dashboards, and interactive data visualizations.Integrating Power BI with other tools and platforms, such as Microsoft Excel, SQLServer, and SharePoint.• Collaborating with stakeholders to understand their business requirements and provide appropriate BI solutions.• Performing data quality checks and ensuring data accuracy.Maintaining and updating existing reports and dashboards.Troubleshooting and resolving technical issues related to Power BI.• Staying current with the latest PowerBI features and technologies, and making recommendations for improvements. Show less

• 

  OrangeMantra

  Oct 2023 - Nov 2024

  Power BI Developer
• 

  Air India Limited

  Nov 2024 - now

  Senior Engineer