Employment History 

• SQL / Power BI Developer

  Colaberry Inc

  July 2018 - Present

  • Design, develop, test, and deploy robust Power BI dashboards across various business domains ensuring seamless integration with SharePoint and ServiceNow in alignment with industry standard best practices and methods.
  
  • Publish reports via the Power BI service, while managing distribution through apps, monitoring usage, data refreshes, sharing, dataset endorsement, and row level security access.
  • Manage IVM vending machine data, optimizing the data flow and analysis processes.
  
  • Involved throughout the full data lifecycle from various sources to target data warehouse and BI Data visualization interfaces for user consumption, sharing, and collaboration.
  
  • Develop data visualizations and Key Performance Indicators (KPIs) using various DAX functions, ensuring quality reporting for the business.
  • Developed and maintained Power Automate flows for automated data workflows, enhancing productivity and efficiency.
  • Utilize Rest API and Web API for efficient data extraction and integration.
  
  • Leverage a strong understanding of Power BI DAX, along with proficiency in troubleshooting and handling complex calculations, measures, calculated columns, and tables.
  
  • Regularly utilize Microsoft Suite tools such as SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI.
  
  • Create and enhance Stored Procedures, Functions (UDF), Indexes, Tables, Views, and other T-SQL code.
  
  • Build data transformation and automations via Azure Data Factory, Power Automate and Azure Logic Apps.
  
  • Employ cloud storage Azure Data Lake Storage & AWS S3 for data ETL.
  
  • Participate in various projects developing BI reports for customers across various industries, including Finance, Retail, Manufacturing, Insurance, and Sales.
  • Conduct analytical studies on service desk operations, focusing on KPIs and data-driven decision-making.