Shamil Pannikkodan

About

Results-driven data analyst with experience in data analytics, business intelligence, and business operations. Skilled in turning raw data into actionable insights through reporting, dashboards, KPI analysis, and data-driven decision support.

Experience

• Freelance Data Analyst
  Self-Employed
  Apr 2026 – Present

  Analyzed datasets using Python, SQL, Excel, and Power BI to support data cleaning, analysis, visualization, and reporting. Built end-to-end analytics solutions including data preparation, exploratory analysis, KPI development, and interactive dashboards.

• Data Analyst
  Manha Facility Management Company · Chennai, Tamil Nadu
  Sep 2025 – Mar 2026

  Analyzed operational and facility management data using Excel and reporting tools to support day-to-day business operations. Prepared structured reports and performance summaries to improve visibility into operational activities.

• Full Stack Developer Intern
  Clovion Tech Solutions Pvt. Ltd. · Kanyakumari, Tamil Nadu
  May 2025 – Aug 2025

  Developed web applications using Python, Django, HTML, CSS, and JavaScript. Worked with SQL databases, APIs, and backend data handling.

Education

• Diploma in AI & Data Engineering
  Learn Logic AI
  Data Analytics, Machine Learning, Python, SQL, Excel, Power BI · 2024 – 2025
• Bachelor of Computer Applications (BCA)
  Yenepoya Medical College, Yenepoya (Deemed to be University)
  2025

Skills

• SQL <3 months
• CSS <3 months
• Data Analysis 1 to 2 years
• Data Engineering <3 months
• Data Visualization 6 to 12 months
• HTML <3 months
• APIs <3 months
• Python <3 months
• JavaScript <3 months
• Django <3 months
• Data Cleaning 6 to 12 months
• Matplotlib <3 months
• NumPy <3 months
• Pandas <3 months
• scikit-learn <3 months
• DAX <3 months
• Seaborn <3 months
• Data validation 6 to 12 months
• Trend analysis <3 months
• Business Intelligence 6 to 12 months
• Dashboard Development 6 to 12 months
• Statistical Analysis <3 months
• Exploratory Data Analysis <3 months
• KPI reporting 6 to 12 months
• Business Reporting <3 months

Tools / apps / platforms

• Microsoft Excel 1 to 2 years
• Microsoft Power BI 6 to 12 months
• PostgreSQL <3 months

Languages

• English Speak
• Malayalam Speak

Projects

• Smartwatch Sales Performance Dashboard
  Power BI

  Designed an interactive Power BI dashboard to analyze current-year versus previous-year sales performance and developed KPIs and visualizations covering monthly sales trends, order volume, and budget performance.

• E-Commerce Sales & Profitability Analytics
  SQL, Power BI, Excel

  Analyzed e-commerce sales data to evaluate revenue, profit, orders, average order value, and product performance. Built an interactive Power BI dashboard to monitor sales trends, profitability, regional performance, and category-level KPIs.

• Customer Churn & Retention Analysis
  SQL, Python, Power BI

  Analyzed customer-level data to identify churn patterns, retention trends, and high-risk customer segments. Developed an interactive Power BI dashboard covering churn rate, retention rate, customer segments, and key KPIs.

Courses & certifications

• Diploma in AI & Data Engineering · Learn Logic AI, Skill India, NCVET, IT-ITeS SSC Nasscom · 2025
• Internship Certification – Full Stack Developer · Clovion Tech Solutions Pvt. Ltd.
• Statistics for Machine Learning · Great Learning
• Machine Learning Certification for Beginners · Analytics Vidhya
• Data Analysis with Python · Cognitive Class
• AI – Data Engineer Certification · Learn Logic AI