● Open to Work

Koyana

Data Analyst | MIS Reporting | Software Testing | Business Analysis
Bangalore, Karnataka, India

About Me

M.Sc IT graduate (CGPA 8.84) with hands-on experience in data analysis, MIS reporting, Excel dashboards, and Python-based data processing. Processed 10,000+ row datasets, automated reporting workflows, and delivered KPI scorecards to operations and business teams. Currently working in Bangalore at Ucanly Infotech LLP. Actively seeking Data Analyst Trainee, MIS Executive, Software Tester, or Business Analyst Intern roles.

Skills & Technologies

Microsoft ExcelVLOOKUPPivot TablesINDEX-MATCHConditional FormattingDashboard DesignPythonPandasNumPyMatplotlibSQLJavaC/C++Scikit-learnTensorFlowKerasPyTorchNLPRandom ForestDeep LearningMIS ReportingKPI ScorecardsData VisualisationStreamlitManual TestingTest Case DesignBug ReportingFunctional TestingUATSDLCSTLCData StorytellingBusiness Requirement AnalysisRoot-Cause AnalysisOperations ReportingMicrosoft AzureGoogle Cloud PlatformJupyter NotebookVS CodePower BI

Work Experience

Business Development & Data Analytics Associate

Ucanly Infotech LLP
Jun 2026NOW

Analyze daily sales pipeline data using Excel to produce MIS reports and KPI dashboards supporting management decisions. Track and report over 50 daily client interaction metrics through structured weekly performance dashboards. Monitor lead conversion channels to improve pipeline visibility with data-driven analysis. Prepare weekly KPI scorecards on team performance contributing to strategic business decisions.

Data Analysis Industrial Trainee

Exide Industries Ltd
Sep 2025Oct 2025

Processed 10,000+ rows of manufacturing data using Excel functions (VLOOKUP, Pivot Tables, INDEX-MATCH) for MIS reporting. Developed an automated MIS report template reducing daily data consolidation by 30 minutes, adopted by operations analysts. Conducted root-cause analysis on production anomalies presenting findings to management. Generated weekly KPI scorecards tracking output, downtime, and efficiency across production lines.

Data Analysis Intern

Zscaler Academy
Apr 2024Jun 2024

Reduced manual security reporting time by 40% via Python pipelines to extract, clean, and organize cloud security logs. Delivered weekly MIS reports summarizing threat analytics across multiple simulated enterprise environments. Designed Excel dashboards tracking policy compliance KPIs using pivot tables and conditional formatting. Conducted business analysis identifying Zero Trust policy gaps and presented insights to senior mentors.

Projects

Social Media Sentiment Analysis Dashboard

Achieved 87% accuracy on a 15,000-tweet dataset using Random Forest and NLP pipeline combining text, image, and Twitter data. Reduced manual data-labelling effort by 60% through automated Python (Pandas, NumPy) data cleaning and processing workflow. Built interactive Streamlit reporting dashboard enabling non-technical stakeholders to query sentiment trends in real time.

PythonPyTorchStreamlitNLP+1

College Placement Analytics System

Improved recruiter shortlisting efficiency by 25% by building a Python scoring system ranking 200+ student profiles across 4 weighted KPIs. Replaced manual Excel tracking with automated MIS reports saving approximately 3 hours per placement cycle.

PythonExcelData Processing

Movie Recommendation System

Achieved 92% collaborative-filtering precision by developing a deep learning recommendation engine trained on 100,000+ user-movie interaction records. Reduced data processing errors by 35% through Pandas-based feature engineering and structured data cleaning pipelines.

PythonTensorFlowKeras

Education

Master of Science

Information Technology

Techno India University, Kolkata2023 - 2025

Bachelor of Science

Mathematics (Honours)

Bidhannagar Government College, Kolkata2018 - 2021

Higher Secondary Education (12th)

Ichapur Girls High School, Ichapur, West Bengal - 2018

Secondary Education (10th)

Shyamnagar Girls High School, Shyamnagar, West Bengal - 2016
Koyana - Data Analyst | MIS Reporting | | HiringAnt