Vaibhav Khot

MIS Analyst

Pune MH 13+ yrs exp 90 · Outstanding

About

To be associated with a dynamic and progressive organization that will allow me to utilize my abilities and qualifications in the field to add value to the organization while providing me with opportunities for growth.

Skills & Expertise (30)

Power BI Desktop Advanced

8.5/10

Years Exp

Data Modeling Advanced

8.0/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

DAX Advanced

7.5/10

Years Exp

ETL Processes Advanced

7.5/10

Years Exp

Power Query Intermediate

7.0/10

Years Exp

Google Data Studio Intermediate

7.0/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

Snowflake Intermediate

6.0/10

Years Exp

Aggregation Dashboard Design Jira Power BI Services Database Management SQL Queries Data Modelling Data Analysis Pivot Table String Google Form Lookup Pivot Macro Word PowerPoint Advance Excel RMS SAP MM Google sheet

Work Experience

Assistant Manager MIS

Angelone

Jan 2023 - Present

Working on various reports with various departments manage data. Working on real-time dashboards and reports. Reporting Zonal head and regional head. Shearing reports and time manner with better insides. Handling on boarding team.

HR and Admin MIS

Logicon Management Pvt Ltd

Jan 2022 - Jan 2023

Maintain leave calendar and salary payout master to payout process. Technical person hiring as per the requirement. Managing office stationary and inventory id card distribution. Work on performance optimization of the dashboards and reports. Expert knowledge using advanced calculations using MS Power BI and MS-EXCEL.

SCM Coordinator (MIS)

SAMSUNG

Feb 2021 - Dec 2021

Day to day sales & Stock report share to RH, ZM, Sales team. Manage inventory planning, forecasting, and supply. Report all PAN India warehouse stock report. Interpreting Business User Requirements and translating them into insights in the form of Reports/Dashboard.

MIS Executive

Swiggy (Bundl Technology Pvt. Ltd)

Feb 2019 - Dec 2020

Providing Data support to multiple departments such as Sales, Operation and on boarding team. Process data and maintaining Excel sheets for different operations. Prepare & send Regular Report. Support to internal software (My SQL, Power BI, And various Dashboards).

Executive-Warehouse Admin

TVS logistics services ltd

Jul 2015 - Dec 2018

Ensure high service and product quality by monitoring “mis-picks” and productivity reports. Maximize order selection accuracy and shift productivity and work quality through hands-on coaching and performance evaluation. Use of SAP and manage transport.

Associate Team Member

SLK global BPO Services Pvt. Ltd

Aug 2011 - Oct 2012

Maintain SLA and TAT trackers of every assignment handled by team and providing it to Manager. Maintain daily tracker in Excel Sheet also creating templates and dashboards as per the Requirements.