● Worked along with the IT team and business in designing the architecture for implementing Power BI.● Gathered business requirements, defined and designed the data sources, data flows, and data quality analysis, and worked in conjunction with the data warehouse architect on the development of logical data models.● Created standard Power BI template and Power BI theme to use for creating reports and dashboards going forward.● Worked along with the IT team to set up an On-Premise data gateway so that data can be refreshed daily for reports and dashboard.● Worked along with network and IT team to create connectivity between Power BI cloud and Advantage Insights.● Completed 3 projects related to the Budget, Timesheet, and AR Aging.● Integrated Power BI reports with Advantage App and created widgets within the Advantage Library.● Created reports using pie charts, column charts, scatter charts, slicers, Line Charts, KPI, and Table matrices.● Wrote complex DAX functions in Power BI and PowerPivot.● Implemented Row-level security to limit data to business requirements.● Made use of Aggregate, Conditional Split, Data Conversion, Derived Column, Lookup, Merge, Merge Join, Multicast, Sort, and Union All in different SSIS packages based on requirements.● Creating reports for the Sales team and providing inputs to Mike Huiras (Vise president of Sales) about the sales compared to present with previous YTD and then comparing it with YTD budget.• Implemented process improvement best practices and continuous process improvement initiatives. • Created Power BI visualization of Dashboards & Scorecards (KPI) for AMI Project.• Configured On-Premise data gateway for Oracle and SQL server database.• Created Workspaces, Apps, Alerts, and Using Microsoft Flows created alerts emails for Business and IT.• Analyzed business requirements, created business/process flow charts, database flow charts, and reporting tool database for Research.

• Worked along with business users to gather the reporting requirements.• Successfully migrated old legacy reports in Power BI reports and Dashboards.• Created standard Power BI templates and Power BI themes for the organization to use.• Created Workspaces, and Apps and helped the IT team in setting up an On-Premise data gateway.• Implemented version control practice of Power BI reports.• Implemented process improvement best practices and continuous process improvement initiatives. • Created Power BI visualization of Dashboards & Scorecards (KPI) for AMI Project.• Configured On-Premise data gateway for Oracle and SQL server database.• Created Workspaces, Apps, Alerts, and Using Microsoft Flows created alerts emails for Business and IT.• Analyzed business requirements, created business/process flow charts, database flow charts, and reporting tool database for Research• Created different reports and dashboards using bookmarks, heat maps, scatterplots, bar charts, slicers, drill down, drill through, and various other parameters.• Manage Departmental Reporting systems, troubleshooting daily issues in Power BI.• Designed and implemented multiple dashboards using Power BI - PowerPivot & Power Query tools for in-house metrics.• Responsible for creating and changing the data visualizations in Power BI reports and Dashboards on client requests.• Deployed Dashboards, Reports, and Data Sources in the Power BI Service• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.• Involved in the Unit testing, Quality Assurance Testing, and User Approval testing of Power BI reports and modifying the code accordingly to match user's business requirements.• Integrated custom visuals based on business requirements using Power BI desktop.

• Worked along with IT team and business in designing the architecture for implementing Power BI in County.• Gathered business requirements, defined and designed the data sources, data flows, and data quality analysis, and worked in conjunction with the data warehouse architect on the development of logical data models.• Translated the business needs into technical specifications.• Created standard Power BI template and Power BI theme for the county to use for creating reports and dashboards going forward.• Worked along with the IT team to set up an On-Premise data gateway so that data can be refreshed daily for reports and dashboard.• Created Workspaces and Apps for different projects for the County.• Migrated some of the SSRS reports to Power BI.• Demonstrated expertise in designing, developing, and deploying Business Intelligence solutions using SSIS, SSRS, and SSAS.• Proven ability in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and ETL package design.• Experience in SSAS (SQL Server Analysis Services) in SQL 2008 and SQL Server 2017• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2017 Analysis Services.• Creating Measures and Calculated columns using DAX commands.