Back to Developers
Rajnish Jangu

Rajnish Jangu

Engineer — Data & Operations Analytics

Hisar, Haryana 1+ yrs exp 79 · Very Good

About

NIT engineering graduate with 1.5 years of analytical experience and hands-on expertise in SQL, Python, ETL, data warehousing, data modeling, Power BI, and business analytics. Built end-to-end data solutions involving data preparation, validation, dimensional modeling, KPI analysis, and reporting, transforming enterprise data into reliable, analytics-ready datasets and business insights.

Skills & Expertise (11)

SQL Intermediate
7.4/10
1.5
Years Exp
Power BI Intermediate
7.0/10
1.5
Years Exp
Python Intermediate
6.5/10
1.5
Years Exp
Joins Window Functions Stored Procedures Pandas NumPy KPI Analysis Medallion Architecture SSMS

Work Experience

Engineer — Data & Operations Analytics

IOL Chemicals & Pharmaceuticals Ltd.

Jul 2024 - Nov 2025

Analyzed manufacturing data across 500+ API production batches to monitor process KPIs, yield, performance, and production efficiency. Conducted controlled A/B testing of Levetiracetam process conditions, analyzing batch-level phase-separation performance to identify the optimal operating approach and achieve a 24% reduction in acidic-layer separation time, from approximately 18–20 hours to 12–15 hours. Automated the month-end production reporting workflow using Power Query and Power BI, transforming recurring Excel production data into standardized KPI datasets and interactive dashboards, reducing report preparation time from approximately 1 working day to 2–3 hours (69%). Monitored production and solvent recovery data to identify process losses, contributing to an improvement in ethyl acetate and MDC solvent recovery efficiency from 92% to 94%.

Education

Bachelor of Technology in Chemical Engineering, Computer Science and Engineering (Minor) - NIT Jalandhar

2020 - 2024 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

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

Profile Overview

Member sinceSep 2026