Power Bi Data

Yadav Oli

Phone: 469-***-****

Email: adyodt@r.postjobfree.com

Summary:

* ***** ** ********** ********** Business Intelligence solutions by focusing on analysis, design, development and implementation of data warehouses, data marts using Power BI, Tableau, SSIS, SSRS with Oracle, MS SQL Server.

Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.

Expertise in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI and Tableau.

Experience in configuration and maintain Report Manager and Report Server for SSRS, deployed and scheduled the reports in Report Manager.

Expert in creating and developing Power BI Dashboards into rich look and tested Power BI reports of Database and verified it with the source data.

Proficient in creating Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries.

Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, Information, Text and Date functions.

Skilled in designing and deploying rich graphic visualizations with Drill Down and Dropdown menu option and Parameterized dashboards using Tableau.

Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, using Power BI.

Experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using SQL Server Integration Services (SSIS).

Expert in Microsoft Excel advance capabilities like Data, Power Query, Tables & Formatting, Conditional Formatting, Pivot Tables & Pivot Reporting.

Familiarity with OLTP/OLAP System Study, E-R modeling, Star and Snowflake Schema in relational, dimensional, & multidimensional modeling.

Generated context filters and data source filters while handling large volume of data using Power BI and Tableau.

Well versed in query optimization for performance tuning and monitoring of processes.

Technical Skills:

Reporting Tools Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server

ETL Tools SQL Server Integration Services (SSIS).

Databases Oracle, MS SQL Server,

Operating System Windows,

Languages SQL, PL/SQL, T-SQL

Others Oracle SQL developer, MS Office, Teradata SQL Assistant, Rally, JIRA, GitHub,

Working Experience:

Client: S&P Global, New York, NY Feb 2022 - Present

Power BI Developer

Responsibilities:

Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.

Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript.

Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.

Specialized in transforming data into user-friendly visualization to give business users a complete view of their business using Power BI.

Used various sources to pull data into Power BI such as SQL Server, oracle.

Involved in installation of Power BI Report Server.

Developed reports to visually explore data and create an interactive report Excel and Power BI.

Developed a QlikView and Qlik Sense training document. Built Qlik Sense prototype dashboards that heavily utilized API extensions (i.e., HTML, CSS, and JavaScript).

Won 3rd place in Qlik Data Blitz for Qlik Sense dashboard.

Using a query editor in Power BI performed certain operations like fetching data from different file.

Created groups, content packs.

Created the KPI to show the difference between actual and forecast data.

Working with import and direct query, creating custom table in the Power BI.

By using Power BI desktop connected to various data sources, working with different visualizations.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging

Created several user roles and groups to the end - user and provided row level security to them.

Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.

Worked on importing custom visualizations.

Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters.

Used various data visualizations with Power BI.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Designed different types of KPI's for percentage growth in different fields and compared over the period of time and designed aggregations and pre-calculations in SSAS.

Involved in designing partitions in cubes to improve performance using SSAS.

Created Tabular model reports to slice and dice huge volumes of data.

Using Tabular model provided more security to data at Row level.

MDX programming, DAX expressions, analysis and business forecasts.

Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.

Creating reports from importing, direct query and live data from several data sources.

Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Client: Republic Services, AZ Feb 2021 – Jan 2022

BI Engineer

Responsibilities:

Gathered business user requirements, analyzed data, and designed software solutions in Power BI Desktop based on the requirements.

Involved in understanding complex data structures and data models to formulate efficient read-write data strategy.

Involved in analyzing data, developing, testing and deploying to production after the user approvals and report design documentation.

Participated in the configuration of on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards.

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.

Wrote DAX expressions to create new measures, calculations per business requirements.

Performed data validation, data profiling, data auditing and data cleansing activities to ensure high quality report deliveries·

Coordinated with ETL team on data transformations using SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Used Power BI Gateways to keep the dashboards and reports up to date.

Embedded reports in Confluence page so users within the organization can consume reports.

Created Workspaces in Power BI Service and created RLS for many reports to maintain Manager Level and other roles visibility in Confluence pages.

Generated and scheduled on-demand reports for business analyses and management decisions with SSRS.

Performed detailed data investigation and analysis of known data quality issues in related databases through SQL.

Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.

Created effective Test Cases and performed Unit and Integration Testing to ensure the successful UAT.

Prepared user training documented for smooth transaction to support team.

Client: Northwest Mutual, Milwaukee, WI Aug 2019 – Dec 2020

Power BI Developer

Responsibilities:

Coordinated with business user at various levels and call meetings during the different phase of projects to deliver successfully.

Participated in the user requirement gathering and design meetings.

Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.

Used Power Pivot to create powerful data model & created Power View for dynamic reports.

Utilized DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.

Used Z-Order to overlap the reports on each other using Power BI.

Developed complex reports in Actuate, in different phases of implementation, integrated these reports with True Information.

Developed complicated business reports using crosstabs, Drill Downs, sub reports and customized conditional formatting.

Read data from multiple data source through Power BI for creating Dashboards & Reports.

Implemented context filters and data source filters for handling large volume of data.

Created multiple data model with Power BI and used as a common data source for generating multiple reports.

Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.

Wrote SQL queries to extract & manipulate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Published Power BI Reports in the required originations and made Power BI Dashboards available in web Clients.

Created Row level security so based on role, the end user can view the data.

Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart and Pie charts.

Imported data from different sources like csv, excel and direct query to SSAS.

Checking the code into TFS for the deployment process for the production environment.

Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.

Client: Florida Blue, Jacksonville, FL Aug 2018 – Jun 2019

Power BI Developer

Responsibilities:

Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.

Co-ordinated with ETL team to create and manipulate source and target data mappings, ETL mapping transformations.

Filtered unwanted data from legacy system using complex T-SQL statements and implemented various types of Constraints and Triggers for Data Consistency.

Used Dynamic-SQL, Joins, Functions and Correlated Sub-Queries to simplify complex queries involving multiple tables.

Created views to facilitate easy user interface implementation, and triggers to enforce data and referential integrity.

Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Created visually compelling and actionable interactive reports and dashboards in Tableau and worked on performance tuning of Tableau.

Used Power Pivot to create powerful data model & created Power View for dynamic reports.

Involved in data validation by writing several complex SQL queries on Teradata SQL Assistant and Involved in back-end testing.

Created individual Worksheets and incorporated it into Dashboards with appropriate filters.

Scheduled timer to refresh data for the data sources are published or extracted to server.

Involved in Data migration, data cleansing & writing retro to fix the existing effected data.

Perform Project documentation. Utilized Visual studio and TFS for development and manage project tasks.

Involved in Import/Export of data from one server to other servers using tools like Data Transformation Services and bulk copy.

Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Education:

MBA In Business and Marketing, Lovely Professional University of India,2013-2015

Bachelor’s in business studies, Tribhuvan University, 2011

Contact this candidate