Power Bi Business Intelligence

Summary

Around *+ years of total professional experience as Business Intelligence Developer/Cognos in various industrial domains like Insurance, Health Care, Finance and electricity and experince in report design, developemnt of visualization, Dashboard, Performing Data Analysis and management in business intelligence/Data warehousing with excellent communication skills and striving for work to get done timely in qualitative manner.

Experience in developing BI Applications utilizing SQL Server, BI Stack, Power BI and Tableau.

Expert in Database Design, Data modeling, Development, Implementation, ETL,Teradata and Reporting in SQL Server.

Expertise in Power BI, Power BI query,Power BI Pro, Power BI Mobile.

Experience in Cognos BI tools using Cognos Framework Manager, Report studio, Query studio and Analysis studio.

Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.

Experience in maintenance and support activities, performance monitoring and tuning upgrading BI versions, software configuration and disaster recovery planning as well as Capacity planning.

Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.

Developed and integrated Power BI reports into enterprise applications using Power BI Embedded.

Designed and deployed Power BI Embedded solutions for customer-facing analytics.

Enabled seamless analytics within business applications by embedding Power BI dashboards.

Worked on Power BI embedded and make enable users with interactive data visualization with out requiring them to access power bi separately

Experienced in generating data reports using Stored Procedures, data migration, SSIS packages, cubes.

Hands-on experience in SQL, writing complex queries, performing tuning and query optimization.

Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.

Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

Created new cubes and modified existing cubes using SSAS 2008 to make data available.

Worked on producation incidents, Acess request and change request tickets which comes from service now.

Assigning Power Bl Pro licenses to the users, configuring role base security by creating different roles in Azure Analysis services and providing access to app workspaces and apps.

Created role level security restricts data access for users based on their roles

dev

Created Grouping, sorting columns and writing expressions according to the business requirements.

Transferred the data using SSIS packages.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.

Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.

Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.

Responsible for creating SQL datasets for Power BI, OBIEE, SSRS ad-hoc Reports. Worked with SQL Server 2008R 2/2014/2016.

Extensive experience in implementing Microsoft Bl/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks,

Azure SQL Database, Azure Data Lake, Azure Data Factory

Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau.

Gather requirements from the business user; document it to develop Power Bi Paginated Reports reports.

Created Calculated Columns and Measures using DAX Functions to incorporate logics in the Power BI data sets.

Used DAX functions in Power BI, Excel Power Pivot, and SQL

Star and Snowflake schema data analysis, modeling and architecture

Designed user defined hierarchies in SSAS including parent-child hierarchy.

Defined specific read/process permissions for the users in SSAS instance.

Automated Power Query refresh using power shell script and windows task scheduler.

Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .

Good experience with Datawarehouse concepts, Star Schema, Snow Flake Schema

Experience with Water Fall and Agile Methodologies.

Experience working in the Functional Domains of Pharmaceuticals, Finance, Human Resource, Sales and Marketing.

Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, CSV files, Oracle and deployed custom reports using SQL Server Reporting Services (SSRS)

Built ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.

Good understanding of RDBMS concepts and experienced in writing queries etc using Oracle, MS SQL Server, Teradata and IBM DB2 UDB.

Developed PL/SQL database stored procedures, packages and triggers to handle complicated business logic for Warehouse Product Database Administration.

Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Strong data analysis skills taking pride in making data-driven decisions while defining and building the necessary tools to gather, track and measure key business data points..

Technical Expertise:

Languages

Python, PL/SQL, TSQL, Visual Basic and HTML

Business Intelligence

Power BI development,Data visualization,Data modeling,DAX,SQL server,SSIS,SSRS,

Database

MS SQL Server 2012/2008, Oracle 10g/9i/8i, MYSQL, IBM DB2 7.1/8.0 and MongoDB

Reporting Tools

SSRS 2012/2008, Crystal Reports XI/X/9/8, Power BI, Excel, Qlikview,Teradata and Tableau

Web Technologies

HTML, XML, JavaScript, Angular JS, PHP, Shell Scripting, jQuery

Methodologies

Agile, waterfall and Scrum.

DataTools

Erwin 4.0

Web/Application Servers

Web Logic Server, Apache and Unix

Cloud Environments

Azure, AWS,Google Cloud and Data Bricks

Education:

Masters in Information Technology- Trine University

Professional Experience:

Client: AEP (American Electric Power), Columbus, OH Sept 23– August 25

Sr. Power BI Developer / SQL Developer

Responsibilities:

Worked with business users on requirements gathering, provided project delivery estimates and Implemented requirements based on timelines.

Resposobie for creatinf dashboards,reports and content packs.

Responsible for migrating folders or mappings and sessions from development server to test environment.

Worked on Power BI Paginated Reports using Report Builder.

Worked extensively on Data visualization and Data analysis using Power BI.

Designed and Developed Dashboard Reports in Power BI using DAX, creating effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map, etc.

Developed and maintained multiple Power BI dashboards/reports and content packs.

Developed Power BI Dashboards using Tabular and Multi-Dimensional Models, leveraging Power Query for data extraction from external sources.

Build in writing complex DAX functions in Power BI and Power Pivot.

Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in Tabular Mode & multi-dimensional Cubes.

Worked in Azure Data Factory, creating data factories, implementing data migration, and scheduling automatic refresh in Power BI.

Created Data Factories in Azure Data Factory for ETL processes, using SSIS for data validation, extraction, transformation, and loading.

Collaborated with cross-functional teams for efficient report and dashboard development.

Utilized Azure DevOps for Application Lifecycle Management.

Involved in creating data visualizations like Bar charts, Tree Maps, Line charts, Scatter plot, Mapping Visualization etc. with Power BI

Load data into azure synapse analytics by using azure data factory

Ingesting transforming and transferring data into azure data lake, azure synapse

Implemented massive transformation and scheduling on Azure Data Bricks for advanced data analytics and provided data to downstream applications.

Involved in developing complex Azure Analysis Services tabular databases and deploying the same in Microsoft azure are scheduling the cube through Azure Automation Runbook.

Worked on data pre-processing and cleaning the data to perform feature engineering and performed data imputation techniques for the missing values in the dataset using Python.

Used Python and Django creating graphics, XML processing, data exchange and business logic implementation

Accessed used various Custom Visuals available in Power BI

Sharing of Power BI reports and managing workspaces in Power BI service.

Designing the modeling in Power BI.

Involved in Configuring and Upgrading the On Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.

Involved in developing reports and dashboards in Power BI.

Environment: Power BI Desktop,Powe Query,Power BI Mobile,Power Automate, Powe BI Embedding,DAX, Data modeling, Data Bricks,Visualization SQL, T-SQL, PL/SQL, Teradata, Oracle,Azure, Azure Storage, Azure Data Factory, PowerShell.

Client: ACC (American Campus Communities), Austin, TX July 22– Aug 23

Sr.Power BI Developer

Responsibilities:

Worked with Business Analysts and gathered requirements for different clients and prepared the technical documents.

Created Power BI Visualizations and Dashboards as per the requirements.

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.

Created PL/SQL packages for implementing Change Requests for adding new functionality to the application

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.

Extensively used Toad to develop Oracle PL/SQL Packages.

Performed SQL and PL/SQL tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE

Used various sources to pull data into Power BI such as SQL Server, excel, cloud, SQL Azure, etc.

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.

Designed, developed reports and Dashboard Reports in Power BI Desktop and published to Power BI Web and working Power BI Pro.

Installation of Power BI desktop, version upgradation and patches installation in client computers

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

Client: CNO IT Services, Hyderabad Oct 20 – June22

Role: SQL BI Developer

Responsibilities

Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.

Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.

Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.

Developed free-form reports using reports using MS-SSRS tool for consulting multiple reports into single report delivered in .pdf format to the power users.

Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.

Worked on SSIS (DTS, DTSX) packages for Data Integration Services. Used SSIS to produce a Data Mart for reporting.

Understanding the PL/SQL code for issues in the database and advice the development team with logs

Extensively used System variables and created User-Defined variables for SSIS packages.

Implemented SSIS data, created maintenance procedures and provided data integrity strategies.

Developed custom reports and developed them on server using SQL Server Reporting Services (SSRS). Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.

Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.

Created reports using stored procedure and experience in building reports on Analysis Services cubes (SSAS).

Worked with Report Builder 2.0, Report Models and Ad Hoc reports and worked with Tableau desktop, Tableau server and Tableau reader in various versions of Tableau.

Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: BI toolsSQL Server, Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS. SSAS, OLAP, XML, SharePoint, Agile, Visual Studio 2010, .Net Framework 3.5, Window 8

Contact this candidate