Back to Developers
jagesh ranjan sharma

jagesh ranjan sharma

Data Analyst

Noida, India
80
Profile Score

About

Analytics professional with 4+ years of experience working with large, complex datasets in the telecom domain. Strong hands-on expertise in SQL, Python, Power BI, and data modeling to support business strategy, performance measurement, and risk-aware decision making. Experienced in data extraction, cleaning, exploratory analysis, KPI definition, and visualization, with a solid understanding of compliance, data governance, and stakeholder communication. Seeking to contribute as a Spec Analytics Analyst in a fast-paced, regulated environment.

Skills & Expertise (16)

Power BI Expert
9.1/10
5
Years Exp
Data Analysis Expert
8.8/10
5
Years Exp
SQL Advanced
8.5/10
5
Years Exp
Python Intermediate
7.8/10
3
Years Exp
Advanced Excel Advanced
7.5/10
5
Years Exp
Power Query DAX Data Validation Forecasting Pandas NumPy Matplotlib Data Modeling Star Schema KPI development Stakeholder Management

Work Experience

Data Analyst

BT Group

Mar 2021 - Apr 2025

Designed and delivered Power BI dashboards and analytical reports covering revenue trends, customer churn, SLA performance, and operational metrics for business and leadership teams. Extracted, transformed, and validated large datasets using advanced SQL (joins, CTEs, window functions), ensuring accurate and consistent reporting. Automated reporting pipelines and refresh processes, improving report delivery speed by ~30% and reducing dependency on manual intervention. Used Python (Pandas, NumPy) for data manipulation, trend analysis, and automation of repetitive reporting tasks. Documented data requirements, assumptions, metrics definitions, and data lineage, ensuring transparency and audit readiness.

Production Planning & Data Analyst

Dixon Technologies

Jun 2025 - Feb 2026

Led the development of end-to-end Power BI dashboards for production planning, dispatch performance, and capacity utilization, enabling data-driven decisions across planning and operations teams. Consolidated demand, production, and dispatch data using SQL and Power Query, resulting in an estimated ~20% improvement in planning accuracy. Automated weekly and monthly MIS reporting workflows, reducing manual data preparation effort by 30–40% and improving reporting timeliness. Defined, standardized, and tracked key operational KPIs (OTIF, utilization, backlog aging, target achievement) to ensure consistent performance measurement.

Education

Bachelor of Technology (B.Tech) - United College of Engineering and Research

2015 - 2019 · Afghanistan

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 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 80/100

Profile Overview

Member sinceMar 2026

Skills (16)

Power BI Data Analysis SQL Python Advanced Excel Power Query DAX Data Validation Forecasting Pandas +6 more