SUMMARY

• Overall 5+ years of professional IT experience in developing and designing Business Intelligence solutions utilizing Power BI and SQL Server.
• Extensive experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop
• Experience in Power BI to design Interactive Reports using Power Query, Power Pivot and Power View.
• Experience in relational database design, SQL queries like Joins, stored procedures, views, Variables.
• Experience in Creating, Maintaining & scheduling various reports in Power BI like Tabular Reports .
• Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI and SSAS
• Experience in Publishing Power BI reports from Power BI desktop to Power BI service.
• Created different visualization in Power BI according to the requirements.
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX), power query and power Pivot.
• Published reports to Azure - based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).
• Excellent hands-on experience in groups, hierarchies, and measures, KPIs.
• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data splitting.
• Expertise in DAX queries to get and better way to analyzing the data.
• Complete understanding in all facets of Software Development Life Cycle (SDLC).
• Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Temporary Tables, Constraints and Indexes using various DDL and DML commands.
• Skilled in creating and developing BI Dashboards into rich look for better understanding.
• Experienced to generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file, and CSV files to the data warehouse.
• Good logical, analytical, interpersonal skills and commitment to perform quality work as well as an excellent team player.
• Expert in creating different visualizations using Slicers, Lines, Pies, Maps, Scatter, Bullets, Tree maps, etc. using Power BI.
• Connecting to data sources, importing data and transforming data for Business Intelligence.
• Extensively worked with clients to understand business requirements, recommended technical solutions and documented functional requirements.
• Implement functionality of existing systems Ability to work in-groups as well as independently with minimal supervision.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Having the ability to work closely with the team to ensure the timely delivery of business requirements.

TECHNICAL SKILLS

Reporting BI Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, SSRS, SSIS

Databases: MS SQL Server 2016/2018, Oracle9i/10g/11g, MySQL, MS Access

Web Technologies: HTML, Java Script

Operating Systems: Windows 2012/2016/2018 R2, UNIX.

Scripting Languages: SQL, PL/SQL, T-SQL, VB Script

Other Tools: MS Access, MS-Excel

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, Pennsylvania

Power BI Developer

Responsibilities:

• Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
• Worked on all type of transformations those are available in power bi query editor.
• Wrote DAX expressions to create new measures, calculations per business requirements.
• Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
• Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
• Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.
• Hands-on expertise in SQL reporting, development, analytics, or BI.
• Created Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Wrote complex SQL queries in database Access and created various joins (inner, outer joins) to fetch the desired output for Data Analysis.
• Used various sources to pull data into Power BI such as SQL Server, excel, cloud, SQL Azure, etc.
• Created Power BI Visualizations and Dashboards as per the requirements
• Wrote DAX Expressions, Power Query, Functions in Power BI.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map, kpi etc. in Power BI.
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.
• Strong experience on connecting various Data Sources in Power BI.
• Created various data modeling in Power BI and linking the tables using various dimensions.
• Developed and maintained multiple Power BI dashboards/reports and content packs.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Creating, maintaining the users, roles and granting privileges.

Environment: Power BI Desktop, Power BI Service, Power BI Data Gateway, DAX, T-SQL, SQL Profiler, MS Excel, Windows 10, MS SQL Server 2018, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure, Windows 2012/2018 R2 Server.

Confidential, Ashburn, VA

Power BI Developer

Responsibilities:

• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Developed and deployed reports for the internal users in Power BI Report Server.
• Implemented DAX Time-intelligence functions SAME PERIOD LAST YEAR, PREVIOUS YEAR, PREVIOUS QUARTER to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.
• Worked on both live and import data to Power BI for creating reports.
• Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
• Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
• Published Power BI reports from Power BI desktop to Power BI service.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Good knowledge of data warehouse and ETL (Extraction, Transformation, and Loading) concepts
• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes
• Implement functionality of existing systems Ability to work in-groups as well as independently with minimal supervision.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.

Environment: Power BI Desktop & Service, DAX, T-SQL, Microsoft Visual Studio 2017, DAX STUDIO, MS Excel., MS SQL Server 2018, SQL Server Integration Services 2018 (SSIS), SQL Server Analysis Services 2018 (SSAS Tabular), SQL Server Reporting Services (SSRS), Windows 2018 R2 server.

Confidential, New York

Power BI Developer

Responsibilities:

• Worked closely with Business Analyst, Data Modeler, and all team within the organization to understand business processes.
• Generated context filters and data source filters while handling a large volume of data.
• Hands-on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like a year to date (YTD), Month to date (MTD), same period last year.
• Created Row-level security so based on role, the end-user can view the data.
• Wrote DAX Expressions, Power Query, Functions in power bi.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data publishing a report to Power BI Services.

Environment: Power BI Desktop & Service, DAX, T-SQL, Microsoft Visual Studio 2017, DAX STUDIO, MS Excel., MS SQL Server 2018, SQL Server Integration Services 2018 (SSIS), Windows 2018 R2 server.