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 analytics.● Successfully integrated Microsoft Dynamics 365 with Power BI to provide healthcare organizations with real-time insights into patient data, financial performance, and operational metrics.● Designed and implemented workflow automation processes within Dynamics 365 to streamline healthcare operations, such as appointment scheduling, billing, and claims processing.● Enabled real-time access to critical patient information by configuring SQL connectors, facilitating timely clinical decision-making.● Implemented data transformation processes through Power BI's SQL connectors to ensure data quality, accuracy, and consistency in healthcare analytics.● Created complex data models using Power BI's SQL connectors to establish meaningful relationships between healthcare data tables, enhancing the quality of insights generated.● Worked closely with various teams across the company to identify and solve business challenges.

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 Tableau server to publish and share the reports with the business users.Working knowledge of data profiling and modeling.Responsible for researching and resolving bad data or transactions contributing to bad data quality and providing continuous improvements to existing process and application framework by meeting service level agreement (SLA's) and streamlining business processes.Maintaining a repository of reusable documentation to support future initiatives in SharePoint using SCRUM/Agile development methodology (Daily scrum meeting, Planning Poker, Sprint Backlog) and participating in sprint planning, daily scrum meeting, retrospectives, and sprint reviews.Analyzed Spotfire data visualization using Cross Tab reports, Summery tables, Line charts, Bar charts Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Line Chat, and Density Chart.Designed and analyzed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau desktop.Created Complex Tableau reports utilizing features like Hierarchy, New Calculated Columns, Actions - Drill Down functionality, Graphs. Also Created Parameters to achieve desired functionality.Analyzed as-is and to-be business process flows, and data models required for new system development or for process redesign by serving as an interface between business and technical teams.Worked on Security concept using RLS (Row -Level-Security) both static and Dynamic.Installation of gateway and implemented scheduled data refreshes with on-premises data gateways as per the business requirement.

● 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, documentation & implementation. ● 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.● Ensured robust security measures and compliance with banking regulations when working with SQL connectors in Power BI, safeguarding sensitive financial data.● Created sophisticated data models using Power BI's SQL connectors, establishing complex relationships between financial data tables, enhancing the quality of insights generated.● Utilized SQL connectors for historical and real-time risk analysis, enabling the bank to assess and mitigate financial risks effectively, contributing to sound risk management practices.● Setting up Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway. ● Used bookmarks feature which enables the ease to jump to respective report tabs with one click. ● Imported custom themes and page backgrounds for rich visual effects. ● Performed end to end testing on the reports and packages developed to ensure data quality is met. ● Creating and managing schema objects such as Tables, Views, Indexes, and referential integrity depending on user requirements.