Experience

Outlook Amusements

• United States
• Technology, Information and Internet
• 100 - 200 Employee

• Senior Business Intelligence Developer

  • Feb 2019 - Present

   Developed Power BI reports for various departments across the company and provided them with key insights on how the company was performing on a daily, monthly and yearly basis.  Designed, developed, and internally tested complex T-SQL scripts via the use of views, functions and stored procedures to implement the business needs and to support and validate front end applications and Power BI and SSRS reports.  Converted over 100 legacy SSRS and Excel reports into Power BI and was able to successfully provide greater insight through the ability to make the report more interactive to the end user.  Worked with aggregating raw data to build counts and summaries which were then presented via Power BI reports  Worked heavily with Excel to build reports via the use of various functions, pivot tables and visualizations.  Implemented DAX queries and functions to generate reports based on Daily, Monthly and Yearly data  Installed and configured Power BI gateways to keep dashboards and reports refreshing automatically  Created workspaces and Apps in Power BI service and gave access to end users  Integrated custom visuals based on business requirements using Power BI desktop  Developed complex calculated measures using Data Analysis Expression language (DAX)  Provided continued maintenance and development of bug fixes for the existing and new Power BI reports  Created Row level security (RLS) and integrated with Power BI service portal  Designed ETL SSIS packages for data migrations, alerting notifications for various processes and developing automation processes for efficiency purposes. Show less