LANGUAGES
Hindi (Native), English (Fluent)
Kartik Chouhan
MIS & Business Reporting Analyst Excel Power BI SQL SAP **************@*****.*** +91-637******* linkedin.com/in/kartikchouhan SUMMARY
MBA (Business Analytics) professional with hands-on experience in MIS Reporting, Business Operations, Data Analysis, and Executive Dashboarding. Experienced in preparing Daily, Weekly, and Monthly MIS reports, data reconciliation, stakeholder reporting, and business performance analysis using Excel, Power BI, SQL, SAP, and Python. Proven track record of developing management dashboards, automating reporting processes, supporting recovery of 12+ Crore outstanding receivables, and presenting business insights to CEO, CFO, and senior leadership teams for strategic decision-making. WORK EXPERIENCE
Management Trainee - Innovative Infra & Mining Solutions (IIMS), CKA Birla Group Nov 2025 – May 2026 (Hyderabad)
• Prepare and maintain Daily, Weekly, and Monthly MIS reports covering Sales, Operations, Inventory, Procurement, Manpower, Collections, and Outstanding Receivables.
• Develop executive dashboards using Power BI, Excel, and SAP for weekly board review meetings attended by CEO, CFO, and senior leadership.
• Analyze large datasets containing lakh+ records to identify trends, variances, operational gaps, and business opportunities.
• Utilize Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, data reconciliation, and advanced Excel functions for reporting and analysis.
• Collaborate with Sales, Finance, Operations, Procurement, HR, Inventory, Branch Managers, and Regional Managers to collect, validate, and reconcile business data.
• Automated data collection and reporting processes through survey-based data integration, enabling automatic dashboard updates and reducing manual reporting effort.
• Supported recovery of 3.2 Crore in receivables aged over 12 months through collection MIS, customer coordination, and management reporting within 2 months.
• Contributed to the development of a company-wide outstanding receivables dashboard that supported recovery of over 12 Crore in pending collections.
Data Science Intern – Celebal Technologies
May 2025 – August 2025 (Remote)
• Developed ETL pipelines using Python & SQL, improving data readiness
• Contributed to AI-driven business intelligence projects
• Performed data preprocessing and feature engineering for ML models Business Operations Analyst - CreativeLog
December 2024 – May 2025 (Remote)
• Prepared operational MIS reports and KPI dashboards using Power BI and Excel.
• Analyzed business performance metrics and supported management decision-making.
• Collaborated with stakeholders to improve reporting accuracy and operational efficiency. Power BI & Excel Projects
Built Power BI dashboards: Hospital operations, Sales insights, Customer churn analysis EDUCATION
Poornima University, MBA - Business Analytics and Digital Marketing (2024-2026)
• Student Coordinator: Coordinated various fests, events and several drives
• Anchor: Anchored various events conducted by the university, and won various anchoring competition S.S. Jain Subhod PG Autonomous College, B. Com (2021-2024) SKILLS
MIS & Reporting: MIS Reporting, Management Reporting, KPI Reporting, Business Performance Analysis. Advanced Excel: Pivot Tables, Advance Formulas, Conditional Formatting, Data Validation, Dashboard Creation, Report Automation BI & Analytics Tools: Power BI, Excel, SQL, Python, SAP, Tableau, Alteryx, Zoho Analytics, Visio Professional Skills: Stakeholder Management, Cross-Functional Coordination, Executive Reporting, Presentation Skills, Problem Solving, Critical Thinking, Business Communication