Meena Prem

Power BI Developer

Erie Insurance

Oct 2024 - Present

Designed and developed interactive Power BI dashboards to track policy performance, claims management, and customer retention. Built optimized data models in Power BI using DAX and Power Query for accurate KPIs and efficient analysis. Extracted, transformed, and loaded (ETL) data from SQL Server and Oracle into Power BI for consolidated reporting. Created complex SQL queries, joins, and stored procedures to prepare structured, analysis-ready datasets. Scheduled automated data refreshes in Power BI Service and optimized performance for near real-time analytics. Partnered with business stakeholders to gather requirements and enhance BI solutions, ensuring data-driven decision-making across insurance operations. Applied data visualization best practices to highlight trends in underwriting, claims, and risk management. Conducted performance tuning and optimization of Power BI reports and SQL queries to improve efficiency and reduce load times.

Power BI Developer

Walmart

Mar 2023 - Sep 2024

Developed a sale analysis dashboard for Walmart. Analysis sale trend, revenue, profit and regional performance using data modeling and DAX. Created interactive dashboard with KPIs and automated data refresh for business insight. Present the analysis to internal and external teams and explain data from a sales perspective and relevance to Key Performance Indicators (KPI). Delivering reports to Sales team on timely manner. Created calculated columns and measures using DAX and prepared report and dashboards in Power BI. Build Pages with Slicers for Quick filters, Generated Report Level filters while handling huge volumes of data. Execute and tested required queries and reports before publishing dashboard. Implemented Role Based Security as part of user level security in Power BI Designing and developing Power BI scripts for importing data from Source.

Transaction processing associate

Accenture

Mar 2018 - Jan 2020

Power BI Developer

Aspire Systems

Jan 2021 - Present

Working with Power BI Desktop and Power BI Service to create and maintain effective reports and dashboards. Developed new reports and dashboards, as well as enhanced existing ones based on client requirements. Analyze large datasets from multiple sources, ensuring data accuracy, completeness, and integrity. Develop, design, and maintain interactive Power BI dashboards and reports that provide business insights and track KPIs (Key Performance Indicators). Designed and implemented scalable ETL processes to prepare and structure data for Power BI dashboards, enabling accurate, real-time analytics and business decision-making. Skilled in writing complex DAX formulas to derive meaningful insights from raw data. Experienced in extracting, transforming, and loading data from various sources using Power Query, SQL, and other data integration tools. Familiar with integrating Power BI with various data sources, including Excel, SharePoint, SQL Server, and cloud platforms like Azure. Published and shared reports on Power BI Service to enable team collaboration and decision-making. Followed Agile methodology, actively participating in daily stand-ups, sprint planning, and reviews to ensure timely and quality delivery of BI solutions. Performed performance tuning and optimization of Power BI reports and data models to enhance load times and improve overall user experience.

Power BI Developer

Ash field commercial and medical services

Aug 2021 - Feb 2023

Using SQL and Power BI to analyze patient feedback, service, quality and hospital performance metrics. Enabled management to monitor Satisfaction Scores and improve healthcare service and quality. Involved discussion with business users and provide technical guidance for Power BI Desktop and Power BI Service. Created Filters and applied conditional formatting based on user requirement. Created Slicer and measures and columns in Power BI Desktop. Created different types of reports in Power BI Desktop Pinning reports to the Dashboards as per the requirements. Created scheduling and sharing the reports & Dashboards using Data Gateway. Generating reports using DAX Time intelligence functions and other kind of DAX functions. Involved in Creating Hierarchies and giving the relationship between attributes to decrease processing time, Created Visuals and Reports in Power BI Desktop and published into Power BI Service. Created Reports and Dashboards and implemented RLS in Power BI Desktop & Service as per requirement.