Power Bi Business Analyst
Resume:
DINESH M
Sr. Power BI Developer
Mail ID: *************@*****.***
Phone: +1-315-***-****
LinkedIn ID: www.linkedin.com/in/dinesh-m22
PROFESSIONAL SUMMARY:
• Highly skilled and results-driven Business Intelligence (BI) and Data Analytics Professional with 8+ years of experience delivering enterprise-level reporting solutions.
• Proven track record of transitioning from Business Analyst roles to advanced BI Development, demonstrating a deep understanding of business processes, KPIs, and data visualization best practices.
• Expertise in creating highly interactive and visually compelling Power BI dashboards and paginated reports, enabling executive leadership to make data-driven decisions.
• Specialized in Power BI, DAX, Power Query (M Language), and SQL for developing interactive dashboards and data models.
• Proficient in building star and snowflake schemas, data modeling, and implementing Row-Level Security (RLS) in Power BI.
• Skilled in integrating and transforming data from SQL Server (2012/2016/2019), Azure SQL, Excel, REST APIs, and healthcare-specific formats like FHIR.
• Working knowledge of Azure Data Factory, Azure Data Lake, and Azure Synapse Analytics for cloud-based data ingestion, ETL automation, and transformation.
• Skilled in defining key business metrics (KPIs) and developing advanced calculations using complex DAX measures for financial, sales, and operational reporting.
• Adept at automating data refresh schedules, managing Power BI workspaces, configuring data gateways, and ensuring high availability of reports through Power BI Service.
• Led Power BI workspace management, deployment pipelines, Power BI Gateway configuration, and dataset refresh automation using Power BI Service.
• Familiar with Power Automate, Power Virtual Agents and Power Apps for automating business workflows, alerts, and extending Power Platform capabilities.
• Adept at optimizing DAX queries and improving report performance using Performance Analyzer and DAX Studio.
• Strong understanding of data governance, security compliance standards (HIPAA, SOX), and implementation of data privacy controls in regulated environments.
• Worked extensively with ETL tools (SSIS) to support data pipelines and integrate data from multiple sources.
• Experienced in Agile/Scrum methodologies, participating in sprint planning, daily stand-ups, and project delivery cycles.
• Domain expertise in Healthcare, Pharmaceuticals, Banking, and Fintech.
• Successfully migrated legacy reports to Power BI and provided training for business users on self- service analytics.
• Familiar with Paginated Reports (Power BI Report Builder) for pixel-perfect reporting and printing solutions.
• Experienced in using Power Apps and Power Automate to enhance BI solutions and business workflows.
• Strong team player with excellent communication skills, capable of collaborating with business users and technical teams.
• Passionate about enabling organizations to make data-driven decisions through impactful visualizations and insights.
TECHNICAL SKILLS:
BI & Visualization Tools: Power BI (Desktop & Service), Power Query (M Language), DAX, Power BI Report Builder (Paginated Reports), Tableau ETL & Data Integration:
SQL Server Integration Services (SSIS), Azure Data Factory, Power Automate
Cloud & Data Platforms:
Azure Synapse Analytics, Azure Data Lake, Azure SQL Database, Snowflake
Databases & Query Languages: SQL Server (2012/2016/2019), T-SQL, PL/SQL, MySQL Programming & Scripting: SQL, DAX, M Query (Power Query), Python Automation & Workflow: Power Automate, Power Apps, Azure Logic Apps Version Control & DevOps: Azure DevOps, Git
Other Tools:
Excel (Advanced Functions, Pivot Tables, Power Pivot), SharePoint Integration, REST APIs
EDUCATION:
Bachelor of Business Management (BBM), Acharya Nagarjuna University, India ( May, 2015 ) Master of Business Informatics (MBAI), Judson University, USA ( Apr, 2025 ) CERTIFICATIONS:
Microsoft Certified Solutions Expert. (Business Intelligence, Data Management and Analytics) Azure Data Engineering Associate
PROFESSIONAL EXPERIENCE:
Camber Pharma Newark, USA
Senior Power BI Developer/ BI Consultant May 2024 – Present Responsibilities:
• Designed and built interactive Power BI dashboards and paginated reports for analyzing marketing campaign effectiveness, prescription trends, and consumer sentiment.
• Developed DAX-based performance KPIs for tracking medication sales by region, campaign response rates, and call-to-action (CTA) effectiveness across channels.
• Conducted data transformation and modeling using Power Query (M), integrating SQL Server, Excel, JSON, and FHIR APIs for unified reporting.
• Integrated and visualized customer sentiment data using Power BI + Python-based NLP, providing actionable insights to marketing and quality assurance teams.
• Applied Python (NLTK, Pandas) to extract customer sentiment from feedback datasets and combined it with structured campaign data for 360 analysis.
• Created paginated reports with cascading parameters for executive reporting and product performance summaries.
• Led end-to-end automation of ETL pipelines using SSIS, integrating structured and semi-structured feedback sources into centralized reporting models.
• Implemented Row-Level Security (RLS) in Power BI for user-level data segregation, especially for sales, QA, and executive roles.
• Optimized report performance using DAX Studio and applied best practices in data model optimization and visual hierarchy.
• Conducted A/B testing analysis on marketing variations and integrated insights directly into Power BI dashboards.
• Collaborated with digital marketing, sales ops, and R&D teams to design insight-driven reports used in board reviews.
• Delivered stakeholder-ready reports in Power BI Report Builder, adhering to HIPAA and internal compliance requirements.
• Conducted performance tuning using DAX Studio and optimized large Power BI datasets for responsive dashboards.
• Built wireframes and mockups for dashboards before final delivery, ensuring usability and accessibility.
• Provided L3 support for Power BI Service workspace refresh issues, dataset failures, and gateway connections.
• Led a small team of 3 developers; conducted code reviews, optimized DAX, and standardized folder/report structures.
Environment: Power BI (Desktop & Service), DAX, Power Query (M Language), SQL Server, SSIS, Power BI Gateway, Power BI Report Builder, Python (Pandas, NLTK), REST APIs, JSON, FHIR APIs, Excel Advanced, Power Automate, A/B Testing, HIPAA, Agile Delivery Atos Syntel Chennai, India
Senior Power BI Developer/ BI Consultant Jan 2021 – Jun 2023 Responsibilities:
• Developed advanced Power BI dashboards and KPI scorecards using Power BI Desktop, integrating data from multiple sources.
• Designed and implemented Drill-Through, Hyperlinks, and interactive slicers to enhance user experience.
• Created Paginated Reports with cascading parameters for regulatory and financial reporting.
• Automated ETL pipelines using SSIS and initiated cloud data migration using Azure Data Factory.
• Defined and optimized data models, schemas, and metadata, ensuring compliance with data governance standards.
• Developed and optimized DAX calculations for complex business KPIs, forecasting, and profitability analysis.
• Collaborated with business users to validate report designs and gathered feedback for continuous improvements.
• Led a team of 5 developers, assigning tasks and providing technical guidance on Power BI, DAX, and data modeling best practices.
• Provided training and ongoing support to users during the migration from SSRS to Power BI.
• Designed and maintained Python-based scripts and automation tools to streamline data processing tasks.
• Collaborated with teams to integrate data pipelines using Power Automate, Power Apps, and REST APIs.
• Optimized Power BI reports using DAX Studio and Performance Analyzer, reducing report load times by 40%.
• Conducted accessibility audits and proposed UI/UX enhancements to improve dashboard usability. Environment: Power BI (Desktop & Service), DAX, Power Query (M Language), SQL Server 2019, SSIS, Azure SQL Database, Azure Data Factory, Power BI Gateway, Power BI Report Builder, DAX Studio, Excel (Advanced Functions), Agile Models
Data Analyst/ Power BI Developer Jan 2019 – Dec 2020 Responsibilities:
• Collaborated with business and technical teams to gather reporting requirements and translate them into Power BI solutions.
• Developed and maintained enterprise-level dashboards for financial KPIs, sales performance, and operational metrics using Power BI Desktop and Service.
• Built and optimized star and snowflake schema data models to improve report performance and scalability.
• Developed ETL processes using SSIS to extract and transform data from SQL Server, Excel, and flat files.
• Created advanced DAX calculations and measures for financial forecasting, variance analysis, and sales performance metrics.
• Automated data refresh schedules using Power BI Service and managed datasets through Power BI Gateways.
• Designed and delivered Paginated Reports (Power BI Report Builder) for financial compliance and audit requirements.
• Worked with cross-functional teams to migrate reports from SSRS and Excel to Power BI, enabling self- service analytics.
• Conducted performance tuning of Power BI datasets and optimized DAX queries using DAX Studio.
• Provided business user training sessions on Power BI, enabling effective self-service analytics. Environment: Power BI (Desktop & Service), DAX, Power Query (M Language), SQL Server 2016/2019, SSIS, SSRS, Power BI Gateway, Power Virtual Agents, Power BI Report Builder, Excel (Advanced Functions), Hybrid.
PhonePe Hyderabad, India
Data Analyst/ Jr. Power BI Developer Oct 2017 – Dec 2018 Responsibilities:
• Collaborated with cross-functional teams to gather business requirements and translate them into actionable reporting solutions using Power BI.
• Developed interactive dashboards to monitor key performance indicators such as Gross Merchandise Value (GMV), Daily Active Users (DAU), Monthly Active Users (MAU), and transaction success rates.
• Utilized Power Query (M Language) for data extraction, transformation, and loading (ETL) processes, integrating data from SQL Server and Excel sources.
• Built complex DAX measures to calculate customer retention, average transaction value, and marketing ROI.
• Creation and modification of SSRS reports meeting business requirements.
• Create and Modify SQL scripts to cater to the requirements.
• Designed and implemented star and snowflake schema data models to optimize report performance and scalability.
• Created Paginated Reports (Power BI Report Builder) for financial reporting and statutory compliance.
• Configured and managed Power BI Gateways and implemented Row-Level Security (RLS) for secure data access.
• Optimized report performance using DAX Studio and Performance Analyzer, reducing dashboard load times by 30%.
• Worked closely with fraud analytics teams to create dashboards detecting high-risk transactions and geolocation anomalies.
• Provided end-user training on Power BI self-service analytics and ad-hoc reporting. Environment: Power BI (Desktop & Service), DAX, Power Query (M Language), SQL Server 2016/2019, SSIS, Power BI Gateway, Power Virtual Agents, Power BI Report Builder, DAX Studio, Waterfall/Hybrid Methodology.
Business Intelligence Specialist Sep 2016 – Oct 2017
• Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS.
• Solution design and implementation
• Creation, Testing of ETL jobs.
• Working on and creating ETL packages to load the data.
• Designing and implementing ETL Transformations with SSIS.
• Review test scenarios for UT, SIT, UAT and Production and Support team on defect analysis and resolution.
• Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transforming and finally loading into the Target Tables.
• The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.
• Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages. Environment: SSIS, Power BI, SQL Server, Waterfall Methodology. Paytm Hyderabad, India
Business Analyst July 2015 – Aug 2016
Responsibilities:
• Partnered with business and technology teams to gather reporting requirements and translate them into functional BI dashboards.
• Analyzed large volumes of transactional and financial data to provide insights into payment gateway success rates, transaction failures, and fraud detection patterns.
• Designed and developed initial Power BI dashboards for executive management, focusing on revenue trends, transaction volumes, and operational KPIs.
• Created data models in Power BI using Power Query (M Language) to clean and transform raw data for accurate reporting.
• Built complex DAX measures for financial performance metrics, including customer acquisition cost, average transaction value, and churn rate analysis.
• Automated recurring reports by integrating Power BI Service with scheduled refreshes, reducing manual reporting efforts by 40%.
• Developed management reports using Excel Advanced Functions (PivotTables, Power Pivot, VLOOKUP, INDEX/MATCH) for financial forecasting and budget tracking.
• Worked with the engineering team to ensure clean data pipelines and accuracy of datasets sourced from SQL Server and REST APIs.
• Coordinated with fraud prevention teams to develop dashboards highlighting high-risk transaction patterns and flagged anomalies.
• Implemented Row-Level Security (RLS) in Power BI to restrict access to sensitive financial data based on user roles.
• Conducted workshops to train business teams on using Power BI dashboards for self-service analytics and ad-hoc reporting.
Environment: Power BI (Desktop & Service), DAX, Power Query (M Language), SQL Server 2012/2016, REST APIs, Excel (Advanced Functions, Power Pivot), Power Virtual Agents, Power BI Report Builder, Waterfall Methodology.
Contact this candidate