Daipayan Banerjee

Product Manager

Pune, Maharashtra, India7 yrs 1 mo experience

Key Highlights

  • 4+ years of experience in data analysis and engineering.
  • Proficient in SQL, Python, and data visualization tools.
  • Strong leadership skills demonstrated in team management roles.
Stackforce AI infers this person is a Data Engineer with expertise in Data Analytics and Automation within the Advertising and Pharmaceutical sectors.

Contact

Skills

Core Skills

Data AnalysisData EngineeringQuality AssuranceSoftware TestingLeadershipBusiness Analysis

Other Skills

SQLPowerBISnowflakeDatabricksPythonSparkPySparkExcelAlteryxBig Data AnalyticsMySQLHadoopHiveAdvertising OperationsPresto

About

Hey! Daipayan Here! ๐Ÿ‘‹ Thanks for visiting my little professional space. ๐—ง๐—Ÿ๐——๐—ฅ; I โค๏ธ to talk about Data. ๐— ๐˜† ๐—–๐˜‚๐—ฟ๐—ฟ๐—ฒ๐—ป๐˜ ๐—ฆ๐˜๐—ฎ๐˜๐˜‚๐˜€: I work for DefineRight as a Senior Technology Analyst, supporting pharmaceutical clients with data-driven insights, process automation, and analytical reporting solutions. ๐— ๐˜† ๐—ž๐—ฒ๐˜† ๐—ฆ๐—ธ๐—ถ๐—น๐—น๐˜€ ๐—œ๐—ป๐—ฐ๐—น๐˜‚๐—ฑ๐—ฒ๐˜€: SQL, PowerBI, Snowflake, Databricks, Python, Spark, PySpark, Excel and Alteryx. ๐— ๐˜† ๐—–๐—ฎ๐—ฟ๐—ฒ๐—ฒ๐—ฟ ๐—›๐—ถ๐—ด๐—ต๐—น๐—ถ๐—ด๐—ต๐˜๐˜€: โ–ช๏ธSpent 4+ Years in the Industry, transitioned from a Test Engineer to a Data Analyst. โ–ช๏ธWorked for wide range of domains that includes Banking, Advertisement, Retail, E-Commerce and now Pharma. โ–ช๏ธHelping clients with tasks such as data extraction, data cleaning, data modeling, data visualization and reporting. ๐—ง๐—ผ๐—ฑ๐—ฎ๐˜†, ๐—œ: โ–ช๏ธAm upskilling myself in Snowflake and dbt, along with understanding Spark. โ–ช๏ธAm exploring the depth of Data Engineering and its vast capabilities. โ–ช๏ธCreate Content to share my learnings with the community in the simplest way possible. โœ… If you share a passion for data, I am open to collaboration, aiming to foster mutual growth in this vast pool of opportunities. ๐—ช๐—ฎ๐—ป๐˜ ๐˜๐—ผ ๐—ฐ๐—ผ๐—ป๐—ป๐—ฒ๐—ฐ๐˜? ๐Ÿ“ฌ DM's are always Open ๐Ÿ“ง daipayan.banerjee77@gmail.com

Experience

Defineright

Senior Technology Analyst

Aug 2025 โ€“ Present ยท 7 mos ยท Remote

SQLPowerBISnowflakeDatabricksPythonSpark+5

Uber advertising

Data Analyst EXT

May 2024 โ€“ Aug 2025 ยท 1 yr 3 mos ยท Pune, Maharashtra, India ยท On-site

  • โ—พ Designed and implemented SQL-driven data reporting solutions, integrating Google Sheets and Looker Studio for real-time visualizations that improved reporting efficiency.
  • โ—พ Automated audience targeting query process using Python, reducing manual intervention and improving query refresh reliability by 40% through efficient handling of API responses.
  • โ—พ Built and optimized SQL-based data sharing pipelines for external partners, enabling seamless transfer of user campaign data related to Uber ads.
  • โ—พ Created SQL queries to analyze user behavior, brand market share, retention rates, and basket analysis using joins, window functions, CTEs, and subqueries to provide actionable insights.
SQLPythonBig Data AnalyticsMySQLHadoopHive+6

Infosys

3 roles

Data Analyst

Promoted

Mar 2023 โ€“ Apr 2024 ยท 1 yr 1 mo

  • โ—พ Developed and analyzed SAS ETL Macros and SQL procedures for Migration to Abinitio and Teradata, along with preparation of mapping documents.
  • โ—พ Crafted DDLs for 70+ schemas adhering to Teradata standards, facilitating data modeling and analysis for the Aspect Dialer Component for banking client.
  • โ—พ Extracted, managed, and cleaned data using SQL procedures and functions, employing joins, aggregations, and string manipulations for analysis and reporting.
  • โ—พ Executed ETL operations on SQL Server, integrating data from diverse sources like Oracle, Excel, and Flat Files into the target Data Warehouse, for visualisation in PowerBI.
SAS BaseSQLETLOracle DatabaseData ControlData Analysis+7

Test Engineer

Jan 2022 โ€“ Mar 2023 ยท 1 yr 2 mos

  • โ—พ Collaborated with Banking stakeholders in Agile methodology, analyzing Non-Functional Requirements and delivering data-driven insights to boost AUT performance.
  • โ—พ Automated user flows with Loadrunner, analyzed data, and identified bottlenecks, resulting in a 12% performance increase.
  • โ—พ Efficiently gathered and segregated data using Pivot Tables in Microsoft Excel, reducing manual efforts by 30%.
  • โ—พ Conducted data manipulation, exploration, and analysis on Oracle SQL for transactions spanning 7 continents, sourced from a Mainframe System.
Oracle DatabaseQuality AssuranceData AnalysisMicrosoft ExcelData IngestionAgile Methodologies+6

System Engineer Trainee

Oct 2021 โ€“ Jan 2022 ยท 3 mos

  • โ—พ Completed 3 months of intensive training in Java programming and MySQL, covering OOP concepts, Database Management System, CRUD operations, and hands-on project implementation.
  • โ—พ Specialized training in Selenium, BDD with Cucumber, and Agile Methodology; implemented on a banking app, resulting in 35% efficiency gain through UI testing and bug identification.
  • โ—พ Secured 81% in the training assessment and was recognised as a "High Performer".
Test Automation FrameworkMySQLSeleniumJavaSQLCucumber+2

Bharati vidyapeeth college of engineering, pune

3 roles

Joint Secretary - T&P Department

Aug 2020 โ€“ Jul 2021 ยท 11 mos ยท Pune, Maharashtra, India

  • โ—พ Worked with a Team of 50+ members and communicated with HR of various MNCs to conduct smooth Placement Drives on Campus, resulting in 85% placements.
Public SpeakingTeam ManagementCorporate CommunicationsLeadership

President - Production Department

Aug 2019 โ€“ Jul 2020 ยท 11 mos ยท Pune, Maharashtra, India

  • โ—พ Solely responsible for building, handling and leading 30 enthusiastic team members and conducting 3 major events and achieving the runner-up's position in the annual fest for the "Best Department"
Public SpeakingTeam OrganisationLeadershipTraining & Development

Editorial Head - Production Department

Aug 2018 โ€“ Jul 2019 ยท 11 mos ยท Pune, Maharashtra, India

  • โ—พ Responsible for writing effective marketing content for the 4 different fests organised in an academic year to ensure maximum participation.

Entrepreneurship cell, iim lucknow

Brand Representative

Jan 2019 โ€“ Mar 2019 ยท 2 mos

  • โ—พ Worked with the IIM students for their Business Fest and helped them in getting 50+ registration for their event by Data Analysis of the right audience in Excel.
Data AnalysisBusiness AnalysisMicrosoft ExcelCommunicationCollaborative Leadership

Internshala

Campus Representative

Jun 2018 โ€“ Aug 2018 ยท 2 mos

  • โ—พ Organised webinars and community meets including 100+ participations to help the college students understand the importance of Internshala and their functioning w.r.t internships and placements.
Public SpeakingBusiness AnalysisLeadershipTeamwork

Abyeti technologies

Marketing Coordinator

Jun 2017 โ€“ Jun 2017 ยท 0 mo

  • โ—พ Understanding and Business Analysis of the newly launched product and communicating it with the students and helping them get benefits of job preparation and thereby resulting in a 35% revenue growth.
Business AnalysisCommunicationBusiness DevelopmentMarketingBusiness Strategy

Education

Bharati Vidyapeeth University College Of Engineering, Pune

Bachelor of Technology โ€” Production Engineering

Jan 2017 โ€“ Jan 2021

Kendriya Vidyalaya

Class 12th

Apr 2016 โ€“ Mar 2017

Air Force School, Jamnagar, Gujarat

Class 10th

Jul 2014 โ€“ Mar 2015

Stackforce found 100+ more professionals with Data Analysis & Data Engineering

Explore similar profiles based on matching skills and experience