JAGESH RANJAN SHARMA

JAGESH RANJAN SHARMA

+•• ••••• •••••••••••@•••••.com

Production Planning & Data analyst · Dixon Technologies India Limited · 5.5 yrs

Data-driven professional with 4+ years of experience combining analytics and operations to drive business impact. At BT Group, I worked as a Data Analyst, designing Power BI dashboards, writing complex SQL queries, and delivering actionable insights across telecom operations and customer behavior. Currently at Dixon Technologies, I serve as a Production Planning & Data analyst, where I apply analytical tools like Power BI, SQL, Excel VBA, and Power Query to optimize order management, production planning, and dispatch efficiency. I’ve automated key reporting processes, improved on-time delivery performance, and supported cross-functional teams with real-time insights. Skilled in Power BI, SQL, Excel, DAX, and data storytelling, I thrive at the intersection of data, operations, and decision-making. I’m passionate about transforming raw data into strategic business outcomes—whether in telecom, manufacturing, or supply chain domains.

  • Noida, Uttar Pradesh, India
  • Remote, Hybrid, On-site

Ask about JAGESH

Skills

Claimed

Data ModelingMeeting FacilitationRequirements AnalysisStakeholder ManagementCross-Departmental CoordinationKPI AnalysisMicrosoft ExcelSQL Server Reporting Services (SSRS)

Proof of Experience

Production Planning & Data analyst

Dixon Technologies India Limited · Jun 2025 – Present

  • As a Production Planning & Control Engineer, leveraged data analytics to optimize production schedules, order fulfillment, and dispatch tracking.
  • Used tools like Excel, Power BI, Power Query, and SQL to automate reports, analyze gaps between order and dispatch, track material availability, and improve On-Time Delivery (OTD).
  • Collaborated cross-functionally with PPC, procurement, and logistics teams to deliver data-driven insights for production efficiency and customer satisfaction.

Associate engineer - Data analyst

BT · Mar 2021 – Apr 2025

  • Roles and responsibilities:
  • I design and maintain Power BI dashboards that visually represent complex data, making it easy for teams to monitor KPIs, track progress, and make data-driven decisions.
  • My role involves analyzing large datasets using pivot charts, uncovering trends that inform strategic planning and process improvements.
  • I monitor pending tasks and analyze workflow data, providing recommendations to improve efficiency and reduce delays in operations.I write SQL queries to retrieve specific data from large databases, transforming and preparing the data to support reporting and analysis needs across teams.

Proof-of-Work

No completed sessions yet. Anything JAGESH finishes shows up here with the evidence behind it.

Proof of Education

Bachelor of Technology - BTech, E Electronics and Communications Engineering

Dr. A.P.J. Abdul Kalam Technical University · 2015 — 2019

Mathematics

central hindu school · 2014

Degree

central hindu school , Gorakhpur

A Proof CV — one profile, kept current, with the proof attached. Back to the portal