Sr BI Consultant
Unison Consulting Pte Ltd
Total years of experience :7 years, 0 Months
• Designed, developed and supporting Interactive Dashboards with Power BI Desktop and publish the same in Power BI Service.
• Implemented effective data visualizations and storytelling techniques to convey insights clearly.
• Utilized different filtering ways, Slicers, Cards and Bookmarks so as to make the Visualizations more efficient and Easy to Understand.
• Enabled drill-through and drill-down capabilities to allow users to explore data intuitively.
• Customized DAX measures, calculated columns and establishing the relationship within the different tables with Star/Snowflake Schemas for proper filter flow.
• Established the end-to-end development of Power BI solutions, from data acquisition and transformation to interactive dashboard creation.
• Implemented advanced analytics features in Power BI, including predictive modeling and data-driven insights.
• Customized Power BI dashboards based on business requirements, incorporating dynamic filters and slicers.
• Extensive usage of different Charts viz, Bars, Clustered columns, Tree-Maps, Donut Charts, Waterfall Charts, Maps and other third-party Visualizations so as to elevate various insights from Datasets.
• Collaborated closely with business stakeholders to understand and refine reporting requirements.
• Optimized and fine-tune Power BI solutions for improved performance and user experience.
• Diagnosed and troubleshoot issues within Power BI reports and datasets, ensuring data accuracy and reliability.
• Implemented robust ETL processes to integrate and transform data from diverse sources into Power BI.
• Designed, developed, and maintained OBIEE repositories, including the logical, physical, and presentation layers to support reporting requirements.
• Developed the Interactive Dashboards & Reports end-to-end using OBIEE and accountable for entire process from development to support
• Performed in-depth performance analysis and tuning of OBIEE reports and queries to optimize system response times.
• Implemented and managed security protocols within OBIEE, including user access controls, role-based security, and data governance policies
• Worked closely with ETL developers to seamlessly integrate OBIEE with data sources, ensuring data quality and consistency.
• Involved actively in Performance tuning of SQL queries and database processes.
• Monitored Informatica workflows, sessions, and jobs meticulously to guarantee their successful execution and troubleshoot any issues promptly.
• Collaborated with business analysts and end-users to gather and understand reporting requirements.
• Implemented advanced OBIEE features and functionalities, leveraging complex calculations, aggregates, and hierarchies.
• Created and customized reports and dashboards to meet business requirements.
• Migrated OBIEE catalogue across OBIEE environments.
• Monitored data quality metrics, reports and addressed data quality issues.
• Provided day-to-day operational support for Informatica environments.