Leena Ashokan

• With over 4 years of professional experience in the IT industry, I possess extensive knowledge and hands-on experience in Power BI and MSBI projects.
• My expertise lies in utilizing ETL and reporting tools like SSRS, SSIS, SQL Server, and Power BI to create visually appealing dashboards tailored to meet client requirements.
• I have a proven track record of implementing slicers and sync slicers across different visuals, as well as utilizing various types of filters including page level, visual level, report level, and drill-through filters.
• Additionally, I have a strong background in importing data from multiple sources into BI tools, establishing data relationships, and creating calculated columns and measures using DAX queries.
• Proficient in Power BI Desktop, I excel in data visualization through charts such as bar charts, line charts, scatter plots, and pie charts.
• Furthermore, I possess advanced skills in writing DAX queries/expressions in Power BI Desktop.
• I have successfully designed a wide range of reports including drill-downs, drill-throughs, and sub-reports using SSRS.

Project #3:

Project Name : Customer Segmentation &

Churn Analysis.

Domain : Banking.

Duration : Nov - 2023 to Till Date.

Environment : Power BI, SQL Server.

Responsibilities:

➢ Involved discussion with business users and provide technical guidance for Power BI Desktop and Power BI Service.

➢ Extracting the data and placed into Power BI desktop.

➢ Created scheduling and sharing the reports & Dashboards using Data Gateway. Creating Content packs and sharing reports and Dashboards.

➢ Generating reports using DAX time intelligence functions and other kind of DAX functions.

➢ Involved in Creating Hierarchies and giving the relationship between attributes to decrease processing time.

➢ Create Visuals and Reports in Power BI Desktop and publish into Power BI Service.

Project #2:

Project Name : Healthcare Analytics.

Duration : Jun - 2022 To Oct - 2023.

Environment : Power BI, SQL Server.

Responsibilities:

➢ Involved in creating relationships between dimensions and measure groups as per business requirement.

➢ Create Visuals and Reports in Power BI Desktop and publish into Power BI Service.

➢ Generating reports using DAX time intelligence functions and other kind of DAX functions.

➢ Creating Content packs and Sharing reports and Dashboards.

➢ Scheduling using Gateway.

➢ Connecting Live and extract data from SQL SERVER Tabular Model into Power BI desktop.

➢ Develop database schemas, tables, and dictionaries. 

Project #1:

Project Name : Operational Analysis.

Domain : Telecom.

Duration : April - 2021 To May - 2022.

Environment : SSIS,SSRS, SQL Server.

Responsibilities:

➢ Extracting data from multiple sources like flat files, excel, and SQL server and transforming, validating data and loading into final Destination.

➢ Designing packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task.

➢ Transforming the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.

➢ Maintaining log information in SQL table to tracking Errors and recording package execution status.

➢ Scheduling Reports Weekly and Monthly basis as per the Client Requirements.