Sandipan Mazumdar

• Ecommerce Sales Analysis - Myntra: KPI Development through Customized SAP HANA SQL Scripts based on Demands
• Developing KPIs example running sum, YTD, MTD sales, Aggregations using SQL Analytical Function and Comparative Analysis
• Dashboard, Graphs and Charts preparation using KPI Data in MS Excel
• Understanding Business Requirement and translating them into BI KPIs into Query Language
• Participating in Oracle DBMS and Data Warehousing Basics Training
• Achieving Client Satisfaction.

• Alef Education, Abu Dhabi: Alef Education runs several initiatives aimed at transforming K-12 education through innovative technology. Their primary project is the Alef Platform, which uses AI-driven personalization to enhance student engagement and performance.
• SQL Script development in Oracle 11g Database in Educational Management

System (EMS)

• KPIs development with 10 years of comparative data in Experienced Learning and

Educational System

• Graphs Charts development using KPI data in MS Excel and MS Power Point
• The Houbara Project under the IFHC: Project Includes the below operations with data and analytics
• SQL Script development and maintenance using Oracle 11g.
• Breeding Data: Number of Houbara bustards bred in captivity.
• Release Data: Information on birds released into the wild.
• Population Monitoring: Tracking survival rates and movement of released birds using tagging and GPS systems.
• Ecological Data: Habitat use, migration patterns, and adaptation.
• Genetic Data: Genetic diversity monitoring to ensure healthy populations.
• Research Data: Studies on species behavior, threats, and sustainable management.
• This data helps in evaluating the effectiveness of conservation strategies.
• Ashok Hall Group Of Schools:
• KPI Generation using Oracle SQL and MS Excel using student performance data.
• Student Achievement: Exam scores, graduation rates, and college acceptance rates.
• Attendance Rates: Student and teacher attendance.
• Student Progress: Year-over-year academic growth.
• Teacher Performance: Evaluation scores, professional development progress.
• Parental Involvement: Participation in school activities and communication.
• Financial Efficiency: Budget adherence, cost per student.
• Student Engagement: Extracurricular participation and behavior metrics.
• Resource Utilization: Library usage, technology integration.
• These KPIs help evaluate a school's success in education and administration.

• Analyzing market trends for different clients
• SQL Script development using competitive analysis data
• Consumer Behavior: Shifts in preferences or spending habits
• Competitive Analysis: Monitoring competitors' strategies
• Technological Advancements: New innovations disrupting the market
• Economic Indicators: Interest rates, inflation, and economic growth
• Regulatory Changes: New laws or regulations affecting industries
• Global Events: Geopolitical developments or global crises
• Sustainability and ESG: Focus on environmental, social, and governance factors.