Nishant Agarwal
Senior Consultant
Pune
Summary
Senior Business Intelligence Consultant with around 5 years of experience in Business Intelligence Reporting. Lead multiple Power BI migration and development projects delivering excellent results.
Overview
5
5
years of professional experience
4
4
years of post-secondary education
1
1
Certification
Work History
Senior Consultant
Nice Software Solutions Pvt. Ltd
Pune
04.2023 - Current
- Analyzed problematic areas to provide recommendations and solutions.
- Assessed needs for projects and made proposals to senior executives.
- Various POCs of Microsoft Fabric for existing client architecture using basic Data pipeline and delta tables in Fabric.
- Worked on migration of complex web application paginated reports to Power BI Report Builder with dataset modelling.
- Developed RLS filter logic along with parameter cascading in paginated report.
- Estimation and budgeting for Power BI premium capacity and Gateways for customers.
Consultant
Nice Software Solutions Pvt. Ltd
Pune
04.2022 - 03.2023
- Architected multiple MSTR modules for migration using Dataflows, Datasets, Deployment Pipelines for report migration as well as BI Self-service.
- Managed a team of 6 developers as Power BI Offshore Lead in MSTR to Power BI Migration project for 50 reports.
- Developed and executed comprehensive migration plan for migrating from MSTR to Power BI, including assessing existing MSTR environment, identifying data sources, and planning migration timelines and resources.
- Designed and implemented MSTR data models in Power BI to accommodate data relationships, data transformations, and data integration requirements, ensuring smooth migration of data and reports. ü üModelled particular module using direct query and M-query parameters due to large data volumes for plotting complicated MSTR graphs.
- Created complex reports in Power BI Report Builder with advanced navigation functionalities using bookmarks.
- Worked with Import, Direct Query, Live connection modes as well as Dual mode for few modules as per requirement.
- Documented the migration process, including data mapping, report design, data model design, testing results, and user training materials, serving as a reference for future maintenance and enhancements.
- Introduced formatted tables to end users for quick data exports bypassing Power BI report limitations.
- Reviewed customer Power BI Multi-tenant solution architecture for possible issues, gaps and risk.
- Collaborated with Web App Development team for embedding Power BI reports as per custom requirements by finding the required Power BI SDK APIs ensuring seamless integration and adherence to security settings.
- Designed the model approach for unique transaction dimension tables with Direct Query and Dual mode based on Azure Synapse.
- Optimized performance of Power BI Embedded solution by optimizing report rendering, reducing load times, improving query performance, and optimizing data caching, resulting in enhanced performance and responsiveness of embedded reports.
- Collaborated with cross-functional teams, including developers, business users, and stakeholders, to gather requirements, provide technical guidance, and ensure smooth coordination in the development and deployment of Power BI Embedded solution.
Associate Consultant
Nice Software Solutions Pvt. Ltd
Pune
07.2021 - 03.2022
- Replicate the existing Power BI Dashboard with new flavor detection model integration.
- Collaborating with ML Engineers to structure the data extraction from DataBricks in required format for visualizing in Power BI.
- Data Modeling for the dashboard using Star schema in Power BI as well the table creation in Azure SQL Sever.
- Setup organization wide distribution for the dashboard using Power BI Workspace App.
- Transform data using Power Query features like Unpivot, merge, append, split, etc to generate analytical KPIs from raw data.
- Design Prototyping by connecting to various data sources like Sharepoint and Presto.
- Participating in internal technical initiatives.
Associate Consultant
Atos Syntel
Pune
09.2018 - 06.2021
- Designing and developing SSRS and Power BI reports as per business logic with CI/CD approach.
- Creation of SQL query for data retrieval as per business use case.
- Configuring SSRS report parameters, expressions, and calculations, adding interactivity to reports, and applying formatting and styling to reports.
- Deploying SSRS and PBI reports to report servers and PBI Service, ensuring proper security and permissions are set up for report access.
- Performing unit testing, integration testing, and troubleshooting report performance issues, data discrepancies, or other report-related problems.
- Providing L2 support to business users with Production report issues.
- Connecting with different client teams for understanding the business logic and providing end to end support post development.
- Understanding the existing SAS reports for the functionality, logic, and data sources used in the existing SAS reports.
- Rewriting complex SAS queries and expression to SQL queries and SSRS expressions to match the report functionalities.
- Identifying and articulating system KSDs to the team as well as the stakeholders based on impact.
Education
Bachelor of Engineering - Computer Engineering
MIT Academy of Engineering
Pune 08.2014 - 05.2018
Skills
Power BI
SSRS/Report Builder
T-SQL
DAX
Power Automate
Business needs analysis
Accomplishments
- Kudos! Award for being the best team player in my team
- Spot Award for helping business user(Investment Director) with BI report solution.
Certification
Microsoft Certified: Power BI Data Analyst Associate
Timeline
Senior Consultant
Nice Software Solutions Pvt. Ltd
04.2023 - Current
Consultant
Nice Software Solutions Pvt. Ltd
04.2022 - 03.2023
Associate Consultant
Nice Software Solutions Pvt. Ltd
07.2021 - 03.2022
Microsoft Certified: Power BI Data Analyst Associate
05-2021
Associate Consultant
Atos Syntel
09.2018 - 06.2021
Bachelor of Engineering - Computer Engineering
MIT Academy of Engineering
08.2014 - 05.2018