Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Projects
Work Availability
Timeline
Generic
Deepak Singh Negi

Deepak Singh Negi

Data Analyst
New Delhi

Summary

Detail-focused Data Analyst with 4.5+ years of experience in interpreting and analyzing data for driving business solutions. Proficient knowledge in statistics and analytics. Good understanding of business operations and analytics tools for effective analysis of data.

Overview

4
4
years of professional experience

Work History

Data Analyst

Tech Mahindra
02.2022 - Current
  • Built out the data and reporting infrastructure from the ground up using Power BI, Excel and SQL to provide real-time insights into the product, marketing funnels, and business KPIs
  • Presented data models to business teams for review
  • Shared data models, boosted customer retention by 20%, and raised average transaction value by 15%.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Designed monthly Power BI reports, cutting issues by 25% and boosting revenue 12%.
  • Worked with complex datasets and trained new hires to work with them as well
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.

Analyst

Wipro
08.2019 - 01.2022
  • Worked in a web traffic data analytics process where analysis was done on user navigation habits using SQL and Power BI
  • This surfaced UX problems on the website and upon addressing those the web traffic was increased by 25% which resulted into sales increase of 10%
  • Researched and resolved data discrepancies with troubleshooting teams
  • Merged data with existing data sets, careful to keep old data sets and documentation
  • Communicated effectively with project management regarding issues and needs for projects
  • Investigated system issues and implemented resolutions to reduce downtime.

Education

B.Tech - Computer Science

Dronacharya College of Engineering - Gurgaon
07.2019

Skills

  • MS SQL Server
  • Hive
  • Advance Excel
  • Power BI
  • Python (Numpy, Pandas)
  • ETL
  • Microsoft Powerpoint
  • Data Warehousing
  • Business Needs Analysis

Accomplishments

    Microsoft Imagine Cup National Finalist (2017)

Projects

Sales Insight Dashboard Using Power BI

  • Built out the Sales data from the ground up using SQL.
  • Use power BI to perform ETL (Extract, transform, load) and data cleaning operations to make it ready to build the dashboard.
  • Build a powerful dashboard that can help to generate sales insights.


Cricket Data Dashboard Using Excel

  • Cleaning and organizing the raw data using Excel formulas.
  • Creating Pivot tables for different different scenarios as per the requirements.
  • Build a powerful dashboard using Pivot tables and Pivot chart and also in addition to quick filtering, adding slicers in the dashboard too.

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Analyst

Tech Mahindra
02.2022 - Current

Analyst

Wipro
08.2019 - 01.2022

B.Tech - Computer Science

Dronacharya College of Engineering - Gurgaon
Deepak Singh NegiData Analyst