Summary
Overview
Work History
Education
Skills
Projectresearchexperience
Certification
Timeline
Generic

Shweta Mardhekar

Dallas,USA

Summary

Power BI Developer with 5+ years of experience in designing data models, crafting intuitive dashboards, and delivering actionable insights. Proficient in Power BI, DAX, SQL, and AWS Redshift, with a strong track record of improving business efficiency through innovative data solutions. Passionate about leveraging data to drive impact and align with mission-driven organizations.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Analyst

Valiant Residential
Dallas
05.2022 - Current
  • Developed and optimized data visualization dashboards in Power BI and Tableau integrated with AWS Redshift, enhancing decision-making by 25% and improving data reporting turnaround time by 40%
  • Implemented and maintained ETL pipelines using Azure Synapse, Power Automate, and Python, reducing data preparation time by 30% while supporting scalable data workflows
  • Engineered predictive models leveraging statistical techniques, leading to a 15% improvement in forecasting accuracy
  • Designed and executed a data governance framework, reducing regulatory risks by 25% and improving data quality by 30%
  • Collaborated closely with senior management to transform complex data into actionable insights, driving a 10% increase in overall business efficiency
  • Leveraged Google Analytics to boost web traffic by 25% and conversion rates by 18% within three months
  • Initiated and led a cross-functional team in a data-driven marketing campaign that resulted in 10% growth in sales
  • Possess in-depth knowledge in financial and real estate domains, enhancing data analysis relevance and accuracy in sector-specific projects
  • Leveraged Python and shell scripting to streamline ETL processes, while crafting efficient paginated reports to support data-driven decision-making

Senior Data Analyst

Nitor Infotech
Pune
06.2020 - 07.2021
  • Migrated legacy data processes by converting Pig scripts into PySpark for data handling within Hive databases, improving query performance by 60% and reducing waiting times by 25%
  • Coordinated with teams virtually to develop solutions using Hive datasets in 30 days, streamlining production processes

Senior BI Developer

Nitor Infotech
Pune
06.2019 - 06.2020
  • Architected and implemented enterprise-level data warehouses using AWS Redshift and Glue to consolidate data from multiple sources, enabling scalable analytics and reporting solutions
  • Designed and optimized dimensional data models and developed ETL pipelines in AWS Glue, achieving a 60% improvement in data processing performance
  • Improved reporting visualizations for business users, adding 3 new customers and boosting reporting efficiency by 40%

BI Developer

Nitor Infotech
Pune
06.2019 - 06.2020
  • Platform shift from Oracle BI to Microsoft BI and Infrastructure shift from On-Premises to Cloud
  • Involved in the Creation of Tables, Indexes, and Stored Procedures which were used to implement business rules, and Generated SQL Queries with necessary Join conditions Designed Dimensional models and developed Data Pipelines with the help of ETL Tool to Perform ETL s Cleansing of inconsistent Data
  • Embedded Power BI dashboard in .Net application with Power BI API
  • Trained business users and stakeholders to use the self-service feature of Power BI which proved of great value for the business

Education

MS - Information Technology and Management

University of Texas
Dallas
05.2023

PG Diploma - Advanced Computing

Know-IT ACTS(ATC) | CDAC
Pune, India
02.2018

BE - Computer Engineering

Pune University
Pune, India
05.2017

Skills

  • Python
  • SQL
  • R
  • MQL
  • Unix Scripting
  • Power BI
  • DAX
  • M language
  • Tableau BI
  • Microsoft Excel
  • PivotTables
  • VBA
  • ETL
  • AWS Redshift
  • Data Visualization Principles
  • Statistics
  • Cross-functional collaboration
  • Business process optimization
  • Automation
  • AWS Glue
  • Amazon Redshift
  • Power Automate

Projectresearchexperience

  • Risk factor Identification based on geographic location, Master's Course Project. By using HDP tools and techniques processed the data and created analytical reports used for decision making.
  • Big Data project, Using Hue and doing scripting, data modeling along visualization part.

Certification

  • Azure Basic Fundamentals
  • Power BI Advance
  • Sql

Timeline

Data Analyst

Valiant Residential
05.2022 - Current

Senior Data Analyst

Nitor Infotech
06.2020 - 07.2021

Senior BI Developer

Nitor Infotech
06.2019 - 06.2020

BI Developer

Nitor Infotech
06.2019 - 06.2020

MS - Information Technology and Management

University of Texas

PG Diploma - Advanced Computing

Know-IT ACTS(ATC) | CDAC

BE - Computer Engineering

Pune University

Similar Profiles

CREATE PROFILE
Shweta Mardhekar