Power BI Resume Samples

ADAMS KING

EMail-Id: [email protected]
Contact No: 9854658210
Address: Chennai

CAREER OBJECTIVE:

• Having 5+ years of IT experience as Microsoft SQL Server developer implementing SSIS and SSRS using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT) and Power BI.
• Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.
• Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
• Experience inRequirement Analysis, Design and Development of Web applications using ASP.NET, VB.NET.
• Expertise in enhancing and deploying the SSIS Packages from development server to production server
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
• Hands on experience in Performance Tuning, Query Optimization
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,

EDUCATIONAL QUALIFICATIONS:

SKILLS:

• MS SQL Server (3 years)
• Azure SQL DB

PROFESSIONAL EXPERIENCE:

1) Power BI Developer

Company Name-Location – February 2017 to Present

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.
• Undergone Intellipaat’s Power BI certification training.

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.

2) SQL BI Developer

Company Name-Location – June 2013 to May 2014

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.
• Creating Database objects – tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.

Environment: MS SQL Server 2012, Power BI, ETL, T-SQL, Visual Studio 2010, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools

ADDITIONAL INFORMATION:

• Databases MS SQL Server, Azure SQL DB
• Operating Systems Windows 7 & 10
• Languages T SQL, SQL, C#
• Business
• Intelligence Tools
• SQL Server Integration Services (SSIS),
• Azure Data Factory (ADF),
• SQL Server Analysis Services (SSAS),
• Power BI Desktop

Power BI Resume Samples 2

CAREER OBJECTIVES

Power BI Expert with 1.5+ years of rich experience in creating compelling reports and dashboard using advanced DAX. Looking to work with an esteemed organization that gives me an opportunity to utilize my existing analytical skills and help make better business decisions.

EDUCATION

SKILLS

• SSAS, Power bi
• sql server
• DAX, Sas

WORK EXPERIENCE

1.) Power BI (Credit Cards Analytics)

Project summary:

• Developing compelling and interactive analysis reports and dashboards for Credit Card Marketing analytics using advanced DAX.
• Integrated custom visuals based on business requirement using power BI desktop.
• Converting all operational excel report into Power BI Reports.

Key deliverable:

• 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.

2.) SAS (Documentary Trade analytics)

Key deliverable:

• Extensive use of Base SAS techniques to generating reports.
• Analysis of data to determine default rate, economic maturity, conversion rate, defaulted transaction-level economic loss rate.
• Generating reports using PROC REPORT and PROC TEBULATE to compare and compute with previous data.
• Populated a lot of ad-hoc stuff on daily basis which cover all parts of trade reporting system.
• Creating Management Information report on weekly and daily basis to compare results with last years and thus creating graphs.
• Having good knowledge of SAS Merging, Handling missing values, Reading raw data files, creating data structures, Handling programming errors, Accessing and Merging data, Appending, Concatenating, and
• Interleaving of SAS datasets.
• Implementing logic involved behind data loading, client reporting, and data manipulations using SAS programming language and SQL queries

ADDITIONAL INFORMATION

• Operating Systems Windows 7 & 10
• Data/business/analysis
• Advanced DAX
• SAS base programming
• Power BI, SAS Studio, Excel, T-SQL, SSAS Tabular.
• Languages T SQL, SQL, C#

DECLARATION

I hereby declare that all the information given above are true to the best of my knowledge and belief.