Summary
Overview
Work History
Education
Skills
Languages
Personal Information
Timeline
Hi, I’m

Sudarshan Singh

ASST MANAGER IT AND MIS
JHANSI,UP
Sudarshan Singh

Summary

Results-driven professional with extensive experience in data analysis and visualization at Balinee Milk Producer Company Limited. Proven expertise in SQL database management and automated reporting, enhancing decision-making processes. Adept at collaborating with cross-functional teams to deliver actionable insights, driving performance improvements and operational efficiency.

Overview

18
years of professional experience

Work History

Balinee Milk Producer Company Limited

Asst Manager IT and MIS
06.2019 - Current

Job overview

Collected and cleaned data from internal and external sources to ensure accuracy and consistency.

Analyzed complex datasets to uncover trends, patterns, and insights for informed business decisions.

Created reports, dashboards, and visualizations to effectively communicate findings to stakeholders.

Collaborated with marketing, finance, and operations teams to understand business needs and provide relevant data insights.

Interpreted data analysis results to deliver actionable recommendations for business strategy.

Maintained and updated databases, ensuring data integrity and accessibility.

Developed automated systems for data processing and reporting to enhance efficiency.

  • Monitored budgets and expenditures to ensure cost-effectiveness while maintaining quality standards.
  • Conducted training on management information systems activities, improving staff expertise across departments.

MRM//McCANN

Senior MIS Executive
01.2018 - 06.2019

Job overview

  • Extracted data from SQL Server and prepared management reports for review.
  • Coordinated performance indicator data collection, analysis, and reporting with project teams.
  • Developed client presentations that highlighted key findings and insights.
  • Executed operational reports within MS SQL Server environment efficiently.
  • Compiled weekly and monthly reports for Maruti-Autocard Program.
  • Established effective communication channels between MIS department and other organizational departments.

Kapston-Facility Management Pvt. Ltd.

MIS Executive
01.2013 - 08.2017

Job overview

  • Coordinated data collection, analysis, and reporting on performance indicators for project teams and counterparts.
  • Developed MIS reports to track customer service performance and identify areas for improvement.
  • Created dashboards and visualizations to present data insights in an easy-to-understand format.
  • Developed data management templates and formats to enhance project activity tracking.
  • Supported Program Managers and M&E staff in planning and implementing baseline surveys and needs assessments.
  • Provided technical assistance to project staff through regular meetings, field visits, and coaching.
  • Prepared comprehensive reports daily, weekly, and monthly based on center-specific data.
  • Utilized advanced formulas such as V-lookup, Pivot Table, and Sumifs for report preparation.
  • Collaborated with State MIS Team and Project Head to ensure timely report submissions.
  • Processed travel allowances for trainees within a 15-day cycle.

Rosemerta Technology Ltd

Sr. MIS Executive
05.2013 - 11.2013

Job overview

  • Coordinated with dealers in Gurgaon, Faridabad, Bhopal, and Indore via calls and emails.
  • Compiled comprehensive reports on dealer cheque/cash receipts, recoverable amounts, and excess funds.
  • Automated reporting process for new orders, affixation, and pending orders of HSRP.
  • Generated invoices in Excel for dealer billing on a 15-day cycle across all project locations.
  • Conducted data compilation, verification, correction, and modification per software standards.
  • Created daily order booking reports detailing location-wise production, affixation, collection, and bank deposits.
  • Managed expense reports and reconciled MIS with software outputs in Excel.
  • Supervised MIS and data entry teams by allocating daily work assignments.

E-Meditek (TPA) Services. Ltd

MIS Executive
05.2011 - 05.2013

Job overview

  • Schedule or priority the work which help in timely delivery the report.
  • Creating Macro for schedule MIS.
  • Creating template for similar reports across clients, departments and teams.
  • Creating MIS/ Dashboard report and presenting it to the concern Department.
  • Prepare variance reports such as Forecast vs. Actual portfolio and so on related to various departments within the organization.
  • Resolving the Query of PSU and Private Insurance Company regarding services.

SCERT, Delhi

Technical Assistant
04.2010 - 05.2011

Job overview

  • Maintaining all hardware in the computer lab.
  • Maintaining the LAN.
  • Setup of Smart Board for smooth functioning of various meeting.
  • Uploading the Video and Audio Lecture on website of SCERT Delhi.
  • Conducting Video and Audio Conferencing.
  • Prepare Power Point Presentation.
  • Make all necessary arrangement for conducting a conference.
  • Conduct various competition for trainees and audio and video recording of the competition.
  • Make necessary arrangement for conducting audio or video conferencing.

IUAC, Delhi

Data Analyst
07.2007 - 12.2009

Job overview

  • Dispatch the Letters.
  • Drafting the Letters.
  • Documentation of Thesis and Paper as Requirements.
  • Make Graphs In Excel for the Research Data.

Education

Sridev Suman University
Badshahithaul, Uttarakhand

Master of Arts from Economics
07.2018

University Overview

  • Division 2
  • GPA: 50%

Makhanlal Chaturvedi National University of Journalism and Communication
Bhopal, Madhya Pradesh

Master of Computer Science
12.2007

University Overview

  • Division 1st
  • GPA: 69%

Uttarakhand Board of Technical Education
Roorkee, Uttarakhand

PGDCA from 2 Year Regula Diploma
07.2005

University Overview

  • Division 1st
  • GPA: 76%

HNB, Garhwal University
Srinagar, Uttarakhand

Bachelor of Science from PCM
07.2003

University Overview

  • Division 2nd
  • GPA: 54%

GIC Kotdwara
Kotdwara, Uttarakhand

10+2
07.2000

University Overview

  • UP Board
  • Division 2nd
  • GPA: 55%

GIC Kotdwara
Kotdwara, Uttarakhand

10th
07.1998

University Overview

  • UP Board
  • Division 1st
  • GPA: 60%

Skills

  • SQL database management
  • Data analysis
  • Data visualization
  • Automated reporting
  • Budget monitoring
  • Team collaboration
  • Process improvement
  • Project management
  • Documentation and reporting
  • Trend analysis
  • Performance evaluations
  • Vendor management
  • Data analysis and validation
  • MIS reporting
  • Conditional formatting
  • VBA programming
  • Macro development
  • Dashboard creation
  • Power BI and Power BI Desktop
  • SQL Server management
  • Microsoft Access proficiency
  • Advanced Excel skills

Languages

  • English
  • Hindi

Personal Information

  • Age: 38
  • Father's Name: Shri Shiv Singh
  • Date of Birth: 02/03/83
  • Marital Status: Married

Timeline

Asst Manager IT and MIS

Balinee Milk Producer Company Limited
06.2019 - Current

Senior MIS Executive

MRM//McCANN
01.2018 - 06.2019

Sr. MIS Executive

Rosemerta Technology Ltd
05.2013 - 11.2013

MIS Executive

Kapston-Facility Management Pvt. Ltd.
01.2013 - 08.2017

MIS Executive

E-Meditek (TPA) Services. Ltd
05.2011 - 05.2013

Technical Assistant

SCERT, Delhi
04.2010 - 05.2011

Data Analyst

IUAC, Delhi
07.2007 - 12.2009

Sridev Suman University

Master of Arts from Economics

Makhanlal Chaturvedi National University of Journalism and Communication

Master of Computer Science

Uttarakhand Board of Technical Education

PGDCA from 2 Year Regula Diploma

HNB, Garhwal University

Bachelor of Science from PCM

GIC Kotdwara

10+2

GIC Kotdwara

10th
Sudarshan SinghASST MANAGER IT AND MIS