I developed reports to explore data visually and create interactive Excel and Power BI reports. I have used query editor in Power BI performed some operations such as retrieving data from another file. Utilized various sources to extract data in Power BI such as SQL Server, oracle. Generated periodic reports based on the statistical analysis of the data from the various time frame and divisions using power pivot, power query, and power view. I was involved in… Show more I developed reports to explore data visually and create interactive Excel and Power BI reports. I have used query editor in Power BI performed some operations such as retrieving data from another file. Utilized various sources to extract data in Power BI such as SQL Server, oracle. Generated periodic reports based on the statistical analysis of the data from the various time frame and divisions using power pivot, power query, and power view. I was involved in implementing Key Performance Indicators (KPI) Objects in SSAS. Show less

Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures and triggers. Generated periodic reports based on the statistical analysis of the data from various time frames and division using power pivot, power query, power view. Generated periodic reports based on the statistical analysis of the data from the various time frames and divisions using power pivot, power… Show more Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures and triggers. Generated periodic reports based on the statistical analysis of the data from various time frames and division using power pivot, power query, power view. Generated periodic reports based on the statistical analysis of the data from the various time frames and divisions using power pivot, power query, and power view. Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning. Show less

I used Power Query to collect data and the Power BI desktop to design rich visuals. I wrote basic reports using confidential files as the source to retrieve data in Power BI. I design and develop Power BI graphical and visual solutions with business requirements documents and blueprints to create interactive dashboards. Use Power Query to collect data and the Power BI desktop to design rich visuals.

I managed enterprise services by diagnosing root causes of incidences, determined time of detection, diagnosed and resolved by analyzing data. I created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS. I developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point, Slicer, Pivot chart, Pie Chart, Macros. Researched… Show more I managed enterprise services by diagnosing root causes of incidences, determined time of detection, diagnosed and resolved by analyzing data. I created, maintained & scheduled various reports in SSRS such as Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS. I developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point, Slicer, Pivot chart, Pie Chart, Macros. Researched problems thoroughly to diagnose the root cause by pulling data from multiple Sources, Developed Reports and dashboards using Power BI. Show less

I Performed major role in understanding the business requirements, designing and loading the data into data warehouse (ETL). I deployed SSIS packages and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis. I conducted Code Walkthroughs and performed SSIS/SSRS peer reviews. Involved in using Sqoop for importing and exporting data into HDFS. Architected Cubes with PowerPivot, MDX, SSAS.