Experienced and passionate Certified Business Intelligence/Power BI Developer with a proven track record. Proficient in utilizing the Microsoft Power Platform, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Microsoft 365. Possesses excellent communication skills, demonstrates a proactive and self-managing work approach, and excels in collaborative team environments. Goal-oriented and highly motivated, with exceptional analytical, troubleshooting, and problem-solving capabilities.
In the constantly evolving world of gaming, the battle for dominance rages on as titles compete for ... ... More
SQL / Power BI Developer
July 2018 - Present
• Designing, developing, testing, and deploying Power BI dashboards across various business domains, adhering to industry-standard tools, methods, and requirements.
• Publishing reports via the Power BI service, managing distribution through apps, and monitoring usage, data refreshes, Sharing, dataset endorsement, and Row level security access.
• Working on full data lifecycle from different sources to target data warehouse and BI Data visualization interfaces for user consumption, sharing, and collaboration.
• Developing data visualizations and Key Performance Indicators (KPIs) using various DAX functions, ensuring quality reports.
• Demonstrating a strong understanding of Power BI DAX, proficient in troubleshooting and handling complex calculations, measures, calculated columns, and tables.
• Utilizing Microsoft Suite tools such as SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI.
• Creating and optimizing Stored Procedures, Functions (UDF), Indexes, Tables, Views, and other T-SQL code.
• Building data transformation and process automations through Azure Data Factory, Power Automate and Azure Logic Apps
• Utilize Cloud storage: Azure Data Lake Storage & AWS S3 for data ETL.
• Working on different projects developing BI reports for customers on different industries, like Finance, Mortgage Banking, Retail, manufacturing, insurance, and Sales.
• Employing indexing strategies and query optimization techniques to optimize stored procedures and resolve performance issues in long-running queries.
• Developing and maintaining SSIS packages to extract data from multiple sources (Excel, XML, OLTP) and load into staging.
• Applying SSIS transformations, including data conversion, derived columns, and conditional splits, for data cleansing.
• Implementing star schema design principles in data warehouse creation, ensuring measurable financial data in the fact table and detailed data in dimension tables.