RESUME
DEBARUN BANERJEE

SKILLS

  • Advanced Excel
  • MySQL
  • Power BI
  • Python

certificates

    LANGUAGES

    • ENGLISH (Proficient)
    • BENGALI (Native)
    • HINDI (Intermediate)

    Interest

    • Data Analysis.
    • Advanced Excel (Dashboards, Pivot Tables, Functions).
    • SQL Querying & Data Exploration.
    • Power BI Dashboard Development.
    • Python for Data Analysis & Automation.

    Personal Info

    • DOB : 10/08/1998
    • Marital Status : Unmarried

    DEBARUN BANERJEE

    DATA ANALYTICS

    54/H PK GUHA LANE, P.O.- DUM DUM CANTONMENT, MODERN PARK, KOLKATA- 700028.

    PROFILE

    Biotechnology professional with hands-on experience in molecular biology and bioinformatics, currently gaining proficiency in data analytics tools including advanced Excel, SQL, Power BI and Python. Skilled in analysing and visualizing complex datasets, and translating biological and research data into actionable insights to support projects and decision-making.

    Personal Project/s

    Project Name :

    URBAN AIR QUALITY MONITORING AND ANALYSIS DASHBOARD.

    Description :

    Urban Air Quality Monitoring & Analysis Dashboard.

    Tools: Advanced Excel (Pivot Tables, Pivot Charts, KPIs)

    • Built an Excel dashboard using Pivot Tables and Charts to analyze multi-year urban air quality data across major Indian metros, tracking PM2.5, AQI trends, and pollutant concentrations (NO, NO₂, NOx, SO₂, O₃) by city, year, and month. • Derived insights on chronic pollution hotspots, PM2.5 exceedance frequency, AQI category distribution, and post-2020 air quality fluctuations to assess long-term pollution severity across cities.

    Project Name :

    FLIGHT PERFORMANCE AND RELIABILITY DASHBOARD.

    Description :

    Flight Performance and Reliability Dashboard

    Tools: Advanced Excel (Pivot Tables, Pivot Charts, KPIs)

    • Built an interactive Excel dashboard analyzing ~10,000 flight records using Pivot Tables, Charts, and slicers to evaluate airline punctuality, delay patterns, cancellation rates, and operational efficiency across airlines, routes, and regions.
    • Derived insights on departure delay trends, peak-hour congestion, high-risk carriers and airports, air time distributions, and regional disruption patterns to support data-driven operational decision-making.

    Experience/s

    15/02/2022 - 12/03/2022

    Company :

    SMART MANAGEMENT CONSULTANCY

    Designation :

    Intern

    Description :

    Project- Protein Structure Prediction and Modelling of Omicron variant.
    • Retrieved and analyzed SARS-CoV-2 genomic data from NCBI, and performed protein structure prediction and modeling for the Omicron variant.
    • Applied bioinformatics tools to evaluate structural variations and functional impacts, and contributed to research reports and visualizations.

    14/03/2022 - 31/03/2022

    Company :

    UNIVERSITY OF CALCUTTA.

    Designation :

    Intern

    Description :

    Internship in Cytogenetics Laboratory.
    • Conducted DNA/RNA extraction, PCR, gel electrophoresis, and applied protein expression analysis, enzyme assays, and immunoassays.
    • Utilized bioinformatics tools for genome/protein analysis, handled microbial and cell culture techniques, and assisted in experimental design, data recording, and lab reports.
    02/08/2022 - 31/01/2023

    Company :

    CNG AGROCARE PRIVATE LIMITED

    Designation :

    Research Associate

    Description :

    Agribiotech Domain.

    • Monitored research and field project progress, conducted soil analysis, and assisted the PI in designing projects with data collection and reporting frameworks.
    • Prepared technical reports, maintained regulatory registers (IMO, FCO, CIB), and supported audits by ensuring accurate documentation and compliance.
    01/02/2023 - 04/03/2023

    Company :

    THE TEACHIEF ACADEMY

    Designation :

    Junior Academic Research Associate

    Description :

    Academic Writing & Academic Research Firm.

    • Designed and structured research projects, conducted literature reviews, assisted in data analysis, and developed qualitative and quantitative methodologies across academic levels.
    • Supported students (Bachelor’s to PhD), ensured proper referencing standards, collaborated on problem-solving, and mentored junior associates on research design and quality.
    13/03/2023 - 18/09/2024

    Company :

    LEARNING TREE

    Designation :

    Academic Research Writer

    Description :

    Academic Writing Organisation.
    • Conceptualized and structured research projects, performed literature analysis, reviewed data, and assisted in developing qualitative, quantitative, and mixed-method methodologies.
    • Supported students (UG to PhD), ensured accurate academic referencing, and addressed research challenges through analysis, collaboration, and structured problem-solving.
    04/11/2024 -

    Company :

    NIL

    Designation :

    Freelancer

    Description :

    Freelance services to students of different domain.
    • Conducted research and developed content for academic publications, and assisted in study design, data analysis, and report preparation.
    • Ensured accuracy and compliance with academic standards and documentation requirements.

    EDUCATION

    Certification Course on Data Analytics

    Pursuing

    Masters in Biotechnology (9.6/10)

    2022

    Bachelors in Biochemistry Honours (61.62%)

    2020
    Logo