profile-pic

Sourav Maity

Sourav Maity

I am an experienced working professional with 5 years of overall experience in various domains like Ecommerce, Non Banking Institutions.

  • Role

    Data Science & Analytics - Other

  • Years of Experience

    6 years

  • Professional Portfolio

    View here

Skillsets

  • Marketing
  • cloud platforms (AWS, Azure, GCP) - 2 Years
  • Google AdWords API - 2 Years
  • Data Warehousing - 2 Years
  • Big Data - 2 Years
  • Azure synapse - 2 Years
  • Power BI - 4 Years
  • Model building
  • Ml / ai
  • Data Visualization
  • MySQL
  • Data Mining
  • Market Analysis
  • Business Analyst
  • Data Science
  • Data Analysis
  • Machine Learning
  • Linear Regression - R or Python
  • Python Programming

Professional Summary

6Years
  • Jul, 2023 - Present1 yr 2 months

    Data Analyst

    Embibe
  • May, 2022 - Jun, 20231 yr 1 month

    Data Analyst

    Skill Lync
  • Jun, 2018 - Apr, 20223 yr 10 months

    Credit Risk Business Analyst

    Shriram Transport Finance Co Ltd
  • Sep, 2017 - Jun, 2018 9 months

    Risk Analyst

    Amazon India

Applications & Tools Known

  • icon-tool

    MySQL

  • icon-tool

    Python

  • icon-tool

    Tableau

  • icon-tool

    Power BI

  • icon-tool

    Advance Excel

  • icon-tool

    Microsoft Azure SQL Database

  • icon-tool

    Azure Data Lake Storage Gen2 (ADLS)

  • icon-tool

    Azure Synapse

Work History

6Years

Data Analyst

Embibe
Jul, 2023 - Present1 yr 2 months

    Developed interactive dashboard & reporting infrastructure

    using Power BI & Azure Synapse Studio to provide real time

    insights on Business KPIs

    Increased user retention by 15% through User Retention

    Analysis by leveraging Azure data tools

    Developed a real-time banner performance tracking system

    using Google Analytics (GA), leveraging A/B testing and

    dropout rate analysis to provide optimization recommendation

    Optimize Search Engine with target performing Keywords using

    Google Ads API to improve organic website Traffic

    Built interactive Report for Central B2B & GTM Team to

    optimize Sales Funnel & determine loop holes in the process, aiming to lift the ROI

Data Analyst

Skill Lync
May, 2022 - Jun, 20231 yr 1 month

    Analyzed engagement activities and optimized the sales funnel

    to significantly improve the L2P by 15% quarterly

    Proficiently design, implement and optimize data models, ETL

    pipelines using RedShift, utilized AWS Lambda to enable

    comprehensive reporting

    Developed Cohort Analysis that identifies price reduction

    opportunities aiming to boost the revenue by 15% QoQ

    (Quarterly)

    Automated marketing campaigns using the Google Ads API and

    Python for ad creation, budget allocation, and performance

    monitoring

    Collaborated with project managers to provide data drive

    insights on Case Studies for articles & Magazines

Credit Risk Business Analyst

Shriram Transport Finance Co Ltd
Jun, 2018 - Apr, 20223 yr 10 months

    Analyzed historic portfolio data with key metrics to acquisition

    source increasing lead generation by 15% quarterly

    Implemented predictive analysis to analyze proposed leads' attributes, predicting the probability of defaults (PD) & reduce

    defaults by 20% Yearly

    Built Interactive report for GTM team using SQL & BI analytics

    to provide insights on market trends, optimize strategies

    Implemented Clustering Mechanism to segment customer &

    enhance Portfolio by 35% yearly

Risk Analyst

Amazon India
Sep, 2017 - Jun, 2018 9 months

    Analyze data using internal data tools using Tableau, SQL to

    identity risk & opportunities on transactional data

    Devlop SQL script to extract transactional level information to

    generate fraud analysis report & improve business operation

Achievements

  • Best of 250 Employees in North Eastern Region at Shriram Transport Finance Co Ltd
  • Weekly Award for Best Performance at Amazon India

Major Projects

5Projects

Credit Card Fraud Risk Modelling

    Predictive Analysis using supervised & unsupervised ML algorithms

Keyword Optimization : Analysis of top keywords to increase Website Traffic

Embibe
Apr, 2024 - May, 2024 1 month
    • Developed Python script to generate Monthly Search Volume (MSV) using Google Ads APIs to optimize the keyword for SEO Team
    • Automated Ads Campaigns efficiently by optimizing context with top performing keywords

SignUp Funnel : Data Modelling & DW Design

Embibe
Feb, 2024 - Apr, 2024 2 months
    • Developed OLAP layer in Azure Synapse Studio performing ETL from data lake structure with Azure Blob Storage to provide consistent & real-time update on funnel
    • Integrated Banner Event Actions with the funnel to get the best Click-through-rates on banner

Business One Dashboard : KPIs & Performance

Embibe
Aug, 2023 - Nov, 2023 3 months
    • Analysis to improve Developed a comprehensive dashboard tracking over 50 KPIs and generating insights on user engagement and behavior. Integrated data from multiple sources using a Snowflake schema to ensure accurate and holistic reporting
    • Optimized Data Workflow with Synapse Studio for efficient ETL processes, from a data lake structure stored in Azure Blob Storage. This streamlined data management and enabled the stakeholders to make informed decisions by providing clear, actionable data points

House Price Predition

University of Texas
Nov, 2022 - Jan, 2023 2 months

    The price of a House depends on multiple parameters for example : location, age, floor levels, Bedrooms etc. In this project we have build an advance regression to find out the correct price of a House using Regression Analysis.

Education

  • B.Tech in Automobile Engineering

    West Bengal University of Technology (2017)
  • Post Graduate Program in Data Science & Business Analytics

    McCombs School of Business, University of Texas at Austin (2023)

Certifications

Interests

  • Driving
  • Travelling
  • Books
  • Listening Music
  • Cricket