About Me
Having 4+ Years of Experience as a Data Analyst. Successfully completed DP-500 Microsoft certification. Good knowledge and experience of Database Design, Development and Business Intelligence of Microsoft SQL Server. Ext…
Having 4+ Years of Experience as a Data Analyst. Successfully completed DP-500 Microsoft certification. Good knowledge and experience of Database Design, Development and Business Intelligence of Microsoft SQL Server. Extensive Experience in SQL databases Development, ETL Development using Microsoft SQL Server Integration Services (SSIS). Good Knowledge in SQL Server Analysis Services (SSAS). Good Knowledge in SQL Server Reporting Services (SSRS). Good Knowledge in PowerApps. Working extensively on Power BI (Desktop, PRO, Premium, Power BI Services, Power Query, Power Pivot, Power bi Report Builder, DAX) Extensive experience in creating SSIS Packages for Data Extraction, Transformation and Loading (ETL) Using Sql Server Integration Services (SSIS) and ADF pipelines. Experience in creating SSIS Packages with Various Tasks and Containers in SSIS Control flow. Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Union All, Merge Join and OLEDB Command to load data into SQL Server destination. Experience in SSIS packages execution and deploying packages to servers. Worked with SSRS to generate reports in different formats like Table, Matrix, Chart, Sub reports, Drilldown, Drill through reports. Having good Knowledge on Writing DAX Queries. Experience in creating the Stored procedures, Views, Joins using SQL Server. Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
Experience
Consultant
Business Intelligence Developer with 4+ years of IT experience with expertise in analysis, Design, development and implementation of data warehouses, datamarts using Power bi, ETL tool (SSIS) and RDBMS like MS SQL Server, Azure Sql.
Experience in developing & publishing power bi reports with different data visualizations like Line, bar, pie, Histogram, Table, Matrix, Scattered chart, Funnel, Maps, bullet, etc and by creating both calculated columns and measures by using DAX.
Extensive experience on loading data from multiple sources to SQL by using SSIS ETL tool.
Requirement gathering and creation of mapping document.
Gathering requirement and applying logics for the reports.
Created VISTA Canada DOS & PPD DOS Power BI reports.
Creating calculated columns and measures by using DAX.
Implemented dynamic row level security to restrict unauthorized access of report.
Requirement gathering and creation of mapping document.
Data modeling and data security implementation.
Preparing sales, finance and other kinds of reports on Power BI.
Creating calculated columns and measures by using DAX.
SQL Server Integration Services (SSIS) for ETL.
Created stored procedures in SQL for SSRS reports.
Gathering requirement and applying logics for the reports.
Currently working on SQL Server 2016 and Visual Studio 2015.
Performed data updation by using SQL Server Integration Services.
Requirement gathering and creation of mapping document.
Gathering requirement and applying logics for the reports.
Built Customer Experience Explorer report on Power BI.
Creating calculated columns and measures by using DAX.
Requirement gathering and creation of mapping document.
Data modeling in SSAS Tabular.
Preparing sales, finance and other kinds of reports on Power BI.
Creating calculated columns and measures by using DAX.
SQL Server Integration Services (SSIS) for ETL.
Created stored procedures to load data from AX Dynamics to SQL DWH.
Gathering requirement and applying logics for the reports.
Worked on SQL Server 2016 and Visual Studio 2017.
Performed data updation by using SQL Server Integration Services.
Requirement gathering and creation of mapping document.
Gathering requirement and applying logics for the reports.
Built Promax Insight report for two regions i.e., ANZ and NWE in Power BI.
Creating calculated columns and measures by using DAX.
Created daily sales report using Report Builder and scheduled auto mailer.