Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic

Naman Gupta

Bengaluru

Summary

Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

5
5
years of professional experience

Work History

Senior Data Analyst

Sigmoid bengaluru
03.2024 - Current
  • Developed and enhanced algorithms and models to solve business problem
  • Provided end-to-end analysis support across different industry domains and application areas
  • Generated data cuts/outputs according to agreed specifications (for example, survey data clean up, weighting data, recoding variables, creating custom tabular views, and running cross-tabulations)
  • Conducted quantitative analyses and interpreted results.
  • Streamlined data analysis workflows for increased efficiency and faster decision-making processes.

Senior Business Analyst

TEKsystems (client- HP, IQVIA)
05.2022 - 03.2024
  • Analyze secondary data and desk market research to identify key findings and trends
  • Collaborated with cross-functional teams to identify key metrics and KPIs, leading to development of customized reports
  • Assisting clients with optimizing data access performance, such as reviewing SQL Queries and analyzing data transfer and suggesting improvements
  • Recommend go-to-market actions based on analysis findings to senior leaders
  • Develop thorough understanding of business data and their underlying processes and apply Big Data analysis techniques to transform data into information and actionable insights
  • Deliver customer behavior insights and recommendations to internal clients including merchandising, marketing, omnichannel, store ops, and executives
  • Build dashboards and analytics reports and derive insights and create storytelling about customer behavior across marketing channels and provide optimization recommendations.

Data Analyst

Vedantu bengaluru
12.2021 - 05.2022
  • Act as Single Point of Contact for all data repositories and develop metrics to analyze pertinent information and share insights through various reports, dashboards on a sustainable basis
  • Data validation and attention to detail is required as this role will be accountable for the quality of all numbers delivered through dashboards or otherwise
  • Ensure data collection is optimized to provide crystal-clear visibility into past, present, and future behaviors of customers.

Data Support Engineer

Amazon Hyderabad
08.2019 - 11.2021
  • Ingesting & Transforming data with tools like MySQLAutomating Scripts and enhancing code according to business needs Worked with BI Analysts to ensure that the solution is meeting the business needs Liaise with sources and internal stakeholders to resolve issues regarding usage reporting Provided Functional support to business team members during deployment phase
  • Automating Scripts and enhancing code according to business needsWorked with BI Analysts to ensure that t solution is meeting business needs
  • Liaise with sources and internal stakeholders to resolve issues regarding usage reporting
  • Provided Functional support to business team members during deployment phase

Education

B.TECH -

ABESIT College of Engineering
Ghaziabad
2019

High School Diploma -

Sarla Chopra DAV Public SchoolCBSE
Noida
05.2015

Skills

  • Predictive Analytics
  • Languages : SQL ( PostgreSQL , MYSQL ) , Python ( pandas )
  • Cloud Computing : GCP( Big Data, Data Lakes)
  • Visualization : Tableau, Power Bi , Looker
  • Platform : Metabase, Databricks , VScode , Git
  • ETL processes
  • Excel
  • Data Administration
  • Root Cause Analysis
  • Business process mapping
  • Topic Modelling

Additional Information

1.File Format Converter Handout
Overview
The objective of this project is to develop solutions based on the design provided. In this case, the source data was obtained in the form of CSV files from a MySQL DB.


To improve the efficiency of our data engineering pipelines, we need to convert these CSV files into JSON files, since JSON is better to use in downstream applications than CSV files. The scope of this project involves converting CSV files into JSON files.

Technologies Used
Programming Language – Python
Pandas – For Converting CSV to Dataframe and then Dataframe into JSON.




2.Files To Database Loader Handout

Overview
The objective of this project is to develop solutions based on the design provided. In this case, the source data was obtained in the form of files from a MySQL DB.


We require the data to be loaded into PostgreSQL, which is a common scenario in companies who want to change underlying database technologies, in which case the data from one DB needs to be migrated into another DB. The Project scope is to migrate file-based data to PostgreSQL tables

Technologies Used
Programming Language – Python
Pandas – For Converting CSV to Dataframe and then load the Dataframe into Postgres Database

Timeline

Senior Data Analyst

Sigmoid bengaluru
03.2024 - Current

Senior Business Analyst

TEKsystems (client- HP, IQVIA)
05.2022 - 03.2024

Data Analyst

Vedantu bengaluru
12.2021 - 05.2022

Data Support Engineer

Amazon Hyderabad
08.2019 - 11.2021

B.TECH -

ABESIT College of Engineering

High School Diploma -

Sarla Chopra DAV Public SchoolCBSE
Naman Gupta