RM Mrityunjay
Gurgaon
Summary
Customer oriented Business Analysis professional with 4 years of progressive experience. Dedicated towards contributing profits by improving self as well as team efficiency and productivity through business analytics and implementing the solution. Have met job demands and deadlines by successfully operating projects, facilitating sales & service techniques.
Overview
5
5
years of professional experience
Work History
Team Leader
Magicpin
Gurgaon
08.2023 - 06.2024
- Developed automated reporting processes using SQL queries on Google BigQuery and Streamlined reporting workflows to improve operational efficiency, resulting in an 30% reduction in reporting time.
- Analyzed and tracked key business metrics such as First resolution time, tickets to order ratio, solvable rates, and revenue to provide data driven
insights that informed strategic decisions. - Developed and optimized intricate SQL queries in BigQuery to efficiently extract and analyze large-scale datasets, resulting in a 40% reduction in query execution time and enabling more timely decision-making processes.
- Created and tested app flows for the customers to raise issues smoothly.
- Worked on product changes and automations to reduce the ticket to order ratio and overall cost.
- Worked closely with 3PLs and brands to reduce the rider related and order related issues.
- Managed a team of 40 agents, developed flowcharts to increase their efficiency.
Department Manager
Future Group
Bhubaneswar
04.2021 - 09.2022
- Did analysis on area wise sales and products for a State. Helped company to plan for inventory replenishment & Service delivery.
- Used descriptive analysis to optimize sales process i.e reducing customer waiting time for billing, on time delivery, setting optimal route for product delivery in supply
chain. - Kept track on sales staff's performance by using pivot table and used predictive analysis to assign them leads to call and follow up, improve pricing, enhance customer segmentation.
- Used diagnostic analysis to retain customers, examine market demand and set marketing campaign accordingly.
Assistant Department Manager
Future Group
Bhubaneswar
07.2019 - 03.2021
- Did demographic analysis to know buying power and customer interest in different
regions. - Did market research to analyze best place for hoardings set-up and Advertising activities.
Management Trainee
Future Group
Kolkata
02.2019 - 07.2019
- Analyzed pain points of customers and suggested appropriate solutions.
- Scheduled new product deliveries. Listened to individual complaints with open mind and asked detailed questions to understand issues.
Education
MBA - Business Analytics
Michigan States University
US05-2023
MBA - Marketing
KIIT University
IN04-2019
Bachelor of Science - Mechanical Engineering
Institute of Technical Education & Research
IN05-2017
Skills
- Advanced Excel
- SQL
- Google BigQuery
- Business Analysis
Project
Operation set-up at client base (Tata Digital)
• Led the setup and operationalisation of food and beverages home delivery services, overseeing all aspects of project management and execution.
• Developed and implemented standard operational procedures (SOPs) to ensure consistency and efficiency in service delivery.
• Provided comprehensive training to associates on resolving customer queries related to ticketing systems, enhancing their skills in customer service.
• Automated Google Sheets to generate key business metrics, including first resolve time, intermediate response time and ticket reason, enabling realtime
monitoring of associate performance, customer satisfaction, facilitating data-driven decision-making.
• Actively collaborated with cross-functional teams to streamline processes and optimize service delivery, driving continuous improvement initiatives.
Timeline
Team Leader
Magicpin
08.2023 - 06.2024
Department Manager
Future Group
04.2021 - 09.2022
Assistant Department Manager
Future Group
07.2019 - 03.2021
Management Trainee
Future Group
02.2019 - 07.2019
MBA - Business Analytics
Michigan States University
MBA - Marketing
KIIT University
Bachelor of Science - Mechanical Engineering
Institute of Technical Education & Research
Similar Profiles
Monika AnandMonika Anand
Marketing Associate at MagicpinMarketing Associate at Magicpin
GULSHAN RAWATGULSHAN RAWAT
Senior Content Analyst at MagicpinSenior Content Analyst at Magicpin
Shivabalu MShivabalu M
Key Account Manager at MagicpinKey Account Manager at Magicpin
Aadarsh SrivastavaAadarsh Srivastava
Area Sales Manager at MagicpinArea Sales Manager at Magicpin
Smriti RanaSmriti Rana
Technical Architect & Lead at Builder.aiTechnical Architect & Lead at Builder.ai