Naresh G

Over 5years of experience on how to import, shape, and convert data for business intelligence (BI) in Power BI, Create and share dashboards based on reports, author reports, schedule automated report refreshes, and visualize data with Power BI desktop. Experience in employing DAX methods to build queries and designing Power BI models for the application security layer. Created Sub-Reports, Drill-through Reports, Linked Reports, and Cascaded Reports SSRS-based parameterized reports. Experience in Creating and administering databases, tables, stored procedures, DDL/DML triggers, views, user-defined data types, and functions (UDFs), Cursors, and Indexes utilizing T-SQL&PL/SQL as per Source & Destination systems. Experience doing data extraction, transformation, and loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, and BCP. Experience scheduling, monitoring, and maintaining old and new SQL jobs using SQL Server Job Agent. Proven ability to create reports using Microsoft Access and Excel spreadsheets and SQL Server Reporting Services (SSRS). Experience on business intelligence and data warehousing technologies with experience in Power BI, Azure, and the MSBI Stack (TSQL, SSAS, and SSRS). Vast experience on putting Microsoft BI tools, such as Power BI, Azure Analysis Services, SQL Server Integration Services, and SQL Server Reporting Services, into action. Experience in creating SSIS packages for integrating data from heterogeneous sources and handling errors in SSIS packages using transactions, checkpoints, and error logging procedures. Experience in producing on-demand and pre-scheduled reports for management or business analysis utilizing POWER BI, Tableau, and SQL Servers Reporting Services (SSRS). Design of OLAP and OTLP databases, as well as development of ETL programs, tabular models, and dashboards. Working knowledge of developing datasets and ETL procedures for reporting in Alteryx (ETL application designed specifically for creating datasets) BI Tableau Data Extract. Experience on the Import-Export Wizard, DTS, SSIS, and Bulk Insert to extract and migrate data from sources including Excel, MS Access, Oracle, CSV files, DB2, and more to MS SQL Server. Experience about all stages of the Software Development Life Cycle (SDLC), particularly Agile and Scrum, which involve business process analysis, requirements collecting and analysis, detailed design, development, testing, and post-implementation support.