Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Sahil Kolambkar

Sahil Kolambkar

Mumbai

Summary

With proficiency in Excel, Power BI, Python, Power Automate, and SQL. I specialize in optimizing workforce operations, extracting insights from data, and automating processes for better decision-making. I'm eager to learn and apply my skills to roles in data analysis, business analysis, and related fields.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Senior Analyst - Operations Business Intelligence

Firstsource
03.2024 - Current
  • Managed enterprise-level dashboards for training and hiring metrics by collaborating with senior management to ensure accurate reporting to the CEO and COO.
  • Handled reporting for Firstsource's largest client, SKY, with approximately 3,700 FTEs and over 200 team leaders.
  • Created and maintained reports including Shrinkage, Invoice dashboard, and Actual vs Forecast dashboard from multiple data sources and stakeholders.
  • Ensured data accuracy and consistency across all reports to support strategic decision-making.

Senior Analyst - Workforce Management

Firstsource
04.2023 - 03.2024
  • Lead advanced data analytics and visualization for customer management and corporate vertical to support leadership in decision-making
  • Created and maintained multiple interactive PowerBI dashboards providing deeper insights on data interpretation
  • Contributed to improvement in team efficiency through automation - automated report using Power Automate and Python which resulted in reducing the processing time to 6 mins as against 2 hours(time before automation)
  • Lead data analytics across customer management and corporate verticals using Prohance - worktime, work output, unaccounted absenteeism and thereby empowering managers to make informed decisions
  • Ensured seamless Prohance (WFM tool) deployment, troubleshooting and ensuring smooth operations and efficient utilization of the tool.

Data Analyst/Data science Intern

Almabetter
06.2022 - 04.2023
  • Completed real world projects using data science, data analytics and data visualization techniques
  • Worked on SQL case studies like Danny's Dinner, Pizza Runner and Foodie Fi
  • Gained proficiency in python programming
  • Learn skills like Feature Engineering, EDA, Power Bi, Tableau, and ML
  • Secured a place in the top 5% of students in the cohort of 367 students, which allowed me to work as a Subject Matter Expert for Doubt Resolution.

Education

Master of Business Administration: Finance -

Arunodaya University
01.2022

Bachelors in Information Technology -

Karmaveer Bhaurao Patil College
01.2017

Skills

  • Power BI/DAX proficiency
  • Power BI/Excel Dashboarding
  • Power Automate proficiency
  • Python proficiency
  • SQL proficiency
  • Data collection
  • Business data analytics
  • Management Reporting
  • Stakeholder Management
  • Advanced Excel Proficiency

Certification

Certified Full stack data scientist/analyst

Timeline

Senior Analyst - Operations Business Intelligence

Firstsource
03.2024 - Current

Senior Analyst - Workforce Management

Firstsource
04.2023 - 03.2024

Data Analyst/Data science Intern

Almabetter
06.2022 - 04.2023

Master of Business Administration: Finance -

Arunodaya University

Bachelors in Information Technology -

Karmaveer Bhaurao Patil College
Sahil Kolambkar