Overview
Work History
Education
Skills
Software
Interests
Timeline
Generic

Nishant Singh

Business Intelligence Engineer II
Bengaluru

Overview

7
7
years of professional experience
4
4
years of post-secondary education

Work History

Business Intelligence Engineer II

Amazon
01.2024 - Current
  • NASCAR Lead Management: Established AWS infrastructure and built a centralised dashboard for 239 monthly users to track brand pipeline progress, key metrics, and self-serve reporting
  • This solution replaced multiple obsolete reports, delivering 15 HC monthly time savings and generating 3.5 K views in the past year
  • OLP (One Lead Pipeline): Engineered a critical automation layer for NASCAR Lead Management that integrates lead programs, SM signals, and comprehensive brand data
  • This sophisticated system automates the NASCAR Lead Management UI while providing robust cross-program reporting capabilities, generating approximately 200 HC yearly time savings for Vendor Managers
  • Vendor Segmentation: Built vendor profiles based on listing experience for a Hold-out and high-profile customer most-wanted brands
  • This helped analysing listing behaviour of different vendor cohorts which informed our technology vision with actual industry requirements
  • It revealed why leading vendors struggled to partner with platforms to streamline their listing and catalog management costs
  • Beacon Migration Pipeline Redesign: Revamped the brand evaluation pipeline to accommodate new data sources and tools, providing VMs with insights across Pre-Pitch Analysis, Brand Identification, and Post-Onboarding stages
  • Implemented Nielsen data integration and enhanced features, projecting a €250 million 3-year product impact

Senior Data Science Consultant

Ernst & Young
05.2021 - 01.2024
  • Campaign Analytics: Developed an analytical approach for CD Retention, using Clustering and Rule-Based Algorithms
  • This strategy significantly reduced out-of-bank money movement for retail products, resulting in a monthly incremental of $210 million
  • Channel Analytics: Created a custom financial transaction journey mapping engine on GCP using Big Query and Python, reducing mapping time by approximately 300%
  • Subsequently, worked on customer/journey and channel analysis, including Digital Spillover, Hopper-Dropper, and Customer Sentiment analysis
  • Propensity to shift to Digital Channel Analysis : Conducted in-depth analysis using Python/SQL to identify customers with a high potential for transitioning from offline to digital channels, leading to a remarkable 9% increase in the digital adoption rate within a month
  • Implemented this analysis within a classifier framework for ongoing optimization

Senior Business Analyst

Dell Technologies
01.2020 - 05.2021
  • Propensity to Buy LOB Analysis: Worked on a Machine Learning model using Python and created a data pipeline to forecast customers' propensity for their next Line of Business purchase on a quarterly basis
  • This model empowered the marketing and sales teams to accurately identify 91% of the total customer base, leading to a remarkable incremental revenue of $74 million over the quarter
  • Buyer Base Analysis : Developed a comprehensive analytical data pipeline/framework using SQL, Python, Statistics, and SSIS, facilitating in-depth analysis of the Customer Life Cycle (CLC), RFM analysis, and Switch rate for various levels of Dell Technologies support and services
  • Portfolio Performance Dashboard : Designed and deployed multiple Tableau Dashboards that enhanced visibility into portfolio performance, resulting in a 75% increase in data-driven decision-making and the efficient management of support and services across regions
  • Portfolio Trend Scanner : Engineered an automated trend scanner that analyzed N portfolio metrics across M levels
  • This solution efficiently identified issues in trends by analyzing the slope of each metric trend, significantly reducing issue identification time and enhancing efficiency by 35%

Decision Scientist

Mu Sigma
10.2017 - 01.2020
  • Advanced Customer Targeting: Created a prioritization framework to identify potential customers who are likely to renew their service contract before its expiry
  • This R and SQL based robust Classifier framework helped the client to increase their renewal rate by 6% and also fetch 3M additional revenue
  • Drug Safety Analysis in RWE: Conducted a study in the US Claims Data in SAS and ML to prove the safety of a Phase-IV drug in terms of Adverse events as a part of the safety report for FDA by leveraging Regression techniques for the outcome
  • Application Analytics: Worked on defining user-related KPI's to enhance users' experience and determine features priority
  • This improved the average application usage time from 2.3 Minutes to 5.1 Minutes for following month

Education

Bachelor of Technology - Computer Science & Engineering

KIIT University
08.2013 - 07.2017

Skills

  • SQL

  • BigQuery

  • SparkSQL

  • Python

  • Excel

  • Predictive Analytics

  • Data Analytics

  • Clustering

  • Business Intelligence

  • Customer Analytics

  • Banking Analytics

  • Customer Segmentation

Software

Tableau

QuickSight

GCP

Athena

SAS Studio

AWS(EC2, DynamoDB,Redshift,Lambda)

MS Office

Interests

Stakeholder Interaction

Story Boarding

Team Management

Problem-solving

Timeline

Business Intelligence Engineer II

Amazon
01.2024 - Current

Senior Data Science Consultant

Ernst & Young
05.2021 - 01.2024

Senior Business Analyst

Dell Technologies
01.2020 - 05.2021

Decision Scientist

Mu Sigma
10.2017 - 01.2020

Bachelor of Technology - Computer Science & Engineering

KIIT University
08.2013 - 07.2017
Nishant SinghBusiness Intelligence Engineer II