Summary
Overview
Work History
Education
Skills
Languages
Affiliations
Hobbies
Timeline
Generic

Deepak Gupta

New Delhi

Summary

Proven Data Analyst with a robust track record at Sewa Grih Rin Ltd., where I leveraged Excel expertise and analytical problem-solving to enhance work efficiency. Skilled in translating complex datasets into actionable insights, I excel in driving revenue growth through data-driven decision-making and business intelligence.

Overview

5
5
years of professional experience

Work History

Data Analyst

Sewa Grih Rin Ltd.
Gurugram
03.2023 - Current

Analyzing and forecasting sales numbers as per the industry demand and projecting sales increase in accordance to that. Handling MIS for the organization. Business Analysis for an organization to substantially increase revenue through higher sales, closely inclined with the Finance team.

· Reporting to the head of Finance, I was hired to assume full analysis for the organization.

· Daily, weekly or monthly reporting needs to be ensured.

· Forecasting the demand for the products in the market, based on the target, as well as the market demand.

· Involved in the calculation of the forecast error, trends and reporting the same for the market.

· Preparing and analyzing reports based on monthly work, and presenting them to the executive management.

· Regulatory reporting, as per compliance.

· Competition Analysis, Product Sales Forecasting, Customer Analysis, Maintaining and analyzing Sales Trends, Business Analysis, Repeat Sales, and Loss Case Analysis.

Data Analyst

SOFT-TEC Software Solutions
Lucknow
01.2020 - 03.2023
  • Maintained documentation of all the processes related to Data Analysis.
  • Cleaned and processed large datasets to ensure data quality.
  • Collaborated with cross-functional teams to implement data-driven solutions to support decision-making.
  • Reduced reporting time by automation.
  • Translated raw data into meaningful information using statistical techniques.
  • Developed and implemented data collection systems and strategies to optimize statistical efficiency and data quality.
  • Prepared detailed reports by collecting, analyzing, and summarizing information and trends.

Education

B.Tech. in IT And Mathematical Innovation - IT And Maths

Cluster Innovation Centre, Delhi University
New Delhi
06-2018

Intermediate - Science

Vishwa Bharati Public School Dwarka Sec 6
New Delhi
06-2013

High School Diploma -

Holy Heart Public School Mahavir Enclave
New Delhi
06-2011

Skills

  • Excel Expertise: Pivot Tables, Power Query, VBA, Macros, Dashboards, Advanced Formulas (INDEX-MATCH, ARRAY, etc)
  • Data Cleaning and Preparation
  • Statistical Analysis
  • Data Visualization (Excel Charts, Power BI, Tableau)
  • SQL for data extraction
  • Reporting and automation
  • Business Intelligence
  • Gap analysis
  • Data filtering
  • Visual data representation
  • Data formatting
  • Defect tracking
  • Data exports
  • Analytical problem solving
  • Business needs analysis
  • Data mapping

Languages

Hindi
First Language
English
Upper Intermediate (B2)
B2

Affiliations

  • Was campus ambassador for Rio+20 program for India for sustainable development of United Nations
  • Part of National level theatre group at National School of Drama.

Hobbies

  • Reading novels
  • Listening to Music
  • Gardening

Timeline

Data Analyst

Sewa Grih Rin Ltd.
03.2023 - Current

Data Analyst

SOFT-TEC Software Solutions
01.2020 - 03.2023

B.Tech. in IT And Mathematical Innovation - IT And Maths

Cluster Innovation Centre, Delhi University

Intermediate - Science

Vishwa Bharati Public School Dwarka Sec 6

High School Diploma -

Holy Heart Public School Mahavir Enclave
Deepak Gupta