Naresh Kumar

Data Analyst Sql Developer Bi Developer @Scotiabank

Created Complex SQL Queries, User Functions, stored procedures, CTE’s, Views, Indexes also created schema and Tables Using SSMS 2018.\\\\n• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.\\\\n• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.\\\\n• Extensively used SSIS transformations such as Lookup, Derived column, Aggregate, Conditional split, SQL task, Script task and Send Mail task.\\\\n• Created SSIS packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.\\\\n• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysis Services (SSAS).\\\\n• Developed data visualizations and dashboards using Power BI and Tableau\\\\n• Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.\\\\n• Created KPI\'s, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.\\\\n• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.\\\\n• Worked on various visualization techniques in Tableau like Scatter Plots, Histogram and Heat Maps.\\\\n• Created different tabular reports using Power BI features and enhanced them based on user requirements.\\\\n• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper-level management.\\\\n• Installed and configured on premises gateway in Power BI services.\\\\n• Scheduled Automatic refresh and scheduling refresh in Power BI service. Maintenance and development of bug fixes for the existing and new Power BI Reports. Dashboards on intranet using SharePoint.\\\\n \\\\n\\\\n \\\\n \\\\n\\\\n \\\\n