Indrani Dey

Senior Associate (Power BI and ADF)

• Job Details:Derived and optimized 10+ ETL pipelines using Azure Data Factory (ADF), leveraging Delta Lake and Parquet file formats to ensure high-performance data processing and storage in ADLS Gen2. Integrated multiple data sources, including on-premises systems, to fetch and transform large datasets using Azure Data Factory (ADF). Developed over 30 reports and dashboards resulting in a 30% increase in operational efficiency. Worked on Power BI Report Builder or Analysis Services to generate paginated reports in Power BI. Optimized the performance of Power BI reports and dashboards through data model enhancements and query optimizations. Implemented row-level security and other advanced security features in Power BI. Worked on complex data transformation activities using ADF dataflows. Worked in database development, including creating views, stored procedures, temp tables, table variable, joins, CTEs, and functions using T-SQL, which was used extensively in optimizing data extraction and performance optimization. Modified existing Power BI dashboards and SSAS models to correct coding errors, upgrade interfaces and improve overall performance. Experienced in using both import and direct query modes to enable real-time data analysis. Built pipelines and dataflows Gen2 to enable efficient and scalable data preparation within the Fabric ecosystem. Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements. Successfully worked within agile and waterfall delivery models, ensuring effective project management and consistent delivery. Experienced in configuring and managing on-premises data gateways to ensure secure and scheduled data refreshes across hybrid environments.

Associate (Power BI and ADF)

• Job Details:Demonstrated expertise in Delta Lake tables and Parquet file format, orchestrating complex data workflows using Azure Data Factory (ADF). Working experience with Azure Data Lake Storage (ADLS) Gen2. Migrated 10 dashboards from Spotfire to Power BI and ensuring seamless data flow and accuracy. Developed tabular models resulting in simplified data interpretation and decision making. Collaborated with cross-functional teams to identify data sources and streamline data collection resulting in a 25% increase in report development time. Used Power Query to transform, shape, clean, and model data to meet business requirements for reporting. Derived financial KPIs from the data in Power BI that would help the organization build insights. Used bookmark feature in Power BI to create report in the monthly, quarterly, yearly frequency. BAU support tasks and performance tuning of the dashboards and reports.

Consultant 3 (SQL & Power BI)

• Job Details:Implemented semantic layer in Power BI as datasets and created visuals using custom libraries. Worked on data analysis expressions (DAX) in creating calculated measures, columns and filters in Power BI and SSAS tabular model used in report creation. Optimized dashboard performance by implementing indexing and partitioning resulting in a 30% increase in load time. Contributed ideas in team meetings and delivered updates on deadlines, designs and enhancements. Specialized in various visualizations, including donut charts, pie charts, bar graphs, metrics, tree maps and KPIs. Developed custom report tooltips for different reports to showcase multiple data points. Monitored junior developers and conducted training sessions on Power BI best practices. Developed multiple reports as per project requirement for finance users and retail users.