Playing Badminton
Pawan Jangid
Manager (Analytics and Operations)
New Delhi
Summary
Encouraging manager and analytical problem-solver with talents for team building, leading and motivating, as well as excellent customer relations aptitude and relationship-building skills. Proficient in using independent decision-making skills and sound judgment to positively impact company success. Dedicated to applying training, monitoring and morale-building abilities to enhance employee engagement and boost performance.
Overview
4
4
years of professional experience
Work History
Manager (Analytics and Operation)
ICICI Lombard General Insurance Co
07.2020 - Current
- Combined my Power BI Skill with SQL and made analytics more Efficient.
- Inclusion of payment link in outbound SMS: Analyzed SMS conversion and customer queries across all automotive dealerships/ OEMs active on the product and introduced new SMS templates and payment link which helped the clients to improve their insurance business by 20%. Introduction of these payment links provided automotive dealerships to generate more revenue with little to no manpower assigned on the data thus solving their problem of lack of desired manpower.
- Zonal level Performance Tracker: Built Power BI dashboard to track client performance metrics on a zonal level involving data extraction through server. This dashboard reduces the time by 50 % when the same is generated through Excel and PowerPoint.
- Client Performance Dashboard: Built a weekly performance Power BI dashboard which helped clients in the data extraction from server as well software build excels reports. This reduced 40 mins of report preparation time required previously while using Excel and PowerPoint.
- Successfully executed a post-merger integration, meeting predefined timelines by implementing software solutions, fostering strategic partnerships, and building synergies.
- Achieved a 5% monthly recurring revenue growth for clients by designing and implementing a 'Targeted Discounting System' using lead lifecycle Data, while also contributing to a 10% increase in Unit Account Profitability.
- From Analysis based on Data, pivoted the Operations from an Integrated Model to Hub & Spoke by restructuring team to drive a 40% improvement in Productivity.
Intern in Analytics and Operation
ICICI Lombard General Insurance Co.
01.2020 - 07.2020
- Quickly learn new skills and apply them to daily tasks, improve efficiency and productivity.
- Develop and implemented performance improvement strategies and plans to promote continuous improvement.
- Use critical thinking to break down problems, evaluate solutions and make decisions.
- Create reports using MS Excel, Power BI and SQL for daily, weekly and monthly reporting.
Education
B. Tech - Civil Engineering
Institute of Technology, Nirma University
Ahmedabad 04.2001 -
Skills
Basic SQL
Interests
Watching Movies and We Series
Timeline
Manager (Analytics and Operation)
ICICI Lombard General Insurance Co
07.2020 - Current
Intern in Analytics and Operation
ICICI Lombard General Insurance Co.
01.2020 - 07.2020
B. Tech - Civil Engineering
Institute of Technology, Nirma University
04.2001 -
Similar Profiles
Abhishek ChetnaniAbhishek Chetnani
Senior Manager, Underwriting at ICICI Lombard General Insurance Company LtdSenior Manager, Underwriting at ICICI Lombard General Insurance Company Ltd
Surendra GodiSurendra Godi
Chief Manager- International Business Group at ICICI Lombard General Insurance Company Ltd.Chief Manager- International Business Group at ICICI Lombard General Insurance Company Ltd.
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
Manav SaxenaManav Saxena
Technical Lead at Digicommerce Solution LLPTechnical Lead at Digicommerce Solution LLP