Prabhat Chanda

Prabhat Chanda

Data Analyst
United Arab Emirates
Hindi, English

نبذة عني

Data Analyst adept at turning complex datasets into actionable insights, bridging technical expertise with business acumen. Proficient in SQL, Python, Excel, and Tableau, with experience in machine learning and data ware…

الخبرة

Data Analyst

Bright Mind Enrichment And Schooling
Feb 2025 - حتى الآن · 1 سنة 5 أشهر

Identified a 15% drop-off rate that led to improved participant follow-up strategies by conducting extensive data manipulation and cleansing on 20K+ records using SQL (CTEs, subqueries, window functions) and SAS.
Performed statistical analysis in R to evaluate outreach campaigns and track KPIs like engagement and attendance.

Data Analyst

Bright Mind Enrichment And Schooling · New York City, USA
Feb 2025 - حتى الآن · 1 سنة 5 أشهر

Identified a 15% drop-off rate that led to improved participant follow-up strategies by conducting extensive data manipulation and cleansing on 20K+ records using SQL (CTEs, subqueries, window functions) and SAS., Performed statistical analysis in R to evaluate outreach campaigns and track KPIs like engagement and attendance.

Data Operations

Enel North America · North Andover, USA
Feb 2024 - Jun 2024 · 4 أشهر

Performed exploratory time-series analysis on historical load profiles in Python and visualized energy usage in a proprietary software to identify peak-demand patterns and support event-day planning., Optimized portfolio delivery for Demand Response programs by managing customer enrollment, consolidating utility portal data, validating 300+ site records in Excel, and analyzing participation trends in Python., Streamlined and automated data collection for 5 energy utilities (e.g. NYSEG, PSEG) via R Shiny & Selenium scripts., Designed 4 dynamic Tableau dashboards for real-time KPI tracking, extracting data from Salesforce CRM with SQL., Reduced errors by 25% by streamlining energy records for CRM integration via Excel (PivotTable, VLOOKUP, VBA).

Data Operations

Enel North America, Andover, MA
Feb 2024 - Jun 2024 · 4 أشهر

Performed exploratory time-series analysis on historical load profiles in Python and visualized energy usage in a proprietary software to identify peak-demand patterns and support event-day planning.
Optimized portfolio delivery for Demand Response programs by managing customer enrollment, consolidating utility portal data, validating 300+ site records in Excel, and analyzing participation trends in Python.
Streamlined and automated data collection for 5 energy utilities (e.g. NYSEG, PSEG) via R Shiny & Selenium scripts.
Designed 4 dynamic Tableau dashboards for real-time KPI tracking, extracting data from Salesforce CRM with SQL.
Reduced errors by 25% by streamlining energy records for CRM integration via Excel (PivotTable, VLOOKUP, VBA).

Graduate Teaching Assistant

Northeastern University · Boston, USA
Sep 2023 - Dec 2023 · 3 أشهر

• Led SQL, Tableau, and database design workshops for 150+ students, enhancing practical analytics proficiency.• Mentored 15 groups to develop Data Science solutions for real-world challenges and evaluated 500+ assignments.

Data Analyst

Chanda Hospital · Sonipat, India
Aug 2021 - Aug 2022 · 1 سنة

Saved 20% in procurement costs by optimizing inventory through root-cause analysis and statistical evaluations., Increased patient engagement by 15% through marketing campaigns informed by demographic analysis in Python., Increased patient capacity by 13% by optimizing scheduling with time-series forecasting in Python (statsmodels)., Provided key recommendations to stakeholders by analyzing data in Python and visualizing findings in Power BI.

Data Analyst

Chanda Hospital, Sonipat, India
Aug 2021 - Aug 2022 · 1 سنة

Saved 20% in procurement costs by optimizing inventory through root-cause analysis and statistical evaluations.
Increased patient engagement by 15% through marketing campaigns informed by demographic analysis in Python.
Increased patient capacity by 13% by optimizing scheduling with time-series forecasting in Python (statsmodels).
Provided key recommendations to stakeholders by analyzing data in Python and visualizing findings in Power BI.

المشاريع

Sentiment Analysis Pipeline

Northeastern University
المدة : 01-Sep-2024 - 31-Dec-2024

• Built an MLOps workflow orchestrating ETL, CI/CD, validation (TFDV), Snorkel labeling and serving 338M records.• Deployed RAG-based summarizer using OpenAI APIs and Pinecone; built Streamlit interface for product feedback.

Analysis of Corporate Layoffs

Northeastern University
المدة : 01-Sep-2023 - 31-Dec-2023

• Designed 5 Tableau dashboards with DAX measures to analyze 164K employee records and identify industry trends.• Reduced errors by 95% by performing data pre-processing in Python using Pandas, NumPy and statistical methods.

E-Commerce Database

Northeastern University
المدة : 01-May-2023 - 31-Aug-2023

• Improved query performance by 75% by designing a scalable database architecture using SQL and MongoDB.• Executed optimized complex SQL queries (joins, CTE, aggregations) to analyze data and uncover actionable insights.

Income Classification of UCI Census

Northeastern University
المدة : 01-Jan-2023 - 30-Apr-2023

• Achieved 79% accuracy with Naive Bayes, highest among 5 supervised ML models developed without scikit-learn.• Applied SMOTE to handle class imbalance and constructed a neural network model to validate backpropagation.

المهارات

إكسل بايثون (لغة برمجة) لغة الاستعلامات الهيكلية (SQL) تابلو MySQL PostgreSQL Oracle MongoDB Scikit-Learn TensorFlow PyTorch Keras NLTK Shiny PySpark Pandas NumPy Regression Classification Clustering Ensemble Learning Neural Networks NLP Statistics Power BI SAS DAX Business Intelligence EDA Data Modeling KPI Analysis MLOps AWS GCP Docker Airflow Git ELK ETL CI/CD MLflow Drift Monitoring
الإبلاغ عن هذا الملف الشخصي؟