SWETA RAKSHIT

Data Analyst & Business Analyst

GitHub | LinkedIn

About

Highly versatile Data Analyst and Business Analyst with 6.4 years of experience, specializing in driving data-driven decision-making and operational efficiency across Telecom, IT, and Enterprise sectors. Expertly leverages Excel, SQL, Power BI, and ETL processes to deliver actionable insights, build scalable dashboards, and automate workflows, enhancing data accuracy and reducing manual effort by up to 30%. Proven ability to translate complex business requirements into technical solutions, significantly improving managerial decision-making speed by 15% and data retrieval efficiency by 20%.

Work Experience

Data Analyst/Business Analyst

Ericsson

Dec 2023 - Present

Bangalore, Karnataka, IN

Led data analysis and business intelligence initiatives within the telecom sector, driving data-driven decision-making and operational improvements.

  • Conducted extensive Exploratory Data Analysis (EDA) on critical telecom network KPIs (Accessibility, Retainability, Mobility) to identify performance trends and enhance network stability.
  • Designed and deployed interactive Power BI dashboards, integrating complex GCP datasets, which accelerated managerial decision-making by 15%.
  • Optimized SQL and GCP queries for data extraction and analysis from data warehouses, significantly improving data retrieval efficiency by 20%.
  • Automated Excel reporting processes using VBA macros, reducing manual effort by 30% and streamlining workflows.
  • Translated complex business requirements into clear KPI metrics and reporting specifications, collaborating with stakeholders and cross-functional teams under an Agile framework.

Business Analyst

Mobilecomm Professional Inc.

Apr 2021 - Dec 2023

Bangalore, Karnataka, IN

Drove business intelligence initiatives by designing and maintaining Power BI dashboards and translating strategic goals into technical solutions for telecom performance monitoring.

  • Designed, implemented, and maintained interactive Power BI dashboards for telecom performance monitoring, enhancing data visibility and decision support.
  • Translated intricate business goals into precise functional and technical specifications, utilizing Agile/Scrum methodologies for streamlined development.
  • Executed comprehensive data cleaning, transformation, and modeling using Power Query and DAX, ensuring data integrity for analytical reporting.
  • Authored and optimized SQL queries for efficient data extraction, validation, and in-depth analysis across various datasets.
  • Managed User Acceptance Testing (UAT) sessions, meticulously documenting findings and coordinating with developers to implement necessary fixes and ensure timely delivery of reports.

Network Engineer

Mastec Quadgen wireless

Jan 2019 - Apr 2021

Bangalore, Karnataka, IN

Contributed to 4G/5G network infrastructure development and optimization by performing integrations, analyzing deployments, and resolving network anomalies.

  • Performed critical 4G/5G integration and meticulously analyzed scripts to ensure successful TDD/FDD technology deployments.
  • Monitored key network KPIs, proactively identifying and escalating anomalies to facilitate rapid resolution and minimize service disruption.
  • Provided essential technical support to cross-functional telecom teams, aiding in troubleshooting and optimizing network performance.

Education

Electronics and Communication Engineering

Gurunanak Institute of Technology

8.62 DGPA

Jan 2014 - Jan 2018

Kolkata, West Bengal, IN

Certificates

SQL - HackerRank Basic & Intermediate Certification

HackerRank

Projects

MS Excel Sales Dashboard

Developed an interactive sales dashboard to visualize key performance indicators (KPIs) and provide actionable insights for sales performance, utilizing advanced Excel functionalities.

Power BI Telecom KPI Dashboard

Designed and developed an interactive Power BI dashboard for real-time monitoring of critical telecom network KPIs (Accessibility, Retainability, Mobility).

Skills

Data Analysis & Business Intelligence

  • Power BI
  • SQL
  • Excel (Advanced)
  • Data Modeling
  • ETL
  • Data Cleaning
  • KPI Reporting
  • Dashboard Development
  • Exploratory Data Analysis (EDA)
  • Data Visualization
  • Business Intelligence
  • Data Migration
  • Data Platform Implementation

Programming & Databases

  • Python (NumPy, Pandas, Matplotlib, Seaborn)
  • MySQL
  • GCP (Google Cloud Platform)

Project Management & Methodologies

  • Agile
  • Scrum
  • ITSM
  • JIRA
  • ServiceNow
  • Business Analysis
  • Requirement Gathering
  • Stakeholder Management

Automation

  • VBA Macros

Telecom Specific

  • Network KPIs (Accessibility, Retainability, Mobility)
  • 4G/5G Integration
  • TDD/FDD Technology

Interests

Hobbies

  • Travelling
  • Hiking
  • Cooking
  • Watching movies