Krishnendra Bhattacharyya

Krishnendra bhattacharyya

bookmark on deepenrich
location of Krishnendra BhattacharyyaKolkata, West Bengal, India
Followers of Krishnendra Bhattacharyya750 followers
  • Timeline

  • About me

    Senior Data Engineer/Analyst @Deloitte USI || SQL || Power BI || Python || Pyspark || Microsoft Certified Data Analyst

  • Education

    • Berhampore krishnath college school

      2010 - 2012
      Science a

      Activities and Societies: Football, Story Writing Completed Higher Secondary with 80.2% in Science Stream under West Bengal Council of Higher Secondary Education(WBCHSE)

    • Berhampore krishnath college school

      2004 - 2010
      General studies a

      Activities and Societies: Football, Story Writing Completed Secondary education with 82.1% under West Bengal Board of Secondary Education(WBBSE)

    • Kalyani government engineering college

      2012 - 2016
      Bachelor's degree electrical, electronics and communications engineering a

      Activities and Societies: Football, Vidyarthi Cultural Club (NGO) Graduated with 8.21 GPA in Electronics & Communication Engineering

  • Experience

    • Capgemini

      Aug 2016 - Jul 2019

      Performed role of an ETL Developer for an supply-chain management clientWork Description -• Creating ETL / SSIS packages to extract data from different sources - Excel, Flat files, SQL Server to files Using different SSIS components.• File Validation by checking file types, names and file handling techniques Using SSIS Packages.• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc. • Script Task- using script code to perform tasks which are not achievable using Built in tasks and Transformations.• Manipulating Data, Applying Business logic, converting Unstructured Data into Structured Data using SSIS packages.• PL/SQL blocks to accomplish multiple DDL, DQL, DML statements.• Advanced SQL Queries, Joins, Stored procedures.• Monitoring jobs in SQL agent Jobs.• Performed Unit Testing and Prepared Unit Testing Documents.• Creating SSRS parameterized reports & error reports. Show less Software Engineer worked on MSBI for an Fleet management clientProject Description - Creation and implementation of central repository for Custom Fleet in SQL Server 2016 (History enabled – SCD Type 2) for BI solution and data science use cases.Data Flow – Replicate data using Attunity from OLTP to staging layer (Oracle) and load data in central repository (SQL Server) using SSIS.Business solution – Creating and load data in report layer for BI analytics using SSIS. BI analytical reports using SSRS. Show less

      • Associate Consultant

        Aug 2018 - Jul 2019
      • Senior Software Engineer

        Aug 2017 - Jul 2018
      • Software Engineer

        Aug 2016 - Jul 2017
    • Deloitte

      Jul 2019 - now

      Working on FCPA engagements using Sql, Tableau & Power BI

      • Lead Solution Advisor

        May 2022 - now
      • Solution Advisor

        May 2021 - May 2022
      • Associate Solution Advisor - Forensic Analytics

        Jul 2019 - May 2021
  • Licenses & Certifications