RESUME
Sourav Thakur

SKILLS

  • •
    EXCEL
  • •
    ADVANCED EXCEL
  • •
    SQL
  • •
    MYSQL
  • •
    POWER BI
  • •
    PYTHON
  • •
    TABLEAU

certificates

    LANGUAGES

    • •
      ENGLISH (Proficient)
    • •
      BENGALI (Proficient)
    • •
      HINDI (Proficient)

    Interest

    • •
      RECITATION
    • •
      DRAWING
    • •
      READING BOOKS
    • •
      CODING

    Personal Info

    • •
      DOB : 03/05/1995
    • •
      Marital Status : Single

    Sourav Thakur

    DATA ANALYTICS

    9163565682
    placement@webskittersacademy.in
    422A/1A, MAHATMA GANDHI ROAD , KOLKATA-700082
    https://www.linkedin.com/in/sourav-thakur-297024378/

    PROFILE

    Aspiring Data Analyst known for strong problem-solving and logical reasoning ability. Strengths include adeptness in multiple programming languages, project management skills, and ability to deliver high-quality solutions. My expertise lies in designing, developing, and maintaining complex databases. Seeking a dynamic role to leverage extensive expertise and contribute to innovative data analytics. Seeking an opportunity to apply analytical skills and work on real-world datasets

    Personal Project/s

    Project Name :

    Bank Customer Churn Analysis (EXCEL)

    Project Url :

    Description :

    Analyzed structured banking data (demographics, tenure, balance, credit score, satisfaction, complaints) using data cleaning, correlation analysis, Pivot Tables, IF, XLOOKUP, COUNTIF, AVERAGEIF to identify key churn drivers. Built an interactive Excel dashboard uncovering high-risk segments and revenue leakage, enabling targeted retention strategies.

    Project Name :

    Walmart Sales Analysis (EXCEL)

    Project Url :

    Description :

    Examined multi-store sales data integrated with CPI, unemployment, fuel price, temperature, and holiday indicators using data preprocessing, SUMIFS/COUNTIFS, CORREL, INDEX-MATCH, Pivot Tables, and slicers. Developed a dynamic dashboard revealing inflation-driven sales impact and store-level performance insights to support pricing and inventory optimization.

    Project Name :

    Hospital Intelligence:  Clinical Operations & Revenue Analytics (POWER BI)

    Project Url :

    Description :

    Built a Power BI Hospital Intelligence Clinical Operations & Revenue Analytics Dashboard using operational and billing data, applying star schema modeling and Power Query data cleaning. Designed advanced DAX measures including MoM growth, efficiency scoring, and profitability metrics, delivered through executive KPI dashboards and analytical visuals for strategic healthcare insights.

    Project Name :

    HR Attrition Intelligence & Risk Analytics (POWER BI)

    Project Url :

    Description :

    Developed a comprehensive HR Attrition Intelligence & Risk Analytics dashboard in Power BI using employee demographic, compensation, tenure, and performance data. Applied data cleaning and transformation in Power Query and implemented advanced DAX functions (CALCULATE, DIVIDE, IF, SWITCH, RANKX, time-intelligence) to build KPI metrics, attrition rate models, conditional formatting (RAG), drillthrough reports, and interactive visualizations for predictive workforce insights.

    Project Name :

    End-to-End Banking & Fraud Risk Intelligence (MY SQL)

    Project Url :

    Description :

    Analyzed large-scale banking and fraud datasets using MySQL, performing anomaly detection, data validation, and schema optimization to build clean analytical tables. Applied advanced SQL (CTEs, window functions, rolling aggregates, ranking, quartile segmentation) to identify fraud patterns, customer risk trends, and risk-adjusted revenue insights.

    Project Name :

    Retail Sales Intelligence Platform (MY SQL)

    Project Url :

    Description :

    Transformed raw retail transaction data into structured analytical datasets through data cleaning, validation, and datatype standardization. Used advanced SQL (window functions, moving averages, cohort analysis, CLV, ranking, stored procedures) to generate insights on revenue growth, customer retention, and product performance.

    EDUCATION

    DATA ANALYTICS

    Pursuing

    • Bachelor of Science in Physics – University of Calcutta

    2018
    Logo