Vishal

Project: Budgeting & Sales

Description

• Developed Power BI dashboard aimed at analyzing data trends through the collection of data from single or multiple sources, establishing a data model, and crafting visualizations within Power BI, while also enhancing report optimization.

Responsibility

• Processing, cleansing and verifying the integrity of data for analysis (ETL).
• Conducted data processing, cleaning, and validation for analysis purposes (ETL).
• Executed daily integration and ETL operations, managing data extraction, transformation, and loading across diverse SQL Server databases.
• Examined customer data comprehensively to uncover trends and patterns.

Project: HR Dashboard

Description

• Responsible for the creation and upkeep of systems documentation
• Involved in requirements gathering, user story creation, solution gap resolution, and the development of standardized data visualization models to deliver sustainable, effective, and efficient reporting and analytical solutions.

Responsibility

• Created and executed a novel ETL process aimed at guaranteeing data accuracy and integrity, resulting in a 25% reduction in data-related errors and enhancing overall data quality by 20%
• Enhanced data extraction efficiency by 70% through automation, enabling real-time data utilization and minimizing manual labor
• Developing visual reports and dashboards using Power BI desktop
• Diagnosing and resolving issues in Microsoft Power BI reports and dashboards
• Conducting Data Modeling and advanced Data Visualization techniques
• Developed and maintained stored procedures to facilitate data manipulation for various business units
• Implementing robust row-level security measures
• Demonstrating proficiency in application security models within Power BI
• Implemented Key Performance Indicators (KPIs) to gauge Measure critical metrics, providing valuable insights into performance and enabling informed decision-making.