Nayana H N

As a member of the business intelligence team, manage projects for sales teams, Primary responsibilities include the collection, analysis, planning, development, and change.
 Performed data collection, mining, and reporting on SQL and Teradata databases. 
 Monitoring the Quarterly production cycle and resolving the issues within service level agreement period.
 Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
 Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, and Send Mail task etc.
 Developed Power BI reports and dashboards for the KPI metrics from multiple data sources such as Excel, Analysis server(cube), SQL queries and Dax query and publish them to Power BI cloud service.
 Built Measures and Calculated columns using DAX. 
 Developed subscription on the Power BI reports using Power BI automate service helps to automate the reports.
 Implemented row-level security in Power BI workspaces depending on the type of access required. 
 Maintained data refresh schedules of published datasets.
 Designed Power BI visualization utilizing bookmarks, matrix, bar graphs, pie charts, master slicer, dual chart.

Business Intelligence AnalystBusiness Intelligence Analyst

Dell EMC · Full-timeDell EMC · Full-timeNov 2015 - Present · 9 yrs 5 mosNov 2015 to Present · 9 yrs 5 mosBengaluru Area, India · Remote

As a member of the business intelligence team, manage projects for sales teams, Primary responsibilities include the collection, analysis, planning, development, and change.
 Performed data collection, mining, and reporting on SQL and Teradata databases. 
 Monitoring the Quarterly production cycle and resolving the issues within service level agreement period.
 Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
 Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, and Send Mail task etc.
 Developed Power BI reports and dashboards for the KPI metrics from multiple data sources such as Excel, Analysis server(cube), SQL queries and Dax query and publish them to Power BI cloud service.
 Built Measures and Calculated columns using DAX. 
 Developed subscription on the Power BI reports using Power BI automate service helps to automate the reports.
 Implemented row-level security in Power BI workspaces depending on the type of access required. 
 Maintained data refresh schedules of published datasets.
 Designed Power BI visualization utilizing bookmarks, matrix, bar graphs, pie charts, master slicer, dual chart.

SJCITSJCIT

Bachelor of Engineering (BE), Information scienceBachelor of Engineering (BE), Information science2008 - 2012