Swetha Prabhakaran

Data Analyst

Bengaluru, Karnataka, India3 yrs 9 mos experience
Most Likely To Switch

Key Highlights

  • Expert in Microsoft Power BI and SQL for data visualization.
  • Proven ability to optimize SQL queries for performance.
  • Hands-on experience in end-to-end BI project execution.
Stackforce AI infers this person is a Data Analyst with expertise in BI solutions and data engineering in SaaS.

Contact

Skills

Core Skills

Microsoft Power BiSqlPython (programming Language)Data EngineeringData AnalysisSoftware Development

Other Skills

Power BIDAXApache NiFiPythonNiFiPySparkObject-Oriented Programming (OOP)MongoDBData ModelingPower BI ServiceData VisualizationMachine LearningNumPyMatplotlibSeaborn

About

-> Expertise in Microsoft Power BI and SQL for developing interactive dashboards and analytical reports. -> Strong experience in DAX (measures, calculated columns) . -> Hands-on experience in Data Modelling using Star Schema and creating optimized tabular models. -> Experience in writing complex SQL queries including joins, CTEs, window functions and performance optimization. -> Worked on end-to-end BI projects covering requirement gathering, design, development, testing and deployment. -> Experience handling large datasets and improving query performance in enterprise-level dashboards. -> Published and managed reports in Power BI Service (Premium capacity). -> Basic exposure to Python (Pandas, Numpy) for data analysis and validation. -> Strong analytical, problem-solving skills and ability to work independently as well as in a team environment.

Experience

Best engineering aids & consultancies

Data Analyst

Mar 2024Present · 2 yrs · Bengaluru, Karnataka, India · On-site

  • Designed and developed BOM and ECO dashboards using Power BI, enabling stakeholders to track item-level changes and process efficiency.
  • Built a Finance dashboard to visualize monthly expenses, savings, and profit trends with DAX-based KPIs and tooltips.
  • Optimized SQL queries for large datasets in DBeaver, reducing Power BI load time from minutes to under 30 seconds.
  • Integrated business logic and user feedback from the Datta team to improve data accuracy and visual storytelling.
  • Published and maintained reports via Power BI Service, ensuring real-time access and collaboration across departments.
SQLMicrosoft Power BI

Cloudloom technologies

Consultant

May 2023Feb 2024 · 9 mos · Bengaluru, Karnataka, India · On-site

  • Designed and executed comprehensive data solutions with Python, NiFi, PySpark, Hadoop, and Hudi, optimizing large-scale data transfers and orchestrating seamless movement. Led development of a robust change data capture (CDC) pipeline, applying intricate business logic transformations for enhanced data processing efficiency.
Python (Programming Language)Apache NiFiData Engineering

Istellar

Software Developer

Jun 2022May 2023 · 11 mos · Bengaluru, Karnataka, India · On-site

  • Streamlined data analysis with user-friendly interfaces and MongoDB storage. Implemented dynamic Python and JSON templates for versatile analysis, ensuring data integrity. Analyzed complex datasets for actionable insights using Python's pymongo library for enhanced capabilities.
SQLObject-Oriented Programming (OOP)Data AnalysisSoftware Development

Education

Anna University Chennai

Bachelor of Engineering - BE — Computer Science

Jun 2017Aug 2021

Bhagavan higher secondary school

Hsc — Maths Biology

Jun 2015Apr 2017

Maharishi Vidya Mandir, Tiruvanamalai , Tamilnadu

SLCC

Mar 2014Apr 2015

Stackforce found 100+ more professionals with Microsoft Power Bi & Sql

Explore similar profiles based on matching skills and experience