Pavan Kumar Email & Phone Number

Sunnyvale, California, United States

• Developed interactive Power BI reports and dashboards for various departments, enabling real-time data analysis and performance tracking.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from Power BI databases.
• Utilized exceptional interpersonal and presentation abilities to effectively show case newly derived metrics from sales data using advanced data analysis with pandas and NumPy.
• Collaborated with cross-functional teams to understand business requirements and translate them into actionable data insights.
• Successfully implemented Power BI's SQL connectors to integrate diverse healthcare data sources, including electronic health records (EHR) and patient management systems, improving data accessibility, and streamlining.
• Successfully integrated Microsoft Dynamics 365 with Power BI to provide healthcare organizations with real-time insights into patient data, financial performance, and operational metrics.

Palo Alto, California, United States

Developing Tableau Data Visualizations using Cross Map, Scatter Plots, Geographic Map, Pie charts, Bar charts, Density charts and Heat maps and providing production support to Tableau Users and writing custom SQL queries to support business requirements.Generating reports using global variables, expressions, and functions for the reports and utilizing.

• Participated in the team business requirements gathering and analyze, understand, and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment.
• Developed and published dynamic and complex Financial and Sales Reports in Power BI via Azure cloud.
• Used DAX to create complex measures and calculated columns.
• Extensive SQL Development experience in Banking and Human resources industries with a strong understanding of data & analytics.
• Utilized Dynamics 365 to design real-time fraud detection systems, enabling prompt identification and prevention of fraudulent activities and enhancing security for both customers and the bank.
• Employed Microsoft Dynamics 365 to manage and track asset portfolios, optimize investment strategies, automate asset allocation and rebalancing.