Power Bi Developer

Prasanna Rani K ********.******@*****.*** BI Developer 732-***-****

Professional Summary

•Certified BI professional with over 10 years of experience in Analysis, design, development, implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions.

•Extensive 10 years of experience in Tableau Desktop, Tableau Server and Tableau Prep, Tableau Cloud in various versions of Tableau as a Developer.

•Around 3 years of working experience on Power BI Desktop, Power BI Service.

•Worked on delivering the design, technical cost, development, and deployment for all reporting and analytics.

•Have experience to partner with business stakeholders, gathering requirements and translating them into technical specifications and process documentation.

•Expertise in designing and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Waterfall Charts, Geographic Visualization.

•Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

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

•Created different Power BI reports utilizing the desktop and publish the reports and schedule refresh in Power BI Service.

•Implemented advanced DAX queries in Power BI desktop, providing detailed insights and enabling better performance.

•Experience in creating Sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters.

•Experience with Agile methodology and project management systems, including Jira.

Skills:

BI Development Tools

Tableau 2020.4/2021.1.x, Tableau server 8.2, Power BI Desktop, DAX, Tableau Reader 8.1, Tableau Prep

Databases

Oracle 12c/11g/10g/9i/8i, MS SQL Server, SSRS, Snowflake, AWS Google Cloud

Programming Languages

SQL, PL/SQL, XML, Python, Java

Tools and Utilities

AWS Redshift, SQL Developer

Certification

Tableau Desktop Specialist, Microsoft Power BI Data Analyst Associate

Professional Experience:

Cleveland Clinic – Cleveland, Ohio Oct 2024- Present

Tableau Tech Lead

Develop an interactive dashboard to visualize patient demographics, clinical outcomes, and healthcare trends.

Analyze operational efficiency, patient flow, and resource utilization to identify areas for improvement.

Demonstrated ability to analyze large datasets, identify trends, and uncover actionable insights to inform business decisions.

Worked with cross-functional teams between sales, marketing, and product teams to design and implement effective Go-To-Market (GTM) strategies, resulting increase in revenue or product adoption.

Provide real-time data insights for decision-makers to enhance patient care and optimize costs.

Use Tableau features like maps, bar charts, and filters for dynamic exploration.

Drill-down functionality for detailed analysis at the department or physician level.

Set up key performance indicators (KPIs) for tracking progress over time.

Environment: Tableau 2022.4, Teradata, and Tableau Server

State of Indiana - Indianapolis July 2023 – Sep 2024 Sr. Tableau Developer

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

Involved in all the aspects like Requirements gathering, Design, Technical and resource estimates, managing the teams, development and documentation.

Work closely with stakeholders to identify and address data-related challenges and bottlenecks.

Build kids subsidies data marts in Hive and generated reports in Excel, Tableau, and Atscale

Developed the reports with Figma background to enhance the presentation of Tableau reports.

Created projects, and provide permissions to the users as a site admin.

Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

Experience working on Performance tuning and optimization of Tableau reports.

Develop parameter and dimension-based reports, drill-down reports, and tabular reports using Tableau Desktop.

Environment: Tableau 2021.3, Salesforce, and Tableau Server.

Charles Schwab – Bozeman, MT June 2022 - May 2023

BI Lead

•Understand analytics requirements from users and build design specifications.

•Provide and explain the requirements to the team and check the status in the development of reports.

•Created reports using advanced calculations, LODs, window functions.

•Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

•Post-production support to Tableau users and follow the best practices, documentation.

•Develop test cases and test scenarios in order to pinpoint the root cause of issues and provide solutions.

Environment: Tableau 2021.3, Denodo, and Google Big Query, Google Cloud, Python

Amazon – Arlington, Virginia October 2021 - May 2022 BI Engineer

•Involved in creating the design, estimating technical resources, gathering business requirements and analyzing data sources for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

•Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.

•Developed filters, calculations, prompts, conditions, and created various reports, using Tableau for users.

•Created dashboards with huge volume of data and worked on improving the performance of the dashboard.

•Leveraged DAX to construct complex calculations and measures, boosting the efficiency of report generation and supporting strategic business operations.

•Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

•Created views using SQL Workbench in AWS Red shift.

Environment: Tableau 2021.1., Aws Red shift, Power BI, Power BI Service, AWS cloud

LabCorp - North Burlington, NC July 2020 – Sep 2021

Tableau Consultant

•Perform complex business analysis to help drive organization decision making.

•Understand the existing reports and implemented the changes as per the user requirements.

•Involved in creating python scripts to build a data source for Tableau Desktop.

•Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.

Environment: Tableau 2021.1., SAP HANA, AWS cloud, Python, and MS Excel

Marriott International, MD Jan 2020 – June 2020

Tableau Developer

•Involved in requirement gathering, business Analysis, design and development, testing and implementation of business rules.

•Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.

•Created flows by cleansing and prepping the data in Tableau Prep and published the data sources to the server.

•Used multiple Measures in Individual Axes, Blended Axes, and Dual Axes.

Environment: Tableau 2020.4, Tableau Prep, and Snowflake.

UBS – Weehawken, NJ. Dec 2017- Dec 2019

BI Developer

•Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

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

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

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

•Developed the resource management dashboard using JIRA tool data as data source in Tableau Desktop.

Environment: Tableau Desktop, Power BI Desktop, Oracle.

American Express - New York, NY Dec 2016 - Nov 2017

BI Consultant

•Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.

•Setup Tableau Schedules and assign dashboards to schedules based on users/group security.

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

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

Environment: Tableau 2018.x, Power BI, Windows 2012 R2 and Oracle 10g.

Provimi, India Jan 2009 – July 2009

Business Intelligence Analyst

•Involved in interaction with business users in the process of discussing the overall Reporting requirements.

•Responsible for Tableau Infrastructure including Server Security, Troubleshooting and overall system maintenance.

•Scheduling and maintaining the workbooks to synchronize dynamically with run time data.

Environment: Tableau 5.0, Oracle 10.2

NHIF, India Sep 2007 - Dec 2008

Software Developer

•Involved in the Requirement Study phase of the NHIF system.

•Implemented business rules using stored procedures and triggers.

•Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.

Environment: SQL Developer & Oracle 9i/10g, SQL & PL/SQL

Educational Qualifications:

•Master’s degree in Computer Applications from SV University, India 2005

•Bachelor's degree in Computer Science from SK University, India 2001

Contact this candidate