Power Bi Business Intelligence

Venkata Padmaja Peddikuppa

Power BI Consultant

Contact Info : +1-951-***-**** *****.*******@*****.*** Work Authorization : GC

PROFESSIONAL SUMMARY:

Over 14+ years of experience in development, implementation and maintenance of software applications using Power BI,SAP BW/BI, SAP Bo Xcelsius, Siebel Analytics, OBIEE Tools which includes Data-Modeling, Data Extraction, Data Loading, Scheduling, Monitoring, Reporting, Performance Tuning and scheduling using process chains and Generating Real time dashboards Building Repository, Creating Reports, Charts and providing Business Intelligence through Power BI Dashboards and Reports in SDLC and Agile environment.

Over 8+ years of experience in Information Technology in System analysis, design, development, Implementation, and maintenance of Data Warehouse project, providing Business Intelligence through Power BI Dashboards and Reports.

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

Experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text, and date functions.

Experienced in Supporting end-user reporting using Power BI.

Good understanding of the Data modeling (Dimensional & Relational) concepts like Star Schema Modeling, Snowflake Schema Modeling

Experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS. Experience in testing and writing SQL statements.

Able to creatively stretch the capability of Power BI to customize and develop creatively stunning and dynamic visualization using Power BI.

Good hands-on experience in Power BI Enterprise gateway, Power BI cloud publish/ sharing.

Leveraged DAX in Power BI to compute data and create new columns and measures.

Developed visual reports, interactive dashboards on Power BI Desktop and Service

Expert UI Designer in creating visualizations as Bar, Line, Pie, Donut Charts, Map, Matrix, Table, Card, KPI, slicer, filters, interactions, tooltips, conditional formatting.

Experience in Generating reports like Pie-charts, Bar graphs, Drill downs, Drill through etc. Using Power BI.

Utilized Page Level, Report Level and Visual Level Filters, Slicers, Drill down capabilities.

Adhered to UI/UX principles and created Device Specific Dashboards for mobile view.

Managed Power BI Service by creating personal, test and production Workspaces.

Utilized Power BI Service/Gateways to schedule data refreshes on dashboards/reports.

Good understanding of Creating the pipelines and Configuring the Integration runtime in ADF.

Implemented row level security (RLS) to provide report access to specific user groups in the organization with DAX expressions.

EDUCATION :

B. Tech, 2006 from AMIETE

PROJECT EXPERIENCE:

IHG (Hotels & Resorts), Los Angeles, California Sep 2020 to Current

Sr. Power BI Developer

Responsibilities:

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications. Designed, developed, and tested solutions for business user specified requirements to achieve desired business results.

Participated in the daily standup with business teams to resolve the business issues and Data challenges.

Hands-on experience in the design, development of end user applications for the data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using POWER BI.

Experience using formula languages such as Data Analysis Expressions (DAX).

Create reports in Power BI Desktop and Service utilizing the connectors and content pack.

Expertise in creating reports from importing, Direct Query and Live data from several data sources.

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

Provided operational support for SharePoint Online, OneDrive for Business, Power Apps and Power Automate services.

Configure data intake using Query and its formula language, ‘M’.

Created different reports in Power BI Desktop and published them to Power BI online.

Skilled at querying relational databases (SQL) and ability to pull data from various sources.

Developed solutions for SharePoint Online, Power Apps and Power Automate.

Created Power Automate flows to automate business processes for a variety of use cases.

Imported data from different data sources to create Power BI reports and dashboards.

Utilized Power BI (Power View) to create various analytics dashboards that depict critical KPI along with slicers and dicers enabling end -user make filters.

Ensured the quality and timely delivery of all the important complex canned reports and involved in migration and testing of objects to PROD environment from DEV through QA environment using Import Wizard.

Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts, etc.

Working extensively building Power BI Dashboards with quick insights into KPIs and Advance analysis actions, Calculations, Parameters, Maps and Scatter plots, heat maps, setting alerts.

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

Published reports and dashboards using Power BI.

Performed Unit testing to ensure dashboard is working as expected in complex scenarios.

Environment Power BI, Power BI Server, Power BI Desktop, Power Pivot, Power View, Power Map, DAX, ETL, SSIS, SSAS, SSRA, Power Query, KPI, MS Azure, OLAP, OLTP, TFS, SQL Profiler, SQL, SQL Server, Oracle, MS Excel, Windows.

BTIS (Builders & Tradesmen insurance services) Roseville, CA

Mar 2018 to Sep 2020

Power BI Developer

Responsibilities:

Involved in gathering requirements, analysis, and specifications from the clients.

Involved in KT sessions and different Controllers meeting to understand the Business.

Publishing Power BI reports on dashboards in Power BI server.

Modified existing dashboards as per new requirements in Power BI.

Recreated reports from MS Excel to Power BI.

Developed analytics solutions by defining and translating business requirements into dashboard &reporting solutions and implementing them within Microsoft Power BI Desktop and visualizations.

Developed Graphic reports, pie charts for the statistical representation of data. Tested the web intelligence reports in system integration and Testing (SIT) environment and Perform testing (stagging) environment to validate performance of the reports, which helped in Analyzing its performance before moving into Production environment.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Involved in dealing with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting.

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI.

Performed tasks like execute SQL task, data flow task, file system task for ETL process.

Added required measures, calculated columns, keeping unnecessary columns hidden from reporting view in Power BI application.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel.

Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.

Generated Monthly, Yearly, Quarterly, and daily reports in Power BI.

Worked and joining the queries and merging the tables in Power BI.

Load and transform large sets of structured, semi structured, and unstructured data.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Generated periodic reports based on the statistical analysis of the data from various time frames and division using SQL Server Reporting Services (SSRS).

Created KPI, Guage, Clustered column chart, Slicers for better understanding of the report.

Developed reports like Ad-hoc reports, charts, tabular, matrixes, and sub report.

Created and maintained tables, stored procedures, indexes, database check constraints, and business rules using SQL.

Assisted in implementing Azure Data Factory v2 for a major financial institution by ingesting their risks and controlling data into Azure data lake store.

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.

Handling Azure Storage like Blob Storage and File Storage.

Worked on Team Foundation Server (TFS) to check in and check out SSRS reports and SSIS packages.

Developed U-SQL Scripts for schematizing the data in Azure Data Lake Analytics

Ability to create scripts using Azure PowerShell during for automation and build process.

Increased query performance by performing monitoring, tuning, and Optimizing Indexes tasks using SQL Profiler.

Environment: Power BI, Power BI Server, Power BI Desktop, Power Pivot, Power View, Power Map, DAX, ETL, SSIS, SSAS, SSRA, Power Query, KPI, MS Azure, OLAP, OLTP, TFS, SQL Profiler, SQL, SQL Server, Oracle, MS Excel, Windows.

Evolve IP, Wayne, CA Oct 2016 – Mar 2018

Power BI Developer

Responsibilities:

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Validated data by writing SQL queries in source and target database.

Support of database with features like partitioning with PL/SQL calls to collect stats, index maintenance.

Generating and applying surrogate keys in the Power BI Query Editor.

Creating different visualization using Data Visualization Desktop.

Worked on deploying, sharing reports/Dashboards to Microsoft Power BI service.

Built ETL jobs to load data from various source systems like Microsoft Dynamics and Salesforce.

Worked on the entire data lifecycle from data ingestion, preprocessing, analyzing and visualization using tools like Adobe Analytics and Tableau.

Modify Stored Procedures and complex T-SQL Queries to improve query execution process.

Exceptionally deliver stunning interactive reports in your app with the Power BI Embedded service.

Developed Logical and Physical models based on the business requirements. Created ER Diagrams using Visio.

Developing Power BI reports using the Azure SQL Database.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.

Used Microsoft Project Pro for O365 for project related activities.

Regular participation in the analysis, design, build, deployment, and support of Power Apps.

Build a data cube around the existing offer click, impression and revenue statistics from redirectors.

Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.

Performing T-SQL tuning and optimizing queries for reports that take longer execution time.

Prepared the data to cover various scenarios and wrote SQL Query to verify the database updates, inserts and deletion of the records.

Created data flows by joining various data objects in Salesforce.

Identified data sources, open communication channels and negotiate timelines on successfully getting the data from the sources to the Unified Analytics Platform in an Agile environment.

Design and development of Microsoft Power BI visualization solutions like Dashboards, Standard Reports, Scorecards, Drill down reports, Drill through reports, charts and Ad - hoc Reports.

Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.

Created Quality Assurance stats reports using Power BI.

Created source to target mapping STTM document and worked on ETL mapping, session and workflow coding, ETL architecture, and provided data quality analysis to determine cleansing requirements.

SME and chaired technical reviews, analysis and involved in preparation of functional specifications and technical specifications for web services with XML and XSD Mapping of domain objects.

Developed data capture and navigation desktop and mobile apps in Microsoft Power apps that connect to distribution center solutions design analytics in Power BI.

Transform the data from Azure SQL Database by using Data Lake (U-SQL) and stored to Data Lake.

Built Dashboards /Reports/ combine different datasets and publishing using Power BI Desktop tools.

Worked on Visualization, Merge queries and enhancements using Power BI desktop tools.

Worked on deploying, sharing reports/Dashboards to Microsoft Power BI service.

Developed Power BI model used for financial reporting.

Created various SQL and PL/SQL scripts for verification of the required functionalities.

Involved in uploading of the data from flat files into Databases and Validated the Data with PL/SQL procedures.

Environment: MS SQL Server 2016, DAX, SQL, T-SQL, T-SQL Procs, PowerApps, Power Flow, Power BI Desktop & Services, XML, Python, Office 365, SSIS, SQL Query, Agile, JSON, TFS, REST API, and Power BI

Health First - NYC May 2015 - Sep2016

Power BI Developer

Responsibilities:

Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers.

Generated periodic reports based on the statistical analysis of the data from various time frames and division using power pivot, power query, power view.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

Gathering the requirements and writing the ad-hoc SQL query batches to update the data and metadata for delta 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.

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

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI .

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel for better business analysis.

Working experience with in-memory concepts of OLTP databases in SQL SERVER 2014.

Hands on experience working with SSIS, for ETL process ensuring proper implementation of event handlers, loggings, checkpoints, transactions and package configurations.

Designed high level ETL architecture for overall data transfer from the source server to the enterprise services warehouse.

Worked in creating complex stored procedures, SSIS packages, triggers, cursors,tables, and views and other SQL joins and statements for applications.

Generated reports using global variables, expressions and functions.

Configured reporting services in SQL Server 2008.

Created different power pivot reports as per the client requirement.

Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008.

Create Calculate member in MOLAP cube using MDX in SSAS 2008.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI .

Experience in designing, building the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.

Performance tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables,, redesigning schemas and many more.

Converted the existing Azure Data Factory V1 to Azure Data Factory V2 and implemented SSIS package in Azure environment using Integration Runtime (IR).

Done configure diagnostics, monitoring, and analytics on Azure platform along with scale and resilience for Azure websites.

Created calculated measures and dimension members using multi-dimensional expression (MDX).

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

Environment: MS SQL Server 2008R2, T-SQL, SQL Profiler, Visual Studio (2012), Power Bi Desktop, Team Foundation Server (2012), MS Analysis Services 2005, MS Reporting Services, MS Access, Import & Export Data, Oracle Warehouse Builder, Power Bi Desktop, Power Bi pro,

Shell Petroleum, India Jan 2012 to Nov 2013

SAP BW/BI

Project Description: Shell Oil is the United States-based company. Shell is the market leader through approximately 25,000 Shell-branded gas stations in the U.S.

Responsibilities:

Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multiproviders

Set up periodic Data loads from legacy system (flat files)

Involved in extracting the data from External Source system.

Installing and creating BI objects like info objects, DSOs, Info cubes.

Creating and managing dataflow using DTP, transformations and info packages.

Data Source Enhancement according to customer requirement.

Designed and developed queries to generate reports inBEx Analyzer.

Worked extensively on query designer.

Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.

Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BI.

Created ODS, Infocubes, Multi-providers and infosets and extracted SD data (Data sources Like 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit (LBWE) extraction. Extensively worked for Sales Order Review.

Environment: SAP BI 7.0, ECC 6.0, SD, MM,SAP-ABAP

Johnson & Johnson, India Nov 2010 to Dec 2011

SAP BW/BI Consultant

Environment: SAP BI 7.0, ECC 6.0, SD, MM, SAP-ABAP,Java script & HTML

Philips Electronics, India May 2010 to Oct 2010

SAP BW/BI Consultant

Environment: SAP BI 7.0, ECC 6.0, SD, MM, SAP-ABAP

OMC Dashboard, India Dec 2009 to April 2010

BI Developer

Environment: DB2, SAP BOX Celsius, Windows NT

British Telecom, India Jan 2007 to Nov 2009

Siebel Analytics & OBI Developer

Environment: Oracle 8i/10.2, Siebel Analytics & OBIEE, Windows NT

WORK SHOPES /TRAINING PROGRAMS ATTENDED

Carporate training for report generation by using Siebel Analytics.

Technical training in Oracle Business intelligence, SAP BO Xcelsius Tool,SAP BW/BI.

Contact this candidate