Power Bi Data Warehousing

RAVI KISHORE TALLA

********************@*****.*** +1-314-***-****

TECHNICAL SNAPSHOT

Involved in developing Functional Requirement document and Detail Design Document preparation, design and Development, Coding and Unit Testing, And Involved in all levels of reviews in design and development phase and implementation.

Responsible for the development of User Interface and implementing the business logic for a module.

Extensive experience in Microsoft Power BI Desktop & Service, Power BI Paginated Reports, MicroStrategy and Tableau.

Extensive experience on visualizations like Column Chart, Stacked Chart, Pie Chart, Slicers, Donut Charts, Row Cards, Multi Row Card, Line Chart.

Broad experience on Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using the functionality.

Expertise in creating dashboards and reports in Tableau and maintaining user and server activities.

Extensively used data blending, embedded functionalities in Tableau and defined best practices for Tableau report development and effectively used data blending feature in tableau.

Solid experience on DAX Expression for creating the Calculated Columns for better Business Decision and worked on M language.

Extensively used Custom Visuals from Power BI Custom Visuals Blog to meet the requirements.

Experienced in developing Power BI reports and dashboards from multiple data sources using data blending.

Created, maintained & scheduled various reports in Power BI Desktop (Power query, Power pivot, Power view), Paginated Reports.

Created Power BI Gateways for data refresh to Source files or Source Databases.

Implemented Data security (Row level security (RLS)).

Created Rich visualized Pie & Line Charts, Tree Map.

Created Interactive Dashboards using selectors, Widgets and Graphs in MicroStrategy.

Design of public objects such as (Metrics, Prompts, Filters, Consolidation) and Schema Objects in MicroStrategy.

Creating Reports using Intelligent Cubes in MicroStrategy.

Experience in DBMS/RDBMS, Data warehousing and SDLC and Data warehousing (Star, Snowflake, Galaxy schema).

Extensive knowledge of data warehouse methodologies.

Developed POC's and implemented.

Strong experience in migrating reports from Tableau to Microsoft Power BI.

Strong experience in migrating reports from OBIEE to Microsoft Power BI.

Strong experience in migrating reports from SAP Business Objects to MicroStragegy.

Optimizing report performance and data retrieval.

Strong ability to understand new concepts and applications.

Performed unit testing and report testing.

Strong knowledge on writing SQL code to compare and validate the data across various systems.

Enhancing solution by eliminating bugs and errors from the Product Setups.

Worked on ERP technologies like Salesforce. To embed Power BI in salesforce environment.

Used Git Hub to create, store, change, merge, and collaborate on files and code.

Worked in Implementation life cycles of both Agile and Waterfall Methodologies.

Well experienced with Agile/Scrum Methodologies.

Performing postproduction Support as a technical for fulfilling Customer and user requirements.

Worked with users and team members at all levels for performance improvement and suggestions.

Worked collaboratively with development teams to manage and perform analytics across the application metadata universe.

Expertise handling support requests from other developers and support teams.

Handling change request and Implementing New Enhancements and customizing the product as per the requirement of Client and ensuring the solution delivery on time.

Analyze and discuss the adaptations (client requirement) prepared by the functional team. Clarifications and conclusions follow.

Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.

WORK HISTORY

Sr. Power BI Developer Tractor Supply Company 11/2024 - Current

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.

Verified business requirements and functional specifications.

Designing the Report as per TDD.

Migrated reports from Tableau to Microsoft Power BI.

Created data marts and multi-dimensional models like Star schema and Snowflake schema.

Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for HR Data and history loads.

Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.

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.

Developed and published reports and dashboards using Power BI and written effective DAX expressions.

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.

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

Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, date & time column.

Worked in scheduling refresh of Power BI reports, hourly and on-demand.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Worked on Quarter over Quarter (QoQ) and Year over Year (YoY).

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

Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Power BI, Tableau and Snowflake.

Principal Software Engineer Fidelity Investments 10/2023 - 02/2024

Designing the Report/ Document as per TDD

Extensively involved in design and building the Reports, and Dashboards as per the business requirements

Migrated reports from Tibco to Power BI Paginated Report Builder

Created Power BI Paginated Reports by using SQL stored procedures.

Designed customized data collection models for specific visualization tasks.

Worked on Star and snowflake schema.

Created Power BI Visualizations and Dashboards as per the requirements.

Developed and deployed interactive dashboards and reports using Power BI.

Collaborate with business stakeholders to understand data requirements and deliver actionable insights.

Optimized Power BI reports and dashboards for performance and efficiency.

Troubleshoot issues related to Power BI reports and data models, ensuring data accuracy and reliability.

Managed and maintained Power BI Gateway servers, ensuring secure and reliable data connectivity.

Configured and maintained connections for two Power BI Gateway servers to various data sources.

Monitor and troubleshoot gateway performance and connectivity issues.

Created data visualizations to present insights and tell compelling stories.

Weekly presentation to the business users about the reports and their changes as required.

Experienced in Writing Data Analysis Expressions (DAX).

Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.

Created reports using time intelligence calculations and functions using DAX.

Integrated Power BI with other applications and services through API-based solutions.

Responsible for improving and adhering to documentation and development standards.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

Validating records from source to target using SQL.

Used Git Hub to create, store, change, merge code.

Environment: Power BI Paginated Report Builder, Jasper Tibco, Git Hub, T-SQL

Senior Power BI Developer Coca-Cola 04/2022 - 09/2023

Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Participated in gathering Business Requirements and System Specifications

Strong business requirement analysis using agile methodologies.

Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.

Designing, extracting, and developing ETL workflows and datasets in Alteryx to let the BI reporting tool make use of it.

Designed customized data collection models for specific visualization tasks

Developed dashboard in inventory levels, vendor management

Develop, design, and maintain advanced Power BI reports and dashboards specific to supply chain metrics.

Created Power BI Visualizations and Dashboards as per the requirements.

Created data visualizations to present insights and tell compelling stories.

Weekly presentation to the business users about the reports and their changes as required.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily

Integrated AWS to Power BI environment.

By using AWS S3 bucket to connect data to Power BI.

Validating records from source to target using SQL.

Involved in daily Status calls with Off-shore and On-Shore

Prepared Daily Status Report and Weekly Status Report.

Trained and mentored junior developers and engineers, teaching skills in Power BI and working to improve overall team performance

Environment: Power BI, Alteryx, AWS RDS Database, T-SQL

Senior BI Developer Starr Health 02/2021 - 04/2022

Gathered Business Requirements from stakeholders, interacted with the Users, Project Manager, and IT teams to get a better understanding of the project goals

Performed gap analysis of the data and reviewing the requirements

By using Alteryx, performed a wide range of data operations such as data cleansing, data transformation, data blending, data modeling, predictive analytics.

Regenerated OBIEE reports and dashboards in Power BI.

Rebuild the Power BI data model based on the OBIEE RPD.

Worked with Dashboards style of reports using all the Power BI components.

Coordinated deployments of new software, feature updates and fixes.

Created proofs of concept for innovative new solutions.

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

Used Bookmarks and RLS as per requirements.

Developed User interactive Reports using bookmarks, filters as business needs.

Rapidly prototyped new data processing capabilities to confirm integration feasibility into existing systems.

Estimated work hours and tracked progress using Scrum methodology.

Published reports into Power BI publisher and schedule the data sets.

Involved in daily Status calls with Off-shore and On-Shore.

Prepared Daily Status Report and Weekly Status Report

Trained and mentored junior developers and engineers, teaching skills in Power BI and working to improve overall team performance.

Environment: Power BI, OBIEE, Alteryx, MySQL, Azure.

Senior Consultant HCM 04/2019 - 08/2020

Understanding source systems and customer requirements

Charts are used in making reports more user-friendly in analysis purposes.

Developed User interactive Reports as business needs.

Used various sources to pull data into Tableau such as Amazon Redshift DB, oracle.

Analyzing the Client Requirements and preparing the Dashboard.

Involved in reviewing requirements and data sources from SQL Server and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Used Tableau for blending databases and creating different interactive views and dashboards.

Defined relationships, created actions, filters, parameters, data blending, hierarchies, calculated fields, sorting, groupings, live connections in tableau.

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Created various types of charts to provide better visualization.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets.

Involved in daily Status calls with Off-shore and On-Shore.

Prepared Daily Status Report and Weekly Status Report.

Environment: Tableau, Oracle, Amazon Redshift DB

Sr. Software Engineer Gordon Food Service 08/2017 - 06/2018

Involved in reviewing requirements and data sources from Excel for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently

Developed User interactive Reports as business needs

Work closely with Supply Chain stakeholders to identify KPI's for visualization

Developed dashboard in inventory levels, vendor management

Develop, design, and maintain advanced Power BI reports and dashboards specific to supply chain metrics

Coordinated and worked with onshore Clients, in gathering the Dashboard requirements

Analyzing the Client Requirements and preparing the Dashboard

Worked on developing Dashboard using MAD methodology (Monitor, Analysis and Design)

Used Tableau for blending databases and creating different interactive views and dashboards

Worked with project managers, developers, quality assurance and customers to resolve technical issues

Partnered with development team on product development and application support plans

Performing Unit Testing and preparing unit test results document and providing support to QA & UAT environments and post production support

Prepared Daily Status Report and Weekly Status Report

Environment: Tableau, Power BI, SQL Server, Oracle

Sr. Software Engineer Citibank 08/2016 - 06/2017

Designing the Report/ Document as per TDD

Extensively involved in design and building the Reports, and Dashboards as per the business requirement.

Migrated reports from SAP Business Objects to MicroStrategy.

Design of public objects such as (Metrics, Prompts, Filters, Consolidation) in MicroStrategy.

Creating Reports using Intelligent Cubes

Collaborated with clients to define solution requirements

Delivered unit-tested systems within customer-prescribed timeframes

Involved in daily Status calls with Off-shore and On-Shore

Prepared Daily Status Report and Weekly Status Report

Environment: MicroStrategy, SQL Server

Software Engineer Emirates Airlines 01/2016 - 04/2016

Company Overview: Dubai, United Arab Emirates

Understanding Business requirements and document the test scenarios

Worked with project managers, developers, quality assurance and customers to resolve technical issues

Design of public objects such as (Metrics, Prompts, Filters, Consolidation) in MicroStrategy

Created Interactive Dashboards using selectors, Widgets and Graphs

Extensively involved in design and building the Reports, and Dashboards as per the business requirements

Creating Reports with OLAP services (Derived metrics, Dynamic aggregation and View filter)

Involved in daily Status calls with Off-shore and On-Shore

Dubai, United Arab Emirates

Environment: MicroStrategy, SQL Server

Software Engineer MobileTec 05/2012 - 01/2016

Understanding Business requirements and document the test scenarios

Design of public objects such as (Metrics, Prompts, Filters, Consolidation)

Created Interactive Dashboards using selectors, Widgets and Graphs

Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance

Involving in GUI, Functional and Regression testing

Involved in writing test cases for the requirements

Performed functional, Integration and UA testing

Reporting bugs and responsible for bug fixes

Providing Test Data's to test the functionalities

Prepared Daily Status Report and Weekly Status Report

Environment: MicroStrategy, SQL Server, Oracle

CERTIFICATIONS

CPD - Certified Project Designer

CRD - Certified Report Developer

CDMD - Certified Dashboard and Mobile Developer

MCA - MicroStrategy Certified Analyst

MCD - MicroStrategy Certified Designer

Analyzing and Visualizing Data with Microsoft Power BI

SKILLS

Microsoft Power BI

Power BI Report Builder

MicroStrategy

Tableau

OBIEE

AWS

Azure

Snowflake

Oracle

MySQL

#HRJ#81e82930-eca4-4e3b-8d21-1cc2439ae94a#

Contact this candidate