Summary
Overview
Work History
Education
Skills
Certification
Awards
Languages
Personal Information
Timeline
Generic

Shwetha Pavadashetty

Bangalore

Summary

With around 6+ years of experience in data engineering and analysis, I have worked extensively with tools and technologies like Power BI (DAX, Power Query, Paginated Reports, Power Automate), Azure SQL, Azure Data Factory, and Databricks. I specialize in creating dynamic dashboards, automating data processes, and delivering actionable insights to support marketing initiatives, KPI tracking, and strategic decision-making. I am seeking a long-term association with a growth-oriented organization where I can further enhance my skills, and contribute to business success.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

EY GDS
12.2021 - Current
  • Managed and maintained SQL database, ensuring data accuracy, security, and optimal performance. Proficient in writing complex SQL queries to extract, transform, and analyze data. Responsible for data discovery, data mapping and data engineering activities. Connected with different teams including Transformation, Data ingestion and Cleansing teams to gather the requirements.
  • Created and worked on transformation logic in SSMS, if required. Applied transformation logic including Spark SQL, Pyspark, operations on data. Applied optimizations logics i.e., Partitioning, broadcast joins etc and utilized Azure DevOps for version control, collaboration, and efficient pull request workflows.
  • Built Notebooks, Workflows, scaling the cluster, extracting data from SQL DB using JDBC connection.

Data Analyst

Acuvate Software Pvt Ltd
Bangalore
07.2018 - 11.2021
  • Developed the wireframe reports in Power BI, handled the visuals, DAX calculations and data validation.
  • Involved in writing DAX measures and calculated column in AAS.
  • Involved in requirement gathering, Need to Analyse the Client business and based on our business understanding, need to create Effective reports and Dashboard using proper business logic that gives them proper view of their Business and Produce right information in terms of their Actuals and Target data of their Business Worldwide.
  • Involved in technical decisions for Business requirement, interaction with Business Analysts, Client team, Development team.
  • Developed a Paginated report in Power bi report builder, handled DAX for calculations and SSAS as the source connection.
  • Developed ADF pipelines to copy the data from Azure to SQL.
  • Created Stored procedures and Views to transform the data.

Education

B.E - Computer and Science Engineering

Acharya institute of technology
Bangalore
01.2017

Skills

  • Databases: MS SQL Server
  • Data integration (ETL): Azure Data Factory, SSIS (Basic)
  • Cloud Technologies: Azure
  • Reporting tools/platforms: Azure Databricks, Power BI, SSRS, Power BI Report Builder, Power Apps
  • Other tools: Visual Studio, SSMS
  • Programming languages: SQL, Spark SQL, PySpark, DAX
  • Agile tools: JIRA, Azure DevOps

Certification

  • Databricks Certified Data Engineer Associate
  • Microsoft Certified Data Analyst Associate (DA-100)

Awards

  • Spot award for developing and delivering the reports on time
  • Spot award for developing and delivering the reports on time in Acuvate
  • Won the 3rd prize in the DataWiz Hackathon, which was conducted by Acuvate

Languages

  • English
  • Kannada
  • Telugu (Beginner)
  • Hindi (Beginner)

Personal Information

  • Date of Birth: 09/04/1995
  • Nationality: Indian

Timeline

Senior Data Engineer

EY GDS
12.2021 - Current

Data Analyst

Acuvate Software Pvt Ltd
07.2018 - 11.2021

B.E - Computer and Science Engineering

Acharya institute of technology

Similar Profiles

CREATE PROFILE
Shwetha Pavadashetty