SWETA RAKSHIT

Data Analyst & Business Analyst
Bangalore, IN.

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

Ericsson
|

Data Analyst/Business Analyst

Bangalore, Karnataka, India

Summary

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

Highlights

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.

Mobilecomm Professional Inc.
|

Business Analyst

Bangalore, Karnataka, India

Summary

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

Highlights

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.

Mastec Quadgen wireless
|

Network Engineer

Bangalore, Karnataka, India

Summary

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

Highlights

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

Gurunanak Institute of Technology
Kolkata, West Bengal, India

Bachelor of Engineering

Electronics and Communication Engineering

Grade: 8.62 DGPA

Certificates

SQL - HackerRank Basic & Intermediate Certification

Issued By

HackerRank

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.

Projects

MS Excel Sales Dashboard

Summary

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

Summary

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