Highly skilled Power Platform Developer with five years of experience leading numerous end-to-end data migration projects to Power BI. Adept at working with diverse data sources, including Oracle, SQL, Snowflake, Azure, Databricks, Synapse, Excel. I stand out in overcoming challenges with unstructured data to deliver precise, insightful, and interactive business intelligence solutions. My technical expertise allows me to conceptualize, design, and implement advanced analytical solutions tailored to the unique needs of various industries. Committed to meticulous oversight of analytics, I craft custom reports and dashboards that drive profit growth and operational efficiency. With exceptional verbal and written communication skills and strong problem-solving abilities, I am equipped to excel in any professional setting and ensure optimal use of business intelligence tools across teams.
- Spearheaded the development and migration of a comprehensive toolbox for the Merchandising team from Microsoft Access to Power BI, significantly enhancing data accessibility and analytical capabilities.
- Reverse engineered complex Merchandising Reports originally built in legacy systems into dynamic and interactive Power BI reports, enabling more efficient and insightful data analysis.
- Addressed and rectified severe data quality issues by developing robust data cleaning and transformation solutions, which were adopted by the entire team to ensure consistent implementation and accuracy.
- Compiled detailed data dictionaries for all tables and fields utilized in Power BI reports, providing clear and comprehensive documentation that facilitated easier understanding and maintenance of the reports.
- Created a Power App integrated with one of the Power BI reports to enable end users to perform efficient item lookups, greatly improving user experience and operational efficiency.
- Ensured that the newly developed Power BI reports and dashboards are utilized nationwide for the Exchange, supporting critical decision-making processes across the organization.
- Delivered continuous support and implemented strategic enhancements to Power BI reports, ensuring they remained up-to-date, relevant, and aligned with evolving business needs and user requirements.
-Create, analyze, and distribute reports for clients by utilizing multiple data sets from various data sources (SQL server, Snowflake, Excel) to provide valuable and interactive insights.
-Design and develop innovative and valuable visualizations to identify trends, patterns, and exceptions that enable senior leaders to make data-driven decisions.
-Collaborate with business partners to gather requirements for new Power BI projects.
-Generate insightful BI-based reports to monitor and highlight contributing factors to financial and operational variances and anomalies that help executives make informed decisions.
-Liaise with end-users and staff to provide support on BI dashboards and other Business Intelligence needs.
-Enhanced end-user experience and satisfaction by providing support on BI dashboards and other Business Intelligence needs, resulting in improved user adoption and increased productivity.
-Provided customized Power BI training to end-users, enabling them to effectively utilize the tool for data analysis and reporting.
-Successfully migrated 67 Legacy reports from Excel to Microsoft Power BI, streamlining data reporting processes and improving accuracy.
-Designed and delivered Power BI dashboards for Income Statement and Balance Sheet, providing senior leaders and business teams with quick and efficient access to key sales information.
-Developed and implemented business logic to data sources and created a semantic layer for Power BI, ensuring data consistency and accuracy.
-Created Bookmarks for Corporate Income Statement, Category Level, and Balance Sheet, improving user experience and enabling quick navigation to key information.
-Installed and configured data gateway to ensure dashboards and reports remained up-to-date with on-premise data sources, ensuring optimal performance and data accuracy.
-Successfully assisted in migration of 4 departments from Excel and Cognos to Microsoft Power BI, resulting in streamlined and optimized data reporting processes, leading to increased productivity and efficiency.
-Developed and implemented effective migration and development strategies, ensuring efficient use of resources and timely delivery of projects, resulting in completion of projects within the expected time frame and budget.
-Created comprehensive documentation for data models, measures, calculated columns, reports, and source data, ensuring consistency and accuracy of information, which helped in the smooth and efficient functioning of the reporting processes.
-Created Workspaces in Power BI service and published 24 reports in workspaces, improving accessibility and sharing of information among team members, leading to better collaboration and communication within the organization.
-Assigned row-level security for Dataset in Power BI Desktop, ensuring data security and confidentiality, which helped maintain data integrity and confidentiality.
-Data Visualization (Reports, charts, maps, filtering, setting properties, custom visualization)
-DAX Language
-SQL Query
-SQL Server
-Snowflake
-Azure
-Data Bricks
-Knowledge of SAP
-Excel
-Providing Power BI Training
-Requirement Gathering
DAX Certification: SQLBI.com
DAX Certification: SQLBI.com