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
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
Similar Profiles
Nikita ShuklaNikita Shukla
Finance Executive at Omnicom Media Group India Private LimitedFinance Executive at Omnicom Media Group India Private Limited
EVANJELIN PREETHI EVANJELIN PREETHI null
Senior Campaign Manager at Vuchi Media Private Limited , HydreabadSenior Campaign Manager at Vuchi Media Private Limited , Hydreabad
Mahesh HadapadMahesh Hadapad
Data Analyst at Omnicom Media Group India Private LimitedData Analyst at Omnicom Media Group India Private Limited