Dileepa Bidare K

Dileepa Bidare K

Followers of Dileepa Bidare K664 followers
location of Dileepa Bidare KBengaluru, Karnataka, India

Connect with Dileepa Bidare K to Send Message

Connect

Connect with Dileepa Bidare K to Send Message

Connect
  • Timeline

  • About me

    Senior Data analyst at Autoliv | Microsoft Certified Power BI Data analyst | Experienced Chemical data analyst | SQL | Python | Data modeling | Snowflake

  • Education

    • IADC bangalore

      2010 - 2012
      Master of Science (MSc) Organic chemistry
    • Tumkur University, Tumkur

      2007 - 2010
      BSc - Bachelor of Science Chemistry

      specialization in physics, chemistry and mathematics

  • Experience

    • Molecular Connections

      Aug 2012 - May 2024

      Having 11+ years of Experience in the Information service industry with relevant of 4+ Experience in Data Analytics and reporting, as a Microsoft Power BI DeveloperExpertise in chemistry reaction /pharmaceutical databases (RDBMS), and drug discovery process which works with big data, and generated Dashboards and Reports as per client's requirement.Familiarity with databases like SciFinder, NCBI, PubMed, Uniprot, and PDBCollaborated closely with stakeholders to gather and meticulously analyse complex business requirements, translating them into effective data visualization solutions.Developed Visually appealing and interactive dashboards and reports in Microsoft Power BI, showcasing expertise in advanced DAX calculations to derive meaningful KPIs.Conducted Data extraction, data transformation, and loading (ETL) processes using Power Query, optimizing data sources for seamless integration with Power BI.Ensured data accuracy and consistency through meticulous data profiling and validation checks.Demonstrated an exceptional knack for optimizing Microsoft Power BI performance, improving report rendering times, and resolving technical issues efficiently.Practical understanding of Data modelling (dimensional and relational) concepts like star-schema modelling, snowflake schema modelling, and fact and dimension tables.Good knowledge on Power BI Service for creating APP Workspaces and adding the Members to APP Workspace to Manage the Content.Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset.Good experience in publishing the Reports and Dashboards to Microsoft Power BI Service along the outputs with applying row-level security.Good hands-on experience in creating SQL Server database objects like Tables, Constraints, Joins, Subqueries, CTE, Stored Procedures, User Defined Functions and Views. Show less

      • Assistant Content Manager / Power BI developer

        Jul 2022 - May 2024
      • Technical Lead

        Oct 2018 - May 2024
      • Senior Scientific analyst

        Apr 2015 - Oct 2018
      • Scientific Analyst

        Aug 2012 - Apr 2015
    • Autoliv India

      May 2024 - now
      Senior Data Analyst
  • Licenses & Certifications

    • SQL new

      United Latino Students Association
      Jun 2025
      View certificate certificate
    • The Python mega course: Learn Python in 50 Days with 20Apps

      Udemy
      Mar 2023
    • The complete SQL Course-Learn by Doing-SQL server

      Udemy
      Aug 2023
    • Computer Aided Drug design (CADD)

      Biotechnika
      Jun 2023
    • Business Intelligence Using Power BI-2 DAY WORKSHOP

      Skill Nation
      Aug 2023
    • Advanced Excel formulas-MASTERCLASS

      Skill Nation
      Sept 2022
    • Microsoft Certified: Power BI Data Analyst Associate

      Microsoft
      Oct 2023
      View certificate certificate
  • Honors & Awards

    • Awarded to Dileepa Bidare K
      Value creator molecular connections pvt ltd January 1, 2019