ANIRUDHA KOLAY

ANIRUDHA KOLAY

Data Analyst & Business Intelligence Specialist
Badlapur West, 421503, Badlapur, India.

About

Data Analyst and Business Intelligence Specialist with expertise in Excel VBA, SQL, Power BI, and Python, adept at ETL processes, database management, and predictive analytics. Proven ability to translate complex business questions into actionable insights, driving measurable improvements in operational efficiency and strategic outcomes. Seeking to leverage advanced data analysis and machine learning skills to solve complex problems and contribute to data-driven decision-making in a dynamic organization.

Work

TCR INNOVATION PVT LTD
|

Python Intern

Navi Mumbai, India, India

→

Intern

Summary

• Developed machine learning models for fraud detection achieving 95% accuracy • Built Flask-based web applications with integrated ML models for real-time predictions • Processed 2M+ records using NumPy and Pandas for data preprocessing • Created API endpoints for model deployment and integrated with frontend applications

Projects

Sales Performance Analytics Dashboard

Summary

Developed a comprehensive Power BI dashboard to analyze 3-year sales data and provide real-time insights for sales performance.

Financial Reporting Automation System

Summary

Engineered an Excel VBA application to automate P&L report generation and streamline multi-source data consolidation.

Customer Segmentation Analysis

Summary

Conducted RFM analysis to segment customers and identify high-value contributors, enhancing targeted marketing strategies.

Inventory Optimization Model

Summary

Developed a predictive inventory optimization model and an Excel VBA tool for inventory managers, reducing stockouts.

Fraud Detection Analytics System

Summary

Designed and deployed an XGBoost-based e-commerce fraud detection model for real-time classification.

Healthcare Cost Analysis & Statistical Modeling

Summary

Performed healthcare cost analysis and statistical modeling on patient records to identify cost drivers and optimize treatment protocols.

Skills

Python
Microsoft Excel
Data visualization
Machine learning
Data Visualization

Power BI, Tableau, Excel Charts, Matplotlib, Seaborn, ggplot2.

Data Analysis

Excel (Advanced Functions, VBA, Power Query, Pivot Tables), SQL, Python.

Database Systems

MySQL, PostgreSQL, Oracle, MongoDB.

Statistical Analysis

Descriptive Statistics, Hypothesis Testing, Regression, Time Series Analysis, SAS, STATA.

ETL Tools

SSIS, Talend, Informatica, Power Query, Pandas.

Programming

Python (NumPy, Pandas, Scikit-learn), SQL, VBA, DAX, M Language.

Cloud Platforms

Google Cloud Platform.

Tools

Git, Jupyter Notebook, SPSS, SAS, Alteryx.

Certificates

Power BI

Issued By

IT Vedant

Tableau

Issued By

IT Vedant

Machine Learning

Issued By

IBM

Master in Data Science & Analytics with Artificial Intelligence

Issued By

IT VEDANT

Data Analysis with Python

Issued By

IBM

Advanced Excel

Issued By

IT Vedant

Education

University of Mumbai
Badlapur, India, India

→

Bachelor of Engineering

CSE (AI&ML)

Maharashtra State Board of Technical Education (MSBTE)
Nagothane, India, India

→

Diploma

Computer Engineering

Grade: 77.7%