Uma Parvathaneni

adgqa5@r.postjobfree.com

+1-757-***-****

Power BI Developer

Professional Summary

Around 5 years of IT experience as Business Intelligence Developer using Microsoft Power BI, Tableau and SSRS, SSIS and SSAS in various domains like Insurance, Retail and Manufacture as MS Power BI developer.

Involved in all the phases of SDLC including Requirements collection, Design and Analysis, Development and Customization of the application with Waterfall and Agile SCRUM methodologies.

Expertise in Microsoft Power BI, Structured Query Language (SQL), Tableau and SQL Server Reporting service (SSRS) with good knowledge on SQL Server Integration service (SSIS) and SAL Server Analysis Services (SSAS).

Developed complex reports and dashboards and supported the existing reports using Power BI based on the end-user requirements.

Design, develop and implement reporting and dashboard solutions using Power BI, Tableau.

Experience implementing and supporting Self-service BI tools such as Microsoft Power BI and Excel (PowerPivot, PowerQuery, and PowerView).

Experience in creating reports using SQL Server Reporting service (SSRS) and creating various types of reports like drill down, drill through, Parameterized, Table, Matrix, chart and sub reports.

Hands on experience in Tableau Desktop, Tableau Server, Tableau Public and Tableau Reader in various versions of Tableau.

Experience in Dimensional Data Modeling using Star and Snowflake Schema, also have vast experience in slowly changing Dimensions and Meta data management.

A high level of proficiency in Data Analysis Expressions (DAX) with demonstrable capabilities in this area.

Knowledge on Paginated reports (Report Builder) and Power APPS.

Worked on different data sources like Azure Analysis service (AAS), SAP BW, SQL Server, Azure SQL Databases, SQL Server Analysis Services (SSAS), SharePoint, and Excel.

Hands on experience on writing SQL queries and understanding of relational database concepts.

Created interactive reports using different visualizations like table, matrix, line, Line and stacked column, slicers, clustered column charts tiles in Power BI.

Experience in installing Power BI Desktop and configuring gateways in Power BI Service.

Experience in implementing Row-Level Security in Power BI. Additionally, good knowledge on Power BI licensing and admin portal.

Well versed in calculated columns, tables, and measure query’s in Power BI desktop.

Good knowledge on all types of transformations available in Power BI query editor and DAX functions.

Worked on PowerApps to create web applications in phones and tablets by using controllers like charts etc.

Experience in creating various reports like table, matrix, drill down, drill through, parameterized, cascaded, linked and sub-reports.

Knowledge and Hands on experience on scripting languages like Python and Power Shell.

Hands on experience on SQL Server Analysis (SSAS) and Azure Analysis Service (AAS) to create reports based on Live connection in Power BI.

Experience including analysis, modeling, design, and development of Tableau reports.

Experienced on Tableau activities, Multidimensional database and writing SQL queries.

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

Defined best practices for Tableau report development and effectively used data blending feature in tableau

Conducted Knowledge Sharing Sessions and ensured that the meetings are more productive and focused this became a vertical wide practice for conducting meetings.

Experience working in Agile.

Technical Summary

ETL Tools : Microsoft SQL Server Integrated Services

Data Visualization Tools : Power BI, Tableau, SSRS

Database : SQL, Oracle, DB2, Teradata, T-SQL

Database GUI : Teradata, SQL Server, SQL Developer, DB2

Methodologies : Waterfall, Agile

Programming Languages : SQL, Python, R, PL/SQL, HTML, Core Java

IDE’s : Eclipse, jGrasp, PyCharm, Dream weaver, Rational Rose

Framework : Hadoop, Django, Flask

Software Packages : Microsoft Visio

Operating Systems : Windows and Mac

Educational Qualification:

Master’s in Computer Science from University of West Florida, USA.

oWorked as a lab Tutor for programming languages like Core Java, SQL, Database and HTML

oWorked as a Graduated Assistant for computer applications like Excel, PowerPoint, Word.

Bachelor’s in Computer Science from JNTUK, India.

Professional Experience:

Client: Align Technologies Jan 2020 – Present

Job Title: MS Power BI Developer

San Jose, CA

Project scope: Align Technologies is a global medical device company that is changing lives through better Smiles. The BI team involves in creating reports for Finance department.

Responsibilities:

Responsible for designing, developing, and maintaining reports as per the business requirements.

Responsible for Importing data from different data sources like SAP BW, Azure Analysis Service, SharePoint, and Excel and modelling it into Power BI Desktop.

Hands on experience with different data import modes in Power BI like Import, Live connection, and Direct Query.

Creating interactive reports by using different visualizations like table, matrix, line, Line and stacked column, Slicers, clustered column charts in Power BI Desktop.

Created calculated measures and calculated columns in Power BI desktop to show good analysis techniques.

Worked on all types of transformation that are available in Power Query Editor based on requirement.

Worked on Finance Insights report to show how revenue is fluctuating Month over Month, Quarter over Quarter and Year over Year and their Percentages using DAX Time intelligence functions like Previous month, Previous Quarter, sameperiodlastyear etc.

Connected tabular model from Azure analysis service using live connection and created interactive reports on top of that based on business requirement.

Experience on creating different levels of filters like visual level, page level, report level filters.

Hands-on experience with Bookmarks, Sync Slicers, Tooltips, Actions & Interactions in Power BI.

Experience with composite models, Data Modelling and Power Query editor like appending queries, splitting data into separate columns, adding columns, Advance editor, creating groups etc.

Performing unit testing on created reports to get desired output from the data.

Worked on improving the report performance tuning and involved in troubleshooting, resolving and escalating data related issues and validate data to improve data quality.

Responsible for publishing reports into required Workspaces in Power BI service.

Created workspaces for different environments and share it with Business users and Team Members.

Responsible for gathering requirement from Business Users.

I used PowerApps to create web applications in phone and tablet layouts

Worked on Controls like gallery, charts etc. and implemented various data driven applications, published, and shared across the team.

I have created simple model driven apps to automate processes.

Knowledge on PowerApps and Power Automate/Flow.

Trained team members on Power BI and Worked on development of Knowledge transfer documentation.

Environment: Power BI Desktop, Power BI Service, SAP BW, Analysis Service, PowerApps, Share Point, Excel, DAX, Window 10

Client: P & G July 2019 – Dec 2019

Job Title: Power BI Developer

Cincinnati, Ohio

Project scope: P&G is an American multinational consumer good cooperation. Its manufacturer different kinds of products which are used in our daily life. The IDM team involves in creating different kinds of reports for different BU’s like fabric care, Feminine Care, Hair Care, baby care and shave care

Responsibilities:

Involved in requirement gathering, Technical design, development, Testing and implementation of BI Analytics and reports.

Responsible for designing, developing and maintaining reports as per the business requirements.

Install and upgrade latest versions of Microsoft Power BI Desktop.

Importing data from different data sources like Azure SQL Database, SQL Server, SharePoint & Excel by using import option.

Converting Manual reports into Automated ones.

Creating interactive reports by using different visualizations like bar, pie, card, table, matrix, line charts in Power BI Desktop.

Created calculated measures and calculated columns using DAX Queries to fulfill client perspectives, executing DAX queries based on requirement of data.

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

Wrote T-SQL queries to get the data into Power BI from Azure SQL Databases.

Experience on creating different levels of filters like visual level, page level, report level filters.

Hands-on experience with Bookmarks, Sync Slicers, Tooltips, Actions & Interactions in Power BI.

Hands on experience on composite models, Data Modelling and Power Query editor.

Created different types of workspaces in Power BI Service for different Business Units and Published reports into it and assign different levels of roles to colleagues and business users.

Worked with static and dynamic level Row level securities in Power BI

Scheduled refresh for the datasets using on-premises gateway.

Knowledge on Paginated reports.

Customize dynamic 365 applications using PowerApps and complex automations.

Develop, deploy, and support Power Platform solutions using Powerapps

Designed and developer various kinds of reports using MS SQL and DAX functions in Power BI.

Hands on experience with Power Query editor like appending queries, splitting data into separate columns, adding columns, Advance editor, creating groups etc.

Experience on creating sample bar chart and line chart using python visual.

Validation of data between client application and SQL DB.

Performing unit testing on created reports to get desired output from the data.

Worked with different custom visuals like, word cloud, star rating, Advanced card etc.

Environment: Power BI Desktop, Power BI Service, SQL Server, Azure SQL DB, SharePoint, Excel, DAX, python, T-SQL, Window 10

Client: AIG April 2016 – June 2019

Job Title: Power BI/SSRS Developer

Charlotte, NC

Project scope: AIG is an American multinational finance and insurance corporation with operations. The BI team involves in creating different kinds of reports for General and Life Insurance departments.

Responsibilities:

Responsible for designing, developing and maintaining reports as per the business requirements.

Installing and upgrading latest versions of Power BI Desktop.

Imported data from different data sources by using import & direct query options.

Creating interactive reports by using different visualizations like bar, pie, card, table, matrix, line charts in Power BI Desktop.

Created calculated measures and calculated columns using DAX Queries to fulfill client perspectives, executing DAX queries based on requirement of data.

Retrieve data from snowflake using direct query option in Power BI.

Worked on different levels of filters like visual level, page level, report level filters.

Hands-on experience with Bookmarks, Sync Slicers, Tooltips, Actions, Interactions.

Hand-on experience on creating Row Level Securities in Power BI.

Created drill through pages as per user requirements.

Publishing Power BI reports into Power BI service and sharing with colleagues and business users.

Responsible for scheduling data based on different timeslots like daily, weekly, monthly and monitoring the reports based on scheduled time.

Export reports to PDF format and Power BI Templates.

Re-created QlikView dashboards into Power BI for General Insurance Application

Worked with the database like IBM Netezza and DB2.

Involved in designing of data modelling using Star and Snow Flake schemas.

Restricted the region level data by using Row Level Securities in Power BI.

Import custom visuals like advanced card, chiclet slicer from market place.

Used conditional formatting options for coloring in power BI.

Excellent skills in developing SSRS reports with functionality such as drill down, drill through, and parameters.

Create reports with different data sources using SSRS.

Used various report items like tables, sub reports and charts to develop the reports in SSRS.

Environment: Power BI Desktop, Power BI Service, SSRS, Snowflake, DAX, QlikView, DB2, IBM Netezza, Excel, Rally, Window 7

Academic Projects:

Team Projects:

Developed 15 puzzle game using 8 different AI methods with Java technology.

Implemented a comparison-based capstone research project for Naïve Bayes algorithm on Hadoop, Hive and SQL using time function, with a team of three

lead a team of five on Database project “Hospital Management” that gives the information about patients, bills, medical department, lab reports, canteen, Management.

Developed “Performance Analysis of RSA Text Encryption and Decryption using CPU and CUDA” project, with a teammate, for Advanced System & Networks to encrypt and decrypt a message by using RSA in both CUDA and CPU.

Lead a team of four on Network Security project “Modeling and Detection of Camouflaging worm” to provide security to the internet users using C-Worm.

Individual Project:

Implemented different data mining techniques on bigdata to clean unwanted data and combine multiple files of data and extract the patterns.

Performed Analysis (SSAS), Integration (SSIS) and Reporting (SSRS) services on Spam Detection in Data warehouse Project.

Additional Skills:

Certified in “Database System” from University of West Florida.

Contact this candidate