Curiosity about aviation and logistics
RATNESH KUMAR
Operations & Planning Support Analyst
Patna,BR
Summary
Detail-oriented and analytical professional with 2 years of experience in operations coordination, data reporting, and stakeholder communication. Proficient in Excel-based analysis, planning documentation, and scheduling support within compliance-driven environments. Skilled at identifying operational issues, applying effective solutions, and ensuring full lifecycle tracking for successful project execution. Eager to contribute planning support and data-driven insights to a dynamic network planning team.
Overview
2
2
years of professional experience
3
3
years of post-secondary education
Work History
Operations & Planning Support Analyst
Megistron Media Private Limited
05.2023 - 04.2025
- Prepared structured reports in Microsoft Excel using advanced formulas, pivot tables, filters, and conditional formatting to highlight trends and identify gaps, supporting data-driven decision-making and strategic planning discussions.
- Utilized Excel and calendar-based planning sheets to streamline internal coordination for strategic project evaluation and timely approvals.
- Created and analyzed KPI reports to uncover optimization opportunities and inform future scheduling and resource planning.
- Collaborated with cross-functional teams (operations, development) to align planning schedules and ensure documentation accuracy.
- Maintained standardized communication templates and submission checklists to ensure timely and compliant coordination with internal and external stakeholders.
Education
Bachelor in Business Administration - business analytics, operations strategy, market coordination
Patna University
07.2018 - 05.2021
Skills
Strategic Planning Support
Data Analysis
Report Preparation
Stakeholder Communication
Document Submissions
Operational Data Mapping
Performance Analysis
Cross-Team Collaboration
Microsoft Office Suite
Internal technical communications
Support ticketing systems
Remote support
Accomplishments
- Reduced reporting time by 30% by streamlining Excel templates and automating repetitive tasks using formulas and pivot tables.
- Improved data accuracy by 25% by introducing standardized tracking sheets for slot scheduling and documentation.
- Enabled faster internal approvals by implementing calendar-based planning tools, reducing back-and-forth between teams.
- Identified key performance gaps in operations using KPI reporting, which informed planning adjustments for higher efficiency.
- Developed structured submission checklist templates, ensuring 100% on-time compliance with documentation deadlines.
Interests
Analytical thinking
Team collaboration
Process improvement
Timeline
Operations & Planning Support Analyst
Megistron Media Private Limited
05.2023 - 04.2025
Bachelor in Business Administration - business analytics, operations strategy, market coordination
Patna University
07.2018 - 05.2021