Sumit Kumar

• Collaborated with cross-functional teams and business stakeholders to analyze BI requirements, recommend solutions, and integrate cutting-edge technologies into projects.
• Developed interacting and visually appealing Power bi dashboards for data analysis and business reporting purposes.
• Designed and Implemented data models in power bi, establishing relationships and hierarchies to facilitate intuitive user explorations.
• Transformed raw data from various sources into structured datasets using power query, ensuring data accuracy and consistency.
• Integrated Power bi reports into custom applications or portals with RLS enabling seamless data access for users.

• Designed, developed, and maintained reports and dashboards for efficient drug distribution for Hospitals and drug manufacturers.
• Utilized Power Query editor dynamically to clean, shape and transform data before loading it into reports.
• Build automated interactive dashboards using BI technologies
• Analyze data from multiple sources to derive questions and insights
• Create visualizations to show KPIs efficiently
• Use optimal data modeling/processing techniques for improved performance
• Collaborated with business stakeholders to gather requirements and translate them into actionable visualizations with in Power bi.

• Designed customized data collection models for specific visualization tasks.
• Maintained proficiency with latest database technologies.
• Automated BI reports for secure virtual server environment.
• Developed intelligence-sharing dashboards, providing company-wide access to collected data.
• Generated reports, updated spreadsheets, and presented results.
• Monitored and optimized SQL server performance.
• Collected data from wide-ranging sources.
• Improved data gathering, analysis, and visualization procedures with strategic optimizations

• Build Automated 3 financial models Which help banks with Loan sectioned and Distribution.
• Built Credit automation process Model for banking industry.
• Creates sales interactive dashboards and Reports in Power BI and Tableau.
• Creates Companies Financial Performance and litigation Dashboards in Power BI and Tableau using Charts, Tree Map, Matrix and Other Custom Visuals Allows to show Company performance.
• Developed macros, Understanding Excel VBA and other actions to produce reliable and consistent statistical reviews.

Projects:-

1. I had completed 3 projects (Automation of Projected 3 financial Statement model) in Excel for banks

2. I had completed 2 projects (Credit Automation process tools) with the help of Excel, VBA and Power bi both are belongs to banks and NBFC.