Dileepa Bidare K

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