Sindhupriya Thumma

ad2fdg@r.postjobfree.com ph:636-***-****

PROFESSIONAL SUMMARY

Over 8 years of working experience in IT industry as BI Developer, Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of projects using Tableau, Oracle, etc. in Health Care, Transportation and Financial industries.

Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS)

Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports developing the all the visualizations which are requested by the business users using Power BI.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

PROFESSIONAL EXPERIENCE

MSA, Pittsburgh, PA April 2022 – Current

Sr. Power BI Developer

Responsibilities:

Develop load scripts for extracting, transforming and loading data into POWER BI applications created complex formulas and calculations within POWERBI to meet the needs of complex business logic.

Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily used different type of slicers available in Power BI for creating reports.

Developing the all the visualizations which are requested by the business users using Power BI managed relationship between tables in Power BI using star schema.

Design and developed the Power BI solution to create reports, visualizations and dashboards as per the business requirements and published enterprise

Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

Utilized SQL to develop new and debug existing Ad-Hoc reports. Migrated Crystal Reports into Web based Ad-Hoc reporting.

Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions.

Worked on Azure Databricks to process and analyze datasets and Data Personas along with SQL Editor and Dashboards.

Abbott Laboratories, Abbott Park, IL Mar 2020 - Mar 2022

Power BI Developer

Responsibilities:

•Develop load scripts for extracting, transforming and loading data into PowerBI applications created complex formulas and calculations within PowerBI to meet the needs of complex business logic during Migration

•While designing the Power Bi reports and dashboards, the measures are created using DAX programming language writing all the calculations using DAX formulas.

•Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily used different type of slicers available in Power BI for creating reports.

•Designed and deployed reports with Drill Down, Drill Through and drop-down menu option and parameterized and Linked reports.

•Worked on all types of transformations & Data Modelings that are available in Power BI query editor utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

•Experience on Azure Boards to work at various stages of a process using cards to represent work items and columns to represent each stage of process.

•Defined parameters for parameterized Reports using SSRS and Power BI scheduled the data refresh for dashboards and reports to show the updated data.

•Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI managed project insights through Azure DevOps to track the list of assignments and provide daily updates on progress.

•Troubleshooted and resolved visualization errors during production support

•Involved in extensive data validation by writing several and complex SQL queries and involved in back-end testing and worked with data quality issues.

•Created Views and Database Triggers, Stored Procedures and Functions using SQL such that information entered by a certain WM can make appropriate changes to the respective tables

•Developing the all the visualizations & Performance Optimization which are requested by the business users using Power BI managed relationship between tables in Power BI using star schema.

•Designed and developed the Power BI solution to create reports, visualizations and dashboards as per the business requirements and published enterprise

Versant Health, Linthicum Heights, MD Sep 2018 – Feb 2020

Tableau/Power BI Developer

Responsibilities:

Responsible for gathering and analyzing the business requirements and then translate them to technical specifications.

Developed various data connections from data source to PowerBI for report and dashboard development migrated SSRS reports to Tableau.

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Involved Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.

Provided Production support to PowerBI users and Wrote Custom SQL to support business requirements.

Developed story telling dashboards in PowerBI Desktop and published them on to PowerBI Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Designed and developed PowerBI reports based on the SSRS reports which are developed using store procedures. Custom SQL is developed to migrate and create same reports on Tableau.

Used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Experience in connecting multiple data sources in Tableau to implement working reports published PowerBI dashboard on PowerBI Server or PowerBI Online and embedded them into portal.

Experience in creating Dashboards Scorecards, views, pivot tables, charts, for further data analysis using Power BI desktop.

Extracted data from different data sources like SQL Server, MySQL and Tableau Server and created queries based on the requirement to provide data visually.

Highmark, Pittsburgh, PA Jul 2017 – Aug 2018

Tableau Developer/ Power BI Developer

Responsibilities:

•Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop to provide better data visualization.

•Develop load scripts for extracting, transforming and loading data into POWER BI applications created complex formulas and calculations within POWERBI to meet the needs of complex business logic.

•Used Custom SQL for joining the tables and selecting the required Data.

•Responsible to create Aggregates, Hierarchies, Charts, Histograms, Filters, Quick filters, Table Calculations, Trend lines and calculates measures and more.

•Developing the all the visualizations which are requested by the business users using Power BI managed relationship between tables in Power BI using star schema.

•Design and developed the Power BI solution to create reports, visualizations and dashboards as per the business requirements and published enterprise

•Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and Logical functions.

SVSAV Technologies, India Aug 2015 - Dec 2016

Data Analyst

Responsibilities:

Developed SSIS packages using various transformations such as Conditional Split, Fuzzy Look Ups, Aggregations, and Multicasting.

Created new Data source and replaced with existed Data source. Created Schedules and Extracted the data into Tableau Data Engine.

Developed various T-SQL queries, Stored Procedures for data retrieval, maintenance and testing.

Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.

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

Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

EDUCATION

B. TECH (CSE) 2015, JNTU HYDERABAD.

TECHNICAL SKILLS

BI/Visualization Tools

Powerbi Desktop v 10,9,8, POWER BI, POWER BI Server, Micro Strategy, Microsoft SQL Server Reporting Services

ETL Tools

Oracle Warehouse Builder (OWB) 10g and 11g

Self Service BI

Powerbi Desktop 9.2, POWER BI Server 9.2

Operating Systems

Windows XP, Windows 7, UNIX/LINUX

Programming Languages

SQL, PL/SQL

Relational Database

Oracle Database

SQL Tools

SQLPLUS, PLSQL Developer, Toad for Oracle

Contact this candidate