Summary
Overview
Work History
Education
Skills
Certification
Disclaimer
PROFESSIONAL SUMMARY
Advance Excel
Key Responsibilities:
Timeline
Generic
Sangam Gaur

Sangam Gaur

MIS DATA ANALYST
New Delhi,DL

Summary

Adding value to the organization by being a productive and an efficient leader, and a committed team member. Taking multifaceted challenge is what I aim at, to pursue my goals and rise above in my carrier Graph.

Professional MIS specialist with strong background in data management and systems analysis. Known for enhancing operational efficiency through comprehensive data analysis, system optimization, and strategic problem-solving. Highly collaborative, adaptable, and result-driven, with keen ability to support and improve team performance in dynamic environments. Skilled in SQL, data visualization, and process improvement, with focus on delivering actionable insights and achieving organizational goals.

Overview

13
13
years of professional experience
2011
2011
years of post-secondary education
1
1
Certification

Work History

MIS Analyst

Sampark Softwares Pvt Ltd.
10.2024 - Current
  • Developed custom reports to support decision-making processes, leading to more informed business strategies.
  • Designed visually appealing dashboards for easy interpretation of key performance indicators, assisting management in strategic planning efforts.
  • Improved overall data quality through consistent monitoring, review, and cleanup efforts as part of ongoing maintenance activities.
  • Optimized database performance by conducting regular maintenance and updates on existing systems.

MDS(Management Database System), MIS Reporting

Metropolis Healthcare Limited
07.2019 - Current
  • 6.1 Years of experience in the Data Analyst, responsible for managing and maintaining data.

Data Analyst, MIS Reporting

Kool-ex Cold Chain Limited
01.2018 - 06.2019

MIS Executive, SQL Database Associate Service Delivery Executive

RateGain IT Solution Private Limited
07.2014 - 11.2017

Associate

VERTEX
01.2013 - 11.2014

Education

Graduation BA -

12th - undefined

UP Board

10th - undefined

UP Board

Skills

Operating System: XP, Windows 7,10

Certification

GNIIT South-ex New Delhi.(NIIT)

Disclaimer

Category: IT / Computer Sub Category: Data Analyst Years of Experience: 6+ years State: Maharashtra Mumbai Gender: Male Highest Qualification attained: Graduate(Bachelor of Arts) Major / Specialization: Information Technology Email Id: sangam0251@gmail.com I hereby certify, that the particulars given herewith, are true to the best of my knowledge and belief. Place: Mumbai (Maharashtra) Date: ......../......./....... (Sangam Gaur)

PROFESSIONAL SUMMARY

  • Over 1.6+Year of experience in Software & Database Development. (SQL Developer)
  • Hands-on experience of SQL Server 2008 R2, SQL Server 2012, SQL Server 2017
  • Has the motivation to take independent responsibility as well as ability to contribute and be a productive team member.
  • Hands on experience of creating Store Procedure, Triggers, Function, Tables, Indexes

Advance Excel

Hands on Experience on using complex formulas like :- Pivot Table V-Lookup, H-Lookup, Nested If, Sum-product, Index, Match, Count function, conditional formatting, data validation, count, count if, if Statements.

Key Responsibilities:

  • Generate timely and accurate reports for analysis. Creating Dashboard report.
  • Automation, Reports/Dashboard designing.
  • Extensive usage of VBA/Macro Automation & MS Excel ( Lookups, Pivot table, Offset, Index, Match, Graph
  • Data Audit – Check data quality, identify gaps and create summary as per database requirements
  • Data Classification – Analyze procurement spend & identify saving opportunities using the analytics tool/spend data audit reports
  • Create and update category-specific and opportunity spend-assessment reports/templates
  • Preparation and presentation of weekly deck and monthly KPI (Key Performance Indicator) report.
  • Automation, Reports/Dashboard designing & application development
  • Creating report that can provide information on business activity. Reporting of daily, weekly or monthly. Report include data, graphics, chats, pivot tables, etc.
  • Preparing financial statement which includes sales, procurement, marketing, purchase order, promotion and other relevant stuff.
  • Analyzing company performance on a quarterly, half-yearly or yearly basis. This helps management for further decision making process.
  • Preparing Comparative Statement and Strategic Negotiation before finalizing the Order/ Contract.
  • Working with the spend (Spend Analytics) so as to choose best vendor to have contract in place.ible for Creating stored procedure, views in SQL server and automated reports via SQL Server.

Timeline

MIS Analyst

Sampark Softwares Pvt Ltd.
10.2024 - Current

MDS(Management Database System), MIS Reporting

Metropolis Healthcare Limited
07.2019 - Current

Data Analyst, MIS Reporting

Kool-ex Cold Chain Limited
01.2018 - 06.2019

MIS Executive, SQL Database Associate Service Delivery Executive

RateGain IT Solution Private Limited
07.2014 - 11.2017

Associate

VERTEX
01.2013 - 11.2014

12th - undefined

UP Board

10th - undefined

UP Board

Graduation BA -

Sangam GaurMIS DATA ANALYST