Vishal Koli
Navi Mumbai
Summary
Detail-oriented Business Analyst with experience in MIS reporting, data analysis, and dashboard creation within performance-driven environments. Proficient in Microsoft Excel (Pivot Tables, VLOOKUP, INDEX-MATCH), Google Sheets, and Power BI for handling large datasets, automating reports, and tracking KPIs.
Experienced in generating daily, weekly, and monthly reports, ensuring data accuracy, and delivering actionable insights to support business decisions. Strong ability to coordinate with cross-functional teams, identify trends and discrepancies, and improve reporting efficiency through automation.
Overview
7
7
years of professional experience
Work History
Associate Business Analytics
Sachin Bhosale Consultancy
Mumbai
02.2025 - Current
- Maintained and updated large datasets, MIS systems, and performance tracking reports to ensure data accuracy and consistency.
- Generated daily, weekly, and monthly MIS reports for management, tracking KPIs such as revenue, conversions, ROI, and campaign performance.
- Analysed data trends and identified actionable insights to support business decisions and improve performance outcomes.
- Built and maintained dashboards using Microsoft Excel, Google Sheets, and Power BI for real-time monitoring of key metrics.
- Applied advanced Excel functions including Pivot Tables, VLOOKUP, INDEX-MATCH, and data cleaning techniques for multi-source data analysis.
- Automated recurring reports and dashboards using Excel templates and formulas, reducing manual effort and turnaround time.
- Coordinated with cross-functional teams (marketing, operations, and clients) for data collection, validation, and reporting alignment.
- Ensured data integrity by identifying discrepancies, performing data validation checks, and resolving inconsistencies.
- Tracked and monitored KPIs and performance metrics, highlighting gaps, and recommending corrective actions.
- Supported data-driven decision-making by delivering structured reports, dashboards, and performance insights to stakeholders.
Associate system analyst
TSS Consultancy PVT. LTD.
Mumbai
09.2023 - 01.2025
- Performed KYC verification and customer due diligence (CDD) by reviewing client documentation.
- Monitored client accounts to detect data discrepancies, and operational risks.
- Investigated and resolved client account issues while ensuring compliance with internal policies.
- Managed support tickets using helpdesk platforms, and ensured timely issue resolution.
- Executed SQL queries to retrieve and validate customer data for troubleshooting.
- Coordinated with internal teams, clients, and to resolve verification issues.
- Participated in daily operational review meetings to address high-priority cases.
- Maintained records of investigations, ensuring transparency and audit readiness.
Lab Technician
Jaslok Hospital
Mumbai
02.2022 - 04.2023
- Conducted biochemical and microscopic analysis of patient samples for diagnostic evaluation.
- Followed strict SOPs and quality control protocols in laboratory operations.
- Managed sample processing, documentation, and equipment maintenance.
Technician in Chest Medicine Laboratory
K. E. M. Hospital
Mumbai
01.2019 - 01.2022
- Conducted pulmonary diagnostic tests and analyzed biological samples.
- Maintained accurate laboratory documentation and testing records.
- Supported diagnostic operations during the COVID-19 pandemic response.
Education
professional certificate program - Business Analytics and Consulting
upGrad University
01.2026
Diploma of Higher Education - Post graduate diplome in Medical lab technician
Nashik University
01.2019
Bachelor of Science - Chemistry
University of Mumbai
Mumbai, MH01.2016
Skills
- Microsoft Excel
- Google Sheets
- Data Analysis and Reporting
- MySQL
- Power BI
- Tableau
- Operational Risk Identification
- KYC verification
- Account monitoring
- Client issue investigation
- Client Relationship Management
- Project Management
- Customer Due Diligence (CDD)
- Ticket and Escalation Management
- Python
- CKYC portal
- CRMs
- Help desk
LANGUAGES
English
Marathi
Hindi
Timeline
Associate Business Analytics
Sachin Bhosale Consultancy
02.2025 - Current
Associate system analyst
TSS Consultancy PVT. LTD.
09.2023 - 01.2025
Lab Technician
Jaslok Hospital
02.2022 - 04.2023
Technician in Chest Medicine Laboratory
K. E. M. Hospital
01.2019 - 01.2022
professional certificate program - Business Analytics and Consulting
upGrad University
Diploma of Higher Education - Post graduate diplome in Medical lab technician
Nashik University
Bachelor of Science - Chemistry
University of Mumbai