Aman Kumar

Experience

• 

  Chegg Inc.

  Jan 2021 - Jan 2022

  Digital Content Analyst

  - Conducted market research studies and provided insights to support marketing strategies.- Regularly evaluated digital performance and recommended improvements to optimize online presence.- Led web page redesign projects and social media revitalization efforts.

• 

  AWC Software

  Jan 2022 - Jan 2022

  Power BI Associate

  · Preparation, Reporting, and Maintenance - Responsible for preparing, reporting, and maintaining daily, weekly, monthly, and ad-hoc reports using Power BI.· Power BI Integration - Integrating Power BI with SQL Server and Excel and Fetching necessary tables, preparing modules, creating reports, dashboards, and publishing them to the Power BI Service Portal.· Data Modeling - Identifying columns for primary keys in all tables during the design phase and Creating star schemas for data modeling. Working in a relational database and managing relationships between tables in Power BI.· Cube Management - Adding new dimension tables and measures to existing cubes and Defining relationships between measure groups and dimensions.· Agile Methodologies - Implementing Agile methodologies to formalize activities and ensure greater agility. Show less

• 

  Astroyogi

  Dec 2022 - now

  Data Analyst

  · Created Reports – Worked on 20+ Power BI Reports by extracting complex data from multiple sources into usable and meaningful reports and analysis, performed data modeling, scripting, reporting, and making effective user interface design.· SQL Procedures – With expertise in developing 25+ stored procedures and crafting complex SQL queries, I bring a strong foundation in database management and SQL programming.· Reports Automation - Build automated solutions for the manual process and reporting systems using Python Scripts.· Root Cause Analysis - Assist management in addressing tech issues such as drop-in no. of users and help them find the Root cause of the issue and fix the issues.· Agile Methodology - Experience working in an agile software delivery model with the help of Jira.· Statistical Analysis - Performed data wrangling and implemented statistical/ML models to analyze the business trends and helped the management make the right decisions. Show less