Hello, I'm Chandra Shekar

Download Resume
Chandra Shekar

About Me

I'm Chandra Shekar, a passionate Data Analyst and Data Scientist with over 3.5+ years of experience in transforming complex data into meaningful and actionable insights. I specialize in using Power BI, Grafana, SQL, and Python to build dynamic dashboards and conduct in-depth data analysis. My expertise includes data preprocessing, statistical modeling, and handling large-scale relational databases such as PostgreSQL, MSSQL, and Oracle. I'm also familiar with applying both supervised and unsupervised machine learning techniques to solve real-world business challenges. I’m driven by a commitment to deliver data-driven solutions that enhance operational efficiency and empower strategic decision-making across organizations.

Skills

Database Management

Microsoft SQL Server, Oracle, PostgreSQL

Programming Languages

Python, SQL

Data Manipulation & Analysis

Pandas, NumPy, Microsoft Excel

Data Visualization

Power BI, Grafana, Matplotlib, Seaborn

Statistics

Descriptive Statistics, Hypothesis Testing, Probability, Regression Analysis, Time Series Analysis

Machine Learning

Scikit-learn, EDA (Exploratory Data Analysis), Regression, Classification, Clustering, Anomaly Detection

Tools & Platforms

Jupyter Notebook, Google Colab, GitHub, Microsoft Power BI Service

Soft Skills

Problem Solving, Critical Thinking, Team Collaboration, Data Storytelling, Time Management, Team Management

Professional Experience

Data Scientist

Efftronics Systems Pvt. Ltd.

Oct 2023 – Present
  • Developed Power BI dashboards for Railway Point Health Monitoring, enabling predictive maintenance and improving system reliability.
  • Designed live dashboards for Water Distribution and Smart Aquaculture, optimizing resource usage and enhancing sustainability.
  • Built real-time Air Quality Monitoring systems with visual alerts, allowing faster pollution spike detection.
  • Created energy-efficient monitoring dashboards for Railway Platforms, improving asset availability and reducing consumption.
  • Delivered proactive, IoT-driven insights across projects, significantly boosting operational efficiency and safety.
Data Analyst

Efftronics Systems Pvt. Ltd.

Nov 2021 – Sep 2023
  • Built energy consumption dashboards to detect anomalies, improving efficiency and reducing waste.
  • Designed a Battery Health Monitoring System with real-time alerts and predictive analytics to extend battery life and ensure safety.
  • Implemented Indoor Air Quality dashboards, helping reduce exposure to harmful pollutants with real-time monitoring.
  • Led Power BI workshops for professionals and students, equipping them with practical skills in data analysis and visualization.
  • Collaborated with engineers and stakeholders to design, deploy, and improve data-driven solutions across various domains.
Power BI Trainer

Efftronics Systems Pvt. Ltd.

Trainer
Training | Power BI
  • Conducted 3-day workshops for educators and professionals, focusing on Power BI data visualization techniques.
  • Trained college students at Vignan College, equipping them with skills in data visualization and Power BI reporting.
  • Empowered internal teams by teaching Power BI Service for live project analysis and reporting.

Focus Areas: Power BI Desktop & Service, DAX, Data Storytelling, Dashboard Design

Projects

Railway Point Health Monitoring
Professional

Implemented a real-time analytics solution to monitor the health of railway point motors using sensor data and Power BI.

  • Improved data reliability from 60% to 100% using live data validation logic.
  • Reduced failure risks by identifying point motor anomalies early.
  • Enhanced asset lifecycle with time-based signal deviation analysis.
  • Enabled predictive maintenance with fault alerting dashboards.
Signal Health Monitoring
Professional

Developed a real-time monitoring solution for railway signaling systems to ensure operational safety and efficiency. By leveraging IoT technology and predictive analytics, we significantly improved system reliability, uptime, and fault detection.

  • 20% increase in signal reliability by implementing real-time monitoring and fault detection.
  • Reduced signal failures by 30% through early identification and timely corrective actions.
  • 40% improvement in system uptime with predictive maintenance and IoT-enabled monitoring.
Smart Water Management
Professional

Designed a real-time IoT-based framework for municipal water supply management and leak detection.

  • Reduced water loss by 40% through intelligent flow and pressure monitoring.
  • Enhanced operational response using dynamic Power BI dashboards and alerting mechanisms.
Smart Aquaculture Monitoring
Professional

Implemented IoT-enabled monitoring of environmental conditions in aquaculture ponds to improve fish health and yield.

  • Improved aquatic sustainability by 25% by optimizing temperature and DO levels.
  • Enabled proactive decision-making through real-time insights.
Air Quality Intelligence System
Professional

Deployed IoT sensors for real-time tracking of key pollutants and visualized trends using Power BI and ECharts.

  • Accelerated pollution alerting by 20% using dynamic AQI-based dashboards.
  • Provided actionable insights to support environmental policy and planning.
Railway Platform Asset Intelligence
Professional

Built dashboards for monitoring platform lighting, lifts, and escalators to ensure availability and energy efficiency.

  • Improved energy efficiency by 40% and minimized equipment downtime.
  • Strengthened passenger safety and service quality through asset health tracking.
Energy Monitoring
Professional

Developed intelligent analytics for IoT-based energy consumption data, identifying inefficiencies and anomalies.

  • 30% reduction in energy usage anomalies through smart detection
  • 20% increase in efficiency via real-time pattern optimization
Battery Health Monitoring
Professional

Designed a real-time IoT-based BHMS to monitor battery health, charge cycles, and performance metrics.

  • 25% increase in battery lifespan through optimized monitoring
  • 100% safety compliance via predictive alerts and maintenance
  • Real-time integration with Power BI for actionable insights
Indoor Air Quality Monitoring
Professional

Engineered a smart monitoring system for real-time indoor air quality analytics using IoT sensor data.

  • Tracked key metrics: CO₂, PM2.5, humidity, temperature
  • Integrated with Power BI for instant air health dashboards
  • Enabled automated alerts for unsafe levels, improving response efficiency by 40%
Data-Driven Healthcare Insights: Exploratory Study
Personal

Tools: Python, Pandas, NumPy, Matplotlib, Seaborn, Jupyter Notebook, Power BI

Executed an end-to-end exploratory data analysis on healthcare data to uncover billing patterns, patient outcomes, and doctor/hospital performance.

  • Performed comprehensive data cleaning, preprocessing, and EDA using Python libraries in Jupyter Notebook.
  • Visualized trends through Matplotlib & Seaborn charts for actionable insights.
  • Developed interactive Power BI dashboards to communicate findings effectively.
Source Code
Cashless Transactions in Vijayawada
Personal

Duration: Jan 2019 – Apr 2019
Tools: SPSS, Microsoft Excel

Executed a statistical study to explore factors influencing digital payment adoption in urban settings.

  • Analyzed user behavior and awareness using descriptive and inferential statistics.
  • Identified key motivators such as convenience and security shaping adoption trends.

Education

Master's in Statistics

Krishna University, Nuzvid

2019 – 2021
CGPA: 9.5

Bachelor's in Mathematics, Statistics & Computer Science

K.B.N. College, Krishna University, Vijayawada

2016 – 2019
CGPA: 9.4

Intermediate in Science

Board of Intermediate Education, Andhra Pradesh

2014 – 2016
CGPA: 9.2

SSC (10th Grade)

Board of Secondary Education, Andhra Pradesh

2013 – 2014
CGPA: 8.2

Certifications

SQL for Data Science

Great Learning Academy

View Certificate
Data Science with Python

Great Learning Academy

View Certificate
Advanced Excel

Udemy

View Certificate
Power BI Visualization

Great Learning Academy

View Certificate
Excel Data Analysis

Udemy

View Certificate
HackerRank SQL (All Levels)

HackerRank

View Certificate
NumPy with Python

Simplilearn

View Certificate
Python Pandas Basics

Simplilearn

View Certificate

Training & Workshops

Power BI Workshop for Educators & Professionals

Successfully conducted an intensive 3-day workshop at Efftronics Systems Pvt. Ltd., guiding participants through advanced data visualization and reporting using Power BI.

Power BI Training for College Students

Delivered hands-on training sessions at Vignan College, equipping students with practical knowledge in data analytics and dashboard creation using Power BI.

Contact

Email

devarasettychandrashekar@gmail.com

Phone

+91 90309 23488

Location

Vijayawada, India