SUMMARY

• Highly motivated Power BI Developer with5 years of IT experience having multiple skill set and extensive working experience indata warehousing and Business IntelligenceTechnologies with expertise in SQL Server development,MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BIfor building, deploying, managing applications and services through a global network of Microsoft - managed Data Centres’.
• Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.
• Experience in writing complex SQL Queries using stored procedure, common table expressions (CTEs) temporary table to support Power BI.
• Created different Power BI reports utilizing the desktop and the online service and schedule refresh.
• Experience in understanding of Microsoft development suite SSIS and SSAS, as well as familiarity with standard data extract, cleansing, integration, and aggregation techniques and best practices.
• Assist end users with problems installing the Power BI Desktop, installing and configuring the Personal and On-Premises gateway, connecting to data sources and adding the different users.
• Managed relationship between tables in Power BI using star schema.
• Responsible for building reports in Power BI from the Scratch and responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Experienced in both live and import data into Power BI for creating reports.
• Created reports in Power BI preview portal utilizing the SSASTabularvia Analysis connector.
• Proficiency in different visualization in the reports using custom visuals likeBar Charts, Pie Charts, Line Charts, Cards, Slicers,Maps etc. Also, using different transformation inside Power Edit Query into clean-up the data.
• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, Information, Text and Date functions, Table Functions and Time Intelligence Functions.
• Hands on experience in designing and deploying rich graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Power BI.
• Generated context filters and data source filters while managing large volume of data using Power BI.
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters in Power BI.
• Worked withtable and matrix visuals, worked with different level of filters likereport level, visual level filters, page level filters.
• Assisted customers in configuring and troubleshooting their Row-level security for their company.
• Created custom KPI scorecards to help end users visualize metrics according to their preference.
• Extensively used RDBMS like Oracle and SQL Server for developing different applications.
• Effective communication skills and proven ability to perform both as an individual and as a team player.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop, Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

Cloud Technologies: Azure and Power BI service.

ETL Tools: SQL Server Integration Services (SSIS).

Databases: MS SQL server 2014/16, Azure SQL DB

Operating System: Windows, UNIX

Languages: C, C++, SQL, PL/SQL, T-SQL

OLAP Tools: Tableau, Power BI SSAS, SSRS, DAX Studio

Others: TOAD, Oracle SQL developer, MS Office, FTP, Control-M, SQL Assistant, Rally, JIRA, GitHub, JSON

PROFESSIONAL EXPERIENCE

Confidential, NY

Power BI Developer

Responsibilities:

• Build Reports in Power BI from scratch.
• Developed various solution driven views and dashboards by developing different chart types includingPie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.
• Created dashboard forTransportation system financial informationwhich includesrevenue and expenditure by routes.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business usingPower BI.
• Used various sources to pull data intoPower BIsuch as SQL Server, oracle.
• Involved in installation ofPower BI Report Server.
• Developed reports to visually explore data and create an interactive reportExcel and Power BI.
• Using a query editor inPower BIperformed certain operations like fetching data from different files.
• Createdgroups, content packs.
• Created the KPI to show the difference between actual and forecast data.
• Working with import and direct query, creating custom table in thePower BI.
• Merge queries and append queries, remove columns and split columns, choosing required columns in the data.
• By usingPower BI desktopconnected to various data sources, working with different visualizations.
• Developed and published reports and dashboards usingPower BIand written effectiveDAXformulas and expressions.
• UtilizedPower QueryinPower BItoPivot and Un-pivotthe data model for data cleansing and data massaging.
• Created severaluser rolesandgroupsto the end - user and providedrow level securityto them.
• CreatedPower BI Reportsusing the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Designed different types of KPI's for percentage growth in different fields and compared over a period and designed aggregations and pre-calculations in SSAS.
• Involved in designing partitions in cubes to improve performance using SSAS.
• CreatedTabular modelreports to slice and dice huge volumes of data.
• UsingTabular modelprovided more security to data atRow level.
• Superior involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud usingPower BI desktop.
• Creating reports from importing, direct query and live data from several data sources.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.
• Experience in combining data from different sources by using ofpower query.
• Experience with power pivot and dashboard designer.
• Troubleshoot and support reports inPower BI workspaceswhenever there are issues in production.

Environment: MS SQL Server 2016/2014, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Migration Assistant (SSMA), Oracle, SQL Profiler, T-SQL, Power Bi Desktop, Power Bi pro, Visual Studio 2017.

Confidential, Chicago, IL

Power BI Developer

Responsibilities:

• Developed Dashboard Visualizations, cross tables, Bar charts, Waterfall, Tree map and complex reports which involves custom Controls and Custom Expressions using bars, lines and pies, maps, scatter plots, Gantts, bubbles, histograms, bullets, heat maps and highlight table.
• Developed custom calculated measures using DAX inPower BI to satisfy business needs.
• Creating Gateways for data intake and scheduled refresh.
• Used SQL Server Management Studio to execute SQL queries for data analysis and debugging
• Deployed and scheduled the reports in the Power BIService.
• Participated in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Created workspace and content packs for business users to view the reports. created new OLAP data mart for more concise data and more efficient report performance.
• Worked on both live and import data to Power BIfor creating reports.
• Transformed complex business logic into Database design and maintaining it by using SQLobjects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Created KPI, Partitions, Perspectives, and Calculated Measures, used DAX queries in Power BI.
• Created tables, matrix, and chart reports as required and deploy those reports into Power BI Service.
• Created Parameterized Report, Dashboard Report and Sub Report by Year, Quarter, Month, and Week.
• Created report and page level filter in Power BIdesktop to visualize data according to requirement for different analysis.
• Created new hierarchies and managed relationships (active and inactive) in Power BI data models.

Environment: Power BI, Microsoft Dynamics CRM, SQL Server 2016, SQL Server Management Studio (SSMS), Visual Studio 2015, T-SQL, Excel, DAX.

Confidential, Dallas, TX

Power BI Developer

Responsibilities:

• Collaborated with the project team to outline project requirements in JRD meetings.
• Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.
• Developed data reconciliation SQL queries to validate the overall data migration.
• Formulated DAX Expressions create Date to yearly columns and implemented partitions in Tabular Models for Power BI.
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Created DAX expressions to create new measures, calculations per business requirements.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Analyzed the data using Statistical features in Power BI to develop trend analysis.
• Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
• Successfully integrated custom visuals based on business requirements in Power BI desktop.
• Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Created complicated reports such as parameter-based reports, graphical reports, excel reports, drill-down chart and tabular reports using Power BI.
• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, and Bullets using Power BI.
• Administrated and scheduled data-driven mailing subscriptions on power BI online services.
• Delivered reports with subscription functions in Power BI online services.
• Generated and scheduled on-demand reports for business analyses and management decisions with Power BI.

Environment: Power BI, Microsoft Dynamics CRM, SQL Server 2016, SQL Server Management Studio (SSMS), Visual Studio 2015, T-SQL, Excel, DAX, T-SQL, SQL Profiler, Visual Studio (2014), Power Bi Desktop, Team Foundation Server (2012), MS Analysis Services 2005, MS Access, Import & Export Data, Oracle.