Pranav Lunkad
Pune
Summary
Experienced Service Management professional interested in transitioning to a Data Analyst role. Proficient in service delivery, process improvement, and ensuring customer satisfaction. Skilled in data analysis methodologies, statistical analysis, and data visualization. Capable of transforming complex data into actionable insights for strategic decision-making and process optimization. Seeking to leverage service management expertise and analytical skills to excel as a Data Analyst, committed to driving organizational success through data-driven approaches. Additionally skilled in root cause determination, API integration, client system mapping, SQL, Python, and data visualization tools.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Service Management Analyst
Accelya
09.2021 - 06.2024
- Triage, troubleshoot, and resolve critical severity production environment issues with an average response time of 40 minutes, ensuring minimal downtime and maximum client satisfaction
- As a service management employee, I ensure that analytical solutions and accuracy effectively deliver high-quality services to our clients
- We have successfully solved 2000+ tickets of recurring and ongoing production issues, improving system reliability and performance
- Pull logs for production instances and query data using tools such as DataDog, Jira, and Kibana, achieving a data analysis accuracy rate of 80%
- Specialize in triaging and determining root causes of bugs reported from multiple carriers and API partners through web applications, resulting in a 20% reduction in overall system errors
- Manage onshore and offshore projects from initiation to delivery phase, consistently meeting project deadlines
- Integrate and map client systems with API data, resulting in an improvement in data accessibility and usability
- Conduct functional, integration, performance, and usability testing for client applications, achieving a defect detection rate of 1%
- Automate scripts using Postman and SOAPUI, reducing testing time by 10% and improving testing efficiency
- Create and accurately maintain documentation for airlines and API partners and ensure clear communication and understanding of processes
- Proficient in Airline Passenger Name Record (PNR) creation process, NDC, air shopping, offer pricing, and order creation management
- Handle NDC client onboarding and offboarding, configuring Farelogix SPRK GDS for B2B and B2C transactions with an average onboarding/offboarding time.
Education
Bachelor of Engineering in Computer Engineering -
Pune University
Pune, India01.2021
Skills
- Service Management
- Root Cause Analysis
- API Integration
- Data Analysis
- SQL
- Python
- Data Visualization (Tableau, Power BI)
Certification
- Become a Data Analyst
- Power BI Essentials
- SQL Data Reporting and Analysis
- Tableau Essentials Training
Projects
Pizza Sales Data Analysis, https://github.com/Pranav190/pizza-sales, The Pizza Sales Data Analysis project involves analyzing sales data from a pizza restaurant chain to gain insights into customer behavior, product performance, and market trends. The goal is to identify opportunities for increasing sales, optimizing menu offerings, and improving operational efficiency.
Timeline
Service Management Analyst
Accelya
09.2021 - 06.2024
Bachelor of Engineering in Computer Engineering -
Pune University