Devanand Manikandan
Bangalore
Summary
Dynamic Power BI Developer with over 5 years at ZydeSoft Solutions, specializing in data integration and visualization. Expert in DAX and SQL, I deliver impactful dashboards that drive business decisions. Adept at stakeholder communication and performance optimization, I enhance data accessibility and reporting efficiency, ensuring timely insights for strategic initiatives.
Overview
5
5
years of professional experience
Work History
Power BI Developer
ZydeSoft solution
08.2020 - Current
- BI Developer with 5+ years of experience in designing and developing business intelligence solutions using Power BI, SQL, and Oracle. Experienced in creating efficient dashboards and reports that provide actionable insights to business stakeholders. Strong understanding of BI tools, data modeling, DAX, Power Query, and report deployment using Power BI Service.
- Hands-on experience with Power BI Desktop and Power BI Service to design, develop, and maintain interactive reports and dashboards, delivering actionable insights for business decision-making.
- Skilled in integrating data from multiple sources such as SQL Server, Oracle, Snowflake, Excel, SharePoint, Databricks, and Microsoft Azure, ensuring comprehensive data analysis and reporting in Power BI.
- Proficient in working with REST APIs to fetch and integrate external data into Power BI for real-time reporting and analytics.
- Expertise in utilizing the Microsoft Power Platform including Power Pivot, Power Automate, Power Apps, and Power BI Service for building, automating, and optimizing end-to-end BI solutions.
- Dimensional modeling expertise, including Star and Snowflake schema design, and enhancing existing models based on client requirements. Designed data models and managed relationships using joins to ensure seamless data flow.
- Skilled in developing complex Advanced DAX formulas.
- Designed and maintained interactive Power BI dashboards and reports to track KPIs, business metrics, and performance indicators.
- Integrated data from various sources to generate detailed paginated reports using Report Builder, providing clear and insightful business analysis.
- Published and shared reports on Power BI Service to enhance team collaboration and decision-making, enabling real-time access to critical business data.
- Managed the deployment and scheduling of data refreshes, ensuring that reports and dashboards are always up-to-date.
- Installed and configured On-Premises Data Gateway to enable secure, seamless data access between internal systems and Power BI.
- Advanced SQL query writing skills for data extraction, transformation, and reporting in Power BI.
Education
Master of Science - Global Business Management
Rennes School of Business
Rennes, France04-2023
BBA - Computer Science
DR.M.G.R University
Chennai, India01.2020
Skills
- Power BI Desktop
- Power BI Service
- Power Query Editor
- Data Modeling
- DAX Function
- Data Visualization
- SQL
- Oracle
- Report Builder
- Power Platform
- Security
- Performance Optimization
- Data Refresh
- Agile/Scrum Methodologies
- Data Governance
- Stakeholder Communication
- Git (Version Control)
- Advanced Excel
- Power BI development
- SQL querying
- Data modeling
- DAX formulas
- Data integration
- Dashboard design
- Report deployment
- Data visualization
- Business analysis
- Data analysis
- KPI tracking
- ETL processes
- Team collaboration
- Database management software
Project -1 GuideOne (Domain - Insurance),
Developed and deployed 50+ interactive Power BI dashboards across insurance, retail, and healthcare domains using Power BI Desktop, Power BI Service, SQL Server, SharePoint, and Oracle. Built complex DAX measures, optimized SQL queries and Power Query transformations (reducing load times by up to 60%), and designed efficient data models (Star/Snowflake) to support analytics for KPIs like policy approvals, claims cycles, sales trends, and clinical outcomes. Automated data refreshes for 15+ datasets, implemented Row-Level Security (RLS), and configured On-Premises Data Gateway for secure connectivity. Collaborated in Agile teams to deliver scalable, real-time reporting solutions that improved performance and reduced manual reporting efforts by up to 80%.
Project -2 CVS Healthcare
Designed and deployed interactive Power BI dashboards using slicers, filters, calculated columns, and custom visuals. Preprocessed large healthcare datasets from EHRs, claims, and clinical sources, optimizing Power Query and SQL to cut load times by 50%. Published reports to Power BI Service with Row-Level Security (RLS) to ensure secure, role-based access.
Project 3- Krogger
Built 20+ sales dashboards by integrating 10M+ rows from SQL Server, Excel, and SharePoint into a unified model. Designed Star schema with 5+ fact and 20+ dimension tables, improving performance by 35%. Developed 40+ DAX measures for advanced analytics like YoY growth and contribution margins. Automated daily data refreshes, cutting manual effort and reporting time by 80%.
Timeline
Power BI Developer
ZydeSoft solution
08.2020 - Current
Master of Science - Global Business Management
Rennes School of Business
BBA - Computer Science
DR.M.G.R University
Similar Profiles
Kapil ThukralKapil Thukral
AR Analyst at ACS Solution (now Innova Solution)AR Analyst at ACS Solution (now Innova Solution)
STELLA.B STELLA.B null
Human Resources Intern at Accevia Global Solution Private SolutionHuman Resources Intern at Accevia Global Solution Private Solution
Girish Kant AryaGirish Kant Arya
Control Room Engineer at M/S O&M Solution M/S O & M SolutionControl Room Engineer at M/S O&M Solution M/S O & M Solution
NAINIKA NAGIRIMADUGUNAINIKA NAGIRIMADUGU
Sr. Strategic Plan Specialist at Honeywell Technology SolutionsSr. Strategic Plan Specialist at Honeywell Technology Solutions
Debabrata DashDebabrata Dash
Consulting Member of Technical Staff at OracleConsulting Member of Technical Staff at Oracle