Gaurav Papnai
Delhi
Summary
Results-driven analyst with expertise in data management and predictive analytics, honed at British Telecom. Skilled in developing impactful dashboards and reports that enhance decision-making. Proven ability to collaborate with stakeholders, and deliver actionable insights, driving improvements in customer engagement and operational efficiency. My diverse roles have equipped me with expertise in tools like Power BI, SQL, MySQL, and Tableau.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Service Request Coordinator-Analyst
British Telecom (e-serve)
Gurugram
07.2022 - Current
- Utilizing Power BI and M Language extensively to design advanced reports, dashboards, and present insights to stakeholders in an understandable format.
- Collaborating with cross-functional teams to define project requirements, develop solutions, and ensure alignment with business goals and analytics needs.
- Analyze customer behavior and preferences to improve services and develop targeted marketing strategies.
- Driving the continuous improvement of reporting processes, enhancing scalability, and ensuring business requirements are met through robust data visualization and analysis.
- Collaborated using PEGA for project management, ensuring timely delivery and alignment with client expectations.
Associate Consultant
EXL Service India Pvt. Ltd
Noida
12.2020 - 07.2022
- Data Management: Collect, clean, and organize order-related data on a weekly basis to ensure accuracy and consistency in reports.
- Applied SQL for data queries, joins, normalization, and data modeling to ensure accurate supply chain reporting.
- Report Creation: Develop and maintain Power BI dashboards and reports that provide insights into weekly orders, including volumes, trends, and customer segmentation.
- Performance Monitoring: Track metrics such as order processing times, shipment delays, or errors and provide actionable insights for improvement.
- Stakeholder Management: Participated in client meetings, offering insights and updates on project status.
- Utilized Power BI for dynamic report creation, and SQL for data extraction and analysis.
Business Advisor
Concentrix
Gurugram
08.2020 - 11.2020
- Coordinated with internal teams and external stakeholders to support business growth.
- Generated thorough and useful reports for use in business decision-making.
- Monitored key performance indicators for clients' businesses in order to measure success against objectives.
Graduate Engineer Trainee
DSM Limited
Delhi And Muzaffar Nagar
02.2018 - 02.2019
- Data Collection and Analysis: Gather and analyze data related to sugar production, cane quality, and factory operations to identify trends and areas for improvement.
- Reporting: Prepared detailed reports and visualizations using Advanced Excel to communicate findings to management.
- Collaboration: Worked closely with engineers, chemists, and other professionals to integrate data-driven solutions into operations.
Education
Bachelor of Technology - Mechanical Engineering
KIET Group of Institutions
Ghaziabad07-2018
12th-91.2% - Science
Swami Vivekanand
Ghaziabad05-2014
10th-9.4 CGPA -
Swami Vivekanand
Ghaziabad05-2012
Skills
- Data analysis
- Dashboard development
- Predictive analytics
- Data management
- Stakeholder management
- Report creation
- Project management
- Effective communication
- Power BI
- SQL Developer
- Market analysis
- PEGA & JIRA
Certification
- Data analyst from Learnbay pvt limited.
- Python programming for data analysis from Learnbay pvt limited.
Timeline
Service Request Coordinator-Analyst
British Telecom (e-serve)
07.2022 - Current
Associate Consultant
EXL Service India Pvt. Ltd
12.2020 - 07.2022
Business Advisor
Concentrix
08.2020 - 11.2020
Graduate Engineer Trainee
DSM Limited
02.2018 - 02.2019
Bachelor of Technology - Mechanical Engineering
KIET Group of Institutions
12th-91.2% - Science
Swami Vivekanand
10th-9.4 CGPA -
Swami Vivekanand
Similar Profiles
Arijit MajumdarArijit Majumdar
In-life Lead: E2E L2C Product Orchestration at British Telecom India Pvt. Ltd.In-life Lead: E2E L2C Product Orchestration at British Telecom India Pvt. Ltd.
Sk Imran QuraishiSk Imran Quraishi
Bill to Cash Operations Team Leader at British TelecomBill to Cash Operations Team Leader at British Telecom
Yashaswini ShanmukhaiahYashaswini Shanmukhaiah
Scrum Master at British TelecomScrum Master at British Telecom