Sandeep Goud

Report Development and Analysis: Recognized and adopted best practices in reporting, analysis and documentation.Extensively worked on performing the ETL Activities in Power Query.

Experience using data visualization (e.g., tables, charts, graphs) to represent analyses to an executive audience.

Good Experience in Creating Hierarchies and Drill down Reports.

Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information.

Sharing of Power BI reports and managing workspaces in Power BI Report Server. Migrating the reports from Kibana to PowerBI_RS.

Data Warehousing Analysis:Understanding of Fact tables, Dimensions tables, Star schema and Snowflake schema, Data Analysis, Data Modeling, BI reporting, logical and physical models.

Quality Assurance: Reviewed test scenarios and test cases for UAT and regression testing to support pre and post implementation of applications and production issues along with QA and other business groups, in addition to maintaining Test Matrix and Requirements Traceability Matrix (RTM).

Business Analysis: IT experience involved with Business Analysis, Domain Analysis, Data Analysis, Business Rules,Prototyping, developing/creating business process related documents.

SDLC: In depth strong working knowledge of the Software Development Life Cycle (SDLC) phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process.

Communication Skills: Excellent communication skills to help facilitate requirements and communication between the client and the project team.Strong project management skills and ability to work on many projects simultaneously.

Developing visual reports, dashboards and KPI scorecards using Power BI desktop.

Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources.

Integrate Power App with Power BI to enable the write back feature from Power BI.

Sharing of Power BI reports and managing workspaces in Power BI service.

Collaborated with cross-functional teams to ensure seamless integration of new features.

Automated repetitive tasks through scripting, freeing up valuable time for higher-priority projects.

Tested programs and databases to identify issues and make necessary modifications.

Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Created drill down and drill through report to go to details and child report within power bi based on hierarchy.

Developed Dashboards to monitor attrition trends and patterns to measure machine performance against target set across both regions and product.

Generated Power BI reports that allow users to filter reports based on years, Marketing Organizations, Regions.  Identified outliers and analysed profitability whilst drilling down into the underlying details.

Designed solutions to enable Dealers to easily monitor workforce metrics, promising higher productivity .

Used different types of Filters in Power BI like Visual level Filter, Report level Filter, Drill- through filter, and Slicer to prepare the detailed Requirement Analysis document for the reports.

Various DAX Expressions like logical functions and filter functions are used to derive calculated measures MTD, QTD, YTD, Current Month by using “Tabular Editor” which is an Added External tool in Power BI.

Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.

Secured the Power BI reports using Row Level Security (RLS) and DAX filters.  Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes