Darsini Penmetsa
Naperville,IL
Summary
Experienced Power BI Developer with over 6 years of expertise in gathering data from various sources and transforming it into insightful reports and dashboards. Proficient in data modeling, integrating reporting components from multiple data sources, and designing interactive visualizations. Seeking new opportunities to leverage my skills and drive data-driven decision-making in a dynamic environment
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Power BI Developer
Kentucky State
01.2022 - Current
- Worked closely with business stakeholders and technical teams to identify business requirements and deliver effective data solutions.
- Collaborated with cross-functional teams to gather business requirements, analyze data needs, and deliver scalable data solutions aligned with business objectives.
- Leveraged Power Query to perform complex data transformations, including data cleaning, merging, and shaping from various sources.
Created optimized DAX calculations and measures to enable advanced analytics and key performance indicators (KPI’s) tracking.
Utilized DAX aggregation functions such as SUM, AVERAGE, and COUNT to perform comprehensive data analysis and derive key performance indicators (KPIs) for business reporting and decision-making processes.
Leveraged DAX time intelligence functions such as TOTALYTD, SAMEPERIODLASTYEAR, and DATEADD to analyze trends, compare data across different time periods, and calculate year-to-date or quarter-to-date figures for accurate forecasting and trend analysis.
Implemented DAX filtering functions such as CALCULATE, FILTER, and ALL to apply dynamic filtering conditions on Power BI reports, enabling users to drill down into specific subsets of data for deeper insights and analysis.
Implemented row-level security (RLS) to ensure data confidentiality and restricted access based on user roles and permissions.
Developed interactive Power BI dashboards to visualize data insights and facilitate decision-making processes.
Power BI Developer
Ecolab
06.2020 - 12.2021
- Gathered and documented business requirements for analytical reports.
- Participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
Developed at least two - three visual options for each report for discussion with stakeholders (product owners and leadership) and customers.
Integrated Custom Visuals based on business requirements using Power BI desktop.
Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and AAS reports.
Developed complex calculated measures using Data Analysis Expression language (DAX).
Embedded Power BI reports on Salesforce portal page and managed access of reports and data for individual users using Roles.
Worked with Microsoft team on product limitations and communicate limitations and tools capabilities to the United IT and business stakeholders.
Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
Conducted comprehensive data profiling, mapping, and integrity analysis to ensure data accuracy and reliability.
Power BI Developer
Walgreens
01.2019 - 05.2020
- Streamlined data preparation processes using Power Query to cleanse and transform data from multiple sources.
- Developed interactive dashboards and reports, incorporating various visualizations and DAX measures for advanced analytics.
Automated data refreshes and deployment using Power BI gateways and scheduled tasks.
Optimized model performance through effective data modeling and query optimization.
Implemented row-level security to protect sensitive data and ensure compliance.
Developed Power BI reports, dashboards, and executed DAX queries for advanced analytics.
Designed and developed schema data models.
Improved existing reports and conducted analysis to improve report performance.
Prepared training materials for Power BI developers with report development best practices, recommendations for specific cases, and overall report design patterns.
Interviewed business users of the data warehouse and business analysts to understand and troubleshoot the existing bottlenecks and problem areas.
SQL Report Developer
Despir
01.2017 - 12.2018
- Designed and developed SQL reports to meet business requirements, ensuring accuracy and relevance of data presented.
- Collaborated with business stakeholders to gather report requirements and translated them into effective reporting solutions.
Conducted performance optimization on SQL queries to enhance report generation speed and efficiency.
Created visually appealing and insightful reports using data visualization tools for improved data interpretation.
Ensured data accuracy and integrity in reports through thorough testing and validation procedures.
Collaborated with the database management team to optimize database queries and improve overall system performance.
Actively participated in cross-functional teams to align reporting solutions with organizational goals.
Developed and maintained SQL queries for various reporting needs, including ad-hoc and scheduled reports.
Assisted in database management tasks, including data extraction, transformation, and loading (ETL) processes.
Conducted data analysis to identify trends and patterns for inclusion in reports.
Participated in report testing and validation to guarantee the accuracy of presented information.
Collaborated with end-users to gather feedback and implemented improvements to meet evolving business needs.
Education
M.S. Information Systems -
DePaul University
Chicago, IL11.2014
B.E. Information Technology -
Andhra University
Visakhapatnam 04.2006
Skills
- Microsoft Power BI (Development and Administration)
- Azure and Power BI Administration
- PBI Premium Capacity Administration
- Row-level Security Implementation
- Data Visualization and Reporting
- DAX Queries and Expressions
- Data Management (Master Data Management, Data Governance, Data Integration)
- SQL (Redshift, Netezza, Microsoft SQL Server, MySQL, Snowflake)
- Dimensional Data Modeling
- Problem Solving and Critical Thinking
- Strong Communication Skills
- Time Management and Multi-tasking
- Virtual and Global Team Collaboration
Certification
- Microsoft Power BI Developer
- Google Business Intelligence Professional Certificate, https://www.coursera.org/professional-certificates/google-business-intelligence
Timeline
Senior Power BI Developer
Kentucky State
01.2022 - Current
Power BI Developer
Ecolab
06.2020 - 12.2021
Power BI Developer
Walgreens
01.2019 - 05.2020
SQL Report Developer
Despir
01.2017 - 12.2018
M.S. Information Systems -
DePaul University
B.E. Information Technology -
Andhra University