Adarsh Kumar

About Adarsh Kumar

3 years of professional experience in information technology with an expert hand in the areas of Power BI, Advanced Excel, SQL Server, Data Analyst, Data Cleaning, ETL Mythology.• Enthusiastic process-oriented Data Analyst with a keen attention to detail with good analytical and communication skills eager to leverage the current skill set and contribute to the team and organization success. Motivated to learn, grow and excel in the same field. • Proficient in creating complex DAX queries, Power Query, Bookmarks, Navigation and SQL.• Create Data Flows.• Proficient in advanced SQL queries, SQL formulas and functions to produce data driven reports, query optimization and analyzing data.• Implement row level security on data and understand application security layer models in Power BI, develop tabular/multidimensional models that are compatible with warehouse standards using M- Query.• Hands on experience in model development for reports, data transformations and Modelling using Power BI Query Editor • Create relationships between data and develop tabular and other multidimensional data models.• Experience in data gateway for data refresh• Handle complex data queries/client requirements with hands on experienced on tools and systems on MS SQL Server, Power Query, Power BI, Power Pivot and DAX for successfully designing, modelling, and implementing end to end power bi solutions.• Experience with Power Services and Power Apps. Good to have Power Automate knowledge.• Creating complex Dashboard in Power BI with various types of KPI, Standard Chart & Non Standard charts.• Adept in developing, publishing, and scheduling Power BI reports and to visualize various trends as per the business requirements• Be able to troubleshoot, do enhancements on existing reports and create new dashboards

Experience

1. Data Analyst

   Ladder India

   May 2023 — Present · Gurugram, IN

   Import the data in Power BI form various type of data source.• Develop visual reports, dashboard and KPI using Power BI Desktop.• Adept in developing, publishing, and scheduling Power BI reports and to visualize various trends as per the business requirements• Be able to troubleshoot, do enhancements on existing reports and create new dashboards• Created DML queries in SQL Server, including where, group by, having, and order by functions, as well as inner, full, left, right, and cross joins.• Designed and implemented data pipelines to process structured/non-structured data using ETLs, automated jobs and stored procedures in SQL Server.• Gathering data from primary or secondary sources, identifying patterns and meaningful insights from data by analyzing it to help drive better business decisions.

Education

• William Carey University, Shillong

  BCA

  2021 — 2023