SUMMARY

• 6+ Years of experience in developing BI applications utilizing SQL server, Azure SQL, SharePoint, Salesforce, MS Excel, SAP BW, SAP HANA, Oracle, R, Python, ServiceNow and other data sources, thereby providing enterprise information and reporting needs within expected delivery dates.
• Work with stakeholders (Directors to C - level), technical project teams to design/develop interactive data visualization, using Power BI, based on business needs.
• Adroit in installing, configuring, upgrading, migrating and troubleshooting SQL Server 2019/2017/2016/2014/2012.
• Dexterity in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Skillful in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors, and Indexes using T-SQL, Azure SQL, Azure storage, ADF, ADL.
• Expertise in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development).

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Power BI Developer/Admin

Responsibilities:

• Design and model datasets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Develop interactive visuals, KPI scoreboards using Power BI Desktop application.
• Adroit in writing complex DAX functions to generate reports based on Daily, Monthly & Yearly data.
• Create rich Power BI visualizations, DAX queries and work with Power Query, M code language for data integration and transformation as per the business requirement.
• Install and configure Power BI Gateways to keep the dashboards and reports refresh automatically.
• Created Workspace and Apps in Power BI service (SaaS) and giving access to end users to Apps.
• Configure Power BI Report Server for SSRS, deployed and scheduled reports in Report Manager.
• Create paginated reports using Power BI Report Builder for on-premises and cloud data sources.
• Adroit in accessing and using PowerApps, Power Automate (MS Flow), and Power BI.
• Experience building Power Automate (Flows), supporting multiple users on Power BI & Power Apps.
• Created Row level security (RLS) and integrated with Power BI service (SaaS) portal.
• Maintained different levels of Data Security in Power BI while granting access to data and assigning Row Level Security (RLS) when needed.
• Configures and maintains Premium capacity planning, updating, troubleshooting, access management and performance management.
• Configured Capacity settings to assign users as Capacity Admins per capacity during initial setup of the capacity and later via User Permissions within the Premium settings.
• Skillful in using Power BI features such as bookmarks, selection pane, drill down drill-throughs.
• Created Power BI Apps using REST API and integrated with Power BI reports & dashboards.
• Configured Tenant settings to give control over the PBI features such as (workspace settings, Export and sharing settings, Publish to web, Developer settings).
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Design and develop Business Intelligence solutions using MSBI tools.
• Skillful in building Business Intelligence solutions on large-scale RDBMS data warehouses.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Developed SSAS Cubes using Star Schema with partitions, aggregations and hierarchies.
• Expert in creating OLAP cubes, dimensions, business critical KPIs, and MDX queries using SSAS.
• Experience as Analysis Services Cube Developer (OLAP) and Report Developer (SSRS).
• Troubleshoot issues with ETL load (SSIS and Stored Procedures) and Cube processing.
• Designed the Data Marts in dimensional data modeling using star and snowflake schemas.
• Write and debug T-SQL Queries, SSRS Reports, SSIS Packages and Stored Procedures.
• Experience with Azure data platform including Azure SQL, Azure Data Factory (ADF), Azure Data Lake (ADF), Azure Databricks, Azure SQL Data Warehouse.

Confidential, Baltimore, MD

Power BI Developer/Admin

Responsibilities:

• Work with multiple teams through all phases (Design, Development, Testing and Deployment) of project life cycle.
• Adept in Power BI Desktop, Power BI service (SaaS), Power BI Gateway & performance optimization.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Created Workspace and Apps in Power BI and giving access to end users to Apps.
• Implemented Data security (Row level security (RLS)) on Dataset and Reports in Power BI.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Dexterity in building reporting dashboards, Data modelling, data pipeline creation and optimization.
• Developed and maintained multiple Power BI dashboards in Power BI mobile and Power BI web.
• Configured Gateway to schedule refresh thereby showing real-time ServiceNow reports.
• Create paginated reports using Power BI Report Builder for both on-premises and cloud data sources.
• Install and configure Power BI Gateways to keep the dashboards and reports refresh automatically.
• Created complex tables and measures using DAX functions such as Time intelligence DAX (TotalMTD, TotalQTD, TotalYTD), Date & Time DAX (day, Month, Year), Filter DAX functions.
• Worked as Power BI Service Administrator.
• As a part of Power BI Administration, configured Usage metrics, Users, Audit logs, Tenant settings, Dashboard settings, Power BI Apps settings, Power BI premium and Premium Capacity settings.
• Adroit in Self-serve analytics and visualizations supporting workflows, dashboards, storyboards.
• Performed subscriptions and refresh extracts in Power BI as well as set up data alerts on business-critical data utilizing Power BI service (SaaS).
• Skillful in Fact/Dimension data warehouse design model, including star and snowflake design methods.
• Involved in code-review sessions on existing SSRS report’s performance and Dataset query tuning.
• Used MDX scripting for querying OLAP cubes.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
• Worked on Tabular Modeling Development and Multidimensional Modelling Development using SSDT.
• Expert in creating OLAP cubes, dimensions, business KPIs, and MDX queries using Analysis Services.
• Adroit in creating Power pivot, Power view and SSRS reports using tabular model (DAX), Cubes (MDX).
• Recreated existing application logic and functionality in the Azure Data Lake, Azure Data Factory, SQL Database and SQL data warehouse environment.
• Used Star Schema in building and designing the logical data model into Dimensional Models.
• Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.
• Expert in creating OLAP cubes, dimensions, business critical KPIs, and MDX queries using SSAS.

Environment: Power BI, DAX, Power query, Excel, ETL, SQL Server 2017/2016/2014, SharePoint, T-SQL.