Anushka Gawai

Experience

• 

  Techlamp software solutions

  Sept 2022 - Mar 2023

  Data Analyst

  • Strong Knowledge in writing and executing Advanced SQL queries, UNIX, and strong debugging skills.• Design, develop, and maintain complex SQL queries such as Joins, Views, Analytical Functions and Aggregate Functions.• Experience in creating Triggers, Functions and Stored Procedure in PL/SQL.• Worked on Power Query, Data Modelling, Data Loading, Data Transformation, Data Cleaning and Data Manipulation in Power BI.• Well versed in creating and developing Power BI Reports and Dashboards.• Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc.• Sound knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes.• Knowledge of Python and Big Data tools like Hadoop, Hive and Spark• Basic knowledge of Python and Big Data tools like Hadoop, Hive, Spark.• Skills: Unix · Data Visualization · PySpark · Hive · Hadoop · MySQL• Tools: Big Data | Unix | MySQL | Python (Programming Language) | Microsoft Power BI Show less