Varun R Email and Phone Number

Data Preloading Optimization: Leveraged M query parameters in Power BI to reduce data preload times by dynamically injecting filters based on user input, improving efficiency and responsiveness. DAX & Bookmarking: Utilized advanced DAX and bookmarks to build interactive Power BI reports tailored to user needs. Web Application Integration: Embedded Power BI reports into web applications, enhancing user access to dynamic data visualizations directly within the interface. Custom Visual Development: Created custom visuals using TypeScript, extending Power BI’s capabilities for tailored data representation. Power BI Report Server Configuration: Deployed Power BI Report Server on-premises, including full branding and folder structure setups for efficient report management. PostgreSQL Performance Optimization: Improved performance on an 30M+ record data sources by leveraging partitioning and TimescaleDB hypertables and continuous aggregates, achieving data aggregation in 4-5 seconds. Analyzed execution plans, applied indexing, and optimized queries to resolve bottlenecks. Implemented data compression for infrequently accessed data, reducing storage usage. Apache Superset Development: Configured and deployed Superset via Docker, using Jinja templating to minimize preload times and enhance performance. Embedded Superset reports with Row-Level Security (RLS). Database System Tuning: Performed PostgreSQL analysis to monitor connections and fine-tuned configuration parameters (e.g., work_mem, shared_buffers) to improve overall performance.

In response to executive leadership's need for more detailed analytics on the open emr's existingbuilt-in reports, Analyzed the codebase to identify necessary data points and constructed a datamodel, starting from the patient level and extending all the way through billing.Leveraged Superset to aggregate data and create insightful data visualizations that providedbusiness users with improved insights and informed data-driven decisions while maintaining HIPAAcompliance.Maintained and updated data models to reflect changes in business requirements and data sources.Utilized stored procedures to improve query performance by reducing network traffic and databaseload, as well as minimizing the number of roundtrips between client and server.Improved the overall efficiency of the business users by automating manual processes previously performed in Excel, resulting in the creation of real-time downloadable reports for immediate access and distribution to medical professionals.Identified recurring posting errors and leveraged Superset to create a detailed report of the error,Presented the report to the claims processing team, leading to a significant reduction in errors andimproved efficiency.Designed and implemented a comprehensive email alert system using Python and SQL that monitorsboth key performance indicators (KPIs) and claim status.Utilized advanced features of Power BI, such as data modeling and DAX formulas, to design reportsfor tracking employee performance across various tools such as JIRA and Ring Central.

Extracted data from various databases and performed transformation before loading into snowflake using combination of SQL, Talend, JavaCreated dynamic data pipelines using data warehousing conceptsHelped the client to achieve flow migration from Alteryx to Talend by recreating the flows in Talend Imported data from Snowflake into Power BI and created data models.Analyzed and presented data using Power BI to help the client make important decisionsCreated interactive and highly informative Power BI Reports (Line Chart, Bar Chart, Tree map, Single Card, KPI, Pie Chart, custom visuals) using DAX featuresUsed Slicers and Filters in the reports to accurately filter and sort visuals and make sure the end users has the relevant information availableUsed power query for data cleansing and data manipulation