Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Deepti Bansal

Jaipur

Summary

Data Analyst with extensive experience in SQL, statistics, and data analytics algorithms. Adept at designing and teaching Data Structures and Algorithms (DSA). Proven ability to simplify complex concepts and foster a learning environment that encourages growth and understanding.

Overview

Work History

Analyst

SHOPSENSE RETAIL TECHNOLOGIES PRIVATE LIMITED (RELIANCE GROUP)
11.2022
  • Formulated and tested multiple hypothesis to optimize the user journey by identifying the key problem areas in the user journey
  • Assisted in conducting in-depth interviews, focus groups to understand consumer behaviors, motivations, and preferences
  • Managed survey projects, including questionnaire design, sampling, and data collection, using online survey platforms
  • Analyzed research data to derive actionable insights
  • Compiled and synthesized research findings into clear, concise reports and presentations for internal and external stakeholders
  • Developed and maintained customer segmentation models to target key consumer groups effectively, resulting 30% increase in retention
  • Tools used: Google Analytics, Advance Excel, Python, GCP

Data Analyst

TESCO PVT LTD
03.2022
  • Generated weekly trade insights, including Like-for-Like (LFL) growth, LFL volume, total sales for more than 150 categories, and individual product contributions
  • Developed and implemented a Master Grids report, calculating the impact of key factors such as IGD, Trade Plan, Trade events, weather, and marketing activities on weekly sales
  • Delivered weekly trade presentations to stakeholders including CXO’s, identifying opportunities for optimizing the impact of individual factors on total sales
  • Publishing Weekly performance newsletter to The Financial Times & The Guardian newspapers
  • Tools used: SQL, Advance Excel, Python

Assistant Manager Analytics

AU SMALL FINANCE BANK
08.2021
  • Automated 15+ Reports using SAS and SQL for different function in Credit Card Business (Sales, Product, Credit Risk) covering 40+ key KPI’s
  • Competitor Analysis and Insights for benchmarking against industry by collecting data from various sources (i.e., RBI, Visa Analytics Platform, Bureau etc.)
  • Initiated the Visualization and Dashboarding practice (first in the bank) using Power BI for better story telling enabling dynamic slicing and dicing of data
  • Tools used: SAS, SQL, Advance Excel, Python, Power BI

Education

B.Tech - Electronics & Communication

Swami Keshwanand Institute of Technology

Rajasthan Board of Secondary Education

Skills

  • TECHNICAL SKILLS
  • Database :
  • MySQL, Oracle
  • Data Structures (Arrays, Linked Lists, Trees, Graphs)
  • Proficient in Advanced Microsoft Excel
  • Teaching and Curriculum Development
  • Applied Statistics: Descriptive and Inferential statistics for hypothesis testing
  • Programming: Python
  • Advance Excel
  • SAS
  • Python
  • BI Reporting & Data Visualization: Tableau, Google Data Studio, Google analytics
  • KEY SKILLS
  • Qualitative and Quantitative Research Methodologies
  • Familiarity with online survey platforms (eg, SurveyMonkey)
  • SAS, SQL, Advance Excel, Python, Power BI

Projects

Implementation of Classic Data Structures

  • Developed and implemented classic data structures including arrays, linked lists, stacks, queues, trees, and graphs.
  • Created comprehensive documentation and examples to explain the usage and advantages of each data structure.
  • Conducted performance analysis to compare the efficiency of different data structures.

Algorithm Optimization and Analysis

  • Designed and analyzed various algorithms such as sorting (quick sort, merge sort) and searching (binary search, linear search).
  • Implemented dynamic programming solutions to solve complex problems.
  • Evaluated algorithm performance and optimized code for better efficiency.

Teaching DSA Concepts through Interactive Workshops

  • Conducted interactive workshops to teach data structures and algorithms to students and professionals.
  • Developed engaging teaching materials, including slides, coding exercises, and quizzes.
  • Received positive feedback for the clarity and effectiveness of teaching methods.

Timeline

Analyst

SHOPSENSE RETAIL TECHNOLOGIES PRIVATE LIMITED (RELIANCE GROUP)
11.2022

Data Analyst

TESCO PVT LTD
03.2022

Assistant Manager Analytics

AU SMALL FINANCE BANK
08.2021

B.Tech - Electronics & Communication

Swami Keshwanand Institute of Technology

Rajasthan Board of Secondary Education
Deepti Bansal