JAGESH RANJAN SHARMA
Production Planning & Data analyst | SAP | SQL | Power BI | Advanced Excel | Data-Driven Decision Making | Telecom & Electronics · Noida, Uttar Pradesh, India
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.
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.
Skills 0 proven through work
Also works with
Proof of Work
Proof of Work
JAGESH shares this with people who ask. You'll hear back either way.
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
Contact details
Contact details
JAGESH shares this with people who ask. You'll hear back either way.
Ask about this candidate
AI responses may contain errors. Proof status and source information are provided by Proof of Skill.
A Proof CV — one profile, kept current, with the proof attached. Back to the portal