Sanjay Singh, Developer in New Delhi, Delhi, India
Sanjay is available for hire
Hire Sanjay

Sanjay Singh

Verified Expert  in Engineering

Bio

Sanjay has expertise in full-stack data analytics solutions. He has built analytics systems and platforms from scratch to enable product, marketing, and sales teams to analyze and make data-informed decisions. Sanjay has also implemented a customer event tracking mechanism with the tech team and set up data lakes and warehouses using data infrastructure designs.

Portfolio

Emeritus
A/B Testing, BigQuery, Amplitude, Business Intelligence (BI), Data Analysis...
Healthplix
SQL, Mixpanel, MoEngage, Zoho CRM, Python, Data Visualization, Data Queries...
BOLD
SQL, Mixpanel, A/B Testing, Data Visualization, Data Queries, Redshift

Experience

  • Data Warehousing - 5 years
  • Tableau - 5 years
  • SQL - 5 years
  • ETL - 5 years
  • Dataiku - 3 years
  • Python 3 - 2 years
  • Redshift - 2 years
  • Mixpanel - 2 years

Availability

Part-time

Preferred Environment

Redshift, Google Cloud Platform (GCP), Tableau, Dataiku, Jupyter Notebook, SQL, Mixpanel, Amplitude, Segment.io, MoEngage

The most amazing...

...project I've built is a trial class booking methodology using tools for marketing to optimize their campaign based on conversion rates.

Work Experience

Manager Analytics

2021 - PRESENT
Emeritus
  • Built product event tracking with Amplitude and worked with the engineering team to implement it.
  • Built a data pipeline of sales data to power sales analytics, improving the sales team's output.
  • Created a reporting framework and architecture for the sales team to track sales performance at different dimensions.
  • Built user journey for the product team to help identify areas of improvement using A/B testing.
Technologies: A/B Testing, BigQuery, Amplitude, Business Intelligence (BI), Data Analysis, Data Cleaning, Data Pipelines, Data Reporting, Google BigQuery, ETL, Google Cloud Platform (GCP), Google Data Studio, SQL, Salesforce, Sales Analysis, Root Cause Analysis, Data Visualization, Data Queries

Lead Analyst

2021 - 2021
Healthplix
  • Built event tracking with Segment and worked with the engineering team to implement the user journey tracking of the product.
  • Provided insights and strategy through analysis to identify power users.
  • Collaborated with CRM team to implement automated triggered communication of user product journey using MoEngage.
  • Created a model to predict the next set of customer target segments with a high conversion probability.
Technologies: SQL, Mixpanel, MoEngage, Zoho CRM, Python, Data Visualization, Data Queries, Pipelines, Redshift

Data Analyst

2021 - 2021
BOLD
  • Analyzed A/B tests to drive KPI improvement, ensuring we ran experiments with the proper sample sizes and power levels.
  • Built Mixpanel reports to track funnel drop-offs, provide insights, and recommend the following steps to the product and content team.
  • Supported the product team with product ideation to identify a significant area for improvement.
Technologies: SQL, Mixpanel, A/B Testing, Data Visualization, Data Queries, Redshift

Lead Data Analyst

2020 - 2021
WhiteHat Jr.
  • Worked with the management team on marketing, media planning, and funnel improvement.
  • Built a model for revenue and spending planning for businesses in India and US.
  • Created an overbooking algorithm that used historical student joining probability to forecast booking to maximize class completion, reducing spending per revenue from 45% to 30%.
  • Optimized class-to-teacher demand-supply ratio to identify optimal teacher needs.
  • Tracked 80% of data analytics projects in product and marketing using Tableau and Google Sheets.
  • Automated and enhanced 20+ analytics dashboards using Tableau to improve daily operations and strategic planning.
Technologies: SQL, Tableau, Marketing Analytics, Product Analytics, Revenue Analysis, Data Reporting, Data Pipelines, Fivetran, Amplitude, Salesforce, Redshift, Amazon Athena, Amazon Redshift, Data Visualization, Data Queries, Pipelines, Dashboard Design

Business Technology Associate Consultant

2017 - 2020
ZS Associates
  • Analyzed the prostate cancer patient's journey and medication behavior to find gaps for improvement.
  • Published a self-serve marketing budget optimization tool for various digital and non-digital channels, saving around $1 million in operating costs annually.
  • Built Tableau dashboards to track sales, market share, and customer-reached performance metrics and quantified the success of marketing campaigns.
  • Created advanced modeling to segment doctors for a particular brand using sales and prescription metrics.
Technologies: SQL, Tableau, Dataiku, Python 3, Microsoft PowerPoint, Client Relations, Team Management, Data Visualization, Data Queries, Pipelines, Dashboard Design, Snowflake, Redshift

Experience

Data Warehousing

Set up a data warehouse on Amazon Redshift to create a single source of truth combining data from multiple sources like Athena, Salesforce, Facebook Ads, Google Ads, Zendesk, and a few other marketing platforms using Fivetran as a data connector.

Report and Dashboard Automation

Automation of reports and dashboards on daily, weekly, and monthly frequencies to define and monitor major business KPIs regularly and generate actionable insights and trends for internal and external stakeholders.

ETL Pipeline for Pharmaceutical

Used Dataiku, a cloud-based ETL tool, to build a data processing layer for pharmaceutical-related data received from various sources like Pharmacy, Patient Dose Data, and Internal Sales data to create a warehouse for reporting and a data science team.

Overbooking Algorithm

Created a booked trial class from the past probability of students joining. This trial allowed us to forecast the number of bookings that would take place based on the total number of trial slots available to have 100% occupancy in the class.

Revenue Prediction Model

Built a revenue prediction model for the revenue, finance, and marketing teams to have visibility of revenue growth and revenue/funnel target across departments using the backtracking method and conversion funnel across products.

Certifications

JULY 2019 - PRESENT

Introduction to Data Science in Python

Coursera

Skills

Libraries/APIs

Segment.io, Google Sheets API

Tools

Tableau, BigQuery, Google Sheets, Amazon Athena, Microsoft PowerPoint

Languages

SQL, Snowflake, Python 3, Python

Paradigms

ETL, Business Intelligence (BI)

Platforms

Google Cloud Platform (GCP), Dataiku, Mixpanel, Jupyter Notebook, Zoho CRM, Salesforce

Storage

Redshift, Data Pipelines

Other

Data Queries, Dashboards, Amplitude, Marketing Analytics, Product Analytics, Revenue Analysis, Data Reporting, Data Visualization, Data Analysis, Google BigQuery, Google Data Studio, Reporting, Data Cleaning, Pipelines, Dashboard Design, MoEngage, Fivetran, A/B Testing, Sales Analysis, Root Cause Analysis, Data Warehousing, Warehouses, Amazon Redshift, Client Relations, Team Management

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring