Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Matin Shaikh

Pune

Summary

Dedicated and Confident Data Professional with almost 7 years of Experience into preparation of analytical reports, Dashboards using Advance Excel and for 1 last year using with Power BI as well in HR analytics.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Senior Reporting Analyst

Gallagher
04.2022 - 06.2024


  • Coordination With Stakeholders, Recruiters
  • Collection of data from Pan India Recruiters
  • Creation of Onboarding Report according to batch
  • Creation of Head Count Report (Master Joiners Data)
  • Visualizing Excel reports Like Source Mix/ Recruiter Performance/Vendor Performance etc using Tools and Advanced Excel
  • Creating Dashboard (Cards/Charts/Graphs using Power BI)
  • Creation of One time Payment - Joining Bonuses and Referral Incentives on Every 15th of month
  • Enhanced business decision-making with comprehensive reports and analyses.
  • Developed custom dashboards to track key performance indicators, resulting in increased efficiency.

Senior Associate

Tech Mahindra
04.2021 - 01.2022

• Preparation of Pan India Agent performance report on Excel [ Productivity, FTF, ASAT Scores]
• Preparation of pan India KPI report using Advance Excel with different formulas
• Downloading Dump for from multiple CRM’s [ Swift, Sumeru, Hyperion tool]
• Uploading daily closures data in SQL on daily basis
• Preparation of reports for different processes [Wcom, NFLC]
• Providing data as per client’s requirement
• Providing overall dump as per requirement
• Providing hourly dump as per requirement
• Providing Training to new team members
• Checking and Answering escalation and other mails on daily basis

CRM-MIS Executive

Richfeel Health and Beauty Pvt Ltd
02.2017 - 01.2021

• Preparing daily sales report in excel (invoice/billing & receipts entries difference between Tally v/s CRM)
• Preparing appointment and NC report on daily basis with useful information by providing to respective department
• Doing invoicing/billing in TALLY ERP 9.0 and CRM on behalf of clinic due to lack of availability of accountant
• Converting raw data into useful information using advance excel
• Co-ordination of MIS reports with different departments (lab/customer care)
• Maintaining day to day operations (Support to the staff regarding invoicing and other operational entries)
• Training of new joiners & technical support of CRM software (newly developed)
• Solving the problem of concerned department (lab/clinics/call center/customer care/operations/inventory)
• Providing ideas for development of new CRM & required help in implementing the new CRM
• Preparing documents regarding different- different modules in the CRM software as per manager
• Coordinating to the HOD of concerned department regarding their query and requirement in CRM
• Working as a team player and leading CRM team
• Preparation of clinics audit report of done and not done entries and sending them on daily basis
• Preparation of user manuals for all the operation module in the CRM using Microsoft word

Education

MBA - Finance

Gahlot Institute of Management Studies & Research
Navi Mumbai
05.2014

Bachelor of Commerce - Accounting

DSM College of Art Commerce And Science
Parbhani
01.2010

Skills

  • Power BI Expertise
  • Advanced Excel
  • Advanced Data Analytics
  • Data Analysis
  • Basics of SQL
  • Collaborative Teamwork

Certification

Power BI

Tally ERP 9.0

Timeline

Senior Reporting Analyst

Gallagher
04.2022 - 06.2024

Senior Associate

Tech Mahindra
04.2021 - 01.2022

CRM-MIS Executive

Richfeel Health and Beauty Pvt Ltd
02.2017 - 01.2021

MBA - Finance

Gahlot Institute of Management Studies & Research

Bachelor of Commerce - Accounting

DSM College of Art Commerce And Science
Matin Shaikh