SUMMARY

• 15+ years of experience in Report Development / Business Analytics / Support, Project Management.
• Used various sources to pull data into Power BI such as Azure SQL, SQL Server, Excel, Oracle, Flat Files etc.
• Created/maintained gateways and Live Connectors for both Connect live and Import options within Azure Analysis Services.
• Connected and Used SSAS multidimensional models in Power BI Desktop, Used Measure Groups in a multidimensional cube. Used Calculated measures without an associated measure group under a special table called Measures in the tabular metadata.
• Developed and maintained multiple Power BI dashboards, Visualizations / reports and content packs as per the requirements.
• Experienced in building Power BI Dashboards using Tabular and Multi - Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Involved in Publishing and Pinning various types of Power BI reports to Dashboards in Power BI service.
• Power BI Administration / Security: managed workspaces, enabled and disabled Power BI features, monitored usage and performance of Reports within Workspaces, Review and managed report auditing, implemented Row Level Security
• Expertise experience in design, development and implementation of BI Solutions (ETL & Reporting & Analysis services) using SSIS, SSRS, Microsoft SQL Server Management Studio 2016/ 2012/ 2008 R2/ 2008, T-SQL, PowerView, PowerQuery, PowerPivot, PowerCharts, PowerMaps and DAX.
• Expertise in writing complex SQL queries (Nested & Sub), Query Optimization, T-SQL, Joins, Indexes, Partitioning, Views, Normalization, Stored Procedure, Functions, Error Handling, Trigger, cursors, Derived Tables, CTEs and Temporary tables.
• Extensive Knowledge on creating Dashboards by using Reports and KPI's.
• Skilled in visualizing, manipulating and analyzing large datasets and also has ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel (Pivot Table, Hlook UP, Vlook Up, CountIf, etc.) and also experienced with Tableau, MS SQL Server.
• Created simple and complex reports by customizing look and feel by using various report models and pass the parameters according to business user's request.
• As per requirements developed the reports in the form of Table, Matrix and Chart using SQL Server Reporting Services.
• Having knowledge in creating cube and modifying measures and attributes, creating hierarchies and relationships in dimensions.
• Experience in creating Power Pivot data models. Also, developed, implemented and supported tableau dashboards.
• Worked on adhoc reports and dashboards. Also, worked in creating different Visualizations in Power BI and Power Pivot using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps, Table reports, Bubbles, Histograms, Bullets Charts.
• Robust Excel skills with Power Pivot, PivotTable, Pivot Chart, Power View, VLookup functions and formulas.
• Experience in deploying created reports in various sources like Web browser, XML, and PDF.
• Proficient in working with Senior executives and multiple stakeholders to understand key data issues and identifying their resolution.
• Experienced in managing, monitoring and investigating cases such as trouble tickets from customers and fixing the issues.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Experience in working with Agile and Sprint methodologies.

TECHNICAL SKILLS

Databases: Hadoop, Azure SQL, MS SQL Server 2016/2014/2012/2008 R2/2008/2005, Access, Share Point and Oracle10g.

Database Tools: SQL Server Management Studio (SSMS), SQL Server Analysis Services (SSAS), SQL Alerts and SQL Mail, SQL Server Integration Services (SSIS), Visual Studio, Query Analyzer, SQL Profiler.

Data Analysis Tools: SQL Server Management Studio (SSMS), Power Query, Power Pivot, Power View and Power Maps, Ad hoc Analysis

Reporting Tools: Power BI, SQL Server Reporting Services (SSRS), Excel

Data Modeling Tool: Power Bi Data Models, Microsoft Visio

Project Management Tool: Azure DevOps, Jira

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Power BI Developer

Responsibilities:

• Imported data into Power BI Desktop and model data using the Power Query language inside of Power BI.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Configured and Maintained Power BI Service (app.powerbi.com) to share content with the business users.
• Published reports and dashboards to Power BI service and maintain the refresh schedules and flow of data into the related data sets.
• Utilized Power BI to design dashboards to display information required by different departments and upper level management.
• Created custom calculated measures using Power BI DAX language to meet the business needs.
• Provided continued maintenance and development of bugs fixes for the existing and new Power BI reports.
• Experience in Power BI service administrator activities such as creating and managing security groups, assigning user permissions, monitoring usage metrics for dashboards.
• Designed power BI data visualization using cross tabs, maps, scatters plots, pie, bar and density charts.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power BI query editor.
• Weekly presentation to the business users about the reports and their changes as required.
• Responsible in meeting different user groups to understand what dashboards need to be built.
• Provided production support on the existing Power BI dashboards.
• Involved in developing the ETL mappings in T-SQL via packages, procedures and views.
• Responsible for communicating with the data warehousing team to ensure the data on server is updated and accurate based on the most recent data received from the client.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.

Environment: Power BI, MS SQL Server 2016, Azure SQL, SQL, Hadoop.

Confidential

Power BI Developer / Analyst

Responsibilities:

• Imported data into Power BI Desktop and model data using the Power Query language inside of Power BI.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Configured and Maintained Power BI Service (app.powerbi.com) to share content with the business users.
• Published reports and dashboards to Power BI service and maintain the refresh schedules and flow of data into the related data sets.
• Utilized Power BI to design dashboards to display information required by different departments and upper level management.
• Shared Power BI reports on SharePoint portal and managed access of reports and data for individual users using Roles.
• Created custom calculated measures using Power BI DAX language to meet the business needs.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps.
• Provided continued maintenance and development of bugs fixes for the existing and new Power BI reports.
• Experience in Power BI service administrator activities such as creating and managing security groups, assigning user permissions, monitoring usage metrics for dashboards.
• Automated various Power BI related jobs using Power Shell activities.
• Designed power BI data visualization using cross tabs, maps, scatters plots, pie, bar and density charts.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques.
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
• Worked on all types of transformations that are available in Power BI query editor.
• Weekly presentation to the business users about the reports and their changes as required.
• Responsible in meeting different user groups to understand what dashboards need to be built.
• Provided production support on the existing Power BI dashboards.
• Involved in developing the ETL mappings in T-SQL via packages, procedures and views.
• Responsible for communicating with the data warehousing team to ensure the data on server is updated and accurate based on the most recent data received from the client.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.

Environment: Power BI, MS SQL Server 2016, SSDT, C#, SSIS, Visual studio 2016, SSRS, DTS, T-SQL, Azure.