DILIP PALIWAL

• Over 9+ years of experience in consulting and industry, with a strong focus on business intelligence (BI) solutions.
• 5+ years of hands-on development expertise with the Microsoft BI stack, including Power BI, MS SQL, Power Apps, and Power Automate.
• Experienced in designing, developing, and maintaining Power BI dashboards and reports aligned with business objectives and KPIs.
• Solid understanding of Power BI architecture and best practices for creating scalable, sustainable BI solutions.
• Strong leadership and interpersonal skills with a commitment to team-oriented work environments.
• Creative and analytical problem-solver with strong verbal and written communication skills.

• Alteryx designer core certificate from Alteryx.
• Business Intelligence using Power BI & Tableau from Grant Thornton.
• IBM Introduction to Data analytics from Coursera.
• Microsoft Power BI training from Multisoft Systems.
• SQL (Basic & Intermediate) From HackerRank.
• Cyber Security training from Grant Thornton.
• Analytical Excel from Grant Thornton.
• Microsoft PowerPoint from Multisoft Systems.

• Passport Details: Available
• Date of Birth: 09/10/92
• Gender: Male
• Marital Status: Single

❖ Travel & Expense claims Dashboard for Procurement team.

Developed to streamline the tracking and management of employee travel and expense claims, ensuring transparency, efficiency and accuracy in financial reporting.

Tools used : Tableau, SQL, Excel.

❖ Vendor Contract Dashboard

Developed to centralize and streamline the management of vendor contracts, ensuring efficiency, tracking and timely renewal/termination of contracts.

Tools used: Tableau, SharePoint, Excel.

❖ PowerApps based SRM reporting dashboard

Interactive reporting dashboard for SRM team to keep track of their monthly reporting and monitoring KPI’s.

Tools used: PowerApps, Power Automate, Power BI.

❖ MIS Automation for Admin team.

Complete automated process of reading emails, saving the attachments to a specific folder, reading the required information from invoices, and updating the MIS dashboard.

Tools used : Power Automate, Power BI, Excel.

❖ Order to Cash dashboard for Finance team.
OTC dashboard prepared to ensure smooth and efficient order processing, fulfillment, and revenue collection.
Tools used : Power BI, SQL.

❖ KPI’s of Power generation for Operations team.
Raw data collection, cleaning and analyzing the impacts and calculating corrections factors for insights on power generation.
Tools used: Power BI, SQL, Python.

❖ Data Quality Enhancement and Standardization for the Sales Team.
Identified and resolved data quality issues, ensuring the accuracy and integrity of the sales dataset.
Tools used : Alteryx, SQL.

❖ Employee Data analytics for HR team.
Analyzed various KPI’s and identified the key areas of improvement to work on for HR team.
Tools used : Power BI, SQL, Excel.

❖ Financial Reporting and Analysis.
Developed a financial reporting solution that consolidates data from multiple sources to provide stakeholders with real-time visibility into the financial health of the organization.
Tools used : Power BI, SQL.

❖ Customer Segmentation and Analysis.
Created a customer segmentation dashboard that classifies customers based on demographics, purchase behavior, or other relevant variables.
Tools used: Tableau, SQL.