JITENDRA JANGID
Data Analytics
Delhi
Summary
Results-driven Business Analyst with 3+ years specializing in SQL, Power BI, and Advanced Excel for impactful data visualization. Proven track record automating reports and dashboards, leading to an 8% increase in overall efficiency. Instrumental in developing data-driven strategies that directly fueled business growth. Eager to contribute analytical thinking and problem-solving skills in a dynamic, result-oriented organization.
Overview
7
7
years of professional experience
Work History
Assistant Manager - Consulting & Analytics
ICICI Lombard General Insurance Co
Delhi
09.2023 - Current
- Dashboards: Developed client-level performance dashboards, reducing manual reporting time by 50% compared to traditional pivot-based methods.
- Integrated customized SMS and WhatsApp business templates into the CRM using Jira, based on client requirements, resulting in a 15% improvement in customer retention for the insurance business.
- Data-Driven Initiatives: Led data-driven initiatives for top OEMs in the North Zone, analyzing client operations, ensuring optimal performance, and addressing operational gaps through regular dealership visits.
- CRM Integration and Reviews: Streamlined Top OEMs service file integration, enhancing onboarding. Conducted onsite reviews for operational improvements.
- Service Module Operations: Led service module operations for OEMs, optimizing call center efficiency and driving 8–10% MoM and YoY growth in the Delhi NCR region.
- Develop on-demand reports using business intelligence tools like Power BI, MS Excel and reporting it to clients and senior management.
- Design presentations for both internal and client's team identifying their improvement areas to drive their business growth.
Operations Manager
ShriJRG Food Products Pvt Ltd
Bengaluru
07.2021 - 08.2023
- Built a Dashboard to track the monthly sales and RTV on weekly basis and reported issues to higher management with great detail.
- Reduced the RTV to 20% by identifying the flaws in POs and sales at various platforms such as Swiggy, Blinkit, Zepto, Big Basket etc.
- Analyzed data trends to identify potential bottlenecks in operations workflow, implementing strategies to mitigate risks accordingly.
- Monitored performance metrics, identifying areas for improvement and implementing corrective actions as needed.
- Coordinated logistics for product shipments, ensuring timely delivery and compliance with safety regulations.
- Managed inventory levels, implementing strategies to reduce waste and optimize stock management.
Assistant Professor - Mechanical
Techno India NJR Institute of Technology
Udaipur
08.2018 - 06.2020
- Developed and implemented engaging curriculum for undergraduate courses in computer science, enhancing student comprehension and interest in technology.
- Mentored junior faculty and graduate students, providing guidance on research methodologies and teaching strategies to foster a collaborative academic environment.
- Designed assessment tools to evaluate student performance, ensuring alignment with learning objectives and fostering continuous improvement in educational outcomes.
- Organized workshops and seminars featuring guest speakers from the technology sector, promoting knowledge exchange and networking opportunities for students and faculty alike.
Education
M.Tech. - Metallurgical Engineering
Indian Institute of Technology
Mumbai 04.2001 -
B.Tech. - Mechanical Engineering
Government Engineering College
Bikaner, India 04.2001 -
Skills
- MS Office
- SQL
- Power BI
- Data Analytics
- Problem-solving
- Team mentoring
Timeline
Assistant Manager - Consulting & Analytics
ICICI Lombard General Insurance Co
09.2023 - Current
Operations Manager
ShriJRG Food Products Pvt Ltd
07.2021 - 08.2023
Assistant Professor - Mechanical
Techno India NJR Institute of Technology
08.2018 - 06.2020
M.Tech. - Metallurgical Engineering
Indian Institute of Technology
04.2001 -
B.Tech. - Mechanical Engineering
Government Engineering College
04.2001 -
Similar Profiles
AMAR SHARMAAMAR SHARMA
Sales Chat Agent at ICICI Lombard General Insurance CoSales Chat Agent at ICICI Lombard General Insurance Co
KAMAL KUMARKAMAL KUMAR
Unit Sales Manager at ICICI LOMBARD GENERAL INSURANCEUnit Sales Manager at ICICI LOMBARD GENERAL INSURANCE
Rakesh Kumar PattnaikRakesh Kumar Pattnaik
Unit Sales Manager at Icici Lombard General Insurance Company LimitedUnit Sales Manager at Icici Lombard General Insurance Company Limited
Jatinder SinghJatinder Singh
Executive Editor, CIO&Leader, CISO Forum and IT Next at 9.9 GroupExecutive Editor, CIO&Leader, CISO Forum and IT Next at 9.9 Group
Selva Prabhu JSelva Prabhu J
Senior Planning Engineer at Larsen & Toubro ConstructionSenior Planning Engineer at Larsen & Toubro Construction