Employment History 

• SQL / Power BI Developer

  Colaberry Inc

  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.