Anamika Kumari

About

MCA candidate with hands-on internship experience in business analysis, data analysis, and business intelligence. Skilled in Power BI, SQL, and Advanced Excel, with experience in requirements gathering, stakeholder communication, and Agile/Scrum collaboration.

Experience

• Business Analyst Intern
  TechOrbitals
  Nov 2024 – Feb 2025

Education

• Master of Computer Applications (MCA)
  ABES Engineering College
  Oct 2024 – Jun 2026
• Bachelor of Computer Applications (BCA)
  School of Management Sciences
  Oct 2021 – May 2024

Skills

• SQL
• DAX
• Requirements Gathering
• Root Cause Analysis
• Customer Segmentation
• Business Process Improvement
• Mis report

Projects

• Retail Customer Segmentation
  MySQL, Advanced Excel

  Designed a normalized relational database schema and wrote complex SQL queries to analyze customer behavior, identify high-value segments, and track sales trends. Generated structured MIS reports and used SQL indexing to optimize query performance.

• Amazon Sales MIS Dashboard
  Power BI, DAX, Power Query, MySQL, Excel

  Built an end-to-end BI dashboard tracking monthly sales trends, regional performance, product profitability, and revenue KPIs. Engineered DAX measures for Total Revenue, MoM Growth Rate, and Product Profitability; applied Power Query for transformation, cleansing, and quality assurance.

Courses & certifications

• Data Analytics Job Simulation · Deloitte
• Microsoft Power BI · Infosys Springboard