Suraj Pandit Email and Phone Number

• Building self-service architecture, data governance strategies within Power BI, enablingdata culture within organizations, providing user training, and driving adoption.• Developing BI Accelerators/Products that will reduce overall time to market, bring in efficiencies and help stand out during RFPs/Proposals.• Knowledge of Power BI REST APIs, Administration, and building custom solutions to bringgovernance and optimization.• Knowledge of Power Automate and build customized automated solutions to bring inefficiencies.• Implemented BI Performance tuning in 30+ dashboards and optimized the DAXExpressions and dashboard data models which reduced node cost by 50%.• Develop a composite model incorporating aggregation and direct query approach byunderstanding the business context.• Implemented Hot and Cold model to accommodate 20 Years of data.• Implemented Incremental Refresh using Tabular Editor to minimize resource Capacity andlower Refresh time.• Implementation of Power BI Project (PBIP) and Azure DevOps build pipelines for continuous integration.

• Developed Dynamic Power BI Reports as one-stop financial management insights apps for executive-level leaders (directors to C-level) to track accounts receivable and payable to monitor the health of the business.• Analysed and interpreted customer data to identify trends and patterns, resulting in a 15% increase in customer satisfaction and a 10% increase in customer retention.• Developed and maintained a suite of KPI dashboards that provided executives withimmediate visibility into performance metrics.• Collaborated with Business Stakeholders, Functional Leaders, and other team members todetermine data extraction, transformation requirements, prototype design and prepareFDD and TDD.• Led the development of a reporting solution suite containing 16 Power BI reports (e.g.,production and inventory reports) using direct query.• Develop Financial deliverables (quarterly, accrual, and budgetary reports) for fundingagencies: as well as POC and solution mock-up’s.• Developed enterprise Data models in SSAS(SQL Server analysis Services) and AAS(AzureAnalysis Services), and Performance optimization.• Accomplished and Configure Azure Data-lake and Azure SQL Database with Power BI andMicrosoft Dynamics 365.• Embedded Power BI Dashboard with Microsoft Dynamics 365 HR and F&O AnalyticsApplication.• Experienced in all facets of the software development life cycle (analysis, design,development, testing and maintenance) using waterfall and agile methodologies usingAzure Devops.

• Developing and maintaining Sales report of Existing stores across Cortex and makingchanges in Dashboard as per management's requirement• Track the performance of stores against ongoing marketing campaigns and initiatives,providing insights thereby empowering management in better decision making• Implemented RLS(Row Level Security) and OLS(Object Level Security) on datasets• Implemented Power BI Gateways to keep the dashboards and reports up to date.• Created Parametrized Report, Linked Report, Superimposed Report• Analyzed the data by Performing Hive Queries and running Unix Scripts to know theinsights of existing customer and potentials customers.• Preformed commissioning, decommissioning, and managing Node optimal performance of the Hadoop cluster• Involved in Analyzing Batch job failures, identifying root causes, and recommended courseof actions. Documented the systems processes and procedures for future references.• Automated the job process in Hadoop system using Unix shell script• First-hand experience in analyzing log files for Hadoop and eco-system services and• finding root causes.