We provide IT Staff Augmentation Services!

Power Bi Developer Resume

Greensboro, NC

SUMMARY

  • 8+ years of experience in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.
  • Strong programming experience in TSQL, PL/SQL Development (SQL SERVER 2012) and Report Development (SSIS, SSRS), Performance Analysis, Deployment Script Development, Production Support.
  • 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
  • Expert in working on all phases of Data warehouse from gathering requirements to testing, implementation, and support.
  • Experienced in design and development of SSIS packages to Extract, Transform and Load data from heterogeneous sources (excel, flat files) to data warehouse (OLAP) according to user requirements.
  • Experience in Deploying and Monitoring ETL packages in SQL Server by job scheduling the flow of packages from Development Server to Test and Production Server.
  • Proficient in optimizing SQL queries, performance tuning using SQL Profiler as well as understanding execution plans.
  • Experienced in creating various reports like Tabular, Matrix, Drill down, Drill-through, Parameterized, Cascading, Conditional, Chart, Sub Reports and Deploying Reports in report server.
  • Developed SQL queries for data extraction, analysis and reporting.
  • 1 year of experience in ASP.Net, C#, HTML, CSS, JavaScript, JQuery and Microsoft Dynamics AX 2012 with web technologies.
  • Strong Knowledge in Data Analytics tools such as Power BI, Tableau, QlikView etc.
  • Expert in generating reports using SQL Server Reporting Services (SSRS).
  • Proficient in SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.
  • Worked in all the products in Power BI such as Power BI Pro, Embeded, Premium, Power BI Mobile
  • Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal

TECHNICAL SKILLS

Data Warehousing/BI Tools: SQL Server Business Intelligence Development - SSIS, SSAS, SSRS, DTS, Power BI, Tableau.

RDBMS/DBMS: SQL Server, MS SQL SERVER 2005/08/12, ORACLE 9i/10g, MSAccess.

Database tools: Management Studio, SQL Profiler, Database Tuning Advisor, Query Analyzer, DTS, Performance Monitor, Client Configuration Utility, Server Configuration Utility.

Programming Languages: C#, .net, VBScript

Protocols / Middleware: TCP/IP, HTTP, FTP, UDP/IP, DOM, ODBC

Visualization Tools: Power BI, Tableau, Power Pivot

PROFESSIONAL EXPERIENCE

Confidential, Greensboro, NC

Power BI Developer

Responsibilities:

  • Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
  • Created Dax Queries to generated computed columns in Power BI.
  • Generated computed tables in Power BI by using Dax.
  • Involved in creating new stored procedures and optimizing existing queries and stored procedures.
  • Created Azure Blob Storage for Import/Export data to/from .CSV File.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
  • Explore data in a Variety of ways and across multiple visualizations using Power BI
  • Used Power BI Gateways to keep the dashboards and reports up to date.
  • Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
  • Published reports and dashboards using Power BI.

Environment: MS SQL Server 2016, SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI.

Confidential, Annaplois, MD

Power BI Developer

Responsibilities:

  • Developing compelling and interactive analysis reports and dashboards for Credit Card Marketing analytics using advanced DAX.
  • Itegrated custom visuals based on business requirement using power BI desktop.
  • Converting all operational excel report into Power BI Reports.
  • Design and develop of reporting data module for Credit Card Marketing Analytics.
  • Developed Up-selling and Cross-selling reports using DAX functions.
  • Creating Row level security with power bi and integration with power bi service portal.
  • Developed profit analysis reports and dashboards by products and customers
  • Worked on all types of transformations that are available in Power bi query editor.
  • Scheduled Automatic refresh and scheduling refresh in power bi service.
  • Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
  • Created reports using time intelligence calculations and functions.
  • Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.
  • Executed dashboard setups and data manipulation using DAX.

Environment: MS SQL Server 2016, SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI.

Confidential, Woonsocket, RI

MSBI Developer

Responsibilities:

  • Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.
  • Designed Data Warehouse and analyzed various approaches for maintaining different dimensions and facts.
  • Created and optimized database objects such as views, functions and stored procedures as per requirement.
  • Performed Index analysis for OLTP tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
  • Configured Always ON availability groups in SQL server 2012.
  • Used T-SQL to create tables, views, user-defined functions, CTEs, Index for implementing application functionality at the database side for performance improvement.
  • Modified T-SQL Stored Procedure, Triggers for validating the integrity.
  • Implemented slowly changing dimension transformation to maintain the historical data in data warehouse.
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, Look up, Data Conversion, Merge, Merge Join.
  • Created effective User Defined Function, Stored Procedure, Triggers, Transactions to facilitate data consistency and efficient data manipulation.
  • Developed dynamic SQL queries for reports on Enterprise Data Warehouse (OLAP) and Operational database (OLTP).
  • Created user defined financial reports to provide on demand financial data analysis.
  • Performed complex expressions to group data, filter and parameterize reports deploy into servers.
  • Built Multidimensional Expressions (MDX) queries for Analysis Services & Reporting Services.
  • Integrated SQL Server 2012 reporting services with Microsoft Share Point Portal Server to deliver automatically generated reports to the Share Point portal.

Environment: MS SQL Server 2012/2008R2/2008/2005,SSIS 2008R2, SSRS 2008R2, SSAS 2008R2,Microsoft Access, TFS, Windows 2003 Standard Edition, Windows 2000 Advanced Server, VSS, SQL Diagnostic Manager

Hire Now