Back to Developers
Prabal Ranjan Goswami

Prabal Ranjan Goswami

Data Analyst

Hyderabad, India 4+ yrs exp 93 · Outstanding

About

Data Analyst with 4+ years building Power BI, SQL, and Python analytics for five state governments and enterprise clients. Model large operational datasets — several lakh records daily — into decision-support systems used by senior stakeholders. Currently lead a 3–5 member BI team across 6+ concurrent projects.

Skills & Expertise (41)

Power BI Advanced
8.3/10
3
Years Exp
SQL Intermediate
7.5/10
3
Years Exp
DAX Intermediate
7.0/10
3
Years Exp
Data Modeling Intermediate
7.0/10
3
Years Exp
Python Intermediate
7.0/10
3
Years Exp
Advanced Excel Intermediate
6.5/10
3
Years Exp
KPI Reporting Intermediate
6.5/10
3
Years Exp
Tableau Intermediate
6.5/10
2
Years Exp
Data Quality Intermediate
6.5/10
3
Years Exp
Exploratory data analysis Intermediate
6.0/10
3
Years Exp
Forecasting Intermediate
6.0/10
2
Years Exp
Predictive Modeling Intermediate
6.0/10
2
Years Exp
Data Governance Intermediate
6.0/10
3
Years Exp
Data Validation Intermediate
6.0/10
3
Years Exp
Git Intermediate
6.0/10
3
Years Exp
Unity Catalog Delta Lake PySpark Databricks Observability LLM Evaluation Prompt Engineering Jira llm apis ServiceNow Microsoft Excel Geospatial Analysis Fraud Detection Anomaly Detection REST APIs SQL Scripting NumPy Pandas Query Optimization CTEs Window Functions Joins Dashboard Design Power BI Service RLS Power Query

Work Experience

Data Analyst / Power BI Developer — Team Lead

RNIT AI Solutions

Aug 2025 - Present

Lead a 3–5 analyst team across 6+ concurrent government and enterprise projects, all releases delivered on schedule; gather requirements directly with stakeholders and propose additional metrics beyond the original ask. Built Power BI analytics for the Government of Andhra Pradesh (Naipunyam – APSSDC) tracking 100K+ jobs, candidates, employers, and trainings from candidate to placement, helping the state identify high-demand courses and top-performing training centres. Developed statewide attendance analytics for the Assam and Telangana governments, processing several lakh records daily across all districts for near real-time monitoring; kept reports fast using incremental refresh, aggregation tables, and DB-side views designed with the database team. Designed geofencing-based anomaly detection flagging teacher and student attendance marked outside school boundaries, plus irregular multi-attempt student registrations, surfacing cases for administrator action. Built Python and LLM-assisted automation for recurring analysis and dashboard build-out, cutting repetitive effort by ~30%; supported internal LLM tooling with prompt/response tracing and token/latency tracking. Informed government stakeholder strategic decision-making by identifying high-demand training courses and top-performing centers through comprehensive data modeling. Provided technical mentorship to a team of 3–5 analysts, ensuring consistent code quality and adherence to project timelines across government and enterprise engagements. Advise government stakeholders on training program efficacy by identifying high-demand courses and top-performing centers, providing actionable, data-driven recommendations to stakeholders for future resource allocation. Support management with data-backed insights for strategic and operational decisions by modeling large operational datasets into decision-support systems for senior leadership.

Data Analyst

ConveGenius.ai

Jul 2024 - Aug 2025

Led education analytics for the Assam, Uttarakhand, and Tripura state education departments, delivering 25+ Power BI dashboards covering 44,000+ schools, 200K+ teachers, and 20K non-teaching staff. Built analytics across attendance, examinations, mid-day meals, uniforms, infrastructure, and smart/digital classrooms, giving departments a single operational view of the school system. Developed a CatBoost-based early-warning system for dropout prevention, with a dashboard breaking dropout drivers down by infrastructure, exam performance, attendance, language, and social category. Automated ETL workflows in Python and SQL, reducing manual data processing effort by 60% within six months. District-level analysis informed ₹2.5+ crore of budget reallocation toward underserved schools. Translate complex dropout patterns into clear, actionable, data-driven recommendations to stakeholders, enabling targeted interventions for at-risk schools. Support management with data-backed insights for strategic and operational decisions regarding budget distribution, resulting in the reallocation of funds toward underserved schools. Applied analytical skills to evaluate complex datasets, identifying trends that informed strategic decision-making processes.

Analyst — Data Analytics (PLM & IT Operations)

Capgemini

Aug 2022 - Jul 2024

Delivered global application support for a pulp-and-paper manufacturing client across CN, APAC, EMEA, and AM regions, managing incidents and service requests through ServiceNow. Supported PDM and Dassault ENOVIA PLM platforms, partnering with CAD teams to resolve cross-system issues and deploying weekly platform changes and releases. Built Power BI dashboards over ServiceNow ticket data (volume, category, region, resolution trends), giving leads visibility into recurring issue patterns and improving support-team efficiency by 20%. Streamlined recurring ServiceNow reporting, reducing manual tracking effort by 30%. Refined communication skills to translate technical requirements into clear documentation for stakeholders and project partners.

Education

MCA - New Horizon College of Engineering

2020 - 2022 · Afghanistan

BCA - Cotton University

2017 - 2020 · Afghanistan

Certifications

Google Data Analytics Professional Certificate

· 2023

Understanding and Visualizing Data with Python

· 2022

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 13/15
💰 Rate 0/5
🏆 Certs 5/5
✅ Verified 5/5
Total Score 93/100

Profile Overview

Member sinceOct 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation