Toffan Kumar Mahalik

Data Analyst with 2+ years of experience in data analytics and software development, skilled in Python, SQL, Power BI, and Excel. Experienced in Power BI dashboard development, DAX, Power Query, Power BI Service, ETL, Star Schema data modeling, KPI reporting, and delivering actionable business insights. Strong understanding of data validation, reporting automation, and business intelligence concepts to support decision-making and operational efficiency.

Software Developer - Abrosys Technologies Private Limited - Bhubaneswar

(2024-02 - 2025-06)

• Analyzed and managed structured data using MySQL, improving data accessibility and reducing report retrieval time by 30%.
• Optimized backend data processes, reducing manual publishing and reporting effort by 50% through workflow automation.
• Developed a Super Store Sales Dashboard using Power BI to analyze sales performance, profit trends, regional insights, and customer behavior, contributing to a 20% improvement in sales analysis efficiency.
• Published and maintained Power BI reports and dashboards using Power BI Service, managing report sharing and scheduled data refreshes.
• Designed and maintained star schema-based data models with fact and dimension tables for efficient reporting and analysis.

Python Developer - Droidshift IT Solutions Pvt Ltd - New Delhi

(2023-03 - 2024-01)

• Developed a Credit Card Transaction Dashboard in Power BI to monitor transaction trends, KPI performance, fraud indicators, and customer spending behavior.
• Created interactive visualizations and business reports using Power BI, SQL, and Excel, enabling 30% faster business insight generation.
• Performed data transformation using Power Query and optimized DAX measures to improve report performance and usability.
• Integrated data from SQL databases and Excel sources to create interactive business dashboards.

MCA - Fakir Mohan University (2022) Balasore

BSc - College of Basic Science and Humanities (2019) Bhubaneswar