Kunal Kawale

• Translated business requirements into analytical solutions, designing methodologies and providing actionable insights to stakeholders.
• Led end-to-end reporting projects for Supply Chain and Revenue, from requirement gathering to dashboard deployment.
• Collaborated with stakeholders to define KPIs and reporting needs for procurement and revenue analysis.
• Performed exploratory data analysis (EDA) to identify key trends and drivers behind procurement delays and revenue fluctuations.
• Ingested and transformed data from NetSuite using Talend (ETL), ensuring data quality for reporting.
• Delivered insights in Purchase Order Analysis, Vendor Performance, and Inventory Management, improving operational efficiency.
• Provided actionable insights into cost-saving opportunities, procurement optimization, and revenue trends by analyzing product and customer segment performance.

• Monitored SSIS jobs and ETL workflows, proactively identifying failures or delays and escalating issues to managers and stakeholders as needed.
• Actively supported change deployments by assessing potential impacts on credit risk systems and coordinating with development and infrastructure teams to ensure smooth transitions.
• Managed and resolved incidents via ServiceNow, prioritizing based on severity and business impact to maintain continuity of credit risk operations.
• Collaborated with cross-functional teams to troubleshoot root causes and implement long-term solutions by collaborating with other teams for recurring issues.

Power BI & Reporting

• Created and maintained interactive Power BI dashboards using complex DAX and M queries, hosted via Power BI Service and Apps.
• Worked on Power BI projects utilizing XMLA Endpoints, ALM Toolkit, Tabular Editor, and DAX Studio.
• Developed SSRS reports based on SQL stored procedures to meet business requirements.
• Troubleshot Power BI, SSRS, and SSAS report issues across Dev, UAT, and Production environments.
• Documented technical specifications, data dictionaries, and standard operating procedures.

Data Modeling & Analysis Services

• Worked with SSAS Tabular and Multidimensional models to support business intelligence solutions.
• Developed and enhanced SSIS ETL packages, including data flow tasks, and deployed them to production.

SQL Development & Performance Tuning

• Designed complex SQL queries, including stored procedures, views, functions, constraints, joins, and indexes to implement business logic.
• Tuned and optimized SQL queries using tools like EXPLAIN plans, SQL Trace, and Stored Outlines to resolve performance issues.

Operations, Collaboration & Support

• Monitored data jobs and provided timely inputs to managers and stakeholders in case of failures or incidents.
• Supported production systems, Production deployment and incident resolution related to SSIS, SSAS, Power BI, and database performance.
• Collaborated with cross-functional teams including Product Development and QA to ensure smooth operations.
• Communicated with clients and dependent teams to gather functional understanding and address dependencies.
• Recommended and implemented improvements to existing BI processes and data flow architectures.

Leadership & Mentorship

• Mentored junior team members and conducted training sessions on BI tools and best practices.