Experience

• 

  Binarybridge technologies india pvt ltd

  Nov 2017 - Dec 2018

  Jr. software engineer (bi, sql developer)
• 

  Comsense technologies

  Jan 2019 - Oct 2020

  Software engineer, data analyst

  Key Responsibilities:Data Visualization and Reporting:Create interactive dashboards and reports, enabling stakeholders to gain insights from complex datasets.Develop paginated reports using Microsoft Report Builder for scheduled distribution and printing of critical business reports.ETL Development:Extract data from various sources such as databases, flat files, APIs, and streaming platforms.Develop scripts or use ETL tools like SSIS to connect to source systems and retrieve required data.Cleanse and preprocess raw data to ensure consistency, accuracy, and integrity.Perform data transformations such as filtering, sorting, aggregating, and joining to prepare data for analysis.Load transformed data into a centralized data warehouse, data lake, or other storage repositories.Data Warehousing:Designing and implementing data models to organize and structure data within the data warehouse. This involves creating dimensional models (e.g., star schema, snowflake schema) optimized for analytical querying and reporting.Implemented data modeling techniques to optimize query performance and facilitate complex analytical queries. Show less

• 

  Intellify solutions

  Nov 2020 - now

  Sr. software engineer, data engineer, data analyst

  Key Responsibilities:Data Visualization and Reporting:Create interactive dashboards and reports using Microsoft Power BI, facilitating insights from complex datasets.Develop paginated reports with Microsoft Report Builder for critical business reports' scheduled distribution and printing.ETL Development:Extract data from various sources including databases, flat files, APIs, and streaming platforms.Utilize SSIS and scripting to connect to source systems, retrieve data, cleanse, preprocess, and perform transformations.Load transformed data into centralized data warehouses or data lakes.Data Warehousing:Design and implement optimized data models for analytical querying and reporting, including dimensional models like star and snowflake schemas.Implement data modeling techniques to enhance query performance and support complex analytical queries.Azure Analysis Services (AAS) Development:Design analytical models using Azure Analysis Services to meet business intelligence and reporting requirements.Develop multidimensional and tabular models, defined measures, calculated columns, hierarchies, and implemented security measures.Manage deployments, backups, updates, and maintenance for Azure Analysis Services models.Microsoft Fabric Solutions:Design end-to-end data pipelines and dataflows to ingest, transform, and load data into Azure Data Lake.Utilize Kusto Query Language (KQL) for querying and analyzing Data Lake data, optimizing queries for performance.Utilize notebooks using PySpark for distributed data processing, complex data transformations, model training, and implementing efficient algorithms.Implement monitoring alerts for pipeline failures, data anomalies, and performance issues. Show less